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_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 |
|---|
| 01a0c4b3-148f-77f3-926f-1784ab2c2b7e | AAOI | 2026-09-21 12:01 | call_vertical_spread | 2 | 1 | 500 | 1822500.00 | long | ask | 108.5250 | 4.7000 | ["90","92"] | ["1.3426","1.2998"] | ["91.85"] | ["XMIO"] | 90.0000 | 92.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:01:31Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b542-2257-7cc1-bd8b-bba22c730c1c | AAOI | 2026-09-18 12:03 | other | 4 | 7 | 27 | 129922.00 | unknown | ask | 101.1800 | 3.0500 | ["90","150","200"] | ["0.9353","0.9629","0.9868"] | [] | ["ARCO","EMLD","MCRY","SPHR","XISX","XMIO","XPHO"] | 90.0000 | 200.0000 | 91 | 182 | false | true | true | true | |||||||||
| 01a0b542-2257-7cc1-bd8b-bb9af9c81be7 | AAOI | 2026-09-18 12:03 | other | 4 | 9 | 38 | 182946.00 | unknown | ask | 101.1800 | 3.0500 | ["90","150","200"] | ["0.9338","0.9646","0.9903"] | [] | ["AMXO","ARCO","EMLD","MCRY","SPHR","XBOX","XISX","XMIO","XPHO"] | 90.0000 | 200.0000 | 91 | 182 | false | true | true | true | |||||||||
| 01a0b082-4cb3-7ab2-b35c-074df146ebde | AAOI | 2026-09-17 13:55 | call_vertical_spread | 2 | 1 | 44 | 589116.00 | long | ask | 98.1950 | 2.6000 | ["31","32"] | ["10.8083","10.7298"] | ["31.97"] | ["XMIO"] | 31.0000 | 32.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0af8f-6135-74e1-a302-3e22f01978ca | AAOI | 2026-09-17 09:30 | call_vertical_spread | 2 | 1 | 50 | 185450.00 | long | ask | 100.7200 | 4.8000 | ["80","85"] | ["2.7151","2.2309"] | ["84.93"] | ["XISX"] | 80.0000 | 85.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0a5cc-bfee-7580-acec-40304babcf1b | AAOI | 2026-09-15 12:00 | call_vertical_spread | 2 | 1 | 90 | 363060.00 | long | ask | 96.2800 | 1.6000 | ["80","110"] | ["0.9382","0.9522"] | ["92.50"] | ["MCRY"] | 80.0000 | 110.0000 | 94 | 94 | false | false | false | true | |||||||||
| 01a0a069-7af9-7a52-958e-843ff7ba8a54 | AAOI | 2026-09-14 10:54 | put_diagonal_spread | 2 | 8 | 20 | 105982.00 | long | ask | 96.8000 | 1.7000 | ["100","110"] | ["0.9618","0.9499"] | [] | ["AMXO","ARCO","EDGO","XBOX","XCBO","XISX","XMIO","XPHO"] | 100.0000 | 110.0000 | 95 | 186 | false | false | true | ||||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:03:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:03:25Z"} |
| 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-17T17:56:03Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:30:02Z"} |
| 2026-09-17 |
| 2026-09-17 17:27 |
| 2026-09-17 17:27 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:01:16Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:54:56Z"} |
| 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-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 |
| 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 |
| mlet |
| 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 |