SELECT '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' as address, 'WMON' as symbol, 18 as decimals

UNION ALL SELECT '0xf817257fed379853cde0fa4f97ab987181b1e5ea', 'USDC', 6

UNION ALL SELECT '0x62FeEb2132d9AC97d7f32D3a896F9aaa9078F8d3', 'BENDS', 18

UNION ALL SELECT '0xE0590015A873bF326bd645c3E1266d4db41C4E6B', 'CHOG', 18

UNION ALL SELECT '0x0F0BDEbF0F83cD1EE3974779Bcb7315f9808c714', 'DAK', 18

UNION ALL SELECT '0x3B428Df09c3508D884C30266Ac1577f099313CF6', 'MAMABTC', 18

UNION ALL SELECT '0xD8C603A0Fe45c77f13FAF626C04fE69EEB628196', 'MDX', 18

UNION ALL SELECT '0xe9f4c0093B4e94800487cad93FBBF7C3729ccf5c', 'MLDC', 18

UNION ALL SELECT '0x59897686b2Dd2059b09642797EBeA3d21E6cE2d1', 'MYK', 18

UNION ALL SELECT '0xab1fA5cc0a7dB885BC691b60eBeEbDF59354434b', 'PEPE', 18

UNION ALL SELECT '0xc60A9A0E7F3cBea1852B945EdB35Be52c2c8954e', 'PYRO', 18

UNION ALL SELECT '0xF42498F419EC9D5b074E675db713bC12B1E274e2', 'SHARKBAN', 18

UNION ALL SELECT '0x3a98250F98Dd388C211206983453837C8365BDc1', 'SHMON', 18

UNION ALL SELECT '0x951832502F0667CD00E1d1dAF1b42d163D3f17Ac', 'TRUMP', 18

UNION ALL SELECT '0x88b8E2161DEDC77EF4ab7585569D2415a1C1055D', 'USDT', 6

UNION ALL SELECT '0xcf5a6076cfa32686c0Df13aBaDa2b40dec133F1d', 'WBTC', 8

UNION ALL SELECT '0xB5a30b0FDc5EA94A52fDc42e3E9760Cb8449Fb37', 'WETH', 18

UNION ALL SELECT '0xfe140e1dCe99Be9F4F15d657CD9b7BF622270C50', 'YAKI', 18

),

transaction_data AS (

TX_HASH,

LOWER('0x' || SUBSTR(input, 11+2*64+24, 40)) AS user_address,

LOWER('0x' || SUBSTR(input, 11+9*64+24, 40)) AS token_in_address,

FROM monad.testnet.fact_traces

WHERE TO_ADDRESS = '0xcbcd292c9dae11875e090bb963aa4c74ccce6a23'

AND TYPE = 'CALL'

AND TRACE_ADDRESS = 'ORIGIN'

),

user_tx_counts AS (

user_address,

COUNT(*) AS tx_count

FROM transaction_data