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 |
|---|
| d4135f2d-c814-4707-98bc-19d4d86adc26 | 2026-09-17 10:06 | 2026-09-17 10:06 | 2026-09-17 10:06 | APLD | APLD260918P00028000 | put | 28.0000 | 2026-09-18 | 3.0500 | 2.0000 | 3.0500 | 25.0400 | 152500.00 | 152500.00 | 0.00 | 500 | 14 | 508 | 3178 | 0.159848961611076 | 1.59552481947223 | 1.59552481947223 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7688955175.00 | 2026-10-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 7af2b98a-1b7f-4b9e-bdb3-78f2bf757eac | 2026-09-09 13:59 | 2026-09-09 13:59 | 2026-09-09 13:59 | APLD | APLD260918P00028000 | put | 28.0000 | 2026-09-18 | 1.7200 | 1.6700 | 1.7200 | 27.2900 | 18232.00 | 18232.00 | 0.00 | 106 | 22 | 387 | 3304 | 0.117130750605327 | 0.78083224795848 | 0.78083224795848 | true | false | false | true | ||||||||||||||||
| f16cfbed-d61a-46a1-af0d-df2d17eedc52 | 2026-09-01 10:10 | 2026-09-01 10:10 | 2026-09-01 10:10 | APLD | APLD260918P00028000 | put | 28.0000 | 2026-09-18 | 4.0300 | 3.9500 | 4.1000 | 24.4050 | 23374.00 | 23374.00 | 0.00 | 58 | 5 | 108 | 3285 | 0.0328767123287671 | 0.756957742933457 | 0.756957742933457 | false | false | false | true | ||||||||||||||||
| e5a4c944-fe90-4008-8abe-7e11a0bfeb6c | 2026-08-28 12:34 | 2026-08-28 12:34 | 2026-08-28 12:34 | APLD | APLD260918P00028000 | put | 28.0000 | 2026-09-18 | 3.4500 | 3.4000 | 3.5000 | 25.4150 | 14490.00 | 11730.00 | 2760.00 | 42 | 8 | 170 | 3283 | 0.0517819067925678 | 0.75826130684664 | 0.75826130684664 | false | false | false | true | ||||||||||||||||
| bfef1429-831b-433b-a6d6-6fc8b02950db | 2026-08-27 10:13 | 2026-08-27 10:13 | 2026-08-27 10:13 | APLD | APLD260918P00028000 | put | 28.0000 | 2026-09-18 | 2.4000 | 2.4000 | 2.4600 | 27.5100 | 22563.00 | 0.00 | 22563.00 | 94 | 8 | 94 | 3303 | 0.0284589766878595 | 0.804335669934607 | 0.808047886402385 | false | false | false | true | ||||||||||||||||
| 838926bf-ced2-46c1-9324-46fab200947f | 2026-08-25 14:20 | 2026-08-25 14:20 | 2026-08-25 14:20 | APLD | APLD260918P00028000 | put | 28.0000 | 2026-09-18 | 2.1100 | 2.0500 | 2.1400 | 28.0000 | 63150.00 | 63150.00 | 0.00 | 300 | 8 | 534 | 3280 | 0.16280487804878 | 0.848717376353446 | 0.848717376353446 | false | false | false | true | ||||||||||||||||
| 2c169b04-7024-4da3-8bf0-81f1cb731dec | 2026-08-25 13:18 | 2026-08-25 13:18 | 2026-08-25 13:18 | APLD | APLD260918P00028000 | put | 28.0000 | 2026-09-18 | 2.1700 | 2.1600 | 2.2300 | 28.4750 | 23436.00 | 0.00 | 23436.00 | 108 | 8 | 230 | 3280 | 0.0701219512195122 | 0.844854399426372 | 0.844854399426372 | true | false | false | true | ||||||||||||||||
| 2293ac2e-085d-4a53-88eb-978b19437b2e | 2026-08-19 11:16 | 2026-08-19 11:16 | 2026-08-19 11:16 | APLD | APLD260918P00028000 | put | 28.0000 | 2026-09-18 | 2.9300 | 2.8700 | 3.1000 | 27.4900 | 22850.00 | 16408.00 | 6442.00 | 78 | 11 | 112 | 3176 | 0.035264483627204 | 0.858525673800678 | 0.858525673800678 | false | false | false | true | ||||||||||||||||
| dbbf55f9-269c-4cb4-86e4-9dbb509c9495 | 2026-08-18 14:16 | 2026-08-18 14:15 | 2026-08-18 14:15 | APLD | APLD260918P00028000 | put | 28.0000 | 2026-09-18 | 2.5000 | 2.5000 | 2.5900 | 28.4550 | 14500.00 | 0.00 | 14500.00 | 58 | 7 | 143 | 3053 | 0.046839174582378 | 0.845814816589867 | 0.845814816589867 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:20:18.853903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T17:31:01.749779Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |