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 |
|---|
| 9210d0c5-d211-4690-a058-6167f7578a5f | 2026-09-02 10:04 | 2026-09-02 10:04 | 2026-09-02 10:04 | SLV | SLV260911C00059000 | call | 59.0000 | 2026-09-11 | 1.6100 | 1.5300 | 1.6100 | 59.0700 | 48288.00 | 48288.00 | 0.00 | 300 | 13 | 599 | 770 | 0.777922077922078 | 0.418362844473547 | 0.415654677798852 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 38529495748.00 | — | — | — | 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 |
| d62d89cd-a8a3-4d35-b0af-4e56c127d6d1 | 2026-09-02 10:05 | 2026-09-02 10:05 | 2026-09-02 10:05 | SLV | SLV260911C00059000 | call | 59.0000 | 2026-09-11 | 1.6300 | 1.5500 | 1.6300 | 59.1100 | 16300.00 | 16300.00 | 0.00 | 100 | 5 | 699 | 770 | 0.907792207792208 | 0.418058410764415 | 0.418058410764415 | false | false | false | |||||||||||||||||
| 767e8cfb-b24b-4a4b-9ae5-428d938bbc73 | 2026-09-02 10:07 | 2026-09-02 10:07 | 2026-09-02 10:07 | SLV | SLV260911C00059000 | call | 59.0000 | 2026-09-11 | 1.6300 | 1.5600 | 1.6300 | 59.1402 | 16299.00 | 16299.00 | 0.00 | 100 | 5 | 799 | 770 | 1.03766233766234 | 0.413709076176641 | 0.411000423682175 | false | false | false | |||||||||||||||||
| 3ab263b9-b5b6-4d84-8f21-2181db3b49b3 | 2026-09-02 14:45 | 2026-09-02 14:44 | 2026-09-02 14:44 | SLV | SLV260911C00059000 | call | 59.0000 | 2026-09-11 | 1.4300 | 1.3700 | 1.4400 | 58.7750 | 14331.00 | 4464.00 | 0.00 | 100 | 5 | 1204 | 770 | 1.56363636363636 | 0.413123050899215 | 0.413123050899215 | false | false | false | |||||||||||||||||
| 6a61c4e6-5d0e-4f17-bb4a-43aa15d1edf9 | 2026-09-04 11:01 | 2026-09-04 11:01 | 2026-09-04 11:01 | SLV | SLV260911C00059000 | call | 59.0000 | 2026-09-11 | 1.5000 | 1.5000 | 1.5700 | 59.5119 | 22500.00 | 0.00 | 22500.00 | 150 | 21 | 562 | 1509 | 0.372432074221339 | 0.367352281698018 | 0.367352281698018 | false | false | false | |||||||||||||||||
| cc91e1fb-776c-4abf-bb0d-126768a63a28 | 2026-09-10 10:36 | 2026-09-10 10:36 | 2026-09-10 10:36 | SLV | SLV260911C00059000 | call | 59.0000 | 2026-09-11 | 0.5800 | 0.5600 | 0.5800 | 58.3900 | 29000.00 | 29000.00 | 0.00 | 500 | 27 | 1845 | 1769 | 1.04296212549463 | 0.691903168103914 | 0.691903168103914 | false | false | false | |||||||||||||||||
| aacaeb4c-54d4-430d-91de-cb088a699ba8 | 2026-09-10 13:13 | 2026-09-10 13:12 | 2026-09-10 13:12 | SLV | SLV260911C00059000 | call | 59.0000 | 2026-09-11 | 0.4500 | 0.4400 | 0.4500 | 58.2050 | 17640.00 | 17640.00 | 0.00 | 392 | 17 | 3641 | 1769 | 2.05822498586772 | 0.639057020476232 | 0.639057020476232 | false | false | false | |||||||||||||||||
| b31a71f0-3ecb-40c6-ae74-d0daf0db4c0c | 2026-09-10 13:32 | 2026-09-10 13:31 | 2026-09-10 13:31 | SLV | SLV260911C00059000 | call | 59.0000 | 2026-09-11 | 0.4400 | 0.4400 | 0.4600 | 58.1850 | 44000.00 | 0.00 | 44000.00 | 1000 | 26 | 5889 | 1769 | 3.32899943470888 | 0.636349025427094 | 0.636349025427094 | false | false | false | |||||||||||||||||
| 2a9e4994-4182-4f8b-8e29-bc648f1ee221 | 2026-09-11 09:55 | 2026-09-11 09:54 | 2026-09-11 09:54 | SLV | SLV260911C00059000 | call | 59.0000 | 2026-09-11 | 0.1900 | 0.1700 | 0.1900 | 58.0000 | 19000.00 | 19000.00 | 0.00 | 1000 | 17 | 3151 | 4913 | 0.641359658050071 | 0.543032980712349 | 0.543032980712349 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:08:56.003529Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:36:53.026568Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T17:37:34.117542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T17:37:34.117542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |