Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c442-e5cf-7cf0-a0d0-7260129ae06f | COIN | 2026-09-21 09:58 | put_diagonal_spread | 2 | 1 | 11 | 168091.00 | short | bid | 205.0800 | 6.3000 | ["200","220"] | ["0.7482","0.7532"] | [] | ["XPHO"] | 200.0000 | 220.0000 | 816 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:58:47Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c440-8086-71a1-b8b3-d199da778cb2 | COIN | 2026-09-21 09:55 | put_diagonal_spread | 2 | 1 | 20 | 179140.00 | long | ask | 205.7900 | 3.5000 | ["200","240"] | ["0.7007","0.7147"] | [] | ["XISX"] | 200.0000 | 240.0000 | 116 | 207 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:56:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b601-a5af-7f53-8a68-3c672821169a | COIN | 2026-09-18 15:32 | put_diagonal_spread | 2 | 1 | 10 | 114320.00 | long | ask | 194.3985 | 3.0500 | ["200","240"] | ["0.7259","0.7145"] | [] | ["SPHR"] | 200.0000 | 240.0000 | 91 | 455 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:32:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b584-a5af-7a33-ab13-bda187b30e9d | COIN | 2026-09-18 13:16 | put_diagonal_spread | 2 | 1 | 30 | 117600.00 | long | ask | 195.0350 | 1.3500 | ["160","175"] | ["0.7003","0.6877"] | [] | ["XPHO"] | 160.0000 | 175.0000 | 119 | 210 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:16:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55d-e7b7-74f1-9b5b-c7638da8ba5b | COIN | 2026-09-18 12:33 | put_diagonal_spread | 2 | 1 | 60 | 348900.00 | short | bid | 195.4300 | 1.6500 | ["190","195"] | ["0.6897","0.6842"] | [] | ["XISX"] | 190.0000 | 195.0000 | 119 | 154 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:34:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b041-f7f3-7f62-84c1-fed158d686cd | COIN | 2026-09-17 12:45 | put_diagonal_spread | 2 | 1 | 20 | 131620.00 | unknown | — | 170.9400 | 4.2000 | ["197.5","200"] | ["0.7055","0.6663"] | [] | ["XPHO"] | 197.5000 | 200.0000 | 29 | 43 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:45:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b041-f40b-7010-acad-1630cba9a8ed | COIN | 2026-09-17 12:45 | put_diagonal_spread | 2 | 1 | 20 | 131820.00 | long | ask | 170.9400 | 5.0000 | ["197.5","200"] | ["0.7116","0.6643"] | [] | ["MCRY"] | 197.5000 | 200.0000 | 29 | 43 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:45:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b041-f40b-7010-acad-162ae9829900 | COIN | 2026-09-17 12:45 | put_diagonal_spread | 2 | 2 | 84 | 554316.00 | short | bid | 170.9400 | 4.4000 | ["197.5","200"] | ["0.7121","0.6690"] | [] | ["ARCO","XCBO"] | 197.5000 | 200.0000 | 29 | 43 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:45:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b041-f023-7f71-9aa8-5cc6948f4663 | COIN | 2026-09-17 12:45 | put_diagonal_spread | 2 | 2 | 86 | 568460.00 | unknown | — | 170.9400 | 4.9000 | ["197.5","200"] | ["0.7152","0.6720"] | [] | ["ARCO","XMIO"] | 197.5000 | 200.0000 | 29 | 43 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:45:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab68-3553-7650-bf94-20c72b903efc | COIN | 2026-09-16 14:08 | put_diagonal_spread | 2 | 6 | 16 | 165050.00 | long | ask | 167.5751 | 9.4750 | ["205","210"] | ["1.2527","0.7533"] | [] | ["EDGO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 205.0000 | 210.0000 | 9 | 212 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:08:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab68-3553-7650-bf94-20b93c4c058a | COIN | 2026-09-16 14:08 | put_diagonal_spread | 2 | 4 | 10 | 103542.00 | long | ask | 167.5751 | 9.6800 | ["205","210"] | ["1.2791","0.7571"] | [] | ["EMLD","XBOX","XCBO","XMIO"] | 205.0000 | 210.0000 | 9 | 212 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:08:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab68-3553-7650-bf94-20addfc82d9b | COIN | 2026-09-16 14:08 | put_diagonal_spread | 2 | 6 | 11 | 113322.00 | long | ask | 167.5751 | 9.9136 | ["205","210"] | ["1.2430","0.7520"] | [] | ["AMXO","EMLD","MCRY","XBOX","XISX","XPHO"] | 205.0000 | 210.0000 | 9 | 212 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:08:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5e-80f4-7041-8ab0-767a25c0347b | COIN | 2026-09-16 13:58 | put_diagonal_spread | 2 | 1 | 5 | 101525.00 | long | ask | 165.1600 | 5.0000 | ["250","260"] | ["0.7515","0.7902"] | [] | ["XISX"] | 250.0000 | 260.0000 | 65 | 492 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:58:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5f9-5dce-75f1-9ef1-4e41a3168a3d | COIN | 2026-09-15 12:49 | put_diagonal_spread | 2 | 1 | 21 | 169113.00 | short | bid | 179.5186 | 4.0000 | ["150","160"] | ["0.7404","0.7336"] | [] | ["BATO"] | 150.0000 | 160.0000 | 458 | 640 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:49:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a143-ba11-7e51-b57d-ec2a0e54c7af | COIN | 2026-09-14 14:52 | put_diagonal_spread | 2 | 1 | 26 | 311220.00 | unknown | — | 189.5000 | 2.6500 | ["210","260"] | ["0.7215","0.7257"] | [] | ["XISX"] | 210.0000 | 260.0000 | 67 | 186 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:53:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a141-8790-71f3-8d3e-2bb42ce50e9b | COIN | 2026-09-14 14:50 | put_diagonal_spread | 2 | 1 | 11 | 131439.00 | long | ask | 190.0567 | 4.1500 | ["210","260"] | ["0.7272","0.7308"] | [] | ["XPHO"] | 210.0000 | 260.0000 | 67 | 186 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:50:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09122-31e8-7cf1-b5b1-62e5c874acb5 | COIN | 2026-09-11 11:42 | put_diagonal_spread | 2 | 1 | 80 | 1017680.00 | long | ask | 180.7050 | 4.4000 | ["180","200"] | ["0.7216","0.7081"] | [] | ["XPHO"] | 180.0000 | 200.0000 | 462 | 826 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:42:36Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090fe-c398-7e93-a5fe-0834f052329d | COIN | 2026-09-11 11:03 | put_diagonal_spread | 2 | 3 | 218 | 688553.00 | long | bid | 181.0600 | 0.8000 | ["180","185"] | ["0.6576","0.6576"] | [] | ["ARCO","XISX","XMIO"] | 180.0000 | 185.0000 | 35 | 42 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:03:46Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |