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_alerts523,327 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 | expiry |
|---|
| 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 |
|---|
| a662d704-fb68-456b-8c32-ab52a67ea992 | 2026-09-21 10:07 | 2026-09-21 10:07 | 2026-09-21 10:07 | GOOGL | GOOGL261120C00365000 | call | 365.0000 | 2026-11-20 | 16.6000 | 16.1000 | 16.6500 | 354.3800 | 13280.00 | 9960.00 | 3320.00 | 8 | 8 | 124 | 2326 | 0.0533104041272571 | 0.3525817856383 | 0.3525817856383 | true | false | false | true | 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-21T14:08:15.762043Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 50ab633d-0cb9-4946-8aea-41ed99785a25 | 2026-09-22 12:58 | 2026-09-22 12:58 | 2026-09-22 12:58 | GOOGL | GOOGL261120C00365000 | call | 365.0000 | 2026-11-20 | 15.3700 | 15.2500 | 15.5000 | 350.7404 | 15370.00 | 9222.00 | 6148.00 | 10 | 5 | 394 | 2307 | 0.170784568703945 | 0.36322057534126 | 0.36322057534126 | false | false | false | true | ||||||||||||||||
| 8f062bea-e7f0-430a-8705-0a6190297a76 | 2026-09-23 12:47 | 2026-09-23 12:47 | 2026-09-23 12:47 | GOOGL | GOOGL261120C00365000 | call | 365.0000 | 2026-11-20 | 10.6000 | 10.4500 | 10.7000 | 338.8350 | 66788.00 | 64674.00 | 2114.00 | 63 | 9 | 248 | 2582 | 0.0960495739736638 | 0.36519550747411 | 0.36519550747411 | false | false | false | true | ||||||||||||||||
| b2d5b32a-770a-474c-b03e-75fd8bcbbae9 | 2026-09-24 10:03 | 2026-09-24 10:03 | 2026-09-24 10:03 | GOOGL | GOOGL261120C00365000 | call | 365.0000 | 2026-11-20 | 10.3000 | 10.2500 | 10.4500 | 338.5500 | 17510.00 | 4120.00 | 13390.00 | 17 | 15 | 43 | 2619 | 0.0164184803360061 | 0.364093414507079 | 0.364093414507079 | false | false | false | true | ||||||||||||||||
| 3a7a9a68-6a5e-4f4f-acc1-b50b949ba29b | 2026-09-24 12:44 | 2026-09-24 12:44 | 2026-09-24 12:44 | GOOGL | GOOGL261120C00365000 | call | 365.0000 | 2026-11-20 | 11.1500 | 11.1500 | 11.5000 | 341.7300 | 46835.00 | 0.00 | 46835.00 | 42 | 8 | 307 | 2619 | 0.117220313096602 | 0.358643959459675 | 0.358643959459675 | false | false | false | true | ||||||||||||||||
| 942a94fe-d115-4c66-bd9b-da422d5f333f | 2026-09-24 15:58 | 2026-09-24 15:58 | 2026-09-24 15:58 | GOOGL | GOOGL261120C00365000 | call | 365.0000 | 2026-11-20 | 11.5500 | 11.5000 | 11.7000 | 342.0000 | 10395.00 | 0.00 | 10395.00 | 9 | 5 | 483 | 2619 | 0.184421534936999 | 0.360439977048011 | 0.360439977048011 | false | false | false | true | ||||||||||||||||
| 27a611b5-12ac-4bc3-b0e5-8ccbd06f1d03 | 2026-09-25 11:35 | 2026-09-25 11:35 | 2026-09-25 11:35 | GOOGL | GOOGL261120C00365000 | call | 365.0000 | 2026-11-20 | 11.7000 | 11.5500 | 11.8500 | 344.5700 | 25740.00 | 7020.00 | 18720.00 | 22 | 8 | 65 | 2818 | 0.0230660042583392 | 0.351831094883149 | 0.351831094883149 | false | false | false | true | ||||||||||||||||
| dca71c22-66bf-43c5-83f7-d5d55f5e2bf1 | 2026-09-25 14:01 | 2026-09-25 14:01 | 2026-09-25 14:01 | GOOGL | GOOGL261120C00365000 | call | 365.0000 | 2026-11-20 | 11.6000 | 11.5000 | 11.7000 | 344.0000 | 11600.00 | 6960.00 | 2320.00 | 10 | 5 | 84 | 2818 | 0.0298083747338538 | 0.352177430074854 | 0.352177430074854 | false | false | false | true | ||||||||||||||||
| c3d038e3-23b5-41c2-a38d-9a076d3cedb3 | 2026-09-25 14:12 | 2026-09-25 14:12 | 2026-09-25 14:12 | GOOGL | GOOGL261120C00365000 | call | 365.0000 | 2026-11-20 | 11.6500 | 11.4500 | 11.6500 | 344.0650 | 18640.00 | 18640.00 | 0.00 | 16 | 7 | 100 | 2818 | 0.035486160397445 | 0.354481860838923 | 0.354592624398493 | true | false | false | true |
| 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:59:26.444099Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-23T16:50:31.727712Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-24T14:04:09.722188Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T16:45:03.999525Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2018122560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:37:39.831939Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2018122560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:10:19.042064Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2018122560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:18:37.657539Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |