MLDZMNCelsius wallet withdrawal
Updated 2023-05-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
date_trunc('hour',block_timestamp)as hour,
count(distinct tx_hash) as "Count of withdraw",
sum(amount) as "Volume in stETH",
sum(amount_usd) as "Volume in USD"
FROM ethereum.core.ez_token_transfers s
left join crosschain.core.address_labels a on s.to_address=a.address
WHERE contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
and block_timestamp>='2023-05-15'
and from_address not in ('0x0000000000000000000000000000000000000000')
and ADDRESS_NAME ilike '%celsius wallet%'
GROUP BY 1
Run a query to Download Data