datavortexTotal WEEKLY
    Updated 2025-03-29
    WITH
    combined_data AS (
    -- Swimmer Weekly Data
    SELECT
    "Week" AS week,
    "Total Unique Bridge Transactions" AS total_unique_bridge_txns,
    "Total Unique Bridgers" AS total_unique_bridgers,
    "Total Inflow (USD)" AS total_inflow_usd,
    "Total Outflow (USD)" AS total_outflow_usd,
    "Net Flow (USD)" AS net_flow_usd
    FROM $query('fb33e00d-9eec-4c22-84cd-ee4ecde53b78') -- Swimmer weekly query
    UNION ALL

    -- stepper Weekly Data
    SELECT
    "Week" AS week,
    "Total Unique Bridge Transactions" AS total_unique_bridge_txns,
    "Total Unique Bridgers" AS total_unique_bridgers,
    "Total Inflow (USD)" AS total_inflow_usd,
    "Total Outflow (USD)" AS total_outflow_usd,
    "Net Flow (USD)" AS net_flow_usd
    FROM $query('9c507e68-9300-4c62-a748-3eae1a98ffef') -- stepper weekly query
    UNION ALL

    -- Xena Weekly Data
    SELECT
    "Week" AS week,
    "Total Unique Bridge Transactions" AS total_unique_bridge_txns,
    "Total Unique Bridgers" AS total_unique_bridgers,
    "Total Inflow (USD)" AS total_inflow_usd,
    "Total Outflow (USD)" AS total_outflow_usd,
    "Net Flow (USD)" AS net_flow_usd
    FROM $query('f5456218-c1d2-4c0c-8d9f-e45689bb05a9') -- Xena weekly query
    Last run: 3 months ago
    Week
    Total Unique Bridge Transactions
    Total Unique Bridgers
    Total Inflow (USD)
    Total Outflow (USD)
    Net Flow (USD)
    1
    2022-03-28 00:00:00.000304521786866855014.147372248060071.619797618794942.5275746
    2
    2022-04-04 00:00:00.0009432609618111077.59753852554291.7190643215556785.8784742
    3
    2022-04-11 00:00:00.000272819462933628.77273594498119.3136784442435509.4590575
    4
    2022-04-18 00:00:00.000154411721335335.25979419208416.478463461126918.78133073
    5
    2022-04-25 00:00:00.000176811622487017.42681858177888.7147918722309128.7120267
    6
    2022-05-02 00:00:00.00010127241382270.6710447292478.4828281841289792.18821654
    7
    2022-05-09 00:00:00.0001028704738254.62459543890127.221607334648127.402988104
    8
    2022-05-16 00:00:00.000696482486242.7010699188345.179182218397897.521887692
    9
    2022-05-23 00:00:00.000740484295336.24967287838706.698361234256629.551311646
    10
    2022-05-30 00:00:00.000594368287437.4879429332379.867871264255057.620071664
    11
    2022-06-06 00:00:00.000454298142298.98000638616994.334033416125304.64597297
    12
    2022-06-13 00:00:00.000506312248866.4798786948360.359987946240506.119890748
    13
    2022-06-20 00:00:00.0001214626947223.484275042206112.072799264741111.411475776
    14
    2022-06-27 00:00:00.0001100506569133.5448157739165.348074828529968.196740942
    15
    2022-07-04 00:00:00.000836556285180.44323545216061.9024396269118.540795852
    16
    2022-07-11 00:00:00.000750474170754.24018154616005.312902202154748.927279344
    17
    2022-07-18 00:00:00.000772464283482.97606097430931.471057516252551.505003458
    18
    2022-07-25 00:00:00.000852550408918.685490423997.479502534384921.205987866
    19
    2022-08-01 00:00:00.0001724692446756.01362226811580.242635686435175.770986582
    20
    2022-08-08 00:00:00.0001370732728264.71326312821577.979250548706686.73401258
    ...
    157
    13KB
    4s