TIME | ISSUER | HISTORY | BALANCE | |
|---|---|---|---|---|
1 | 2024-02-20 00:00:00.000 | Grayscale | -3732.68593965 | 452595.660871701 |
2 | 2024-02-20 00:00:00.000 | 21Shares | 174.9920424 | 26814.90686092 |
3 | 2024-02-20 00:00:00.000 | Bitwise | 403.46540998 | 22517.79638079 |
4 | 2024-02-20 00:00:00.000 | Fidelity | 2251.78448075 | 18083.56386038 |
5 | 2024-02-20 00:00:00.000 | Invesco | 0 | 6100 |
6 | 2024-02-16 00:00:00.000 | Grayscale | -3840.02252491 | 456328.346811351 |
7 | 2024-02-16 00:00:00.000 | BlackRock | 6380.40112278 | 115989.8043228 |
8 | 2024-02-16 00:00:00.000 | 21Shares | 1714.96135416 | 26639.91481852 |
9 | 2024-02-16 00:00:00.000 | Bitwise | 2317.20683367 | 22114.33097081 |
10 | 2024-02-16 00:00:00.000 | Fidelity | 1880.13074784 | 15831.77937963 |
11 | 2024-02-16 00:00:00.000 | Invesco | 25 | 6100 |
12 | 2024-02-16 00:00:00.000 | VanEck | 56.57081414 | 3677.39661676 |
13 | 2024-02-16 00:00:00.000 | WisdomTree | 53.1048082 | 562.91504472 |
14 | 2024-02-15 00:00:00.000 | Grayscale | -2459.00394337 | 460168.369336261 |
15 | 2024-02-15 00:00:00.000 | BlackRock | 4329.08262973 | 109609.40320002 |
16 | 2024-02-15 00:00:00.000 | 21Shares | 1959.96611552 | 24924.95346436 |
17 | 2024-02-15 00:00:00.000 | Bitwise | 910.52595207 | 19797.12413714 |
18 | 2024-02-15 00:00:00.000 | Fidelity | 2295.50845545 | 13951.64863179 |
19 | 2024-02-15 00:00:00.000 | Invesco | -725 | 6075 |
20 | 2024-02-15 00:00:00.000 | VanEck | 56.57097666 | 3620.82580262 |
0xEdwardbtcetf_daily
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)
),
-- database
data as (
select
block_timestamp,
'out' as event,
0 - value as value,
pubkey_script_address,
tx_id
from
bitcoin.core.fact_inputs
Last run: about 1 year ago
...
762
50KB
43s