DAY | NEW_SWAPPERS | TOTAL_SWAPPERS | |
|---|---|---|---|
1 | 2025-04-12 00:00:00.000 | 218 | 86833 |
2 | 2025-04-11 00:00:00.000 | 467 | 86615 |
3 | 2025-04-10 00:00:00.000 | 673 | 86148 |
4 | 2025-04-09 00:00:00.000 | 784 | 85475 |
5 | 2025-04-08 00:00:00.000 | 578 | 84691 |
6 | 2025-04-07 00:00:00.000 | 734 | 84113 |
7 | 2025-04-06 00:00:00.000 | 984 | 83379 |
8 | 2025-04-05 00:00:00.000 | 996 | 82395 |
9 | 2025-04-04 00:00:00.000 | 1000 | 81399 |
10 | 2025-04-03 00:00:00.000 | 1247 | 80399 |
11 | 2025-04-02 00:00:00.000 | 1351 | 79152 |
12 | 2025-04-01 00:00:00.000 | 1464 | 77801 |
13 | 2025-03-31 00:00:00.000 | 1613 | 76337 |
14 | 2025-03-30 00:00:00.000 | 1516 | 74724 |
15 | 2025-03-29 00:00:00.000 | 1415 | 73208 |
16 | 2025-03-28 00:00:00.000 | 7971 | 71793 |
17 | 2025-03-27 00:00:00.000 | 4109 | 63822 |
18 | 2025-03-26 00:00:00.000 | 2517 | 59713 |
19 | 2025-03-25 00:00:00.000 | 1636 | 57196 |
20 | 2025-03-24 00:00:00.000 | 1630 | 55560 |
Pine Analyticsrural-jade copy
Updated 2025-04-12
999
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 tab1 as (
select
tx_id,
block_timestamp,
signers[0] as trader,
inner_instruction,
inner_instruction['instructions'][0]['parsed']['info']['mint'] as token_address_1,
case
when token_address_1 like 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL' then 'SOL'
when token_address_1 like 'So11111111111111111111111111111111111111112' then 'ETH'
when token_address_1 like 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE' then 'USDC'
when token_address_1 like 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn' then 'tETH'
when token_address_1 like 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm' then 'USDT'
end as token_symbol_1,
inner_instruction['instructions'][0]['parsed']['info']['tokenAmount']['uiAmount'] as token_amount_1,
inner_instruction['instructions'][1]['parsed']['info']['mint'] as token_address_2,
case
when token_address_2 like 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL' then 'SOL'
when token_address_2 like 'So11111111111111111111111111111111111111112' then 'ETH'
when token_address_2 like 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE' then 'USDC'
when token_address_2 like 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn' then 'tETH'
when token_address_2 like 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm' then 'USDT'
end as token_symbol_2,
inner_instruction['instructions'][1]['parsed']['info']['tokenAmount']['uiAmount'] as token_amount_2
from eclipse.core.fact_events
where program_id like 'CLMMjQ8usCDmeP2hZFc6Mhih7JFbjg6mHeRxeEtTWHNf'
and block_timestamp > '2024-03-10'
and ARRAY_SIZE(instruction['accounts']) in (16, 17)
and SUCCEEDED
union all
select
tx_id,
block_timestamp,
Last run: 12 days ago
52
2KB
3s