core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_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 |
|---|
| 01a0b0b0-d6c3-7e51-b473-995af754cd67 | CRM | 2026-09-17 14:46 | put_vertical_spread | 2 | 1 | 22 | 261140.00 | unknown | — | 244.9500 | 5.0500 | ["300","305"] | ["2.9415","3.1113"] | [] | ["XBOX"] | 300.0000 | 305.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:46:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ac-f693-73a2-be4c-c6cf03bc7519 | CRM | 2026-09-17 14:41 | other | 7 | 1 | 1014 | 9536202.00 | unknown | — | 244.9949 | 18.4000 | ["270","275","280","285","305","325","390"] | ["1.7890","1.5655","2.1955","2.4105","3.1287","3.7617","0.7398"] | [] | ["XBOX"] | 270.0000 | 390.0000 | 1 | 92 | false | false | true | true | false | mlft | |||||||
| 01a0b0a7-c672-7072-92b6-9bc9aa4276bb | CRM | 2026-09-17 14:36 | put_ladder | 8 | 1 | 605 | 7281980.00 | unknown | — | 244.8250 | 21.3000 | ["280","285","290","295","305","310","315","325"] | ["2.1413","1.5406","2.5200","2.7201","3.0616","3.2244","3.3826","3.6860"] | [] | ["XBOX"] | 280.0000 | 325.0000 | 1 | 1 | true | false | false | true | false | mlft | |||||||
| 01a0b069-522b-7440-ae55-fb301bc13ab5 | CRM | 2026-09-17 13:28 | call_diagonal_spread | 2 | 2 | 500 | 1063500.00 | long | ask | 243.1950 | 0.7000 | ["245","250"] | ["0.4801","0.4410"] | [] | ["ARCO"] | 245.0000 | 250.0000 | 1 | 92 | false | true | true | true | false | ||||||||
| 01a0abab-d1eb-73f3-b2a6-6cf2e26ef907 | CRM | 2026-09-16 15:22 | call_vertical_spread | 2 | 1 | 600 | 3963600.00 | unknown | — | 249.7400 | 4.6000 | ["215","220"] | ["1.3797","1.2114"] | [] | ["XPHO"] | 215.0000 | 220.0000 | 2 | 2 | false | false | false | true | false | mlft | |||||||
| 01a0aba6-440b-7052-8af9-f9a6e75e17ce | CRM | 2026-09-16 15:16 | call_vertical_spread | 2 | 1 | 4000 | 34078000.00 | unknown | — | 250.6800 | 4.2500 | ["197.5","220"] | ["1.9357","1.1835"] | [] | ["XPHO"] | 197.5000 | 220.0000 | 2 | 2 | false | false | false | true | false | mlft | |||||||
| 01a0aba5-617b-7f52-b67b-1dcdf51c9f29 | CRM | 2026-09-16 15:15 | call_vertical_spread | 2 | 1 | 5 | 112630.00 | unknown | — | 250.7700 | 5.4000 | ["90","187.5"] | ["6.8414","2.2375"] | [] | ["XPHO"] | 90.0000 | 187.5000 | 2 | 2 | false | false | false | true | false | mlft | |||||||
| 01a0aba1-620b-7743-9ef5-54f265abf2f1 | CRM | 2026-09-16 15:11 | call_vertical_spread | 2 | 1 | 700 | 4797800.00 | unknown | — | 251.1350 | 3.8500 | ["215","220"] | ["1.3461","1.1847"] | [] | ["XPHO"] | 215.0000 | 220.0000 | 2 | 2 | false | false | false | true | false | mlft | |||||||
| 01a0a69c-4106-7be1-b99e-61931a2684db | CRM | 2026-09-15 15:47 | call_ratio_spread | 2 | 1 | 700 | 156100.00 | unknown | — | 255.1500 | 0.3300 | ["260","275"] | ["0.5812","0.5967"] | [] | ["XBOX"] | 260.0000 | 275.0000 | 3 | 3 | false | true | false | true | false | mlft | |||||||
| 01a081ae-f2f1-73a1-9057-8aa4bda6bc02 | CRM | 2026-09-08 11:41 | call_diagonal_spread | 2 | 1 | 180 | 1126260.00 | long | ask | 250.1150 | 2.8500 | ["220","240"] | ["0.5158","0.4228"] | [] | ["SPHR"] | 220.0000 | 240.0000 | 10 | 129 | false | false | true | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:42:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:36:19Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:28:42Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:22:38Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:16:35Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:15:40Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:11:15Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:47:53Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:42:24Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |