MOHAMAD23sum eth value last year
Updated 2022-08-10
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 addresses as (
select ADDRESS , ADDRESS_NAME
from ethereum.core.dim_labels
where label like '%tornado cash%'
),
y as (
select sum (ETH_VALUE) as sum_ , '0.01<transactions<0.1' as eth
from ethereum.core.fact_transactions
join addresses on ethereum.core.fact_transactions.TO_ADDRESS=addresses.ADDRESS
where BLOCK_TIMESTAMP >= DATEADD(month, - 12, GETDATE())
AND BLOCK_TIMESTAMP <= getdate() and ETH_VALUE between 0.01 and 0.1
),
yy as (
select sum (ETH_VALUE) as sum_ , '0.1<transactions<1' as eth
from ethereum.core.fact_transactions
join addresses on ethereum.core.fact_transactions.TO_ADDRESS=addresses.ADDRESS
where BLOCK_TIMESTAMP >= DATEADD(month, - 12, GETDATE())
AND BLOCK_TIMESTAMP <= getdate() and ETH_VALUE between 0.1 and 1
),
yyy as (
select sum (ETH_VALUE) as sum_ , '1<transactions<10' as eth
from ethereum.core.fact_transactions
join addresses on ethereum.core.fact_transactions.TO_ADDRESS=addresses.ADDRESS
where BLOCK_TIMESTAMP >= DATEADD(month, - 12, GETDATE())
AND BLOCK_TIMESTAMP <= getdate() and ETH_VALUE between 1 and 10
),
yyyy as (
select sum (ETH_VALUE) as sum_ , '10<transactions<100' as eth
from ethereum.core.fact_transactions
join addresses on ethereum.core.fact_transactions.TO_ADDRESS=addresses.ADDRESS
where BLOCK_TIMESTAMP >= DATEADD(month, - 12, GETDATE())
AND BLOCK_TIMESTAMP <= getdate() and ETH_VALUE between 10 and 100
),
yyyyy as (
select sum (ETH_VALUE) as sum_ , '100<transactions' as eth
from ethereum.core.fact_transactions
Run a query to Download Data