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×er_time = unknown×ticker = BTI×

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

07ae64bb-9c97-4d8f-a470-2078603dbca3	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	BTI	BTI270115C00060000	call	60.0000	2027-01-15	1.0500	1.0500	1.1500	55.6200	21000.00	0.00	21000.00	200	6	245	1720	0.142441860465116	0.192068522443089	0.192068522443089	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Consumer Defensive	128641843891.00	—	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:54:56.567521Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
433259d2-842c-4148-9569-b21da8e1dbb0	2026-09-25 11:17	2026-09-25 11:17	2026-09-25 11:17	BTI	BTI261218C00060000	call	60.0000	2026-12-18	0.8100	0.8000	0.9000	55.3800	39197.00	0.00	39197.00	482	7	495	2936	0.168596730245232	0.210325993049374	0.210325993049374	false	false	false
77f8d74c-a87c-41aa-ad89-49cc89b05364	2026-09-24 13:16	2026-09-24 13:16	2026-09-24 13:16	BTI	BTI261218C00060000	call	60.0000	2026-12-18	1.0000	1.0000	1.2000	56.1500	50000.00	0.00	50000.00	500	6	512	2946	0.173794976238968	0.204128052411594	0.204128052411594	false	false	false
f960eab8-ad95-450d-aa98-65842db9cc30	2026-09-23 15:49	2026-09-23 15:49	2026-09-23 15:49	BTI	BTI261218C00055000	call	55.0000	2026-12-18	3.0000	2.7500	3.0000	55.8350	324556.00	324556.00	0.00	1082	34	1084	1000	1.084	0.210599969423849	0.210599969423849	true	false	false
e4c5dd0c-3fae-4f22-a55e-88083cdbd67a	2026-09-23 15:49	2026-09-23 15:49	2026-09-23 15:49	BTI	BTI270115C00055000	call	55.0000	2027-01-15	3.2000	3.0000	3.2000	55.8350	40960.00	31360.00	0.00	128	15	440	2033	0.216428922774225	0.190449975034294	0.190449975034294	true	false	false
695b7980-8255-45be-863d-6809a754f7a8	2026-09-23 15:49	2026-09-23 15:49	2026-09-23 15:49	BTI	BTI261120C00055000	call	55.0000	2026-11-20	2.3500	2.1500	2.3500	55.8350	15510.00	15040.00	0.00	66	10	73	53	1.37735849056604	0.192193513388872	0.192193513388872	true	false	false
4eb431e5-3ffc-4cc3-bfd2-e1678085bc55	2026-09-23 10:57	2026-09-23 10:57	2026-09-23 10:57	BTI	BTI270115C00055000	call	55.0000	2027-01-15	3.1000	3.0000	3.2000	55.0000	15500.00	0.00	10540.00	50	6	262	2033	0.128873585833743	0.187003911854585	0.187003911854585	false	false	false
7010a82b-7e76-4f9d-899c-c40af5a8de00	2026-09-21 12:54	2026-09-21 12:54	2026-09-21 12:54	BTI	BTI280121C00095000	call	95.0000	2028-01-21	0.4000	0.4000	0.8500	55.0000	18920.00	0.00	18920.00	473	26	511	1505	0.33953488372093	0.244964949393252	0.244964949393252	false	false	false
72ebb862-56e5-4740-973d-665d98bdae7e	2026-09-21 12:24	2026-09-21 12:24	2026-09-21 12:24	BTI	BTI261218C00065000	call	65.0000	2026-12-18	0.3000	0.3000	0.4500	55.7200	13500.00	0.00	13500.00	450	7	464	2677	0.173328352633545	0.225336752102088	0.225336752102088	false	false	false
19fefb57-b8a1-4f5b-8409-0c7cd944a455	2026-09-21 10:56	2026-09-21 10:56	2026-09-21 10:56	BTI	BTI261016C00055000	call	55.0000	2026-10-16	1.5500	1.5000	1.5500	55.6700	12090.00	12090.00	0.00	78	6	240	750	0.32	0.189247282927483	0.189247282927483	false	false	false
8a472a74-2571-4adf-bbe6-c55cf212dfb1	2026-08-28 12:03	2026-08-28 12:03	2026-08-28 12:03	BTI	BTI261218C00060000	call	60.0000	2026-12-18	1.5500	1.5000	1.6000	56.0000	110980.00	110825.00	155.00	716	19	729	2416	0.301738410596026	0.223850434139137	0.223850434139137	false	false	false
40216486-78cc-402b-b817-38b088f5a385	2026-08-26 09:52	2026-08-26 09:52	2026-08-26 09:52	BTI	BTI261218P00055000	put	55.0000	2026-12-18	2.2500	2.1000	2.2500	57.3110	121030.00	121030.00	0.00	538	39	543	1528	0.355366492146597	0.284833341579228	0.284833341579228	false	false	false
036d8b26-d343-4e0c-a7b7-c8178cca320a	2026-08-20 09:51	2026-08-20 09:51	2026-08-20 09:51	BTI	BTI260918C00060000	call	60.0000	2026-09-18	0.4000	0.4000	0.5000	56.4500	52819.00	0.00	52819.00	1320	38	1340	5176	0.258887171561051	0.234075338580046	0.234075338580046	false	false	false
e9db8c4a-f6db-4f32-be81-dd699523d5be	2026-08-18 10:04	2026-08-18 10:04	2026-08-18 10:04	BTI	BTI261218P00055000	put	55.0000	2026-12-18	2.5500	2.5500	2.7000	56.5100	122423.00	0.00	122423.00	480	42	480	1055	0.454976303317536	0.278570594740612	0.278570594740612	false	false	false