MLDZMNgno11
Updated 2023-03-15Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
block_timestamp::date as day,
case when ADDRESS_NAME='hop protocol: usdc l2canonicaltoken' then 'USDC'
when ADDRESS_NAME='hop protocol: usdt l2canonicaltoken' then 'USDT' end as token,
count(tx_hash) as application,
count(distinct from_address) as users,
sum(RAW_AMOUNT/1e6) as volume,
sum(volume) over (partition by token order by day) as cumulative_usage
from gnosis.core.fact_token_transfers x
join gnosis.core.dim_labels z on x.CONTRACT_ADDRESS=z.address
where CONTRACT_ADDRESS in (lower('0x4ecaba5870353805a9f068101a40e0f32ed605c6'),
lower('0xddafbb505ad214d7b80b1f830fccc89b60fb7a83'),
lower('0xd586E7F844cEa2F87f50152665BCbc2C279D8d70'))
-- and STATUS = 'SUCCESS'
group by 1,2
Run a query to Download Data