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_alerts566,287 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 |
|---|
| a1cd6463-994e-42ca-a213-d078b54533e3 | 2026-09-29 15:38 | 2026-09-29 15:38 | 2026-09-29 15:38 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 17.1000 | 17.1000 | 17.2500 | 340.0000 | 10260.00 | 0.00 | 10260.00 | 6 | 6 | 62 | 3304 | 0.0187651331719128 | 0.345359950699304 | 0.345359950699304 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2000518560000.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T19:43:26.980226Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| b879c792-2ccd-4ba1-8ab1-700e401cf905 | 2026-09-29 15:37 | 2026-09-29 15:37 | 2026-09-29 15:37 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 17.1000 | 17.1000 | 17.2500 | 340.0000 | 10260.00 | 0.00 | 10260.00 | 6 | 6 | 56 | 3304 | 0.0169491525423729 | 0.345149271795055 | 0.345149271795055 | false | false | false | true | ||||||||||||||||
| c2de795e-31f7-48c8-99d7-64c7170b816a | 2026-09-29 15:37 | 2026-09-29 15:37 | 2026-09-29 15:37 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 17.1000 | 17.1000 | 17.2500 | 340.0000 | 10260.00 | 0.00 | 10260.00 | 6 | 6 | 50 | 3304 | 0.0151331719128329 | 0.345119900471252 | 0.345119900471252 | false | false | false | true | ||||||||||||||||
| 4a50779a-69f1-462a-8c56-a74732d994de | 2026-09-29 15:37 | 2026-09-29 15:36 | 2026-09-29 15:36 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 17.1000 | 17.1000 | 17.2500 | 340.0000 | 10260.00 | 0.00 | 10260.00 | 6 | 6 | 44 | 3304 | 0.013317191283293 | 0.345075839625102 | 0.345075839625102 | false | false | false | true | ||||||||||||||||
| 4266c479-b856-4340-89eb-6e58b03ae117 | 2026-09-29 15:37 | 2026-09-29 15:36 | 2026-09-29 15:36 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 17.1000 | 16.4500 | 17.2500 | 340.0000 | 10260.00 | 1710.00 | 8550.00 | 6 | 6 | 38 | 3304 | 0.011501210653753 | 0.345075839625102 | 0.345075839625102 | false | false | false | true | ||||||||||||||||
| 982c2e4c-7f63-4ec2-bf56-dfa777133b53 | 2026-09-28 15:42 | 2026-09-28 15:42 | 2026-09-28 15:42 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 17.0000 | 17.0000 | 17.0500 | 342.1600 | 10200.00 | 0.00 | 10200.00 | 6 | 6 | 160 | 3356 | 0.0476758045292014 | 0.348022931955808 | 0.348022931955808 | false | false | false | true | ||||||||||||||||
| ee1eb7b3-22dc-4339-8daf-fca0e4082241 | 2026-09-28 15:42 | 2026-09-28 15:42 | 2026-09-28 15:42 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 17.0000 | 17.0000 | 17.1000 | 342.1300 | 10200.00 | 0.00 | 8500.00 | 6 | 6 | 142 | 3356 | 0.0423122765196663 | 0.347914551050782 | 0.347914551050782 | false | false | false | true | ||||||||||||||||
| c88fe7ea-8c0a-44b3-9c07-e6faae1b464a | 2026-09-28 15:42 | 2026-09-28 15:42 | 2026-09-28 15:42 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 17.0000 | 16.6500 | 17.1000 | 342.0500 | 10200.00 | 1700.00 | 8500.00 | 6 | 6 | 136 | 3356 | 0.0405244338498212 | 0.347625398989804 | 0.347625398989804 | false | false | false | true | ||||||||||||||||
| 969cba24-10da-4fb3-a4c6-2a51b6915994 | 2026-09-28 13:35 | 2026-09-28 13:35 | 2026-09-28 13:35 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 16.8500 | 16.8500 | 17.0000 | 342.0000 | 10110.00 | 0.00 | 10110.00 | 6 | 6 | 11 | 3356 | 0.0032777115613826 | 0.346249017187131 | 0.346303128369037 | false | false | false | true | ||||||||||||||||
| 32eb9479-1991-48d1-abd7-2f0867f00970 | 2026-09-25 15:48 | 2026-09-25 15:48 | 2026-09-25 15:48 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 16.7000 | 16.4500 | 16.7500 | 343.0000 | 10020.00 | 1670.00 | 8350.00 | 6 | 6 | 273 | 3255 | 0.0838709677419355 | 0.348319871751166 | 0.348319871751166 | false | false | false | true | ||||||||||||||||
| a9369ce3-1418-4141-95e6-a72decd6e6a5 | 2026-09-25 15:48 | 2026-09-25 15:48 | 2026-09-25 15:48 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 16.7000 | 16.4500 | 16.7500 | 343.0000 | 10020.00 | 1670.00 | 8350.00 | 6 | 6 | 267 | 3255 | 0.0820276497695853 | 0.348249531739818 | 0.348249531739818 | false | false | false | true | ||||||||||||||||
| d8c089bf-4cbd-4644-8f00-c1bfc98645c0 | 2026-09-25 15:48 | 2026-09-25 15:48 | 2026-09-25 15:48 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 16.7000 | 16.0500 | 16.7500 | 343.0000 | 10020.00 | 3340.00 | 6680.00 | 6 | 6 | 240 | 3255 | 0.0737327188940092 | 0.348196769036741 | 0.348196769036741 | false | false | false | true | ||||||||||||||||
| c54c0df2-0799-492a-a857-02cf37faf5d1 | 2026-09-25 15:36 | 2026-09-25 15:36 | 2026-09-25 15:36 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 16.7500 | 16.6000 | 16.8000 | 343.0000 | 10050.00 | 1675.00 | 8375.00 | 6 | 6 | 226 | 3255 | 0.069431643625192 | 0.347423938231268 | 0.347423938231268 | false | false | false | true | ||||||||||||||||
| a5c32e49-dd82-48a4-aa77-beb4753c2c76 | 2026-09-25 15:36 | 2026-09-25 15:36 | 2026-09-25 15:36 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 16.7500 | 16.6000 | 16.7500 | 343.0000 | 10050.00 | 10050.00 | 0.00 | 6 | 6 | 232 | 3255 | 0.0712749615975422 | 0.347353672342068 | 0.347353672342068 | true | false | false | true | ||||||||||||||||
| 87914416-f950-4077-879d-23460a18a895 | 2026-09-25 10:39 | 2026-09-25 10:39 | 2026-09-25 10:39 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 16.9500 | 16.8000 | 16.9500 | 342.6995 | 271200.00 | 271200.00 | 0.00 | 160 | 8 | 164 | 3255 | 0.050384024577573 | 0.346915473696622 | 0.346915473696622 | false | false | false | true | ||||||||||||||||
| d35ea086-cc3b-40ac-97fb-ed45272ac0b0 | 2026-09-22 12:33 | 2026-09-22 12:33 | 2026-09-22 12:33 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 15.5000 | 15.1500 | 15.5500 | 350.8200 | 153455.00 | 153455.00 | 0.00 | 99 | 11 | 116 | 3191 | 0.0363522406769038 | 0.353602854836979 | 0.353602854836979 | false | false | false | true | ||||||||||||||||
| 94a140f9-b022-4cc1-bf24-bd68cec2c9a0 | 2026-09-21 15:51 | 2026-09-21 15:51 | 2026-09-21 15:51 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 14.4000 | 14.3000 | 14.5000 | 355.8600 | 11520.00 | 5760.00 | 5760.00 | 8 | 6 | 251 | 3114 | 0.0806037251123956 | 0.354572821632634 | 0.354666172089734 | false | false | false | true | ||||||||||||||||
| ea37da1c-3bd9-4c6b-b8cb-1b2fd52d5dde | 2026-09-21 15:49 | 2026-09-21 15:49 | 2026-09-21 15:49 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 14.3000 | 14.0000 | 14.3500 | 356.0000 | 14300.00 | 4290.00 | 10010.00 | 10 | 6 | 163 | 3114 | 0.0523442517662171 | 0.354653830928874 | 0.354607339749581 | false | false | false | true | ||||||||||||||||
| c7e0e387-a3b9-4c0b-9406-276ec896b356 | 2026-09-21 15:49 | 2026-09-21 15:49 | 2026-09-21 15:49 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 14.3000 | 14.0000 | 14.3000 | 356.0000 | 32890.00 | 32890.00 | 0.00 | 23 | 7 | 186 | 3114 | 0.0597302504816956 | 0.354607339749581 | 0.354684822288102 | false | false | false | true | ||||||||||||||||
| 2e5da096-feaa-4be1-8fb9-c38c58bb7f17 | 2026-09-16 14:22 | 2026-09-16 14:22 | 2026-09-16 14:22 | GOOGL | GOOGL270319P00315000 | put | 315.0000 | 2027-03-19 | 16.6000 | 16.6000 | 17.0000 | 346.6350 | 127825.00 | 1665.00 | 126160.00 | 77 | 6 | 107 | 2855 | 0.0374781085814361 | 0.349321628164859 | 0.349930859405513 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:43:26.980226Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:43:26.980226Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:43:26.980226Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:43:26.980226Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:41:35.586557Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 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-25T19:51:07.574812Z"} |
| 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-25T19:51:07.574812Z"} |
| 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-25T19:51:07.574812Z"} |
| 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-25T19:39:29.889694Z"} |
| 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-25T19:39:29.889694Z"} |
| 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-25T14:40:21.587562Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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:35:05.886735Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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:52:57.186278Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011961160000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:26:46.257544Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |