core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0da27-060e-7ce0-bf7a-18044e602a70 | PYPL | 2026-09-25 15:59 | call_vertical_spread | 2 | 1 | 971 | 103897.00 | short | bid | 55.0550 | 0.0800 | ["54","56"] | ["20.7913","18.2486"] | ["54.99"] | ["ARCO"] | 54.0000 | 56.0000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:59:51Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d9e0-5c37-7b63-b757-542080d88654 | PYPL | 2026-09-25 14:42 | put_vertical_spread | 2 | 2 | 700 | 133000.00 | unknown | bid | 55.0050 | 0.2600 | ["51","53"] | ["0.4144","0.4164"] | ["51.10"] | ["ARCO","EDGO"] | 51.0000 | 53.0000 | 21 | 21 | false | true | false | ||||||||||
| 01a0d9db-e3ae-7661-8b20-e7426b18f8ac | PYPL | 2026-09-25 14:37 | put_vertical_spread | 2 | 1 | 797 | 151430.00 | unknown | bid | 54.9950 | 0.2600 | ["51","53"] | ["0.4139","0.4157"] | ["51.10"] | ["ARCO"] | 51.0000 | 53.0000 | 21 | 21 | false | true | false | ||||||||||
| 01a0d9d9-20a6-7640-a237-712f3fe173b0 | PYPL | 2026-09-25 14:34 | put_vertical_spread | 2 | 3 | 900 | 168646.00 | unknown | bid | 55.0350 | 0.2698 | ["51","53"] | ["0.4125","0.4157"] | ["51.13"] | ["ARCO","XBOX","XMIO"] | 51.0000 | 53.0000 | 21 | 21 | false | true | |||||||||||
| 01a0d9cc-89fe-78e0-ae30-a7297e430d53 | PYPL | 2026-09-25 14:20 | other | 4 | 1 | 1730 | 615880.00 | unknown | — | 54.8950 | 0.8400 | ["53","55","56","58"] | ["1.6799","0.5893","0.4735","0.5159"] | [] | ["EDGO"] | 53.0000 | 58.0000 | 0 | 7 | false | false | true | true | false | ||||||||
| 01a0d9cb-b327-70d2-916e-e99e953df206 | PYPL | 2026-09-25 14:19 | put_vertical_spread | 2 | 1 | 564 | 107160.00 | unknown | bid | 54.9250 | 0.3000 | ["51","53"] | ["0.4101","0.4109"] | ["51.10"] | ["ARCO"] | 51.0000 | 53.0000 | 21 | 21 | false | true | false | ||||||||||
| 01a0d9ca-43f6-7a30-ba11-81263b0b02e8 | PYPL | 2026-09-25 14:18 | put_vertical_spread | 2 | 1 | 651 | 123690.00 | unknown | bid | 54.9400 | 0.3000 | ["51","53"] | ["0.4109","0.4119"] | ["51.10"] | ["EDGO"] | 51.0000 | 53.0000 | 21 | 21 | false | true | false | ||||||||||
| 01a0d930-3e46-7a62-8594-f9b8a411c656 | PYPL | 2026-09-25 11:30 | other | 4 | 5 | 357 | 133353.00 | unknown | ask | 54.8300 | 0.6200 | ["53","54","57","59"] | ["0.9218","0.7676","0.4576","0.5288"] | [] | ["ARCO","EDGO","XCBO","XISX"] | 53.0000 | 59.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0d900-e917-73c0-b113-2f7f8ab7cc26 | PYPL | 2026-09-25 10:38 | call_diagonal_spread | 2 | 1 | 100 | 191600.00 | long | ask | 54.7375 | 3.4400 | ["40","57"] | ["0.3264","0.5564"] | [] | ["XISX"] | 40.0000 | 57.0000 | 7 | 448 | false | false | true | ||||||||||
| 01a0d4c4-02b6-7ae0-8263-b84b5cb9139e | PYPL | 2026-09-24 14:53 | other | 6 | 1 | 837 | 3937030.00 | unknown | ask | 52.2300 | 14.0000 | ["57","58","60","75","80","115"] | ["1.7241","1.9367","2.1603","0.7635","0.8774","0.8960"] | [] | ["XBOX"] | 57.0000 | 115.0000 | 1 | 449 | false | false | |||||||||||
| 01a0d4b7-837f-77f3-b58c-aec49f886e19 | PYPL | 2026-09-24 14:39 | other | 3 | 1 | 428 | 1457400.00 | unknown | ask | 52.2196 | 5.2500 | ["56","59","80"] | ["1.4878","2.2022","0.7168"] | [] | ["XBOX"] | 56.0000 | 80.0000 | 1 | 85 | false | false | true | ||||||||||
| 01a0d49e-bbbe-7620-863d-814bd31680d0 | PYPL | 2026-09-24 14:12 | put_calendar | 2 | 1 | 155 | 287422.00 | short | ask | 52.1000 | 3.3500 | ["60"] | ["0.3453"] | [] | ["EDGO"] | 60.0000 | 60.0000 | 113 | 266 | false | false | true | ||||||||||
| 01a0d499-c24e-7483-82ae-ac93e03f2b0e | PYPL | 2026-09-24 14:07 | put_calendar | 2 | 1 | 175 | 263900.00 | short | ask | 52.1200 | 3.4000 | ["57.5"] | ["0.3454"] | [] | ["EDGO"] | 57.5000 | 57.5000 | 113 | 266 | false | false | true | ||||||||||
| 01a0d3f2-f32f-72f1-97b7-64ddad728004 | PYPL | 2026-09-24 11:05 | put_calendar | 2 | 3 | 258 | 136134.00 | short | ask | 52.2200 | 0.6142 | ["53"] | ["0.3702"] | [] | ["ARCO","XCBO","XISX"] | 53.0000 | 53.0000 | 29 | 36 | true | false | true | ||||||||||
| 01a0ca82-434f-7562-8a3b-60e65a3dd01f | PYPL | 2026-09-22 15:05 | put_calendar | 2 | 1 | 616 | 3092320.00 | unknown | bid | 52.8800 | 6.7000 | ["80"] | ["0.5412"] | [] | ["XBOX"] | 80.0000 | 80.0000 | 87 | 451 | false | false | true | ||||||||||
| 01a0c9c9-4007-7081-885c-3bcefbc76124 | PYPL | 2026-09-22 11:43 | put_vertical_spread | 2 | 1 | 949 | 155636.00 | unknown | bid | 53.7300 | 0.2000 | ["53","54"] | ["0.4745","0.4715"] | ["52.68"] | ["XBOX"] | 53.0000 | 54.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c56b-298e-7bf2-ada2-fbcb5ced0dbb | PYPL | 2026-09-21 15:22 | put_calendar | 2 | 1 | 924 | 4832520.00 | unknown | bid | 52.7650 | 5.0000 | ["80"] | ["0.6013"] | [] | ["XBOX"] | 80.0000 | 80.0000 | 88 | 452 | true | false | true | ||||||||||
| 01a0c4d2-e12e-7401-8794-e7d5f5cee951 | PYPL | 2026-09-21 12:35 | put_ratio_spread | 2 | 3 | 733 | 809816.00 | unknown | bid | 52.7300 | 4.4750 | ["55","60"] | ["0.3291","0.3448"] | ["46.69"] | ["XCBO"] | 55.0000 | 60.0000 | 487 | 487 | false | false | false | ||||||||||
| 01a0b60e-5b97-7362-8c19-434ec56277cd | PYPL | 2026-09-18 15:46 | other | 4 | 1 | 540 | 3576960.00 | unknown | ask | 52.4250 | 10.0500 | ["60","75","80"] | ["0.7868","0.4495","0.5562"] | [] | ["XPHO"] | 60.0000 | 80.0000 | 7 | 455 | false | false | true | ||||||||||
| 01a0b5d0-1247-7df2-9bbc-04e5ec092405 | PYPL | 2026-09-18 14:38 | call_diagonal_spread | 2 | 1 | 71 | 212361.00 | short | ask | 52.5150 | 1.0500 | ["30","50"] | ["0.3457","0.3492"] | [] | ["XCBO"] | 30.0000 | 50.0000 | 119 | 182 | false | false | true | ||||||||||
| 01a0b4d9-4e67-7a22-923e-8b23ba4e5f98 | PYPL | 2026-09-18 10:08 | call_vertical_spread | 2 | 1 | 1730 | 185110.00 | long | ask | 52.7750 | 0.2100 | ["53","55"] | ["0.3079","0.3334"] | ["53.55"] | ["EDGO"] | 53.0000 | 55.0000 | 7 | 7 | true | true | false | ||||||||||
| 01a0b0ed-10bb-7401-84a4-d160c302d088 | PYPL | 2026-09-17 15:51 | put_vertical_spread | 2 | 1 | 606 | 349056.00 | short | bid | 52.9950 | 2.9100 | ["55","56"] | ["0.9798","1.2287"] | ["0","55"] | ["AMXO"] | 55.0000 | 56.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0b0a9-1663-77d3-9815-010be86e42aa | PYPL | 2026-09-17 14:37 | put_diagonal_spread | 2 | 1 | 117 | 843570.00 | unknown | — | 53.2050 | 2.8000 | ["62.5","115"] | ["2.6917","0.7056"] | [] | ["XBOX"] | 62.5000 | 115.0000 | 1 | 456 | true | false | true | true | false | ||||||||
| 01a0b0a8-fef3-71b3-b43b-739e5b292e02 | PYPL | 2026-09-17 14:37 | other | 4 | 1 | 1774 | 3962056.00 | unknown | — | 53.2050 | 3.1500 | ["60","61","65","75"] | ["1.4722","1.8820","2.7405","5.7035"] | [] | ["XBOX"] | 60.0000 | 75.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b0a8-e39b-7223-bd25-131112c45bd3 | PYPL | 2026-09-17 14:37 | other | 7 | 1 | 1816 | 5264780.00 | unknown | — | 53.2050 | 11.1500 | ["59","60","62","67.5","70","72.5","80"] | ["1.3112","1.4722","1.7766","4.6495","5.2086","5.6118","0.4568"] | [] | ["XBOX"] | 59.0000 | 80.0000 | 1 | 92 | false | false | true | true | |||||||||
| 01a0a108-c450-7e03-ba66-9be7f3b73f66 | PYPL | 2026-09-14 13:48 | call_vertical_spread | 2 | 1 | 160 | 107520.00 | unknown | — | 54.1350 | 2.4400 | ["65","75"] | ["0.2951","0.2752"] | [] | ["XBOX"] | 65.0000 | 75.0000 | 494 | 494 | false | true | false | true | false | ||||||||
| 01a091e8-c1f0-7a60-9018-7633d19a1b6e | PYPL | 2026-09-11 15:19 | other | 2 | 1 | 124 | 999440.00 | unknown | — | 53.7450 | 7.3000 | ["75","115"] | ["2.4754","0.6836"] | [] | ["XBOX"] | 75.0000 | 115.0000 | 7 | 462 | false | false | true | true | false | ||||||||
| 01a090f1-4e49-76c3-9665-de95f1dfe190 | PYPL | 2026-09-11 10:48 | other | 2 | 1 | 50 | 165450.00 | unknown | — | 54.1800 | 2.5500 | ["70"] | ["0.4841"] | [] | ["XISX"] | 70.0000 | 70.0000 | 98 | 126 | false | false | true | false | false | ||||||||
| 01a08cbf-cde0-7d03-a193-912a94572a4b | PYPL | 2026-09-10 15:16 | other | 2 | 1 | 125 | 1062500.00 | unknown | — | 53.0410 | 7.9500 | ["75","115"] | ["1.6930","0.7076"] | [] | ["XPHO"] | 75.0000 | 115.0000 | 8 | 463 | false | false | true | true | false | ||||||||
| 01a08c9e-dc48-7602-8f77-8a6ecef410c1 | PYPL | 2026-09-10 14:40 | other | 3 | 1 | 737 | 2320580.00 | unknown | — | 52.9450 | 6.5500 | ["63","72.5","75"] | ["2.4550","2.2291","2.3474"] | [] | ["XBOX"] | 63.0000 | 75.0000 | 1 | 8 | false | false | true | true | false | ||||||||
| 01a08c9e-a1b0-7033-b467-69658428eb21 | PYPL | 2026-09-10 14:39 | other | 6 | 1 | 700 | 4147120.00 | unknown | — | 52.9400 | 16.9000 | ["63","72.5","75","80","90","115"] | ["2.4456","2.2274","1.7342","0.8234","0.7969","0.5433"] | [] | ["XBOX"] | 63.0000 | 115.0000 | 1 | 463 | false | false | true | true | |||||||||
| 01a0817d-3c60-7d50-bc32-f5103c618719 | PYPL | 2026-09-08 10:47 | put_diagonal_spread | 2 | 2 | 45 | 221940.00 | short | bid | 53.4023 | 2.0500 | ["75","80"] | ["0.3858","0.3928"] | [] | ["EMLD","SPHR"] | 75.0000 | 80.0000 | 500 | 829 | false | false | true | ||||||||||
| 01a0817d-3c60-7d50-bc32-f503a3f5a13b | PYPL | 2026-09-08 10:47 | other | 2 | 3 | 35 | 170906.00 | unknown | — | 53.4023 | 2.1271 | ["75","80"] | ["0.3750","0.3849"] | [] | ["EMLD","SPHR","XBOX"] | 75.0000 | 80.0000 | 500 | 829 | false | false | true | true | false | ||||||||
| 01a08147-20d0-7881-a063-d403a7c5662a | PYPL | 2026-09-08 09:48 | call_vertical_spread | 2 | 1 | 100 | 169200.00 | unknown | — | 53.6200 | 3.8500 | ["55","60"] | ["0.3708","0.3431"] | [] | ["SPHR"] | 55.0000 | 60.0000 | 500 | 500 | false | true | false | true | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:42:56Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:38:14Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:34:45Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:21:11Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:20:19Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:18:29Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:30:34Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:38:47Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:53:36Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:39:58Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:13:27Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:07:50Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:05:20Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:05:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:43:50Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:22:22Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:36:15Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:46:28Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:38:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:08:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:52:15Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:38:07Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:38:07Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:38:07Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:48:29Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:19:28Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:48:57Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:16:43Z"} |
| 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-10T18:40:22Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:40:22Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:47:48Z"} |
| 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-08T14:47:48Z"} |
| 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-08T13:48:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |