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 |
|---|
| 01a06dd8-8535-7540-b235-201a03e56574 | ONON | 2026-09-04 15:14 | other | 2 | 1 | 600 | 2544000.00 | unknown | — | 28.0850 | 1.9500 | ["45","52.5"] | ["0.7825","0.8926"] | [] | ["XBOX"] | 45.0000 | 52.5000 | 105 | 133 | true | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:15:16Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfb-bcd5-7920-9882-273c00e543a3 | ONON | 2026-09-04 15:53 | other | 2 | 1 | 600 | 2484000.00 | unknown | — | 28.0150 | 2.1000 | ["45","52.5"] | ["0.6217","0.7586"] | [] | ["XPHO"] | 45.0000 | 52.5000 | 105 | 133 | false | false | true | true | false | ||||||||
| 01a0865e-bf60-7e41-b5df-1be0cd23cce0 | ONON | 2026-09-09 09:32 | synthetic | 2 | 5 | 1058 | 234972.00 | long | ask | 26.8900 | 0.9816 | ["27"] | ["0.4939"] | ["27.26"] | ["ARCO","XISX"] | 27.0000 | 27.0000 | 16 | 16 | true | false | false | ||||||||||
| 01a0865e-dea0-7681-a50f-7484627a5a17 | ONON | 2026-09-09 09:32 | straddle | 2 | 1 | 508 | 112776.00 | short | bid | 26.9800 | 0.4400 | ["27"] | ["0.4930"] | ["24.78","29.22"] | ["ARCO"] | 27.0000 | 27.0000 | 16 | 16 | false | false | false | ||||||||||
| 01a0865f-7ae0-7611-b049-47bb419d3f75 | ONON | 2026-09-09 09:33 | synthetic | 2 | 2 | 535 | 127154.00 | long | bid | 27.1250 | 0.6995 | ["28"] | ["0.4960"] | ["27.4"] | ["XISX"] | 28.0000 | 28.0000 | 16 | 16 | true | false | false | ||||||||||
| 01a08660-6929-7850-8cbb-17aeae231c56 | ONON | 2026-09-09 09:34 | synthetic | 2 | 4 | 2324 | 1754620.00 | long | ask | 27.1350 | 0.5770 | ["27.5"] | ["0.4852"] | ["27.95"] | ["XISX"] | 27.5000 | 27.5000 | 191 | 191 | true | false | false | ||||||||||
| 01a08660-6929-7850-8cbb-179355bde30d | ONON | 2026-09-09 09:34 | synthetic | 2 | 3 | 403 | 304265.00 | long | ask | 27.1350 | 0.4280 | ["27.5"] | ["0.4857"] | ["27.95"] | ["XISX"] | 27.5000 | 27.5000 | 191 | 191 | false | false | false | ||||||||||
| 01a08c9b-0000-7182-a70e-ef9bfa7e1486 | ONON | 2026-09-10 14:36 | other | 7 | 1 | 551 | 1077788.00 | unknown | — | 26.7150 | 8.2000 | ["31.5","32.5","33.5","35","37.5","42.5"] | ["3.5855","5.5479","4.5977","1.2675","1.2321","2.9296"] | [] | ["XBOX"] | 31.5000 | 42.5000 | 1 | 36 | false | false | true | true | |||||||||
| 01a08ca1-1699-7be1-849e-e5f4eb6ce3e7 | ONON | 2026-09-10 14:42 | other | 3 | 1 | 72 | 187760.00 | unknown | — | 26.6400 | 4.6000 | ["31","42.5"] | ["4.8729","1.7891"] | [] | ["XBOX"] | 31.0000 | 42.5000 | 1 | 99 | false | false | true | true | false | ||||||||
| 01a08ca1-baa9-70f3-9d26-05dee840a28b | ONON | 2026-09-10 14:43 | other | 8 | 1 | 1665 | 6484128.00 | unknown | — | 26.6350 | 7.5300 | ["29","29.5","35","37.5","42.5","45","52.5"] | ["1.1418","1.3114","1.1365","1.1652","0.7453","0.8699","0.9236"] | [] | ["XBOX"] | 29.0000 | 52.5000 | 1 | 127 | false | false | true | true | |||||||||
| 01a0a698-e98d-7c00-9c95-d765e49841c8 | ONON | 2026-09-15 15:43 | other | 4 | 1 | 600 | 1921200.00 | unknown | — | 27.0500 | 3.6500 | ["32.5","35","37.5","52.5"] | ["1.7715","1.9117","0.8278","0.7343"] | [] | ["XPHO"] | 32.5000 | 52.5000 | 3 | 122 | false | false | true | true | |||||||||
| 01a0aba7-c2db-7740-bac5-7c4fd8af8f49 | ONON | 2026-09-16 15:18 | other | 3 | 1 | 266 | 364440.00 | unknown | — | 27.2299 | 4.3500 | ["32.5","35","37.5"] | ["2.0820","2.3761","1.0656"] | [] | ["XBOX"] | 32.5000 | 37.5000 | 2 | 30 | false | false | true | true | false | ||||||||
| 01a0afbc-494b-75f0-b77d-eebfa370bcd2 | ONON | 2026-09-17 10:19 | put_diagonal_spread | 2 | 1 | 20000 | 2640000.00 | short | bid | 26.5150 | 0.2100 | ["22.5","26"] | ["0.5271","0.5660"] | [] | ["XBOX"] | 22.5000 | 26.0000 | 8 | 64 | false | true | |||||||||||
| 01a0b0a2-6b5b-70e0-97a3-a6229cafa4f2 | ONON | 2026-09-17 14:30 | other | 7 | 1 | 3070 | 3074030.00 | unknown | — | 27.2939 | 11.9700 | ["29.5","30","31","35","37.5","42.5"] | ["3.2076","1.2724","5.3991","2.2134","7.5609","9.6069"] | [] | ["XBOX"] | 29.5000 | 42.5000 | 1 | 29 | true | false | true | true | |||||||||
| 01a0b0a9-7bf3-77f2-a136-c140aeda97a6 | ONON | 2026-09-17 14:38 | other | 8 | 1 | 808 | 3727672.00 | unknown | — | 27.3050 | 13.7700 | ["28.5","29.5","30","32.5","35","37.5","45","52.5"] | ["2.1925","3.2211","2.2553","2.2528","1.4359","1.5195","0.6722","1.2581"] | [] | ["XBOX"] | 28.5000 | 52.5000 | 1 | 120 | false | false | true | true | |||||||||
| 01a0b0ac-bfe3-7822-811f-4f1a2a411ee9 | ONON | 2026-09-17 14:41 | put_butterfly_spread | 3 | 1 | 2954 | 2166080.00 | unknown | — | 27.3050 | 2.4200 | ["29","30","35"] | ["2.1116","2.2553","2.9498"] | [] | ["XBOX"] | 29.0000 | 35.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0c4ea-689f-7722-bd95-de54aeedf09e | ONON | 2026-09-21 13:01 | risk_reversal | 2 | 1 | 250 | 190000.00 | short | ask | 27.6700 | 0.4000 | ["25","37.5"] | ["0.5061","0.4705"] | ["24.60"] | ["XISX"] | 25.0000 | 37.5000 | 487 | 487 | false | true | |||||||||||
| 01a0c4ea-689f-7722-bd95-de3231c0bde8 | ONON | 2026-09-21 13:01 | risk_reversal | 2 | 2 | 404 | 306230.00 | short | ask | 27.7250 | 0.2509 | ["25","37.5"] | ["0.5066","0.4679"] | ["24.6"] | ["AMXO","XPHO"] | 25.0000 | 37.5000 | 487 | 487 | false | true | |||||||||||
| 01a0c4ea-689f-7722-bd95-de2bb4e09461 | ONON | 2026-09-21 13:01 | risk_reversal | 2 | 4 | 637 | 482740.00 | short | ask | 27.7250 | 0.4500 | ["25","37.5"] | ["0.5066","0.4678"] | ["24.6"] | ["ARCO","XBOX"] | 25.0000 | 37.5000 | 487 | 487 | false | true | |||||||||||
| 01a0c4ea-689f-7722-bd95-de1d6663b029 | ONON | 2026-09-21 13:01 | risk_reversal | 2 | 1 | 260 | 195522.00 | short | ask | 27.7250 | 0.2263 | ["25","37.5"] | ["0.5039","0.4655"] | ["24.60"] | ["XISX"] | 25.0000 | 37.5000 | 487 | 487 | false | true | |||||||||||
| 01a0c4f2-5faf-7982-be45-640f7f25c09f | ONON | 2026-09-21 13:10 | risk_reversal | 2 | 2 | 501 | 380760.00 | long | bid | 27.7800 | 0.4000 | ["25","37.5"] | ["0.4997","0.4747"] | ["24.80"] | ["AMXO","ARCO"] | 25.0000 | 37.5000 | 487 | 487 | false | true | |||||||||||
| 01a0c4f2-9e2f-7573-831d-dca2f533ed59 | ONON | 2026-09-21 13:10 | strangle | 2 | 7 | 1180 | 901164.00 | short | bid | 27.7900 | 0.3154 | ["25","37.5"] | ["0.5017","0.4758"] | ["17.36","45.14"] | ["AMXO","ARCO","EDGO","XCBO","XISX","XMIO","XPHO"] | 25.0000 | 37.5000 | 487 | 487 | false | true | |||||||||||
| 01a0c54c-89b7-71f1-a76c-e2849e4a0ffc | ONON | 2026-09-21 14:48 | other | 3 | 1 | 1159 | 191235.00 | unknown | — | 27.2250 | 0.2200 | ["22.5","28","32.5"] | ["0.5366","0.4553","0.4712"] | [] | ["XISX"] | 22.5000 | 32.5000 | 25 | 60 | false | true | true | true | true | ||||||||
| 01a0ca46-7e87-7ea1-a811-fc26353bfcdc | ONON | 2026-09-22 14:00 | call_vertical_spread | 2 | 2 | 179 | 144111.00 | long | ask | 29.7314 | 0.3000 | ["25","27"] | ["0.4579","0.4523"] | ["26.73"] | ["XCBO","XISX"] | 25.0000 | 27.0000 | 24 | 24 | false | false | |||||||||||
| 01a0ca4b-2207-79a1-91cf-aec54e0334ee | ONON | 2026-09-22 14:05 | call_vertical_spread | 2 | 1 | 2700 | 2189704.00 | short | bid | 29.7750 | 0.3000 | ["25","27"] | ["0.4564","0.4443"] | ["26.75"] | ["XCBO"] | 25.0000 | 27.0000 | 24 | 24 | false | false | |||||||||||
| 01a0ca4b-1e1e-7fb1-b02d-d609e51e1863 | ONON | 2026-09-22 14:05 | call_vertical_spread | 2 | 2 | 1800 | 1454400.00 | short | bid | 29.8100 | 0.4000 | ["25","27"] | ["0.4599","0.4344"] | ["26.70"] | ["AMXO","XPHO"] | 25.0000 | 27.0000 | 24 | 24 | false | false | |||||||||||
| 01a0ca4e-a08f-7550-876a-00fbdb66acc6 | ONON | 2026-09-22 14:09 | call_vertical_spread | 2 | 1 | 1260 | 1033200.00 | unknown | — | 29.8250 | 0.4000 | ["25","27"] | ["0.4218","0.4589"] | [] | ["XISX"] | 25.0000 | 27.0000 | 24 | 24 | false | false | false | true | |||||||||
| 01a0ca50-88d6-75e2-9d19-8815a6959137 | ONON | 2026-09-22 14:11 | call_vertical_spread | 2 | 1 | 415 | 341130.00 | short | bid | 29.8799 | 0.4500 | ["25","27"] | ["0.3356","0.4406"] | ["26.70"] | ["XMIO"] | 25.0000 | 27.0000 | 24 | 24 | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:53:42Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:32:32Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:32:47Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:33:20Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:34:24Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:34:24Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:36:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:43:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:43:48Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:43:58Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:18:21Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:19:17Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:30:58Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| 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 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:41:47Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:01:32Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:01:32Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:01:32Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:01:32Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:10:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:10:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:49:04Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:00:23Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:05:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:05:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:09:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:11:57Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |