Abbas_ra21Daily amount
Updated 2024-03-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with main AS (select
block_timestamp,
TX_HASH,
DECODED_LOG:to AS User,
DECODED_LOG:value/1e18 AS Amount
FROM
ethereum.core.ez_decoded_event_logs
where
EVENT_NAME = 'Transfer'
and CONTRACT_NAME = 'pufETH'
and ORIGIN_TO_ADDRESS = '0x4aa799c5dfc01ee7d790e3bf1a7c2257ce1dceff'
and DECODED_LOG:from='0x0000000000000000000000000000000000000000')
select
block_timestamp::date AS Day,
sum(Amount) AS "Total Deposited Amount",
sum("Total Deposited Amount") over (order by Day) AS "Cumulative Deposited Amount",
count(DISTINCT User) AS Users,
Count(*) AS TXns,
avg(Amount) AS "Avg Deposited Amount",
median(Amount) AS "Median Deposited Amount"
from main group by 1
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived