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:er_time = unknown×ticker = SMR×

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

b1e9533f-baa4-42e6-a082-1fa2feb16a79	2026-08-19 12:02	2026-08-19 12:02	2026-08-19 12:02	SMR	SMR260821C00009500	call	9.5000	2026-08-21	0.1000	0.0900	0.1000	9.0900	16030.00	16030.00	0.00	1603	54	2502	2490	1.00481927710843	0.924336969185242	0.923850103133702	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	3492414832.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
65fe5d23-c4cb-4123-ac5d-4727abcb153f	2026-08-19 10:40	2026-08-19 10:40	2026-08-19 10:40	SMR	SMR260918P00008000	put	8.0000	2026-09-18	0.3900	0.3800	0.4000	8.7650	11583.00	11115.00	0.00	297	20	322	1889	0.170460561143462	0.750704422170809	0.750704422170809	false	false	false	true	false
38c273d8-8398-42d2-9237-df1e53ad23b7	2026-08-19 09:56	2026-08-19 09:56	2026-08-19 09:56	SMR	SMR260904C00009500	call	9.5000	2026-09-04	0.2600	0.2400	0.3600	8.6700	13093.00	0.00	13093.00	500	5	546	315	1.73333333333333	0.779411330319045	0.779411330319045	false	false	false	true	false
b64743e8-3e1f-4f2e-9ee4-574afbf38985	2026-08-18 11:46	2026-08-18 11:45	2026-08-18 11:45	SMR	SMR261002C00009000	call	9.0000	2026-10-02	0.8800	0.8100	0.8900	8.7000	17551.00	17551.00	0.00	200	12	225	4	56.25	0.806102707255789	0.806102707255789	false	false	false	true	false
0495b8c8-85df-4f65-a298-a79308c9a3b3	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	SMR	SMR260918C00011000	call	11.0000	2026-09-18	0.1800	0.1800	0.2000	8.6949	14490.00	0.00	14490.00	805	35	3814	4239	0.899740504836046	0.784209786115552	0.784209786115552	false	false	false	true
17c31f9f-bbb9-411a-8560-ef07f1102b24	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	SMR	SMR260918C00011000	call	11.0000	2026-09-18	0.1800	0.1800	0.2000	8.7050	23652.00	0.00	23652.00	1314	42	3009	4239	0.709837225760793	0.781454117177011	0.781454117177011	false	false	false	true
1d4c0a8f-699b-44a0-8606-4264c7121dd8	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	SMR	SMR260918C00011000	call	11.0000	2026-09-18	0.1900	0.1900	0.2000	8.7199	22572.00	0.00	22572.00	1188	23	1694	4239	0.399622552488795	0.792012879380725	0.792012879380725	false	false	false	true
4033751c-32ae-4835-8fbf-566cdf6f2a03	2026-08-18 09:34	2026-08-18 09:34	2026-08-18 09:34	SMR	SMR280121C00008000	call	8.0000	2028-01-21	4.3500	4.3500	4.4500	8.8600	10005.00	0.00	3480.00	23	15	24	5188	0.0046260601387818	0.991040357453979	0.991040357453979	false	false	false	true	false
51639b72-a640-48fc-a219-dc3ed2746960	2026-08-18 09:30	2026-08-18 09:30	2026-08-18 09:30	SMR	SMR260828P00009500	put	9.5000	2026-08-28	0.8500	0.5300	0.9500	8.8300	147220.00	135915.00	6970.00	1732	10	2005	198	10.1262626262626	0.762030658052691	0.734883528312302	false	false	false	true
b6365791-f6e8-4086-b50a-383595645b4b	2026-08-18 09:30	2026-08-18 09:30	2026-08-18 09:30	SMR	SMR260828P00009500	put	9.5000	2026-08-28	0.8500	0.5100	0.8500	8.8500	10115.00	10115.00	0.00	119	6	271	198	1.36868686868687	0.762030658052691	0.762030658052691	false	false	false	true	false
6f071c1a-674d-4087-805d-f0bde992f8d4	2026-08-17 15:50	2026-08-17 15:50	2026-08-17 15:50	SMR	SMR260821P00009500	put	9.5000	2026-08-21	0.5300	0.4500	0.5300	9.1650	26500.00	26500.00	0.00	500	11	2584	2879	0.897533865925669	0.870536066153437	0.870536066153437	true	false	false	true	false
3fac7005-6878-4db2-9c6f-9aa4072f97fe	2026-08-17 14:35	2026-08-17 14:35	2026-08-17 14:35	SMR	SMR260821P00009500	put	9.5000	2026-08-21	0.4600	0.4500	0.4700	9.2700	13754.00	4278.00	9476.00	299	16	1787	2879	0.620701632511289	0.854965178545428	0.854965178545428	false	false	false	true	false
cf905887-3fda-4efa-a53f-5c2162af4bc4	2026-08-17 12:10	2026-08-17 12:10	2026-08-17 12:10	SMR	SMR270115C00015000	call	15.0000	2027-01-15	0.9100	0.8800	0.9200	9.4000	10283.00	10192.00	91.00	113	10	335	14423	0.0232267905428829	0.937173168886421	0.937173168886421	false	false	false	true
26ad5799-0e7b-4879-8d13-2d099ec73a94	2026-08-17 11:16	2026-08-17 11:16	2026-08-17 11:16	SMR	SMR280121C00008000	call	8.0000	2028-01-21	4.7100	4.7000	4.8000	9.3750	20714.00	0.00	20714.00	44	5	45	5233	0.00859927383909803	0.975534989808731	0.978544595732834	false	false	false	true	false
dea475a9-0c89-4967-8073-aa4679a67d9f	2026-08-17 09:32	2026-08-17 09:32	2026-08-17 09:32	SMR	SMR260821P00010000	put	10.0000	2026-08-21	0.7500	0.7000	0.8400	9.4300	37650.00	0.00	37650.00	502	27	504	6910	0.0729377713458755	1.0012980646883	1.0012980646883	true	false	false	true	false
12836db7-510d-4c3d-8458-6caf08287d2b	2026-08-17 09:30	2026-08-17 09:30	2026-08-17 09:30	SMR	SMR261120P00010000	put	10.0000	2026-11-20	2.0200	1.9600	2.0500	9.3800	26058.00	14140.00	808.00	129	30	429	3282	0.130712979890311	0.896552231360302	0.898957392819554	false	false	false	true	false
2f920840-8383-4761-a571-2a6ce660f608	2026-08-17 09:30	2026-08-17 09:30	2026-08-17 09:30	SMR	SMR261120P00010000	put	10.0000	2026-11-20	1.9900	1.5100	2.5300	9.4300	59700.00	31243.00	6368.00	300	8	300	3282	0.0914076782449726	0.895104265112128	0.895104265112128	false	false	false	true