BLOCK_TIMESTAMP | TX_HASH | EVENT | MINTER | MUSD | |
|---|---|---|---|---|---|
1 | 2025-04-04 10:46:38.000 | 0xfbb9addb07bc5284e9f4b83b4610a08a52498ce30da781b2d92194d9bfe3ff67 | MINT | 0x2c14e90c1061dca450c04e985b76dabda9b12626 | 10000000 |
2 | 2025-03-29 11:05:20.000 | 0xc4c32c2e1c49f5a5d415bb0287e89ef05a8f18939446714db38a010048ab933b | MINT | 0x440ea357667969fa73c602573c37eac6678eb552 | 7598599 |
3 | 2025-03-29 11:23:50.000 | 0xf44eebee2c9c4e69ef14e2db7426d1f212ef1c04c221f96bb6486ccf14c73c2c | MINT | 0xcfe04b1fadca7ea3ce90aeb08907d2672db2f515 | 7489000 |
4 | 2025-03-29 18:44:23.000 | 0x8366e3c633d17ad4833898b44e54e0f7deb8f82bde0cc789e24cd9d58ce4d9b3 | MINT | 0xd66c34ecae068c634d07600b1e92030799d54730 | 7305000 |
5 | 2025-03-30 13:42:44.000 | 0xf417a27ab7c2e903e360e937fa14febf72ab6a1f4872c1578a1e00a792e7ea33 | MINT | 0xd03c86a83c291fd0c026dead54d20f5229a082ca | 7144667.57 |
6 | 2025-04-02 18:00:50.000 | 0x3d66e9c23f89b59454f00f6acecede0af84eb393530f5bd9fdf634ed9e266c5b | MINT | 0xeb8c7511df7af644ec3e7decfd6d3209f02ff481 | 7143355 |
7 | 2025-04-02 19:02:26.000 | 0xfbeff0d287636ec0a8ba6f5726827529fa4d728f15d9fc461012477e6294fb92 | MINT | 0x05519d8dd01a7e9735423464ce6f4d09761f0607 | 6943582.08 |
8 | 2025-03-29 11:13:56.000 | 0x2b327db328b012647439154492272454e0cbe3a0b1f57291418626189b6645bc | MINT | 0xb2e0a30bc5a2771181bce1d899dfac84a0e0a3b4 | 6900069 |
9 | 2025-03-30 13:49:44.000 | 0x53d55b603a168e7d07e063c1c2337bd4df028139bc955bb5eb993191ff997ef3 | MINT | 0x02170e85a5f92467df0f7a32dcbece6b0963ec5f | 5993378.56 |
10 | 2025-03-29 18:35:57.000 | 0xdaf324d6360c81166b9b516c6d5e7ca9e63cbf5139b5cf41c9ae3aa67db64828 | MINT | 0x7433cede19df35236af4b40e140500199339f95f | 4884378.1 |
11 | 2025-04-02 16:29:43.000 | 0xbc6471e4bd166a92c2d2266b6be769add1d2b913d705043a9fa7ca5d101331f8 | MINT | 0xa4f6f39cfa76f084252f08544c8d817f1edeb973 | 4199945 |
12 | 2025-03-29 18:30:46.000 | 0x5951f28ba6780d26179ab6313ab4762448d795d6e96d3109505cb603bafefce2 | MINT | 0xc2757dd4299ac88b19d33d6b6bba7e68615b8690 | 2772062.41 |
13 | 2025-04-04 10:51:07.000 | 0xcc48d5926dcaa5a2c15604b2c3916a3fe300debca32118fcfed52d8688b1143d | MINT | 0x3d268e0b9f94d762f5e31a91ab1f010a5c082874 | 2000000 |
14 | 2025-04-04 10:48:43.000 | 0x3cd049db7e8dfdefadde59a16e3ffa9848e250c2c34340ff12769a52538088b9 | MINT | 0x358a575c9526d0f49bc0f7d47de3f222b81dbed0 | 2000000 |
15 | 2025-04-05 03:44:47.000 | 0x19327d02a44c04b5ba06d7e32435c34107d1329e44d1587e50cdebe61c24eb68 | MINT | 0x61f9dd9850d61681b71aa7bfb66fa711acdc4259 | 2000000 |
16 | 2025-04-04 10:49:42.000 | 0xd39303969ee1944f13c3547b633868044b0456b1fbc7f4e095a8421a7e48a80b | MINT | 0xb353600640c8d13533f3d20ae908c41c1cbfaeb5 | 2000000 |
17 | 2025-04-04 03:29:14.000 | 0xd675331a69c0ead6cfda5f37aa49fcbf68f5651fb8ce97c7be145573bcb6aced | MINT | 0x645d66f587cacdc2879f59fa67730f5a529928d4 | 1800000 |
18 | 2025-04-04 16:47:22.000 | 0xe82e3159e119aee7d89118e2cbcfb4af420d6532544cb20d8b4bd35169f475d0 | MINT | 0x5de50cb6beceec9319076ba37c6e56f7c25593a3 | 1515000 |
19 | 2025-03-30 04:16:40.000 | 0x901eea26b398163931c62d048854e808e94e309f43afce4bea8326f7e049bab6 | MINT | 0x312f78844e644a01aff20a7118ead69735ed20ac | 1505941.2 |
20 | 2025-04-02 20:52:30.000 | 0x265b3feae5ad5876eb7869ea2f90ba64c985324c023d78a42515b7b1457c755f | MINT | 0x9c57027b1eca93093a6f446422c59c85a5a3fa52 | 1258178.19 |
pepperatzitasteless-silver
Updated 2025-04-11
99
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
›
⌄
with mints as (
select
block_timestamp,
tx_hash,
'MINT' as event,
'0x' || substr(topic_2, 27) as minter,
livequery.utils.udf_hex_to_int(data) / '1e18' as musd
from mezo.testnet.fact_event_logs
where topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and topic_1 = '0x0000000000000000000000000000000000000000000000000000000000000000'
and contract_address = lower('0x637e22A1EBbca50EA2d34027c238317fD10003eB')
),
burn as (
select
block_timestamp,
tx_hash,
'BURN' as event,
'0x' || substr(topic_1, 27) as minter,
livequery.utils.udf_hex_to_int(data) / '1e18' as musd
from mezo.testnet.fact_event_logs
where topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and topic_2 = '0x0000000000000000000000000000000000000000000000000000000000000000'
and contract_address = lower('0x637e22A1EBbca50EA2d34027c238317fD10003eB')
),
combined as (
select * from mints
union all
select * from burn
)
select
*
from combined
order by musd desc
Last run: 15 days ago
...
22384
3MB
5s