kasadeghUntitled Query
Updated 2022-11-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
'solana' as chain,
DAYNAME(block_timestamp) as day,
hour(block_timestamp) as hour,
count(distinct TX_ID) as tx_count,
sum(amount) as total_volume,
median(amount) as median_volume,
avg(amount) as avg_volume,
count(DISTINCT TX_FROM) as senders_cnt,
count(DISTINCT TX_TO) as receivers_cnt
FROM solana.core.fact_transfers
where MINT ='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and amount!=0
GROUP BY 1,2,3
order by 2
Run a query to Download Data