TIME | ISSUER | HISTORY | BALANCE | |
|---|---|---|---|---|
1 | 2024-02-19 00:00:00.000 | Grayscale | -3732.68593965 | 452595.6608717 |
2 | 2024-02-19 00:00:00.000 | 21Shares | 174.9920424 | 26814.90686092 |
3 | 2024-02-19 00:00:00.000 | Bitwise | 403.46540998 | 22517.79638079 |
4 | 2024-02-19 00:00:00.000 | Fidelity | 2251.78448075 | 18083.56386038 |
5 | 2024-02-19 00:00:00.000 | Invesco | 0 | 6100 |
6 | 2024-02-12 00:00:00.000 | Grayscale | -8392.08557058 | 456328.34681135 |
7 | 2024-02-12 00:00:00.000 | BlackRock | 33473.85264355 | 115989.8043228 |
8 | 2024-02-12 00:00:00.000 | 21Shares | 8049.91471852 | 26639.91481852 |
9 | 2024-02-12 00:00:00.000 | Bitwise | 4716.19733331 | 22114.33097081 |
10 | 2024-02-12 00:00:00.000 | Fidelity | -7315.87413517 | 15831.77937963 |
11 | 2024-02-12 00:00:00.000 | Invesco | -1480 | 6100 |
12 | 2024-02-12 00:00:00.000 | VanEck | 339.42932953 | 3677.39661676 |
13 | 2024-02-12 00:00:00.000 | Valkyrie | 2.013114068e-14 | 2700.34381603 |
14 | 2024-02-12 00:00:00.000 | WisdomTree | 154.00390507 | 562.91504472 |
15 | 2024-02-05 00:00:00.000 | Grayscale | -13275.48097632 | 464720.43238193 |
16 | 2024-02-05 00:00:00.000 | BlackRock | 12510.39136661 | 82515.95167925 |
17 | 2024-02-05 00:00:00.000 | Fidelity | -2385.18397185 | 23147.6535148 |
18 | 2024-02-05 00:00:00.000 | 21Shares | 2700 | 18590.0001 |
19 | 2024-02-05 00:00:00.000 | Bitwise | 2344.46878218 | 17398.1336375 |
20 | 2024-02-05 00:00:00.000 | Invesco | 490 | 7580 |
0xEdwardbtcetf_weekly
Updated 2024-02-20
999
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
›
⌄
with -- label
gsheet AS (
SELECT
livequery.live.udf_api(
'GET',
'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
{ 'Content-Type': 'application/json' },
{ 'sheets_id': '1m2mul3uqGcjYA7RCoUnhLNpRaxNwQH2-P9BzxoZS4gM',
'tab_name': 'ETF' }
) as result
from
dual
),
label as (
select
value:"issuer" :: varchar as issuer,
value:"symbol" :: varchar as symbol,
value:"add" :: varchar as
add
from
gsheet,
lateral flatten (input = > result:data)
where
issuer != 'Grayscale'
),
-- database
data as (
select
block_timestamp,
'out' as event,
0 - value as value,
pubkey_script_address,
tx_id
from
bitcoin.core.fact_inputs
union
Last run: about 1 year ago
...
218
15KB
33s