DATE | DAPP | TOTAL_TX_FEE | GIGA_GAS_UNITS | TRACES | TXS | TOTAL_L1_FEES | SEQ_REV | |
|---|---|---|---|---|---|---|---|---|
1 | 2025-03-28 00:00:00.000 | hyperlane | 0.00003688136 | 0.000677 | 7 | 2 | 0 | 0.00003688136 |
2 | 2025-03-28 00:00:00.000 | layerzero old | 0 | 0.001626 | 150 | 139 | 0 | 0 |
3 | 2025-03-28 00:00:00.000 | erc20 | 0.00000158204 | 0.012507 | 1012 | 218 | 0 | 0.00000158204 |
4 | 2025-03-28 00:00:00.000 | merkl | 0 | 0.012286 | 108 | 56 | 0 | 0 |
5 | 2025-03-28 00:00:00.000 | ambient | 4.4932e-7 | 0.014203 | 422 | 120 | 0 | 4.4932e-7 |
6 | 2025-03-28 00:00:00.000 | velodrome | 0.00002399396 | 0.013213 | 460 | 37 | 0 | 0.00002399396 |
7 | 2025-03-28 00:00:00.000 | neptune | 0.00001444007 | 0.022893 | 626 | 44 | 0 | 0.00001444007 |
8 | 2025-03-28 00:00:00.000 | oracle | 0 | 0.002706 | 47 | 47 | 0 | 0 |
9 | 2025-03-28 00:00:00.000 | untagged | 0.00007550315 | 0.080926 | 3581 | 287 | 0 | 0.00007550315 |
10 | 2025-03-27 00:00:00.000 | velodrome | 0.00332190813 | 0.195792 | 5348 | 571 | 0 | 0.00332190813 |
11 | 2025-03-27 00:00:00.000 | oracle | 0.00003605954 | 0.023423 | 471 | 445 | 0 | 0.00003605954 |
12 | 2025-03-27 00:00:00.000 | tempest | 0 | 0.000797 | 10 | 2 | 0 | 0 |
13 | 2025-03-27 00:00:00.000 | untagged | 0.01366290339 | 0.86847 | 23630 | 2195 | 0 | 0.01366290339 |
14 | 2025-03-27 00:00:00.000 | ambient | 0.00002457682 | 0.091982 | 1852 | 802 | 0 | 0.00002457682 |
15 | 2025-03-27 00:00:00.000 | layerzero old | 0 | 0.012541 | 1150 | 1050 | 0 | 0 |
16 | 2025-03-27 00:00:00.000 | merkl | 0.00011566152 | 0.033992 | 387 | 235 | 0 | 0.00011566152 |
17 | 2025-03-27 00:00:00.000 | hyperlane | 0.01072515373 | 0.111894 | 783 | 203 | 0 | 0.01072515373 |
18 | 2025-03-27 00:00:00.000 | permit2 | 0 | 0.000654 | 28 | 14 | 0 | 0 |
19 | 2025-03-27 00:00:00.000 | erc20 | 0.00066972574 | 0.083109 | 7882 | 1555 | 0 | 0.00066972574 |
20 | 2025-03-27 00:00:00.000 | neptune | 0.00049499271 | 0.206839 | 3019 | 188 | 0 | 0.00049499271 |
maybeyonastop_trace_dapps_historical
Updated 2025-03-28
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
›
⌄
-- forked from top_trace_contracts @ https://flipsidecrypto.xyz/studio/queries/0d523ad6-e48d-48ab-847e-c3b7d61f7b64
-- forked from top_tx_contracts @ https://flipsidecrypto.xyz/studio/queries/1f13ed97-40b1-4a6b-98ce-b3a75282d2c5
with
labels as (
select
contract_address,
dapp,
name
from $query('92e9b095-a8c5-44f1-8c63-caf6feb228b1')
),
traces as (
select * from swell.core.fact_traces
where origin_function_signature != '0x'
and trace_address != 'ORIGIN'
and origin_from_address != '0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001'
and origin_to_address != '0x4200000000000000000000000000000000000007'
),
txs as (
select * from swell.core.fact_transactions
where origin_function_signature != '0x'
and from_address != '0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001'
and to_address != '0x4200000000000000000000000000000000000007'
),
traces_enhanced as (
select
t.block_timestamp,
t.tx_hash,
t.from_address,
t.to_address,
t.input,
t.trace_succeeded,
t.gas_used,
txs.gas_used as total_gas_used,
txs.tx_fee_precise,
Last run: 28 days ago
...
1153
96KB
5s