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 |
|---|
| 01a0ca67-7407-70a2-ada9-a805232b63e9 | NET | 2026-09-22 14:36 | other | 4 | 1 | 9 | 253233.00 | unknown | bid | 354.6200 | 13.8000 | ["260","280","300","320"] | ["1.5210","1.1470","0.6262","0.6197"] | [] | ["XCBO"] | 260.0000 | 320.0000 | 3 | 38 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:36:45Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9e1-020f-7402-aa87-972eb03d5746 | NET | 2026-09-22 12:09 | call_vertical_spread | 2 | 1 | 5 | 109170.00 | unknown | bid | 349.6400 | 6.1000 | ["250","260"] | ["0.6621","0.6552"] | ["364.17"] | ["AMXO"] | 250.0000 | 260.0000 | 115 | 115 | false | false | false | true | |||||||||
| 01a0c9c3-b9f6-7a91-b5de-9e999bd43426 | NET | 2026-09-22 11:37 | call_diagonal_spread | 2 | 1 | 14 | 213556.00 | unknown | bid | 351.3800 | 2.6000 | ["290","370"] | ["0.6492","0.6322"] | [] | ["BATO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | true | |||||||||
| 01a0c957-406f-7a72-9fc0-40ed954ddefe | NET | 2026-09-22 09:38 | call_diagonal_spread | 2 | 2 | 12 | 130854.00 | unknown | bid | 351.0550 | 5.5000 | ["370","400"] | ["0.6360","0.6295"] | [] | ["XISX"] | 370.0000 | 400.0000 | 150 | 241 | false | true | true | true | |||||||||
| 01a0c587-6bef-70e0-956c-ed2a7665a101 | NET | 2026-09-21 15:52 | other | 2 | 1 | 6 | 152000.00 | unknown | bid | 350.8675 | 8.5000 | ["470"] | ["0.6309"] | ["216.67","850.00"] | ["XISX"] | 470.0000 | 470.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c580-e40f-7c80-ad96-06be0337fc91 | NET | 2026-09-21 15:45 | other | 2 | 2 | 12 | 304000.00 | unknown | bid | 350.1300 | 6.4625 | ["470"] | ["0.6310"] | ["216.67","850.00"] | ["XCBO","XISX"] | 470.0000 | 470.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c57c-f056-7763-b2dd-8cf94600b90b | NET | 2026-09-21 15:41 | call_diagonal_spread | 2 | 2 | 11 | 113181.00 | unknown | bid | 350.1100 | 2.7045 | ["350","370"] | ["0.6245","0.6419"] | [] | ["XPHO"] | 350.0000 | 370.0000 | 116 | 151 | false | false | true | true | |||||||||
| 01a0c557-ad47-7022-8a6d-00fb87b3c718 | NET | 2026-09-21 15:00 | other | 2 | 2 | 12 | 304000.00 | unknown | bid | 349.0950 | 5.6000 | ["470"] | ["0.6310"] | ["216.67","850.00"] | ["XCBO","XISX"] | 470.0000 | 470.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c555-7eaf-7813-8ebc-74c31bd664a5 | NET | 2026-09-21 14:58 | other | 2 | 2 | 21 | 532000.00 | unknown | bid | 348.9700 | 6.3000 | ["470"] | ["0.6311"] | ["216.67","850.00"] | ["XCBO","XISX"] | 470.0000 | 470.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c554-9837-7561-9cb5-a1f5b004ae8f | NET | 2026-09-21 14:57 | other | 2 | 1 | 9 | 228000.00 | unknown | bid | 348.7650 | 6.3000 | ["470"] | ["0.6311"] | ["216.67","850.00"] | ["XISX"] | 470.0000 | 470.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c54f-6817-7b73-8542-193251596562 | NET | 2026-09-21 14:51 | other | 2 | 1 | 9 | 228300.00 | unknown | bid | 348.5901 | 6.3000 | ["470"] | ["0.6321"] | ["216.33","850.50"] | ["XISX"] | 470.0000 | 470.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c54e-a0df-77e0-90b3-febf23be940e | NET | 2026-09-21 14:50 | other | 2 | 1 | 9 | 228300.00 | unknown | bid | 348.8057 | 6.8000 | ["470"] | ["0.6321"] | ["216.33","850.50"] | ["XISX"] | 470.0000 | 470.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c54a-1c9f-7c63-8db9-3cb076a93201 | NET | 2026-09-21 14:46 | other | 2 | 1 | 9 | 228300.00 | unknown | bid | 348.0600 | 6.7000 | ["470"] | ["0.6321"] | ["216.33","850.50"] | ["XISX"] | 470.0000 | 470.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c549-af3f-7292-9e9f-9ebef9893a37 | NET | 2026-09-21 14:45 | other | 2 | 1 | 9 | 228300.00 | unknown | bid | 348.0600 | 6.7000 | ["470"] | ["0.6321"] | ["216.33","850.50"] | ["XISX"] | 470.0000 | 470.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c543-b016-7041-b3cb-38d6d1b1db65 | NET | 2026-09-21 14:38 | other | 2 | 1 | 9 | 228900.00 | unknown | bid | 347.9650 | 7.2000 | ["470"] | ["0.6341"] | ["215.67","851.50"] | ["XISX"] | 470.0000 | 470.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c53f-e36f-72c3-bf0d-fed5c8416922 | NET | 2026-09-21 14:34 | other | 2 | 1 | 9 | 229200.00 | unknown | bid | 347.8400 | 6.1500 | ["470"] | ["0.6351"] | ["215.33","852.00"] | ["XISX"] | 470.0000 | 470.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c468-d4bf-7d82-be6c-d00fea91294c | NET | 2026-09-21 10:39 | call_vertical_spread | 2 | 1 | 20 | 113540.00 | unknown | bid | 341.9950 | 6.1000 | ["315","317.5"] | ["0.7967","0.7869"] | ["344.64"] | ["XCBO"] | 315.0000 | 317.5000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0b5f2-154f-76a1-9ccd-6924f3eab661 | NET | 2026-09-18 15:15 | call_vertical_spread | 2 | 1 | 63 | 974988.00 | unknown | bid | 322.2948 | 6.4500 | ["250","260"] | ["0.6692","0.6586"] | ["332.38"] | ["BATO"] | 250.0000 | 260.0000 | 63 | 63 | false | false | false | true | |||||||||
| 01a0b5e1-fc37-73b3-a3fc-708fb7cfa7c6 | NET | 2026-09-18 14:57 | put_ratio_spread | 2 | 1 | 400 | 1272000.00 | unknown | bid | 322.7150 | 2.0500 | ["250","320"] | ["0.6050","0.5937"] | ["256.40"] | ["XBOX"] | 250.0000 | 320.0000 | 119 | 119 | false | true | false | true | |||||||||
| 01a0b4e8-5ddf-7710-9af7-19e40183fbdc | NET | 2026-09-18 10:25 | call_diagonal_spread | 2 | 1 | 10 | 193940.00 | unknown | bid | 315.3000 | 5.8000 | ["220","310"] | ["6.5022","0.6260"] | [] | ["XCBO"] | 220.0000 | 310.0000 | 0 | 490 | false | false | true | true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:09:24Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:37:31Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:39:09Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:53:00Z"} |
| 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-21T19:45:55Z"} |
| 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-21T19:41:33Z"} |
| 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-21T19:01:21Z"} |
| 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-21T18:58:50Z"} |
| 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-21T18:57:46Z"} |
| 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-21T18:52:00Z"} |
| 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-21T18:51:25Z"} |
| 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-21T18:46:22Z"} |
| 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-21T18:45:52Z"} |
| 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-21T18:39:33Z"} |
| 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-21T18:35:07Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:40:07Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:15:53Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:58:08Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:25:22Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |