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

),

new_users AS (

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,

LOWER(FROM_ADDRESS) AS user_address

FROM monad.testnet.fact_traces

WHERE TO_ADDRESS = '0xcbcd292c9dae11875e090bb963aa4c74ccce6a23'

AND TYPE = 'CALL'

AND TRACE_ADDRESS = 'ORIGIN'

GROUP BY date, user_address

),

first_time_users AS (

SELECT

date,

user_address,

ROW_NUMBER() OVER (PARTITION BY user_address ORDER BY date) AS rn

FROM new_users