dr1888Inflows to DEX
Updated 2023-05-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from 2023-05-20 10:22 PM @ https://flipsidecrypto.xyz/edit/queries/d5d32cd6-e07a-4aa4-820d-2d29202e9b42
select
date_trunc('month', block_timestamp) as Month,
sum(amount_usd) as Volume,
sum(Volume) over (order by Month) as Cumulative_Volume
from ethereum.core.ez_token_transfers
join ethereum.core.dim_labels
on to_address = address
where symbol like 'UNI'
and label_type like 'dex'
group by 1
having Volume is not null
order by Month DESC
Run a query to Download Data