OMIE / Table

omie.continuous_trades

Continuous intraday market continuous trades.

OMIEPer recordBy sourceUp to date
Coverage2024-06-30 – 2026-07-0224,809,602 rows
In your planPublic accessSign in to check access

Source: OMIE. Latest data: 2026-07-02. Joltio normalizes the published values without altering them and is not affiliated with or endorsed by OMIE.

Sample

Sample from 2026-09-28 · 100 rows · 2026-07-01 – 2026-07-02

datetimeDateTime('Europe/Madrid')contractStringbuy_agentLowCardinality(String)buy_unitStringbuy_zoneLowCardinality(String)sell_agentLowCardinality(String)sell_unitStringsell_zoneLowCardinality(String)priceFloat64quantityFloat64matched_atDateTime('Europe/Madrid')file_dateDateinserted_atDateTime
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01100.52026-06-30T20:51:59+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01100.62026-06-30T20:52:00+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01101.52026-06-30T20:51:59+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01102.42026-06-30T20:51:59+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0111.20.52026-06-30T17:26:39+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01120.12026-06-30T18:08:40+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01120.22026-06-30T18:08:40+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01120.22026-06-30T18:08:41+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01120.32026-06-30T18:08:40+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01120.42026-06-30T18:08:40+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01120.52026-06-30T18:08:36+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01120.52026-06-30T18:08:40+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01120.52026-06-30T19:24:26+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01120.62026-06-30T18:08:40+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01120.72026-06-30T18:08:40+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01120.72026-06-30T19:24:38+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01120.82026-06-30T18:08:40+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------011212026-06-30T18:08:40+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------011212026-06-30T19:25:05+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01121.12026-06-30T18:08:40+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01121.32026-06-30T19:24:38+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01121.82026-06-30T18:08:40+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------011222026-06-30T18:08:36+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01122.22026-06-30T18:08:40+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------011242026-06-30T18:08:36+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------011312026-06-30T20:51:26+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------011352026-06-30T20:51:26+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0113.0232026-06-30T20:51:26+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01161.52026-06-30T17:16:39+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0116.90.32026-06-30T17:16:15+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0116.93.72026-06-30T17:16:15+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0117.40.32026-06-30T17:16:15+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0117.44.72026-06-30T17:16:15+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0117.942026-06-30T17:16:15+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0118.422026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0118.432026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0118.922026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0118.932026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0119.422026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0119.432026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0119.912026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0119.942026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.12026-06-30T20:51:01+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.12026-06-30T20:51:16+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.22026-06-30T20:14:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.22026-06-30T20:51:16+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.32026-06-30T20:14:17+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.32026-06-30T20:50:41+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.32026-06-30T20:51:01+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.32026-06-30T20:51:16+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.42026-06-30T20:19:52+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.42026-06-30T20:50:17+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.42026-06-30T20:51:01+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.42026-06-30T20:51:16+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.52026-06-30T19:49:10+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.52026-06-30T20:38:32+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.52026-06-30T20:51:01+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.72026-06-30T20:51:01+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.82026-06-30T20:51:01+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01200.92026-06-30T20:19:52+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012012026-06-30T19:39:37+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012012026-06-30T20:14:13+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012012026-06-30T20:19:52+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012012026-06-30T20:50:41+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01201.12026-06-30T20:51:16+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01201.32026-06-30T20:14:22+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01201.32026-06-30T20:17:03+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01201.32026-06-30T20:50:41+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01201.32026-06-30T20:51:04+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01201.32026-06-30T20:51:16+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01201.42026-06-30T20:51:01+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01201.52026-06-30T20:19:52+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01201.52026-06-30T20:51:16+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01201.62026-06-30T20:19:52+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01201.62026-06-30T20:39:58+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01201.82026-06-30T20:14:17+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012022026-06-30T19:31:11+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012022026-06-30T19:32:28+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012022026-06-30T19:42:15+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012022026-06-30T19:46:27+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012022026-06-30T19:49:10+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012022026-06-30T20:14:17+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012022026-06-30T20:16:46+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012022026-06-30T20:50:26+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012022026-06-30T20:51:10+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01202.22026-06-30T20:39:58+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01202.42026-06-30T20:51:16+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01202.52026-06-30T19:57:45+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01202.62026-06-30T20:51:16+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------01202.72026-06-30T20:14:22+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012032026-06-30T19:46:27+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------012032026-06-30T20:05:22+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0120.422026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0120.432026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0120.922026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0120.932026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0121.422026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0121.432026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0121.922026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
2026-07-01T00:00:00+02:0020260701 00:00-20260701 00:15REPSBECT310YES-REE------0121.932026-06-30T17:15:12+02:002026-07-012026-09-28T16:35:36
SQL
SELECT
    datetime,
    contract,
    buy_agent,
    buy_unit,
    buy_zone,
    sell_agent,
    sell_unit,
    sell_zone,
    price,
    quantity,
    matched_at,
    file_date,
    inserted_at
FROM omie.continuous_trades
WHERE datetime >= '2026-07-01' AND datetime < '2026-07-02'
LIMIT 100