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 | strike |
|---|
| 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 |
|---|
| 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 | false | 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 |
| 96e212d6-23fb-4c02-9dc6-cb56918a181b | 2026-09-23 16:00 | 2026-09-23 15:59 | 2026-09-23 15:59 | ECHO | ECHO261016P00091000 | put | 91.0000 | 2026-10-16 | 3.1000 | 2.8000 | 3.1000 | 92.0000 | 180726.00 | 180726.00 | 0.00 | 583 | 42 | 1000 | 0 | 0 | 0.432735778454548 | 0.432735778454548 | false | false | ||||||||||||||||||
| 97e31c03-081d-4653-ad93-cf9bf45002dc | 2026-09-16 13:08 | 2026-09-16 13:08 | 2026-09-16 13:08 | ECHO | ECHO261218C00100000 | call | 100.0000 | 2026-12-18 | 7.2000 | 6.8000 | 7.2000 | 93.8500 | 134629.00 | 134629.00 | 0.00 | 187 | 43 | 191 | 11571 | 0.016506784201884 | 0.492258375332844 | 0.491727174944324 | false | false | ||||||||||||||||||
| 00ee81f8-776a-4d43-b240-3a131e193278 | 2026-09-11 12:41 | 2026-09-11 12:41 | 2026-09-11 12:41 | ECHO | ECHO280121C00170000 | call | 170.0000 | 2028-01-21 | 6.4900 | 6.1000 | 6.6000 | 92.4350 | 15580.00 | 7260.00 | 8320.00 | 24 | 5 | 235 | 152 | 1.54605263157895 | 0.510336496760255 | 0.504595038497805 | false | false | ||||||||||||||||||
| 704b34a2-0724-47ab-a1e7-62019b020b91 | 2026-09-08 12:50 | 2026-09-08 12:50 | 2026-09-08 12:50 | ECHO | ECHO261218C00115000 | call | 115.0000 | 2026-12-18 | 3.5000 | 3.2000 | 3.7000 | 93.5800 | 34294.00 | 2094.00 | 32200.00 | 98 | 5 | 113 | 2327 | 0.0485603781693167 | 0.494258404058065 | 0.493641008263037 | false | false | ||||||||||||||||||
| 7bbe561a-d360-49b3-8bd6-981ddd118465 | 2026-09-03 10:48 | 2026-09-03 10:48 | 2026-09-03 10:48 | ECHO | ECHO260911C00091000 | call | 91.0000 | 2026-09-11 | 1.4500 | 1.2500 | 1.4500 | 89.3250 | 66966.00 | 66966.00 | 0.00 | 462 | 45 | 462 | 40 | 11.55 | 0.405120378101214 | 0.405120378101214 | false | false | ||||||||||||||||||
| 14b5891d-825f-4eaa-8997-dbab61f45918 | 2026-08-28 12:27 | 2026-08-28 12:27 | 2026-08-28 12:27 | ECHO | ECHO260828C00085000 | call | 85.0000 | 2026-08-28 | 0.4000 | 0.2000 | 0.4000 | 84.9200 | 10428.00 | 10428.00 | 0.00 | 261 | 38 | 286 | 49 | 5.83673469387755 | 0.6431198555741 | 0.6431198555741 | false | false | ||||||||||||||||||
| 17a4230d-e6fd-4655-9279-ae062a5efe6c | 2026-08-27 14:57 | 2026-08-27 14:57 | 2026-08-27 14:57 | ECHO | ECHO270115C00150000 | call | 150.0000 | 2027-01-15 | 0.7700 | 0.4000 | 0.8000 | 85.3700 | 91095.00 | 91095.00 | 0.00 | 1182 | 41 | 1184 | 8389 | 0.141137203480749 | 0.540478408788563 | 0.54003424556491 | false | false | ||||||||||||||||||
| ede4e48f-8baa-4c76-9d48-0898e29c8e55 | 2026-08-27 11:19 | 2026-08-27 11:19 | 2026-08-27 11:19 | ECHO | ECHO260918C00085000 | call | 85.0000 | 2026-09-18 | 3.8100 | 3.4000 | 4.8000 | 85.4100 | 23622.00 | 0.00 | 23622.00 | 62 | 8 | 70 | 1100 | 0.0636363636363636 | 0.421206239293886 | 0.421206239293886 | false | false | ||||||||||||||||||
| 4770915f-e405-4a76-93f4-78ca473e56a3 | 2026-08-27 09:56 | 2026-08-27 09:56 | 2026-08-27 09:56 | ECHO | ECHO260918P00082000 | put | 82.0000 | 2026-09-18 | 2.1500 | 1.8500 | 2.1500 | 85.0450 | 71577.00 | 71577.00 | 0.00 | 333 | 46 | 333 | 215 | 1.54883720930233 | 0.432691686169857 | 0.432691686169857 | false | false | ||||||||||||||||||
| bd88b49a-71b5-4ca3-b374-d1a1bf9135ad | 2026-08-26 12:04 | 2026-08-26 12:04 | 2026-08-26 12:04 | ECHO | ECHO260828P00082000 | put | 82.0000 | 2026-08-28 | 0.3500 | 0.3000 | 0.3500 | 84.5600 | 10000.00 | 10000.00 | 0.00 | 286 | 38 | 286 | 85 | 3.36470588235294 | 0.501535578280895 | 0.501535578280895 | false | false | ||||||||||||||||||
| d6d9d171-6ef6-4b5d-910b-e0b0c1bb5c8d | 2026-08-26 11:12 | 2026-08-26 11:12 | 2026-08-26 11:12 | ECHO | ECHO261218P00075000 | put | 75.0000 | 2026-12-18 | 4.3100 | 4.1000 | 5.0000 | 84.7800 | 430692.00 | 466.00 | 430226.00 | 1000 | 6 | 1001 | 3027 | 0.330690452593327 | 0.511406332809962 | 0.511406332809962 | false | false | ||||||||||||||||||
| 62b52753-d074-43db-91f4-fa189d4ffd85 | 2026-08-18 09:53 | 2026-08-18 09:53 | 2026-08-18 09:53 | ECHO | ECHO260821C00090000 | call | 90.0000 | 2026-08-21 | 2.3400 | 1.7500 | 3.2000 | 90.8200 | 46782.00 | 0.00 | 46782.00 | 200 | 6 | 200 | 2813 | 0.0710984713828653 | 0.561287089032673 | 0.548834007556905 | false | false | ||||||||||||||||||
| dc00b68e-0f28-4c44-aec6-3ce7cd8348a2 | 2026-08-17 12:06 | 2026-08-17 12:06 | 2026-08-17 12:06 | ECHO | ECHO260911P00083000 | put | 83.0000 | 2026-09-11 | 0.7500 | 0.7500 | 1.0000 | 94.2500 | 20187.00 | 0.00 | 20187.00 | 269 | 32 | 364 | 26 | 14 | 0.461550454670484 | 0.457664801721673 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 14755668493.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 14873433750.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-11T16:54:27.741510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-08T17:11:09.796111Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-03T14:57:35.447301Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:00:28.149501Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 14941864914.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |