goozeguztx_fetching
Updated 2024-10-25Copy Reference Fork
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 all_txs as (
select
swap_program,
block_id,
block_timestamp as a_time,
tx_id as a_tx,
program_id,
swapper,
swap_from_mint,
swap_from_symbol,
swap_from_amount,
swap_from_amount_usd,
swap_to_mint,
swap_to_symbol,
swap_to_amount,
swap_to_amount_usd,
_log_id,
inserted_timestamp,
modified_timestamp,
ez_swaps_id
from solana.defi.ez_dex_swaps
where swap_to_mint = 'FqnqT1GKi8S4Gyk5wnSKvJjXW48HqGtKJt9WS4o2pump'
or swap_from_mint = 'FqnqT1GKi8S4Gyk5wnSKvJjXW48HqGtKJt9WS4o2pump'
order by block_timestamp asc
),
hui as (
select
block_timestamp as sol_t,
tx_id as sol_tx,
owner,
pre_balance,
balance
from
solana.core.fact_sol_balances
inner join
all_txs a on a.a_tx = sol_tx and a.swapper = owner and sol_t = a.a_time
QueryRunArchived: QueryRun has been archived