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 |
|---|
| 01a0ca9e-c42e-7083-b2e4-7070e4b7a9ea | BE | 2026-09-22 15:36 | risk_reversal | 3 | 1 | 15 | 292200.00 | long | ask | 274.2700 | 3.9000 | ["140","300","400"] | ["0.8598","0.8625","0.8639"] | ["301.90"] | ["XISX"] | 140.0000 | 400.0000 | 451 | 451 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:36:51Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ab2d-b4c3-7e71-8dfc-7e73686682c8 | BE | 2026-09-16 13:04 | risk_reversal | 2 | 1 | 10 | 121630.00 | long | ask | 270.1800 | 4.1500 | ["210","510"] | ["0.8873","0.8846"] | ["512.99"] | ["MCRY"] | 210.0000 | 510.0000 | 492 | 492 | false | true | false | true | |||||||||
| 01a0aac8-d873-77b3-b0cc-9f132bdcee86 | BE | 2026-09-16 11:14 | risk_reversal | 2 | 3 | 330 | 125703.00 | short | ask | 270.5400 | 0.4500 | ["255","300"] | ["1.0944","1.0458"] | ["253.06"] | ["AMXO","ARCO","XISX"] | 255.0000 | 300.0000 | 2 | 2 | false | true | false | true | |||||||||
| 01a0aac8-d48a-7730-94dd-d089d751c605 | BE | 2026-09-16 11:14 | risk_reversal | 2 | 2 | 270 | 103410.00 | short | ask | 270.5400 | 0.4422 | ["255","300"] | ["1.0973","1.0469"] | ["253.05"] | ["XCBO","XPHO"] | 255.0000 | 300.0000 | 2 | 2 | false | true | false | true | |||||||||
| 01a0a63b-7b96-7ce1-9beb-5a35ccf0f7b8 | BE | 2026-09-15 14:01 | risk_reversal | 2 | 2 | 824 | 449418.00 | short | ask | 261.1500 | 0.1309 | ["250","292.5"] | ["0.9558","0.9670"] | ["246.8"] | ["AMXO","XPHO"] | 250.0000 | 292.5000 | 3 | 3 | false | true | false | true | |||||||||
| 01a08161-1170-7f50-a935-4bf2e6ceb748 | BE | 2026-09-08 10:16 | risk_reversal | 2 | 2 | 14 | 122500.00 | long | ask | 274.9850 | 1.4000 | ["250","290"] | ["0.9352","0.9460"] | ["301.46"] | ["ARCO","XCBO"] | 250.0000 | 290.0000 | 101 | 101 | false | true | false | true | |||||||||
| 01a08161-01d1-7d40-ab6e-9935c93b8c61 | BE | 2026-09-08 10:16 | risk_reversal | 2 | 1 | 19 | 166250.00 | long | ask | 274.9850 | 0.3000 | ["250","290"] | ["0.9323","0.9487"] | ["301.76"] | ["XCBO"] | 250.0000 | 290.0000 | 101 | 101 | false | true | false | true | |||||||||
| 01a08161-01d1-7d40-ab6e-992a8aa26e12 | BE | 2026-09-08 10:16 | risk_reversal | 2 | 1 | 17 | 148750.00 | short | bid | 274.9850 | 0.5500 | ["250","290"] | ["0.9363","0.9450"] | ["301.34"] | ["ARCO"] | 250.0000 | 290.0000 | 101 | 101 | false | true | false | true | |||||||||
| 01a08161-01d1-7d40-ab6e-991468119d1f | BE | 2026-09-08 10:16 | risk_reversal | 2 | 2 | 16 | 140000.00 | long | ask | 275.0895 | 0.5500 | ["250","290"] | ["0.9321","0.9484"] | ["301.84"] | ["ARCO","XCBO"] | 250.0000 | 290.0000 | 101 | 101 | false | true | false | true | |||||||||
| 01a08160-fde8-7522-87d0-213f567934f0 | BE | 2026-09-08 10:16 | risk_reversal | 2 | 1 | 16 | 140000.00 | long | ask | 274.9850 | 0.6500 | ["250","290"] | ["0.9309","0.9499"] | ["301.90"] | ["ARCO"] | 250.0000 | 290.0000 | 101 | 101 | false | true | false | true | |||||||||
| 01a08160-fde8-7522-87d0-212013e430ce | BE | 2026-09-08 10:16 | risk_reversal | 2 | 1 | 13 | 113750.00 | short | bid | 274.9850 | 1.0000 | ["250","290"] | ["0.9363","0.9450"] | ["301.34"] | ["ARCO"] | 250.0000 | 290.0000 | 101 | 101 | false | true | false | true | |||||||||
| 01a08160-f230-7ad1-be5e-1268c5d61a54 | BE | 2026-09-08 10:16 | risk_reversal | 2 | 3 | 72 | 627984.00 | unknown | — | 275.0550 | 1.6000 | ["250","290"] | ["0.9305","0.9451"] | [] | ["ARCO","C2OX","EDGO"] | 250.0000 | 290.0000 | 101 | 101 | false | true | false | true | true | ||||||||
| 01a0813b-6100-7ee0-8f93-a0a09c3a89d6 | BE | 2026-09-08 09:35 | risk_reversal | 2 | 1 | 44 | 256432.00 | short | bid | 272.2530 | 1.9000 | ["190","230"] | ["0.8968","0.8841"] | ["281.78"] | ["EDGO"] | 190.0000 | 230.0000 | 38 | 38 | false | false | false | true | |||||||||
| 01a0813b-5d19-7153-91a1-56ed6447a332 | BE | 2026-09-08 09:35 | risk_reversal | 2 | 1 | 22 | 128171.00 | short | bid | 272.1550 | 2.2500 | ["190","230"] | ["0.8953","0.8867"] | ["281.78"] | ["XCBO"] | 190.0000 | 230.0000 | 38 | 38 | false | false | false | true | |||||||||
| 01a0813b-5d19-7153-91a1-56dccd48891a | BE | 2026-09-08 09:35 | risk_reversal | 2 | 2 | 67 | 392419.00 | short | bid | 272.4850 | 1.7000 | ["190","230"] | ["0.9096","0.8826"] | ["281.77"] | ["AMXO","XMIO"] | 190.0000 | 230.0000 | 38 | 38 | false | false | false | true | |||||||||
| 01a0813b-5d19-7153-91a1-56cc34167d54 | BE | 2026-09-08 09:35 | risk_reversal | 2 | 1 | 30 | 175230.00 | short | bid | 272.4850 | 1.7000 | ["190","230"] | ["0.9035","0.8796"] | ["281.77"] | ["XPHO"] | 190.0000 | 230.0000 | 38 | 38 | false | false | false | true | |||||||||
| 01a0813b-3dd9-7221-955d-61f6a56e0b44 | BE | 2026-09-08 09:35 | risk_reversal | 2 | 2 | 58 | 335994.00 | unknown | — | 271.8750 | 1.4500 | ["190","230"] | ["0.8918","0.8832"] | [] | ["ARCO","EDGO"] | 190.0000 | 230.0000 | 38 | 38 | false | false | false | true | true | mlet | |||||||
| 01a0813b-3dd9-7221-955d-61e773f59ee1 | BE | 2026-09-08 09:35 | risk_reversal | 2 | 6 | 142 | 820458.00 | long | ask | 271.8750 | 1.4489 | ["190","230"] | ["0.8859","0.8804"] | ["281.50"] | ["AMXO","XBOX","XCBO","XISX","XMIO","XPHO"] | 190.0000 | 230.0000 | 38 | 38 | false | false | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:05:34Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:15:26Z"} |
| 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:15:26Z"} |
| 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-15T18:02:18Z"} |
| 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-08T14:17:14Z"} |
| 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-08T14:17:14Z"} |
| 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-08T14:17:14Z"} |
| 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-08T14:17:14Z"} |
| 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-08T14:17:14Z"} |
| 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-08T14:17:14Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:17:14Z"} |
| 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:35:50Z"} |
| 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:35:50Z"} |
| 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:35:50Z"} |
| 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:35:50Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:35:50Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:35:50Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |