flipside

    ERC20 Launch Analysis
    flyingfishERC20 Launch Analysis
    Updated 2022-11-15
    SELECT origin_from_address as wallet
    , token_in
    , token_out
    , sum(amount_in) as swaps_in
    , sum(amount_out) as swaps_out
    FROM ethereum.core.ez_dex_swaps
    WHERE block_timestamp > '2022-11-01'
    -- AND (token_in = lower('0xd3591ff711429fffe8e99660fd7558e179d6de71') OR token_out = lower('0xd3591ff711429fffe8e99660fd7558e179d6de71'))
    AND (origin_from_address = lower('0x1153c66da82e81c20e962bb547d1dcb1023b2d45') OR origin_to_address = lower('0x1153c66da82e81c20e962bb547d1dcb1023b2d45'))
    -- WHERE pool_address = '0xe755497e858932b9cc69f21c228f277eaafa0015'
    GROUP BY wallet, token_in, token_out
    -- SELECT *
    -- FROM ethereum.core.ez_dex_swaps
    -- WHERE block_timestamp > '2022-11-14'
    -- AND (token_in = lower('0xa4917Dc78495395470cF892F09bE605F7744eC41') OR
    -- token_out = lower('0xa4917Dc78495395470cF892F09bE605F7744eC41'))
    Run a query to Download Data