Marinade Swap Over Time

0xHaM-dMarinade Swap Over Time

Updated 2025-02-19

-- forked from Swap Over Time @ https://flipsidecrypto.xyz/studio/queries/f9a33527-ef4d-4fc4-bd4d-4102bae75457

with balanceTb as (

select

owner ,

balance

from solana.core.fact_token_balances

where mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

qualify row_number() over (partition by owner order by block_timestamp desc) = 1

)

, mnde_price as (

select

hour,

price as price

from solana.price.ez_prices_hourly

where symbol = 'MSOL'

)

select

trunc(BLOCK_TIMESTAMP,'week') as date,

avg(price) as price,

count(distinct TX_ID) as swaps,

count(distinct SWAPPER) as swappers,

sum(case when SWAP_FROM_MINT = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' then SWAP_FROM_AMOUNT_USD else 0 end) as swap_from_amount_usd,

sum(case when SWAP_TO_MINT = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' then SWAP_TO_AMOUNT_USD else 0 end) as swap_TO_amount_usd,

sum(coalesce(SWAP_FROM_AMOUNT_USD,SWAP_TO_AMOUNT_USD)) as swap_amount_usd,

sum(swaps) over (order by date) as total_swaps,

sum(swap_amount_usd) over (order by date) as total_swap_amount_usd

from solana.marinade.ez_swaps

join mnde_price on trunc(BLOCK_TIMESTAMP,'d') = trunc(hour,'d')

where (

SWAP_FROM_MINT = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

or SWAP_TO_MINT = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

)

and SWAPPER in (select distinct owner from balanceTb)

group by 1

order by 1 desc

Last run: about 1 month ago

	DATE	PRICE	SWAPS	SWAPPERS	SWAP_FROM_AMOUNT_USD	SWAP_TO_AMOUNT_USD	SWAP_AMOUNT_USD	TOTAL_SWAPS	TOTAL_SWAP_AMOUNT_USD
1	2025-02-17 00:00:00.000	221.902417656	15419	2379	709830995.24	539135287.97	1248522471.2	30510847	169372429093.04
2	2025-02-10 00:00:00.000	250.326414278	33335	7613	656241237.6	1108989404.88	1765628841.36	30495428	168123906621.84
3	2025-02-03 00:00:00.000	254.624984851	48711	5748	805646393.28	1562905355.76	2368633207.68	30462093	166358277780.48
4	2025-01-27 00:00:00.000	288.487962774	56902	4972	1073561365.44	1700672002.08	2773433718.48	30413382	163989644572.8
5	2025-01-20 00:00:00.000	314.395584762	184808	5285	2303867120.16	3054734775.12	5366463889.92	30356480	161216210854.32
6	2025-01-13 00:00:00.000	296.7605376	181879	5097	2537135062.08	2502809606.4	5013283355.76	30171672	155849746964.4
7	2025-01-06 00:00:00.000	241.364745766	137068	3673	1609846987.44	2292272970.96	3905801050.32	29989793	150836463608.64
8	2024-12-30 00:00:00.000	254.107118966	36340	3314	479707160.16	857158321.92	1337448825.12	29852725	146930662558.32
9	2024-12-23 00:00:00.000	238.315401645	39017	3391	1239393760.56	1606956847.44	2848324932.48	29816385	145593213733.2
10	2024-12-16 00:00:00.000	251.584018021	49945	4350	826215409.68	1567575136.32	2392048758.24	29777368	142744888800.72
11	2024-12-09 00:00:00.000	277.388593223	39878	4567	711051367.44	936659662.8	1648493317.68	29727423	140352840042.48
12	2024-12-02 00:00:00.000	289.481766963	54511	5035	1566800348.88	2236970240.4	3806597971.68	29687545	138704346724.8
13	2024-11-25 00:00:00.000	295.97033411	47477	4340	525259270.08	724291629.84	1249933100.64	29633034	134897748753.12
14	2024-11-18 00:00:00.000	305.563591586	43898	5512	914898148.56	1186389109.44	2101468475.04	29585557	133647815652.48
15	2024-11-11 00:00:00.000	265.438112812	61970	5695	958373031.84	1429146823.44	2386995177.6	29541659	131546347177.44
16	2024-11-04 00:00:00.000	232.629363209	69716	5518	637102557.6	1044953249.04	1684121586.72	29479689	129159351999.84
17	2024-10-28 00:00:00.000	212.114927017	56919	6808	715602428.16	1462864061.04	2179561611.12	29409973	127475230413.12
18	2024-10-21 00:00:00.000	208.733583471	46163	6347	1139033477.04	3170786763.12	4309894810.56	29353054	125295668802
19	2024-10-14 00:00:00.000	189.461594883	47088	5418	734133835.2	1189400097.36	1921525583.28	29306891	120985773991.44
20	2024-10-07 00:00:00.000	175.904222117	53206	6256	743073095.52	1340578162.32	2081630148.48	29259803	119064248408.16

...

135

15KB

182s