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_alerts609,118 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 |
|---|
| 5b31c3d3-d867-42c8-a69c-dc52abc2a3b1 | 2026-08-19 11:08 | 2026-08-19 11:08 | 2026-08-19 11:08 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.1400 | 0.1300 | 0.1500 | 18.5400 | 19642.00 | 18592.00 | 1050.00 | 1403 | 54 | 4193 | 20051 | 0.209116752281682 | 0.503435846452767 | 0.503435846452767 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22796216219.00 | 2026-10-27 | 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 |
| f12a1f80-53f9-4501-998e-aa3d564109d9 | 2026-08-20 14:02 | 2026-08-20 14:02 | 2026-08-20 14:02 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.0600 | 0.0600 | 0.0700 | 17.9250 | 11586.00 | 0.00 | 11586.00 | 1931 | 42 | 5602 | 24381 | 0.229769082482261 | 0.538765880900479 | 0.538765880900479 | false | false | false | true | ||||||||||||||||
| 78115166-8281-4eed-b49b-4d9ce3046503 | 2026-08-21 09:51 | 2026-08-21 09:50 | 2026-08-21 09:50 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.1800 | 0.1700 | 0.1900 | 18.7850 | 11124.00 | 11106.00 | 0.00 | 618 | 24 | 3623 | 25700 | 0.140972762645914 | 0.558785900297713 | 0.558785900297713 | false | false | false | true | ||||||||||||||||
| bef3e354-e201-4f65-9a61-346ecf2c89ee | 2026-08-21 09:58 | 2026-08-21 09:57 | 2026-08-21 09:57 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.2500 | 0.2400 | 0.2600 | 19.0001 | 15200.00 | 12700.00 | 0.00 | 608 | 31 | 7537 | 25700 | 0.293268482490272 | 0.576790740887862 | 0.578332207745217 | false | false | false | true | ||||||||||||||||
| 7881a18f-834f-4315-b5cb-df4ed182aca4 | 2026-08-21 10:12 | 2026-08-21 10:11 | 2026-08-21 10:11 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.2500 | 0.2400 | 0.2500 | 19.0250 | 10000.00 | 10000.00 | 0.00 | 400 | 10 | 10554 | 25700 | 0.410661478599222 | 0.570488883793635 | 0.570488883793635 | false | false | false | true | ||||||||||||||||
| bf686b25-0b28-4939-8164-02cf5e95fa62 | 2026-08-21 15:12 | 2026-08-21 15:12 | 2026-08-21 15:12 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.1700 | 0.1600 | 0.1700 | 18.9250 | 12138.00 | 12138.00 | 0.00 | 714 | 18 | 24209 | 25700 | 0.941984435797665 | 0.505757442713013 | 0.505757442713013 | false | false | false | true | ||||||||||||||||
| 89364d72-6d35-4dfe-bfee-b8069173a9b1 | 2026-08-21 15:25 | 2026-08-21 15:25 | 2026-08-21 15:25 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.1700 | 0.1600 | 0.1700 | 18.9279 | 10982.00 | 10982.00 | 0.00 | 646 | 29 | 27846 | 25700 | 1.08350194552529 | 0.504921370547341 | 0.504921370547341 | false | false | false | true | ||||||||||||||||
| de6cd35f-eb23-4887-a831-64153264577a | 2026-08-24 09:51 | 2026-08-24 09:51 | 2026-08-24 09:51 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.1000 | 0.0900 | 0.1000 | 18.7375 | 12210.00 | 12210.00 | 0.00 | 1221 | 35 | 4011 | 33024 | 0.121457122093023 | 0.609768870167169 | 0.609768870167169 | true | false | false | true | ||||||||||||||||
| 15ff11d8-1f1d-41ab-86da-48eb29302aeb | 2026-08-24 09:51 | 2026-08-24 09:51 | 2026-08-24 09:51 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.1000 | 0.0900 | 0.1000 | 18.7700 | 12420.00 | 12420.00 | 0.00 | 1242 | 5 | 5403 | 33024 | 0.163608284883721 | 0.598792726707999 | 0.598792726707999 | false | false | false | true | ||||||||||||||||
| aebbe932-405f-4508-8b4d-364f972d7318 | 2026-08-24 09:55 | 2026-08-24 09:55 | 2026-08-24 09:55 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.0900 | 0.0900 | 0.1000 | 18.6500 | 10782.00 | 0.00 | 10782.00 | 1198 | 13 | 8242 | 33024 | 0.249576065891473 | 0.617504644300885 | 0.617504644300885 | false | false | false | true | ||||||||||||||||
| 91c18c8a-d078-477c-835e-bf3a5a62767f | 2026-08-24 09:55 | 2026-08-24 09:55 | 2026-08-24 09:55 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.0900 | 0.0900 | 0.1000 | 18.6550 | 11718.00 | 0.00 | 11718.00 | 1302 | 31 | 7044 | 33024 | 0.213299418604651 | 0.615861797841566 | 0.615861797841566 | false | false | false | true | ||||||||||||||||
| ae9ca1e1-986c-4dd0-9076-2a1bc38423e2 | 2026-08-25 14:04 | 2026-08-25 14:04 | 2026-08-25 14:04 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.0900 | 0.0700 | 0.0900 | 18.0000 | 18000.00 | 18000.00 | 0.00 | 2000 | 20 | 16312 | 35097 | 0.46476906858136 | 0.613986506600087 | 0.613986506600087 | false | false | false | true | ||||||||||||||||
| cb4a3da2-3b5b-42d8-a542-5ea625984466 | 2026-08-26 09:36 | 2026-08-26 09:36 | 2026-08-26 09:36 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.1100 | 0.1000 | 0.1100 | 19.0865 | 18623.00 | 18623.00 | 0.00 | 1693 | 27 | 3576 | 43790 | 0.081662480018269 | 0.720597718849897 | 0.720597718849897 | false | false | false | true | ||||||||||||||||
| 4c2f91a6-ef44-424d-98dc-8673cdfc60ab | 2026-08-26 09:36 | 2026-08-26 09:36 | 2026-08-26 09:36 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.1100 | 0.1000 | 0.1100 | 19.0800 | 20658.00 | 20658.00 | 0.00 | 1878 | 14 | 5454 | 43790 | 0.124548983786253 | 0.723874991875848 | 0.723874991875848 | false | false | false | true | ||||||||||||||||
| fe75bbc4-834e-4954-b4db-934efbe43282 | 2026-08-26 09:38 | 2026-08-26 09:38 | 2026-08-26 09:38 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.1300 | 0.1200 | 0.1300 | 19.1250 | 11570.00 | 11570.00 | 0.00 | 890 | 27 | 9354 | 43790 | 0.213610413336378 | 0.751929397040501 | 0.749990414022521 | false | false | false | true | ||||||||||||||||
| b74bbb09-29ba-442b-9c2a-55610efd490e | 2026-08-26 09:38 | 2026-08-26 09:38 | 2026-08-26 09:38 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.1300 | 0.1200 | 0.1300 | 19.1250 | 44148.00 | 44148.00 | 0.00 | 3396 | 5 | 12852 | 43790 | 0.293491664763645 | 0.752610398467921 | 0.749990414022521 | false | false | false | true | ||||||||||||||||
| 797e82d4-213e-4028-80cf-197205c89306 | 2026-08-26 10:20 | 2026-08-26 10:20 | 2026-08-26 10:20 | SOFI | SOFI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.0800 | 0.0800 | 0.0900 | 18.9601 | 107200.00 | 0.00 | 107200.00 | 13400 | 28 | 31779 | 43790 | 0.7257136332496 | 0.693359134503032 | 0.700325741994791 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| 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 |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22796216219.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |