kgmm2019hist_sig
Updated 2025-03-15Copy 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
›
⌄
-- forked from all_data @ https://flipsidecrypto.xyz/studio/queries/4ee7dc90-c622-4860-b92c-f0cf5d25f470
-- forked from of2_rolling_usd_val copy @ https://flipsidecrypto.xyz/studio/queries/0bbed8e4-22da-4b78-9d4a-f8dc1384a4f6
-- forked from of2_rolling_usd_val @ https://flipsidecrypto.xyz/studio/queries/a5daca41-618d-4da6-bf20-e7d6fd02c8f7
-- forked from of2 @ https://flipsidecrypto.xyz/studio/queries/7b73360d-c132-449e-adf9-68b9bb31292e
--select block_timestamp,tx_id,swapper,swap_from_mint,swap_from_symbol,swap_from_amount,swap_from_amount_usd,swap_to_symbol,swap_to_amount,swap_to_amount_usd
--from solana.defi.ez_dex_swaps where tx_id = '4bQ3FzkEoQ1Bny9rz6my4yKN9hUHyghy8NYsHth5bKLc2ajkHghwcfTrMNhkTcs2oqnCx6SGMyiiZptxyohywhks'
WITH cte_ca as (
select '9m3nh7YDoF1WSYpNxCjKVU8D1MrXsWRic4HqRaTdcTYB' as ca
),
cte_start_ts as (
select '2025-03-12 13:37:00' as start_ts
),
cte_end_ts as (
select '2025-03-13 16:10:00' as end_ts
),
cte_amm as (
--select 'GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL' as amm --'5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1'
-- union all
select '5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1' as amm
),
QueryRunArchived: QueryRun has been archived