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 | 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 |
|---|
| 01a0caa8-5567-7493-b28d-7883a522e3ba | AAOI | 2026-09-22 15:47 | put_diagonal_spread | 2 | 1 | 63 | 114975.00 | unknown | bid | 107.0200 | 2.2000 | ["110","112"] | ["0.8404","0.8617"] | [] | ["XBOX"] | 110.0000 | 112.0000 | 10 | 17 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:47:17Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c4a9-fc6f-7f52-aa98-b06171407dbd | AAOI | 2026-09-21 11:51 | risk_reversal | 3 | 4 | 34 | 219976.00 | long | bid | 109.0105 | 4.1000 | ["60","125","150"] | ["0.9615","0.9709","0.9709"] | ["58.20"] | ["ARCO","EDGO","XCBO","XISX"] | 60.0000 | 150.0000 | 269 | 269 | false | true | false | true | |||||||||
| 01a0c4a9-fc6f-7f52-aa98-b05ca5df3ecf | AAOI | 2026-09-21 11:51 | risk_reversal | 3 | 6 | 16 | 103486.00 | long | bid | 109.0105 | 4.1000 | ["60","125","150"] | ["0.9623","0.9708","0.9700"] | ["58.21"] | ["C2OX","EMLD","MCRY","XBOX","XMIO","XPHO"] | 60.0000 | 150.0000 | 269 | 269 | false | true | false | ||||||||||
| 01a0c4a9-5477-7693-a77d-e1f0d1b712bd | AAOI | 2026-09-21 11:50 | risk_reversal | 3 | 4 | 34 | 219857.00 | long | bid | 109.1150 | 4.2000 | ["60","125","150"] | ["0.9620","0.9686","0.9690"] | ["58.20"] | ["ARCO","EDGO","XCBO","XISX"] | 60.0000 | 150.0000 | 269 | 269 | false | true | false | true | |||||||||
| 01a0b55e-5130-76b2-ae75-63cf68fc182c | AAOI | 2026-09-18 12:34 | other | 4 | 2 | 20 | 121680.00 | unknown | bid | 100.4600 | 7.1000 | ["108","110","120"] | ["0.8471","1.9845","3.9939"] | [] | ["SPHR","XCBO"] | 108.0000 | 120.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a0b541-91cf-7d32-b42d-97511b133e53 | AAOI | 2026-09-18 12:02 | call_vertical_spread | 2 | 1 | 600 | 1200000.00 | short | bid | 101.0500 | 3.2000 | ["90","92"] | ["5.0901","4.4071"] | ["91.98"] | ["XMIO"] | 90.0000 | 92.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a0b509-d447-7aa3-a675-df0a8ddeaafd | AAOI | 2026-09-18 11:01 | call_diagonal_spread | 2 | 2 | 50 | 410250.00 | short | bid | 100.3400 | 4.0000 | ["100","200"] | ["0.9611","0.9730"] | [] | ["MCRY"] | 100.0000 | 200.0000 | 490 | 854 | false | false | true | true | |||||||||
| 01a0a038-aec8-7692-a5b7-f375d10bf51c | AAOI | 2026-09-14 10:01 | call_diagonal_spread | 2 | 1 | 51 | 529431.00 | short | bid | 98.0300 | 5.8000 | ["100","105"] | ["0.9751","1.0061"] | [] | ["XISX"] | 100.0000 | 105.0000 | 641 | 858 | false | true | true | true | |||||||||
| 01a08c8d-4079-7540-8672-d17e0b2de92b | AAOI | 2026-09-10 14:20 | put_diagonal_spread | 2 | 5 | 49 | 115060.00 | short | bid | 103.8900 | 3.2857 | ["101","115"] | ["0.9039","1.5888"] | [] | ["EMLD","SPHR","XBOX","XPHO"] | 101.0000 | 115.0000 | 1 | 50 | false | false | true | true | |||||||||
| 01a081e6-9909-74a2-b9da-36e4ca777730 | AAOI | 2026-09-08 12:42 | put_calendar | 2 | 1 | 20 | 129860.00 | short | bid | 114.2800 | 3.8000 | ["145"] | ["1.0278"] | [] | ["XPHO"] | 145.0000 | 145.0000 | 10 | 24 | false | false | true | false | |||||||||
| 01a08170-b170-7b20-90e3-cbd38af400d3 | AAOI | 2026-09-08 10:33 | put_diagonal_spread | 2 | 1 | 32 | 113120.00 | short | bid | 115.6500 | 4.3000 | ["115","135"] | ["1.0390","0.9690"] | [] | ["SPHR"] | 115.0000 | 135.0000 | 10 | 45 | false | false | true | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:51:13Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:51:13Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:50:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:34:13Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:03:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:02:07Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:01:12Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:21:45Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:43:17Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:34:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |