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 | directiontext |
|---|
| 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 |
|---|
| 01a0ca23-0c4f-7d63-9bba-94b498d6e508 | GDX | 2026-09-22 13:21 | call_vertical_spread | 2 | 1 | 154 | 112266.00 | short | bid | 96.2500 | 1.5800 | ["180","220"] | ["0.4525","0.4671"] | ["182.05"] | ["XCBO"] | 180.0000 | 220.0000 | 486 | 486 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T17:22:00Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9e3-1167-7092-b990-74d11b469bca | GDX | 2026-09-22 12:11 | call_vertical_spread | 2 | 1 | 56 | 595448.00 | short | bid | 95.5500 | 5.1000 | ["40","45"] | ["1.5334","1.4289"] | ["44.97"] | ["BATO"] | 40.0000 | 45.0000 | 17 | 17 | false | false | false | true | |||||||||
| 01a0c957-500f-7942-ac74-1d7bc53f63a0 | GDX | 2026-09-22 09:38 | call_vertical_spread | 2 | 1 | 144 | 487584.00 | short | bid | 95.3900 | 2.0000 | ["95","120"] | ["0.4196","0.4315"] | ["103"] | ["XPHO"] | 95.0000 | 120.0000 | 486 | 486 | false | false | false | true | |||||||||
| 01a0c957-212f-7f02-a7cc-1cabd8182706 | GDX | 2026-09-22 09:38 | call_vertical_spread | 2 | 1 | 56 | 189168.00 | short | bid | 95.2450 | 2.3000 | ["95","120"] | ["0.4206","0.4324"] | ["102.98"] | ["XPHO"] | 95.0000 | 120.0000 | 486 | 486 | false | false | false | true | |||||||||
| 01a0b61a-7157-7bb0-adf8-e7ab0fe7f3e6 | GDX | 2026-09-18 15:59 | put_vertical_spread | 2 | 3 | 60 | 348880.00 | short | bid | 95.5000 | 1.1500 | ["115","130"] | ["0.4838","0.5262"] | ["117"] | ["C2OX","XPHO"] | 115.0000 | 130.0000 | 119 | 119 | false | false | false | true | |||||||||
| 01a0b615-b280-7d10-b837-ffa0fe508744 | GDX | 2026-09-18 15:54 | put_vertical_spread | 2 | 1 | 20 | 116200.00 | short | bid | 95.3650 | 0.7000 | ["115","130"] | ["0.4777","0.5176"] | ["117"] | ["C2OX"] | 115.0000 | 130.0000 | 119 | 119 | false | false | false | true | |||||||||
| 01a0a61e-f6ce-7600-bd41-04f6d286f052 | GDX | 2026-09-15 13:30 | call_vertical_spread | 2 | 7 | 211 | 536392.00 | short | bid | 93.4800 | 0.6500 | ["82","87"] | ["0.4543","0.4505"] | ["85.42"] | ["AMXO","ARCO","XBOX","XISX","XPHO"] | 82.0000 | 87.0000 | 66 | 66 | false | false | false | ||||||||||
| 01a0a13e-2460-7132-94eb-3c3c68e8151b | GDX | 2026-09-14 14:46 | call_vertical_spread | 2 | 1 | 300 | 519600.00 | short | bid | 94.6250 | 0.4500 | ["92","100"] | ["0.4500","0.4527"] | ["95.50"] | ["AMXO"] | 92.0000 | 100.0000 | 95 | 95 | false | false | false | true | |||||||||
| 01a0a13d-a378-7701-bb7a-b38a7de13e14 | GDX | 2026-09-14 14:46 | call_vertical_spread | 2 | 1 | 300 | 519600.00 | short | bid | 94.6363 | 0.4500 | ["92","100"] | ["0.4496","0.4524"] | ["95.50"] | ["XMIO"] | 92.0000 | 100.0000 | 95 | 95 | false | false | false | true | |||||||||
| 01a0a067-bda8-76e2-aafe-61a7687a449d | GDX | 2026-09-14 10:52 | put_calendar | 2 | 1 | 24 | 157656.00 | short | ask | 93.5654 | 2.3500 | ["120"] | ["0.4764"] | [] | ["EDGO"] | 120.0000 | 120.0000 | 276 | 494 | false | false | true | false | |||||||||
| 01a0910c-8321-7ef3-98c0-8a828e5be4e9 | GDX | 2026-09-11 11:18 | call_calendar | 2 | 4 | 11 | 104951.00 | short | ask | 97.1900 | 2.1000 | ["50"] | ["9.3682"] | [] | ["BATO","C2OX","EDGO","XCBO"] | 50.0000 | 50.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0910c-8321-7ef3-98c0-8a7001e4d781 | GDX | 2026-09-11 11:18 | call_calendar | 2 | 7 | 12 | 114388.00 | short | ask | 97.1900 | 2.3250 | ["50"] | ["9.5873"] | [] | ["AMXO","ARCO","EMLD","MCRY","XBOX","XISX","XPHO"] | 50.0000 | 50.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0910c-7f38-73d2-b121-83ddcdc61aee | GDX | 2026-09-11 11:18 | call_calendar | 2 | 5 | 35 | 333889.00 | short | ask | 97.1900 | 2.7500 | ["50"] | ["9.6060"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 50.0000 | 50.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a090ed-b468-7963-9bcf-4db41320e8e5 | GDX | 2026-09-11 10:44 | call_calendar | 2 | 3 | 25 | 139725.00 | short | ask | 97.3200 | 2.9500 | ["70"] | ["5.1008"] | [] | ["BATO","C2OX","EDGO"] | 70.0000 | 70.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0825c-f5d0-75f1-a61b-cb17e3d79a11 | GDX | 2026-09-08 14:52 | synthetic | 2 | 1 | 25 | 102900.00 | short | bid | 98.4950 | 2.9500 | ["100"] | ["0.4615"] | ["103.50"] | ["XISX"] | 100.0000 | 100.0000 | 500 | 500 | false | false | false | false | |||||||||
| 01a08198-7521-7c73-98ed-e3c518079c0d | GDX | 2026-09-08 11:17 | call_diagonal_spread | 2 | 1 | 76 | 151531.00 | short | ask | 99.8700 | 0.7500 | ["100","110"] | ["0.4625","0.4482"] | [] | ["XCBO"] | 100.0000 | 110.0000 | 101 | 192 | false | true | true | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:11:44Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:39:09Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:38:52Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:59:44Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:54:41Z"} |
| 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-15T17:31:24Z"} |
| 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-14T18:46:47Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:46:04Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:52:50Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:18:47Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:18:47Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:18:47Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:45:02Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:52:27Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:17:29Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |