NavidUntitled Query
Updated 2022-12-08Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc('day', block_timestamp) as day,
count(distinct tx_hash) as tx_cnt,
count(distinct origin_from_address) as stakers_cnt,
sum(amount) as volume,
sum(amount_usd) as volume_usd
from
ethereum.core.ez_token_transfers
where
contract_address = '0x4d224452801aced8b2f0aebe155379bb5d594381' and from_address = '0x5954ab967bc958940b7eb73ee84797dc8a2afbb9' and has_price
and day<'2022'
group by 1
order by 1 asc
Run a query to Download Data