sixahi6066US Govt - Daily Net Flow of BTC copy
    Updated 2024-06-19
    -- forked from zakkisyed / US Govt - Daily Net Flow of BTC @ https://flipsidecrypto.xyz/zakkisyed/q/vrNzFnDornJL/us-govt---daily-net-flow-of-btc

    -- forked from Bitcoin ETFs - Daily Net Flow @ https://flipsidecrypto.xyz/edit/queries/a0f6ba71-d036-4989-931c-7d2aecdff190

    -- forked from Bitcoin ETFs - Net Holdings @ https://flipsidecrypto.xyz/edit/queries/7224ec56-3baf-46d3-9c93-79fc5ce248ad

    -- Select ETF_name, net_holdings, 1D_change, 7D_Change
    -- from final_table




    WITH USGOVT_CTE AS (
    SELECT 'U.S. Government' as fund_name, '3G98jSULfhrES1J9HKfZdDjXx1sTNvHkhN' as address, '3 of 8' as label_name
    UNION ALL
    SELECT 'U.S. Government' as fund_name, '34oud2h4JYFef7tEpag5xgE4oUbyQDteoa' as address, '3 of 8' as label_name
    UNION ALL
    SELECT 'U.S. Government' as fund_name, '3HWR6fmv22vUWgQLbuMRX3NBfmMpjNuV8f' as address, '3 of 8' as label_name
    UNION ALL
    SELECT 'U.S. Government' as fund_name, '31pCdkyF6Ep8UkzpkWpv3SMbY3C5s7VhXL' as address, '3 of 8' as label_name
    UNION ALL
    SELECT 'U.S. Government' as fund_name, '3EHeQxMkEbH3wD69A9mL1WF2QhdJAEnqBv' as address, '3 of 8' as label_name
    UNION ALL
    SELECT 'U.S. Government' as fund_name, '3JagUxG3z1aPqRNDfxukGRdHSmZwTffCHN' as address, '3 of 8' as label_name
    UNION ALL
    SELECT 'U.S. Government' as fund_name, '3JszuRdFFEz1WbQKam4XjAtnZsYX62RLMX' as address, '3 of 8' as label_name
    UNION ALL
    SELECT 'U.S. Government' as fund_name, '33uhW878fbvVxZuZ216q2XvgdajLdG4rN4' as address, '3 of 8' as label_name
    UNION ALL
    SELECT 'U.S. Government' as fund_name, '34oud2h4JYFef7tEpag5xgE4oUbyQDteoa' as address, '3 of 8' as label_name
    UNION ALL
    SELECT 'U.S. Government' as fund_name, '36PL3NFuq2787HssvbfhDbtU2WupqUTwST' as address, '3 of 8' as label_name
    UNION ALL
    SELECT 'U.S. Government' as fund_name, '3H8cmLndtkBs7kiHByhHAddTzy8taUwYPt' as address, '3 of 8' as label_name
    ),
    -- Aggregating input values with daily truncation
    QueryRunArchived: QueryRun has been archived