About queries and results
Dune Analytics lets you explore, create, and share Ethereum analytics. You can find an endless amount of great queries and dashboards on Dune.
We have decoded Ethereum smart contract data so you can do powerful analysis with simple SQL queries and visualise the query results into beautiful graphs.
Dune Analytics is free for everyone forever. If you want extra features like private queries, export your results and more check out our Pro plan.
1Select a1.week_start, 2a1.value_of_deposits as pjar069a_deposits, 3a1.value_of_withdrawals as pjar069a_withdrawal, 4 5b1.value_of_deposits as pjar069b_deposits, 6b1.value_of_withdrawals as pjar069b_withdrawal, 7 8c1.value_of_deposits as pjar069c_deposits, 9c1.value_of_withdrawals as pjar069c_withdrawal, 10 11d1.value_of_deposits as pjar069d_deposits, 12d1.value_of_withdrawals as pjar069d_withdrawal, 13 14a01.value_of_deposits as pjar0a_deposits, 15a01.value_of_withdrawals as pjar0a_withdrawal, 16 17b01.value_of_deposits as pjar0b_deposits, 18b01.value_of_withdrawals as pjar0b_withdrawal, 19 20c01.value_of_deposits as pjar0c_deposits, 21c01.value_of_withdrawals as pjar0c_withdrawal, 22 23a1.value_of_deposits + b1.value_of_deposits +c1.value_of_deposits +coalesce(d1.value_of_deposits,0) +a01.value_of_deposits +b01.value_of_deposits +c01.value_of_deposits as total_deposits, 24 25a1.value_of_withdrawals+b1.value_of_withdrawals+c1.value_of_withdrawals+coalesce(d1.value_of_withdrawals,0)+a01.value_of_withdrawals+b01.value_of_withdrawals+c01.value_of_withdrawals as total_withdrawals ...