Sistema completo

Documentazione tecnica auto-generata · cache 60s · snapshot 2026-08-28 05:11:00

Server

Host	hydra-unified	OS	Ubuntu 24.04.4 LTS
Kernel	6.8.0-90-generic	Uptime	144g 9h 38m
CPU core	4	Load (1/5/15m)	3.33 / 2.37 / 1.74
RAM	3.4 GB / 7.6 GB (45.4%)	Disco /	75G totali, 62G usati (87%), 10G liberi

PostgreSQL

PostgreSQL 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit
Dimensione database: 25 GB · 22 tabelle hydra_v6 + 10 dashboard. Conteggi righe stimati (pg_class.reltuples, prefisso “~”); “N/A” se la query supera il timeout di 2s.

Tabelle hydra_v6 (17)

candles_1m — ~73,274,296 righe · 19.9 GB · OHLCV 1 minuto. PK(symbol, open_time). open_time = Unix ms apertura candela. ~44.3M righe, 439 asset.

WRITTEN BY DATA SOURCE (via SERVER LOG)

READ BY LIVE SCANNER, SERVER STAT, SERVER ANALYZ, SERVER QUALITY

DATA FLOW in: Binance WS (kline_1m) -> normalizzazione -> SERVER LOG → out: Aggregata in 15m/1h/4h/1d; alimenta detector e indicatori

OHLCV base 1 minuto, append-only.

Sample row (SELECT * LIMIT 1):

symbol	ARBUSDT
open_time	1775672460000
open	0.1007
high	0.1007
low	0.1007
close	0.1007
volume	404018.2
quote_volume	40684.63274
trades	30

Schema:

Colonna	Tipo	Null	Commento
symbol	text	NO
open_time	bigint	NO	Unix ms di apertura candela (BIGINT).
open	double precision	NO
high	double precision	NO
low	double precision	NO
close	double precision	NO
volume	double precision	NO
quote_volume	double precision	YES	Volume in valuta quote (USDT).
trades	integer	YES	Numero di trade nella candela.

Constraints:

candles_1m_pkey: PRIMARY KEY (symbol, open_time)

Indici:

CREATE UNIQUE INDEX candles_1m_pkey ON public.candles_1m USING btree (symbol, open_time)
CREATE INDEX idx_candles_1m_open_time ON public.candles_1m USING btree (open_time)

candles_15m — ~8,512,020 righe · 1.8 GB · OHLCV 15 minuti. PK(symbol, open_time). ~6.5M righe.

WRITTEN BY DATA SOURCE / aggregazione (via SERVER LOG)

READ BY LIVE SCANNER, SERVER STAT

DATA FLOW in: Aggregazione da candles_1m → out: Detector LIVE SCANNER, feature SERVER STAT

Timeframe derivato.

Sample row (SELECT * LIMIT 1):

symbol	ADAUSDT
open_time	1767878100000
open	0.3893
high	0.3903
low	0.3886
close	0.3901
volume	438568.0
quote_volume	170836.73834
trades	1159

Schema:

Colonna	Tipo	Null
symbol	text	NO
open_time	bigint	NO
open	double precision	NO
high	double precision	NO
low	double precision	NO
close	double precision	NO
volume	double precision	NO
quote_volume	double precision	YES
trades	integer	YES

Constraints:

candles_15m_pkey: PRIMARY KEY (symbol, open_time)

Indici:

CREATE UNIQUE INDEX candles_15m_pkey ON public.candles_15m USING btree (symbol, open_time)
CREATE INDEX idx_candles_15m_open_time ON public.candles_15m USING btree (open_time)

candles_1h — ~2,974,019 righe · 560.4 MB · OHLCV 1 ora. PK(symbol, open_time). ~1.6M righe.

WRITTEN BY DATA SOURCE / aggregazione (via SERVER LOG)

READ BY SERVER STAT, SERVER ANALYZ

DATA FLOW in: Aggregazione da candles_1m + backfill storico Binance spot klines (major, 2021+) → out: Indicatori Tier 1-3 (SERVER STAT)

Timeframe principale indicatori. Backfill storico lungo da Binance spot (2021-oggi) per 20 major (Passo1 ricerca, scripts/14): ~48k candele/asset.

Sample row (SELECT * LIMIT 1):

symbol	ADAUSDT
open_time	1767880800000
open	0.3891
high	0.3902
low	0.3849
close	0.3887
volume	10309012.5
quote_volume	3999154.25694
trades	18807

Schema:

Colonna	Tipo	Null
symbol	text	NO
open_time	bigint	NO
open	double precision	NO
high	double precision	NO
low	double precision	NO
close	double precision	NO
volume	double precision	NO
quote_volume	double precision	YES
trades	integer	YES

Constraints:

candles_1h_pkey: PRIMARY KEY (symbol, open_time)

Indici:

CREATE UNIQUE INDEX candles_1h_pkey ON public.candles_1h USING btree (symbol, open_time)
CREATE INDEX idx_candles_1h_open_time ON public.candles_1h USING btree (open_time)

candles_4h — ~568,527 righe · 92.5 MB · OHLCV 4 ore. PK(symbol, open_time). ~568K righe. Aggiunta in fase-1-migration-v2.

WRITTEN BY DATA SOURCE / aggregazione (via SERVER LOG)

READ BY SERVER STAT, SERVER ANALYZ

DATA FLOW in: Aggregazione da candles_1m → out: Indicatori multi-timeframe

Timeframe derivato.

Sample row (SELECT * LIMIT 1):

symbol	SOLUSDT
open_time	1761148800000
open	183.99
high	184.96
low	177.07
close	180.2
volume	862504.568
quote_volume	156715416.5352
trades	631942

Schema:

Colonna	Tipo	Null
symbol	text	NO
open_time	bigint	NO
open	double precision	NO
high	double precision	NO
low	double precision	NO
close	double precision	NO
volume	double precision	NO
quote_volume	double precision	YES
trades	integer	YES

Constraints:

candles_4h_pkey: PRIMARY KEY (symbol, open_time)

Indici:

CREATE UNIQUE INDEX candles_4h_pkey ON public.candles_4h USING btree (symbol, open_time)
CREATE INDEX idx_candles_4h_open_time ON public.candles_4h USING btree (open_time)

candles_1d — ~127,778 righe · 19.9 MB · OHLCV 1 giorno. PK(symbol, open_time). ~94K righe.

WRITTEN BY DATA SOURCE / aggregazione (via SERVER LOG)

READ BY SERVER STAT, SERVER ANALYZ

DATA FLOW in: Aggregazione da candles_1m + backfill storico Binance spot klines (major, 2021+) → out: Indicatori daily, beta, regime

Timeframe daily. Backfill storico lungo da Binance spot (2021-oggi) per 20 major (Passo1 ricerca, scripts/14): 2008 candele/asset. Copre bull+bear per ricerca edge.

Sample row (SELECT * LIMIT 1):

symbol	ADAUSDT
open_time	1761177600000
open	0.6238
high	0.654
low	0.6227
close	0.6428
volume	93548863.2
quote_volume	59800155.24974
trades	241871

Schema:

Colonna	Tipo	Null
symbol	text	NO
open_time	bigint	NO
open	double precision	NO
high	double precision	NO
low	double precision	NO
close	double precision	NO
volume	double precision	NO
quote_volume	double precision	YES
trades	integer	YES

Constraints:

candles_1d_pkey: PRIMARY KEY (symbol, open_time)

Indici:

CREATE UNIQUE INDEX candles_1d_pkey ON public.candles_1d USING btree (symbol, open_time)
CREATE INDEX idx_candles_1d_open_time ON public.candles_1d USING btree (open_time)

driver_per_asset — ~1,503,667 righe · 363.2 MB · Driver per-asset (funding_rate, open_interest, long_short_ratio...). PK(driver_name, symbol, timestamp_ms). ~21K righe, 10 major.

WRITTEN BY DATA SOURCE (via SERVER LOG)

READ BY LIVE SCANNER, SERVER STAT, SERVER ANALYZ

DATA FLOW in: Binance REST (funding, OI, long/short) → out: Edge Funding Q90, detector funding_extreme

Driver per simbolo (10 major piu' densi).

Sample row (SELECT * LIMIT 1):

driver_name	funding_rate
symbol	AGLDUSDT
timestamp_ms	1690617600000
value	0.0001
metadata	NULL

Schema:

Colonna	Tipo	Null	Commento
driver_name	text	NO	Nome driver: funding_rate, open_interest, long_short_ratio, ...
symbol	text	NO
timestamp_ms	bigint	NO
value	double precision	YES	Valore numerico del driver al timestamp.
metadata	jsonb	YES	Payload JSONB con dettagli aggiuntivi.

Constraints:

driver_per_asset_pkey: PRIMARY KEY (driver_name, symbol, timestamp_ms)

Indici:

CREATE UNIQUE INDEX driver_per_asset_pkey ON public.driver_per_asset USING btree (driver_name, symbol, timestamp_ms)
CREATE INDEX idx_driver_per_asset_name_ts ON public.driver_per_asset USING btree (driver_name, timestamp_ms)
CREATE INDEX idx_driver_per_asset_sym_ts ON public.driver_per_asset USING btree (symbol, timestamp_ms)

driver_global — ~1,074 righe · 448.0 KB · Driver globali (fear_greed, btc_dominance, stablecoin_supply, macro_*). PK(driver_name, timestamp_ms). ~1074 righe.

WRITTEN BY DATA SOURCE (via SERVER LOG)

READ BY SERVER ANALYZ

DATA FLOW in: Alternative.me (F&G), FRED (DXY/macro), DefiLlama (stablecoin) → out: Moduli di contesto/regime (Cat D)

Driver di mercato globali.

Sample row (SELECT * LIMIT 1):

driver_name	fear_greed
timestamp_ms	1763856000000
value	13.0
metadata	{"classification": "Extreme Fear", "time_until_update": ""}

Schema:

Colonna	Tipo	Null	Commento
driver_name	text	NO	Nome driver globale: fear_greed, btc_dominance, ...
timestamp_ms	bigint	NO
value	double precision	YES
metadata	jsonb	YES

Constraints:

driver_global_pkey: PRIMARY KEY (driver_name, timestamp_ms)

Indici:

CREATE UNIQUE INDEX driver_global_pkey ON public.driver_global USING btree (driver_name, timestamp_ms)
CREATE INDEX idx_driver_global_name_ts ON public.driver_global USING btree (driver_name, timestamp_ms)

token_metadata — ~420 righe · 360.0 KB · Un record per simbolo: asset base/quote, tier, listing, attivo. ~420 token.

WRITTEN BY DATA SOURCE

READ BY AGENT AI (filtri universe), LIVE SCANNER

DATA FLOW in: Coingecko / listing Binance → out: Filtri AGENT AI (vol/eta'/spread/blacklist)

Un record per simbolo.

Sample row (SELECT * LIMIT 1):

symbol	0GUSDT
base_asset	0G
quote_asset	USDT
tier	NULL
listed_at	2026-04-19 21:53:00+00:00
is_active	True
metadata	{"name": "0G", "ath_usd": 7.05, "atl_usd": 0.455121, "category": "Artificial Intelligence (AI)", "first_seen": "2026-04-19 21:53:00", "market_cap": 123106703.0,…

Schema:

Colonna	Tipo	Null	Commento
symbol	text	NO
base_asset	text	YES
quote_asset	text	YES
tier	text	YES	Tier di liquidita' / importanza del token.
listed_at	timestamp with time zone	YES
is_active	boolean	NO	TRUE se il token e' nello universe attivo.
metadata	jsonb	YES

Constraints:

token_metadata_pkey: PRIMARY KEY (symbol)

Indici:

CREATE INDEX idx_token_metadata_active ON public.token_metadata USING btree (is_active)
CREATE INDEX idx_token_metadata_tier ON public.token_metadata USING btree (tier)
CREATE UNIQUE INDEX token_metadata_pkey ON public.token_metadata USING btree (symbol)

token_fingerprint_history — ~0 righe · 24.0 KB · Snapshot periodici per simbolo (volume_24h, market_cap, prezzo, liquidita'). PK(symbol, timestamp_ms).

WRITTEN BY DATA SOURCE / fingerprint (legacy v4/v5)

READ BY SERVER QUALITY, AGENT AI

DATA FLOW in: Snapshot periodici volume/mcap/liquidita' → out: Filtri liquidita' e analisi qualita'

Storico fingerprint per simbolo.

Sample row (SELECT * LIMIT 1):

(tabella vuota)

Schema:

Colonna	Tipo	Null
symbol	text	NO
timestamp_ms	bigint	NO
volume_24h	double precision	YES
market_cap	double precision	YES
price	double precision	YES
liquidity	double precision	YES
metadata	jsonb	YES

Constraints:

token_fingerprint_history_pkey: PRIMARY KEY (symbol, timestamp_ms)

Indici:

CREATE INDEX idx_fingerprint_ts ON public.token_fingerprint_history USING btree (timestamp_ms)
CREATE UNIQUE INDEX token_fingerprint_history_pkey ON public.token_fingerprint_history USING btree (symbol, timestamp_ms)

live_events — ~0 righe · 40.0 KB · Eventi grezzi dal LIVE SCANNER / sistema (5 detector: pump, dump, volume_spike, funding_extreme, liquidity_drop).

WRITTEN BY LIVE SCANNER

READ BY SERVER ANALYZ, SERVER QUALITY, AGENT AI

DATA FLOW in: 5 detector @1min su candele/driver → out: Contesto per ANALYZ, audit eventi

Eventi grezzi del mercato.

Sample row (SELECT * LIMIT 1):

(tabella vuota)

Schema:

Colonna	Tipo	Null	Commento
id	bigint	NO
event_type	text	NO	Tipo evento/detector che ha generato l'evento.
symbol	text	YES
timestamp_ms	bigint	NO
severity	text	YES	Severita' evento (info/warning/critical).
payload	jsonb	YES
created_at	timestamp with time zone	NO

Constraints:

live_events_pkey: PRIMARY KEY (id)

Indici:

CREATE INDEX idx_live_events_symbol ON public.live_events USING btree (symbol, timestamp_ms)
CREATE INDEX idx_live_events_ts ON public.live_events USING btree (timestamp_ms)
CREATE INDEX idx_live_events_type ON public.live_events USING btree (event_type)
CREATE UNIQUE INDEX live_events_pkey ON public.live_events USING btree (id)

analyz_signals — ~247 righe · 224.0 KB · Segnali prodotti da SERVER ANALYZ (15 moduli). score 0-1 continuo.

WRITTEN BY SERVER ANALYZ

READ BY AGENT AI, SERVER QUALITY

DATA FLOW in: 15 moduli (Cat A-E) su feature SERVER STAT → out: Decisioni di trading (AGENT AI)

Score 0-1 continuo per simbolo.

Sample row (SELECT * LIMIT 1):

id	211
symbol	BTCUSDT
signal_type	funding_q90_defensive
timestamp_ms	1761177600000
direction	short
score	1.0
payload	{"z21": 2.575805803581311, "funding_rate": 8.911e-05, "q90_threshold": 1.2974035460139137}
created_at	2026-06-30 21:29:38.519040+00:00

Schema:

Colonna	Tipo	Null	Commento
id	bigint	NO
symbol	text	NO
signal_type	text	NO	Modulo/tipo segnale (es. funding_q90_defensive).
timestamp_ms	bigint	NO
direction	text	YES	Direzione segnale: long/short/neutral.
score	double precision	YES	Score continuo 0-1.
payload	jsonb	YES
created_at	timestamp with time zone	NO

Constraints:

analyz_signals_pkey: PRIMARY KEY (id)

Indici:

CREATE UNIQUE INDEX analyz_signals_pkey ON public.analyz_signals USING btree (id)
CREATE INDEX idx_analyz_signals_sym_ts ON public.analyz_signals USING btree (symbol, timestamp_ms)
CREATE INDEX idx_analyz_signals_type ON public.analyz_signals USING btree (signal_type, timestamp_ms)

decisions — ~0 righe · 32.0 KB · Decisioni di trading (output AGENT AI rule-based). action: buy/sell/hold/close.

WRITTEN BY AGENT AI

READ BY SERVER QUALITY, EMERGENCY

DATA FLOW in: Regole su analyz_signals + filtri → out: Esecuzione paper, audit qualita'

Output del decisore rule-based.

Sample row (SELECT * LIMIT 1):

(tabella vuota)

Schema:

Colonna	Tipo	Null	Commento
id	bigint	NO
symbol	text	NO
timestamp_ms	bigint	NO
action	text	NO
confidence	double precision	YES	Confidenza della decisione 0-1.
reason	text	YES
signal_id	bigint	YES	FK ad analyz_signals che ha originato la decisione.
payload	jsonb	YES
created_at	timestamp with time zone	NO

Constraints:

decisions_pkey: PRIMARY KEY (id)
decisions_signal_id_fkey: FOREIGN KEY (signal_id) REFERENCES analyz_signals(id) ON DELETE SET NULL

Indici:

CREATE UNIQUE INDEX decisions_pkey ON public.decisions USING btree (id)
CREATE INDEX idx_decisions_action ON public.decisions USING btree (action, timestamp_ms)
CREATE INDEX idx_decisions_sym_ts ON public.decisions USING btree (symbol, timestamp_ms)

paper_positions — ~0 righe · 40.0 KB · Posizioni del paper-trading engine. exit_reason ESPLICITO per evitare il mislabel "manual_sell" visto in v4/v5.

WRITTEN BY AGENT AI

READ BY SERVER QUALITY, EMERGENCY

DATA FLOW in: Apertura/chiusura da decisions → out: Analisi perdite (QUALITY), liquidazione (EMERGENCY)

exit_reason esplicito (no mislabel manual_sell).

Sample row (SELECT * LIMIT 1):

(tabella vuota)

Schema:

Colonna	Tipo	Null	Commento
id	bigint	NO
symbol	text	NO
side	text	NO
status	text	NO	open / closed.
entry_time_ms	bigint	NO
entry_price	double precision	NO
size	double precision	NO
exit_time_ms	bigint	YES
exit_price	double precision	YES
exit_reason	text	YES	Motivo di uscita esplicito (NO mislabel manual_sell).
pnl	double precision	YES
pnl_pct	double precision	YES	PnL percentuale della posizione.
metadata	jsonb	YES
created_at	timestamp with time zone	NO

Constraints:

paper_positions_pkey: PRIMARY KEY (id)

Indici:

CREATE INDEX idx_paper_positions_entry_ts ON public.paper_positions USING btree (entry_time_ms)
CREATE INDEX idx_paper_positions_status ON public.paper_positions USING btree (status)
CREATE INDEX idx_paper_positions_sym ON public.paper_positions USING btree (symbol, entry_time_ms)
CREATE UNIQUE INDEX paper_positions_pkey ON public.paper_positions USING btree (id)

heartbeats — ~0 righe · 24.0 KB · Health-check componenti (heartbeat 5min usato anche da EMERGENCY trigger).

WRITTEN BY TUTTI i servizi v6

READ BY SERVER QUALITY, EMERGENCY

DATA FLOW in: Ping periodico di ogni componente → out: Health check 5min, trigger heartbeat EMERGENCY

Liveness dei componenti.

Sample row (SELECT * LIMIT 1):

(tabella vuota)

Schema:

Colonna	Tipo	Null
id	bigint	NO
component	text	NO
timestamp_ms	bigint	NO
status	text	NO
latency_ms	double precision	YES
metadata	jsonb	YES

Constraints:

heartbeats_pkey: PRIMARY KEY (id)

Indici:

CREATE UNIQUE INDEX heartbeats_pkey ON public.heartbeats USING btree (id)
CREATE INDEX idx_heartbeats_comp_ts ON public.heartbeats USING btree (component, timestamp_ms)

quality_reports — ~0 righe · 32.0 KB · Report di SERVER QUALITY (auditor investigativo, health 5min, analisi perdite per-trade).

WRITTEN BY SERVER QUALITY

READ BY EMERGENCY (critical), operatore

DATA FLOW in: Audit su trade/decisioni/heartbeat → out: Trigger quality_critical di EMERGENCY

Report investigativi, nessuna notifica.

Sample row (SELECT * LIMIT 1):

(tabella vuota)

Schema:

Colonna	Tipo	Null
id	bigint	NO
report_type	text	NO
scope	text	YES
timestamp_ms	bigint	NO
status	text	YES
details	jsonb	YES
created_at	timestamp with time zone	NO

Constraints:

quality_reports_pkey: PRIMARY KEY (id)

Indici:

CREATE INDEX idx_quality_reports_ts ON public.quality_reports USING btree (timestamp_ms)
CREATE INDEX idx_quality_reports_type ON public.quality_reports USING btree (report_type, timestamp_ms)
CREATE UNIQUE INDEX quality_reports_pkey ON public.quality_reports USING btree (id)

emergency_actions — ~0 righe · 24.0 KB · Azioni EMERGENCY / kill-switch (8 trigger, market sell, restart manuale).

WRITTEN BY EMERGENCY

READ BY SERVER QUALITY, operatore

DATA FLOW in: Scatto di uno degli 8 trigger → out: Market sell + halt; audit post-mortem

Kill-switch, restart manuale.

Sample row (SELECT * LIMIT 1):

(tabella vuota)

Schema:

Colonna	Tipo	Null	Commento
id	bigint	NO
action_type	text	NO
timestamp_ms	bigint	NO
reason	text	YES
triggered_by	text	YES	Trigger che ha causato l'azione (es. drawdown_20, flash_crash_btc).
details	jsonb	YES
created_at	timestamp with time zone	NO

Constraints:

emergency_actions_pkey: PRIMARY KEY (id)

Indici:

CREATE UNIQUE INDEX emergency_actions_pkey ON public.emergency_actions USING btree (id)
CREATE INDEX idx_emergency_actions_ts ON public.emergency_actions USING btree (timestamp_ms)

schema_info — ~1 righe · 32.0 KB · Versioning/tracking delle migrazioni schema.

WRITTEN BY Migrazioni / DDL

READ BY Operatore / dashboard

DATA FLOW in: Script di migrazione (scripts/) → out: Versioning schema

Tracking versioni schema.

Sample row (SELECT * LIMIT 1):

version	fase-1-schema
description	Schema iniziale HYDRA v6: candele, driver, metadata, tabelle operative
applied_at	2026-06-25 20:23:05.895565+00:00

Schema:

Colonna	Tipo	Null
version	text	NO
description	text	YES
applied_at	timestamp with time zone	NO

Constraints:

schema_info_pkey: PRIMARY KEY (version)

Indici:

CREATE UNIQUE INDEX schema_info_pkey ON public.schema_info USING btree (version)

features_1h — ~2,964,775 righe · 1.5 GB · HYDRA v6 SERVER STAT: ~30 indicatori tecnici per (symbol, open_time) sul timeframe 1h. NULL dove storia/driver insufficienti.

Sample row (SELECT * LIMIT 1):

symbol	OPUSDT
open_time	1654167600000
rsi_14	50.67380520174665
ema_9	1.2128059482601254
ema_21	1.2414795625237112
ema_50	NULL
ema_200	NULL
ret_1	0.03542673107890493
ret_4	0.1260945709281962
ret_24	-0.023538344722854876
ret_168	NULL
ret_720	NULL
atr_14	0.13132024926243094
realized_vol_24	0.05154636578077439
realized_vol_168	NULL
volume_ratio	0.732906453671831
volume_zscore	-0.5632378003569534
momentum_30d	NULL
dist_from_ema200	NULL
bb_upper	1.3167493649511033
bb_lower	1.0921506350488968
bb_position	0.8630919909275891
vol_percentile_200	NULL
vwap_24	1.219085772821969
beta_btc	NULL
corr_btc_30	NULL
rel_strength_btc	NULL
funding_rate	9.202e-05
funding_z21	NULL
funding_slope	NULL
oi_change	NULL

Schema:

Colonna	Tipo	Null
symbol	character varying	NO
open_time	bigint	NO
rsi_14	double precision	YES
ema_9	double precision	YES
ema_21	double precision	YES
ema_50	double precision	YES
ema_200	double precision	YES
ret_1	double precision	YES
ret_4	double precision	YES
ret_24	double precision	YES
ret_168	double precision	YES
ret_720	double precision	YES
atr_14	double precision	YES
realized_vol_24	double precision	YES
realized_vol_168	double precision	YES
volume_ratio	double precision	YES
volume_zscore	double precision	YES
momentum_30d	double precision	YES
dist_from_ema200	double precision	YES
bb_upper	double precision	YES
bb_lower	double precision	YES
bb_position	double precision	YES
vol_percentile_200	double precision	YES
vwap_24	double precision	YES
beta_btc	double precision	YES
corr_btc_30	double precision	YES
rel_strength_btc	double precision	YES
funding_rate	double precision	YES
funding_z21	double precision	YES
funding_slope	double precision	YES
oi_change	double precision	YES

Constraints:

features_1h_pkey: PRIMARY KEY (symbol, open_time)

Indici:

CREATE UNIQUE INDEX features_1h_pkey ON public.features_1h USING btree (symbol, open_time)
CREATE INDEX idx_features_1h_ot ON public.features_1h USING btree (open_time)
CREATE INDEX idx_features_1h_sym_ot ON public.features_1h USING btree (symbol, open_time DESC)

features_4h — ~568,527 righe · 302.6 MB · HYDRA v6 SERVER STAT: ~30 indicatori tecnici per (symbol, open_time) sul timeframe 4h. NULL dove storia/driver insufficienti.

Sample row (SELECT * LIMIT 1):

symbol	JASMYUSDT
open_time	1761148800000
rsi_14	NULL
ema_9	NULL
ema_21	NULL
ema_50	NULL
ema_200	NULL
ret_1	NULL
ret_4	NULL
ret_24	NULL
ret_168	NULL
ret_720	NULL
atr_14	NULL
realized_vol_24	NULL
realized_vol_168	NULL
volume_ratio	NULL
volume_zscore	NULL
momentum_30d	NULL
dist_from_ema200	NULL
bb_upper	NULL
bb_lower	NULL
bb_position	NULL
vol_percentile_200	NULL
vwap_24	NULL
beta_btc	NULL
corr_btc_30	NULL
rel_strength_btc	NULL
funding_rate	-0.00023426
funding_z21	-1.4121673485960067
funding_slope	1.8587012987012995e-07
oi_change	NULL

Schema:

Colonna	Tipo	Null
symbol	character varying	NO
open_time	bigint	NO
rsi_14	double precision	YES
ema_9	double precision	YES
ema_21	double precision	YES
ema_50	double precision	YES
ema_200	double precision	YES
ret_1	double precision	YES
ret_4	double precision	YES
ret_24	double precision	YES
ret_168	double precision	YES
ret_720	double precision	YES
atr_14	double precision	YES
realized_vol_24	double precision	YES
realized_vol_168	double precision	YES
volume_ratio	double precision	YES
volume_zscore	double precision	YES
momentum_30d	double precision	YES
dist_from_ema200	double precision	YES
bb_upper	double precision	YES
bb_lower	double precision	YES
bb_position	double precision	YES
vol_percentile_200	double precision	YES
vwap_24	double precision	YES
beta_btc	double precision	YES
corr_btc_30	double precision	YES
rel_strength_btc	double precision	YES
funding_rate	double precision	YES
funding_z21	double precision	YES
funding_slope	double precision	YES
oi_change	double precision	YES

Constraints:

features_4h_pkey: PRIMARY KEY (symbol, open_time)

Indici:

CREATE UNIQUE INDEX features_4h_pkey ON public.features_4h USING btree (symbol, open_time)
CREATE INDEX idx_features_4h_ot ON public.features_4h USING btree (open_time)
CREATE INDEX idx_features_4h_sym_ot ON public.features_4h USING btree (symbol, open_time DESC)

features_1d — ~127,778 righe · 46.9 MB · HYDRA v6 SERVER STAT: ~30 indicatori tecnici per (symbol, open_time) sul timeframe 1d. NULL dove storia/driver insufficienti.

Sample row (SELECT * LIMIT 1):

symbol	LUMIAUSDT
open_time	1761177600000
rsi_14	NULL
ema_9	NULL
ema_21	NULL
ema_50	NULL
ema_200	NULL
ret_1	NULL
ret_4	NULL
ret_24	NULL
ret_168	NULL
ret_720	NULL
atr_14	NULL
realized_vol_24	NULL
realized_vol_168	NULL
volume_ratio	NULL
volume_zscore	NULL
momentum_30d	NULL
dist_from_ema200	NULL
bb_upper	NULL
bb_lower	NULL
bb_position	NULL
vol_percentile_200	NULL
vwap_24	NULL
beta_btc	NULL
corr_btc_30	NULL
rel_strength_btc	NULL
funding_rate	0.00054555
funding_z21	3.453592114913977
funding_slope	8.795155844155844e-06
oi_change	NULL

Schema:

Colonna	Tipo	Null
symbol	character varying	NO
open_time	bigint	NO
rsi_14	double precision	YES
ema_9	double precision	YES
ema_21	double precision	YES
ema_50	double precision	YES
ema_200	double precision	YES
ret_1	double precision	YES
ret_4	double precision	YES
ret_24	double precision	YES
ret_168	double precision	YES
ret_720	double precision	YES
atr_14	double precision	YES
realized_vol_24	double precision	YES
realized_vol_168	double precision	YES
volume_ratio	double precision	YES
volume_zscore	double precision	YES
momentum_30d	double precision	YES
dist_from_ema200	double precision	YES
bb_upper	double precision	YES
bb_lower	double precision	YES
bb_position	double precision	YES
vol_percentile_200	double precision	YES
vwap_24	double precision	YES
beta_btc	double precision	YES
corr_btc_30	double precision	YES
rel_strength_btc	double precision	YES
funding_rate	double precision	YES
funding_z21	double precision	YES
funding_slope	double precision	YES
oi_change	double precision	YES

Constraints:

features_1d_pkey: PRIMARY KEY (symbol, open_time)

Indici:

CREATE UNIQUE INDEX features_1d_pkey ON public.features_1d USING btree (symbol, open_time)
CREATE INDEX idx_features_1d_ot ON public.features_1d USING btree (open_time)
CREATE INDEX idx_features_1d_sym_ot ON public.features_1d USING btree (symbol, open_time DESC)

legacy_trades — ~5,403 righe · 3.8 MB · Simulazioni storiche v2-v5: trades chiusi importati dai vecchi DB SQLite.

Sample row (SELECT * LIMIT 1):

id	1
source_version	v2
source_engine	ai
symbol	5HHANI_SOLANA
side	long
entry_time	2026-03-31 06:41:06+00:00
entry_price	0.01538
exit_time	2026-03-31 07:45:40+00:00
exit_price	0.01547
quantity	NULL
pnl_eur	0.0213
pnl_pct	0.5851755526657954
exit_reason	ai_signal
source_db	historical_trades.db
metadata	{"chain": "solana", "layer": "l4", "cost_eur": 25.0, "holding_hours": 1.0761100822222223, "signal_source": "momentum", "orig_source_db": "v2_hydra_ai", "symbol_…
imported_at	2026-06-29 20:32:00.500002+00:00
dedup_key	historical_trades.db\|v2\|ai\|5HHANI_SOLANA\|2026-03-31 06:41:06\|2026-03-31 07:45:40\|0.0213

Schema:

Colonna	Tipo	Null
id	bigint	NO
source_version	character varying	YES
source_engine	character varying	YES
symbol	character varying	YES
side	character varying	YES
entry_time	timestamp with time zone	YES
entry_price	double precision	YES
exit_time	timestamp with time zone	YES
exit_price	double precision	YES
quantity	double precision	YES
pnl_eur	double precision	YES
pnl_pct	double precision	YES
exit_reason	character varying	YES
source_db	character varying	YES
metadata	jsonb	YES
imported_at	timestamp with time zone	YES
dedup_key	text	YES

Constraints:

legacy_trades_dedup_key_key: UNIQUE (dedup_key)
legacy_trades_pkey: PRIMARY KEY (id)

Indici:

CREATE INDEX idx_legacy_trades_entry ON public.legacy_trades USING btree (entry_time)
CREATE INDEX idx_legacy_trades_symbol ON public.legacy_trades USING btree (symbol)
CREATE INDEX idx_legacy_trades_ver_eng ON public.legacy_trades USING btree (source_version, source_engine)
CREATE UNIQUE INDEX legacy_trades_dedup_key_key ON public.legacy_trades USING btree (dedup_key)
CREATE UNIQUE INDEX legacy_trades_pkey ON public.legacy_trades USING btree (id)

legacy_equity_log — ~343,742 righe · 137.0 MB · Simulazioni storiche v2-v5: curve di equity importate dai vecchi DB SQLite.

Sample row (SELECT * LIMIT 1):

id	1
source_version	v2
source_engine	ai
timestamp	2026-04-06 09:28:32+00:00
equity_eur	200.0
source_db	historical_trades.db
metadata	{"orig_source_db": "v2_hydra_ai"}
dedup_key	historical_trades.db\|v2\|ai\|2026-04-06 09:28:32\|200.0

Schema:

Colonna	Tipo	Null
id	bigint	NO
source_version	character varying	YES
source_engine	character varying	YES
timestamp	timestamp with time zone	NO
equity_eur	double precision	YES
source_db	character varying	YES
metadata	jsonb	YES
dedup_key	text	YES

Constraints:

legacy_equity_log_dedup_key_key: UNIQUE (dedup_key)
legacy_equity_log_pkey: PRIMARY KEY (id)

Indici:

CREATE INDEX idx_legacy_equity_ts ON public.legacy_equity_log USING btree ("timestamp")
CREATE INDEX idx_legacy_equity_ver_eng ON public.legacy_equity_log USING btree (source_version, source_engine)
CREATE INDEX idx_legacy_equity_ver_eng_ts ON public.legacy_equity_log USING btree (source_version, source_engine, "timestamp")
CREATE UNIQUE INDEX legacy_equity_log_dedup_key_key ON public.legacy_equity_log USING btree (dedup_key)
CREATE UNIQUE INDEX legacy_equity_log_pkey ON public.legacy_equity_log USING btree (id)

Tabelle dashboard (10)

dashboard_notes — ~9 righe · 32.0 KB · Dashboard: note libere per pagina (contenuto editoriale unico, da backuppare).

WRITTEN BY Dashboard web (utente)

READ BY Dashboard (/v5 e altre pagine)

DATA FLOW in: Form web → out: Rendering note

Contenuto editoriale, backuppato.

Sample row (SELECT * LIMIT 1):

id	1
page	v5
category	engine
title	ENGINE V5 — STANDARD
content	Mean-reversion, RSI<35, hard-stop -9%. FERMATO.
created_at	2026-06-28 18:10:51.552788+00:00
updated_at	2026-06-28 18:10:51.552788+00:00

Schema:

Colonna	Tipo	Null
id	bigint	NO
page	character varying	NO
category	character varying	YES
title	character varying	YES
content	text	NO
created_at	timestamp with time zone	YES
updated_at	timestamp with time zone	YES

Constraints:

dashboard_notes_pkey: PRIMARY KEY (id)

Indici:

CREATE UNIQUE INDEX dashboard_notes_pkey ON public.dashboard_notes USING btree (id)

dashboard_decisions — ~14 righe · 64.0 KB · Dashboard: decisioni di design per servizio v6. status: active/pending/applied/abandoned/in_progress/done.

WRITTEN BY Dashboard web (utente)

READ BY Dashboard (/servizi, /roadmap)

DATA FLOW in: Form web → out: Pagine servizi e decisioni pendenti

Decisioni di design, backuppate.

Sample row (SELECT * LIMIT 1):

id	1
service	data_source
decision_title	Sorgenti esterne, nessuna persistenza propria
decision_text	Binance WS+REST, FRED, DefiLlama, Alternative.me, Coingecko. Il servizio normalizza e inoltra; la persistenza e' delegata a SERVER LOG (PostgreSQL).
rationale	Separazione netta ingest/storage; evita duplicazione dati.
status	active
created_at	2026-06-28 18:10:51.552788+00:00
updated_at	2026-06-28 18:10:51.552788+00:00

Schema:

Colonna	Tipo	Null
id	bigint	NO
service	character varying	NO
decision_title	character varying	NO
decision_text	text	NO
rationale	text	YES
status	character varying	YES
created_at	timestamp with time zone	YES
updated_at	timestamp with time zone	YES

Constraints:

dashboard_decisions_pkey: PRIMARY KEY (id)

Indici:

CREATE UNIQUE INDEX dashboard_decisions_pkey ON public.dashboard_decisions USING btree (id)
CREATE INDEX idx_dashboard_decisions_service ON public.dashboard_decisions USING btree (service)
CREATE INDEX idx_dashboard_decisions_status ON public.dashboard_decisions USING btree (status)

dashboard_ideas — ~10 righe · 48.0 KB · Dashboard: backlog idee/task. status: pending/in_progress/done/abandoned. priority 1(alta)-5(bassa).

WRITTEN BY Dashboard web (utente)

READ BY Dashboard (/servizi, /roadmap)

DATA FLOW in: Form web → out: Backlog e task per servizio

Idee/task, backuppate.

Sample row (SELECT * LIMIT 1):

id	2
title	Job retention 180gg
description	Definire e schedulare il job di retention append-only a 180 giorni.
category	server_log
priority	3
status	pending
created_at	2026-06-28 18:10:51.552788+00:00
updated_at	2026-06-28 18:10:51.552788+00:00

Schema:

Colonna	Tipo	Null
id	bigint	NO
title	character varying	NO
description	text	YES
category	character varying	YES
priority	integer	YES
status	character varying	YES
created_at	timestamp with time zone	YES
updated_at	timestamp with time zone	YES

Constraints:

dashboard_ideas_pkey: PRIMARY KEY (id)

Indici:

CREATE UNIQUE INDEX dashboard_ideas_pkey ON public.dashboard_ideas USING btree (id)
CREATE INDEX idx_dashboard_ideas_status ON public.dashboard_ideas USING btree (status)

dashboard_roadmap — ~12 righe · 32.0 KB · Dashboard: stato fasi 0-10 del progetto v6 (status: completed/in_progress/pending).

WRITTEN BY Dashboard web (utente)

READ BY Dashboard (/home, /roadmap)

DATA FLOW in: Form web + seed iniziale → out: Timeline fasi, % completamento

Stato fasi 0-10, backuppato.

Sample row (SELECT * LIMIT 1):

phase_num	0.0
phase_name	Pulizia ambiente + PostgreSQL
status	completed
estimated_days	1g
started_at	2026-06-25 00:00:00+00:00
completed_at	2026-06-25 00:00:00+00:00
git_tag	NULL
description	Setup ambiente v6 e installazione PostgreSQL.

Schema:

Colonna	Tipo	Null
phase_num	numeric	NO
phase_name	character varying	NO
status	character varying	NO
estimated_days	character varying	YES
started_at	timestamp with time zone	YES
completed_at	timestamp with time zone	YES
git_tag	character varying	YES
description	text	YES

Constraints:

dashboard_roadmap_pkey: PRIMARY KEY (phase_num)

Indici:

CREATE UNIQUE INDEX dashboard_roadmap_pkey ON public.dashboard_roadmap USING btree (phase_num)

dashboard_backups_log — ~51 righe · 24.0 KB · Dashboard: registro dei backup eseguiti (auto/manuale).

WRITTEN BY Backup (auto/manuale)

READ BY Dashboard (/backup)

DATA FLOW in: dashboard_backup.sh / API backup → out: Elenco backup disponibili

Registro dei backup.

Sample row (SELECT * LIMIT 1):

id	1
backup_file	dashboard_backup_20260628_185542.sql
backup_type	auto
size_bytes	20136
created_at	2026-06-28 18:55:42.383464+00:00

Schema:

Colonna	Tipo	Null
id	bigint	NO
backup_file	character varying	NO
backup_type	character varying	YES
size_bytes	bigint	YES
created_at	timestamp with time zone	YES

Constraints:

dashboard_backups_log_pkey: PRIMARY KEY (id)

Indici:

CREATE UNIQUE INDEX dashboard_backups_log_pkey ON public.dashboard_backups_log USING btree (id)

dashboard_service_logic — ~57 righe · 80.0 KB · Dashboard: documentazione LOGICA per servizio v6 (section: INPUT/LOGIC/OUTPUT/PSEUDOCODE/KEY PARAMETERS/DEPENDENCIES/RESOURCES/MODULES).

WRITTEN BY Seed (Task 1)

READ BY Dashboard (/servizi)

DATA FLOW in: scripts/05_service_logic_seed.py → out: Sezione LOGICA per servizio

Doc tecnica per servizio.

Sample row (SELECT * LIMIT 1):

id	1
service	data_source
section	INPUT
content	Binance WebSocket (kline/trade streams) + REST (klines, funding rate, open interest, long/short ratio). FRED (DXY, tassi). DefiLlama (stablecoin supply, TVL). A…
ordering	1
created_at	2026-06-28 19:16:12.692604+00:00
updated_at	2026-06-28 19:16:12.692604+00:00

Schema:

Colonna	Tipo	Null
id	bigint	NO
service	character varying	NO
section	character varying	NO
content	text	NO
ordering	integer	YES
created_at	timestamp with time zone	YES
updated_at	timestamp with time zone	YES

Constraints:

dashboard_service_logic_pkey: PRIMARY KEY (id)

Indici:

CREATE UNIQUE INDEX dashboard_service_logic_pkey ON public.dashboard_service_logic USING btree (id)
CREATE INDEX idx_service_logic_svc ON public.dashboard_service_logic USING btree (service, ordering)

dashboard_table_metadata — ~24 righe · 32.0 KB · Dashboard: per ogni tabella hydra_v6/dashboard chi la scrive, chi la legge e il data flow (in/out).

WRITTEN BY Seed (Task 2)

READ BY Dashboard (/sistema)

DATA FLOW in: scripts/06_table_metadata_seed.py → out: Data flow per tabella su /sistema

Questa tabella.

Sample row (SELECT * LIMIT 1):

table_name	candles_1m
written_by	DATA SOURCE (via SERVER LOG)
read_by	LIVE SCANNER, SERVER STAT, SERVER ANALYZ, SERVER QUALITY
data_flow_in	Binance WS (kline_1m) -> normalizzazione -> SERVER LOG
data_flow_out	Aggregata in 15m/1h/4h/1d; alimenta detector e indicatori
notes	OHLCV base 1 minuto, append-only.
updated_at	2026-06-28 19:18:41.125950+00:00

Schema:

Colonna	Tipo	Null
table_name	character varying	NO
written_by	character varying	YES
read_by	character varying	YES
data_flow_in	text	YES
data_flow_out	text	YES
notes	text	YES
updated_at	timestamp with time zone	YES

Constraints:

dashboard_table_metadata_pkey: PRIMARY KEY (table_name)

Indici:

CREATE UNIQUE INDEX dashboard_table_metadata_pkey ON public.dashboard_table_metadata USING btree (table_name)

dashboard_events — ~8 righe · 64.0 KB · Dashboard: timeline eventi del progetto (commit/fase/decisione/manuale).

Sample row (SELECT * LIMIT 1):

id	1
event_date	2026-06-25
event_type	fase
title	Fase 0 completata — Pulizia ambiente + PostgreSQL
description	Setup ambiente v6 e installazione PostgreSQL.
related_service	NULL
related_phase	0
metadata	NULL
created_at	2026-06-28 19:21:34.249287+00:00

Schema:

Colonna	Tipo	Null
id	bigint	NO
event_date	date	NO
event_type	character varying	NO
title	character varying	NO
description	text	YES
related_service	character varying	YES
related_phase	character varying	YES
metadata	jsonb	YES
created_at	timestamp with time zone	YES

Constraints:

dashboard_events_pkey: PRIMARY KEY (id)

Indici:

CREATE UNIQUE INDEX dashboard_events_pkey ON public.dashboard_events USING btree (id)
CREATE INDEX idx_events_date ON public.dashboard_events USING btree (event_date DESC)
CREATE INDEX idx_events_type ON public.dashboard_events USING btree (event_type)

dashboard_audit_log — ~51 righe · 168.0 KB · Dashboard: log automatico (trigger) delle modifiche alle tabelle dashboard_* editabili.

Sample row (SELECT * LIMIT 1):

id	1
table_name	dashboard_ideas
action	INSERT
record_id	15
old_data	NULL
new_data	{"id": 15, "title": "auto analisi ", "status": "pending", "category": "backlog", "priority": 3, "created_at": "2026-06-28T19:33:37.900765+00:00", "updated_at": …
changed_at	2026-06-28 19:33:37.900765+00:00

Schema:

Colonna	Tipo	Null
id	bigint	NO
table_name	character varying	NO
action	character varying	NO
record_id	text	YES
old_data	jsonb	YES
new_data	jsonb	YES
changed_at	timestamp with time zone	YES

Constraints:

dashboard_audit_log_pkey: PRIMARY KEY (id)

Indici:

CREATE UNIQUE INDEX dashboard_audit_log_pkey ON public.dashboard_audit_log USING btree (id)
CREATE INDEX idx_audit_action ON public.dashboard_audit_log USING btree (action)
CREATE INDEX idx_audit_tbl ON public.dashboard_audit_log USING btree (table_name)
CREATE INDEX idx_audit_ts ON public.dashboard_audit_log USING btree (changed_at DESC)

dashboard_findings — ~43 righe · 104.0 KB · Dashboard: knowledge base ricerca, strategie testate, lezioni v2-v5.

Sample row (SELECT * LIMIT 1):

id	1
finding_number	1
finding_type	finding
title	Walk-forward #1 — RSI mean reversion (soglie 30/70, 25/75, 20/80)
methodology	Walk-forward 12-fold su 180gg, 10 asset top-cap. Trigger tecnico puro, return +7d misurato OOS.
result	Nessun edge OOS robusto: performance crolla fuori dal training window.
conclusion	Nessun edge tecnico puro sopravvive walk-forward 12-fold su 180gg.
status	refuted
date_found	2026-05-15
related_phase	research-2026
metadata	{"strategie": ["RSI mean reversion (soglie 30/70, 25/75, 20/80)", "MACD crossover (12-26-9)", "EMA crossover (9/21, 21/50, 50/200)", "Triple EMA cross", "Bollin…
created_at	2026-06-29 20:21:56.578872+00:00

Schema:

Colonna	Tipo	Null
id	bigint	NO
finding_number	integer	YES
finding_type	character varying	NO
title	character varying	NO
methodology	text	YES
result	text	YES
conclusion	text	YES
status	character varying	YES
date_found	date	YES
related_phase	character varying	YES
metadata	jsonb	YES
created_at	timestamp with time zone	YES

Constraints:

dashboard_findings_pkey: PRIMARY KEY (id)

Indici:

CREATE UNIQUE INDEX dashboard_findings_pkey ON public.dashboard_findings USING btree (id)
CREATE INDEX idx_findings_status ON public.dashboard_findings USING btree (status)
CREATE INDEX idx_findings_type ON public.dashboard_findings USING btree (finding_type)

Servizi systemd

Unit	Stato	Avvio	Dal
caddy.service	failed	enabled	Wed 2026-08-12 07:02:47 UTC
hydra-backup.service	inactive	static
hydra-candle-aggregator.service	active	enabled	Thu 2026-08-27 14:59:29 UTC
hydra-dashboard.service	active	enabled	Thu 2026-08-27 14:59:29 UTC
hydra-fingerprint-eod.service	inactive	static
hydra-fingerprint.service	active	enabled	Thu 2026-08-27 14:59:29 UTC
hydra-free.service	inactive	enabled	Sat 2026-04-18 12:21:40 UTC
hydra-lab-report.service	inactive	static
hydra-lab.service	active	enabled	Thu 2026-08-27 14:59:30 UTC
hydra-macro-daily.service	inactive	static
hydra-slot-game.service	active	enabled	Thu 2026-08-27 14:59:29 UTC
hydra-v6-bridge.service	activating	static
hydra-v6-dashboard.service	active	enabled	Thu 2026-08-27 14:59:29 UTC
hydra-v6-features.service	activating	static
hydra-ws-collector.service	active	enabled	Thu 2026-08-27 14:59:38 UTC
nginx.service	active	enabled	Thu 2026-08-27 06:07:39 UTC
postgresql.service	active	enabled	Thu 2026-06-25 19:57:16 UTC
postgresql@16-main.service	active	enabled-runtime	Thu 2026-08-27 06:07:43 UTC

Albero /home/hydra/hydra_v6

📁 .claude	12K
📁 .git	2.7M
📄 .gitignore	4.0K
📄 README.md	4.0K
📁 backups	23M
📁 config	4.0K
📁 docs	4.0K
📁 logs	96M
📁 scripts	244K
📁 src	800K
📁 tests	4.0K
📁 venv	569M

Git

Branch: lab-tappa1

Tag: fase-3-funding-q90 fase-2-stat fase-1.5-dashboard-storia-sim fase-1.5-dashboard-finding fase-1.5-dashboard-arricchimento fase-1.5-dashboard-fix1 fase-1.5-dashboard-complete fase-1-migration-v2 fase-1-migration fase-1-schema

Ultimi 20 commit

9a8268a LAB: family fuori dal fingerprint + migrazione dei dati esistenti
3ac6456 LAB: watchlist per i survivor young (fiducia bassa)
b28cfa7 LAB fix: due guasti che tenevano fermo il motore da 14 giorni
0a3a37d LAB: ridotto peso famiglia volume (sterile per dati scarsi)
4b4760c LAB fix: notifiche Telegram in HTML (evita 400 su regole con _ e >=)
f84049e LAB Tappa 5: pagina web /lab su docu.spocci.ch
43790fc LAB Tappa 4: servizio 24/7 systemd + caching dati tra ondate
2b8a56b LAB Tappa 3: notifiche Telegram (report giornaliero + avviso scoperta)
92105bc LAB Tappa 2: forward tracking (Fase 3) delle survivors
4a9ad92 LAB Tappa 1: schema DB + motore ricerca + rigore IS/OOS (fase 1-2)
52a3cea Slot: scala leve x100-x5000 + pool 13 token reali
5c663fa Slot: prezzi reali live Binance + frazioni + leva con liquidazione realistica
20249f0 Timer orario ricalcolo features_1h (volatilita') da candele fresche
5410f50 Bridge candele SQLite (v4) -> PostgreSQL hydra_v6 + timer 5min
fc33b15 Slot: durata strategica (rischio/tempo) + leggenda simboli
2182d68 Slot: rulli modalita' A + logging giocate + pagina log pubblica
62e5c0d App crypto slot game su gioco.spocci.ch
44b97f2 Post-mortem perdite simulazione grande OOS (283 trade)
ebf92ed Simulazione grande OOS 2 anni bot 300 EUR
5eda5f8 Simulazione 1 mese bot 300 EUR con dettaglio transazioni

Log files

File	Dim.	Modificato
ai_decision_test.log	4.5 KB	2026-07-01 23:10
best_opportunities_bot.log	7.2 KB	2026-07-02 20:48
candidates_validation.log	5.0 KB	2026-07-01 19:38
candles_history.log	4.3 KB	2026-07-01 20:19
combo_search.log	5.1 KB	2026-07-01 22:01
dashboard_backup.log	5.1 KB	2026-08-28 03:00
funding_features.log	4.3 KB	2026-06-30 21:33
funding_harvest.log	7.7 KB	2026-07-01 22:57
funding_ingest.log	2.9 KB	2026-06-30 21:27
funding_q90.log	1.8 KB	2026-06-30 21:29
funding_q90_longhistory.log	4.2 KB	2026-07-01 21:17
funding_q90_net_validation.log	4.8 KB	2026-07-01 19:59
funding_q90_validation.log	2.8 KB	2026-06-30 21:29
indicator_screening.log	8.3 KB	2026-07-01 21:32
lab.log	88.3 MB	2026-08-28 05:10
legacy_import.log	4.1 KB	2026-06-29 20:32
loss_postmortem_large.log	7.1 KB	2026-07-02 20:57
migration_20260625_203104.log	2.3 KB	2026-06-25 20:36
migration_20260625_203839.log	6.1 KB	2026-06-25 21:07
migration_20260625_211535.log	1.0 KB	2026-06-25 21:16
run_1m_console.log	6.1 KB	2026-06-25 21:07
simulate_large_oos.log	0.0 B	2026-07-02 20:48
simulate_large_oos_equity.csv	20.4 KB	2026-07-02 20:48
simulate_large_oos_trades.csv	25.0 KB	2026-07-02 20:48
simulation_1month.log	0.0 B	2026-07-02 20:37
simulation_1month_trades.csv	1.6 KB	2026-07-02 20:37
sqlite_bridge.log	5.0 MB	2026-08-28 05:08
stat_compute.log	1.7 MB	2026-08-28 05:10

Dati di mercato

Candele

Timeframe	Asset	Range temporale
candles_1m	503	2025-12-10 -> 2026-08-28
candles_15m	515	2025-10-22 -> 2026-08-28
candles_1h	516	2021-01-01 -> 2026-08-28
candles_4h	452	2025-10-22 -> 2026-06-25
candles_1d	453	2021-01-01 -> 2026-07-01

Driver per-asset

Driver	Righe	Asset
funding_rate	1,491,432	354
long_short_global	5,000	10
long_short_ratio	5,000	10
open_interest	5,000	10

Driver globali

Driver	Righe
btc_dominance	200
fear_greed	200
macro_dxy	134
macro_fed_funds	199
macro_m2	6
macro_yield_10y	135
stablecoin_supply	200