leo-lZzln2Untitled Query
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 token_prices as (select avg(price_usd) as avg , symbol , date_trunc('month', timestamp) as m from flow.core.fact_prices
group by symbol, m)
, TokensDeposited as (select sum(event_data:amount) as sm , symbol , date_trunc('month', block_timestamp) as m
from flow.core.fact_events as e inner join flow.core.fact_prices as p
on e.event_contract=p.token_contract
where event_data:amount::int > 0 and TX_SUCCEEDED=1 and event_type='TokensDeposited'
group by m, symbol)
, TokensWithdrawn as (select sum(event_data:amount) as sm , symbol , date_trunc('month', block_timestamp) as m
from flow.core.fact_events as e inner join flow.core.fact_prices as p
on e.event_contract=p.token_contract
where event_data:amount::int > 0 and TX_SUCCEEDED=1 and event_type='TokensWithdrawn'
group by m, symbol)
, net_flow as (select TokensDeposited.sm - TokensWithdrawn.sm as net ,TokensDeposited.m as date , TokensDeposited.symbol from TokensDeposited
inner join TokensWithdrawn on TokensWithdrawn.m=TokensDeposited.m and TokensWithdrawn.symbol=TokensDeposited.symbol )
, swap_in_symbols as (select sum(token_in_amount ) as in_sm , symbol , date_trunc('month', block_timestamp) as m
from flow.core.ez_swaps as s inner join flow.core.fact_prices as p
on s.token_in_contract=p.token_contract
group by symbol,m)
, swap_out_symbols as (select sum(token_out_amount ) as out_sm , symbol , date_trunc('month', block_timestamp) as m
from flow.core.ez_swaps as s inner join flow.core.fact_prices as p
on s.token_out_contract=p.token_contract
group by symbol,m)
, transfers as (select sum(amount) as sm, symbol, date_trunc('month', block_timestamp) as m
from flow.core.ez_token_transfers as t inner join flow.core.fact_prices as p
on t.token_contract=p.token_contract
group by symbol,m)
, allblockchain_inbounded as (select sum(amount) as sm , symbol , date_trunc('month', block_timestamp) as m
from flow.core.ez_bridge_transactions as b inner join flow.core.fact_prices as p
on b.token_contract=p.token_contract and direction='inbound'
group by symbol,m)
, allblockchain_outbound as (select sum(amount) as sm , symbol , date_trunc('month', block_timestamp) as m
from flow.core.ez_bridge_transactions as b inner join flow.core.fact_prices as p
on b.token_contract=p.token_contract and direction='outbound'
group by symbol,m)
, Ethereum_chain_inbounded as (select sum(amount) as sm , symbol , date_trunc('month', block_timestamp) as m
from flow.core.ez_bridge_transactions as b inner join flow.core.fact_prices as p
Run a query to Download Data