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 | 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 |
|---|
| 01a0caad-79cf-78c0-9f7f-3043d6605a74 | XLI | 2026-09-22 15:52 | call_ratio_spread | 2 | 2 | 172 | 62780.00 | long | ask | 170.4600 | 0.4900 | ["173","195"] | ["0.1929","0.1862"] | ["177.72","212.28"] | ["ARCO","EDGO"] | 173.0000 | 195.0000 | 87 | 87 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:52:45Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0caad-71ff-7913-ae5a-e07e939efea8 | XLI | 2026-09-22 15:52 | call_ratio_spread | 2 | 2 | 180 | 65880.00 | long | ask | 170.4650 | 0.6300 | ["173","195"] | ["0.1934","0.1862"] | ["177.74","212.26"] | ["C2OX","EDGO"] | 173.0000 | 195.0000 | 87 | 87 | false | true | false | ||||||||||
| 01a0caa4-138f-70e2-a391-3c4e280fdaa6 | XLI | 2026-09-22 15:42 | call_ratio_spread | 2 | 4 | 94 | 48595.00 | long | ask | 170.2800 | 0.6700 | ["170","195"] | ["0.1864","0.1782"] | ["176.46","213.54"] | ["C2OX","EDGO","XCBO","XISX"] | 170.0000 | 195.0000 | 115 | 115 | false | false | false | ||||||||||
| 01a0caa4-138f-70e2-a391-3c3e6239f36e | XLI | 2026-09-22 15:42 | call_ratio_spread | 2 | 7 | 116 | 59845.00 | long | ask | 170.2800 | 0.6700 | ["170","195"] | ["0.1861","0.1778"] | ["176.46","213.54"] | ["ARCO","EMLD","MCRY","SPHR","XBOX","XMIO","XPHO"] | 170.0000 | 195.0000 | 115 | 115 | false | false | false | ||||||||||
| 01a0caa4-138f-70e2-a391-3c2f5a7b51a0 | XLI | 2026-09-22 15:42 | call_ratio_spread | 2 | 5 | 78 | 39999.00 | long | ask | 170.2800 | 0.6700 | ["170","195"] | ["0.1852","0.1771"] | ["176.45","213.55"] | ["AMXO","ARCO","MCRY","XMIO","XPHO"] | 170.0000 | 195.0000 | 115 | 115 | false | false | false | ||||||||||
| 01a0c96c-b49e-79d2-96eb-4d80bd19a096 | XLI | 2026-09-22 10:02 | call_ratio_spread | 2 | 4 | 54 | 27750.00 | long | ask | 169.9300 | 0.6600 | ["170","195"] | ["0.1882","0.1822"] | ["176.25","213.75"] | ["C2OX","EDGO","XCBO","XISX"] | 170.0000 | 195.0000 | 115 | 115 | false | true | false | ||||||||||
| 01a0c96c-b49e-79d2-96eb-4d482db92093 | XLI | 2026-09-22 10:02 | call_ratio_spread | 2 | 5 | 60 | 30652.00 | long | ask | 169.9300 | 0.6600 | ["170","195"] | ["0.1875","0.1814"] | ["176.25","213.75"] | ["ARCO","MCRY","SPHR","XBOX","XPHO"] | 170.0000 | 195.0000 | 115 | 115 | false | true | false | ||||||||||
| 01a0c58d-d0a6-7a30-b65b-796faa456b0e | XLI | 2026-09-21 15:59 | call_ratio_spread | 2 | 1 | 78 | 28119.00 | long | ask | 169.9500 | 0.2300 | ["173","195"] | ["0.1959","0.1892"] | ["177.59","212.41"] | ["EDGO"] | 173.0000 | 195.0000 | 88 | 88 | false | true | false | ||||||||||
| 01a0c58d-d0a6-7a30-b65b-795c13249b88 | XLI | 2026-09-21 15:59 | call_ratio_spread | 2 | 1 | 120 | 43200.00 | long | ask | 169.9400 | 0.2300 | ["173","195"] | ["0.1960","0.1889"] | ["177.60","212.40"] | ["EDGO"] | 173.0000 | 195.0000 | 88 | 88 | false | true | false | ||||||||||
| 01a0c58b-f7fe-7243-82b5-f72fdb82524e | XLI | 2026-09-21 15:57 | call_ratio_spread | 2 | 1 | 220 | 79090.00 | long | ask | 169.9900 | 0.6600 | ["173","195"] | ["0.1944","0.1893"] | ["177.55","212.45"] | ["EDGO"] | 173.0000 | 195.0000 | 88 | 88 | false | true | false | ||||||||||
| 01a0b4c7-1e27-7a51-aac7-7fe568e7d624 | XLI | 2026-09-18 09:49 | call_ratio_spread | 2 | 2 | 62 | 28923.00 | long | ask | 169.1600 | 0.3100 | ["170","195"] | ["0.1784","0.1757"] | ["175.89","214.11"] | ["EDGO","XCBO"] | 170.0000 | 195.0000 | 119 | 119 | false | true | false |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:52:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:42:26Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:42:26Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:42:26Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:02:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:02:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T20:00:12Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T20:00:12Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:58:18Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:49:14Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |