sixahi6066US Govt - Daily Net Flow of BTC copy
Updated 2024-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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