Eman-RazClaim Over Time
Updated 2025-01-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tab1 as (select block_timestamp, origin_from_address, amount, amount_usd, token_price, tx_hash
from base.core.ez_token_transfers
where origin_function_signature='0x2f52ebb7'
and origin_to_address='0x584cb7dae5158be594aa1022fb38017c791af2a0' -- CARV Airdrop
and contract_address='0xc08cd26474722ce93f4d0c34d16201461c10aa8c' -- $CARV Token
and from_address=origin_to_address
and to_address=origin_from_address
and symbol='CARV')
select date_trunc('hour',block_timestamp) as "Date", count(distinct origin_from_address) as "Claimer Count",
sum(amount) as "Amount ($CARV)", sum(amount_usd) as "Amount ($USD)",
sum("Amount ($CARV)") over (order by "Date") as "Total Amount ($CARV)",
sum("Amount ($USD)") over (order by "Date") as "Total Amount ($USD)",
SUM("Claimer Count") over (order by "Date") as "Total Claimers Count",
FROM TAB1
group by 1
order by 1
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived