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 |
|---|
| 01a0caa5-e84f-7531-8094-a3652823264b | META | 2026-09-22 15:44 | risk_reversal | 3 | 1 | 10 | 294450.00 | long | ask | 739.2950 | 7.6000 | ["500","760","880"] | ["0.4510","0.4428","0.4447"] | ["771.85"] | ["XMIO"] | 500.0000 | 880.0000 | 451 | 451 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:44:30Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c991-0197-7480-ad1f-df2d58f7915d | META | 2026-09-22 10:41 | risk_reversal | 2 | 1 | 10 | 182400.00 | short | bid | 747.0000 | 2.3000 | ["550","800"] | ["0.4459","0.4409"] | ["900.98"] | ["MCRY"] | 550.0000 | 800.0000 | 451 | 451 | false | true | false | true | |||||||||
| 01a0c950-7df7-71e3-96ac-fee926347530 | META | 2026-09-22 09:31 | risk_reversal | 3 | 1 | 15 | 254490.00 | short | ask | 740.7400 | 4.1000 | ["650","800","850"] | ["0.4367","0.4445","0.4390"] | ["764.30"] | ["XMIO"] | 650.0000 | 850.0000 | 115 | 115 | false | false | false | ||||||||||
| 01a0c538-26f7-7d73-a4da-749a9b991331 | META | 2026-09-21 14:26 | risk_reversal | 3 | 1 | 20 | 71760.00 | long | ask | 746.7550 | 0.5500 | ["705","737.5","790"] | ["0.6266","0.6271","0.6639"] | ["750.8"] | ["XCBO"] | 705.0000 | 790.0000 | 4 | 4 | false | false | false | ||||||||||
| 01a0c44d-ab9f-7921-ba01-2c544ad2ed26 | META | 2026-09-21 10:10 | risk_reversal | 3 | 1 | 220 | 3472697.00 | long | ask | 714.4000 | 4.4100 | ["455","600","700"] | ["0.6346","0.4469","0.4170"] | ["678.53"] | ["XMIO"] | 455.0000 | 700.0000 | 25 | 25 | false | false | false | ||||||||||
| 01a0c44c-9647-7d40-a5ae-2eb2ebff2319 | META | 2026-09-21 10:09 | risk_reversal | 2 | 1 | 10 | 47140.00 | long | ask | 714.6800 | 1.3500 | ["650","800"] | ["0.4512","0.4579"] | ["802.20"] | ["XCBO"] | 650.0000 | 800.0000 | 60 | 60 | false | true | false | true | |||||||||
| 01a0c44c-1946-7ec1-8bce-7c7dc1877681 | META | 2026-09-21 10:08 | risk_reversal | 2 | 1 | 50 | 492750.00 | long | ask | 714.6700 | 3.5000 | ["575","650"] | ["0.4623","0.4543"] | ["735.05"] | ["XMIO"] | 575.0000 | 650.0000 | 60 | 60 | false | false | false | true | |||||||||
| 01a0c438-3b57-7600-926d-38db24b6d81c | META | 2026-09-21 09:46 | risk_reversal | 2 | 1 | 50 | 456100.00 | short | bid | 704.2494 | 5.6000 | ["575","650"] | ["0.4564","0.4488"] | ["726.16"] | ["XCBO"] | 575.0000 | 650.0000 | 60 | 60 | false | false | false | true | |||||||||
| 01a0b4fc-e7b0-78b2-b7f7-680829fe0080 | META | 2026-09-18 10:47 | risk_reversal | 2 | 1 | 275 | 1345575.00 | short | bid | 675.0900 | 1.2500 | ["625","745"] | ["0.4350","0.4312"] | ["745.25"] | ["EDGO"] | 625.0000 | 745.0000 | 63 | 63 | false | true | false | true | |||||||||
| 01a0b0d1-2833-7df0-b49f-bc5fa0428478 | META | 2026-09-17 15:21 | risk_reversal | 2 | 1 | 10 | 68257.00 | short | bid | 676.2650 | 1.2500 | ["620","760"] | ["0.4080","0.4027"] | ["762.29"] | ["EDGO"] | 620.0000 | 760.0000 | 120 | 120 | false | true | false | true | |||||||||
| 01a0afbc-06e3-7a02-bc84-51e513fef61b | META | 2026-09-17 10:18 | risk_reversal | 2 | 1 | 4 | 27764.00 | long | bid | 672.3700 | 2.4500 | ["490","1200"] | ["0.4355","0.4308"] | ["487.43"] | ["XCBO"] | 490.0000 | 1200.0000 | 491 | 491 | false | true | false | true | |||||||||
| 01a0aa6f-46c3-74c1-ade0-f119e41ab686 | META | 2026-09-16 09:36 | risk_reversal | 2 | 1 | 146 | 712490.00 | long | bid | 678.2951 | 1.2000 | ["675","700"] | ["0.3873","0.3851"] | ["669.30"] | ["XISX"] | 675.0000 | 700.0000 | 30 | 30 | false | true | false | true | |||||||||
| 01a0a60b-769e-7a42-93c0-a5004d2a42fc | META | 2026-09-15 13:09 | risk_reversal | 2 | 1 | 18 | 141714.00 | short | bid | 666.2000 | 0.9000 | ["590","800"] | ["0.4219","0.4196"] | ["801.11"] | ["XCBO"] | 590.0000 | 800.0000 | 185 | 185 | false | true | false | true | |||||||||
| 01a0a59f-81e5-7801-bcae-fffabc100d3c | META | 2026-09-15 11:11 | risk_reversal | 2 | 1 | 10 | 33484.00 | short | ask | 670.8687 | 0.8500 | ["600","800"] | ["0.4473","0.4465"] | ["594.70"] | ["XMIO"] | 600.0000 | 800.0000 | 66 | 66 | false | true | false | true | |||||||||
| 01a08c6f-9aa0-7a70-b2dc-fde544b815c2 | META | 2026-09-10 13:48 | risk_reversal | 2 | 1 | 6 | 112716.00 | long | ask | 649.5000 | 2.8500 | ["520","650"] | ["0.4353","0.4309"] | ["741.02"] | ["XCBO"] | 520.0000 | 650.0000 | 463 | 463 | false | true | false | true | |||||||||
| 01a08c67-0750-7db0-94ef-a30fe9188970 | META | 2026-09-10 13:39 | risk_reversal | 2 | 1 | 3 | 53778.00 | long | ask | 649.7099 | 5.2000 | ["550","700"] | ["0.4358","0.4301"] | ["759.86"] | ["XCBO"] | 550.0000 | 700.0000 | 463 | 463 | false | true | false | true | |||||||||
| 01a08bcf-10f8-7e63-bde1-e7c56c08318d | META | 2026-09-10 10:53 | risk_reversal | 2 | 1 | 5 | 44870.00 | short | ask | 656.2800 | 0.7500 | ["680","850"] | ["0.4227","0.4286"] | ["623.30"] | ["XCBO"] | 680.0000 | 850.0000 | 127 | 127 | false | false | false | true | |||||||||
| 01a08b95-4030-7111-9a8b-d86ccfae59c6 | META | 2026-09-10 09:50 | risk_reversal | 2 | 1 | 5 | 57473.00 | short | ask | 645.6300 | 1.6500 | ["680","730"] | ["0.4219","0.4201"] | ["638.15"] | ["XCBO"] | 680.0000 | 730.0000 | 127 | 127 | false | false | false | true | |||||||||
| 01a08b8c-8da0-7b91-8613-6b58c1f7473c | META | 2026-09-10 09:40 | risk_reversal | 2 | 1 | 5 | 50428.00 | short | ask | 661.9100 | 2.5500 | ["675","725"] | ["0.4347","0.4322"] | ["650.25"] | ["XCBO"] | 675.0000 | 725.0000 | 99 | 99 | false | false | false | true | |||||||||
| 01a08784-7ab0-7b42-8a38-1b33cd77f6ea | META | 2026-09-09 14:53 | risk_reversal | 2 | 1 | 10 | 58920.00 | short | bid | 653.0850 | 1.5900 | ["545","615"] | ["0.4166","0.3947"] | ["668.06"] | ["XMIO"] | 545.0000 | 615.0000 | 37 | 37 | false | false | false | true | |||||||||
| 01a0866e-9de0-75d2-ad65-76fed47a4b3a | META | 2026-09-09 09:49 | risk_reversal | 2 | 1 | 12 | 106128.00 | long | ask | 648.1300 | 1.7500 | ["520","800"] | ["0.4351","0.4339"] | ["822.52"] | ["MCRY"] | 520.0000 | 800.0000 | 281 | 281 | false | true | false | true | |||||||||
| 01a0866e-72e8-7893-81de-a1f91a208b90 | META | 2026-09-09 09:49 | risk_reversal | 2 | 3 | 76 | 211356.00 | short | bid | 648.7900 | 1.0000 | ["600","700"] | ["0.4000","0.4019"] | ["702.99"] | ["XBOX","XCBO","XISX"] | 600.0000 | 700.0000 | 37 | 37 | false | true | false | ||||||||||
| 01a08666-1a30-7252-ace7-0ef84d518ef0 | META | 2026-09-09 09:40 | risk_reversal | 3 | 1 | 3 | 56838.00 | long | ask | 646.0650 | 5.3000 | ["450","580","680"] | ["0.4563","0.4399","0.4360"] | ["621.62"] | ["XCBO"] | 450.0000 | 680.0000 | 163 | 163 | false | false | false |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:42:10Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:31:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:26:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:10:36Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:09:13Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:08:35Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:47:04Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:47:50Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:21:48Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:18:54Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:37:04Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:09:31Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:11:35Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:49:10Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:39:29Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:53:45Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:50:22Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:40:52Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:53:52Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:50:09Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:49:45Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:40:42Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |