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 |
|---|
| 01a0c4e0-bff7-7592-a260-aac681151a04 | TXN | 2026-09-21 12:50 | other | 4 | 1 | 10 | 155740.00 | unknown | bid | 269.0100 | 11.0500 | ["150","220","230","390"] | ["0.4907","0.4733","0.3830","0.3938"] | [] | ["C2OX"] | 150.0000 | 390.0000 | 487 | 851 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:51:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5f9-fcbf-72d0-bc97-9ff5f18c7e51 | TXN | 2026-09-18 15:24 | call_diagonal_spread | 2 | 1 | 75 | 390450.00 | short | bid | 264.5300 | 1.9500 | ["240","260"] | ["7.2042","0.3929"] | [] | ["ARCO"] | 240.0000 | 260.0000 | 0 | 119 | false | false | true | true | |||||||||
| 01a0b5bb-9bff-7e12-95e3-d1fe73dc63b1 | TXN | 2026-09-18 14:16 | call_diagonal_spread | 2 | 1 | 10 | 111510.00 | short | bid | 263.5850 | 3.9500 | ["260","310"] | ["0.3903","0.3848"] | [] | ["XISX"] | 260.0000 | 310.0000 | 490 | 854 | false | false | true | true | |||||||||
| 01a0b0e2-00b3-7823-9a87-45a379511d79 | TXN | 2026-09-17 15:39 | call_diagonal_spread | 2 | 1 | 200 | 2093597.00 | short | bid | 258.6800 | 4.2000 | ["270","300"] | ["0.3931","0.3817"] | [] | ["XCBO"] | 270.0000 | 300.0000 | 491 | 855 | false | true | true | true | |||||||||
| 01a0b03e-796b-7fd3-8981-5880967123a7 | TXN | 2026-09-17 12:41 | call_diagonal_spread | 2 | 1 | 20 | 302140.00 | short | bid | 259.6500 | 4.5000 | ["220","240"] | ["0.3840","0.3700"] | [] | ["XCBO"] | 220.0000 | 240.0000 | 491 | 855 | false | false | true | true | |||||||||
| 01a0b03b-c9ea-70e0-a1f7-ca05949179f7 | TXN | 2026-09-17 12:38 | call_diagonal_spread | 2 | 1 | 11 | 177166.00 | short | bid | 259.4500 | 6.3500 | ["210","230"] | ["0.3820","0.3677"] | [] | ["XCBO"] | 210.0000 | 230.0000 | 491 | 855 | false | false | true | true | |||||||||
| 01a0b012-8b52-72b0-bf26-300cec4a7386 | TXN | 2026-09-17 11:53 | call_diagonal_spread | 2 | 1 | 20 | 303000.00 | long | bid | 258.7400 | 5.8000 | ["210","250"] | ["0.3803","0.3750"] | [] | ["XISX"] | 210.0000 | 250.0000 | 491 | 855 | false | false | true | true | |||||||||
| 01a0b00f-5aeb-7352-9908-ee6517fabdb6 | TXN | 2026-09-17 11:49 | call_diagonal_spread | 2 | 1 | 35 | 529760.00 | long | bid | 258.2200 | 5.8000 | ["210","250"] | ["0.3836","0.3777"] | [] | ["XISX"] | 210.0000 | 250.0000 | 491 | 855 | false | false | true | true | |||||||||
| 01a0b00f-5aeb-7352-9908-ee51a877b191 | TXN | 2026-09-17 11:49 | call_diagonal_spread | 2 | 1 | 35 | 529760.00 | long | bid | 258.2200 | 5.8000 | ["210","250"] | ["0.3836","0.3777"] | [] | ["XISX"] | 210.0000 | 250.0000 | 491 | 855 | false | false | true | true | |||||||||
| 01a0aa7b-318b-7e70-b15b-a1f917a6aaea | TXN | 2026-09-16 09:49 | call_calendar | 2 | 4 | 86 | 333726.00 | short | bid | 266.3200 | 4.6000 | ["250"] | ["0.5146"] | [] | ["BATO","EDGO","MCRY","XCBO"] | 250.0000 | 250.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0aa7b-318b-7e70-b15b-a1ecacc51c56 | TXN | 2026-09-16 09:49 | call_calendar | 2 | 2 | 56 | 217203.00 | short | bid | 266.3200 | 4.6000 | ["250"] | ["0.5132"] | [] | ["BATO","EDGO"] | 250.0000 | 250.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0aa7b-318b-7e70-b15b-a1d56d1226de | TXN | 2026-09-16 09:49 | call_calendar | 2 | 1 | 31 | 120280.00 | short | bid | 266.3200 | 5.0000 | ["250"] | ["0.5148"] | [] | ["BATO"] | 250.0000 | 250.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0a5fd-7896-7bf2-a988-5b9d42790654 | TXN | 2026-09-15 12:54 | call_diagonal_spread | 2 | 1 | 20 | 135880.00 | short | bid | 263.5800 | 5.4000 | ["230","240"] | ["0.8583","0.4384"] | [] | ["XCBO"] | 230.0000 | 240.0000 | 3 | 66 | false | false | true | true | |||||||||
| 01a0a5d3-24a5-7722-ad68-a9a0897f541d | TXN | 2026-09-15 12:07 | call_diagonal_spread | 2 | 1 | 11 | 133199.00 | short | bid | 263.6150 | 6.5500 | ["260","290"] | ["0.4047","0.3915"] | [] | ["XMIO"] | 260.0000 | 290.0000 | 493 | 857 | false | false | true | true | |||||||||
| 01a0a568-6486-7351-a5c1-a65cab837a70 | TXN | 2026-09-15 10:11 | call_diagonal_spread | 2 | 1 | 162 | 2269296.00 | short | bid | 265.8250 | 6.2000 | ["240","270"] | ["0.4011","0.3874"] | [] | ["XCBO"] | 240.0000 | 270.0000 | 493 | 857 | false | false | true | true | |||||||||
| 01a0a548-8c2d-7191-8243-b5ee85ab068f | TXN | 2026-09-15 09:36 | call_diagonal_spread | 2 | 1 | 30 | 223200.00 | short | bid | 265.5900 | 5.2000 | ["230","245"] | ["1.0053","0.4174"] | [] | ["XCBO"] | 230.0000 | 245.0000 | 3 | 122 | false | false | true | true | |||||||||
| 01a0a0c9-4a50-75f3-bc23-20ea6609a862 | TXN | 2026-09-14 12:38 | call_diagonal_spread | 2 | 1 | 18 | 227826.00 | short | bid | 264.3700 | 7.1500 | ["250","290"] | ["0.3992","0.3946"] | [] | ["XCBO"] | 250.0000 | 290.0000 | 494 | 858 | false | false | true | true | |||||||||
| 01a0a0c6-ecd8-7fe0-9583-ceb954d4f2e6 | TXN | 2026-09-14 12:36 | call_diagonal_spread | 2 | 1 | 108 | 1634364.00 | short | bid | 264.3950 | 6.7000 | ["230","250"] | ["0.3982","0.3864"] | [] | ["XCBO"] | 230.0000 | 250.0000 | 494 | 858 | false | false | true | true | |||||||||
| 01a0a0b6-6a48-79f1-829d-5d5dce0544f6 | TXN | 2026-09-14 12:18 | call_diagonal_spread | 2 | 1 | 80 | 1066960.00 | short | bid | 265.0200 | 6.9000 | ["250","270"] | ["0.3959","0.3868"] | [] | ["XCBO"] | 250.0000 | 270.0000 | 494 | 858 | false | false | true | true | |||||||||
| 01a08154-4be8-7451-ba21-de80a6973089 | TXN | 2026-09-08 10:02 | risk_reversal | 2 | 2 | 46 | 271354.00 | long | bid | 257.8100 | 0.9500 | ["270","280"] | ["0.4341","0.3974"] | ["257.12"] | ["ARCO","C2OX"] | 270.0000 | 280.0000 | 192 | 192 | false | false | false | true | |||||||||
| 01a08154-4be8-7451-ba21-de6688657248 | TXN | 2026-09-08 10:02 | strangle | 2 | 3 | 18 | 106182.00 | short | bid | 257.8100 | 0.6000 | ["270","280"] | ["0.4339","0.3975"] | ["211.01","338.99"] | ["EDGO","XISX","XMIO"] | 270.0000 | 280.0000 | 192 | 192 | false | false | false | true | |||||||||
| 01a08154-4be8-7451-ba21-de349558d902 | TXN | 2026-09-08 10:02 | strangle | 2 | 2 | 18 | 106182.00 | short | bid | 257.7200 | 0.4000 | ["270","280"] | ["0.4335","0.3979"] | ["211.01","338.99"] | ["EDGO","XMIO"] | 270.0000 | 280.0000 | 192 | 192 | false | false | false | true | |||||||||
| 01a08154-4418-7721-babb-0a325769f83b | TXN | 2026-09-08 10:02 | strangle | 2 | 2 | 24 | 141426.00 | short | bid | 257.7200 | 1.3313 | ["270","280"] | ["0.4330","0.3976"] | ["211.07","338.93"] | ["EDGO","XISX"] | 270.0000 | 280.0000 | 192 | 192 | false | false | false | true | |||||||||
| 01a08154-3478-77f2-90e2-1ad46c9b758e | TXN | 2026-09-08 10:02 | strangle | 2 | 2 | 27 | 159165.00 | short | bid | 257.7200 | 1.8000 | ["270","280"] | ["0.4333","0.3977"] | ["211.05","338.95"] | ["C2OX","XCBO"] | 270.0000 | 280.0000 | 192 | 192 | false | false | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:24:15Z"} |
| 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-18T18:16:28Z"} |
| 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-17T19:40:02Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:41:46Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:38:26Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:53:44Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:49:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:49:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:50:06Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:50:06Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:50:06Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:54:06Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:08:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:11:16Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:36:29Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:39:14Z"} |
| 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-14T16:36:54Z"} |
| 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-14T16:18:28Z"} |
| 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-08T14:03:02Z"} |
| 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:03:02Z"} |
| 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:03:02Z"} |
| 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:03:02Z"} |
| 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:03:02Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |