core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a0f822-7c07-7952-ba77-3ff3f5aeacd5 | MRNA | 2026-10-01 11:43 | call_ratio_spread | 2 | 1 | 330 | 411400.00 | long | ask | 193.2801 | 2.3500 | ["220","290"] | ["0.9711","1.0100"] | ["325.35"] | ["XISX"] | 220.0000 | 290.0000 | 50 | 50 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T15:43:42Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f7fe-cb4f-7482-b9d4-ab0a93d89fb1 | MRNA | 2026-10-01 11:04 | call_ratio_spread | 2 | 1 | 300 | 438200.00 | unknown | ask | 199.6128 | 2.3000 | ["220","290"] | ["0.9777","1.0030"] | ["263.82"] | ["XISX"] | 220.0000 | 290.0000 | 50 | 50 | false | true | false | true | |||||||||
| 01a0f7d9-edcf-7691-86dd-2314b721d736 | MRNA | 2026-10-01 10:24 | call_ratio_spread | 2 | 1 | 15 | 208730.00 | long | ask | 198.8500 | 8.0500 | ["150","270"] | ["0.7250","0.7208"] | ["150.05","509.90"] | ["XMIO"] | 150.0000 | 270.0000 | 806 | 806 | false | false | false | true | |||||||||
| 01a0f7d7-1f0f-73f2-9845-63f86fa6ff18 | MRNA | 2026-10-01 10:21 | call_ratio_spread | 2 | 1 | 15 | 209390.00 | long | ask | 198.6100 | 7.0000 | ["150","270"] | ["0.7323","0.7239"] | ["150.14","509.72"] | ["XCBO"] | 150.0000 | 270.0000 | 806 | 806 | false | false | false | true | |||||||||
| 01a0f7d4-6f8e-7440-afd4-c4da585dcefd | MRNA | 2026-10-01 10:18 | call_ratio_spread | 2 | 1 | 15 | 208770.00 | unknown | bid | 199.3700 | 8.4500 | ["150","270"] | ["0.7205","0.7176"] | ["305.51"] | ["XISX"] | 150.0000 | 270.0000 | 806 | 806 | false | false | false | true | |||||||||
| 01a0f333-1e26-74a3-9212-2fe4c5d6901c | MRNA | 2026-09-30 12:43 | call_ratio_spread | 2 | 1 | 150 | 171650.00 | long | ask | 188.6300 | 1.8500 | ["220","290"] | ["0.9808","1.0157"] | ["325.24"] | ["XCBO"] | 220.0000 | 290.0000 | 51 | 51 | false | true | false | true | |||||||||
| 01a0ee51-879f-7d11-ab49-dc5fe6c04b90 | MRNA | 2026-09-29 13:58 | call_ratio_spread | 2 | 2 | 300 | 182100.00 | unknown | bid | 197.8600 | 1.2000 | ["195","205"] | ["0.8915","0.9127"] | ["207.36"] | ["XCBO"] | 195.0000 | 205.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ed6d-f1e7-7b82-9b0e-4ec8c29c06f1 | MRNA | 2026-09-29 09:49 | call_ratio_spread | 2 | 1 | 9 | 127791.00 | long | ask | 200.5350 | 6.8500 | ["150","270"] | ["0.7291","0.7241"] | ["511.05"] | ["XISX"] | 150.0000 | 270.0000 | 808 | 808 | false | false | false | true | |||||||||
| 01a0e995-cc7f-7981-b451-5ceb2f4e0beb | MRNA | 2026-09-28 15:55 | call_ratio_spread | 2 | 1 | 15 | 205235.00 | unknown | bid | 197.1350 | 13.3500 | ["150","270"] | ["0.7205","0.7191"] | ["304.09"] | ["XISX"] | 150.0000 | 270.0000 | 809 | 809 | false | false | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:04:32Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:24:23Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:21:23Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:18:31Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T16:44:01Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T17:59:11Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T13:50:05Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T19:55:12Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |