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 |
|---|
| 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 |
|---|
| 01a0cab2-445e-7b61-b6b3-be938ce1e580 | SMH | 2026-09-22 15:57 | call_vertical_spread | 2 | 1 | 1998 | 1442556.00 | short | bid | 607.7200 | 0.7300 | ["610","615"] | ["0.3041","0.3117"] | ["611.70"] | ["SPHR"] | 610.0000 | 615.0000 | 2 | 2 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:58:14Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca11-ce3f-7672-9c5a-62c75cff497f | SMH | 2026-09-22 13:02 | other | 5 | 1 | 817 | 5403570.00 | unknown | bid | 603.9450 | 4.6000 | ["600","610","650","660"] | ["0.3568","0.3579","0.3557","0.3500"] | [] | ["XBOX"] | 600.0000 | 660.0000 | 59 | 87 | false | false | true | true | |||||||||
| 01a0c9dc-04b7-7a73-908d-f020825eaad0 | SMH | 2026-09-22 12:03 | straddle | 2 | 1 | 50 | 641500.00 | short | bid | 602.2350 | 5.5500 | ["560"] | ["0.3780"] | ["431.70","688.30"] | ["SPHR"] | 560.0000 | 560.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0c9d9-8be6-7193-83c6-bdccde04566c | SMH | 2026-09-22 12:01 | synthetic | 2 | 1 | 45 | 494100.00 | short | bid | 602.2150 | 3.6500 | ["545"] | ["0.3787"] | ["606.90"] | ["XBOX"] | 545.0000 | 545.0000 | 115 | 115 | false | false | false | false | |||||||||
| 01a0c9cc-7456-7053-8b7b-637a1850d0d8 | SMH | 2026-09-22 11:46 | synthetic | 2 | 1 | 78 | 1000740.00 | short | bid | 601.3700 | 5.7500 | ["560"] | ["0.3791"] | ["608.70"] | ["XBOX"] | 560.0000 | 560.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0c9c4-c396-73a2-9b5e-abb78f918e87 | SMH | 2026-09-22 11:38 | other | 2 | 1 | 500 | 2885000.00 | unknown | bid | 600.9700 | 5.0500 | ["700"] | ["0.3580"] | ["539.72","757.70"] | ["XPHO"] | 700.0000 | 700.0000 | 115 | 115 | false | false | false | false | |||||||||
| 01a0c56a-df57-7932-8cd8-2af833490ff6 | SMH | 2026-09-21 15:21 | call_diagonal_spread | 2 | 1 | 7000 | 6034000.00 | unknown | bid | 596.8200 | 4.0900 | ["570","610"] | ["0.5256","0.3035"] | [] | ["AMXO"] | 570.0000 | 610.0000 | 2 | 3 | false | false | true | true | |||||||||
| 01a0c50b-2f3f-7740-bd1b-706ec10c0fc8 | SMH | 2026-09-21 13:37 | other | 5 | 1 | 1100 | 2702800.00 | unknown | bid | 592.8200 | 4.2500 | ["570","585","595","597.5","615"] | ["0.3037","0.3352","0.3131","0.2999","0.3196"] | [] | ["XBOX"] | 570.0000 | 615.0000 | 4 | 25 | false | false | true | true | |||||||||
| 01a0c4b2-a72f-7093-8eb3-6fd316f84447 | SMH | 2026-09-21 12:00 | straddle | 2 | 1 | 100 | 952000.00 | short | bid | 590.3050 | 3.7000 | ["600"] | ["0.3586"] | ["504.80","695.20"] | ["AMXO"] | 600.0000 | 600.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c44e-c0f7-7110-84e2-54c567b67332 | SMH | 2026-09-21 10:11 | straddle | 2 | 1 | 122 | 1021140.00 | short | bid | 583.8200 | 4.2000 | ["565"] | ["0.3639"] | ["481.30","648.70"] | ["AMXO"] | 565.0000 | 565.0000 | 88 | 88 | false | false | false | false | |||||||||
| 01a0c443-7a3f-70a3-a8ae-cc7f159ce7ed | SMH | 2026-09-21 09:59 | call_butterfly_spread | 3 | 1 | 1000 | 1224500.00 | short | bid | 584.4700 | 0.7400 | ["610","630","665"] | ["0.3305","0.3304","0.3374"] | ["610.87","649.13"] | ["SPHR"] | 610.0000 | 665.0000 | 25 | 25 | false | true | false | ||||||||||
| 01a0b5fd-c57f-7683-80f4-8e5cae9605a3 | SMH | 2026-09-18 15:28 | straddle | 2 | 1 | 400 | 82000.00 | short | bid | 565.7000 | 1.2800 | ["567.5"] | ["0.3846"] | ["565.45","569.55"] | ["AMXO"] | 567.5000 | 567.5000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b5eb-3f4f-7930-94a7-4b0188532821 | SMH | 2026-09-18 15:08 | straddle | 2 | 2 | 70 | 1332450.00 | short | bid | 565.5900 | 8.2500 | ["555"] | ["0.3754"] | ["364.65","745.35"] | ["AMXO"] | 555.0000 | 555.0000 | 490 | 490 | true | false | false | false | |||||||||
| 01a0b5a8-5e37-7403-9204-98783bdfd62e | SMH | 2026-09-18 13:55 | risk_reversal | 2 | 2 | 500 | 2092500.00 | long | bid | 564.5400 | 1.6500 | ["550","605"] | ["0.3554","0.3370"] | ["543.29"] | ["AMXO"] | 550.0000 | 605.0000 | 63 | 63 | false | true | false | true | |||||||||
| 01a0b4d8-f877-7142-8090-b633bd8db0f2 | SMH | 2026-09-18 10:08 | call_ratio_spread | 2 | 2 | 1000 | 1653500.00 | unknown | bid | 564.4400 | 1.9500 | ["565","600"] | ["0.3048","0.2968"] | ["598.07"] | ["AMXO"] | 565.0000 | 600.0000 | 28 | 28 | false | true | false | true | |||||||||
| 01a0b094-c72b-7c72-a132-75a87be33191 | SMH | 2026-09-17 14:15 | strangle | 2 | 1 | 201 | 658275.00 | short | bid | 561.4300 | 1.3000 | ["500","660"] | ["0.3739","0.3289"] | ["467.25","692.75"] | ["XBOX"] | 500.0000 | 660.0000 | 120 | 120 | false | true | false | true | |||||||||
| 01a0afec-88db-7752-bafa-2bd6d0ac5ff3 | SMH | 2026-09-17 11:11 | risk_reversal | 2 | 1 | 62 | 432760.00 | long | bid | 559.6450 | 3.1500 | ["565","585"] | ["0.3527","0.3469"] | ["556.52"] | ["XPHO"] | 565.0000 | 585.0000 | 92 | 92 | false | false | false | true | |||||||||
| 01a0aa96-d7ab-7c30-9ad2-42609d670d36 | SMH | 2026-09-16 10:20 | straddle | 2 | 1 | 200 | 1560000.00 | short | bid | 551.2300 | 2.9000 | ["550"] | ["0.3532"] | ["472","628.00"] | ["SPHR"] | 550.0000 | 550.0000 | 93 | 93 | false | false | false | false | |||||||||
| 01a0a660-ca5e-7382-94cf-8c542df7e575 | SMH | 2026-09-15 14:42 | risk_reversal | 2 | 2 | 280 | 1211000.00 | short | bid | 541.3700 | 2.2000 | ["515","565"] | ["0.3682","0.3439"] | ["568.41"] | ["AMXO"] | 515.0000 | 565.0000 | 66 | 66 | false | true | false | true | |||||||||
| 01a0a5b6-3e36-77e2-baa9-63ec633f62eb | SMH | 2026-09-15 11:36 | risk_reversal | 2 | 2 | 285 | 1239750.00 | short | bid | 543.0300 | 2.6000 | ["515","565"] | ["0.3705","0.3425"] | ["569.36"] | ["AMXO"] | 515.0000 | 565.0000 | 66 | 66 | false | true | false | true | |||||||||
| 01a0a094-4800-7f03-867e-7d1fae4beae6 | SMH | 2026-09-14 11:41 | synthetic | 2 | 1 | 35 | 390600.00 | long | bid | 544.6900 | 5.3000 | ["560"] | ["0.3594"] | ["554.80"] | ["AMXO"] | 560.0000 | 560.0000 | 186 | 186 | false | false | false | false | |||||||||
| 01a0a08c-c238-7b93-a7ea-df7c40f6294b | SMH | 2026-09-14 11:32 | call_vertical_spread | 2 | 1 | 200 | 189200.00 | short | bid | 543.7300 | 0.8500 | ["545","565"] | ["0.3581","0.3680"] | ["550.80"] | ["SPHR"] | 545.0000 | 565.0000 | 4 | 4 | false | true | false | true | |||||||||
| 01a0910c-f468-7b82-a6c2-fdf9606a9758 | SMH | 2026-09-11 11:18 | strangle | 2 | 1 | 130 | 1904500.00 | short | bid | 570.9700 | 8.3500 | ["500","700"] | ["0.4075","0.3658"] | ["353.50","846.50"] | ["AMXO"] | 500.0000 | 700.0000 | 644 | 644 | false | true | false | true | |||||||||
| 01a08cbe-7a08-7d81-8410-cd40b0dae145 | SMH | 2026-09-10 15:14 | call_diagonal_spread | 2 | 2 | 21 | 62916.00 | long | bid | 561.2400 | 4.9500 | ["547.5","550"] | ["0.5467","0.3176"] | [] | ["AMXO"] | 547.5000 | 550.0000 | 1 | 4 | false | false | true | true | |||||||||
| 01a086e5-6fd8-7711-b756-9ea748f925ba | SMH | 2026-09-09 11:59 | straddle | 2 | 1 | 335 | 6599500.00 | short | bid | 574.1900 | 8.9000 | ["580"] | ["0.3912"] | ["383","777.00"] | ["XBOX"] | 580.0000 | 580.0000 | 464 | 464 | false | false | false | false | |||||||||
| 01a0828a-5318-7230-85d5-542746851d80 | SMH | 2026-09-08 15:41 | straddle | 2 | 1 | 200 | 38400.00 | short | bid | 573.4700 | 1.7400 | ["572.5"] | ["0.6471"] | ["570.58","574.42"] | ["AMXO"] | 572.5000 | 572.5000 | 0 | 0 | false | false | false | false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:03:11Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:04:32Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:01:19Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:47:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:38:41Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:22:22Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:37:33Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:00:55Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:11:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:59:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:28:25Z"} |
| 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-18T19:08:27Z"} |
| 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:55:22Z"} |
| 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-18T14:08:42Z"} |
| 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-17T18:16:02Z"} |
| 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-17T15:11:55Z"} |
| 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-16T14:20:14Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:43:13Z"} |
| 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-15T15:36:49Z"} |
| 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-14T15:41:23Z"} |
| 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-14T15:33:04Z"} |
| 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-11T15:19:16Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:15:20Z"} |
| 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-09T16:00:05Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:42:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |