core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 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 |
|---|
| 01a0e989-f53f-7a42-a7ec-501040ceac47 | CRM | 2026-09-28 15:42 | call_diagonal_spread | 2 | 1 | 25 | 203650.00 | long | bid | 228.2000 | 5.0000 | ["185","230"] | ["0.6280","0.4524"] | [] | ["XCBO"] | 185.0000 | 230.0000 | 18 | 262 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T19:42:29Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0e884-1247-7ae0-bae2-939630c02903 | CRM | 2026-09-28 10:56 | put_diagonal_spread | 2 | 3 | 14 | 106456.00 | long | bid | 229.6800 | 2.9500 | ["230","280"] | ["0.4474","0.9042"] | [] | ["ARCO","XPHO"] | 230.0000 | 280.0000 | 4 | 172 | false | false | true | true | |||||||||
| 01a0e879-8af6-7903-a23d-1817c7d52059 | CRM | 2026-09-28 10:44 | put_calendar | 2 | 1 | 21 | 100779.00 | long | bid | 229.7700 | 2.6000 | ["250"] | ["0.4117"] | [] | ["ARCO"] | 250.0000 | 250.0000 | 18 | 53 | false | false | true | false | |||||||||
| 01a0d9e1-b7de-7570-bdb2-d26cf31b453c | CRM | 2026-09-25 14:44 | call_diagonal_spread | 2 | 1 | 25 | 127025.00 | long | bid | 234.1100 | 2.4500 | ["210","270"] | ["0.4122","0.4399"] | [] | ["EDGO"] | 210.0000 | 270.0000 | 21 | 265 | false | false | true | true | |||||||||
| 01a0d946-c7ce-7080-b2a3-9e5ffc45db66 | CRM | 2026-09-25 11:54 | synthetic | 2 | 1 | 2000 | 5848000.00 | long | bid | 235.0700 | 1.1000 | ["240"] | ["0.3938"] | ["236.70"] | ["ARCO"] | 240.0000 | 240.0000 | 56 | 56 | false | false | false | false | |||||||||
| 01a0d4e4-dcdf-7bc0-baf2-d1a4501e589a | CRM | 2026-09-24 15:29 | synthetic | 2 | 1 | 500 | 215000.00 | long | bid | 239.7050 | 0.3400 | ["240"] | ["0.4288"] | ["239.92"] | ["AMXO"] | 240.0000 | 240.0000 | 1 | 1 | false | false | false | false | |||||||||
| 01a0cfb3-41f6-7712-881f-8fc6b92571dc | CRM | 2026-09-23 15:17 | call_diagonal_spread | 2 | 1 | 25 | 253550.00 | long | bid | 238.3800 | 4.5000 | ["185","250"] | ["0.4950","0.4437"] | [] | ["EDGO"] | 185.0000 | 250.0000 | 23 | 450 | false | false | true | true | |||||||||
| 01a0c532-9917-7c20-8f44-bbb0fe181408 | CRM | 2026-09-21 14:20 | call_diagonal_spread | 2 | 1 | 65 | 770120.00 | long | bid | 237.4300 | 4.2000 | ["185","230"] | ["0.4531","0.4444"] | [] | ["XCBO"] | 185.0000 | 230.0000 | 269 | 361 | false | false | true | true | |||||||||
| 01a0abbc-1213-7981-ad72-551a088759ee | CRM | 2026-09-16 15:40 | call_diagonal_spread | 2 | 1 | 50 | 680700.00 | long | bid | 250.1200 | 5.1500 | ["180","185"] | ["2.0150","0.4675"] | [] | ["EDGO"] | 180.0000 | 185.0000 | 2 | 30 | false | false | true | true | |||||||||
| 01a0ab92-a49b-7c20-8f32-1101521bc407 | CRM | 2026-09-16 14:55 | call_diagonal_spread | 2 | 2 | 37 | 531810.00 | long | bid | 252.1200 | 5.8000 | ["180","195"] | ["0.4970","0.4653"] | [] | ["AMXO","XISX"] | 180.0000 | 195.0000 | 65 | 184 | false | false | true | true | |||||||||
| 01a0ab92-a49b-7c20-8f32-10f08384ef48 | CRM | 2026-09-16 14:55 | call_diagonal_spread | 2 | 1 | 13 | 186914.00 | long | bid | 252.1200 | 5.8000 | ["180","195"] | ["0.4995","0.4658"] | [] | ["XCBO"] | 180.0000 | 195.0000 | 65 | 184 | false | false | true | true | |||||||||
| 01a0ab40-f28b-7ec2-b422-b586c069465f | CRM | 2026-09-16 13:25 | call_calendar | 2 | 1 | 11 | 181005.00 | long | bid | 251.1100 | 6.5000 | ["170"] | ["0.6279"] | [] | ["XMIO"] | 170.0000 | 170.0000 | 30 | 93 | false | false | true | false | |||||||||
| 01a0aaee-f25b-7402-bdd8-697c797823c2 | CRM | 2026-09-16 11:56 | call_diagonal_spread | 2 | 1 | 16 | 112008.00 | long | bid | 250.4000 | 2.2000 | ["202.5","270"] | ["1.3003","0.4293"] | [] | ["XISX"] | 202.5000 | 270.0000 | 2 | 156 | false | false | true | true | |||||||||
| 01a0a6a6-fb1e-7a00-8185-79382c441cc4 | CRM | 2026-09-15 15:59 | call_diagonal_spread | 2 | 1 | 52 | 219806.00 | long | bid | 255.3700 | 0.8000 | ["220","270"] | ["0.7361","0.4080"] | [] | ["EDGO"] | 220.0000 | 270.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a6a6-fb1e-7a00-8185-7925b6189901 | CRM | 2026-09-15 15:59 | call_diagonal_spread | 2 | 1 | 53 | 224455.00 | long | bid | 255.3800 | 0.8000 | ["220","270"] | ["0.7847","0.4089"] | [] | ["XMIO"] | 220.0000 | 270.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a6a6-3f9e-72e0-9da2-471f731afe5a | CRM | 2026-09-15 15:58 | call_diagonal_spread | 2 | 1 | 106 | 449018.00 | long | bid | 255.3850 | 2.0500 | ["220","270"] | ["0.7684","0.4096"] | [] | ["EDGO"] | 220.0000 | 270.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a6a5-841f-75d2-b4a8-d097a2c96ee0 | CRM | 2026-09-15 15:57 | call_diagonal_spread | 2 | 1 | 106 | 451560.00 | long | bid | 255.7100 | 1.5500 | ["220","270"] | ["1.1666","0.4069"] | [] | ["EDGO"] | 220.0000 | 270.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a6a4-cc86-74d1-862d-98a5dd704c91 | CRM | 2026-09-15 15:56 | call_diagonal_spread | 2 | 1 | 106 | 451136.00 | long | bid | 255.6700 | 1.5500 | ["220","270"] | ["1.1784","0.4074"] | [] | ["EDGO"] | 220.0000 | 270.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a633-903e-7d10-95ca-6a88afafe23e | CRM | 2026-09-15 13:53 | call_diagonal_spread | 2 | 1 | 19 | 151544.00 | long | bid | 259.7699 | 1.7500 | ["210","250"] | ["0.9458","0.4516"] | [] | ["XISX"] | 210.0000 | 250.0000 | 3 | 94 | false | false | true | true | |||||||||
| 01a0a0a2-da78-7b61-8690-b20a3e9345e0 | CRM | 2026-09-14 11:56 | put_ratio_spread | 2 | 1 | 152 | 150624.00 | long | bid | 257.1600 | 0.5500 | ["240","250"] | ["0.4251","0.4139"] | ["242.39"] | ["XCBO"] | 240.0000 | 250.0000 | 32 | 32 | false | true | false | true | |||||||||
| 01a090df-e540-7d23-9e66-6576e59da5af | CRM | 2026-09-11 10:29 | call_calendar | 2 | 1 | 11 | 170093.00 | long | bid | 247.3300 | 2.7500 | ["170"] | ["4.9156"] | [] | ["XMIO"] | 170.0000 | 170.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a08671-0ee0-7810-96be-b36f35e2e242 | CRM | 2026-09-09 09:52 | put_calendar | 2 | 6 | 78 | 161434.00 | long | bid | 252.4600 | 1.1333 | ["260"] | ["0.5092"] | [] | ["ARCO","C2OX","EDGO","SPHR","XBOX","XMIO"] | 260.0000 | 260.0000 | 2 | 9 | false | false | true | false | |||||||||
| 01a0866f-c2d9-7a30-add0-52f45e85758c | CRM | 2026-09-09 09:51 | put_calendar | 2 | 4 | 62 | 125820.00 | long | bid | 252.7000 | 1.1000 | ["260"] | ["0.5056"] | [] | ["C2OX","SPHR","XBOX","XMIO"] | 260.0000 | 260.0000 | 2 | 9 | false | false | true | false | |||||||||
| 01a06db4-7aa5-7c53-b9e4-961e0919def1 | CRM | 2026-09-04 14:35 | call_diagonal_spread_bearish | 2 | 1 | 8 | 112696.00 | long | bid | 260.6000 | 3.8500 | ["180","220"] | ["0.4542","0.4334"] | [] | ["ARCO"] | 180.0000 | 220.0000 | 133 | 168 | false | false | true | true | |||||||||
| 01a06d7a-ec46-74a3-a755-dde09d20c44c | CRM | 2026-09-04 13:32 | call_diagonal_spread_bearish | 2 | 1 | 100 | 1577500.00 | long | bid | 261.1950 | 4.5500 | ["180","185"] | ["1.0132","0.6442"] | [] | ["EDGO"] | 180.0000 | 185.0000 | 14 | 42 | false | false | true | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:56:18Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:44:45Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:44:23Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:54:54Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:29:37Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:17:49Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:20:29Z"} |
| 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-16T19:40:28Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:55:09Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:55:09Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:26:40Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:56:33Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:59:14Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:59:14Z"} |
| 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-15T19:58:37Z"} |
| 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-15T19:57:51Z"} |
| 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-15T19:57:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| 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 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:57: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-11T14:29:50Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:52:49Z"} |
| 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-09T13:51:15Z"} |
| 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-04T18:35:51Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:32:52Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |