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_alerts425,429 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 |
|---|
| 2c270ccc-3155-452c-b6ff-a833afdbf67c | 2026-08-26 09:35 | 2026-08-26 09:34 | 2026-08-26 09:34 | SOFI | SOFI260828C00018000 | call | 18.0000 | 2026-08-28 | 1.2200 | 1.1700 | 1.2500 | 19.1350 | 12206.00 | 12206.00 | 0.00 | 100 | 7 | 217 | 9744 | 0.0222701149425287 | 0.876975772864823 | 0.786921395064699 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 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 |
| 6110f131-6c81-40b9-b293-7c4db9cbdfc5 | 2026-08-25 14:37 | 2026-08-25 14:36 | 2026-08-25 14:36 | SOFI | SOFI260918C00020000 | call | 20.0000 | 2026-09-18 | 0.5100 | 0.5100 | 0.5400 | 18.7400 | 16137.00 | 0.00 | 16137.00 | 316 | 11 | 19243 | 47235 | 0.407388588970043 | 0.517622342801195 | 0.506269883542549 | true | false | false | true | ||||||||||||||||
| 864a0ef5-5f06-4932-b48c-e53b107534e7 | 2026-08-25 12:21 | 2026-08-25 12:21 | 2026-08-25 12:21 | SOFI | SOFI260918C00020000 | call | 20.0000 | 2026-09-18 | 0.5400 | 0.5300 | 0.5500 | 18.7750 | 33092.00 | 8360.00 | 20304.00 | 610 | 66 | 15895 | 47235 | 0.33650894463851 | 0.521066574456036 | 0.516450242065411 | false | false | false | true | ||||||||||||||||
| 0b964f88-b3c4-4690-985e-121a22468e3f | 2026-08-25 12:13 | 2026-08-25 12:12 | 2026-08-25 12:12 | SOFI | SOFI271217C00020000 | call | 20.0000 | 2027-12-17 | 5.0900 | 5.0000 | 5.1500 | 18.8150 | 35600.00 | 32030.00 | 3570.00 | 70 | 6 | 113 | 17858 | 0.00632769627057901 | 0.609589266604919 | 0.607124396828731 | false | false | false | true | ||||||||||||||||
| 8016a564-2666-477c-8edf-13373b1ca175 | 2026-08-25 11:52 | 2026-08-25 11:52 | 2026-08-25 11:52 | SOFI | SOFI270319C00020000 | call | 20.0000 | 2027-03-19 | 2.9600 | 2.8700 | 3.0500 | 18.7950 | 23686.00 | 1782.00 | 0.00 | 80 | 5 | 164 | 11296 | 0.0145184135977337 | 0.584888287476119 | 0.584888287476119 | false | false | false | true | ||||||||||||||||
| a9a312c0-35ae-4d29-9bbc-bd59795affeb | 2026-08-25 11:00 | 2026-08-25 10:59 | 2026-08-25 10:59 | SOFI | SOFI260918C00020000 | call | 20.0000 | 2026-09-18 | 0.5800 | 0.5800 | 0.5900 | 18.8550 | 13429.00 | 5251.00 | 8178.00 | 230 | 54 | 7648 | 47235 | 0.16191383507992 | 0.528445721164825 | 0.528445721164825 | false | false | false | true | ||||||||||||||||
| d7c02166-8902-454c-b392-4c1d5d51e1cf | 2026-08-25 09:37 | 2026-08-25 09:37 | 2026-08-25 09:37 | SOFI | SOFI260918C00020000 | call | 20.0000 | 2026-09-18 | 0.4200 | 0.3900 | 0.4200 | 18.3999 | 18119.00 | 18119.00 | 0.00 | 436 | 21 | 2360 | 47235 | 0.0499629512014396 | 0.517351943802241 | 0.510291594146086 | false | false | false | true | ||||||||||||||||
| 99ed52a4-27b8-4397-a764-7019eec762f4 | 2026-08-24 09:35 | 2026-08-24 09:35 | 2026-08-24 09:35 | SOFI | SOFI260918C00020000 | call | 20.0000 | 2026-09-18 | 0.5200 | 0.5100 | 0.5300 | 18.6450 | 96377.00 | 60027.00 | 26418.00 | 1858 | 120 | 2375 | 41744 | 0.0568944039862016 | 0.523481414619465 | 0.52480358917682 | true | false | false | true | ||||||||||||||||
| 157bf341-6cf6-4896-9b60-a90bb6f02777 | 2026-08-21 10:42 | 2026-08-21 10:42 | 2026-08-21 10:42 | SOFI | SOFI260828P00019000 | put | 19.0000 | 2026-08-28 | 0.7000 | 0.6700 | 0.7100 | 18.7000 | 14048.00 | 14048.00 | 0.00 | 200 | 6 | 3360 | 4672 | 0.719178082191781 | 0.533472491814753 | 0.523650786159707 | false | false | false | true | ||||||||||||||||
| f16ca568-38a7-4466-a5cf-4d3f13836ff2 | 2026-08-21 10:30 | 2026-08-21 10:30 | 2026-08-21 10:30 | SOFI | SOFI261016C00020000 | call | 20.0000 | 2026-10-16 | 1.1500 | 1.1200 | 1.1600 | 18.9650 | 131910.00 | 11385.00 | 63370.00 | 1150 | 48 | 2986 | 17650 | 0.169178470254957 | 0.51793136236697 | 0.513765557843888 | true | false | false | true | ||||||||||||||||
| 950656e4-716b-4582-b805-ee49fe346d12 | 2026-08-21 10:10 | 2026-08-21 10:10 | 2026-08-21 10:10 | SOFI | SOFI261016C00022000 | call | 22.0000 | 2026-10-16 | 0.6300 | 0.6300 | 0.6500 | 19.0250 | 22100.00 | 0.00 | 18900.00 | 350 | 15 | 951 | 5881 | 0.16170719265431 | 0.533509107937709 | 0.528994886900219 | false | false | false | true | ||||||||||||||||
| b9878c1a-904b-4437-9472-db29757a0689 | 2026-08-21 10:07 | 2026-08-21 10:07 | 2026-08-21 10:07 | SOFI | SOFI260828P00019000 | put | 19.0000 | 2026-08-28 | 0.5700 | 0.5500 | 0.5800 | 18.9950 | 22497.00 | 22497.00 | 0.00 | 392 | 32 | 1883 | 4672 | 0.403039383561644 | 0.557153147687096 | 0.547614762144241 | false | false | false | true | ||||||||||||||||
| 3a7db3e2-a2a7-4f88-8dd7-a246f69b4c07 | 2026-08-21 09:58 | 2026-08-21 09:58 | 2026-08-21 09:58 | SOFI | SOFI260911C00020000 | call | 20.0000 | 2026-09-11 | 0.6200 | 0.5700 | 0.6200 | 19.0400 | 12375.00 | 12375.00 | 0.00 | 200 | 10 | 609 | 4535 | 0.134288864388093 | 0.543360020522593 | 0.543360020522593 | true | false | false | true | ||||||||||||||||
| 0c85a9c5-6ecd-4919-a8e5-4daa528ada38 | 2026-08-20 12:09 | 2026-08-20 12:08 | 2026-08-20 12:08 | SOFI | SOFI260918C00020000 | call | 20.0000 | 2026-09-18 | 0.3200 | 0.3100 | 0.3200 | 17.8450 | 34227.00 | 27872.00 | 6355.00 | 1076 | 59 | 5064 | 38866 | 0.130293830082849 | 0.496061797295999 | 0.496061797295999 | false | false | false | true | ||||||||||||||||
| 849d8348-f358-4396-9456-fbcfee53a253 | 2026-08-20 09:39 | 2026-08-20 09:39 | 2026-08-20 09:39 | SOFI | SOFI261016C00019000 | call | 19.0000 | 2026-10-16 | 1.1700 | 1.1700 | 1.2100 | 18.3600 | 122500.00 | 0.00 | 122500.00 | 1047 | 12 | 1979 | 8716 | 0.227053694355209 | 0.487210541061378 | 0.483751100356375 | false | false | false | true | ||||||||||||||||
| 019ed857-bc71-47cc-b098-4c3783ffb159 | 2026-08-20 09:39 | 2026-08-20 09:39 | 2026-08-20 09:39 | SOFI | SOFI261016C00019000 | call | 19.0000 | 2026-10-16 | 1.1700 | 1.1700 | 1.2100 | 18.3600 | 66960.00 | 0.00 | 66960.00 | 571 | 17 | 889 | 8716 | 0.101996328591097 | 0.486380544269688 | 0.487210541061378 | false | false | false | true | ||||||||||||||||
| 1376d670-2ab6-47ed-927c-c17f336629bf | 2026-08-20 09:31 | 2026-08-20 09:30 | 2026-08-20 09:30 | SOFI | SOFI280616C00040000 | call | 40.0000 | 2028-06-16 | 2.4300 | 2.2400 | 2.5100 | 18.7000 | 36488.00 | 36488.00 | 0.00 | 150 | 5 | 153 | 9584 | 0.0159641068447412 | 0.627134792405745 | 0.612092575843566 | false | false | false | true | ||||||||||||||||
| b34a652c-71b6-4233-b336-1399f0606dcc | 2026-08-19 13:34 | 2026-08-19 13:34 | 2026-08-19 13:34 | SOFI | SOFI260828C00017000 | call | 17.0000 | 2026-08-28 | 1.5700 | 1.4500 | 1.5700 | 18.4400 | 15673.00 | 15673.00 | 0.00 | 100 | 27 | 461 | 1634 | 0.282129742962056 | 0.513162111298258 | 0.513162111298258 | false | false | false | true | ||||||||||||||||
| f94a3d26-5127-4d74-8635-6a9081ddb814 | 2026-08-19 10:58 | 2026-08-19 10:58 | 2026-08-19 10:58 | SOFI | SOFI260918C00019000 | call | 19.0000 | 2026-09-18 | 0.7900 | 0.7900 | 0.8100 | 18.4950 | 18329.00 | 0.00 | 18329.00 | 232 | 9 | 1441 | 12377 | 0.116425628181304 | 0.47092067347219 | 0.466164462319811 | false | false | false | true | ||||||||||||||||
| fc2537ce-224b-48c8-83cf-880089d56741 | 2026-08-18 10:04 | 2026-08-18 10:04 | 2026-08-18 10:04 | SOFI | SOFI261218C00023000 | call | 23.0000 | 2026-12-18 | 0.9400 | 0.8700 | 1.0000 | 18.0950 | 539892.00 | 524050.00 | 12176.00 | 5744 | 86 | 5799 | 7289 | 0.795582384414872 | 0.565919839665565 | 0.562639276189224 | false | false | false | true | ||||||||||||||||
| bc8cf61b-1481-4f1f-9806-d35f1dd4fa20 | 2026-08-18 09:30 | 2026-08-18 09:30 | 2026-08-18 09:30 | SOFI | SOFI260918C00020000 | call | 20.0000 | 2026-09-18 | 0.3700 | 0.3500 | 0.3800 | 18.0399 | 43215.00 | 33300.00 | 9915.00 | 1171 | 53 | 1456 | 35904 | 0.0405525846702317 | 0.485606532154758 | 0.480289847626134 | false | false | false | true | ||||||||||||||||
| e7998afd-f83c-4a96-b7c1-982d1fb35306 | 2026-08-17 10:25 | 2026-08-17 10:25 | 2026-08-17 10:25 | SOFI | SOFI270115C00024000 | call | 24.0000 | 2027-01-15 | 1.0400 | 1.0400 | 1.1100 | 18.3850 | 104100.00 | 0.00 | 104100.00 | 1000 | 13 | 1013 | 2991 | 0.3386827148111 | 0.554597080137611 | 0.554597080137611 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-25T18:54:14.733334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-25T16:29:52.792110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-25T16:29:52.792110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-25T16:00:53.835343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-25T15:00:40.665909Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-25T13:41:46.514863Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:38:06.174043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:50:41.871179Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-20T13:35:56.061771Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:01:13.058297Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |