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:option_symbol = SPXW260922C07765000×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

3e112043-a8e6-47e5-a854-31ae75b13cfc	2026-09-22 11:41	2026-09-22 11:41	2026-09-22 11:41	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.3000	4.2000	4.3000	7757.8600	17630.00	17630.00	0.00	41	15	33729	1982	17.0176589303734	0.105754500482565	0.105754500482565	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T15:42:55.952799Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
c0d2dae2-9536-45c1-b2d6-b5f78c5cfe23	2026-09-22 11:41	2026-09-22 11:41	2026-09-22 11:41	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	3.9000	3.9000	4.0000	7757.0000	47970.00	0.00	47970.00	123	22	33982	1982	17.1453077699294	0.104174312718645	0.104174312718645	false	false	false	true
3f0ec4fe-fc36-4e67-80b0-68d8cc428120	2026-09-22 11:41	2026-09-22 11:41	2026-09-22 11:41	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.1000	4.0000	4.2000	7756.7500	16810.00	15990.00	0.00	41	6	34064	1982	17.1866801210898	0.108729546583257	0.108729546583257	false	false	false	true
3a2f956c-a93b-4df1-bb92-409684ad6d79	2026-09-22 11:42	2026-09-22 11:42	2026-09-22 11:42	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.5000	4.4000	4.5000	7758.4100	12150.00	12150.00	0.00	27	5	34378	1982	17.3451059535822	0.106046730459603	0.106046730459603	false	false	false	true
e2d580ad-5379-4eda-848f-ee3e1cb04d7a	2026-09-22 11:42	2026-09-22 11:42	2026-09-22 11:42	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.5900	4.4000	4.6000	7758.5500	12400.00	11500.00	0.00	27	5	34450	1982	17.3814328960646	0.105564132202842	0.106830733054187	false	false	false	true
82a6c190-d27f-4478-a476-b2fd65f0fbb7	2026-09-22 11:42	2026-09-22 11:42	2026-09-22 11:42	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.4000	4.3000	4.5000	7758.5000	10120.00	0.00	5720.00	23	6	34423	1982	17.3678102926337	0.104008183051159	0.104008183051159	false	false	false	true
409e2cf6-97e8-4864-af38-a300fc7678ed	2026-09-22 11:44	2026-09-22 11:43	2026-09-22 11:43	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.5000	4.4000	4.6000	7759.1900	12150.00	0.00	11700.00	27	5	34886	1982	17.6014127144299	0.101934106050543	0.101934106050543	false	false	false	true
c9ed693a-761f-4de5-a291-884632c7a1da	2026-09-22 11:44	2026-09-22 11:44	2026-09-22 11:44	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.5000	4.4000	4.5000	7758.4400	18000.00	18000.00	0.00	40	6	35079	1982	17.6987891019173	0.106276696873265	0.106276696873265	false	false	false	true
0b7da46a-2a5f-4cdd-871b-7feee48ca50e	2026-09-22 11:46	2026-09-22 11:46	2026-09-22 11:46	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.5000	4.4000	4.5000	7759.0200	45000.00	45000.00	0.00	100	14	35453	1982	17.8874873864783	0.103376674565522	0.103376674565522	false	false	false	true
a81c0911-2dca-4571-b71d-70c57efa4499	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.8000	4.7000	4.8000	7759.6200	18720.00	18720.00	0.00	39	9	35755	1982	18.039858728557	0.104681402886767	0.104681402886767	false	false	false	true
990c4cbb-ae10-474e-8435-733415965166	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.8000	4.7000	4.8000	7759.8800	22560.00	22560.00	0.00	47	13	35802	1982	18.0635721493441	0.103144452282068	0.103144452282068	false	false	false	true
bb905c2e-0055-4f13-ae5b-1c99508a9733	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.9000	4.8000	4.9000	7760.1600	12250.00	12250.00	0.00	25	10	35868	1982	18.0968718466196	0.103026409212544	0.103026409212544	false	false	false	true
df97c206-27ca-4506-8be9-106e9584ebec	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.9000	4.9000	5.0000	7760.2400	10290.00	0.00	10290.00	21	12	35952	1982	18.1392532795156	0.102567732923413	0.102567732923413	false	false	false	true
0c533d08-32c1-482c-aa29-0562c4be9e83	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.2000	5.2000	5.3000	7760.6200	27060.00	1060.00	26000.00	52	20	36056	1982	18.1917255297679	0.106343860203498	0.104829431476985	false	false	false	true
2d315223-f4b5-47d6-9659-0ead08edee3c	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.4000	5.3000	5.4000	7761.1800	11330.00	10800.00	530.00	21	7	36140	1982	18.234106962664	0.102879551664399	0.104385137201558	false	false	false	true
3a7c8761-cbd6-4a6d-81d3-6eb81677d9b7	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.1300	5.1000	5.3000	7760.8700	62020.00	0.00	56820.00	121	23	36331	1982	18.3304742684157	0.103321400021498	0.103321400021498	false	false	false	true
ad464241-3a12-4a2b-8056-f38a84609777	2026-09-22 11:48	2026-09-22 11:48	2026-09-22 11:48	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.0000	4.9000	5.1000	7761.0800	10500.00	0.00	8500.00	21	11	36538	1982	18.4349142280525	0.0990765576260064	0.0990765576260064	false	false	false	true
b204cd17-82ec-4a2f-a3bd-47075bc5360a	2026-09-22 11:49	2026-09-22 11:49	2026-09-22 11:49	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.2000	5.1000	5.2000	7760.7400	23920.00	23920.00	0.00	46	13	37022	1982	18.6791120080727	0.104475195161244	0.104475195161244	false	false	false	true
6ff99fb9-3b65-4557-96c2-52eca0e47976	2026-09-22 11:49	2026-09-22 11:49	2026-09-22 11:49	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.3000	5.3000	5.4000	7760.9600	15900.00	0.00	15900.00	30	6	37240	1982	18.7891019172553	0.104729957346932	0.104729957346932	false	false	false	true
53434d32-13f6-4b44-a0bc-c367c8378e41	2026-09-22 11:50	2026-09-22 11:50	2026-09-22 11:50	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.3000	4.3000	4.4000	7758.7900	13760.00	0.00	13760.00	32	5	37480	1982	18.9101917255298	0.10243580545316	0.10243580545316	false	false	false	true
f6f70241-30ec-43f6-8a0d-dd140529f607	2026-09-22 11:53	2026-09-22 11:53	2026-09-22 11:53	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.4000	4.4000	4.5000	7760.0200	12330.00	450.00	11880.00	28	5	38091	1982	19.2184661957619	0.0974405355762167	0.0974405355762167	false	false	false	true
cd143fe6-4b73-4dae-adc5-b976c822c8af	2026-09-22 11:54	2026-09-22 11:54	2026-09-22 11:54	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.4000	4.4000	4.5000	7759.6800	15400.00	0.00	15400.00	35	6	38195	1982	19.2709384460141	0.0995956593022731	0.0995956593022731	false	false	false	true
76c96469-3bc4-474f-bece-ad5a116e10d9	2026-09-22 11:55	2026-09-22 11:55	2026-09-22 11:55	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.0000	4.0000	4.1000	7758.8700	13600.00	0.00	13600.00	34	16	38417	1982	19.382946518668	0.0981932076816168	0.0981932076816168	false	false	false	true
ad21428a-1468-4e6c-bfc7-ad2ebe9278d4	2026-09-22 11:55	2026-09-22 11:55	2026-09-22 11:55	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	3.8000	3.7000	3.9000	7757.8700	10640.00	0.00	10260.00	28	5	38604	1982	19.4772956609485	0.0982386582905427	0.100690513875993	false	false	false	true
74e8027a-d24e-44f0-ada2-c8ebefb46145	2026-09-22 11:57	2026-09-22 11:57	2026-09-22 11:57	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	3.6000	3.5000	3.6000	7757.5400	10080.00	10080.00	0.00	28	7	39322	1982	19.8395560040363	0.0996683414090108	0.0996683414090108	false	false	false	true
1451734f-97c7-40d7-abcd-1239bcc2109f	2026-09-22 11:59	2026-09-22 11:59	2026-09-22 11:59	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.4000	4.4000	4.5000	7760.1000	11440.00	0.00	11440.00	26	6	39779	1982	20.0701311806256	0.0981808129004416	0.0981808129004416	false	false	false	true
05e9fac6-68d6-478f-8ea3-1a98a12197e0	2026-09-22 12:00	2026-09-22 11:59	2026-09-22 11:59	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.6900	4.6000	4.7000	7760.9500	15010.00	13630.00	1380.00	32	6	40227	1982	20.2961654894046	0.0964854285869852	0.0977278090327955	false	false	false	true
7c44c5a5-1f72-477d-b749-6e9248b784e3	2026-09-22 12:00	2026-09-22 12:00	2026-09-22 12:00	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.6600	4.6000	4.7000	7761.4000	10250.00	6110.00	4140.00	22	5	40323	1982	20.3446014127144	0.0933481743490188	0.0948971621110438	false	false	false	true
6e8b623b-2737-4f08-a14f-38bf28028d8c	2026-09-22 12:00	2026-09-22 12:00	2026-09-22 12:00	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.0000	4.9000	5.1000	7761.9100	34000.00	32500.00	1500.00	68	17	40507	1982	20.4374369323915	0.0962357445293112	0.0962357445293112	false	false	false	true
076453e0-be59-4984-98df-6cfac8cdf4a6	2026-09-22 12:00	2026-09-22 12:00	2026-09-22 12:00	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.2700	5.2000	5.3000	7762.5800	15800.00	10600.00	5200.00	30	9	40705	1982	20.537336024218	0.0948725986893687	0.0964004474608188	false	false	false	true
54e5aecd-02f0-42fc-8a99-bc8eac2a76b1	2026-09-22 12:00	2026-09-22 12:00	2026-09-22 12:00	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.3000	5.2000	5.3000	7762.5400	10600.00	10600.00	0.00	20	8	40736	1982	20.5529767911201	0.0966747718007827	0.0966747718007827	false	false	false	true
01305e62-df90-4761-b1f7-555689795586	2026-09-22 12:00	2026-09-22 12:00	2026-09-22 12:00	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.4000	5.3000	5.5000	7762.5500	14580.00	7020.00	7020.00	27	7	40852	1982	20.6115035317861	0.0981626818126997	0.0981626818126997	false	false	false	true
d45f705d-9b6c-4ea5-95ed-878279c4ed88	2026-09-22 12:00	2026-09-22 12:00	2026-09-22 12:00	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.3600	5.3000	5.4000	7762.7000	12870.00	8100.00	4770.00	24	13	40921	1982	20.646316851665	0.0956259088064133	0.097156005230481	false	false	false	true
c1266cd5-4fc8-4822-b0f2-0eb6ff41240d	2026-09-22 12:00	2026-09-22 12:00	2026-09-22 12:00	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.4000	5.3000	5.4000	7762.7800	13500.00	13500.00	0.00	25	6	40995	1982	20.6836528758829	0.0966195078105658	0.0966195078105658	false	false	false	true
d2f1dc8c-2746-44e3-b8a1-518973232921	2026-09-22 12:00	2026-09-22 12:00	2026-09-22 12:00	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.0600	5.0000	5.2000	7762.4400	10120.00	510.00	9610.00	20	10	41137	1982	20.755297679112	0.0943507548193582	0.0943507548193582	false	false	false	true
33e8c306-bdbc-41b6-bd02-4094421ce060	2026-09-22 12:00	2026-09-22 12:00	2026-09-22 12:00	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.2000	5.2000	5.3000	7762.4400	29640.00	0.00	29640.00	57	17	41100	1982	20.736629667003	0.0958818531256308	0.0958818531256308	false	false	false	true
46100d65-a316-4fe3-ad04-b33297d1a5a5	2026-09-22 12:01	2026-09-22 12:00	2026-09-22 12:00	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.9000	4.9000	5.0000	7762.3900	11270.00	0.00	11270.00	23	8	41248	1982	20.811301715439	0.0916667554995609	0.0916667554995609	false	false	false	true
d548a08b-af89-49a4-9ea8-a710500a9b34	2026-09-22 12:02	2026-09-22 12:02	2026-09-22 12:02	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.2000	4.2000	4.3000	7759.7400	13860.00	0.00	13860.00	33	12	41794	1982	21.0867810292634	0.0977489274581203	0.0977489274581203	false	false	false	true
c97e9df9-37b0-41f1-9a88-736acfda0197	2026-09-22 12:02	2026-09-22 12:02	2026-09-22 12:02	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.3000	4.2000	4.3000	7759.7400	12900.00	12900.00	0.00	30	5	41876	1982	21.1281533804238	0.0993901104416323	0.0993901104416323	false	false	false	true
2ba1291f-3570-4f7b-a099-3720dadca1bb	2026-09-22 12:03	2026-09-22 12:03	2026-09-22 12:03	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.1000	4.1000	4.2000	7759.9300	12710.00	0.00	12710.00	31	22	41988	1982	21.1846619576186	0.0951885221232596	0.0951885221232596	false	false	false	true
9d6606d5-890b-4a11-aa44-5438a6bd2ac0	2026-09-22 12:04	2026-09-22 12:04	2026-09-22 12:04	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.5000	4.4000	4.5000	7760.8700	22500.00	22500.00	0.00	50	7	42466	1982	21.4258324924319	0.0960559511373085	0.0960559511373085	false	false	false	true
c626aab3-96df-4e19-86ef-39c0d5f3391c	2026-09-22 12:04	2026-09-22 12:04	2026-09-22 12:04	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.4900	4.4000	4.6000	7761.1600	14360.00	2700.00	11660.00	32	10	42588	1982	21.4873864783047	0.094268158803637	0.094268158803637	false	false	false	true
1893e5a3-3964-41f0-8094-df9c2a3b902f	2026-09-22 12:06	2026-09-22 12:06	2026-09-22 12:06	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.0000	3.9000	4.1000	7760.1600	12800.00	400.00	10800.00	32	16	43028	1982	21.7093844601413	0.0928342318348819	0.0928342318348819	false	false	false	true
e60ce2f8-92e5-4b7c-af14-dabca0ee2e39	2026-09-22 12:06	2026-09-22 12:06	2026-09-22 12:06	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.4400	4.3000	4.5000	7760.4800	133180.00	123940.00	0.00	300	46	43412	1982	21.9031281533804	0.0973603375014813	0.0989511720277086	false	false	false	true
2b9deb4e-a9f3-4f00-8000-b0ee5a176c39	2026-09-22 12:07	2026-09-22 12:06	2026-09-22 12:06	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.7000	4.7000	4.8000	7761.2800	23500.00	0.00	23500.00	50	11	43596	1982	21.9959636730575	0.0970676975425481	0.0970676975425481	false	false	false	true
e9807702-2bae-4b1b-b448-2f29924858d9	2026-09-22 12:07	2026-09-22 12:07	2026-09-22 12:07	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	4.8000	4.7000	4.8000	7761.5000	12960.00	12960.00	0.00	27	8	43711	1982	22.0539858728557	0.097282746111215	0.097282746111215	false	false	false	true
f975e635-e9b5-477d-9a4e-ab197e56bad6	2026-09-22 12:07	2026-09-22 12:07	2026-09-22 12:07	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.0000	4.9000	5.0000	7761.9600	20000.00	20000.00	0.00	40	13	43813	1982	22.1054490413724	0.0973975724464496	0.0973975724464496	false	false	false	true
fcdfc43c-95c0-4955-9aca-911cef0f2d20	2026-09-22 12:07	2026-09-22 12:07	2026-09-22 12:07	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.2000	5.1000	5.2000	7762.3200	41080.00	41080.00	0.00	79	17	44025	1982	22.2124117053481	0.0970453266309646	0.0981366487767537	false	false	false	true
3e4139f3-5d82-432d-a598-234e8159b02a	2026-09-22 12:07	2026-09-22 12:07	2026-09-22 12:07	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.3000	5.2000	5.4000	7762.0500	15900.00	14310.00	1590.00	30	12	44062	1982	22.2310797174571	0.101525116809357	0.101528823108077	false	false	false	true
27d5a333-1e5b-4d18-ac56-01d2985029ac	2026-09-22 12:07	2026-09-22 12:07	2026-09-22 12:07	SPXW	SPXW260922C07765000	call	7765.0000	2026-09-22	5.3000	5.2000	5.3500	7762.5600	20140.00	20140.00	0.00	38	14	44205	1982	22.303229061554	0.0980953438934529	0.0980953438934529	false	false	false	true