connorh1-inch Pools/LP Tokens
    Updated 2021-07-21
    SELECT
    event_inputs:mooniswap::STRING AS pool_address,
    event_inputs:token1::STRING AS token1,
    event_inputs:token2::STRING AS token2,
    tx_id AS creation_tx,
    block_timestamp AS block_timestamp
    FROM
    ethereum.events_emitted
    WHERE contract_address IN (
    '0xbaf9a5d4b0052359326a6cdab54babaa3a3a9643') -- 1 inch factory address
    AND block_timestamp >= CURRENT_DATE - 360 AND event_name = 'Deployed'
    Run a query to Download Data