Simplify Analytics
← Data Explorer

Options flow alerts (market-wide)

core.flow_alerts

Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

created_at (ET days)to
column equals (exact text)
sort
chart against created_at
reset
active:ticker = CLX×sorted by created_at ↑×
iduuidcreated_attimestamp with time zonestart_timetimestamp with time zoneend_timetimestamp with time zonetickertextoption_symboltextoption_typetextstrikenumericexpirydatepricenumericbidnumericasknumericunderlying_pricenumerictotal_premiumnumerictotal_ask_side_premnumerictotal_bid_side_premnumerictotal_sizebiginttrade_countintegervolumebigintopen_interestbigintvolume_oi_rationumericiv_startnumericiv_endnumerichas_sweepbooleanhas_floorbooleanhas_multilegbooleanhas_singlelegbooleanall_opening_tradesbooleanalert_ruletextrule_iduuidexpiry_countintegerissue_typetextsectortextmarketcapnumericnext_earnings_datedateer_timetextmissing_periscopebooleansourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
5fbde667-06cd-4b62-924e-0b7b838e3a392026-09-10 12:512026-09-10 12:502026-09-10 12:50CLXCLX280121C00110000call110.00002028-01-215.40005.40006.700089.000054000.000.0054000.00100131002360.4237288135593220.2481169917798160.248116991779816falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknowntrueuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-10T17:02:16.286608Z"}2026-09-152026-09-15 08:452026-09-15 08:45
b650067a-1f03-41d5-853c-07b6170c389e2026-09-10 14:592026-09-10 14:582026-09-10 14:58CLXCLX260918P00090000put90.00002026-09-182.20002.05002.200088.9250110000.00110000.000.00500176913460.5713224368499260.3127709086042390.312770908604239falsetruefalsetruefalseFloorTradeLargeCap85cc2f90-fef8-4e3c-8c5c-01d1ead51af11Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"}2026-09-152026-09-15 08:452026-09-15 08:45
b8773890-f074-4d13-b710-8cdb9e298b772026-09-10 15:222026-09-10 15:222026-09-10 15:22CLXCLX270115C00105000call105.00002027-01-152.10001.90002.100088.640032128.0032128.000.001533320611630.1771281169389510.3212483006849890.321248300684989falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-10T19:25:57.950009Z"}2026-09-152026-09-15 08:452026-09-15 08:45
e0608c58-0e8c-4fda-bc92-34d920205afd2026-09-11 09:532026-09-11 09:532026-09-11 09:53CLXCLX270115C00085000call85.00002027-01-157.40007.40007.800086.000044400.000.0044400.00605661780.3707865168539330.3038464044380060.303846404438006falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknowntrueuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"}2026-09-152026-09-15 08:452026-09-15 08:45
2da835fa-1667-45fe-8148-b2f1ba8c67de2026-09-11 10:002026-09-11 10:002026-09-11 10:00CLXCLX260918C00085000call85.00002026-09-182.00002.00002.650085.875010600.000.0010600.00535146393.743589743589740.3144593221637010.314459322163701falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-11T14:11:33.656123Z"}2026-09-152026-09-15 08:452026-09-15 08:45
6bb9c2e4-557f-430e-b382-00f34b7072c62026-09-11 10:032026-09-11 10:032026-09-11 10:03CLXCLX270115P00075000put75.00002027-01-152.40002.20002.400085.925086629.0086629.000.003613437812490.3026421136909530.3602807326244080.360280732624408falsefalsefalsetruefalseRepeatedHitsDescendingFill5ce5ec11-087c-4c00-b164-08106b0158561Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-11T14:11:33.656123Z"}2026-09-152026-09-15 08:452026-09-15 08:45
9c3af1ec-36de-48bd-b788-900b8aff29ba2026-09-11 10:062026-09-11 10:062026-09-11 10:06CLXCLX260918P00085000put85.00002026-09-181.10000.95001.200085.810011550.00110.0011440.00105151739550.1811518324607330.3172967429235210.317296742923521truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-11T14:11:33.656123Z"}2026-09-152026-09-15 08:452026-09-15 08:45
296d9974-cd10-4fba-b595-f6e7595cfe5f2026-09-11 11:052026-09-11 11:052026-09-11 11:05CLXCLX260918P00085000put85.00002026-09-181.10001.00001.200085.840019360.002420.0016940.00176124509550.4712041884816750.3199014746006970.319901474600697falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"}2026-09-152026-09-15 08:452026-09-15 08:45
6cb1c248-f265-4dd0-8495-f4df33d46f042026-09-11 11:232026-09-11 11:232026-09-11 11:23CLXCLX270115C00085000call85.00002027-01-157.30007.20007.500085.910067160.0066430.00730.0092171851781.039325842696630.3154226129109330.315422612910933falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-11T15:28:46.184785Z"}2026-09-152026-09-15 08:452026-09-15 08:45
34ff0adb-61b1-46ea-afaa-b446d457dfbc2026-09-11 14:182026-09-11 14:182026-09-11 14:18CLXCLX261016P00085000put85.00002026-10-162.00001.65002.100087.8700196006.00200.00195806.0098047155018060.8582502768549280.3127879033354150.315325091146624falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"}2026-09-152026-09-15 08:452026-09-15 08:45
a687ee6e-9479-4f8b-ad72-efec14569ea62026-09-14 09:592026-09-14 09:592026-09-14 09:59CLXCLX270115P00095000put95.00002027-01-1510.77009.900011.000088.701953844.0053844.000.005055014230.03513703443429370.3806156262722830.380615626272283falsefalsefalsetruefalseRepeatedHitsAscendingFilla0979b52-28e4-4585-8f22-881faad2dd8e1Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"}2026-09-152026-09-15 08:452026-09-15 08:45
ee917a66-a0a3-4a06-812b-98f2f451e6612026-09-14 10:202026-09-14 10:202026-09-14 10:20CLXCLX270319P00100000put100.00002027-03-1916.000014.500016.800088.0000302400.00134400.00168000.0018983506860.5102040816326530.4128351338907110.412835133890711falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknowntrueuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"}2026-09-152026-09-15 08:452026-09-15 08:45
90f986dc-b232-4559-a026-e55ba339f6962026-09-14 11:062026-09-14 11:062026-09-14 11:06CLXCLX260918C00090000call90.00002026-09-181.05000.85001.150089.100047762.0043982.003780.00455435285071.04142011834320.3851022864165380.385102286416538falsefalsefalsetruefalseRepeatedHitsDescendingFill5ce5ec11-087c-4c00-b164-08106b0158561Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"}2026-09-152026-09-15 08:452026-09-15 08:45
4164aacc-99ce-496b-89ab-b295652e47aa2026-09-14 15:452026-09-14 15:452026-09-14 15:45CLXCLX270416P00075000put75.00002027-04-163.40003.30003.400089.000010200.0010200.000.003011721840.3801649907581340.380164990758134falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknowntrueuw_flow_alerts/api/option-trades/flow-alerts{"limit":500}2026-09-152026-09-15 08:452026-09-15 08:45
2e792da9-8f90-4717-b1f0-e6bf27901c322026-09-15 11:282026-09-15 11:282026-09-15 11:28CLXCLX261016P00090000put90.00002026-10-164.29004.00004.300088.165024015.0024015.000.0056713023350.05567451820128480.3351914074509440.327321202944002falsefalsefalsetruefalseRepeatedHitsAscendingFilla0979b52-28e4-4585-8f22-881faad2dd8e1Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"}2026-09-152026-09-15 21:152026-09-15 21:15
cec45d7c-3610-4ee4-b0c2-c05cb5d7120e2026-09-16 10:452026-09-16 10:452026-09-16 10:45CLXCLX261016C00090000call90.00002026-10-161.90001.85001.950086.430057950.0044650.008360.00305123413291.036474164133740.3260328960205690.326032896020569falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10262205084.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"}2026-09-162026-09-16 21:152026-09-16 21:15
7832a4b9-c65f-466a-a21c-317fb7457deb2026-09-16 13:282026-09-16 13:282026-09-16 13:28CLXCLX270416C00100000call100.00002027-04-164.20004.10004.300086.280027300.0015120.0012180.00655811120.7232142857142860.3116448746625370.311644874662537falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10262205084.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"}2026-09-162026-09-16 21:152026-09-16 21:15
25a60745-f609-49cd-a2aa-c0d93eae267c2026-09-16 14:012026-09-16 14:012026-09-16 14:01CLXCLX260918P00085000put85.00002026-09-180.50000.20000.550085.000012000.0012000.000.00240832612860.2534992223950230.3432387357651210.343238735765121falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10262205084.002026-11-02unknowntrueuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"}2026-09-162026-09-16 21:152026-09-16 21:15
44d6ffe8-578a-466d-8065-e4ff46f571fe2026-09-16 15:102026-09-16 15:102026-09-16 15:10CLXCLX261016C00095000call95.00002026-10-160.60000.60000.650085.570018843.000.0018843.003143761016070.3795892968263850.326808428423610.32680842842361falsefalsefalsetruefalseRepeatedHitsAscendingFilla0979b52-28e4-4585-8f22-881faad2dd8e1Common StockConsumer Defensive10262205084.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"}2026-09-162026-09-16 21:152026-09-16 21:15
fd39074d-644e-4989-8a2c-fe4d91811f062026-09-17 13:172026-09-17 13:172026-09-17 13:17CLXCLX261120C00085000call85.00002026-11-204.60004.50004.600084.410013800.0013800.000.0030890000.3256397082028870.325639708202887falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10279135425.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"}2026-09-172026-09-17 21:152026-09-17 21:15
20c8aea7-bfa1-46d4-af75-7437302eccc12026-09-17 14:592026-09-17 14:582026-09-17 14:58CLXCLX261120C00085000call85.00002026-11-205.00004.70005.000085.130050000.0050000.000.0010017193000.3264124860793540.326412486079354falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10279135425.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"}2026-09-172026-09-17 21:152026-09-17 21:15
367b9cf9-eb98-4cae-83e2-f864e2f1c6552026-09-17 15:122026-09-17 15:112026-09-17 15:11CLXCLX261120C00090000call90.00002026-11-203.10003.10003.200085.110012400.000.0012400.0040897000.3388380543404230.338838054340423falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10279135425.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-17T19:28:01.580099Z"}2026-09-172026-09-17 21:152026-09-17 21:15
13f2490f-e7ee-4488-bdc3-63267b7f2db92026-09-17 15:272026-09-17 15:272026-09-17 15:27CLXCLX261120C00090000call90.00002026-11-203.10002.95003.100085.230061993.0061993.000.0020028427000.3353922523125220.335392252312522falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10279135425.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-17T19:28:01.580099Z"}2026-09-172026-09-17 21:152026-09-17 21:15
5337d3e5-64b7-4337-a585-91dd327150612026-09-18 14:172026-09-18 14:172026-09-18 14:17CLXCLX260918P00090000put90.00002026-09-186.43005.90006.500083.600011572.0011572.000.00187426340.06624605678233442.528809461093822.52880946109382falsefalsefalsetruefalseRepeatedHitsAscendingFilla0979b52-28e4-4585-8f22-881faad2dd8e1Common StockConsumer Defensive10049366516.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"}2026-09-182026-09-18 21:152026-09-18 21:15
bd9bdcf8-5a79-4b80-93bb-f0579e525f152026-09-18 15:532026-09-18 15:532026-09-18 15:53CLXCLX261120C00090000call90.00002026-11-202.35002.30002.350083.000011750.008930.000.0050115434291.265734265734270.3324540445874780.332454044587478falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10049366516.002026-11-02unknowntrueuw_flow_alerts/api/option-trades/flow-alerts{"limit":500}2026-09-182026-09-18 21:152026-09-18 21:15
173e275d-2db5-4757-8039-511cef6168e12026-09-21 11:482026-09-21 11:472026-09-21 11:47CLXCLX261016C00085000call85.00002026-10-162.40002.25002.400084.100035040.0035040.000.0014615101011920.8473154362416110.3087991423692970.308799142369297falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10264623704.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-21T15:49:21.879731Z"}2026-09-212026-09-21 21:152026-09-21 21:15
e0a9a76a-1e44-49d1-ac49-564f228fc5942026-09-21 13:532026-09-21 13:532026-09-21 13:53CLXCLX270416C00090000call90.00002027-04-166.60006.20006.600085.225019800.0019800.000.0030751481.06250.300945590545280.30094559054528falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10264623704.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-21T17:55:32.885478Z"}2026-09-212026-09-21 21:152026-09-21 21:15