TO_ADDRESS | TXS | FEES_USED | NAME | SYMBOL | |
|---|---|---|---|---|---|
1 | 0xfff9ce5f71ca6178d3beecedb61e7eff1602950e | 478030 | 9413.635194465 | MarketGateway | axie_marketplace |
2 | 0x02790f32ad7e7eaaecfb0ad21950829932f1a2ee | 6416627 | 8537.29419485 | pixels_game_tracker | pixels |
3 | 0x0e6bce8f215c52b53fad009e3bfacbb3be3774a6 | 170365 | 6955.174071109 | ||
4 | 0x9d3936dbd9a794ee31ef9f13814233d435bd806c | 3818979 | 5008.079264239 | AtiasBlessing | axie_marketplace |
5 | 0xa62bbfe37d5fd209a83e17c385b0d1034ac41ade | 3223722 | 4133.97495948 | Raffle | themachinesarena |
6 | 0x5f0acdd3ec767514ff1bf7e79949640bf94576bd | 528883 | 2809.031264407 | AggregateRouter | katana_dex |
7 | 0xd97c9707528141b3b505eec03ee90aebf055a901 | 1972289 | 2570.79593133 | KalodiumGacha | kaidro |
8 | 0x7d0556d55ca1a92708681e2e231733ebd922597d | 211529 | 2524.549295431 | KatanaRouter | katana_dex |
9 | 0x16a62a921e7fec5bf867ff5c805b662db757b778 | 260184 | 2496.337336036 | RoninVRFCoordinator | ronin_vrf |
10 | 0xa54b0184d12349cf65281c6f965a74828ddd9e8f | 401660 | 2432.186493188 | MainContract | tamadotmeme |
11 | 0x0cf8ff40a508bdbc39fbe1bb679dcba64e65c7df | 198095 | 2178.585781879 | RoninGatewayV3 | bridge |
12 | 0x3e0674b1ddc84b0cfd9d773bb2ce23fe8f445de3 | 134553 | 1335.90653704 | ||
13 | 0x32950db2a7164ae833121501c797d79e7b79d74c | 473742 | 1234.410196629 | Axie | axie |
14 | 0x58ad3594758b0f74478dbc07168812ddf460a07f | 1623536 | 1188.93832015 | DailyCheckin | apeiron |
15 | 0x2880ab155794e7179c9ee2e38200202908c17b43 | 204766 | 1059.070324649 | PythUpgradable | pyth |
16 | 0xc05afc8c9353c1dd5f872eccfacd60fd5a2a9ac7 | 38350 | 1012.046671515 | PermissionedRouter | katana_dex |
17 | 0x21d18ae443f86a755ba47d6241c49c5bcf070bbf | 489517 | 859.95589214 | ||
18 | 0x4f517774388e5f8b5ab4e20b606e0d035514f890 | 117216 | 725.83982855 | ||
19 | 0xa8e9fdf57bbd991c3f494273198606632769db99 | 15919 | 684.436550061 | MavisLaunchpad | mavismarketlaunchpad |
20 | 0x0a9e7795ab1d691986b8f944f99560a7ed9e0708 | 84553 | 603.357310695 | JungleAdventureV2 | cyberkongz_pnk_adventure |
Sandeshgas guzzlers
Updated 2025-03-04
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
35
36
›
⌄
with res AS (
SELECT live.udf_api(
'https://api.dune.com/api/v1/query/4771344/results?api_key={dune_key}',
--'https://api.dune.com/api/v1/query/2946766/results?api_key={dune}',
'DuneAPI'
):"data":"result":"rows" AS json_result_must_pivot
from DUAL
),
historical_contracts as
(
SELECT
TO_DATE(REPLACE(d.value:"block_time", 'UTC', '')) AS date,
TRY_CAST(NULLIF(d.value:"tx_hash"::STRING, '') AS VARCHAR) AS CREATED_TX_HASH,
TRY_CAST(NULLIF(d.value:"address"::STRING, '') AS VARCHAR) AS Address,
TRY_CAST(NULLIF(d.value:"from"::STRING, '') AS VARCHAR) AS creator_address,
-- TRY_CAST(NULLIF(d.value:"contract_abi"::STRING, '') AS VARCHAR) AS contract_abi,
TRY_CAST(NULLIF(d.value:"name"::STRING, '') AS VARCHAR) AS Name,
TRY_CAST(NULLIF(d.value:"namespace"::STRING, '') AS VARCHAR) AS Symbol
FROM
res,
LATERAL FLATTEN(input => res.json_result_must_pivot::VARIANT) d
),
combined as
(
( select
created_block_timestamp
, created_tx_hash
, address
, creator_address
, name
, symbol
from ronin.core.dim_contracts
where address not in ( select address from historical_contracts)
Last run: about 2 months ago
50
4KB
10s