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.

231,528 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:source = uw_flow_alerts×ticker = PSX×
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
65276bbf-3341-4e19-a798-55fa0ffe200b2026-09-18 13:462026-09-18 13:462026-09-18 13:46PSXPSX261120C00270000call270.00002026-11-2021.500020.700021.5000271.740051593.0051593.000.002412392970.1313131313131310.4391707969979830.439170796997983falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy108984582787.002026-10-28premarketuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"}2026-09-182026-09-18 21:152026-09-18 21:15
f0b100de-a025-4de8-bcc1-e09d7eb33d1f2026-09-17 15:252026-09-17 15:252026-09-17 15:25PSXPSX261120P00270000put270.00002026-11-2018.300017.800018.8000272.270065880.0064050.001830.0036101651221.352459016393440.4514090776520920.451409077652092falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy109415525376.002026-10-28premarketuw_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
353ec7f0-38da-479f-a8ba-93fc5f4ad9d42026-09-17 09:302026-09-17 09:302026-09-17 09:30PSXPSX260918C00230000call230.00002026-09-1834.630029.650034.6500261.1100110800.00110800.000.003212374900.07551020408163272.694813524459892.69481352445989truefalsefalsetruefalseRepeatedHitsAscendingFilla0979b52-28e4-4585-8f22-881faad2dd8e1Common StockEnergy109415525376.002026-10-28premarketuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-17T13:32:41.851557Z"}2026-09-172026-09-17 21:152026-09-17 21:15
04dc0a25-7a8d-4649-beb9-a43bc9b7a33b2026-09-15 14:032026-09-15 14:032026-09-15 14:03PSXPSX261218P00260000put260.00002026-12-1819.800019.700020.2000265.510069300.0013860.0055440.0035131212240.5401785714285710.4492156235024010.449215623502401falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"}2026-09-152026-09-15 21:152026-09-15 21:15
06f8615e-9638-4780-a864-40ffaef2d1692026-09-15 13:002026-09-15 13:002026-09-15 13:00PSXPSX261120C00280000call280.00002026-11-2014.700014.400014.7000265.8000144060.00144060.000.009810993190.3103448275862070.4384033756649310.438403375664931falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"}2026-09-152026-09-15 21:152026-09-15 21:15
dbcb2daa-00ae-4c99-a026-1b442229fdd42026-09-15 12:112026-09-15 12:112026-09-15 12:11PSXPSX270115P00250000put250.00002027-01-1518.300017.600018.3000263.5000188442.00188442.000.0010320280654.307692307692310.4366348120099620.438050857639149falsefalsefalsetruefalseRepeatedHitsAscendingFilla0979b52-28e4-4585-8f22-881faad2dd8e1Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"}2026-09-152026-09-15 21:152026-09-15 21:15
c385001d-cb98-4580-b259-65318000331d2026-09-15 12:112026-09-15 12:102026-09-15 12:10PSXPSX270115P00250000put250.00002027-01-1518.100018.100018.2000263.9000237110.000.00215390.0013111154652.369230769230770.4369890189694460.436989018969446falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"}2026-09-152026-09-15 21:152026-09-15 21:15
dcf5e8da-6acc-45da-a1b6-2b8542aad9c72026-09-15 11:522026-09-15 11:522026-09-15 11:52PSXPSX261218P00260000put260.00002026-12-1820.400019.500020.4000263.725081600.0081600.000.004018532240.2366071428571430.4468282404248170.446828240424817falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-15T15:54:17.138635Z"}2026-09-152026-09-15 21:152026-09-15 21:15
a76f2ccd-cec7-4564-887a-46e0fc49f62f2026-09-14 13:132026-09-14 13:132026-09-14 13:13PSXPSX270319P00230000put230.00002027-03-1916.600016.600017.2000255.000084660.000.0084660.00511992332.787878787878790.4233568816083740.423356881608374truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"}2026-09-152026-09-15 08:452026-09-15 08:45
b91d8d6c-158d-4614-9c82-4ffa275cd1772026-09-14 11:062026-09-14 11:062026-09-14 11:06PSXPSX270319C00230000call230.00002027-03-1947.700047.700050.2000259.8600162180.000.00162180.00349341350.2518518518518520.3987237788549110.398723778854911falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_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
557315bc-0c9b-4a0a-aa5e-01c8b250d5932026-09-14 11:062026-09-14 11:062026-09-14 11:06PSXPSX261218C00240000call240.00002026-12-1833.300033.300035.8000259.3250163170.000.00163170.00491060920.6521739130434780.4068187693303180.406818769330318falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_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
4c8ab2ad-2ed5-4e0c-9346-de0146ba7f182026-09-14 11:062026-09-14 11:062026-09-14 11:06PSXPSX261218C00230000call230.00002026-12-1839.700039.700042.4000259.3250154830.000.00154830.00395392720.1433823529411760.4027110001645680.402711000164568falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_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
299c9023-333e-426a-bac6-09c40f7ec4ce2026-09-10 14:512026-09-10 14:512026-09-10 14:51PSXPSX261218P00240000put240.00002026-12-1812.400012.100012.5000261.020052080.0040920.000.0042421076320.1693037974683540.431042112466930.43104211246693falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_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
6d05544f-dc48-4c1d-b587-cc3dcd12fb9f2026-09-10 11:242026-09-10 11:242026-09-10 11:24PSXPSX280121C00300000call300.00002028-01-2137.500034.500037.5000261.3400375000.00375000.000.0010025100616.66666666666670.3854653777276970.385465377727697truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"}2026-09-152026-09-15 08:452026-09-15 08:45
3983b522-41ee-425e-a1fd-19bd9234386c2026-09-08 11:042026-09-08 11:042026-09-08 11:04PSXPSX261218C00220000call220.00002026-12-1847.430046.400048.5000258.7400109081.000.0037906.002310378550.04327485380116960.4120713311637810.412071331163781falsefalsefalsetruefalseRepeatedHitsAscendingFilla0979b52-28e4-4585-8f22-881faad2dd8e1Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-08T15:14:28.726538Z"}2026-09-152026-09-15 08:452026-09-15 08:45
9ace7aad-b635-45d2-9e23-7302dc3e53c02026-09-04 11:342026-09-04 11:342026-09-04 11:34PSXPSX261120C00280000call280.00002026-11-2010.900010.300011.4000256.415071940.0071940.000.006620732640.2765151515151510.4043548913664650.404354891366465falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-04T15:46:11.944585Z"}2026-09-152026-09-15 08:452026-09-15 08:45
791b66b8-5ee3-414e-862e-1019a03494402026-09-03 14:212026-09-03 14:212026-09-03 14:21PSXPSX270617P00280000put280.00002027-06-1747.500046.500047.5000256.170085500.0085500.000.0018723000.4279020390455340.427902039045534falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"}2026-09-152026-09-15 08:452026-09-15 08:45
c198b04c-0228-46ae-ad49-7dbc8d1ac2402026-09-03 13:312026-09-03 13:312026-09-03 13:31PSXPSX261120C00260000call260.00002026-11-2019.800019.300019.8000258.465069300.0069300.000.003511603310.1812688821752270.4098167114858550.409816711485855falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"}2026-09-152026-09-15 08:452026-09-15 08:45
4243c1c7-34c7-475a-b99c-6ed6f780299c2026-09-03 12:172026-09-03 12:172026-09-03 12:17PSXPSX260918C00257500call257.50002026-09-188.50008.50009.6000258.265090100.000.0090100.0010681071010.70.3792383873625750.379238387362575falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"}2026-09-152026-09-15 08:452026-09-15 08:45
fefb2e38-772b-4e93-929b-a724d1e4599b2026-09-03 10:592026-09-03 10:592026-09-03 10:59PSXPSX260911C00257500call257.50002026-09-116.71006.10008.3000259.8000152940.0051810.00101130.0022863741820.77777777777780.3502042325308170.350273570908346falsefalsefalsetruefalseRepeatedHitsAscendingFilla0979b52-28e4-4585-8f22-881faad2dd8e1Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-03T15:12:38.137640Z"}2026-09-152026-09-15 08:452026-09-15 08:45
c77144af-c918-47a9-9856-1ff1ba10d5a32026-09-02 14:082026-09-02 14:082026-09-02 14:08PSXPSX270617P00250000put250.00002027-06-1729.400028.300029.4000257.605082320.0082320.000.00281334410.8292682926829270.4174617490119960.417461749011996falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"}2026-09-152026-09-15 08:452026-09-15 08:45
0efb027f-6a48-47c0-87db-82d9ae8ffd3a2026-09-01 12:432026-09-01 12:432026-09-01 12:43PSXPSX280121P00270000put270.00002028-01-2150.500048.500050.5000248.800055550.0055550.000.0011511000.4076957632871160.407695763287116falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-01T16:48:42.201804Z"}2026-09-152026-09-15 08:452026-09-15 08:45
0de4ecc3-7cd2-4ff2-9e27-495e4c94b5ef2026-08-31 13:092026-08-31 13:092026-08-31 13:09PSXPSX270617P00240000put240.00002027-06-1728.290027.900028.8000244.6300161260.00152770.008490.005716572150.2651162790697670.4050562459907740.405056245990774falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"}2026-09-152026-09-15 08:452026-09-15 08:45
cb831c71-cd54-4a70-95fe-0a879a72f60d2026-08-24 12:132026-08-24 12:132026-08-24 12:13PSXPSX261016P00200000put200.00002026-10-161.75001.60001.7500240.8500208075.00208075.000.00118926200014114.18439716312060.4056164918866810.405582887565798falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"}2026-09-152026-09-15 08:452026-09-15 08:45
b1c78485-34c7-4b87-87f3-0aad118aee302026-08-21 13:422026-08-21 13:422026-08-21 13:42PSXPSX261218C00290000call290.00002026-12-187.70007.30007.7000242.8400157080.00157080.000.00204232042780.7338129496402880.3876602373686990.387660237368699falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"}2026-09-152026-09-15 08:452026-09-15 08:45
79ddfa42-3fd6-4d94-ada8-d1551fe1d5362026-08-21 10:442026-08-21 10:432026-08-21 10:43PSXPSX270115P00230000put230.00002027-01-1515.900014.800017.0000243.640055650.0050880.000.0035735660.530303030303030.3966922572632220.396692257263222falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-21T14:50:41.871179Z"}2026-09-152026-09-15 08:452026-09-15 08:45
7ea7933b-3b93-45d2-9ba7-02ee19dcc6592026-08-20 10:012026-08-20 10:012026-08-20 10:01PSXPSX261218C00290000call290.00002026-12-188.50007.90008.5000245.850095200.0095200.000.00112261121760.6363636363636360.3854965111708330.385496511170833falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"}2026-09-152026-09-15 08:452026-09-15 08:45
d66488f9-9fa8-42af-8dca-326f8f35a7712026-08-20 09:422026-08-20 09:422026-08-20 09:42PSXPSX260821C00240000call240.00002026-08-216.00004.80006.0000245.540075000.0075000.000.00125131254430.2821670428893910.4286305837998020.428630583799802falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"}2026-09-152026-09-15 08:452026-09-15 08:45
2388310c-cb08-4cb6-99fc-66116ea7fec62026-08-19 12:412026-08-19 12:412026-08-19 12:41PSXPSX260918C00260000call260.00002026-09-184.00003.90004.3000242.0050120400.0096400.0024000.00301710346061.706270627062710.3636822078591890.363682207859189falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"}2026-09-152026-09-15 08:452026-09-15 08:45
20ab817b-7b9b-44a1-b032-b4a4a1bec8192026-08-18 13:342026-08-18 13:342026-08-18 13:34PSXPSX261120C00250000call250.00002026-11-2015.800015.400016.0000240.960067920.0063200.004720.004313591800.3277777777777780.3827289881452070.378625584445902truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"}2026-09-152026-09-15 08:452026-09-15 08:45
6d12971c-edbb-47b2-b96d-ac9fad0422c92026-08-17 14:242026-08-17 14:242026-08-17 14:24PSXPSX270115C00260000call260.00002027-01-1515.600015.200015.7000239.6600113880.00113880.000.0073232321261.841269841269840.3589761652534930.358976165253493falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"}2026-09-152026-09-15 08:452026-09-15 08:45
3b867f63-34fd-456d-93b4-c3fce316c7aa2026-08-17 13:262026-08-17 13:262026-08-17 13:26PSXPSX270219C00280000call280.00002027-02-1912.250012.200012.3000240.090184550.0045510.0039040.0069116988.6250.3552369473898850.355236947389885falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockEnergy102572316667.002026-11-04unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"}2026-09-152026-09-15 08:452026-09-15 08:45