core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 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 |
|---|
| 01a0ee70-cb87-74e1-81f1-7aed13bf31ea | TQQQ | 2026-09-29 14:32 | call_calendar | 2 | 2 | 60 | 184444.00 | short | ask | 77.2800 | 0.7675 | ["80"] | ["0.5908"] | [] | ["XPHO"] | 80.0000 | 80.0000 | 108 | 479 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-29T18:32:47Z"} | 2026-09-29 | 2026-09-29 17:15 | 2026-09-29 17:15 |
| 01a0ee1c-bbff-7351-8bd9-b44736db11ef | TQQQ | 2026-09-29 13:00 | call_calendar | 2 | 1 | 170 | 167280.00 | short | ask | 76.7975 | 0.7000 | ["73"] | ["0.6801"] | [] | ["XMIO"] | 73.0000 | 73.0000 | 3 | 10 | false | false | true | false | |||||||||
| 01a0e83a-b507-7370-8421-20f89a16552e | TQQQ | 2026-09-28 09:35 | call_calendar | 2 | 1 | 38 | 137940.00 | short | ask | 77.5950 | 2.1500 | ["60"] | ["1.2651"] | [] | ["XISX"] | 60.0000 | 60.0000 | 4 | 18 | false | false | true | false | |||||||||
| 01a0d999-9aef-7802-9072-a7048026bf24 | TQQQ | 2026-09-25 13:25 | call_calendar | 2 | 1 | 127 | 249434.00 | unknown | ask | 79.8627 | 1.1500 | ["73"] | ["0.5817"] | [] | ["XISX"] | 73.0000 | 73.0000 | 35 | 42 | false | false | true | false | |||||||||
| 01a0d969-2c7f-7a93-bac9-51a742b0e2bf | TQQQ | 2026-09-25 12:32 | call_calendar | 2 | 1 | 100 | 104900.00 | short | ask | 79.8499 | 0.4000 | ["75"] | ["1.1139"] | [] | ["XPHO"] | 75.0000 | 75.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0d3e7-f2c7-7590-bd73-8e941bf9b073 | TQQQ | 2026-09-24 10:53 | call_calendar | 2 | 1 | 100 | 461400.00 | unknown | ask | 77.1250 | 3.3000 | ["55"] | ["0.8011"] | [] | ["XPHO"] | 55.0000 | 55.0000 | 36 | 57 | false | false | true | false | |||||||||
| 01a0cfbf-9e07-7bc0-b8df-a2e50abacf19 | TQQQ | 2026-09-23 15:30 | call_calendar | 2 | 4 | 13 | 109408.00 | short | ask | 78.5400 | 3.2962 | ["40"] | ["0.7495"] | [] | ["ARCO","EMLD","SPHR","XPHO"] | 40.0000 | 40.0000 | 114 | 485 | false | false | true | false | |||||||||
| 01a0cfbd-e886-7972-8b0b-1047e6a08581 | TQQQ | 2026-09-23 15:28 | call_calendar | 2 | 3 | 15 | 126141.00 | short | ask | 78.5300 | 3.4500 | ["40"] | ["0.7337"] | [] | ["AMXO","XCBO"] | 40.0000 | 40.0000 | 114 | 485 | false | false | true | false | |||||||||
| 01a0cfbd-e49e-7502-8324-e0d3eabb4af0 | TQQQ | 2026-09-23 15:28 | call_calendar | 2 | 1 | 17 | 143089.00 | short | ask | 78.5300 | 3.4000 | ["40"] | ["0.7404"] | [] | ["XCBO"] | 40.0000 | 40.0000 | 114 | 485 | false | false | true | false | |||||||||
| 01a0c977-d82f-78b0-a0fc-d07ec3fb52b5 | TQQQ | 2026-09-22 10:14 | call_calendar | 2 | 1 | 125 | 171625.00 | short | ask | 80.3100 | 0.6500 | ["75"] | ["0.5284"] | [] | ["BATO"] | 75.0000 | 75.0000 | 10 | 24 | false | false | true | false | |||||||||
| 01a0c52b-616f-7f41-83cb-6f02fca664a2 | TQQQ | 2026-09-21 14:12 | call_calendar | 2 | 1 | 55 | 129250.00 | short | ask | 78.4900 | 1.2000 | ["67"] | ["0.4563"] | [] | ["XISX"] | 67.0000 | 67.0000 | 11 | 18 | false | false | true | false | |||||||||
| 01a0c4e3-30f7-78a3-88ee-79ea7df0fc05 | TQQQ | 2026-09-21 12:53 | call_calendar | 2 | 1 | 37 | 180338.00 | long | ask | 78.0900 | 0.8500 | ["55"] | ["0.7381"] | [] | ["BATO"] | 55.0000 | 55.0000 | 25 | 88 | false | false | true | false | |||||||||
| 01a0c4d8-a1d7-7dd3-80e4-9b74e154019e | TQQQ | 2026-09-21 12:42 | call_calendar | 2 | 1 | 40 | 179440.00 | unknown | ask | 78.1440 | 1.6000 | ["90"] | ["0.5881"] | [] | ["XMIO"] | 90.0000 | 90.0000 | 487 | 851 | false | true | true | false | |||||||||
| 01a0c435-8fbf-7211-80ff-6c5628fd9643 | TQQQ | 2026-09-21 09:43 | call_calendar | 2 | 1 | 20 | 100380.00 | unknown | ask | 75.6150 | 4.3000 | ["75"] | ["0.5737"] | [] | ["XPHO"] | 75.0000 | 75.0000 | 487 | 851 | false | false | true | false | |||||||||
| 01a0c435-8fbf-7211-80ff-6c4574dc0323 | TQQQ | 2026-09-21 09:43 | call_calendar | 2 | 1 | 20 | 100380.00 | unknown | ask | 75.6100 | 4.3000 | ["75"] | ["0.5738"] | [] | ["XPHO"] | 75.0000 | 75.0000 | 487 | 851 | false | false | true | false | |||||||||
| 01a0c435-8fbf-7211-80ff-6c36196c7497 | TQQQ | 2026-09-21 09:43 | call_calendar | 2 | 1 | 20 | 100380.00 | unknown | ask | 75.6100 | 4.3000 | ["75"] | ["0.5738"] | [] | ["XPHO"] | 75.0000 | 75.0000 | 487 | 851 | false | false | true | false | |||||||||
| 01a0c435-8bd7-7893-9381-7669456435e0 | TQQQ | 2026-09-21 09:43 | call_calendar | 2 | 1 | 20 | 100360.00 | unknown | ask | 75.6171 | 4.3000 | ["75"] | ["0.5735"] | [] | ["XPHO"] | 75.0000 | 75.0000 | 487 | 851 | false | false | true | false | |||||||||
| 01a0c435-8bd7-7893-9381-76580f995581 | TQQQ | 2026-09-21 09:43 | call_calendar | 2 | 1 | 20 | 100380.00 | unknown | ask | 75.6150 | 4.3000 | ["75"] | ["0.5737"] | [] | ["XPHO"] | 75.0000 | 75.0000 | 487 | 851 | false | false | true | false | |||||||||
| 01a0b5ff-6777-7650-a393-db29245e7648 | TQQQ | 2026-09-18 15:30 | call_calendar | 2 | 1 | 64 | 157440.00 | short | ask | 72.0100 | 1.1000 | ["60"] | ["0.5099"] | [] | ["XPHO"] | 60.0000 | 60.0000 | 14 | 21 | false | false | true | false | |||||||||
| 01a0b5ff-6777-7650-a393-db1c06a28643 | TQQQ | 2026-09-18 15:30 | call_calendar | 2 | 1 | 64 | 157440.00 | short | ask | 72.0100 | 1.1000 | ["60"] | ["0.5099"] | [] | ["XPHO"] | 60.0000 | 60.0000 | 14 | 21 | false | false | true | false | |||||||||
| 01a0b5ff-6777-7650-a393-db02505f7639 | TQQQ | 2026-09-18 15:30 | call_calendar | 2 | 1 | 64 | 157440.00 | short | ask | 72.0100 | 1.1000 | ["60"] | ["0.5099"] | [] | ["XPHO"] | 60.0000 | 60.0000 | 14 | 21 | false | false | true | false | |||||||||
| 01a0b5ff-6390-7ce2-886e-36b82a219cb1 | TQQQ | 2026-09-18 15:30 | call_calendar | 2 | 1 | 64 | 157440.00 | short | ask | 72.0150 | 1.1000 | ["60"] | ["0.5055"] | [] | ["XPHO"] | 60.0000 | 60.0000 | 14 | 21 | false | false | true | false | |||||||||
| 01a0b5ff-6390-7ce2-886e-36a592413ce1 | TQQQ | 2026-09-18 15:30 | call_calendar | 2 | 1 | 64 | 157440.00 | short | ask | 72.0150 | 1.1000 | ["60"] | ["0.5055"] | [] | ["XPHO"] | 60.0000 | 60.0000 | 14 | 21 | false | false | true | false | |||||||||
| 01a0a17b-e8e0-7420-bfb0-d7f9311498d2 | TQQQ | 2026-09-14 15:54 | call_calendar | 2 | 1 | 50 | 106900.00 | short | ask | 69.5800 | 0.5500 | ["60"] | ["0.6835"] | [] | ["XISX"] | 60.0000 | 60.0000 | 11 | 32 | false | false | true | false | |||||||||
| 01a0a17a-52a0-7771-b40b-140927265513 | TQQQ | 2026-09-14 15:52 | call_calendar | 2 | 1 | 50 | 106550.00 | short | ask | 69.6400 | 0.6500 | ["60"] | ["0.6539"] | [] | ["AMXO"] | 60.0000 | 60.0000 | 11 | 32 | false | false | true | false | |||||||||
| 01a0a162-0010-78e3-8e7b-7c809c5d390f | TQQQ | 2026-09-14 15:25 | call_calendar | 2 | 1 | 40 | 282560.00 | short | ask | 69.7950 | 1.8500 | ["35"] | ["2.1094"] | [] | ["XPHO"] | 35.0000 | 35.0000 | 4 | 95 | false | false | true | false | |||||||||
| 01a090c1-e978-7811-85b5-c7bd35b0baa1 | TQQQ | 2026-09-11 09:57 | call_calendar | 2 | 1 | 199 | 118604.00 | long | ask | 71.3150 | 0.3400 | ["69"] | ["0.7368"] | [] | ["BATO"] | 69.0000 | 69.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a086f5-36e8-71b1-ae72-25fd30b69e46 | TQQQ | 2026-09-09 12:16 | call_calendar | 2 | 1 | 90 | 162630.00 | short | ask | 71.1700 | 0.7500 | ["64"] | ["0.7118"] | [] | ["XMIO"] | 64.0000 | 64.0000 | 9 | 37 | false | false | true | false | |||||||||
| 01a086ec-45d8-7d32-aed2-a275b466ea24 | TQQQ | 2026-09-09 12:07 | call_calendar | 2 | 1 | 75 | 189825.00 | short | ask | 71.4950 | 0.6000 | ["60"] | ["0.7866"] | [] | ["BATO"] | 60.0000 | 60.0000 | 9 | 37 | false | false | true | false | |||||||||
| 01a086d0-5968-7060-bd6d-96d77f501c9a | TQQQ | 2026-09-09 11:36 | call_calendar | 2 | 1 | 40 | 174080.00 | short | ask | 71.4280 | 2.2500 | ["50"] | ["0.8824"] | [] | ["XISX"] | 50.0000 | 50.0000 | 9 | 37 | false | false | true | false | |||||||||
| 01a08152-ec58-7d72-95bf-e9f21e35d7c1 | TQQQ | 2026-09-08 10:01 | call_calendar | 2 | 1 | 200 | 192400.00 | long | ask | 71.7500 | 0.8500 | ["68"] | ["0.6927"] | [] | ["BATO"] | 68.0000 | 68.0000 | 3 | 10 | false | false | true | false | |||||||||
| 01a06d74-e935-7a33-a275-ec34a55cbc87 | TQQQ | 2026-09-04 13:26 | call_calendar | 2 | 1 | 32 | 175904.00 | short | ask | 72.0400 | 2.6500 | ["45"] | ["1.1278"] | [] | ["XISX"] | 45.0000 | 45.0000 | 14 | 42 | false | false | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T17:01:06Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T13:35:57Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:25:26Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:32:49Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:53:19Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:30:43Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:29:11Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:29:11Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:14:33Z"} |
| 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-21T18:12:57Z"} |
| 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-21T16:54:04Z"} |
| 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-21T16:42:14Z"} |
| 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-21T13:43:59Z"} |
| 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-21T13:43:59Z"} |
| 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-21T13:43:59Z"} |
| 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-21T13:43:59Z"} |
| 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-21T13:43:59Z"} |
| 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-18T19:30:24Z"} |
| 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-18T19:30:24Z"} |
| 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-18T19:30:24Z"} |
| 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-18T19:30:24Z"} |
| 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-18T19:30:24Z"} |
| 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-14T19:54:05Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:52:25Z"} |
| 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-14T19:26:10Z"} |
| 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-11T13:57:20Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:17:21Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:07:07Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:36:44Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:01:36Z"} |
| 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-04T17:26:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |