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_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 |
|---|
| 01a06dd1-97c6-7211-b40e-57fa1fcbd42f | SPOT | 2026-09-04 15:07 | call_diagonal_spread_bearish | 2 | 1 | 26 | 189660.00 | long | ask | 545.6400 | 8.9000 | ["510","515"] | ["5.6685","0.3501"] | [] | ["XMIO"] | 510.0000 | 515.0000 | 0 | 21 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:07:50Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd6-857d-7760-beb3-4acdf50a94f2 | SPOT | 2026-09-04 15:12 | put_vertical_spread | 2 | 1 | 39 | 1214460.00 | long | ask | 545.6800 | 15.0000 | ["690","720"] | ["0.8934","1.0100"] | ["0","690"] | ["XBOX"] | 690.0000 | 720.0000 | 14 | 14 | false | false | false | true | |||||||||
| 01a06dfc-d616-7363-9aa8-48f42a696fbb | SPOT | 2026-09-04 15:54 | put_vertical_spread | 2 | 1 | 39 | 1260246.00 | long | ask | 542.6900 | 12.9000 | ["690","720"] | ["0.5413","0.6348"] | ["0","690"] | ["XPHO"] | 690.0000 | 720.0000 | 14 | 14 | false | false | false | true | |||||||||
| 01a081e8-5a40-7331-830a-e586fbe73b5a | SPOT | 2026-09-08 12:44 | call_calendar | 2 | 1 | 3 | 110379.00 | long | bid | 529.4150 | 13.5500 | ["350"] | ["0.8018"] | [] | ["XMIO"] | 350.0000 | 350.0000 | 10 | 129 | false | false | true | false | |||||||||
| 01a081e8-5a40-7331-830a-e570e39310ff | SPOT | 2026-09-08 12:44 | call_calendar | 2 | 2 | 5 | 192315.00 | long | bid | 529.4150 | 14.1000 | ["340"] | ["1.1632"] | [] | ["ARCO"] | 340.0000 | 340.0000 | 10 | 101 | false | false | true | false | |||||||||
| 01a086e5-bdf9-7ec0-abbc-792cbc259ba7 | SPOT | 2026-09-09 11:59 | straddle | 2 | 1 | 12 | 201600.00 | long | ask | 529.5500 | 4.0500 | ["560"] | ["0.4498"] | ["392","728.00"] | ["C2OX"] | 560.0000 | 560.0000 | 281 | 281 | false | false | false | false | |||||||||
| 01a086ea-da90-7711-a231-67dba9222760 | SPOT | 2026-09-09 12:05 | straddle | 2 | 1 | 10 | 167900.00 | long | ask | 528.4900 | 5.1500 | ["560"] | ["0.4499"] | ["392.10","727.90"] | ["C2OX"] | 560.0000 | 560.0000 | 281 | 281 | false | false | false | false | |||||||||
| 01a0a05e-18e8-7bb1-8758-f8a3d3e16ad7 | SPOT | 2026-09-14 10:41 | call_calendar | 2 | 5 | 20 | 841600.00 | long | ask | 545.7700 | 9.0450 | ["340"] | ["1.3980"] | [] | ["AMXO","ARCO","EDGO","XCBO","XISX"] | 340.0000 | 340.0000 | 4 | 123 | false | false | true | false | |||||||||
| 01a0a05e-18e8-7bb1-8758-f8999f8529f7 | SPOT | 2026-09-14 10:41 | call_calendar | 2 | 2 | 10 | 420280.00 | long | ask | 545.7700 | 12.2750 | ["340"] | ["1.3206"] | [] | ["XPHO"] | 340.0000 | 340.0000 | 4 | 123 | false | false | true | false | |||||||||
| 01a0a0bd-9638-7031-9eed-910d14bbd53f | SPOT | 2026-09-14 12:26 | call_diagonal_spread | 2 | 1 | 12 | 118272.00 | long | bid | 553.6150 | 8.4500 | ["500","520"] | ["0.6870","0.3795"] | [] | ["BATO"] | 500.0000 | 520.0000 | 4 | 32 | false | false | true | true | |||||||||
| 01a0c4a0-f3ee-7fe3-9935-32d4bd39bb69 | SPOT | 2026-09-21 11:41 | call_vertical_spread | 2 | 1 | 14 | 123522.00 | long | ask | 513.8550 | 8.3500 | ["520","540"] | ["0.4170","0.4144"] | ["528.67"] | ["XPHO"] | 520.0000 | 540.0000 | 116 | 116 | false | true | false | true | |||||||||
| 01a0c519-9aa7-7913-a73e-e3038f5d39e6 | SPOT | 2026-09-21 13:53 | put_vertical_spread | 2 | 1 | 4 | 103480.00 | long | ask | 515.5450 | 10.0000 | ["645","647.5"] | ["1.2722","1.2720"] | ["645.02"] | ["XISX"] | 645.0000 | 647.5000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c523-0c9f-7fd3-8301-510551a8bedc | SPOT | 2026-09-21 14:03 | call_vertical_spread | 2 | 1 | 6 | 178800.00 | long | ask | 515.9150 | 7.0000 | ["365","370"] | ["1.5524","1.5078"] | ["369.98"] | ["XPHO"] | 365.0000 | 370.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c527-98af-7a71-9a79-411e5c6cb8f7 | SPOT | 2026-09-21 14:08 | call_vertical_spread | 2 | 1 | 6 | 178794.00 | long | ask | 516.1700 | 7.0000 | ["365","370"] | ["1.3614","1.3404"] | ["369.97"] | ["XMIO"] | 365.0000 | 370.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c52d-de27-7300-9df9-2985eafa4016 | SPOT | 2026-09-21 14:15 | call_vertical_spread | 2 | 1 | 6 | 166008.00 | long | ask | 515.1100 | 11.5000 | ["375","380"] | ["1.5041","1.4566"] | ["379.98"] | ["XCBO"] | 375.0000 | 380.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c535-38f6-7003-902d-d9128dc63f08 | SPOT | 2026-09-21 14:23 | call_vertical_spread | 2 | 1 | 4 | 126684.00 | long | ask | 515.8900 | 7.2000 | ["355","360"] | ["2.0637","2.0220"] | ["359.99"] | ["XCBO"] | 355.0000 | 360.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c539-0986-7732-907a-35da186975ac | SPOT | 2026-09-21 14:27 | call_vertical_spread | 2 | 1 | 5 | 158350.00 | long | ask | 515.9500 | 7.2000 | ["355","360"] | ["2.0489","2.0080"] | ["359.98"] | ["XPHO"] | 355.0000 | 360.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c542-1dbf-7671-bc6e-6ff735768f9d | SPOT | 2026-09-21 14:37 | put_vertical_spread | 2 | 1 | 10 | 280920.00 | long | ask | 516.0300 | 10.0000 | ["655","657.5"] | ["1.1207","1.1293"] | ["655.02"] | ["XCBO"] | 655.0000 | 657.5000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c545-7d07-7971-8f00-cf37792519bf | SPOT | 2026-09-21 14:40 | put_vertical_spread | 2 | 1 | 4 | 112368.00 | long | ask | 516.2950 | 10.0000 | ["655","657.5"] | ["1.1936","1.2043"] | ["655.02"] | ["XCBO"] | 655.0000 | 657.5000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c559-ef66-73b1-8fb9-f3d6c1964fee | SPOT | 2026-09-21 15:03 | call_vertical_spread | 2 | 1 | 6 | 166446.00 | long | ask | 516.9300 | 9.6000 | ["375","380"] | ["1.7920","1.7521"] | ["379.99"] | ["XCBO"] | 375.0000 | 380.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c9d3-afe6-7292-b433-13bc9db35177 | SPOT | 2026-09-22 11:54 | call_vertical_spread | 2 | 1 | 6 | 188916.00 | long | ask | 509.0700 | 9.7000 | ["350","355"] | ["2.0995","2.0384"] | ["354.98"] | ["XCBO"] | 350.0000 | 355.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0c9db-f12e-7be3-a303-7f9873685a40 | SPOT | 2026-09-22 12:03 | put_vertical_spread | 2 | 1 | 5 | 150325.00 | long | ask | 508.7300 | 16.3000 | ["657.5","660"] | ["1.3741","1.3872"] | ["657.51"] | ["XCBO"] | 657.5000 | 660.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0c9e4-3277-7f52-bdfe-175e99e41205 | SPOT | 2026-09-22 12:12 | put_vertical_spread | 2 | 1 | 10 | 290030.00 | long | ask | 509.1800 | 15.8500 | ["652.5","655"] | ["1.3858","1.4002"] | ["652.51"] | ["XMIO"] | 652.5000 | 655.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca02-0efe-7f20-bd14-478d116569d9 | SPOT | 2026-09-22 12:45 | put_vertical_spread | 2 | 1 | 4 | 119084.00 | long | ask | 507.0000 | 16.4000 | ["655","657.5"] | ["2.0300","2.0391"] | ["655.03"] | ["BATO"] | 655.0000 | 657.5000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca19-f817-75a0-bc56-2281a280640a | SPOT | 2026-09-22 13:11 | put_vertical_spread | 2 | 1 | 6 | 156216.00 | long | ask | 504.8700 | 11.8500 | ["635","637.5"] | ["1.6041","1.6079"] | ["635.02"] | ["XMIO"] | 635.0000 | 637.5000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca1f-ef6f-7fe3-a76a-83ca67a1f285 | SPOT | 2026-09-22 13:18 | straddle | 2 | 2 | 14 | 133014.00 | long | ask | 505.3300 | 8.1500 | ["500"] | ["0.4237"] | ["404.99","595.01"] | ["MCRY","SPHR"] | 500.0000 | 500.0000 | 115 | 115 | false | false | false | false | |||||||||
| 01a0ca2d-fd16-7143-9840-7b2d19104a29 | SPOT | 2026-09-22 13:33 | put_vertical_spread | 2 | 1 | 4 | 114884.00 | long | ask | 503.0800 | 10.8000 | ["647.5","650"] | ["1.4792","1.4681"] | ["647.53"] | ["BATO"] | 647.5000 | 650.0000 | 3 | 3 | false | false | false | true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:12:56Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:44:55Z"} |
| 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-08T16:44:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:00:05Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:06:11Z"} |
| 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-14T14:41: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-14T14:41: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-14T16:26:41Z"} |
| 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-21T15:41:38Z"} |
| 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-21T17:53:08Z"} |
| 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-21T18:03:40Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:08:20Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:15:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:23:27Z"} |
| 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-21T18:27:43Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:37:40Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:41:08Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:03:34Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:55:12Z"} |
| 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-22T16:04:32Z"} |
| 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-22T16:13:16Z"} |
| 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-22T16:45:47Z"} |
| 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-22T17:11:48Z"} |
| 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-22T17:18:49Z"} |
| 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-22T17:33:38Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |