Arkanntransfer 1
Updated 2023-01-22
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
date_trunc('month',BLOCK_TIMESTAMP) as date,
SYMBOL,
sum(AMOUNT_USD) as Volume,
count(distinct ORIGIN_FROM_ADDRESS) as transferor_number,
count(*) as transfers_number,
sum(Volume) over (partition by symbol order by date) as Cumulative_Volume,
sum(transfers_number) over (partition by symbol order by date) as Cumulative_transfers_number
FROM
ethereum.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = LOWER('0x92D6C1e31e14520e676a687F0a93788B716BEff5')
GROUP BY 1,2
Run a query to Download Data