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:endpoint = /api/option-trades/flow-alerts×ticker = EGO×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	expiry

b4d70cc2-cdc9-4f76-a8b8-89bc67e550e6	2026-08-17 13:07	2026-08-17 13:07	2026-08-17 13:07	EGO	EGO270319C00055000	call	55.0000	2027-03-19	3.3200	2.5000	3.5000	40.8800	94025.00	94025.00	0.00	283	6	283	102	2.77450980392157	0.562818004532222	0.562818004532222	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Basic Materials	8173162603.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
26525b8e-80d0-414d-9750-ceab44737972	2026-08-18 11:55	2026-08-18 11:55	2026-08-18 11:55	EGO	EGO261218P00036000	put	36.0000	2026-12-18	3.1000	3.1000	3.4000	39.0400	15500.00	0.00	15500.00	50	7	100	7	14.2857142857143	0.542942591838287	0.542942591838287	false	false	false
3d41ef6b-9d18-4f11-b13b-929dc6458bf3	2026-08-18 15:49	2026-08-18 15:49	2026-08-18 15:49	EGO	EGO261218P00037000	put	37.0000	2026-12-18	3.8000	3.7000	3.8000	38.0000	14050.00	13680.00	370.00	37	12	43	55	0.781818181818182	0.564034819696841	0.552155385223475	false	false	false
f5af5ce1-b81e-46d8-9597-ffa0f07abd30	2026-08-20 11:39	2026-08-20 11:39	2026-08-20 11:39	EGO	EGO260918C00044000	call	44.0000	2026-09-18	2.0500	2.0000	2.1500	42.2900	20500.00	205.00	20295.00	100	7	112	29	3.86206896551724	0.572052706490773	0.572052706490773	false	false	false
9e8f188b-64a7-4fe4-b7c6-1b7c66aeea43	2026-08-20 12:54	2026-08-20 12:54	2026-08-20 12:54	EGO	EGO260918P00042000	put	42.0000	2026-09-18	2.5000	2.5000	2.6000	42.2500	48250.00	0.00	48250.00	193	23	224	227	0.986784140969163	0.567981095471949	0.567981095471949	false	false	false
f55eb32b-a5a1-4bea-9ec8-6c5e07f1cefd	2026-08-21 09:38	2026-08-21 09:37	2026-08-21 09:37	EGO	EGO280121C00060000	call	60.0000	2028-01-21	7.0000	6.7000	7.0000	44.7400	10500.00	10500.00	0.00	15	5	47	144	0.326388888888889	0.507953967412525	0.507953967412525	false	false	false
5b9c5555-c6b1-4bf9-a966-ad0a0108a1f5	2026-08-21 11:20	2026-08-21 11:20	2026-08-21 11:20	EGO	EGO261218C00046000	call	46.0000	2026-12-18	5.7000	5.5000	5.7000	44.8400	27930.00	27930.00	0.00	49	18	49	11	4.45454545454545	0.585026144042241	0.585026144042241	false	false	false
35230112-bc07-4c9c-a8ce-d6069bff1f10	2026-08-24 15:03	2026-08-24 15:03	2026-08-24 15:03	EGO	EGO270115C00050000	call	50.0000	2027-01-15	5.7000	5.7000	5.9000	46.5150	28500.00	0.00	28500.00	50	15	59	3823	0.01543290609469	0.584657615956604	0.584657615956604	true	false	false
8eac9332-f400-4613-817c-a187ef75bd7b	2026-08-24 15:05	2026-08-24 15:05	2026-08-24 15:05	EGO	EGO270115C00055000	call	55.0000	2027-01-15	4.2000	4.0000	4.3000	46.5200	21000.00	8820.00	4200.00	50	6	50	259	0.193050193050193	0.590987734927112	0.590987734927112	false	false	false
2808d3ae-cc45-46c4-8a92-1d1a62bc6bc8	2026-08-24 15:08	2026-08-24 15:07	2026-08-24 15:07	EGO	EGO270115C00050000	call	50.0000	2027-01-15	5.7000	5.6000	5.9000	46.4850	14250.00	0.00	13110.00	25	11	134	3823	0.0350510070625163	0.585975095862429	0.585975095862429	true	false	false
64fd7385-70bc-4fa9-befa-9231a180f5ac	2026-08-24 15:08	2026-08-24 15:08	2026-08-24 15:08	EGO	EGO270115C00050000	call	50.0000	2027-01-15	5.7000	5.7000	5.9000	46.4950	28500.00	0.00	28500.00	50	17	184	3823	0.0481297410410672	0.585535958833411	0.585535958833411	true	false	false
89f5b1ff-d4d4-4db2-9853-3cc8019f9c3d	2026-08-24 15:30	2026-08-24 15:29	2026-08-24 15:29	EGO	EGO261218C00060000	call	60.0000	2026-12-18	2.5000	2.1500	2.7500	46.6000	10000.00	3750.00	2000.00	40	6	41	177	0.231638418079096	0.60282961778858	0.60282961778858	false	false	false
d651e2b2-1cf1-4d4d-9dbc-227625ce88d3	2026-08-24 15:31	2026-08-24 15:31	2026-08-24 15:31	EGO	EGO270115C00050000	call	50.0000	2027-01-15	5.7000	5.6000	5.7500	46.5800	28500.00	6270.00	16530.00	50	5	234	3823	0.0612084750196181	0.581802346849417	0.581802346849417	false	false	false
6ec68cf4-464d-489c-9325-a42dbcc1067c	2026-08-24 15:31	2026-08-24 15:31	2026-08-24 15:31	EGO	EGO270115C00050000	call	50.0000	2027-01-15	5.7000	5.6000	5.7000	46.5550	28500.00	16530.00	0.00	50	5	284	3823	0.074287208998169	0.582900648199944	0.582900648199944	false	false	false
78a68fe9-3565-4089-ae7c-86775e5df4e7	2026-08-24 15:32	2026-08-24 15:32	2026-08-24 15:32	EGO	EGO270115C00050000	call	50.0000	2027-01-15	5.7000	5.6000	5.9000	46.5600	28500.00	6270.00	5700.00	50	5	334	3823	0.0873659429767199	0.582681000204254	0.582681000204254	false	false	false
c571e8ba-500f-4a89-a549-00921527e89d	2026-08-24 15:32	2026-08-24 15:32	2026-08-24 15:32	EGO	EGO261218C00055000	call	55.0000	2026-12-18	3.6000	3.4000	3.7000	46.5550	10800.00	10800.00	0.00	30	5	30	11	2.72727272727273	0.602507191063186	0.602507191063186	false	false	false
0073b661-7b8c-4cdf-9fa1-0ba1914aee58	2026-08-24 15:33	2026-08-24 15:32	2026-08-24 15:32	EGO	EGO270115C00050000	call	50.0000	2027-01-15	5.7000	5.6000	5.9000	46.5700	17100.00	7980.00	6840.00	30	5	364	3823	0.0952131833638504	0.5822416858621	0.5822416858621	false	false	false
fa72e14d-7dea-418d-8153-89e6877ee217	2026-08-24 15:33	2026-08-24 15:33	2026-08-24 15:33	EGO	EGO270115C00050000	call	50.0000	2027-01-15	5.7000	5.6000	5.9000	46.5500	28500.00	6270.00	5700.00	50	5	414	3823	0.108291917342401	0.583120290119203	0.583120290119203	false	false	false
14aef9ee-e1c0-40a5-bc8e-6eaf1a59fd68	2026-08-24 15:35	2026-08-24 15:35	2026-08-24 15:35	EGO	EGO270115C00050000	call	50.0000	2027-01-15	5.7000	5.6000	5.7000	46.5550	22800.00	9120.00	0.00	40	5	454	3823	0.118754904525242	0.582900648199944	0.582900648199944	false	false	false
cd59c76e-86d7-45ae-9ca0-557f8392ef3e	2026-08-24 15:42	2026-08-24 15:42	2026-08-24 15:42	EGO	EGO270319C00060000	call	60.0000	2027-03-19	4.3000	3.9000	4.6000	46.5650	12900.00	5590.00	3010.00	30	5	155	4	38.75	0.582445217927558	0.582445217927558	false	false	false
1533e6da-daea-47be-bce9-d034e654fa4e	2026-08-25 09:30	2026-08-25 09:30	2026-08-25 09:30	EGO	EGO261016P00050000	put	50.0000	2026-10-16	6.2000	6.0000	6.2000	45.3108	31000.00	13020.00	0.00	50	12	50	7	7.14285714285714	0.499008851153139	0.499008851153139	false	false	false
97544cf2-de0d-43fc-ada9-7551b83a0ac3	2026-08-25 09:44	2026-08-25 09:43	2026-08-25 09:43	EGO	EGO280121P00045000	put	45.0000	2028-01-21	10.5000	10.5000	11.0000	46.3000	27300.00	0.00	9450.00	26	17	27	104	0.259615384615385	0.601444933156411	0.601444933156411	false	false	false
e3944c52-e30e-442a-b918-5d13741c263d	2026-08-25 10:14	2026-08-25 10:14	2026-08-25 10:14	EGO	EGO270115C00050000	call	50.0000	2027-01-15	6.0000	5.2000	6.3000	47.0000	30000.00	24000.00	0.00	50	5	53	4287	0.0123629577793329	0.590998372037679	0.590998372037679	false	false	false
8ac0312b-1f84-4fab-b956-71e24a32edba	2026-08-26 15:17	2026-08-26 15:17	2026-08-26 15:17	EGO	EGO270115C00050000	call	50.0000	2027-01-15	5.4000	5.4000	6.0000	47.0350	24300.00	0.00	24300.00	45	6	51	4166	0.0122419587133941	0.540417536304204	0.540417536304204	false	false	false
11b5cf93-c306-4f0f-be5f-3cfefb429d95	2026-08-27 10:45	2026-08-27 10:45	2026-08-27 10:45	EGO	EGO261016C00060000	call	60.0000	2026-10-16	1.1000	0.8000	1.1000	48.3300	11988.00	11988.00	0.00	109	22	111	18	6.16666666666667	0.602641140048797	0.602641140048797	false	false	false
6516649d-e074-4b9f-8c8e-4900575603ad	2026-08-27 12:46	2026-08-27 12:46	2026-08-27 12:46	EGO	EGO261016P00046000	put	46.0000	2026-10-16	2.9000	2.7000	2.9000	48.0200	37697.00	37697.00	0.00	130	30	130	8	16.25	0.568264528198006	0.568264528198006	false	false	false	true
f4fa9be0-4183-43d6-bfa0-56fb0b74408a	2026-08-27 14:31	2026-08-27 14:31	2026-08-27 14:31	EGO	EGO261016P00049000	put	49.0000	2026-10-16	4.5000	4.3000	4.5000	48.0100	36450.00	36450.00	0.00	81	19	81	18	4.5	0.578128356739549	0.578128356739549	false	false	false	true
1eaded53-ae1a-4063-b372-d0c8eaf28ae9	2026-08-28 14:00	2026-08-28 13:59	2026-08-28 13:59	EGO	EGO260918C00040000	call	40.0000	2026-09-18	5.9000	5.8000	6.2000	45.3600	141010.00	139830.00	1180.00	239	10	260	271	0.959409594095941	0.522580861409891	0.533175691282153	false	false	false
22467413-53f2-4602-9ddf-6a14002f7333	2026-08-28 15:46	2026-08-28 15:46	2026-08-28 15:46	EGO	EGO261218P00036000	put	36.0000	2026-12-18	1.7000	1.5500	1.9000	45.5500	23290.00	22950.00	340.00	137	27	144	165	0.872727272727273	0.59096916301938	0.59096916301938	false	false	false
d07b3d21-365d-4240-a03a-c756d92475ec	2026-09-17 09:30	2026-09-17 09:30	2026-09-17 09:30	EGO	EGO280121C00075000	call	75.0000	2028-01-21	4.0000	1.3000	5.4000	41.9900	20000.00	12000.00	0.00	50	12	50	367	0.136239782016349	0.551246580762849	0.551246580762849	false	false	false
0305b865-e80c-4c63-87db-4df75e1be2fa	2026-09-17 14:50	2026-09-17 14:49	2026-09-17 14:49	EGO	EGO261120P00039000	put	39.0000	2026-11-20	2.3500	2.2500	2.3500	42.4250	10575.00	10575.00	0.00	45	11	55	3	18.3333333333333	0.58145458275801	0.58145458275801	false	false	false
7bd5750f-785e-4203-911d-7d0f47943f18	2026-09-17 15:45	2026-09-17 15:45	2026-09-17 15:45	EGO	EGO261120P00043000	put	43.0000	2026-11-20	4.3000	4.2000	4.4000	42.3100	24510.00	21930.00	0.00	57	11	57	0	0	0.580006986400508	0.580006986400508	false	false	false	true
30defe13-0afa-4fe7-a97b-8738edf980c9	2026-09-22 11:26	2026-09-22 11:25	2026-09-22 11:25	EGO	EGO270115C00047000	call	47.0000	2027-01-15	4.7000	4.7000	5.0000	44.0000	44652.00	0.00	44652.00	95	25	95	1483	0.0640593391773432	0.554419983316811	0.554419983316811	false	false	false