greyswan2023-11-10 02:21 PM
    Updated 2023-11-10
    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