FlippppppaFlows - Bridges weekly copy
    Updated 2024-12-17
    -- forked from charliemarketplace / Flows - Bridges weekly @ https://flipsidecrypto.xyz/charliemarketplace/q/E7NqahKNALdh/flows---bridges-weekly

    -- forked from Flows - Bridges @ https://flipsidecrypto.xyz/studio/queries/1af0d4d4-1221-439c-9c2e-d431492e1e7c

    select date_trunc('week', day_) as week_,
    other_chain,
    sum(inbound_usd) as inbound_usd,
    sum(outbound_usd) as outbound_usd,
    sum(net_flow_usd) as net_flow_usd,
    sum(total_volume_usd) as total_volume_usd
    from
    datascience_public_misc.near_analytics.bridge_flows_daily
    -- rolling 24 weeks
    where day_ >= date_trunc('week', current_date - 168)
    group by week_, other_chain
    order by week_ asc, other_chain asc



    Last run: 2 months ago
    WEEK_
    OTHER_CHAIN
    INBOUND_USD
    OUTBOUND_USD
    NET_FLOW_USD
    TOTAL_VOLUME_USD
    1
    2024-07-01 00:00:00.000aurora5171972.4299718592250.914890174579721.515081635764223.34486197
    2
    2024-07-01 00:00:00.000ethereum3385972.42674014423375.7134689172962596.713271223809348.14020906
    3
    2024-07-01 00:00:00.000huobi eco chain0.0019357453200.001935745320.00193574532
    4
    2024-07-01 00:00:00.000solana102.6345950191239.058871127-1136.4242761081341.693466146
    5
    2024-07-08 00:00:00.000aurora6992726.05773647356716.0750549186636009.982681557349442.13279139
    6
    2024-07-08 00:00:00.000binance smart chain0.00195506546700.0019550654670.001955065467
    7
    2024-07-08 00:00:00.000celo0.49232780800.4923278080.492327808
    8
    2024-07-08 00:00:00.000ethereum1989417.50260816471073.720486011518343.782122152460491.22309417
    9
    2024-07-08 00:00:00.000huobi eco chain0347.436045641-347.436045641347.436045641
    10
    2024-07-08 00:00:00.000solana0.0239925334900.023992533490.02399253349
    11
    2024-07-15 00:00:00.000aurora2175549.04974577193953.3759043051981595.673841472369502.42565008
    12
    2024-07-15 00:00:00.000binance smart chain0.08581868389402.748397251-402.662578567402.834215935
    13
    2024-07-15 00:00:00.000celo17.048022761017.04802276117.048022761
    14
    2024-07-15 00:00:00.000ethereum2273227.55276629439329.7512020161833897.801564272712557.3039683
    15
    2024-07-15 00:00:00.000huobi eco chain0.0119035242329.98863648-29.97673295630.000540004
    16
    2024-07-15 00:00:00.000polygon0.0012657701800.001265770180.00126577018
    17
    2024-07-15 00:00:00.000solana26.1455184071533.510964107-1507.36544571559.656482514
    18
    2024-07-22 00:00:00.000aurora300490.906111422355733.834681538-55242.928570116656224.74079296
    19
    2024-07-22 00:00:00.000binance smart chain0214.482748654-214.482748654214.482748654
    20
    2024-07-22 00:00:00.000celo24.947473526024.94747352624.947473526
    ...
    128
    12KB
    1s