Mrfti2024-03-23 03:40 PM
Updated 2024-11-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date_trunc(day, block_timestamp) as date,
count(distinct TX_HASH) as "Total transactions",
sum("Total transactions") over (order by date) as "Cumulative transaction",
count(distinct ORIGIN_FROM_ADDRESS) as "Total users",
sum("Total users") over (order by date) as "Cumulative users",
sum(AMOUNT_USD) as "Total volume (USD)",
sum ("Total volume (USD)") over (order by date) as "Cumulative volume (USD)"
from
base.core.ez_token_transfers
where
CONTRACT_ADDRESS = lower('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')
group by 1
order by 1
QueryRunArchived: QueryRun has been archived