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:strategy = put_ratio_spread×ticker = SMH×sorted by executed_at ↑×
idtexttickertextexecuted_at ↑timestamp 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
01a0a55f-86fe-78c0-8e33-d0dd5f8fcaf3SMH2026-09-15 10:01put_ratio_spread221239066.00unknown—547.10003.0000["490","540"]["0.3801","0.3590"][]["ARCO","XISX"]490.0000540.00009494falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:01:57Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a56c-5456-7f93-8317-97d22f66e672SMH2026-09-15 10:15put_ratio_spread22200146400.00unknown—545.08000.5000["535","545"]["0.3973","0.3753"][]["AMXO","XPHO"]535.0000545.000033falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:15:48Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a56c-5456-7f93-8317-97c3a5b39d1cSMH2026-09-15 10:15put_ratio_spread22318235134.00unknown—545.08000.5000["535","545"]["0.3994","0.3791"][]["ARCO","XBOX"]535.0000545.000033falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:15:48Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a56c-5456-7f93-8317-97b54e7a7533SMH2026-09-15 10:15put_ratio_spread2112894080.00unknown—545.08000.5000["535","545"]["0.3981","0.3769"][]["XISX"]535.0000545.000033falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:15:48Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a56c-5456-7f93-8317-983a0844b552SMH2026-09-15 10:15put_ratio_spread225036450.00unknown—545.08000.5000["535","545"]["0.3964","0.3738"][]["ARCO","XBOX"]535.0000545.000033falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:15:48Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a56c-5456-7f93-8317-980b45ac117cSMH2026-09-15 10:15put_ratio_spread226245210.00unknown—545.08000.5000["535","545"]["0.3964","0.3739"][]["ARCO","XBOX"]535.0000545.000033falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:15:48Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a56c-5456-7f93-8317-97ea02f16c84SMH2026-09-15 10:15put_ratio_spread2112289670.00unknown—545.08000.5000["535","545"]["0.3981","0.3769"][]["XMIO"]535.0000545.000033falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:15:48Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a56c-ecad-72c2-acd3-2ec54bd12959SMH2026-09-15 10:16put_ratio_spread214834680.00unknown—545.35000.6500["535","545"]["0.3984","0.3784"][]["XMIO"]535.0000545.000033falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:16:14Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a56c-ecad-72c2-acd3-2ebafd36d97aSMH2026-09-15 10:16put_ratio_spread228057600.00unknown—545.35000.6500["535","545"]["0.3976","0.3772"][]["AMXO","XPHO"]535.0000545.000033falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:16:14Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a56c-ecad-72c2-acd3-2ea76da7c4a7SMH2026-09-15 10:16put_ratio_spread2213296422.00unknown—545.35000.6500["535","545"]["0.4007","0.3825"][]["ARCO","XBOX"]535.0000545.000033falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:16:14Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a56c-ecad-72c2-acd3-2e91533d9b67SMH2026-09-15 10:16put_ratio_spread215237310.00unknown—545.35000.6500["535","545"]["0.3969","0.3759"][]["XISX"]535.0000545.000033falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:16:14Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a667-5a0e-7592-a36d-eced445ed494SMH2026-09-15 14:49put_ratio_spread224061180.00unknown—540.88000.6500["500","535"]["0.3599","0.3320"][]["XISX","XPHO"]500.0000535.00003131falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:50:05Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a66f-2626-7e00-8bd9-a4858b63674eSMH2026-09-15 14:58put_ratio_spread224060240.00unknown—541.43000.8500["500","535"]["0.3597","0.3320"][]["XISX","XPHO"]500.0000535.00003131falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:58:26Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0aaba-f9ab-7b71-9d53-17208f913950SMH2026-09-16 10:59put_ratio_spread2231656030.00unknown—551.16000.2000["525","535"]["0.4931","0.4575"][]["ARCO","XBOX"]525.0000535.000022falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:59:54Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aacd-c243-7ff3-809f-73845c2161efSMH2026-09-16 11:20put_ratio_spread2310001818850.00unknown—550.92501.0500["530","550"]["0.3436","0.3306"][]["XCBO"]530.0000550.00003030falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:20:55Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0b0f0-6c1b-73c2-bfaf-7f19bc1a28faSMH2026-09-17 15:55put_ratio_spread272140904.00unknown—560.95502.5500["460","540"]["0.4105","0.3584"][]["AMXO","ARCO","MCRY","XBOX","XCBO","XMIO","XPHO"]460.0000540.00006464falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:55:56Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0f0-a2cb-74a3-b4c7-fc6084a3134aSMH2026-09-17 15:55put_ratio_spread272446216.00unknown—560.98002.2000["460","540"]["0.4079","0.3566"][]["AMXO","ARCO","EDGO","XCBO","XISX","XMIO","XPHO"]460.0000540.00006464falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:55:56Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b50c-5cb8-7550-9e34-41416a4a28ccSMH2026-09-18 11:04put_ratio_spread2132119088.00unknownbid564.64001.8500["500","560"]["0.3733","0.3511"]["442.99","557.01"]["XCBO"]500.0000560.0000119119falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:04:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b511-f650-7df1-a287-8f7b8ea5aee3SMH2026-09-18 11:10put_ratio_spread2164237984.00unknownbid564.82001.6000["500","560"]["0.3729","0.3525"]["443.25","556.75"]["XCBO"]500.0000560.0000119119falsetruefalsetruefalsemletmarket_whaleuw_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
01a0b51b-ae97-7e91-95f7-daf9d428df37SMH2026-09-18 11:21put_ratio_spread2268254762.00unknownask564.90002.0000["500","560"]["0.3746","0.3550"]["495.02"]["XISX","XPHO"]500.0000560.0000119119falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:21:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b51b-ae97-7e91-95f7-db030ec49f91SMH2026-09-18 11:21put_ratio_spread2132119472.00unknownbid564.90002.0000["500","560"]["0.3743","0.3534"]["443.11","556.89"]["XCBO"]500.0000560.0000119119falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:21:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b559-c137-7f22-9597-4eca3b39ffbeSMH2026-09-18 12:29put_ratio_spread224549740.00unknownask563.30001.0000["535","557.5"]["0.3318","0.3064"]["540.92"]["XISX","XPHO"]535.0000557.50001414falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:29:12Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b56c-d020-79b0-b211-d1a2ca207c15SMH2026-09-18 12:49put_ratio_spread214031230.00unknown—563.68001.3900["430","470"]["0.4407","0.4039"][]["XMIO"]430.0000470.00006363falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:50:02Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b618-f670-7623-9fba-f495b2b4b184SMH2026-09-18 15:58put_ratio_spread23100350320.00unknownbid572.68005.4500["500","560"]["0.3804","0.3596"]["496.65"]["XCBO","XISX","XPHO"]500.0000560.0000119119falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:58:10Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0c459-a606-7a21-a03b-6c7d17f310bdSMH2026-09-21 10:23put_ratio_spread211228374.00unknownbid585.59001.6000["565","595"]["0.3432","0.3315"]["536.77","593.23"]["XISX"]565.0000595.00002525falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:23:24Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4ff-2536-7810-8bac-8858a0bbc633SMH2026-09-21 13:24put_ratio_spread2236127296.00unknownbid592.24001.5000["510","580"]["0.3911","0.3673"]["446.60","573.40"]["XISX","XPHO"]510.0000580.0000116116falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:24:32Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4ff-214e-7bb1-b576-99c7d9aa9bd6SMH2026-09-21 13:24put_ratio_spread211035344.00unknownbid592.24001.5000["510","580"]["0.3911","0.3670"]["446.56","573.44"]["XCBO"]510.0000580.0000116116falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:24:32Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c520-ce67-7ab3-b60e-352684c43f47SMH2026-09-21 14:00put_ratio_spread2352593981.00longbid593.59000.0800["450","500"]["0.5124","0.4227"]["498.83"]["XBOX","XCBO","XISX"]450.0000500.00002525falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:01:21Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c52b-887f-7533-832c-0faf9f70838bSMH2026-09-21 14:12put_ratio_spread26916193154.00unknownbid593.96000.3100["565","590"]["0.3992","0.3082"]["585.78"]["ARCO","C2OX","EDGO","EMLD","XBOX","XISX"]565.0000590.000022truetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:12:57Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c535-e4d7-7302-9aa1-495c2fa3d473SMH2026-09-21 14:23put_ratio_spread2230105250.00unknownask594.69002.0500["510","580"]["0.3951","0.3722"]["509.94"]["XCBO","XPHO"]510.0000580.0000116116falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:24:27Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c543-0437-7410-8bd9-a91ed4c3c92eSMH2026-09-21 14:38put_ratio_spread212070300.00unknownask594.95002.0500["510","580"]["0.3960","0.3735"]["509.90"]["XPHO"]510.0000580.0000116116falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:38:17Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c570-6d36-72d0-b19c-e82f1f2d3b4aSMH2026-09-21 15:27put_ratio_spread213050700.00unknownask596.51000.5000["552.5","587.5"]["0.3638","0.3396"]["562.15"]["XPHO"]552.5000587.50002525falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:28:20Z"}2026-09-212026-09-21 17:152026-09-21 17:15