core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0d4ff-36f7-7f53-899e-7e8145598d98 | AAPL | 2026-09-24 15:58 | put_calendar | 2 | 1 | 35 | 30380.00 | long | bid | 336.0200 | 0.3700 | ["320"] | ["0.2538"] | [] | ["XMIO"] | 320.0000 | 320.0000 | 22 | 57 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:58:14Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d4df-e36f-79b1-9227-913bac7ceabf | AAPL | 2026-09-24 15:23 | put_calendar | 2 | 1 | 10 | 59420.00 | long | bid | 337.8710 | 2.8500 | ["365"] | ["0.2644"] | [] | ["XISX"] | 365.0000 | 365.0000 | 43 | 57 | false | false | true | false | |||||||||
| 01a0d4a3-382f-70f2-ae33-1e8e260e771f | AAPL | 2026-09-24 14:17 | put_calendar | 2 | 1 | 20 | 38000.00 | long | ask | 337.4500 | 1.2000 | ["345"] | ["0.2603"] | [] | ["XISX"] | 345.0000 | 345.0000 | 1 | 22 | false | false | true | false | |||||||||
| 01a0cefc-9457-7f11-91a9-c63a596f2e43 | AAPL | 2026-09-23 11:57 | put_calendar | 2 | 2 | 184 | 36800.00 | long | bid | 336.9500 | 0.0900 | ["335"] | ["0.2814"] | [] | ["MCRY","XPHO"] | 335.0000 | 335.0000 | 0 | 2 | false | true | true | false | |||||||||
| 01a0b4d5-2fb7-7132-92b4-120854c45edf | AAPL | 2026-09-18 10:04 | put_calendar | 2 | 1 | 20 | 25340.00 | long | bid | 335.1199 | 0.2500 | ["320"] | ["0.2562"] | [] | ["XCBO"] | 320.0000 | 320.0000 | 28 | 91 | false | true | true | false | |||||||||
| 01a0ab7c-7103-77c2-993c-93da26973b7b | AAPL | 2026-09-16 14:30 | put_calendar | 2 | 1 | 40 | 30400.00 | long | bid | 334.5300 | 0.4500 | ["337.5"] | ["0.3970"] | [] | ["XPHO"] | 337.5000 | 337.5000 | 0 | 2 | false | false | true | false | |||||||||
| 01a0aab5-a27b-7a63-b6a7-60f368245108 | AAPL | 2026-09-16 10:53 | put_calendar | 2 | 1 | 14 | 91560.00 | long | ask | 333.7600 | 1.5000 | ["335"] | ["0.2926"] | [] | ["XCBO"] | 335.0000 | 335.0000 | 366 | 457 | false | false | true | false | |||||||||
| 01a08bad-b9d1-7833-8c3f-e8bc9c1c67c0 | AAPL | 2026-09-10 10:16 | put_calendar | 2 | 1 | 10 | 32260.00 | long | bid | 319.2751 | 1.2500 | ["335"] | ["0.4195"] | [] | ["BATO"] | 335.0000 | 335.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a0879b-b7e8-73e1-9561-be3b6a2857a2 | AAPL | 2026-09-09 15:18 | put_calendar | 2 | 1 | 500 | 2179000.00 | long | bid | 316.0900 | 3.6000 | ["337.5"] | ["0.4354"] | [] | ["EDGO"] | 337.5000 | 337.5000 | 2 | 9 | false | false | true | false | |||||||||
| 01a08790-d2d8-7c41-a665-630fc77d5fb9 | AAPL | 2026-09-09 15:06 | put_calendar | 2 | 1 | 139 | 532370.00 | long | bid | 315.8100 | 3.3500 | ["335"] | ["0.4147"] | [] | ["XISX"] | 335.0000 | 335.0000 | 2 | 9 | false | false | true | false | |||||||||
| 01a08790-cef0-7e90-8bd4-02f9c4c88072 | AAPL | 2026-09-09 15:06 | put_calendar | 2 | 1 | 249 | 948873.00 | long | bid | 315.8350 | 3.4500 | ["335"] | ["0.4133"] | [] | ["EDGO"] | 335.0000 | 335.0000 | 2 | 9 | false | false | true | false | |||||||||
| 01a08790-cef0-7e90-8bd4-02e38b9434cc | AAPL | 2026-09-09 15:06 | put_calendar | 2 | 3 | 198 | 753791.00 | long | bid | 315.8181 | 3.6131 | ["335"] | ["0.4088"] | [] | ["AMXO","EDGO","XISX"] | 335.0000 | 335.0000 | 2 | 9 | false | false | true | false | |||||||||
| 01a08747-f680-7af0-8613-dd87627cea90 | AAPL | 2026-09-09 13:47 | put_calendar | 2 | 1 | 50 | 81150.00 | long | ask | 312.5720 | 0.4500 | ["320"] | ["0.7463"] | [] | ["XCBO"] | 320.0000 | 320.0000 | 0 | 2 | false | false | true | false | |||||||||
| 01a0872f-2308-7e83-8f38-ead56e9ad663 | AAPL | 2026-09-09 13:20 | put_calendar | 2 | 1 | 10 | 27590.00 | long | ask | 311.4000 | 1.3500 | ["325"] | ["0.9517"] | [] | ["EDGO"] | 325.0000 | 325.0000 | 0 | 2 | false | false | true | false | |||||||||
| 01a0872a-8b40-7de0-94ba-70e0f5503016 | AAPL | 2026-09-09 13:15 | put_calendar | 2 | 1 | 10 | 26540.00 | long | bid | 312.7900 | 1.5000 | ["325"] | ["0.3756"] | [] | ["BATO"] | 325.0000 | 325.0000 | 2 | 9 | false | false | true | false | |||||||||
| 01a0871e-db10-7c02-840b-13b261aaa33b | AAPL | 2026-09-09 13:02 | put_calendar | 2 | 2 | 27 | 27249.00 | long | ask | 314.6750 | 0.2000 | ["317.5"] | ["0.7888"] | [] | ["XCBO","XISX"] | 317.5000 | 317.5000 | 0 | 2 | false | false | true | false | |||||||||
| 01a086f0-2220-7f02-a513-0820db664579 | AAPL | 2026-09-09 12:11 | put_calendar | 2 | 1 | 27 | 32292.00 | long | bid | 313.4500 | 0.5000 | ["317.5"] | ["0.7471"] | [] | ["XMIO"] | 317.5000 | 317.5000 | 0 | 2 | false | false | true | false | |||||||||
| 01a086ce-32a0-7af1-a55f-abc7335e1c7b | AAPL | 2026-09-09 11:34 | put_calendar | 2 | 1 | 74 | 29452.00 | long | bid | 313.2200 | 0.1000 | ["310"] | ["0.6579"] | [] | ["XMIO"] | 310.0000 | 310.0000 | 0 | 2 | false | true | true | false | |||||||||
| 01a08661-4bb8-7a23-ac98-84812aaca125 | AAPL | 2026-09-09 09:35 | put_calendar | 2 | 1 | 200 | 190000.00 | long | bid | 315.5000 | 0.5000 | ["317.5"] | ["0.6726"] | [] | ["XMIO"] | 317.5000 | 317.5000 | 0 | 2 | false | false | true | false | |||||||||
| 01a08260-e1b8-70d3-9fe8-e8e95f2885d8 | AAPL | 2026-09-08 14:56 | put_calendar | 2 | 1 | 14 | 113330.00 | long | bid | 315.8800 | 2.2000 | ["355"] | ["0.2978"] | [] | ["SPHR"] | 355.0000 | 355.0000 | 38 | 73 | false | false | true | false | |||||||||
| 01a08260-e1b8-70d3-9fe8-e8d0a2e68b39 | AAPL | 2026-09-08 14:56 | put_calendar | 2 | 5 | 21 | 170695.00 | long | ask | 315.8800 | 4.2786 | ["355"] | ["0.3034"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 355.0000 | 355.0000 | 38 | 73 | false | false | true | ||||||||||
| 01a0825e-fd58-7cc2-b9a3-94551bfc694b | AAPL | 2026-09-08 14:54 | put_calendar | 2 | 1 | 25 | 178450.00 | long | bid | 315.8250 | 2.6000 | ["350"] | ["0.2923"] | [] | ["XCBO"] | 350.0000 | 350.0000 | 24 | 73 | false | false | true | false | |||||||||
| 01a0825d-e418-7640-94be-630d701d5a97 | AAPL | 2026-09-08 14:53 | put_calendar | 2 | 1 | 4 | 28676.00 | long | ask | 315.5800 | 1.8000 | ["350"] | ["0.2900"] | [] | ["XCBO"] | 350.0000 | 350.0000 | 24 | 73 | false | false | true | false | |||||||||
| 01a0825d-e030-76a0-a70f-a8a57df8edf1 | AAPL | 2026-09-08 14:53 | put_calendar | 2 | 4 | 6 | 43700.00 | long | ask | 315.5750 | 3.6500 | ["350"] | ["0.3147"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 350.0000 | 350.0000 | 24 | 73 | false | false | true | false | |||||||||
| 01a08247-1c10-7581-ab0f-fdc82b17a406 | AAPL | 2026-09-08 14:28 | put_calendar | 2 | 1 | 5 | 27200.00 | long | bid | 316.5900 | 1.4000 | ["340"] | ["0.2873"] | [] | ["C2OX"] | 340.0000 | 340.0000 | 17 | 101 | false | false | true | false | |||||||||
| 01a081d5-fb20-7513-9bd2-e67c0e3a5af1 | AAPL | 2026-09-08 12:24 | put_calendar | 2 | 1 | 200 | 190200.00 | long | ask | 315.7800 | 0.3000 | ["317.5"] | ["0.4404"] | [] | ["XCBO"] | 317.5000 | 317.5000 | 1 | 3 | false | false | true | false | |||||||||
| 01a06da8-880e-7cd2-8090-f8185f03c3c5 | AAPL | 2026-09-04 14:22 | put_calendar | 2 | 1 | 20 | 35720.00 | long | ask | 321.1200 | 0.5500 | ["327.5"] | ["0.2650"] | [] | ["XISX"] | 327.5000 | 327.5000 | 5 | 14 | false | false | true | false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:24:31Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:17:46Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:57:53Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:04:31Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:31:13Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:53:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:17:16Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:19:04Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:07:10Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:07:10Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:07:10Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:47:50Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:20:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:15:06Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:02:27Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:11:49Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:34:35Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:35:32Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:56:47Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:56:47Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:54:21Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:53:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:53:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:29:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:25:02Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:22:41Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |