core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0e984-963e-7be0-bd33-71e371c8ecd3 | CEG | 2026-09-28 15:36 | put_diagonal_spread | 2 | 5 | 12 | 132880.00 | unknown | bid | 260.6400 | 4.0000 | ["310","320"] | ["0.4539","0.6295"] | [] | ["AMXO","EMLD","XBOX","XMIO","XPHO"] | 310.0000 | 320.0000 | 18 | 53 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T19:36:28Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0e984-963e-7be0-bd33-71d0ea22689b | CEG | 2026-09-28 15:36 | put_diagonal_spread | 2 | 6 | 25 | 277750.00 | unknown | bid | 260.6400 | 4.0000 | ["310","320"] | ["0.4607","0.6080"] | [] | ["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"] | 310.0000 | 320.0000 | 18 | 53 | false | false | |||||||||||
| 01a0e984-963e-7be0-bd33-71c22a7c577e | CEG | 2026-09-28 15:36 | put_diagonal_spread | 2 | 5 | 19 | 210610.00 | unknown | bid | 260.6400 | 4.0000 | ["310","320"] | ["0.4560","0.6228"] | [] | ["AMXO","EMLD","XBOX","XMIO","XPHO"] | 310.0000 | 320.0000 | 18 | 53 | false | false | |||||||||||
| 01a0e984-9257-7f11-a48d-2ddc8759bee7 | CEG | 2026-09-28 15:36 | put_diagonal_spread | 2 | 5 | 19 | 210610.00 | unknown | bid | 260.6400 | 4.0000 | ["310","320"] | ["0.4560","0.6228"] | [] | ["AMXO","EMLD","XBOX","XMIO","XPHO"] | 310.0000 | 320.0000 | 18 | 53 | false | false | |||||||||||
| 01a0e983-a026-7681-953d-084499443869 | CEG | 2026-09-28 15:35 | put_diagonal_spread | 2 | 6 | 19 | 211010.00 | unknown | bid | 260.6000 | 4.0000 | ["310","320"] | ["0.4587","0.6057"] | [] | ["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"] | 310.0000 | 320.0000 | 18 | 53 | false | false | |||||||||||
| 01a0e983-a026-7681-953d-083b133f4a5d | CEG | 2026-09-28 15:35 | put_diagonal_spread | 2 | 5 | 19 | 210610.00 | unknown | bid | 260.6000 | 4.0000 | ["310","320"] | ["0.4548","0.6183"] | [] | ["AMXO","EMLD","XBOX","XMIO","XPHO"] | 310.0000 | 320.0000 | 18 | 53 | false | false | |||||||||||
| 01a0e983-a026-7681-953d-08253aa0fcea | CEG | 2026-09-28 15:35 | put_diagonal_spread | 2 | 4 | 16 | 177190.00 | unknown | bid | 260.6000 | 4.5625 | ["310","320"] | ["0.4528","0.6368"] | [] | ["AMXO","EMLD","XBOX","XPHO"] | 310.0000 | 320.0000 | 18 | 53 | false | false | |||||||||||
| 01a0e983-9c3e-7e91-bd9a-42f9dd26cd64 | CEG | 2026-09-28 15:35 | put_diagonal_spread | 2 | 6 | 25 | 278324.00 | unknown | bid | 260.6000 | 4.3680 | ["310","320"] | ["0.4635","0.6479"] | [] | ["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"] | 310.0000 | 320.0000 | 18 | 53 | false | false | |||||||||||
| 01a0d4b8-69f7-7190-a051-d51608c26d3a | CEG | 2026-09-24 14:40 | put_ladder | 3 | 1 | 42 | 185160.00 | unknown | bid | 262.2800 | 8.9000 | ["280","285","295"] | ["1.3144","1.2656","1.9677"] | ["264.20"] | ["XBOX"] | 280.0000 | 295.0000 | 1 | 1 | false | false | |||||||||||
| 01a0cf49-d997-7e92-8126-f9ba903f647b | CEG | 2026-09-23 13:21 | call_diagonal_spread | 2 | 1 | 10 | 109440.00 | long | bid | 263.3700 | 1.5000 | ["270","280"] | ["0.4486","0.4503"] | [] | ["BATO"] | 270.0000 | 280.0000 | 450 | 485 | false | true | |||||||||||
| 01a0b4f6-e887-7dc2-9886-6e1be73f5c79 | CEG | 2026-09-18 10:41 | put_diagonal_spread | 2 | 1 | 105 | 243600.00 | long | bid | 258.4250 | 3.5000 | ["255","275"] | ["0.4174","1.1226"] | [] | ["XISX"] | 255.0000 | 275.0000 | 0 | 14 | false | false | |||||||||||
| 01a0b05d-7aeb-7d80-b581-ac42141932c7 | CEG | 2026-09-17 13:15 | straddle | 2 | 2 | 17 | 119986.00 | short | bid | 263.9950 | 2.1353 | ["290"] | ["0.4469"] | ["219.42","360.58"] | ["ARCO","XBOX"] | 290.0000 | 290.0000 | 183 | 183 | false | false | |||||||||||
| 01a0b02b-3f8b-7370-9d9e-600a3c424ec9 | CEG | 2026-09-17 12:20 | synthetic | 2 | 2 | 25 | 176250.00 | long | bid | 268.3100 | 2.2000 | ["290"] | ["0.4473"] | ["274.30"] | ["ARCO","XBOX"] | 290.0000 | 290.0000 | 183 | 183 | false | false | |||||||||||
| 01a0af9c-22d3-7a32-ae7d-2bf39d16d8d7 | CEG | 2026-09-17 09:43 | call_vertical_spread | 2 | 2 | 14 | 165690.00 | short | bid | 264.2200 | 5.7000 | ["280","430"] | ["0.4540","0.4639"] | ["315.57"] | ["ARCO","XMIO"] | 280.0000 | 430.0000 | 855 | 855 | true | true | |||||||||||
| 01a0af9a-425b-7a50-81da-fd90f1692da3 | CEG | 2026-09-17 09:41 | call_vertical_spread | 2 | 1 | 10 | 254700.00 | short | bid | 264.0600 | 6.6000 | ["150","155"] | ["0.4600","0.4622"] | ["153.70"] | ["XMIO"] | 150.0000 | 155.0000 | 491 | 491 | false | false | |||||||||||
| 01a0a632-d0d6-7ce2-bada-4554ef08692b | CEG | 2026-09-15 13:52 | call_diagonal_spread | 2 | 6 | 240 | 1080120.00 | short | bid | 261.9800 | 2.5000 | ["250","300"] | ["0.4470","0.4274"] | [] | ["AMXO","ARCO","C2OX","XCBO","XMIO","XPHO"] | 250.0000 | 300.0000 | 38 | 185 | true | false | |||||||||||
| 01a0a0ce-0d11-7a03-bdd7-5cc19756bf69 | CEG | 2026-09-14 12:44 | call_diagonal_spread | 2 | 1 | 10 | 119850.00 | long | bid | 265.8500 | 4.3000 | ["270","300"] | ["0.4547","0.4572"] | [] | ["XMIO"] | 270.0000 | 300.0000 | 494 | 641 | false | true | |||||||||||
| 01a0a026-2899-7090-8bc8-907066e803d4 | CEG | 2026-09-14 09:40 | call_vertical_spread | 2 | 2 | 32 | 232720.00 | short | bid | 271.8200 | 5.5000 | ["260","360"] | ["0.4563","0.4693"] | ["291.36"] | ["ARCO","XISX"] | 260.0000 | 360.0000 | 276 | 276 | false | false | |||||||||||
| 01a08154-3091-7980-a851-e358e956375e | CEG | 2026-09-08 10:02 | call_vertical_spread | 2 | 1 | 200 | 1160140.00 | short | bid | 301.0300 | 4.7000 | ["290","300"] | ["0.4647","0.4659"] | ["295.01"] | ["XCBO"] | 290.0000 | 300.0000 | 73 | 73 | false | false | |||||||||||
| 01a06df8-d2bd-7d60-a850-047e9ce82935 | CEG | 2026-09-04 15:50 | call_vertical_spread | 2 | 2 | 20 | 166810.00 | short | bid | 299.0300 | 6.7000 | ["290","310"] | ["0.4482","0.4485"] | ["298.92"] | ["ARCO","C2OX"] | 290.0000 | 310.0000 | 196 | 196 | false | false | |||||||||||
| 01a06dbf-9a4d-7df0-b0e4-a8eb6445bf53 | CEG | 2026-09-04 14:47 | call_vertical_spread | 2 | 1 | 9 | 171846.00 | short | bid | 297.2550 | 7.9000 | ["280","290"] | ["0.4533","0.4529"] | ["284.10"] | ["XCBO"] | 280.0000 | 290.0000 | 833 | 833 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T19:36:28Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T19:36:28Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T19:36:28Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T19:35:12Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T19:35:12Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T19:35:12Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T19:35:12Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:41:41Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:22:25Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:41:22Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:15:55Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:20:25Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:43:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:41:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:53:18Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:44:49Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:40:57Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:03:02Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:50:29Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:48:13Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |