MLDZMNhiv3
Updated 2023-05-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc('week',block_timestamp) as date,
sum(amount) as volume,
avg(amount) as avg_volume,
median(amount) as median_volume,
count(distinct tx_from) as no_senders,
count(distinct tx_id) as no_transfers,
sum(no_senders) over (order by date) as total_senders,
sum(no_transfers) over (order by date) as total_transfers
from solana.core.fact_transfers
where mint in ('4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy' )
and block_timestamp > '2023-01-01'
group by 1
Run a query to Download Data