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_alerts375,978 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 |
|---|
| 0daeef28-817b-4c1b-85f4-7998a493d643 | 2026-08-18 09:37 | 2026-08-18 09:37 | 2026-08-18 09:37 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 1.9500 | 1.7600 | 1.9800 | 17.6300 | 58484.00 | 58484.00 | 0.00 | 300 | 5 | 300 | 2976 | 0.100806451612903 | 1.06879594240704 | 1.06879594240704 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 6489005338.00 | 2026-11-02 | 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 |
| b7e629b3-1e7c-4cdd-b44c-2fc8cd507429 | 2026-08-19 11:44 | 2026-08-19 11:44 | 2026-08-19 11:44 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 1.0800 | 1.0000 | 1.0800 | 16.0100 | 23760.00 | 23760.00 | 0.00 | 220 | 6 | 2569 | 3431 | 0.748761294083358 | 1.10081265559868 | 1.10081265559868 | false | false | false | true | ||||||||||||||||
| 3cc6ec43-b32a-475b-bb6b-384ff22f4154 | 2026-08-20 15:37 | 2026-08-20 15:37 | 2026-08-20 15:37 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 1.4200 | 1.4200 | 1.4900 | 16.9350 | 108829.00 | 143.00 | 108686.00 | 766 | 25 | 1059 | 3282 | 0.322669104204753 | 1.05898376863819 | 1.05164844262619 | false | false | false | true | ||||||||||||||||
| 959ac3a6-aaf5-4f0a-a609-8ad11e2093a3 | 2026-08-21 11:00 | 2026-08-21 11:00 | 2026-08-21 11:00 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.8700 | 0.8300 | 0.8700 | 15.6400 | 17400.00 | 17400.00 | 0.00 | 200 | 9 | 536 | 2419 | 0.221579164944192 | 1.13329609292789 | 1.13329609292789 | false | false | false | true | ||||||||||||||||
| ce2c9581-3fd2-4a6b-ab26-6f1bff2f4c91 | 2026-08-31 09:33 | 2026-08-31 09:33 | 2026-08-31 09:33 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.1500 | 0.1400 | 0.1700 | 14.9620 | 23700.00 | 180.00 | 23505.00 | 1580 | 51 | 1840 | 6915 | 0.266088214027477 | 1.16043960538531 | 1.16805634919324 | false | false | false | true | ||||||||||||||||
| d610f0ca-eadd-47e2-8995-b9c0cd7ccf32 | 2026-08-31 09:33 | 2026-08-31 09:33 | 2026-08-31 09:33 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.1500 | 0.1300 | 0.1500 | 14.9200 | 22065.00 | 22065.00 | 0.00 | 1471 | 7 | 3405 | 6915 | 0.492407809110629 | 1.18582301943138 | 1.18582301943138 | false | false | false | true | ||||||||||||||||
| 129092d3-56b1-4525-8857-65bd021c894a | 2026-08-31 09:36 | 2026-08-31 09:36 | 2026-08-31 09:36 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.1600 | 0.1400 | 0.1600 | 15.0695 | 15984.00 | 15984.00 | 0.00 | 999 | 5 | 5829 | 6915 | 0.84295010845987 | 1.14752801370797 | 1.14752801370797 | false | false | false | true | ||||||||||||||||
| ffe8df24-6665-4073-b342-eb78cb20138b | 2026-09-03 10:20 | 2026-09-03 10:19 | 2026-09-03 10:19 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.1700 | 0.1500 | 0.1750 | 16.1699 | 11900.00 | 11900.00 | 0.00 | 700 | 35 | 1903 | 13701 | 0.138894971169988 | 1.37177115096723 | 1.36718496809059 | true | false | false | true | ||||||||||||||||
| 2256ac2f-6fe0-4cde-b5ee-6cd80d5ef07c | 2026-09-03 14:55 | 2026-09-03 14:55 | 2026-09-03 14:55 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.5000 | 0.4700 | 0.5000 | 17.1500 | 33950.00 | 33950.00 | 0.00 | 679 | 49 | 10514 | 13701 | 0.767389241661193 | 1.17749362335991 | 1.17749362335991 | false | false | false | true | ||||||||||||||||
| ee3b3728-3556-44ca-b676-a6ae5494f450 | 2026-09-04 10:17 | 2026-09-04 10:16 | 2026-09-04 10:16 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.7400 | 0.7400 | 0.7800 | 17.6850 | 34336.00 | 0.00 | 19462.00 | 464 | 5 | 1917 | 11916 | 0.160876132930514 | 1.52361434890468 | 1.52361434890468 | false | false | false | true | ||||||||||||||||
| a96740d5-5476-43d3-b0dd-bd05fc6582bd | 2026-09-04 10:17 | 2026-09-04 10:17 | 2026-09-04 10:17 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.7200 | 0.7200 | 0.7700 | 17.6839 | 44496.00 | 0.00 | 44496.00 | 618 | 39 | 2559 | 11916 | 0.214753272910373 | 1.32937027797518 | 1.32937027797518 | false | false | false | true | ||||||||||||||||
| bd3266b4-5ca1-4c47-801e-8f3181e7d996 | 2026-09-04 10:17 | 2026-09-04 10:17 | 2026-09-04 10:17 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.7200 | 0.7100 | 0.7200 | 17.6600 | 25704.00 | 25704.00 | 0.00 | 357 | 6 | 2940 | 11916 | 0.246727089627392 | 1.53407072735186 | 1.53407072735186 | false | false | false | true | ||||||||||||||||
| dc350dab-be37-415f-b708-f13e42bd72bb | 2026-09-04 10:17 | 2026-09-04 10:17 | 2026-09-04 10:17 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.7200 | 0.7100 | 0.7200 | 17.6650 | 19872.00 | 19872.00 | 0.00 | 276 | 5 | 3508 | 11916 | 0.294394091977174 | 1.49520218099033 | 1.49520218099033 | false | false | false | true | ||||||||||||||||
| 42dad6d0-5862-49a8-a0f3-68e9c46c102a | 2026-09-04 10:17 | 2026-09-04 10:17 | 2026-09-04 10:17 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.7300 | 0.7200 | 0.7600 | 17.6900 | 30441.00 | 5840.00 | 13724.00 | 417 | 12 | 3925 | 11916 | 0.329389056730446 | 1.3801939056618 | 1.3801939056618 | true | false | false | true | ||||||||||||||||
| 18797d0c-d9ec-4cd2-b261-28f83f8db381 | 2026-09-04 10:17 | 2026-09-04 10:17 | 2026-09-04 10:17 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.7200 | 0.7000 | 0.7600 | 17.6750 | 15768.00 | 9576.00 | 1296.00 | 219 | 10 | 4144 | 11916 | 0.347767707284324 | 1.41184286768107 | 1.41184286768107 | true | false | false | true | ||||||||||||||||
| f33d22ef-6a6b-4366-bd42-30044912f4c2 | 2026-09-04 10:34 | 2026-09-04 10:34 | 2026-09-04 10:34 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.7700 | 0.7200 | 0.7700 | 17.7250 | 10472.00 | 10472.00 | 0.00 | 136 | 5 | 4287 | 11916 | 0.359768378650554 | 1.51960642653305 | 1.51960642653305 | false | false | false | true | ||||||||||||||||
| e1b29b4d-0568-426e-8af5-dc8a5848d45e | 2026-09-04 11:49 | 2026-09-04 11:49 | 2026-09-04 11:49 | CIFR | CIFR260904C00017000 | call | 17.0000 | 2026-09-04 | 0.7600 | 0.7400 | 0.8600 | 17.7550 | 13148.00 | 0.00 | 4712.00 | 173 | 9 | 7788 | 11916 | 0.653575025176234 | 1.05869174890363 | 1.05869174890363 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:35:53.678596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:35:53.678596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:13:56.145626Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |