kasadeghUntitled Query
Updated 2022-11-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
'ethereum' as chain,
count(distinct TX_HASH) as tx_count,
sum(amount) as total_volume,
avg(amount) as avg_volume,
median(amount) as median_volume,
count(DISTINCT FROM_ADDRESS) as senders_cnt,
count(DISTINCT TO_ADDRESS) as receivers_cnt
FROM ethereum.core.ez_token_transfers
where symbol='USDC'
AND block_timestamp::date >='{{start_time}}' and block_timestamp::date <='{{end_date}}'
GROUP BY 1
Run a query to Download Data