Updated 2022-03-22
    SELECT *
    FROM ethereum.events_emitted
    where
    -- tx_id='0x8ffa4fd6a391cdb10dd2e237407ddb5a84ab9d016d88a86be6d87bb7b65b4fe2'
    lower(contract_address) = lower('0xafd2aade64e6ea690173f6de59fc09f5c9190d74')
    AND tx_succeeded = 'TRUE'
    AND tx_to_label_subtype = 'pool'
    AND event_name = 'PoolAllocation'
    AND event_inputs:pool = 101
    limit 1

    -- SELECT *
    -- FROM ethereum.dex_liquidity_pools
    -- where
    -- token1='0xdb55b77f5e8a1a41931684cf9e4881d24e6b6cc9'

    -- 0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569
    Run a query to Download Data