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_alerts523,327 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 |
|---|
| 97adabd3-abfc-4809-b5f3-fec1c6f8a0d2 | 2026-09-28 10:58 | 2026-09-28 10:58 | 2026-09-28 10:58 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 21.6000 | 21.5000 | 21.8500 | 262.6040 | 28080.00 | 25920.00 | 2160.00 | 13 | 6 | 264 | 2813 | 0.0938499822253822 | 0.865451907749989 | 0.865451907749989 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 77422403443.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T15:01:52.060675Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 8e947c2f-4592-44bd-92f2-04155f1de41d | 2026-09-28 09:33 | 2026-09-28 09:33 | 2026-09-28 09:33 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 27.8100 | 27.3500 | 29.3500 | 274.8600 | 22245.00 | 5560.00 | 16685.00 | 8 | 8 | 16 | 2813 | 0.00568787771062922 | 0.884778800389273 | 0.884778800389273 | true | false | false | true | ||||||||||||||||
| ae8ea3db-dd23-4c17-b899-a8840b3ecaf9 | 2026-09-25 12:01 | 2026-09-25 12:01 | 2026-09-25 12:01 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 36.3300 | 35.2500 | 36.4500 | 290.6850 | 36330.00 | 36330.00 | 0.00 | 10 | 5 | 234 | 2798 | 0.0836311651179414 | 0.874711139375068 | 0.868075455049696 | false | false | false | true | ||||||||||||||||
| 92ae7904-354d-40bf-b795-c6aee53ca7da | 2026-09-25 11:58 | 2026-09-25 11:58 | 2026-09-25 11:58 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 35.0000 | 34.0500 | 35.3000 | 288.9800 | 28000.00 | 28000.00 | 0.00 | 8 | 5 | 223 | 2798 | 0.0796997855611151 | 0.862787028180688 | 0.862787028180688 | true | false | false | true | ||||||||||||||||
| 5d4deb6b-b1e7-4ff6-b87b-1f247b0093dd | 2026-09-25 10:03 | 2026-09-25 10:02 | 2026-09-25 10:02 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 33.9100 | 31.3000 | 34.0000 | 286.5000 | 77995.00 | 40735.00 | 37260.00 | 23 | 6 | 68 | 2798 | 0.0243030736240172 | 0.867344279450657 | 0.867344279450657 | true | false | false | true | ||||||||||||||||
| 2c413284-a088-422c-936e-711aef4661a2 | 2026-09-25 09:32 | 2026-09-25 09:32 | 2026-09-25 09:32 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 26.4900 | 24.2500 | 27.1000 | 272.6500 | 18540.00 | 13240.00 | 5300.00 | 7 | 5 | 9 | 2798 | 0.00321658327376698 | 0.859357022046679 | 0.853656785281585 | false | false | false | true | ||||||||||||||||
| 3d73a76d-7d8c-4317-b979-aa112f7fad39 | 2026-09-22 10:46 | 2026-09-22 10:46 | 2026-09-22 10:46 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 33.1300 | 32.7000 | 33.3000 | 280.6900 | 33125.00 | 19925.00 | 13200.00 | 10 | 6 | 754 | 2237 | 0.337058560572195 | 0.895769641485768 | 0.890216249542467 | false | false | false | true | ||||||||||||||||
| 79c80776-ddad-4126-bcce-7eaa1e64814b | 2026-09-22 10:07 | 2026-09-22 10:06 | 2026-09-22 10:06 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 31.4000 | 31.4000 | 32.8000 | 278.6600 | 62800.00 | 0.00 | 62800.00 | 20 | 6 | 515 | 2237 | 0.230219043361645 | 0.877153213240853 | 0.877153213240853 | false | false | false | true | ||||||||||||||||
| edf2ea3c-2358-47f0-be6d-259666655573 | 2026-09-21 11:16 | 2026-09-21 11:16 | 2026-09-21 11:16 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 32.3000 | 31.5000 | 32.3000 | 278.8600 | 35530.00 | 35530.00 | 0.00 | 11 | 7 | 757 | 2159 | 0.350625289485873 | 0.887307566847748 | 0.887307566847748 | true | false | false | true | ||||||||||||||||
| 656a94bb-1dbe-4445-abd7-ab4321593c78 | 2026-09-21 11:09 | 2026-09-21 11:09 | 2026-09-21 11:09 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 31.3500 | 31.3500 | 31.7500 | 276.0000 | 620730.00 | 0.00 | 620730.00 | 198 | 6 | 744 | 2159 | 0.344603983325614 | 0.887399244727156 | 0.887399244727156 | false | false | false | true | ||||||||||||||||
| 6d768694-dbf4-48c6-ae22-7f91c992e351 | 2026-09-09 09:47 | 2026-09-09 09:47 | 2026-09-09 09:47 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 37.2500 | 37.2500 | 39.9500 | 275.7605 | 134100.00 | 0.00 | 134100.00 | 36 | 11 | 109 | 2756 | 0.0395500725689405 | 0.940352835438627 | 0.940352835438627 | false | false | false | true | ||||||||||||||||
| cc443655-a42b-4112-9540-0089c37bf538 | 2026-09-08 12:53 | 2026-09-08 12:53 | 2026-09-08 12:53 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 42.1500 | 40.9000 | 42.1500 | 280.6550 | 63225.00 | 63225.00 | 0.00 | 15 | 6 | 842 | 2389 | 0.352448723315195 | 0.981084027072049 | 0.981084027072049 | false | false | false | true | ||||||||||||||||
| 309e7c78-2060-4a60-90e0-9a86f53cd685 | 2026-09-08 09:51 | 2026-09-08 09:51 | 2026-09-08 09:51 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 38.8300 | 37.4000 | 38.9000 | 276.2050 | 143670.00 | 143670.00 | 0.00 | 37 | 6 | 235 | 2389 | 0.0983675177898702 | 0.962680884839305 | 0.960649886363374 | true | false | false | true | ||||||||||||||||
| 9fb90f5a-6168-40f4-a6d5-87bbe006c955 | 2026-09-08 09:43 | 2026-09-08 09:43 | 2026-09-08 09:43 | BE | BE261120C00300000 | call | 300.0000 | 2026-11-20 | 36.0500 | 34.3500 | 36.9500 | 271.2500 | 191080.00 | 187470.00 | 3610.00 | 53 | 5 | 185 | 2389 | 0.0774382586856425 | 0.960457895482459 | 0.956854747113753 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 77422403443.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:34:45.644461Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 85030044790.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:02:23.613765Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 85030044790.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:59:16.361510Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 85030044790.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:04:05.801469Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 85030044790.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:33:47.828400Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 81445646989.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:48:37.826382Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 81445646989.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 80373567450.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:16:13.769524Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 80373567450.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:13:03.739619Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:11:09.796111Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |