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 |
|---|
| 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 |
|---|
| b99b4a73-8dc3-423e-a1ce-c310dbdc3071 | 2026-09-21 14:25 | 2026-09-21 14:25 | 2026-09-21 14:25 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 12.5100 | 12.4000 | 12.6500 | 745.8795 | 36281.00 | 7531.00 | 28750.00 | 29 | 7 | 1393 | 2 | 696.5 | 0.599472824513579 | 0.599926929030087 | true | 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-21T18:28:37.842583Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 362a44ea-e2a5-4b3b-b49c-9c743ea0121a | 2026-09-21 15:00 | 2026-09-21 15:00 | 2026-09-21 15:00 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 12.1800 | 12.1000 | 12.2000 | 745.9000 | 12178.00 | 12178.00 | 0.00 | 10 | 5 | 2349 | 2 | 1174.5 | 0.584030239737239 | 0.584030239737239 | false | false | false | |||||||||||||||||
| cae45873-9a07-40e8-89fc-8a5fa1a83aa2 | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 6.2700 | 5.5500 | 6.3000 | 735.1000 | 14425.00 | 12570.00 | 1855.00 | 23 | 14 | 30 | 621 | 0.0483091787439614 | 0.73590298003767 | 0.737710492271189 | true | false | false | |||||||||||||||||
| 0fd7a271-2211-4353-9638-5c3d167331af | 2026-09-22 09:36 | 2026-09-22 09:36 | 2026-09-22 09:36 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 14.1800 | 13.8500 | 14.3500 | 752.0000 | 19855.00 | 18440.00 | 1415.00 | 14 | 6 | 1029 | 621 | 1.65700483091787 | 0.745274858392497 | 0.748508585933147 | false | false | false | |||||||||||||||||
| 69ee2d16-9582-4bf1-9ac4-d373ee38557e | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 15.8800 | 15.3000 | 16.0500 | 755.3000 | 11115.00 | 11115.00 | 0.00 | 7 | 5 | 1245 | 621 | 2.0048309178744 | 0.743324097376887 | 0.745079569227014 | false | false | false | |||||||||||||||||
| 12c46678-5fff-45f2-b39e-00b233c4c3cf | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 15.6700 | 15.2000 | 16.3500 | 754.3500 | 48570.00 | 25200.00 | 23370.00 | 31 | 8 | 1372 | 621 | 2.20933977455717 | 0.742615716415212 | 0.740286135875292 | false | false | false | |||||||||||||||||
| 1cd8e422-cc43-4f50-8e38-32350fb262b6 | 2026-09-22 10:00 | 2026-09-22 10:00 | 2026-09-22 10:00 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 8.7600 | 8.7000 | 8.9000 | 744.0000 | 25414.00 | 6230.00 | 19184.00 | 29 | 8 | 2682 | 621 | 4.31884057971014 | 0.648934648269569 | 0.661014661097487 | false | false | false | |||||||||||||||||
| e33ad9b0-cf7a-41e5-87af-169ff3fc0a7f | 2026-09-22 10:10 | 2026-09-22 10:10 | 2026-09-22 10:10 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 10.9300 | 10.8000 | 11.2500 | 749.3600 | 33898.00 | 1123.00 | 32775.00 | 31 | 6 | 3743 | 621 | 6.02737520128824 | 0.626707803791266 | 0.636682573832948 | false | false | false | |||||||||||||||||
| 439618f3-b2bb-41b4-8d7a-7564bcd4596c | 2026-09-22 10:17 | 2026-09-22 10:16 | 2026-09-22 10:16 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 12.0000 | 11.9500 | 12.3500 | 751.1372 | 12003.00 | 0.00 | 12003.00 | 10 | 6 | 4479 | 621 | 7.21256038647343 | 0.643961462968928 | 0.648280757554666 | false | false | false | |||||||||||||||||
| f01599bd-10e1-4ce9-bba3-e27b5047cda5 | 2026-09-23 09:43 | 2026-09-23 09:43 | 2026-09-23 09:43 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 8.0100 | 7.7000 | 8.1250 | 750.7100 | 13615.00 | 12015.00 | 1600.00 | 17 | 6 | 2341 | 1147 | 2.0409764603313 | 0.857227121574032 | 0.800548994271306 | false | false | false | |||||||||||||||||
| 07de2716-0905-4805-b0cd-301021907103 | 2026-09-23 11:22 | 2026-09-23 11:21 | 2026-09-23 11:21 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 9.6600 | 9.6500 | 9.9000 | 755.2200 | 10625.00 | 0.00 | 10625.00 | 11 | 6 | 10042 | 1147 | 8.75501307759372 | 0.700342459337647 | 0.700342459337647 | true | false | false | |||||||||||||||||
| a372bfd9-a112-48a2-aad4-d20a775ec545 | 2026-09-23 12:35 | 2026-09-23 12:35 | 2026-09-23 12:35 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 12.5100 | 11.6500 | 12.7000 | 759.4176 | 47530.00 | 43885.00 | 3645.00 | 38 | 9 | 11143 | 1147 | 9.71490845684394 | 0.738085772647211 | 0.656059843438748 | true | false | false | |||||||||||||||||
| ae15f29a-ad56-4cb5-a20e-48f1df29baf7 | 2026-09-23 15:44 | 2026-09-23 15:44 | 2026-09-23 15:44 | META | META260923C00747500 | call | 747.5000 | 2026-09-23 | 1.6200 | 1.6100 | 1.7000 | 748.0000 | 10025.00 | 0.00 | 10025.00 | 62 | 11 | 22258 | 1147 | 19.4054054054054 | 0.822260170017194 | 0.832574068293972 | true | 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-21T19:00:53.952817Z"} |
| 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 |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:39:02.678096Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-22T14:11:50.316445Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-22T14:17:46.082263Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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-23T15:23:47.442599Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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-23T16:39:09.093031Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:47:37.737983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |