Multi-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08be6-9098-7db2-8b1d-a862bac31b0b | AMDL | 2026-09-10 11:18 | call_diagonal_spread | 2 | 1 | 50 | 121950.00 | long | ask | 56.0000 | 1.6000 | ["45","46"] | ["1.1387","0.9624"] | [] | ["XMIO"] | 45.0000 | 46.0000 | 8 | 43 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:19:38Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0a0ae-53f8-7260-bc65-1900ed828223 | AMDL | 2026-09-14 12:09 | call_diagonal_spread | 2 | 1 | 43 | 225922.00 | short | bid | 51.5650 | 3.1000 | ["28","38"] | ["0.9060","0.9001"] | [] | ["BATO"] | 28.0000 | 38.0000 | 186 | 494 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:10:13Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a627-efae-7990-a9f5-d350b56a1e9d | AMDL | 2026-09-15 13:40 | call_diagonal_spread | 2 | 1 | 103 | 194736.00 | unknown | — | 54.6761 | 1.8000 | ["45.5","46"] | ["1.4857","1.0519"] | [] | ["EDGO"] | 45.5000 | 46.0000 | 3 | 10 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:40:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0b02d-720b-7f42-9d44-39e7ad2ab86a | AMDL | 2026-09-17 12:22 | call_diagonal_spread | 2 | 1 | 50 | 409250.00 | unknown | — | 65.1000 | 5.3000 | ["30","39"] | ["0.8199","0.8189"] | [] | ["XBOX"] | 30.0000 | 39.0000 | 491 | 855 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:23:09Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b06d-807b-7cc3-beda-f9b94f577512 | AMDL | 2026-09-17 13:32 | call_diagonal_spread | 2 | 1 | 18 | 113940.00 | unknown | — | 64.2500 | 5.1000 | ["55","65"] | ["0.9064","0.8674"] | [] | ["XISX"] | 55.0000 | 65.0000 | 491 | 855 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:32:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0c434-7a67-7bd2-b96d-9a4d87892bfa | AMDL | 2026-09-21 09:42 | call_diagonal_spread | 2 | 1 | 192 | 561408.00 | long | ask | 76.9100 | 3.0000 | ["65","80"] | ["1.2353","1.0349"] | [] | ["XCBO"] | 65.0000 | 80.0000 | 4 | 116 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:42:55Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c435-64c7-7a73-b55b-39661b9f6188 | AMDL | 2026-09-21 09:43 | call_diagonal_spread | 2 | 1 | 300 | 777000.00 | unknown | — | 77.2400 | 2.0000 | ["65","85"] | ["1.0374","1.0680"] | [] | ["XCBO"] | 65.0000 | 85.0000 | 4 | 88 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:43:59Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c439-48df-7420-abea-4958db51b5bb | AMDL | 2026-09-21 09:48 | call_diagonal_spread | 2 | 1 | 200 | 542000.00 | short | bid | 77.2200 | 2.8000 | ["65","85"] | ["1.6413","1.0953"] | [] | ["ARCO"] | 65.0000 | 85.0000 | 4 | 88 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:48:10Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43d-e0a7-7dd1-9bc1-4579d5e865ae | AMDL | 2026-09-21 09:53 | call_diagonal_spread | 2 | 1 | 70 | 153020.00 | long | ask | 78.0997 | 3.1000 | ["75","100"] | ["1.0425","1.0496"] | [] | ["XPHO"] | 75.0000 | 100.0000 | 25 | 116 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:53:10Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c440-49d6-7f91-a6e3-1eb86fd60937 | AMDL | 2026-09-21 09:55 | call_diagonal_spread | 2 | 1 | 68 | 206720.00 | long | ask | 78.1500 | 3.1000 | ["70","82"] | ["1.0768","1.0884"] | [] | ["XISX"] | 70.0000 | 82.0000 | 39 | 88 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:55:49Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c466-f82f-7b23-8a09-c0b382135831 | AMDL | 2026-09-21 10:37 | call_diagonal_spread | 2 | 1 | 40 | 196080.00 | short | ask | 79.2600 | 2.5000 | ["56","63"] | ["1.0152","1.0530"] | [] | ["XISX"] | 56.0000 | 63.0000 | 32 | 88 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:38:00Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c489-ce27-7fc3-8dd5-dbe59981246e | AMDL | 2026-09-21 11:15 | call_diagonal_spread | 2 | 1 | 42 | 152460.00 | short | bid | 79.6000 | 2.4000 | ["62","77"] | ["1.5282","1.1047"] | [] | ["AMXO"] | 62.0000 | 77.0000 | 4 | 88 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:16:00Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c49b-8d1f-7662-8a28-aba7da06a836 | AMDL | 2026-09-21 11:35 | call_diagonal_spread | 2 | 1 | 164 | 613360.00 | short | bid | 79.5300 | 2.2000 | ["62","80"] | ["1.1742","1.0675"] | [] | ["XMIO"] | 62.0000 | 80.0000 | 11 | 116 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:35:55Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |