Simplify AnalyticsMulti-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0ab11-a52b-7312-afce-c4967d8be100 | TLT | 2026-09-16 12:34 | call_ratio_spread | 2 | 3 | 16500 | 441375.00 | unknown | — | 81.1000 | 0.0200 | ["81.5","82"] | ["0.1833","0.1813"] | [] | ["AMXO"] | 81.5000 | 82.0000 | 2 | 2 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:34:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 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 |
| 01a0aa7c-3743-7ef3-8e2b-81798583cb25 | TLT | 2026-09-16 09:51 | call_ratio_spread | 2 | 6 | 938 | 126554.00 | long | ask | 81.0000 | 0.0400 | ["82","93"] | ["0.0934","0.1289"] | ["83.70","102.30"] | ["ARCO","EMLD","SPHR","XBOX","XISX","XMIO"] | 82.0000 | 93.0000 | 156 | 156 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:51:24Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa79-e96b-7d63-bfa8-e169828a2925 | TLT | 2026-09-16 09:48 | call_ratio_spread | 2 | 1 | 1000 | 134500.00 | long | ask | 81.0200 | 0.0500 | ["82","93"] | ["0.0929","0.1281"] | ["83.71","102.29"] | ["EDGO"] | 82.0000 | 93.0000 | 156 | 156 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:48:52Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a55b-607e-7ed0-bef5-ecee707a904d | TLT | 2026-09-15 09:57 | call_ratio_spread | 2 | 1 | 2500 | 277500.00 | unknown | — | 80.6100 | 0.0700 | ["81","86"] | ["0.1093","0.1242"] | [] | ["XMIO"] | 81.0000 | 86.0000 | 66 | 66 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:57:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08bb3-3810-7e00-80c8-34260da7c205 | TLT | 2026-09-10 10:22 | call_ratio_spread | 2 | 1 | 756 | 122094.00 | long | ask | 81.1850 | 0.0400 | ["81","92"] | ["0.0847","0.1161"] | ["83.23","100.77"] | ["XPHO"] | 81.0000 | 92.0000 | 162 | 162 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:23:11Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |