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 | 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 |
|---|
| c6770a14-7977-47ca-b994-fc289420b277 | 2026-09-30 15:16 | 2026-09-30 15:16 | 2026-09-30 15:16 | ONDS | ONDS270115C00007500 | call | 7.5000 | 2027-01-15 | 1.2200 | 1.2200 | 1.2300 | 7.0000 | 12081.00 | 369.00 | 11712.00 | 99 | 8 | 582 | 33507 | 0.0173695048795774 | 0.774917600873824 | 0.76852810718351 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3708304622.00 | 2026-11-12 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T19:23:43.569533Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| e9da8300-490a-4740-b91d-80f63b4e3eb6 | 2026-09-29 10:01 | 2026-09-29 10:01 | 2026-09-29 10:01 | ONDS | ONDS270416C00009000 | call | 9.0000 | 2027-04-16 | 1.4400 | 1.4300 | 1.5200 | 7.6105 | 15409.00 | 144.00 | 15265.00 | 107 | 5 | 131 | 104 | 1.25961538461538 | 0.830619866637502 | 0.829822640376416 | true | false | ||||||||||||||||||
| 56ebe0df-6f0d-44c3-8eec-b01d68735504 | 2026-09-28 11:53 | 2026-09-28 11:52 | 2026-09-28 11:52 | ONDS | ONDS270319C00010000 | call | 10.0000 | 2027-03-19 | 1.0500 | 1.0100 | 1.0500 | 7.6301 | 10385.00 | 10385.00 | 0.00 | 99 | 13 | 333 | 4394 | 0.0757851615839781 | 0.830261497877543 | 0.825417304022954 | false | false | ||||||||||||||||||
| cc82d30a-e6a4-4b94-baa3-0825842bdfe1 | 2026-09-24 11:52 | 2026-09-24 11:52 | 2026-09-24 11:52 | ONDS | ONDS280121C00010000 | call | 10.0000 | 2028-01-21 | 2.2800 | 2.2500 | 2.3600 | 7.4101 | 29662.00 | 0.00 | 29662.00 | 130 | 7 | 330 | 24217 | 0.0136267910971631 | 0.861822054345716 | 0.861822054345716 | false | false | ||||||||||||||||||
| bf9e2304-4d40-4c1c-8f37-cbd2cbf49d1a | 2026-09-24 09:38 | 2026-09-24 09:38 | 2026-09-24 09:38 | ONDS | ONDS261009C00007500 | call | 7.5000 | 2026-10-09 | 0.3000 | 0.3000 | 0.3300 | 7.2700 | 13681.00 | 0.00 | 13681.00 | 456 | 7 | 4024 | 4904 | 0.820554649265905 | 0.687120353436549 | 0.66993057726611 | false | false | ||||||||||||||||||
| 23d075a5-9665-4ac8-9cd3-c310b12e5ddb | 2026-09-24 09:37 | 2026-09-24 09:37 | 2026-09-24 09:37 | ONDS | ONDS261009C00007500 | call | 7.5000 | 2026-10-09 | 0.3100 | 0.3000 | 0.3400 | 7.2700 | 25979.00 | 0.00 | 25979.00 | 839 | 10 | 1756 | 4904 | 0.358075040783034 | 0.687120353436549 | 0.66993057726611 | false | false | ||||||||||||||||||
| ce1a3145-83ef-4c07-b4fe-04e86d6c807a | 2026-09-23 10:53 | 2026-09-23 10:53 | 2026-09-23 10:53 | ONDS | ONDS260925C00007500 | call | 7.5000 | 2026-09-25 | 0.4100 | 0.3900 | 0.4200 | 7.8250 | 24783.00 | 24783.00 | 0.00 | 600 | 6 | 1764 | 10937 | 0.161287373137058 | 0.968393283727289 | 0.915052828242414 | false | false | ||||||||||||||||||
| 1d311d85-17cc-416b-a153-9a139507338c | 2026-09-22 15:53 | 2026-09-22 15:53 | 2026-09-22 15:53 | ONDS | ONDS261218P00008000 | put | 8.0000 | 2026-12-18 | 1.3200 | 1.3200 | 1.3500 | 7.0000 | 55144.00 | 798.00 | 54346.00 | 417 | 40 | 1241 | 33475 | 0.0370724421209858 | 0.803274671071675 | 0.796553311670795 | true | false | ||||||||||||||||||
| 388f9ce0-00d0-4ced-a39c-7d975548f526 | 2026-09-16 15:49 | 2026-09-16 15:49 | 2026-09-16 15:49 | ONDS | ONDS270521C00010000 | call | 10.0000 | 2027-05-21 | 1.2500 | 1.2400 | 1.3600 | 7.0000 | 36128.00 | 127.00 | 36001.00 | 289 | 7 | 331 | 15 | 22.0666666666667 | 0.874456506334173 | 0.865859645405691 | true | false | ||||||||||||||||||
| 427979f1-26ef-4182-9952-851effa97220 | 2026-08-28 11:12 | 2026-08-28 11:12 | 2026-08-28 11:12 | ONDS | ONDS260918C00007000 | call | 7.0000 | 2026-09-18 | 1.3000 | 1.3000 | 1.3500 | 8.2097 | 11729.00 | 0.00 | 11729.00 | 90 | 5 | 121 | 4728 | 0.0255922165820643 | 0.634234953857861 | 0.609341353236694 | false | false | ||||||||||||||||||
| c0c2c407-7775-49eb-839e-7886b0eb6b51 | 2026-08-28 09:42 | 2026-08-28 09:42 | 2026-08-28 09:42 | ONDS | ONDS261218C00009000 | call | 9.0000 | 2026-12-18 | 1.4000 | 1.3400 | 1.5600 | 8.4299 | 58286.00 | 0.00 | 58286.00 | 417 | 6 | 420 | 5368 | 0.0782414307004471 | 0.855114948540349 | 0.822685557947616 | true | false | ||||||||||||||||||
| 86eb28a2-bd59-42c9-ae38-a6b9a525d784 | 2026-08-26 14:22 | 2026-08-26 14:22 | 2026-08-26 14:22 | ONDS | ONDS280121C00010000 | call | 10.0000 | 2028-01-21 | 3.1400 | 3.0000 | 3.1500 | 8.1550 | 14109.00 | 14109.00 | 0.00 | 45 | 6 | 504 | 21945 | 0.0229665071770335 | 0.957640135488185 | 0.949110663825948 | false | false | ||||||||||||||||||
| 6c14f261-2139-428e-9b24-86ac4132d0a8 | 2026-08-26 09:52 | 2026-08-26 09:52 | 2026-08-26 09:52 | ONDS | ONDS280121C00017000 | call | 17.0000 | 2028-01-21 | 1.9600 | 1.9500 | 2.0000 | 8.1750 | 17445.00 | 0.00 | 17445.00 | 89 | 9 | 411 | 9226 | 0.0445480164751788 | 0.944988399955057 | 0.939808822890328 | false | false | ||||||||||||||||||
| 910b281b-c5e5-429e-8216-da84fbdee1ae | 2026-08-24 12:58 | 2026-08-24 12:58 | 2026-08-24 12:58 | ONDS | ONDS261016C00009000 | call | 9.0000 | 2026-10-16 | 0.7300 | 0.7200 | 0.7600 | 8.2800 | 18252.00 | 1973.00 | 16279.00 | 250 | 8 | 1080 | 2263 | 0.477242598320813 | 0.798362232955657 | 0.790373040973903 | false | false | ||||||||||||||||||
| e1fdfea1-a78f-4f4b-8e36-0a3f290af915 | 2026-08-19 09:59 | 2026-08-19 09:59 | 2026-08-19 09:59 | ONDS | ONDS270115C00012000 | call | 12.0000 | 2027-01-15 | 1.1300 | 1.0800 | 1.2000 | 8.7350 | 17093.00 | 15256.00 | 1837.00 | 151 | 7 | 181 | 19660 | 0.00920651068158698 | 0.928314310213145 | 0.919120003889354 | true | false | ||||||||||||||||||
| f0907d10-dcdd-413a-842f-d3c0134f8c98 | 2026-08-18 13:29 | 2026-08-18 13:29 | 2026-08-18 13:29 | ONDS | ONDS280121C00020000 | call | 20.0000 | 2028-01-21 | 2.1400 | 2.1000 | 2.1500 | 8.9350 | 10704.00 | 10704.00 | 0.00 | 50 | 5 | 151 | 16017 | 0.00942748329899482 | 0.968977169092669 | 0.966623757325014 | false | false | ||||||||||||||||||
| 99e2956d-604d-47fe-bae5-48df149c8e25 | 2026-08-17 15:10 | 2026-08-17 15:10 | 2026-08-17 15:10 | ONDS | ONDS280121C00010000 | call | 10.0000 | 2028-01-21 | 3.9000 | 3.8000 | 3.9500 | 9.0400 | 39819.00 | 31589.00 | 8230.00 | 102 | 12 | 1248 | 21168 | 0.0589569160997732 | 0.987386841321588 | 0.981981270811819 | true | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3708304622.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:02:34.176265Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3807457152.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:53:41.284908Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3668643610.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:54:32.289461Z"} |
| 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 |
| 3668643610.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:38:54.076483Z"} |
| 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 |
| 3668643610.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:38:54.076483Z"} |
| 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 |
| 3668643610.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:53:23.630136Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3827287658.00 |
| 2026-11-12 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3569491080.00 |
| 2026-11-12 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3584363960.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 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 |
| 3584363960.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} |
| 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 |
| 3584363960.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"} |
| 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 |
| 3584363960.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} |
| 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 |
| 3584363960.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} |
| 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 |
| 3584363960.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 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 |
| 3584363960.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 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 |
| 3584363960.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |