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_alerts658,639 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 |
|---|
| 09439525-a7a0-4cc7-b223-ac37c6ca576a | 2026-08-20 14:49 | 2026-08-20 14:49 | 2026-08-20 14:49 | NOK | NOK260918C00011000 | call | 11.0000 | 2026-09-18 | 0.3900 | 0.3900 | 0.4100 | 10.1594 | 117117.00 | 0.00 | 117117.00 | 3003 | 77 | 8410 | 60707 | 0.138534271171364 | 0.609907933600938 | 0.609907933600938 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Technology | 55412613066.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5c8e2a28-73c3-41c8-9567-d9839deb537d | 2026-08-27 11:42 | 2026-08-27 11:42 | 2026-08-27 11:42 | NOK | NOK260918C00011000 | call | 11.0000 | 2026-09-18 | 0.3900 | 0.3700 | 0.4000 | 10.4500 | 117273.00 | 111423.00 | 1404.00 | 3007 | 93 | 6207 | 72476 | 0.0856421436061593 | 0.590919819828373 | 0.588921851978495 | true | false | false | true | ||||||||||||||||
| 9bff718a-a540-4df6-b955-14ba73b1e5f7 | 2026-08-27 11:42 | 2026-08-27 11:42 | 2026-08-27 11:42 | NOK | NOK260918C00011000 | call | 11.0000 | 2026-09-18 | 0.4000 | 0.3800 | 0.4000 | 10.4500 | 57840.00 | 57520.00 | 0.00 | 1446 | 74 | 8093 | 72476 | 0.111664551023787 | 0.597026737723608 | 0.599036350313603 | true | false | false | true | ||||||||||||||||
| 30bd32b1-2ce2-42d6-9468-6e9215a76c0f | 2026-08-27 11:47 | 2026-08-27 11:46 | 2026-08-27 11:46 | NOK | NOK260918C00011000 | call | 11.0000 | 2026-09-18 | 0.4000 | 0.3800 | 0.4000 | 10.4650 | 66000.00 | 66000.00 | 0.00 | 1650 | 32 | 9861 | 72476 | 0.136058833268944 | 0.593002221479457 | 0.593002221479457 | true | false | false | true | ||||||||||||||||
| b99078b2-51f0-47a2-8e71-edf1d0929806 | 2026-08-27 11:59 | 2026-08-27 11:53 | 2026-08-27 11:59 | NOK | NOK260918C00011000 | call | 11.0000 | 2026-09-18 | 0.4400 | 0.0000 | 0.0000 | 10.5750 | 272297.00 | 27921.00 | 0.00 | 6235 | 34 | 18109 | 72476 | 0.249862023290469 | 0 | 0 | true | true | false | true | ||||||||||||||||
| 8b7e8bc6-d62d-4c4f-9f7b-ec5d40658e1c | 2026-09-08 11:17 | 2026-09-08 11:17 | 2026-09-08 11:17 | NOK | NOK260918C00011000 | call | 11.0000 | 2026-09-18 | 0.3400 | 0.3000 | 0.3500 | 10.6800 | 69856.00 | 68238.00 | 1618.00 | 2056 | 32 | 6610 | 78569 | 0.0841298731051687 | 0.67231873604032 | 0.669281730981283 | true | false | false | true | ||||||||||||||||
| e90cd0ea-7073-4d22-9adb-5783d7d89bc4 | 2026-09-09 10:04 | 2026-09-09 10:04 | 2026-09-09 10:04 | NOK | NOK260918C00011000 | call | 11.0000 | 2026-09-18 | 0.4800 | 0.4600 | 0.4800 | 11.0300 | 96000.00 | 96000.00 | 0.00 | 2000 | 5 | 13463 | 120176 | 0.112027359872187 | 0.666742190516703 | 0.666664503985222 | false | false | false | true | ||||||||||||||||
| 34cd046b-070f-468c-8201-eb00460b0a4f | 2026-09-11 15:43 | 2026-09-11 15:43 | 2026-09-11 15:43 | NOK | NOK260918C00011000 | call | 11.0000 | 2026-09-18 | 0.3700 | 0.3700 | 0.3900 | 11.0650 | 72594.00 | 0.00 | 72594.00 | 1962 | 16 | 13130 | 132522 | 0.0990778889542868 | 0.545179633963838 | 0.545179633963838 | false | false | false | true | ||||||||||||||||
| 9a7b9a95-bd09-4550-9fa3-0b5e91db1381 | 2026-09-11 15:43 | 2026-09-11 15:43 | 2026-09-11 15:43 | NOK | NOK260918C00011000 | call | 11.0000 | 2026-09-18 | 0.3600 | 0.3600 | 0.3800 | 11.0500 | 54396.00 | 0.00 | 54396.00 | 1511 | 32 | 15970 | 132522 | 0.120508292962678 | 0.542208978200698 | 0.542208978200698 | false | false | false | true | ||||||||||||||||
| eacc5777-ffa8-4094-af46-72b10e3d1534 | 2026-09-11 15:43 | 2026-09-11 15:43 | 2026-09-11 15:43 | NOK | NOK260918C00011000 | call | 11.0000 | 2026-09-18 | 0.3600 | 0.3600 | 0.3800 | 11.0550 | 62676.00 | 0.00 | 62676.00 | 1741 | 16 | 17911 | 132522 | 0.135154917674047 | 0.537725039353359 | 0.537725039353359 | false | false | false | true | ||||||||||||||||
| cd54d81f-ec32-49f2-b0a8-fd2ec8d62935 | 2026-09-11 15:43 | 2026-09-11 15:43 | 2026-09-11 15:43 | NOK | NOK260918C00011000 | call | 11.0000 | 2026-09-18 | 0.3600 | 0.3600 | 0.3800 | 11.0550 | 270000.00 | 0.00 | 270000.00 | 7500 | 21 | 25570 | 132522 | 0.192949095244563 | 0.537725039353359 | 0.537725039353359 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:07:33.804891Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| SweepsFollowedByFloor |
| 36cb34b2-bfec-40a0-b347-859cae1cf152 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:07:33.804891Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:11:22.686371Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |