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 |
|---|
| 01a0ca5e-4c47-7673-92b0-ac95edf23053 | MCD | 2026-09-22 14:26 | put_vertical_spread | 2 | 1 | 10 | 193470.00 | long | ask | 251.0500 | 4.3000 | ["345","350"] | ["1.7628","1.8076"] | ["345.03"] | ["BATO"] | 345.0000 | 350.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:26:42Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c57b-1b97-7b71-a323-a7b131f2458e | MCD | 2026-09-21 15:39 | call_calendar | 2 | 1 | 129 | 131322.00 | long | ask | 248.8250 | 0.3500 | ["265"] | ["0.2333"] | [] | ["BATO"] | 265.0000 | 265.0000 | 60 | 88 | false | true | true | false | false | ||||||||
| 01a0c56b-40ff-7702-a948-157b03cb89b4 | MCD | 2026-09-21 15:22 | put_diagonal_spread | 2 | 1 | 80 | 1253600.00 | unknown | ask | 248.6001 | 5.3500 | ["320","330"] | ["0.4415","0.5188"] | [] | ["XBOX"] | 320.0000 | 330.0000 | 88 | 116 | false | false | true | true | false | ||||||||
| 01a0c47a-ed8e-7842-8d38-e968a81a7bbb | MCD | 2026-09-21 10:59 | other | 4 | 1 | 16 | 103776.00 | unknown | ask | 247.2600 | 1.7900 | ["240","250","270","275"] | ["0.2190","0.2169","0.2373","0.2415"] | [] | ["XMIO"] | 240.0000 | 275.0000 | 60 | 452 | false | false | true | true | false | ||||||||
| 01a0b5a3-7c37-7250-9653-e8b063c1d550 | MCD | 2026-09-18 13:49 | call_vertical_spread | 2 | 1 | 60 | 303360.00 | long | ask | 249.0900 | 2.1000 | ["240","250"] | ["0.2218","0.2225"] | ["245.40"] | ["BATO"] | 240.0000 | 250.0000 | 272 | 272 | false | false | false | true | |||||||||
| 01a0b4fa-5f40-7a50-9a15-455d60abed54 | MCD | 2026-09-18 10:44 | put_vertical_spread | 2 | 1 | 45 | 215685.00 | long | ask | 250.0650 | 1.7000 | ["265","275"] | ["0.2602","0.2698"] | ["267.51"] | ["BATO"] | 265.0000 | 275.0000 | 91 | 91 | false | false | false | true | false | ||||||||
| 01a0b4b9-6a58-7fa3-830f-c2c7fb569614 | MCD | 2026-09-18 09:34 | other | 3 | 1 | 190 | 366700.00 | unknown | ask | 248.8950 | 2.1000 | ["240","255","285"] | ["0.2511","0.2292","0.2325"] | ["220.70","274.30"] | ["XBOX"] | 240.0000 | 285.0000 | 91 | 91 | false | true | false | true | true | ||||||||
| 01a0b007-6f93-7292-8ce0-e4316b58b7ae | MCD | 2026-09-17 11:41 | put_vertical_spread | 2 | 1 | 6 | 150714.00 | long | ask | 249.2926 | 9.4000 | ["350","400"] | ["0.3930","0.5005"] | ["350.05"] | ["XMIO"] | 350.0000 | 400.0000 | 491 | 491 | false | false | false | true | false | ||||||||
| 01a0afd4-a793-7480-801b-8f6ad3cb95f5 | MCD | 2026-09-17 10:45 | put_vertical_spread | 2 | 1 | 6 | 111684.00 | long | ask | 249.8100 | 3.5000 | ["340","345"] | ["2.9981","3.0904"] | ["340.02"] | ["XMIO"] | 340.0000 | 345.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0aad0-bfe3-7bf2-af73-2c3a26672c8e | MCD | 2026-09-16 11:23 | put_calendar | 2 | 1 | 20 | 214420.00 | long | ask | 250.2250 | 2.6500 | ["300"] | ["0.3129"] | [] | ["XMIO"] | 300.0000 | 300.0000 | 184 | 457 | false | false | true | false | false | ||||||||
| 01a0aa84-8443-7d80-ae06-33ba7a7afad3 | MCD | 2026-09-16 10:00 | call_ratio_spread | 2 | 3 | 70 | 148532.00 | long | ask | 249.2850 | 1.7000 | ["250","270"] | ["0.2282","0.2275"] | ["251.50","297.75"] | ["ARCO","EMLD","SPHR"] | 250.0000 | 270.0000 | 184 | 184 | false | true | false | true | |||||||||
| 01a0a5d7-f706-73b2-9871-8a5b7cf2aad5 | MCD | 2026-09-15 12:13 | put_vertical_spread | 2 | 6 | 49 | 127706.00 | long | ask | 254.4850 | 0.6000 | ["250","260"] | ["0.2452","0.2473"] | ["255.0"] | ["ARCO","BATO","C2OX","EMLD","SPHR","XBOX"] | 250.0000 | 260.0000 | 122 | 122 | false | false | false | true | |||||||||
| 01a0a0fe-3149-79c0-ba31-cfc811d1fdd9 | MCD | 2026-09-14 13:36 | put_calendar | 2 | 1 | 22 | 107668.00 | long | ask | 257.1300 | 2.5000 | ["280"] | ["0.2394"] | [] | ["XMIO"] | 280.0000 | 280.0000 | 32 | 95 | false | false | true | false | false | ||||||||
| 01a08661-1508-7631-b7e4-b3580c5d0cf1 | MCD | 2026-09-09 09:35 | put_vertical_spread | 2 | 6 | 111 | 438006.00 | long | ask | 253.8100 | 0.9500 | ["250","260"] | ["0.2608","0.2628"] | ["255"] | ["BATO","EDGO","XCBO","XISX","XPHO"] | 250.0000 | 260.0000 | 281 | 281 | false | false | false | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:39:54Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:22:22Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:00:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:50:13Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:45: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-18T13:34:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:41:32Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:46:09Z"} |
| 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-16T15:23:31Z"} |
| 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:00:19Z"} |
| 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-15T16:13:16Z"} |
| 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-14T17:37:27Z"} |
| 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-09T13:35:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |