Tables and columns
Tap a column to put its name in the query.
journal_trades
One row for each trade. · 69 columns
id number
account_id number
venue text
symbol text
instrument_type text
direction text
status text
source text
opened_at date
closed_at date
hold_seconds number
reviewed_at date
logged_while_open number
recall_delay_min number
tz text
entry_hour_local number
weekday_local number
session text
qty_base number
avg_entry number
avg_exit number
notional number
leverage number
quote_asset text
equity_at_open number
gross_pnl number
fees_total number
fee_asset text
fee_rebate number
funding_total number
liquidation_fee number
net_pnl number
cost_pct number
initial_stop number
stop_state text
stop_distance_pct number
initial_target number
tp_distance_pct number
rr_planned number
rr_realised number
target_filled number
risk_quote number
risk_pct_equity number
r_actual number
mae_r number
mfe_r number
efficiency number
exit_reason text
plan_id number
plan_answers_json text
checklist_passed number
management_passed number
plan_adherence text
adherence_overridden number
override_reason text
broken_rules_json text
before_text text
before_transcript text
before_words number
before_sealed_at date
during_text text
during_transcript text
during_words number
after_text text
after_transcript text
after_words number
equity_wallet number
trade_no number
before_draft text
journal_plans
Your plans. · 8 columns
id number
plan_group_id number
version number
name text
description text
rules_json text
is_active number
created_at date
journal_events
What happened inside a trade: notes, orders, moves of a stop. · 12 columns
id number
account_id number
trade_id number
kind text
at date
symbol text
price number
qty number
value number
asset text
pos_after number
avg_after number
journal_attachments
The screenshots and voice notes attached to trades: which trade, phase, when, and the transcript (the Ask tab can also look at and listen to the files). · 8 columns
id number
trade_id number
phase text
kind text
duration_ms number
transcript text
transcript_words number
created_at date
journal_accounts
The exchange accounts your trades came from (never their keys). · 6 columns
id number
venue text
label text
status text
last_sync_at date
created_at date
journal_checkins
· 12 columns
id number
day date
energy number
time_avail number
note text
not_trading number
handled number
handled_at date
checked_at date
skipped number
audio_id number
review_note text