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 | strike |
|---|
| expirydate |
|---|
| 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 |
|---|
| 37bdfb8b-709a-4e9a-be3c-fa161caf3e4e | 2026-09-25 12:43 | 2026-09-25 12:43 | 2026-09-25 12:43 | QBTS | QBTS261016C00020000 | call | 20.0000 | 2026-10-16 | 0.4800 | 0.4700 | 0.5100 | 17.6700 | 14500.00 | 0.00 | 9600.00 | 300 | 5 | 566 | 16066 | 0.0352296775799826 | 0.741778133089769 | 0.741778133089769 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 6428883402.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T16:45:32.616673Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 026703f1-3d3c-4fce-9ae0-22230a3f2369 | 2026-09-24 13:53 | 2026-09-24 13:53 | 2026-09-24 13:53 | QBTS | QBTS261016C00019500 | call | 19.5000 | 2026-10-16 | 0.6100 | 0.5400 | 0.6100 | 17.0000 | 11879.00 | 11461.00 | 418.00 | 196 | 46 | 397 | 90 | 4.41111111111111 | 0.772828522476113 | 0.77179312537158 | false | false | ||||||||||||||||||
| 37ede1ce-be23-4867-a070-192cfc1a20ed | 2026-09-15 15:31 | 2026-09-15 15:31 | 2026-09-15 15:31 | QBTS | QBTS261120C00020000 | call | 20.0000 | 2026-11-20 | 1.0800 | 1.0700 | 1.1000 | 16.3650 | 47520.00 | 15950.00 | 31570.00 | 440 | 18 | 758 | 2068 | 0.366537717601547 | 0.79820469978661 | 0.807337982652283 | false | false | ||||||||||||||||||
| d7775b04-c8d6-4be9-a8e9-da923cefe56b | 2026-09-11 11:12 | 2026-09-11 11:12 | 2026-09-11 11:12 | QBTS | QBTS280121C00015000 | call | 15.0000 | 2028-01-21 | 7.3000 | 6.9500 | 7.6000 | 17.0950 | 36480.00 | 36480.00 | 0.00 | 50 | 5 | 83 | 1395 | 0.0594982078853047 | 0.81367499007264 | 0.81367499007264 | false | false | ||||||||||||||||||
| 0be5e9e2-7296-42f8-b6ca-a9345e5c050d | 2026-09-08 12:06 | 2026-09-08 12:06 | 2026-09-08 12:06 | QBTS | QBTS260918C00018000 | call | 18.0000 | 2026-09-18 | 1.2300 | 1.1500 | 1.2400 | 18.3900 | 36927.00 | 6054.00 | 23370.00 | 300 | 9 | 1155 | 4459 | 0.259026687598116 | 0.854869758213362 | 0.843917694492468 | false | false | ||||||||||||||||||
| 764dbbf3-1406-415d-9ac7-b37c35341c47 | 2026-08-27 15:46 | 2026-08-27 15:46 | 2026-08-27 15:46 | QBTS | QBTS270115C00022000 | call | 22.0000 | 2027-01-15 | 2.4600 | 2.4400 | 2.6000 | 18.0150 | 226722.00 | 11516.00 | 203936.00 | 922 | 32 | 937 | 6009 | 0.155932767515394 | 0.831307387470618 | 0.829056965275367 | false | false | ||||||||||||||||||
| d35c35aa-ee90-4ea0-8a73-52fa1dd30b3d | 2026-08-27 15:45 | 2026-08-27 15:45 | 2026-08-27 15:45 | QBTS | QBTS270115C00020000 | call | 20.0000 | 2027-01-15 | 3.0200 | 3.0000 | 3.1000 | 18.0300 | 36220.00 | 0.00 | 36220.00 | 120 | 7 | 910 | 10554 | 0.0862232328974796 | 0.822738382068736 | 0.822738382068736 | false | false | ||||||||||||||||||
| cf8f95bf-fe72-49f3-9c58-0b3618b80c7b | 2026-08-27 12:56 | 2026-08-27 12:56 | 2026-08-27 12:56 | QBTS | QBTS260918P00018000 | put | 18.0000 | 2026-09-18 | 1.2100 | 1.1600 | 1.2800 | 18.0600 | 20168.00 | 0.00 | 20168.00 | 166 | 6 | 202 | 2414 | 0.0836785418392709 | 0.717036264230307 | 0.715213028028022 | true | false | ||||||||||||||||||
| bc0630dc-6175-4581-8de7-d74b64f963ec | 2026-08-27 10:02 | 2026-08-27 10:02 | 2026-08-27 10:02 | QBTS | QBTS260904C00018000 | call | 18.0000 | 2026-09-04 | 0.8400 | 0.8000 | 0.8500 | 17.9800 | 37610.00 | 765.00 | 16517.00 | 450 | 12 | 593 | 455 | 1.3032967032967 | 0.805608264236802 | 0.784281182138889 | false | false | ||||||||||||||||||
| d7124cea-fba9-4b75-b0cd-48a5af82e64c | 2026-08-19 12:06 | 2026-08-19 12:06 | 2026-08-19 12:06 | QBTS | QBTS261016C00029000 | call | 29.0000 | 2026-10-16 | 0.5400 | 0.4200 | 0.5400 | 19.5500 | 32336.00 | 31806.00 | 0.00 | 599 | 28 | 604 | 241 | 2.50622406639004 | 0.871722374628022 | 0.870942462628726 | false | false | ||||||||||||||||||
| d5b03db4-d854-4c57-a792-9aec9b3ebe1e | 2026-08-18 12:51 | 2026-08-18 12:51 | 2026-08-18 12:51 | QBTS | QBTS260904C00020000 | call | 20.0000 | 2026-09-04 | 1.3800 | 1.3400 | 1.3900 | 19.9900 | 27670.00 | 22230.00 | 5440.00 | 200 | 16 | 4076 | 97 | 42.020618556701 | 0.805628037063734 | 0.784268115539109 | true | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6207325100.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:55:11.953323Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6214710377.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6214710377.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:28:46.184785Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6214710377.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6214710377.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:52:49.177007Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6214710377.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:52:49.177007Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6214710377.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6214710377.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6214710377.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6214710377.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |