Simplify Analytics
← Data Explorer

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

executed_at (ET days)to
column equals (exact text)
sort
chart against executed_at
reset
active:code = cbmo×direction = short×net_side = ask×
idtexttickertextexecuted_attimestamp with time zonestrategytextleg_countintegertxnsintegersizebiginttotal_premiumnumericdirectiontextnet_sidetextunderlying_pricenumericbid_ask_spreadnumericstrikesjsonbivsjsonbbreakevensjsonbuniq_exchangesjsonbmin_strikenumericmax_strikenumericmin_dteintegermax_dteintegerall_opening_legsbooleanall_otmbooleandiff_expirationsbooleandiff_strikesbooleandiff_typesbooleancodetextkept_bytextsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
01a0c576-60a7-79f2-83d9-498e389b7943SPX2026-09-21 15:34risk_reversal222502405000.00shortask7774.92000.6000["7800","7850"]["0.1098","0.1028"]["7761.40"]["XCBO"]7800.00007850.00001111falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:34:41Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c575-62be-75b1-91df-2aa79cef3290SPX2026-09-21 15:33synthetic2114580300.00shortask7773.16001.7000["7840"]["0.1362"]["7839.50"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:33:26Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c529-9c4f-7c43-b334-41c0e33f2545SPX2026-09-21 14:10ratio_risk_reversal21300931500.00shortask7763.15000.6000["7650","7900"]["0.1229","0.0983"]["7903.35"]["XCBO"]7650.00007900.00001414falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:10:41Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c51f-5b4f-75c2-acba-79ed17eb7be2SPX2026-09-21 13:59synthetic2440016560000.00shortask7759.78001.6000["7830"]["0.1363"]["7826"]["XCBO"]7830.00007830.00008888truefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:59:34Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c51c-cb0e-7443-b6e2-cccd49a37b67SPX2026-09-21 13:56synthetic23361490400.00shortask7758.77001.8000["7830"]["0.1363"]["7826"]["XCBO"]7830.00007830.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:56:48Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c519-777f-75c0-b246-96ac866e3cecSPX2026-09-21 13:52synthetic22451860750.00shortask7759.71001.8000["7830"]["0.1361"]["7826.50"]["XCBO"]7830.00007830.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:53:08Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c504-2676-7380-975a-b3d538debb10SPX2026-09-21 13:29synthetic21863551800.00shortask7758.01001.7000["7825"]["0.1360"]["7824"]["XCBO"]7825.00007825.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:30:01Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4e3-cd37-79b0-b6af-ba6861ca8849SPX2026-09-21 12:54synthetic2344818524800.00shortask7751.54001.6000["7820"]["0.1362"]["7817.50"]["XCBO"]7820.00007820.00008888truefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:54:47Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4de-b487-73e2-b2ff-301fe430e8cfSPX2026-09-21 12:48ratio_risk_reversal21100241250.00shortask7751.98000.6000["7660","7860"]["0.1189","0.0972"]["7647.12"]["XCBO"]7660.00007860.000088falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:49:18Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4cb-76bf-7de3-ba2b-c07a9d5ce920SPX2026-09-21 12:27synthetic231506210000.00shortask7750.06001.5000["7815"]["0.1364"]["7814"]["XCBO"]7815.00007815.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:28:06Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4c5-6fc6-71e1-b06d-2a39232b1013SPX2026-09-21 12:21synthetic231204960800.00shortask7746.50001.5000["7815"]["0.1363"]["7812"]["XCBO"]7815.00007815.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:21:14Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c478-3a27-7b02-ab2e-c631889a7d72SPX2026-09-21 10:56synthetic21773141600.00shortask7721.49001.4000["7790"]["0.1350"]["7788"]["XCBO"]7790.00007790.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:56:58Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c44c-925f-7a10-a88a-3e29ef22d4bdSPX2026-09-21 10:09synthetic2112490800.00shortask7704.32001.5000["7775"]["0.1356"]["7770"]["XCBO"]7775.00007775.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:09:13Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0b619-7370-79d2-81b8-641a5e6732e5SPX2026-09-18 15:58risk_reversal21150244350.00shortask7645.60000.7000["7000","8000"]["0.2126","0.0964"]["6993.81"]["XCBO"]7000.00008000.00002828falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:58:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b616-d38f-76e1-9f5a-fbc3254f23c9SPX2026-09-18 15:55ratio_risk_reversal21200214000.00shortask7648.50000.4000["7400","7800"]["0.1505","0.0803"]["7800.50"]["XCBO"]7400.00007800.00001212falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:55:48Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5aa-7560-74c1-bf86-bfc097976c7fSPX2026-09-18 13:57ratio_risk_reversal22600313500.00shortask7628.47000.2000["7550","7700"]["0.1094","0.0709"]["7701.18"]["XCBO"]7550.00007700.000044falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:57:28Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b59e-211f-70e1-bec4-d55101ee998cSPX2026-09-18 13:43synthetic21251045850.00shortask7626.87001.4000["7700"]["0.1378"]["7692"]["XCBO"]7700.00007700.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:44:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b57a-8007-7690-8f96-b6d9f127d1d7SPX2026-09-18 13:04ratio_risk_reversal211001747000.00shortask7624.13001.6000["7690","7900"]["0.1439","0.1224"]["7939.66"]["XCBO"]7690.00007900.00009191falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:05:23Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b541-8618-7751-abcf-99ec0c26fc5bSPX2026-09-18 12:02synthetic2215633750.00shortask7619.34001.4000["7685"]["0.1393"]["7682.50"]["XCBO"]7685.00007685.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:03:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b541-8618-7751-abcf-98ae6ec1989bSPX2026-09-18 12:02ratio_risk_reversal225001646250.00shortask7619.34000.6000["7520","7720"]["0.1267","0.0872"]["7501.32"]["XCBO"]7520.00007720.00001111truetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:03:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4f1-e35f-7f23-8886-6c2ec20452f9SPX2026-09-18 10:35synthetic211004196000.00shortask7622.92001.4000["7700"]["0.1382"]["7687.60"]["XCBO"]7700.00007700.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:36:04Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4f1-e35f-7f23-8886-6993b572156bSPX2026-09-18 10:35synthetic211001688000.00shortask7622.92001.1000["7700"]["0.1105"]["7636.40"]["XCBO"]7700.00007700.00002121falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:36:04Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0fb-8fab-7781-8ff5-015c40406114SPX2026-09-17 16:07synthetic21501015000.00shortask7637.76002.0000["7700"]["0.1166"]["7659"]["XCBO"]7700.00007700.00002929falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T20:10:19Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0fb-8fab-7781-8ff5-00e16e30240cSPX2026-09-17 16:07synthetic2150635000.00shortask7637.76000.8000["7700"]["0.1040"]["7645"]["XCBO"]7700.00007700.00001313falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T20:10:19Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0f1-bff4-7000-af22-81d5d3e3856eSPX2026-09-17 15:57synthetic2120117480.00shortask7643.01004.2500["7700"]["0.0968"]["7644.04"]["XCBO"]7700.00007700.000011falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:57:28Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0f1-bff3-7070-a49d-a06b01b946b6SPX2026-09-17 15:57synthetic2120253800.00shortask7643.01000.9000["7700"]["0.1051"]["7650.54"]["XCBO"]7700.00007700.00001313falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:57:28Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0d9-697b-7f61-8f4f-e543609f6843SPX2026-09-17 15:30synthetic21552326500.00shortask7638.21001.5000["7710"]["0.1383"]["7707"]["XCBO"]7710.00007710.00009292falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:30:58Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0d9-697b-7f61-8f4f-e3e5b8a26599SPX2026-09-17 15:30risk_reversal21250168250.00shortask7638.21000.1500["7550","7700"]["0.1880","0.1214"]["7548.19"]["XCBO"]7550.00007700.000011falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:30:58Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0c9-fc43-7133-bfb4-ad8f95d6210aSPX2026-09-17 15:13put_calendar21150136500.00shortask7639.28000.2000["7400"]["0.2311"][]["XCBO"]7400.00007400.000018falsetruetruefalsefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:14:03Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0ac-eadb-7f03-97c0-0992aa6926f5SPX2026-09-17 14:41synthetic2118761400.00shortask7634.29001.3000["7705"]["0.1384"]["7704"]["XCBO"]7705.00007705.00009292falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:42:34Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b06d-6cf3-75d2-b6af-31bac8373db0SPX2026-09-17 13:32synthetic23502120000.00shortask7632.25001.3000["7705"]["0.1388"]["7701"]["XCBO"]7705.00007705.00009292falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:32:57Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afeb-1d94-73f3-9afc-f46e22bee9f0SPX2026-09-17 11:10synthetic22361532160.00shortask7618.45001.6000["7700"]["0.1395"]["7685"]["XCBO"]7700.00007700.00009292falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:10:19Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afe7-fccb-79c1-85a0-406b1da0fc74SPX2026-09-17 11:06risk_reversal21200017176000.00shortask7616.90001.0000["7000","8000"]["0.2051","0.1155"]["6994.62"]["XCBO"]7000.00008000.00006464falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:07:01Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afca-eb64-7301-8bfb-27c08558ba6dSPX2026-09-17 10:35synthetic214170400.00shortask7631.34001.5000["7700"]["0.1395"]["7698"]["XCBO"]7700.00007700.00009292falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:35:17Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afca-81ec-7031-89ba-99c57e9ffd5eSPX2026-09-17 10:34synthetic2222937200.00shortask7630.69001.7000["7700"]["0.1395"]["7698"]["XCBO"]7700.00007700.00009292falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:34:47Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0abc5-c674-74f3-b410-34dc47d60fcbSPX2026-09-16 15:50ratio_risk_reversal213003011400.00shortask7548.57002.1000["7600","7900"]["0.1552","0.1241"]["7973.86"]["XCBO"]7600.00007900.00009393falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:51:15Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab5d-e0cb-7240-bd37-472fc4c82f69SPX2026-09-16 13:57synthetic213131550.00shortask7609.65002.1000["7680"]["0.1432"]["7679.50"]["XCBO"]7680.00007680.00009393falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:58:03Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aae3-a3d3-7ca3-bef6-1a84802c2862SPX2026-09-16 11:43risk_reversal21300757500.00shortask7615.97000.6000["7000","8000"]["0.2230","0.1069"]["6988.75"]["XCBO"]7000.00008000.00003030falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:44:18Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aae3-a3d3-7ca3-bef6-1a7267e758e2SPX2026-09-16 11:43risk_reversal215001262500.00shortask7615.97000.6000["7000","8000"]["0.2230","0.1069"]["6988.75"]["XCBO"]7000.00008000.00003030falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:44:18Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aae1-9863-72e3-865c-62a1a8126944SPX2026-09-16 11:41ratio_risk_reversal22250934700.00shortask7615.70000.4800["7500","7750"]["0.1655","0.1169"]["7473.95"]["XCBO"]7500.00007750.000099falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:42:10Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aada-ba92-76e0-a4a3-5df122b48be1SPX2026-09-16 11:34ratio_risk_reversal225001228000.00shortask7611.72000.5000["7450","7800"]["0.1646","0.1064"]["7443.60"]["XCBO"]7450.00007800.00001414falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:34:43Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aac0-0a8b-70d0-9994-50cb52dae22dSPX2026-09-16 11:05ratio_risk_reversal21401099720.00shortask7616.12001.8000["7680","7700"]["0.1474","0.1375"]["7844.73"]["XCBO"]7680.00007700.00009393falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:05:13Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a657-19e6-72e1-9e7d-eacb7985c220SPX2026-09-15 14:31synthetic226267000.00shortask7585.10001.4000["7660"]["0.1450"]["7655"]["XCBO"]7660.00007660.00009494falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:32:10Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a637-d216-7331-9948-6a3e0f6001c7SPX2026-09-15 13:57risk_reversal212501025750.00shortask7584.86000.4000["7520","7715"]["0.1598","0.1171"]["7495.03"]["XCBO"]7520.00007715.000066falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:58:07Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a61c-9955-7052-becc-9857e1ef419fSPX2026-09-15 13:28synthetic219403200.00shortask7580.09001.7000["7655"]["0.1461"]["7649"]["XCBO"]7655.00007655.00009494falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:28:07Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5b0-a886-70d0-b0e2-aa39a9b0ae84SPX2026-09-15 11:30risk_reversal234002741600.00shortask7586.51000.4000["7570","7800"]["0.1512","0.1109"]["7510.66"]["XCBO"]7570.00007800.00001010falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:30:43Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a15b-7830-7333-a427-0438001809aeSPX2026-09-14 15:18synthetic212169555840.00shortask7631.41001.7000["7705"]["0.1425"]["7703"]["XCBO"]7705.00007705.00009595falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:18:53Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a130-d620-7111-8b40-10c76533c2eaSPX2026-09-14 14:32synthetic213133200.00shortask7632.93001.8000["7705"]["0.1430"]["7704"]["XCBO"]7705.00007705.00009595falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:32:40Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a11c-5fd9-7ae0-8322-ba31bae7ea54SPX2026-09-14 14:09synthetic23994392630.00shortask7637.84001.8000["7710"]["0.1428"]["7706.50"]["XCBO"]7710.00007710.00009595falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:09:45Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0c3-52f8-7433-b9bc-92e3e644d1c3SPX2026-09-14 12:32ratio_risk_reversal21100010114000.00shortask7635.57001.6000["7705","8000"]["0.1473","0.1225"]["8070.06"]["XCBO"]7705.00008000.00009595falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T16:32:58Z"}2026-09-142026-09-14 17:152026-09-14 17:15