HosseinUntitled Query
Updated 2023-01-14
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('week', block_timestamp) as week,
count(distinct tx_hash) as txn_count,
sum(raw_amount/1e18) as total_volume,
sum(txn_count) over (order by week) as cumulative_txn_count,
sum(total_volume) over (order by week) as cumulative_total_volume
from ethereum.core.ez_token_transfers
where contract_address = '0xe95a203b1a91a908f9b9ce46459d101078c2c3cb' --aETHc
and from_address = '0x0000000000000000000000000000000000000000'
group by week
order by week asc
Run a query to Download Data