core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg677,480 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 |
|---|
| 01a0fe28-5ac6-7540-87b6-080e3377a1df | SOXL | 2026-10-02 15:47 | call_calendar | 2 | 2 | 100 | 410000.00 | unknown | ask | 164.8150 | 1.7500 | ["145"] | ["8.3023"] | [] | ["AMXO"] | 145.0000 | 145.0000 | 0 | 7 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-02T19:47:47Z"} | 2026-10-02 | 2026-10-02 17:15 | 2026-10-02 17:15 |
| 01a0fd02-16bf-7dc3-a0df-2bf77581feb8 | SOXL | 2026-10-02 10:26 | call_diagonal_spread | 2 | 2 | 53 | 451878.00 | long | bid | 169.3100 | 3.5000 | ["135","145"] | ["1.1947","1.1920"] | [] | ["AMXO"] | 135.0000 | 145.0000 | 35 | 49 | false | false | true | ||||||||||
| 01a0da23-1e0f-7d20-a82d-94da12211a43 | SOXL | 2026-09-25 15:55 | call_diagonal_spread | 2 | 1 | 75 | 216750.00 | unknown | ask | 151.9700 | 0.3500 | ["145","150"] | ["1.0369","1.0571"] | [] | ["XBOX"] | 145.0000 | 150.0000 | 7 | 21 | false | false | true | ||||||||||
| 01a0da0c-5dd7-7ff1-a004-c0094ffa63c9 | SOXL | 2026-09-25 15:30 | call_calendar | 2 | 1 | 62 | 395436.00 | short | bid | 151.6100 | 5.0500 | ["120"] | ["9.5819"] | [] | ["SPHR"] | 120.0000 | 120.0000 | 0 | 3 | false | false | true | false | |||||||||
| 01a0d9c1-04c7-7572-9a12-9db1a3cac4a7 | SOXL | 2026-09-25 14:08 | call_calendar | 2 | 1 | 80 | 566480.00 | unknown | ask | 152.1420 | 5.1000 | ["120"] | ["5.3553"] | [] | ["SPHR"] | 120.0000 | 120.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0d96b-d047-7e20-8e5c-8486d934eccf | SOXL | 2026-09-25 12:35 | call_diagonal_spread | 2 | 1 | 107 | 377282.00 | unknown | ask | 152.7471 | 3.3500 | ["150","185"] | ["1.0956","1.1909"] | [] | ["XBOX"] | 150.0000 | 185.0000 | 21 | 56 | false | false | true | ||||||||||
| 01a0d8fc-64d7-77f0-8a6a-f97fa2d1e2b6 | SOXL | 2026-09-25 10:33 | call_vertical_spread | 2 | 1 | 200 | 146400.00 | long | ask | 149.3301 | 0.2500 | ["150","152"] | ["0.8156","0.8071"] | ["150.90"] | ["SPHR"] | 150.0000 | 152.0000 | 3 | 3 | false | true | false | ||||||||||
| 01a0d8db-1197-7072-a5b3-8ba20998038e | SOXL | 2026-09-25 09:57 | call_diagonal_spread | 2 | 1 | 48 | 158160.00 | unknown | ask | 152.3400 | 3.4500 | ["145","156"] | ["1.0583","1.0673"] | [] | ["AMXO"] | 145.0000 | 156.0000 | 14 | 28 | false | false | true | ||||||||||
| 01a0d8cf-da7f-7bf2-8aa8-691a1e2c26b0 | SOXL | 2026-09-25 09:44 | call_diagonal_spread | 2 | 1 | 130 | 348400.00 | unknown | ask | 151.8300 | 1.4500 | ["150","156"] | ["1.0408","1.0448"] | [] | ["XBOX"] | 150.0000 | 156.0000 | 14 | 21 | false | false | true | ||||||||||
| 01a0d4d7-6b76-7703-8c37-fce7a21d590b | SOXL | 2026-09-24 15:14 | other | 4 | 1 | 84 | 827080.00 | unknown | bid | 144.8200 | 14.2000 | ["190","195","200","205"] | ["3.6375","4.3023","4.5218","4.8022"] | ["146.90"] | ["XBOX"] | 190.0000 | 205.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0d4bb-2917-7670-bb9b-462d40e1879d | SOXL | 2026-09-24 14:43 | other | 4 | 1 | 76 | 717720.00 | unknown | bid | 144.2821 | 13.2000 | ["185","190","200","205"] | ["3.4235","3.6868","4.3451","4.5820"] | ["146.40"] | ["XBOX"] | 185.0000 | 205.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0d42d-4caf-7913-b9f4-9a3adf7d5e64 | SOXL | 2026-09-24 12:08 | call_diagonal_spread | 2 | 1 | 164 | 689784.00 | short | bid | 138.7150 | 3.2000 | ["119","126"] | ["2.1096","1.1135"] | [] | ["SPHR"] | 119.0000 | 126.0000 | 1 | 22 | false | false | true | ||||||||||
| 01a0d3f6-e2ff-7c43-bc2a-647c6911b6f6 | SOXL | 2026-09-24 11:09 | put_diagonal_spread | 2 | 1 | 40 | 526600.00 | long | ask | 138.3100 | 1.9500 | ["140","220"] | ["1.0639","1.2457"] | [] | ["AMXO"] | 140.0000 | 220.0000 | 1 | 484 | false | false | true | ||||||||||
| 01a0d3b2-0617-7610-a1bd-22012e42683b | SOXL | 2026-09-24 09:54 | call_calendar | 2 | 1 | 100 | 1436000.00 | short | ask | 140.3300 | 5.7000 | ["70"] | ["1.5366"] | [] | ["SPHR"] | 70.0000 | 70.0000 | 29 | 36 | false | false | true | false | |||||||||
| 01a0cebd-6877-7b43-b073-785752076933 | SOXL | 2026-09-23 10:48 | call_diagonal_spread | 2 | 1 | 66 | 701646.00 | unknown | bid | 141.9249 | 5.8500 | ["105","148"] | ["1.1344","1.1205"] | [] | ["AMXO"] | 105.0000 | 148.0000 | 149 | 240 | false | false | true | ||||||||||
| 01a0ce88-3746-74a2-bb63-3a694d4fd736 | SOXL | 2026-09-23 09:50 | call_diagonal_spread | 2 | 1 | 134 | 1341614.00 | short | bid | 144.2716 | 7.2500 | ["160","215"] | ["1.2205","1.0132"] | [] | ["XBOX"] | 160.0000 | 215.0000 | 86 | 849 | false | true | true | ||||||||||
| 01a0ca80-0ce7-7001-90fd-e4fb1bf1295d | SOXL | 2026-09-22 15:03 | other | 4 | 2 | 100 | 501600.00 | unknown | bid | 149.7400 | 1.6600 | ["115","125"] | ["1.7923","1.4973"] | [] | ["AMXO"] | 115.0000 | 125.0000 | 1 | 3 | false | false | true | true | |||||||||
| 01a0c447-8d37-7ee3-9197-255f4a863314 | SOXL | 2026-09-21 10:03 | put_diagonal_spread | 2 | 1 | 20 | 115600.00 | long | ask | 134.5950 | 4.3000 | ["120","125"] | ["1.1737","1.1878"] | [] | ["AMXO"] | 120.0000 | 125.0000 | 116 | 151 | false | true | true | ||||||||||
| 01a0b4ba-9ef0-7a22-ab06-98d26ced4c87 | SOXL | 2026-09-18 09:35 | call_vertical_spread | 2 | 1 | 50 | 267500.00 | unknown | bid | 117.7900 | 3.3500 | ["100","110"] | ["1.0418","1.0544"] | ["131.75"] | ["XBOX"] | 100.0000 | 110.0000 | 63 | 63 | false | false | false | ||||||||||
| 01a0a0fe-f0b0-70f2-ae75-67bd5d514ddc | SOXL | 2026-09-14 13:37 | other | 2 | 1 | 1000 | 900000.00 | unknown | — | 103.4600 | 1.0500 | ["105","108"] | ["1.0395","1.0408"] | [] | ["XBOX"] | 105.0000 | 108.0000 | 11 | 11 | false | true | false | true | false | mlft | |||||||
| 01a0a069-2cd8-7fb0-8f00-305084b79805 | SOXL | 2026-09-14 10:53 | risk_reversal | 3 | 1 | 300 | 174000.00 | unknown | — | 100.7950 | 0.3100 | ["100","125","130"] | ["1.3152","1.3545","1.3686"] | [] | ["XBOX"] | 100.0000 | 130.0000 | 4 | 4 | false | true | false | true | true | ||||||||
| 01a08248-cda8-76b0-ad29-5e24cd2932bf | SOXL | 2026-09-08 14:30 | call_vertical_spread | 2 | 1 | 200 | 250000.00 | long | ask | 125.3000 | 0.2000 | ["124","126"] | ["1.3491","1.3333"] | ["125.04"] | ["SPHR"] | 124.0000 | 126.0000 | 3 | 3 | false | false | false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-02T14:26:22Z"} |
| 2026-10-02 |
| 2026-10-02 17:15 |
| 2026-10-02 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:55:45Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:30:54Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:08:28Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:35:40Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:33:47Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:57:15Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:45:03Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:15:11Z"} |
| 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-24T18:44:21Z"} |
| 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-24T16:09:28Z"} |
| 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-24T15:09:54Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:54:29Z"} |
| 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-23T14:48:59Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:50:38Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:03:11Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:03:49Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:35:24Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:38:10Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:54:18Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:30:36Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |