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

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	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-18T14:49:07.673043Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
4d865d10-3979-487f-bc98-5600e75ffb17	2026-08-28 13:24	2026-08-28 13:24	2026-08-28 13:24	BILI	BILI270115C00018000	call	18.0000	2027-01-15	1.5700	1.5200	1.5800	16.6495	17898.00	16328.00	1570.00	114	7	169	3141	0.0538045208532315	0.488327291747597	0.488327291747597	false	false	false
f6071d71-b686-4adc-847f-5c197fc24aa6	2026-08-31 09:45	2026-08-31 09:45	2026-08-31 09:45	BILI	BILI260918P00016000	put	16.0000	2026-09-18	0.4200	0.3700	0.4300	16.4100	20370.00	20370.00	0.00	485	7	501	1253	0.399840383080607	0.429128091841482	0.429128091841482	false	false	false
7797d4cc-4e37-4611-81a1-856d6d8353b5	2026-08-31 10:23	2026-08-31 10:22	2026-08-31 10:22	BILI	BILI260918P00016000	put	16.0000	2026-09-18	0.4100	0.4100	0.4500	16.3700	20090.00	0.00	20090.00	490	22	1116	1253	0.890662410215483	0.41104717934114	0.41104717934114	false	false	false
068b492a-3939-4197-9ae8-69816ea8fadb	2026-08-31 11:48	2026-08-31 11:47	2026-08-31 11:47	BILI	BILI270115P00017000	put	17.0000	2027-01-15	2.2400	2.2000	2.3700	16.3500	37408.00	37184.00	224.00	167	6	217	924	0.234848484848485	0.505485450655911	0.505485450655911	false	false	false
c33d55e4-4c6b-4727-a2e9-da511c7fd9ea	2026-09-01 10:20	2026-09-01 10:20	2026-09-01 10:20	BILI	BILI260918P00016000	put	16.0000	2026-09-18	0.5500	0.5400	0.6400	16.0300	24090.00	21340.00	2750.00	438	12	2685	1603	1.67498440424205	0.425205993266192	0.420145504443532	false	false	false
7fded6c7-b561-4acf-81d9-a8fe60cc3f7c	2026-09-01 10:25	2026-09-01 10:25	2026-09-01 10:25	BILI	BILI260918P00016000	put	16.0000	2026-09-18	0.6000	0.5700	0.6000	15.9400	28920.00	28920.00	0.00	482	9	4786	1603	2.98565190268247	0.435833398121044	0.425212366478789	false	false	false
5e219158-06cf-47d8-a1b9-87e94f756599	2026-09-01 10:25	2026-09-01 10:25	2026-09-01 10:25	BILI	BILI260918P00016000	put	16.0000	2026-09-18	0.6000	0.5700	0.6200	15.9700	20251.00	12871.00	7380.00	338	28	4304	1603	2.6849656893325	0.43933002588698	0.428553012387021	false	false	false
993a7ae9-91ea-4f45-9e1d-726439c62639	2026-09-01 14:04	2026-09-01 14:04	2026-09-01 14:04	BILI	BILI270115P00017000	put	17.0000	2027-01-15	2.4500	2.3900	2.4500	15.8700	58800.00	58800.00	0.00	240	18	240	1024	0.234375	0.500447770936062	0.500447770936062	false	false	false
9468e353-9610-4e57-ba8c-93a574749a08	2026-09-03 10:49	2026-09-03 10:49	2026-09-03 10:49	BILI	BILI260918P00016000	put	16.0000	2026-09-18	0.8800	0.8400	0.9500	15.3550	29658.00	1672.00	27986.00	337	39	851	10306	0.0825732582961382	0.403778916136209	0.403864674729533	false	false	false
37243c44-279f-4f2b-95e0-c2c997c9e385	2026-09-03 11:47	2026-09-03 11:47	2026-09-03 11:47	BILI	BILI260918P00016000	put	16.0000	2026-09-18	0.8300	0.8100	0.8900	15.4300	45734.00	83.00	45651.00	551	32	2068	10306	0.200659809819523	0.397795381246289	0.403436291130568	false	false	false
e006622c-842d-471d-a1f4-8c750a95c441	2026-09-04 09:33	2026-09-04 09:33	2026-09-04 09:33	BILI	BILI280121P00018000	put	18.0000	2028-01-21	4.7400	4.4500	5.1000	15.9250	47436.00	0.00	47436.00	100	11	100	239	0.418410041841004	0.551548553309592	0.551548553309592	false	false	false
6e2168d6-8db0-4c21-b7da-366357557dab	2026-09-04 13:19	2026-09-04 13:19	2026-09-04 13:19	BILI	BILI270115C00018000	call	18.0000	2027-01-15	1.0000	0.9800	1.0000	15.3550	20000.00	20000.00	0.00	200	23	1005	3650	0.275342465753425	0.496984419467137	0.496456007162732	true	false	false
26760fe6-de2d-41b7-817a-dcfb15402f9d	2026-09-08 10:43	2026-09-08 10:43	2026-09-08 10:43	BILI	BILI271217P00015000	put	15.0000	2027-12-17	2.7300	2.7300	2.9300	15.9500	91455.00	0.00	91455.00	335	26	335	278	1.20503597122302	0.530355795663632	0.530355795663632	false	false	false
678ef97f-f2d8-40c2-aed5-8fd566971441	2026-09-08 12:37	2026-09-08 12:37	2026-09-08 12:37	BILI	BILI271217C00027000	call	27.0000	2027-12-17	1.5400	1.4400	1.5500	15.9884	10776.00	10776.00	0.00	70	5	79	168	0.470238095238095	0.541044612220546	0.541044612220546	false	false	false
0c4c46eb-f6e3-4fb6-8192-52822b278e42	2026-09-08 12:37	2026-09-08 12:37	2026-09-08 12:37	BILI	BILI271217C00027000	call	27.0000	2027-12-17	1.5500	1.4400	1.5600	16.0150	22320.00	22165.00	155.00	144	15	416	168	2.47619047619048	0.542801978352067	0.542801978352067	false	false	false
18aa6c4f-365b-4658-af04-91e298a01b7d	2026-09-08 12:38	2026-09-08 12:37	2026-09-08 12:37	BILI	BILI271217P00015000	put	15.0000	2027-12-17	2.7700	2.6200	2.7700	16.0150	67311.00	67311.00	0.00	243	24	585	278	2.10431654676259	0.53981079198306	0.53981079198306	false	false	false
099c0dbc-37d7-4139-a3c5-e0b1aebc7d71	2026-09-08 12:38	2026-09-08 12:38	2026-09-08 12:38	BILI	BILI271217P00015000	put	15.0000	2027-12-17	2.7800	2.6200	2.7800	15.9850	41700.00	41700.00	0.00	150	7	735	278	2.64388489208633	0.539931149914525	0.539931149914525	false	false	false
898dd924-788d-427c-8589-8165e3f3dc77	2026-09-08 14:50	2026-09-08 14:50	2026-09-08 14:50	BILI	BILI270115P00016000	put	16.0000	2027-01-15	1.6800	1.6400	1.6800	16.2650	211512.00	211512.00	0.00	1259	45	1259	4415	0.285164212910532	0.505758053004237	0.505758053004237	false	false	false
5e6288f9-c5f1-411d-a02f-f6c81b6de7ef	2026-09-14 14:12	2026-09-14 14:12	2026-09-14 14:12	BILI	BILI270115P00014000	put	14.0000	2027-01-15	0.9200	0.8900	0.9300	15.8000	31648.00	31372.00	0.00	344	9	344	488	0.704918032786885	0.509492367947603	0.509492367947603	false	false	false
748d4994-f115-4bbd-8926-d6eeb32055e9	2026-09-16 10:33	2026-09-16 10:33	2026-09-16 10:33	BILI	BILI260918P00015000	put	15.0000	2026-09-18	0.2400	0.2400	0.2800	15.0000	30746.00	4825.00	25921.00	1273	30	1284	390	3.29230769230769	0.584540908459555	0.584540908459555	false	false	false
4fecd09d-a355-49ed-b114-bc8958bc95df	2026-09-16 10:33	2026-09-16 10:33	2026-09-16 10:33	BILI	BILI260918P00015000	put	15.0000	2026-09-18	0.2400	0.2000	0.2500	15.0000	122904.00	24672.00	98232.00	5121	8	6413	390	16.4435897435897	0.556522417065328	0.556522417065328	false	false	false
15429b5a-f44d-4814-8a4c-1cc47e3c42d9	2026-09-16 10:33	2026-09-16 10:33	2026-09-16 10:33	BILI	BILI260918C00015000	call	15.0000	2026-09-18	0.2600	0.2600	0.2700	15.0000	29298.00	4104.00	25194.00	1121	14	1245	214	5.81775700934579	0.588538120220385	0.588538120220385	true	false	false
d566972d-84d8-40b3-b199-49f150c9c500	2026-09-17 12:00	2026-09-17 12:00	2026-09-17 12:00	BILI	BILI261016P00014000	put	14.0000	2026-10-16	0.4800	0.4600	0.4800	14.5050	12000.00	12000.00	0.00	250	7	1573	900	1.74777777777778	0.451233212875802	0.451233212875802	false	false	false
68229359-8444-44be-90ab-2589fe8b583c	2026-09-17 13:30	2026-09-17 13:30	2026-09-17 13:30	BILI	BILI270115C00020000	call	20.0000	2027-01-15	0.4800	0.4700	0.6800	14.4650	16310.00	13536.00	2774.00	340	49	345	1528	0.225785340314136	0.561137363767052	0.556508808784564	false	false	false
08e209bf-839f-46a2-bd03-5f6cbf8635da	2026-09-18 13:36	2026-09-18 13:36	2026-09-18 13:36	BILI	BILI261016C00015000	call	15.0000	2026-10-16	0.7500	0.7300	0.7600	14.9550	11250.00	11250.00	0.00	150	7	197	1560	0.126282051282051	0.453993543697906	0.453993543697906	false	false	false
afd3c654-4a7e-4b76-af9c-e339fa5b5dc3	2026-09-18 13:57	2026-09-18 13:57	2026-09-18 13:57	BILI	BILI261016P00015000	put	15.0000	2026-10-16	0.7500	0.6900	0.7500	14.9350	11250.00	11250.00	0.00	150	16	203	1803	0.112590127565169	0.448577432492419	0.448577432492419	false	false	false
d3a2eadb-7b9b-48f3-992e-29913919b6b6	2026-09-18 13:57	2026-09-18 13:57	2026-09-18 13:57	BILI	BILI261016P00015000	put	15.0000	2026-10-16	0.7500	0.7000	0.7500	14.9332	13275.00	13275.00	0.00	177	12	380	1803	0.210759844703272	0.448053590674278	0.448053590674278	false	false	false
59e96a1e-4406-47a3-93f3-7332447f2409	2026-09-21 10:31	2026-09-21 10:31	2026-09-21 10:31	BILI	BILI270115C00022000	call	22.0000	2027-01-15	0.3600	0.3600	0.4000	14.9700	53100.00	0.00	29376.00	1475	31	1475	5889	0.250466972321277	0.574379551539965	0.573769204981339	false	false	false