PS0G1Daily volume of Matic unstaked
Updated 2022-09-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
--inspired by masi
select trunc(block_timestamp,'day') as day,
count(DISTINCT tx_hash) as count_tx,
count(DISTINCT origin_from_address) as users,
sum(amount_usd) as usd_volume,
sum(amount) as amounts,
avg(amount) as average_amount,
sum(count_tx) over (order by day asc) as cumulaitve_tx,
sum(amounts) over (order by day asc) as cumulative_amounts,
sum(usd_volume) over (order by day asc) as cumulative_volume
from ethereum.core.ez_token_transfers
where from_address = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908'
and CONTRACT_ADDRESS = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'
group by 1
Run a query to Download Data