greyswan2023-11-10 02:21 PM
Updated 2023-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
--date_trunc('day', block_timestamp) as day,
sum(SWAP_TO_AMOUNT) as sol_amount,
sum(SWAP_FROM_AMOUNT) as USDC_amount
from
solana.defi.fact_swaps
where
swap_from_mint = 'So11111111111111111111111111111111111111112'
and swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and block_timestamp >= current_date - 50
and SUCCEEDED = 'true'
and swapper ='9vu7XMz8Brmfm4mT1T2E1YzemsUCwQEzeM3DrocPBxWc'
Run a query to Download Data