core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg677,480 rows| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0fd77-a47f-71e2-ac19-2980f07ddf5d | CBOE | 2026-10-02 12:34 | call_vertical_spread | 2 | 1 | 16 | 105120.00 | short | bid | 272.4000 | 4.9000 | ["240","260"] | ["0.3738","0.3617"] | ["254"] | ["XISX"] | 240.0000 | 260.0000 | 77 | 77 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-02T16:34:45Z"} | 2026-10-02 | 2026-10-02 17:15 | 2026-10-02 17:15 |
| 01a0e87c-b38f-7d80-b902-08bda6e31300 | CBOE | 2026-09-28 10:47 | put_vertical_spread | 2 | 1 | 67 | 197248.00 | unknown | bid | 253.5400 | 1.8000 | ["250","260"] | ["0.3832","0.3768"] | ["240.28"] | ["XISX"] | 250.0000 | 260.0000 | 53 | 53 | false | false | |||||||||||
| 01a0e87c-a3ef-72d3-adf3-4bca05300211 | CBOE | 2026-09-28 10:47 | put_vertical_spread | 2 | 6 | 50 | 147392.00 | unknown | bid | 253.6450 | 1.8000 | ["250","260"] | ["0.3849","0.3788"] | ["240.26"] | ["BATO","C2OX","SPHR","XISX","XMIO","XPHO"] | 250.0000 | 260.0000 | 53 | 53 | false | false | |||||||||||
| 01a0d977-97e7-7f00-b36b-4d4e0ea2e26e | CBOE | 2026-09-25 12:48 | put_calendar | 2 | 2 | 86 | 298592.00 | short | bid | 254.9275 | 5.9000 | ["270"] | ["0.3250"] | [] | ["C2OX","XCBO"] | 270.0000 | 270.0000 | 7 | 35 | false | false | |||||||||||
| 01a0d977-97e7-7f00-b36b-4d25de4682bd | CBOE | 2026-09-25 12:48 | put_calendar | 2 | 3 | 189 | 655316.00 | short | bid | 254.9275 | 5.9000 | ["270"] | ["0.3226"] | [] | ["AMXO","XISX","XMIO"] | 270.0000 | 270.0000 | 7 | 35 | false | false | |||||||||||
| 01a0d977-97e7-7f00-b36b-4d1b13ca1247 | CBOE | 2026-09-25 12:48 | put_calendar | 2 | 2 | 86 | 298420.00 | short | bid | 254.9275 | 6.0000 | ["270"] | ["0.3240"] | [] | ["EMLD","SPHR"] | 270.0000 | 270.0000 | 7 | 35 | false | false | |||||||||||
| 01a0d3a8-f5c7-7c20-aa6e-923a79ce60d0 | CBOE | 2026-09-24 09:44 | put_vertical_spread | 2 | 3 | 29 | 105473.00 | short | bid | 267.5750 | 3.0000 | ["260","270"] | ["0.3604","0.3559"] | ["265.39"] | ["ARCO","EDGO","XBOX"] | 260.0000 | 270.0000 | 113 | 113 | false | false | |||||||||||
| 01a0d3a8-f1df-7eb1-8361-95e2124ea488 | CBOE | 2026-09-24 09:44 | put_vertical_spread | 2 | 4 | 37 | 132141.00 | unknown | bid | 266.8850 | 3.0000 | ["260","270"] | ["0.3500","0.3450"] | ["247.14"] | ["AMXO","ARCO","C2OX","XISX"] | 260.0000 | 270.0000 | 113 | 113 | false | false | |||||||||||
| 01a0d3a8-e627-7362-aa39-af58488a3fe4 | CBOE | 2026-09-24 09:44 | put_vertical_spread | 2 | 4 | 42 | 150158.00 | short | bid | 266.8850 | 3.0000 | ["260","270"] | ["0.3503","0.3453"] | ["265.39"] | ["ARCO","C2OX","EDGO","XISX"] | 260.0000 | 270.0000 | 113 | 113 | false | false | |||||||||||
| 01a0d3a8-e23e-71a2-a409-5a6f137bd4bc | CBOE | 2026-09-24 09:44 | put_vertical_spread | 2 | 5 | 39 | 139342.00 | short | bid | 266.8850 | 3.0000 | ["260","270"] | ["0.3502","0.3450"] | ["265.4"] | ["ARCO","EDGO","XCBO","XISX"] | 260.0000 | 270.0000 | 113 | 113 | false | false | |||||||||||
| 01a0d3a8-ab8f-72f0-97a2-a494e18dd4c6 | CBOE | 2026-09-24 09:43 | put_vertical_spread | 2 | 4 | 36 | 128590.00 | unknown | bid | 266.8850 | 3.1000 | ["260","270"] | ["0.3498","0.3453"] | ["247.14"] | ["ARCO","C2OX","XISX","XMIO"] | 260.0000 | 270.0000 | 113 | 113 | false | false | |||||||||||
| 01a0d3a8-a7a6-7150-a2d9-15c7dcc80d3d | CBOE | 2026-09-24 09:43 | put_vertical_spread | 2 | 4 | 38 | 138160.00 | short | bid | 266.8850 | 3.1000 | ["260","270"] | ["0.3554","0.3507"] | ["265.36"] | ["ARCO","EDGO","XBOX","XCBO"] | 260.0000 | 270.0000 | 113 | 113 | false | false | |||||||||||
| 01a0d3a8-a3bf-7cc0-8bfb-d60698feb494 | CBOE | 2026-09-24 09:43 | put_vertical_spread | 2 | 4 | 29 | 105746.00 | short | bid | 266.8850 | 3.1000 | ["260","270"] | ["0.3563","0.3516"] | ["265.36"] | ["C2OX","XBOX","XCBO","XISX"] | 260.0000 | 270.0000 | 113 | 113 | false | false | |||||||||||
| 01a0b59c-2167-76d0-9795-53de5a367f5c | CBOE | 2026-09-18 13:41 | other | 4 | 4 | 13 | 161728.00 | unknown | bid | 266.4900 | 12.2000 | ["250","260","300","350"] | ["3.6656","0.3386","0.3358","0.3361"] | [] | ["ARCO","MCRY","XISX","XPHO"] | 250.0000 | 350.0000 | 0 | 490 | false | false | |||||||||||
| 01a0b4cc-d6ff-76f1-93e1-3eba78bea439 | CBOE | 2026-09-18 09:55 | other | 3 | 2 | 312 | 133710.00 | unknown | bid | 266.0600 | 7.9500 | ["257.5","262.5","280"] | ["0.3525","0.3417","1.8834"] | [] | ["AMXO"] | 257.5000 | 280.0000 | 0 | 7 | false | false | |||||||||||
| 01a0aa94-91a3-7400-9b45-dcedcd92ebc9 | CBOE | 2026-09-16 10:17 | put_vertical_spread | 2 | 4 | 22 | 115662.00 | short | bid | 272.1000 | 2.1000 | ["270","290"] | ["0.3835","0.3769"] | ["279.17"] | ["ARCO","C2OX","EDGO","XBOX"] | 270.0000 | 290.0000 | 121 | 121 | false | false | |||||||||||
| 01a0aa94-7e1b-7051-bd78-073e7db98c5a | CBOE | 2026-09-16 10:17 | put_vertical_spread | 2 | 4 | 21 | 109685.00 | short | bid | 272.1000 | 2.1000 | ["270","290"] | ["0.3807","0.3741"] | ["279.17"] | ["AMXO","C2OX","EDGO","XCBO"] | 270.0000 | 290.0000 | 121 | 121 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:48:03Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:48:03Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:48:30Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:48:30Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:48:30Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:44:23Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:44:23Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:44:23Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:44:23Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:44:23Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:44:23Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:43:57Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:41:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:55:27Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:17:52Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:17:52Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |