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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×endpoint = /api/option-trades/flow-alerts×ticker = STUB×

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

e1ceeb62-e415-4973-9569-c2505778ea44	2026-10-01 10:09	2026-10-01 10:09	2026-10-01 10:09	STUB	STUB280121C00005000	call	5.0000	2028-01-21	2.0000	2.0000	2.2500	5.0000	10001.00	0.00	10001.00	50	8	50	1524	0.0328083989501312	0.667153929276678	0.667153929276678	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	1960342013.00	2026-11-12	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T14:10:48.155850Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
e78d4204-ee91-447a-93e0-6f02642cd71f	2026-09-30 15:43	2026-09-30 15:43	2026-09-30 15:43	STUB	STUB261218P00005000	put	5.0000	2026-12-18	0.4000	0.4000	0.4500	5.6650	18080.00	0.00	6800.00	452	7	458	1920	0.238541666666667	0.713248030047849	0.713248030047849	true	false	false
a53d12f2-dfb9-42aa-b00b-e99a45750b7e	2026-09-28 12:04	2026-09-28 12:04	2026-09-28 12:04	STUB	STUB290119P00005000	put	5.0000	2029-01-19	1.6500	1.5000	1.7000	5.3850	109725.00	59895.00	22110.00	665	31	4665	9	518.333333333333	0.731519344037043	0.731519344037043	true	false	false
2238c0e2-1ff8-4a51-8a31-bd61631fca14	2026-09-28 12:03	2026-09-28 12:03	2026-09-28 12:03	STUB	STUB290119P00005000	put	5.0000	2029-01-19	1.6500	1.5000	1.6500	5.3900	165000.00	165000.00	0.00	1000	39	4000	9	444.444444444444	0.73198581779444	0.73198581779444	true	false	false
eb67711a-45ef-47ac-8e73-0c63b6afd57a	2026-09-23 11:38	2026-09-23 11:38	2026-09-23 11:38	STUB	STUB270115P00005000	put	5.0000	2027-01-15	0.5000	0.4500	0.6000	5.4600	50000.00	5400.00	44600.00	1000	16	1000	763	1.31061598951507	0.636676953859561	0.636676953859561	true	false	false
57a89d9f-5a74-48b1-8224-3d38b4adc3b7	2026-09-23 09:30	2026-09-23 09:30	2026-09-23 09:30	STUB	STUB261120C00005000	call	5.0000	2026-11-20	1.0000	0.9500	1.1500	5.6700	11000.00	0.00	11000.00	110	6	110	358	0.307262569832402	0.692085095338653	0.692085095338653	false	false	false
e5419a55-7daf-4799-95f2-0261ce8fc23e	2026-09-11 11:06	2026-09-11 11:06	2026-09-11 11:06	STUB	STUB280121C00010000	call	10.0000	2028-01-21	1.0500	0.9000	1.1000	6.0950	23940.00	23940.00	0.00	228	5	433	1604	0.269950124688279	0.676094307554821	0.676094307554821	false	false	false
7b5ea42c-3852-42c3-8a69-f49626a84712	2026-09-10 15:59	2026-09-10 15:59	2026-09-10 15:59	STUB	STUB270115C00007500	call	7.5000	2027-01-15	0.4500	0.4000	0.5000	5.9400	10800.00	10440.00	0.00	240	6	291	2205	0.131972789115646	0.654386324000375	0.654386324000375	false	false	false
eae1daa1-e491-4ab1-9fad-74f9af00e173	2026-09-08 09:56	2026-09-08 09:56	2026-09-08 09:56	STUB	STUB260911C00006000	call	6.0000	2026-09-11	0.4300	0.3000	0.5500	6.3200	215000.00	0.00	0.00	5000	7	5000	5001	0.999800039992002	1.05470554943367	1.05470554943367	false	false	false
49f585b8-8472-442d-b85b-ec86fd834137	2026-09-03 10:55	2026-09-03 10:54	2026-09-03 10:54	STUB	STUB261218C00007500	call	7.5000	2026-12-18	0.4500	0.4500	0.6500	6.4700	11250.00	0.00	11250.00	250	9	250	717	0.348675034867504	0.564891704546867	0.564891704546867	false	false	false
9ab6ca1e-a150-4b01-80a4-95be5908a17e	2026-09-02 15:58	2026-09-02 15:58	2026-09-02 15:58	STUB	STUB260904C00006000	call	6.0000	2026-09-04	0.2000	0.1500	0.2000	6.1650	10000.00	10000.00	0.00	500	8	3061	5012	0.61073423782921	0.526216305735809	0.526216305735809	true	false	false
95542cc6-6b33-4051-9d21-6832575b3f12	2026-09-02 15:49	2026-09-02 15:49	2026-09-02 15:49	STUB	STUB260904C00006000	call	6.0000	2026-09-04	0.2000	0.1500	0.2500	6.1750	27720.00	0.00	20880.00	1386	13	2389	5012	0.476656025538707	0.434274932809536	0.467676121616209	false	false	false
ff9c5c75-f72d-4996-b112-75ba0188843e	2026-08-26 10:31	2026-08-26 10:30	2026-08-26 10:30	STUB	STUB261120C00007500	call	7.5000	2026-11-20	0.6500	0.6000	0.6500	6.8600	11115.00	11115.00	0.00	171	6	301	1909	0.157674174960712	0.658942582896747	0.658942582896747	true	false	false
e2f54911-1cbb-4b19-8bb2-9e9773b86a13	2026-08-25 14:35	2026-08-25 14:34	2026-08-25 14:34	STUB	STUB260828C00006500	call	6.5000	2026-08-28	0.3000	0.2500	0.3500	6.7600	28050.00	4350.00	23700.00	935	7	5119	214	23.9205607476636	0.559598579147047	0.537058269794788	false	false	false
0a0642e5-1c34-46f8-bdf9-c45b37d05c0a	2026-08-25 14:34	2026-08-25 14:34	2026-08-25 14:34	STUB	STUB260828C00006500	call	6.5000	2026-08-28	0.3000	0.2500	0.3500	6.7500	56730.00	16770.00	36570.00	1891	25	4178	214	19.5233644859813	0.621285256829598	0.581037835864979	true	false	false
e06927d6-71db-4484-aef3-0b981fd21730	2026-08-24 11:39	2026-08-24 11:38	2026-08-24 11:38	STUB	STUB260904C00006500	call	6.5000	2026-09-04	0.4500	0.4500	0.4500	6.7750	17595.00	0.00	0.00	391	7	1320	5379	0.245398773006135	0.624947413781015	0.624947413781015	true	false	false
8a6a4bb2-3a69-4b45-ad70-ac412e2a87f7	2026-08-24 11:08	2026-08-24 11:08	2026-08-24 11:08	STUB	STUB260904C00006500	call	6.5000	2026-09-04	0.4500	0.4000	0.5500	6.7750	26550.00	0.00	23040.00	590	13	590	5379	0.109685815207288	0.624947413781015	0.624947413781015	true	false	false
878a8db4-5b76-433c-b9e3-2175f9e3e41d	2026-08-17 11:41	2026-08-17 11:40	2026-08-17 11:40	STUB	STUB260828C00007000	call	7.0000	2026-08-28	0.4500	0.3500	0.4500	7.2500	10890.00	3150.00	0.00	242	28	542	339	1.59882005899705	0.616229588591018	0.616229588591018	false	false	false
9cdf00b5-ad22-4a3a-ab39-a0336bd64e5b	2026-08-14 15:57	2026-08-14 15:57	2026-08-14 15:57	STUB	STUB260814P00009000	put	9.0000	2026-08-14	1.0000	0.9500	1.0500	8.0050	10000.00	0.00	8000.00	100	5	246	975	0.252307692307692	25.3370916622147	25.3370916622147	false	false	false