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

f827e1fb-b230-4113-a7e2-85b936f6ff3b	2026-08-17 11:39	2026-08-17 11:39	2026-08-17 11:39	DINO	DINO260918C00100000	call	100.0000	2026-09-18	3.2000	3.2000	3.3000	94.6600	31360.00	0.00	31360.00	98	6	1013	1600	0.633125	0.465177752824584	0.465177752824584	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	19006871297.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e52598a9-ed7d-4d24-a090-6a52a1299520	2026-08-17 11:39	2026-08-17 11:39	2026-08-17 11:39	DINO	DINO260918C00100000	call	100.0000	2026-09-18	3.2000	3.1000	3.3000	94.7500	101760.00	26240.00	45760.00	318	5	549	1600	0.343125	0.461969903474802	0.461969903474802	false	false	false	true
85013a23-b512-4a0e-a7db-dae8d0f825d7	2026-08-17 11:39	2026-08-17 11:39	2026-08-17 11:39	DINO	DINO260821C00095000	call	95.0000	2026-08-21	1.9000	1.8500	1.9000	94.7700	44270.00	3800.00	0.00	233	14	369	7358	0.0501494971459636	0.503311442044583	0.503311442044583	true	false	false	true
df2a73f0-637c-49f1-b4ff-ad7e978e9fb7	2026-08-17 11:39	2026-08-17 11:39	2026-08-17 11:39	DINO	DINO260918C00100000	call	100.0000	2026-09-18	3.2000	3.2000	3.3000	94.5980	75840.00	0.00	75840.00	237	12	1250	1600	0.78125	0.465177752824584	0.467384368727714	true	false	false	true
d5eb7dbe-5210-4ca2-b51e-16cba6b66b1a	2026-08-17 11:39	2026-08-17 11:39	2026-08-17 11:39	DINO	DINO260821C00095000	call	95.0000	2026-08-21	1.7500	1.7500	1.7500	94.5450	40950.00	0.00	0.00	234	6	1332	7358	0.181027453112259	0.493016728523006	0.493016728523006	false	false	false	true
8001cd08-536b-4e80-a9d2-6ddfeb1ac709	2026-08-17 11:39	2026-08-17 11:39	2026-08-17 11:39	DINO	DINO260918C00100000	call	100.0000	2026-09-18	3.2000	3.2000	3.3000	94.5450	94080.00	0.00	94080.00	294	6	1544	1600	0.965	0.469268614490826	0.469268614490826	true	false	false	true
99828ea2-8db8-4327-b37c-9b874c46eb16	2026-08-17 11:39	2026-08-17 11:39	2026-08-17 11:39	DINO	DINO260918C00100000	call	100.0000	2026-09-18	3.2000	3.0000	3.3000	94.5700	193600.00	117120.00	15360.00	605	43	2209	1600	1.380625	0.468380053439631	0.468380053439631	true	false	false	true
ca1f41ba-6ddb-456b-b75b-be1eb8a34d63	2026-08-18 13:26	2026-08-18 13:26	2026-08-18 13:26	DINO	DINO270115C00100000	call	100.0000	2027-01-15	9.6500	9.6000	10.0000	95.0100	19300.00	0.00	6755.00	20	20	80	2708	0.0295420974889217	0.456950997353863	0.456950997353863	false	false	false	true
ff5ff520-3b95-40fb-a429-3d56faf021c0	2026-08-18 14:40	2026-08-18 14:40	2026-08-18 14:40	DINO	DINO260821C00095000	call	95.0000	2026-08-21	1.6500	1.6500	1.9500	94.9213	23430.00	0.00	17325.00	142	6	243	5385	0.045125348189415	0.487646351197979	0.487646351197979	true	false	false	true
633748d2-96cb-4a5c-8d77-80218a877622	2026-08-18 15:56	2026-08-18 15:55	2026-08-18 15:55	DINO	DINO260918C00097500	call	97.5000	2026-09-18	4.4000	3.9000	4.4000	95.0000	47080.00	47080.00	0.00	107	26	121	68	1.77941176470588	0.461056105350521	0.461056105350521	true	false	false	true
87051379-0511-4a7f-96cd-470aad853632	2026-08-18 15:56	2026-08-18 15:56	2026-08-18 15:56	DINO	DINO260918C00097500	call	97.5000	2026-09-18	4.4000	4.4000	4.5000	95.0000	20240.00	0.00	20240.00	46	7	192	68	2.82352941176471	0.461486321021419	0.461486321021419	false	false	false	true
aaceeaed-31f8-48b6-90a5-ec823e47b5e7	2026-08-19 09:41	2026-08-19 09:41	2026-08-19 09:41	DINO	DINO270115C00100000	call	100.0000	2027-01-15	9.9000	9.4000	9.9000	95.4350	12870.00	12870.00	0.00	13	12	32	2653	0.0120618168111572	0.460024281304863	0.460024281304863	false	false	false	true
798908df-9a63-4133-9573-5ddc9e550b8d	2026-08-19 12:28	2026-08-19 12:28	2026-08-19 12:28	DINO	DINO261218C00100000	call	100.0000	2026-12-18	9.1000	9.1000	9.3000	96.0300	52780.00	0.00	52780.00	58	13	73	142	0.514084507042254	0.465608821366387	0.465608821366387	false	false	false	true
43ca9bb2-8c76-418f-93ce-f18a1f8c2cce	2026-08-19 14:10	2026-08-19 14:09	2026-08-19 14:09	DINO	DINO261218P00100000	put	100.0000	2026-12-18	12.7000	12.6000	12.9000	95.1700	22855.00	15235.00	7620.00	18	6	28	17	1.64705882352941	0.488607798813036	0.488607798813036	false	false	false	true
fd1909a1-c60f-4fd5-b9da-ef66cec9cf66	2026-08-19 14:54	2026-08-19 14:53	2026-08-19 14:53	DINO	DINO261218C00097500	call	97.5000	2026-12-18	9.5000	9.4000	9.6000	95.0250	63650.00	5700.00	48450.00	67	11	69	56	1.23214285714286	0.460854868458793	0.460854868458793	false	false	false	true
d0f639f2-62f7-49a3-9937-09f8165efb31	2026-08-19 15:36	2026-08-19 15:36	2026-08-19 15:36	DINO	DINO270115C00105000	call	105.0000	2027-01-15	7.5000	7.5000	8.1000	94.6300	11251.00	0.00	11251.00	15	10	15	96	0.15625	0.450538553293627	0.450538553293627	false	false	false	true
883425f1-7be3-412e-85ff-45d567fda492	2026-08-20 12:11	2026-08-20 12:11	2026-08-20 12:11	DINO	DINO270115C00100000	call	100.0000	2027-01-15	9.3000	9.3000	9.8000	94.6250	13950.00	0.00	13950.00	15	5	116	2593	0.04473582722715	0.454014816756386	0.454014816756386	false	false	false	true
ada3a94e-20fb-4375-812a-e252803b53b7	2026-08-20 12:54	2026-08-20 12:54	2026-08-20 12:54	DINO	DINO270115C00110000	call	110.0000	2027-01-15	6.0000	6.0000	6.3000	94.3300	10800.00	0.00	10800.00	18	7	20	2658	0.00752445447705041	0.455618448239053	0.455618448239053	false	false	false	true
88a7461b-0549-4aab-8e33-c8a0e3f4ecf1	2026-08-20 13:16	2026-08-20 13:16	2026-08-20 13:16	DINO	DINO280121C00125000	call	125.0000	2028-01-21	11.1000	11.1000	11.9000	94.2200	16650.00	0.00	16650.00	15	6	22	0	0	0.418257305820737	0.418257305820737	false	false	false	true
5197bcf4-2af2-469f-abc9-08bd14b1f963	2026-08-20 14:15	2026-08-20 14:15	2026-08-20 14:15	DINO	DINO270115C00110000	call	110.0000	2027-01-15	5.5000	5.5000	5.7000	93.2100	34100.00	0.00	34100.00	62	7	132	2658	0.0496613995485327	0.45139343203309	0.45139343203309	false	false	false	true
b8593f4a-f902-40f6-a1e4-3a934c138d10	2026-08-20 15:48	2026-08-20 15:48	2026-08-20 15:48	DINO	DINO270115C00097500	call	97.5000	2027-01-15	8.8000	8.8000	9.1000	92.4800	32560.00	0.00	32560.00	37	7	37	14	2.64285714285714	0.437883686419625	0.437883686419625	false	false	false	true
00469a9b-6ffc-4d62-8199-aba3c9ac3fe8	2026-08-21 09:33	2026-08-21 09:33	2026-08-21 09:33	DINO	DINO270115C00100000	call	100.0000	2027-01-15	9.0000	7.6000	9.0000	94.2650	54000.00	54000.00	0.00	60	8	60	2675	0.0224299065420561	0.450712130379453	0.450712130379453	false	false	false	true
b4839584-c91d-4a99-9eaa-a9de3e0d5bb8	2026-08-21 10:17	2026-08-21 10:17	2026-08-21 10:17	DINO	DINO261218C00100000	call	100.0000	2026-12-18	8.4000	8.1000	8.4000	94.6850	99120.00	99120.00	0.00	118	28	125	219	0.570776255707763	0.469091617917719	0.469091617917719	false	false	false	true
8eb7cd77-7731-4abc-a1d2-f34414dc2c28	2026-08-21 11:54	2026-08-21 11:54	2026-08-21 11:54	DINO	DINO261218C00125000	call	125.0000	2026-12-18	3.1000	2.9000	3.1000	96.0800	104770.00	104770.00	0.00	338	40	338	40	8.45	0.491932754234394	0.491932754234394	false	false	false	true
8463cc37-f448-4ce0-b171-62845f88d1c8	2026-08-21 12:00	2026-08-21 11:59	2026-08-21 11:59	DINO	DINO260918C00100000	call	100.0000	2026-09-18	3.6000	3.3000	3.7000	96.3200	71280.00	71280.00	0.00	198	8	1824	7302	0.249794576828266	0.472852852675539	0.472852852675539	true	false	false	true
3dcb6b7f-0691-4285-bc3f-42208a201184	2026-08-21 12:48	2026-08-21 12:48	2026-08-21 12:48	DINO	DINO260918C00100000	call	100.0000	2026-09-18	3.9000	3.9000	4.1000	97.0850	47226.00	0.00	47226.00	121	12	1985	7302	0.271843330594358	0.4698989056309	0.472722637794453	true	false	false	true
adfe661a-dabe-426c-bc64-4a3f77079259	2026-08-25 12:11	2026-08-25 12:11	2026-08-25 12:11	DINO	DINO260918C00100000	call	100.0000	2026-09-18	2.9500	2.8000	3.0000	95.2200	13570.00	7965.00	5605.00	46	16	92	8104	0.0113524185587364	0.490237244518043	0.490237244518043	false	false	false	true
4031a1fb-a16a-4cbb-8937-883a9b351c30	2026-08-25 14:47	2026-08-25 14:46	2026-08-25 14:46	DINO	DINO261218C00105000	call	105.0000	2026-12-18	6.9000	6.9000	7.3000	94.6550	42090.00	0.00	42090.00	61	21	62	166	0.373493975903614	0.489638077203193	0.489638077203193	false	false	false	true
fa02199a-a729-4b34-aa86-edbdd65c033b	2026-08-26 15:26	2026-08-26 15:26	2026-08-26 15:26	DINO	DINO260918C00105000	call	105.0000	2026-09-18	2.2000	2.0500	2.2000	97.2050	39160.00	39160.00	0.00	178	42	200	1708	0.117096018735363	0.505972281025046	0.505972281025046	false	false	false	true
81365d69-ee2a-43e5-b1e3-fd3f3eaf8ad6	2026-08-26 15:26	2026-08-26 15:26	2026-08-26 15:26	DINO	DINO260918C00100000	call	100.0000	2026-09-18	3.7000	3.6000	3.8000	97.2050	82880.00	0.00	82510.00	224	6	754	8075	0.093374613003096	0.494320518083004	0.494320518083004	false	false	false	true
e79d5801-a279-466e-9352-41ae354d219f	2026-08-26 15:26	2026-08-26 15:26	2026-08-26 15:26	DINO	DINO260918C00105000	call	105.0000	2026-09-18	2.2500	2.2000	2.3000	97.2400	31950.00	11925.00	0.00	142	11	587	1708	0.34367681498829	0.51061273618381	0.51061273618381	true	false	false	true
a5e3bf11-1ece-43f0-8f70-cf6a68c22a34	2026-08-26 15:26	2026-08-26 15:26	2026-08-26 15:26	DINO	DINO260918C00105000	call	105.0000	2026-09-18	2.2000	2.1500	2.2500	97.2400	53900.00	53460.00	220.00	245	20	445	1708	0.260538641686183	0.504734882590571	0.504734882590571	false	false	false	true
21c05727-94f6-4038-955d-91996e07b8d4	2026-08-26 15:26	2026-08-26 15:26	2026-08-26 15:26	DINO	DINO260918C00100000	call	100.0000	2026-09-18	3.7000	3.7000	3.9000	97.3100	92130.00	0.00	92130.00	249	36	1117	8075	0.138328173374613	0.48949810867659	0.48949810867659	false	false	false	true
ceae3b9c-3ad5-4ee6-9779-bef37e12c528	2026-08-26 15:26	2026-08-26 15:26	2026-08-26 15:26	DINO	DINO260918C00105000	call	105.0000	2026-09-18	2.2500	2.2000	2.3000	97.2500	51975.00	51750.00	225.00	231	32	1032	1708	0.604215456674473	0.51025740679544	0.51025740679544	false	false	false	true
bc7d3ca2-098e-4e47-8198-ae883400bd05	2026-08-26 15:26	2026-08-26 15:26	2026-08-26 15:26	DINO	DINO260918C00105000	call	105.0000	2026-09-18	2.2500	2.2000	2.2500	97.2500	18410.00	16650.00	1760.00	82	16	801	1708	0.468969555035129	0.51025740679544	0.504381242464398	false	false	false	true
30126582-d2e7-4c61-9db6-2a676a721e21	2026-08-26 15:26	2026-08-26 15:26	2026-08-26 15:26	DINO	DINO260918C00100000	call	100.0000	2026-09-18	3.7000	3.6000	3.8000	97.2500	92130.00	0.00	86950.00	249	11	1368	8075	0.169411764705882	0.492255834185353	0.492255834185353	false	false	false	true
2ec0b988-184f-4bf3-be61-b4fd50fbeb68	2026-08-26 15:35	2026-08-26 15:35	2026-08-26 15:35	DINO	DINO261218P00085000	put	85.0000	2026-12-18	5.2000	5.0000	5.2000	96.6200	10920.00	10920.00	0.00	21	8	36	88	0.409090909090909	0.514888442785558	0.514888442785558	false	false	false	true
629b67b6-0790-4663-95f4-334d8ff032de	2026-08-27 10:18	2026-08-27 10:18	2026-08-27 10:18	DINO	DINO261218P00100000	put	100.0000	2026-12-18	12.6000	12.6000	12.9000	95.7800	151200.00	0.00	151200.00	120	24	120	110	1.09090909090909	0.512079147047641	0.512079147047641	false	false	false	true
464c14ed-3b6e-4bfc-bfef-1aa58b070e27	2026-08-27 11:20	2026-08-27 11:19	2026-08-27 11:19	DINO	DINO270521P00075000	put	75.0000	2027-05-21	6.0000	4.4000	6.0000	94.8400	14400.00	14400.00	0.00	24	7	29	6	4.83333333333333	0.510738979497654	0.510738979497654	false	false	false	true
fa75f3b2-586a-4385-893d-fbebc1e1021a	2026-08-27 12:31	2026-08-27 12:31	2026-08-27 12:31	DINO	DINO280121P00095000	put	95.0000	2028-01-21	17.0000	17.0000	19.6000	96.1800	170000.00	0.00	170000.00	100	7	100	0	0	0.464674549569476	0.464674549569476	false	false	false	true
40a8bbc9-e7cf-40e9-ba9c-5c32ee66627d	2026-08-28 11:20	2026-08-28 11:20	2026-08-28 11:20	DINO	DINO270319C00105000	call	105.0000	2027-03-19	13.0000	12.3000	13.0000	99.9800	38999.00	38999.00	0.00	30	13	30	63	0.476190476190476	0.477009726013078	0.477009726013078	false	false	false	true
2e33f6c6-9420-4326-8ac4-817a6b2fb454	2026-08-28 11:29	2026-08-28 11:29	2026-08-28 11:29	DINO	DINO260918C00105000	call	105.0000	2026-09-18	2.7500	2.7500	2.8000	99.9050	23100.00	0.00	23100.00	84	5	133	2151	0.0618317061831706	0.490019135001712	0.490019135001712	false	false	false	true
ed50cef0-4957-4703-bf9c-dbcab2aa0d13	2026-08-28 11:29	2026-08-28 11:29	2026-08-28 11:29	DINO	DINO260918C00105000	call	105.0000	2026-09-18	2.7500	2.6500	2.8000	99.9300	36575.00	5500.00	7700.00	133	6	543	2151	0.252440725244073	0.489006237986139	0.489006237986139	false	false	false	true
cce53a9a-9cc7-4e20-b5e4-82948e094bae	2026-08-28 11:29	2026-08-28 11:29	2026-08-28 11:29	DINO	DINO260918C00105000	call	105.0000	2026-09-18	2.7500	2.7500	2.8000	99.9300	43450.00	0.00	43450.00	158	6	299	2151	0.139005113900511	0.489006237986139	0.489006237986139	false	false	false	true
7e46c0b1-cce3-4c7c-9433-a495f6ecbe49	2026-08-28 11:29	2026-08-28 11:29	2026-08-28 11:29	DINO	DINO260918C00100000	call	100.0000	2026-09-18	4.6000	4.5000	4.7000	99.9300	110400.00	51520.00	39100.00	240	7	501	7359	0.0680799021606197	0.473826345882022	0.473826345882022	false	false	false	true
5e447bef-1130-49cb-b84a-75b886416983	2026-08-28 11:29	2026-08-28 11:29	2026-08-28 11:29	DINO	DINO260918C00105000	call	105.0000	2026-09-18	2.8000	2.5500	2.8500	99.9300	31080.00	31080.00	0.00	111	6	410	2151	0.190609019060902	0.494549930209016	0.494549930209016	true	false	false	true
f7156338-aa5b-406b-9bb6-28f9f5af4246	2026-08-28 11:29	2026-08-28 11:29	2026-08-28 11:29	DINO	DINO260918C00100000	call	100.0000	2026-09-18	4.5000	4.5000	4.7000	99.8300	89100.00	0.00	89100.00	198	34	959	7359	0.130316619105857	0.468856669317269	0.468856669317269	false	false	false	true
60598c30-c93b-4c3a-a78c-43ea3f52168a	2026-08-28 11:29	2026-08-28 11:29	2026-08-28 11:29	DINO	DINO260918C00105000	call	105.0000	2026-09-18	2.7000	2.5000	2.7500	99.8300	46980.00	9450.00	37530.00	174	6	1010	2151	0.469549046954905	0.487486095497498	0.487486095497498	false	false	false	true
2800bbb7-ec43-4aa7-81b0-ae7a020494bf	2026-08-28 11:29	2026-08-28 11:29	2026-08-28 11:29	DINO	DINO260918C00105000	call	105.0000	2026-09-18	2.7000	2.7000	2.8000	99.9300	26460.00	0.00	26460.00	98	5	641	2151	0.298000929800093	0.483452523072014	0.483452523072014	false	false	false	true
e8d49e89-d3fa-44ac-9fc6-86bc24edd1cb	2026-08-28 11:54	2026-08-28 11:54	2026-08-28 11:54	DINO	DINO260918C00100000	call	100.0000	2026-09-18	4.5000	4.5000	4.7000	100.0000	157052.00	0.00	106202.00	349	47	1988	7359	0.270145400190243	0.459464629992914	0.459464629992914	false	false	false	true