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 | 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 |
|---|
| d16c3863-e037-4a23-88e6-964430b95006 | 2026-09-04 10:40 | 2026-09-04 10:40 | 2026-09-04 10:40 | SNDK | SNDK261016C02000000 | call | 2000.0000 | 2026-10-16 | 71.5800 | 68.2000 | 72.5000 | 1688.4750 | 164640.00 | 157510.00 | 7130.00 | 23 | 5 | 211 | 892 | 0.236547085201794 | 0.746404937842569 | 0.744897206466663 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T14:44:26.340635Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 09e97fa4-7328-429a-be0b-77b5b932d9b2 | 2026-09-04 15:35 | 2026-09-04 15:35 | 2026-09-04 15:35 | SNDK | SNDK261016C02000000 | call | 2000.0000 | 2026-10-16 | 90.5000 | 87.1000 | 91.8000 | 1726.5800 | 271488.00 | 262438.00 | 9050.00 | 30 | 10 | 616 | 892 | 0.690582959641256 | 0.778624057985335 | 0.778624057985335 | true | false | false | |||||||||||||||||
| 299a902e-de15-4514-9617-fc8a67aceaf7 | 2026-09-10 10:28 | 2026-09-10 10:27 | 2026-09-10 10:27 | SNDK | SNDK261016C02000000 | call | 2000.0000 | 2026-10-16 | 67.4400 | 66.0000 | 67.7000 | 1703.7000 | 269750.00 | 40490.00 | 47230.00 | 40 | 40 | 111 | 1184 | 0.09375 | 0.76195794595841 | 0.759794323150291 | false | false | false | |||||||||||||||||
| b4e31728-7159-43f8-b904-be1d0d99e71a | 2026-09-21 14:14 | 2026-09-21 14:14 | 2026-09-21 14:14 | SNDK | SNDK261016C02000000 | call | 2000.0000 | 2026-10-16 | 55.3000 | 54.0000 | 56.3000 | 1750.9750 | 132711.00 | 55230.00 | 27641.00 | 24 | 24 | 669 | 1575 | 0.424761904761905 | 0.748918827159732 | 0.747698163007294 | false | false | false | |||||||||||||||||
| c30ddd6d-3299-4492-9825-79bad1c0f0db | 2026-09-21 14:14 | 2026-09-21 14:14 | 2026-09-21 14:14 | SNDK | SNDK261016C02000000 | call | 2000.0000 | 2026-10-16 | 55.4300 | 54.9000 | 55.9000 | 1750.5401 | 105310.00 | 5540.00 | 49870.00 | 19 | 19 | 698 | 1575 | 0.443174603174603 | 0.750358678555765 | 0.749716244118539 | false | false | false | |||||||||||||||||
| 8238ada7-5a76-499c-895b-0d9feb16fb8a | 2026-09-21 15:34 | 2026-09-21 15:34 | 2026-09-21 15:34 | SNDK | SNDK261016C02000000 | call | 2000.0000 | 2026-10-16 | 54.9700 | 53.3000 | 55.0000 | 1746.4180 | 835540.00 | 549600.00 | 32940.00 | 152 | 6 | 1184 | 1575 | 0.751746031746032 | 0.75468857637087 | 0.754041842048099 | true | false | false | |||||||||||||||||
| 17a0f7f9-ea3f-4528-aa95-c539420b46ec | 2026-09-22 11:17 | 2026-09-22 11:17 | 2026-09-22 11:17 | SNDK | SNDK261016C02000000 | call | 2000.0000 | 2026-10-16 | 93.6500 | 91.9000 | 94.2000 | 1850.2420 | 477610.00 | 290890.00 | 186720.00 | 51 | 14 | 1013 | 2102 | 0.481921979067555 | 0.79297228866598 | 0.790233251575181 | true | false | false | |||||||||||||||||
| 9e748ca2-7dac-4687-a369-fae4eadb21ad | 2026-09-28 09:31 | 2026-09-28 09:31 | 2026-09-28 09:31 | SNDK | SNDK261016C02000000 | call | 2000.0000 | 2026-10-16 | 37.6800 | 37.5000 | 38.0000 | 1742.0352 | 48980.00 | 3760.00 | 45220.00 | 13 | 9 | 47 | 2063 | 0.0227823557925351 | 0.763137495270257 | 0.762298512355181 | false | false | false | |||||||||||||||||
| 49368981-0761-4547-9ebb-c7def5725f0e | 2026-09-28 09:31 | 2026-09-28 09:31 | 2026-09-28 09:31 | SNDK | SNDK261016C02000000 | call | 2000.0000 | 2026-10-16 | 34.7800 | 34.5000 | 36.4000 | 1737.0300 | 59130.00 | 0.00 | 59130.00 | 17 | 5 | 69 | 2063 | 0.0334464372273388 | 0.745056807249494 | 0.748304255464617 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:47:04.296573Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:36:53.026568Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 258669663927.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:15:35.599753Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 258669663927.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:15:35.599753Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 258669663927.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:36:57.124687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 276298511647.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:21:55.684470Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 250799642623.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:31:55.658450Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 250799642623.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:31:55.658450Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |