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 | direction |
|---|
| 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 |
|---|
| 01a06d31-a675-7192-b43e-8715c8831027 | SOXS | 2026-09-04 12:12 | other | 2 | 1 | 123 | 153135.00 | unknown | — | 46.8001 | 2.0000 | ["50"] | ["0.9919"] | [] | ["XISX"] | 50.0000 | 50.0000 | 7 | 35 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:12:46Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a0813f-8780-7411-b29c-0c953fd45d3d | SOXS | 2026-09-08 09:40 | put_calendar | 2 | 1 | 64 | 112448.00 | short | bid | 43.5400 | 1.2500 | ["51"] | ["1.3888"] | [] | ["XMIO"] | 51.0000 | 51.0000 | 3 | 17 | false | false | true | ||||||||||
| 01a08142-def9-7df2-8e2f-d5aec428f003 | SOXS | 2026-09-08 09:43 | put_vertical_spread | 2 | 1 | 50 | 114150.00 | unknown | — | 44.3800 | 1.9500 | ["40","44"] | ["1.2860","1.2902"] | [] | ["XPHO"] | 40.0000 | 44.0000 | 129 | 129 | false | true | false | true | |||||||||
| 01a081b9-4f48-7f91-8c54-eba8a7da8945 | SOXS | 2026-09-08 11:53 | put_vertical_spread | 2 | 1 | 50 | 116500.00 | short | bid | 42.8650 | 1.7500 | ["40","44"] | ["1.2571","1.2630"] | ["41.46"] | ["XPHO"] | 40.0000 | 44.0000 | 129 | 129 | false | false | |||||||||||
| 01a090b8-8339-7cf1-8690-2a5cd4301ed0 | SOXS | 2026-09-11 09:46 | put_vertical_spread | 2 | 1 | 48 | 105744.00 | unknown | — | 43.6800 | 1.9500 | ["40","44"] | ["1.2334","1.2450"] | [] | ["XPHO"] | 40.0000 | 44.0000 | 126 | 126 | false | false | false | true | |||||||||
| 01a0a027-1eb0-74c3-bb16-1cf38dd1709a | SOXS | 2026-09-14 09:41 | put_vertical_spread | 2 | 1 | 55 | 175592.00 | short | bid | 51.8162 | 9.4000 | ["20","48"] | ["1.3099","1.4074"] | ["28.64"] | ["XCBO"] | 20.0000 | 48.0000 | 494 | 494 | false | true | |||||||||||
| 01a0a038-54f1-7971-a572-e47ff01388b5 | SOXS | 2026-09-14 10:00 | call_vertical_spread | 2 | 1 | 32 | 117344.00 | short | bid | 51.1914 | 3.4500 | ["25","55"] | ["1.0939","1.2864"] | ["41.95"] | ["SPHR"] | 25.0000 | 55.0000 | 67 | 67 | false | false | |||||||||||
| 01a0a053-3f90-74e2-a44f-6643e8521aee | SOXS | 2026-09-14 10:30 | other | 2 | 1 | 20 | 106840.00 | unknown | — | 51.0200 | 1.2200 | ["50","100"] | ["1.3288","1.4132"] | [] | ["XCBO"] | 50.0000 | 100.0000 | 4 | 67 | false | false | true | true | false | ||||||||
| 01a0a083-cd40-7f51-ac02-393e3ec44eae | SOXS | 2026-09-14 11:23 | other | 2 | 1 | 90 | 254250.00 | unknown | — | 51.7050 | 0.8000 | ["38"] | ["0.9334"] | [] | ["MCRY"] | 38.0000 | 38.0000 | 11 | 25 | false | false | true | false | false | ||||||||
| 01a0a084-bb88-7170-a0bc-55861fb146be | SOXS | 2026-09-14 11:24 | call_calendar | 2 | 1 | 200 | 564600.00 | short | ask | 51.6150 | 0.8500 | ["38"] | ["1.0169"] | [] | ["BATO"] | 38.0000 | 38.0000 | 11 | 25 | false | false | true | ||||||||||
| 01a0a0bb-1598-7db2-8e87-1610fbd3ce1c | SOXS | 2026-09-14 12:23 | put_vertical_spread | 2 | 6 | 27 | 205335.00 | long | ask | 50.8839 | 6.8000 | ["63","65"] | ["1.4075","1.4076"] | ["63.43"] | ["AMXO","XISX","XPHO"] | 63.0000 | 65.0000 | 494 | 494 | false | false | |||||||||||
| 01a0a5cb-f8b6-7843-afa6-2debf8fa009a | SOXS | 2026-09-15 12:00 | put_vertical_spread | 2 | 1 | 429 | 133848.00 | long | ask | 51.4782 | 0.3900 | ["49.5","50"] | ["1.2727","1.2714"] | ["49.8"] | ["AMXO"] | 49.5000 | 50.0000 | 3 | 3 | false | true | |||||||||||
| 01a0abbb-8573-7f42-b1c6-9da69a279d38 | SOXS | 2026-09-16 15:39 | put_vertical_spread | 2 | 1 | 199 | 362578.00 | long | ask | 50.6799 | 3.6000 | ["40","44"] | ["1.2739","1.2865"] | ["41.76"] | ["XCBO"] | 40.0000 | 44.0000 | 121 | 121 | false | true | |||||||||||
| 01a0af97-7783-7e33-b1ae-6a1363e3e6b4 | SOXS | 2026-09-17 09:38 | put_diagonal_spread | 2 | 2 | 27 | 160209.00 | short | bid | 46.0600 | 1.7000 | ["50","100"] | ["1.4600","1.4435"] | [] | ["AMXO","SPHR"] | 50.0000 | 100.0000 | 1 | 64 | false | false | |||||||||||
| 01a0af97-7783-7e33-b1ae-6a02f8d0dec0 | SOXS | 2026-09-17 09:38 | put_diagonal_spread | 2 | 3 | 17 | 101440.00 | short | bid | 46.0650 | 2.8029 | ["50","100"] | ["1.7615","1.4747"] | [] | ["EMLD","SPHR","XPHO"] | 50.0000 | 100.0000 | 1 | 64 | false | false | |||||||||||
| 01a0af9e-593b-7202-b2cd-e9298cf94b2d | SOXS | 2026-09-17 09:46 | put_diagonal_spread | 2 | 1 | 35 | 171325.00 | long | ask | 45.4550 | 3.8500 | ["45.5","90"] | ["1.0765","1.3854"] | [] | ["XCBO"] | 45.5000 | 90.0000 | 8 | 64 | false | false | |||||||||||
| 01a0afb7-115b-7a53-ae06-4e3c3803ae70 | SOXS | 2026-09-17 10:13 | call_diagonal_spread | 2 | 1 | 250 | 151000.00 | long | ask | 45.2083 | 1.0100 | ["44.5","47"] | ["0.8872","1.1031"] | [] | ["SPHR"] | 44.5000 | 47.0000 | 8 | 15 | false | false | |||||||||||
| 01a0b5d0-4510-7672-9130-3c811c817f9e | SOXS | 2026-09-18 14:38 | call_vertical_spread | 2 | 1 | 30 | 161610.00 | unknown | bid | 43.8050 | 2.9000 | ["35","78"] | ["1.1453","1.1908"] | ["83.44"] | ["XISX"] | 35.0000 | 78.0000 | 854 | 854 | false | false | |||||||||||
| 01a0b5d2-6bd8-76d3-ab04-32bd94b8f03f | SOXS | 2026-09-18 14:40 | call_vertical_spread | 2 | 1 | 200 | 319800.00 | short | bid | 43.7789 | 0.8000 | ["44","45"] | ["1.1340","1.1349"] | ["44.39"] | ["XCBO"] | 44.0000 | 45.0000 | 63 | 63 | false | true | |||||||||||
| 01a0c430-fbdf-7d42-9a62-2affd0cba32c | SOXS | 2026-09-21 09:38 | put_diagonal_spread | 2 | 1 | 35 | 205940.00 | short | bid | 38.4350 | 4.3000 | ["45.5","90"] | ["1.7618","1.3568"] | [] | ["XCBO"] | 45.5000 | 90.0000 | 4 | 60 | false | false | |||||||||||
| 01a0c43e-51ef-7373-88c5-2b3ddda51714 | SOXS | 2026-09-21 09:53 | put_calendar | 2 | 1 | 64 | 170432.00 | short | bid | 37.8650 | 3.5000 | ["51"] | ["1.6723"] | [] | ["BATO"] | 51.0000 | 51.0000 | 4 | 25 | false | false | true | ||||||||||
| 01a0c466-447f-7242-bdea-0c179c9feb23 | SOXS | 2026-09-21 10:37 | put_vertical_spread | 2 | 1 | 200 | 392400.00 | short | bid | 37.0600 | 4.9500 | ["20","25"] | ["1.4000","1.4132"] | ["21.70"] | ["SPHR"] | 20.0000 | 25.0000 | 487 | 487 | false | true | |||||||||||
| 01a0c483-ee3f-7171-bfdc-ff1532db9a85 | SOXS | 2026-09-21 11:09 | call_vertical_spread | 2 | 1 | 99 | 171270.00 | long | ask | 36.5000 | 0.6500 | ["35","44"] | ["1.1575","1.1686"] | ["37.90"] | ["XISX"] | 35.0000 | 44.0000 | 116 | 116 | true | false | |||||||||||
| 01a0c486-f797-7a41-b9a2-3a87f575a68a | SOXS | 2026-09-21 11:12 | other | 4 | 1 | 20 | 129340.00 | unknown | bid | 36.3250 | 8.3500 | ["52","53","54"] | ["1.7277","2.1749","2.7627"] | [] | ["XMIO"] | 52.0000 | 54.0000 | 4 | 11 | false | false | true | ||||||||||
| 01a0c964-63b6-7823-90dd-d812ab69fa0d | SOXS | 2026-09-22 09:53 | put_diagonal_spread | 2 | 1 | 30 | 223888.00 | long | ask | 34.4350 | 3.3000 | ["38","105"] | ["0.9202","1.4235"] | [] | ["XCBO"] | 38.0000 | 105.0000 | 3 | 115 | false | false | |||||||||||
| 01a0c96c-52f7-73a0-be6b-bde980ff2f5d | SOXS | 2026-09-22 10:01 | put_diagonal_spread | 2 | 1 | 39 | 185133.00 | long | ask | 34.1699 | 1.5900 | ["34","80"] | ["1.1189","1.4159"] | [] | ["XCBO"] | 34.0000 | 80.0000 | 3 | 59 | false | false | |||||||||||
| 01a0c9a2-3fa7-7f10-afc4-dbebf52d1271 | SOXS | 2026-09-22 11:00 | put_vertical_spread | 2 | 1 | 225 | 137475.00 | unknown | — | 33.9400 | 0.4000 | ["33","34"] | ["1.1444","1.1326"] | [] | ["XCBO"] | 33.0000 | 34.0000 | 17 | 17 | true | false | false | true | |||||||||
| 01a0c9ca-edb7-7320-81c3-42aeda21b989 | SOXS | 2026-09-22 11:45 | call_vertical_spread | 2 | 1 | 100 | 407700.00 | unknown | bid | 33.7200 | 4.6000 | ["45","55"] | ["1.2395","1.2315"] | ["70.38"] | ["BATO"] | 45.0000 | 55.0000 | 850 | 850 | true | true | |||||||||||
| 01a0c9da-4767-7051-8908-b53936737039 | SOXS | 2026-09-22 12:01 | put_calendar | 2 | 1 | 45 | 152550.00 | short | bid | 33.4600 | 1.4500 | ["50"] | ["1.6783"] | [] | ["BATO"] | 50.0000 | 50.0000 | 3 | 38 | false | false | true | ||||||||||
| 01a0c9eb-9516-7b81-bc75-2177e8e4755d | SOXS | 2026-09-22 12:20 | put_diagonal_spread | 2 | 1 | 61 | 206851.00 | short | bid | 33.5100 | 0.5500 | ["45","50"] | ["1.3091","2.1361"] | [] | ["XISX"] | 45.0000 | 50.0000 | 3 | 115 | false | false | |||||||||||
| 01a0ca02-12e7-7002-b974-b3e327150f44 | SOXS | 2026-09-22 12:45 | put_calendar | 2 | 1 | 200 | 270400.00 | short | ask | 33.5099 | 3.1500 | ["40.5"] | ["1.5000"] | [] | ["XMIO"] | 40.5000 | 40.5000 | 3 | 10 | false | false | true | ||||||||||
| 01a0ca03-959f-7a93-9bd9-9ff426ed5bba | SOXS | 2026-09-22 12:47 | put_calendar | 2 | 1 | 200 | 284400.00 | short | bid | 33.4835 | 1.2000 | ["40.5"] | ["1.1914"] | [] | ["XCBO"] | 40.5000 | 40.5000 | 3 | 10 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:40:19Z"} |
| 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-08T13:44:12Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:53:40Z"} |
| 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-11T13:46:57Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:42:03Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:00:51Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:30:19Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:23:28Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:24:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:23:55Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:00:02Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:40:02Z"} |
| 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-17T13:39:04Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:39:04Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:46:35Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:13:28Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:38:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:41:37Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:39:01Z"} |
| 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-21T13:53:40Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:37:10Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:09:57Z"} |
| 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:13:08Z"} |
| 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-22T13:53:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:02:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:01:18Z"} |
| 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-22T15:45:15Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:02:03Z"} |
| 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-22T16:21:32Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:45:47Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:47:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |