AndyCoolSwaps on SushiSwap
    Updated 2022-05-15
    WITH aaa AS (
    SELECT block_timestamp, tx_from_address,TX_TO_LABEL,TX_TO_ADDRESS, EVENT_NAME,
    row_number() over (partition by tx_from_address order by block_timestamp asc) as rank
    FROM flipside_prod_db.polygon.events_emitted
    WHERE block_timestamp::DATE BETWEEN '2020-05-30' AND '2021-06-30'
    qualify rank <=2
    )

    SELECT block_timestamp, tx_from_address FROM aaa
    WHERE TX_TO_LABEL = 'sushiswap'
    AND EVENT_NAME = 'Swap'
    ORDER by block_timestamp ASC
    Run a query to Download Data