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 |
|---|
| 01a06e01-372d-71c1-9c8e-f96d540be997 | META | 2026-09-04 15:59 | call_diagonal_spread_bullish | 2 | 1 | 300 | 6510600.00 | long | ask | 616.8100 | 5.6500 | ["450","600"] | ["0.4573","0.3570"] | [] | ["ARCO"] | 450.0000 | 600.0000 | 42 | 105 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:59:34Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfd-b4bd-7932-a622-a0efab825358 | META | 2026-09-04 15:55 | call_diagonal_spread_bullish | 2 | 1 | 5 | 164550.00 | long | ask | 616.9600 | 5.7000 | ["300","605"] | ["1.0942","4.3006"] | [] | ["ARCO"] | 300.0000 | 605.0000 | 0 | 42 | false | false | true | ||||||||||
| 01a06de7-003d-7773-9b7d-e8373857549b | META | 2026-09-04 15:30 | call_diagonal_spread_bullish | 2 | 1 | 40 | 118600.00 | short | bid | 616.6350 | 0.3000 | ["605","610"] | ["0.3328","0.9397"] | [] | ["BATO"] | 605.0000 | 610.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a06de4-29ad-7480-aa87-240f4a84d79c | META | 2026-09-04 15:27 | call_diagonal_spread_bullish | 2 | 1 | 4 | 29332.00 | short | bid | 616.3700 | 1.5500 | ["650","660"] | ["0.4022","0.4165"] | [] | ["XMIO"] | 650.0000 | 660.0000 | 77 | 105 | false | true | true | ||||||||||
| 01a06dd6-1fed-72e1-9eaf-18883b3f1cda | META | 2026-09-04 15:12 | call_diagonal_spread_bullish | 2 | 1 | 100 | 279000.00 | short | bid | 616.3400 | 0.7500 | ["610","615"] | ["0.3015","0.3230"] | [] | ["XISX"] | 610.0000 | 615.0000 | 7 | 10 | false | false | true | ||||||||||
| 01a06dd5-fcc5-7c31-b312-4173b7a5da36 | META | 2026-09-04 15:12 | call_diagonal_spread_bullish | 2 | 1 | 80 | 222400.00 | short | bid | 616.2550 | 1.2000 | ["610","615"] | ["0.3007","0.3237"] | [] | ["XMIO"] | 610.0000 | 615.0000 | 7 | 10 | false | false | true | ||||||||||
| 01a06dcb-17b5-7413-9bd7-2ec774edbbdb | META | 2026-09-04 15:00 | call_diagonal_spread_bullish | 2 | 2 | 10 | 70700.00 | short | bid | 614.8400 | 1.1500 | ["560","610"] | ["0.3553","0.6782"] | [] | ["XCBO"] | 560.0000 | 610.0000 | 0 | 42 | false | false | true | ||||||||||
| 01a06dca-40dd-71b2-b052-7779c87cf697 | META | 2026-09-04 14:59 | call_diagonal_spread_bullish | 2 | 1 | 5 | 30070.00 | long | ask | 614.8700 | 0.9500 | ["570","612.5"] | ["0.3390","0.3128"] | [] | ["BATO"] | 570.0000 | 612.5000 | 7 | 14 | false | false | true | ||||||||||
| 01a06dc6-6c65-76d0-aa81-8efc362841ff | META | 2026-09-04 14:55 | call_diagonal_spread_bullish | 2 | 1 | 5 | 94000.00 | short | bid | 613.3600 | 4.9000 | ["500","550"] | ["0.4284","6.3628"] | [] | ["SPHR"] | 500.0000 | 550.0000 | 0 | 77 | false | false | true | ||||||||||
| 01a06da6-51a5-7a61-b8d5-dadbabf2aa5f | META | 2026-09-04 14:20 | call_diagonal_spread_bullish | 2 | 1 | 10 | 76140.00 | long | ask | 611.0860 | 2.3000 | ["570","590"] | ["0.3477","1.6071"] | [] | ["SPHR"] | 570.0000 | 590.0000 | 0 | 42 | false | false | true | ||||||||||
| 01a06d9c-6695-7142-ae93-6b3ded8a6afa | META | 2026-09-04 14:09 | call_diagonal_spread_bullish | 2 | 1 | 5 | 94745.00 | short | bid | 608.2550 | 2.7000 | ["500","610"] | ["0.4191","0.2606"] | [] | ["XCBO"] | 500.0000 | 610.0000 | 5 | 469 | false | false | true | ||||||||||
| 01a06d94-5815-7e21-a156-92365f38af6a | META | 2026-09-04 14:00 | call_diagonal_spread_bullish | 2 | 1 | 6 | 31182.00 | long | ask | 609.0250 | 0.8500 | ["570","612.5"] | ["0.3343","0.3129"] | [] | ["BATO"] | 570.0000 | 612.5000 | 7 | 14 | false | false | true | ||||||||||
| 01a06d78-09fd-7663-9d53-887b0a537629 | META | 2026-09-04 13:29 | call_diagonal_spread_bullish | 2 | 1 | 20 | 61600.00 | short | bid | 609.3900 | 0.4300 | ["580","612.5"] | ["0.2634","0.4494"] | [] | ["XMIO"] | 580.0000 | 612.5000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d6e-c6e5-7840-bfeb-c89b262b58c7 | META | 2026-09-04 13:19 | call_diagonal_spread_bullish | 2 | 1 | 2 | 53880.00 | short | bid | 608.8900 | 5.6000 | ["350","597.5"] | ["1.7989","0.6154"] | [] | ["C2OX"] | 350.0000 | 597.5000 | 0 | 14 | false | false | true | ||||||||||
| 01a06d6d-9a1d-7a31-b1fd-9bd10984260d | META | 2026-09-04 13:18 | call_diagonal_spread_bullish | 2 | 1 | 6 | 41682.00 | short | bid | 609.4600 | 1.5000 | ["575","590"] | ["0.3479","0.8391"] | [] | ["MCRY"] | 575.0000 | 590.0000 | 0 | 42 | false | false | true | ||||||||||
| 01a06d3f-df15-70c0-ba5b-5a6c30634fc2 | META | 2026-09-04 12:28 | call_diagonal_spread_bullish | 2 | 1 | 7 | 262374.00 | long | ask | 613.3599 | 6.9500 | ["300","595"] | ["0.4469","0.7898"] | [] | ["XISX"] | 300.0000 | 595.0000 | 0 | 833 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:55:40Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:30:55Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:28:02Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:12:56Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:12:20Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:00:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:59:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:55:39Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:20:35Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:10:05Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:00:35Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:29:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:19:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:18:49Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:28:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |