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 |
|---|
| 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 |
|---|
| 01a0b01b-881b-7fd3-b886-ef17b606ae8b | PAYC | 2026-09-17 12:03 | call_vertical_spread | 2 | 1 | 16 | 307600.00 | unknown | — | 228.9550 | 6.9000 | ["125","145"] | ["0.5841","0.5751"] | [] | ["BATO"] | 125.0000 | 145.0000 | 92 | 92 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:03:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abc8-2bbb-7ad3-8607-3167ef03521d | PAYC | 2026-09-16 15:53 | put_diagonal_spread | 2 | 1 | 60 | 172920.00 | unknown | — | 228.1450 | 2.7000 | ["210","230"] | ["0.4696","0.4803"] | [] | ["XMIO"] | 210.0000 | 230.0000 | 93 | 121 | false | false | true | true | false | mlet | |||||||
| 01a0abc2-6efc-7983-aca8-8b168ffffd13 | PAYC | 2026-09-16 15:47 | put_diagonal_spread | 2 | 1 | 60 | 209214.00 | unknown | — | 226.8900 | 4.3000 | ["220","240"] | ["0.4790","0.4910"] | [] | ["XISX"] | 220.0000 | 240.0000 | 65 | 93 | false | false | true | true | false | mlet | |||||||
| 01a0aaa2-689b-7331-83a4-d8760431e0ce | PAYC | 2026-09-16 10:32 | straddle | 2 | 4 | 27 | 158830.00 | long | ask | 226.4625 | 2.9000 | ["240"] | ["0.4862"] | ["181.17","298.83"] | ["C2OX","EDGO","XCBO"] | 240.0000 | 240.0000 | 156 | 156 | false | false | false | false | |||||||||
| 01a0aaa2-689b-7331-83a4-d84ad4222291 | PAYC | 2026-09-16 10:32 | straddle | 2 | 2 | 25 | 147230.00 | long | ask | 226.4625 | 2.9840 | ["240"] | ["0.4867"] | ["181.11","298.89"] | ["XBOX","XISX"] | 240.0000 | 240.0000 | 156 | 156 | false | false | false | false | |||||||||
| 01a0aaa2-689b-7331-83a4-d83ae90e4290 | PAYC | 2026-09-16 10:32 | straddle | 2 | 3 | 37 | 217870.00 | long | ask | 226.4625 | 2.9838 | ["240"] | ["0.4867"] | ["181.12","298.88"] | ["ARCO","XBOX","XISX"] | 240.0000 | 240.0000 | 156 | 156 | false | false | false | false | |||||||||
| 01a0aaa2-495b-78e0-8f01-43806c4bfafa | PAYC | 2026-09-16 10:32 | straddle | 2 | 3 | 75 | 442500.00 | long | ask | 227.0000 | 3.8533 | ["240"] | ["0.4875"] | ["181","299.00"] | ["ARCO","XBOX","XISX"] | 240.0000 | 240.0000 | 156 | 156 | false | false | false | false | |||||||||
| 01a0aaa2-2633-7ab1-95e6-e4c0307ca52e | PAYC | 2026-09-16 10:32 | straddle | 2 | 2 | 27 | 158640.00 | long | ask | 227.2900 | 4.0000 | ["240"] | ["0.4854"] | ["181.24","298.76"] | ["EDGO","XCBO"] | 240.0000 | 240.0000 | 156 | 156 | false | false | false | false | |||||||||
| 01a0aaa2-2633-7ab1-95e6-e4be6f03d772 | PAYC | 2026-09-16 10:32 | straddle | 2 | 2 | 73 | 430700.00 | long | ask | 227.2900 | 4.4000 | ["240"] | ["0.4874"] | ["181","299.00"] | ["ARCO","XBOX"] | 240.0000 | 240.0000 | 156 | 156 | true | false | false | false | |||||||||
| 01a0a5d2-365e-7c90-a6a6-ff03b7d8d216 | PAYC | 2026-09-15 12:06 | put_diagonal_spread | 2 | 3 | 100 | 271628.00 | unknown | — | 229.3500 | 4.8000 | ["210","220"] | ["0.4646","0.4888"] | [] | ["AMXO","XMIO"] | 210.0000 | 220.0000 | 122 | 157 | false | true | true | true | false | mlet | |||||||
| 01a087b5-23b8-75b2-b3b2-02613f6b6b84 | PAYC | 2026-09-09 15:46 | other | 2 | 1 | 86 | 474118.00 | unknown | — | 214.3300 | 2.9000 | ["220","230"] | ["0.4721","0.4936"] | [] | ["BATO"] | 220.0000 | 230.0000 | 72 | 163 | false | false | true | true | false | mlet | |||||||
| 01a087a2-8230-7c72-b9ea-27610b056e08 | PAYC | 2026-09-09 15:26 | other | 2 | 1 | 120 | 540920.00 | unknown | — | 215.6900 | 4.7000 | ["190","210"] | ["0.4163","0.4920"] | [] | ["XMIO"] | 190.0000 | 210.0000 | 37 | 72 | false | false | true | true | false | mlat | |||||||
| 01a0879a-8350-70f1-82c7-1bde3c769a26 | PAYC | 2026-09-09 15:17 | put_diagonal_spread | 2 | 1 | 22 | 119306.00 | short | bid | 215.3200 | 2.7000 | ["220","230"] | ["0.4746","0.4925"] | [] | ["BATO"] | 220.0000 | 230.0000 | 72 | 163 | false | false | true | true | |||||||||
| 01a08799-75c8-7531-bbde-853b6ea8ac38 | PAYC | 2026-09-09 15:16 | other | 2 | 2 | 160 | 719544.00 | unknown | — | 215.3800 | 4.2000 | ["190","210"] | ["0.4529","0.5001"] | [] | ["EDGO","XPHO"] | 190.0000 | 210.0000 | 37 | 72 | false | false | true | true | false | mlet | |||||||
| 01a08789-3d70-7063-b79f-7879df725296 | PAYC | 2026-09-09 14:58 | other | 2 | 1 | 60 | 274598.00 | unknown | — | 215.9100 | 6.2000 | ["200","210"] | ["0.5092","0.5022"] | [] | ["XMIO"] | 200.0000 | 210.0000 | 72 | 72 | false | false | false | true | false | mlat | |||||||
| 01a08778-ca81-7d90-b33d-f43947f9af79 | PAYC | 2026-09-09 14:40 | put_diagonal_spread | 2 | 1 | 27 | 142965.00 | short | bid | 216.1600 | 3.5000 | ["220","230"] | ["0.4708","0.4867"] | [] | ["BATO"] | 220.0000 | 230.0000 | 72 | 163 | false | false | true | true | |||||||||
| 01a086f1-04b0-7302-9ed2-433c00f8bbf2 | PAYC | 2026-09-09 12:12 | other | 2 | 1 | 89 | 353790.00 | unknown | — | 216.1999 | 3.4000 | ["220"] | ["0.4818"] | [] | ["XISX"] | 220.0000 | 220.0000 | 72 | 163 | false | false | true | false | false | mlet | |||||||
| 01a086e6-e2f0-74e1-bd93-9d0c39a9ef75 | PAYC | 2026-09-09 12:01 | other | 2 | 1 | 100 | 517516.00 | unknown | — | 216.4950 | 6.1000 | ["200","210"] | ["0.4763","0.4718"] | [] | ["XMIO"] | 200.0000 | 210.0000 | 100 | 100 | false | false | false | true | false | mlat | |||||||
| 01a086aa-6a78-7e72-bdf0-f291db3791b6 | PAYC | 2026-09-09 10:55 | other | 2 | 1 | 80 | 315036.00 | unknown | — | 216.9800 | 4.9000 | ["220"] | ["0.4739"] | [] | ["XMIO"] | 220.0000 | 220.0000 | 72 | 128 | false | false | true | false | false | mlat | |||||||
| 01a0867b-3871-7f83-99ca-49780d36404a | PAYC | 2026-09-09 10:03 | other | 2 | 1 | 100 | 413800.00 | unknown | — | 215.8900 | 5.4000 | ["220"] | ["0.4912"] | [] | ["XISX"] | 220.0000 | 220.0000 | 72 | 464 | false | false | true | false | false | mlet | |||||||
| 01a08278-74e0-7393-92b6-7acf3491ad9b | PAYC | 2026-09-08 15:22 | other | 2 | 1 | 120 | 420780.00 | unknown | — | 220.1900 | 4.4000 | ["230"] | ["0.4520"] | [] | ["XCBO"] | 230.0000 | 230.0000 | 38 | 73 | false | false | true | false | false | mlat | |||||||
| 01a08270-5e90-7780-9fb7-6725ee9a3715 | PAYC | 2026-09-08 15:13 | other | 2 | 1 | 110 | 533640.00 | unknown | — | 220.7150 | 5.0000 | ["240"] | ["0.4473"] | [] | ["MCRY"] | 240.0000 | 240.0000 | 38 | 101 | false | false | true | false | false | mlet | |||||||
| 01a0817e-a7a8-7c11-a1a0-b6992587c524 | PAYC | 2026-09-08 10:49 | other | 2 | 1 | 139 | 655175.00 | unknown | — | 221.1900 | 4.8000 | ["210","220"] | ["0.5080","0.4713"] | [] | ["XISX"] | 210.0000 | 220.0000 | 73 | 101 | false | false | true | true | false | mlet | |||||||
| 01a0817e-0780-7641-8886-dd74ad2270ba | PAYC | 2026-09-08 10:48 | other | 2 | 1 | 40 | 249720.00 | unknown | — | 221.1900 | 5.0000 | ["200","210"] | ["0.4785","0.4637"] | [] | ["XMIO"] | 200.0000 | 210.0000 | 101 | 129 | false | false | true | true | false | mlet | |||||||
| 01a0816e-bd70-7b11-8397-7a408dad2dc5 | PAYC | 2026-09-08 10:31 | call_frontspread | 2 | 1 | 34 | 132930.00 | long | bid | 222.5300 | 6.2000 | ["220","230"] | ["0.4630","0.4629"] | ["220.31","275.21"] | ["XMIO"] | 220.0000 | 230.0000 | 101 | 101 | false | false | false | true | |||||||||
| 01a0816a-cda0-7511-9573-2026f6ead62f | PAYC | 2026-09-08 10:27 | call_frontspread | 2 | 1 | 64 | 282720.00 | long | bid | 222.8092 | 6.8000 | ["210","220"] | ["0.5034","0.4985"] | ["210.41","261.55"] | ["XMIO"] | 210.0000 | 220.0000 | 73 | 73 | false | false | false | true | |||||||||
| 01a0815c-fa90-79b0-a188-cebda3b2f8a8 | PAYC | 2026-09-08 10:12 | other | 2 | 1 | 33 | 115362.00 | unknown | — | 223.4000 | 6.0000 | ["220","230"] | ["0.4851","0.4845"] | [] | ["XPHO"] | 220.0000 | 230.0000 | 73 | 73 | false | false | false | true | false | mlet | |||||||
| 01a08156-cc88-75d2-a6d9-e8379197fa28 | PAYC | 2026-09-08 10:05 | call_frontspread | 2 | 1 | 100 | 391862.00 | long | bid | 223.4450 | 5.4000 | ["220","230"] | ["0.4539","0.4543"] | ["220.25","274.41"] | ["XISX"] | 220.0000 | 230.0000 | 101 | 101 | false | false | false | true | |||||||||
| 01a06d89-a5cd-73f3-b0c6-ce697ed1ca5a | PAYC | 2026-09-04 13:48 | other | 2 | 1 | 30 | 471900.00 | unknown | — | 233.6700 | 5.8000 | ["160"] | ["0.5477"] | [] | ["XISX"] | 160.0000 | 160.0000 | 77 | 168 | false | false | true | false | false | mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:53:51Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:47:23Z"} |
| 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:32:47Z"} |
| 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:32:47Z"} |
| 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:32:47Z"} |
| 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:32:47Z"} |
| 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:32:47Z"} |
| 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:32:47Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:07:21Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:46:47Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:26:27Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:17:50Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:16:15Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:59:01Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:40:55Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:12:37Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:01:44Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:55:40Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:03:39Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:22:43Z"} |
| 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-08T19:13:36Z"} |
| 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:49:40Z"} |
| 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:49:04Z"} |
| 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-08T14:32:03Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:27:41Z"} |
| 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:12:29Z"} |
| 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-08T14:06:05Z"} |
| 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-04T17:49:04Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |