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 |
|---|
| 2df8b211-2ef4-45fe-83bc-974ae9f83e1f | 2026-09-01 10:17 | 2026-09-01 10:17 | 2026-09-01 10:17 | SPXW | SPXW260902P07640000 | put | 7640.0000 | 2026-09-02 | 15.1800 | 15.1000 | 15.5000 | 7650.7800 | 151800.00 | 0.00 | 151800.00 | 100 | 24 | 1099 | 420 | 2.61666666666667 | 0.128890308507722 | 0.127605140478783 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | — | 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 |
| abd41c73-ea1f-4a0d-a1da-1e62cb12e6ad | 2026-09-01 12:58 | 2026-09-01 12:58 | 2026-09-01 12:58 | SPXW | SPXW260902P07640000 | put | 7640.0000 | 2026-09-02 | 19.7900 | 19.6000 | 19.9000 | 7638.6100 | 126680.00 | 1980.00 | 116820.00 | 64 | 8 | 3621 | 420 | 8.62142857142857 | 0.122288584718687 | 0.121661626222993 | false | false | false | true | ||||||||||||||||
| 7ea966fe-9e46-472e-b6e1-4a1a3c8eba99 | 2026-09-01 13:00 | 2026-09-01 13:00 | 2026-09-01 13:00 | SPXW | SPXW260902P07640000 | put | 7640.0000 | 2026-09-02 | 20.2000 | 20.1000 | 20.4000 | 7639.0600 | 121200.00 | 90900.00 | 30300.00 | 60 | 8 | 3697 | 420 | 8.80238095238095 | 0.126211359090117 | 0.126211359090117 | false | false | false | true | ||||||||||||||||
| f732b4f7-8295-47c8-84fc-148e6e380a69 | 2026-09-02 10:19 | 2026-09-02 10:19 | 2026-09-02 10:19 | SPXW | SPXW260902P07640000 | put | 7640.0000 | 2026-09-02 | 3.1600 | 3.0000 | 3.3000 | 7665.9600 | 158300.00 | 0.00 | 150350.00 | 501 | 66 | 17806 | 1080 | 16.487037037037 | 0.154148455606382 | 0.152587788741768 | false | false | false | true | ||||||||||||||||
| c7456ddf-59ee-4de7-8fd2-b79071b02ae7 | 2026-09-02 10:27 | 2026-09-02 10:27 | 2026-09-02 10:27 | SPXW | SPXW260902P07640000 | put | 7640.0000 | 2026-09-02 | 2.8500 | 2.7500 | 2.9000 | 7671.5700 | 282775.00 | 90115.00 | 53865.00 | 993 | 62 | 22919 | 1080 | 21.2212962962963 | 0.168090036789903 | 0.169143050781572 | false | false | false | true | ||||||||||||||||
| a8ffa88e-8fcd-452b-9126-665851883ffd | 2026-09-02 10:48 | 2026-09-02 10:48 | 2026-09-02 10:48 | SPXW | SPXW260902P07640000 | put | 7640.0000 | 2026-09-02 | 2.2000 | 2.1500 | 2.2500 | 7675.8500 | 100540.00 | 55660.00 | 44880.00 | 457 | 51 | 31634 | 1080 | 29.2907407407407 | 0.174459886821049 | 0.174459886821049 | false | false | false | true | ||||||||||||||||
| 7f89c0b2-5a6d-481d-99d0-b2287ec239da | 2026-09-02 10:48 | 2026-09-02 10:48 | 2026-09-02 10:48 | SPXW | SPXW260902P07640000 | put | 7640.0000 | 2026-09-02 | 2.3000 | 2.2000 | 2.3500 | 7675.8100 | 107570.00 | 66635.00 | 37490.00 | 468 | 44 | 32165 | 1080 | 29.7824074074074 | 0.175695417712006 | 0.176786848638337 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T17:20:15.685951Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T17:20:15.685951Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:25:30.485375Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |