MostafaUntitled Query
Updated 2023-09-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc('week', block_timestamp) as date,
count(distinct TX_HASH) as All_transactions,
sum(All_transactions) over (order by date) as cumulative_transfers,
COUNT(distinct ORIGIN_FROM_ADDRESS) as users,
sum(users) over (order by date) as cumulative_users,
sum(AMOUNT) as Total_volume,
sum(AMOUNT_USD) as Total_volume_USD,
sum(AMOUNT_USD)/All_transactions as AVG_volume_per_transactions,
sum(AMOUNT_USD)/users as AVG_volume_per_users
from Ethereum.core.ez_token_transfers
where CONTRACT_ADDRESS= lower ('0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce')
group by 1
Run a query to Download Data