Dune vs Rotki

Dune operates primarily as a web-based data workspace that abstracts raw blockchain data into clean relational schemas. Supported networks span major Layer 1 and Layer 2 ecosystems, including Ethereum, Solana, Bitcoin, Arbitrum, Optimism, Polygon, and Base. Raw blockchain data, encompassing block headers, transaction receipts, and log traces, is parsed into structured tables via DuneSQL, an optimized query engine based on Trino. This structure allows researchers to query event logs, contract method calls, and transfer traces directly.

Beyond raw blocks, the platform provides curated datasets through its Spellbook repository, a community-maintained transformation layer powered by dbt. These abstractions aggregate complex protocol interactions, such as automated market maker swaps, lending pool liquidations, and non-fungible token marketplace sales, into standardised multi-chain tables. Visualisation modules allow users to turn raw table outputs into line charts, bar plots, area graphs, counters, and pie visualisations, which can be grouped into composite shareable dashboards. Protocol builders can publish project pages that display real-time ecosystem health metrics to the broader market, while analysts can fork existing community code to modify underlying parameters without starting from scratch.

Rotki operates primarily as a locally installed portfolio tracking and accounting client available on Linux, macOS, and Windows. The software connects directly to public blockchain RPC nodes, supported exchange API endpoints, and decentralized finance protocols to compile an integrated balance overview. Rather than routing queries through a centralized middle layer, Rotki pulls raw ledger data and parses transaction events directly onto your local machine. This setup gives users full insight into historical swaps, liquidity pool deposits, staking rewards, lending positions, and centralized exchange balances.

Supported networks include major Layer 1 and Layer 2 ecosystems such as Bitcoin, Ethereum, Arbitrum, Optimism, Polygon, and Avalanche, alongside key protocol integrations like Uniswap, Aave, Compound, Maker, and Curve. Rotki also accommodates traditional fiat cash accounts and manual asset entries, allowing operators to construct complete net worth overviews. Because the protocol catalog expands through open source development, support for niche decentralized applications frequently relies on community pull requests and node availability. The application features deep reporting tools, transaction tag labeling, and exportable profit and loss ledgers suitable for multi account monitoring.

Dune uses a freemium model where users can sign up at zero initial cost to write public queries, build public dashboards, and explore community research. Free accounts receive a baseline allowance of monthly query execution credits, sufficient for casual exploration and standard research workloads. However, free accounts run on shared compute queues, which can lead to longer execution waiting times during peak network congestion, and all published work remains publicly visible.

For teams requiring dedicated resources, Dune provides paid commercial tiers, commonly structured around Plus and Premium subscriptions alongside custom Enterprise packages. Paid plans introduce private query authoring, private dashboards, larger allowances of monthly compute credits, prioritized query execution pipelines, and automated query scheduling. Furthermore, Dune offers programmatic API tiers priced according to monthly datapoint and execution unit allowances. Heavy data users consuming continuous streaming API responses or running resource-intensive historical aggregations must monitor their monthly credit burn rates closely, as additional compute units and private team seats scale total recurring costs.

The core Rotki software is open source and freely accessible without mandatory subscription charges or software licensing paywalls. Users can install the desktop package, configure exchange read keys, query supported blockchains, and generate core accounting summaries at zero direct monetary cost. This open access model helps support that individuals with basic portfolio tracking needs or those willing to run their own infrastructure can track assets without incurring recurrent software overhead.

To support ongoing development and unlock enhanced conveniences, Rotki offers a premium tier known as Rotki Premium. Priced typically around 16.50 USD per month or 165 EUR per year when billed annually, the subscription activates automated encrypted cloud backups, priority protocol integrations, advanced decentralized finance data decoders, and direct developer support. Premium members can store encrypted database snapshots remotely to synchronize records across multiple desktop workstations. Transactions remain non custodial throughout the platform lifecycle, meaning Rotki does not intermediate asset transfers, charge trading spreads, or levy withdrawal commissions, as it operates strictly as an analytics and accounting interface.

Dune is entirely non-custodial and read-only regarding asset management. The platform does not hold, transmit, custody, or manage cryptographic keys, wallet funds, or financial balances. Users connect to the analytics dashboard using standard email credentials or single sign-on mechanisms, with optional multi-factor authentication available to helps protect organizational accounts. Read-only wallet addresses can be queried publicly across raw ledger records, ensuring that no sensitive private keys are ever requested or stored on the platform servers.

