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.

312,778 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 = mlat×net_side = bid×strategy = put_ratio_spread×
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
01a0b615-d1bf-7e31-ab79-9b3bc8ae5c49BMY2026-09-18 15:54put_ratio_spread21576209088.00unknownbid62.77000.7500["45","55"]["0.3687","0.3660"]["36.22","53.78"]["XPHO"]45.000055.0000364364falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:54:41Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b610-8647-7691-a70f-b3f501d6ffedSOXX2026-09-18 15:48put_ratio_spread21510186405.00unknownbid527.20001.2000["490","520"]["0.3742","0.3033"]["463.67","516.33"]["EDGO"]490.0000520.000077falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:48:59Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b60e-a9b7-7601-b465-e1f8e0b0eb7fSPCX2026-09-18 15:46put_ratio_spread214626588.00unknownbid152.73500.1900["110","145"]["0.5792","0.5373"]["133.44"]["AMXO"]110.0000145.00006363falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:46:48Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b606-f50f-7f13-80c0-757f690c4b5aSPX2026-09-18 15:38put_ratio_spread21440930.00longbid7640.33000.9000["5800","6800"]["0.2918","0.2121"]["6730.44"]["XCBO"]5800.00006800.0000154154falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:38:38Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fb-5c4f-7683-8249-c0369398adecSPX2026-09-18 15:25put_ratio_spread212099060.00unknownbid7639.96000.4500["7610","7640"]["0.1075","0.1010"]["7560.50"]["XCBO"]7610.00007640.000077falsefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:26:01Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5b2-6887-75e0-8743-4c447cdda6fcUSO2026-09-18 14:06put_ratio_spread21500243751.00unknownbid154.19810.2800["105","140"]["0.5170","0.4982"]["130.25"]["XMIO"]105.0000140.00009191falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:06:14Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5b0-0ef8-79e1-9cf7-18acba5e44deSNDK2026-09-18 14:03put_ratio_spread2150268800.00unknownbid1742.32501.2000["1660","1720"]["0.6519","0.6494"]["1594.40"]["XISX"]1660.00001720.000077falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:03:58Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b59d-7d0f-7101-8460-b31b8b5c7dc2SPCX2026-09-18 13:43put_ratio_spread2110070900.00unknownbid152.15000.2000["110","150"]["0.5842","0.5327"]["135.82"]["EDGO"]110.0000150.00006363falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:43:46Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b564-f07f-7e83-80de-fbbfd0c60848ORCL2026-09-18 12:41put_ratio_spread221028995.00unknownbid145.09000.6500["145","165"]["0.5540","0.5637"]["122.67"]["XCBO"]145.0000165.00009191falsefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:41:40Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b559-3880-7051-94a6-6ef84ccb2250IWM2026-09-18 12:28put_ratio_spread2111634974.00unknownbid282.69500.2200["282","287"]["0.1178","0.1186"]["279.63","284.37"]["XMIO"]282.0000287.000033falsefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:28:40Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b54c-2ca7-78d3-b731-66d1f3495da7SPY2026-09-18 12:14put_ratio_spread21420559230.00unknownbid759.05000.0500["720","730"]["0.1799","0.1698"]["717.28"]["XPHO"]720.0000730.00006363falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:14:23Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b544-7be7-7f70-af14-0742f7bd6259SPX2026-09-18 12:05put_ratio_spread21631167.00longbid7619.67001.3000["7625","7650"]["0.0839","0.0838"]["7620.25"]["XCBO"]7625.00007650.000033falsefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:06:04Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b539-6bdf-77d0-9d9b-12ef63d4b5f7DIS2026-09-18 11:53put_ratio_spread21750574500.00unknownbid103.20000.8000["90","100"]["0.3063","0.3017"]["88.23"]["XPHO"]90.0000100.0000272272falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:54:13Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b511-90bf-7270-ad3a-c28fc10f0075SNDK2026-09-18 11:10put_ratio_spread21464348.00longbid1715.44001.7000["1730","1815"]["0.6594","0.6739"]["1717.38"]["XCBO"]1730.00001815.000077falsefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:10:52Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4ed-5b37-7b81-8ced-65b0d1118b85URA2026-09-18 10:30put_ratio_spread21375221750.00longbid41.93000.6000["42","47.5"]["0.4665","0.4060"]["42.32"]["XBOX"]42.000047.500077falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:30:58Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4d1-a577-7453-900a-5cff7ea21a59SNDK2026-09-18 10:00put_ratio_spread21471163.00unknownbid1694.690013.3000["1050","1100"]["0.7315","0.7310"]["851.55"]["XCBO"]1050.00001100.0000272272falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:00:34Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4c5-31f7-7153-83c8-8d05c3ab3e82VIX2026-09-18 09:46put_ratio_spread21150001177500.00unknownbid15.20000.0800["16","17"]["0.5480","0.6396"]["15.81"]["XCBO"]16.000017.00003333falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:47:01Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4be-6f80-7b20-bdca-375ed94fac68IWM2026-09-18 09:39put_ratio_spread2128251489234.00unknownbid283.91500.1000["281","285"]["0.1698","0.1533"]["253.47","283.76"]["XISX"]281.0000285.00001212falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:39:39Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4b9-04c7-77f2-a6dc-01fe0b30d331MSFT2026-09-18 09:33put_ratio_spread216028360.00unknownbid495.87504.0400["185","210"]["0.4036","0.3891"]["134.96"]["XCBO"]185.0000210.0000819819falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:33:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0a69c-ba1e-79f3-b58e-74c39890bc0eSPY2026-09-15 15:48put_ratio_spread211659600.00longbid756.87000.5100["772","779"]["0.1431","0.1428"]["755.06"]["MCRY"]772.0000779.00004545falsefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:48:34Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a682-9e86-7fd3-be84-67888c85ffe3SPY2026-09-15 15:19put_ratio_spread21500263397.00longbid757.20000.0600["680","745"]["0.2928","0.1694"]["740.39"]["XMIO"]680.0000745.00001515falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:20:10Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a050-da48-7f02-b122-a0f4c2c9ed5aSNDK2026-09-14 10:27put_ratio_spread21226459.00longbid1554.02501.7000["1570","1635"]["0.7892","0.7971"]["1554.35"]["XCBO"]1570.00001635.000044falsefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T14:27:44Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a024-6379-70f1-8ac3-e75f7a5af1fdSNDK2026-09-14 09:38put_ratio_spread21228311.00longbid1512.05004.7000["1530","1600"]["0.8513","0.8601"]["1513.15"]["XCBO"]1530.00001600.000044falsefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T13:38:53Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a08c67-af48-70d0-8b8f-7e2350482cfdSPY2026-09-10 13:39put_ratio_spread214398661899.00longbid758.08000.0300["690","730"]["0.3204","0.2180"]["728.78"]["XMIO"]690.0000730.000088falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:40:07Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08143-6f81-7230-b59f-773c030e6110QQQ2026-09-08 09:44put_ratio_spread214499726.00longbid717.09000.1900["710","715"]["0.2011","0.1970"]["702.41"]["XISX"]710.0000715.00003838falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:44:44Z"}2026-09-082026-09-08 21:502026-09-08 21:50