Updated 2022-10-22
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 assets_coming_from as (select sum(amount) as eth_value , sum(amount_usd) as usd_value , label
from ethereum.core.ez_token_transfers as t inner join ethereum.core.dim_labels as l
on from_address=address
where amount>0 and amount_usd >0
and to_address in ('0xa752ef191e8b103150d5fe4a6639a598ede5a50f','0x7be48633d86aa9821284b01030b8a3f9b06ea876','0x2c4f1df9c7de0c59778936c9b145ff56813f3295',
'0xdaf0b40b961ca51fc914fbabda8e779619576cad','0xdeded2dc963c7461833633c6f45bf2e21eef8ba9','0xcf6dee9947fddc958985e5283e63d41cbc83ff61',
'0x70edf1c215d0ce69e7f16fd4e6276ba0d99d4de7','0xe8883baef3869e14e4823f46662e81d4f7d2a81f','0x4547254e6e3195ce57bc50352193a25c2f4b8fcf',
'0x736e16998a3fe6914f9f66faebd447809965e976','0xa4108aa1ec4967f8b52220a4f7e94a8201f2d906')
group by label),
assets_coming_from_daily as (select sum(amount) as eth_value , sum(amount_usd) as usd_value , label , block_timestamp::date as date
from ethereum.core.ez_token_transfers as t inner join ethereum.core.dim_labels as l
on from_address=address
where amount>0 and amount_usd >0
and to_address in ('0xa752ef191e8b103150d5fe4a6639a598ede5a50f','0x7be48633d86aa9821284b01030b8a3f9b06ea876','0x2c4f1df9c7de0c59778936c9b145ff56813f3295',
'0xdaf0b40b961ca51fc914fbabda8e779619576cad','0xdeded2dc963c7461833633c6f45bf2e21eef8ba9','0xcf6dee9947fddc958985e5283e63d41cbc83ff61',
'0x70edf1c215d0ce69e7f16fd4e6276ba0d99d4de7','0xe8883baef3869e14e4823f46662e81d4f7d2a81f','0x4547254e6e3195ce57bc50352193a25c2f4b8fcf',
'0x736e16998a3fe6914f9f66faebd447809965e976','0xa4108aa1ec4967f8b52220a4f7e94a8201f2d906')
group by label,date),
where_going as (select sum(amount) as eth_value , sum(amount_usd) as usd_value , label
from ethereum.core.ez_token_transfers as t inner join ethereum.core.dim_labels as l
on to_address=address
where amount>0 and amount_usd >0
and from_address in ('0xa752ef191e8b103150d5fe4a6639a598ede5a50f','0x7be48633d86aa9821284b01030b8a3f9b06ea876','0x2c4f1df9c7de0c59778936c9b145ff56813f3295',
'0xdaf0b40b961ca51fc914fbabda8e779619576cad','0xdeded2dc963c7461833633c6f45bf2e21eef8ba9','0xcf6dee9947fddc958985e5283e63d41cbc83ff61',
'0x70edf1c215d0ce69e7f16fd4e6276ba0d99d4de7','0xe8883baef3869e14e4823f46662e81d4f7d2a81f','0x4547254e6e3195ce57bc50352193a25c2f4b8fcf',
'0x736e16998a3fe6914f9f66faebd447809965e976','0xa4108aa1ec4967f8b52220a4f7e94a8201f2d906')
group by label),
where_going_daily as (select sum(amount) as eth_value , sum(amount_usd) as usd_value , label , block_timestamp::date as date
from ethereum.core.ez_token_transfers as t inner join ethereum.core.dim_labels as l
on to_address=address
where amount>0 and amount_usd >0
and from_address in ('0xa752ef191e8b103150d5fe4a6639a598ede5a50f','0x7be48633d86aa9821284b01030b8a3f9b06ea876','0x2c4f1df9c7de0c59778936c9b145ff56813f3295',
'0xdaf0b40b961ca51fc914fbabda8e779619576cad','0xdeded2dc963c7461833633c6f45bf2e21eef8ba9','0xcf6dee9947fddc958985e5283e63d41cbc83ff61',
'0x70edf1c215d0ce69e7f16fd4e6276ba0d99d4de7','0xe8883baef3869e14e4823f46662e81d4f7d2a81f','0x4547254e6e3195ce57bc50352193a25c2f4b8fcf',
'0x736e16998a3fe6914f9f66faebd447809965e976','0xa4108aa1ec4967f8b52220a4f7e94a8201f2d906')
group by label,date),
Run a query to Download Data