marquVpe Sandwhich - v1.3 - aggregated USD
Updated 2024-12-15
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 '7 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
or fact_events.instruction :accounts[7] = createsandwhichv2_txs.sandwhich_acc
left join solana.defi.fact_swaps
QueryRunArchived: QueryRun has been archived