MLDZMNneon2
Updated 2023-09-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
block_timestamp::date as date,
count(distinct tx_id) as no_transfer,
count(distinct tx_from) as no_sender,
count(distinct tx_to) as no_receiver,
sum(AMOUNT) as daily_volume,
avg(AMOUNT) as avg_volume,
median(amount) as med_volume,
sum(no_transfer)over (order by date) as total_transfers,
sum(no_sender)over (order by date) as total_senders,
sum(no_receiver)over (order by date) as total_receivers,
sum(daily_volume)over (order by date) as total_volume
from solana.core.fact_transfers
where mint = 'NeonTjSjsuo3rexg9o6vHuMXw62f9V7zvmu8M8Zut44'
group by 1
order by 1
Run a query to Download Data