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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = SPOT×

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

48882c70-50eb-42f2-b54a-17d541f386e5	2026-09-03 15:37	2026-09-03 15:37	2026-09-03 15:37	SPOT	SPOT260918C00590000	call	590.0000	2026-09-18	5.9000	5.3500	5.9000	560.6450	56637.00	56637.00	0.00	96	36	102	264	0.386363636363636	0.35137850268884	0.35137850268884	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	114506693095.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T19:48:49.580975Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
8825b0ed-bdea-4265-bce0-622a490dd3b3	2026-09-03 14:55	2026-09-03 14:55	2026-09-03 14:55	SPOT	SPOT261002P00580000	put	580.0000	2026-10-02	31.6000	30.4000	31.6000	562.6000	221200.00	221200.00	0.00	70	19	110	10	11	0.357541411053757	0.357541411053757	false	false	false	true
00fef4d4-91f3-4d13-96bc-3be8708315b5	2026-09-03 13:48	2026-09-03 13:48	2026-09-03 13:48	SPOT	SPOT270115C00480000	call	480.0000	2027-01-15	111.8700	109.0500	113.2500	564.5400	134248.00	134248.00	0.00	12	9	12	177	0.0677966101694915	0.453591597862685	0.434012748957055	false	false	false
5fe059c5-504c-4137-8ce3-a091d8b192d7	2026-09-03 13:34	2026-09-03 13:34	2026-09-03 13:34	SPOT	SPOT261009C00520000	call	520.0000	2026-10-09	55.8900	51.4000	56.0000	565.2650	340925.00	184560.00	156365.00	61	5	68	1	68	0.377560833812652	0.378527888598435	false	false	false	true
dbb33f8f-bd0d-45fe-bd47-370820ee8167	2026-09-03 12:54	2026-09-03 12:54	2026-09-03 12:54	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	29.7500	29.0000	29.7500	561.0000	895470.00	892500.00	2970.00	301	48	625	726	0.860881542699725	0.365757626098754	0.365757626098754	false	false	false
49392dad-54e3-4a8d-abe1-7cf63b607414	2026-09-03 12:10	2026-09-03 12:10	2026-09-03 12:10	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	30.6500	30.4000	30.6500	563.4250	217615.00	217615.00	0.00	71	8	311	726	0.428374655647383	0.360031921990113	0.360031921990113	false	false	false
0fc09a87-4346-411b-a084-8d14cb3522f3	2026-09-03 11:24	2026-09-03 11:24	2026-09-03 11:24	SPOT	SPOT261016C00570000	call	570.0000	2026-10-16	27.3000	27.1500	27.8500	566.7300	51870.00	27300.00	16350.00	19	6	197	549	0.358834244080146	0.356114154375519	0.357404391280897	true	false	false
62bc20c2-0342-4c14-b0ee-912ea942687a	2026-09-03 11:16	2026-09-03 11:16	2026-09-03 11:16	SPOT	SPOT261009C00510000	call	510.0000	2026-10-09	66.1400	62.5000	67.8500	567.5650	231475.00	231475.00	0.00	35	7	47	0	0	0.394598353160087	0.394598353160087	false	false	false	true
e096b58f-4bb8-4bf0-92ef-ed0ee26a65b5	2026-09-03 11:12	2026-09-03 11:12	2026-09-03 11:12	SPOT	SPOT270115C00590000	call	590.0000	2027-01-15	49.9500	47.3000	49.9500	567.2700	129870.00	129870.00	0.00	26	7	26	283	0.0918727915194346	0.412231236833382	0.412231236833382	false	false	false
ad84e203-aa1c-4853-92a7-6b1696b5cfda	2026-09-03 10:58	2026-09-03 10:58	2026-09-03 10:58	SPOT	SPOT261016P00570000	put	570.0000	2026-10-16	30.0000	28.6500	30.4000	563.8901	504005.00	495000.00	9005.00	168	46	170	8	21.25	0.3652390191708	0.364997198069286	true	false	false	true
a0f42386-51eb-479c-882a-4ed79e1a7c79	2026-09-03 10:57	2026-09-03 10:57	2026-09-03 10:57	SPOT	SPOT261016C00570000	call	570.0000	2026-10-16	26.5500	26.0500	26.5500	564.3400	220365.00	220365.00	0.00	83	9	94	549	0.171220400728597	0.362923207560827	0.362923207560827	true	false	false
97a8fc7c-7ead-43b9-a739-bec5e7279543	2026-09-03 10:54	2026-09-03 10:54	2026-09-03 10:54	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	32.4000	31.9500	32.4000	565.5900	200880.00	200880.00	0.00	62	6	81	726	0.111570247933884	0.36695854287847	0.36695854287847	false	false	false
14418161-01c1-4bf0-b079-9a9e730dccda	2026-09-03 10:23	2026-09-03 10:23	2026-09-03 10:23	SPOT	SPOT261016C00550000	call	550.0000	2026-10-16	41.3500	40.7500	42.2500	569.6100	1116454.00	8270.00	1108184.00	270	64	289	172	1.68023255813953	0.37203200605323	0.379764957069898	true	false	false
30deb5fc-59f0-4dbf-8c0d-60a2b404bb37	2026-09-02 14:14	2026-09-02 14:14	2026-09-02 14:14	SPOT	SPOT261009P00510000	put	510.0000	2026-10-09	8.3100	7.5500	9.9500	560.6500	77310.00	37510.00	39800.00	93	9	118	1	118	0.394304269930955	0.39530975468913	false	false	false	true
1fc59430-f842-46b2-8f15-49352134f6d7	2026-09-02 13:38	2026-09-02 13:38	2026-09-02 13:38	SPOT	SPOT261218C00550000	call	550.0000	2026-12-18	58.2500	57.7000	59.5500	558.6300	1095097.00	11640.00	1083457.00	188	51	194	75	2.58666666666667	0.423607103824468	0.423461843525051	false	false	false
469c5f09-f403-4090-abcc-107462576391	2026-09-02 11:55	2026-09-02 11:55	2026-09-02 11:55	SPOT	SPOT260904C00570000	call	570.0000	2026-09-04	3.0500	3.0000	3.8500	558.7600	80245.00	915.00	79330.00	263	55	330	735	0.448979591836735	0.438221289143056	0.438221289143056	false	false	false
14b34826-ee2d-46b4-8ddc-b7a4d8b95b3d	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	SPOT	SPOT260918P00570000	put	570.0000	2026-09-18	22.5000	22.5000	24.2500	560.7950	51750.00	0.00	51750.00	23	5	26	17	1.52941176470588	0.383273722477535	0.383273722477535	false	false	false	true
e2eeee0e-4b24-45b5-a734-81c1cf8284c3	2026-09-01 15:18	2026-09-01 15:18	2026-09-01 15:18	SPOT	SPOT271217P00480000	put	480.0000	2027-12-17	64.9800	64.9500	68.9500	542.6300	97465.00	0.00	97465.00	15	5	17	25	0.68	0.463774768486259	0.464261868045175	false	false	false	true
85b31101-8693-456e-9858-de4934a9972e	2026-09-01 14:00	2026-09-01 14:00	2026-09-01 14:00	SPOT	SPOT280121P00320000	put	320.0000	2028-01-21	18.1000	18.1000	19.5000	542.8150	65160.00	0.00	65160.00	36	12	44	323	0.136222910216718	0.488561060718453	0.488561060718453	false	false	false	true
c90de888-c4c2-4729-9c8f-49b683fa5689	2026-09-01 12:09	2026-09-01 12:09	2026-09-01 12:09	SPOT	SPOT260904P00537500	put	537.5000	2026-09-04	5.4500	4.9000	5.7500	544.0000	101374.00	100274.00	560.00	186	52	186	12	15.5	0.438733705978757	0.435885772520045	false	false	false	true
adc074e4-e0c8-41ed-a5ca-373a8e0ec07d	2026-09-01 11:00	2026-09-01 11:00	2026-09-01 11:00	SPOT	SPOT270319P00450000	put	450.0000	2027-03-19	25.1500	23.3500	26.4000	546.3000	120720.00	20120.00	100600.00	48	9	48	85	0.564705882352941	0.4509729515976	0.4509729515976	false	false	false	true
1096aa10-8d4e-4418-a1cd-f5a83e1912d1	2026-08-31 15:16	2026-08-31 15:16	2026-08-31 15:16	SPOT	SPOT261218P00500000	put	500.0000	2026-12-18	28.3000	28.2000	29.3500	542.9150	67910.00	19915.00	47995.00	24	7	24	336	0.0714285714285714	0.432574077986172	0.434986449177022	false	false	false
0bc57bb4-1bf0-494e-bfd1-008b7b85978f	2026-08-31 15:16	2026-08-31 15:16	2026-08-31 15:16	SPOT	SPOT261218P00500000	put	500.0000	2026-12-18	28.1600	27.9000	28.7000	542.9800	259060.00	30950.00	225315.00	92	9	117	336	0.348214285714286	0.434504128714214	0.430349544450659	false	false	false
9f11de9b-2e55-4e89-918f-1185b05a6d96	2026-08-31 14:28	2026-08-31 14:28	2026-08-31 14:28	SPOT	SPOT271217C00780000	call	780.0000	2027-12-17	55.3700	54.6500	56.8000	541.3900	337745.00	77510.00	254705.00	61	26	67	72	0.930555555555556	0.460662186906244	0.460018503567176	false	false	false
7affbe0a-06c4-4323-b529-a255d5f0730a	2026-08-28 12:34	2026-08-28 12:33	2026-08-28 12:33	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	26.3000	25.8500	26.3000	548.5500	73640.00	73640.00	0.00	28	7	92	794	0.115869017632242	0.376538757261315	0.376538757261315	false	false	false
9c389e07-8dea-494d-b6e1-b9a54bf6475d	2026-08-28 12:28	2026-08-28 12:28	2026-08-28 12:28	SPOT	SPOT270115P00490000	put	490.0000	2027-01-15	28.4600	27.4500	28.7500	548.3800	569241.00	569241.00	0.00	200	8	205	285	0.719298245614035	0.434581349017959	0.434403660121328	false	false	false
c75fcad4-7010-44ff-b153-fe2a551d9f5c	2026-08-28 12:21	2026-08-28 12:21	2026-08-28 12:21	SPOT	SPOT261016C00680000	call	680.0000	2026-10-16	2.7200	2.2300	2.7200	549.9200	94928.00	94928.00	0.00	349	42	376	25	15.04	0.38562460858246	0.38562460858246	true	false	false	true
1d147c18-1bad-4da6-b1e0-a4b5e6386e50	2026-08-28 12:21	2026-08-28 12:21	2026-08-28 12:21	SPOT	SPOT261016C00570000	call	570.0000	2026-10-16	23.0000	22.3000	23.6000	549.9200	85100.00	85100.00	0.00	37	9	122	566	0.215547703180212	0.377951540824621	0.377951540824621	false	false	false
d92532e3-2d95-4d8a-85ca-f5a2f5d806b4	2026-08-28 11:33	2026-08-28 11:33	2026-08-28 11:33	SPOT	SPOT260925C00585000	call	585.0000	2026-09-25	10.6400	8.3500	11.3000	552.8900	76595.00	53150.00	23445.00	72	11	72	13	5.53846153846154	0.359767993423434	0.367120175843072	true	false	false
357a42ec-82e7-4925-9f89-83baa6051a89	2026-08-28 11:32	2026-08-28 11:31	2026-08-28 11:31	SPOT	SPOT260918C00580000	call	580.0000	2026-09-18	8.7000	8.5500	9.9500	550.9600	56550.00	55680.00	870.00	65	22	106	2164	0.0489833641404806	0.361390220239538	0.361390220239538	false	false	false
a3f5ec95-6280-465e-99b1-ba52c541227e	2026-08-28 11:24	2026-08-28 11:24	2026-08-28 11:24	SPOT	SPOT261016C00590000	call	590.0000	2026-10-16	16.1800	16.1000	16.2500	550.4200	50170.00	0.00	50170.00	31	6	95	129	0.736434108527132	0.373525004109174	0.374871781590259	false	false	false
879d2eea-9215-463f-8cab-7bd5fb8f0201	2026-08-28 10:27	2026-08-28 10:27	2026-08-28 10:27	SPOT	SPOT280121P00450000	put	450.0000	2028-01-21	57.6900	57.6000	62.7000	541.0000	115380.00	0.00	115380.00	20	5	22	208	0.105769230769231	0.473098301500999	0.475623842040737	false	false	false
3c25a498-47f0-4f0d-aaef-54545bc07667	2026-08-28 10:20	2026-08-28 10:20	2026-08-28 10:20	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	22.5900	21.3500	22.7500	540.7600	99390.00	56630.00	40500.00	44	12	47	794	0.0591939546599496	0.376527407927632	0.375248378505279	false	false	false
b35003e1-be76-4339-a8ec-cd718e976535	2026-08-27 14:54	2026-08-27 14:53	2026-08-27 14:53	SPOT	SPOT260904P00525000	put	525.0000	2026-09-04	10.9900	9.1500	11.0000	527.7000	54955.00	54955.00	0.00	50	6	329	32	10.28125	0.401865958419347	0.402513099552248	false	false	false	true
d561e6e4-50e9-4b16-b980-77bb379dbc43	2026-08-27 11:24	2026-08-27 11:24	2026-08-27 11:24	SPOT	SPOT261016P00480000	put	480.0000	2026-10-16	10.0500	9.4000	10.0500	528.7600	101505.00	101505.00	0.00	101	27	112	194	0.577319587628866	0.386740120472025	0.386740120472025	false	false	false
ffd712a0-d3d0-48f5-87b2-5627715b6177	2026-08-27 11:09	2026-08-27 11:09	2026-08-27 11:09	SPOT	SPOT270319P00480000	put	480.0000	2027-03-19	39.9900	39.7000	41.8000	528.2500	399850.00	200100.00	199750.00	100	5	207	164	1.26219512195122	0.436927169405255	0.435476012930434	false	false	false
96ca730b-885e-4c5a-97b3-d1b5f00dfe36	2026-08-26 15:44	2026-08-26 15:44	2026-08-26 15:44	SPOT	SPOT260828P00542500	put	542.5000	2026-08-28	3.3000	3.3000	4.2000	551.6800	54452.00	0.00	54452.00	165	45	170	4	42.5	0.432416428731187	0.432416428731187	false	false	false	true
b0883fd7-6c01-4b82-a658-592b9b9ca23f	2026-08-26 12:31	2026-08-26 12:31	2026-08-26 12:31	SPOT	SPOT261218C00800000	call	800.0000	2026-12-18	4.0500	4.0500	4.7500	544.9400	74520.00	0.00	74520.00	184	42	184	248	0.741935483870968	0.428260358748693	0.428260358748693	false	false	false
155d4978-b407-4d8a-b4e3-4353b8a2d505	2026-08-26 10:46	2026-08-26 10:46	2026-08-26 10:46	SPOT	SPOT270617P00470000	put	470.0000	2027-06-17	44.3500	41.2000	44.4500	546.9100	62085.00	57660.00	4425.00	14	6	15	46	0.326086956521739	0.462202706867388	0.462761208998483	true	false	false	true
1a9da378-7e95-47ef-96dc-138098dbe0ab	2026-08-25 14:05	2026-08-25 14:05	2026-08-25 14:05	SPOT	SPOT260904C00570000	call	570.0000	2026-09-04	6.6000	5.5500	6.6000	549.0000	65992.00	65992.00	0.00	100	28	114	24	4.75	0.388748315712452	0.388748315712452	false	false	false	true
c59ddd94-5b75-4650-b317-050e3aff7d64	2026-08-25 09:50	2026-08-25 09:50	2026-08-25 09:50	SPOT	SPOT260911P00575000	put	575.0000	2026-09-11	34.9000	31.0500	34.9000	548.4500	432760.00	432760.00	0.00	124	38	124	1	124	0.404473164629796	0.404473164629796	false	false	false	true
80de809d-52b9-4b40-8bac-58f75f5ad645	2026-08-25 09:34	2026-08-25 09:34	2026-08-25 09:34	SPOT	SPOT260918C00540000	call	540.0000	2026-09-18	23.4800	22.1500	23.9000	543.7000	251215.00	63700.00	187515.00	107	7	119	1441	0.0825815405968078	0.379142595334176	0.373691958269891	true	false	false
2ed9f83b-145f-48ae-afb6-573cfbfac168	2026-08-21 13:51	2026-08-21 13:50	2026-08-21 13:50	SPOT	SPOT260904P00535000	put	535.0000	2026-09-04	15.1000	14.1000	15.1000	534.5500	291424.00	289919.00	1505.00	193	48	194	13	14.9230769230769	0.36566223922045	0.36566223922045	false	false	false
96a219d9-8ea3-41c3-b061-efc8139a301f	2026-08-21 12:45	2026-08-21 12:44	2026-08-21 12:44	SPOT	SPOT260911P00550000	put	550.0000	2026-09-11	23.9000	22.7500	23.9000	538.8500	88430.00	88430.00	0.00	37	16	37	1	37	0.355646199470568	0.355646199470568	false	false	false	true
92dc3189-aca8-4f37-92c3-d34a9840cfb9	2026-08-21 10:18	2026-08-21 10:18	2026-08-21 10:18	SPOT	SPOT261016C00540000	call	540.0000	2026-10-16	30.2500	30.2500	31.6500	533.2050	163350.00	0.00	163350.00	54	33	57	138	0.41304347826087	0.383689207869558	0.383689207869558	true	false	false
d5ebab0a-0f19-4204-a0e8-0d36e1b36846	2026-08-21 10:15	2026-08-21 10:14	2026-08-21 10:14	SPOT	SPOT260828C00540000	call	540.0000	2026-08-28	8.3800	8.0500	8.6500	534.1600	63660.00	36940.00	1670.00	76	31	150	127	1.18110236220472	0.366058765868206	0.36777896644624	false	false	false
900ddc9f-f68e-454e-8edf-8666a9fe43d3	2026-08-21 09:31	2026-08-21 09:31	2026-08-21 09:31	SPOT	SPOT270115C00640000	call	640.0000	2027-01-15	23.6300	23.6000	28.3500	532.7750	70880.00	0.00	33040.00	30	6	30	237	0.126582278481013	0.410391791228595	0.410391791228595	false	false	false
26bec5c8-32b0-467b-94d5-d25d185d1df9	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	SPOT	SPOT260821C00470000	call	470.0000	2026-08-21	64.7500	63.0500	64.7500	534.4600	84181.00	71231.00	0.00	13	13	201	504	0.398809523809524	1.2051344920655	1.2051344920655	true	false	false	true
fabe49e6-81c0-4ca4-80a1-acf0d291e947	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	SPOT	SPOT260821C00470000	call	470.0000	2026-08-21	64.7000	64.3500	67.7500	534.6200	213510.00	0.00	213510.00	33	16	183	504	0.363095238095238	0.932816461622682	0.932816461622682	false	false	false
e2e04a1d-2237-49ab-97e7-a914cc4101e5	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	SPOT	SPOT260821C00470000	call	470.0000	2026-08-21	64.7000	63.2500	67.9500	534.6050	310570.00	0.00	310570.00	48	19	119	504	0.236111111111111	1.06194054582312	0.97301246343121	false	false	false