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

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

b427034f-2eae-4767-aec2-4dc655899ef0	2026-08-28 10:00	2026-08-28 10:00	2026-08-28 10:00	BILI	BILI280121C00018000	call	18.0000	2028-01-21	4.5000	3.8500	4.5000	16.7300	13500.00	13500.00	0.00	30	5	30	404	0.0742574257425743	0.593925292835974	0.593925292835974	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Communication Services	5273184925.00	2026-11-12	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T14:08:43.927668Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a1f6bb65-d7fc-4062-9853-693d7eb10dfd	2026-08-27 15:55	2026-08-27 15:55	2026-08-27 15:55	BILI	BILI260918P00016000	put	16.0000	2026-09-18	0.4100	0.4000	0.4100	16.6600	20500.00	20500.00	0.00	500	31	3026	181	16.7182320441989	0.441039991101932	0.441039991101932	false	false	false	true	false
34875954-7ce9-4bfb-be0c-b6b93071fbca	2026-08-27 15:38	2026-08-27 15:38	2026-08-27 15:38	BILI	BILI270115C00018000	call	18.0000	2027-01-15	1.6100	1.6000	1.7000	16.6200	28980.00	0.00	28980.00	180	14	682	2704	0.252218934911243	0.499563249904766	0.499563249904766	false	false	false	true	false
9b336c5a-a8c1-4176-9d00-9887be38c079	2026-08-27 15:38	2026-08-27 15:38	2026-08-27 15:38	BILI	BILI270115C00018000	call	18.0000	2027-01-15	1.6200	1.6100	1.7100	16.6150	15882.00	0.00	15882.00	98	7	502	2704	0.185650887573965	0.509866471088507	0.509866471088507	false	false	false	true	false
ec8453cb-386a-4e8a-80f1-b32cd3d075df	2026-08-27 15:38	2026-08-27 15:38	2026-08-27 15:38	BILI	BILI270115P00018000	put	18.0000	2027-01-15	2.7600	2.7600	2.8500	16.6150	41400.00	0.00	41400.00	150	23	501	3255	0.153917050691244	0.509110896541362	0.509110896541362	false	false	false	true	false
2422599f-b193-428e-972a-d6cac9dc6e02	2026-08-27 13:01	2026-08-27 13:01	2026-08-27 13:01	BILI	BILI260918P00016000	put	16.0000	2026-09-18	0.3900	0.3800	0.4300	16.7100	19929.00	1014.00	18915.00	511	14	1281	181	7.07734806629834	0.438365459415895	0.438365459415895	false	false	false	true	false
c031e78d-c15b-42bf-b510-adbc9c3757e9	2026-08-26 11:59	2026-08-26 11:58	2026-08-26 11:58	BILI	BILI260828P00015500	put	15.5000	2026-08-28	0.2800	0.2500	0.2800	16.1700	28000.00	28000.00	0.00	1000	27	1013	193	5.24870466321244	1.18238875252185	1.18238875252185	false	false	false	true	false
602ad1f8-dc71-421d-81a6-bdf7f48bf609	2026-08-25 13:53	2026-08-25 13:52	2026-08-25 13:52	BILI	BILI270115C00018000	call	18.0000	2027-01-15	1.7700	1.7200	1.8300	16.6000	50799.00	4779.00	46020.00	287	9	290	2703	0.107288198298187	0.536550663108804	0.536550663108804	false	false	false	true	false
f820e4ae-64b8-46af-a58c-1b66f5eb8f04	2026-08-25 13:52	2026-08-25 13:52	2026-08-25 13:52	BILI	BILI270115P00018000	put	18.0000	2027-01-15	2.9000	2.8800	2.9100	16.5950	23200.00	15660.00	7540.00	80	5	441	2841	0.155227032734952	0.537649447069172	0.537649447069172	true	false	false	true	false
01a55a4a-19fe-47fa-86f2-a05d7aa4e111	2026-08-25 13:52	2026-08-25 13:52	2026-08-25 13:52	BILI	BILI270115P00018000	put	18.0000	2027-01-15	2.9000	2.8800	2.9000	16.6050	45820.00	45820.00	0.00	158	13	361	2841	0.127067933826118	0.538880936624863	0.538880936624863	false	false	false	true	false
a8c08c74-996d-4320-a70a-e1303f07ecf7	2026-08-20 14:07	2026-08-20 14:07	2026-08-20 14:07	BILI	BILI280121C00018000	call	18.0000	2028-01-21	4.2000	4.0500	4.3000	16.5900	15120.00	5460.00	9660.00	36	5	124	293	0.42320819112628	0.559349677948473	0.559349677948473	false	false	false	true	false
afbf994e-59a7-474a-9c85-48219e3560b1	2026-08-20 10:06	2026-08-20 10:05	2026-08-20 10:05	BILI	BILI261016C00017000	call	17.0000	2026-10-16	1.2200	1.1500	1.2200	16.6450	36355.00	36355.00	0.00	298	6	301	225	1.33777777777778	0.509844381725449	0.508872535854646	true	false	false	true	false
80a6b2ec-b7d0-4ede-82d3-6841f8e788b9	2026-08-19 13:06	2026-08-19 13:06	2026-08-19 13:06	BILI	BILI261016P00016000	put	16.0000	2026-10-16	0.7500	0.7400	0.7700	17.2700	15280.00	8175.00	7105.00	205	11	509	3158	0.161177960734642	0.498369795858854	0.502523063345558	false	false	false	true	false
04639683-ab90-4e70-9f33-69c2f47eb231	2026-08-19 11:40	2026-08-19 11:40	2026-08-19 11:40	BILI	BILI260918P00017000	put	17.0000	2026-09-18	0.9000	0.8500	0.9000	17.3100	23490.00	23490.00	0.00	261	10	269	126	2.13492063492063	0.54758598256256	0.54758598256256	false	false	false	true	false
4ec3c6ce-8c4d-4b03-83d7-7a6d4d3c37c0	2026-08-18 10:40	2026-08-18 10:40	2026-08-18 10:40	BILI	BILI261016C00022000	call	22.0000	2026-10-16	0.3300	0.3300	0.3400	17.0300	29733.00	0.00	29733.00	901	24	5019	113	44.4159292035398	0.582850915260896	0.582850915260896	false	false	false	true	false
a9b52399-4f7e-4344-9691-8ee201da5022	2026-08-18 10:40	2026-08-18 10:40	2026-08-18 10:40	BILI	BILI261016C00022000	call	22.0000	2026-10-16	0.3300	0.2300	0.3400	17.0200	34782.00	21252.00	13530.00	1054	29	4118	113	36.4424778761062	0.583834836352066	0.583834836352066	false	false	false	true	false
4ac25367-b0c2-43b4-a11a-41136cab871e	2026-08-18 10:40	2026-08-18 10:40	2026-08-18 10:40	BILI	BILI261016C00022000	call	22.0000	2026-10-16	0.3300	0.3300	0.3400	17.0100	15345.00	0.00	1155.00	465	13	3028	113	26.7964601769912	0.584819068762851	0.584819068762851	false	false	false	true	false
09fb7e19-193c-4ce8-abd3-4e7f41a3f32b	2026-08-18 10:40	2026-08-18 10:40	2026-08-18 10:40	BILI	BILI261016C00018000	call	18.0000	2026-10-16	1.0600	0.9000	1.2900	17.0300	138143.00	32461.00	105682.00	1304	29	1306	6640	0.196686746987952	0.516899816017418	0.514859669719527	true	false	false	true	false
7439e8ad-b77b-4c6a-994f-8da786b9bdaa	2026-08-18 10:40	2026-08-18 10:40	2026-08-18 10:40	BILI	BILI261016C00020000	call	20.0000	2026-10-16	0.6000	0.4500	0.6000	17.0550	11820.00	11820.00	0.00	197	10	198	1572	0.125954198473282	0.555532937265774	0.555532937265774	true	false	false	true	false
f686e0ec-1766-4826-8d3d-6f11f8ba5c0d	2026-08-18 10:39	2026-08-18 10:39	2026-08-18 10:39	BILI	BILI261016C00022000	call	22.0000	2026-10-16	0.3300	0.2700	0.3300	17.0500	31482.00	31482.00	0.00	954	24	2442	113	21.6106194690265	0.580884001836337	0.580884001836337	false	false	false	true	false
1272ebc9-115b-44a0-a0d3-3fc951dad1bc	2026-08-18 10:39	2026-08-18 10:39	2026-08-18 10:39	BILI	BILI261016C00022000	call	22.0000	2026-10-16	0.3300	0.2600	0.3300	17.0300	23639.00	21879.00	1760.00	718	31	1488	113	13.1681415929204	0.582850915260896	0.577074101103405	false	false	false	true	false
763aea3d-ea57-482e-aeff-fc501d092a7d	2026-08-18 10:39	2026-08-18 10:39	2026-08-18 10:39	BILI	BILI261016C00022000	call	22.0000	2026-10-16	0.3100	0.3100	0.3500	16.9800	23870.00	0.00	5952.00	770	16	770	113	6.8141592920354	0.576090295263847	0.576090295263847	false	false	false	true	false