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 |
|---|
| 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 |
|---|
| 01a0d9fb-799e-72b2-9337-0aefe67c9db2 | TWLO | 2026-09-25 15:12 | call_vertical_spread | 2 | 1 | 7 | 207900.00 | unknown | ask | 276.9400 | 7.0000 | ["100","175"] | ["0.9472","0.7316"] | ["286.00"] | ["XBOX"] | 100.0000 | 175.0000 | 175 | 175 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:12:13Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d9e2-5037-7031-9fd0-081051392d2f | TWLO | 2026-09-25 14:44 | call_vertical_spread | 2 | 1 | 25 | 216739.00 | long | ask | 277.4400 | 3.2000 | ["250","300"] | ["0.6471","0.6462"] | ["272.51"] | ["XMIO"] | 250.0000 | 300.0000 | 112 | 112 | false | false | |||||||||||
| 01a0d98c-f0bf-7191-9dd3-d1ddc968702b | TWLO | 2026-09-25 13:11 | call_diagonal_spread | 2 | 1 | 5 | 180230.00 | long | ask | 278.6000 | 7.3000 | ["115","130"] | ["0.7190","0.6748"] | [] | ["XCBO"] | 115.0000 | 130.0000 | 483 | 847 | false | false | |||||||||||
| 01a0d447-d98f-7130-8418-b7fd49d65d89 | TWLO | 2026-09-24 12:37 | call_vertical_spread | 2 | 1 | 10 | 204670.00 | long | ask | 297.3300 | 6.7000 | ["240","250"] | ["0.6455","0.6416"] | ["245.35"] | ["XCBO"] | 240.0000 | 250.0000 | 358 | 358 | false | false | |||||||||||
| 01a0d436-7087-7bb1-a5a0-fd0a200f2142 | TWLO | 2026-09-24 12:18 | call_vertical_spread | 2 | 1 | 6 | 133050.00 | long | ask | 297.8300 | 5.9000 | ["185","195"] | ["0.7494","0.7392"] | ["194.25"] | ["XPHO"] | 185.0000 | 195.0000 | 57 | 57 | false | false | |||||||||||
| 01a0d3f2-280f-7013-a542-08663e3cf026 | TWLO | 2026-09-24 11:04 | straddle | 2 | 1 | 500 | 7950000.00 | long | ask | 297.7600 | 5.4000 | ["260"] | ["0.6305"] | ["101","419.00"] | ["AMXO"] | 260.0000 | 260.0000 | 484 | 484 | false | false | |||||||||||
| 01a0cf9c-e74f-7bd3-82d2-eac9f4096622 | TWLO | 2026-09-23 14:52 | call_ratio_spread | 2 | 3 | 12 | 178000.00 | unknown | ask | 287.6300 | 5.1500 | ["250","350"] | ["0.6394","0.6146"] | ["379.00"] | ["XISX"] | 250.0000 | 350.0000 | 485 | 485 | false | false | |||||||||||
| 01a0ceaf-7a0e-78a0-b9c1-4abc3e0b35e1 | TWLO | 2026-09-23 10:33 | strangle | 2 | 1 | 858 | 1595880.00 | long | ask | 288.8500 | 4.7000 | ["285","320"] | ["0.6426","0.6390"] | ["266.40","338.60"] | ["XBOX"] | 285.0000 | 320.0000 | 16 | 16 | true | true | |||||||||||
| 01a0c962-063f-7c33-9737-183f0cf46491 | TWLO | 2026-09-22 09:50 | call_diagonal_spread | 2 | 1 | 210 | 413700.00 | long | ask | 275.1750 | 5.8000 | ["280","330"] | ["0.8478","0.6916"] | [] | ["XPHO"] | 280.0000 | 330.0000 | 3 | 59 | false | true | |||||||||||
| 01a0c961-42ef-7ab1-b95f-4bfdaa601286 | TWLO | 2026-09-22 09:49 | put_vertical_spread | 2 | 1 | 250 | 107500.00 | long | ask | 278.1300 | 4.8500 | ["265","267.5"] | ["0.6592","0.6465"] | ["267.0"] | ["BATO"] | 265.0000 | 267.5000 | 3 | 3 | false | true | |||||||||||
| 01a0c958-07a7-7083-bd44-98dc8f5fb8d6 | TWLO | 2026-09-22 09:39 | call_vertical_spread | 2 | 2 | 38 | 297400.00 | long | ask | 285.3000 | 6.8000 | ["240","260"] | ["0.4895","0.5255"] | ["256.0"] | ["XISX","XMIO"] | 240.0000 | 260.0000 | 24 | 24 | false | false | |||||||||||
| 01a0c55c-0a77-7b31-ab94-8a193466816d | TWLO | 2026-09-21 15:05 | put_diagonal_spread | 2 | 2 | 35 | 269465.00 | unknown | ask | 262.7301 | 8.0000 | ["210","230"] | ["0.6325","0.6207"] | [] | ["AMXO"] | 210.0000 | 230.0000 | 361 | 487 | false | true | |||||||||||
| 01a0c4d5-810f-7f51-8a1e-d918df128a93 | TWLO | 2026-09-21 12:38 | call_diagonal_spread | 2 | 1 | 5 | 121605.00 | short | ask | 259.8750 | 7.6000 | ["140","160"] | ["0.7075","0.6672"] | [] | ["XCBO"] | 140.0000 | 160.0000 | 179 | 269 | false | false | |||||||||||
| 01a0c48f-9a87-7de0-a522-ba981cea0f30 | TWLO | 2026-09-21 11:22 | put_vertical_spread | 2 | 1 | 250 | 620250.00 | long | ask | 257.1575 | 5.6000 | ["265","267.5"] | ["0.6371","0.6458"] | ["265.65"] | ["BATO"] | 265.0000 | 267.5000 | 4 | 4 | true | false | |||||||||||
| 01a0c43e-07b7-72e2-b476-ab553567bab1 | TWLO | 2026-09-21 09:53 | call_vertical_spread | 2 | 1 | 23 | 162840.00 | long | ask | 251.3500 | 4.8000 | ["217.5","220"] | ["0.5055","0.4986"] | ["219.7"] | ["BATO"] | 217.5000 | 220.0000 | 25 | 25 | false | false | |||||||||||
| 01a0c43e-07b7-72e2-b476-ab49b0cab6d9 | TWLO | 2026-09-21 09:53 | call_vertical_spread | 2 | 1 | 67 | 474427.00 | long | ask | 251.3500 | 4.8000 | ["217.5","220"] | ["0.5063","0.4986"] | ["219.71"] | ["BATO"] | 217.5000 | 220.0000 | 25 | 25 | false | false | |||||||||||
| 01a0b4bc-9ea7-79b1-8822-84eb198e796a | TWLO | 2026-09-18 09:37 | other | 4 | 3 | 8 | 133852.00 | unknown | ask | 242.0650 | 13.6000 | ["160","175","190","200"] | ["7.2225","0.6371","6.2624","0.5928"] | [] | ["XISX"] | 160.0000 | 200.0000 | 0 | 182 | false | false | |||||||||||
| 01a0aad3-3c9b-7ad2-8d65-66e107c73f49 | TWLO | 2026-09-16 11:26 | call_diagonal_spread | 2 | 2 | 10 | 107780.00 | long | ask | 242.3700 | 3.1000 | ["190","200"] | ["1.7367","0.6187"] | [] | ["EDGO","XISX"] | 190.0000 | 200.0000 | 2 | 93 | false | false | |||||||||||
| 01a0aa69-767b-7ba0-b211-0c9baee1e82d | TWLO | 2026-09-16 09:30 | call_vertical_spread | 2 | 2 | 13 | 149753.00 | long | ask | 239.7400 | 10.0000 | ["185","195"] | ["0.6690","0.6565"] | ["192.88"] | ["XPHO"] | 185.0000 | 195.0000 | 65 | 65 | false | false | |||||||||||
| 01a0a680-73d5-7fb0-a84c-d46c06a0e110 | TWLO | 2026-09-15 15:17 | call_vertical_spread | 2 | 1 | 31 | 362421.00 | long | ask | 240.8150 | 3.0000 | ["185","195"] | ["0.6615","0.6487"] | ["192.95"] | ["BATO"] | 185.0000 | 195.0000 | 66 | 66 | false | false | |||||||||||
| 01a0a623-9a4e-7523-9eb2-af53c213745b | TWLO | 2026-09-15 13:35 | call_calendar | 2 | 1 | 3 | 110403.00 | short | ask | 243.0000 | 9.0000 | ["60"] | ["1.1097"] | [] | ["XCBO"] | 60.0000 | 60.0000 | 122 | 185 | false | false | |||||||||||
| 01a0a5f5-6246-71d1-bb36-5d8a22d5cd65 | TWLO | 2026-09-15 12:45 | call_vertical_spread | 2 | 1 | 3 | 101907.00 | long | ask | 242.0500 | 4.4000 | ["70","75"] | ["5.9752","5.7364"] | ["74.97"] | ["AMXO"] | 70.0000 | 75.0000 | 3 | 3 | false | false |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:45:07Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:11:59Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:38:14Z"} |
| 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-24T16:19:07Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:04:50Z"} |
| 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-23T18:53:23Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:33:29Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:50:49Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:49:51Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:39:49Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:05:53Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:38:44Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:22:19Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:53:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:53:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:37:49Z"} |
| 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-16T15:26:32Z"} |
| 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-16T13:30:40Z"} |
| 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-15T19:17:45Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:35:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:45:42Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |