DATE | SWAPS | SWAPPERS | VOLUME_USD | |
|---|---|---|---|---|
1 | 2025-02-26 00:00:00.000 | 42546 | 6520 | 6453130.84004872 |
2 | 2025-01-16 00:00:00.000 | 45172 | 10113 | 9980679.17032771 |
3 | 2025-02-04 00:00:00.000 | 53471 | 7763 | 14323850.3396751 |
4 | 2025-02-11 00:00:00.000 | 36095 | 10664 | 5205749.44177918 |
5 | 2025-01-28 00:00:00.000 | 44827 | 10628 | 9675365.25463055 |
6 | 2025-02-13 00:00:00.000 | 35035 | 8987 | 5126233.15772194 |
7 | 2025-02-20 00:00:00.000 | 31709 | 6803 | 5444590.19263899 |
8 | 2025-01-27 00:00:00.000 | 54040 | 9942 | 15173814.2025996 |
9 | 2025-01-22 00:00:00.000 | 66014 | 14930 | 15379800.7812401 |
10 | 2025-02-25 00:00:00.000 | 59657 | 7844 | 12509035.9136593 |
11 | 2025-01-10 00:00:00.000 | 34641 | 10998 | 5056358.83682636 |
12 | 2025-03-07 00:00:00.000 | 78475 | 10757 | 7717768.09969963 |
13 | 2025-01-09 00:00:00.000 | 36444 | 12052 | 5293034.04336767 |
14 | 2025-03-10 00:00:00.000 | 75457 | 9376 | 7140410.41554142 |
15 | 2025-03-01 00:00:00.000 | 44292 | 6533 | 4871169.25450692 |
16 | 2025-03-17 00:00:00.000 | 42782 | 7325 | 3512480.72905192 |
17 | 2025-01-26 00:00:00.000 | 44445 | 11313 | 8874755.13863622 |
18 | 2025-02-07 00:00:00.000 | 53837 | 10053 | 10820767.366591 |
19 | 2025-03-16 00:00:00.000 | 36314 | 5731 | 3143457.89465681 |
20 | 2025-02-09 00:00:00.000 | 39522 | 9007 | 7264840.65592513 |
Pine Analyticssilky-scarlet
Updated 2025-03-19
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 log_data AS (
SELECT
signers[0] as wallet,
tx_id as tx
FROM
eclipse.core.fact_transactions t,
TABLE(FLATTEN(log_messages)) f
WHERE SUCCEEDED
AND value in ('Program log: Instruction: SwapV2', 'Program log: Instruction: TwoHopSwapV2')
and block_timestamp > '2025-01-01'
), tab1 as (
SELECT
tx_id,
block_timestamp,
wallet,
mint as mint_out,
amount/power(10, decimal) as out_amount
from eclipse.core.fact_transfers
left outer join log_data
on tx = tx_id
where tx_id in (SELECT tx from log_data)
and wallet = tx_to
), tab2 as (
SELECT
tx_id as tx,
mint as mint_in,
amount/power(10, decimal) as in_amount
from eclipse.core.fact_transfers
left outer join log_data
on tx = tx_id
where tx_id in (SELECT tx from log_data)
and wallet = tx_from
and block_timestamp > '2025-01-01'
), tab3 as (
Last run: about 1 month ago
78
4KB
905s