0xHaM-dTotal Trades & Unique Traders Count
    Updated 2023-02-07
    with tb1 as (
    SELECT
    BLOCK_TIMESTAMP,
    'Gains Network' as platrofm,
    tx_hash,
    origin_from_address
    FROM arbitrum.core.fact_event_logs
    WHERE CONTRACT_ADDRESS in (lower('0x2f67a8d26f370b922b31b199c7946c3ed53c10c6'), lower('0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46'),
    lower('0xcfa6ebd475d89db04cad5a756fff1cb2bc5be33c'), lower('0x6b8d3c08072a020ac065c467ce922e3a36d3f9d6'),
    lower('0x04a5e3cf21B0080B72fAcDca634349A56982D497'), lower('0xAA379DD7Ec0bae467490e89bB2055A7e01231b8f'),
    lower('0xf67Df2a4339eC1591615d94599081Dd037960d4b'), lower('0xc2d107e870927E3fb1127E6c1a33De5C863505b8'),
    lower('0xcef1C791CDd8c3EA92D6AB32399119Fd30E1Ff21'), lower('0x6C612C804c84e3D20E3109c8efD06cD2d8b28F46'),
    lower('0xcef1C791CDd8c3EA92D6AB32399119Fd30E1Ff21'), lower('0xd85E038593d7A098614721EaE955EC2022B9B91B'),
    lower('0x990BA9Edd8a9615A23E4c452E63A80e519A4a23D'), lower('0x673cf5AB7b44Caac43C80dE5b99A37Ed5B3E4Cc6'),
    lower('0x1759eD3BB9ecd661ebEcF4264f7677E09206ACE2'), lower('0x128889a9b82e5574012177055a35310d50c31a7d'))
    UNION

    SELECT
    BLOCK_TIMESTAMP,
    'GMX' as platrofm,
    tx_hash,
    origin_from_address
    FROM arbitrum.core.fact_event_logs
    WHERE contract_address = '0x489ee077994b6658eafa855c308275ead8097c4a'
    )
    SELECT
    platrofm,
    COUNT(DISTINCT tx_hash) as total_trade,
    COUNT(DISTINCT origin_from_address) as total_trader
    FROM tb1
    GROUP by 1
    order by 2 DESC

    Run a query to Download Data