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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b03f-11c2-7b71-820b-dd7cd015ef3a | TLT | 2026-09-17 12:41 | straddle | 2 | 1 | 600 | 232200.00 | long | ask | 81.6650 | 0.0200 | ["82"] | ["0.1179"] | ["78.13","85.87"] | ["AMXO"] | 82.0000 | 82.0000 | 92 | 92 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:42:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab01-41db-7510-aeec-3e4bb1899eb5 | TLT | 2026-09-16 12:16 | call_ratio_spread | 2 | 1 | 16700 | 2404800.00 | long | ask | 81.1299 | 0.0800 | ["90","103"] | ["0.0771","0.1225"] | ["90.26","115.74"] | ["XBOX"] | 90.0000 | 103.0000 | 492 | 492 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:16:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5bc-29d6-7e63-9be4-95a8af6c00ca | TLT | 2026-09-15 11:42 | call_diagonal_spread | 2 | 2 | 1000 | 372000.00 | long | ask | 80.8350 | 0.1000 | ["85","88"] | ["0.0858","0.0726"] | [] | ["ARCO"] | 85.0000 | 88.0000 | 275 | 493 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:43:20Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5bb-1866-7842-97c5-6ef2a896a99f | TLT | 2026-09-15 11:41 | call_diagonal_spread | 2 | 1 | 7000 | 2604000.00 | long | ask | 80.8180 | 0.1000 | ["85","88"] | ["0.0860","0.0728"] | [] | ["ARCO"] | 85.0000 | 88.0000 | 275 | 493 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:41:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a15e-46f0-7291-b201-507f11d7260b | TLT | 2026-09-14 15:21 | straddle | 2 | 2 | 1000 | 690000.00 | long | ask | 81.0850 | 0.1300 | ["80"] | ["0.1148"] | ["73.10","86.90"] | ["AMXO"] | 80.0000 | 80.0000 | 276 | 276 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:21:47Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ab-3ee9-77b1-afc5-88b091c4753b | TLT | 2026-09-14 12:06 | straddle | 2 | 1 | 1000 | 685000.00 | long | ask | 81.2400 | 0.0900 | ["80"] | ["0.1125"] | ["73.15","86.85"] | ["XPHO"] | 80.0000 | 80.0000 | 276 | 276 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:06:49Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a076-38b0-7411-875c-c64ddde84b60 | TLT | 2026-09-14 11:08 | call_diagonal_spread | 2 | 1 | 500 | 103500.00 | long | ask | 80.8650 | 0.3500 | ["95","110"] | ["0.1034","0.1310"] | [] | ["SPHR"] | 95.0000 | 110.0000 | 494 | 823 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:08:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c85-b2e0-7bf2-ad25-c2e85816860f | TLT | 2026-09-10 14:12 | risk_reversal | 2 | 2 | 25500 | 2652000.00 | long | ask | 80.8250 | 0.0200 | ["80","82"] | ["0.1214","0.1264"] | ["82.04"] | ["AMXO"] | 80.0000 | 82.0000 | 20 | 20 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:13:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0868e-cc28-7dd3-bbe8-5927eefac0cc | TLT | 2026-09-09 10:24 | call_ladder | 3 | 3 | 3500 | 241500.00 | long | ask | 82.0400 | 0.0300 | ["82.5","83.5","84.5"] | ["0.1229","0.1227","0.1289"] | ["82.73","85.27"] | ["AMXO"] | 82.5000 | 84.5000 | 9 | 9 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:25:10Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06e09-a36d-72a1-be8f-e2840690d46b | TLT | 2026-09-04 16:08 | put_vertical_spread | 2 | 1 | 2000 | 1720000.00 | long | ask | 82.1900 | 0.2500 | ["86","87"] | ["0.1676","0.2001"] | ["0","86"] | ["XPHO"] | 86.0000 | 87.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:11:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d2b-498d-7421-a426-eca2f341ee14 | TLT | 2026-09-04 12:05 | risk_reversal | 2 | 2 | 700 | 192500.00 | long | bid | 82.3450 | 0.0300 | ["81","84"] | ["0.1398","0.0912"] | ["80.83"] | ["AMXO"] | 81.0000 | 84.0000 | 105 | 105 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:06:27Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |