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 | expirydate |
|---|
| 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 |
|---|
| aaf3f061-2f4e-4d94-8a40-91e23d5c32bc | 2026-09-01 11:35 | 2026-09-01 11:35 | 2026-09-01 11:35 | ECHO | ECHO261218C00120000 | call | 120.0000 | 2026-12-18 | 1.4500 | 1.4500 | 1.6000 | 86.5900 | 17835.00 | 0.00 | 17835.00 | 123 | 12 | 152 | 23012 | 0.00660524943507735 | 0.47892875283585 | 0.47892875283585 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 14941864914.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6433ad05-c3a8-4d2c-93cc-9d04ca2a14b2 | 2026-09-01 13:25 | 2026-09-01 13:25 | 2026-09-01 13:25 | ECHO | ECHO261218C00120000 | call | 120.0000 | 2026-12-18 | 1.5000 | 1.3500 | 1.5000 | 86.1500 | 29687.00 | 29687.00 | 0.00 | 198 | 11 | 1469 | 23012 | 0.0638362593429515 | 0.48958403299266 | 0.48958403299266 | true | false | false | true | ||||||||||||||||
| ed187129-8e70-47aa-8bed-a1d89619535f | 2026-09-01 13:25 | 2026-09-01 13:25 | 2026-09-01 13:25 | ECHO | ECHO261218C00120000 | call | 120.0000 | 2026-12-18 | 1.5000 | 1.3500 | 1.5000 | 86.1600 | 39750.00 | 39750.00 | 0.00 | 265 | 8 | 1734 | 23012 | 0.0753519902659482 | 0.489448916416907 | 0.489448916416907 | true | false | false | true | ||||||||||||||||
| 0081e360-f255-475e-81aa-6eb2bc07d34a | 2026-09-01 15:53 | 2026-09-01 15:53 | 2026-09-01 15:53 | ECHO | ECHO261218C00120000 | call | 120.0000 | 2026-12-18 | 1.4500 | 1.2000 | 1.4500 | 85.8400 | 18270.00 | 18270.00 | 0.00 | 126 | 7 | 3409 | 23012 | 0.148140100816965 | 0.488990205272151 | 0.488990205272151 | true | false | false | true | ||||||||||||||||
| 0e472d95-ad81-49b7-ab54-10c42ea5a05d | 2026-09-01 15:53 | 2026-09-01 15:53 | 2026-09-01 15:53 | ECHO | ECHO261218C00120000 | call | 120.0000 | 2026-12-18 | 1.4500 | 1.2000 | 1.5000 | 85.8400 | 15225.00 | 10150.00 | 5075.00 | 105 | 13 | 3514 | 23012 | 0.152702937597775 | 0.488990205272151 | 0.488990205272151 | true | false | false | true | ||||||||||||||||
| 2f6b9b2e-3537-4555-8483-241c510da51d | 2026-09-02 10:49 | 2026-09-02 10:49 | 2026-09-02 10:49 | ECHO | ECHO261218C00120000 | call | 120.0000 | 2026-12-18 | 1.4500 | 1.4000 | 1.5000 | 85.9100 | 327555.00 | 325670.00 | 0.00 | 2259 | 12 | 3391 | 20405 | 0.166184758637589 | 0.490404623377282 | 0.490404623377282 | true | false | false | true | ||||||||||||||||
| 2bd155e0-8a72-4f5f-be1a-0755027a9e79 | 2026-09-04 14:18 | 2026-09-04 14:18 | 2026-09-04 14:18 | ECHO | ECHO261218C00120000 | call | 120.0000 | 2026-12-18 | 1.9500 | 1.9500 | 2.1000 | 89.8400 | 11310.00 | 0.00 | 11310.00 | 58 | 10 | 62 | 19467 | 0.00318487697128474 | 0.485061918560743 | 0.485061918560743 | false | false | false | true | ||||||||||||||||
| d1701dc2-84bd-4d2d-9017-75e382dce9ae | 2026-09-21 12:31 | 2026-09-21 12:31 | 2026-09-21 12:31 | ECHO | ECHO261218C00120000 | call | 120.0000 | 2026-12-18 | 2.1500 | 2.1500 | 2.2500 | 95.0000 | 22360.00 | 0.00 | 22360.00 | 104 | 24 | 116 | 20981 | 0.00552881178208856 | 0.461262561399119 | 0.461262561399119 | false | false | false | true | ||||||||||||||||
| 48342592-9890-451b-a9e3-1e0ace683142 | 2026-09-28 10:44 | 2026-09-28 10:43 | 2026-09-28 10:43 | ECHO | ECHO261218C00120000 | call | 120.0000 | 2026-12-18 | 1.0900 | 0.9000 | 1.1000 | 89.8450 | 30205.00 | 24640.00 | 5565.00 | 277 | 24 | 424 | 15456 | 0.0274327122153209 | 0.467927355927977 | 0.462065049316474 | true | false | false | true | ||||||||||||||||
| f5957858-bf16-4714-b8a3-4d077fe7aa7f | 2026-09-28 10:44 | 2026-09-28 10:44 | 2026-09-28 10:44 | ECHO | ECHO261218C00120000 | call | 120.0000 | 2026-12-18 | 1.0900 | 1.0500 | 1.1000 | 89.8450 | 11525.00 | 8690.00 | 2835.00 | 106 | 17 | 531 | 15456 | 0.0343555900621118 | 0.467927355927977 | 0.462065049316474 | true | false | false | true | ||||||||||||||||
| 802c1c51-7e53-4c0a-a040-4912c7fc0f96 | 2026-09-28 10:44 | 2026-09-28 10:44 | 2026-09-28 10:44 | ECHO | ECHO261218C00120000 | call | 120.0000 | 2026-12-18 | 1.1000 | 1.0500 | 1.1000 | 89.8450 | 12208.00 | 12208.00 | 0.00 | 111 | 7 | 680 | 15456 | 0.0439958592132505 | 0.467927355927977 | 0.467927355927977 | true | false | false | true | ||||||||||||||||
| c4253eb1-1291-4662-aebf-7b7ae0ceb4dd | 2026-09-28 10:44 | 2026-09-28 10:44 | 2026-09-28 10:44 | ECHO | ECHO261218C00120000 | call | 120.0000 | 2026-12-18 | 1.1500 | 1.1000 | 1.1500 | 89.7500 | 14561.00 | 13681.00 | 880.00 | 127 | 25 | 853 | 15456 | 0.0551889233954451 | 0.475042575222391 | 0.469284269787608 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T17:48:11.364966Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T17:48:11.364966Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:31:29.863287Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:31:29.863287Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 15175804006.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:32:17.927421Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 14198670653.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:44:43.841562Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 14198670653.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:44:43.841562Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 14198670653.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:44:43.841562Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 14198670653.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:44:43.841562Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |