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 |
|---|
| 5598b7b1-8d10-4278-a3a0-fddd940f2d8d | 2026-09-25 10:25 | 2026-09-25 10:25 | 2026-09-25 10:25 | CRCL | CRCL260925P00088000 | put | 88.0000 | 2026-09-25 | 0.4200 | 0.4200 | 0.5000 | 89.1600 | 16842.00 | 0.00 | 16842.00 | 401 | 51 | 2173 | 1040 | 2.08942307692308 | 0.988667287119665 | 0.988667287119665 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 20886981910.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T14:26:29.670335Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 6512f674-0e65-44f8-a6a0-fb03d41b3cf8 | 2026-09-25 10:07 | 2026-09-25 10:07 | 2026-09-25 10:07 | CRCL | CRCL260925P00088000 | put | 88.0000 | 2026-09-25 | 0.7800 | 0.7500 | 0.9100 | 88.0000 | 21823.00 | 0.00 | 21823.00 | 279 | 38 | 1575 | 1040 | 1.51442307692308 | 1.0745053928353 | 1.11335097728963 | true | false | false | true | ||||||||||||||||
| 150fd7df-9ca7-44d4-adb4-335d35e81f1e | 2026-09-25 10:05 | 2026-09-25 10:04 | 2026-09-25 10:04 | CRCL | CRCL260925P00088000 | put | 88.0000 | 2026-09-25 | 0.9500 | 0.9400 | 0.9500 | 88.0000 | 60230.00 | 60230.00 | 0.00 | 634 | 14 | 1263 | 1040 | 1.21442307692308 | 1.13199085453984 | 1.13199085453984 | false | false | false | true | ||||||||||||||||
| d4acf64e-846f-4a5f-bf3e-530c18de6d46 | 2026-09-25 09:42 | 2026-09-25 09:42 | 2026-09-25 09:42 | CRCL | CRCL260925P00088000 | put | 88.0000 | 2026-09-25 | 0.5700 | 0.4500 | 0.5700 | 89.7650 | 10773.00 | 10773.00 | 0.00 | 189 | 40 | 205 | 1040 | 0.197115384615385 | 1.32843673464878 | 1.32843673464878 | true | false | false | true | ||||||||||||||||
| 5e8f21fb-4ddd-4f00-9773-a78f87dbf038 | 2026-09-21 13:35 | 2026-09-21 13:35 | 2026-09-21 13:35 | CRCL | CRCL260925P00088000 | put | 88.0000 | 2026-09-25 | 1.0400 | 0.9500 | 1.0400 | 94.0000 | 20696.00 | 20696.00 | 0.00 | 199 | 6 | 434 | 461 | 0.941431670281996 | 0.840851857879658 | 0.840851857879658 | false | false | false | true | ||||||||||||||||
| 9c60eabf-6ad5-43f3-a08b-d2ca8bb493a4 | 2026-09-17 13:09 | 2026-09-17 13:09 | 2026-09-17 13:09 | CRCL | CRCL260925P00088000 | put | 88.0000 | 2026-09-25 | 5.0000 | 4.8000 | 5.1000 | 85.6700 | 39000.00 | 24000.00 | 0.00 | 78 | 5 | 181 | 262 | 0.690839694656489 | 0.747676990843225 | 0.735104547445292 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 20886981910.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:09:41.700516Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 20886981910.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:05:23.720155Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 20886981910.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:43:32.172352Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22175403603.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 19969362817.00 |
| 2026-11-11 |
| unknown |
| — |
| 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 |