Skip to content
Dune Analytics

@hagaetc / Monthly Dai+Sai tx volume

Monthly Dai+Sai tx volume

Loading
 

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.

SQL query

1WITH dai AS (
2SELECT 
3date_trunc('month', evt_block_time) as month,
4sum("wad"/1e18) as transfer_volume 
5FROM makermcd."DAI_evt_Transfer" s
6GROUP BY 1
7ORDER BY 1 desc
8),
9
10sai AS (
11SELECT 
12date_trunc('month', evt_block_time) as month,
13sum("wad"/1e18) as transfer_volume 
14FROM maker."SAI_evt_Transfer" s
15WHERE evt_block_time > '2019-01-01'
16GROUP BY 1
17ORDER BY 1 desc
18)
19
20SELECT sai.month, dai.transfer_volume AS "Dai tx volume", sai.transfer_volume AS "Sai tx volume"
21FROM sai
22FULL OUTER JOIN dai on dai.month = sai.month

SQL query results

Loading