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 | 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 |
|---|
| 01a09207-5611-7511-8bf2-4fd577a2ee15 | AAOI | 2026-09-11 15:52 | iron_butterfly | 4 | 1 | 88 | 106128.00 | short | ask | 105.7000 | 2.5500 | ["96","105","114"] | ["0.7538","0.7884","0.8129"] | ["98.68","111.32"] | ["XCBO"] | 96.0000 | 114.0000 | 7 | 7 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:52:34Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091a8-f9d1-7502-a279-ac8069a3fe80 | AAOI | 2026-09-11 14:09 | put_vertical_spread | 2 | 1 | 169 | 142636.00 | long | ask | 105.8400 | 0.7500 | ["95","105"] | ["0.8043","0.8093"] | ["101.10"] | ["XISX"] | 95.0000 | 105.0000 | 14 | 14 | false | true | false | true | |||||||||
| 01a09102-e631-7752-8e94-a20497ed22e1 | AAOI | 2026-09-11 11:07 | call_diagonal_spread | 2 | 1 | 10 | 128100.00 | long | ask | 105.3650 | 4.7000 | ["42","70"] | ["3.4024","1.0045"] | [] | ["XPHO"] | 42.0000 | 70.0000 | 7 | 644 | false | false | true | true | false | ||||||||
| 01a08ca9-ffd8-71d1-9b0e-8ec355cb460f | AAOI | 2026-09-10 14:52 | call_diagonal_spread | 2 | 1 | 15 | 178950.00 | long | ask | 103.4400 | 3.8000 | ["45","65"] | ["3.1020","1.0062"] | [] | ["AMXO"] | 45.0000 | 65.0000 | 8 | 498 | false | false | true | true | false | ||||||||
| 01a08c7c-d940-77c0-ba82-562197461c86 | AAOI | 2026-09-10 14:03 | put_vertical_spread | 2 | 1 | 188 | 1718132.00 | long | ask | 103.6200 | 2.6000 | ["149","150"] | ["4.1641","4.0571"] | ["149.01"] | ["XISX"] | 149.0000 | 150.0000 | 1 | 1 | true | false | false | true | |||||||||
| 01a08291-05f1-76f0-9984-cff5f8bb0643 | AAOI | 2026-09-08 15:48 | put_vertical_spread | 2 | 1 | 99 | 723393.00 | long | ask | 111.9650 | 3.1000 | ["148","149"] | ["1.3180","1.3107"] | ["148.01"] | ["XCBO"] | 148.0000 | 149.0000 | 3 | 3 | true | false | false | true | |||||||||
| 01a08290-36e9-7793-b107-2b7d76955567 | AAOI | 2026-09-08 15:48 | put_vertical_spread | 2 | 1 | 88 | 638440.00 | long | ask | 112.0800 | 4.5000 | ["148","149"] | ["2.2400","2.2789"] | ["148.01"] | ["XMIO"] | 148.0000 | 149.0000 | 3 | 3 | true | false | false | true | |||||||||
| 01a0828f-3519-7091-8207-1e14a947db75 | AAOI | 2026-09-08 15:46 | call_vertical_spread | 2 | 1 | 99 | 752103.00 | long | ask | 112.3400 | 5.3000 | ["74","75"] | ["2.1947","2.1577"] | ["74.99"] | ["EDGO"] | 74.0000 | 75.0000 | 3 | 3 | true | false | false | true | false | ||||||||
| 01a0828e-e311-7363-9c4f-761807b50ce5 | AAOI | 2026-09-08 15:46 | call_vertical_spread | 2 | 1 | 28 | 212716.00 | long | ask | 112.2600 | 5.3000 | ["74","75"] | ["2.3768","2.3286"] | ["74.99"] | ["XCBO"] | 74.0000 | 75.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a0828e-e311-7363-9c4f-7603b29fcb39 | AAOI | 2026-09-08 15:46 | call_vertical_spread | 2 | 1 | 60 | 455820.00 | long | ask | 112.2600 | 5.3000 | ["74","75"] | ["2.3768","2.3286"] | ["74.99"] | ["XCBO"] | 74.0000 | 75.0000 | 3 | 3 | true | false | false | true | false | ||||||||
| 01a0821f-a298-7d50-8c5d-064190ce1521 | AAOI | 2026-09-08 13:45 | put_diagonal_spread | 2 | 1 | 63 | 125055.00 | long | ask | 113.4400 | 1.5000 | ["115","118"] | ["0.9447","0.9783"] | [] | ["BATO"] | 115.0000 | 118.0000 | 10 | 17 | false | false | true | true | false | ||||||||
| 01a08180-bed1-7f02-9be0-8e4e98e65dd0 | AAOI | 2026-09-08 10:51 | put_calendar | 2 | 1 | 45 | 359550.00 | long | ask | 116.5201 | 3.9000 | ["145"] | ["1.0123"] | [] | ["XISX"] | 145.0000 | 145.0000 | 38 | 129 | false | false | true | false | false | ||||||||
| 01a06df4-eea5-7d53-b75d-18f7f20a6f8f | AAOI | 2026-09-04 15:46 | put_diagonal_spread_bullish | 2 | 1 | 63 | 190890.00 | long | ask | 105.1900 | 2.2000 | ["118","119"] | ["0.8698","0.8679"] | [] | ["BATO"] | 118.0000 | 119.0000 | 7 | 14 | false | false | true | true | |||||||||
| 01a06d98-057d-7231-8c32-be3427d355d8 | AAOI | 2026-09-04 14:04 | put_vertical_spread | 2 | 1 | 188 | 1644248.00 | long | ask | 104.1867 | 4.3000 | ["148","149"] | ["14.0510","14.2583"] | ["0","148"] | ["XCBO"] | 148.0000 | 149.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a06d86-bbb5-7aa3-931d-acdc9bcb7676 | AAOI | 2026-09-04 13:45 | put_vertical_spread | 2 | 1 | 99 | 737055.00 | long | ask | 104.3650 | 5.0000 | ["142","143"] | ["11.1288","10.6877"] | ["142.01"] | ["XISX"] | 142.0000 | 143.0000 | 0 | 0 | true | false | false | true | |||||||||
| 01a06d84-71c5-7f02-80b9-576f345e61c5 | AAOI | 2026-09-04 13:43 | put_vertical_spread | 2 | 1 | 195 | 1567995.00 | long | ask | 104.4500 | 5.3000 | ["145","146"] | ["12.5530","12.2513"] | ["145.01"] | ["XISX"] | 145.0000 | 146.0000 | 0 | 0 | true | false | false | true | |||||||||
| 01a06d83-ecf5-7f31-b711-671a2e81bc4b | AAOI | 2026-09-04 13:42 | put_vertical_spread | 2 | 1 | 188 | 1626388.00 | long | ask | 104.5950 | 5.5000 | ["148","149"] | ["14.1421","13.9305"] | ["148.01"] | ["XISX"] | 148.0000 | 149.0000 | 0 | 0 | true | false | false | true | |||||||||
| 01a06d83-0295-7e13-84af-8ff0f3a5124d | AAOI | 2026-09-04 13:41 | call_vertical_spread | 2 | 1 | 99 | 547569.00 | long | ask | 104.5653 | 5.9000 | ["77","78"] | ["12.8292","12.4422"] | ["77.99"] | ["XISX"] | 77.0000 | 78.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a06d82-9535-7282-8cbc-e19e8a4176e7 | AAOI | 2026-09-04 13:41 | call_vertical_spread | 2 | 1 | 88 | 486728.00 | long | ask | 104.6300 | 5.9000 | ["77","78"] | ["12.4873","12.1125"] | ["77.99"] | ["XISX"] | 77.0000 | 78.0000 | 0 | 0 | true | false | false | true | |||||||||
| 01a06d81-f50d-7260-8e61-2beccfe423de | AAOI | 2026-09-04 13:40 | call_vertical_spread | 2 | 1 | 99 | 643599.00 | long | ask | 104.5820 | 5.3000 | ["72","73"] | ["13.9803","13.6140"] | ["72.99"] | ["XISX"] | 72.0000 | 73.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a06d81-a6ed-7c81-b045-439d95570fc3 | AAOI | 2026-09-04 13:40 | call_vertical_spread | 2 | 1 | 88 | 572088.00 | long | ask | 104.6650 | 5.3000 | ["72","73"] | ["13.3846","13.0418"] | ["72.99"] | ["XISX"] | 72.0000 | 73.0000 | 0 | 0 | true | false | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:09:31Z"} |
| 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-11T15:08:00Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:52:38Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:03:31Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:49:20Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:48:11Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:47:02Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:47:02Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:47: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-08T17:45:45Z"} |
| 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-08T14:51:52Z"} |
| 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-04T19:46:04Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:05:06Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:45:59Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:43:44Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:43:01Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:41:43Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:41:43Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:40:51Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:40:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |