core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 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 |
|---|
| 01a0f336-71b7-73d2-ae3e-16295c1b63da | FANG | 2026-09-30 12:47 | straddle | 2 | 1 | 500 | 3075000.00 | short | bid | 185.5800 | 5.2000 | ["200"] | ["0.3636"] | ["138.50","261.50"] | ["AMXO"] | 200.0000 | 200.0000 | 478 | 478 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-30T16:48:02Z"} | 2026-09-30 | 2026-09-30 17:15 | 2026-09-30 17:15 |
| 01a0e940-1aff-7a23-8748-b853df34accd | FANG | 2026-09-28 14:21 | straddle | 2 | 3 | 41 | 109306.00 | short | bid | 186.3350 | 0.4537 | ["195"] | ["0.3663"] | ["168.34","221.66"] | ["XBOX","XISX","XMIO"] | 195.0000 | 195.0000 | 81 | 81 | false | false | false | false | |||||||||
| 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 | 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 | 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 | 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 | ||||||||||
| 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 | ||||||||||
| 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 | true | |||||||||
| 01a08cdb-54c1-7e91-811d-f93dbdf04447 | FANG | 2026-09-10 15:46 | strangle | 2 | 1 | 330 | 2046000.00 | short | bid | 205.1306 | 5.6000 | ["220","240"] | ["0.4004","0.3231"] | ["158","302.00"] | ["SPHR"] | 220.0000 | 240.0000 | 498 | 498 | true | false | false | true | |||||||||
| 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 | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T18:21:47Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| 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 |
| 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:17:23Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| 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 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:46:37Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| 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 |