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 = 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

cb56cc76-7979-4c77-a177-30abfdd35493	2026-09-25 15:32	2026-09-25 15:32	2026-09-25 15:32	BILI	BILI270115C00021000	call	21.0000	2027-01-15	0.3700	0.3700	0.3800	14.8550	10656.00	0.00	6327.00	288	8	394	3313	0.118925445215816	0.550311153464013	0.550311153464013	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Communication Services	4990094629.00	2026-11-12	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:35:55.847824Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
9d46d6b5-e7ce-4521-bfd5-2a6ba5e16e8e	2026-09-23 15:28	2026-09-23 15:28	2026-09-23 15:28	BILI	BILI270115C00015000	call	15.0000	2027-01-15	1.7700	1.7700	1.7900	15.0000	11505.00	0.00	11505.00	65	6	7822	2154	3.6313834726091	0.492634628708254	0.492634628708254	false	false	false	true
ea0ecf87-49fb-4c67-91ac-8c8a793d82fc	2026-09-23 13:57	2026-09-23 13:57	2026-09-23 13:57	BILI	BILI270115P00015000	put	15.0000	2027-01-15	1.5900	1.5800	1.6300	15.0100	10494.00	3657.00	5247.00	66	6	5051	2438	2.07178014766202	0.510247373008513	0.510893006697144	false	false	false	true
af5b33e8-2d57-4a98-9180-ad6748a28fb6	2026-09-23 13:48	2026-09-23 13:47	2026-09-23 13:47	BILI	BILI270115C00015000	call	15.0000	2027-01-15	1.7400	1.6900	1.7800	14.0000	23838.00	8700.00	15138.00	137	20	4308	2154	2	0.501014674567927	0.501014674567927	false	false	false	true
9ebfa20e-f6bc-4483-8f09-b9ab4c68f03b	2026-09-23 13:18	2026-09-23 13:18	2026-09-23 13:18	BILI	BILI270115C00015000	call	15.0000	2027-01-15	1.7200	1.7000	1.7800	14.0000	18920.00	0.00	18920.00	110	21	2805	2154	1.30222841225627	0.496660616674341	0.496660616674341	false	false	false	true
17ba80a4-3ac8-4b4b-8377-5cb109e8eb18	2026-09-23 13:18	2026-09-23 13:18	2026-09-23 13:18	BILI	BILI270115C00015000	call	15.0000	2027-01-15	1.7200	1.7200	1.7400	14.0000	12728.00	0.00	12728.00	74	8	2967	2154	1.37743732590529	0.496660616674341	0.496660616674341	false	false	false	true
94740b57-52d4-4a90-bc86-684a15813d49	2026-09-23 13:15	2026-09-23 13:15	2026-09-23 13:15	BILI	BILI270115C00015000	call	15.0000	2027-01-15	1.7000	1.7000	1.7500	14.0000	11900.00	0.00	11900.00	70	7	2022	2154	0.938718662952646	0.492302225512761	0.491453424274463	false	false	false	true
9c954ed6-81bd-48ec-a79f-bc465e067227	2026-09-23 13:15	2026-09-23 13:15	2026-09-23 13:15	BILI	BILI270115C00015000	call	15.0000	2027-01-15	1.7100	1.7000	1.9100	14.0000	21375.00	4617.00	16758.00	125	5	1951	2154	0.905756731662024	0.494499303850987	0.495348568742123	false	false	false	true
5d77c84d-2f54-463d-8f50-ac0163d15ba9	2026-09-23 13:15	2026-09-23 13:15	2026-09-23 13:15	BILI	BILI270115C00015000	call	15.0000	2027-01-15	1.7000	1.7000	1.7100	14.0000	10200.00	0.00	10200.00	60	6	1786	2154	0.829155060352832	0.49150540514938	0.492302225512761	false	false	false	true
876a3b62-bd87-42b2-b159-c0f5c7403c70	2026-09-23 13:14	2026-09-23 13:14	2026-09-23 13:14	BILI	BILI270115C00015000	call	15.0000	2027-01-15	1.7000	1.7000	1.7100	14.0000	13600.00	0.00	13600.00	80	18	1568	2154	0.72794800371402	0.491453424274463	0.491453424274463	false	false	false	true
29b78e27-97c0-4b95-a3fa-a4c0bba46e8b	2026-09-23 13:13	2026-09-23 13:13	2026-09-23 13:13	BILI	BILI270115P00015000	put	15.0000	2027-01-15	1.6000	1.5600	1.6600	14.0000	12960.00	4960.00	8000.00	81	7	1093	2438	0.448318293683347	0.506137425476559	0.506137425476559	false	false	false	true
9522ed47-1bfe-41d9-9103-c508b7ed2d62	2026-09-23 13:11	2026-09-23 13:10	2026-09-23 13:10	BILI	BILI270115C00015000	call	15.0000	2027-01-15	1.7100	1.6800	1.7300	14.9650	11652.00	7035.00	171.00	68	5	320	2154	0.148560817084494	0.491010693335494	0.491879249352714	false	false	false	true
59c973af-b9be-48d3-8cbc-d9fcaecb2d9f	2026-09-23 13:11	2026-09-23 13:10	2026-09-23 13:10	BILI	BILI270115P00015000	put	15.0000	2027-01-15	1.6000	1.5600	1.6000	14.9650	10080.00	10080.00	0.00	63	8	559	2438	0.229286300246103	0.508098595795522	0.508098595795522	false	false	false	true
3ce8edee-dc46-4353-9f16-2f2abdfb0979	2026-09-23 13:11	2026-09-23 13:10	2026-09-23 13:10	BILI	BILI270115P00015000	put	15.0000	2027-01-15	1.6000	1.5500	1.6500	14.9700	14720.00	10720.00	4000.00	92	15	317	2438	0.130024610336341	0.508750621984672	0.508750621984672	false	false	false	true
c148c090-abba-48f9-805c-053b0356b7cd	2026-09-22 12:01	2026-09-22 12:01	2026-09-22 12:01	BILI	BILI270115C00015000	call	15.0000	2027-01-15	1.8600	1.8600	1.8900	15.1700	87978.00	0.00	86118.00	473	17	1086	444	2.44594594594595	0.498874772012336	0.498874772012336	false	false	false	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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