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 | net_side |
|---|
| 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 |
|---|
| 01a0b5e2-4e40-7793-acb7-5a599d85075e | NEM | 2026-09-18 14:58 | call_diagonal_spread | 2 | 1 | 21 | 215124.00 | long | bid | 122.9000 | 4.9500 | ["60","95"] | ["0.5882","0.4365"] | [] | ["XCBO"] | 60.0000 | 95.0000 | 119 | 364 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:58:34Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b548-b208-7e92-b7c7-35e38b5af641 | NEM | 2026-09-18 12:10 | call_calendar | 2 | 1 | 15 | 256470.00 | short | bid | 122.7300 | 5.4500 | ["37.5"] | ["1.4192"] | [] | ["XMIO"] | 37.5000 | 37.5000 | 91 | 119 | false | false | true | false | false | ||||||||
| 01a0b548-92c7-7062-9d4f-1c6e2a62e0cf | NEM | 2026-09-18 12:10 | call_calendar | 2 | 1 | 10 | 170980.00 | short | bid | 122.7835 | 5.4500 | ["37.5"] | ["1.4053"] | [] | ["XMIO"] | 37.5000 | 37.5000 | 91 | 119 | false | false | true | false | false | ||||||||
| 01a0b548-6f9f-7921-985c-9c76728cdd8d | NEM | 2026-09-18 12:10 | call_calendar | 2 | 1 | 6 | 102588.00 | short | bid | 122.7900 | 5.4500 | ["37.5"] | ["1.4036"] | [] | ["XMIO"] | 37.5000 | 37.5000 | 91 | 119 | false | false | true | false | false | ||||||||
| 01a0b548-0df7-7cd0-9c7f-e770809b3203 | NEM | 2026-09-18 12:09 | call_calendar | 2 | 1 | 6 | 102588.00 | short | bid | 122.7900 | 5.4500 | ["37.5"] | ["1.4036"] | [] | ["XMIO"] | 37.5000 | 37.5000 | 91 | 119 | false | false | true | false | false | ||||||||
| 01a0b546-0287-7631-93d9-37fd4fa989a5 | NEM | 2026-09-18 12:07 | call_calendar | 2 | 1 | 6 | 102588.00 | short | bid | 122.8262 | 5.4500 | ["37.5"] | ["1.3939"] | [] | ["XMIO"] | 37.5000 | 37.5000 | 91 | 119 | false | false | true | false | false | ||||||||
| 01a0b545-0888-77b2-a089-738a01766728 | NEM | 2026-09-18 12:06 | call_calendar | 2 | 1 | 6 | 102588.00 | short | bid | 122.8200 | 5.4500 | ["37.5"] | ["1.3956"] | [] | ["XMIO"] | 37.5000 | 37.5000 | 91 | 119 | false | false | true | false | false | ||||||||
| 01a0b51e-bfbf-7552-a4b1-0de597e1a702 | NEM | 2026-09-18 11:24 | call_diagonal_spread | 2 | 1 | 20 | 215673.00 | long | bid | 122.0400 | 2.9000 | ["65","75"] | ["0.6104","0.4710"] | [] | ["AMXO"] | 65.0000 | 75.0000 | 119 | 182 | false | false | true | true | false | ||||||||
| 01a0b511-17a7-7710-8478-bab1ea80acb8 | NEM | 2026-09-18 11:09 | call_diagonal_spread | 2 | 1 | 112 | 927696.00 | long | bid | 121.8900 | 2.5000 | ["80","85"] | ["10.1181","0.4557"] | [] | ["XCBO"] | 80.0000 | 85.0000 | 0 | 182 | false | false | true | true | false | ||||||||
| 01a0b511-17a7-7710-8478-baacbbbca746 | NEM | 2026-09-18 11:09 | call_diagonal_spread | 2 | 1 | 13 | 107822.00 | long | bid | 121.8900 | 2.2500 | ["80","85"] | ["10.4651","0.4586"] | [] | ["XISX"] | 80.0000 | 85.0000 | 0 | 182 | false | false | true | true | false | ||||||||
| 01a0b4bf-80f0-7d13-83c5-2eff0e565fba | NEM | 2026-09-18 09:40 | put_calendar | 2 | 3 | 500 | 443437.00 | short | bid | 122.9150 | 2.6800 | ["125"] | ["0.6550"] | [] | ["ARCO","EDGO","XISX"] | 125.0000 | 125.0000 | 0 | 28 | false | false | true | false | false | ||||||||
| 01a0b4bf-80f0-7d13-83c5-2ee49fd6c744 | NEM | 2026-09-18 09:40 | put_calendar | 2 | 5 | 250 | 217926.00 | unknown | bid | 122.9150 | 2.3100 | ["125"] | ["0.6646"] | [] | ["EMLD","MCRY","XBOX","XMIO","XPHO"] | 125.0000 | 125.0000 | 0 | 28 | false | false | true | false | false | ||||||||
| 01a0ab8a-20eb-7742-b7ea-a41b26beb578 | NEM | 2026-09-16 14:45 | call_calendar | 2 | 1 | 28 | 292348.00 | short | bid | 122.5550 | 4.9500 | ["70"] | ["2.8580"] | [] | ["XCBO"] | 70.0000 | 70.0000 | 2 | 23 | false | false | true | false | false | ||||||||
| 01a0aaaa-0da2-71d0-b3bd-e42a6de72642 | NEM | 2026-09-16 10:41 | call_calendar | 2 | 1 | 10 | 116540.00 | short | bid | 123.0200 | 5.1000 | ["65"] | ["2.5911"] | [] | ["XCBO"] | 65.0000 | 65.0000 | 2 | 30 | false | false | true | false | false | ||||||||
| 01a0aaa2-f53b-7b91-abc1-ebd2ad980ed8 | NEM | 2026-09-16 10:33 | call_diagonal_spread | 2 | 3 | 49 | 133461.00 | short | bid | 122.7300 | 0.6000 | ["110","120"] | ["0.8215","0.4371"] | [] | ["C2OX","EDGO","XCBO"] | 110.0000 | 120.0000 | 2 | 121 | false | false | true | true | |||||||||
| 01a0aa69-43b6-7622-9921-12830aa1c7a3 | NEM | 2026-09-16 09:30 | call_vertical_spread | 2 | 1 | 30 | 354570.00 | short | bid | 125.7400 | 4.1000 | ["65","70"] | ["0.7406","0.6750"] | ["69.85"] | ["AMXO"] | 65.0000 | 70.0000 | 121 | 121 | false | false | false | true | |||||||||
| 01a0a580-a776-7ef3-bb8a-b841c8adf772 | NEM | 2026-09-15 10:37 | call_diagonal_spread | 2 | 1 | 15 | 164610.00 | short | bid | 122.0200 | 5.8500 | ["65","70"] | ["1.0204","1.0179"] | [] | ["XCBO"] | 65.0000 | 70.0000 | 24 | 31 | false | false | true | true | false | ||||||||
| 01a0a572-6ed6-71b3-b534-e1ca49a6b4fe | NEM | 2026-09-15 10:22 | call_calendar | 2 | 1 | 37 | 388056.00 | short | bid | 122.0300 | 3.8500 | ["70"] | ["2.0820"] | [] | ["AMXO"] | 70.0000 | 70.0000 | 3 | 31 | false | false | true | false | false | ||||||||
| 01a0a040-8699-7572-80c2-3fab50fb794e | NEM | 2026-09-14 10:09 | call_diagonal_spread | 2 | 1 | 15 | 149790.00 | short | bid | 122.0550 | 7.7500 | ["70","75"] | ["1.0821","1.0900"] | [] | ["XCBO"] | 70.0000 | 75.0000 | 18 | 25 | false | false | true | true | false | ||||||||
| 01a09105-dc00-77b1-b7bc-eb0a0fc0b0a5 | NEM | 2026-09-11 11:11 | call_diagonal_spread | 2 | 2 | 200 | 229200.00 | long | bid | 126.6750 | 1.9625 | ["120","130"] | ["1.5725","0.4229"] | [] | ["AMXO","XPHO"] | 120.0000 | 130.0000 | 0 | 28 | false | false | true | true | false | ||||||||
| 01a08b9a-7ff1-7b32-9f2c-bc0a7b12e42e | NEM | 2026-09-10 09:55 | call_diagonal_spread | 2 | 1 | 47 | 116983.00 | long | bid | 126.5700 | 3.1000 | ["115","125"] | ["0.4018","0.4409"] | [] | ["XCBO"] | 115.0000 | 125.0000 | 36 | 71 | false | false | true | true | false | ||||||||
| 01a086d1-bce0-7533-8f43-533db1a4c134 | NEM | 2026-09-09 11:38 | call_calendar | 2 | 1 | 13 | 152171.00 | short | bid | 128.5950 | 6.6500 | ["70"] | ["3.5135"] | [] | ["EDGO"] | 70.0000 | 70.0000 | 2 | 30 | false | false | true | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:11:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:11:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:10:23Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:10:23Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:07:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:06:38Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:25:01Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:09:50Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:09:50Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:40:53Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:40:53Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:46:16Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:41:29Z"} |
| 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-16T14:33:27Z"} |
| 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-16T13:30:23Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:37:49Z"} |
| 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-15T14:22:23Z"} |
| 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-14T14:09:45Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:11:19Z"} |
| 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-10T13:55:51Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:38:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |