binhachonETH Deposited or Withdrawn - #1
Updated 2022-06-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with deposit_transactions as (
select
block_timestamp,
eth_from_address as user_address,
amount
from ethereum.core.ez_eth_transfers
where origin_function_signature = '0xb6b55f25'
and eth_to_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'
),
deposit_amount as (
select
date_trunc('week', block_timestamp) as time,
sum(amount) as deposit_amount,
count(distinct user_address) as number_of_depositors
from deposit_transactions
group by 1
),
withdraw_transactions as (
select
block_timestamp,
eth_to_address as user_address,
amount
from ethereum.core.ez_eth_transfers
where origin_function_signature = '0x00f714ce'
and eth_from_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'
),
withdraw_amount as (
select
date_trunc('week', block_timestamp) as time,
sum(amount) as withdraw_amount,
count(distinct user_address) as number_of_withdrawers
from withdraw_transactions
group by 1
),
timetable as (
select
Run a query to Download Data