0xHaM-dSwaps Over Time
    Updated 2025-01-14
    WITH token_map AS (
    SELECT
    COLUMN1 AS TOKEN_CONTRACT, COLUMN2 AS SYMBOL, COLUMN3 AS DECIMALS
    FROM
    (VALUES
    ('0xf1815bd50389c46847f0bda824ec8da914045d14', 'USDC.e', 6),
    ('0x2a1bce657f919ac3f9ab50b2584cfc77563a02ec', 'AK47', 18),
    ('0x1b184de5952d11fe3e821fc58e6ef73d545f733e', 'CYPHER', 18),
    ('0x21c97338b1ea81a0b49930483c70d5b79abcf041', 'DBI', 18),
    ('0xae44bac3814ecc4f5ac3fee16eb06bff1b74fe82', 'PENK', 8),
    ('0x145922e65ceaf0e4cf6e37e3a0e5bb57d9e1ff09', 'SQWARD', 18),
    ('0x2e1ac42aef8dc9fb4c661d017273e93ba82d3d0e', 'IAGENT', 18),
    ('0xd43e76ff8f95035e220070bddfd3c0c2bdd3051b', 'SINK', 18),
    ('0xe169c0cad1f9e5884c30db1976a39ebc40f8865f', 'WAGMI', 18),
    ('0xee73d2f34d66f0f07af6ab37b42713520e33119c', 'MYST', 18),
    ('0x1514c65c751d16bf253a9e82715771c5557e568b', 'INKYME', 18),
    ('0xec2d096221bf7f599d1b1581dd73eb6b245807ee', 'LIT', 18),
    ('0x67314f6a5732a308408969269618f38132777a45', 'SQUI', 18),
    ('0x232e0fef23dc0d6371ac2e59a6b7bfac2b971fe5', 'SHARK', 18),
    ('0xd0eca4bd623bad9a3872d31b6ac7065e4fa9344d', 'OCTOPEPE', 18),
    ('0x82ae03bbe6ec576bbd7496cbd67917cc21af097c', 'IKA', 18),
    ('0x75e7a5316e44755ff4ad724ee45337d1eef6895e', 'PRL', 18),
    ('0x4e7942a72dcfcc72fa0872068b0dba3921c1bb8a', 'CHAD', 18),
    ('0x084c4cafb176536b62d56a2f17ed1213d5b7b140', 'LANDWOLF', 9),
    ('0x2dc2b752f4c6dffe2dbcf60b848b8357a8879a01', 'Worm', 18),
    ('0x2e3b82891d1b2b90655597110cca9b6587607e0c', 'SQUID', 18),
    ('0x4200000000000000000000000000000000000006', 'WETH', 18),
    ('0xbf0cafcbaaf0be8221ae8d630500984edc908861', 'SQUIDS', 18),
    ('0x6814b9c5dae3dd05a8dbe9bf2b4e4fbb9cef5302', 'ISWAP', 18),
    ('0x19eb460d4155e204b054de78661f9aa556b50874', 'OCTO', 18),
    ('0xca5f2ccbd9c40b32657df57c716de44237f80f05', 'Kraken', 18),
    ('0x870657fd6372262f5b0ef90e0ae5ddf9bf585d09', 'OSSY', 18)
    )
    )
    , priceTb as (
    SELECT
    QueryRunArchived: QueryRun has been archived