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_alerts658,639 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 | expiry |
|---|
| 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 |
|---|
| b4995484-d287-43b1-8f97-88ff0aa988d1 | 2026-10-01 10:19 | 2026-10-01 10:18 | 2026-10-01 10:18 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 0.3800 | 0.3800 | 0.3900 | 738.4000 | 109820.00 | 0.00 | 109820.00 | 2890 | 46 | 6085 | 8587 | 0.708629323395831 | 0.251925560102279 | 0.251925560102279 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 498945995904.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T14:20:01.826419Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| 161b3159-b861-4677-807a-cd72db15bfa2 | 2026-09-30 16:09 | 2026-09-30 16:08 | 2026-09-30 16:08 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 0.8000 | 0.7900 | 0.8300 | 739.0000 | 20000.00 | 10160.00 | 9760.00 | 250 | 18 | 7783 | 7493 | 1.03870278926999 | 0.203134232681616 | 0.203134232681616 | false | false | false | true | ||||||||||||||||
| e61908d7-cc55-4aa0-b423-033de5fcbce0 | 2026-09-30 16:07 | 2026-09-30 16:07 | 2026-09-30 16:07 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 0.8700 | 0.8600 | 0.9000 | 740.0000 | 11573.00 | 0.00 | 8615.00 | 133 | 12 | 7253 | 7493 | 0.967970105431736 | 0.20322293354023 | 0.20322293354023 | true | false | false | true | ||||||||||||||||
| 9cc7bc9d-62f8-4303-80db-917eedc2ab09 | 2026-09-30 15:37 | 2026-09-30 15:37 | 2026-09-30 15:37 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 1.4900 | 1.4800 | 1.4900 | 743.5000 | 39187.00 | 39187.00 | 0.00 | 263 | 13 | 6361 | 7493 | 0.848925663953023 | 0.202580832967805 | 0.202718761466498 | false | false | false | true | ||||||||||||||||
| 8b0dc114-efc0-4bb1-a24e-2ad483407f76 | 2026-09-30 15:21 | 2026-09-30 15:21 | 2026-09-30 15:21 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 1.4400 | 1.4300 | 1.4400 | 743.0000 | 14400.00 | 14400.00 | 0.00 | 100 | 9 | 5361 | 7493 | 0.715467769918591 | 0.200954294540902 | 0.200954294540902 | false | false | false | true | ||||||||||||||||
| 71ccea81-f531-4394-88ae-cf585985c2bc | 2026-09-30 15:20 | 2026-09-30 15:20 | 2026-09-30 15:20 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 1.4300 | 1.4300 | 1.4400 | 743.0000 | 14300.00 | 0.00 | 14300.00 | 100 | 7 | 5261 | 7493 | 0.702121980515148 | 0.200488248400982 | 0.200488248400982 | false | false | false | true | ||||||||||||||||
| 96ad9ea7-81b9-4b33-becc-b688bdb83202 | 2026-09-30 15:10 | 2026-09-30 15:09 | 2026-09-30 15:09 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 1.5100 | 1.5100 | 1.5200 | 743.7000 | 15100.00 | 0.00 | 15100.00 | 100 | 14 | 4638 | 7493 | 0.618977712531696 | 0.201139230757328 | 0.201139230757328 | false | false | false | true | ||||||||||||||||
| 052bc667-d0c3-4b23-96bb-008551ebaefb | 2026-09-30 14:23 | 2026-09-30 14:23 | 2026-09-30 14:23 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 1.3800 | 1.3800 | 1.3900 | 743.0500 | 16422.00 | 0.00 | 16422.00 | 119 | 7 | 4259 | 7493 | 0.568397170692647 | 0.202179720257873 | 0.202179720257873 | false | false | false | true | ||||||||||||||||
| 78c24aff-030b-495c-8b1c-4a9802158b19 | 2026-09-30 11:57 | 2026-09-30 11:57 | 2026-09-30 11:57 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 1.7300 | 1.7300 | 1.7400 | 744.0000 | 13840.00 | 0.00 | 13840.00 | 80 | 9 | 3328 | 7493 | 0.44414787134659 | 0.207239410436071 | 0.207239410436071 | false | false | false | true | ||||||||||||||||
| 81f29275-45f0-440f-acb4-9a38e1292d46 | 2026-09-30 10:04 | 2026-09-30 10:04 | 2026-09-30 10:04 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 1.9100 | 1.9000 | 1.9200 | 744.1100 | 19100.00 | 16808.00 | 0.00 | 100 | 11 | 1552 | 7493 | 0.207126651541439 | 0.218170070017545 | 0.218170070017545 | true | false | false | true | ||||||||||||||||
| 91ee8b8b-9051-4780-9fcb-82934e67a4d7 | 2026-09-30 10:04 | 2026-09-30 10:04 | 2026-09-30 10:04 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 1.9100 | 1.9000 | 1.9200 | 744.1400 | 29987.00 | 28650.00 | 382.00 | 157 | 29 | 1441 | 7493 | 0.192312825303617 | 0.217730158421997 | 0.217730158421997 | true | false | false | true | ||||||||||||||||
| 4e05bc9b-80ee-4766-b1ce-64eca213f229 | 2026-09-25 15:46 | 2026-09-25 15:46 | 2026-09-25 15:46 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 4.0400 | 4.0200 | 4.0500 | 744.0000 | 12120.00 | 3232.00 | 808.00 | 30 | 10 | 3236 | 6736 | 0.480403800475059 | 0.165311232600935 | 0.165311232600935 | true | false | false | true | ||||||||||||||||
| c6ad3c90-129d-4d52-aefd-1130d0951649 | 2026-09-25 09:39 | 2026-09-25 09:39 | 2026-09-25 09:39 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 3.7800 | 3.7800 | 3.7900 | 744.0000 | 30996.00 | 0.00 | 30996.00 | 82 | 11 | 361 | 6736 | 0.0535926365795724 | 0.165935687281597 | 0.165935687281597 | false | false | false | true | ||||||||||||||||
| d9adef5f-cf38-4a3f-8b1f-e645a8a3daa9 | 2026-09-24 15:59 | 2026-09-24 15:59 | 2026-09-24 15:59 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 3.5800 | 3.5400 | 3.5800 | 741.0000 | 22554.00 | 22554.00 | 0.00 | 63 | 10 | 3217 | 5506 | 0.584271703596077 | 0.170193607197267 | 0.170193607197267 | false | false | false | true | ||||||||||||||||
| 294fcc3f-25ed-4315-9dd6-6019dc4f8f49 | 2026-09-24 15:53 | 2026-09-24 15:53 | 2026-09-24 15:53 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 3.6300 | 3.6200 | 3.6300 | 741.6600 | 63507.00 | 56991.00 | 6516.00 | 175 | 8 | 3051 | 5506 | 0.554122775154377 | 0.170061681797976 | 0.170061681797976 | true | false | false | true | ||||||||||||||||
| 70c7a5c4-08ea-4ae0-b735-ede3cf3eaaf5 | 2026-09-23 15:59 | 2026-09-23 15:59 | 2026-09-23 15:59 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 3.7900 | 3.7400 | 3.7900 | 740.0000 | 26909.00 | 26909.00 | 0.00 | 71 | 12 | 1860 | 5449 | 0.341347036153423 | 0.169006456350675 | 0.169156340997483 | false | false | false | true | ||||||||||||||||
| 84ab3ea0-1cc2-4ce0-a312-7145fe7047e0 | 2026-09-22 10:14 | 2026-09-22 10:14 | 2026-09-22 10:14 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 5.6400 | 5.5900 | 5.6500 | 745.6850 | 11844.00 | 11280.00 | 0.00 | 21 | 8 | 1113 | 4416 | 0.252038043478261 | 0.163784881246163 | 0.163784881246163 | true | false | false | true | ||||||||||||||||
| 62ad864a-b969-4f18-847e-b291cefcec2e | 2026-09-22 10:04 | 2026-09-22 10:03 | 2026-09-22 10:03 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 5.3200 | 5.3200 | 5.3300 | 744.7599 | 89908.00 | 0.00 | 89908.00 | 169 | 6 | 308 | 4416 | 0.0697463768115942 | 0.164645215162882 | 0.164645215162882 | true | false | false | true | ||||||||||||||||
| 5a39e941-6937-40b0-a3ef-5f10e70f063c | 2026-09-21 15:59 | 2026-09-21 15:59 | 2026-09-21 15:59 | QQQ | QQQ261002C00752000 | call | 752.0000 | 2026-10-02 | 4.6100 | 4.5500 | 4.6100 | 741.0000 | 27199.00 | 27199.00 | 0.00 | 59 | 7 | 533 | 4299 | 0.123982321470109 | 0.165997284727824 | 0.165997284727824 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498608653246.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498608653246.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498608653246.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:37:24.384434Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498608653246.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:23:43.569533Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498608653246.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:23:43.569533Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498608653246.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:16:05.592005Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498608653246.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T18:26:32.922967Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498608653246.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T15:59:45.687136Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498608653246.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:05:50.172417Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498608653246.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:05:50.172417Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 500943922525.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:47:28.119549Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 500943922525.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:39:47.971768Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 497207767216.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 497207767216.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:53:57.742588Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498637580106.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 495805413150.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 |
| — |
| 495805413150.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:04:08.107942Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 484276301501.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |