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 |
|---|
| 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 |
|---|
| 01a0d97a-996f-7eb1-90ce-546344c9fac2 | STX | 2026-09-25 12:51 | straddle | 2 | 3 | 7 | 85064.00 | long | ask | 915.9550 | 7.1429 | ["850"] | ["0.6421"] | ["728.48","971.52"] | ["MCRY","XISX","XPHO"] | 850.0000 | 850.0000 | 21 | 21 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T16:51:59Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d8ed-baee-7641-be68-fd45ea8c8772 | STX | 2026-09-25 10:17 | straddle | 2 | 1 | 3 | 52623.00 | long | ask | 906.8599 | 11.6000 | ["1050"] | ["0.6950"] | ["874.59","1225.41"] | ["EMLD"] | 1050.0000 | 1050.0000 | 21 | 21 | false | false | |||||||||||
| 01a0d3bf-9e8e-7d53-95d2-7187f2457142 | STX | 2026-09-24 10:09 | straddle | 2 | 1 | 14 | 113260.00 | long | ask | 919.0129 | 12.3000 | ["885"] | ["0.7129"] | ["804.10","965.90"] | ["ARCO"] | 885.0000 | 885.0000 | 8 | 8 | false | false | |||||||||||
| 01a0cf2a-7e3f-7c72-80a5-da8ebd0c028c | STX | 2026-09-23 12:47 | straddle | 2 | 2 | 12 | 101274.00 | long | ask | 917.6400 | 8.0000 | ["995"] | ["0.9102"] | ["910.60","1079.40"] | ["ARCO","EMLD"] | 995.0000 | 995.0000 | 2 | 2 | false | false | |||||||||||
| 01a0cec7-864f-7993-8aa0-7de47b43207e | STX | 2026-09-23 10:59 | straddle | 2 | 1 | 2 | 28150.00 | long | ask | 911.1300 | 2.4000 | ["970"] | ["0.7092"] | ["829.25","1110.75"] | ["XMIO"] | 970.0000 | 970.0000 | 23 | 23 | false | false | |||||||||||
| 01a0cec7-864f-7993-8aa0-7dcaf76e425d | STX | 2026-09-23 10:59 | straddle | 2 | 3 | 3 | 38625.00 | short | bid | 911.1300 | 2.7333 | ["920"] | ["0.7033"] | ["791.25","1048.75"] | ["EMLD","MCRY"] | 920.0000 | 920.0000 | 23 | 23 | false | false | |||||||||||
| 01a0ce8b-86ef-7191-85c3-06c5eb887997 | STX | 2026-09-23 09:54 | straddle | 2 | 1 | 7 | 94395.00 | long | ask | 901.1400 | 4.2000 | ["940"] | ["0.7159"] | ["805.15","1074.85"] | ["XPHO"] | 940.0000 | 940.0000 | 23 | 23 | false | false | |||||||||||
| 01a0ce8b-86ef-7191-85c3-06adc7c09e7e | STX | 2026-09-23 09:54 | straddle | 2 | 3 | 3 | 38933.00 | long | ask | 903.6978 | 4.7500 | ["905"] | ["0.7183"] | ["775.22","1034.78"] | ["AMXO","ARCO","EMLD"] | 905.0000 | 905.0000 | 23 | 23 | false | false | |||||||||||
| 01a0cab2-fbf6-7f03-b4cc-20376693238c | STX | 2026-09-22 15:58 | straddle | 2 | 1 | 30 | 400800.00 | long | ask | 919.4200 | 21.1000 | ["910"] | ["0.7140"] | ["776.40","1043.60"] | ["AMXO"] | 910.0000 | 910.0000 | 24 | 24 | false | false | |||||||||||
| 01a0c96e-f6be-7d72-8433-b1041f3c3cfc | STX | 2026-09-22 10:04 | straddle | 2 | 1 | 2 | 26940.00 | short | bid | 919.0978 | 24.2000 | ["920"] | ["0.7179"] | ["785.30","1054.70"] | ["XCBO"] | 920.0000 | 920.0000 | 24 | 24 | false | false | |||||||||||
| 01a0c4c0-ef6f-7d53-82dd-f9ba9bbaf94e | STX | 2026-09-21 12:16 | straddle | 2 | 2 | 3 | 124218.00 | short | bid | 872.9000 | 13.5000 | ["1200"] | ["0.7086"] | ["785.94","1614.06"] | ["ARCO","XISX"] | 1200.0000 | 1200.0000 | 116 | 116 | false | false | |||||||||||
| 01a0c4c0-ef6f-7d53-82dd-f9a322d16ade | STX | 2026-09-21 12:16 | straddle | 2 | 4 | 4 | 165624.00 | short | bid | 872.5833 | 14.1000 | ["1200"] | ["0.7082"] | ["785.94","1614.06"] | ["AMXO","XBOX","XCBO","XPHO"] | 1200.0000 | 1200.0000 | 116 | 116 | false | false | |||||||||||
| 01a0c4bc-441f-7772-a5dc-e7c4d009a8d0 | STX | 2026-09-21 12:11 | straddle | 2 | 1 | 3 | 124422.00 | short | bid | 871.0800 | 10.3000 | ["1200"] | ["0.7084"] | ["785.26","1614.74"] | ["XISX"] | 1200.0000 | 1200.0000 | 116 | 116 | false | false | |||||||||||
| 01a0c4bc-4037-7082-a2f3-72cacdaf452b | STX | 2026-09-21 12:11 | straddle | 2 | 2 | 4 | 165896.00 | short | bid | 871.0800 | 10.9000 | ["1200"] | ["0.7084"] | ["785.26","1614.74"] | ["XCBO","XPHO"] | 1200.0000 | 1200.0000 | 116 | 116 | false | false | |||||||||||
| 01a08c11-e270-7652-aeb5-c764a4776ecb | STX | 2026-09-10 12:06 | straddle | 2 | 5 | 12 | 35352.00 | long | ask | 855.1285 | 2.1000 | ["860"] | ["0.8157"] | ["830.54","889.46"] | ["AMXO","SPHR","XCBO","XPHO"] | 860.0000 | 860.0000 | 1 | 1 | false | false | |||||||||||
| 01a0826d-ab28-7212-bf0b-99fd7dc38c88 | STX | 2026-09-08 15:10 | straddle | 2 | 3 | 3 | 87000.00 | short | bid | 918.9100 | 16.9333 | ["900"] | ["0.7667"] | ["610","1190.00"] | ["XCBO","XPHO"] | 900.0000 | 900.0000 | 101 | 101 | false | false | |||||||||||
| 01a0826d-ab28-7212-bf0b-99ea929565be | STX | 2026-09-08 15:10 | straddle | 2 | 4 | 5 | 145052.00 | long | ask | 918.9100 | 16.3600 | ["900"] | ["0.7670"] | ["609.90","1190.10"] | ["ARCO","XCBO","XPHO"] | 900.0000 | 900.0000 | 101 | 101 | false | false | |||||||||||
| 01a0826d-ab28-7212-bf0b-99bed39c5648 | STX | 2026-09-08 15:10 | straddle | 2 | 2 | 2 | 58000.00 | short | bid | 918.9100 | 17.1000 | ["900"] | ["0.7667"] | ["610","1190.00"] | ["XCBO","XPHO"] | 900.0000 | 900.0000 | 101 | 101 | false | false |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:17:38Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:09:24Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:47:54Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:59:54Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:59:54Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:54:07Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:54:07Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:58:56Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:04:53Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:16:28Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:16:28Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:11:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:11:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:06:52Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:10:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:10:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:10:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |