core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 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 |
|---|
| 01a06dea-9635-7181-b848-c90b8b8c3431 | HOOD | 2026-09-04 15:34 | call_diagonal_spread_bearish | 2 | 1 | 37 | 154845.00 | short | bid | 122.9650 | 0.8000 | ["102","103"] | ["11.7856","0.5995"] | [] | ["XCBO"] | 102.0000 | 103.0000 | 0 | 21 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:34:46Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dea-8e65-7803-bb79-6b8fdf763d3a | HOOD | 2026-09-04 15:34 | other | 4 | 1 | 22 | 287210.00 | unknown | — | 122.9700 | 7.0500 | ["50","120","220","290"] | ["0.7612","0.6959","0.6848","0.7010"] | [] | ["XCBO"] | 50.0000 | 290.0000 | 504 | 833 | false | false | true | true | false | ||||||||
| 01a06de4-48ed-71d0-b350-cec034327a96 | HOOD | 2026-09-04 15:27 | call_vertical_spread | 2 | 1 | 6400 | 14067200.00 | short | bid | 122.5200 | 0.7500 | ["109","114"] | ["9.1737","5.8164"] | ["114"] | ["AMXO"] | 109.0000 | 114.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a06de3-2fad-7cf3-9c14-db2b806fb4ec | HOOD | 2026-09-04 15:26 | call_vertical_spread | 2 | 1 | 2000 | 3620000.00 | unknown | — | 122.4250 | 0.8000 | ["111","116"] | ["7.2530","4.5033"] | [] | ["AMXO"] | 111.0000 | 116.0000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a06de2-a6f5-7332-bc5a-58de8d8b6c2d | HOOD | 2026-09-04 15:26 | call_vertical_spread | 2 | 1 | 1260 | 2550240.00 | unknown | — | 122.6000 | 0.5000 | ["110","115"] | ["5.8534","3.6981"] | [] | ["AMXO"] | 110.0000 | 115.0000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a06de1-a90d-78f2-ac74-c3b847de20e9 | HOOD | 2026-09-04 15:24 | call_vertical_spread | 2 | 1 | 1070 | 1532240.00 | long | ask | 122.5800 | 0.6500 | ["113","118"] | ["5.5866","3.0305"] | ["118"] | ["AMXO"] | 113.0000 | 118.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a06dd8-ac45-70e2-9e2c-8cd80b36b6ec | HOOD | 2026-09-04 15:15 | call_vertical_spread | 2 | 1 | 733 | 1806112.00 | long | ask | 122.8744 | 0.9500 | ["108","113"] | ["8.8080","5.5116"] | ["113"] | ["EDGO"] | 108.0000 | 113.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a06dd6-5a85-7e41-82ec-cba4be1e86db | HOOD | 2026-09-04 15:12 | call_calendar | 2 | 1 | 18 | 137268.00 | long | ask | 122.9200 | 1.2500 | ["85"] | ["10.0824"] | [] | ["XMIO"] | 85.0000 | 85.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a06dc1-5f6e-7df2-9beb-2154dfcba683 | HOOD | 2026-09-04 14:49 | call_diagonal_spread_bearish | 2 | 1 | 90 | 208800.00 | short | ask | 122.7500 | 0.4000 | ["108","118"] | ["1.5868","0.6016"] | [] | ["XCBO"] | 108.0000 | 118.0000 | 0 | 14 | false | false | |||||||||||
| 01a06dbb-548d-7892-b144-7360405fb290 | HOOD | 2026-09-04 14:43 | call_diagonal_spread_bearish | 2 | 1 | 25 | 165400.00 | short | ask | 123.0330 | 0.8000 | ["80","100"] | ["17.5711","0.6699"] | [] | ["XMIO"] | 80.0000 | 100.0000 | 0 | 7 | false | false | |||||||||||
| 01a06dba-79cd-7272-afda-fd65e17f1f42 | HOOD | 2026-09-04 14:42 | call_diagonal_spread_bearish | 2 | 1 | 24 | 129192.00 | long | bid | 122.9900 | 1.7000 | ["105","120"] | ["0.6673","0.6796"] | [] | ["XCBO"] | 105.0000 | 120.0000 | 105 | 196 | false | false | |||||||||||
| 01a06db3-0f5e-7423-a52e-2683b229d4a7 | HOOD | 2026-09-04 14:34 | call_diagonal_spread_bearish | 2 | 1 | 24 | 124200.00 | short | bid | 123.1500 | 1.5500 | ["105","120"] | ["0.6704","0.6758"] | [] | ["XCBO"] | 105.0000 | 120.0000 | 77 | 196 | false | false | |||||||||||
| 01a06da4-78fd-7b00-9531-ecf84c2fdedb | HOOD | 2026-09-04 14:18 | call_diagonal_spread_bearish | 2 | 4 | 41 | 152558.00 | short | bid | 123.0200 | 1.0500 | ["105","106"] | ["6.9217","0.6073"] | [] | ["BATO","C2OX","EDGO","XCBO"] | 105.0000 | 106.0000 | 0 | 28 | false | false | |||||||||||
| 01a06da4-78fd-7b00-9531-eced09c8d6e7 | HOOD | 2026-09-04 14:18 | call_diagonal_spread_bearish | 2 | 7 | 40 | 147748.00 | short | bid | 123.0200 | 1.3450 | ["105","106"] | ["6.9217","0.5876"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 105.0000 | 106.0000 | 0 | 28 | false | false | |||||||||||
| 01a06d9e-664e-7251-9e3c-03c97486805f | HOOD | 2026-09-04 14:11 | call_vertical_spread | 2 | 1 | 60 | 102559.00 | short | bid | 122.7050 | 0.6500 | ["114","123"] | ["0.6191","0.6194"] | ["119.33"] | ["XCBO"] | 114.0000 | 123.0000 | 14 | 14 | false | false | false | ||||||||||
| 01a06d8c-f575-7b40-a411-ee5eb4b63c13 | HOOD | 2026-09-04 13:52 | call_calendar | 2 | 1 | 29 | 134676.00 | short | bid | 123.0850 | 0.8000 | ["100"] | ["3.6411"] | [] | ["XCBO"] | 100.0000 | 100.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a06d89-3486-72e1-98a5-1f56f58d9dce | HOOD | 2026-09-04 13:48 | other | 2 | 1 | 917 | 3139550.00 | unknown | — | 123.0100 | 2.3000 | ["94","125"] | ["9.4018","0.6314"] | [] | ["XCBO"] | 94.0000 | 125.0000 | 0 | 28 | false | false | true | true | false | ||||||||
| 01a06d88-afb5-78f0-81da-101ccfe14c06 | HOOD | 2026-09-04 13:47 | call_vertical_spread | 2 | 1 | 1530 | 761940.00 | short | bid | 122.9900 | 0.1400 | ["125","130"] | ["0.6031","0.6232"] | ["126.50"] | ["XPHO"] | 125.0000 | 130.0000 | 7 | 7 | false | true | false | ||||||||||
| 01a06d85-dd0d-77f3-bdad-e7dcd0b885fc | HOOD | 2026-09-04 13:44 | call_diagonal_spread_bearish | 2 | 1 | 30 | 112260.00 | long | bid | 123.1600 | 0.9000 | ["95","115"] | ["9.7414","0.5931"] | [] | ["C2OX"] | 95.0000 | 115.0000 | 0 | 7 | false | false | |||||||||||
| 01a06d7d-900d-7250-9f36-805e427ef325 | HOOD | 2026-09-04 13:35 | call_vertical_spread | 2 | 1 | 34 | 201450.00 | unknown | — | 123.3000 | 1.2000 | ["90","110"] | ["0.6914","0.6774"] | [] | ["BATO"] | 90.0000 | 110.0000 | 77 | 77 | false | false | false | true | false | ||||||||
| 01a06d6e-edf6-76d1-95f5-689509275531 | HOOD | 2026-09-04 13:19 | call_calendar | 2 | 1 | 100 | 179400.00 | short | bid | 123.3600 | 0.7500 | ["115"] | ["1.3916"] | [] | ["XPHO"] | 115.0000 | 115.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a06d67-f8b5-7631-ab80-90dba32d2c29 | HOOD | 2026-09-04 13:12 | call_vertical_spread | 2 | 1 | 479 | 135557.00 | long | ask | 123.5700 | 0.1300 | ["128","141"] | ["0.6091","0.6645"] | ["129.99"] | ["XPHO"] | 128.0000 | 141.0000 | 7 | 7 | false | true | false | ||||||||||
| 01a06d50-bf65-7300-9b39-20de303cce9a | HOOD | 2026-09-04 12:46 | other | 2 | 4 | 63 | 305675.00 | unknown | — | 124.1264 | 1.0563 | ["100"] | ["3.2154"] | [] | ["ARCO","XBOX","XCBO","XISX"] | 100.0000 | 100.0000 | 0 | 14 | false | false | true | false | false | ||||||||
| 01a06d3b-7dfe-7583-9781-d49a6b783859 | HOOD | 2026-09-04 12:23 | other | 4 | 1 | 50 | 103900.00 | unknown | — | 123.5900 | 1.3000 | ["119","120"] | ["1.0025","0.8256"] | [] | ["XISX"] | 119.0000 | 120.0000 | 0 | 7 | false | false | true | true | false | ||||||||
| 01a06d38-baf5-7c13-a1f4-2de538de62ad | HOOD | 2026-09-04 12:20 | other | 2 | 1 | 90 | 160560.00 | unknown | — | 123.4400 | 0.5000 | ["108","128"] | ["3.3643","0.6022"] | [] | ["BATO"] | 108.0000 | 128.0000 | 0 | 7 | false | false | true | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:34:46Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:28:02Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:27:06Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:26:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:25:21Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:15:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:12:56Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:49:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:43:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:42:17Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:34:19Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:18:28Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:18:28Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:12:04Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:53:05Z"} |
| 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-04T17:48:28Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:47:51Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:45:08Z"} |
| 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-04T17:36:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:20:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:12:36Z"} |
| 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-04T16:47:14Z"} |
| 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-04T16:23:43Z"} |
| 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-04T16:20:53Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |