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 | directiontext | net_side |
|---|
| 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 |
|---|
| 01a0f8a3-73a7-7df0-aaf5-84ea97c3498b | AFL | 2026-10-01 14:04 | call_vertical_spread | 2 | 1 | 49 | 381024.00 | long | ask | 110.8350 | 3.1000 | ["70","75"] | ["1.8539","1.6414"] | ["74.96"] | ["XMIO"] | 70.0000 | 75.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T18:04:26Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0ee09-dfdf-7331-915b-1445e8f8d522 | AFL | 2026-09-29 12:40 | call_calendar | 2 | 1 | 17 | 105638.00 | short | ask | 112.6400 | 7.1000 | ["90"] | ["0.1700"] | [] | ["XMIO"] | 90.0000 | 90.0000 | 479 | 843 | false | false | true | false | false | ||||||||
| 01a0eded-f757-7003-9f53-009bc9e46f99 | AFL | 2026-09-29 12:09 | call_vertical_spread | 2 | 1 | 46 | 244030.00 | unknown | ask | 112.6750 | 4.2000 | ["85","90"] | ["1.0641","0.9082"] | ["114.02"] | ["XBOX"] | 85.0000 | 90.0000 | 17 | 17 | false | false | false | true | |||||||||
| 01a0cfc5-f707-7573-a3b6-864352f491f4 | AFL | 2026-09-23 15:37 | call_vertical_spread | 2 | 1 | 18 | 117540.00 | long | ask | 115.1700 | 1.6000 | ["80","85"] | ["0.9105","0.8360"] | ["84.96"] | ["XISX"] | 80.0000 | 85.0000 | 16 | 16 | false | false | false | true | false | ||||||||
| 01a0cfc5-2be7-7cc0-a079-ed741d59250e | AFL | 2026-09-23 15:36 | call_vertical_spread | 2 | 1 | 20 | 130600.00 | long | ask | 115.1600 | 1.6000 | ["80","85"] | ["0.9182","0.8413"] | ["84.96"] | ["XMIO"] | 80.0000 | 85.0000 | 16 | 16 | false | false | false | true | false | ||||||||
| 01a0cfc4-7c1f-7cb3-bbb5-9fc04ce14eea | AFL | 2026-09-23 15:35 | call_vertical_spread | 2 | 1 | 30 | 198120.00 | unknown | ask | 115.1400 | 1.6000 | ["80","85"] | ["0.9327","0.8181"] | ["115.52"] | ["XBOX"] | 80.0000 | 85.0000 | 16 | 16 | false | false | false | true | |||||||||
| 01a0cfa4-d68f-7d41-a7f6-838b843f097c | AFL | 2026-09-23 15:01 | call_vertical_spread | 2 | 1 | 67 | 442468.00 | unknown | ask | 115.0600 | 1.6000 | ["80","85"] | ["0.9840","0.8605"] | ["115.52"] | ["XBOX"] | 80.0000 | 85.0000 | 16 | 16 | false | false | false | true | |||||||||
| 01a0cf81-77de-7ce1-82a4-6dc2f55cc846 | AFL | 2026-09-23 14:22 | call_vertical_spread | 2 | 1 | 65 | 369460.00 | unknown | ask | 115.1000 | 2.4000 | ["85","90"] | ["0.9948","0.8531"] | ["115.92"] | ["XBOX"] | 85.0000 | 90.0000 | 16 | 16 | false | false | false | true | |||||||||
| 01a0a126-bc30-7d13-b951-628df92e810c | AFL | 2026-09-14 14:21 | call_vertical_spread | 2 | 1 | 53 | 310156.00 | long | ask | 116.6400 | 4.8000 | ["85","90"] | ["1.4270","0.6331"] | ["89.96"] | ["XCBO"] | 85.0000 | 90.0000 | 11 | 11 | false | false | false | true | false | ||||||||
| 01a0a0fc-d988-7731-8d05-cf942fa88225 | AFL | 2026-09-14 13:35 | call_vertical_spread | 2 | 1 | 37 | 216450.00 | long | ask | 116.2100 | 4.8000 | ["85","90"] | ["1.1131","0.9600"] | ["89.96"] | ["XMIO"] | 85.0000 | 90.0000 | 11 | 11 | false | false | false | true | false | ||||||||
| 01a0a0e9-b718-77b0-a16c-69932e7e8bed | AFL | 2026-09-14 13:14 | call_vertical_spread | 2 | 1 | 37 | 216450.00 | long | ask | 116.2200 | 4.8000 | ["85","90"] | ["1.1078","0.9556"] | ["89.96"] | ["XMIO"] | 85.0000 | 90.0000 | 11 | 11 | false | false | false | true | false | ||||||||
| 01a0822d-8548-7981-bda8-e4a4fe53fbb2 | AFL | 2026-09-08 14:00 | call_vertical_spread | 2 | 1 | 44 | 160204.00 | long | ask | 115.4800 | 1.4000 | ["95","100"] | ["0.6074","0.5020"] | ["99.95"] | ["XCBO"] | 95.0000 | 100.0000 | 10 | 10 | false | false | false | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T16:40:59Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T16:09:58Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:37:51Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:37:17Z"} |
| 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-23T19:35:56Z"} |
| 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-23T19:01:54Z"} |
| 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-23T18:23:30Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:21:51Z"} |
| 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-14T17:35:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:15:01Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:00:22Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |