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 |
|---|
| 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 |
|---|
| 01a0caa6-3e3f-76d0-bfee-a50e95021588 | TER | 2026-09-22 15:44 | call_butterfly_spread | 3 | 1 | 6 | 123948.00 | long | ask | 398.0500 | 23.0000 | ["360","500","640"] | ["0.6771","0.6782","0.6822"] | ["376.56","623.44"] | ["XCBO"] | 360.0000 | 640.0000 | 486 | 486 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:45:01Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c42e-5fe7-79e1-84d8-7145bddd3bdf | TER | 2026-09-21 09:36 | call_diagonal_spread | 2 | 2 | 36 | 111636.00 | long | ask | 375.9850 | 7.4000 | ["370","380"] | ["0.7515","0.6771"] | [] | ["ARCO","C2OX"] | 370.0000 | 380.0000 | 4 | 11 | false | false | true | true | |||||||||
| 01a0a679-ccb6-78d3-ab78-337fae9e43bd | TER | 2026-09-15 15:09 | call_diagonal_spread | 2 | 1 | 10 | 402800.00 | long | ask | 329.5300 | 13.6000 | ["150","175"] | ["0.6966","0.6806"] | [] | ["XMIO"] | 150.0000 | 175.0000 | 458 | 857 | false | false | true | true | |||||||||
| 01a0a558-d03e-7153-b568-e8a9f895170a | TER | 2026-09-15 09:54 | put_calendar | 2 | 1 | 9 | 110286.00 | long | bid | 331.5900 | 6.7000 | ["390"] | ["0.9357"] | [] | ["ARCO"] | 390.0000 | 390.0000 | 3 | 31 | false | false | true | false | false | ||||||||
| 01a0a09c-d381-7b90-956c-38089b7775d2 | TER | 2026-09-14 11:50 | put_vertical_spread | 2 | 1 | 70 | 553490.00 | long | ask | 337.6750 | 4.3000 | ["270","350"] | ["0.6911","0.6925"] | ["311.91"] | ["XCBO"] | 270.0000 | 350.0000 | 123 | 123 | false | false | false | true | |||||||||
| 01a0a06e-e5b0-76c2-87dd-eff4f997ed90 | TER | 2026-09-14 11:00 | put_vertical_spread | 2 | 1 | 30 | 239820.00 | long | ask | 336.3250 | 6.0000 | ["270","350"] | ["0.6907","0.6925"] | ["311.58"] | ["XCBO"] | 270.0000 | 350.0000 | 123 | 123 | false | false | false | true | |||||||||
| 01a0a06e-e5b0-76c2-87dd-efee77b7852b | TER | 2026-09-14 11:00 | call_vertical_spread | 2 | 1 | 9 | 183411.00 | long | ask | 336.3250 | 13.6000 | ["360","370"] | ["0.7251","0.7236"] | ["363.33"] | ["XPHO"] | 360.0000 | 370.0000 | 459 | 459 | false | true | false | true | |||||||||
| 01a0a045-4959-7bd0-97d9-bd3fe6909d90 | TER | 2026-09-14 10:14 | put_vertical_spread | 2 | 1 | 100 | 751700.00 | long | ask | 344.2850 | 8.0000 | ["270","350"] | ["0.6988","0.6914"] | ["313.93"] | ["XCBO"] | 270.0000 | 350.0000 | 123 | 123 | false | false | false | true | |||||||||
| 01a09109-1ff0-7180-b7a8-5bb428db235f | TER | 2026-09-11 11:14 | call_calendar | 2 | 1 | 5 | 212705.00 | long | bid | 381.2500 | 12.6000 | ["170"] | ["2.1804"] | [] | ["XMIO"] | 170.0000 | 170.0000 | 7 | 35 | false | false | true | false | false | ||||||||
| 01a087a3-5520-76c3-a98c-7404dae4f4bc | TER | 2026-09-09 15:27 | straddle | 2 | 2 | 15 | 475550.00 | long | ask | 382.8250 | 3.2000 | ["560"] | ["0.7209"] | ["242.97","877.03"] | ["EDGO","XISX"] | 560.0000 | 560.0000 | 499 | 499 | false | false | false | false | true | ||||||||
| 01a087a3-39c8-73c2-9f1b-fc70ce6804b0 | TER | 2026-09-09 15:26 | synthetic | 2 | 1 | 7 | 222250.00 | long | bid | 382.8750 | 3.9000 | ["560"] | ["0.7222"] | ["410.10"] | ["EDGO"] | 560.0000 | 560.0000 | 499 | 499 | false | false | false | false | true | ||||||||
| 01a087a2-c498-72a3-bf91-bb867f79f75f | TER | 2026-09-09 15:26 | straddle | 2 | 3 | 10 | 317500.00 | long | ask | 382.8200 | 2.4100 | ["560"] | ["0.7222"] | ["242.50","877.50"] | ["ARCO","EDGO","XISX"] | 560.0000 | 560.0000 | 499 | 499 | false | false | false | false | true | ||||||||
| 01a087a1-2e58-7ab3-85f2-4bce9ac4d138 | TER | 2026-09-09 15:24 | straddle | 2 | 1 | 4 | 127400.00 | long | ask | 383.4800 | 6.4000 | ["560"] | ["0.7250"] | ["241.50","878.50"] | ["EDGO"] | 560.0000 | 560.0000 | 499 | 499 | false | false | false | false | true | ||||||||
| 01a087a0-9dd0-7060-b6e9-33fd138aa482 | TER | 2026-09-09 15:24 | synthetic | 2 | 1 | 4 | 127600.00 | long | bid | 383.5800 | 0.6000 | ["560"] | ["0.7264"] | ["410.62"] | ["EDGO"] | 560.0000 | 560.0000 | 499 | 499 | false | false | false | false | true | ||||||||
| 01a087a0-9dd0-7060-b6e9-33cc0f053165 | TER | 2026-09-09 15:24 | straddle | 2 | 1 | 5 | 159500.00 | long | ask | 383.5800 | 7.7000 | ["560"] | ["0.7264"] | ["241","879.00"] | ["XISX"] | 560.0000 | 560.0000 | 499 | 499 | false | false | false | false | true | ||||||||
| 01a087a0-99e8-7961-af1d-33ae61813586 | TER | 2026-09-09 15:24 | synthetic | 2 | 1 | 6 | 191400.00 | long | bid | 383.5800 | 10.0000 | ["560"] | ["0.7264"] | ["407"] | ["EDGO"] | 560.0000 | 560.0000 | 499 | 499 | false | false | false | false | true | ||||||||
| 01a087a0-99e8-7961-af1d-33968fa2376a | TER | 2026-09-09 15:24 | synthetic | 2 | 1 | 5 | 159500.00 | long | bid | 383.5800 | 11.6000 | ["560"] | ["0.7264"] | ["411.40"] | ["XISX"] | 560.0000 | 560.0000 | 499 | 499 | false | false | false | false | true | ||||||||
| 01a087a0-7aa8-75e0-9d0e-c3a7ecf4e83e | TER | 2026-09-09 15:23 | straddle | 2 | 2 | 10 | 320000.00 | long | ask | 383.7000 | 13.4000 | ["560"] | ["0.7292"] | ["240","880.00"] | ["EDGO","XISX"] | 560.0000 | 560.0000 | 499 | 499 | false | false | false | false | true | ||||||||
| 01a08728-be50-79e2-a773-4b975c1bec41 | TER | 2026-09-09 13:13 | straddle | 2 | 1 | 14 | 138222.00 | long | ask | 380.7500 | 4.2000 | ["360"] | ["0.7448"] | ["261.27","458.73"] | ["EMLD"] | 360.0000 | 360.0000 | 72 | 72 | false | false | false | false | true | ||||||||
| 01a08728-be50-79e2-a773-4b6d69972ed5 | TER | 2026-09-09 13:13 | straddle | 2 | 10 | 26 | 257078.00 | long | ask | 380.7500 | 5.3500 | ["360"] | ["0.7460"] | ["261.12","458.88"] | ["ARCO","EMLD","MCRY","XISX","XPHO"] | 360.0000 | 360.0000 | 72 | 72 | false | false | false | false | true | ||||||||
| 01a086e4-75d8-7f70-862b-f62346de1012 | TER | 2026-09-09 11:58 | risk_reversal | 2 | 1 | 50 | 104048.00 | long | ask | 379.5300 | 3.0000 | ["320","450"] | ["0.6855","0.6905"] | ["452.62"] | ["AMXO"] | 320.0000 | 450.0000 | 37 | 37 | false | true | false | true | true | ||||||||
| 01a0868e-c840-7c11-83a6-bf4cc0de6b8b | TER | 2026-09-09 10:24 | put_vertical_spread | 2 | 2 | 7 | 124548.00 | long | ask | 380.8703 | 6.0000 | ["400","450"] | ["0.7192","0.7221"] | ["416.80"] | ["BATO","XMIO"] | 400.0000 | 450.0000 | 128 | 128 | false | false | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:36:12Z"} |
| 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-15T19:10:34Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:54:39Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:50:52Z"} |
| 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-14T15:00:19Z"} |
| 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-14T15:00:19Z"} |
| 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-14T14:14:50Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:14:58Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:27:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:27:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:26:27Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:25:10Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:24:21Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:24:21Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:24:21Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:24:21Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:24:21Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:13:12Z"} |
| 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-09T17:13:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:59:14Z"} |
| 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-09T14:25:10Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |