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 |
|---|
| 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 |
|---|
| f3a9fa81-5735-4930-b588-e57640710d16 | 2026-09-21 14:03 | 2026-09-21 14:03 | 2026-09-21 14:03 | IWM | IWM260930P00284000 | put | 284.0000 | 2026-09-30 | 1.9100 | 1.9100 | 1.9300 | 285.0000 | 166934.00 | 0.00 | 166934.00 | 874 | 49 | 4255 | 531 | 8.01318267419962 | 0.154974175818841 | 0.154974175818841 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 78247032269.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:05:09.858972Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 7022a111-a01e-4656-aa92-ead5bb58349d | 2026-09-23 10:02 | 2026-09-23 10:02 | 2026-09-23 10:02 | IWM | IWM260930P00284000 | put | 284.0000 | 2026-09-30 | 2.3100 | 2.2800 | 2.3100 | 284.0000 | 24024.00 | 24024.00 | 0.00 | 104 | 11 | 486 | 2918 | 0.166552433173406 | 0.15743222756351 | 0.15743222756351 | true | false | false | |||||||||||||||||
| b7742714-2eac-49ea-b0ce-0a7e1bcd23eb | 2026-09-23 10:02 | 2026-09-23 10:02 | 2026-09-23 10:02 | IWM | IWM260930P00284000 | put | 284.0000 | 2026-09-30 | 2.3100 | 2.3100 | 2.3400 | 284.0000 | 51051.00 | 0.00 | 51051.00 | 221 | 10 | 707 | 2918 | 0.242289239204935 | 0.156673545546389 | 0.156673545546389 | false | false | false | |||||||||||||||||
| c53918c3-a15d-47d7-ba0d-0d5f530ea610 | 2026-09-23 10:02 | 2026-09-23 10:02 | 2026-09-23 10:02 | IWM | IWM260930P00284000 | put | 284.0000 | 2026-09-30 | 2.2900 | 2.2900 | 2.3300 | 284.0000 | 91829.00 | 0.00 | 91829.00 | 401 | 14 | 1108 | 2918 | 0.379712131596984 | 0.155852341547277 | 0.155852341547277 | false | false | false | |||||||||||||||||
| 653dc230-281d-475b-a0cc-1f6695432e94 | 2026-09-23 10:05 | 2026-09-23 10:05 | 2026-09-23 10:05 | IWM | IWM260930P00284000 | put | 284.0000 | 2026-09-30 | 2.4700 | 2.4700 | 2.4900 | 283.0000 | 36803.00 | 0.00 | 36803.00 | 149 | 7 | 1467 | 2918 | 0.502741603838245 | 0.157739472694909 | 0.157739472694909 | false | false | false | |||||||||||||||||
| 4480091b-6b8d-4940-8d2d-c4b4178d4940 | 2026-09-23 11:05 | 2026-09-23 11:05 | 2026-09-23 11:05 | IWM | IWM260930P00284000 | put | 284.0000 | 2026-09-30 | 2.7400 | 2.7400 | 2.7900 | 283.2600 | 13426.00 | 0.00 | 13426.00 | 49 | 8 | 2785 | 2918 | 0.954420836189171 | 0.157641954670982 | 0.157641954670982 | false | false | false | |||||||||||||||||
| 525b85fd-5bbf-4815-8774-e09d6e59be28 | 2026-09-23 11:17 | 2026-09-23 11:17 | 2026-09-23 11:17 | IWM | IWM260930P00284000 | put | 284.0000 | 2026-09-30 | 2.4600 | 2.4300 | 2.4600 | 283.8500 | 11070.00 | 11070.00 | 0.00 | 45 | 9 | 2857 | 2918 | 0.979095270733379 | 0.1589895417041 | 0.1589895417041 | false | false | false | |||||||||||||||||
| a2040715-d36b-45da-a7a6-a050979caf71 | 2026-09-25 09:35 | 2026-09-25 09:35 | 2026-09-25 09:35 | IWM | IWM260930P00284000 | put | 284.0000 | 2026-09-30 | 3.2700 | 3.2500 | 3.2700 | 281.9350 | 12099.00 | 12099.00 | 0.00 | 37 | 6 | 84 | 1749 | 0.0480274442538593 | 0.165348360322161 | 0.165348360322161 | false | false | false | |||||||||||||||||
| e1ba2929-7b6b-4ed2-897f-7ce810b63ab3 | 2026-09-25 12:04 | 2026-09-25 12:04 | 2026-09-25 12:04 | IWM | IWM260930P00284000 | put | 284.0000 | 2026-09-30 | 2.7800 | 2.7800 | 2.8000 | 282.9900 | 13622.00 | 0.00 | 13622.00 | 49 | 7 | 288 | 1749 | 0.164665523156089 | 0.172516565093544 | 0.175927628196681 | false | false | false | |||||||||||||||||
| 160b5f38-35cc-4cc0-914d-8c814a34564f | 2026-09-25 12:28 | 2026-09-25 12:27 | 2026-09-25 12:27 | IWM | IWM260930P00284000 | put | 284.0000 | 2026-09-30 | 2.6800 | 2.6800 | 2.7000 | 282.0000 | 21209.00 | 0.00 | 21209.00 | 79 | 11 | 432 | 1749 | 0.246998284734134 | 0.166051088541125 | 0.165284537544012 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:02:33.967509Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:02:33.967509Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:02:33.967509Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:05:57.943683Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:19:29.119553Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:35:49.891887Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:05:43.599354Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:31:25.590153Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |