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 |
|---|
| 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 |
|---|
| 01a0c94f-5c53-72a3-a1d4-9d09cefb7d2c | LNG | 2026-09-22 09:30 | call_vertical_spread | 2 | 1 | 400 | 684000.00 | long | ask | 270.7400 | 3.0000 | ["270","280"] | ["0.3735","0.3459"] | ["275"] | ["XCBO"] | 270.0000 | 280.0000 | 24 | 24 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:30:09Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c586-3b3e-7b50-96b4-63a5ec4e6172 | LNG | 2026-09-21 15:51 | call_vertical_spread | 2 | 1 | 90 | 185400.00 | long | ask | 276.7350 | 1.8789 | ["275","280"] | ["0.3569","0.3534"] | ["277.50"] | ["XISX"] | 275.0000 | 280.0000 | 25 | 25 | false | false | |||||||||||
| 01a0c55c-3d3f-73b1-a573-510d6ad3de0d | LNG | 2026-09-21 15:05 | straddle | 2 | 1 | 33 | 108240.00 | short | bid | 277.5000 | 1.6000 | ["260"] | ["0.3327"] | ["227.20","292.80"] | ["XISX"] | 260.0000 | 260.0000 | 60 | 60 | false | false | |||||||||||
| 01a0c52e-14d6-79a0-871d-2ba0de0e5569 | LNG | 2026-09-21 14:15 | call_diagonal_spread | 2 | 1 | 75 | 238500.00 | long | bid | 277.2350 | 1.8000 | ["250","285"] | ["0.5882","0.3736"] | [] | ["XPHO"] | 250.0000 | 285.0000 | 4 | 11 | false | false | |||||||||||
| 01a0b093-11ab-7222-8a43-750ad707e452 | LNG | 2026-09-17 14:13 | put_calendar | 2 | 1 | 38 | 167390.00 | unknown | — | 269.5050 | 3.9000 | ["290"] | ["0.6861"] | [] | ["XPHO"] | 290.0000 | 290.0000 | 1 | 29 | false | false | true | false | false | ||||||||
| 01a0a625-24d6-7422-87bb-aecf62207e27 | LNG | 2026-09-15 13:37 | call_vertical_spread | 2 | 1 | 40 | 195200.00 | unknown | — | 272.6600 | 3.6000 | ["230","270"] | ["1.0011","0.4369"] | [] | ["XPHO"] | 230.0000 | 270.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a624-07ae-7791-9d5e-06a8f8155b61 | LNG | 2026-09-15 13:36 | call_vertical_spread | 2 | 1 | 200 | 221200.00 | unknown | — | 272.5400 | 1.4000 | ["267.5","272.5"] | ["0.3997","0.4065"] | [] | ["XISX"] | 267.5000 | 272.5000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a620-cf75-7221-8516-e4fd4178d439 | LNG | 2026-09-15 13:32 | call_vertical_spread | 2 | 1 | 75 | 260250.00 | unknown | — | 272.7800 | 4.2000 | ["250","265"] | ["0.3969","0.3435"] | [] | ["XISX"] | 250.0000 | 265.0000 | 10 | 10 | false | false | false | true | |||||||||
| 01a0a12b-cd10-71f2-89ee-8460867642da | LNG | 2026-09-14 14:26 | call_vertical_spread | 2 | 1 | 20 | 205820.00 | unknown | — | 276.3500 | 4.1000 | ["220","230"] | ["1.4420","0.6888"] | [] | ["XISX"] | 220.0000 | 230.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0a09e-1f88-7080-952a-9332af75b9d3 | LNG | 2026-09-14 11:51 | call_vertical_spread | 2 | 1 | 75 | 188250.00 | unknown | — | 276.6900 | 2.6000 | ["265","270"] | ["0.3583","0.3527"] | [] | ["XISX"] | 265.0000 | 270.0000 | 11 | 11 | false | false | false | true | |||||||||
| 01a090f3-4a18-7242-8d32-4dea8103a559 | LNG | 2026-09-11 10:50 | call_vertical_spread | 2 | 1 | 145 | 284200.00 | unknown | — | 274.9600 | 1.5724 | ["270","275"] | ["0.3097","0.3104"] | [] | ["XISX"] | 270.0000 | 275.0000 | 21 | 21 | true | false | false | true | |||||||||
| 01a090f3-4a18-7242-8d32-4dd349757e0a | LNG | 2026-09-11 10:50 | call_vertical_spread | 2 | 1 | 74 | 146224.00 | unknown | — | 274.9600 | 2.1000 | ["270","275"] | ["0.3128","0.3135"] | [] | ["XISX"] | 270.0000 | 275.0000 | 21 | 21 | true | false | false | true | |||||||||
| 01a090e7-5780-75b1-9a21-61976e89a423 | LNG | 2026-09-11 10:37 | call_vertical_spread | 2 | 1 | 230 | 505770.00 | long | ask | 276.0300 | 3.4000 | ["265","270"] | ["0.3799","0.3539"] | ["268.95"] | ["XMIO"] | 265.0000 | 270.0000 | 7 | 7 | false | false | |||||||||||
| 01a090b9-a060-7df2-97e0-5db213006a08 | LNG | 2026-09-11 09:47 | call_diagonal_spread | 2 | 1 | 20 | 176720.00 | unknown | — | 279.6250 | 5.8000 | ["240","250"] | ["0.2964","0.3144"] | [] | ["XISX"] | 240.0000 | 250.0000 | 70 | 189 | false | false | true | true | |||||||||
| 01a08c3c-ea10-72f1-8026-09117b0a613a | LNG | 2026-09-10 12:53 | call_calendar | 2 | 1 | 30 | 419820.00 | short | bid | 278.7800 | 4.5000 | ["210"] | ["0.8144"] | [] | ["BATO"] | 210.0000 | 210.0000 | 8 | 36 | false | false | |||||||||||
| 01a08c3b-7310-7491-98fa-13a2eea8cbba | LNG | 2026-09-10 12:51 | other | 2 | 1 | 30 | 478380.00 | unknown | — | 278.7900 | 5.7000 | ["200"] | ["0.8684"] | [] | ["XISX"] | 200.0000 | 200.0000 | 8 | 36 | false | false | true | false | false | ||||||||
| 01a08b8c-7630-7913-9b57-b856ad33a876 | LNG | 2026-09-10 09:40 | call_vertical_spread | 2 | 2 | 128 | 144360.00 | short | bid | 279.0250 | 3.3000 | ["272.5","277.5"] | ["0.5659","0.4998"] | ["276.28"] | ["ARCO","XISX"] | 272.5000 | 277.5000 | 1 | 1 | false | false | |||||||||||
| 01a08b8c-7630-7913-9b57-b847015bcc1a | LNG | 2026-09-10 09:40 | call_vertical_spread | 2 | 3 | 202 | 228680.00 | short | bid | 279.0250 | 3.5713 | ["272.5","277.5"] | ["0.5715","0.5031"] | ["276.29"] | ["AMXO","ARCO","XISX"] | 272.5000 | 277.5000 | 1 | 1 | false | false | |||||||||||
| 01a08b8c-7630-7913-9b57-b8266f37ca5a | LNG | 2026-09-10 09:40 | call_vertical_spread | 2 | 2 | 111 | 124710.00 | short | bid | 279.0250 | 3.6000 | ["272.5","277.5"] | ["0.5604","0.4962"] | ["276.28"] | ["ARCO","XISX"] | 272.5000 | 277.5000 | 1 | 1 | true | false | |||||||||||
| 01a08b82-f883-7371-b594-50baa9fd5844 | LNG | 2026-09-10 09:30 | call_vertical_spread | 2 | 2 | 370 | 625300.00 | short | bid | 280.3600 | 2.7622 | ["270","275"] | ["0.3811","0.5212"] | ["274"] | ["XISX"] | 270.0000 | 275.0000 | 1 | 1 | false | false | |||||||||||
| 01a08b82-f883-7371-b594-50aab18f5a66 | LNG | 2026-09-10 09:30 | call_vertical_spread | 2 | 1 | 100 | 261800.00 | unknown | — | 280.3600 | 6.0000 | ["265","270"] | ["0.9972","0.5889"] | [] | ["XCBO"] | 265.0000 | 270.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08683-9ce0-7832-bcbb-ccfa2e2ad176 | LNG | 2026-09-09 10:12 | call_vertical_spread | 2 | 1 | 90 | 866700.00 | unknown | — | 278.4250 | 6.2000 | ["220","240"] | ["0.9682","0.7173"] | [] | ["XISX"] | 220.0000 | 240.0000 | 9 | 9 | false | false | false | true | |||||||||
| 01a081a7-1b20-7d52-9f82-012f863b955e | LNG | 2026-09-08 11:33 | call_vertical_spread | 2 | 2 | 100 | 222900.00 | long | ask | 276.7250 | 4.4250 | ["265","270"] | ["0.5489","0.4994"] | ["269.15"] | ["XISX"] | 265.0000 | 270.0000 | 3 | 3 | false | false | |||||||||||
| 01a08156-f399-7a32-908c-cd966e47e881 | LNG | 2026-09-08 10:05 | call_vertical_spread | 2 | 2 | 270 | 548400.00 | short | bid | 279.9300 | 5.7000 | ["270","275"] | ["0.5797","0.5313"] | ["273.89"] | ["ARCO","XISX"] | 270.0000 | 275.0000 | 3 | 3 | false | false | |||||||||||
| 01a08156-f399-7a32-908c-cd8064629ebc | LNG | 2026-09-08 10:05 | call_vertical_spread | 2 | 1 | 150 | 304500.00 | unknown | — | 279.9300 | 5.7000 | ["270","275"] | ["0.5795","0.5303"] | [] | ["XISX"] | 270.0000 | 275.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0814b-10a1-7601-9b84-44894c4c592f | LNG | 2026-09-08 09:52 | call_vertical_spread | 2 | 1 | 499 | 419160.00 | short | bid | 276.6800 | 2.5000 | ["275","280"] | ["0.3730","0.5154"] | ["275.94"] | ["MCRY"] | 275.0000 | 280.0000 | 3 | 3 | false | false | |||||||||||
| 01a08138-1159-79e1-af3d-e54dbe9fd549 | LNG | 2026-09-08 09:32 | call_vertical_spread | 2 | 2 | 499 | 436126.00 | long | ask | 275.4850 | 6.1500 | ["275","280"] | ["0.5204","0.5164"] | ["277.20"] | ["XPHO"] | 275.0000 | 280.0000 | 3 | 3 | true | false | |||||||||||
| 01a06d82-23ed-71f0-b5b1-f8eb802a034a | LNG | 2026-09-04 13:40 | put_frontspread | 2 | 4 | 164 | 120022.00 | long | ask | 289.0250 | 1.9500 | ["275","290"] | ["0.5124","0.5409"] | ["263.43","286.57"] | ["ARCO","C2OX","XCBO","XISX"] | 275.0000 | 290.0000 | 7 | 7 | false | false | |||||||||||
| 01a06d25-a43d-7fa3-8ffa-c9681f1e6d0e | LNG | 2026-09-04 11:59 | other | 2 | 3 | 60 | 121476.00 | unknown | — | 290.7550 | 2.7000 | ["290"] | ["0.4510"] | [] | ["XBOX"] | 290.0000 | 290.0000 | 7 | 21 | false | false | true | false | false | ||||||||
| 01a06d25-a43d-7fa3-8ffa-c959b9e57a34 | LNG | 2026-09-04 11:59 | call_calendar | 2 | 2 | 60 | 126420.00 | short | ask | 290.7550 | 2.7000 | ["290"] | ["0.4713"] | [] | ["AMXO","XPHO"] | 290.0000 | 290.0000 | 7 | 21 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:51:45Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:05:53Z"} |
| 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-21T18:15:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:14:24Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:37:56Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:36:52Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:33:06Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:27:00Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:52:02Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:51:11Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:51:11Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:38:20Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:48:13Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:53:28Z"} |
| 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-10T16:51:48Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:40:36Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:40:36Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:40:36Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:30:05Z"} |
| 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-10T13:30:05Z"} |
| 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-09T14:13:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:33:34Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:06:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:06:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:53:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:32:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:40:51Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T15:59:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T15:59:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |