BLOCK_TIMESTAMP | TX_HASH | REAL_USER | EVENT | AMOUNT_IN | TOKEN | TOKEN_NAME | SYMBOL | AMOUNT_OUT | |
|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-11 18:43:59.000 | 0xdf50ad2f8a47e5c55ae8e80ff129756f57306183c0c91f103d9700b73a38ebad | 0x9e855115aeb32c80b9305b7f741bf77418ede7e7 | Buy | 5.05 | 0x2ad2ff30e94d3c42c8feda3c6522130076402910 | Bean Poap | BEAN | 68845781.7687691 |
2 | 2025-02-26 04:12:03.000 | 0x5c8bb92769ef7a67884ee9837581050af930d164a7b3f91f3c8795c55fde080e | 0xc9b9931990a92dde0e046145f9cda5903700d683 | Buy | 1.01 | 0x8c80ae799e18aace8dc2c5b4b0800913cd221eec | Pythenians | Pythenians | 13830550.5981723 |
3 | 2025-03-14 18:28:20.000 | 0xdd77117a81683f9f0bf2b79f17320e0e89d2b705d0e8c21aed341c37b445ceaf | 0x782bff05245a9049c86cfcfd511a223b9094faf2 | Buy | 0.505 | 0xa8a5103ae431153604bfa0c02ae66719b5ee54a0 | NADCHILL | NCH | 12032792.5521455 |
4 | 2025-02-23 19:05:52.000 | 0xa65c5db4477615840bd958bd9e84ec8f4c57c97b372c9a6f95ce79aa2f111ac4 | 0x3f599dd9249a1f633b1854d2123a82c9f6be83aa | Buy | 20.2 | 0xa1356c14f4762c73c89255e8c120917466e24732 | $Mona | Mona | 93947581.6968373 |
5 | 2025-03-03 10:45:32.000 | 0xd2dc291c5bd27398c09773543a72fd006c1c73f445b09905b3535bac6dc3874d | 0x6af0ee7f9a291e8b5964e331701058efbde2537d | Buy | 5.05 | 0x39b88585651a71b4e7a4209f4a342bfbd2f38c96 | idol jpan 4 | idolj4 | 13437423.2648943 |
6 | 2025-03-12 17:33:49.000 | 0x31887808f736ae74318f6c4e0e0cc48b71de75f9f172bae3ec4140a2490bdbe2 | 0xeb5f70720aa2f63c851a59a7750cb497402a48dc | Buy | 0.202 | 0x8b33bb13ccd4910e746b8f9474253223ceb7ac8d | Job | Job | 6442613.91947346 |
7 | 2025-02-28 08:00:47.000 | 0xdea4055041c4c6ef897b589a0676cbeba6f7e7842562afd1842bafb533b5966d | 0x1c99ef55f7a38a36ed9b49910b0966bc7cafb1ed | Buy | 1.01 | 0x1669157d6eb6bcf33de1229d2779482c03782005 | Just a chill pug | Chill | 5800001.03243243 |
8 | 2025-03-13 16:39:51.000 | 0x98e04e3eed3283c0a74af02e838180c77c225e6fe16e02c08011b7f377be735f | 0x777777777726b8dcb3e1de8eb23c398ae60b1d33 | Buy | 10.1 | 0x5bda0990f81a5938b82e12e30d2c6784b6354439 | LiLi Girl | LILI | 37063059.4883813 |
9 | 2025-03-08 22:52:23.000 | 0x4d9b6666ca736f7338a27fd68548c1533edf5aebeab6f96e25b035b990aea0fb | 0x10adf52c8b552390d034867f4e5693a38e0e37b5 | Buy | 0.511464 | 0x2ca8caa893bf2af2347852d7b2325c3dcb446d80 | AIXBT | aixbt | 6223880.34794412 |
10 | 2025-02-23 18:21:41.000 | 0x534b00ad461beee16194349f9538e9303ddb4c34f8f1c14d38d51cddf30068d4 | 0x9f5dd62267e0f036677bdee79c5a205d7a1994cb | Buy | 0.505 | 0x1a98ab93a0501248311a66c659ea4658b4425149 | Kontol Nad | KTLD | 6774682.70287693 |
11 | 2025-02-25 01:48:22.000 | 0x715803e2d47593e37d33dbc7f364ec0866be49c3e61a55d5eeaee223f829ebec | 0x826e4167ba4d924d2f154c6e571db2d73275be29 | Buy | 0.505 | 0x2d68c9607365e12b343650d679555e1725e765d3 | minchi | minchi | 17011675.2866538 |
12 | 2025-03-03 12:17:05.000 | 0x5342697627908c8defeafb677ab1004a43172bb4a41b6d321e7083ecb5106926 | 0x327cee6f45fadfec5912dc34643f53fcc88c4deb | Buy | 1.01 | 0x04e7c4f4c2eb973b7baa995daf63a955822509ad | Lilchogstars | Lcgtrs | 32449602.5504032 |
13 | 2025-03-10 06:11:38.000 | 0xbdcc54520059d1309a959283bc06228f35e6fb8418cb5775eab2377291dbb26d | 0x94ab99b4f2f8a6959dd5437cb4e864bcb9e071bd | Buy | 0.505 | 0x17dd2915dae6a16a0b7b89e111f6b8ef3d90c98d | oou | oou | 14240483.0845442 |
14 | 2025-03-13 05:23:13.000 | 0xc2fdf1d5982a4436661b50dee7075cf33eccdafcfb844cee18ae9e50c2586f84 | 0xe6c59d74eacdef815f99ceedaf8af789ede47698 | Buy | 0.113322 | 0xe3d9e1a1d9626e2d63e932390091d2d514b86fc1 | MONmeme | MONmeme | 520182.159998205 |
15 | 2025-03-05 15:51:17.000 | 0x04cef449823556154ffc534dcf7abfc1c0bfc7d7750291089ced1b6b860f2b79 | 0xbb1a80440658334e0596ff27d0c6b55c27140e2d | Buy | 0.505 | 0x450090f1d6a010d64c066d9e51584a8806de7449 | CHOGSTAR | CHOGSTAR | 9852799.88260104 |
16 | 2025-02-23 06:30:44.000 | 0x5f439298ed7318d9be0996d79bbf7ad860742ef546f4652f107fd6f4d3138df9 | 0xdba4da73ddd5bea5467b2dedc4567a3d037f1ee5 | Buy | 0.505 | 0xd1daf5e10eb3e12ea0bd2ffe7b24a37c7fd130f3 | CHILLGUY | CHILL | 13721230.0639386 |
17 | 2025-02-28 03:45:42.000 | 0xf30b74c2d0fa76bcaf3526ab4b49afc6e758e9db8d9d6a5fdeaa61f1727e0206 | 0x56a5c048d778e85bbd415735ce86dc22bffaf57b | Buy | 1.01 | 0xa00b8b8450c195b3b6faa8f36cbc645017b10be7 | Monad中文频道 | Monad | 7699214.06952824 |
18 | 2025-02-23 17:39:31.000 | 0x31c8f75f3170c95cc77ba04002cd7390d77d1e912d849e580b637028dcdd92f2 | 0xcb1362f3c30152f41edf5352a42bacf5263f85ea | Buy | 10.1 | 0x9d724232b8f5db9efcb6e04264c1edd3e0a6a8aa | Bolaji | BOL | 182017448.327943 |
19 | 2025-03-13 07:55:50.000 | 0x0177014f48fd61e272b0f21e557b4cfb2795c1d1d6bfc71e786df04fcb465022 | 0x53c3d7351196e058126c0523a99a885eaf6f89c9 | Buy | 0.101 | 0x676af7fb2a34165809b5944369ccb9a7899212e0 | vvv | vvv | 1514321.70112527 |
20 | 2025-03-06 16:14:14.000 | 0xecf2190a80b9528141ef1b0720b283df149c5ce7b3b40e1529f94a3558040af4 | 0x82f62c323e996081fb4080141437de709b1ec1a3 | Buy | 0.51508485 | 0xbe95f1f6f29863f79d10d8f2a4226b0c9b4b2cf1 | mona | moni | 14415457.7070868 |
Monad Metrics GuildNad.Fun
Updated 2025-03-15
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH raw AS (
SELECT
block_timestamp,
tx_hash,
topic_1,
topic_3,
regexp_substr_all(SUBSTR(data, 3), '.{64}') AS segmented
FROM monad.testnet.fact_event_logs
WHERE contract_address = '0x60216fb3285595f4643f9f7cddab842e799bd642'
AND topic_0 = '0x962c5f466b5c14a23d5aa7d7f1cd96153b1fd74124062d77ef00352a9812daf5'
),
almost AS (
SELECT
block_timestamp,
tx_hash,
segmented,
'0x' || SUBSTR(topic_1, 27) AS creator,
DATEDIFF('day', block_timestamp, CURRENT_DATE()) AS created_interval,
'0x' || SUBSTR(topic_3, 27) AS Token_address,
CASE
WHEN livequery.utils.udf_hex_to_int(segmented[9]) <= POWER(10, 38) THEN livequery.utils.udf_hex_to_int(segmented[9]) * 2
ELSE NULL
END AS array_two,
CASE
WHEN livequery.utils.udf_hex_to_int(segmented[11]) <= POWER(10, 38) THEN livequery.utils.udf_hex_to_int(segmented[11]) * 2
ELSE NULL
END AS array_three
FROM raw
),
names AS (
SELECT
block_timestamp,
tx_hash,
created_interval,
Last run: 28 days ago
100
23KB
82s