mehdimarjanFTX Inflow by Origin (Solana)
    Updated 2022-11-08
    WITH addresses AS (
    SELECT * FROM solana.core.dim_labels WHERE label = 'ftx'
    )

    SELECT block_timestamp::DATE AS DAY, label, SUM(amount) AS volume
    FROM solana.core.fact_transfers
    INNER JOIN solana.core.dim_labels l ON tx_from = address
    WHERE tx_to IN (SELECT address FROM addresses)
    AND mint IN ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
    AND label <> 'ftx'
    AND block_timestamp::DATE >= CURRENT_DATE - 90
    GROUP BY 1,2
    Run a query to Download Data