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_alerts609,118 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 | expirydate |
|---|
| 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 |
|---|
| 578f96be-b290-4f65-a8d9-63266e4af6ee | 2026-09-16 09:50 | 2026-09-16 09:50 | 2026-09-16 09:50 | META | META270115C00600000 | call | 600.0000 | 2027-01-15 | 114.0000 | 111.0000 | 114.0000 | 679.1250 | 809400.00 | 809400.00 | 0.00 | 71 | 5 | 93 | 6443 | 0.0144342697501164 | 0.416543008997451 | 0.416543008997451 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1484735076395.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 5bc629ee-71b4-4277-95e8-f5afe800e0f4 | 2026-09-09 10:59 | 2026-09-09 10:59 | 2026-09-09 10:59 | META | META270115C00600000 | call | 600.0000 | 2027-01-15 | 100.0000 | 99.7000 | 100.0000 | 655.9000 | 290000.00 | 290000.00 | 0.00 | 29 | 11 | 577 | 7069 | 0.0816239920780874 | 0.427004410592971 | 0.427004410592971 | false | false | false | true | ||||||||||||||||
| 511fd8e6-12cd-4637-842e-4910078c4f1d | 2026-09-09 09:50 | 2026-09-09 09:50 | 2026-09-09 09:50 | META | META270115C00600000 | call | 600.0000 | 2027-01-15 | 94.9900 | 93.4000 | 95.8000 | 649.6095 | 227965.00 | 227965.00 | 0.00 | 24 | 9 | 327 | 7069 | 0.0462583109350686 | 0.421419993137171 | 0.42245482614715 | false | false | false | true | ||||||||||||||||
| 3b91824a-405f-4673-87d6-316e18bc2521 | 2026-09-03 11:25 | 2026-09-03 11:25 | 2026-09-03 11:25 | META | META270115C00600000 | call | 600.0000 | 2027-01-15 | 72.6400 | 72.4000 | 73.2500 | 618.7800 | 159815.00 | 14530.00 | 145285.00 | 22 | 6 | 1066 | 7489 | 0.142342101749232 | 0.396219241955045 | 0.396920618571809 | false | false | false | true | ||||||||||||||||
| f059cedf-2337-4ec4-b1cd-15c0393a8de0 | 2026-09-02 10:03 | 2026-09-02 10:03 | 2026-09-02 10:03 | META | META270115C00600000 | call | 600.0000 | 2027-01-15 | 60.0000 | 59.0500 | 60.0500 | 597.1300 | 234010.00 | 234010.00 | 0.00 | 39 | 9 | 178 | 7763 | 0.0229292799175576 | 0.396738560067454 | 0.396575283534857 | false | false | false | true | ||||||||||||||||
| 24a0b11d-ec69-40f9-809a-e7649113ed10 | 2026-09-01 10:02 | 2026-09-01 10:02 | 2026-09-01 10:02 | META | META270115C00600000 | call | 600.0000 | 2027-01-15 | 43.2200 | 43.1500 | 43.6500 | 566.2830 | 419188.00 | 0.00 | 419188.00 | 97 | 5 | 192 | 7827 | 0.0245304714449981 | 0.389946349131274 | 0.389946349131274 | false | false | false | true | ||||||||||||||||
| e5233d60-adb3-436f-9e94-2300c152ccfd | 2026-08-28 10:51 | 2026-08-28 10:51 | 2026-08-28 10:51 | META | META270115C00600000 | call | 600.0000 | 2027-01-15 | 55.0000 | 54.5000 | 55.0500 | 586.4499 | 110005.00 | 110005.00 | 0.00 | 20 | 6 | 226 | 8032 | 0.0281374501992032 | 0.395171147845298 | 0.394886639578714 | false | false | false | true | ||||||||||||||||
| c3bd151b-2daa-41c4-af13-83cd1e47ca0c | 2026-08-26 09:32 | 2026-08-26 09:32 | 2026-08-26 09:32 | META | META270115C00600000 | call | 600.0000 | 2027-01-15 | 56.8700 | 56.0000 | 57.2500 | 586.3500 | 181975.00 | 96810.00 | 85165.00 | 32 | 12 | 260 | 7649 | 0.0339913714211008 | 0.407746582315202 | 0.404744884739612 | false | false | false | true | ||||||||||||||||
| 3b38b6a1-b971-4cd7-8dcd-7d6808408ad1 | 2026-08-17 11:43 | 2026-08-17 11:43 | 2026-08-17 11:43 | META | META270115C00600000 | call | 600.0000 | 2027-01-15 | 49.8100 | 49.8000 | 50.5000 | 574.1100 | 403444.00 | 0.00 | 403444.00 | 81 | 14 | 589 | 6724 | 0.0875966686496133 | 0.386058473206308 | 0.386737343669264 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:11:00.326314Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:20:18.853903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:54:23.998586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |