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_alerts474,253 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 |
|---|
| 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 |
|---|
| e6bc2703-d47b-46cc-9131-e987dfb26d14 | 2026-09-25 09:40 | 2026-09-25 09:40 | 2026-09-25 09:40 | NOK | NOK280121C00015000 | call | 15.0000 | 2028-01-21 | 1.7600 | 1.7600 | 1.8400 | 10.3900 | 15875.00 | 0.00 | 15875.00 | 90 | 29 | 104 | 43602 | 0.00238521168753727 | 0.601750420843211 | 0.601750420843211 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 59661870441.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T13:41:37.814256Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 7567c266-86ca-4976-9970-6f0f5d5090f0 | 2026-09-24 11:30 | 2026-09-24 11:30 | 2026-09-24 11:30 | NOK | NOK280121C00015000 | call | 15.0000 | 2028-01-21 | 1.7200 | 1.7000 | 1.7300 | 10.2525 | 22906.00 | 5190.00 | 17716.00 | 133 | 20 | 192 | 43469 | 0.00441694080839219 | 0.60617179668666 | 0.60403680056048 | false | false | false | |||||||||||||||||
| 736deb1b-ede0-44bd-8d0a-dbc362479ee1 | 2026-09-24 09:56 | 2026-09-24 09:56 | 2026-09-24 09:56 | NOK | NOK270115C00011000 | call | 11.0000 | 2027-01-15 | 1.1000 | 1.1000 | 1.1300 | 10.2599 | 320328.00 | 0.00 | 320328.00 | 2912 | 32 | 3113 | 30792 | 0.101097687711094 | 0.59915186186637 | 0.590369942792512 | false | false | false | |||||||||||||||||
| c886ec8d-71f0-4a10-9592-d4e62e16157d | 2026-09-23 12:49 | 2026-09-23 12:49 | 2026-09-23 12:49 | NOK | NOK270617C00014000 | call | 14.0000 | 2027-06-17 | 1.2900 | 1.2800 | 1.4000 | 10.6500 | 64538.00 | 0.00 | 64538.00 | 500 | 7 | 500 | 1179 | 0.424088210347752 | 0.612067115456358 | 0.612067115456358 | false | false | false | |||||||||||||||||
| ea866322-eb0d-44b1-ab8d-9d09193ba24a | 2026-09-23 11:00 | 2026-09-23 11:00 | 2026-09-23 11:00 | NOK | NOK270617C00015000 | call | 15.0000 | 2027-06-17 | 1.1500 | 1.1500 | 1.2000 | 10.0000 | 11178.00 | 0.00 | 11178.00 | 97 | 6 | 199 | 23124 | 0.00860577754713717 | 0.62255716368022 | 0.619698714639768 | false | false | false | |||||||||||||||||
| a8db0cd1-3302-4d9c-b5da-aa22458e1f1e | 2026-09-23 10:05 | 2026-09-23 10:05 | 2026-09-23 10:05 | NOK | NOK261120C00011000 | call | 11.0000 | 2026-11-20 | 1.0300 | 1.0300 | 1.0600 | 10.0000 | 313784.00 | 2517.00 | 307208.00 | 3035 | 62 | 4291 | 27052 | 0.15862043471832 | 0.630460889893971 | 0.617251984713607 | true | false | false | |||||||||||||||||
| 17f1efac-80da-4a1d-8d71-ebd58e752e30 | 2026-09-22 15:25 | 2026-09-22 15:25 | 2026-09-22 15:25 | NOK | NOK270115C00012000 | call | 12.0000 | 2027-01-15 | 1.0600 | 1.0600 | 1.0900 | 10.7900 | 19082.00 | 0.00 | 19082.00 | 180 | 5 | 1131 | 26875 | 0.0420837209302326 | 0.614696999465348 | 0.606378361221141 | false | false | false | |||||||||||||||||
| 59790e0e-41f9-4e2a-9087-e29e4cb9ebcb | 2026-09-22 15:17 | 2026-09-22 15:17 | 2026-09-22 15:17 | NOK | NOK270115C00011000 | call | 11.0000 | 2027-01-15 | 1.4200 | 1.4300 | 1.4400 | 10.8150 | 36946.00 | 0.00 | 36946.00 | 260 | 13 | 2316 | 27473 | 0.0843009500236596 | 0.600119171531416 | 0.600119171531416 | true | false | false | |||||||||||||||||
| 8bd423bc-9dad-4e55-ad32-3b710f7373f3 | 2026-09-22 13:00 | 2026-09-22 12:59 | 2026-09-22 12:59 | NOK | NOK260925C00011000 | call | 11.0000 | 2026-09-25 | 0.0900 | 0.0900 | 0.1100 | 10.0000 | 13504.00 | 0.00 | 13464.00 | 1500 | 34 | 7137 | 17444 | 0.409137812428342 | 0.677777927022761 | 0.645351999816319 | true | false | false | |||||||||||||||||
| 7d321f86-dfef-4eb8-a432-bbd78fd4fcb7 | 2026-09-21 13:31 | 2026-09-21 13:30 | 2026-09-21 13:30 | NOK | NOK270115C00013000 | call | 13.0000 | 2027-01-15 | 0.8600 | 0.8400 | 0.8700 | 10.8850 | 69583.00 | 69583.00 | 0.00 | 807 | 40 | 1119 | 15951 | 0.0701523415459846 | 0.628547252310531 | 0.624289295275958 | false | false | false | |||||||||||||||||
| 60ce5a9d-4c15-40ab-beb8-22e1b77a2abb | 2026-09-17 10:00 | 2026-09-17 10:00 | 2026-09-17 10:00 | NOK | NOK260918C00010000 | call | 10.0000 | 2026-09-18 | 0.8200 | 0.8200 | 0.8300 | 10.8150 | 80565.00 | 17015.00 | 63550.00 | 980 | 34 | 2663 | 68045 | 0.0391358659710486 | 0.969603194573363 | 0.764258730387209 | true | false | false | |||||||||||||||||
| 0bf336e4-69b6-4162-9128-cc880add3c74 | 2026-09-16 15:56 | 2026-09-16 15:56 | 2026-09-16 15:56 | NOK | NOK261016C00012000 | call | 12.0000 | 2026-10-16 | 0.2000 | 0.1800 | 0.2100 | 10.0000 | 97143.00 | 97083.00 | 0.00 | 4829 | 30 | 37857 | 54027 | 0.700705202954079 | 0.655454223268438 | 0.655454223268438 | false | false | false | |||||||||||||||||
| 9d0307dc-2294-4e85-ac6d-83b7f82ed27e | 2026-09-16 09:37 | 2026-09-16 09:37 | 2026-09-16 09:37 | NOK | NOK261016C00012000 | call | 12.0000 | 2026-10-16 | 0.2100 | 0.2000 | 0.2200 | 10.3150 | 101062.00 | 101062.00 | 0.00 | 4805 | 35 | 4986 | 54027 | 0.0922871897384641 | 0.616321957135704 | 0.605022242618869 | false | false | false | |||||||||||||||||
| 988cad01-a8aa-4078-a954-9142d1b855db | 2026-09-11 10:16 | 2026-09-11 10:16 | 2026-09-11 10:16 | NOK | NOK281215C00020000 | call | 20.0000 | 2028-12-15 | 2.2100 | 2.1900 | 2.3000 | 10.8850 | 88440.00 | 0.00 | 88440.00 | 400 | 5 | 555 | 2461 | 0.225518082080455 | 0.611006934395732 | 0.611006934395732 | false | false | false | |||||||||||||||||
| f30aa727-f519-4cc2-860e-5d105e632a9c | 2026-09-08 13:26 | 2026-09-08 13:26 | 2026-09-08 13:26 | NOK | NOK281215C00010000 | call | 10.0000 | 2028-12-15 | 4.2800 | 4.1500 | 4.4500 | 10.8600 | 214120.00 | 8680.00 | 205440.00 | 500 | 5 | 4890 | 2465 | 1.98377281947262 | 0.580928619141515 | 0.580928619141515 | false | false | false | |||||||||||||||||
| ea72fd43-13aa-46fd-a868-0496669733d5 | 2026-09-01 13:14 | 2026-09-01 13:14 | 2026-09-01 13:14 | NOK | NOK270416P00009000 | put | 9.0000 | 2027-04-16 | 1.2100 | 1.2100 | 1.2400 | 9.8350 | 154581.00 | 0.00 | 154581.00 | 1276 | 43 | 1276 | 29 | 44 | 0.586547296154069 | 0.586547296154069 | false | false | false | |||||||||||||||||
| 8f4617dd-07b2-47bb-91b3-0d7a4b13eb9c | 2026-08-25 09:42 | 2026-08-25 09:42 | 2026-08-25 09:42 | NOK | NOK270617C00015000 | call | 15.0000 | 2027-06-17 | 1.3000 | 1.2400 | 1.3000 | 10.2750 | 166257.00 | 123603.00 | 14964.00 | 1280 | 40 | 1281 | 23349 | 0.0548631633046383 | 0.679541966195854 | 0.676181759918627 | false | false | false | |||||||||||||||||
| 66da2597-70e7-4637-837f-f986ab61f463 | 2026-08-18 10:46 | 2026-08-18 10:46 | 2026-08-18 10:46 | NOK | NOK260925C00012000 | call | 12.0000 | 2026-09-25 | 0.3200 | 0.3200 | 0.3700 | 10.3600 | 97438.00 | 0.00 | 97438.00 | 3000 | 11 | 3085 | 3910 | 0.789002557544757 | 0.638584116939513 | 0.638584116939513 | false | false | false | |||||||||||||||||
| 8d4c6265-c40c-4389-bf12-3c0e3de6f772 | 2026-08-17 11:53 | 2026-08-17 11:53 | 2026-08-17 11:53 | NOK | NOK261120C00012000 | call | 12.0000 | 2026-11-20 | 1.2200 | 1.1900 | 1.2200 | 10.9750 | 54860.00 | 54860.00 | 0.00 | 450 | 19 | 828 | 23622 | 0.0350520701041402 | 0.706085919109182 | 0.706085919109182 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 61040007968.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 61040007968.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:59:25.813942Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 61040007968.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:50:31.727712Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 61040007968.00 |
| 2026-10-22 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:00:57.901243Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 61040007968.00 |
| 2026-10-22 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:05:57.943683Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 62131033511.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:27:59.988967Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 62131033511.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:23:17.824277Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 62131033511.00 |
| 2026-10-22 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:06:21.234354Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 62820102274.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:34:20.106500Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 60867740778.00 |
| 2026-10-22 |
| premarket |
| — |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 58226310517.00 |
| 2026-10-22 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 58226310517.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:42:35.153326Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T17:20:15.685951Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 55412613066.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |