core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg677,480 rows| 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 |
|---|
| 01a0f285-32b7-7642-847c-789776400061 | GLD | 2026-09-30 09:33 | risk_reversal | 2 | 1 | 51 | 136170.00 | long | bid | 383.9850 | 0.3000 | ["400","435"] | ["0.2264","0.2369"] | ["380.10"] | ["C2OX"] | 400.0000 | 435.0000 | 79 | 79 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-30T13:33:39Z"} | 2026-09-30 | 2026-09-30 17:15 | 2026-09-30 17:15 |
| 01a0ee8c-42c7-7e20-8b87-298a25665e82 | GLD | 2026-09-29 15:02 | risk_reversal | 2 | 3 | 46 | 128792.00 | long | bid | 382.3400 | 0.4978 | ["400","435"] | ["0.2308","0.2400"] | ["378.7"] | ["EMLD","SPHR","XPHO"] | 400.0000 | 435.0000 | 80 | 80 | false | false | false | ||||||||||
| 01a0e881-d40f-72e2-8400-509b4db7cbed | GLD | 2026-09-28 10:53 | risk_reversal | 2 | 2 | 54 | 169020.00 | long | bid | 377.3950 | 0.3400 | ["400","435"] | ["0.2375","0.2478"] | ["374.70"] | ["EMLD","SPHR"] | 400.0000 | 435.0000 | 81 | 81 | false | false | false | true | |||||||||
| 01a0e881-d40f-72e2-8400-508289ced7ff | GLD | 2026-09-28 10:53 | risk_reversal | 2 | 4 | 46 | 144056.00 | long | bid | 377.3950 | 0.5413 | ["400","435"] | ["0.2377","0.2480"] | ["374.7"] | ["EMLD","SPHR","XPHO"] | 400.0000 | 435.0000 | 81 | 81 | false | false | false | ||||||||||
| 01a0d49e-f657-7e62-9175-2cac4bb944b3 | GLD | 2026-09-24 14:12 | risk_reversal | 2 | 1 | 18 | 166356.00 | long | bid | 391.1600 | 7.3000 | ["405","470"] | ["0.2658","0.2495"] | ["404.40"] | ["XCBO"] | 405.0000 | 470.0000 | 813 | 813 | false | false | false | true | |||||||||
| 01a0d49e-f657-7e62-9175-2c91bef633f2 | GLD | 2026-09-24 14:12 | risk_reversal | 2 | 6 | 30 | 277544.00 | long | bid | 391.1600 | 7.3000 | ["405","470"] | ["0.2660","0.2497"] | ["404.4"] | ["ARCO","EMLD","MCRY","SPHR","XISX","XPHO"] | 405.0000 | 470.0000 | 813 | 813 | false | false | false | ||||||||||
| 01a0d44c-9097-7623-b58a-df99b7317193 | GLD | 2026-09-24 12:42 | risk_reversal | 2 | 4 | 52 | 114676.00 | short | bid | 392.7200 | 0.3077 | ["390","400"] | ["0.2154","0.2165"] | ["400.45"] | ["ARCO","BATO","EMLD","SPHR"] | 390.0000 | 400.0000 | 57 | 57 | false | true | false | ||||||||||
| 01a0cf63-f917-7e81-873c-b45d4ac840cb | GLD | 2026-09-23 13:50 | risk_reversal | 2 | 6 | 25 | 235162.00 | short | bid | 393.3450 | 7.6500 | ["405","470"] | ["0.2686","0.2519"] | ["470.20"] | ["ARCO","EMLD","SPHR","XISX"] | 405.0000 | 470.0000 | 814 | 814 | false | false | false | ||||||||||
| 01a0cef4-08d7-7e51-a211-dff2cc144f21 | GLD | 2026-09-23 11:48 | risk_reversal | 2 | 4 | 12 | 113816.00 | short | bid | 392.7200 | 5.2125 | ["405","470"] | ["0.2696","0.2546"] | ["470.10"] | ["MCRY","XBOX","XISX","XPHO"] | 405.0000 | 470.0000 | 814 | 814 | false | false | false | ||||||||||
| 01a0cef4-08d7-7e51-a211-dfd213187946 | GLD | 2026-09-23 11:48 | risk_reversal | 2 | 6 | 41 | 389892.00 | short | bid | 392.7200 | 5.2366 | ["405","470"] | ["0.2702","0.2552"] | ["470.10"] | ["ARCO","EMLD","MCRY","SPHR","XISX","XPHO"] | 405.0000 | 470.0000 | 814 | 814 | false | false | false | ||||||||||
| 01a0ab81-00fb-72a3-831a-51e39e4b78a0 | GLD | 2026-09-16 14:35 | risk_reversal | 2 | 2 | 150 | 783000.00 | long | bid | 392.0350 | 1.3500 | ["400","405"] | ["0.2459","0.2453"] | ["398.50"] | ["AMXO"] | 400.0000 | 405.0000 | 184 | 184 | false | false | false | true | |||||||||
| 01a09182-66d0-71a1-a5de-13272f388465 | GLD | 2026-09-11 13:27 | risk_reversal | 2 | 1 | 850 | 343400.00 | short | bid | 400.3768 | 0.1300 | ["390","410"] | ["0.2536","0.2585"] | ["410.52"] | ["AMXO"] | 390.0000 | 410.0000 | 7 | 7 | false | true | false | true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T19:02:49Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:53:51Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:53:51Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:13:27Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:13:27Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:43:12Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:51:03Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:48:28Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:48:28Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:36:07Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:27:44Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |