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_alerts566,287 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 |
|---|
| 064fdaf1-127e-4e92-9865-1f530801ab99 | 2026-08-18 10:32 | 2026-08-18 10:32 | 2026-08-18 10:32 | SPY | SPY260821P00767000 | put | 767.0000 | 2026-08-21 | 2.3700 | 2.3700 | 2.3800 | 768.9300 | 106650.00 | 0.00 | 106650.00 | 450 | 20 | 3859 | 2804 | 1.3762482168331 | 0.120379506554669 | 0.120379506554669 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 802935622223.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 09914f4e-0f30-4817-9a12-0614b7f14a49 | 2026-08-20 10:53 | 2026-08-20 10:53 | 2026-08-20 10:53 | SPY | SPY260821P00767000 | put | 767.0000 | 2026-08-21 | 2.1100 | 2.0900 | 2.1000 | 767.0600 | 249566.00 | 249566.00 | 0.00 | 1184 | 22 | 23775 | 6698 | 3.5495670349358 | 0.13542112648421 | 0.136045710581632 | true | false | false | true | ||||||||||||||||
| 3377ee19-6120-44b2-9bcf-564bb4475e68 | 2026-08-20 11:13 | 2026-08-20 11:13 | 2026-08-20 11:13 | SPY | SPY260821P00767000 | put | 767.0000 | 2026-08-21 | 2.3400 | 2.3400 | 2.3600 | 766.5400 | 273078.00 | 0.00 | 273078.00 | 1167 | 47 | 31597 | 6698 | 4.71737832188713 | 0.133596149846341 | 0.13392632003585 | true | false | false | true | ||||||||||||||||
| 4a439369-0bea-4439-ad62-2e90d896f615 | 2026-08-20 11:29 | 2026-08-20 11:29 | 2026-08-20 11:29 | SPY | SPY260821P00767000 | put | 767.0000 | 2026-08-21 | 2.1900 | 2.1800 | 2.2000 | 766.7800 | 109724.00 | 106658.00 | 0.00 | 500 | 27 | 34599 | 6698 | 5.16557181248134 | 0.132321302865264 | 0.132946015359991 | false | false | false | true | ||||||||||||||||
| 19efaa29-9c10-4973-b6c4-140f4e23c9a3 | 2026-08-20 11:30 | 2026-08-20 11:30 | 2026-08-20 11:30 | SPY | SPY260821P00767000 | put | 767.0000 | 2026-08-21 | 2.2000 | 2.1900 | 2.2200 | 766.7294 | 110000.00 | 96360.00 | 13640.00 | 500 | 5 | 35156 | 6698 | 5.24873096446701 | 0.131330095448884 | 0.131330095448884 | false | false | false | true | ||||||||||||||||
| b69638ac-2697-473e-89d1-79ae2d0bfb2c | 2026-08-20 12:39 | 2026-08-20 12:38 | 2026-08-20 12:38 | SPY | SPY260821P00767000 | put | 767.0000 | 2026-08-21 | 2.3300 | 2.3200 | 2.3400 | 766.2600 | 247159.00 | 245528.00 | 0.00 | 1059 | 58 | 39456 | 6698 | 5.89071364586444 | 0.12417003236857 | 0.124452951598097 | true | false | false | true | ||||||||||||||||
| c08079c4-a027-473e-98a3-30a4fe45c1a0 | 2026-08-20 13:21 | 2026-08-20 13:21 | 2026-08-20 13:21 | SPY | SPY260821P00767000 | put | 767.0000 | 2026-08-21 | 3.0000 | 2.9900 | 3.0400 | 764.9999 | 318306.00 | 42300.00 | 276006.00 | 1061 | 53 | 43282 | 6698 | 6.46192893401015 | 0.117914607929442 | 0.117914607929442 | false | false | false | true | ||||||||||||||||
| 80503a8f-37e3-4728-93bf-569ce2dacd9c | 2026-08-21 10:57 | 2026-08-21 10:57 | 2026-08-21 10:57 | SPY | SPY260821P00767000 | put | 767.0000 | 2026-08-21 | 1.8600 | 1.8400 | 1.8700 | 765.4800 | 122574.00 | 94860.00 | 0.00 | 659 | 7 | 15023 | 9451 | 1.58956724156174 | 0.125397392873727 | 0.125397392873727 | false | false | false | true | ||||||||||||||||
| 208557aa-61a0-46b9-8773-fbe2acdd7505 | 2026-08-21 11:44 | 2026-08-21 11:44 | 2026-08-21 11:44 | SPY | SPY260821P00767000 | put | 767.0000 | 2026-08-21 | 0.7400 | 0.7400 | 0.7500 | 767.2200 | 322640.00 | 0.00 | 322640.00 | 4360 | 7 | 65613 | 9451 | 6.94243995344408 | 0.126247241115499 | 0.126247241115499 | false | false | false | true | ||||||||||||||||
| 6055c301-461e-44b5-a66e-70b02aafe652 | 2026-08-21 12:02 | 2026-08-21 12:02 | 2026-08-21 12:02 | SPY | SPY260821P00767000 | put | 767.0000 | 2026-08-21 | 0.8300 | 0.8100 | 0.8300 | 766.9300 | 150804.00 | 150476.00 | 328.00 | 1817 | 11 | 126028 | 9451 | 13.3348851973336 | 0.121614031972045 | 0.123155858600876 | false | false | false | true | ||||||||||||||||
| 47875326-21dd-4978-9695-ae99189220c8 | 2026-08-21 13:22 | 2026-08-21 13:22 | 2026-08-21 13:22 | SPY | SPY260821P00767000 | put | 767.0000 | 2026-08-21 | 1.2700 | 1.2600 | 1.2800 | 765.9300 | 414041.00 | 413914.00 | 0.00 | 3260 | 15 | 220440 | 9451 | 23.3245159242408 | 0.112298999526444 | 0.114718814596709 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |