Sistema completo

Documentazione tecnica auto-generata · cache 60s · snapshot 2026-06-28 21:09:06

Server

Host	hydra-unified	OS	Ubuntu 24.04.4 LTS
Kernel	6.8.0-90-generic	Uptime	84g 1h 36m
CPU core	4	Load (1/5/15m)	0.49 / 0.39 / 0.35
RAM	2.9 GB / 7.6 GB (38.0%)	Disco /	75G totali, 43G usati (60%), 30G liberi

PostgreSQL

PostgreSQL 16.14 (Ubuntu 16.14-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: 8776 MB · 17 tabelle hydra_v6 + 5 dashboard. Conteggi righe stimati (pg_class.reltuples, prefisso “~”); “N/A” se la query supera il timeout di 2s.

Tabelle hydra_v6 (17)

candles_1m — ~41,002,568 righe · 7.2 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	HOLOUSDT
open_time	1778666880000
open	0.0867
high	0.0868
low	0.0866
close	0.0868
volume	29824.0
quote_volume	2586.49596
trades	23

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 — ~6,493,966 righe · 1.0 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 — ~1,627,494 righe · 266.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 → out: Indicatori Tier 1-3 (SERVER STAT)

Timeframe principale per gli indicatori.

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 — ~94,934 righe · 14.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 → out: Indicatori daily, beta, regime

Timeframe derivato.

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 — ~21,000 righe · 5.5 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	BTCUSDT
timestamp_ms	1763827200000
value	5.057e-05
metadata	{"mark_price": 84241.49595652}

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 — ~0 righe · 32.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):

(tabella vuota)

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)

Tabelle dashboard (9)

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 — ~2 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 — ~2 righe · 80.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)

Servizi systemd

Unit	Stato	Avvio	Dal
caddy.service	failed	disabled	Mon 2026-05-18 20:23:05 UTC
hydra-backup.service	inactive	static
hydra-candle-aggregator.service	active	enabled	Sun 2026-06-14 20:18:31 UTC
hydra-dashboard.service	inactive	enabled	Wed 2026-06-10 06:30:45 UTC
hydra-fingerprint-eod.service	inactive	static
hydra-fingerprint.service	active	enabled	Sun 2026-06-14 20:18:31 UTC
hydra-free.service	inactive	enabled	Sat 2026-04-18 12:21:40 UTC
hydra-macro-daily.service	inactive	static
hydra-v6-dashboard.service	active	enabled	Sun 2026-06-28 19:25:35 UTC
hydra-ws-collector.service	active	enabled	Sun 2026-06-14 20:18:31 UTC
nginx.service	active	enabled	Tue 2026-06-23 06:37:17 UTC
postgresql.service	active	enabled	Thu 2026-06-25 19:57:16 UTC
postgresql@16-main.service	active	enabled-runtime	Thu 2026-06-25 19:57:20 UTC

Albero /home/hydra/hydra_v6

📁 .git	1.1M
📄 .gitignore	4.0K
📄 README.md	4.0K
📁 backups	120K
📁 config	4.0K
📁 docs	4.0K
📁 logs	28K
📁 scripts	108K
📁 src	216K
📁 tests	4.0K
📁 venv	66M

Git

Branch: main

Tag: 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

580b9dc Arricchimento: includi le 4 nuove tabelle dashboard_* nel backup
33b0194 Task 3: pagine /cronologia (timeline eventi+git) e /audit (trigger PG + diff)
d342ce7 Task 2: sample row + data flow per tabella su /sistema
6ae2436 Task 1: sezione LOGICA per gli 8 servizi (+ tabella 15 moduli ANALYZ)
7d8471e Fix /sistema timeout
ee75eac Fase 1.5: deploy (systemd unit, nginx docu.spocci.ch, backup giornaliero + cron)
6f1b76b Fase 1.5: dashboard FastAPI (backend + 6 pagine + CRUD + backup/restore)
a7cfa45 Fase 1.5: dashboard schema (5 tabelle + COMMENT 17 tabelle) + seed dati
fd00c90 Fase 1: add candles_4h
c0164fd Fase 1: data migration complete
cb7c4b0 Fase 1: schema completo DB (16 tabelle + indici)
85f60be Fase 0: initial structure

Log files

File	Dim.	Modificato
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

Dati di mercato

Candele

Timeframe	Asset	Range temporale
candles_1m	439	2025-12-10 -> 2026-06-25
candles_15m	451	2025-10-22 -> 2026-06-25
candles_1h	451	2025-10-22 -> 2026-06-25
candles_4h	452	2025-10-22 -> 2026-06-25
candles_1d	452	2025-10-23 -> 2026-06-25

Driver per-asset

Driver	Righe	Asset
funding_rate	6,000	10
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