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 |
|---|
| 13900b58-80d2-41d3-9de4-7f392a9e97d2 | 2026-09-25 10:08 | 2026-09-25 10:08 | 2026-09-25 10:08 | BAC | BAC270115P00055000 | put | 55.0000 | 2027-01-15 | 2.6000 | 2.5000 | 2.6000 | 56.0000 | 23140.00 | 23140.00 | 0.00 | 89 | 30 | 189 | 71489 | 0.00264376337618375 | 0.278791153230506 | 0.278791153230506 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 396488832296.00 | 2026-10-14 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T14:09:41.700516Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 60a23f69-4f4a-4cea-9f2b-a3566e20eeb9 | 2026-09-25 09:45 | 2026-09-25 09:45 | 2026-09-25 09:45 | BAC | BAC270115P00055000 | put | 55.0000 | 2027-01-15 | 2.5200 | 2.4400 | 2.5300 | 56.2900 | 24948.00 | 23688.00 | 252.00 | 99 | 12 | 99 | 71489 | 0.00138482843514387 | 0.281422911525487 | 0.281422911525487 | false | false | false | true | ||||||||||||||||
| fd0b0456-630b-470a-9d16-cdd9cf314d3e | 2026-09-22 11:43 | 2026-09-22 11:43 | 2026-09-22 11:43 | BAC | BAC270115P00055000 | put | 55.0000 | 2027-01-15 | 2.4700 | 2.4000 | 2.4700 | 56.3650 | 36803.00 | 36803.00 | 0.00 | 149 | 30 | 7485 | 70884 | 0.105595056712375 | 0.276174882670792 | 0.276174882670792 | false | false | false | true | ||||||||||||||||
| eff46101-6061-46b4-ae9e-91fba3ded2aa | 2026-09-22 09:34 | 2026-09-22 09:34 | 2026-09-22 09:34 | BAC | BAC270115P00055000 | put | 55.0000 | 2027-01-15 | 1.8500 | 1.8300 | 1.8900 | 58.0650 | 961262.00 | 0.00 | 960890.00 | 5196 | 5 | 7000 | 70884 | 0.0987528920489814 | 0.273065614702442 | 0.273065614702442 | false | false | false | true | ||||||||||||||||
| 31b50832-2277-43d6-8730-79373df8c713 | 2026-09-22 09:34 | 2026-09-22 09:33 | 2026-09-22 09:33 | BAC | BAC270115P00055000 | put | 55.0000 | 2027-01-15 | 1.8600 | 1.8500 | 1.9400 | 58.0050 | 28086.00 | 0.00 | 18042.00 | 151 | 6 | 1800 | 70884 | 0.0253936008125952 | 0.27146757741646 | 0.27146757741646 | false | false | false | true | ||||||||||||||||
| c080a83b-4449-4927-bcb6-80474651d0fc | 2026-09-22 09:33 | 2026-09-22 09:33 | 2026-09-22 09:33 | BAC | BAC270115P00055000 | put | 55.0000 | 2027-01-15 | 1.8700 | 1.8600 | 1.9400 | 57.9800 | 98410.00 | 4862.00 | 93548.00 | 527 | 47 | 1610 | 70884 | 0.0227131651712657 | 0.271008053053773 | 0.270799840952679 | false | false | false | true | ||||||||||||||||
| 2e325b74-0a80-4fa8-a779-4ffe2e0d4eb6 | 2026-09-22 09:33 | 2026-09-22 09:33 | 2026-09-22 09:33 | BAC | BAC270115P00055000 | put | 55.0000 | 2027-01-15 | 1.8600 | 1.8600 | 1.9400 | 57.9000 | 93000.00 | 0.00 | 93000.00 | 500 | 31 | 1083 | 70884 | 0.0152784831555781 | 0.26865553026336 | 0.26865553026336 | false | false | false | true | ||||||||||||||||
| 3592684e-5f82-4905-8cb4-b43e13b140ac | 2026-09-22 09:33 | 2026-09-22 09:33 | 2026-09-22 09:33 | BAC | BAC270115P00055000 | put | 55.0000 | 2027-01-15 | 1.8800 | 1.8600 | 1.8800 | 57.9600 | 51136.00 | 51136.00 | 0.00 | 272 | 5 | 581 | 70884 | 0.00819649004006546 | 0.272286647547825 | 0.272018665765436 | false | false | false | true | ||||||||||||||||
| 2fa2a2f7-89d4-4df5-8498-8e5f00e342e7 | 2026-09-14 13:38 | 2026-09-14 13:38 | 2026-09-14 13:38 | BAC | BAC270115P00055000 | put | 55.0000 | 2027-01-15 | 1.5200 | 1.5100 | 1.5800 | 60.1353 | 62168.00 | 60800.00 | 1368.00 | 409 | 9 | 535 | 20243 | 0.0264288889986662 | 0.283986929678073 | 0.283986929678073 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 396488832296.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:45:37.818098Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 392992458113.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:49:01.734970Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 392992458113.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:35:07.797098Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 392992458113.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:35:07.797098Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 392992458113.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:35:07.797098Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 392992458113.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:35:07.797098Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 392992458113.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:33:30.058722Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 415858745267.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |