core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a08bf3-d320-7b01-b4f0-6061e8be0e0f | GLD | 2026-09-10 11:33 | put_calendar | 2 | 3 | 24 | 123400.00 | short | ask | 399.9700 | 1.6500 | ["395"] | ["0.2518"] | [] | ["EMLD","MCRY","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:33:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bf3-d320-7b01-b4f0-605d8f0a3147 | GLD | 2026-09-10 11:33 | put_calendar | 2 | 4 | 32 | 164544.00 | short | ask | 399.9700 | 1.6500 | ["395"] | ["0.2518"] | [] | ["C2OX","EMLD","MCRY","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf3-d320-7b01-b4f0-6042be7aa521 | GLD | 2026-09-10 11:33 | put_calendar | 2 | 4 | 32 | 164720.00 | short | ask | 399.9700 | 1.6500 | ["395"] | ["0.2521"] | [] | ["C2OX","MCRY","XBOX","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf3-d320-7b01-b4f0-603671381e62 | GLD | 2026-09-10 11:33 | put_calendar | 2 | 4 | 32 | 164720.00 | short | ask | 399.9700 | 1.6500 | ["395"] | ["0.2521"] | [] | ["EMLD","MCRY","XBOX","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf3-d320-7b01-b4f0-6027e00992e2 | GLD | 2026-09-10 11:33 | put_calendar | 2 | 4 | 32 | 164720.00 | short | ask | 399.9700 | 1.6500 | ["395"] | ["0.2521"] | [] | ["EMLD","MCRY","XBOX","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf3-d320-7b01-b4f0-601e18cc9599 | GLD | 2026-09-10 11:33 | put_calendar | 2 | 4 | 32 | 164720.00 | short | ask | 399.9700 | 1.6500 | ["395"] | ["0.2521"] | [] | ["EMLD","MCRY","XBOX","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf3-d320-7b01-b4f0-6000caefc525 | GLD | 2026-09-10 11:33 | put_calendar | 2 | 5 | 40 | 205864.00 | short | ask | 399.9700 | 1.6500 | ["395"] | ["0.2520"] | [] | ["C2OX","EMLD","MCRY","XBOX"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf3-d320-7b01-b4f0-5ffba0b8f009 | GLD | 2026-09-10 11:33 | put_calendar | 2 | 3 | 24 | 123608.00 | short | ask | 399.9700 | 1.6500 | ["395"] | ["0.2522"] | [] | ["EMLD","XBOX","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf3-d320-7b01-b4f0-5fc30f73e087 | GLD | 2026-09-10 11:33 | put_calendar | 2 | 4 | 24 | 123752.00 | short | bid | 399.9700 | 1.0500 | ["395"] | ["0.2524"] | [] | ["C2OX","MCRY","XBOX"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf3-d320-7b01-b4f0-5fb86ec6e1fc | GLD | 2026-09-10 11:33 | put_calendar | 2 | 8 | 40 | 206166.00 | short | bid | 399.9700 | 0.9113 | ["395"] | ["0.2523"] | [] | ["C2OX","EMLD","MCRY","XBOX","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf1-42e0-7612-9176-8177dca5c258 | GLD | 2026-09-10 11:30 | put_calendar | 2 | 11 | 125 | 639673.00 | short | bid | 400.2800 | 1.0000 | ["395"] | ["0.2518"] | [] | ["AMXO","ARCO","C2OX","EMLD","MCRY","XBOX","XCBO","XISX","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf1-3340-77b2-8aca-68bdf7f16863 | GLD | 2026-09-10 11:30 | put_calendar | 2 | 6 | 50 | 256471.00 | short | bid | 400.2800 | 1.0000 | ["395"] | ["0.2523"] | [] | ["ARCO","C2OX","MCRY","XCBO","XISX","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf1-1bd0-72c2-a982-0724a2afd616 | GLD | 2026-09-10 11:30 | put_calendar | 2 | 3 | 38 | 195510.00 | short | bid | 400.2278 | 1.1000 | ["395"] | ["0.2528"] | [] | ["ARCO","EMLD","XBOX"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf1-1bd0-72c2-a982-0703388a4d3a | GLD | 2026-09-10 11:30 | put_calendar | 2 | 9 | 132 | 677546.00 | short | bid | 400.2278 | 1.4864 | ["395"] | ["0.2523"] | [] | ["AMXO","ARCO","C2OX","EMLD","MCRY","XBOX","XCBO","XISX","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf1-0849-7770-8047-7759fb859fbf | GLD | 2026-09-10 11:30 | put_calendar | 2 | 9 | 134 | 688710.00 | short | bid | 400.1350 | 1.5000 | ["395"] | ["0.2523"] | [] | ["AMXO","ARCO","C2OX","EMLD","MCRY","XBOX","XCBO","XISX","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf0-b258-7c41-afae-d2e513e154a6 | GLD | 2026-09-10 11:30 | put_calendar | 2 | 3 | 36 | 184496.00 | short | bid | 400.1500 | 1.7500 | ["395"] | ["0.2518"] | [] | ["XCBO","XISX","XPHO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf0-b258-7c41-afae-d2c17a94b4d2 | GLD | 2026-09-10 11:29 | put_calendar | 2 | 2 | 25 | 128220.00 | short | bid | 400.1500 | 1.7500 | ["395"] | ["0.2519"] | [] | ["XCBO","XISX"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf0-b258-7c41-afae-d2bcd7c42f5a | GLD | 2026-09-10 11:29 | put_calendar | 2 | 2 | 25 | 128220.00 | short | bid | 400.1500 | 1.7500 | ["395"] | ["0.2519"] | [] | ["XCBO","XISX"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | |||||||||
| 01a08bf0-b258-7c41-afae-d2ab2dc1ff9c | GLD | 2026-09-10 11:29 | put_calendar | 2 | 3 | 28 | 143640.00 | unknown | — | 400.1500 | 2.2000 | ["395"] | ["0.2520"] | [] | ["XCBO","XISX","XMIO"] | 395.0000 | 395.0000 | 127 | 498 | false | true | true | false | false | mlet | |||||||
| 01a0827b-d428-7a21-86c8-0d83df54954c | GLD | 2026-09-08 15:25 | put_calendar | 2 | 2 | 195 | 209625.00 | short | ask | 400.4400 | 0.7500 | ["405"] | ["0.6129"] | [] | ["C2OX","EDGO"] | 405.0000 | 405.0000 | 0 | 2 | false | false | true | false | false | ||||||||
| 01a0827b-d428-7a21-86c8-0d79d1ae26d7 | GLD | 2026-09-08 15:25 | put_calendar | 2 | 2 | 147 | 157635.00 | short | ask | 400.4400 | 0.7500 | ["405"] | ["0.5959"] | [] | ["ARCO","EMLD"] | 405.0000 | 405.0000 | 0 | 2 | false | false | true | false | false | ||||||||
| 01a0825e-ce78-7b02-a501-b39b10ce213e | GLD | 2026-09-08 14:54 | put_calendar | 2 | 1 | 1000 | 1066000.00 | unknown | — | 400.9650 | 0.4000 | ["400"] | ["0.2964"] | [] | ["XPHO"] | 400.0000 | 400.0000 | 3 | 10 | false | true | true | false | false | mlet | |||||||
| 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 | false | |||||||||
| 01a0813d-ba90-7f62-a492-2b9665d679ab | GLD | 2026-09-08 09:38 | put_calendar | 2 | 4 | 242 | 150774.00 | short | ask | 403.5100 | 0.7400 | ["405"] | ["0.2825"] | [] | ["ARCO","EMLD","SPHR","XPHO"] | 405.0000 | 405.0000 | 0 | 2 | false | false | true | false | |||||||||
| 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 | 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 | 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 | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:33:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:33:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:33:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:33:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:33:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:33:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:33:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:33:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:33:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:31:24Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:30:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:30:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:30:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:30:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:30:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:30:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:30:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:30:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:26: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-08T19:26:27Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:54:21Z"} |
| 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-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-08T13:38:27Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| 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 |
| 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 |
| 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 |