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.
Simplify Analyticsuw_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 | expirydate |
|---|
| 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 |
|---|
| 05d9d8b8-89e7-41ca-ab34-3b8361c4be66 | 2026-08-24 14:50 | 2026-08-24 14:50 | 2026-08-24 14:50 | CDNS | CDNS260918C00322500 | call | 322.5000 | 2026-09-18 | 8.4000 | 7.2000 | 8.4000 | 314.4800 | 76440.00 | 76440.00 | 0.00 | 91 | 9 | 92 | 0 | 0 | 0.350644366410842 | 0.350644366410842 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 76851170580.00 | 2026-10-26 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| da280097-57e3-4016-9ae5-aa9a7f02fa66 | 2026-08-24 13:33 | 2026-08-24 13:33 | 2026-08-24 13:33 | CDNS | CDNS260918P00315000 | put | 315.0000 | 2026-09-18 | 12.3000 | 11.2000 | 12.3000 | 312.5300 | 131610.00 | 131610.00 | 0.00 | 107 | 16 | 108 | 321 | 0.336448598130841 | 0.350263286112951 | 0.350263286112951 | false | false | false | true | ||||||||||||||||
| 8ead3fa2-1129-41a8-a19f-f1c43620ff79 | 2026-08-24 09:44 | 2026-08-24 09:44 | 2026-08-24 09:44 | CDNS | CDNS261218P00340000 | put | 340.0000 | 2026-12-18 | 42.0000 | 40.0000 | 42.0000 | 312.3193 | 210000.00 | 210000.00 | 0.00 | 50 | 7 | 50 | 134 | 0.373134328358209 | 0.395305622211972 | 0.395305622211972 | false | false | false | true | ||||||||||||||||
| 18c1bdf6-436c-4454-9dc9-b25cbab4a024 | 2026-08-21 13:13 | 2026-08-21 13:13 | 2026-08-21 13:13 | CDNS | CDNS261120P00315000 | put | 315.0000 | 2026-11-20 | 22.2000 | 21.9000 | 22.7000 | 316.6100 | 71040.00 | 17760.00 | 53280.00 | 32 | 9 | 37 | 250 | 0.148 | 0.391185907856906 | 0.391185907856906 | false | false | false | true | false | |||||||||||||||
| 6d345c8e-5f9a-479f-b339-3f0f7872f6c7 | 2026-08-20 12:52 | 2026-08-20 12:52 | 2026-08-20 12:52 | CDNS | CDNS260918C00350000 | call | 350.0000 | 2026-09-18 | 2.5000 | 2.1500 | 2.9500 | 314.5300 | 93260.00 | 260.00 | 93000.00 | 373 | 6 | 691 | 176 | 3.92613636363636 | 0.356552552436365 | 0.35193625626486 | false | false | false | true | ||||||||||||||||
| 9d08047f-e6d4-48cc-8f37-99bdb8e4407d | 2026-08-19 11:32 | 2026-08-19 11:31 | 2026-08-19 11:31 | CDNS | CDNS261120C00350000 | call | 350.0000 | 2026-11-20 | 13.7000 | 13.7000 | 14.9000 | 315.8000 | 263047.00 | 0.00 | 263047.00 | 192 | 36 | 216 | 17 | 12.7058823529412 | 0.393598103041481 | 0.394738749301126 | false | false | false | true | ||||||||||||||||
| 4792a842-096e-4257-a984-641e2d76cdf2 | 2026-08-18 09:59 | 2026-08-18 09:59 | 2026-08-18 09:59 | CDNS | CDNS260821P00320000 | put | 320.0000 | 2026-08-21 | 3.7000 | 2.7000 | 3.7000 | 322.0800 | 54020.00 | 54020.00 | 0.00 | 146 | 28 | 161 | 10602 | 0.015185813997359 | 0.405706054819506 | 0.405706054819506 | false | false | false | true | ||||||||||||||||
| 561e4125-a3c1-490e-bebe-f6ae36e4ffae | 2026-08-17 15:27 | 2026-08-17 15:27 | 2026-08-17 15:27 | CDNS | CDNS260904P00317500 | put | 317.5000 | 2026-09-04 | 6.7000 | 5.7000 | 6.7000 | 325.2850 | 123280.00 | 123280.00 | 0.00 | 184 | 21 | 184 | 0 | 0 | 0.364100778513213 | 0.364100778513213 | false | false | false | true | false | |||||||||||||||
| 6a281ca5-11be-4516-aa09-69199f763ed5 | 2026-08-17 14:25 | 2026-08-17 14:25 | 2026-08-17 14:25 | CDNS | CDNS260904C00320000 | call | 320.0000 | 2026-09-04 | 13.5000 | 12.5000 | 13.5000 | 324.7200 | 118800.00 | 118800.00 | 0.00 | 88 | 19 | 94 | 1 | 94 | 0.372682752252397 | 0.372682752252397 | false | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 76851170580.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 76851170580.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:46:45.098903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 76851170580.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 76851170580.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 76851170580.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 76851170580.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 76851170580.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 76851170580.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |