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 | strikenumeric |
|---|
| 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 |
|---|
| f8fad645-32a9-42f9-9407-0ff340fdb016 | 2026-09-01 11:58 | 2026-09-01 11:58 | 2026-09-01 11:58 | PCG | PCG261016C00014000 | call | 14.0000 | 2026-10-16 | 0.7400 | 0.7000 | 0.7400 | 13.5000 | 185000.00 | 185000.00 | 0.00 | 2500 | 30 | 3186 | 404 | 7.88613861386139 | 0.4939441659417 | 0.490272597138643 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 89eaf2d1-f9d2-477a-acec-e6cb78034d70 | 2026-09-01 12:06 | 2026-09-01 12:06 | 2026-09-01 12:06 | PCG | PCG261016C00014000 | call | 14.0000 | 2026-10-16 | 0.7700 | 0.7700 | 0.7800 | 13.5050 | 11242.00 | 0.00 | 11242.00 | 146 | 21 | 3547 | 404 | 8.77970297029703 | 0.504971951253299 | 0.504971951253299 | true | false | false | |||||||||||||||||
| 2bbd9389-d909-48ff-ab14-a16a9ed7741f | 2026-09-01 12:13 | 2026-09-01 12:12 | 2026-09-01 12:12 | PCG | PCG261016C00014000 | call | 14.0000 | 2026-10-16 | 0.8000 | 0.7400 | 0.8000 | 13.5486 | 152800.00 | 152800.00 | 0.00 | 1910 | 22 | 5706 | 404 | 14.1237623762376 | 0.510021094301595 | 0.510021094301595 | true | false | false | |||||||||||||||||
| cf6410a1-9e1e-4f4c-9fdc-94bbc679062e | 2026-09-02 11:11 | 2026-09-02 11:11 | 2026-09-02 11:11 | PCG | PCG261016C00014000 | call | 14.0000 | 2026-10-16 | 0.5200 | 0.4900 | 0.5300 | 12.9050 | 27300.00 | 3796.00 | 23504.00 | 525 | 12 | 1226 | 6556 | 0.187004270896888 | 0.510418561149957 | 0.510418561149957 | false | false | false | |||||||||||||||||
| 5f77885d-62d3-44da-b018-94b25bd22789 | 2026-09-03 10:58 | 2026-09-03 10:58 | 2026-09-03 10:58 | PCG | PCG261016C00014000 | call | 14.0000 | 2026-10-16 | 0.9000 | 0.9000 | 0.9700 | 13.6400 | 51750.00 | 0.00 | 51750.00 | 575 | 11 | 1336 | 12840 | 0.10404984423676 | 0.552390607471643 | 0.552390607471643 | true | false | false | |||||||||||||||||
| 4641795f-53c6-4e58-bf96-39cab81618a9 | 2026-09-03 11:02 | 2026-09-03 11:02 | 2026-09-03 11:02 | PCG | PCG261016C00014000 | call | 14.0000 | 2026-10-16 | 0.9400 | 0.8700 | 1.0100 | 13.7000 | 92120.00 | 87608.00 | 4418.00 | 980 | 13 | 2321 | 12840 | 0.180763239875389 | 0.556468539116391 | 0.557808713553502 | true | false | false | |||||||||||||||||
| a3f42c79-f851-4712-afae-330fc52c4a79 | 2026-09-03 11:31 | 2026-09-03 11:31 | 2026-09-03 11:31 | PCG | PCG261016C00014000 | call | 14.0000 | 2026-10-16 | 0.9800 | 0.8900 | 0.9900 | 13.7400 | 39792.00 | 39694.00 | 98.00 | 406 | 10 | 2756 | 12840 | 0.214641744548287 | 0.573638836919575 | 0.573638836919575 | true | false | false | |||||||||||||||||
| 7525fc62-4872-46ec-bd7c-6c5b8839d3c6 | 2026-09-08 12:44 | 2026-09-08 12:44 | 2026-09-08 12:44 | PCG | PCG261016C00014000 | call | 14.0000 | 2026-10-16 | 1.6600 | 1.6600 | 1.7000 | 14.7600 | 20916.00 | 0.00 | 20916.00 | 126 | 7 | 779 | 14488 | 0.053768636112645 | 0.655269708492706 | 0.655269708492706 | false | false | false | |||||||||||||||||
| 0fab2e18-6e37-4c7d-8426-f25cdf4891e6 | 2026-09-11 14:07 | 2026-09-11 14:07 | 2026-09-11 14:07 | PCG | PCG261016C00014000 | call | 14.0000 | 2026-10-16 | 0.6700 | 0.6700 | 0.7100 | 13.8650 | 40870.00 | 0.00 | 40870.00 | 610 | 39 | 1667 | 18728 | 0.0890111063648014 | 0.411596546136832 | 0.414559186312999 | false | false | false | |||||||||||||||||
| 44824173-b93f-45a9-84ec-0a3cb3a22807 | 2026-09-23 10:59 | 2026-09-23 10:59 | 2026-09-23 10:59 | PCG | PCG261016C00014000 | call | 14.0000 | 2026-10-16 | 0.0800 | 0.0800 | 0.1400 | 12.0000 | 11657.00 | 0.00 | 11657.00 | 1457 | 10 | 1726 | 17319 | 0.0996593336797737 | 0.375687248433744 | 0.375687248433744 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:27:11.873526Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:12:38.137640Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:12:38.137640Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:11:09.796111Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 33260171255.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:00:57.901243Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |