HOUR | BUYERS | BUY | SELLERS | SELL | |
|---|---|---|---|---|---|
1 | 2024-04-09 12:00:00.000 | 165 | 660838.524926709 | 205 | -706684.503660327 |
2 | 2024-07-30 11:00:00.000 | 30 | 27156.562545373 | 33 | -21520.786090926 |
3 | 2024-08-09 14:00:00.000 | 46 | 73166.252904454 | 48 | -64520.112820184 |
4 | 2024-08-05 08:00:00.000 | 35 | 13301.594964539 | 41 | -75470.651520161 |
5 | 2024-06-10 07:00:00.000 | 79 | 47704.871442323 | 79 | -114454.836066462 |
6 | 2024-04-08 18:00:00.000 | 239 | 3279921.69937187 | 726 | -3409110.14618396 |
7 | 2024-04-22 10:00:00.000 | 78 | 98068.038925992 | 88 | -142474.632929297 |
8 | 2025-01-26 03:00:00.000 | 19 | 32718.511220882 | 8 | -1773.789027267 |
9 | 2024-10-23 15:00:00.000 | 47 | 30382.121222578 | 48 | -36164.108051922 |
10 | 2024-05-25 04:00:00.000 | 119 | 158836.822417509 | 131 | -197090.225599717 |
11 | 2024-06-04 14:00:00.000 | 75 | 110975.07850188 | 86 | -102162.915088934 |
12 | 2024-08-28 08:00:00.000 | 30 | 27249.319744895 | 36 | -53019.235220247 |
13 | 2024-04-20 03:00:00.000 | 72 | 50243.910427626 | 69 | -152191.811582921 |
14 | 2024-08-04 16:00:00.000 | 76 | 75310.192155809 | 56 | -20573.884348937 |
15 | 2024-09-26 19:00:00.000 | 12 | 3572.910683377 | 21 | -8978.403198424 |
16 | 2024-10-19 10:00:00.000 | 63 | 12718.17 | 22 | -5107.54180433 |
17 | 2024-04-21 11:00:00.000 | 60 | 35443.411592404 | 77 | -125374.737158408 |
18 | 2024-06-19 14:00:00.000 | 47 | 14221.950261553 | 44 | -17727.717495645 |
19 | 2024-06-29 02:00:00.000 | 38 | 9853.342197056 | 29 | -3934.865615812 |
20 | 2024-07-12 04:00:00.000 | 51 | 14191.194029898 | 48 | -4679.487390262 |
ArioTNSR Swap Stats
Updated 2025-02-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with Buy as (
select
date_trunc(hour, block_timestamp) as Hour,
count(DISTINCT SWAPPER) as Buyers,
sum(SWAP_TO_AMOUNT) as Buy
from solana.defi.fact_swaps
where SWAP_TO_MINT = 'TNSRxcUxoT9xBG3de7PiJyTDYu7kskLqcpddxnEJAS6'
group by 1
),
Sell as (
select
date_trunc(hour, block_timestamp) as Hour,
count(DISTINCT SWAPPER) as Sellers,
sum(-1 * SWAP_from_AMOUNT) as Sell
from solana.defi.fact_swaps
where SWAP_from_MINT = 'TNSRxcUxoT9xBG3de7PiJyTDYu7kskLqcpddxnEJAS6'
group by 1
)
select
*
from Buy join sell using(hour)
Last run: 2 months ago
...
7217
462KB
19s