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 | expirydate |
|---|
| 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 |
|---|
| fde92e67-7852-4995-bd80-eb904a103a0c | 2026-09-11 10:35 | 2026-09-11 10:35 | 2026-09-11 10:35 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 11.0000 | 10.8600 | 11.0000 | 764.6200 | 221099.00 | 221099.00 | 0.00 | 201 | 8 | 676 | 4507 | 0.149988906145995 | 0.149615443938793 | 0.149615443938793 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 810275044553.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 96d3d148-55aa-4daa-89dc-4b6bce4b38e0 | 2026-09-03 12:02 | 2026-09-03 12:02 | 2026-09-03 12:02 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 7.4100 | 7.4000 | 7.4200 | 773.0700 | 163761.00 | 741.00 | 163020.00 | 221 | 6 | 959 | 4320 | 0.221990740740741 | 0.128650801021875 | 0.128650801021875 | true | false | false | true | false | |||||||||||||||
| e7d37387-40a0-463e-895e-9c6ed433f244 | 2026-09-03 11:38 | 2026-09-03 11:38 | 2026-09-03 11:38 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 7.7600 | 7.7400 | 7.7600 | 772.5200 | 250648.00 | 250648.00 | 0.00 | 323 | 11 | 552 | 4320 | 0.127777777777778 | 0.130074861020044 | 0.130074861020044 | false | false | false | true | false | |||||||||||||||
| 4993a8cb-cd3d-493e-9de6-93a209cbf6ff | 2026-08-31 14:35 | 2026-08-31 14:35 | 2026-08-31 14:35 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 11.5700 | 11.5700 | 11.6900 | 766.0500 | 208260.00 | 0.00 | 208260.00 | 180 | 6 | 313 | 4364 | 0.0717231897341888 | 0.125498761586438 | 0.125498761586438 | false | false | false | true | false | |||||||||||||||
| 590fd1d7-6e6f-4add-ab1c-54b0ed9248b8 | 2026-08-28 11:03 | 2026-08-28 11:03 | 2026-08-28 11:03 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 7.4000 | 7.4000 | 7.4300 | 775.0100 | 566840.00 | 0.00 | 566840.00 | 766 | 14 | 1615 | 3326 | 0.485568250150331 | 0.123378100219511 | 0.123436991128796 | false | false | false | true | false | |||||||||||||||
| f1c029ae-c83d-4b8b-98ac-2f676e0ca47d | 2026-08-28 11:01 | 2026-08-28 11:01 | 2026-08-28 11:01 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 7.3500 | 7.3500 | 7.3700 | 775.1799 | 109515.00 | 0.00 | 109515.00 | 149 | 8 | 843 | 3326 | 0.253457606734817 | 0.123749571158109 | 0.123749571158109 | false | false | false | true | false | |||||||||||||||
| 43bf92ce-bc4f-4eff-8432-3d2b43f52e27 | 2026-08-27 13:25 | 2026-08-27 13:25 | 2026-08-27 13:25 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 9.1000 | 9.1000 | 9.1200 | 772.0700 | 351260.00 | 0.00 | 351260.00 | 386 | 19 | 457 | 2884 | 0.158460471567268 | 0.125818924969941 | 0.125818924969941 | false | false | false | true | false | |||||||||||||||
| 1ae16cbb-93b0-4814-a4ba-1ce0d1e29f94 | 2026-08-20 11:06 | 2026-08-20 11:06 | 2026-08-20 11:06 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 13.1000 | 13.0900 | 13.1700 | 767.2401 | 222677.00 | 0.00 | 222677.00 | 170 | 5 | 1608 | 3678 | 0.437194127243067 | 0.130482702342853 | 0.130599230389324 | false | false | false | true | false | |||||||||||||||
| cd2100c8-37f7-4ad3-9f65-af77116f7ba4 | 2026-08-20 11:04 | 2026-08-20 11:04 | 2026-08-20 11:04 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 12.6400 | 12.5700 | 12.7000 | 768.0950 | 126400.00 | 72048.00 | 54352.00 | 100 | 6 | 1256 | 3678 | 0.341489940184883 | 0.130570380271379 | 0.130570380271379 | false | false | false | true | false | |||||||||||||||
| 6e736442-3473-4b11-9bdd-d691ee9999b9 | 2026-08-20 10:51 | 2026-08-20 10:51 | 2026-08-20 10:51 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 13.3800 | 13.3500 | 13.4500 | 766.6500 | 401400.00 | 0.00 | 401400.00 | 300 | 7 | 348 | 3678 | 0.0946166394779772 | 0.130110669974 | 0.130110669974 | false | false | false | true | false | |||||||||||||||
| fabeae78-99c6-47e2-be8c-eed8bf555a0f | 2026-08-19 10:01 | 2026-08-19 10:01 | 2026-08-19 10:01 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 11.9800 | 11.9300 | 11.9900 | 769.8200 | 104213.00 | 104213.00 | 0.00 | 87 | 6 | 1112 | 4300 | 0.258604651162791 | 0.131402161972736 | 0.131515741693567 | false | false | false | true | false | |||||||||||||||
| 96c67164-9095-4e03-beff-16d1f8ce6a4f | 2026-08-17 15:40 | 2026-08-17 15:40 | 2026-08-17 15:40 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 10.9300 | 10.9100 | 10.9500 | 773.0100 | 233902.00 | 148648.00 | 14209.00 | 214 | 14 | 1597 | 3174 | 0.503150598613737 | 0.133624090513495 | 0.133624090513495 | false | false | false | true | ||||||||||||||||
| e008c490-bf0d-4f7a-8c8d-ec260373a228 | 2026-08-17 15:39 | 2026-08-17 15:39 | 2026-08-17 15:39 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 10.9200 | 10.9200 | 10.9300 | 773.0200 | 501228.00 | 0.00 | 501228.00 | 459 | 35 | 1369 | 3174 | 0.431316950220542 | 0.133539208984181 | 0.133564440362972 | true | false | false | true | false | |||||||||||||||
| 20f700c2-3b2f-4378-b9c5-3e8d6ac2f2be | 2026-08-17 15:39 | 2026-08-17 15:39 | 2026-08-17 15:39 | SPY | SPY260918P00773000 | put | 773.0000 | 2026-09-18 | 10.9200 | 10.9200 | 10.9400 | 773.0050 | 255528.00 | 0.00 | 255528.00 | 234 | 18 | 910 | 3174 | 0.286704473850032 | 0.133488737021422 | 0.133488737021422 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 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-31T19:01:22.528333Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T17:46:53.178792Z"} |
| 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:16:49.821442Z"} |
| 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 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 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-17T19:59:29.758034Z"} |
| 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-17T19:59:29.758034Z"} |
| 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-17T19:59:29.758034Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |