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_alerts728,802 rows| 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 |
|---|
| ab868f80-57e7-4fe7-a420-a068fbdbb794 | 2026-10-02 10:22 | 2026-10-02 10:22 | 2026-10-02 10:22 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 1.3300 | 1.3200 | 1.3600 | 283.0000 | 11734.00 | 7906.00 | 3828.00 | 88 | 5 | 10762 | 7959 | 1.35217992210077 | 0.24900521887206 | 0.240699916256211 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 77426935612.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-02T14:24:38.432450Z"} | 2026-10-02 | 2026-10-02 21:15 | 2026-10-02 21:15 |
| 7aa56ba7-e1e2-4d88-a9a5-1167d397c711 | 2026-10-02 10:22 | 2026-10-02 10:22 | 2026-10-02 10:22 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 1.3400 | 1.3200 | 1.3700 | 283.0000 | 12284.00 | 5852.00 | 6432.00 | 92 | 8 | 10674 | 7959 | 1.34112325669054 | 0.250784317607599 | 0.24900521887206 | false | false | false | true | ||||||||||||||||
| 1dc5c65d-4a99-4e97-bb07-93600ccf73f7 | 2026-10-02 10:29 | 2026-10-02 10:29 | 2026-10-02 10:29 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 1.3700 | 1.3700 | 1.3900 | 283.0700 | 10960.00 | 0.00 | 10960.00 | 80 | 5 | 11077 | 7959 | 1.39175775851238 | 0.249271558494876 | 0.249271558494876 | false | false | false | true | ||||||||||||||||
| 8d6181df-1fa3-472b-8aee-aaff13ed8e60 | 2026-10-02 10:47 | 2026-10-02 10:47 | 2026-10-02 10:47 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 1.6700 | 1.6600 | 1.6800 | 283.4800 | 22712.00 | 835.00 | 21877.00 | 136 | 5 | 11733 | 7959 | 1.47418017338862 | 0.248965729260085 | 0.248965729260085 | false | false | false | true | ||||||||||||||||
| 35d2dd94-611b-4ec8-a724-36915849a3f2 | 2026-10-02 11:05 | 2026-10-02 11:05 | 2026-10-02 11:05 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 0.6000 | 0.5900 | 0.6000 | 281.0000 | 12000.00 | 12000.00 | 0.00 | 200 | 19 | 13087 | 7959 | 1.64430204799598 | 0.237148840689058 | 0.237148840689058 | false | false | false | true | ||||||||||||||||
| 1e030f32-cb37-4068-bb74-c0e3a6f82771 | 2026-10-02 11:07 | 2026-10-02 11:07 | 2026-10-02 11:07 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 0.5100 | 0.5000 | 0.5200 | 281.0000 | 10710.00 | 6018.00 | 3723.00 | 210 | 12 | 14315 | 7959 | 1.7985927880387 | 0.242888321269234 | 0.243711803213855 | false | false | false | true | ||||||||||||||||
| 74aa9e4e-d5cb-47b5-89b5-a5e9d64e129f | 2026-10-02 11:15 | 2026-10-02 11:15 | 2026-10-02 11:15 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 0.5000 | 0.5000 | 0.5100 | 281.7100 | 32504.00 | 204.00 | 32300.00 | 650 | 5 | 19498 | 7959 | 2.44980525191607 | 0.241439807686644 | 0.241439807686644 | false | false | false | true | ||||||||||||||||
| 7aa90b55-ef9c-4511-a1bf-198c601ac516 | 2026-10-02 11:23 | 2026-10-02 11:23 | 2026-10-02 11:23 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 0.3700 | 0.3600 | 0.3700 | 281.2800 | 18500.00 | 18500.00 | 0.00 | 500 | 9 | 23059 | 7959 | 2.89722326925493 | 0.258748817683445 | 0.258756661261383 | false | false | false | true | ||||||||||||||||
| 6dde354a-e4f7-45e9-8d80-44b500963242 | 2026-10-02 11:33 | 2026-10-02 11:33 | 2026-10-02 11:33 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 0.5700 | 0.5700 | 0.5800 | 281.0000 | 18240.00 | 0.00 | 18240.00 | 320 | 20 | 28476 | 7959 | 3.5778364116095 | 0.239538166613706 | 0.239538166613706 | false | false | false | true | ||||||||||||||||
| 2a160dfb-b9b8-4107-bb15-10b1f720163d | 2026-10-02 11:36 | 2026-10-02 11:36 | 2026-10-02 11:36 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 0.5900 | 0.5900 | 0.6000 | 281.0000 | 11800.00 | 0.00 | 11800.00 | 200 | 21 | 31281 | 7959 | 3.9302676215605 | 0.234902397479409 | 0.234902397479409 | true | false | false | true | ||||||||||||||||
| 875ec2c5-b1ea-49a2-ba59-c4f662cfbf88 | 2026-10-02 12:29 | 2026-10-02 12:29 | 2026-10-02 12:29 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 0.1800 | 0.1800 | 0.2000 | 281.0000 | 10839.00 | 39.00 | 10800.00 | 602 | 25 | 44450 | 7959 | 5.58487247141601 | 0.211577929711692 | 0.202234649028658 | false | false | false | true | ||||||||||||||||
| 3a76d4fd-ef27-44b2-8ce0-961cccbcfd32 | 2026-10-02 12:45 | 2026-10-02 12:45 | 2026-10-02 12:45 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 0.2000 | 0.1900 | 0.2000 | 281.4250 | 10000.00 | 10000.00 | 0.00 | 500 | 15 | 49081 | 7959 | 6.16672948862923 | 0.197163590919462 | 0.197163590919462 | false | false | false | true | ||||||||||||||||
| 8a6dc50c-d353-4457-afaf-964de0e8ba83 | 2026-10-02 12:52 | 2026-10-02 12:52 | 2026-10-02 12:52 | IWM | IWM261002C00282000 | call | 282.0000 | 2026-10-02 | 0.2500 | 0.2500 | 0.2600 | 281.6150 | 11575.00 | 0.00 | 11575.00 | 463 | 15 | 50748 | 7959 | 6.37617791179796 | 0.194265166923504 | 0.194265166923504 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 77426935612.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T14:24:38.432450Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77426935612.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T14:30:03.899313Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77426935612.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T14:49:11.588051Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77426935612.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:06:05.796781Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77426935612.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:08:03.968530Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77426935612.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:17:41.582030Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77426935612.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:25:11.846831Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77426935612.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:34:27.628549Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77426935612.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:38:49.827146Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 77426935612.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T16:30:27.653312Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77426935612.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T16:49:57.851482Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77426935612.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T16:57:13.004249Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |