AntonidasBridge Txns - Per Blockchain
Updated 2023-09-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from 7d57de99-3dab-40d0-8cee-35c708d919d8
select
date_trunc('week', block_timestamp) as day_date,
blockchain,
sum(IFF(direction='inbound', amount, 0)) as inflow_to_chain,
sum(IFF(direction='outbound', -amount, 0)) as outflow_from_chain,
inflow_to_chain + outflow_from_chain as net_flow
from flow.core.ez_bridge_transactions
where block_timestamp > current_date - 90
and block_timestamp > '2023-02-01'
group by 1,2
Run a query to Download Data