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 |
|---|
| 01a08bfa-eb88-7cf3-96a3-979ba237ed50 | FANG | 2026-09-10 11:41 | call_diagonal_spread | 2 | 2 | 72 | 129636.00 | unknown | — | 203.9550 | 0.8000 | ["200","250"] | ["0.3910","0.3317"] | [] | ["C2OX","XPHO"] | 200.0000 | 250.0000 | 8 | 280 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:41:31Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c03-2cd0-7fa0-bf7f-bf256a7908f9 | FANG | 2026-09-10 11:50 | call_diagonal_spread | 2 | 2 | 72 | 133992.00 | short | bid | 204.4850 | 1.0000 | ["200","250"] | ["0.3939","0.3325"] | [] | ["AMXO"] | 200.0000 | 250.0000 | 8 | 280 | false | false | true | ||||||||||
| 01a0a58f-ed9e-7151-b688-ad52b401864c | FANG | 2026-09-15 10:54 | call_diagonal_spread | 2 | 1 | 123 | 180810.00 | unknown | — | 209.7100 | 2.6000 | ["220","230"] | ["0.4682","0.3386"] | [] | ["XBOX"] | 220.0000 | 230.0000 | 3 | 185 | false | true | true | true | false | ||||||||
| 01a0aad3-11a3-7c31-81e6-94ba62f76d10 | FANG | 2026-09-16 11:25 | call_diagonal_spread | 2 | 1 | 32 | 117600.00 | short | bid | 192.4200 | 4.3000 | ["175","185"] | ["0.8023","0.3668"] | [] | ["XMIO"] | 175.0000 | 185.0000 | 2 | 93 | false | false | true | ||||||||||
| 01a0ab70-0553-7772-91b4-7f2e445b4072 | FANG | 2026-09-16 14:17 | call_diagonal_spread | 2 | 6 | 52 | 132237.00 | short | bid | 197.3900 | 3.0000 | ["220","260"] | ["0.3695","0.3400"] | [] | ["ARCO","EDGO","XBOX","XCBO","XISX","XPHO"] | 220.0000 | 260.0000 | 121 | 492 | false | true | true | ||||||||||
| 01a0ab70-2493-7ba0-9a0a-2e1713a83594 | FANG | 2026-09-16 14:17 | call_diagonal_spread | 2 | 8 | 50 | 124970.00 | long | ask | 197.3900 | 2.8000 | ["220","260"] | ["0.3646","0.3374"] | [] | ["AMXO","ARCO","EDGO","XBOX","XCBO","XISX","XMIO","XPHO"] | 220.0000 | 260.0000 | 121 | 492 | false | true | true | ||||||||||
| 01a0ab70-6ae3-78e1-a631-4b0e8acf1c03 | FANG | 2026-09-16 14:17 | call_diagonal_spread | 2 | 8 | 47 | 117622.00 | long | ask | 197.2150 | 2.8000 | ["220","260"] | ["0.3665","0.3383"] | [] | ["AMXO","ARCO","EDGO","XCBO","XISX","XMIO","XPHO"] | 220.0000 | 260.0000 | 121 | 492 | false | true | true | ||||||||||
| 01a0ab83-9cf3-7b83-95a9-d7baa9af3ffc | FANG | 2026-09-16 14:38 | call_diagonal_spread | 2 | 1 | 240 | 1610160.00 | short | bid | 195.6800 | 1.0000 | ["170","200"] | ["0.3779","0.3337"] | [] | ["XISX"] | 170.0000 | 200.0000 | 121 | 492 | false | false | true | ||||||||||
| 01a0ab83-9cf3-7b83-95a9-d79011af7d53 | FANG | 2026-09-16 14:38 | call_diagonal_spread | 2 | 8 | 940 | 6316757.00 | short | bid | 195.6600 | 1.0461 | ["170","200"] | ["0.3803","0.3344"] | [] | ["ARCO","EDGO","XCBO","XISX"] | 170.0000 | 200.0000 | 121 | 492 | false | false | true | ||||||||||
| 01a0ab83-9cf3-7b83-95a9-d77f5fbbcf4b | FANG | 2026-09-16 14:38 | call_diagonal_spread | 2 | 4 | 167 | 1122240.00 | short | bid | 195.6350 | 1.5503 | ["170","200"] | ["0.3812","0.3345"] | [] | ["ARCO","MCRY","XPHO"] | 170.0000 | 200.0000 | 121 | 492 | false | false | true | ||||||||||
| 01a0ab83-9cf3-7b83-95a9-d75bda696d5d | FANG | 2026-09-16 14:38 | call_diagonal_spread | 2 | 1 | 77 | 517440.00 | short | bid | 195.6350 | 1.7000 | ["170","200"] | ["0.3812","0.3345"] | [] | ["XPHO"] | 170.0000 | 200.0000 | 121 | 492 | false | false | true | ||||||||||
| 01a0ab83-9cf3-7b83-95a9-d72d56b45d83 | FANG | 2026-09-16 14:38 | call_diagonal_spread | 2 | 4 | 259 | 1748180.00 | short | bid | 195.6350 | 3.3301 | ["170","200"] | ["0.3857","0.3362"] | [] | ["ARCO","MCRY","XMIO","XPHO"] | 170.0000 | 200.0000 | 121 | 492 | false | false | true | ||||||||||
| 01a0afc9-ed7b-7243-8c85-9b2dd4f59c02 | FANG | 2026-09-17 10:33 | call_diagonal_spread | 2 | 1 | 60 | 225600.00 | unknown | — | 193.2200 | 5.6000 | ["175","185"] | ["1.0048","0.3602"] | [] | ["XPHO"] | 175.0000 | 185.0000 | 1 | 92 | false | false | true | true | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:50:48Z"} |
| 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-15T14:54:44Z"} |
| 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-16T15:26:32Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:17:23Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:18:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:18:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:38:57Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:38:57Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:38:57Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:38:57Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:38:57Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:34:22Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |