Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5d8-20c7-7640-bc17-56b3629e0959 | SPX | 2026-09-18 14:47 | call_frontspread | 2 | 3 | 150 | 1796940.00 | long | bid | 7642.4400 | 1.4000 | ["7630","8000"] | ["0.1141","0.0988"] | ["7740.20"] | ["XCBO"] | 7630.0000 | 8000.0000 | 28 | 28 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:47:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c9-3937-7ef3-a7ca-438b2df668b6 | SPX | 2026-09-18 09:51 | call_frontspread | 2 | 2 | 1000 | 277600.00 | long | bid | 7633.2000 | 0.1000 | ["7660","7670"] | ["0.1291","0.1338"] | ["7661.44"] | ["XCBO"] | 7660.0000 | 7670.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:51:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b00b-9de2-7042-8698-2e9170071cf4 | SPX | 2026-09-17 11:45 | call_frontspread | 2 | 2 | 150 | 114300.00 | long | bid | 7634.5800 | 0.3000 | ["7640","7645"] | ["0.1157","0.1161"] | ["7643.18"] | ["XCBO"] | 7640.0000 | 7645.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:46:14Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0affe-8653-71c1-a0f9-1d3b3f9fda58 | SPX | 2026-09-17 11:31 | call_frontspread | 2 | 3 | 300 | 36300.00 | long | bid | 7628.0300 | 0.2000 | ["7655","7675"] | ["0.1214","0.1488"] | ["7655.79"] | ["XCBO"] | 7655.0000 | 7675.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:31:28Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afdf-cf0a-79c1-925a-adea704035c4 | SPX | 2026-09-17 10:57 | call_frontspread | 2 | 2 | 300 | 63000.00 | long | bid | 7619.8300 | 0.1000 | ["7645","7665"] | ["0.1301","0.1454"] | ["7646.50"] | ["XCBO"] | 7645.0000 | 7665.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:57:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb2-42e3-73a1-b479-f5db925cf27e | SPX | 2026-09-17 10:08 | call_frontspread | 2 | 1 | 1485 | 79785.00 | long | bid | 7613.0400 | 0.1000 | ["7765","7855"] | ["0.1756","0.2406"] | ["7765.28"] | ["XCBO"] | 7765.0000 | 7855.0000 | 1 | 1 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:08:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afae-4372-7ab1-8189-13d1ae0f2837 | SPX | 2026-09-17 10:03 | call_frontspread | 2 | 2 | 1500 | 72000.00 | long | bid | 7616.4800 | 0.1500 | ["7765","7855"] | ["0.1721","0.2375"] | ["7765.34"] | ["XCBO"] | 7765.0000 | 7855.0000 | 1 | 1 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:03:52Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab29-ec03-75f3-bf76-835f394226f9 | SPX | 2026-09-16 13:00 | call_frontspread | 2 | 1 | 1500 | 48900.00 | long | bid | 7607.5100 | 0.1500 | ["7790","7890"] | ["0.1934","0.2571"] | ["7790.19"] | ["XCBO"] | 7790.0000 | 7890.0000 | 1 | 1 | true | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:01:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab1f-4d43-7611-b7d8-8a8ae87e5c1e | SPX | 2026-09-16 12:49 | call_frontspread | 2 | 2 | 2000 | 58000.00 | long | bid | 7612.6700 | 0.1500 | ["7800","7900"] | ["0.1947","0.2527"] | ["7800.17"] | ["XCBO"] | 7800.0000 | 7900.0000 | 1 | 1 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:50:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa73-daa3-7451-a4f7-dd6016ddf6bc | SPX | 2026-09-16 09:41 | call_frontspread | 2 | 3 | 1500 | 68400.00 | long | bid | 7599.3900 | 0.1500 | ["7780","7870"] | ["0.2002","0.2578"] | ["7780.26"] | ["XCBO"] | 7780.0000 | 7870.0000 | 1 | 1 | true | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:41:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a690-7966-7840-b9d9-ad6c0a9e8fb9 | SPX | 2026-09-15 15:34 | call_frontspread | 2 | 2 | 106 | 376250.00 | long | bid | 7580.5000 | 0.4000 | ["7640","7650"] | ["0.1690","0.1666"] | ["7653.55"] | ["XCBO"] | 7640.0000 | 7650.0000 | 3 | 3 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:35:06Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a621-7b56-7f13-9bbd-bab92d9c7731 | SPX | 2026-09-15 13:33 | call_frontspread | 2 | 2 | 1500 | 611500.00 | long | bid | 7582.7000 | 0.6500 | ["8650","9200"] | ["0.1169","0.1374"] | ["8653.22"] | ["XCBO"] | 8650.0000 | 9200.0000 | 94 | 94 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:33:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60d-66b6-7390-bc68-12974ed5479c | EXPE | 2026-09-15 13:11 | call_frontspread | 2 | 2 | 1711 | 8294141.00 | long | bid | 292.8600 | 7.1000 | ["250","280"] | ["1.3592","0.5448"] | ["291.66"] | ["XCBO"] | 250.0000 | 280.0000 | 3 | 3 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:12:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a56b-9cbd-7b02-b674-e64d0e25efba | SPX | 2026-09-15 10:14 | call_frontspread | 2 | 3 | 1000 | 287000.00 | long | bid | 7592.2200 | 0.1000 | ["7620","7630"] | ["0.1383","0.1447"] | ["7621.43"] | ["XCBO"] | 7620.0000 | 7630.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:14:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a173-78b8-7bc1-98d0-174e2697aeaf | SPX | 2026-09-14 15:44 | call_frontspread | 2 | 4 | 750 | 292500.00 | unknown | — | 7628.3700 | 0.1500 | ["7675","7685"] | ["0.1039","0.1041"] | [] | ["XCBO"] | 7675.0000 | 7685.0000 | 1 | 1 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:45:01Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a09b-c5f8-7de3-877d-bba16cc181ed | SPX | 2026-09-14 11:49 | call_frontspread | 2 | 3 | 1000 | 429000.00 | long | bid | 7630.9300 | 0.1500 | ["7645","7655"] | ["0.1279","0.1345"] | ["7647.31"] | ["XCBO"] | 7645.0000 | 7655.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:49:47Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a05b-e668-7cf2-8fa3-7390ff257c07 | SPX | 2026-09-14 10:39 | call_frontspread | 2 | 2 | 114 | 14310496.00 | long | bid | 7596.3100 | 10.3500 | ["6600","7175"] | ["0.5482","0.3070"] | ["7595.94"] | ["XCBO"] | 6600.0000 | 7175.0000 | 4 | 4 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:39:35Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a026-ff70-7c32-af7e-441c0745faa0 | SPX | 2026-09-14 09:41 | call_frontspread | 2 | 1 | 376 | 59680.00 | unknown | — | 7603.1000 | 0.2000 | ["7645","7650"] | ["0.1425","0.1477"] | [] | ["XCBO"] | 7645.0000 | 7650.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:41:47Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091fb-a1f8-7dc0-a30c-cd84cf140754 | SPX | 2026-09-11 15:39 | call_frontspread | 2 | 3 | 200 | 555400.00 | unknown | — | 7663.1300 | 0.4000 | ["7665","7670"] | ["0.0651","0.0643"] | [] | ["XCBO"] | 7665.0000 | 7670.0000 | 3 | 3 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:39:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0916f-7ef8-72f3-a751-77e3d5ddede4 | PBF | 2026-09-11 13:06 | call_frontspread | 2 | 3 | 1000 | 340800.00 | long | bid | 79.1400 | 1.2500 | ["80","85"] | ["0.6747","0.7843"] | ["81.75"] | ["XCBO"] | 80.0000 | 85.0000 | 7 | 7 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:06:41Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09152-cf38-7c92-812c-1efe4ed51aac | SPX | 2026-09-11 12:35 | call_frontspread | 2 | 2 | 1500 | 563500.00 | long | bid | 7669.2400 | 0.5500 | ["8800","9400"] | ["0.1178","0.1414"] | ["8803.20"] | ["XCBO"] | 8800.0000 | 9400.0000 | 98 | 98 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:36:07Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09112-f390-72d3-9277-aeff35f1afc1 | SPX | 2026-09-11 11:25 | call_frontspread | 2 | 2 | 1485 | 53163.00 | long | bid | 7671.4300 | 0.2000 | ["7775","7825"] | ["0.0677","0.0867"] | ["7775.20"] | ["XCBO"] | 7775.0000 | 7825.0000 | 3 | 3 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:25:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0910b-6dc8-71f2-a4de-47e1a0b5b01b | SPX | 2026-09-11 11:17 | call_frontspread | 2 | 3 | 298 | 39010.00 | long | bid | 7666.9300 | 0.1000 | ["7695","7715"] | ["0.1244","0.1470"] | ["7695.89"] | ["XCBO"] | 7695.0000 | 7715.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:17:44Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08bee-1a48-7c33-8e43-765eb38646ba | SPX | 2026-09-10 11:27 | call_frontspread | 2 | 4 | 200 | 486240.00 | long | bid | 7606.3600 | 0.6000 | ["7700","7870"] | ["0.1257","0.1157"] | ["7722.73"] | ["XCBO"] | 7700.0000 | 7870.0000 | 8 | 8 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:27:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bbb-eaa0-7e60-9fde-70dc96e5cbd1 | VIX | 2026-09-10 10:32 | call_frontspread | 2 | 1 | 300 | 71700.00 | unknown | — | 17.4100 | 0.1200 | ["18.5","19"] | ["1.0932","1.1132"] | [] | ["XCBO"] | 18.5000 | 19.0000 | 41 | 41 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:32:47Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bbb-eaa0-7e60-9fde-70cb1a9a8578 | VIX | 2026-09-10 10:32 | call_frontspread | 2 | 1 | 1500 | 358500.00 | unknown | — | 17.4100 | 0.1200 | ["18.5","19"] | ["1.0932","1.1132"] | [] | ["XCBO"] | 18.5000 | 19.0000 | 41 | 41 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:32:47Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb6-a310-7ef1-955e-909622c4384d | SPX | 2026-09-10 10:26 | call_frontspread | 2 | 3 | 3000 | 132000.00 | long | bid | 7605.0900 | 0.1500 | ["7760","7860"] | ["0.1747","0.2427"] | ["7760.26"] | ["XCBO"] | 7760.0000 | 7860.0000 | 1 | 1 | true | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:26:49Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb1-b940-7150-9477-116fd20a953e | SPX | 2026-09-10 10:21 | call_frontspread | 2 | 4 | 2975 | 82110.00 | long | bid | 7595.5900 | 0.1500 | ["7775","7875"] | ["0.1858","0.2550"] | ["7775.14"] | ["XCBO"] | 7775.0000 | 7875.0000 | 1 | 1 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:21:15Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb1-1d00-7fd1-a80e-f93d980cef8e | SPX | 2026-09-10 10:20 | call_frontspread | 2 | 2 | 2985 | 97311.00 | long | bid | 7594.9600 | 0.1500 | ["7765","7865"] | ["0.1822","0.2475"] | ["7765.19"] | ["XCBO"] | 7765.0000 | 7865.0000 | 1 | 1 | true | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:20:47Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8a-b110-7920-a3c3-812f0dc55a5f | SPX | 2026-09-10 09:38 | call_frontspread | 2 | 4 | 1000 | 101000.00 | long | bid | 7596.0200 | 0.1500 | ["7650","7725"] | ["0.1707","0.2487"] | ["7650.89"] | ["XCBO"] | 7650.0000 | 7725.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:38:38Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b87-9c01-7612-a818-c569b0c3c972 | SPX | 2026-09-10 09:35 | call_frontspread | 2 | 2 | 2000 | 635000.00 | unknown | — | 7592.8000 | 0.8000 | ["8400","8800"] | ["0.1206","0.1388"] | [] | ["XCBO"] | 8400.0000 | 8800.0000 | 57 | 57 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:35:26Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08685-8140-7f23-8f88-0d95354907a9 | SPX | 2026-09-09 10:14 | call_frontspread | 2 | 2 | 1495 | 34086.00 | long | bid | 7653.5100 | 0.1500 | ["7790","7875"] | ["0.1426","0.1995"] | ["7790.13"] | ["XCBO"] | 7790.0000 | 7875.0000 | 1 | 1 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:15:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08680-31e0-78f2-a26e-da1de666d3d5 | SPX | 2026-09-09 10:09 | call_frontspread | 2 | 1 | 3000 | 66000.00 | long | bid | 7655.9100 | 0.1500 | ["7790","7875"] | ["0.1404","0.1975"] | ["7790.14"] | ["XCBO"] | 7790.0000 | 7875.0000 | 1 | 1 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:09:26Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08197-2d01-7992-a272-9dc20ce5818c | SPX | 2026-09-08 11:16 | call_frontspread | 2 | 2 | 2999 | 68374.00 | long | bid | 7697.5300 | 0.1500 | ["7835","7925"] | ["0.1427","0.2031"] | ["7835.13"] | ["XCBO"] | 7835.0000 | 7925.0000 | 1 | 1 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:16:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0815f-7f18-7552-9dd9-f473f9de7899 | SPX | 2026-09-08 10:15 | call_frontspread | 2 | 4 | 800 | 229600.00 | long | bid | 7680.1200 | 0.1000 | ["7705","7715"] | ["0.1272","0.1349"] | ["7706.43"] | ["XCBO"] | 7705.0000 | 7715.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:15:28Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08147-f7a8-7a31-9e8b-579831d62108 | DINO | 2026-09-08 09:49 | call_frontspread | 2 | 3 | 1000 | 534000.00 | long | bid | 109.1299 | 1.3500 | ["110","115"] | ["0.5279","0.5938"] | ["111.56"] | ["XCBO"] | 110.0000 | 115.0000 | 10 | 10 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:49:41Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |