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.
Simplify Analyticsuw_flow_alerts474,253 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 |
|---|
| ff38f6ed-a7fe-42df-afff-15c71b8fe3b5 | 2026-09-22 14:13 | 2026-09-22 14:13 | 2026-09-22 14:13 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.4400 | 1.4400 | 1.4900 | 287.8300 | 237744.00 | 0.00 | 237744.00 | 1651 | 75 | 6773 | 2603 | 2.60199769496735 | 0.143130463019986 | 0.143130463019986 | true | false | false | true | 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-22T18:18:27.911867Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 4c236abd-49e4-456c-ae77-4f18249fa07e | 2026-09-22 14:10 | 2026-09-22 14:10 | 2026-09-22 14:10 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.5300 | 1.5300 | 1.5400 | 287.9950 | 18207.00 | 0.00 | 18207.00 | 119 | 12 | 4923 | 2603 | 1.89127929312332 | 0.144969429398685 | 0.144969429398685 | false | false | false | true | false | |||||||||||||||
| 8fbb4cdb-47bd-4780-a49c-93cc5474c62a | 2026-09-22 14:08 | 2026-09-22 14:08 | 2026-09-22 14:08 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.5200 | 1.5200 | 1.5500 | 287.9050 | 92112.00 | 0.00 | 92112.00 | 606 | 26 | 4771 | 2603 | 1.83288513253938 | 0.146566456907675 | 0.146566456907675 | false | false | false | true | false | |||||||||||||||
| ebcf0860-7a8a-41fe-ab50-69f893b57ae7 | 2026-09-22 13:58 | 2026-09-22 13:58 | 2026-09-22 13:58 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.5100 | 1.5100 | 1.5300 | 287.8700 | 37448.00 | 0.00 | 37448.00 | 248 | 13 | 4107 | 2603 | 1.57779485209374 | 0.146778235183159 | 0.146778235183159 | false | false | false | true | false | |||||||||||||||
| afe6620a-ac62-409c-8d94-c5648e35b9dc | 2026-09-22 13:58 | 2026-09-22 13:58 | 2026-09-22 13:58 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.5200 | 1.5000 | 1.5400 | 287.8700 | 27512.00 | 18696.00 | 8816.00 | 181 | 8 | 3857 | 2603 | 1.48175182481752 | 0.14743885997423 | 0.14743885997423 | true | false | false | true | false | |||||||||||||||
| 21e68a6b-c1c6-4216-809c-12d94d786c8d | 2026-09-22 13:58 | 2026-09-22 13:58 | 2026-09-22 13:58 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.5000 | 1.5100 | 1.5200 | 287.8300 | 20103.00 | 0.00 | 20103.00 | 134 | 11 | 3676 | 2603 | 1.41221667306954 | 0.147109424443225 | 0.147771411560534 | false | false | false | true | false | |||||||||||||||
| 274645c0-984d-4d0b-a147-1917c0b539db | 2026-09-22 13:56 | 2026-09-22 13:56 | 2026-09-22 13:56 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.4700 | 1.4200 | 1.4700 | 287.8200 | 10584.00 | 10584.00 | 0.00 | 72 | 17 | 3456 | 2603 | 1.32769880906646 | 0.145368249570085 | 0.145368249570085 | true | false | false | true | false | |||||||||||||||
| 69ee9f79-4720-4131-9371-501dabb3d81f | 2026-09-22 11:09 | 2026-09-22 11:08 | 2026-09-22 11:08 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.0100 | 1.0000 | 1.0100 | 286.0000 | 10201.00 | 10201.00 | 0.00 | 101 | 16 | 2933 | 2603 | 1.12677679600461 | 0.141428877824372 | 0.141428877824372 | false | false | false | true | false | |||||||||||||||
| a29bc148-1193-4519-968a-9d2544fdc003 | 2026-09-22 11:08 | 2026-09-22 11:08 | 2026-09-22 11:08 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.0100 | 0.9900 | 1.0100 | 286.0000 | 20705.00 | 20604.00 | 0.00 | 205 | 19 | 2831 | 2603 | 1.08759124087591 | 0.141215389945433 | 0.141215389945433 | false | false | false | true | false | |||||||||||||||
| 3ef6494b-16f0-475b-8e42-4e2fd37d4c9e | 2026-09-22 10:46 | 2026-09-22 10:46 | 2026-09-22 10:46 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 0.9800 | 0.9800 | 1.0000 | 286.2700 | 23226.00 | 0.00 | 23226.00 | 237 | 19 | 2604 | 2603 | 1.0003841721091 | 0.146157879473034 | 0.146157879473034 | true | false | false | true | false | |||||||||||||||
| ee46bfd2-9ca9-47c7-b7a3-9f75cfbacc40 | 2026-09-22 10:45 | 2026-09-22 10:45 | 2026-09-22 10:45 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.0100 | 0.9700 | 1.0100 | 286.3000 | 23331.00 | 23331.00 | 0.00 | 231 | 8 | 2367 | 2603 | 0.909335382251249 | 0.147781734841918 | 0.147781734841918 | true | false | false | true | false | |||||||||||||||
| 88c9892d-5106-4bfd-b784-b72c8bd6e999 | 2026-09-22 10:45 | 2026-09-22 10:45 | 2026-09-22 10:45 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.0100 | 0.9700 | 1.0100 | 286.3000 | 102048.00 | 102048.00 | 0.00 | 1012 | 44 | 2136 | 2603 | 0.820591625048022 | 0.147781734841918 | 0.146282941985907 | true | false | false | true | false | |||||||||||||||
| 57982b81-ce93-480f-8b76-0a9a3af9cc10 | 2026-09-22 10:05 | 2026-09-22 10:05 | 2026-09-22 10:05 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.7200 | 1.7200 | 1.7400 | 288.3700 | 22532.00 | 0.00 | 22532.00 | 131 | 8 | 1102 | 2603 | 0.423357664233577 | 0.147658741692575 | 0.147658741692575 | false | false | false | true | false | |||||||||||||||
| bbef53fe-3762-401b-a6c5-e12219fbd941 | 2026-09-22 10:05 | 2026-09-22 10:05 | 2026-09-22 10:05 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.7000 | 1.7000 | 1.7200 | 288.3300 | 23970.00 | 0.00 | 23970.00 | 141 | 13 | 886 | 2603 | 0.340376488666923 | 0.147422263120103 | 0.147422263120103 | false | false | false | true | false | |||||||||||||||
| 9f4f1ae7-60f9-4d37-83a8-2eaf862b85fb | 2026-09-22 10:05 | 2026-09-22 10:05 | 2026-09-22 10:05 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.7100 | 1.7000 | 1.7100 | 288.3400 | 23598.00 | 23598.00 | 0.00 | 138 | 13 | 698 | 2603 | 0.268152132155206 | 0.147804637186153 | 0.147804637186153 | true | false | false | true | false | |||||||||||||||
| 89f209e5-bd3a-4e42-a4ff-52303f3af8e8 | 2026-09-22 10:05 | 2026-09-22 10:05 | 2026-09-22 10:05 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.7100 | 1.7100 | 1.7200 | 288.3500 | 31977.00 | 0.00 | 31977.00 | 187 | 9 | 522 | 2603 | 0.200537840952747 | 0.147541456556137 | 0.147541456556137 | false | false | false | true | false | |||||||||||||||
| 10fc65f3-1d2b-4894-813b-3dde8b33aa25 | 2026-09-22 10:05 | 2026-09-22 10:05 | 2026-09-22 10:05 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.7300 | 1.7200 | 1.7300 | 288.3600 | 21798.00 | 21798.00 | 0.00 | 126 | 5 | 272 | 2603 | 0.104494813676527 | 0.148566959662708 | 0.148566959662708 | false | false | false | true | false | |||||||||||||||
| 5a60c707-2539-4aeb-b6e3-8cf451dd235c | 2026-09-21 15:17 | 2026-09-21 15:16 | 2026-09-21 15:16 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.1000 | 1.0900 | 1.1000 | 286.3350 | 22660.00 | 22660.00 | 0.00 | 206 | 8 | 2609 | 37 | 70.5135135135135 | 0.143161222350477 | 0.143161222350477 | false | false | false | true | false | |||||||||||||||
| 6eff4fb8-7aeb-4fe0-8e86-103330823087 | 2026-09-21 15:16 | 2026-09-21 15:16 | 2026-09-21 15:16 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 1.0900 | 1.0700 | 1.0900 | 286.3100 | 22890.00 | 22890.00 | 0.00 | 210 | 21 | 2384 | 37 | 64.4324324324324 | 0.142973445447863 | 0.142973445447863 | false | false | false | true | false | |||||||||||||||
| aa5ff2d9-4c05-41c5-87a5-2d2114aee26f | 2026-09-21 10:29 | 2026-09-21 10:29 | 2026-09-21 10:29 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 0.9500 | 0.9400 | 0.9500 | 286.0701 | 22610.00 | 22610.00 | 0.00 | 238 | 5 | 2102 | 37 | 56.8108108108108 | 0.137856197115103 | 0.137856197115103 | false | false | false | true | false | |||||||||||||||
| 96e50be0-d168-431d-be41-cf9a7c06b9c0 | 2026-09-21 10:29 | 2026-09-21 10:29 | 2026-09-21 10:29 | IWM | IWM260929C00290000 | call | 290.0000 | 2026-09-29 | 0.9400 | 0.9300 | 0.9400 | 285.9200 | 20774.00 | 20774.00 | 0.00 | 221 | 8 | 1863 | 37 | 50.3513513513514 | 0.140013248550439 | 0.140013248550439 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:10:48.215993Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:57:38.128984Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:10:39.659738Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:10:39.659738Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:48:37.826382Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:48:37.826382Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:45:53.881330Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:29:33.809340Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:29:33.809340Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |