MLDZMNneon2.1
Updated 2023-09-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from neon2 @ https://flipsidecrypto.xyz/edit/queries/d407dddd-eb87-4cc8-887f-9874b7a56957
select
date_trunc('hour',block_timestamp)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 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(volume)over (order by date) as total_volume
from solana.core.fact_transfers
where mint = 'NeonTjSjsuo3rexg9o6vHuMXw62f9V7zvmu8M8Zut44'
and block_timestamp>='2023-07-17'
group by 1
order by 1
Run a query to Download Data