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.
uw_flow_alerts326,449 rowsrestricted — hover for the licence| 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 |
|---|
| bidnumeric |
|---|
| asknumeric |
|---|
| underlying_pricenumeric |
|---|
| total_premiumnumeric |
|---|
| total_ask_side_premnumeric |
|---|
| total_bid_side_premnumeric |
|---|
| total_sizebigint |
|---|
| trade_countinteger |
|---|
| volumebigint |
|---|
| open_interestbigint |
|---|
| volume_oi_rationumeric |
|---|
| iv_startnumeric |
|---|
| iv_endnumeric |
|---|
| has_sweepboolean |
|---|
| has_floorboolean |
|---|
| has_multilegboolean |
|---|
| has_singlelegboolean |
|---|
| all_opening_tradesboolean |
|---|
| alert_ruletext |
|---|
| rule_iduuid |
|---|
| expiry_countinteger |
|---|
| issue_typetext |
|---|
| sectortext |
|---|
| marketcapnumeric |
|---|
| next_earnings_datedate |
|---|
| er_timetext |
|---|
| missing_periscopeboolean |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 883aeb01-fa77-4e93-a034-648fd96000c7 | 2026-09-18 11:54 | 2026-09-18 11:54 | 2026-09-18 11:54 | LYFT | LYFT270115P00012000 | put | 12.0000 | 2027-01-15 | 0.4600 | 0.4600 | 0.5100 | 15.1550 | 10350.00 | 0.00 | 10350.00 | 225 | 15 | 250 | 30799 | 0.00811714666060586 | 0.525521386108334 | 0.525521386108334 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 5715957760.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| a5d3d594-1cd6-4c1c-9d9e-3c71706b8048 | 2026-09-18 13:15 | 2026-09-18 13:14 | 2026-09-18 13:14 | LYFT | LYFT261016C00015000 | call | 15.0000 | 2026-10-16 | 0.8200 | 0.8100 | 0.8500 | 15.1700 | 21811.00 | 0.00 | 21811.00 | 266 | 22 | 285 | 3201 | 0.0890346766635426 | 0.425036811343542 | 0.425036811343542 | true | false | false | true | false | |||||||||||||||
| 3415803c-26f5-4bfa-83c4-d7f68ca0fabb | 2026-09-21 11:56 | 2026-09-21 11:56 | 2026-09-21 11:56 | LYFT | LYFT270917C00027000 | call | 27.0000 | 2027-09-17 | 0.8700 | 0.8700 | 0.9300 | 15.2350 | 11310.00 | 0.00 | 11310.00 | 130 | 23 | 525 | 306 | 1.7156862745098 | 0.534649877634744 | 0.534649877634744 | true | false | false | true | false | |||||||||||||||
| 79580384-a0c3-4fd3-bb9a-4d26188369d0 | 2026-09-21 12:11 | 2026-09-21 12:11 | 2026-09-21 12:11 | LYFT | LYFT270115P00012000 | put | 12.0000 | 2027-01-15 | 0.4400 | 0.4400 | 0.5100 | 15.2100 | 21209.00 | 0.00 | 21209.00 | 482 | 24 | 484 | 30623 | 0.0158051138033504 | 0.5262061401437 | 0.53135842867593 | false | false | false | true | false | |||||||||||||||
| 88585259-0eab-494a-a910-23cfd5043f71 | 2026-09-21 12:47 | 2026-09-21 12:47 | 2026-09-21 12:47 | LYFT | LYFT270115P00012000 | put | 12.0000 | 2027-01-15 | 0.4400 | 0.4400 | 0.4800 | 15.2300 | 16896.00 | 0.00 | 16896.00 | 384 | 11 | 869 | 30623 | 0.0283773634196519 | 0.528123715893081 | 0.528123715893081 | false | false | false | true | false | |||||||||||||||
| 0bf02585-9d67-454f-acef-3150a1725bf0 | 2026-09-21 13:13 | 2026-09-21 13:13 | 2026-09-21 13:13 | LYFT | LYFT270115P00012000 | put | 12.0000 | 2027-01-15 | 0.4300 | 0.4300 | 0.4800 | 15.2350 | 10406.00 | 0.00 | 10406.00 | 242 | 18 | 1111 | 30623 | 0.0362799203213271 | 0.523701777106621 | 0.523701777106621 | false | false | false | true | false | |||||||||||||||
| e12a1bb8-cc63-4ae1-afc9-5a72f1a1e949 | 2026-09-21 14:35 | 2026-09-21 14:35 | 2026-09-21 14:35 | LYFT | LYFT270115C00015000 | call | 15.0000 | 2027-01-15 | 1.9600 | 1.9600 | 2.0000 | 15.2800 | 18620.00 | 0.00 | 18620.00 | 95 | 21 | 149 | 32686 | 0.00455852658630606 | 0.506980086133377 | 0.506980086133377 | false | false | false | true | false | |||||||||||||||
| 05bbd2ce-0b05-4c91-b888-8c30e66636a8 | 2026-09-21 15:49 | 2026-09-21 15:49 | 2026-09-21 15:49 | LYFT | LYFT270115P00015000 | put | 15.0000 | 2027-01-15 | 1.4500 | 1.3800 | 1.4500 | 15.0000 | 145000.00 | 145000.00 | 0.00 | 1000 | 10 | 1001 | 20812 | 0.0480972515856237 | 0.503571242342287 | 0.503571242342287 | false | false | false | true | false | |||||||||||||||
| a3b9796b-fd9d-491f-97a4-04cd2e45a867 | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | LYFT | LYFT261016C00016000 | call | 16.0000 | 2026-10-16 | 0.4600 | 0.4400 | 0.4600 | 15.5400 | 21160.00 | 230.00 | 0.00 | 460 | 55 | 463 | 1706 | 0.271395076201641 | 0.402289557760468 | 0.402289557760468 | false | false | false | true | false | |||||||||||||||
| 53a71d93-ec61-4572-8320-0f83e2599b18 | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | LYFT | LYFT261120C00017000 | call | 17.0000 | 2026-11-20 | 0.8000 | 0.7800 | 0.8100 | 15.5100 | 16143.00 | 6762.00 | 0.00 | 201 | 29 | 455 | 425 | 1.07058823529412 | 0.532816861123989 | 0.537007035394719 | false | false | false | true | false | |||||||||||||||
| 085ed890-ecad-46bd-b742-0a671bef45aa | 2026-09-22 11:10 | 2026-09-22 11:10 | 2026-09-22 11:10 | LYFT | LYFT270319P00015000 | put | 15.0000 | 2027-03-19 | 1.9700 | 1.8300 | 2.0400 | 15.0300 | 11426.00 | 7486.00 | 3940.00 | 58 | 5 | 58 | 1628 | 0.0356265356265356 | 0.518604280439498 | 0.518604280439498 | false | false | false | true | false | |||||||||||||||
| c7d0dc12-e0c8-4aad-af57-c331740eb8fe | 2026-09-22 14:40 | 2026-09-22 14:40 | 2026-09-22 14:40 | LYFT | LYFT261016C00015000 | call | 15.0000 | 2026-10-16 | 0.6600 | 0.6500 | 0.6700 | 14.9050 | 149820.00 | 149754.00 | 66.00 | 2270 | 18 | 3312 | 3316 | 0.998793727382388 | 0.450383869424284 | 0.450383869424284 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5715957760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5780309602.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5780309602.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:13:06.153982Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5780309602.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:51:16.040164Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5780309602.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:16:02.178873Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5780309602.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:37:54.025147Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5780309602.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:50:07.722851Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5640249710.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5640249710.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5640249710.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:15:45.651673Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5640249710.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:44:24.241276Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |