core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a0c9b3-913e-74c3-9a57-ac646263f613 | SOXL | 2026-09-22 11:19 | put_vertical_spread | 2 | 1 | 10 | 153100.00 | short | bid | 146.6500 | 6.3500 | ["190","200"] | ["1.2135","1.2149"] | ["192.40"] | ["XISX"] | 190.0000 | 200.0000 | 150 | 150 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:20:13Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c989-4907-72e0-85b2-6b27bc52d212 | SOXL | 2026-09-22 10:33 | put_vertical_spread | 2 | 1 | 100 | 118700.00 | short | bid | 148.6899 | 1.0500 | ["95","115"] | ["1.3175","1.2569"] | ["110.45"] | ["XCBO"] | 95.0000 | 115.0000 | 38 | 38 | false | true | false | ||||||||||
| 01a0c958-c327-7a40-a95f-968a957ed11c | SOXL | 2026-09-22 09:40 | put_vertical_spread | 2 | 1 | 20 | 216620.00 | short | bid | 142.4500 | 7.4500 | ["120","125"] | ["1.2305","1.2315"] | ["121.61"] | ["XPHO"] | 120.0000 | 125.0000 | 486 | 486 | false | true | false | ||||||||||
| 01a0c551-3cd7-7030-8f70-a4f34afc96de | SOXL | 2026-09-21 14:53 | put_vertical_spread | 2 | 1 | 100 | 226700.00 | short | bid | 141.3099 | 1.0500 | ["40","50"] | ["1.2861","1.2669"] | ["45.99"] | ["XPHO"] | 40.0000 | 50.0000 | 487 | 487 | false | true | false | ||||||||||
| 01a0c4da-3fe7-7273-917c-13cf97dccabd | SOXL | 2026-09-21 12:43 | put_vertical_spread | 2 | 1 | 50 | 107200.00 | short | bid | 139.8580 | 0.7000 | ["90","100"] | ["1.2553","1.2367"] | ["96.70"] | ["BATO"] | 90.0000 | 100.0000 | 88 | 88 | false | true | false | ||||||||||
| 01a0c4c4-3b2f-7653-961d-11ba67ce342c | SOXL | 2026-09-21 12:19 | put_vertical_spread | 2 | 1 | 49 | 117208.00 | short | bid | 139.2800 | 0.1500 | ["120","140"] | ["1.1523","1.1117"] | ["131.32"] | ["BATO"] | 120.0000 | 140.0000 | 25 | 25 | false | false | false | ||||||||||
| 01a0c4c4-3b2f-7653-961d-11aa2cdfd2dd | SOXL | 2026-09-21 12:19 | put_vertical_spread | 2 | 1 | 67 | 160063.00 | short | bid | 139.2800 | 0.2000 | ["120","140"] | ["1.1532","1.1090"] | ["131.37"] | ["BATO"] | 120.0000 | 140.0000 | 25 | 25 | false | false | false | ||||||||||
| 01a0c46f-e16f-7450-9e40-6eb6c538caa5 | SOXL | 2026-09-21 10:47 | put_vertical_spread | 2 | 1 | 10 | 161820.00 | short | bid | 136.6000 | 7.1000 | ["190","200"] | ["1.1926","1.1899"] | ["192.28"] | ["XPHO"] | 190.0000 | 200.0000 | 151 | 151 | false | false | false | ||||||||||
| 01a0c45d-5f27-7d52-99fd-dc812b47fe0a | SOXL | 2026-09-21 10:27 | put_vertical_spread | 2 | 1 | 62 | 257920.00 | short | bid | 136.2999 | 1.4500 | ["125","130"] | ["1.2045","1.2012"] | ["127.40"] | ["XISX"] | 125.0000 | 130.0000 | 60 | 60 | false | true | false | ||||||||||
| 01a0c43a-75a7-7550-a054-b507c9ecd9be | SOXL | 2026-09-21 09:49 | put_vertical_spread | 2 | 1 | 50 | 113450.00 | short | bid | 134.4000 | 0.8000 | ["90","100"] | ["1.2335","1.2186"] | ["96.45"] | ["BATO"] | 90.0000 | 100.0000 | 88 | 88 | false | true | false | ||||||||||
| 01a0c434-37ff-7660-8820-368cca5e5334 | SOXL | 2026-09-21 09:42 | put_vertical_spread | 2 | 1 | 100 | 104600.00 | unknown | bid | 133.5200 | 1.6500 | ["100","105"] | ["1.1895","1.1810"] | ["97.27"] | ["XPHO"] | 100.0000 | 105.0000 | 32 | 32 | false | true | false | ||||||||||
| 01a0b5b1-6e87-7cf0-91c8-2850fa776a47 | SOXL | 2026-09-18 14:04 | put_vertical_spread | 2 | 2 | 125 | 169750.00 | short | bid | 118.0500 | 1.3500 | ["106","118"] | ["1.0726","1.0005"] | ["113.40"] | ["ARCO"] | 106.0000 | 118.0000 | 14 | 14 | false | true | false | ||||||||||
| 01a0b54f-39e7-71b0-b40f-990c01a99ef5 | SOXL | 2026-09-18 12:17 | put_vertical_spread | 2 | 1 | 60 | 317400.00 | short | bid | 117.5700 | 3.4000 | ["55","60"] | ["1.2572","1.2483"] | ["57.10"] | ["XMIO"] | 55.0000 | 60.0000 | 854 | 854 | false | true | false | ||||||||||
| 01a0b538-df40-7ea3-985b-c1846a34476e | SOXL | 2026-09-18 11:53 | put_vertical_spread | 2 | 1 | 30 | 156600.00 | short | bid | 118.2000 | 2.4000 | ["55","60"] | ["1.2459","1.2379"] | ["57.10"] | ["XISX"] | 55.0000 | 60.0000 | 854 | 854 | false | true | false | ||||||||||
| 01a0abcc-2b2b-7dd3-bf96-d6b39eeae764 | SOXL | 2026-09-16 15:57 | put_vertical_spread | 2 | 2 | 247 | 388477.00 | short | bid | 103.5900 | 2.7034 | ["101","102"] | ["1.1165","1.1210"] | ["101.46"] | ["ARCO","XCBO"] | 101.0000 | 102.0000 | 14 | 14 | true | true | false | ||||||||||
| 01a0abcc-2b2b-7dd3-bf96-d6a550552849 | SOXL | 2026-09-16 15:57 | put_vertical_spread | 2 | 1 | 83 | 132053.00 | short | bid | 103.5900 | 5.1500 | ["101","102"] | ["1.1337","1.1268"] | ["101.55"] | ["XCBO"] | 101.0000 | 102.0000 | 14 | 14 | true | true | false | ||||||||||
| 01a0aa74-2cab-7331-8fe4-275fd88be4ef | SOXL | 2026-09-16 09:42 | put_vertical_spread | 2 | 1 | 38 | 219336.00 | short | bid | 107.3194 | 4.6500 | ["50","95"] | ["1.2305","1.2117"] | ["68.26"] | ["ARCO"] | 50.0000 | 95.0000 | 492 | 492 | false | true | false | ||||||||||
| 01a0a5ff-4586-77a0-910d-b68c9bebafe4 | SOXL | 2026-09-15 12:56 | put_vertical_spread | 2 | 2 | 11 | 347457.00 | short | bid | 101.8800 | 7.4500 | ["200","275"] | ["1.2431","1.2933"] | ["209.53"] | ["AMXO","ARCO"] | 200.0000 | 275.0000 | 493 | 493 | false | false | false | ||||||||||
| 01a0a07d-4178-7781-8465-771ed4bdf901 | SOXL | 2026-09-14 11:15 | put_vertical_spread | 2 | 2 | 100 | 160800.00 | short | bid | 100.9903 | 0.9500 | ["85","110"] | ["1.2739","1.1501"] | ["98.96"] | ["XMIO"] | 85.0000 | 110.0000 | 11 | 11 | false | false | false | ||||||||||
| 01a0a025-cec1-7020-9d23-27a6673fde96 | SOXL | 2026-09-14 09:40 | put_vertical_spread | 2 | 5 | 142 | 226908.00 | short | bid | 100.4100 | 0.7000 | ["85","90"] | ["1.2490","1.2155"] | ["88.25"] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 85.0000 | 90.0000 | 32 | 32 | false | true | false | ||||||||||
| 01a0a025-9810-7302-bf19-24cbd229f011 | SOXL | 2026-09-14 09:40 | put_vertical_spread | 2 | 1 | 56 | 232400.00 | short | bid | 100.0050 | 1.0500 | ["90","100"] | ["1.2201","1.2061"] | ["94.50"] | ["XISX"] | 90.0000 | 100.0000 | 95 | 95 | false | true | false | ||||||||||
| 01a0829a-7018-7bc0-a431-4a6774d928ef | SOXL | 2026-09-08 15:59 | put_vertical_spread | 2 | 1 | 5 | 103375.00 | short | bid | 122.9751 | 6.4000 | ["135","220"] | ["1.2740","1.2242"] | ["155.65"] | ["C2OX"] | 135.0000 | 220.0000 | 500 | 500 | false | false | false | ||||||||||
| 01a0826d-5538-77c0-a062-1a1619c443d6 | SOXL | 2026-09-08 15:09 | put_vertical_spread | 2 | 1 | 20 | 270000.00 | short | bid | 123.9000 | 5.2000 | ["135","220"] | ["1.2320","1.2528"] | ["151.56"] | ["XPHO"] | 135.0000 | 220.0000 | 73 | 73 | false | false | false | ||||||||||
| 01a0817a-4a78-74c3-9dba-73c8a98ade9c | SOXL | 2026-09-08 10:44 | put_vertical_spread | 2 | 1 | 5 | 105460.00 | short | bid | 124.3700 | 7.3500 | ["75","275"] | ["1.2583","1.2377"] | ["122.48"] | ["ARCO"] | 75.0000 | 275.0000 | 500 | 500 | false | false | false | ||||||||||
| 01a08141-3530-7522-beec-c72e8a800498 | SOXL | 2026-09-08 09:42 | put_vertical_spread | 2 | 1 | 98 | 196000.00 | short | bid | 123.2100 | 2.6500 | ["100","105"] | ["1.2010","1.1924"] | ["103.10"] | ["XISX"] | 100.0000 | 105.0000 | 45 | 45 | false | true | false | ||||||||||
| 01a06d46-4f85-7573-9460-6b4d668f0a9c | SOXL | 2026-09-04 12:35 | put_vertical_spread | 2 | 1 | 32 | 129184.00 | short | bid | 117.0750 | 4.0000 | ["57","58"] | ["1.2860","1.2774"] | ["57.65"] | ["BATO"] | 57.0000 | 58.0000 | 504 | 504 | false | true | false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:33:54Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:40:41Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:54: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-21T16:44:23Z"} |
| 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-21T16:19:50Z"} |
| 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-21T16:19:50Z"} |
| 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-21T14:47:53Z"} |
| 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-21T14:27:40Z"} |
| 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:49:31Z"} |
| 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:42:38Z"} |
| 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-18T18:05:06Z"} |
| 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-18T16:17:49Z"} |
| 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-18T15:53:44Z"} |
| 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-16T19:58:14Z"} |
| 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-16T19:58:14Z"} |
| 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-16T13:42:24Z"} |
| 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-15T16:56:14Z"} |
| 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-14T15:16:20Z"} |
| 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-14T13:40:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:40:14Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:59:19Z"} |
| 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:10:18Z"} |
| 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:44:29Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:42:07Z"} |
| 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-04T16:35:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |