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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = CRK×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

3b98642d-8d73-4a45-acdf-3f190c35a3cd	2026-08-17 12:11	2026-08-17 12:11	2026-08-17 12:11	CRK	CRK280121C00017000	call	17.0000	2028-01-21	2.7500	2.7500	3.2000	13.5500	13750.00	0.00	13750.00	50	5	72	624	0.115384615384615	0.558527262849202	0.558527262849202	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	4198773836.00	2026-11-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
1879bd65-ea3a-4497-8e77-35db3ae408df	2026-08-17 12:25	2026-08-17 12:25	2026-08-17 12:25	CRK	CRK280121C00015000	call	15.0000	2028-01-21	3.3000	3.3000	3.7000	13.5200	14191.00	0.00	14191.00	43	6	51	2463	0.0207064555420219	0.555538642807789	0.557144871767001	false	false	false	true
0201445e-b2bb-421a-982e-045190e6de7a	2026-08-17 15:28	2026-08-17 15:28	2026-08-17 15:28	CRK	CRK261120P00015000	put	15.0000	2026-11-20	2.3000	2.3000	2.4000	13.4500	16560.00	0.00	16560.00	72	17	73	65	1.12307692307692	0.521952995811597	0.521952995811597	false	false	false	true
9d652c10-74b1-4333-b619-1e07a41b0e8f	2026-08-18 10:03	2026-08-18 10:03	2026-08-18 10:03	CRK	CRK260918C00013000	call	13.0000	2026-09-18	1.1500	0.8000	1.2500	13.5850	17365.00	5635.00	11730.00	151	13	151	489	0.30879345603272	0.506253472257637	0.517455804876098	true	false	false	true
8f866519-4bed-4c58-b54f-f25bc8d271b0	2026-08-21 10:00	2026-08-21 10:00	2026-08-21 10:00	CRK	CRK260918C00014000	call	14.0000	2026-09-18	0.9000	0.8000	0.9000	14.1000	13500.00	13500.00	0.00	150	17	151	1192	0.126677852348993	0.534435027357419	0.534435027357419	false	false	false	true
38b4f7fb-4a0e-4120-9602-a56c9126bbcf	2026-08-21 10:00	2026-08-21 10:00	2026-08-21 10:00	CRK	CRK260918C00014000	call	14.0000	2026-09-18	0.9000	0.8000	0.9000	14.1100	13440.00	13440.00	0.00	150	17	301	1192	0.25251677852349	0.530821745686944	0.530821745686944	false	false	false	true
dffbfce8-7056-4c9c-8831-3ca901f15a7a	2026-08-21 10:00	2026-08-21 10:00	2026-08-21 10:00	CRK	CRK260918C00014000	call	14.0000	2026-09-18	0.9000	0.8000	0.9000	14.1300	11880.00	11880.00	0.00	132	6	493	1192	0.413590604026846	0.523557931923025	0.523557931923025	false	false	false	true
28372840-9652-4efb-b66c-828ff77153df	2026-08-21 10:00	2026-08-21 10:00	2026-08-21 10:00	CRK	CRK260918C00014000	call	14.0000	2026-09-18	0.9000	0.8000	0.9000	14.1300	13500.00	13500.00	0.00	150	10	661	1192	0.554530201342282	0.523557931923025	0.523557931923025	false	false	false	true
f70de2d6-bce5-4402-a455-15bdbfa05227	2026-08-21 10:48	2026-08-21 10:48	2026-08-21 10:48	CRK	CRK260918C00014000	call	14.0000	2026-09-18	0.9500	0.9000	0.9500	14.1450	22800.00	22800.00	0.00	240	13	6855	1192	5.7508389261745	0.55961270738207	0.550496687635553	false	false	false	true
eb07c95f-20ff-4c75-81e5-3509cd350c0a	2026-08-21 10:51	2026-08-21 10:51	2026-08-21 10:51	CRK	CRK260918C00014000	call	14.0000	2026-09-18	0.9500	0.9000	0.9500	14.1100	14155.00	14155.00	0.00	149	6	7623	1192	6.39513422818792	0.563238667177221	0.563238667177221	false	false	false	true
f0d560b3-ffa3-4f6e-89c0-c4d3b7b80e4f	2026-08-21 10:56	2026-08-21 10:56	2026-08-21 10:56	CRK	CRK260918C00014000	call	14.0000	2026-09-18	0.9000	0.9000	1.0000	14.1239	10080.00	0.00	10080.00	112	10	8180	1192	6.86241610738255	0.525778759388934	0.525778759388934	false	false	false	true
c49527b4-0010-4182-81bd-b9f39f92b6de	2026-08-21 10:59	2026-08-21 10:59	2026-08-21 10:59	CRK	CRK260918C00014000	call	14.0000	2026-09-18	0.9500	0.9000	0.9500	14.1310	10640.00	10640.00	0.00	112	19	8527	1192	7.15352348993289	0.555610799937523	0.555610799937523	false	false	false	true
97a01311-aa5a-499b-a0b1-3a92803df06a	2026-08-21 11:30	2026-08-21 11:30	2026-08-21 11:30	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.0100	0.9500	1.0500	14.2300	58600.00	10300.00	47900.00	583	47	10694	1192	8.97147651006711	0.551368230344352	0.551368230344352	false	false	false	true
4624be99-0364-461c-8750-fd26e84c5dc2	2026-08-21 13:35	2026-08-21 13:35	2026-08-21 13:35	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.0000	0.9500	1.0000	14.1900	99800.00	99800.00	0.00	998	35	15774	1192	13.2332214765101	0.566324662241334	0.566324662241334	false	false	false	true
09341e62-103d-47b4-8b67-eea85db85ca7	2026-08-24 10:50	2026-08-24 10:50	2026-08-24 10:50	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.0500	1.0500	1.1000	14.3201	15540.00	0.00	15540.00	148	14	1082	15015	0.0720612720612721	0.583060695375993	0.583060695375993	false	false	false	true
95f2bbd8-3f84-4b57-8cf4-3390764e1de9	2026-08-25 09:30	2026-08-25 09:30	2026-08-25 09:30	CRK	CRK260918C00014000	call	14.0000	2026-09-18	0.9000	0.9000	1.0000	13.8600	11270.00	0.00	11270.00	125	7	1924	17551	0.109623383283004	0.669478763442792	0.669478763442792	false	false	false	true
57200ebb-b604-4b27-bd7a-8e0bee361a04	2026-08-25 09:49	2026-08-25 09:48	2026-08-25 09:48	CRK	CRK260918C00014000	call	14.0000	2026-09-18	0.8000	0.8000	0.8500	13.8100	40000.00	0.00	40000.00	500	12	3712	17551	0.211497920346419	0.606099781434879	0.616826205100642	false	false	false	true
d0d809ac-5958-4bc3-9854-1b9a2a465d42	2026-08-25 09:59	2026-08-25 09:59	2026-08-25 09:59	CRK	CRK260918C00014000	call	14.0000	2026-09-18	0.8400	0.8000	0.8500	13.8600	16800.00	16800.00	0.00	200	7	4732	17551	0.269614266993334	0.627131274182897	0.627131274182897	false	false	false	true
8fcf2839-c3ef-44a9-9e83-567020a5cb73	2026-08-25 10:03	2026-08-25 10:02	2026-08-25 10:02	CRK	CRK260918P00014000	put	14.0000	2026-09-18	0.8500	0.8000	0.9000	13.9700	16575.00	0.00	13770.00	195	26	226	542	0.416974169741697	0.597155814811729	0.597155814811729	true	false	false	true
1963819b-f282-46db-aec0-fe3661766e01	2026-08-26 12:38	2026-08-26 12:37	2026-08-26 12:37	CRK	CRK261120P00013000	put	13.0000	2026-11-20	0.8500	0.8000	0.8500	14.5950	12750.00	12750.00	0.00	150	9	170	355	0.47887323943662	0.58873415862855	0.58873415862855	false	false	false	true
7ec361a1-f3ba-4bb2-815c-691851173072	2026-08-27 09:39	2026-08-27 09:39	2026-08-27 09:39	CRK	CRK260918C00014000	call	14.0000	2026-09-18	0.9100	0.9000	0.9500	14.2500	33070.00	0.00	33070.00	363	9	447	22357	0.0199937379791564	0.543570630381506	0.543570630381506	false	false	false	true
28c723f3-12c2-48ff-86fc-a1069d7f4e80	2026-08-27 10:46	2026-08-27 10:46	2026-08-27 10:46	CRK	CRK261016C00016000	call	16.0000	2026-10-16	0.6000	0.5500	0.6500	14.3700	11820.00	0.00	11760.00	197	22	207	48	4.3125	0.547340027980448	0.547340027980448	false	false	false	true
26ba7119-929b-4a11-b47e-5968946a6095	2026-08-27 12:58	2026-08-27 12:57	2026-08-27 12:57	CRK	CRK261016P00015000	put	15.0000	2026-10-16	1.3000	1.3000	1.3500	14.6691	34970.00	0.00	34970.00	269	33	273	2125	0.128470588235294	0.53605024903642	0.53605024903642	false	false	false	true
de4446b7-9da0-4bdb-baea-5cde9ed4a933	2026-08-27 14:35	2026-08-27 14:35	2026-08-27 14:35	CRK	CRK261016P00015000	put	15.0000	2026-10-16	1.3000	1.3000	1.3500	14.6700	18330.00	0.00	18330.00	141	17	414	2125	0.194823529411765	0.536255832788111	0.536255832788111	false	false	false	true
4e846bfd-0612-43e6-891a-6f00f9d63aa9	2026-08-27 15:24	2026-08-27 15:24	2026-08-27 15:24	CRK	CRK261218C00016000	call	16.0000	2026-12-18	1.3500	1.3500	1.4500	14.0000	10260.00	0.00	10260.00	76	14	77	45	1.71111111111111	0.557873124239486	0.557873124239486	false	false	false	true
bca9fcd5-185d-47fa-97e6-c2d57c7d2683	2026-08-28 11:42	2026-08-28 11:42	2026-08-28 11:42	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.0000	1.0000	1.1000	14.0000	11100.00	0.00	11100.00	111	5	494	22512	0.0219438521677328	0.488930462439717	0.488930462439717	false	false	false	true
6efcaa7a-0e18-4fd8-8d8c-a19d5d53ed1c	2026-08-28 11:55	2026-08-28 11:55	2026-08-28 11:55	CRK	CRK261120C00015000	call	15.0000	2026-11-20	1.4000	1.3500	1.4500	14.0000	24081.00	280.00	23381.00	172	19	346	1278	0.270735524256651	0.568317244911729	0.574816296654458	false	false	false	true
4ad9eea5-81d0-49ea-8c6b-0e17ae620ed4	2026-08-28 12:13	2026-08-28 12:13	2026-08-28 12:13	CRK	CRK261120C00016000	call	16.0000	2026-11-20	1.0000	1.0000	1.0500	14.4300	15505.00	0.00	15505.00	155	24	155	320	0.484375	0.559878594792119	0.559878594792119	false	false	false	true
dbd06810-59c5-4ad9-9820-fb625570d204	2026-08-28 12:24	2026-08-28 12:24	2026-08-28 12:24	CRK	CRK261120C00015000	call	15.0000	2026-11-20	1.3500	1.3500	1.4000	14.3950	14040.00	0.00	14040.00	104	15	462	1278	0.36150234741784	0.564996507230791	0.564996507230791	false	false	false	true
c4c1bef6-1439-4a6a-ba25-1222e74cf550	2026-08-28 15:13	2026-08-28 15:13	2026-08-28 15:13	CRK	CRK260918P00014000	put	14.0000	2026-09-18	0.5500	0.4500	0.5500	14.3600	10340.00	10340.00	0.00	188	13	205	773	0.265200517464424	0.537957659980536	0.537957659980536	false	false	false	true
6842068f-65bc-4256-85fb-6b281eeaa003	2026-08-31 15:33	2026-08-31 15:33	2026-08-31 15:33	CRK	CRK261016C00015000	call	15.0000	2026-10-16	0.8500	0.8500	0.9500	14.4300	17850.00	0.00	17850.00	210	24	370	4185	0.0884109916367981	0.513667959829137	0.52051720987964	false	false	false	true
03d4cc7e-7073-494d-baeb-9c9faa80d7ab	2026-08-31 15:36	2026-08-31 15:36	2026-08-31 15:36	CRK	CRK261016C00015000	call	15.0000	2026-10-16	0.8000	0.8000	0.9500	14.4500	16000.00	0.00	16000.00	200	11	570	4185	0.136200716845878	0.4914173918788	0.4914173918788	false	false	false	true
1f935a66-93fb-43b1-b6c8-7c3c5a7d71ef	2026-09-01 09:34	2026-09-01 09:33	2026-09-01 09:33	CRK	CRK260918C00014000	call	14.0000	2026-09-18	2.1000	2.0500	2.1000	15.9100	10286.00	10286.00	0.00	49	5	1936	22023	0.0879080960813695	0.606063622681316	0.606063622681316	true	false	false	true
9d8b9fe1-f6b8-49f1-a64e-c6d3be1688c1	2026-09-01 09:36	2026-09-01 09:36	2026-09-01 09:36	CRK	CRK260918C00014000	call	14.0000	2026-09-18	2.0000	1.9500	2.0500	15.9000	45000.00	44000.00	0.00	225	8	3063	22023	0.139081868955183	0.473474764074624	0.473474764074624	false	false	false	true
8ed285d8-4cd9-44a4-95bd-7800bc720587	2026-09-01 09:39	2026-09-01 09:39	2026-09-01 09:39	CRK	CRK260918C00014000	call	14.0000	2026-09-18	2.0000	2.0000	2.0500	15.9100	328600.00	0.00	328600.00	1643	47	5410	22023	0.245652272624075	0.457205118411603	0.457205118411603	false	false	false	true
12cc15c1-08ea-4179-81f5-4028d6b1d789	2026-09-01 09:40	2026-09-01 09:40	2026-09-01 09:40	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.8500	1.7500	1.9000	15.6800	18501.00	186.00	18315.00	100	6	5708	22023	0.259183580801889	0.477103254247605	0.550134553546806	false	false	false	true
32a22e0a-cfd8-4424-9f63-ed3615a6b932	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	CRK	CRK260918C00014000	call	14.0000	2026-09-18	2.0000	1.9000	2.0500	15.8800	20000.00	20000.00	0.00	100	9	6114	22023	0.2776188530173	0.502958382626481	0.502958382626481	false	false	false	true
66933e36-d71f-437e-b303-55dfce42a340	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.9500	1.9500	2.0000	15.8505	19305.00	0.00	19305.00	99	6	6213	22023	0.282114153385097	0.464489733444359	0.464489733444359	false	false	false	true
22a3df2d-5eab-47b8-a047-9f10a45725f0	2026-09-01 09:42	2026-09-01 09:42	2026-09-01 09:42	CRK	CRK261016C00015000	call	15.0000	2026-10-16	1.6000	1.6000	1.6500	15.8400	32000.00	0.00	32000.00	200	6	898	3719	0.241462758806131	0.503709629633958	0.503709629633958	false	false	false	true
b3b7cb47-90de-4b40-ba5d-8dc95c575ae2	2026-09-01 09:43	2026-09-01 09:43	2026-09-01 09:43	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.9000	1.9000	1.9500	15.8125	29070.00	0.00	29070.00	153	5	6505	22023	0.295373019116378	0.436943399832532	0.436943399832532	false	false	false	true
a79aefad-11c4-470c-ad69-537d1b54271a	2026-09-01 09:43	2026-09-01 09:43	2026-09-01 09:43	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.9500	1.9000	2.0000	15.8200	14036.00	12866.00	0.00	72	5	6596	22023	0.299505062888798	0.50782475314835	0.50782475314835	false	false	false	true
033fa25d-2e86-4e6f-a6d3-a37b41b21e9d	2026-09-01 09:48	2026-09-01 09:48	2026-09-01 09:48	CRK	CRK261016C00015000	call	15.0000	2026-10-16	1.5000	1.5000	1.6000	15.7300	15000.00	0.00	15000.00	100	6	1129	3719	0.3035762301694	0.49013733953466	0.49013733953466	false	false	false	true
ec42103e-c142-4c9c-8b75-273e694af6c6	2026-09-01 10:55	2026-09-01 10:54	2026-09-01 10:54	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.7000	1.5500	1.7500	15.5700	13260.00	13090.00	170.00	78	10	9072	22023	0.411932979158153	0.46320193247408	0.46320193247408	true	false	false	true
ec1679a2-3014-4324-b3ce-a51ceae6eb41	2026-09-01 11:36	2026-09-01 11:36	2026-09-01 11:36	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.8000	1.7000	1.8000	15.6500	16200.00	16200.00	0.00	90	13	9662	22023	0.438723153067248	0.505495778590957	0.505495778590957	false	false	false	true
30156c44-101b-47ca-8d2c-8e5da594ce93	2026-09-01 11:50	2026-09-01 11:50	2026-09-01 11:50	CRK	CRK261120C00015000	call	15.0000	2026-11-20	2.0000	1.9500	2.0500	15.7500	24600.00	23000.00	0.00	123	16	854	1906	0.448058761804827	0.533356969712418	0.533356969712418	false	false	false	true
37ae34f9-8fb0-4a2b-a206-20828e352b9c	2026-09-01 11:53	2026-09-01 11:53	2026-09-01 11:53	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.9000	1.8000	1.9000	15.7800	13490.00	13490.00	0.00	71	21	9879	22023	0.448576488216864	0.485792601380019	0.485792601380019	false	false	false	true
3ca94e08-e80b-40ae-a279-2f1122be890c	2026-09-01 11:55	2026-09-01 11:55	2026-09-01 11:55	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.9500	1.9000	1.9500	15.8400	10530.00	10530.00	0.00	54	18	10063	22023	0.456931389910548	0.480272961073154	0.480272961073154	false	false	false	true
5c7121d4-2a1d-428e-a3dd-970f50c0c53a	2026-09-01 13:38	2026-09-01 13:38	2026-09-01 13:38	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.9500	1.9000	2.0000	15.8400	10920.00	7800.00	0.00	56	10	10914	22023	0.495572810243836	0.480272961073154	0.480272961073154	false	false	false	true
e2b62708-4923-4216-af42-c9da12c4fc32	2026-09-01 15:01	2026-09-01 15:01	2026-09-01 15:01	CRK	CRK260918C00014000	call	14.0000	2026-09-18	2.0000	1.9000	2.0000	15.8850	27800.00	27800.00	0.00	139	15	11534	22023	0.523725196385597	0.495907985390165	0.495907985390165	false	false	false	true
45e48430-c661-43dc-b98f-a420330b1036	2026-09-01 15:01	2026-09-01 15:01	2026-09-01 15:01	CRK	CRK260918C00014000	call	14.0000	2026-09-18	2.0000	1.9000	2.0000	15.8950	128600.00	128600.00	0.00	643	67	12177	22023	0.552921945239068	0.481187679287643	0.481187679287643	false	false	false	true