DATE | Total $BERA paid | Cumulative $BERA paid | |
|---|---|---|---|
1 | 2024-10-05 00:00:00.000 | 3978.749999096 | 199471.499995182 |
2 | 2024-10-23 00:00:00.000 | 4481.35 | 278819.999995182 |
3 | 2024-11-08 00:00:00.000 | 4815.05 | 360406.049995182 |
4 | 2024-11-18 00:00:00.000 | 2846.75 | 433468.549995182 |
5 | 2024-11-25 00:00:00.000 | 4374.5 | 460253.349995182 |
6 | 2024-11-26 00:00:00.000 | 5756.25 | 466009.599995182 |
7 | 2024-12-05 00:00:00.000 | 3961.85 | 501091.949995182 |
8 | 2024-12-07 00:00:00.000 | 1128 | 503413.949995182 |
9 | 2024-12-10 00:00:00.000 | 1250 | 506948.949995182 |
10 | 2025-01-05 00:00:00.000 | 683 | 552256.949995182 |
11 | 2024-10-29 00:00:00.000 | 3601.3 | 298818.699995182 |
12 | 2024-09-17 00:00:00.000 | 8491.9 | 130618.299999477 |
13 | 2024-09-27 00:00:00.000 | 3199.9 | 171080.249999477 |
14 | 2024-09-30 00:00:00.000 | 2579.95 | 179969.499999477 |
15 | 2024-10-10 00:00:00.000 | 10616.8 | 230198.799995182 |
16 | 2024-11-19 00:00:00.000 | 4226.25 | 437694.799995182 |
17 | 2024-11-23 00:00:00.000 | 3606.55 | 454455.449995182 |
18 | 2024-11-29 00:00:00.000 | 2830 | 479930.249995182 |
19 | 2024-12-02 00:00:00.000 | 3045.6 | 489324.649995182 |
20 | 2024-12-11 00:00:00.000 | 1407 | 508355.949995182 |
Mrftisore-yellow copy
Updated 2025-04-25
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
-- forked from sore-yellow @ https://flipsidecrypto.xyz/studio/queries/b0e8ee0f-7d14-4be7-833f-b7ef0b984870
SELECT
date_trunc (day, b.block_timestamp) as date,
sum (VALUE) as "Total $BERA paid",
sum ("Total $BERA paid") over (order by date) as "Cumulative $BERA paid"
from berachain.testnet.fact_transactions a join berachain.testnet.ez_decoded_event_logs b on a.tx_hash = b.tx_hash
where contract_address = '0xbb57539243c4d35265fbf4b2f17d67219200450f'
and contract_name = 'Beranames'
and event_name = 'Mint'
and b.ORIGIN_FUNCTION_SIGNATURE = '0x3d30c7f6'
group by 1
Last run: about 1 month agoAuto-refreshes every 12 hours
...
160
8KB
1s