DATETIME | TOTAL_MINT | |
|---|---|---|
1 | 2024-08-05 00:00:00.000 | 149764 |
2 | 2024-08-14 00:00:00.000 | 153039 |
3 | 2024-09-10 00:00:00.000 | 225491 |
4 | 2024-09-27 00:00:00.000 | 239043 |
5 | 2024-10-02 00:00:00.000 | 257461 |
6 | 2024-10-12 00:00:00.000 | 251129 |
7 | 2024-07-23 00:00:00.000 | 137287 |
8 | 2025-01-28 00:00:00.000 | 172416 |
9 | 2024-07-21 00:00:00.000 | 118365 |
10 | 2024-08-29 00:00:00.000 | 180592 |
11 | 2024-07-18 00:00:00.000 | 132452 |
12 | 2024-08-02 00:00:00.000 | 156474 |
13 | 2024-07-11 00:00:00.000 | 122483 |
14 | 2024-08-28 00:00:00.000 | 173761 |
15 | 2024-12-23 00:00:00.000 | 303537 |
16 | 2025-01-14 00:00:00.000 | 331590 |
17 | 2024-08-20 00:00:00.000 | 167357 |
18 | 2024-08-24 00:00:00.000 | 159157 |
19 | 2024-09-01 00:00:00.000 | 169721 |
20 | 2024-09-12 00:00:00.000 | 239273 |
tkvresearchold-tomato
Updated 2025-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select date(block_timestamp) as datetime,
sum(VALUE) as total_mint
from berachain.testnet.fact_transactions
where value != 0
and
ORIGIN_FUNCTION_SIGNATURE = '0x298c0733'
group by 1
-- and
-- from_address = lower('0x9fAa90d6797Bd01dB2035F820Fa662e38CcBaaab')
-- 0xa15112f9 (add liquidity)
Last run: about 1 month ago
...
236
8KB
27s