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_alerts474,253 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 |
|---|
| 9cc4e7e0-d2cc-46f2-aa8e-3430b6e06a45 | 2026-09-25 15:24 | 2026-09-25 15:24 | 2026-09-25 15:24 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 8.3000 | 8.2000 | 8.6500 | 751.1800 | 38180.00 | 36520.00 | 1660.00 | 46 | 21 | 2271 | 699 | 3.24892703862661 | 0.415763323187905 | 0.415763323187905 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1657506895075.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:30:11.536652Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 2690ab61-af8c-4e53-bf22-0b4ca905e92f | 2026-09-25 10:33 | 2026-09-25 10:32 | 2026-09-25 10:32 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 8.9000 | 8.9000 | 9.1000 | 751.2801 | 31150.00 | 0.00 | 31150.00 | 35 | 11 | 817 | 699 | 1.16881258941345 | 0.429324990552654 | 0.431205217554471 | false | false | false | true | ||||||||||||||||
| f9a4dff5-ca59-4b25-a17e-d7a484acebee | 2026-09-25 09:56 | 2026-09-25 09:56 | 2026-09-25 09:56 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 11.0500 | 11.0500 | 11.2500 | 756.6299 | 72936.00 | 0.00 | 72936.00 | 66 | 16 | 521 | 699 | 0.745350500715308 | 0.439919798614273 | 0.440174182248424 | false | false | false | true | ||||||||||||||||
| e46c54db-f20d-4774-a966-20da0f1aaf7f | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 16.9700 | 16.7000 | 17.5000 | 766.6300 | 20360.00 | 5095.00 | 15265.00 | 12 | 12 | 61 | 699 | 0.0872675250357654 | 0.485408094632494 | 0.484110203370441 | true | false | false | true | ||||||||||||||||
| 878b1d9c-693b-455e-843d-c6093e5111bc | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 16.9500 | 16.9500 | 17.6000 | 766.6750 | 27120.00 | 0.00 | 27120.00 | 16 | 9 | 49 | 699 | 0.0701001430615164 | 0.486263854425689 | 0.483625020732128 | true | false | false | true | ||||||||||||||||
| 29f3bfc8-120e-4ad6-bef6-8256025e8591 | 2026-09-24 14:05 | 2026-09-24 14:05 | 2026-09-24 14:05 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 20.5000 | 20.0500 | 20.5000 | 771.5100 | 84050.00 | 84050.00 | 0.00 | 41 | 8 | 733 | 617 | 1.18800648298217 | 0.479345113603791 | 0.479345113603791 | false | false | false | true | ||||||||||||||||
| 1a1d6678-e52b-4136-8ce1-7c2ec279f415 | 2026-09-24 14:05 | 2026-09-24 14:05 | 2026-09-24 14:05 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 20.5000 | 20.0500 | 20.5000 | 771.3501 | 55350.00 | 55350.00 | 0.00 | 27 | 10 | 692 | 617 | 1.12155591572123 | 0.481076176642247 | 0.481076176642247 | false | false | false | true | ||||||||||||||||
| 37945481-1c23-4357-8065-6bdf97cd8a15 | 2026-09-24 13:23 | 2026-09-24 13:22 | 2026-09-24 13:22 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 20.5600 | 20.4500 | 20.9000 | 770.7700 | 20560.00 | 6180.00 | 10270.00 | 10 | 5 | 601 | 617 | 0.974068071312804 | 0.483399814391804 | 0.488428572578655 | false | false | false | true | ||||||||||||||||
| 48f5132b-4efe-411b-b241-93fb53414b84 | 2026-09-24 11:32 | 2026-09-24 11:32 | 2026-09-24 11:32 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 18.7500 | 18.0000 | 18.8000 | 765.8600 | 41245.00 | 39370.00 | 1875.00 | 22 | 15 | 386 | 617 | 0.625607779578606 | 0.499886693468877 | 0.499886693468877 | true | false | false | true | ||||||||||||||||
| 300c0d78-2628-4120-8cd4-996386b660bb | 2026-09-24 11:32 | 2026-09-24 11:32 | 2026-09-24 11:32 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 18.4900 | 17.8000 | 18.9500 | 765.6350 | 16645.00 | 14780.00 | 1865.00 | 9 | 5 | 364 | 617 | 0.589951377633712 | 0.501083784647044 | 0.499938708491174 | true | false | false | true | ||||||||||||||||
| c3b7850c-61a5-434f-bfc2-df0cdb9ca784 | 2026-09-24 11:01 | 2026-09-24 11:01 | 2026-09-24 11:01 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 20.8500 | 20.3000 | 20.8500 | 768.9100 | 41700.00 | 41700.00 | 0.00 | 20 | 7 | 306 | 617 | 0.495948136142626 | 0.514835580354627 | 0.514835580354627 | false | false | false | true | ||||||||||||||||
| ef23a9fb-7322-4ace-84cb-d6d03dcc83c7 | 2026-09-24 10:59 | 2026-09-24 10:59 | 2026-09-24 10:59 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 21.3300 | 20.9500 | 21.5000 | 770.3400 | 21334.00 | 21334.00 | 0.00 | 10 | 5 | 280 | 617 | 0.453808752025932 | 0.51019147301009 | 0.51019147301009 | false | false | false | true | ||||||||||||||||
| a91fc064-c44d-4a16-9859-8893505965b6 | 2026-09-24 10:42 | 2026-09-24 10:42 | 2026-09-24 10:42 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 18.9500 | 18.8500 | 19.5500 | 765.4400 | 18950.00 | 0.00 | 18950.00 | 10 | 7 | 199 | 617 | 0.322528363047002 | 0.509034761539145 | 0.509034761539145 | false | false | false | true | ||||||||||||||||
| b9f4a128-bd18-426a-a341-21db649c6a41 | 2026-09-24 10:05 | 2026-09-24 10:05 | 2026-09-24 10:05 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 16.7400 | 16.5500 | 17.4500 | 760.7900 | 11720.00 | 3360.00 | 8360.00 | 7 | 6 | 115 | 617 | 0.186385737439222 | 0.502891198777975 | 0.503751795361084 | true | false | false | true | ||||||||||||||||
| 812373a8-fe2e-4fc6-84a8-d499ccdd92d6 | 2026-09-24 09:38 | 2026-09-24 09:38 | 2026-09-24 09:38 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 17.9000 | 17.6000 | 17.9000 | 762.1320 | 44750.00 | 1790.00 | 0.00 | 25 | 6 | 73 | 617 | 0.118314424635332 | 0.517926885286006 | 0.517926885286006 | false | false | false | true | ||||||||||||||||
| 15e7ba59-bbb7-4dbd-916c-3899812b1253 | 2026-09-22 15:09 | 2026-09-22 15:08 | 2026-09-22 15:08 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 10.3500 | 10.3000 | 10.7500 | 737.7106 | 25875.00 | 19665.00 | 6210.00 | 25 | 6 | 636 | 251 | 2.53386454183267 | 0.488213479743607 | 0.488213479743607 | false | false | false | true | ||||||||||||||||
| a12517b5-65f3-422b-9967-5f0433b43fcd | 2026-09-22 10:01 | 2026-09-22 10:00 | 2026-09-22 10:00 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 12.7200 | 12.6000 | 13.2000 | 744.0000 | 12715.00 | 5085.00 | 7630.00 | 10 | 8 | 277 | 251 | 1.10358565737052 | 0.490263325545233 | 0.49115405579983 | true | false | false | true | ||||||||||||||||
| b1fbf6c7-737e-4d2a-94a6-cc02466bf1c0 | 2026-09-22 09:32 | 2026-09-22 09:32 | 2026-09-22 09:32 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 12.2500 | 12.1000 | 13.1500 | 741.7700 | 129865.00 | 2455.00 | 127410.00 | 106 | 6 | 106 | 251 | 0.422310756972112 | 0.50594066164643 | 0.50377035886846 | true | false | false | true | ||||||||||||||||
| 893260bb-3d49-4d36-b737-1eb9d502ae44 | 2026-09-21 15:01 | 2026-09-21 15:01 | 2026-09-21 15:01 | META | META261002C00775000 | call | 775.0000 | 2026-10-02 | 15.2500 | 15.2500 | 15.4000 | 744.0000 | 97600.00 | 0.00 | 97600.00 | 64 | 5 | 349 | 105 | 3.32380952380952 | 0.524041285722152 | 0.524041285722152 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:33:57.900979Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:58:47.547545Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:30:25.838480Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:30:25.838480Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:09:26.312126Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:09:26.312126Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:26:09.725902Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:05:25.664270Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:01:26.561696Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:44:10.025245Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:06:35.686187Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:38:54.076483Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:01:27.900775Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| 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 |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:06:05.917319Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |