SWAP_TO_SYMBOL | January 2024 | February 2024 | March 2024 | April 2024 | May 2024 | June 2024 | July 2024 | August 2024 | September 2024 | October 2024 | November 2024 | December 2024 | Total Transactions | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | MSOL | 856652 | 598485 | 395302 | 120163 | 66036 | 61136 | 83560 | 96073 | 96756 | 116400 | 128856 | 137688 | 2758863 |
2 | SOL | 178924 | 124154 | 117739 | 65302 | 64282 | 34596 | 41530 | 47273 | 65348 | 81099 | 67811 | 78062 | 967032 |
3 | USDC | 60374 | 41813 | 63222 | 28891 | 15836 | 19110 | 25507 | 32259 | 42133 | 29410 | 22215 | 54444 | 435759 |
4 | MNDE | 31735 | 25779 | 32587 | 11540 | 12576 | 7708 | 7113 | 6544 | 4055 | 6983 | 12976 | 13096 | 172766 |
5 | BSOL | 11029 | 7477 | 21018 | 3540 | 1702 | 1118 | 1313 | 873 | 897 | 4741 | 33034 | 427 | 87179 |
6 | JITOSOL | 16916 | 26662 | 20197 | 4410 | 2313 | 1726 | 1838 | 1263 | 1431 | 2582 | 1763 | 1135 | 82252 |
7 | USDT | 11623 | 8108 | 16068 | 4198 | 1965 | 1089 | 1657 | 2880 | 1734 | 2012 | 5548 | 5774 | 62671 |
8 | RAY | 6510 | 3073 | 6899 | 1194 | 682 | 613 | 1970 | 2412 | 1631 | 2241 | 4962 | 6307 | 38593 |
9 | JLP | 348 | 732 | 764 | 618 | 493 | 525 | 1088 | 1480 | 2082 | 3097 | 1262 | 968 | 13504 |
solomixSwap to stats
Updated 3 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with monthly_transactions as (
select
date_trunc('month', block_timestamp::date) as month,
count(tx_id) as tx_count,
swap_to_symbol
from solana.marinade.ez_swaps
where block_timestamp::date between '2024-01-01' and '2025-01-01'
group by 3,1
),
ranked_symbols as (
select
swap_to_symbol,
sum(tx_count) as total_tx_count,
rank() over (order by sum(tx_count) desc) as rank
from monthly_transactions
group by 1
)
select
swap_to_symbol,
sum(case when month = '2024-01-01' then tx_count else 0 end) as "January 2024",
sum(case when month = '2024-02-01' then tx_count else 0 end) as "February 2024",
sum(case when month = '2024-03-01' then tx_count else 0 end) as "March 2024",
sum(case when month = '2024-04-01' then tx_count else 0 end) as "April 2024",
sum(case when month = '2024-05-01' then tx_count else 0 end) as "May 2024",
sum(case when month = '2024-06-01' then tx_count else 0 end) as "June 2024",
sum(case when month = '2024-07-01' then tx_count else 0 end) as "July 2024",
sum(case when month = '2024-08-01' then tx_count else 0 end) as "August 2024",
sum(case when month = '2024-09-01' then tx_count else 0 end) as "September 2024",
sum(case when month = '2024-10-01' then tx_count else 0 end) as "October 2024",
sum(case when month = '2024-11-01' then tx_count else 0 end) as "November 2024",
sum(case when month = '2024-12-01' then tx_count else 0 end) as "December 2024",
sum(tx_count) as "Total Transactions"
from monthly_transactions
join ranked_symbols using(swap_to_symbol)
where rank <= 10
group by 1
Last run: 3 days ago
9
730B
5s