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 | 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 |
|---|
| 01a0c532-376f-7622-bee5-655526adcd51 | NBIS | 2026-09-21 14:19 | call_diagonal_spread | 2 | 1 | 15 | 168120.00 | long | ask | 236.4950 | 3.4500 | ["210","240"] | ["0.8808","0.8851"] | [] | ["XCBO"] | 210.0000 | 240.0000 | 88 | 179 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:20:29Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c497-d3ff-7072-9d19-7afa19fc8a8c | NBIS | 2026-09-21 11:31 | call_diagonal_spread | 2 | 1 | 9 | 111159.00 | short | ask | 234.0800 | 3.1000 | ["200","230"] | ["0.8776","0.8876"] | [] | ["XCBO"] | 200.0000 | 230.0000 | 116 | 179 | false | false | true | ||||||||||
| 01a0b617-779f-7f21-a564-fe1352a8e36f | NBIS | 2026-09-18 15:56 | call_diagonal_spread | 2 | 1 | 5 | 158210.00 | short | ask | 223.5000 | 6.5000 | ["47","110"] | ["247.6361","0.9399"] | [] | ["EDGO"] | 47.0000 | 110.0000 | 0 | 455 | false | false | true | ||||||||||
| 01a0b612-3bc8-7ae0-b5ca-8fd79419dd3d | NBIS | 2026-09-18 15:50 | call_diagonal_spread | 2 | 1 | 6 | 190032.00 | long | bid | 223.9300 | 3.5000 | ["45","115"] | ["166.0863","0.9423"] | [] | ["XCBO"] | 45.0000 | 115.0000 | 0 | 455 | false | false | true | ||||||||||
| 01a0b59b-cb77-74b3-9d0c-2bfa2b557501 | NBIS | 2026-09-18 13:41 | call_diagonal_spread | 2 | 1 | 720 | 2702880.00 | short | bid | 220.0500 | 2.0000 | ["205","210"] | ["0.7682","0.7830"] | [] | ["XCBO"] | 205.0000 | 210.0000 | 7 | 14 | false | false | true | ||||||||||
| 01a0b577-b147-7e31-84ac-17daa14977fc | NBIS | 2026-09-18 13:01 | call_diagonal_spread | 2 | 1 | 100 | 1981700.00 | short | bid | 219.1522 | 7.4500 | ["220","250"] | ["0.8953","0.8947"] | [] | ["XCBO"] | 220.0000 | 250.0000 | 490 | 819 | false | true | true | ||||||||||
| 01a0b53f-5b67-7502-9514-334a8b60af00 | NBIS | 2026-09-18 12:00 | call_diagonal_spread | 2 | 1 | 5 | 101750.00 | long | ask | 220.3300 | 7.4000 | ["200","220"] | ["0.9081","0.9088"] | [] | ["XMIO"] | 200.0000 | 220.0000 | 490 | 637 | false | false | true | ||||||||||
| 01a0aff8-dd1b-7c22-96f1-a26c35e106a7 | NBIS | 2026-09-17 11:25 | call_diagonal_spread | 2 | 1 | 8 | 105182.00 | unknown | — | 211.0500 | 7.2500 | ["210","220"] | ["0.8965","0.9023"] | [] | ["XCBO"] | 210.0000 | 220.0000 | 246 | 820 | false | false | true | true | false | ||||||||
| 01a0abbf-c74b-75c0-862d-1b619d5fd83b | NBIS | 2026-09-16 15:44 | call_diagonal_spread | 2 | 1 | 9 | 231183.00 | short | ask | 209.9500 | 6.1000 | ["70","100"] | ["8.1172","0.9084"] | [] | ["XCBO"] | 70.0000 | 100.0000 | 2 | 184 | false | false | true | ||||||||||
| 01a0ab44-da8b-7572-9524-c2f5ab7e03f1 | NBIS | 2026-09-16 13:30 | call_diagonal_spread | 2 | 1 | 360 | 513360.00 | long | ask | 217.3200 | 0.9000 | ["235","400"] | ["0.7918","0.9144"] | [] | ["XCBO"] | 235.0000 | 400.0000 | 9 | 121 | false | true | true | ||||||||||
| 01a0aab1-742b-7012-80e4-f249a93dc1c4 | NBIS | 2026-09-16 10:49 | call_diagonal_spread | 2 | 1 | 8 | 222328.00 | short | ask | 215.6550 | 4.3500 | ["47","130"] | ["10.4222","0.9208"] | [] | ["XCBO"] | 47.0000 | 130.0000 | 2 | 274 | false | false | true | ||||||||||
| 01a0a6a4-b12e-7170-888c-f39f9a1167f4 | NBIS | 2026-09-15 15:56 | call_diagonal_spread | 2 | 1 | 25 | 666825.00 | short | ask | 207.2500 | 5.1500 | ["47","120"] | ["9.2391","0.9063"] | [] | ["XCBO"] | 47.0000 | 120.0000 | 3 | 275 | false | false | true | ||||||||||
| 01a0a5ec-4e0e-7873-bded-438196ee2105 | NBIS | 2026-09-15 12:35 | call_diagonal_spread | 2 | 1 | 7 | 113022.00 | short | ask | 209.0350 | 4.0500 | ["125","200"] | ["0.9113","0.8941"] | [] | ["XCBO"] | 125.0000 | 200.0000 | 122 | 275 | false | false | true | ||||||||||
| 01a0a57f-921e-7ff2-9f67-3fc18c15c9bf | NBIS | 2026-09-15 10:36 | call_diagonal_spread | 2 | 1 | 10 | 213520.00 | short | ask | 214.3100 | 6.9500 | ["210","310"] | ["0.9305","0.9107"] | [] | ["EDGO"] | 210.0000 | 310.0000 | 822 | 857 | false | false | true | ||||||||||
| 01a0a10e-32f0-71c3-8e50-98dee894a2a4 | NBIS | 2026-09-14 13:54 | call_diagonal_spread | 2 | 1 | 7 | 137774.00 | short | bid | 217.8500 | 4.5500 | ["185","220"] | ["0.9075","0.9150"] | [] | ["XCBO"] | 185.0000 | 220.0000 | 249 | 858 | false | false | true | ||||||||||
| 01a0a0aa-77b0-7f03-8539-89ade7a644bc | NBIS | 2026-09-14 12:05 | call_diagonal_spread | 2 | 1 | 445 | 174440.00 | short | bid | 212.5300 | 0.6600 | ["340","350"] | ["0.9392","0.9189"] | [] | ["XMIO"] | 340.0000 | 350.0000 | 32 | 46 | false | true | true | ||||||||||
| 01a0a060-fb30-70d0-a9de-76689dd7243f | NBIS | 2026-09-14 10:45 | call_diagonal_spread | 2 | 1 | 12 | 125340.00 | short | bid | 214.9750 | 4.5500 | ["200","210"] | ["0.8815","0.8979"] | [] | ["XPHO"] | 200.0000 | 210.0000 | 123 | 158 | false | false | true | ||||||||||
| 01a090cc-22a8-7eb1-9f81-4d8e6bce39f8 | NBIS | 2026-09-11 10:08 | call_diagonal_spread | 2 | 1 | 92 | 476192.00 | long | bid | 227.4900 | 5.5000 | ["202.5","205"] | ["3.4714","0.9277"] | [] | ["XCBO"] | 202.5000 | 205.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a090c8-7d10-7071-ae4c-a6fb843eb201 | NBIS | 2026-09-11 10:04 | call_diagonal_spread | 2 | 1 | 600 | 3116400.00 | short | bid | 227.6005 | 5.8500 | ["202.5","205"] | ["3.4407","0.9278"] | [] | ["XMIO"] | 202.5000 | 205.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a090c5-0659-71d0-b83f-d36db643e536 | NBIS | 2026-09-11 10:00 | call_diagonal_spread | 2 | 1 | 9 | 108774.00 | long | ask | 228.1300 | 4.8500 | ["185","190"] | ["0.9105","0.8940"] | [] | ["XCBO"] | 185.0000 | 190.0000 | 70 | 98 | false | false | true | ||||||||||
| 01a090b9-3ad0-7a32-aa61-3d539e1a0014 | NBIS | 2026-09-11 09:47 | call_diagonal_spread | 2 | 1 | 9 | 305982.00 | short | ask | 228.9400 | 6.0000 | ["30","120"] | ["6.9105","0.9605"] | [] | ["XCBO"] | 30.0000 | 120.0000 | 7 | 462 | false | false | true | ||||||||||
| 01a08bdd-eda8-7d40-b175-e2cdcb72d07c | NBIS | 2026-09-10 11:09 | call_diagonal_spread | 2 | 1 | 130 | 313690.00 | short | bid | 230.2750 | 0.4500 | ["220","227.5"] | ["1.0676","0.8014"] | [] | ["XMIO"] | 220.0000 | 227.5000 | 1 | 8 | false | false | true | ||||||||||
| 01a08267-7938-7ec3-ae3c-0ab37f106c55 | NBIS | 2026-09-08 15:03 | call_diagonal_spread | 2 | 1 | 23 | 471523.00 | short | ask | 246.6500 | 4.9000 | ["250","410"] | ["0.9392","0.9254"] | [] | ["XPHO"] | 250.0000 | 410.0000 | 465 | 829 | false | true | true | ||||||||||
| 01a081f5-b051-77e1-9407-5c03bdb54899 | NBIS | 2026-09-08 12:59 | call_diagonal_spread | 2 | 1 | 10 | 132670.00 | long | ask | 252.9950 | 6.0000 | ["260","270"] | ["0.9670","0.9508"] | [] | ["XCBO"] | 260.0000 | 270.0000 | 164 | 220 | false | true | true | ||||||||||
| 01a081de-7318-7c53-b427-93a543d25b18 | NBIS | 2026-09-08 12:33 | call_diagonal_spread | 2 | 1 | 13 | 380328.00 | short | ask | 249.5100 | 3.5000 | ["80","160"] | ["2.7777","0.9601"] | [] | ["XCBO"] | 80.0000 | 160.0000 | 10 | 282 | false | false | true | ||||||||||
| 01a08149-2c41-78b3-9a4d-3023d9581b8a | NBIS | 2026-09-08 09:50 | call_diagonal_spread | 2 | 1 | 50 | 221400.00 | long | ask | 238.0655 | 4.2000 | ["225","330"] | ["0.9403","0.9578"] | [] | ["XCBO"] | 225.0000 | 330.0000 | 10 | 101 | false | false | true | ||||||||||
| 01a08147-1518-78a0-b84f-d41cac82e528 | NBIS | 2026-09-08 09:48 | call_diagonal_spread | 2 | 1 | 50 | 218950.00 | long | ask | 237.5200 | 4.5000 | ["225","330"] | ["0.9407","0.9592"] | [] | ["XCBO"] | 225.0000 | 330.0000 | 10 | 101 | false | false | true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:31:18Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:56: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-18T19:50: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-18T17:41:42Z"} |
| 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-18T17:01:53Z"} |
| 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-18T16:00:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:25:25Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:44:30Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:30:56Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:49:14Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:57:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:35:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:36:43Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:54:57Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:05:30Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:45:07Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:08:27Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:04:22Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:00:39Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:47:36Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:09:58Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:04:06Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:59:36Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:33:59Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:50:59Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| 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 |