marquvpe sandwich - v1.3 - sw swaps proportion of all swaps
Updated 2025-01-23
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
createsandwhichv2_txs as (
select
instruction :accounts[2] as sandwhich_acc
from solana.core.fact_events
where succeeded
and program_id = 'vpeNALD89BZ4KxNUFjdLmFXBCwtyqBDQ85ouNoax38b'
and substr(livequery.utils.udf_base58_to_hex(instruction :data), 3, 16) = 'b3ecc1a00df8fe9a' -- CreateSandwhichV2
and block_timestamp ::date > current_date()
- interval '30 days'
),
swap_in_txs as (
select
fact_events.block_timestamp
, fact_events.block_id
, fact_events.tx_id as fr_tx_id
, fee / pow(10,9) as fee_swap_in
, createsandwhichv2_txs.sandwhich_acc
, swapper as fr_swapper
, swap_from_amount as fr_swap_from_amount
, swap_from_mint as fr_swap_from_mint
, swap_to_amount as fr_swap_to_amount
, swap_to_mint as fr_swap_to_mint
from solana.core.fact_events
inner join createsandwhichv2_txs
on fact_events.instruction :accounts[6] = createsandwhichv2_txs.sandwhich_acc
QueryRunArchived: QueryRun has been archived