rokete5
Updated 2022-10-26
9
1
2
3
4
5
6
7
›
⌄
select trunc(block_timestamp,'day') as date, count(DISTINCT(ORIGIN_FROM_ADDRESS)) as total_user,
count(DISTINCT(tx_hash)) as total_bid, sum(amount) as eth_bid, sum(amount_usd) as usd_bid,
avg(amount) as avg_eth, avg(amount_usd) as avg_usd
from ethereum.core.ez_eth_transfers
where origin_to_address = lower('0x55e0f7a3bb39a28bd7bcc458e04b3cf00ad3219e')
and ETH_FROM_ADDRESS = ORIGIN_FROM_ADDRESS
group by 1
Run a query to Download Data