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 | 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 |
|---|
| 01a0ed6d-3666-7203-8056-71f17f034430 | SNOW | 2026-09-29 09:49 | call_calendar | 2 | 1 | 9 | 134901.00 | short | ask | 327.6400 | 12.0000 | ["500"] | ["0.5620"] | [] | ["XMIO"] | 500.0000 | 500.0000 | 808 | 843 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-29T13:49:22Z"} | 2026-09-29 | 2026-09-29 17:15 | 2026-09-29 17:15 |
| 01a0e897-8e8f-7320-90bb-453c188da615 | SNOW | 2026-09-28 11:17 | call_calendar | 2 | 2 | 18 | 263520.00 | short | ask | 329.7001 | 12.4000 | ["500"] | ["0.5485"] | [] | ["ARCO","XISX"] | 500.0000 | 500.0000 | 809 | 844 | false | true | true | false | |||||||||
| 01a0e897-8aa7-7772-b090-b699f560c6bd | SNOW | 2026-09-28 11:17 | call_calendar | 2 | 2 | 8 | 117120.00 | short | ask | 329.7001 | 12.4000 | ["500"] | ["0.5485"] | [] | ["ARCO","XISX"] | 500.0000 | 500.0000 | 809 | 844 | false | true | true | false | |||||||||
| 01a0e897-5bc6-7960-a97b-05c390e713a0 | SNOW | 2026-09-28 11:17 | call_calendar | 2 | 10 | 20 | 293588.00 | short | bid | 329.7001 | 13.9500 | ["500"] | ["0.5495"] | [] | ["AMXO","ARCO","C2OX","EDGO","EMLD","MCRY","XCBO","XISX","XMIO","XPHO"] | 500.0000 | 500.0000 | 809 | 844 | false | true | true | ||||||||||
| 01a0da17-101e-73d2-9149-bce56b45c7e0 | SNOW | 2026-09-25 15:42 | call_calendar | 2 | 1 | 6 | 195654.00 | short | ask | 337.6600 | 13.2000 | ["175"] | ["1.4054"] | [] | ["XMIO"] | 175.0000 | 175.0000 | 14 | 28 | false | false | true | false | |||||||||
| 01a0c522-511e-7901-ac75-033a388b8add | SNOW | 2026-09-21 14:02 | call_calendar | 2 | 1 | 5 | 229655.00 | short | bid | 333.5900 | 12.9500 | ["120"] | ["0.6210"] | [] | ["XCBO"] | 120.0000 | 120.0000 | 487 | 816 | false | false | true | false | |||||||||
| 01a0b5de-9907-71b0-a7b0-dd9cacff96d0 | SNOW | 2026-09-18 14:54 | call_calendar | 2 | 1 | 7 | 160384.00 | short | ask | 334.4200 | 10.4500 | ["220"] | ["12.6585"] | [] | ["XMIO"] | 220.0000 | 220.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0b550-bc9f-7792-af75-b2f3488f10bf | SNOW | 2026-09-18 12:19 | call_calendar | 2 | 2 | 20 | 737636.00 | short | bid | 333.7443 | 11.5500 | ["150"] | ["10.1332"] | [] | ["SPHR","XCBO"] | 150.0000 | 150.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0b4e9-3c87-7e53-9059-fb605da954c2 | SNOW | 2026-09-18 10:26 | call_calendar | 2 | 1 | 10 | 348040.00 | short | ask | 333.1201 | 7.2000 | ["160"] | ["7.8118"] | [] | ["XMIO"] | 160.0000 | 160.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0b4e8-b3cf-74c0-9dce-e3407a2a1794 | SNOW | 2026-09-18 10:25 | call_calendar | 2 | 1 | 4 | 123608.00 | short | bid | 333.2900 | 12.3500 | ["180"] | ["7.1809"] | [] | ["EMLD"] | 180.0000 | 180.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0b4bb-817f-7a02-907f-efbebb2556be | SNOW | 2026-09-18 09:36 | call_calendar | 2 | 1 | 25 | 440800.00 | short | ask | 335.0000 | 11.9500 | ["250"] | ["3.5070"] | [] | ["XMIO"] | 250.0000 | 250.0000 | 0 | 63 | false | false | true | false | |||||||||
| 01a0affd-3e33-7fe3-b511-174a162dd251 | SNOW | 2026-09-17 11:30 | call_calendar | 2 | 1 | 10 | 228700.00 | short | ask | 343.1800 | 8.6000 | ["230"] | ["2.6409"] | [] | ["XMIO"] | 230.0000 | 230.0000 | 1 | 64 | false | false | true | false | |||||||||
| 01a0aaee-755b-71f0-b709-9a4000132b33 | SNOW | 2026-09-16 11:55 | call_calendar | 2 | 2 | 5 | 129809.00 | short | ask | 334.5650 | 7.6500 | ["210"] | ["2.0288"] | [] | ["XCBO","XISX"] | 210.0000 | 210.0000 | 2 | 156 | false | false | true | false | |||||||||
| 01a09193-9d10-7b73-9323-634c49841d7d | SNOW | 2026-09-11 13:46 | call_calendar | 2 | 3 | 3 | 100042.00 | short | ask | 325.4050 | 11.2167 | ["170"] | ["0.6936"] | [] | ["SPHR","XBOX"] | 170.0000 | 170.0000 | 189 | 279 | false | false | true | false | |||||||||
| 01a08789-29e9-7b72-b225-6f50e885e3b7 | SNOW | 2026-09-09 14:58 | call_calendar | 2 | 1 | 2 | 108290.00 | short | bid | 333.2800 | 8.3000 | ["65"] | ["2.2118"] | [] | ["ARCO"] | 65.0000 | 65.0000 | 9 | 499 | false | false | true | false | |||||||||
| 01a08789-2600-7392-8cdb-a7bebecffc64 | SNOW | 2026-09-09 14:58 | call_calendar | 2 | 1 | 2 | 108254.00 | short | bid | 333.2400 | 7.9500 | ["65"] | ["1.9380"] | [] | ["AMXO"] | 65.0000 | 65.0000 | 9 | 499 | false | false | true | false | |||||||||
| 01a08288-6301-7ae0-b449-294b37368be4 | SNOW | 2026-09-08 15:39 | call_calendar | 2 | 1 | 3 | 155139.00 | short | bid | 336.8450 | 11.0500 | ["85"] | ["2.2457"] | [] | ["XPHO"] | 85.0000 | 85.0000 | 10 | 829 | false | false | true | false | |||||||||
| 01a08288-5748-7f41-a187-fc711df7fd32 | SNOW | 2026-09-08 15:39 | call_calendar | 2 | 1 | 3 | 155217.00 | short | bid | 336.8450 | 11.0500 | ["85"] | ["2.3531"] | [] | ["XMIO"] | 85.0000 | 85.0000 | 10 | 829 | false | false | true | false | |||||||||
| 01a0826e-0118-7193-a1eb-333acf031502 | SNOW | 2026-09-08 15:10 | call_calendar | 2 | 1 | 2 | 109442.00 | short | ask | 338.2150 | 12.1500 | ["70"] | ["0.9523"] | [] | ["ARCO"] | 70.0000 | 70.0000 | 129 | 829 | false | false | true | false | |||||||||
| 01a08191-dda0-7c10-a25d-595cf987f720 | SNOW | 2026-09-08 11:10 | call_calendar | 2 | 2 | 4 | 110300.00 | short | bid | 337.4700 | 5.5500 | ["200"] | ["1.3668"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 10 | 38 | false | false | true | false | |||||||||
| 01a0813d-4948-7b03-89a5-a057fca85fcf | SNOW | 2026-09-08 09:37 | call_calendar | 2 | 1 | 44 | 298012.00 | short | ask | 338.6450 | 9.4500 | ["360"] | ["0.5054"] | [] | ["XMIO"] | 360.0000 | 360.0000 | 101 | 164 | false | true | true | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:17:22Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:17:22Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:17:22Z"} |
| 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-25T19:42:40Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:03:09Z"} |
| 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-18T18:54:22Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:19:56Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:26:38Z"} |
| 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:25:46Z"} |
| 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-18T13:36:28Z"} |
| 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:30:18Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:46:31Z"} |
| 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-09T18:59:01Z"} |
| 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-09T18:59:01Z"} |
| 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-08T19:40:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:40:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:10:57Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:10:17Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:38:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |