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 = WDAY×

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

ed63bbdb-1e8e-413b-8f39-c3526d7b9486	2026-08-19 11:39	2026-08-19 11:39	2026-08-19 11:39	WDAY	WDAY260828P00197500	put	197.5000	2026-08-28	8.2000	7.3000	8.6000	198.9400	33620.00	3280.00	30340.00	41	6	60	26	2.30769230769231	0.724604125779381	0.724604125779381	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	38065160000.00	2026-11-24	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
485813eb-efe1-4d57-9ee6-ae1f373b350c	2026-08-19 11:33	2026-08-19 11:33	2026-08-19 11:33	WDAY	WDAY260828P00190000	put	190.0000	2026-08-28	5.0000	4.8000	5.0000	198.8200	38500.00	38500.00	0.00	77	10	204	130	1.56923076923077	0.721313443979756	0.721313443979756	false	false	false	true
666f8b3c-605e-4bdc-af26-441c803b8ad3	2026-08-19 11:25	2026-08-19 11:25	2026-08-19 11:25	WDAY	WDAY260828C00192500	call	192.5000	2026-08-28	12.2000	11.6000	13.0000	198.8100	18300.00	2440.00	15860.00	15	5	15	60	0.25	0.69970720310667	0.69970720310667	false	false	false	true
42af59f3-eb25-414f-8d37-1ec9e5eb70a2	2026-08-19 10:41	2026-08-19 10:41	2026-08-19 10:41	WDAY	WDAY260918C00210000	call	210.0000	2026-09-18	7.6000	7.6000	8.1000	199.3850	131480.00	0.00	131480.00	173	40	228	2772	0.0822510822510823	0.510755084878706	0.510755084878706	true	false	false	true
7d28e2ea-569a-4311-8a3d-8886a1ba2100	2026-08-19 10:41	2026-08-19 10:41	2026-08-19 10:41	WDAY	WDAY260918C00210000	call	210.0000	2026-09-18	7.8000	7.2000	8.1000	199.3850	10920.00	4680.00	780.00	14	5	37	2772	0.0133477633477633	0.519818059562929	0.519818059562929	true	false	false	true
f75153c0-53f1-4be7-8ca2-0d554194b33f	2026-08-19 10:30	2026-08-19 10:30	2026-08-19 10:30	WDAY	WDAY261218P00210000	put	210.0000	2026-12-18	27.0000	26.4000	28.3000	197.4000	32400.00	21600.00	10800.00	12	6	12	32	0.375	0.468542201327139	0.468542201327139	false	false	false	true
b26e6106-104d-4589-9a64-3eb62c4deb7e	2026-08-19 10:30	2026-08-19 10:30	2026-08-19 10:30	WDAY	WDAY261218C00200000	call	200.0000	2026-12-18	21.7000	19.5000	23.1000	197.4000	32550.00	23870.00	8680.00	15	6	15	618	0.0242718446601942	0.480152812958034	0.480152812958034	false	false	false	true
1c7a16f9-db76-47e5-98c5-6e5cff4080de	2026-08-19 10:27	2026-08-19 10:27	2026-08-19 10:27	WDAY	WDAY261218C00250000	call	250.0000	2026-12-18	5.4000	4.9000	5.4000	197.5450	16200.00	16200.00	0.00	30	11	30	1172	0.0255972696245734	0.427622591579165	0.427622591579165	false	false	false	true
8cd25800-030a-4b95-8862-7eb01077847e	2026-08-18 15:33	2026-08-18 15:33	2026-08-18 15:33	WDAY	WDAY280121C00220000	call	220.0000	2028-01-21	26.0000	23.0000	26.0000	192.2200	109199.00	109199.00	0.00	42	14	56	278	0.201438848920863	0.348928894745415	0.348928894745415	false	false	false	true
ce8a753c-a8a4-416d-b341-ef1267dbe986	2026-08-18 15:26	2026-08-18 15:26	2026-08-18 15:26	WDAY	WDAY260918C00210000	call	210.0000	2026-09-18	5.7000	5.7000	6.1000	192.7700	31350.00	0.00	31350.00	55	15	132	2724	0.0484581497797357	0.524267408595563	0.524267408595563	false	false	false	true
b8aec383-0a43-42e3-bc32-6ef47463f350	2026-08-18 15:00	2026-08-18 15:00	2026-08-18 15:00	WDAY	WDAY270617C00185000	call	185.0000	2027-06-17	34.1000	34.1000	37.0000	193.3300	20460.00	0.00	20460.00	6	5	30	30	1	0.390824544127743	0.390824544127743	true	false	false	true
06d079e5-24f7-4d77-860f-54cf5975ef0d	2026-08-18 14:02	2026-08-18 14:02	2026-08-18 14:02	WDAY	WDAY260918P00185000	put	185.0000	2026-09-18	7.9000	7.9000	8.5000	193.8500	19750.00	0.00	19750.00	25	6	210	1565	0.134185303514377	0.548221240337809	0.548221240337809	false	false	false	true
78e05f3e-8f74-4b01-a82e-c2eeaa670c3b	2026-08-18 12:15	2026-08-18 12:15	2026-08-18 12:15	WDAY	WDAY260821C00205000	call	205.0000	2026-08-21	0.8000	0.4500	0.8000	193.3100	13030.00	13030.00	0.00	163	20	327	911	0.358946212952799	0.604374015170242	0.604374015170242	false	false	false	true
1548e14e-e21a-4df6-a0d6-9b72a6008868	2026-08-18 11:55	2026-08-18 11:54	2026-08-18 11:54	WDAY	WDAY260828C00195000	call	195.0000	2026-08-28	7.7000	7.7000	8.1000	192.6050	10780.00	0.00	10780.00	14	5	39	13	3	0.684667668058014	0.684667668058014	false	false	false	true
a0724ad9-d6ea-45bb-9a37-9b3786dc6640	2026-08-18 10:11	2026-08-18 10:11	2026-08-18 10:11	WDAY	WDAY261218C00250000	call	250.0000	2026-12-18	4.3000	3.9000	4.3000	193.9400	24510.00	24510.00	0.00	57	14	61	724	0.0842541436464088	0.414147584619182	0.414147584619182	false	false	false	true
0facf1a7-4d0a-4fdb-90e7-80d5fe6dd024	2026-08-18 10:04	2026-08-18 10:04	2026-08-18 10:04	WDAY	WDAY260918P00185000	put	185.0000	2026-09-18	7.5000	7.5000	8.8000	193.3800	13501.00	0.00	13501.00	18	12	18	1565	0.0115015974440895	0.521199610359323	0.521199610359323	false	false	false	true
b90ef2ce-d0d6-4764-ac03-c861f18c616a	2026-08-17 15:57	2026-08-17 15:57	2026-08-17 15:57	WDAY	WDAY260821P00185000	put	185.0000	2026-08-21	1.8500	1.6000	1.8500	191.0775	18500.00	18500.00	0.00	100	19	838	167	5.01796407185629	0.539469152845569	0.539469152845569	false	false	false	true
b5c34da1-9738-4859-813c-8b822d82bc51	2026-08-17 14:46	2026-08-17 14:45	2026-08-17 14:45	WDAY	WDAY260918C00210000	call	210.0000	2026-09-18	5.6000	5.3000	6.1000	192.3600	17361.00	1120.00	16241.00	31	22	153	2617	0.0584638899503248	0.517272142074962	0.517272142074962	true	false	false	true
5c11286e-cf91-49e6-a62a-3e32a7e4935f	2026-08-17 14:02	2026-08-17 14:02	2026-08-17 14:02	WDAY	WDAY260918C00230000	call	230.0000	2026-09-18	1.6500	1.2000	1.6500	190.0000	27390.00	27390.00	0.00	166	29	212	554	0.382671480144404	0.512618677356863	0.512618677356863	false	false	false	true
a48f81d3-d2b1-42f7-aafa-428a85114596	2026-08-17 13:24	2026-08-17 13:24	2026-08-17 13:24	WDAY	WDAY260821C00192500	call	192.5000	2026-08-21	3.1000	2.5500	3.1000	189.7100	32550.00	32550.00	0.00	105	18	274	621	0.44122383252818	0.541527279690106	0.541527279690106	false	false	false	true
6f9226d0-093e-4c78-aeb6-42a9b0b1df47	2026-08-17 11:51	2026-08-17 11:50	2026-08-17 11:50	WDAY	WDAY280121C00260000	call	260.0000	2028-01-21	12.1000	10.5000	12.1000	191.0800	12100.00	12100.00	0.00	10	5	3803	72	52.8194444444444	0.311971119168712	0.311971119168712	true	false	false	true
32302fdd-6ee3-43d2-95b6-80b14de5c16a	2026-08-17 11:11	2026-08-17 11:11	2026-08-17 11:11	WDAY	WDAY260918P00180000	put	180.0000	2026-09-18	7.2000	7.0000	8.2000	191.8000	15120.00	11520.00	3600.00	21	5	39	508	0.0767716535433071	0.567767741010574	0.567767741010574	false	false	false	true
e0b899b5-481a-4dd0-b270-d8e6a5801894	2026-08-17 10:40	2026-08-17 10:39	2026-08-17 10:39	WDAY	WDAY260821C00200000	call	200.0000	2026-08-21	1.7000	1.4500	1.9500	193.1600	12920.00	9010.00	0.00	76	11	526	7617	0.0690560588158067	0.518068166627176	0.518068166627176	false	false	false	true
cf098a02-d9a7-45f6-b198-a4fb29063fa9	2026-08-17 10:21	2026-08-17 10:21	2026-08-17 10:21	WDAY	WDAY260918P00160000	put	160.0000	2026-09-18	2.0000	1.5500	2.0000	194.4750	20000.00	12000.00	0.00	100	5	100	829	0.120627261761158	0.593689574892699	0.593689574892699	false	false	false	true
97a2f977-6572-44b3-81e1-81ed7437fcf3	2026-08-17 10:20	2026-08-17 10:20	2026-08-17 10:20	WDAY	WDAY260821C00200000	call	200.0000	2026-08-21	2.2000	1.9000	2.2000	194.2350	36520.00	36520.00	0.00	166	12	207	7617	0.0271760535643954	0.544349219117149	0.544349219117149	false	false	false	true
c953a0f1-0faa-42e2-858e-9eaaadfa268f	2026-08-17 09:58	2026-08-17 09:58	2026-08-17 09:58	WDAY	WDAY260904P00177500	put	177.5000	2026-09-04	4.6000	4.6000	4.9000	192.7551	13340.00	0.00	2300.00	29	5	151	7	21.5714285714286	0.649275299263742	0.649275299263742	false	false	false	true
e39618f7-b53d-4c7a-958f-0d125154d405	2026-08-17 09:52	2026-08-17 09:52	2026-08-17 09:52	WDAY	WDAY270617C00350000	call	350.0000	2027-06-17	2.7000	2.6500	2.7000	194.5450	58590.00	58590.00	0.00	217	20	217	39	5.56410256410256	0.40328347448093	0.40328347448093	false	false	false	true
092f1ced-b1c8-476d-8d13-00be36ac1460	2026-08-17 09:52	2026-08-17 09:52	2026-08-17 09:52	WDAY	WDAY270617C00400000	call	400.0000	2027-06-17	2.2000	2.1500	2.2000	194.5450	74140.00	74140.00	0.00	337	27	337	242	1.39256198347107	0.451722024712691	0.451722024712691	false	false	false	true
2c26579c-0514-47ef-b0b0-90e7dc2ebf24	2026-08-17 09:38	2026-08-17 09:37	2026-08-17 09:37	WDAY	WDAY260821P00197500	put	197.5000	2026-08-21	5.9000	5.5000	6.6000	195.2400	23010.00	0.00	22420.00	39	9	43	36	1.19444444444444	0.577147051023038	0.577147051023038	false	false	false	true
87807d49-6561-4da0-908a-fdf86c026b6f	2026-08-17 09:35	2026-08-17 09:35	2026-08-17 09:35	WDAY	WDAY280121C00180000	call	180.0000	2028-01-21	45.0000	45.0000	49.4000	193.9700	22500.00	0.00	22500.00	5	5	6	26	0.230769230769231	0.364376498173684	0.364376498173684	false	false	false	true
e3ebb126-5f8b-4fe7-a50e-86789e7fd2d6	2026-08-14 15:53	2026-08-14 15:53	2026-08-14 15:53	WDAY	WDAY260821C00210000	call	210.0000	2026-08-21	1.6000	1.6000	1.9000	198.0600	72640.00	0.00	72640.00	454	18	1457	185	7.87567567567568	0.500703792689984	0.500703792689984	true	false	false	true