core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d432-ee19-7c73-a9b5-4d55ab8c127d | FSLR | 2026-09-24 12:14 | call_diagonal_spread | 2 | 1 | 1273 | 3111212.00 | short | bid | 177.5900 | 0.9000 | ["230","260"] | ["0.5455","0.5379"] | [] | ["XCBO"] | 230.0000 | 260.0000 | 176 | 266 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T16:15:03Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d432-bb4f-7ae2-bb5e-86f76857f7d8 | FSLR | 2026-09-24 12:14 | call_diagonal_spread | 2 | 11 | 56 | 137032.00 | unknown | bid | 177.5900 | 1.0000 | ["230","260"] | ["0.5453","0.5386"] | [] | ["AMXO","ARCO","EMLD","MCRY","XBOX","XISX","XMIO","XPHO"] | 230.0000 | 260.0000 | 176 | 266 | false | true | |||||||||||
| 01a0b08f-f4cb-7101-b3d3-1866672a13f4 | FSLR | 2026-09-17 14:10 | call_diagonal_spread | 2 | 1 | 1000 | 4698000.00 | short | bid | 201.0250 | 1.9500 | ["210","220"] | ["0.5445","0.5420"] | [] | ["SPHR"] | 210.0000 | 220.0000 | 120 | 183 | false | true | true | ||||||||||
| 01a0b07b-76b3-7c21-8b66-2dd737cb4370 | FSLR | 2026-09-17 13:47 | call_diagonal_spread | 2 | 2 | 1000 | 2618000.00 | short | bid | 201.7000 | 1.9500 | ["210","220"] | ["0.4872","0.5324"] | [] | ["XMIO"] | 210.0000 | 220.0000 | 29 | 120 | false | true | true | ||||||||||
| 01a0b06d-ce9b-75b2-aa97-a626ede49de0 | FSLR | 2026-09-17 13:32 | call_diagonal_spread | 2 | 1 | 1500 | 4902000.00 | short | bid | 201.8250 | 1.9500 | ["200","220"] | ["0.5308","0.5455"] | [] | ["SPHR"] | 200.0000 | 220.0000 | 8 | 183 | false | false | true | ||||||||||
| 01a0b067-5e2b-7cd3-9118-704073fe01f2 | FSLR | 2026-09-17 13:25 | call_diagonal_spread | 2 | 1 | 53 | 178981.00 | short | bid | 202.6950 | 2.0500 | ["195","220"] | ["0.7459","0.5361"] | [] | ["EDGO"] | 195.0000 | 220.0000 | 1 | 183 | false | false | true | ||||||||||
| 01a0b067-5e2b-7cd3-9118-703ebfa1b1e6 | FSLR | 2026-09-17 13:25 | call_diagonal_spread | 2 | 1 | 60 | 199620.00 | short | bid | 202.6950 | 2.0500 | ["195","220"] | ["0.6145","0.5326"] | [] | ["BATO"] | 195.0000 | 220.0000 | 1 | 183 | false | false | true | ||||||||||
| 01a0b067-5e2b-7cd3-9118-701fe5cda0e4 | FSLR | 2026-09-17 13:25 | call_diagonal_spread | 2 | 2 | 123 | 412244.00 | short | bid | 202.6950 | 1.1175 | ["195","220"] | ["0.6959","0.5365"] | [] | ["BATO","MCRY"] | 195.0000 | 220.0000 | 1 | 183 | false | false | true | ||||||||||
| 01a0b067-5e2b-7cd3-9118-700ad59587ef | FSLR | 2026-09-17 13:25 | call_diagonal_spread | 2 | 3 | 127 | 425665.00 | short | bid | 202.6950 | 1.9000 | ["195","220"] | ["0.6983","0.5364"] | [] | ["BATO","MCRY"] | 195.0000 | 220.0000 | 1 | 183 | false | false | true | ||||||||||
| 01a0b067-5e2b-7cd3-9118-6ffaca2501be | FSLR | 2026-09-17 13:25 | call_diagonal_spread | 2 | 1 | 67 | 223780.00 | short | bid | 202.6950 | 1.9500 | ["195","220"] | ["0.6752","0.5353"] | [] | ["BATO"] | 195.0000 | 220.0000 | 1 | 183 | false | false | true | ||||||||||
| 01a0b065-3b4b-76c0-9d2f-3b1cf8de2f52 | FSLR | 2026-09-17 13:23 | call_diagonal_spread | 2 | 1 | 900 | 2480420.00 | short | bid | 203.2500 | 1.7500 | ["195","220"] | ["0.5115","0.5342"] | [] | ["XCBO"] | 195.0000 | 220.0000 | 1 | 120 | false | false | true | ||||||||||
| 01a0b065-3b4b-76c0-9d2f-3b077ec3aaea | FSLR | 2026-09-17 13:23 | call_diagonal_spread | 2 | 1 | 100 | 274100.00 | short | bid | 203.0400 | 1.4500 | ["195","220"] | ["0.5878","0.5348"] | [] | ["AMXO"] | 195.0000 | 220.0000 | 1 | 120 | false | false | true | ||||||||||
| 01a0b065-3763-7352-918d-b2055e428ab2 | FSLR | 2026-09-17 13:23 | call_diagonal_spread | 2 | 2 | 500 | 1372200.00 | short | bid | 203.0400 | 1.5500 | ["195","220"] | ["0.6084","0.5347"] | [] | ["AMXO","XISX"] | 195.0000 | 220.0000 | 1 | 120 | false | false | true | ||||||||||
| 01a0b05e-8c5b-7b60-b215-600835b793ca | FSLR | 2026-09-17 13:16 | call_diagonal_spread | 2 | 1 | 1000 | 3042000.00 | short | bid | 202.4150 | 1.6500 | ["195","210"] | ["0.7168","0.5313"] | [] | ["SPHR"] | 195.0000 | 210.0000 | 1 | 120 | 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 | ||||||||||
| 01a0a557-2676-7df3-a8f7-3462a1ce0436 | FSLR | 2026-09-15 09:52 | call_diagonal_spread | 2 | 2 | 10 | 119204.00 | short | bid | 206.3075 | 7.2000 | ["150","190"] | ["0.5498","0.5581"] | [] | ["ARCO","EMLD"] | 150.0000 | 190.0000 | 122 | 493 | false | false | true | ||||||||||
| 01a0a542-c3b9-7f61-8e45-3a257655993a | FSLR | 2026-09-15 09:30 | call_diagonal_spread | 2 | 1 | 1185 | 6042445.00 | short | bid | 209.4100 | 9.2500 | ["280","460"] | ["0.5173","0.5198"] | [] | ["XCBO"] | 280.0000 | 460.0000 | 493 | 640 | false | true | true | ||||||||||
| 01a0a031-5010-7f72-aaae-394341caa4a7 | FSLR | 2026-09-14 09:52 | call_diagonal_spread | 2 | 1 | 15 | 114960.00 | short | bid | 209.1750 | 5.3000 | ["310","330"] | ["0.5223","0.5310"] | [] | ["XISX"] | 310.0000 | 330.0000 | 641 | 858 | false | true | true | ||||||||||
| 01a090d5-0031-7f51-98dc-303a3b218b74 | FSLR | 2026-09-11 10:17 | call_diagonal_spread | 2 | 4 | 114 | 186870.00 | short | bid | 211.5900 | 1.1447 | ["205","220"] | ["0.7715","0.4951"] | [] | ["C2OX","EDGO","XBOX","XPHO"] | 205.0000 | 220.0000 | 0 | 35 | false | false | true | ||||||||||
| 01a08c7e-bda1-7cc0-ba6f-b6f556e1b9f7 | FSLR | 2026-09-10 14:05 | call_diagonal_spread | 2 | 1 | 1500 | 6072000.00 | short | bid | 206.8050 | 3.8500 | ["230","240"] | ["0.5520","0.5368"] | [] | ["SPHR"] | 230.0000 | 240.0000 | 127 | 190 | false | true | true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:15:00Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:10:46Z"} |
| 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:48:18Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:33:43Z"} |
| 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:26:12Z"} |
| 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:26:12Z"} |
| 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:26:12Z"} |
| 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:26:12Z"} |
| 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:26:12Z"} |
| 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:24:06Z"} |
| 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:24:06Z"} |
| 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:24:06Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:16:54Z"} |
| 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-15T13:52:30Z"} |
| 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-15T13:30:07Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:53:01Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:17:53Z"} |
| 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:05:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |