olavGOO daily Statistics
Updated 2022-11-02
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
block_timestamp::date "Date",
sum(raw_amount/1e18) "Volume",
count (distinct tx_hash) "Transactions Number",
count (distinct origin_from_address) "Wallets Number",
sum("Transactions Number") over (order by "Date" asc) "Comulative Transactions Number",
sum("Volume") over (order by "Date" asc) as "Comulative Volume",
sum("Wallets Number") over (order by "Date" asc) "Comulative Wallets Number"
from ethereum.core.ez_token_transfers
where contract_address = '0x600000000a36f3cd48407e35eb7c5c910dc1f7a8'
group by 1
order by 1 asc
Run a query to Download Data