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 |
|---|
| ca613942-6819-4cf9-8ae0-1925a95468d4 | 2026-08-17 13:32 | 2026-08-17 13:32 | 2026-08-17 13:32 | SPY | SPY260817P00775000 | put | 775.0000 | 2026-08-17 | 1.5100 | 1.5100 | 1.5400 | 773.5900 | 183317.00 | 154.00 | 183163.00 | 1214 | 14 | 805048 | 11470 | 70.1872711421099 | 0.115785619608422 | 0.105168413147575 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 802935622223.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cf8d6724-8918-4c1d-8b27-33485513f320 | 2026-08-17 13:23 | 2026-08-17 13:23 | 2026-08-17 13:23 | SPY | SPY260817P00775000 | put | 775.0000 | 2026-08-17 | 1.2000 | 1.1600 | 1.2300 | 773.9800 | 101779.00 | 98037.00 | 3742.00 | 847 | 65 | 785875 | 11470 | 68.5156931124673 | 0.100099830379804 | 0.110897659918872 | true | false | false | true | ||||||||||||||||
| a5a35850-4527-4c85-8c01-b4e54671d337 | 2026-08-17 13:16 | 2026-08-17 13:16 | 2026-08-17 13:16 | SPY | SPY260817P00775000 | put | 775.0000 | 2026-08-17 | 0.8800 | 0.8600 | 0.8800 | 774.3550 | 112195.00 | 111760.00 | 435.00 | 1275 | 27 | 759825 | 11470 | 66.2445510026155 | 0.0892495465800767 | 0.0893565457477172 | false | false | false | true | ||||||||||||||||
| 0c659fce-4fda-4637-8668-432b99db6911 | 2026-08-17 12:44 | 2026-08-17 12:44 | 2026-08-17 12:44 | SPY | SPY260817P00775000 | put | 775.0000 | 2026-08-17 | 0.4800 | 0.4700 | 0.4800 | 774.9400 | 123600.00 | 123600.00 | 0.00 | 2575 | 14 | 667097 | 11470 | 58.1601569311247 | 0.0772410849838149 | 0.076375964935538 | true | false | false | true | ||||||||||||||||
| b47c2564-3d8b-4bf1-87bd-4afd2033b53d | 2026-08-17 11:45 | 2026-08-17 11:45 | 2026-08-17 11:45 | SPY | SPY260817P00775000 | put | 775.0000 | 2026-08-17 | 0.5600 | 0.5500 | 0.5800 | 775.0399 | 153384.00 | 7504.00 | 145880.00 | 2739 | 15 | 525493 | 11470 | 45.8145597210113 | 0.0876415615782644 | 0.0862153913703807 | false | false | false | true | ||||||||||||||||
| dc780e82-209f-4481-94dc-64bdec5a1c9f | 2026-08-17 11:44 | 2026-08-17 11:44 | 2026-08-17 11:44 | SPY | SPY260817P00775000 | put | 775.0000 | 2026-08-17 | 0.5600 | 0.5500 | 0.5700 | 775.0500 | 134021.00 | 1804.00 | 55553.00 | 2394 | 91 | 519729 | 11470 | 45.3120313862249 | 0.0851797013421648 | 0.0853211814624688 | true | false | false | true | ||||||||||||||||
| fa2867fe-3596-409a-83f3-28e0153c95db | 2026-08-17 11:41 | 2026-08-17 11:40 | 2026-08-17 11:40 | SPY | SPY260817P00775000 | put | 775.0000 | 2026-08-17 | 0.6400 | 0.6300 | 0.6400 | 774.9200 | 146804.00 | 146048.00 | 756.00 | 2294 | 51 | 500778 | 11470 | 43.6598081952921 | 0.0861707184817032 | 0.08838799383613 | false | false | false | true | ||||||||||||||||
| 4876796d-1159-4e59-81f5-a6fbe3d78ad7 | 2026-08-17 11:36 | 2026-08-17 11:36 | 2026-08-17 11:36 | SPY | SPY260817P00775000 | put | 775.0000 | 2026-08-17 | 0.4900 | 0.4800 | 0.5100 | 775.2200 | 248078.00 | 247833.00 | 145.00 | 5062 | 83 | 479324 | 11470 | 41.7893635571055 | 0.0873332183599882 | 0.0896182623758223 | true | false | false | true | ||||||||||||||||
| f6bba046-2c68-4166-bb43-d6cd7031b589 | 2026-08-17 09:39 | 2026-08-17 09:39 | 2026-08-17 09:39 | SPY | SPY260817P00775000 | put | 775.0000 | 2026-08-17 | 0.8500 | 0.8400 | 0.8600 | 775.4100 | 325711.00 | 30530.00 | 294501.00 | 3828 | 99 | 40652 | 11470 | 3.54420226678291 | 0.126392848154239 | 0.126392848154239 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 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-17T17:22:08.033203Z"} |
| 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-17T16:56:51.972483Z"} |
| 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-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 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-17T16:01:56.961018Z"} |
| 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-17T15:40:30.458422Z"} |
| 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-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |