core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a0cf8f-fe9e-77b2-a540-d18daa81db66 | META | 2026-09-23 14:38 | synthetic | 2 | 4 | 14 | 50162.00 | long | bid | 747.9900 | 0.2964 | ["765"] | ["0.7412"] | ["748.25"] | ["MCRY","XISX","XPHO"] | 765.0000 | 765.0000 | 2 | 2 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T18:39:07Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0ce93-0cb7-7ca3-95b4-495482a3d01c | META | 2026-09-23 10:02 | synthetic | 2 | 1 | 3 | 47379.00 | long | ask | 753.5160 | 3.6000 | ["670"] | ["0.4419"] | ["762.85"] | ["XCBO"] | 670.0000 | 670.0000 | 114 | 114 | false | false | false | false | |||||||||
| 01a0ce82-95df-7c73-92a4-fd08343f0eaf | META | 2026-09-23 09:44 | synthetic | 2 | 4 | 20 | 84015.00 | long | ask | 747.7001 | 0.9475 | ["745"] | ["0.5087"] | ["748.28"] | ["MCRY","XISX","XPHO"] | 745.0000 | 745.0000 | 7 | 7 | false | false | false | false | |||||||||
| 01a0ca6e-51d6-7a00-b014-0529b749ce1a | META | 2026-09-22 14:43 | synthetic | 2 | 2 | 2 | 28420.00 | long | ask | 740.8450 | 2.0000 | ["750"] | ["0.4296"] | ["750.68"] | ["XISX","XPHO"] | 750.0000 | 750.0000 | 115 | 115 | false | false | false | false | |||||||||
| 01a0ca3b-3f9f-7d00-9dba-0bf05611c9c6 | META | 2026-09-22 13:47 | synthetic | 2 | 2 | 2 | 28282.00 | long | bid | 740.0200 | 1.2000 | ["750"] | ["0.4277"] | ["749.69"] | ["EDGO","XCBO"] | 750.0000 | 750.0000 | 115 | 115 | false | false | false | false | |||||||||
| 01a0ca3b-3f9f-7d00-9dba-0beffc2dd9d2 | META | 2026-09-22 13:47 | synthetic | 2 | 2 | 2 | 28278.00 | long | bid | 739.7950 | 1.2000 | ["750"] | ["0.4273"] | ["749.69"] | ["XISX","XPHO"] | 750.0000 | 750.0000 | 115 | 115 | false | false | false | false | |||||||||
| 01a0ca1b-b17f-7a53-9d3a-6e9ee12d1826 | META | 2026-09-22 13:13 | synthetic | 2 | 1 | 2 | 37906.00 | long | ask | 744.8550 | 3.5500 | ["590"] | ["0.4385"] | ["753.29"] | ["XCBO"] | 590.0000 | 590.0000 | 115 | 115 | false | false | false | false | |||||||||
| 01a0c9f8-52ce-70b2-bccd-5e0f28e48b91 | META | 2026-09-22 12:34 | synthetic | 2 | 2 | 2 | 28700.00 | long | ask | 749.1800 | 1.6000 | ["750"] | ["0.4308"] | ["758.78"] | ["XISX","XPHO"] | 750.0000 | 750.0000 | 115 | 115 | false | false | false | false | |||||||||
| 01a0c9c6-b797-7f03-84da-0ea5766f52a2 | META | 2026-09-22 11:40 | synthetic | 2 | 1 | 11 | 36696.00 | long | ask | 750.0400 | 0.9500 | ["745"] | ["0.6123"] | ["750.50"] | ["EMLD"] | 745.0000 | 745.0000 | 3 | 3 | false | false | false | false | |||||||||
| 01a0c566-ff27-7c41-8fc0-1f16991eaf20 | META | 2026-09-21 15:17 | synthetic | 2 | 1 | 6 | 64920.00 | long | ask | 745.4600 | 4.0000 | ["680"] | ["0.4998"] | ["748.20"] | ["XBOX"] | 680.0000 | 680.0000 | 39 | 39 | false | false | false | false | |||||||||
| 01a0c566-ff27-7c41-8fc0-1f0abce2271e | META | 2026-09-21 15:17 | synthetic | 2 | 1 | 3 | 32460.00 | long | ask | 745.5000 | 4.0000 | ["680"] | ["0.4996"] | ["748.20"] | ["XBOX"] | 680.0000 | 680.0000 | 39 | 39 | false | false | false | false | |||||||||
| 01a0c532-75ef-7b83-998e-a168adcc01c8 | META | 2026-09-21 14:20 | synthetic | 2 | 1 | 4 | 46972.00 | long | bid | 742.5900 | 1.1500 | ["765"] | ["0.4806"] | ["748.03"] | ["AMXO"] | 765.0000 | 765.0000 | 60 | 60 | false | false | false | false | |||||||||
| 01a0c500-425f-7cd3-87cc-a1af6007c435 | META | 2026-09-21 13:25 | synthetic | 2 | 4 | 15 | 60105.00 | long | ask | 737.1801 | 0.3567 | ["737.5"] | ["0.4921"] | ["737.88"] | ["EMLD","MCRY","XISX","XPHO"] | 737.5000 | 737.5000 | 7 | 7 | false | false | false | false | |||||||||
| 01a0c4d2-0e3f-71f0-800b-96ae3634f8ff | META | 2026-09-21 12:34 | synthetic | 2 | 1 | 20 | 45240.00 | long | bid | 728.1400 | 0.3250 | ["730"] | ["0.5245"] | ["728.38"] | ["XCBO"] | 730.0000 | 730.0000 | 2 | 2 | false | false | false | false | |||||||||
| 01a0c4c4-42ff-7e81-9495-8b12866c0ca5 | META | 2026-09-21 12:19 | synthetic | 2 | 1 | 3 | 46920.00 | long | bid | 725.4000 | 1.5000 | ["800"] | ["0.4349"] | ["735.06"] | ["XCBO"] | 800.0000 | 800.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c439-4cc7-7212-b08a-18cf3ffc95e7 | META | 2026-09-21 09:48 | synthetic | 2 | 4 | 8 | 26908.00 | long | ask | 702.1700 | 0.8000 | ["682.5"] | ["0.5090"] | ["702.50"] | ["ARCO","C2OX","EMLD","SPHR"] | 682.5000 | 682.5000 | 4 | 4 | false | false | false | false | |||||||||
| 01a0b603-91df-7fd3-a05d-3e011765af93 | META | 2026-09-18 15:34 | synthetic | 2 | 1 | 2500 | 1050000.00 | long | bid | 669.7400 | 0.4700 | ["670"] | ["1.1305"] | ["669.70"] | ["AMXO"] | 670.0000 | 670.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b50e-4500-7a40-b9ff-25d1e18d4107 | META | 2026-09-18 11:06 | synthetic | 2 | 2 | 2 | 61308.00 | long | ask | 680.5350 | 6.4000 | ["730"] | ["0.4356"] | ["732.02"] | ["XMIO"] | 730.0000 | 730.0000 | 637 | 637 | false | false | false | false | |||||||||
| 01a0b4ff-413f-7990-bc15-f26bf973902f | META | 2026-09-18 10:50 | synthetic | 2 | 2 | 2 | 31580.00 | long | ask | 677.5700 | 2.6500 | ["670"] | ["0.4157"] | ["691.00"] | ["BATO","C2OX"] | 670.0000 | 670.0000 | 182 | 182 | false | false | false | false | |||||||||
| 01a0b4ff-3d57-7183-b45d-e2d06e309f6b | META | 2026-09-18 10:50 | synthetic | 2 | 2 | 2 | 31576.00 | long | ask | 677.5700 | 2.6500 | ["670"] | ["0.4156"] | ["691.00"] | ["EMLD","SPHR"] | 670.0000 | 670.0000 | 182 | 182 | false | false | false | false | |||||||||
| 01a0b4d8-92e7-7811-8376-194cd38e4d0e | META | 2026-09-18 10:08 | synthetic | 2 | 1 | 2 | 61358.00 | long | bid | 675.6000 | 4.3000 | ["730"] | ["0.4377"] | ["727.39"] | ["XISX"] | 730.0000 | 730.0000 | 637 | 637 | false | false | false | false | |||||||||
| 01a0b0e6-793b-75f3-91d2-3defd2b2d1de | META | 2026-09-17 15:44 | synthetic | 2 | 1 | 10 | 162040.00 | long | ask | 680.0208 | 2.3500 | ["590"] | ["0.4287"] | ["691.00"] | ["XISX"] | 590.0000 | 590.0000 | 155 | 155 | false | false | false | false | |||||||||
| 01a0b02c-06c3-7600-9333-d1cb3e10e108 | META | 2026-09-17 12:21 | synthetic | 2 | 2 | 14 | 85064.00 | long | bid | 678.0100 | 0.2321 | ["700"] | ["0.3793"] | ["679.89"] | ["XISX","XPHO"] | 700.0000 | 700.0000 | 29 | 29 | false | false | false | false | |||||||||
| 01a0abc5-3dbb-7300-96fb-5bb07ed068ca | META | 2026-09-16 15:50 | synthetic | 2 | 6 | 10 | 303132.00 | long | ask | 675.7200 | 11.6500 | ["710"] | ["0.4372"] | ["726.50"] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR"] | 710.0000 | 710.0000 | 639 | 639 | false | false | false | false | |||||||||
| 01a0a594-98ee-78a1-b0fd-a7125bf69773 | META | 2026-09-15 10:59 | synthetic | 2 | 2 | 18 | 25164.00 | long | ask | 665.7750 | 0.1500 | ["665"] | ["0.5026"] | ["665.80"] | ["XISX","XPHO"] | 665.0000 | 665.0000 | 1 | 1 | false | false | false | false | |||||||||
| 01a0a129-8ed8-7030-832c-3d051a36935e | META | 2026-09-14 14:24 | synthetic | 2 | 3 | 6 | 76560.00 | long | ask | 667.0600 | 1.0500 | ["630"] | ["0.4090"] | ["676.04"] | ["ARCO","XCBO","XISX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | |||||||||
| 01a0a073-db38-7240-b96d-3e3b3b633663 | META | 2026-09-14 11:05 | synthetic | 2 | 2 | 3 | 47102.00 | long | ask | 653.0400 | 3.1000 | ["605"] | ["0.4192"] | ["666.50"] | ["C2OX","SPHR"] | 605.0000 | 605.0000 | 186 | 186 | false | false | false | false | |||||||||
| 01a09205-d358-7930-a4a6-d69e377cb316 | META | 2026-09-11 15:50 | synthetic | 2 | 1 | 10 | 63620.00 | long | ask | 647.0400 | 2.0000 | ["615"] | ["0.3676"] | ["649.12"] | ["XMIO"] | 615.0000 | 615.0000 | 35 | 35 | false | false | false | false | |||||||||
| 01a08ba4-95f8-7dc0-9d0b-645594b5921d | META | 2026-09-10 10:06 | synthetic | 2 | 2 | 27 | 46143.00 | long | ask | 644.4550 | 0.3000 | ["635"] | ["0.5702"] | ["644.73"] | ["SPHR","XPHO"] | 635.0000 | 635.0000 | 1 | 1 | false | false | false | false | |||||||||
| 01a08b8b-2640-7c43-b0a3-fc09c3229eac | META | 2026-09-10 09:39 | synthetic | 2 | 1 | 3 | 35805.00 | long | bid | 658.1598 | 2.2500 | ["675"] | ["0.4333"] | ["664.77"] | ["XISX"] | 675.0000 | 675.0000 | 99 | 99 | false | false | false | false | |||||||||
| 01a0869f-f6b0-7e51-9e72-6fcac3a0bf03 | META | 2026-09-09 10:43 | synthetic | 2 | 1 | 6 | 54720.00 | long | bid | 645.4100 | 1.7000 | ["700"] | ["0.4187"] | ["699.80"] | ["XISX"] | 700.0000 | 700.0000 | 128 | 128 | false | false | false | false | |||||||||
| 01a0868a-24c0-74a2-9bd6-39ed03fd93ae | META | 2026-09-09 10:19 | synthetic | 2 | 4 | 21 | 75285.00 | long | ask | 646.1000 | 0.3500 | ["620"] | ["0.4047"] | ["646.72"] | ["EMLD","XISX","XPHO"] | 620.0000 | 620.0000 | 7 | 7 | false | false | false | false | |||||||||
| 01a08665-52f8-7ed2-b145-bef9dbfbfbed | META | 2026-09-09 09:39 | synthetic | 2 | 4 | 2 | 31640.00 | long | ask | 647.1850 | 5.4000 | ["610"] | ["0.4280"] | ["660.00"] | ["C2OX","SPHR"] | 610.0000 | 610.0000 | 191 | 191 | false | false | false | false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:02:33Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:44:28Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:44:25Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:48:15Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:48:15Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:13:34Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:35:08Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:41:00Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:17:35Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:17:35Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:20:29Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:25:48Z"} |
| 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-21T16:35:15Z"} |
| 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-21T16:19:50Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:48:10Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:34:57Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:07:01Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:50:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:50:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:08:22Z"} |
| 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-17T19:44:51Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:21:11Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:50:31Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:59:33Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:24:30Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:05:43Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:51:00Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:07:05Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:39:12Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:43:47Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:19:58Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:40:00Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |