Flipside TeamStorage Staking
Updated 2024-11-27
9
1
2
3
4
5
6
7
8
›
⌄
select trunc(block_timestamp,'day') as "Date",
sum(deposit/pow(10,24)) as "Daily (NEAR)",
sum("Daily (NEAR)") over (order by "Date" asc) as "Total Amount (Near)"
from near.core.fact_actions_events_function_call
where method_name = 'storage_deposit'
and RECEIPT_SUCCEEDED = 'TRUE'
and block_timestamp::date >= '2023-01-01'
group by 1
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived