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 |
|---|
| 01a0c496-4977-7130-92fd-aef8651ea390 | FSLR | 2026-09-21 11:29 | put_vertical_spread | 2 | 1 | 1000 | 21176000.00 | long | ask | 196.7100 | 4.5500 | ["280","300"] | ["0.5691","0.5874"] | ["283.46"] | ["XPHO"] | 280.0000 | 300.0000 | 487 | 487 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:29:43Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c48f-f847-7791-a990-3b84c44068da | FSLR | 2026-09-21 11:22 | put_diagonal_spread | 2 | 2 | 110 | 781275.00 | long | ask | 196.9400 | 2.0500 | ["197.5","260"] | ["0.5336","0.5790"] | [] | ["EDGO","EMLD"] | 197.5000 | 260.0000 | 4 | 88 | false | false | true | ||||||||||
| 01a0c48f-f45e-7311-a463-0c1607c0a89e | FSLR | 2026-09-21 11:22 | put_diagonal_spread | 2 | 1 | 14 | 113876.00 | long | ask | 196.9400 | 3.0750 | ["200","270"] | ["0.5310","0.5886"] | [] | ["XPHO"] | 200.0000 | 270.0000 | 4 | 88 | false | false | true | ||||||||||
| 01a0c431-0797-7e71-9709-0b53b109f21b | FSLR | 2026-09-21 09:38 | put_diagonal_spread | 2 | 1 | 10 | 215070.00 | long | bid | 194.2100 | 3.2500 | ["250","340"] | ["0.5501","0.6750"] | [] | ["XMIO"] | 250.0000 | 340.0000 | 179 | 269 | false | false | true | ||||||||||
| 01a0b5f0-6f6f-74d0-8948-ef50cb08eed8 | FSLR | 2026-09-18 15:13 | put_diagonal_spread | 2 | 1 | 500 | 10578500.00 | long | bid | 195.5300 | 6.7500 | ["250","320"] | ["0.5528","0.6027"] | [] | ["XMIO"] | 250.0000 | 320.0000 | 490 | 637 | false | false | true | ||||||||||
| 01a0b0a0-504b-7c02-9f62-9ffc6bc72a08 | FSLR | 2026-09-17 14:28 | call_diagonal_spread | 2 | 2 | 72 | 368028.00 | long | ask | 201.5700 | 1.5500 | ["200","205"] | ["0.5445","0.4902"] | [] | ["ARCO","C2OX"] | 200.0000 | 205.0000 | 8 | 365 | false | false | true | ||||||||||
| 01a0b0a0-487a-78a0-9f89-5da8dfce676e | FSLR | 2026-09-17 14:28 | call_diagonal_spread | 2 | 2 | 120 | 615780.00 | long | ask | 201.5700 | 1.7500 | ["200","205"] | ["0.5458","0.4988"] | [] | ["ARCO","C2OX"] | 200.0000 | 205.0000 | 8 | 365 | false | false | true | ||||||||||
| 01a0b0a0-487a-78a0-9f89-5d942d6ac345 | FSLR | 2026-09-17 14:28 | call_diagonal_spread | 2 | 2 | 120 | 615960.00 | long | ask | 201.5700 | 1.7750 | ["200","205"] | ["0.5460","0.4988"] | [] | ["ARCO","C2OX"] | 200.0000 | 205.0000 | 8 | 365 | false | false | true | ||||||||||
| 01a0b0a0-34f3-7f40-b740-6beabee73f4f | FSLR | 2026-09-17 14:28 | call_diagonal_spread | 2 | 1 | 60 | 309240.00 | long | ask | 201.5700 | 2.0000 | ["200","205"] | ["0.5471","0.5094"] | [] | ["C2OX"] | 200.0000 | 205.0000 | 8 | 365 | false | false | true | ||||||||||
| 01a0b09f-c3ab-79a2-b7f0-84551647437b | FSLR | 2026-09-17 14:27 | call_diagonal_spread | 2 | 2 | 120 | 610800.00 | long | ask | 201.3100 | 1.6500 | ["200","205"] | ["0.5452","0.4906"] | [] | ["ARCO","C2OX"] | 200.0000 | 205.0000 | 8 | 365 | false | false | true | ||||||||||
| 01a0b069-c373-7252-ba1f-0bd419f86a41 | FSLR | 2026-09-17 13:28 | call_diagonal_spread | 2 | 1 | 1500 | 4418998.00 | long | ask | 202.2600 | 2.3000 | ["200","230"] | ["0.5105","0.5429"] | [] | ["XMIO"] | 200.0000 | 230.0000 | 8 | 183 | false | false | true | ||||||||||
| 01a0b059-21a3-79f2-b8f0-2de81b963c59 | FSLR | 2026-09-17 13:10 | call_diagonal_spread | 2 | 1 | 200 | 350200.00 | long | bid | 202.0100 | 1.4000 | ["192.5","210"] | ["0.5498","0.4827"] | [] | ["XISX"] | 192.5000 | 210.0000 | 1 | 29 | false | false | true | ||||||||||
| 01a0b059-21a3-79f2-b8f0-2dcc5621812b | FSLR | 2026-09-17 13:10 | call_diagonal_spread | 2 | 1 | 200 | 356800.00 | long | bid | 201.9300 | 2.1000 | ["192.5","210"] | ["0.7201","0.4914"] | [] | ["XISX"] | 192.5000 | 210.0000 | 1 | 29 | false | false | true | ||||||||||
| 01a0b059-21a3-79f2-b8f0-2db48ee3c526 | FSLR | 2026-09-17 13:10 | call_diagonal_spread | 2 | 1 | 200 | 357000.00 | long | bid | 201.9300 | 2.1000 | ["192.5","210"] | ["0.7091","0.4927"] | [] | ["XPHO"] | 192.5000 | 210.0000 | 1 | 29 | false | false | true | ||||||||||
| 01a0ab3f-259b-73e1-bad0-91f4849268da | FSLR | 2026-09-16 13:23 | put_diagonal_spread | 2 | 1 | 14 | 108332.00 | long | ask | 191.3200 | 5.0000 | ["220","230"] | ["0.5226","1.7125"] | [] | ["MCRY"] | 220.0000 | 230.0000 | 2 | 121 | false | false | true | ||||||||||
| 01a0aa9d-f012-7ef3-b66b-02c51cacb68b | FSLR | 2026-09-16 10:27 | put_diagonal_spread | 2 | 1 | 1000 | 10354000.00 | long | bid | 197.7600 | 5.0000 | ["200","220"] | ["0.5240","0.5325"] | [] | ["XCBO"] | 200.0000 | 220.0000 | 492 | 856 | false | false | true | ||||||||||
| 01a0a676-659e-77f2-9a9b-8ff4a098790d | FSLR | 2026-09-15 15:06 | put_diagonal_spread | 2 | 1 | 460 | 1027698.00 | long | ask | 203.4300 | 1.3000 | ["150","170"] | ["0.5257","0.5300"] | [] | ["XMIO"] | 150.0000 | 170.0000 | 122 | 367 | false | true | true | ||||||||||
| 01a09208-4c29-7322-9793-c5c8ca020876 | FSLR | 2026-09-11 15:53 | call_calendar | 2 | 1 | 300 | 145200.00 | long | bid | 208.7900 | 0.4200 | ["210"] | ["0.9570"] | [] | ["XBOX"] | 210.0000 | 210.0000 | 0 | 7 | false | true | true | false | |||||||||
| 01a08c91-c4b8-7712-a76c-da8c07d3563d | FSLR | 2026-09-10 14:25 | put_diagonal_spread | 2 | 1 | 1100 | 3863200.00 | long | bid | 205.8650 | 2.8500 | ["150","185"] | ["0.5150","0.5215"] | [] | ["SPHR"] | 150.0000 | 185.0000 | 190 | 498 | false | true | true | ||||||||||
| 01a08669-7590-7a33-b24e-3931ddaa3837 | FSLR | 2026-09-09 09:44 | call_calendar | 2 | 3 | 236 | 550925.00 | long | bid | 211.2000 | 2.3013 | ["205"] | ["0.5302"] | [] | ["ARCO","C2OX","XPHO"] | 205.0000 | 205.0000 | 9 | 16 | true | false | true | false | |||||||||
| 01a0827a-de10-7160-a5c7-9db10ee60330 | FSLR | 2026-09-08 15:24 | put_vertical_spread | 2 | 2 | 13 | 110861.00 | long | ask | 213.5750 | 2.6500 | ["185","270"] | ["0.5345","0.5556"] | ["218.17"] | ["XCBO","XMIO"] | 185.0000 | 270.0000 | 192 | 192 | false | false | false | ||||||||||
| 01a0827a-da28-71e1-9b3e-f718599f378d | FSLR | 2026-09-08 15:24 | put_vertical_spread | 2 | 2 | 13 | 110861.00 | long | ask | 213.5750 | 2.6500 | ["185","270"] | ["0.5345","0.5556"] | ["218.17"] | ["XCBO","XMIO"] | 185.0000 | 270.0000 | 192 | 192 | false | false | false | ||||||||||
| 01a0827a-da28-71e1-9b3e-f6e1d685b9c7 | FSLR | 2026-09-08 15:24 | put_vertical_spread | 2 | 5 | 33 | 281179.00 | long | ask | 213.5750 | 2.1909 | ["185","270"] | ["0.5338","0.5549"] | ["218.17"] | ["AMXO","EMLD","XISX","XMIO","XPHO"] | 185.0000 | 270.0000 | 192 | 192 | false | false | false | ||||||||||
| 01a0820b-3fd8-7b21-9c61-7ad9bbdb8759 | FSLR | 2026-09-08 13:22 | put_diagonal_spread | 2 | 11 | 90 | 168530.00 | long | ask | 214.3350 | 1.6000 | ["210","220"] | ["0.5041","0.4945"] | [] | ["AMXO","ARCO","EMLD","MCRY","SPHR","XBOX","XISX","XMIO","XPHO"] | 210.0000 | 220.0000 | 10 | 24 | false | false | true | ||||||||||
| 01a08156-2878-7940-bbb3-27707d19154c | FSLR | 2026-09-08 10:05 | call_diagonal_spread | 2 | 3 | 29 | 120828.00 | long | ask | 210.0000 | 2.5000 | ["200","240"] | ["0.5591","0.5703"] | [] | ["EDGO","EMLD","SPHR"] | 200.0000 | 240.0000 | 73 | 101 | false | false | true | ||||||||||
| 01a06dec-864d-7df3-b50d-a4d0d1b7b0bf | FSLR | 2026-09-04 15:36 | call_vertical_spread | 2 | 2 | 22 | 205260.00 | long | ask | 203.9400 | 5.6818 | ["200","260"] | ["0.5361","0.5298"] | ["220"] | ["XBOX","XCBO"] | 200.0000 | 260.0000 | 504 | 504 | false | false | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:22:49Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:22:49Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:39:01Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:13:54Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:28:37Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:28:37Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:28:37Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:28:37Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:27:53Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:28:42Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:10:37Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:10:37Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:10:37Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:24:04Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:28:05Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:06:34Z"} |
| 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-11T19:53:42Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:26:01Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:44:19Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:25:01Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:25:01Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:25:01Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:23:01Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:05:21Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:37:14Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |