Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5f6-ad18-7633-b842-a0a32f465d1a | LITE | 2026-09-18 15:20 | put_frontspread | 2 | 1 | 3 | 135455.00 | long | ask | 925.7301 | 21.4000 | ["860","1160"] | ["0.7647","0.7764"] | ["456.61","1061.70"] | ["XPHO"] | 860.0000 | 1160.0000 | 301 | 301 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:20:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5f6-6e97-7111-af0d-3bebc13a65e9 | LITE | 2026-09-18 15:20 | put_frontspread | 2 | 1 | 3 | 135724.00 | long | ask | 926.5400 | 21.4000 | ["860","1160"] | ["0.7673","0.7793"] | ["456.30","1061.85"] | ["XCBO"] | 860.0000 | 1160.0000 | 301 | 301 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:20:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aab8-55e3-71c1-804d-8a1740088f50 | LITE | 2026-09-16 10:56 | put_frontspread | 2 | 1 | 4 | 148476.00 | long | ask | 899.2900 | 26.7000 | ["780","1180"] | ["0.7726","0.7941"] | ["480.18","1079.82"] | ["BATO"] | 780.0000 | 1180.0000 | 303 | 303 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:57:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a547-3c3e-7d31-a1cd-98e404f6dde9 | LITE | 2026-09-15 09:35 | put_frontspread | 2 | 1 | 40 | 509500.00 | long | ask | 848.3300 | 15.8000 | ["530","900"] | ["0.7885","0.7674"] | ["288.93","771.07"] | ["AMXO"] | 530.0000 | 900.0000 | 157 | 157 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:35:08Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a090da-b138-7802-b840-f57d3d5db8ac | LITE | 2026-09-11 10:24 | put_frontspread | 2 | 1 | 20 | 758460.00 | long | ask | 943.2289 | 24.3000 | ["780","1280"] | ["0.7826","0.8057"] | ["460.18","1099.82"] | ["XPHO"] | 780.0000 | 1280.0000 | 279 | 279 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:24:07Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090da-8640-7691-890e-4854efea75d9 | LITE | 2026-09-11 10:23 | put_frontspread | 2 | 1 | 20 | 758530.00 | long | ask | 942.4950 | 24.7000 | ["780","1280"] | ["0.7821","0.8045"] | ["460.05","1099.95"] | ["XPHO"] | 780.0000 | 1280.0000 | 279 | 279 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:24:07Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090da-6ed1-7511-94d3-583ce49cd4a3 | LITE | 2026-09-11 10:23 | put_frontspread | 2 | 1 | 20 | 724500.00 | long | ask | 943.5250 | 19.5000 | ["760","1260"] | ["0.7828","0.8069"] | ["444.90","1075.10"] | ["XPHO"] | 760.0000 | 1260.0000 | 279 | 279 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:24:07Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090da-5760-7031-b0e9-35fb0b609524 | LITE | 2026-09-11 10:23 | put_frontspread | 2 | 1 | 20 | 724830.00 | long | ask | 943.7150 | 22.7000 | ["760","1260"] | ["0.7843","0.8061"] | ["443.87","1076.13"] | ["XPHO"] | 760.0000 | 1260.0000 | 279 | 279 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:24:07Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090c7-15b0-76e2-8263-5140c2fabfa8 | LITE | 2026-09-11 10:02 | put_frontspread | 2 | 1 | 60 | 340770.00 | long | ask | 934.2000 | 10.8000 | ["470","690"] | ["0.8015","0.7728"] | ["285.99","654.01"] | ["XPHO"] | 470.0000 | 690.0000 | 189 | 189 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:02:39Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090c6-fa58-7471-bf62-a4229639b101 | LITE | 2026-09-11 10:02 | put_frontspread | 2 | 1 | 60 | 337350.00 | long | ask | 932.8750 | 10.8000 | ["470","690"] | ["0.8011","0.7647"] | ["284.65","655.35"] | ["AMXO"] | 470.0000 | 690.0000 | 189 | 189 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:02:39Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08be5-b1f1-7743-83fb-8f96b4f0d80b | LITE | 2026-09-10 11:17 | put_frontspread | 2 | 1 | 60 | 265440.00 | long | ask | 964.3500 | 14.0000 | ["725","895"] | ["0.7577","0.7252"] | ["585.98","864.02"] | ["AMXO"] | 725.0000 | 895.0000 | 43 | 43 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:18:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b9d-cbb1-7b61-95e2-eb34e86fd695 | LITE | 2026-09-10 09:59 | put_frontspread | 2 | 1 | 50 | 403250.00 | long | ask | 973.3009 | 14.7000 | ["440","660"] | ["0.8174","0.7897"] | ["253.06","626.94"] | ["AMXO"] | 440.0000 | 660.0000 | 309 | 309 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:59:43Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8e-2bb0-7041-8677-35e69f3e47f9 | LITE | 2026-09-10 09:42 | put_frontspread | 2 | 1 | 42 | 963207.00 | long | ask | 981.6450 | 20.7000 | ["780","1180"] | ["0.7942","0.8056"] | ["531.23","1028.77"] | ["XPHO"] | 780.0000 | 1180.0000 | 127 | 127 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:42:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8e-1058-71a2-b2d0-c535c49c525b | LITE | 2026-09-10 09:42 | put_frontspread | 2 | 1 | 60 | 1363320.00 | long | ask | 981.7700 | 22.4000 | ["780","1180"] | ["0.7896","0.7946"] | ["530.26","1029.74"] | ["AMXO"] | 780.0000 | 1180.0000 | 127 | 127 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:42:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08184-7021-7d01-8ae0-181b155e1d84 | LITE | 2026-09-08 10:55 | put_frontspread | 2 | 1 | 14 | 134701.00 | long | ask | 973.9550 | 20.2000 | ["570","820"] | ["0.8456","0.8287"] | ["370.27","769.73"] | ["XPHO"] | 570.0000 | 820.0000 | 164 | 164 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:55:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08184-5c98-7f31-84b5-b75dcdb63e04 | LITE | 2026-09-08 10:55 | put_frontspread | 2 | 1 | 36 | 346086.00 | long | ask | 974.9984 | 20.2000 | ["570","820"] | ["0.8452","0.8307"] | ["370.75","769.25"] | ["XPHO"] | 570.0000 | 820.0000 | 164 | 164 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:55:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08184-2db8-75e1-b651-9acd5d80a71b | LITE | 2026-09-08 10:55 | put_frontspread | 2 | 1 | 50 | 481525.00 | long | ask | 975.5201 | 20.2000 | ["570","820"] | ["0.8501","0.8280"] | ["368.97","771.03"] | ["AMXO"] | 570.0000 | 820.0000 | 164 | 164 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:55:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |