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 |
|---|
| 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 |
|---|
| d2b4dc40-2f46-467e-b9a4-8846d75ff502 | 2026-08-24 09:39 | 2026-08-24 09:39 | 2026-08-24 09:39 | DRAM | DRAM261016C00061000 | call | 61.0000 | 2026-10-16 | 3.3900 | 3.2000 | 3.5500 | 54.0300 | 33852.00 | 27112.00 | 6740.00 | 100 | 5 | 1105 | 14 | 78.9285714285714 | 0.705358464782642 | 0.705358464782642 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:46:45.098903Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 93c2bfcb-4e7e-47ba-8ad5-c445db47374c | 2026-08-24 09:42 | 2026-08-24 09:42 | 2026-08-24 09:42 | DRAM | DRAM261016C00061000 | call | 61.0000 | 2026-10-16 | 3.3500 | 3.2000 | 3.4500 | 53.8701 | 100379.00 | 91766.00 | 8613.00 | 300 | 7 | 2208 | 14 | 157.714285714286 | 0.705483076327632 | 0.705483076327632 | false | false | false | |||||||||||||||||
| 8b0e2120-1d00-4ec4-ba09-955c3ce71c58 | 2026-09-14 09:34 | 2026-09-14 09:34 | 2026-09-14 09:34 | DRAM | DRAM261016C00061000 | call | 61.0000 | 2026-10-16 | 1.8700 | 1.8400 | 1.9900 | 54.5800 | 18690.00 | 0.00 | 18690.00 | 100 | 5 | 108 | 2853 | 0.0378548895899054 | 0.628903804736555 | 0.628903804736555 | false | false | false | |||||||||||||||||
| 949e38ee-7154-459c-8c0a-2be397cbf861 | 2026-09-17 12:47 | 2026-09-17 12:47 | 2026-09-17 12:47 | DRAM | DRAM261016C00061000 | call | 61.0000 | 2026-10-16 | 2.6000 | 2.5800 | 2.6000 | 57.8250 | 11700.00 | 11700.00 | 0.00 | 45 | 16 | 318 | 2816 | 0.112926136363636 | 0.587284709532659 | 0.587284709532659 | false | false | false | |||||||||||||||||
| b4a22a85-a8f9-4761-8d6c-ef40e18d6c5e | 2026-09-21 10:08 | 2026-09-21 10:08 | 2026-09-21 10:08 | DRAM | DRAM261016C00061000 | call | 61.0000 | 2026-10-16 | 3.8000 | 3.8000 | 3.8500 | 60.9799 | 11400.00 | 0.00 | 11400.00 | 30 | 12 | 208 | 3074 | 0.0676642810670137 | 0.58662155926525 | 0.58662155926525 | false | false | false | |||||||||||||||||
| 2335dfbe-ecd0-4dc6-8cce-d8c2017f1be5 | 2026-09-21 10:08 | 2026-09-21 10:08 | 2026-09-21 10:08 | DRAM | DRAM261016C00061000 | call | 61.0000 | 2026-10-16 | 3.8000 | 3.8000 | 3.8500 | 60.9900 | 11400.00 | 0.00 | 11400.00 | 30 | 13 | 239 | 3074 | 0.0777488614183474 | 0.585766113426988 | 0.585766113426988 | false | false | false | |||||||||||||||||
| b1846207-ffc1-4edb-ab98-98159a9fb9e4 | 2026-09-21 10:39 | 2026-09-21 10:39 | 2026-09-21 10:39 | DRAM | DRAM261016C00061000 | call | 61.0000 | 2026-10-16 | 3.9500 | 3.9000 | 3.9500 | 61.2350 | 13822.00 | 13430.00 | 392.00 | 35 | 5 | 317 | 3074 | 0.103122966818478 | 0.588463060510559 | 0.583737119801525 | false | false | false | |||||||||||||||||
| 09734955-56cf-47bd-9a4e-24ea7672cbfa | 2026-09-25 09:39 | 2026-09-25 09:39 | 2026-09-25 09:39 | DRAM | DRAM261016C00061000 | call | 61.0000 | 2026-10-16 | 4.1500 | 4.1000 | 4.2000 | 62.0000 | 13280.00 | 12865.00 | 0.00 | 32 | 7 | 33 | 3157 | 0.0104529616724739 | 0.58241527556869 | 0.58241527556869 | false | false | false | |||||||||||||||||
| 7988226b-3e3d-470a-8fe5-6f4698d32d4e | 2026-09-28 09:34 | 2026-09-28 09:34 | 2026-09-28 09:34 | DRAM | DRAM261016C00061000 | call | 61.0000 | 2026-10-16 | 2.8000 | 2.8000 | 2.8500 | 60.0500 | 27721.00 | 0.00 | 27721.00 | 99 | 27 | 134 | 3170 | 0.0422712933753943 | 0.597308829801604 | 0.597308829801604 | false | false | false | |||||||||||||||||
| e909ad36-06ba-4d84-8a66-f1e44e2b20cb | 2026-09-29 10:24 | 2026-09-29 10:24 | 2026-09-29 10:24 | DRAM | DRAM261016C00061000 | call | 61.0000 | 2026-10-16 | 3.3100 | 3.3000 | 3.4000 | 61.4450 | 33100.00 | 0.00 | 33100.00 | 100 | 8 | 198 | 3375 | 0.0586666666666667 | 0.574210910804329 | 0.574210910804329 | false | false | false | |||||||||||||||||
| ebdb3236-87a2-4df1-9fad-cd9198b21116 | 2026-09-30 14:18 | 2026-09-30 14:18 | 2026-09-30 14:18 | DRAM | DRAM261016C00061000 | call | 61.0000 | 2026-10-16 | 2.6400 | 2.6400 | 2.6800 | 60.2150 | 26400.00 | 0.00 | 26400.00 | 100 | 26 | 302 | 3371 | 0.0895876594482349 | 0.586842210677606 | 0.586842210677606 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:46:45.098903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:08:15.762043Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:10:29.738922Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:35:57.715033Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:27:05.819137Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T18:21:07.901642Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |