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:alert_rule = RepeatedHits×ticker = KOD×

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

39d7a2e5-8473-4340-858e-a27df605b3b3	2026-09-16 13:03	2026-09-16 13:03	2026-09-16 13:03	KOD	KOD261016C00070000	call	70.0000	2026-10-16	1.8500	1.8500	1.8500	32.6000	37185.00	0.00	0.00	201	7	2734	3790	0.721372031662269	2.29297810676404	2.29297810676404	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	2050695512.00	2026-11-12	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
5967dced-183f-4fdf-8aa8-082f82b23cb7	2026-09-16 12:17	2026-09-16 12:17	2026-09-16 12:17	KOD	KOD261016C00035000	call	35.0000	2026-10-16	7.0000	6.2000	7.0000	32.4500	14000.00	14000.00	0.00	20	5	1525	223	6.83856502242153	2.15389756395347	2.15389756395347	false	false	false	true
cb3901de-33d2-4658-9cb0-7294e702112f	2026-09-15 10:30	2026-09-15 10:30	2026-09-15 10:30	KOD	KOD261016C00070000	call	70.0000	2026-10-16	1.5500	1.5500	2.7000	32.7050	18290.00	0.00	18290.00	118	10	308	3790	0.0812664907651715	2.13234958975723	2.13234958975723	false	false	false	true
fc80da6b-d224-4d2b-9378-7905e7a3ac2d	2026-09-15 10:30	2026-09-15 10:30	2026-09-15 10:30	KOD	KOD261016C00070000	call	70.0000	2026-10-16	1.5500	1.5500	2.7500	32.7050	18290.00	0.00	18290.00	118	10	190	3790	0.050131926121372	2.13234958975723	2.13234958975723	false	false	false	true
4504427c-8b8a-4219-a66d-9455ebf78d67	2026-09-11 15:10	2026-09-11 15:09	2026-09-11 15:09	KOD	KOD270115C00040000	call	40.0000	2027-01-15	9.1000	8.4000	9.3000	33.0850	72800.00	6370.00	35490.00	80	8	505	2171	0.232611699677568	1.46035912435358	1.46035912435358	false	false	false	true
e3a53fd2-8b28-4ad2-a6a8-b94348553d96	2026-09-11 13:44	2026-09-11 13:44	2026-09-11 13:44	KOD	KOD270115C00040000	call	40.0000	2027-01-15	8.8000	7.4000	9.3000	32.5400	74800.00	11440.00	63360.00	85	9	391	2171	0.180101335789959	1.4628748227196	1.4628748227196	false	false	false	true
c892948d-1791-489a-baf4-d1404400adf1	2026-09-11 13:44	2026-09-11 13:44	2026-09-11 13:44	KOD	KOD270115C00060000	call	60.0000	2027-01-15	4.0000	3.0000	4.9000	32.5400	20400.00	5200.00	11600.00	51	7	51	1002	0.0508982035928144	1.30286586039985	1.30286586039985	false	false	false	true
5be3f0c6-a391-47e5-9af1-8652acc66415	2026-09-11 10:54	2026-09-11 10:54	2026-09-11 10:54	KOD	KOD270115C00040000	call	40.0000	2027-01-15	9.3000	9.3000	10.0000	32.9200	46500.00	0.00	23250.00	50	6	250	2171	0.115154306771073	1.49984665706899	1.49984665706899	false	false	false	true
efcf5c10-09b4-4525-8fe3-8d3d73646199	2026-09-11 09:35	2026-09-11 09:35	2026-09-11 09:35	KOD	KOD270115C00040000	call	40.0000	2027-01-15	9.6000	7.3000	10.0000	33.0000	94080.00	8640.00	85440.00	98	10	200	2171	0.0921234454168586	1.46867694116257	1.46867694116257	false	false	false	true
acc52bac-242c-430e-8227-e3527edd720e	2026-09-09 15:26	2026-09-09 15:26	2026-09-09 15:26	KOD	KOD270115C00040000	call	40.0000	2027-01-15	9.6000	9.6000	10.2000	33.9900	73920.00	0.00	38400.00	77	5	1112	1083	1.02677746999077	1.45057507690646	1.44400786194067	false	false	false	true
b4793f1b-e626-4324-89aa-9098f991e6a3	2026-09-09 11:00	2026-09-09 11:00	2026-09-09 11:00	KOD	KOD270115C00060000	call	60.0000	2027-01-15	4.8000	4.7000	5.5000	34.3750	57120.00	3840.00	41280.00	119	25	929	3	309.666666666667	1.31104530545788	1.31104530545788	false	false	false	true
2764a150-c12a-48b0-8c13-9c50034810db	2026-09-09 11:00	2026-09-09 10:59	2026-09-09 10:59	KOD	KOD270115C00040000	call	40.0000	2027-01-15	9.8000	9.2000	9.9000	34.2900	98000.00	10780.00	87220.00	100	8	905	1083	0.835641735918744	1.44648506307419	1.44648506307419	false	false	false	true
1eb04847-0213-43fe-bbe5-fa222b946399	2026-09-09 10:56	2026-09-09 10:56	2026-09-09 10:56	KOD	KOD270115C00060000	call	60.0000	2027-01-15	4.8000	4.6000	6.0000	34.4200	115683.00	9120.00	103683.00	241	25	558	3	186	1.30884937055946	1.30884937055946	false	false	false	true
2c4318d6-6dd3-41a5-9c33-58442d2ad09b	2026-09-09 10:55	2026-09-09 10:54	2026-09-09 10:55	KOD	KOD270115C00060000	call	60.0000	2027-01-15	4.8000	4.6000	5.6000	34.4200	48001.00	3360.00	44641.00	100	12	280	3	93.3333333333333	1.30884937055946	1.30884937055946	false	false	false	true
c985b207-799b-4e22-be3b-759a5233faac	2026-09-09 10:54	2026-09-09 10:54	2026-09-09 10:54	KOD	KOD270115C00060000	call	60.0000	2027-01-15	5.0000	4.6000	6.6000	34.4800	90000.00	10500.00	51000.00	180	27	180	3	60	1.32176807318145	1.33161627997676	false	false	false	true
111e0347-de31-44ce-b2ca-10768f27d101	2026-09-09 10:54	2026-09-09 10:54	2026-09-09 10:54	KOD	KOD270115C00040000	call	40.0000	2027-01-15	10.2000	9.3000	11.0000	34.3750	101995.00	73435.00	7140.00	100	21	676	1083	0.624192059095106	1.49108406848729	1.49108406848729	false	false	false	true
16b6a704-62d8-49a1-8a19-ae64aba63b4c	2026-09-09 09:55	2026-09-09 09:55	2026-09-09 09:55	KOD	KOD270115C00040000	call	40.0000	2027-01-15	10.6000	9.9000	10.7000	35.7400	98580.00	31800.00	66780.00	93	7	519	1083	0.479224376731302	1.44767487356091	1.43530073652094	false	false	false	true
f81c994a-8be9-4416-ba3a-59e6850d064f	2026-09-09 09:54	2026-09-09 09:54	2026-09-09 09:54	KOD	KOD270115C00040000	call	40.0000	2027-01-15	10.6000	9.3000	10.8000	35.5100	167478.00	153698.00	13780.00	158	22	426	1083	0.393351800554017	1.45310406394294	1.45310406394294	false	false	false	true
d8f2bfdb-48c3-43cb-adf5-232b31f6e0fe	2026-09-09 09:50	2026-09-09 09:50	2026-09-09 09:50	KOD	KOD270115C00040000	call	40.0000	2027-01-15	10.2000	9.3000	10.4000	34.9000	93840.00	22440.00	71400.00	92	9	268	1083	0.247460757156048	1.45013293421702	1.45013293421702	false	false	false	true
f207366e-1e73-4d02-8ae5-956073df1cc3	2026-09-09 09:49	2026-09-09 09:49	2026-09-09 09:49	KOD	KOD270115C00040000	call	40.0000	2027-01-15	10.2000	9.4000	10.4000	34.9050	122400.00	35700.00	86700.00	120	10	162	1083	0.149584487534626	1.45711237186294	1.44974566951756	true	false	false	true
10d99c41-0dc7-4751-90a7-f7753e38710a	2026-09-04 09:38	2026-09-04 09:38	2026-09-04 09:38	KOD	KOD260918C00040000	call	40.0000	2026-09-18	1.2500	1.2500	2.1500	36.0500	12500.00	0.00	8375.00	100	6	100	855	0.116959064327485	0.935863480499881	0.935863480499881	false	false	false	true
53f90027-b47a-44d4-9209-4b58c7be4411	2026-09-03 14:37	2026-09-03 14:37	2026-09-03 14:37	KOD	KOD260918C00040000	call	40.0000	2026-09-18	1.6500	1.6500	2.0000	36.7900	16665.00	0.00	16665.00	101	6	206	657	0.313546423135464	0.956576491160203	0.956576491160203	false	false	false	true
9973ff2c-8589-43d8-b411-f2aa5f1e5529	2026-09-02 12:41	2026-09-02 12:41	2026-09-02 12:41	KOD	KOD260918C00040000	call	40.0000	2026-09-18	1.4000	1.4000	1.7000	36.7100	14000.00	0.00	14000.00	100	5	230	457	0.50328227571116	0.84894204721105	0.84894204721105	false	false	false	true
7a0350d9-50fc-4ca7-aae4-dbdd4e9b8f77	2026-09-02 11:46	2026-09-02 11:46	2026-09-02 11:46	KOD	KOD270115C00040000	call	40.0000	2027-01-15	11.3000	11.3000	12.1000	37.3900	11300.00	0.00	11300.00	10	5	215	1002	0.214570858283433	1.35633029216278	1.35633029216278	false	false	false	true
730aac85-8b11-4932-8a5f-9e8f3e892f36	2026-09-02 10:47	2026-09-02 10:47	2026-09-02 10:47	KOD	KOD260918C00040000	call	40.0000	2026-09-18	1.5000	1.5000	2.7000	37.1700	15000.00	0.00	15000.00	100	6	100	457	0.218818380743982	0.82616164753241	0.82616164753241	false	false	false	true
0e17602f-ce97-4d00-910e-14b70d87c68d	2026-08-31 14:14	2026-08-31 14:14	2026-08-31 14:14	KOD	KOD260918C00040000	call	40.0000	2026-09-18	1.7500	1.7500	1.9000	37.0000	26600.00	0.00	26600.00	152	7	400	33	12.1212121212121	0.866201268896722	0.866201268896722	false	false	false	true
5306d8b0-c329-45f7-ae16-3e298be0d267	2026-08-28 12:49	2026-08-28 12:49	2026-08-28 12:49	KOD	KOD261016C00045000	call	45.0000	2026-10-16	6.8000	6.6000	6.8000	37.5900	17680.00	17680.00	0.00	26	8	247	4787	0.0515980781282641	1.68910011942986	1.68910011942986	false	false	false	true
2f65079b-c1b2-4350-b34e-51845d359804	2026-08-25 10:53	2026-08-25 10:53	2026-08-25 10:53	KOD	KOD261218C00049000	call	49.0000	2026-12-18	8.9000	7.7000	9.8000	37.9400	26700.00	22250.00	4450.00	30	6	30	22	1.36363636363636	1.44064397538205	1.44064397538205	false	false	false	true
ed49768b-3914-4ae2-9e9d-36211d43c092	2026-08-24 13:17	2026-08-24 13:17	2026-08-24 13:17	KOD	KOD260918P00030000	put	30.0000	2026-09-18	0.6000	0.2500	0.6000	37.8200	22137.00	22137.00	0.00	369	35	743	21	35.3809523809524	0.869303224765542	0.869303224765542	false	false	false	true
f74b75a0-47ac-4027-9cd4-cbb0ca123844	2026-08-24 13:16	2026-08-24 13:16	2026-08-24 13:16	KOD	KOD260918P00030000	put	30.0000	2026-09-18	0.5500	0.2500	0.5500	37.8200	18810.00	18810.00	0.00	342	31	363	21	17.2857142857143	0.84458441927776	0.84458441927776	false	false	false	true
c618aebf-1195-44b9-9abb-544e92143951	2026-08-20 15:41	2026-08-20 15:41	2026-08-20 15:41	KOD	KOD270115C00040000	call	40.0000	2027-01-15	14.2500	12.9000	15.6000	40.1600	35625.00	14250.00	14250.00	25	5	25	970	0.0257731958762887	1.41782354899662	1.41782354899662	false	false	false	true