mariyaInflow to FTX
Updated 2022-11-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with alamedaftx as ( select *
from ethereum.core.dim_labels
where label ilike 'ftx%' or address_name ilike 'ftx%'), Inflowt
as ( select sum (amount_usd) as Inflow_Volume
from ethereum.core.ez_token_transfers
where to_address in (select distinct address from alamedaftx)
and from_address not in (select distinct address from alamedaftx)
and block_timestamp >= '2022-11-07'), Outflowt
as ( select sum (amount_usd) as Outflow_Volume
from ethereum.core.ez_token_transfers
where from_address in (select distinct address from alamedaftx)
and to_address not in (select distinct address from alamedaftx)
and block_timestamp >= '2022-11-07' )
select inflow_volume as Inflow, outflow_volume*-1
as Outflow, inflow_volume - outflow_volume as Net_Flow
from Inflowt t1 join Outflowt t2
Run a query to Download Data