defikit1Getting Started
Updated 2024-09-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
date(tbl.block_timestamp) as date,
count(DISTINCT tbl.tx_hash) as transactions
from
berachain.testnet.fact_transactions tbl
where
-- tbl.block_number > 2536188
-- and
tbl.block_timestamp > current_date - interval '7 days'
AND
tbl.to_address = lower('{{bera_rocketlaunch_address}}')
GROUP by 1
ORDER by 1 desc
QueryRunArchived: QueryRun has been archived