DATE | SWAPS | SWAPPERS | SWAP_VOLUME_USD | |
|---|---|---|---|---|
1 | 2024-02-03 00:00:00.000 | 69111 | 15529 | 4112803.14338545 |
2 | 2024-02-12 00:00:00.000 | 23535 | 3502 | 2119491.84783076 |
3 | 2024-02-02 00:00:00.000 | 51700 | 19305 | 2009515.50646677 |
4 | 2024-02-11 00:00:00.000 | 42236 | 7195 | 4948270.7615876 |
5 | 2024-02-10 00:00:00.000 | 23395 | 6184 | 1602807.91649243 |
6 | 2024-01-27 00:00:00.000 | 529838 | 141902 | 2123906.56427075 |
7 | 2024-01-28 00:00:00.000 | 257915 | 86957 | 486031.566753046 |
8 | 2024-02-08 00:00:00.000 | 28711 | 7657 | 1052486.84631126 |
9 | 2024-02-06 00:00:00.000 | 24035 | 7123 | 572942.288525273 |
10 | 2024-02-05 00:00:00.000 | 34820 | 8852 | 640147.299885638 |
11 | 2024-02-07 00:00:00.000 | 31592 | 8655 | 1347191.49039196 |
12 | 2024-02-09 00:00:00.000 | 22818 | 6904 | 887597.067684457 |
13 | 2024-01-30 00:00:00.000 | 153883 | 56744 | 1267376.41003916 |
14 | 2024-01-29 00:00:00.000 | 252103 | 94728 | 915688.988589492 |
15 | 2024-02-01 00:00:00.000 | 67647 | 25494 | 1807902.84867162 |
16 | 2024-01-26 00:00:00.000 | 410040 | 157148 | 1418219.27986781 |
17 | 2024-02-04 00:00:00.000 | 78677 | 12434 | 3312732.50620316 |
18 | 2024-01-31 00:00:00.000 | 109174 | 42611 | 1834090.65299436 |
BlazeWen swaps
Updated 2024-02-12
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
›
⌄
-- forked from Jito Swaps @ https://flipsidecrypto.xyz/edit/queries/4ac2ee69-4d68-477a-a866-c552484a9018
-- forked from Pyth Token 1 copy @ https://flipsidecrypto.xyz/edit/queries/8e949e9d-4983-405c-bed3-c4261b9d97fe
SELECT
date_trunc('day', block_timestamp) as date,
count(DISTINCT tx_id) as SWAPS,
count(DISTINCT SWAPPER) as SWAPPERS,
sum(
case when SWAP_FROM_MINT = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' then SWAP_FROM_AMOUNT
else SWAP_TO_AMOUNT end * price
) as swap_volume_usd
FROM solana.defi.fact_swaps
LEFT outer join (
SELECT
date_trunc('hour', block_timestamp) as hour,
median(
CASE when SWAP_FROM_MINT = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' then SWAP_to_AMOUNT/SWAP_from_AMOUNT
else SWAP_from_AMOUNT/SWAP_to_AMOUNT end
) as price
FROM solana.defi.fact_swaps
WHERE (
SWAP_FROM_MINT = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk'
or SWAP_TO_MINT = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk'
)
AND NOT (
SWAP_TO_AMOUNT = 0
OR SWAP_From_AMOUNT = 0
)
AND block_TIMESTAMP >= '2023-09-01'
GROUP BY 1
) on date_trunc('hour', block_timestamp) = hour
WHERE (
SWAP_FROM_MINT = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk'
Last run: about 1 year ago
18
1KB
52s