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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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 = CI×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

20e9ac8d-0cd3-450c-851c-de33648023cd	2026-08-20 12:34	2026-08-20 12:34	2026-08-20 12:34	CI	CI260828P00275000	put	275.0000	2026-08-28	3.5000	3.5000	4.2000	276.3800	72800.00	0.00	72800.00	208	35	208	77	2.7012987012987	0.261465184286076	0.261465184286076	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	76642952964.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f4cf22fb-27cd-451f-9e43-c31a0612a240	2026-09-01 15:00	2026-09-01 15:00	2026-09-01 15:00	CI	CI261016C00300000	call	300.0000	2026-10-16	3.5000	3.5000	3.8000	280.2150	52850.00	0.00	52850.00	151	33	165	325	0.507692307692308	0.250377386823363	0.250377386823363	false	false	false	true
a1ad6461-3f06-4c89-ae7a-7ecddc78a77f	2026-09-14 13:44	2026-09-14 13:44	2026-09-14 13:44	CI	CI261030C00310000	call	310.0000	2026-10-30	4.9000	4.0000	4.9000	288.6050	177380.00	177380.00	0.00	362	36	364	1	364	0.292677211500035	0.292677211500035	false	false	false	true
4e02f216-4950-4dac-9a1d-d1b2e88478a4	2026-09-17 11:22	2026-09-17 11:22	2026-09-17 11:22	CI	CI260925C00277500	call	277.5000	2026-09-25	4.8000	4.4000	4.8000	277.7600	71520.00	71520.00	0.00	149	10	150	3	50	0.277332220360885	0.277332220360885	false	false	false	true
076a30d5-6a56-4856-a01c-e1a846d36821	2026-09-18 14:14	2026-09-18 14:14	2026-09-18 14:14	CI	CI261120P00270000	put	270.0000	2026-11-20	10.5000	10.1000	10.5000	276.7000	72450.00	72450.00	0.00	69	13	78	0	0	0.318225856359852	0.318225856359852	false	false	false	true
702dacaa-5145-4ae5-8695-ba08c8924838	2026-09-21 11:14	2026-09-21 11:14	2026-09-21 11:14	CI	CI261016C00280000	call	280.0000	2026-10-16	6.0000	5.6000	6.0000	274.2800	34799.00	34799.00	0.00	58	23	60	366	0.163934426229508	0.28535665693611	0.28535665693611	false	false	false	true
df22ce4a-041e-4601-bbf8-5850f274377a	2026-09-22 09:46	2026-09-22 09:46	2026-09-22 09:46	CI	CI261002P00272500	put	272.5000	2026-10-02	4.1000	3.0000	5.0000	275.0000	10250.00	10250.00	0.00	25	6	25	58	0.431034482758621	0.302100722459757	0.302100722459757	false	false	false	true
3f112c20-dfb0-4e19-a208-09ae51427439	2026-09-23 10:21	2026-09-23 10:21	2026-09-23 10:21	CI	CI261218C00300000	call	300.0000	2026-12-18	7.1000	7.0000	7.4000	273.7600	31950.00	710.00	4260.00	45	19	45	329	0.13677811550152	0.292615772122266	0.292615772122266	false	false	false	true
bc1b8bc1-c487-4ec1-b4ca-4b4065a6433e	2026-09-23 12:07	2026-09-23 12:06	2026-09-23 12:06	CI	CI261016P00260000	put	260.0000	2026-10-16	3.4000	3.4000	3.5000	271.2400	28560.00	0.00	4080.00	84	10	94	3702	0.0253916801728795	0.300268507369886	0.300268507369886	false	false	false	true
f95339d5-c585-48fc-84ec-b23ef687a860	2026-09-23 12:15	2026-09-23 12:15	2026-09-23 12:15	CI	CI280121P00170000	put	170.0000	2028-01-21	4.4000	4.4000	6.0000	270.5000	20240.00	0.00	20240.00	46	15	50	1	50	0.366568406192358	0.366568406192358	false	false	false	true
de0c1b42-1300-4aa3-85a2-2b2175886fe4	2026-09-23 12:15	2026-09-23 12:15	2026-09-23 12:15	CI	CI280121P00170000	put	170.0000	2028-01-21	4.4000	4.4000	6.0000	270.5000	22000.00	0.00	22000.00	50	6	100	1	100	0.366568406192358	0.366568406192358	false	false	false	true
69457f07-75a1-45a8-9229-d37aefe4eb98	2026-09-24 10:47	2026-09-24 10:47	2026-09-24 10:47	CI	CI261002P00270000	put	270.0000	2026-10-02	6.2000	6.2000	6.6000	267.0000	31000.00	0.00	31000.00	50	8	61	82	0.74390243902439	0.320398582956564	0.320398582956564	false	false	false	true
c16d9e80-108a-47da-9f3e-a5395e5a9131	2026-09-24 10:47	2026-09-24 10:47	2026-09-24 10:47	CI	CI261002P00270000	put	270.0000	2026-10-02	6.5000	6.5000	6.9000	267.0000	16900.00	0.00	16900.00	26	5	102	82	1.24390243902439	0.326320951116648	0.326320951116648	false	false	false	true
7c3cf85a-f2b7-41ba-bbc3-145c400426f4	2026-09-24 11:02	2026-09-24 11:02	2026-09-24 11:02	CI	CI261002P00265000	put	265.0000	2026-10-02	4.1000	3.6000	4.1000	266.6800	58220.00	58220.00	0.00	142	8	143	70	2.04285714285714	0.318476052596042	0.318476052596042	false	false	false	true
6d4fe173-665a-4265-b868-f102bbd61cd8	2026-09-24 11:02	2026-09-24 11:02	2026-09-24 11:02	CI	CI261002P00270000	put	270.0000	2026-10-02	6.7000	6.6000	7.1000	266.5900	18760.00	2010.00	16750.00	28	12	525	82	6.40243902439024	0.312675558375203	0.312675558375203	false	false	false	true
3751dc4f-2f47-4036-92b9-690f85a98753	2026-09-24 11:04	2026-09-24 11:04	2026-09-24 11:04	CI	CI261002P00270000	put	270.0000	2026-10-02	7.0000	6.6000	7.3000	266.3700	10500.00	700.00	9800.00	15	5	562	82	6.85365853658537	0.32374654626908	0.32374654626908	false	false	false	true
c3e40325-7212-4a91-894a-95eb16e50926	2026-09-24 11:08	2026-09-24 11:08	2026-09-24 11:08	CI	CI261002P00267500	put	267.5000	2026-10-02	5.8000	5.0000	5.8000	266.1750	15080.00	15080.00	0.00	26	6	107	109	0.981651376146789	0.332434771052201	0.332434771052201	false	false	false	true
22ba99cd-e12d-4319-b17a-444d7c9f9704	2026-09-24 11:26	2026-09-24 11:26	2026-09-24 11:26	CI	CI261002P00265000	put	265.0000	2026-10-02	5.3000	5.0000	5.6000	264.9600	10070.00	0.00	9540.00	19	6	244	70	3.48571428571429	0.344928811338529	0.344928811338529	true	false	false	true
6b9614fc-e3ff-414d-be1d-ba7a533c88cd	2026-09-24 11:27	2026-09-24 11:27	2026-09-24 11:27	CI	CI261002P00265000	put	265.0000	2026-10-02	5.4000	4.9000	5.8000	265.0200	12420.00	540.00	11880.00	23	6	267	70	3.81428571428571	0.353178102573092	0.353178102573092	false	false	false	true
668c0591-fe96-4cba-b2b4-4176a86bc384	2026-09-24 11:50	2026-09-24 11:50	2026-09-24 11:50	CI	CI261002P00270000	put	270.0000	2026-10-02	7.9000	7.4000	7.9000	264.8900	116920.00	116920.00	0.00	148	15	738	82	9	0.322831304191054	0.322831304191054	true	false	false	true
7f86d604-d670-46ba-8263-af26c113157f	2026-09-24 11:53	2026-09-24 11:53	2026-09-24 11:53	CI	CI261016P00262500	put	262.5000	2026-10-16	6.9000	5.7000	6.9000	264.8400	121439.00	121439.00	0.00	176	19	177	51	3.47058823529412	0.321901038339587	0.321901038339587	false	false	false	true
ebcba8d9-0672-4082-b24c-e8dff3117132	2026-09-24 12:14	2026-09-24 12:14	2026-09-24 12:14	CI	CI261002C00267500	call	267.5000	2026-10-02	4.3900	3.6000	4.4000	264.1900	25470.00	25470.00	0.00	58	23	426	7	60.8571428571429	0.370176944973752	0.370176944973752	false	false	false	true
42204f92-bc26-4976-a9ac-878b9a8d2750	2026-09-24 12:15	2026-09-24 12:15	2026-09-24 12:15	CI	CI261030C00270000	call	270.0000	2026-10-30	8.8000	7.5000	8.8000	264.6200	30800.00	30800.00	0.00	35	8	35	2	17.5	0.323576019128173	0.323576019128173	false	false	false	true