Market Data

Market Data

Real-time and historical market data, price feeds, technical indicators, and alerts.

15 tables in this group.

market_data

RLS Policies:

• market_data_read_policy — SELECT for {authenticated}
• market_data_service_policy — ALL for {service_role}

Indexes:

• market_data_pkey

---

market_data_ticks

RLS Policies:

• rls_market_data_ticks_insert — INSERT for {service_role}
• rls_market_data_ticks_select — SELECT for {authenticated}

Indexes:

• market_data_ticks_pkey

---

market_data_ohlcv

RLS Policies:

• rls_market_data_ohlcv_insert — INSERT for {service_role}
• rls_market_data_ohlcv_select — SELECT for {authenticated}

Indexes:

• market_data_ohlcv_pkey

---

market_data_orderbook

RLS Policies:

• rls_market_data_orderbook_insert — INSERT for {service_role}
• rls_market_data_orderbook_select — SELECT for {authenticated}

Indexes:

• market_data_orderbook_pkey

---

market_data_trades

RLS Policies:

• rls_market_data_trades_insert — INSERT for {service_role}
• rls_market_data_trades_select — SELECT for {authenticated}

Indexes:

• market_data_trades_pkey

---

candlestick_data

RLS Policies:

• candlestick_data_public_select — SELECT for {public}
• candlestick_data_service_delete — DELETE for {public}
• candlestick_data_service_insert — INSERT for {public}
• candlestick_data_service_update — UPDATE for {public}

Indexes:

• candlestick_data_pkey
• candlestick_data_unique_candle
• idx_symbol_exchange_interval_time
• ix_candlestick_data_open_time
• ix_candlestick_data_symbol

---

price_data

RLS Policies:

• price_data_public_select — SELECT for {public}
• price_data_service_delete — DELETE for {public}
• price_data_service_insert — INSERT for {public}
• price_data_service_update — UPDATE for {public}

Indexes:

• ix_price_data_asset_symbol
• ix_price_data_timestamp
• price_data_pkey

---

price_alerts

RLS Policies:

• price_alerts_delete_own — DELETE for {public}
• price_alerts_insert_own — INSERT for {public}
• price_alerts_select_own — SELECT for {public}
• price_alerts_update_own — UPDATE for {public}

Indexes:

• ix_price_alerts_symbol
• ix_price_alerts_user_id
• price_alerts_pkey

---

market_trends

RLS Policies:

• market_trends_public_select — SELECT for {public}
• market_trends_service_delete — DELETE for {public}
• market_trends_service_insert — INSERT for {public}
• market_trends_service_update — UPDATE for {public}

Indexes:

• ix_market_trends_symbol
• market_trends_pkey

---

technical_indicators

RLS Policies:

• technical_indicators_public_select — SELECT for {public}
• technical_indicators_service_delete — DELETE for {public}
• technical_indicators_service_insert — INSERT for {public}
• technical_indicators_service_update — UPDATE for {public}

Indexes:

• ix_technical_indicators_symbol
• ix_technical_indicators_timestamp
• technical_indicators_pkey

---

market_correlations

RLS Policies:

• market_correlations_public_select — SELECT for {public}
• market_correlations_service_delete — DELETE for {public}
• market_correlations_service_insert — INSERT for {public}
• market_correlations_service_update — UPDATE for {public}

Indexes:

• ix_market_correlations_symbol_1
• ix_market_correlations_symbol_2
• market_correlations_pkey

---

market_sentiment_scores

RLS Policies:

• market_sentiment_scores_public_select — SELECT for {public}
• market_sentiment_scores_service_delete — DELETE for {public}
• market_sentiment_scores_service_insert — INSERT for {public}
• market_sentiment_scores_service_update — UPDATE for {public}

Indexes:

• ix_market_sentiment_scores_asset_symbol
• ix_market_sentiment_scores_symbol
• ix_market_sentiment_scores_timestamp
• market_sentiment_scores_pkey

---

alerts

RLS Policies:

• alerts_delete_own — DELETE for {public}
• alerts_insert_own — INSERT for {public}
• alerts_select_own — SELECT for {public}
• alerts_update_own — UPDATE for {public}

Indexes:

• alerts_pkey
• idx_alerts_active_queries
• idx_alerts_alert_id
• idx_alerts_asset_symbol
• idx_alerts_auto_disable
• idx_alerts_created_at
• idx_alerts_expired_cleanup
• idx_alerts_last_triggered
• idx_alerts_next_check
• idx_alerts_notification_channels
• idx_alerts_symbol_type
• idx_alerts_trigger_condition
• idx_alerts_user_severity
• idx_alerts_user_status
• idx_alerts_user_type
• ix_alerts_alert_id
• ix_alerts_asset_symbol
• ix_alerts_user_id

---

alert_history

RLS Policies:

• alert_history_delete_own — DELETE for {public}
• alert_history_insert_own — INSERT for {public}
• alert_history_select_own — SELECT for {public}
• alert_history_update_own — UPDATE for {public}

Indexes:

• alert_history_pkey
• idx_alert_history_alert_event
• idx_alert_history_alert_id
• idx_alert_history_event_type
• idx_alert_history_market_context
• idx_alert_history_metadata
• idx_alert_history_recent_triggers
• idx_alert_history_trigger_analytics
• idx_alert_history_user_id
• ix_alert_history_alert_id
• ix_alert_history_history_id
• ix_alert_history_user_id

---

alert_notifications

RLS Policies:

• alert_notifications_delete_own — DELETE for {public}
• alert_notifications_insert_own — INSERT for {public}
• alert_notifications_select_own — SELECT for {public}
• alert_notifications_update_own — UPDATE for {public}

Indexes:

• alert_notifications_pkey
• idx_alert_notifications_alert_id
• idx_alert_notifications_channel_recent
• idx_alert_notifications_delivery_time
• idx_alert_notifications_market_context
• idx_alert_notifications_retry
• idx_alert_notifications_status
• idx_alert_notifications_user_id
• ix_alert_notifications_alert_id
• ix_alert_notifications_notification_id
• ix_alert_notifications_user_id

---