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_alerts523,327 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 |
|---|
| 24108bcb-6e1f-43e0-acc7-72f390e2df96 | 2026-09-02 13:16 | 2026-09-02 13:16 | 2026-09-02 13:16 | BIDU | BIDU261016P00100000 | put | 100.0000 | 2026-10-16 | 8.3500 | 8.1500 | 8.3500 | 94.3600 | 18370.00 | 18370.00 | 0.00 | 22 | 6 | 23 | 1912 | 0.0120292887029289 | 0.400504084350164 | 0.400504084350164 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 25249453318.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6883271c-76fa-43d6-8dd0-1247b848f335 | 2026-08-28 09:35 | 2026-08-28 09:35 | 2026-08-28 09:35 | BIDU | BIDU261016P00100000 | put | 100.0000 | 2026-10-16 | 6.8000 | 6.7000 | 7.2500 | 97.7300 | 20400.00 | 10200.00 | 10200.00 | 30 | 6 | 113 | 1593 | 0.0709353421217828 | 0.410016099748245 | 0.408205686796972 | false | false | false | true | ||||||||||||||||
| 2a608ff6-682e-4053-b68c-7d30477e9955 | 2026-08-28 09:32 | 2026-08-28 09:32 | 2026-08-28 09:32 | BIDU | BIDU261016P00100000 | put | 100.0000 | 2026-10-16 | 7.0000 | 6.8500 | 7.6000 | 97.4800 | 17500.00 | 0.00 | 17500.00 | 25 | 5 | 33 | 1593 | 0.0207156308851224 | 0.413106729633146 | 0.413106729633146 | false | false | false | true | ||||||||||||||||
| b2a0e2cf-a09e-40af-8cfb-ee3add57857b | 2026-08-27 14:18 | 2026-08-27 14:18 | 2026-08-27 14:18 | BIDU | BIDU261016P00100000 | put | 100.0000 | 2026-10-16 | 7.6000 | 7.5500 | 7.7500 | 96.6400 | 11400.00 | 0.00 | 11400.00 | 15 | 5 | 302 | 1295 | 0.233204633204633 | 0.419964414509935 | 0.419964414509935 | false | false | false | true | ||||||||||||||||
| 6bab688e-965d-42bd-a98c-0ff0d676c77f | 2026-08-27 14:18 | 2026-08-27 14:18 | 2026-08-27 14:18 | BIDU | BIDU261016P00100000 | put | 100.0000 | 2026-10-16 | 7.6500 | 7.5500 | 7.7500 | 96.6100 | 11475.00 | 0.00 | 0.00 | 15 | 5 | 287 | 1295 | 0.221621621621622 | 0.422340458497634 | 0.422340458497634 | false | false | false | true | ||||||||||||||||
| 50f037c3-aee5-4764-9d8d-455cddedceb9 | 2026-08-27 14:05 | 2026-08-27 14:05 | 2026-08-27 14:05 | BIDU | BIDU261016P00100000 | put | 100.0000 | 2026-10-16 | 7.6000 | 7.5000 | 7.7500 | 96.5950 | 11400.00 | 0.00 | 11400.00 | 15 | 5 | 237 | 1295 | 0.183011583011583 | 0.418237647151734 | 0.418237647151734 | false | false | false | true | ||||||||||||||||
| 3dd156fa-958a-4ac6-9879-6da2f47237b4 | 2026-08-27 14:04 | 2026-08-27 14:04 | 2026-08-27 14:04 | BIDU | BIDU261016P00100000 | put | 100.0000 | 2026-10-16 | 7.6000 | 7.5000 | 7.8500 | 96.5750 | 19000.00 | 3800.00 | 15200.00 | 25 | 5 | 222 | 1295 | 0.171428571428571 | 0.417468020802748 | 0.417468020802748 | false | false | false | true | ||||||||||||||||
| c3b47d00-d752-4840-a8ee-9f360d70b538 | 2026-08-27 14:03 | 2026-08-27 14:03 | 2026-08-27 14:03 | BIDU | BIDU261016P00100000 | put | 100.0000 | 2026-10-16 | 7.6000 | 7.5000 | 7.8500 | 96.5700 | 11400.00 | 0.00 | 11400.00 | 15 | 5 | 197 | 1295 | 0.152123552123552 | 0.417275403679428 | 0.417275403679428 | false | false | false | true | ||||||||||||||||
| da77a9ad-748e-40cb-9071-b5cae886b072 | 2026-08-27 13:16 | 2026-08-27 13:16 | 2026-08-27 13:16 | BIDU | BIDU261016P00100000 | put | 100.0000 | 2026-10-16 | 7.5500 | 7.4500 | 7.6500 | 96.7300 | 11325.00 | 4530.00 | 0.00 | 15 | 5 | 182 | 1295 | 0.140540540540541 | 0.419879060803811 | 0.419879060803811 | false | false | false | true | ||||||||||||||||
| 8755c90d-80ed-4bcb-8124-e5d800642d80 | 2026-08-27 13:02 | 2026-08-27 13:02 | 2026-08-27 13:02 | BIDU | BIDU261016P00100000 | put | 100.0000 | 2026-10-16 | 7.6000 | 7.5000 | 7.8500 | 96.6500 | 19000.00 | 3800.00 | 15200.00 | 25 | 5 | 167 | 1295 | 0.128957528957529 | 0.420347227640311 | 0.420347227640311 | false | false | false | true | ||||||||||||||||
| f9160cf2-f955-41f3-9d2f-5bd13b6187d2 | 2026-08-17 13:18 | 2026-08-17 13:18 | 2026-08-17 13:18 | BIDU | BIDU261016P00100000 | put | 100.0000 | 2026-10-16 | 5.9000 | 5.7500 | 6.0000 | 103.0300 | 10030.00 | 10030.00 | 0.00 | 17 | 5 | 206 | 848 | 0.242924528301887 | 0.464255675814345 | 0.464255675814345 | false | false | false | true | ||||||||||||||||
| 521136cf-a7f8-405c-9fb6-190eee0131d6 | 2026-08-17 11:10 | 2026-08-17 11:10 | 2026-08-17 11:10 | BIDU | BIDU261016P00100000 | put | 100.0000 | 2026-10-16 | 6.1500 | 5.9500 | 6.3500 | 102.3000 | 25215.00 | 4920.00 | 20295.00 | 41 | 6 | 172 | 848 | 0.202830188679245 | 0.461879075870964 | 0.461879075870964 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:32:48.312014Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |