samresulting-copper
Updated 2025-03-02
9
1
2
3
4
5
6
7
8
9
›
⌄
-- select * from ronin.core.ez_decoded_event_logs
-- where tx_hash = '0xb69cfbaf03da3d7e2d78bc11390ebecacaaf1fd9d38a660671d51124011b8089'
select
date_trunc('month', block_timestamp) as year,
count(1)
from boba.core.fact_transactions
where date_trunc('year', block_timestamp) = '2023-01-01 00:00:00.000'
group by 1
QueryRunArchived: QueryRun has been archived