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 |
|---|
| 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 |
|---|
| 4fac314c-e6d2-4a93-8d1a-f6a59390ab77 | 2026-09-21 13:42 | 2026-09-21 13:42 | 2026-09-21 13:42 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 1.4800 | 1.4300 | 1.5000 | 741.0300 | 67039.00 | 23084.00 | 43955.00 | 452 | 19 | 6598 | 230 | 28.6869565217391 | 0.816687382653265 | 0.812616065021905 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:43:51.748700Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| af66d2c7-7c5c-4788-a9b8-d57c6a7ae357 | 2026-09-21 13:59 | 2026-09-21 13:59 | 2026-09-21 13:59 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 2.2900 | 2.2400 | 2.3000 | 744.0300 | 17847.00 | 10810.00 | 0.00 | 78 | 5 | 12623 | 230 | 54.8826086956522 | 0.831570138932717 | 0.838686067973348 | false | false | false | |||||||||||||||||
| 212788e6-3bf7-4cb8-b499-367dddd44434 | 2026-09-21 14:03 | 2026-09-21 14:03 | 2026-09-21 14:03 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 1.9500 | 1.9100 | 2.0000 | 743.0000 | 19738.00 | 17637.00 | 2101.00 | 101 | 10 | 14361 | 230 | 62.4391304347826 | 0.778561720177072 | 0.777073357731261 | false | false | false | |||||||||||||||||
| 0a0a571f-c830-4fde-b0fd-abe89304a327 | 2026-09-21 14:26 | 2026-09-21 14:26 | 2026-09-21 14:26 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 2.9400 | 2.8700 | 2.9500 | 747.2750 | 12043.00 | 11467.00 | 576.00 | 41 | 5 | 20817 | 230 | 90.5086956521739 | 0.75563062177822 | 0.767679674879521 | false | false | false | |||||||||||||||||
| b5a4bdca-bf8f-434c-98b6-c64f24eff0c1 | 2026-09-21 14:26 | 2026-09-21 14:26 | 2026-09-21 14:26 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 2.6100 | 2.5300 | 2.6900 | 746.8700 | 27928.00 | 1828.00 | 26100.00 | 107 | 6 | 21184 | 230 | 92.104347826087 | 0.731712740611489 | 0.73204856432981 | true | false | false | |||||||||||||||||
| f7b8a6b3-9e7a-436f-a3fa-42576a087abd | 2026-09-21 14:27 | 2026-09-21 14:26 | 2026-09-21 14:26 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 2.9300 | 2.8900 | 2.9500 | 747.5550 | 10848.00 | 10268.00 | 580.00 | 37 | 6 | 21655 | 230 | 94.1521739130435 | 0.743896484281944 | 0.733124744034266 | false | false | false | |||||||||||||||||
| 85947e27-5706-4ba4-bcbf-01300cec12e4 | 2026-09-21 14:27 | 2026-09-21 14:27 | 2026-09-21 14:27 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 3.4900 | 3.3500 | 3.5000 | 748.2642 | 15355.00 | 13991.00 | 1364.00 | 44 | 8 | 22214 | 230 | 96.5826086956522 | 0.757024563849975 | 0.762098448130882 | false | false | false | |||||||||||||||||
| bfe21167-c36a-48fe-beac-499edb5a2115 | 2026-09-21 14:27 | 2026-09-21 14:27 | 2026-09-21 14:27 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 3.4700 | 3.4000 | 3.5000 | 748.2750 | 10412.00 | 10412.00 | 0.00 | 30 | 10 | 22276 | 230 | 96.8521739130435 | 0.770898327993183 | 0.775972880571998 | false | false | false | |||||||||||||||||
| b91dc7d3-7dfb-4538-bfb3-eb232fe2626b | 2026-09-21 14:27 | 2026-09-21 14:27 | 2026-09-21 14:27 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 3.4900 | 3.4000 | 3.5500 | 748.2750 | 18504.00 | 18154.00 | 350.00 | 53 | 12 | 22331 | 230 | 97.0913043478261 | 0.775972880571998 | 0.781047093814928 | true | false | false | |||||||||||||||||
| bc84a783-aa5a-4b1c-879b-d0e600184948 | 2026-09-21 14:32 | 2026-09-21 14:32 | 2026-09-21 14:32 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 2.7700 | 2.7200 | 2.8500 | 747.0000 | 12172.00 | 558.00 | 11614.00 | 44 | 6 | 25534 | 230 | 111.017391304348 | 0.763518790045865 | 0.776559997604371 | false | false | false | |||||||||||||||||
| 13a705f3-fa56-4cad-93e7-f5ab95ffad2d | 2026-09-21 14:39 | 2026-09-21 14:39 | 2026-09-21 14:39 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 3.4700 | 3.4000 | 3.5000 | 748.6900 | 16650.00 | 16650.00 | 0.00 | 48 | 5 | 28095 | 230 | 122.152173913043 | 0.795514888009811 | 0.776323868788535 | true | false | false | |||||||||||||||||
| a980a349-3541-4c74-8a2c-c7539f034adf | 2026-09-21 14:45 | 2026-09-21 14:45 | 2026-09-21 14:45 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 2.2900 | 2.2700 | 2.4100 | 746.4400 | 11687.00 | 233.00 | 11454.00 | 51 | 7 | 29402 | 230 | 127.834782608696 | 0.778470639166742 | 0.787099652134387 | false | false | false | |||||||||||||||||
| f0c67cc1-6dc8-4de8-9116-73f79d5dc1f3 | 2026-09-21 14:48 | 2026-09-21 14:48 | 2026-09-21 14:48 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 2.3800 | 2.3100 | 2.3900 | 746.0000 | 15016.00 | 12172.00 | 2844.00 | 63 | 8 | 30544 | 230 | 132.8 | 0.766796482079924 | 0.766796482079924 | true | false | false | |||||||||||||||||
| 9825157e-5faf-4c88-bc91-97ec42587ce4 | 2026-09-21 14:48 | 2026-09-21 14:48 | 2026-09-21 14:48 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 2.3900 | 2.3000 | 2.3900 | 746.0000 | 15291.00 | 15057.00 | 234.00 | 64 | 7 | 30476 | 230 | 132.504347826087 | 0.758153780947303 | 0.772557802446159 | false | false | false | |||||||||||||||||
| f9444841-e095-4e0a-bbd0-44d314148485 | 2026-09-21 14:56 | 2026-09-21 14:56 | 2026-09-21 14:56 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 1.2600 | 1.2200 | 1.2700 | 744.5000 | 10108.00 | 9856.00 | 252.00 | 80 | 20 | 32888 | 230 | 142.991304347826 | 0.756113229949519 | 0.759544372861548 | true | false | false | |||||||||||||||||
| 3f06507d-e8c6-400d-b269-619f2fa00115 | 2026-09-21 14:56 | 2026-09-21 14:56 | 2026-09-21 14:56 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 1.2500 | 1.1900 | 1.2600 | 744.4300 | 50374.00 | 50249.00 | 0.00 | 402 | 48 | 33314 | 230 | 144.84347826087 | 0.756315076430107 | 0.764394700621731 | false | false | false | |||||||||||||||||
| 307227f7-8f90-4cbf-bde8-e12e874cc4fb | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 1.1200 | 1.1000 | 1.1600 | 746.0000 | 14942.00 | 10355.00 | 3916.00 | 133 | 35 | 45078 | 230 | 195.991304347826 | 0.771302530180646 | 0.753270390491888 | false | false | false | |||||||||||||||||
| c027a6e8-9745-411a-bbf4-280409e43dc8 | 2026-09-21 15:31 | 2026-09-21 15:31 | 2026-09-21 15:31 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 1.7200 | 1.6600 | 1.7500 | 747.0000 | 17343.00 | 3321.00 | 0.00 | 101 | 8 | 45734 | 230 | 198.84347826087 | 0.827920737771913 | 0.827920737771913 | false | false | false | |||||||||||||||||
| 2ab7d992-ba2b-4ab3-9fe7-ff27bc27d355 | 2026-09-21 15:31 | 2026-09-21 15:31 | 2026-09-21 15:31 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 2.0000 | 1.9100 | 2.0000 | 747.0000 | 11196.00 | 11196.00 | 0.00 | 56 | 7 | 46330 | 230 | 201.434782608696 | 0.852008304919579 | 0.861118728953354 | true | false | false | |||||||||||||||||
| 85d23058-f47a-4bf4-b684-c00e9e7e804b | 2026-09-21 15:34 | 2026-09-21 15:34 | 2026-09-21 15:34 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 3.4300 | 3.1000 | 3.5000 | 750.3050 | 17490.00 | 17490.00 | 0.00 | 51 | 10 | 48994 | 230 | 213.017391304348 | 0.867305658511761 | 0.842805846139523 | true | false | false | |||||||||||||||||
| c2a782f7-1896-4470-99a1-fc5134eb7c0c | 2026-09-21 15:35 | 2026-09-21 15:35 | 2026-09-21 15:35 | META | META260921C00747500 | call | 747.5000 | 2026-09-21 | 4.9800 | 4.9500 | 5.2500 | 752.3300 | 26384.00 | 12500.00 | 13884.00 | 53 | 11 | 49274 | 230 | 214.234782608696 | 0.657929839091775 | 0.792305763353257 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:00:14.697100Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-21T18:05:09.858972Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-21T18:32:54.184324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:42:48.011261Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:46:35.766190Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-21T18:50:33.734980Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-21T18:50:33.734980Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:56:46.399450Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:56:46.399450Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:36:57.124687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:36:57.124687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |