core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| net_sidetext |
|---|
| underlying_pricenumeric |
|---|
| bid_ask_spreadnumeric |
|---|
| strikesjsonb |
|---|
| ivsjsonb |
|---|
| breakevensjsonb |
|---|
| uniq_exchangesjsonb |
|---|
| min_strikenumeric |
|---|
| max_strikenumeric |
|---|
| min_dteinteger |
|---|
| max_dteinteger |
|---|
| all_opening_legsboolean |
|---|
| all_otmboolean |
|---|
| diff_expirationsboolean |
|---|
| diff_strikesboolean |
|---|
| diff_typesboolean |
|---|
| codetext |
|---|
| kept_bytext |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 01a0afea-cf73-7720-9a50-5ec195306200 | ORCL | 2026-09-17 11:09 | call_ratio_spread | 2 | 1 | 240 | 96480.00 | long | ask | 150.4000 | 0.2200 | ["170","200"] | ["0.5254","0.5590"] | ["172.85","254.30"] | ["XPHO"] | 170.0000 | 200.0000 | 43 | 43 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:10:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a08187-d739-70d3-bbfa-1abd2aba3438 | ORCL | 2026-09-08 10:59 | call_ratio_spread | 2 | 1 | 615 | 795810.00 | unknown | — | 163.9200 | 0.4000 | ["155","175"] | ["0.9728","1.0218"] | [] | ["XPHO"] | 155.0000 | 175.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a06db1-f235-71b0-b3b7-b506b37b236e | ORCL | 2026-09-04 14:32 | call_ratio_spread | 2 | 1 | 100 | 59500.00 | long | ask | 157.6150 | 0.6000 | ["147","157.5"] | ["2.6980","0.6919"] | ["156.42","158.58"] | ["XCBO"] | 147.0000 | 157.5000 | 0 | 0 | false | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:59:26Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:32:51Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |