YEAR | COUNT(1) | |
|---|---|---|
1 | 2023-01-01 00:00:00.000 | 28354 |
2 | 2023-03-01 00:00:00.000 | 21777 |
3 | 2023-10-01 00:00:00.000 | 11883 |
4 | 2023-11-01 00:00:00.000 | 11645 |
5 | 2023-04-01 00:00:00.000 | 13869 |
6 | 2023-07-01 00:00:00.000 | 11466 |
7 | 2023-08-01 00:00:00.000 | 12225 |
8 | 2023-05-01 00:00:00.000 | 10767 |
9 | 2023-06-01 00:00:00.000 | 10072 |
10 | 2023-09-01 00:00:00.000 | 6742 |
11 | 2023-12-01 00:00:00.000 | 12563 |
12 | 2023-02-01 00:00:00.000 | 18420 |
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
Last run: 17 days ago
12
408B
1s