forgashuni v3 data exploration
    Updated 2022-08-15
    -- select platform, count(1) from ethereum.core.dim_dex_liquidity_pools
    -- where platform in ('uniswap-v2', 'sushiswap')
    -- limit 100

    -- select
    -- block_number,
    -- tx_hash,
    -- block_timestamp,
    -- tx_json:receipt:logs
    -- *
    -- from ethereum.core.fact_transactions where tx_hash = '0x776673e67ebd2f65e17371aecabc39b18979d40d5778c60afae1cf21153f66ff'


    -- dai to weth
    -- 0x32844e66c41bf08a8c3d249d1dd53a404831bc486e094342dc4b79ae9c7aa8d3
    -- eth to dai
    -- 0x20db61bcf3940f091541c8d186fc42d81591b971871be6d8a3f980a54b730791
    -- bal to eth
    -- 0x776673e67ebd2f65e17371aecabc39b18979d40d5778c60afae1cf21153f66ff
    -- fort to usdc
    -- 0x85139e7479b63f846ccf58784fbdee931733ffe53e3e52744948a5ab521d9977

    -- select * from ethereum.core.fact_event_logs
    -- where event_name = 'Swap'
    -- -- and contract_name is not null
    -- and tx_hash in ('0x776673e67ebd2f65e17371aecabc39b18979d40d5778c60afae1cf21153f66ff',
    -- '0x32844e66c41bf08a8c3d249d1dd53a404831bc486e094342dc4b79ae9c7aa8d3',
    -- '0x20db61bcf3940f091541c8d186fc42d81591b971871be6d8a3f980a54b730791',
    -- '0x85139e7479b63f846ccf58784fbdee931733ffe53e3e52744948a5ab521d9977'
    -- )
    -- order by event_index
    -- limit 10


    select c.address_name as address, count(1)
    from ethereum.core.fact_event_logs l
    Run a query to Download Data