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

c37cdb44-1d0a-4986-af92-da187a90f524	2026-08-18 09:34	2026-08-18 09:34	2026-08-18 09:34	ET	ET281215C00020000	call	20.0000	2028-12-15	3.5000	2.5000	3.5000	21.2892	52500.00	52500.00	0.00	150	10	160	4086	0.0391581008321096	0.116699251183677	0.116699251183677	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Unit	Energy	73996508425.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a6f4da3e-1825-4c78-a65b-d8ba30a2a448	2026-08-18 12:57	2026-08-18 12:57	2026-08-18 12:57	ET	ET260918P00022000	put	22.0000	2026-09-18	0.8300	0.7600	0.8300	21.2950	55444.00	55444.00	0.00	668	24	728	113	6.44247787610619	0.176282391042686	0.176282391042686	false	false	false	true
a638da47-21f5-4b7d-8651-2a589ced65bc	2026-08-18 14:41	2026-08-18 14:40	2026-08-18 14:40	ET	ET270319C00024000	call	24.0000	2027-03-19	0.4500	0.3600	0.4500	21.3800	72000.00	72000.00	0.00	1600	39	1784	287	6.21602787456446	0.17791030540204	0.17791030540204	false	false	false	true
42ba5bbb-fa92-4615-aaf3-71a688185ddc	2026-08-21 14:53	2026-08-21 14:53	2026-08-21 14:53	ET	ET281215C00022000	call	22.0000	2028-12-15	2.0400	1.8000	2.0800	21.1600	101748.00	101748.00	0.00	499	19	2937	13586	0.216178418960695	0.109649098645447	0.107939873987447	true	false	false	true
ab698bf3-d360-478b-80a7-b7a1bab84eed	2026-08-21 14:55	2026-08-21 14:55	2026-08-21 14:55	ET	ET281215C00022000	call	22.0000	2028-12-15	2.0100	1.8000	2.0100	21.1301	100500.00	100500.00	0.00	500	17	3437	13586	0.252981009863094	0.107935811690821	0.107935811690821	false	false	false	true
1bc4b7e5-c7c3-4513-9b9d-04096e6b18ad	2026-08-21 14:56	2026-08-21 14:56	2026-08-21 14:56	ET	ET281215C00022000	call	22.0000	2028-12-15	1.9900	1.8000	2.0100	21.1450	99500.00	99500.00	0.00	500	19	3937	13586	0.289783600765494	0.105374637774972	0.105374637774972	false	false	false	true
e267317f-6593-4518-b9d2-b32f5c5924ec	2026-09-01 10:17	2026-09-01 10:16	2026-09-01 10:16	ET	ET261016C00021000	call	21.0000	2026-10-16	0.9800	0.9500	1.0100	21.5850	144158.00	98.00	144060.00	1471	10	1618	38993	0.0414946272407868	0.192769155542569	0.192769155542569	false	false	false	true
b82d7295-0360-4cb3-8a38-04f818b224d1	2026-09-08 14:20	2026-09-08 14:20	2026-09-08 14:20	ET	ET261009C00022000	call	22.0000	2026-10-09	0.2900	0.2200	0.3100	21.5250	54607.00	116.00	54491.00	1883	20	1966	182	10.8021978021978	0.184071145669611	0.184071145669611	false	false	false	true
18bdc81d-3f3a-44b7-9803-5672d2ebc80e	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	ET	ET261016C00019000	call	19.0000	2026-10-16	2.5100	2.5100	2.6100	21.4450	368970.00	0.00	368970.00	1470	28	1511	5601	0.269773254775933	0.177075539287632	0.177075539287632	false	false	false	true
e52ed556-b4f3-4b51-b945-25d6252f3827	2026-09-15 13:06	2026-09-15 13:06	2026-09-15 13:06	ET	ET261218C00022000	call	22.0000	2026-12-18	0.5400	0.5400	0.5900	21.4350	50004.00	0.00	50004.00	926	24	1079	10927	0.0987462249473781	0.158355416855682	0.158355416855682	false	false	false	true
67d15520-fc7a-4e86-a965-1d216ca347e4	2026-09-15 13:06	2026-09-15 13:06	2026-09-15 13:06	ET	ET261218C00021000	call	21.0000	2026-12-18	1.0500	1.0500	1.1000	21.4350	382306.00	0.00	382306.00	3641	38	14091	1845	7.63739837398374	0.156610235277547	0.156610235277547	true	false	false	true
9d3a9493-1b63-4f4c-b5ab-e03c015649e7	2026-09-17 12:37	2026-09-17 12:37	2026-09-17 12:37	ET	ET290119C00020000	call	20.0000	2029-01-19	2.7000	2.5200	2.7000	21.0750	54000.00	54000.00	0.00	200	10	218	66	3.3030303030303	0.172523395911077	0.172523395911077	false	false	false	true
0351a546-f115-479e-8e63-797151022202	2026-09-21 10:56	2026-09-21 10:56	2026-09-21 10:56	ET	ET280121C00020000	call	20.0000	2028-01-21	2.0000	2.0000	2.2000	20.8101	40000.00	0.00	40000.00	200	10	552	24085	0.0229188291467718	0.0874108124804558	0.0874108124804558	false	false	false	true
13591840-e9ea-4e1a-b690-b881d06a227f	2026-09-21 11:48	2026-09-21 11:48	2026-09-21 11:48	ET	ET260925C00019500	call	19.5000	2026-09-25	1.4200	1.1100	1.5000	20.8700	27344.00	27344.00	0.00	193	13	193	8	24.125	0.673852547973655	0.36612094188137	false	false	false	true
ae971062-982d-43c5-b47f-2c04a344a24b	2026-09-21 11:59	2026-09-21 11:59	2026-09-21 11:59	ET	ET260925C00019500	call	19.5000	2026-09-25	1.3700	1.3700	1.4000	20.8550	21509.00	0.00	822.00	157	8	590	8	73.75	0.329122893675691	0.329122893675691	true	false	false	true
ca91b2ce-1e8e-4ffe-b0bc-624c541aa3ba	2026-09-22 10:09	2026-09-22 10:09	2026-09-22 10:09	ET	ET260925P00021000	put	21.0000	2026-09-25	0.2200	0.1900	0.2200	20.9550	21978.00	21978.00	0.00	999	5	1024	3245	0.315562403697997	0.264099757987482	0.264099757987482	false	false	false	true
5613239a-593d-48f2-9191-cefe648a09e2	2026-09-22 13:46	2026-09-22 13:46	2026-09-22 13:46	ET	ET270115C00020000	call	20.0000	2027-01-15	1.3300	1.3300	1.3800	20.8200	66500.00	0.00	66500.00	500	31	1268	98973	0.0128115748739555	0.142467574345772	0.142467574345772	false	false	false	true
47fe5bb5-5253-44fd-be4e-67145e08c4e5	2026-09-22 13:46	2026-09-22 13:46	2026-09-22 13:46	ET	ET270115C00020000	call	20.0000	2027-01-15	1.3200	1.3200	1.3800	20.8200	132000.00	0.00	132000.00	1000	8	2268	98973	0.022915340547422	0.139694956597594	0.139694956597594	false	false	false	true
a4c8aa97-6eda-4080-aef7-c8249fe95dee	2026-09-22 14:34	2026-09-22 14:33	2026-09-22 14:33	ET	ET270115C00020000	call	20.0000	2027-01-15	1.2100	1.2100	1.2400	20.6600	96800.00	0.00	96800.00	800	45	8273	98973	0.0835884534165884	0.142299324990921	0.142299324990921	false	false	false	true
8ce3f352-d070-4277-8f45-7951925a5db2	2026-09-22 14:46	2026-09-22 14:46	2026-09-22 14:46	ET	ET270115C00020000	call	20.0000	2027-01-15	1.2100	1.2100	1.2400	20.6700	60500.00	0.00	60500.00	500	16	8773	98973	0.0886403362533216	0.140378920842198	0.140378920842198	false	false	false	true
e90f0466-a869-4eb4-aad5-434d069f3d42	2026-09-22 14:46	2026-09-22 14:46	2026-09-22 14:46	ET	ET270115C00020000	call	20.0000	2027-01-15	1.2100	1.2100	1.2400	20.6450	90750.00	0.00	90750.00	750	30	9523	98973	0.0962181605084215	0.143249690148368	0.145131645365647	false	false	false	true
9a67a85f-f37f-443d-a9c1-c953a64cf574	2026-09-22 14:47	2026-09-22 14:47	2026-09-22 14:47	ET	ET270115C00020000	call	20.0000	2027-01-15	1.2100	1.2100	1.2400	20.6400	58806.00	0.00	58806.00	486	14	10009	98973	0.101128590625726	0.144193739698883	0.146063571428613	false	false	false	true
b8e6edec-0115-4251-bf8e-dce2da3374bf	2026-09-22 14:48	2026-09-22 14:47	2026-09-22 14:47	ET	ET270115C00020000	call	20.0000	2027-01-15	1.2000	1.2000	1.2400	20.6450	30000.00	0.00	30000.00	250	22	10273	98973	0.103795984763521	0.14254232789068	0.14254232789068	false	false	false	true
45e29d75-7f9a-4154-a12b-b4dafa3cda7f	2026-09-22 14:53	2026-09-22 14:53	2026-09-22 14:53	ET	ET270115C00020000	call	20.0000	2027-01-15	1.1900	1.1800	1.2400	20.6450	133756.00	14994.00	118762.00	1124	34	11400	98973	0.115182928677518	0.1399380067016	0.1399380067016	false	false	false	true
b22aa3d7-54d5-48dc-bec6-3ff977ee6358	2026-09-22 14:53	2026-09-22 14:53	2026-09-22 14:53	ET	ET290119P00020000	put	20.0000	2029-01-19	2.2000	2.1200	2.2100	20.6150	11220.00	1320.00	9680.00	51	8	106	18	5.88888888888889	0.291592537369354	0.291592537369354	false	false	false	true
b9d31e5a-7136-4070-9440-1259407317af	2026-09-22 15:04	2026-09-22 15:04	2026-09-22 15:04	ET	ET270115C00022000	call	22.0000	2027-01-15	0.3300	0.3200	0.3300	20.5150	15114.00	15114.00	0.00	458	14	1119	54233	0.0206331938118858	0.166445916760072	0.166445916760072	false	false	false	true
f7c4ae59-dcda-4099-aa6e-f7a068378342	2026-09-22 15:07	2026-09-22 15:07	2026-09-22 15:07	ET	ET270115C00020000	call	20.0000	2027-01-15	1.1300	1.1300	1.1600	20.5200	20905.00	0.00	20905.00	185	10	15605	98973	0.157669263334445	0.147354908355571	0.147354908355571	false	false	false	true