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 | direction |
|---|
| 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 |
|---|
| 01a0ca71-fb57-7fc1-9ad0-870f36402658 | TXN | 2026-09-22 14:47 | put_vertical_spread | 2 | 1 | 4 | 102596.00 | long | ask | 269.2350 | 2.2000 | ["395","400"] | ["1.7150","1.7479"] | ["395.01"] | ["AMXO"] | 395.0000 | 400.0000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:47:49Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca4c-79c6-7000-a650-f7482405f8a5 | TXN | 2026-09-22 14:06 | call_vertical_spread | 2 | 1 | 13 | 100958.00 | short | bid | 270.0000 | 4.3000 | ["220","245"] | ["0.5046","0.4106"] | ["243.74"] | ["XMIO"] | 220.0000 | 245.0000 | 17 | 17 | true | false | false | ||||||||||
| 01a0afe7-aac3-7573-8fab-86f19cef30e4 | TXN | 2026-09-17 11:06 | other | 4 | 1 | 1243 | 650089.00 | unknown | — | 259.4650 | 1.9300 | ["265","272.5","280"] | ["0.3588","0.4677","0.8691"] | [] | ["XPHO"] | 265.0000 | 280.0000 | 1 | 8 | false | true | true | true | false | mlat | |||||||
| 01a0ab59-ba4b-7892-bac5-f08a428e897b | TXN | 2026-09-16 13:52 | other | 4 | 1 | 79 | 153734.00 | unknown | — | 264.8900 | 1.9500 | ["260","265","280","290"] | ["0.4854","0.4636","0.3694","0.3694"] | [] | ["AMXO"] | 260.0000 | 290.0000 | 2 | 30 | false | false | true | true | false | ||||||||
| 01a0aa97-8f43-7fc3-b882-0d7fa8384924 | TXN | 2026-09-16 10:20 | call_calendar | 2 | 1 | 318 | 1144800.00 | short | ask | 264.6450 | 3.8000 | ["250"] | ["0.4755"] | [] | ["XMIO"] | 250.0000 | 250.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0aa93-0b03-7962-b44c-c5c48f32b589 | TXN | 2026-09-16 10:15 | put_vertical_spread | 2 | 1 | 3 | 124971.00 | long | ask | 264.2400 | 7.2500 | ["470","475"] | ["3.0384","3.0626"] | ["470.01"] | ["AMXO"] | 470.0000 | 475.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0aa8f-6d3b-7152-9162-c7523890e449 | TXN | 2026-09-16 10:11 | put_vertical_spread | 2 | 1 | 5 | 223055.00 | short | bid | 264.3500 | 7.8500 | ["485","490"] | ["2.5897","2.4471"] | ["485.01"] | ["XCBO"] | 485.0000 | 490.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0a620-4aa6-7721-850b-565332a1670d | TXN | 2026-09-15 13:32 | call_vertical_spread | 2 | 1 | 4 | 108704.00 | long | ask | 263.2550 | 2.8000 | ["125","130"] | ["3.1570","3.0756"] | ["129.98"] | ["XCBO"] | 125.0000 | 130.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0a617-f5d6-77a1-90d3-ffd999ae2d6e | TXN | 2026-09-15 13:23 | call_vertical_spread | 2 | 1 | 7 | 162127.00 | long | ask | 263.2200 | 2.4000 | ["145","150"] | ["2.3609","2.2864"] | ["149.99"] | ["XCBO"] | 145.0000 | 150.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0a5fd-c2ce-7d63-90b2-7c3a9dc696d2 | TXN | 2026-09-15 12:54 | call_vertical_spread | 2 | 1 | 4 | 112544.00 | long | ask | 263.4850 | 3.9000 | ["120","125"] | ["4.3291","4.2310"] | ["124.98"] | ["XCBO"] | 120.0000 | 125.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0a5f9-9866-7b03-87e9-a9102dad5128 | TXN | 2026-09-15 12:49 | call_vertical_spread | 2 | 1 | 3 | 102366.00 | long | ask | 263.3400 | 3.6000 | ["90","95"] | ["5.7765","5.6405"] | ["94.98"] | ["XCBO"] | 90.0000 | 95.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0a5dd-dad5-7d81-a671-b6c8c50777d1 | TXN | 2026-09-15 12:19 | put_vertical_spread | 2 | 1 | 6 | 244878.00 | unknown | — | 263.4400 | 7.9000 | ["465","470"] | ["2.5094","2.5342"] | [] | ["XCBO"] | 465.0000 | 470.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a0a5d9-6635-7ba2-8124-ad2fb0311a96 | TXN | 2026-09-15 12:14 | other | 4 | 2 | 2 | 103769.00 | unknown | — | 263.3850 | 9.1500 | ["85","90","95","100"] | ["5.6314","5.4005","5.1012","5.0208"] | [] | ["XCBO"] | 85.0000 | 100.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a0a5c6-c4ae-7bb1-baa2-8583c249f6c0 | TXN | 2026-09-15 11:54 | call_vertical_spread | 2 | 1 | 3 | 105972.00 | long | ask | 263.6825 | 3.1500 | ["85","90"] | ["5.7472","5.5081"] | ["89.98"] | ["XCBO"] | 85.0000 | 90.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0a5a3-100e-73e1-8fb7-7cce4613d230 | TXN | 2026-09-15 11:15 | call_vertical_spread | 2 | 1 | 3 | 108927.00 | long | ask | 264.1450 | 2.2000 | ["80","85"] | ["6.0007","5.9025"] | ["84.99"] | ["AMXO"] | 80.0000 | 85.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0a105-e5f0-79b1-aed6-b059f15c18b9 | TXN | 2026-09-14 13:45 | call_vertical_spread | 2 | 1 | 5 | 157925.00 | long | ask | 264.8300 | 4.7000 | ["105","110"] | ["4.2977","4.1303"] | ["109.97"] | ["XCBO"] | 105.0000 | 110.0000 | 4 | 4 | false | false | false | ||||||||||
| 01a090f9-39a0-78d1-a238-11fe92e90085 | TXN | 2026-09-11 10:57 | other | 4 | 1 | 1242 | 3870072.00 | unknown | — | 270.1900 | 6.1300 | ["255","260","272.5","280"] | ["1.9208","1.5735","0.3541","0.3859"] | [] | ["AMXO"] | 255.0000 | 280.0000 | 0 | 7 | false | false | true | true | false | ||||||||
| 01a08714-4808-74c2-8775-ad235cf40f13 | TXN | 2026-09-09 12:50 | other | 3 | 1 | 157 | 183754.00 | unknown | — | 262.5750 | 1.3100 | ["240","280","310"] | ["0.4027","0.3876","0.3867"] | [] | ["XCBO"] | 240.0000 | 310.0000 | 37 | 37 | false | true | false | true | true | mlat |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:07:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:07:01Z"} |
| 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-16T17:53:29Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:21:27Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:15:56Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:12:15Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:32:16Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:23:28Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:54:46Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:50:51Z"} |
| 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-15T16:19:46Z"} |
| 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-15T16:14:55Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:55:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:15:56Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:45:16Z"} |
| 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-11T14:57:46Z"} |
| 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-09T16:50:46Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |