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 | directiontext |
|---|
| 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 |
|---|
| 01a06d56-35d5-7573-a6e7-11bdde785590 | TEAM | 2026-09-04 12:52 | strangle | 2 | 2 | 60 | 594110.00 | long | ask | 190.1500 | 4.5000 | ["200","270"] | ["0.6943","0.6665"] | ["100.98","369.02"] | ["ARCO","XPHO"] | 200.0000 | 270.0000 | 504 | 504 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:52:59Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d56-418e-7081-bcff-2a6a0b94226f | TEAM | 2026-09-04 12:52 | strangle | 2 | 1 | 10 | 100350.00 | long | ask | 190.1550 | 2.3000 | ["200","270"] | ["0.7030","0.6736"] | ["99.65","370.35"] | ["XISX"] | 200.0000 | 270.0000 | 504 | 504 | false | false | false | true | |||||||||
| 01a08175-60aa-7b22-aac0-50f0299c7b99 | TEAM | 2026-09-08 10:39 | risk_reversal | 2 | 2 | 51 | 159834.00 | long | ask | 180.4600 | 2.5000 | ["160","210"] | ["0.7001","0.6844"] | ["211.00"] | ["XMIO"] | 160.0000 | 210.0000 | 101 | 101 | false | true | false | true | |||||||||
| 01a0825c-b750-7af3-a0f0-89df4011e616 | TEAM | 2026-09-08 14:51 | call_diagonal_spread | 2 | 1 | 17 | 108430.00 | long | ask | 176.4300 | 4.9000 | ["170","210"] | ["0.7181","0.7005"] | [] | ["XCBO"] | 170.0000 | 210.0000 | 101 | 282 | false | false | true | true | |||||||||
| 01a08674-6a40-7202-ad97-a93de1073fd7 | TEAM | 2026-09-09 09:56 | call_diagonal_spread | 2 | 1 | 10 | 106580.00 | long | ask | 179.2900 | 9.7000 | ["165","175"] | ["0.7151","0.7044"] | [] | ["EDGO"] | 165.0000 | 175.0000 | 281 | 373 | false | false | true | true | |||||||||
| 01a08bba-6400-7bd3-9b64-03010d5025c6 | TEAM | 2026-09-10 10:30 | other | 4 | 1 | 26 | 265564.00 | unknown | — | 181.6100 | 6.5000 | ["145","150","190","195"] | ["0.7007","0.6966","0.5922","0.5891"] | [] | ["C2OX"] | 145.0000 | 195.0000 | 8 | 127 | false | false | true | true | false | mlet | |||||||
| 01a0a043-0350-71f0-9263-a5f767e1aa58 | TEAM | 2026-09-14 10:12 | call_diagonal_spread | 2 | 1 | 13 | 158158.00 | short | bid | 183.7100 | 7.2000 | ["110","150"] | ["0.8301","0.7822"] | [] | ["XCBO"] | 110.0000 | 150.0000 | 67 | 95 | false | false | true | true | |||||||||
| 01a0a043-0350-71f0-9263-a5ebbd7e7c33 | TEAM | 2026-09-14 10:12 | call_diagonal_spread | 2 | 5 | 19 | 231048.00 | short | bid | 183.7100 | 7.3000 | ["110","150"] | ["0.8169","0.7866"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 110.0000 | 150.0000 | 67 | 95 | false | false | true | ||||||||||
| 01a0a132-9f28-7371-b56b-431b7ab44d39 | TEAM | 2026-09-14 14:34 | risk_reversal | 2 | 2 | 150 | 495000.00 | short | ask | 191.1300 | 2.3000 | ["185","220"] | ["0.7182","0.7164"] | ["179.30"] | ["AMXO"] | 185.0000 | 220.0000 | 67 | 67 | false | true | false | true | |||||||||
| 01a0a59a-c6f6-7a60-8003-df933151dbac | TEAM | 2026-09-15 11:06 | call_vertical_spread | 2 | 1 | 80 | 806000.00 | long | ask | 190.5400 | 2.9000 | ["110","170"] | ["3.0160","0.9650"] | ["169.61"] | ["XMIO"] | 110.0000 | 170.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a59a-c6f6-7a60-8003-df87be9ee7c9 | TEAM | 2026-09-15 11:06 | call_vertical_spread | 2 | 1 | 20 | 201600.00 | unknown | — | 190.5400 | 5.5000 | ["110","170"] | ["3.0160","0.4455"] | [] | ["XISX"] | 110.0000 | 170.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a0a5ac-5ede-7823-8d50-29980c1e2596 | TEAM | 2026-09-15 11:25 | call_diagonal_spread | 2 | 1 | 12 | 102510.00 | short | ask | 190.5950 | 8.6000 | ["155","170"] | ["0.7362","0.6807"] | [] | ["XISX"] | 155.0000 | 170.0000 | 66 | 122 | false | false | true | true | |||||||||
| 01a0a66a-c50e-7132-8560-b5262ad3dda0 | TEAM | 2026-09-15 14:53 | call_diagonal_spread | 2 | 1 | 250 | 3621230.00 | short | ask | 189.8750 | 7.0000 | ["100","150"] | ["4.3597","0.7254"] | [] | ["XCBO"] | 100.0000 | 150.0000 | 3 | 122 | false | false | true | true | |||||||||
| 01a0aff1-3043-7a82-9800-379bdc0bacd2 | TEAM | 2026-09-17 11:16 | call_diagonal_spread | 2 | 2 | 33 | 113360.00 | unknown | — | 194.9150 | 1.9091 | ["195","250"] | ["0.5790","0.6796"] | [] | ["MCRY","SPHR"] | 195.0000 | 250.0000 | 29 | 183 | false | true | true | true | false | ||||||||
| 01a0b04d-5233-72a2-95df-a631000c9fba | TEAM | 2026-09-17 12:57 | call_diagonal_spread | 2 | 1 | 6 | 120060.00 | unknown | — | 192.1200 | 9.0000 | ["90","120"] | ["0.7307","0.7045"] | [] | ["XMIO"] | 90.0000 | 120.0000 | 64 | 491 | false | false | true | true | false | ||||||||
| 01a0b04f-51ea-7e53-af33-21fb0bcb1e6a | TEAM | 2026-09-17 12:59 | call_calendar | 2 | 1 | 6 | 124020.00 | unknown | — | 192.2900 | 7.5000 | ["90"] | ["0.7712"] | [] | ["XPHO"] | 90.0000 | 90.0000 | 64 | 92 | false | false | true | false | false | mlet | |||||||
| 01a0b0a9-7bf3-77f2-a136-c17a41a8b83c | TEAM | 2026-09-17 14:38 | call_calendar | 2 | 1 | 6 | 107220.00 | unknown | — | 192.8600 | 10.0000 | ["105"] | ["3.8180"] | [] | ["XCBO"] | 105.0000 | 105.0000 | 1 | 64 | false | false | true | false | false | mlet | |||||||
| 01a0b0dc-6eeb-7283-9b53-a5fd00da931c | TEAM | 2026-09-17 15:33 | call_vertical_spread | 2 | 1 | 10 | 201800.00 | unknown | — | 193.4700 | 5.9000 | ["65","150"] | ["0.8204","0.7131"] | [] | ["MCRY"] | 65.0000 | 150.0000 | 273 | 273 | false | false | false | true | false | ||||||||
| 01a0b526-c66f-7991-b044-1a4118c2658f | TEAM | 2026-09-18 11:33 | call_diagonal_spread | 2 | 1 | 20 | 395600.00 | short | ask | 193.0600 | 7.0000 | ["90","105"] | ["0.5951","0.7081"] | [] | ["XMIO"] | 90.0000 | 105.0000 | 91 | 182 | false | false | true | true | |||||||||
| 01a0b540-41df-73e0-a9c8-99078d6deffb | TEAM | 2026-09-18 12:01 | other | 4 | 1 | 19 | 117914.00 | unknown | bid | 193.6950 | 7.1000 | ["175","185","195"] | ["2.2284","2.2339","0.5547"] | [] | ["XCBO"] | 175.0000 | 195.0000 | 0 | 28 | false | false | true | true | |||||||||
| 01a0b59e-7327-7461-a37f-0bb95381a886 | TEAM | 2026-09-18 13:44 | risk_reversal | 2 | 2 | 150 | 1023000.00 | long | bid | 192.1300 | 6.1000 | ["190","250"] | ["0.6858","0.6734"] | ["178.70"] | ["AMXO"] | 190.0000 | 250.0000 | 272 | 272 | true | true | false | true | |||||||||
| 01a0b5fe-ee5f-7192-ae42-b71ecc80d48f | TEAM | 2026-09-18 15:29 | call_diagonal_spread | 2 | 1 | 15 | 181410.00 | long | bid | 193.3201 | 6.1000 | ["130","140"] | ["35.1471","0.7291"] | [] | ["BATO"] | 130.0000 | 140.0000 | 0 | 63 | false | false | true | true | |||||||||
| 01a0c46e-d7cf-71d0-b7a1-8c9843d91856 | TEAM | 2026-09-21 10:46 | straddle | 2 | 1 | 500 | 5650000.00 | long | ask | 195.6550 | 5.4000 | ["85"] | ["0.9353"] | ["198.00"] | ["AMXO"] | 85.0000 | 85.0000 | 88 | 88 | false | false | false | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:52:59Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:39:33Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:52:27Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:56:16Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:30:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:12:21Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:12:21Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:34:22Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:06:22Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:06:22Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:25:45Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:54:12Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:17:32Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:57:38Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:59:46Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:38:57Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:33:51Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:33:59Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:01:32Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:44:15Z"} |
| 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-18T19:29:40Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:46:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |