emferonsFlows - Bridge Protocols weekly copy
Updated 2025-01-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from charliemarketplace / Flows - Bridge Protocols weekly @ https://flipsidecrypto.xyz/charliemarketplace/q/hd0q8y0TP0bP/flows---bridge-protocols-weekly
-- forked from Flows - Bridge Protocols @ https://flipsidecrypto.xyz/studio/queries/dc613001-cbb3-4c94-ab53-99cdea74656b
select date_trunc('week', day_) as week_,
platform,
sum(inbound_volume_usd) as inbound_usd,
sum(outbound_volume_usd) as outbound_usd,
sum(net_volume_usd) as net_flow_usd,
sum(total_volume_usd) as total_volume_usd
from
datascience_public_misc.near_analytics.platform_bridge_flows_daily
-- rolling 24 weeks
where day_ >= date_trunc('week', current_date - 168)
group by week_, platform
order by week_ asc, platform asc
QueryRunArchived: QueryRun has been archived