alirsAPA-03
Updated 2022-11-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT block_timestamp::date as date
,count(DISTINCT tx_hash) AS Number_of_Claims
,count(DISTINCT to_address) AS Number_of_Users
,sum(raw_amount / pow(10, 18)) AS ACX_Volume
,125000000 - ACX_Volume AS unclaimed_Volume
,(ACX_Volume / 125000000) * 100 AS claimed_Ratio
,(unclaimed_Volume / 125000000) * 100 AS unclaimed_Ratio
,sum (Number_of_Users) over (order by date) as Cum_Claim_Count
,sum (ACX_volume) over (order by date) as Cum_ACX_Volume
FROM ethereum.core.ez_token_transfers
WHERE contract_address = '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f'
AND from_address = '0xe50b2ceac4f60e840ae513924033e753e2366487'
group by DATE
order by DATE
Run a query to Download Data