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_side |
|---|
| 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 |
|---|
| 01a06dd3-800d-7f90-a15d-21605cbcf980 | SNXX | 2026-09-04 15:09 | put_vertical_spread | 2 | 1 | 191 | 471770.00 | unknown | — | 16.9350 | 1.2000 | ["29","29.5"] | ["25.9811","26.6536"] | [] | ["XCBO"] | 29.0000 | 29.5000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:09:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dde-49c5-7833-981d-c56c59535188 | SNXX | 2026-09-04 15:21 | other | 2 | 1 | 144 | 112320.00 | unknown | — | 16.8820 | 0.7000 | ["30","32"] | ["1.5548","1.5528"] | [] | ["XISX"] | 30.0000 | 32.0000 | 133 | 196 | false | true | true | true | false | mlet | |||||||
| 01a081ae-81a8-7bb0-9728-a40da3512f6f | SNXX | 2026-09-08 11:41 | other | 2 | 1 | 1000 | 280000.00 | unknown | — | 18.4508 | 0.2500 | ["22","26"] | ["1.6099","1.6337"] | [] | ["MCRY"] | 22.0000 | 26.0000 | 17 | 31 | false | true | true | true | false | mlet | |||||||
| 01a081af-77c0-7820-b3bc-c1117d6c9aa0 | SNXX | 2026-09-08 11:42 | other | 2 | 1 | 80 | 122400.00 | unknown | — | 18.4528 | 2.5000 | ["18","18.75"] | ["1.6851","1.7582"] | [] | ["XBOX"] | 18.0000 | 18.7500 | 129 | 192 | false | false | true | true | false | mlft | |||||||
| 01a0825b-5ba8-74f1-a530-120b6b386e2b | SNXX | 2026-09-08 14:50 | call_vertical_spread | 2 | 1 | 105 | 320145.00 | unknown | — | 18.4500 | 1.3000 | ["3","3.5"] | ["9.5583","9.0536"] | [] | ["XISX"] | 3.0000 | 3.5000 | 3 | 3 | true | false | false | true | false | mlat | |||||||
| 01a0826a-fba8-7de3-8d4d-5156b86043bd | SNXX | 2026-09-08 15:07 | call_vertical_spread | 2 | 1 | 193 | 586720.00 | unknown | — | 18.2550 | 1.4000 | ["3","3.5"] | ["12.7788","11.6657"] | [] | ["XCBO"] | 3.0000 | 3.5000 | 3 | 3 | false | false | false | true | false | mlat | |||||||
| 01a08684-4ca8-7fc3-844e-2f150954ac0d | SNXX | 2026-09-09 10:13 | call_vertical_spread | 2 | 1 | 200 | 199000.00 | unknown | — | 18.5501 | 1.5000 | ["20","25"] | ["1.6211","1.5823"] | [] | ["XBOX"] | 20.0000 | 25.0000 | 100 | 100 | false | true | false | true | false | mlft | |||||||
| 01a087b7-4a80-74b1-97b8-4fd40008ab6d | SNXX | 2026-09-09 15:48 | put_vertical_spread | 2 | 1 | 187 | 282370.00 | unknown | — | 17.7250 | 0.8000 | ["25","25.5"] | ["2.3167","2.4265"] | [] | ["XCBO"] | 25.0000 | 25.5000 | 2 | 2 | false | false | false | true | false | mlat | |||||||
| 01a087ba-e848-7380-8f82-7dca84897495 | SNXX | 2026-09-09 15:52 | put_vertical_spread | 2 | 1 | 88 | 169752.00 | unknown | — | 17.8191 | 0.7000 | ["27","28"] | ["3.4685","3.6963"] | [] | ["XISX"] | 27.0000 | 28.0000 | 2 | 2 | true | false | false | true | false | mlat | |||||||
| 01a087bb-a3c8-7081-ab07-9ff2732cc4e2 | SNXX | 2026-09-09 15:53 | put_vertical_spread | 2 | 1 | 140 | 271460.00 | unknown | — | 17.7215 | 0.9000 | ["27","28"] | ["3.5208","3.7487"] | [] | ["XISX"] | 27.0000 | 28.0000 | 2 | 2 | true | false | false | true | false | mlat | |||||||
| 01a087bc-c8c0-7e93-90bc-c97860eaa9c8 | SNXX | 2026-09-09 15:54 | put_vertical_spread | 2 | 1 | 189 | 266490.00 | unknown | — | 17.8050 | 0.8000 | ["24.5","25"] | ["2.7707","2.9021"] | [] | ["XCBO"] | 24.5000 | 25.0000 | 2 | 2 | false | false | false | true | false | mlat | |||||||
| 01a087be-a169-7722-9dfd-05d4e855b8da | SNXX | 2026-09-09 15:56 | put_vertical_spread | 2 | 1 | 229 | 444260.00 | unknown | — | 17.7800 | 3.2000 | ["27","28"] | ["5.7286","6.0176"] | [] | ["XCBO"] | 27.0000 | 28.0000 | 2 | 2 | false | false | false | true | false | mlat | |||||||
| 01a08cb2-c5f1-7761-b097-04374797b142 | SNXX | 2026-09-10 15:01 | call_vertical_spread | 2 | 1 | 88 | 210232.00 | unknown | — | 16.6550 | 1.0000 | ["4.5","5"] | ["11.9563","11.4744"] | [] | ["XISX"] | 4.5000 | 5.0000 | 1 | 1 | true | false | false | true | false | mlat | |||||||
| 01a08cb3-b050-7420-8d6a-2bfb0f2e1f1d | SNXX | 2026-09-10 15:02 | call_vertical_spread | 2 | 1 | 188 | 336332.00 | unknown | — | 16.6514 | 0.9000 | ["7.5","8"] | ["7.6380","7.3525"] | [] | ["XISX"] | 7.5000 | 8.0000 | 1 | 1 | true | false | false | true | false | mlat | |||||||
| 01a08cbc-95a8-73c0-8aa8-28ff29c2ff7b | SNXX | 2026-09-10 15:12 | call_vertical_spread | 2 | 1 | 188 | 334640.00 | unknown | — | 16.4914 | 1.0000 | ["7.5","8"] | ["9.9090","9.1989"] | [] | ["XCBO"] | 7.5000 | 8.0000 | 1 | 1 | false | false | false | true | false | mlat | |||||||
| 01a08cd9-3d99-7b72-a867-bc615cb37670 | SNXX | 2026-09-10 15:43 | call_vertical_spread | 2 | 1 | 89 | 211820.00 | unknown | — | 16.7250 | 1.0000 | ["4.5","5"] | ["16.0760","14.8538"] | [] | ["XCBO"] | 4.5000 | 5.0000 | 1 | 1 | false | false | false | true | false | mlat | |||||||
| 01a091a7-3c80-74e0-a822-e1ffcf46ce1d | SNXX | 2026-09-11 14:07 | put_calendar | 2 | 1 | 200 | 150600.00 | unknown | — | 15.2550 | 0.5000 | ["19"] | ["5.2730"] | [] | ["XCBO"] | 19.0000 | 19.0000 | 0 | 7 | false | false | true | false | false | mlat | |||||||
| 01a0b00b-a5b2-7e50-ba7f-b7f051522d4c | SNXX | 2026-09-17 11:45 | call_diagonal_spread | 2 | 1 | 1000 | 178000.00 | unknown | — | 14.5900 | 0.1500 | ["17.5","25"] | ["2.0271","1.4232"] | [] | ["XISX"] | 17.5000 | 25.0000 | 1 | 92 | false | true | true | true | false | mlet | |||||||
| 01a0b4c8-625f-79f3-8a71-33f35f9796e1 | SNXX | 2026-09-18 09:50 | call_calendar | 2 | 1 | 100 | 115900.00 | unknown | ask | 15.6750 | 1.3000 | ["10"] | ["7.4954"] | [] | ["AMXO"] | 10.0000 | 10.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0b5ed-cba8-71e1-89bb-9092607a4b62 | SNXX | 2026-09-18 15:10 | put_vertical_spread | 2 | 1 | 80 | 112000.00 | unknown | — | 16.9929 | 1.0000 | ["18","26"] | ["1.4407","1.5329"] | [] | ["XMIO"] | 18.0000 | 26.0000 | 42 | 42 | true | false | false | true | false | mlat | |||||||
| 01a0c42f-deb7-7691-ab7a-5392ae2ffebb | SNXX | 2026-09-21 09:37 | call_diagonal_spread | 2 | 1 | 150 | 238350.00 | unknown | ask | 18.2950 | 1.4000 | ["3","20"] | ["1.9666","1.6232"] | [] | ["XISX"] | 3.0000 | 20.0000 | 4 | 88 | false | false | true | true | |||||||||
| 01a0c58b-82cf-7220-b02a-26fdf4cfce8a | SNXX | 2026-09-21 15:57 | call_diagonal_spread | 2 | 1 | 350 | 548800.00 | unknown | bid | 17.5850 | 1.0000 | ["15","27"] | ["1.3318","1.3269"] | [] | ["XISX"] | 15.0000 | 27.0000 | 179 | 487 | false | false | true | true | |||||||||
| 01a0c9b6-f46f-7d73-8f54-6da4e90bb2a4 | SNXX | 2026-09-22 11:23 | call_ratio_spread | 2 | 3 | 180 | 103200.00 | unknown | ask | 18.9950 | 0.5000 | ["25","30"] | ["1.5157","1.5273"] | ["26.89"] | ["C2OX","XISX"] | 25.0000 | 30.0000 | 87 | 87 | false | true | false | true | |||||||||
| 01a0c9d8-d067-7523-b06c-fbdd7c16baa5 | SNXX | 2026-09-22 12:00 | call_vertical_spread | 2 | 1 | 100 | 206500.00 | unknown | — | 19.5605 | 1.1000 | ["8.75","11.25"] | ["1.2272","1.3504"] | [] | ["XMIO"] | 8.7500 | 11.2500 | 87 | 87 | false | false | false | true | false | mlet | |||||||
| 01a0c9f6-bc8e-7d80-afb4-70994136b50d | SNXX | 2026-09-22 12:33 | call_diagonal_spread | 2 | 1 | 150 | 528750.00 | unknown | bid | 19.7850 | 3.7000 | ["1","2.5"] | ["10.0954","3.5572"] | [] | ["XPHO"] | 1.0000 | 2.5000 | 24 | 115 | false | false | true | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:21:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:41:53Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:42:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:50:24Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:07:25Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:13:45Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:49:17Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:53:09Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:53:37Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:55:00Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:57:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:02:16Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:03:29Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:12:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:44:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:08:06Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:46:14Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:50:29Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:11:00Z"} |
| 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-21T13:37:45Z"} |
| 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:57:35Z"} |
| 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-22T15:23:36Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:00:38Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:33:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |