Worm Data Length

hbd1994Worm Data Length

Updated 2025-02-10

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] = '0x6eb224fb001ed210e379b335e35efe88672a8ce935d981a6896b27ffdf52a3b2'

--and tx_hash = '0x06547c683a9929e872fed11a72c62a79569ef5a5b45af761341bbef566cf8a69'

and TX_STATUS = 'SUCCESS'

and CONTRACT_ADDRESS = '0xbebdb6c8ddc678ffa9f8748f85c815c556dd8ac6'

--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

	LENS	TXS	ANY_VALUE(TX_HASH)
1	578	2218	0xb07dba528ffb2af49f78ce3ec128e431ab088c03538ef143456645d2796a2506
2	1602	164	0x10fabc91413f27fb737c17d65dcc64acc1c89251b43630023edbc6a029510c48
3	1922	41214	0x20d28cef643af162ecd5a22cd08168c7a8e65e3d19486621bfc831fcd28cbb91
4	1538	714	0x43febfeb787f5040a2f31ef53c9840bace99607407023cfcadaf4cd59c3f399e
5	450	38592	0x2ed57b36c1a473864a7764520811641f8355df9e3f7a346a10fd79822e169459
6	1346	4491	0x438548f42030dd9713cb8e4cb1918d689073b9473612c79b01169349b9194e87
7	1026	19835	0xb06c58537bc3d64cb094d83dcc0077f26b08b5aba45b402ae370c92bf446a560
8	2818	12	0xe5a54a1a07a224292e827906c95e3aec2dfbb939f3db6dfc28b9c662c39fb64c
9	4610	1	0x1512b61ed019750863a4dca4f8c2dd245fa66e87ea626a929803ba2df0d52521
10	2562	4	0x02258e0a7e8d10d96f55ca3817044f2c4d4b724b0fe1726457f515934caaac38
11	3522	3	0xe4d44947065aba418bdf33682892ff4e21c84b5c0eab13a28cd818cda1e670b2
12	6338	1	0xc8d979d86da4e9f2ccb658d33daf3bbeead2ee702b80788fe7a12575622c74b6
13	2114	15895	0x93df3b7ada2188815c4da43af2c46dd82e42cb430eb2222515b9f93c8160997f
14	1666	13202	0xc8df10293de5212d601dc02a55c940facd84e99c7e1c25efc576d55d9bf2d3db
15	1474	18582	0x14d1ee924942942427a754e183adaac052d50390c20c1eda18b96be10ff2dea5
16	2370	1	0x8b80fc4f26bcc5f5f33e853929dd6c27b25937ec4af0cd7988b62922f056426b
17	1090	41	0x9303534ba6b3a9bf54fa7e1268ab7802fb69e3589037cd96abb59fb1610d1516
18	2626	2	0x055619fc354f1512b9e496988c2a624d297bb493a025bd0f63fa1a315753bf3e
19	1154	115977	0x8dbfbfd428d4ab19fb63006775e7ac79647f26442e98987d9c5036ac74cac108
20	770	19674	0xa6b78e90f7e76b18b90d61b6e0a8486d48b727759bb49efdf880b44a198678a2

4KB

124s

flipside

flipside