PROJECT_NAME | |
|---|---|
1 | fidelity |
2 | coinbase |
3 | grayscale |
4 | hotbit |
5 | bitstamp |
6 | coinsquare |
7 | bake |
8 | kucoin |
9 | bitwise |
10 | firi |
11 | bitmex |
12 | vaneck |
13 | poloniex |
14 | binance |
15 | woo network |
16 | korbit |
17 | swissborg |
18 | crypto.com |
19 | p2pool |
20 | coindcx |
datavortexback test
Updated 2025-02-28
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
›
⌄
⌄
SELECT DISTINCT PROJECT_NAME
FROM bitcoin.core.dim_entity_clusters
WHERE PROJECT_NAME IS NOT NULL
LIMIT 100;
/*
WITH outputs AS (
SELECT
tx_id,
block_number,
block_timestamp,
PUBKEY_SCRIPT_HEX,
PUBKEY_SCRIPT_TYPE,
VALUE_SATS / 100000000.0 AS value,
"INDEX"
FROM bitcoin.core.fact_outputs
),
nulldata_outputs AS (
SELECT
tx_id,
block_number,
block_timestamp,
PUBKEY_SCRIPT_HEX AS script_hex,
SUBSTR(PUBKEY_SCRIPT_HEX, 5) AS data
FROM outputs
WHERE PUBKEY_SCRIPT_TYPE = 'nulldata'
),
value_outputs AS (
SELECT
tx_id,
SUM(value) AS total_value
FROM outputs
WHERE PUBKEY_SCRIPT_TYPE != 'nulldata'
AND "INDEX" = 0
GROUP BY tx_id
),
potential_lombard AS (
Last run: 3 months ago
31
375B
9s