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_alerts658,639 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 |
|---|
| pricenumeric |
|---|
| 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 |
|---|
| 43cea6d3-9939-4a03-9f29-2df137057ae8 | 2026-09-23 15:57 | 2026-09-23 15:57 | 2026-09-23 15:57 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 7.0500 | 6.7500 | 7.3000 | 337.9000 | 118441.00 | 116325.00 | 2116.00 | 168 | 76 | 12800 | 3193 | 4.00876918258691 | 2.35905579483761 | 2.35905579483761 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1982386440000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T19:57:58.068578Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 3aa32ccc-6edb-4248-b632-911fa1832fe3 | 2026-09-23 15:13 | 2026-09-23 15:12 | 2026-09-23 15:12 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 5.5000 | 5.4000 | 5.6000 | 339.4600 | 91316.00 | 17607.00 | 71504.00 | 166 | 93 | 12457 | 3193 | 3.90134669589728 | 1.01263524350969 | 1.01263524350969 | true | false | false | |||||||||||||||||
| 46c54790-a128-40b6-a991-bb62cf2393fc | 2026-09-23 10:53 | 2026-09-23 10:53 | 2026-09-23 10:53 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 3.3000 | 3.3000 | 3.5500 | 342.0000 | 95391.00 | 0.00 | 95391.00 | 289 | 24 | 11380 | 3193 | 3.56404635139367 | 0.389037268683292 | 0.389037268683292 | false | false | false | |||||||||||||||||
| 1b22c0c8-3268-4619-a3c2-e9aad9023a11 | 2026-09-23 10:53 | 2026-09-23 10:53 | 2026-09-23 10:53 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 3.3000 | 3.3000 | 3.3500 | 342.0200 | 26730.00 | 0.00 | 26730.00 | 81 | 5 | 11482 | 3193 | 3.59599123081741 | 0.39656484283841 | 0.39656484283841 | false | false | false | |||||||||||||||||
| 8f6906a5-23ce-45db-8b61-70a094a0742d | 2026-09-23 10:22 | 2026-09-23 10:22 | 2026-09-23 10:22 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 4.9000 | 4.6000 | 5.0500 | 340.5000 | 20580.00 | 20580.00 | 0.00 | 42 | 7 | 10784 | 3193 | 3.37738803632947 | 0.555282349704677 | 0.532988170170022 | false | false | false | |||||||||||||||||
| d03c0132-9537-4763-81f8-6265d5184405 | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 1.0500 | 1.0000 | 1.0500 | 346.3200 | 10500.00 | 10500.00 | 0.00 | 100 | 13 | 6728 | 3193 | 2.10710930159724 | 0.44505515857709 | 0.44505515857709 | true | false | false | |||||||||||||||||
| fba2f671-afb4-4ac3-a22c-9b02c419b661 | 2026-09-22 14:11 | 2026-09-22 14:11 | 2026-09-22 14:11 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 0.4800 | 0.4700 | 0.4900 | 352.9201 | 12912.00 | 0.00 | 12432.00 | 269 | 10 | 6909 | 975 | 7.08615384615385 | 0.391952222467536 | 0.391952222467536 | false | false | false | |||||||||||||||||
| c3e1a8c8-55d3-48de-9011-a358eb3b6459 | 2026-09-22 13:37 | 2026-09-22 13:37 | 2026-09-22 13:37 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 0.6600 | 0.6300 | 0.6600 | 351.0000 | 12474.00 | 12474.00 | 0.00 | 189 | 9 | 6341 | 975 | 6.50358974358974 | 0.39457599733415 | 0.39457599733415 | false | false | false | |||||||||||||||||
| 2c958ee8-3ae0-46a4-ae60-a06435acf385 | 2026-09-22 13:31 | 2026-09-22 13:31 | 2026-09-22 13:31 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 0.5700 | 0.5700 | 0.6200 | 352.0000 | 30267.00 | 0.00 | 30267.00 | 531 | 46 | 6073 | 975 | 6.22871794871795 | 0.396998625282065 | 0.39682458732699 | false | false | false | |||||||||||||||||
| fb6f28e2-b7b5-4f15-aa15-08dbf12373fa | 2026-09-22 12:42 | 2026-09-22 12:42 | 2026-09-22 12:42 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 1.0100 | 1.0100 | 1.0500 | 350.7300 | 10100.00 | 0.00 | 10100.00 | 100 | 8 | 4659 | 975 | 4.77846153846154 | 0.422619753955181 | 0.422619753955181 | true | false | false | |||||||||||||||||
| 30e5e78a-f4c1-4c5c-a4de-65c45386be4a | 2026-09-22 12:25 | 2026-09-22 12:25 | 2026-09-22 12:25 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 0.5500 | 0.5200 | 0.5500 | 352.7850 | 37895.00 | 37895.00 | 0.00 | 689 | 43 | 2946 | 975 | 3.02153846153846 | 0.406228787537809 | 0.404691496242184 | false | false | false | |||||||||||||||||
| 6bfaa2c3-e645-4095-8f10-09d89f7e7a0c | 2026-09-22 12:14 | 2026-09-22 12:14 | 2026-09-22 12:14 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 0.5000 | 0.4700 | 0.5000 | 353.2484 | 20150.00 | 20150.00 | 0.00 | 403 | 33 | 1777 | 975 | 1.8225641025641 | 0.407983073224791 | 0.407983073224791 | false | false | false | |||||||||||||||||
| a31c6f4b-9b3d-47c0-b0c7-c39f862b4889 | 2026-09-21 15:39 | 2026-09-21 15:39 | 2026-09-21 15:39 | GOOGL | GOOGL260923P00345000 | put | 345.0000 | 2026-09-23 | 0.4900 | 0.4700 | 0.4900 | 356.4650 | 21903.00 | 21903.00 | 0.00 | 447 | 32 | 1545 | 209 | 7.39234449760766 | 0.360470343759412 | 0.360470343759412 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:19:13.860823Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:54:01.895756Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:54:01.895756Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:22:47.791063Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:48:50.097062Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:27:20.551854Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:20:35.100506Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:43:03.886437Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |