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:ticker = LMB×

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

c901bca7-b280-4183-afc2-359c95cde1e2	2026-09-16 10:42	2026-09-16 10:42	2026-09-16 10:42	LMB	LMB270115C00065000	call	65.0000	2027-01-15	3.5000	3.3000	5.1000	52.3300	301000.00	0.00	301000.00	860	1	860	1351	0.636565507031828	0.607585601182937	0.607585601182937	false	true	false	true	false	LowHistoricVolumeFloor	b356ec2b-92e1-458a-934a-7719f71c40bc	1	Common Stock	Industrials	626777632.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
d8185419-043c-49c7-8169-0fc1448e1d72	2026-09-16 10:06	2026-09-16 10:06	2026-09-16 10:06	LMB	LMB260918C00050000	call	50.0000	2026-09-18	3.0000	2.3000	3.0000	53.0000	21000.00	21000.00	0.00	70	5	70	449	0.155902004454343	0.72709742883107	0.573450921184407	false	false	false	true	false
8fcd8557-817d-439f-873e-b3425d8b3d28	2026-09-14 14:30	2026-09-14 14:30	2026-09-14 14:30	LMB	LMB260918C00050000	call	50.0000	2026-09-18	1.6000	1.6000	2.4500	51.0000	110472.00	0.00	110472.00	690	9	690	764	0.903141361256545	0.58961698988467	0.58961698988467	false	false	false	true	false
775e0f6f-a49a-4a0a-8ad0-eb3ac3bd6bc1	2026-09-03 11:30	2026-09-03 11:30	2026-09-03 11:30	LMB	LMB270115C00065000	call	65.0000	2027-01-15	3.0000	3.0000	3.7000	49.2600	11716.00	0.00	11716.00	39	6	723	1668	0.433453237410072	0.622855553898699	0.622855553898699	false	false	false	true	false
15bb12d2-2f5e-469b-aefd-ffff5c758965	2026-09-03 11:30	2026-09-03 11:30	2026-09-03 11:30	LMB	LMB270115C00065000	call	65.0000	2027-01-15	3.1000	3.1000	3.5000	49.1900	103850.00	0.00	103850.00	335	11	683	1668	0.40947242206235	0.625771230333507	0.632536367936787	false	false	false	true	false
82b03891-95cc-4150-9c54-044372388c28	2026-09-03 11:29	2026-09-03 11:29	2026-09-03 11:29	LMB	LMB270115C00065000	call	65.0000	2027-01-15	3.2000	3.2000	3.6000	49.7100	111050.00	0.00	110720.00	347	19	348	1668	0.20863309352518	0.626626117436923	0.626626117436923	false	false	false	true	false
a60e6c26-bc2d-4434-9d7c-fd2828fe5643	2026-09-02 14:20	2026-09-02 14:20	2026-09-02 14:20	LMB	LMB270115C00065000	call	65.0000	2027-01-15	2.9000	2.9000	3.4000	48.6000	115130.00	0.00	115130.00	397	11	401	2069	0.193813436442726	0.628051155890983	0.628051155890983	false	false	false	true	false
d988abb2-93a7-4fc1-987b-36b38dd8d93f	2026-09-02 10:16	2026-09-02 10:16	2026-09-02 10:16	LMB	LMB260918C00045000	call	45.0000	2026-09-18	3.0000	3.0000	4.7000	47.2350	38700.00	0.00	38700.00	129	12	655	741	0.883940620782726	0.41164184213497	0.41164184213497	false	false	false	true	false
5197d724-028a-44c1-b041-2338858bb172	2026-09-02 10:16	2026-09-02 10:15	2026-09-02 10:15	LMB	LMB260918C00045000	call	45.0000	2026-09-18	2.8600	2.7000	4.1000	47.1000	17990.00	0.00	17990.00	63	16	521	741	0.703103913630229	0.395908178168841	0.499644621250176	true	false	false	true	false
0dfc6608-ed7d-4093-8c9b-225851f1ff0b	2026-09-02 10:15	2026-09-02 10:15	2026-09-02 10:15	LMB	LMB260918C00045000	call	45.0000	2026-09-18	2.9200	1.8500	4.1000	47.3000	130966.00	35130.00	95836.00	449	37	449	741	0.605937921727395	0.459808307498279	0.348111653656156	true	false	false	true	false
cfbea98e-1a06-449d-a4e9-63fe6688eccf	2026-08-31 15:57	2026-08-31 15:57	2026-08-31 15:57	LMB	LMB260918C00045000	call	45.0000	2026-09-18	0.6500	0.4500	0.7000	41.2600	32435.00	17095.00	9230.00	499	9	501	234	2.14102564102564	0.513623117391204	0.513623117391204	false	false	false	true	false
84897090-48d6-4193-af02-3d3a2cedc0a5	2026-08-26 14:27	2026-08-26 14:27	2026-08-26 14:27	LMB	LMB261120P00040000	put	40.0000	2026-11-20	4.0700	3.9000	5.0000	41.7500	40733.00	0.00	40733.00	100	7	100	3	33.3333333333333	0.659997559786706	0.659997559786706	false	false	false	true	false
3c1234b5-5b10-42fe-951e-7d46b283e763	2026-08-25 15:10	2026-08-25 15:10	2026-08-25 15:10	LMB	LMB270115C00065000	call	65.0000	2027-01-15	1.6500	1.6500	1.9000	41.6900	16500.00	0.00	16500.00	100	5	1821	7	260.142857142857	0.662451147544768	0.662451147544768	false	false	false	true	false
5115fbd2-0277-4dbc-a09e-c3aedb62b2f3	2026-08-25 10:07	2026-08-25 10:07	2026-08-25 10:07	LMB	LMB270115C00065000	call	65.0000	2027-01-15	1.8000	1.0500	1.9500	41.8700	27000.00	25560.00	1440.00	150	28	400	7	57.1428571428571	0.677357406243738	0.677357406243738	false	false	false	true	false
4b338b8d-7c46-4ca2-b237-ef071fd8df35	2026-08-21 13:04	2026-08-21 13:04	2026-08-21 13:04	LMB	LMB260918C00045000	call	45.0000	2026-09-18	1.4500	1.0500	1.5500	42.1000	22470.00	22330.00	140.00	155	8	180	6	30	0.542567867695239	0.531124051446174	false	false	false	true	false