From an organizational data security perspective, Dune supports role-based access management for corporate accounts and research teams. Workspace administrators can designate member permissions, control private dashboard visibility, and manage the generation and revocation of API keys. Network communications are secured through standard transport layer encryption protocols. Because public queries and schemas are accessible to all platform users by default, enterprise users managing proprietary trading strategies or unpublished commercial metrics must helps support their dashboards are explicitly set to private within paid team workspaces to prevent unintended strategy disclosure.

Security within Rotki follows a local first paradigm where the software never takes custody of private spending keys or native digital assets. When monitoring centralized exchange balances, users provide read only API keys with trading and withdrawal permissions disabled. When tracking onchain activity, Rotki relies solely on public wallet addresses and direct blockchain queries. All fetched balance histories, transaction tags, exchange credentials, and accounting tables are stored in a local SQLite database protected by SQLCipher encryption utilizing user generated master passwords.

Because data processing occurs locally, third party intermediaries cannot inspect user net worth, trade frequency, or counterparty addresses. However, users must understand the operational boundaries of this model. The security of stored accounting data depends directly on local workstation hygiene, operating system integrity, and robust password management. Rotki does not offer password recovery for encrypted local databases, meaning a forgotten master password results in permanent loss of local transaction classifications. Furthermore, querying public RPC endpoints directly reveals your IP address to node providers unless routed through custom personal nodes, VPN tunnels, or Tor proxies.

Founded in Norway in 2018, Dune provides global web availability without traditional financial services licensing requirements, as it provides data analytics rather than investment execution or money transmission services. Access to the platform web portal and documentation is available internationally, subject to standard international sanction boundaries and acceptable use policies that prohibit malicious scraping or system abuse. Individual researchers and enterprise organisations can register accounts using standard email credentials or single sign on authentication without needing accredited investor verification.

Customer assistance is centered around an extensive public knowledge base, official platform documentation, and an active community Discord server. Free tier users primarily obtain assistance through community discussion channels and shared public forums, where experienced community analysts collaborate on SQL debugging and table mapping. Paid subscription tiers receive dedicated support routing, including direct technical assistance channels, higher service level agreements for enterprise accounts, and dedicated onboarding sessions for data engineering teams integrating Dune API streams into internal production data pipelines.

Rotki is globally distributed under the open source GNU General Public License v3, allowing anyone worldwide to download, audit, and compile the software without jurisdictional restrictions, know your customer identity verification, or regional software blocks. Desktop installers are published across official GitHub releases and package repositories, catering to developers, system administrators, and everyday desktop users alike. Because it functions as an offline capable tracking tool rather than a financial custodian, it is not subject to custodial financial licensing.

Customer support workflows reflect the platform open source heritage. Free tier participants access self service documentation, public GitHub issue trackers, and community Discord and Telegram discussion channels where community members and maintainers troubleshoot bugs. Paying Rotki Premium subscribers receive direct email assistance and prioritized bug resolution. Users seeking immediate corporate desk support or real time chat assistance may find the community driven model slower than traditional commercial platforms, but the transparent development cycle allows direct communication with the core software engineers.

Selecting an appropriate Dune plan depends on workflow privacy, query execution frequency, and external pipeline requirements. Independent analysts conducting public market research and educational protocol breakdowns can operate comfortably on the free plan, leveraging the extensive community catalog. However, Web3 startups, risk advisory firms, and hedge funds typically require paid subscription tiers. These plans unlock private query workspaces to protect proprietary logic, eliminate watermarks on embeds, provide prioritized compute queues for complex nested queries, and supply dedicated API access keys to feed clean onchain metrics directly into custom internal applications and investor reporting decks.

Selecting between the open source core version and Rotki Premium depends on operational complexity and multi device requirements. The free tier provides all core portfolio tracking, local encrypted SQLite storage, manual transaction editing, and direct custom node integrations across desktop installations. This baseline tier suits individuals managing straightforward spot holdings on centralized exchanges and primary blockchain addresses from a single computer. Rotki Premium introduces automated end to end encrypted cloud synchronization, priority decentralized finance protocol decoding, and direct developer support. Active yield farmers and liquidity providers benefit from premium modules that automatically decode complex multi step smart contract interactions. Premium users also support ongoing open source development while maintaining the ability to revert to local manual database tracking at any point without data loss.