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 |
|---|
| 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 |
|---|
| 4bc29773-ce98-4ffc-8649-d7e4d3b6736f | 2026-09-22 15:38 | 2026-09-22 15:38 | 2026-09-22 15:38 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.9800 | 0.9800 | 1.0000 | 287.8450 | 29400.00 | 0.00 | 29400.00 | 300 | 20 | 17599 | 3081 | 5.7121064589419 | 0.17310685948167 | 0.17310685948167 | false | 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-22T19:40:59.804437Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| c574b098-2273-4988-a983-8b766bb8e036 | 2026-09-22 13:39 | 2026-09-22 13:39 | 2026-09-22 13:39 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.6200 | 0.6200 | 0.6300 | 287.0000 | 22134.00 | 0.00 | 22134.00 | 357 | 23 | 12605 | 3081 | 4.09120415449529 | 0.168228683646136 | 0.168228683646136 | true | false | false | true | false | |||||||||||||||
| 874d8c5a-0882-42d4-a393-98862a16dcf4 | 2026-09-22 13:08 | 2026-09-22 13:08 | 2026-09-22 13:08 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.5300 | 0.5300 | 0.5500 | 286.7601 | 10652.00 | 0.00 | 10652.00 | 200 | 26 | 11945 | 3081 | 3.87698799091204 | 0.172296411657665 | 0.1704362274281 | true | false | false | true | false | |||||||||||||||
| 5bda6016-a853-4886-bc4e-07e3b7a54ad3 | 2026-09-22 12:55 | 2026-09-22 12:55 | 2026-09-22 12:55 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.6300 | 0.6200 | 0.6300 | 286.9600 | 12600.00 | 12600.00 | 0.00 | 200 | 15 | 11152 | 3081 | 3.61960402466732 | 0.176388644441242 | 0.176388644441242 | true | false | false | true | false | |||||||||||||||
| e49cabdf-1dd5-46e5-a054-6deb661c1ec4 | 2026-09-22 12:50 | 2026-09-22 12:50 | 2026-09-22 12:50 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.6800 | 0.6600 | 0.6800 | 287.1397 | 13532.00 | 13532.00 | 0.00 | 199 | 8 | 10758 | 3081 | 3.49172346640701 | 0.173617380536725 | 0.173617380536725 | false | false | false | true | false | |||||||||||||||
| 327fafa8-8c21-4653-8f40-a476e7de169a | 2026-09-22 10:13 | 2026-09-22 10:13 | 2026-09-22 10:13 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 1.5300 | 1.5000 | 1.5300 | 288.6400 | 19584.00 | 19584.00 | 0.00 | 128 | 13 | 6429 | 3081 | 2.08666017526777 | 0.193298678971965 | 0.193298678971965 | false | false | false | true | false | |||||||||||||||
| da015efb-c3cf-4220-ab8e-3a94137243dd | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.8800 | 0.8700 | 0.9100 | 287.4350 | 45232.00 | 88.00 | 45144.00 | 514 | 35 | 3774 | 3081 | 1.22492697176241 | 0.187925480360137 | 0.187563892218684 | false | false | false | true | false | |||||||||||||||
| d1d18d29-e809-4740-a47b-9679c861fa26 | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.8900 | 0.8800 | 0.9000 | 287.4300 | 31741.00 | 8722.00 | 23019.00 | 358 | 40 | 3260 | 3081 | 1.05809802012334 | 0.189258168075296 | 0.187925480360137 | false | false | false | true | false | |||||||||||||||
| be40f470-ba97-4766-a7aa-77854dd2b572 | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.9000 | 0.9000 | 0.9200 | 287.4250 | 36630.00 | 0.00 | 36630.00 | 407 | 24 | 2078 | 3081 | 0.674456345342421 | 0.19167656571252 | 0.19167656571252 | false | false | false | true | false | |||||||||||||||
| aaedc160-99a4-46cb-a62b-72da6aa76653 | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.9000 | 0.8900 | 0.9100 | 287.4350 | 36000.00 | 10980.00 | 25020.00 | 400 | 33 | 2538 | 3081 | 0.823758519961052 | 0.19167656571252 | 0.190951912444886 | false | false | false | true | false | |||||||||||||||
| 51c6f040-ea6f-4e77-ba8a-abd41820f421 | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.8900 | 0.8900 | 0.9100 | 287.4350 | 29993.00 | 0.00 | 29993.00 | 337 | 26 | 2902 | 3081 | 0.941901979876663 | 0.189258168075296 | 0.189258168075296 | false | false | false | true | false | |||||||||||||||
| 03ecd59a-98b5-476c-8c7c-eebac33b57a2 | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.9400 | 0.9400 | 0.9500 | 287.4750 | 12784.00 | 0.00 | 12784.00 | 136 | 7 | 1384 | 3081 | 0.449204803635183 | 0.194794869910014 | 0.194794869910014 | false | false | false | true | false | |||||||||||||||
| 3baf6027-aaf0-4410-8582-a9843185c4aa | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.7600 | 0.7500 | 0.8100 | 287.1500 | 13300.00 | 0.00 | 13300.00 | 175 | 23 | 374 | 3081 | 0.121389159363843 | 0.186883351661678 | 0.186883351661678 | true | false | false | true | false | |||||||||||||||
| 3774dee1-9808-495a-9fed-6485e1ca1d46 | 2026-09-21 15:40 | 2026-09-21 15:40 | 2026-09-21 15:40 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.6700 | 0.6500 | 0.6700 | 286.2900 | 13376.00 | 13376.00 | 0.00 | 200 | 19 | 4094 | 367 | 11.1553133514986 | 0.156134516597974 | 0.157467240773666 | false | false | false | true | false | |||||||||||||||
| d67f6842-8566-4ee4-9286-d5df893dc000 | 2026-09-21 10:16 | 2026-09-21 10:16 | 2026-09-21 10:16 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.4600 | 0.4400 | 0.4600 | 285.6550 | 18998.00 | 18998.00 | 0.00 | 413 | 21 | 2623 | 367 | 7.14713896457766 | 0.152699589066959 | 0.152699589066959 | true | false | false | true | false | |||||||||||||||
| 7c64f29c-5ae4-4dc1-959d-ee47ad59dc1b | 2026-09-21 10:16 | 2026-09-21 10:16 | 2026-09-21 10:16 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.4500 | 0.4300 | 0.4500 | 285.6250 | 42975.00 | 42975.00 | 0.00 | 955 | 37 | 1859 | 367 | 5.06539509536785 | 0.152277502872614 | 0.152277502872614 | true | false | false | true | false | |||||||||||||||
| 0f3ddaf2-c95a-4366-96b0-88269464d2a6 | 2026-09-21 10:16 | 2026-09-21 10:16 | 2026-09-21 10:16 | IWM | IWM260923C00288000 | call | 288.0000 | 2026-09-23 | 0.4400 | 0.4300 | 0.4400 | 285.6200 | 34276.00 | 34276.00 | 0.00 | 779 | 22 | 902 | 367 | 2.45776566757493 | 0.150929854321691 | 0.150929854321691 | true | false | false | true | false |
| 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:40:26.166069Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:14:46.677665Z"} |
| 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-22T16:59:26.444099Z"} |
| 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-22T16:52:20.560244Z"} |
| 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:15:02.242582Z"} |
| 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:39:02.678096Z"} |
| 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-22T13:39:02.678096Z"} |
| 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-22T13:39:02.678096Z"} |
| 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:39:02.678096Z"} |
| 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:39:02.678096Z"} |
| 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:39:02.678096Z"} |
| 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-22T13:31:35.812482Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:43:03.886437Z"} |
| 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:18:27.541285Z"} |
| 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:18:27.541285Z"} |
| 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:18:27.541285Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |