LENS | TXS | ANY_VALUE(TX_HASH) | |
|---|---|---|---|
1 | 9346 | 55 | 0xa96d0cf83b04eb695f48dbad329931740db75d9864d1501515f91aea3d23f24d |
2 | 4034 | 641 | 0xb2433233d54cd2f1fe57a2f173be7a8eda3a1ca80a600d0331436cbfff4fcf20 |
3 | 16450 | 1 | 0x0fb2690cc08098b565c7dead6db7c4f74e755aef90b759e6542e1459fd00284f |
4 | 14594 | 1 | 0x961fb2b9681722b5b3665660a1826a79a4418cf04eb4ebee4e581e284ca99420 |
5 | 8002 | 32 | 0x0c3366e6d97daf3a494e8bce39da50b4de014ce2c32dbbc0aeec7ef877ac02f8 |
6 | 4098 | 251 | 0x0ce32ed025e36a867a3adcc89867591cb60f5bcecb899c5c88f1e68c03a69670 |
7 | 14210 | 11 | 0x4257175ed86a9b7ba2de16f0ca08c09977657a687e2c4b1a51883b401a8ea35b |
8 | 9410 | 4 | 0x3acd4ea902a24a8a2f21651635eebd2edb8fb6a1d51df1ad93a5d4287ee5512d |
9 | 578 | 325457 | 0xdacd9bc0a204fd9a1ee24810b2cd2160dbcf98e878d7a9e2de793bb0506bc853 |
10 | 6530 | 492 | 0x40aea697c0cc0a253776e4183ca374ff5bb6897639c1597220d2585cc7680cf7 |
11 | 6850 | 10 | 0xf948db9c64a6ec4b44788e10e7d8eb4a4a30dcb7140813f0ec4ec3ace6ffc481 |
12 | 3970 | 196 | 0xe07c14d55ababc9219e0f6c4cbea826aedb8b14c6a1d03572c89c58eb9e3af39 |
13 | 7106 | 13 | 0x4d3da7d19dd6d8aea3f2822266d4f5008ffdc05194497b2b985d096dfc1d345c |
14 | 10946 | 3 | 0xc886d176d5873c87ed5161426206e12a7fbcb3a4c8c82d178de96a700b9f8cc1 |
15 | 13122 | 2 | 0xb0ba424b1abc7d2f1499312ab42065a38e6a8402f22221f2bc2d6367e76626be |
16 | 12610 | 8 | 0xf35ecf725fe107df8ddf700c2898a9fe2b14648f617667915d3f9e6531b9da6b |
17 | 1922 | 66 | 0x74bf65a4ca2314de126d60879379c8116bed2c251fa82be8f243398118575388 |
18 | 1602 | 24665 | 0x81f3a4494fb3b1a4e1bc9522f24d27ce0bc1964c037cb53e6be2e71849a77eb3 |
19 | 3714 | 823 | 0x0a421d9f0b0f3cd775b667eb4efd7b578d043d3fdb8f63c7d487de7b26befb48 |
20 | 16386 | 1 | 0x2f6bd4d9060e62c6ef4ccfe2e947e94f1a37cef1efd5c69281f1e6743ac71801 |
hbd1994L0 Data Length
Updated 2025-02-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with base as (
select
length(DATA) as lens,
tx_hash
from base.core.fact_event_logs
--left join chains on toChain = Chain_ID
where TOPICS[0] = '0xe9bded5f24a4168e4f3bf44e00298c993b22376aad8c58c7dda9718a54cbea82'
--and tx_hash = '0x06547c683a9929e872fed11a72c62a79569ef5a5b45af761341bbef566cf8a69'
and TX_STATUS = 'SUCCESS'
and CONTRACT_ADDRESS = '0x38de71124f7a447a01d67945a51edce9ff491251'
--and ORIGIN_TO_ADDRESS = '0x8d2de8d2f73f1f4cab472ac9a881c9b123c79627'
order by 1 desc)
select
lens,
count(distinct tx_hash) as txs,
any_value(tx_hash)
from base
group by 1
Last run: 2 months ago
...
229
18KB
172s