Flipside TeamStorage Staking
    Updated 2024-11-27
    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
    Last run: about 2 months agoAuto-refreshes every 24 hours
    Date
    Daily (NEAR)
    Total Amount (Near)
    1
    2024-01-31 00:00:00.000286.85301102948.4365961
    2
    2023-03-09 00:00:00.00079.0899254608.600090265
    3
    2024-04-20 00:00:00.000399.19957168177.510436161
    4
    2024-05-29 00:00:00.000600.09247185216.398154227
    5
    2024-07-04 00:00:00.000526.55042210025.300074227
    6
    2024-08-22 00:00:00.000666.58635236231.517804227
    7
    2024-10-18 00:00:00.000488.217463263018.260883127
    8
    2023-04-26 00:00:00.00064.4377558093.011400626
    9
    2023-07-14 00:00:00.00041.6311862085.937738228
    10
    2023-01-24 00:00:00.000109.09561424318548.785891787
    11
    2023-05-24 00:00:00.00044.5480359467.715368102
    12
    2024-03-29 00:00:00.0001015.30468152447.27025612
    13
    2024-07-22 00:00:00.0001054.16062220120.102494227
    14
    2024-09-07 00:00:00.000611.46073244605.272144227
    15
    2024-11-30 00:00:00.000413.66167285556.329406538
    16
    2023-10-17 00:00:00.00089.4069970926.913838228
    17
    2023-06-05 00:00:00.00042.9908760371.349428102
    18
    2023-04-19 00:00:00.00048.3117457746.404940626
    19
    2023-03-03 00:00:00.000120.3634953895.293900757
    20
    2023-08-13 00:00:00.00058.0949463549.111088228
    ...
    727
    39KB
    177s