core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| directiontext |
|---|
| 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 |
|---|
| 01a0ced4-307e-77b1-bca9-7c67d14ddb1b | EXPE | 2026-09-23 11:13 | put_vertical_spread | 2 | 1 | 114 | 136116.00 | unknown | bid | 259.1050 | 3.2000 | ["250","260"] | ["0.4803","0.4767"] | ["249.03"] | ["XMIO"] | 250.0000 | 260.0000 | 9 | 9 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T15:13:32Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0cebb-802f-7612-ba45-f9e1a4121eaa | EXPE | 2026-09-23 10:46 | risk_reversal | 2 | 1 | 4991 | 15896335.00 | long | ask | 263.5275 | 2.3000 | ["220","330"] | ["0.5110","0.4922"] | ["331.85"] | ["SPHR"] | 220.0000 | 330.0000 | 177 | 177 | false | true | |||||||||||
| 01a0ceba-f38e-7663-93cb-5ec9d1f14670 | EXPE | 2026-09-23 10:45 | risk_reversal | 2 | 1 | 5000 | 15645000.00 | long | ask | 263.3700 | 3.8000 | ["220","330"] | ["0.5053","0.4888"] | ["331.85"] | ["SPHR"] | 220.0000 | 330.0000 | 177 | 177 | false | true | |||||||||||
| 01a0ceb5-466f-76b1-ae39-216b6ba1ab2e | EXPE | 2026-09-23 10:39 | risk_reversal | 2 | 1 | 4991 | 15347325.00 | short | ask | 263.2450 | 3.0000 | ["220","330"] | ["0.5242","0.4649"] | ["219.15"] | ["SPHR"] | 220.0000 | 330.0000 | 177 | 177 | true | true | |||||||||||
| 01a0ca9f-73f7-74b0-b9c7-1c599b8f76e9 | EXPE | 2026-09-22 15:37 | put_vertical_spread | 2 | 1 | 25 | 105350.00 | long | ask | 272.7775 | 4.1000 | ["260","270"] | ["0.4995","0.4956"] | ["265.40"] | ["XMIO"] | 260.0000 | 270.0000 | 87 | 87 | false | true | |||||||||||
| 01a0ca02-2e3f-7413-ba50-b703ce475049 | EXPE | 2026-09-22 12:45 | risk_reversal | 2 | 1 | 300 | 4410000.00 | long | bid | 267.9800 | 8.5000 | ["370","380"] | ["0.4985","0.4685"] | ["285"] | ["XBOX"] | 370.0000 | 380.0000 | 486 | 486 | false | false | |||||||||||
| 01a0c435-419f-7b82-a8cc-058e3f26d9b0 | EXPE | 2026-09-21 09:43 | call_vertical_spread | 2 | 1 | 50 | 301400.00 | short | bid | 281.2250 | 4.4000 | ["280","290"] | ["0.4784","0.4750"] | ["284.62"] | ["XCBO"] | 280.0000 | 290.0000 | 116 | 116 | false | ||||||||||||
| 01a0b597-7de7-74b0-bfd9-ce2ad88a63b8 | EXPE | 2026-09-18 13:36 | put_diagonal_spread | 2 | 1 | 40 | 132280.00 | short | ask | 278.5100 | 4.9000 | ["292.5","295"] | ["0.4583","2.5577"] | [] | ["XCBO"] | 292.5000 | 295.0000 | 0 | 7 | false | false | |||||||||||
| 01a0b578-2677-7e03-9254-0bdf9321ee04 | EXPE | 2026-09-18 13:02 | call_diagonal_spread | 2 | 1 | 400 | 1560000.00 | unknown | ask | 278.1800 | 3.6000 | ["310","360"] | ["0.4883","0.4714"] | [] | ["ARCO"] | 310.0000 | 360.0000 | 91 | 272 | false | ||||||||||||
| 01a0b516-3c0f-7f70-9828-1a7d699b1012 | EXPE | 2026-09-18 11:15 | put_butterfly_spread | 3 | 4 | 70 | 216520.00 | long | ask | 279.2800 | 6.5000 | ["200","230","260"] | ["0.5177","0.4993","0.4899"] | ["203.96","256.04"] | ["AMXO","XBOX","XMIO","XPHO"] | 200.0000 | 260.0000 | 182 | 182 | false | ||||||||||||
| 01a0b516-3827-7e00-aaa6-4b8061f66bf8 | EXPE | 2026-09-18 11:15 | put_butterfly_spread | 3 | 2 | 42 | 130435.00 | unknown | ask | 279.2800 | 6.5000 | ["200","230","260"] | ["0.5111","0.5004","0.4953"] | ["224.06"] | ["XBOX","XPHO"] | 200.0000 | 260.0000 | 182 | 182 | false | ||||||||||||
| 01a0b50c-9b37-7570-82df-415cef3ab966 | EXPE | 2026-09-18 11:04 | put_butterfly_spread | 3 | 4 | 44 | 133592.00 | short | bid | 281.7450 | 5.7000 | ["200","230","260"] | ["0.5289","0.5037","0.4906"] | ["203.89","256.11"] | ["AMXO","XCBO","XPHO"] | 200.0000 | 260.0000 | 182 | 182 | false | ||||||||||||
| 01a0b50c-8f7f-7f80-b1c3-1c7b7719a07e | EXPE | 2026-09-18 11:04 | put_butterfly_spread | 3 | 2 | 46 | 139704.00 | short | bid | 281.7450 | 5.7000 | ["200","230","260"] | ["0.5158","0.5039","0.4979"] | ["203.88","256.12"] | ["AMXO","XBOX"] | 200.0000 | 260.0000 | 182 | 182 | false | ||||||||||||
| 01a0b50c-8f7f-7f80-b1c3-1c5750d08e40 | EXPE | 2026-09-18 11:04 | put_butterfly_spread | 3 | 3 | 72 | 218160.00 | short | bid | 281.7450 | 5.7000 | ["200","230","260"] | ["0.5271","0.5032","0.4907"] | ["203.88","256.12"] | ["AMXO","XMIO","XPHO"] | 200.0000 | 260.0000 | 182 | 182 | false | ||||||||||||
| 01a0b50c-8b98-7572-8b6d-cde40540f535 | EXPE | 2026-09-18 11:04 | put_butterfly_spread | 3 | 2 | 52 | 157808.00 | unknown | bid | 281.7450 | 5.7000 | ["200","230","260"] | ["0.5178","0.5037","0.4964"] | ["194.81"] | ["XBOX","XPHO"] | 200.0000 | 260.0000 | 182 | 182 | false | ||||||||||||
| 01a0b50c-7428-77c0-94a6-e14d51109f84 | EXPE | 2026-09-18 11:04 | put_butterfly_spread | 3 | 2 | 66 | 199569.00 | unknown | bid | 281.7450 | 5.7000 | ["200","230","260"] | ["0.5137","0.5029","0.4969"] | ["219.84"] | ["XBOX","XPHO"] | 200.0000 | 260.0000 | 182 | 182 | false | ||||||||||||
| 01a0b4eb-b93f-7380-905d-cc274c21f7cf | EXPE | 2026-09-18 10:29 | other | 3 | 1 | 100 | 523000.00 | unknown | — | 281.3750 | 7.1000 | ["220","260","360"] | ["0.5035","0.5066","0.4640"] | [] | ["XBOX"] | 220.0000 | 360.0000 | 182 | 182 | true | true | false | true | |||||||||
| 01a0b0b0-175b-7d10-88bd-68be6251acc6 | EXPE | 2026-09-17 14:45 | put_ladder | 6 | 1 | 898 | 6321908.00 | unknown | — | 283.7400 | 20.2000 | ["305","307.5","310","312.5","315","317.5"] | ["1.2968","1.5864","1.6865","1.3823","1.7621","1.9720"] | [] | ["XBOX"] | 305.0000 | 317.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a0b0a6-18c4-7193-8722-ce9edbe2c8ec | EXPE | 2026-09-17 14:34 | other | 4 | 1 | 20 | 118180.00 | unknown | — | 283.5500 | 13.0000 | ["280","290","295","300"] | ["0.4332","0.4293","0.2586","0.5150"] | [] | ["XCBO"] | 280.0000 | 300.0000 | 1 | 36 | false | false | true | true | |||||||||
| 01a0b0a0-4c63-7dd0-887f-292fb645f172 | EXPE | 2026-09-17 14:28 | put_ladder | 5 | 1 | 1540 | 8463080.00 | unknown | — | 283.3200 | 18.0000 | ["310","312.5","315","317.5","330"] | ["1.6171","1.6519","1.6443","1.8632","2.3540"] | [] | ["XBOX"] | 310.0000 | 330.0000 | 1 | 1 | true | false | false | ||||||||||
| 01a0aafb-b013-7dd3-9774-10b8142b961b | EXPE | 2026-09-16 12:10 | other | 4 | 1 | 20 | 119980.00 | unknown | — | 290.7200 | 6.4000 | ["280","290","295","300"] | ["0.5226","0.5090","0.5490","0.4931"] | [] | ["XPHO"] | 280.0000 | 300.0000 | 2 | 65 | false | false | true | true | |||||||||
| 01a0aaec-621b-7ff0-9a9a-44139229d5ae | EXPE | 2026-09-16 11:53 | other | 4 | 1 | 20 | 154760.00 | unknown | — | 290.7800 | 6.8000 | ["290","295","300"] | ["0.5211","0.4607","0.4887"] | [] | ["XCBO"] | 290.0000 | 300.0000 | 9 | 65 | false | false | true | true | |||||||||
| 01a0a60d-66b6-7390-bc68-12974ed5479c | EXPE | 2026-09-15 13:11 | call_frontspread | 2 | 2 | 1711 | 8294141.00 | long | bid | 292.8600 | 7.1000 | ["250","280"] | ["1.3592","0.5448"] | ["291.66"] | ["XCBO"] | 250.0000 | 280.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a605-11e6-7d61-9db3-b16901b176a9 | EXPE | 2026-09-15 13:02 | call_vertical_spread | 2 | 1 | 89 | 510860.00 | unknown | — | 292.6400 | 7.3000 | ["250","280"] | ["0.9040","0.5872"] | [] | ["XISX"] | 250.0000 | 280.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a603-7ba6-75d1-98bc-03043ab81912 | EXPE | 2026-09-15 13:00 | call_vertical_spread | 2 | 1 | 100 | 568100.00 | short | bid | 292.8250 | 4.6000 | ["250","280"] | ["1.2408","0.5222"] | ["278.51"] | ["XISX"] | 250.0000 | 280.0000 | 3 | 3 | false | ||||||||||||
| 01a0a602-b46e-7200-b466-9a76e4985cd8 | EXPE | 2026-09-15 12:59 | call_vertical_spread | 2 | 1 | 100 | 568100.00 | short | bid | 292.9750 | 4.6000 | ["250","280"] | ["1.2008","0.5026"] | ["278.51"] | ["XISX"] | 250.0000 | 280.0000 | 3 | 3 | false | ||||||||||||
| 01a08bbd-1b51-72e2-88da-0d5040224668 | EXPE | 2026-09-10 10:33 | put_diagonal_spread | 2 | 1 | 45 | 172350.00 | long | bid | 278.1500 | 5.8000 | ["295","297.5"] | ["0.4624","0.7570"] | [] | ["XISX"] | 295.0000 | 297.5000 | 1 | 8 | false | false | |||||||||||
| 01a08b96-45e8-77e3-888c-b64aa52aa656 | EXPE | 2026-09-10 09:51 | put_calendar | 2 | 1 | 45 | 281205.00 | short | ask | 275.2950 | 6.0000 | ["305"] | ["0.8710"] | [] | ["XMIO"] | 305.0000 | 305.0000 | 1 | 22 | false | false | |||||||||||
| 01a0874a-86c0-79a3-881c-fa5fb66b51ce | EXPE | 2026-09-09 13:50 | other | 2 | 1 | 31 | 176142.00 | unknown | — | 272.6200 | 5.0000 | ["240","270"] | ["0.5053","0.4930"] | [] | ["MCRY"] | 240.0000 | 270.0000 | 100 | 373 | false | true | true | true | |||||||||
| 01a0867d-6ed8-7b51-abed-728df6def0e8 | EXPE | 2026-09-09 10:06 | other | 2 | 7 | 22 | 126162.00 | unknown | — | 266.7000 | 3.9000 | ["220","270"] | ["0.5346","0.4586"] | [] | ["C2OX","EDGO","XBOX","XMIO"] | 220.0000 | 270.0000 | 37 | 37 | false | false | false | true | |||||||||
| 01a08294-bf11-7350-8189-020c2d6b8010 | EXPE | 2026-09-08 15:52 | other | 2 | 1 | 35 | 178710.00 | unknown | — | 275.6900 | 6.0000 | ["285","315"] | ["0.4526","0.4626"] | [] | ["AMXO"] | 285.0000 | 315.0000 | 10 | 10 | false | false | false | true | |||||||||
| 01a0828e-4ea0-7f02-80fc-f01791a28acd | EXPE | 2026-09-08 15:45 | put_vertical_spread | 2 | 2 | 8 | 101856.00 | long | ask | 274.7300 | 5.4000 | ["337.5","340"] | ["0.3244","0.8256"] | ["337.52"] | ["C2OX"] | 337.5000 | 340.0000 | 10 | 10 | false | false |
| true |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:47:01Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:46:23Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:39:55Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:37:23Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:45:47Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:43:41Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:36:56Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:02:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:15:51Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:15:51Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:05:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:05:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:05:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:05:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:04:49Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:29:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:45:42Z"} |
| 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-17T18:34:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:28:37Z"} |
| 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-16T16:11:11Z"} |
| 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:54:05Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:12:25Z"} |
| 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:02:57Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:01:18Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:00:25Z"} |
| 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-10T14:34:00Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:51:24Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:50:02Z"} |
| 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-09T14:06:04Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:53:11Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:46:02Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |