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 |
|---|
| 01a0d426-b917-7583-9ac3-9089dd795c30 | GLD | 2026-09-24 12:01 | put_calendar | 2 | 2 | 440 | 494040.00 | long | ask | 390.1000 | 0.4000 | ["390"] | ["0.1925"] | [] | ["ARCO","XISX"] | 390.0000 | 390.0000 | 14 | 15 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T16:02:03Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d426-b917-7583-9ac3-906e7013cee8 | GLD | 2026-09-24 12:01 | put_calendar | 2 | 2 | 440 | 494040.00 | long | ask | 390.1000 | 0.4000 | ["390"] | ["0.1925"] | [] | ["AMXO","XISX"] | 390.0000 | 390.0000 | 14 | 15 | false | true | true | false | |||||||||
| 01a0cfd0-b507-7ec1-a4f9-0f8119db42e8 | GLD | 2026-09-23 15:49 | put_calendar | 2 | 1 | 60 | 351840.00 | long | ask | 392.9810 | 2.1500 | ["410"] | ["0.3114"] | [] | ["XISX"] | 410.0000 | 410.0000 | 2 | 485 | false | false | true | false | |||||||||
| 01a0afc8-ef93-71f3-87fa-43e7aa650a38 | GLD | 2026-09-17 10:32 | put_calendar | 2 | 1 | 17 | 103020.00 | long | bid | 399.9400 | 6.8000 | ["395"] | ["0.2527"] | [] | ["SPHR"] | 395.0000 | 395.0000 | 365 | 491 | false | true | true | false | |||||||||
| 01a0aaaa-0da3-7a93-bc92-2f52fbb536f8 | GLD | 2026-09-16 10:41 | put_calendar | 2 | 1 | 288 | 482688.00 | long | bid | 398.1800 | 0.6000 | ["405"] | ["0.4183"] | [] | ["XISX"] | 405.0000 | 405.0000 | 1 | 2 | false | false | true | false | |||||||||
| 01a0aaa8-fc33-7ad0-b587-54047ef32c3c | GLD | 2026-09-16 10:39 | put_calendar | 2 | 1 | 217 | 365862.00 | long | bid | 398.0400 | 0.6000 | ["405"] | ["0.4114"] | [] | ["XISX"] | 405.0000 | 405.0000 | 1 | 2 | false | false | true | false | |||||||||
| 01a0aaa8-fc33-7ad0-b587-53fb2ed3d68f | GLD | 2026-09-16 10:39 | put_calendar | 2 | 1 | 403 | 678652.00 | long | bid | 398.0400 | 0.6000 | ["405"] | ["0.4101"] | [] | ["BATO"] | 405.0000 | 405.0000 | 1 | 2 | false | false | true | false | |||||||||
| 01a0aaa8-2d2b-7282-a3bf-d3c1b9a872be | GLD | 2026-09-16 10:39 | put_calendar | 2 | 1 | 181 | 306614.00 | long | bid | 398.0499 | 0.5428 | ["405"] | ["0.4175"] | [] | ["XPHO"] | 405.0000 | 405.0000 | 1 | 2 | false | false | true | false | |||||||||
| 01a0aaa8-2d2b-7282-a3bf-d3be76cd8aa4 | GLD | 2026-09-16 10:39 | put_calendar | 2 | 1 | 181 | 306614.00 | long | bid | 398.0499 | 0.5376 | ["405"] | ["0.4175"] | [] | ["XPHO"] | 405.0000 | 405.0000 | 1 | 2 | false | false | true | false | |||||||||
| 01a0aa9f-7e83-7252-a454-a1f2c9d96eb6 | GLD | 2026-09-16 10:29 | put_calendar | 2 | 1 | 289 | 505750.00 | long | bid | 397.6200 | 0.2500 | ["405"] | ["0.4117"] | [] | ["XISX"] | 405.0000 | 405.0000 | 1 | 2 | false | false | true | false | |||||||||
| 01a0aa9d-5ba3-7193-9a5b-f042ee498923 | GLD | 2026-09-16 10:27 | put_calendar | 2 | 1 | 200 | 360000.00 | long | bid | 397.3200 | 0.2000 | ["405"] | ["0.4144"] | [] | ["XISX"] | 405.0000 | 405.0000 | 1 | 2 | false | false | true | false | |||||||||
| 01a0aa9d-5ba3-7193-9a5b-f03c647a4565 | GLD | 2026-09-16 10:27 | put_calendar | 2 | 1 | 200 | 360000.00 | long | bid | 397.3200 | 0.3000 | ["405"] | ["0.4144"] | [] | ["XISX"] | 405.0000 | 405.0000 | 1 | 2 | false | false | true | false | |||||||||
| 01a090d7-1f28-7da0-9a9a-89e797723f08 | GLD | 2026-09-11 10:20 | put_calendar | 2 | 4 | 504 | 241492.00 | long | ask | 401.9299 | 0.1600 | ["395"] | ["0.2560"] | [] | ["ARCO","EMLD","SPHR","XPHO"] | 395.0000 | 395.0000 | 5 | 7 | false | true | true | false | |||||||||
| 01a08141-6fc8-7473-ad59-5af7d33e3b2f | GLD | 2026-09-08 09:42 | put_calendar | 2 | 9 | 289 | 130645.00 | long | bid | 402.6981 | 0.3700 | ["400"] | ["0.3007"] | [] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XBOX","XISX","XPHO"] | 400.0000 | 400.0000 | 1 | 3 | false | true | true | ||||||||||
| 01a06dff-4ee5-79d0-b6b1-36e87034a454 | GLD | 2026-09-04 15:57 | put_calendar | 2 | 1 | 312 | 693888.00 | long | bid | 406.5500 | 0.8500 | ["417"] | ["3.3683"] | [] | ["XISX"] | 417.0000 | 417.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a06dff-4ee5-79d0-b6b1-36de2bf02ca2 | GLD | 2026-09-04 15:57 | put_calendar | 2 | 1 | 88 | 195360.00 | long | bid | 406.5500 | 0.9000 | ["417"] | ["3.3576"] | [] | ["BATO"] | 417.0000 | 417.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a06d79-1785-7422-a333-77c31c146f4d | GLD | 2026-09-04 13:30 | put_calendar | 2 | 1 | 100 | 133200.00 | long | ask | 406.0832 | 0.4500 | ["405"] | ["0.2400"] | [] | ["XCBO"] | 405.0000 | 405.0000 | 13 | 14 | false | true | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:02:03Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:49:37Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:33:00Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:41:29Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:40:02Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:40:02Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:39:13Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:39:13Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:30:02Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:27:28Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:27:28Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:20:11Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:42:22Z"} |
| 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-04T19:57:24Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:57:24Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:31:05Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |