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

ecad3d60-1826-4b60-b7a5-a88c2e8fe990	2026-08-21 10:07	2026-08-21 10:07	2026-08-21 10:07	BUG	BUG260821P00041000	put	41.0000	2026-08-21	1.1500	1.1500	1.7000	39.8550	24150.00	0.00	24035.00	210	25	211	1864	0.113197424892704	0.566064015126119	0.566076659244328	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	792741600.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
420200e8-9f1d-44a1-9b20-832fcd03c8a9	2026-08-21 15:46	2026-08-21 15:46	2026-08-21 15:46	BUG	BUG260821P00041000	put	41.0000	2026-08-21	0.3500	0.3000	0.5000	40.6500	33855.00	4235.00	28745.00	967	38	1276	1864	0.684549356223176	1.18463368180343	0.550259697820957	true	false	false	true
b584c3bb-6cc4-4bcd-9393-bc5c2db9baf5	2026-08-26 10:21	2026-08-26 10:21	2026-08-26 10:21	BUG	BUG260918P00039000	put	39.0000	2026-09-18	1.4000	1.0000	1.8500	39.5525	14000.00	3500.00	10500.00	100	5	102	32	3.1875	0.433791588175607	0.433791588175607	false	false	false	true
0711ae94-6657-4dbc-ab9d-134810c58ea4	2026-08-26 12:25	2026-08-26 12:25	2026-08-26 12:25	BUG	BUG261016C00035000	call	35.0000	2026-10-16	5.5000	5.2000	5.5000	39.6150	22000.00	22000.00	0.00	40	8	40	0	0	0.427001474681248	0.427001474681248	false	false	false	true
42272201-53a4-472e-9721-b858cbb0df91	2026-08-27 13:44	2026-08-27 13:44	2026-08-27 13:44	BUG	BUG261218C00039000	call	39.0000	2026-12-18	7.1000	6.7000	7.2000	44.2200	10650.00	8520.00	2130.00	15	5	35	78	0.448717948717949	0.388709048798012	0.388709048798012	false	false	false	true
c8de6170-bc2a-4c3b-9f89-4b2f82610d1f	2026-09-02 09:36	2026-09-02 09:36	2026-09-02 09:36	BUG	BUG261016C00035000	call	35.0000	2026-10-16	6.1000	5.8000	7.4000	40.5020	12200.00	1830.00	7320.00	20	5	20	30	0.666666666666667	0.42226479028412	0.42226479028412	false	false	false	true
33165ec8-67d4-4b7b-8219-4c0f8308377d	2026-09-14 11:21	2026-09-14 11:21	2026-09-14 11:21	BUG	BUG261016C00045000	call	45.0000	2026-10-16	1.7000	1.5000	1.7000	44.1399	34000.00	34000.00	0.00	200	12	231	367	0.629427792915531	0.387754805443712	0.387754805443712	false	false	false	true
3b6d5db8-639c-4253-90ec-d75f0c9b3b8c	2026-09-14 15:55	2026-09-14 15:55	2026-09-14 15:55	BUG	BUG261016P00040000	put	40.0000	2026-10-16	0.5500	0.4500	0.5500	44.0000	23100.00	23100.00	0.00	420	9	498	123	4.04878048780488	0.413472771224891	0.413472771224891	false	false	false	true
8b742bbc-7feb-4701-834d-b90f6e6005a7	2026-09-14 15:56	2026-09-14 15:56	2026-09-14 15:56	BUG	BUG261016P00042000	put	42.0000	2026-10-16	1.0000	0.9000	1.0000	44.0000	21099.00	21099.00	0.00	211	18	236	20	11.8	0.394254305931617	0.392027084193747	false	false	false	true
03c648ad-c111-4bec-ab79-d0228d8e141e	2026-09-16 12:11	2026-09-16 12:11	2026-09-16 12:11	BUG	BUG261218C00045000	call	45.0000	2026-12-18	3.8000	3.7000	3.9000	45.0800	145540.00	145160.00	0.00	383	11	389	1899	0.204844655081622	0.388246900191532	0.390138027554816	false	false	false	true
e17da19a-a294-4017-956b-95d33dfdc829	2026-09-17 12:07	2026-09-17 12:06	2026-09-17 12:06	BUG	BUG261218C00050000	call	50.0000	2026-12-18	1.9000	1.7500	2.0500	45.3200	57950.00	57760.00	0.00	305	13	305	236	1.29237288135593	0.380107669892714	0.380107669892714	false	false	false	true
f8fce3f9-06e4-460d-9480-eb53710635b1	2026-09-21 12:25	2026-09-21 12:25	2026-09-21 12:25	BUG	BUG270319C00046000	call	46.0000	2027-03-19	5.2000	5.1000	5.3000	45.6500	17160.00	0.00	10400.00	33	5	871	933	0.933547695605573	0.387603057777841	0.387603057777841	false	false	false	true