core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0ceac-2a67-7c80-b2fc-7b4d69ccbb5a | DAVE | 2026-09-23 10:29 | other | 4 | 3 | 10 | 119800.00 | unknown | — | 319.4100 | 32.9000 | ["210","240","290","300"] | ["0.7779","0.7559","1.6237","1.4007"] | [] | ["XISX","XPHO"] | 210.0000 | 300.0000 | 2 | 114 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T14:29:53Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0b5ef-9897-7c71-85f9-ae6f8ee514cf | DAVE | 2026-09-18 15:12 | other | 4 | 1 | 10 | 122810.00 | unknown | — | 341.3150 | 18.7000 | ["345","355"] | ["0.6692","0.6741"] | [] | ["XPHO"] | 345.0000 | 355.0000 | 21 | 42 | false | false | true | true | |||||||||
| 01a0ab73-02f3-7e41-b15b-4d22d7d3fcf8 | DAVE | 2026-09-16 14:20 | strangle | 2 | 1 | 20 | 130000.00 | unknown | — | 373.4500 | 11.2000 | ["370","660"] | ["0.7291","0.7063"] | [] | ["XISX"] | 370.0000 | 660.0000 | 121 | 121 | false | true | false | true | |||||||||
| 01a0ab65-7633-7461-8627-5f113ecd8e9e | DAVE | 2026-09-16 14:05 | other | 3 | 3 | 25 | 203480.00 | unknown | — | 372.1600 | 20.7000 | ["370","372.5","660"] | ["0.7275","0.6773","0.7148"] | [] | ["ARCO","XMIO"] | 370.0000 | 660.0000 | 9 | 121 | false | true | true | true | |||||||||
| 01a0aa95-ca23-7760-9477-e60d51523b91 | DAVE | 2026-09-16 10:18 | call_vertical_spread | 2 | 1 | 3 | 171660.00 | unknown | — | 373.3432 | 12.4000 | ["85","90"] | ["8.1461","7.8347"] | [] | ["XCBO"] | 85.0000 | 90.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0a636-ef86-7b60-9352-d9dec9ba6569 | DAVE | 2026-09-15 13:56 | put_vertical_spread | 2 | 1 | 10 | 187850.00 | unknown | — | 376.1000 | 6.4000 | ["340","350"] | ["0.7344","0.7324"] | [] | ["XCBO"] | 340.0000 | 350.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5d4-16d6-7aa0-91e8-dfeb61d62e0f | DAVE | 2026-09-15 12:08 | other | 3 | 1 | 5 | 135130.00 | unknown | — | 377.6900 | 11.0000 | ["360","370","660"] | ["0.7299","0.7254","0.7019"] | [] | ["XCBO"] | 360.0000 | 660.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5d2-de57-7652-9128-d302ee63a916 | DAVE | 2026-09-15 12:07 | put_vertical_spread | 2 | 1 | 5 | 104525.00 | unknown | — | 377.6900 | 5.3000 | ["360","370"] | ["0.7314","0.7262"] | [] | ["XPHO"] | 360.0000 | 370.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5d2-6156-7b90-8129-9529d2e0592f | DAVE | 2026-09-15 12:07 | other | 3 | 1 | 10 | 269950.00 | unknown | — | 378.4600 | 9.3000 | ["360","370","660"] | ["0.7286","0.7259","0.7016"] | [] | ["XPHO"] | 360.0000 | 660.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5ce-b006-7d13-be49-d9510ece6a01 | DAVE | 2026-09-15 12:02 | put_vertical_spread | 2 | 1 | 10 | 208500.00 | unknown | — | 378.4600 | 5.3000 | ["360","370"] | ["0.7308","0.7263"] | [] | ["XCBO"] | 360.0000 | 370.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5cd-0e0e-7b82-9f32-8ccd28683440 | DAVE | 2026-09-15 12:01 | other | 3 | 1 | 5 | 133450.00 | unknown | — | 378.7450 | 10.9000 | ["360","370","660"] | ["0.7249","0.7190","0.6937"] | [] | ["XMIO"] | 360.0000 | 660.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5cb-ae7e-7ce3-9b87-c88e34d9e4f4 | DAVE | 2026-09-15 11:59 | put_vertical_spread | 2 | 1 | 5 | 103900.00 | unknown | — | 377.7201 | 5.9000 | ["360","370"] | ["0.7281","0.7215"] | [] | ["XCBO"] | 360.0000 | 370.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5bb-c446-7072-ad3a-1d1410d9ca56 | DAVE | 2026-09-15 11:42 | put_vertical_spread | 2 | 1 | 9 | 187065.00 | unknown | — | 377.4000 | 8.7000 | ["360","370"] | ["0.7298","0.7189"] | [] | ["XPHO"] | 360.0000 | 370.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5bb-6e56-7203-96a2-b1e0900763e6 | DAVE | 2026-09-15 11:41 | put_vertical_spread | 2 | 1 | 5 | 104025.00 | unknown | — | 377.4000 | 8.7000 | ["360","370"] | ["0.7303","0.7197"] | [] | ["XPHO"] | 360.0000 | 370.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5af-9afd-7791-abf2-f1cb8c41e73d | DAVE | 2026-09-15 11:29 | other | 3 | 1 | 15 | 405600.00 | unknown | — | 375.5903 | 13.4000 | ["360","370","660"] | ["0.7264","0.7308","0.6986"] | [] | ["XPHO"] | 360.0000 | 660.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5ae-c426-7ed1-a239-d890d17be331 | DAVE | 2026-09-15 11:28 | other | 3 | 1 | 10 | 269900.00 | unknown | — | 374.8400 | 13.8000 | ["360","370","660"] | ["0.7249","0.7264","0.7000"] | [] | ["XPHO"] | 360.0000 | 660.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5ae-7dd6-7661-a801-b10dd1990cdf | DAVE | 2026-09-15 11:27 | other | 3 | 1 | 10 | 270600.00 | unknown | — | 375.9500 | 13.8000 | ["360","370","660"] | ["0.7276","0.7315","0.6985"] | [] | ["XMIO"] | 360.0000 | 660.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5ab-5156-7cd1-81d7-07176002ed26 | DAVE | 2026-09-15 11:24 | strangle | 2 | 1 | 16 | 267840.00 | unknown | — | 375.7500 | 6.5000 | ["370","660"] | ["0.7242","0.6974"] | [] | ["XPHO"] | 370.0000 | 660.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5a6-7726-7462-91da-f93776133b4d | DAVE | 2026-09-15 11:19 | strangle | 2 | 1 | 10 | 167200.00 | unknown | — | 375.3200 | 6.2000 | ["370","660"] | ["0.7233","0.6973"] | [] | ["XCBO"] | 370.0000 | 660.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a5a4-217f-77a3-a8c0-d852bff29212 | DAVE | 2026-09-15 11:16 | strangle | 2 | 1 | 17 | 284750.00 | unknown | — | 375.5200 | 7.5000 | ["370","660"] | ["0.7250","0.6974"] | [] | ["XPHO"] | 370.0000 | 660.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0a583-995e-7961-81af-9e4b8b30e6fc | DAVE | 2026-09-15 10:40 | call_vertical_spread | 2 | 1 | 2 | 118580.00 | unknown | — | 382.9250 | 9.0000 | ["85","90"] | ["8.1869","7.8815"] | [] | ["XCBO"] | 85.0000 | 90.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a0b2-5b38-7883-98a2-aea1d4878788 | DAVE | 2026-09-14 12:13 | risk_reversal | 2 | 1 | 10 | 162520.00 | unknown | — | 370.1150 | 7.9000 | ["360","660"] | ["0.7496","0.6937"] | [] | ["XPHO"] | 360.0000 | 660.0000 | 494 | 494 | false | true | false | true | |||||||||
| 01a09192-f130-7223-be10-983ee9fe5f54 | DAVE | 2026-09-11 13:45 | strangle | 2 | 7 | 15 | 229200.00 | unknown | — | 356.6500 | 7.0000 | ["290","490"] | ["0.7393","0.7063"] | [] | ["AMXO","ARCO","BATO","EDGO","XCBO","XISX","XMIO"] | 290.0000 | 490.0000 | 497 | 497 | false | true | false | true | |||||||||
| 01a08cad-ad40-7202-a437-59cdfbba4808 | DAVE | 2026-09-10 14:56 | other | 3 | 1 | 5 | 116440.00 | unknown | — | 356.0800 | 8.7000 | ["350","660"] | ["0.7318","0.6928"] | [] | ["XCBO"] | 350.0000 | 660.0000 | 280 | 498 | false | true | true | true | |||||||||
| 01a08c9f-d260-7a62-9811-65363f0cd7c4 | DAVE | 2026-09-10 14:41 | other | 3 | 1 | 5 | 116835.00 | unknown | — | 355.5600 | 15.9000 | ["350","660"] | ["0.7337","0.6944"] | [] | ["XCBO"] | 350.0000 | 660.0000 | 280 | 498 | false | true | true | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:12:59Z"} |
| 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-16T18:21:10Z"} |
| 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-16T18:05:58Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:19:06Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:57:11Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:09:21Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:08:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:07:21Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:03:50Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:01:16Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:00:02Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:42:39Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:42:39Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:29:25Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:28:32Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:27:53Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:24:49Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:19:09Z"} |
| 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-15T15:16:41Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:41:00Z"} |
| 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-14T16:14:33Z"} |
| 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-11T17:45:37Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:56:25Z"} |
| 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-10T18:41:19Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |