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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = DINO×

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

8bc64b49-67a3-47e6-a6ec-874fc3d0f0d0	2026-09-16 15:20	2026-09-16 15:20	2026-09-16 15:20	DINO	DINO260918C00120000	call	120.0000	2026-09-18	0.4000	0.3000	0.5500	113.3600	23680.00	40.00	23640.00	592	12	854	330	2.58787878787879	0.689772609368945	0.689772609368945	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	20262025271.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T19:29:08.379560Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
6a2740d4-cfd3-44b2-8d2b-2bb70c4d6816	2026-09-16 15:20	2026-09-16 15:20	2026-09-16 15:20	DINO	DINO260918C00120000	call	120.0000	2026-09-18	0.4000	0.4000	0.5500	113.3600	10000.00	0.00	10000.00	250	13	262	330	0.793939393939394	0.689772609368945	0.689772609368945	false	false	false
67d6bab5-5047-4896-abe1-a4f8d718fd0e	2026-09-16 15:11	2026-09-16 15:10	2026-09-16 15:10	DINO	DINO261016P00105000	put	105.0000	2026-10-16	3.7000	3.3000	3.7000	113.3400	14800.00	14800.00	0.00	40	10	75	688	0.109011627906977	0.580540047250284	0.580540047250284	true	false	false	true
c80b812e-d171-452b-9ef0-27baea367514	2026-09-16 14:48	2026-09-16 14:48	2026-09-16 14:48	DINO	DINO260918C00115000	call	115.0000	2026-09-18	1.7000	1.7000	1.9500	113.9450	22100.00	0.00	22100.00	130	15	1123	3627	0.309622277364213	0.643954428831116	0.643954428831116	false	false	false
2386201e-ca81-4de8-aece-a814be43c5e9	2026-09-16 14:48	2026-09-16 14:48	2026-09-16 14:48	DINO	DINO261016C00120000	call	120.0000	2026-10-16	5.4000	4.8000	5.4000	113.9700	68040.00	68040.00	0.00	126	6	1063	300	3.54333333333333	0.592466193885476	0.592466193885476	false	false	false	true
91314e3b-521a-4ec2-9a18-f3af88847036	2026-09-16 14:48	2026-09-16 14:47	2026-09-16 14:47	DINO	DINO261016C00120000	call	120.0000	2026-10-16	5.3000	4.9000	5.3000	114.0175	67840.00	67840.00	0.00	128	28	920	300	3.06666666666667	0.583076871642471	0.583076871642471	false	false	false	true
ec8d0aad-5b22-4ef8-bc2b-567a2c343d76	2026-09-16 14:47	2026-09-16 14:47	2026-09-16 14:47	DINO	DINO261016C00120000	call	120.0000	2026-10-16	5.2000	4.9000	5.2000	113.7800	220460.00	220460.00	0.00	424	26	792	300	2.64	0.575134047168774	0.583003487464924	false	false	false	true
ac6d3d2a-14bf-47be-baf7-eea82269972c	2026-09-16 14:47	2026-09-16 14:47	2026-09-16 14:47	DINO	DINO261016C00120000	call	120.0000	2026-10-16	5.1000	4.7000	5.1000	113.7738	133110.00	133110.00	0.00	261	32	336	300	1.12	0.575335481927538	0.575335481927538	false	false	false	true
6a9939bf-0839-4dc0-8c84-2d5b96866ea1	2026-09-16 14:33	2026-09-16 14:32	2026-09-16 14:32	DINO	DINO261218C00120000	call	120.0000	2026-12-18	11.0000	10.7000	11.1000	114.2200	22000.00	17600.00	4400.00	20	10	28	230	0.121739130434783	0.561748844954773	0.561748844954773	false	false	false
63f48117-797c-435b-84d3-3d7dc9988c77	2026-09-16 14:32	2026-09-16 14:32	2026-09-16 14:32	DINO	DINO261218P00120000	put	120.0000	2026-12-18	16.0600	16.0000	17.2000	114.2200	22486.00	6436.00	16050.00	14	5	15	3	5	0.58758841854314	0.583240171037704	false	false	false	true
a4cfa5e6-e1e2-49f1-bed1-767b9efddae3	2026-09-16 14:26	2026-09-16 14:26	2026-09-16 14:26	DINO	DINO270115C00120000	call	120.0000	2027-01-15	12.4100	12.4000	12.8000	114.2300	11170.00	1250.00	9920.00	9	5	45	76	0.592105263157895	0.540085464963268	0.540085464963268	false	false	false
bd29a45d-6246-4abd-a888-b31eb792fd0a	2026-09-16 14:19	2026-09-16 14:19	2026-09-16 14:19	DINO	DINO270115C00120000	call	120.0000	2027-01-15	12.3000	12.3000	12.8000	114.0375	34440.00	0.00	34440.00	28	8	36	76	0.473684210526316	0.540055883629223	0.540055883629223	false	false	false
2f7c0f50-64d9-4841-9e7a-d94b7aeb27a5	2026-09-16 10:30	2026-09-16 10:30	2026-09-16 10:30	DINO	DINO270115P00110000	put	110.0000	2027-01-15	13.0700	13.0000	13.4000	110.0000	13070.00	1310.00	11760.00	10	7	10	329	0.0303951367781155	0.569586135597863	0.565555047476288	false	false	false
672db99f-6fab-42e6-8138-1455cbc4aae9	2026-09-15 14:52	2026-09-15 14:52	2026-09-15 14:52	DINO	DINO260918P00105000	put	105.0000	2026-09-18	0.4500	0.4000	0.6000	112.4700	20475.00	19215.00	1080.00	455	26	467	463	1.00863930885529	0.684008280032439	0.684008280032439	false	false	false
651d37a6-b3ce-447a-8de4-364ad976d434	2026-09-15 14:11	2026-09-15 14:11	2026-09-15 14:11	DINO	DINO261218C00155000	call	155.0000	2026-12-18	2.6000	2.4500	2.6000	112.2650	22360.00	22360.00	0.00	86	21	86	12	7.16666666666667	0.563038061117015	0.563038061117015	false	false	false	true
2561f1f8-dc85-45b6-b58c-18287818febb	2026-09-15 14:11	2026-09-15 14:11	2026-09-15 14:11	DINO	DINO261218C00160000	call	160.0000	2026-12-18	2.1500	1.8500	2.1500	112.2650	15480.00	15480.00	0.00	72	19	72	0	0	0.565955186907308	0.565955186907308	false	false	false	true
ca6aab30-352c-453c-ba9d-9531ad90c4b9	2026-09-15 13:56	2026-09-15 13:55	2026-09-15 13:55	DINO	DINO260918C00110000	call	110.0000	2026-09-18	3.9000	3.7000	4.1000	112.1450	31590.00	0.00	14040.00	81	9	227	2769	0.0819790538100397	0.664651970922458	0.664651970922458	false	false	false
9e371400-ed5a-4704-be88-e05838eb2f55	2026-09-15 13:30	2026-09-15 13:29	2026-09-15 13:29	DINO	DINO260918P00110000	put	110.0000	2026-09-18	1.9000	1.7500	1.9500	111.4300	12160.00	12160.00	0.00	64	9	295	51	5.7843137254902	0.64113066251065	0.64113066251065	false	false	false	true
ca995ed0-fc53-4705-8d9d-9e93838428f1	2026-09-15 11:07	2026-09-15 11:07	2026-09-15 11:07	DINO	DINO270115C00110000	call	110.0000	2027-01-15	13.3000	13.1000	13.3000	109.0000	289940.00	289940.00	0.00	218	16	501	2905	0.172461273666093	0.524072088335988	0.524072088335988	false	false	false
c6e9e11f-c485-4ca1-bc0a-4b4f577a8ea2	2026-09-15 11:07	2026-09-15 11:07	2026-09-15 11:07	DINO	DINO270115C00110000	call	110.0000	2027-01-15	13.4000	13.2000	13.4000	109.0000	40200.00	40200.00	0.00	30	5	283	2905	0.0974182444061962	0.525480531350015	0.525480531350015	false	false	false
b0024da8-8bdc-4832-8778-b8b7e145177d	2026-09-15 11:06	2026-09-15 11:06	2026-09-15 11:06	DINO	DINO270115C00110000	call	110.0000	2027-01-15	13.5000	13.4000	13.8000	109.0000	337500.00	41850.00	43200.00	250	8	251	2905	0.0864027538726334	0.523335785365974	0.523335785365974	false	false	false
273623f3-3766-48c3-b07b-9ab6673aa985	2026-09-15 10:29	2026-09-15 10:29	2026-09-15 10:29	DINO	DINO260918P00110000	put	110.0000	2026-09-18	2.9000	2.4500	2.9000	110.0350	62584.00	62584.00	0.00	216	12	226	51	4.43137254901961	0.737902444669794	0.732872355063675	true	false	false	true
c1895f6c-19ab-4f92-9159-309c91357447	2026-09-15 10:16	2026-09-15 10:16	2026-09-15 10:16	DINO	DINO270115P00105000	put	105.0000	2027-01-15	10.4000	10.1000	10.4000	109.8300	31200.00	31200.00	0.00	30	10	30	33	0.909090909090909	0.53916223560231	0.53916223560231	false	false	false	true
59197b6d-a792-4dfa-9cbe-8551a048d185	2026-09-15 10:16	2026-09-15 10:16	2026-09-15 10:16	DINO	DINO270115P00110000	put	110.0000	2027-01-15	13.0000	12.6000	13.0000	109.8300	81900.00	81900.00	0.00	63	19	64	266	0.240601503759398	0.540584293951842	0.540584293951842	false	false	false	true
3ff09df9-a8e9-4210-874a-a41e5d1e0e11	2026-09-14 13:03	2026-09-14 13:03	2026-09-14 13:03	DINO	DINO270319P00115000	put	115.0000	2027-03-19	20.4000	19.8000	20.4000	106.2850	306000.00	306000.00	0.00	150	33	351	3	117	0.553479689768638	0.553479689768638	false	false	false	true
132941d8-9843-42de-bdc1-d24f9577260f	2026-09-14 12:49	2026-09-14 12:49	2026-09-14 12:49	DINO	DINO271119C00160000	call	160.0000	2027-11-19	9.3500	8.4000	10.3000	106.5350	13090.00	6580.00	6510.00	14	5	20	0	0	0.470742886267628	0.47311788275701	false	false	false	true
e79f7451-a538-462d-8fb6-c4232daab47d	2026-09-14 10:44	2026-09-14 10:44	2026-09-14 10:44	DINO	DINO270115C00110000	call	110.0000	2027-01-15	14.0000	13.5000	15.1000	110.4900	700023.00	0.00	700023.00	500	6	500	2431	0.205676676264912	0.522698408043917	0.522698408043917	false	false	false
bd32e643-7de0-494b-96ef-9f801767f607	2026-09-11 14:05	2026-09-11 14:05	2026-09-11 14:05	DINO	DINO260918P00105000	put	105.0000	2026-09-18	1.4000	1.4000	1.4500	109.1200	52500.00	19460.00	1400.00	375	61	390	177	2.20338983050847	0.516142093152883	0.516142093152883	false	false	false
984e2245-f0eb-4a26-a855-efaf650aa044	2026-09-10 14:07	2026-09-10 14:07	2026-09-10 14:07	DINO	DINO261218P00110000	put	110.0000	2026-12-18	11.9000	11.9000	12.2000	109.6550	99960.00	0.00	99960.00	84	25	85	24	3.54166666666667	0.54493311979365	0.54493311979365	false	false	false	true
9850dff4-a281-4b81-af86-293c3c6ac8b2	2026-09-10 12:41	2026-09-10 12:41	2026-09-10 12:41	DINO	DINO260918C00115000	call	115.0000	2026-09-18	1.5000	1.3000	1.5000	109.0000	45890.00	45890.00	0.00	306	43	623	1705	0.365395894428153	0.533266528858241	0.533266528858241	false	false	false
cd088e66-6031-4f68-a085-2686baec3fca	2026-09-10 12:41	2026-09-10 12:41	2026-09-10 12:41	DINO	DINO260918C00110000	call	110.0000	2026-09-18	3.1000	3.1000	3.4000	109.0000	46191.00	0.00	46191.00	149	28	570	3828	0.148902821316614	0.500980857200086	0.500980857200086	false	false	false
3c49646f-4624-4d41-afca-002deb04b10d	2026-09-10 12:41	2026-09-10 12:41	2026-09-10 12:41	DINO	DINO260918C00110000	call	110.0000	2026-09-18	3.1000	3.1000	3.4000	109.0000	49601.00	0.00	49601.00	160	44	421	3828	0.109979101358412	0.500980857200086	0.500980857200086	false	false	false
aa222b41-3b42-4618-afea-332380ad7405	2026-09-09 10:14	2026-09-09 10:13	2026-09-09 10:13	DINO	DINO260918C00110000	call	110.0000	2026-09-18	2.3500	2.3500	2.6500	106.7800	161210.00	0.00	161210.00	686	53	692	3801	0.182057353328072	0.545592607050206	0.545592607050206	false	false	false
3e9702b8-8a80-43e7-ba3a-b52b4c050f0e	2026-09-08 09:46	2026-09-08 09:46	2026-09-08 09:46	DINO	DINO260918C00110000	call	110.0000	2026-09-18	3.3000	3.3000	3.6000	108.6900	20790.00	0.00	20790.00	63	23	786	5416	0.145125553914328	0.536238846817042	0.536238846817042	false	false	false
544fdf8f-9a8e-4a96-99df-bf02bf3b2dde	2026-09-08 09:46	2026-09-08 09:46	2026-09-08 09:46	DINO	DINO260918C00110000	call	110.0000	2026-09-18	3.3000	3.3000	3.6000	108.7650	37620.00	0.00	37620.00	114	13	723	5416	0.133493353028065	0.531317071468148	0.531317071468148	false	false	false
a5782e8d-622a-4a7d-92c4-c8c61261dadc	2026-09-08 09:46	2026-09-08 09:46	2026-09-08 09:46	DINO	DINO260918C00110000	call	110.0000	2026-09-18	3.3000	3.3000	3.6000	108.6550	28710.00	0.00	28710.00	87	11	384	5416	0.0709010339734121	0.538528726950979	0.538528726950979	false	false	false
1b8d5e53-3283-48d1-b233-fbf1f52557ae	2026-09-04 15:19	2026-09-04 15:19	2026-09-04 15:19	DINO	DINO270115C00140000	call	140.0000	2027-01-15	4.3000	4.2000	4.3000	105.4025	11610.00	11610.00	0.00	27	14	59	112	0.526785714285714	0.531501389509492	0.531501389509492	false	false	false	true
8f394578-5358-410a-8bad-1966de89d035	2026-09-03 14:09	2026-09-03 14:09	2026-09-03 14:09	DINO	DINO261218P00105000	put	105.0000	2026-12-18	10.7000	10.7000	10.9000	106.5100	47080.00	0.00	47080.00	44	10	54	34	1.58823529411765	0.530908086540627	0.530908086540627	false	false	false	true
c99e28b5-0924-4a66-9f05-60469db1d1f1	2026-09-03 13:52	2026-09-03 13:52	2026-09-03 13:52	DINO	DINO270319P00090000	put	90.0000	2027-03-19	7.3000	7.3000	7.7000	106.4750	22630.00	0.00	22630.00	31	14	31	51	0.607843137254902	0.521610491694157	0.521610491694157	false	false	false	true
6cf7616e-03e4-40c2-99fa-9be1242afaf8	2026-09-03 13:50	2026-09-03 13:50	2026-09-03 13:50	DINO	DINO261016P00110000	put	110.0000	2026-10-16	9.1000	9.1000	9.5000	106.4000	364008.00	0.00	364008.00	400	44	400	2	200	0.498935045214413	0.503720575029212	true	false	false	true
66deabe4-ef37-4e6b-846b-827cd63f5092	2026-09-03 13:37	2026-09-03 13:37	2026-09-03 13:37	DINO	DINO270115C00140000	call	140.0000	2027-01-15	4.6000	4.5000	4.6000	106.4700	10120.00	10120.00	0.00	22	5	51	61	0.836065573770492	0.530603722498215	0.530603722498215	false	false	false	true
9041f105-5692-4b45-97c0-037b12650cc6	2026-09-02 15:52	2026-09-02 15:52	2026-09-02 15:52	DINO	DINO270115C00100000	call	100.0000	2027-01-15	16.4000	16.4000	17.3000	106.3100	39360.00	0.00	39360.00	24	8	59	2132	0.0276735459662289	0.489589638694278	0.489589638694278	false	false	false
9a3eca6e-576a-4e65-a144-a638eb062dd3	2026-09-02 14:22	2026-09-02 14:21	2026-09-02 14:21	DINO	DINO270115C00105000	call	105.0000	2027-01-15	13.9000	13.9000	14.4000	106.2700	27800.00	0.00	27800.00	20	6	25	100	0.25	0.490931943968287	0.490931943968287	false	false	false	true
e58d885b-3823-4eec-82a2-666e15ac2fdc	2026-09-02 14:10	2026-09-02 14:09	2026-09-02 14:09	DINO	DINO270521C00140000	call	140.0000	2027-05-21	8.6000	8.1000	8.6000	106.3200	50736.00	50736.00	0.00	59	17	72	2	36	0.495611296157362	0.495611296157362	false	false	false	true
73026dc1-a70d-4b36-804c-b756387d4cf3	2026-09-02 13:56	2026-09-02 13:56	2026-09-02 13:56	DINO	DINO270521C00140000	call	140.0000	2027-05-21	8.5000	8.0000	8.5000	106.1192	10198.00	10198.00	0.00	12	8	12	2	6	0.494434522297604	0.494734989079956	false	false	false	true
371ad9ca-b3e6-4e85-bd2d-d671c094a628	2026-09-02 13:43	2026-09-02 13:43	2026-09-02 13:43	DINO	DINO260918C00105000	call	105.0000	2026-09-18	4.9000	4.9000	5.3000	106.1500	93592.00	0.00	93592.00	191	31	4441	6743	0.658608927776954	0.477247153709314	0.477247153709314	false	false	false
b218b92d-ed18-425d-908a-8ad8a76eb339	2026-09-02 12:49	2026-09-02 12:49	2026-09-02 12:49	DINO	DINO270521P00100000	put	100.0000	2027-05-21	13.4000	13.0000	13.4000	105.8000	103169.00	103169.00	0.00	77	16	77	0	0	0.513553960450278	0.513553960450278	false	false	false	true
0dee0075-40e9-4925-b980-bbc690c52e76	2026-09-02 12:26	2026-09-02 12:26	2026-09-02 12:26	DINO	DINO261218C00125000	call	125.0000	2026-12-18	5.6000	5.3000	5.6000	105.3000	38640.00	38640.00	0.00	69	5	154	435	0.354022988505747	0.516334355650196	0.516334355650196	false	false	false	true
5c6bea7b-ef41-4d4a-9760-b216b156dae8	2026-09-02 11:21	2026-09-02 11:21	2026-09-02 11:21	DINO	DINO261016C00115000	call	115.0000	2026-10-16	3.8000	3.5000	4.1000	104.7400	46360.00	20140.00	760.00	122	7	125	208	0.600961538461538	0.508524581303265	0.508524581303265	false	false	false
f2491933-536d-4162-b284-3176a7f8124d	2026-09-02 09:48	2026-09-02 09:48	2026-09-02 09:48	DINO	DINO260918C00105000	call	105.0000	2026-09-18	4.1000	3.8000	4.6000	104.1702	820000.00	0.00	820000.00	2000	1	4139	6743	0.613821741064808	0.50649341686786	0.50649341686786	false	true	false