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 |
|---|
| 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 |
|---|
| a096c54c-904c-4c0d-8aef-f232371cc6b3 | 2026-09-01 10:13 | 2026-09-01 10:13 | 2026-09-01 10:13 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 6.1600 | 6.0900 | 6.1600 | 291.6400 | 119504.00 | 119504.00 | 0.00 | 194 | 10 | 256 | 137 | 1.86861313868613 | 0.162644307240759 | 0.162644307240759 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 79887436077.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:20:18.853903Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 46b11b6e-e7ae-44cc-ae9d-b455d40c254e | 2026-09-21 10:23 | 2026-09-21 10:22 | 2026-09-21 10:22 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 1.8600 | 1.8300 | 1.8600 | 285.0000 | 18042.00 | 18042.00 | 0.00 | 97 | 5 | 410 | 2802 | 0.146324054246966 | 0.153784511029748 | 0.153675374483021 | false | false | false | true | ||||||||||||||||
| 70aec564-c1cc-4ede-bafc-d6403fa1f094 | 2026-09-21 12:39 | 2026-09-21 12:39 | 2026-09-21 12:39 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 2.0000 | 2.0000 | 2.0100 | 285.9100 | 16400.00 | 0.00 | 16400.00 | 82 | 5 | 1208 | 2802 | 0.431120628122769 | 0.158409987479492 | 0.158409987479492 | true | false | false | true | ||||||||||||||||
| 6f990875-d351-4029-b2f1-b95f7da02c65 | 2026-09-21 13:00 | 2026-09-21 13:00 | 2026-09-21 13:00 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 1.9100 | 1.9000 | 1.9100 | 285.6300 | 15471.00 | 15471.00 | 0.00 | 81 | 6 | 1550 | 2802 | 0.553176302640971 | 0.157881591603751 | 0.157881591603751 | false | false | false | true | ||||||||||||||||
| d6376590-4098-49db-9d5f-1ac32b4ae84e | 2026-09-21 13:12 | 2026-09-21 13:12 | 2026-09-21 13:12 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 1.9000 | 1.8700 | 1.9100 | 285.7900 | 11030.00 | 10840.00 | 0.00 | 58 | 11 | 1758 | 2802 | 0.627408993576017 | 0.155727644568835 | 0.156130571561024 | false | false | false | true | ||||||||||||||||
| 60a09485-e30d-46fd-8f46-7e3bea17f68e | 2026-09-21 13:22 | 2026-09-21 13:22 | 2026-09-21 13:22 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 1.8800 | 1.8700 | 1.9100 | 285.0000 | 12408.00 | 0.00 | 12408.00 | 66 | 5 | 1824 | 2802 | 0.650963597430407 | 0.156393789437796 | 0.156393789437796 | false | false | false | true | ||||||||||||||||
| 638372b9-c8e8-43af-a4d5-b0ded6130d07 | 2026-09-22 09:40 | 2026-09-22 09:40 | 2026-09-22 09:40 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 2.4600 | 2.4300 | 2.4700 | 287.3400 | 10590.00 | 10590.00 | 0.00 | 43 | 7 | 92 | 3461 | 0.0265819127419821 | 0.163521099261694 | 0.163656498906934 | false | false | false | true | ||||||||||||||||
| 7334f5f3-a281-45b0-95d4-1845b40714be | 2026-09-22 09:53 | 2026-09-22 09:53 | 2026-09-22 09:53 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 2.7100 | 2.6900 | 2.7100 | 287.9850 | 24661.00 | 24661.00 | 0.00 | 91 | 5 | 191 | 3461 | 0.055186362323028 | 0.164626154163753 | 0.164626154163753 | false | false | false | true | ||||||||||||||||
| f645a3c8-6283-4b2a-9612-67a8ead36455 | 2026-09-22 09:59 | 2026-09-22 09:59 | 2026-09-22 09:59 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 2.7800 | 2.7800 | 2.8200 | 288.0000 | 16680.00 | 0.00 | 16680.00 | 60 | 6 | 271 | 3461 | 0.0783010690551864 | 0.163769255053734 | 0.163769255053734 | false | false | false | true | ||||||||||||||||
| bb881504-0ca0-4d5c-82e8-72ae31aebb37 | 2026-09-22 10:08 | 2026-09-22 10:07 | 2026-09-22 10:07 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 2.8600 | 2.8600 | 2.8800 | 288.5600 | 30888.00 | 0.00 | 30888.00 | 108 | 11 | 451 | 3461 | 0.130309159202543 | 0.162756296536646 | 0.162756296536646 | false | false | false | true | ||||||||||||||||
| 87d94f7b-fe11-4575-b496-d88ec0aeb11d | 2026-09-22 10:20 | 2026-09-22 10:19 | 2026-09-22 10:19 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 2.5900 | 2.5900 | 2.6200 | 287.9500 | 30821.00 | 0.00 | 30821.00 | 119 | 6 | 603 | 3461 | 0.174227101993643 | 0.160627734916216 | 0.160627734916216 | false | false | false | true | ||||||||||||||||
| 5ecbb94b-946a-41a4-9b75-1944a4dd1656 | 2026-09-22 13:03 | 2026-09-22 13:03 | 2026-09-22 13:03 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 2.1700 | 2.1600 | 2.1800 | 286.0000 | 58590.00 | 57939.00 | 0.00 | 270 | 17 | 1503 | 3461 | 0.434267552730425 | 0.15757244736812 | 0.15757244736812 | true | false | false | true | ||||||||||||||||
| 18c6c942-8006-42f4-900b-0386b73e0764 | 2026-09-24 12:24 | 2026-09-24 12:24 | 2026-09-24 12:24 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 0.9800 | 0.9800 | 1.0200 | 281.1700 | 28420.00 | 0.00 | 28420.00 | 290 | 10 | 597 | 19902 | 0.0299969852276153 | 0.170190252135015 | 0.170190252135015 | false | false | false | true | ||||||||||||||||
| 5c5a8aed-77d6-4f23-9a42-5768ac4b6d5a | 2026-09-24 13:13 | 2026-09-24 13:13 | 2026-09-24 13:13 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 0.9500 | 0.9400 | 0.9500 | 281.1799 | 13205.00 | 13205.00 | 0.00 | 139 | 6 | 810 | 19902 | 0.0406994271932469 | 0.168309255048942 | 0.168309255048942 | false | false | false | true | ||||||||||||||||
| b9a564ac-1442-44b5-b853-8c91bf491807 | 2026-09-24 13:14 | 2026-09-24 13:14 | 2026-09-24 13:14 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 0.9800 | 0.9700 | 0.9800 | 281.4250 | 12838.00 | 12838.00 | 0.00 | 131 | 6 | 941 | 19902 | 0.0472816802331424 | 0.167751248888819 | 0.167751248888819 | false | false | false | true | ||||||||||||||||
| 570bb299-86f4-4036-9cd2-7f28e7187793 | 2026-09-24 14:09 | 2026-09-24 14:09 | 2026-09-24 14:09 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 0.9300 | 0.9100 | 0.9300 | 281.0450 | 23157.00 | 23157.00 | 0.00 | 249 | 7 | 1371 | 19902 | 0.0688875489900513 | 0.168382553930221 | 0.168382553930221 | false | false | false | true | ||||||||||||||||
| b4388547-bbeb-49ee-b7da-7350efcdd2b1 | 2026-09-25 15:54 | 2026-09-25 15:54 | 2026-09-25 15:54 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 1.0300 | 1.0200 | 1.0300 | 282.4900 | 53457.00 | 53457.00 | 0.00 | 519 | 5 | 3185 | 20526 | 0.15516905388288 | 0.164348175683561 | 0.164348175683561 | true | false | false | true | ||||||||||||||||
| 7aca9551-115f-4890-9543-02fe14da285f | 2026-09-25 15:54 | 2026-09-25 15:54 | 2026-09-25 15:54 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 1.0300 | 1.0100 | 1.0300 | 282.4800 | 203940.00 | 203940.00 | 0.00 | 1980 | 50 | 2666 | 20526 | 0.129884049498197 | 0.164448346989659 | 0.164448346989659 | true | false | false | true | ||||||||||||||||
| 19d88b82-27a6-4ac8-a142-8c89f8d3f6d6 | 2026-09-28 15:05 | 2026-09-28 15:05 | 2026-09-28 15:05 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 0.6900 | 0.6700 | 0.6900 | 280.4500 | 13800.00 | 13800.00 | 0.00 | 200 | 7 | 726 | 20446 | 0.0355081678567935 | 0.176195458844801 | 0.176195458844801 | false | false | false | true | ||||||||||||||||
| 8fb5ec76-fbad-4111-a866-15d4f175d94c | 2026-09-28 16:01 | 2026-09-28 16:01 | 2026-09-28 16:01 | IWM | IWM261016C00294000 | call | 294.0000 | 2026-10-16 | 0.6400 | 0.6200 | 0.6400 | 280.0000 | 42880.00 | 42880.00 | 0.00 | 670 | 34 | 1409 | 20446 | 0.0689132348625648 | 0.175691011615668 | 0.175691011615668 | true | false | false | true |
| 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-21T14:24:21.810098Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:41:29.676906Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:02:00.389820Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:16:02.178873Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T17:24:56.111062Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-22T13:41:44.035284Z"} |
| 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-22T13:54:31.756724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T14:01:27.900775Z"} |
| 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:10:05.607073Z"} |
| 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:20:22.518739Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T17:06:21.234354Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77607608234.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:27:48.650295Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77607608234.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:14:36.344002Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77607608234.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:14:36.344002Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77607608234.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:15:40.223371Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:54:56.567521Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:54:56.567521Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:11:33.715590Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |