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_alerts523,327 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 |
|---|
| 33fca925-116c-4aa6-a1f3-349683e4b7d1 | 2026-09-25 10:15 | 2026-09-25 10:15 | 2026-09-25 10:15 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 4.7200 | 4.7000 | 4.9000 | 755.3050 | 25983.00 | 0.00 | 23583.00 | 55 | 31 | 9753 | 2303 | 4.23491098567086 | 0.628719068539158 | 0.636850513391473 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 1657506895075.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T14:17:27.635758Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| fab5fd2b-6a34-4afd-8ad2-135548612799 | 2026-09-24 12:57 | 2026-09-24 12:57 | 2026-09-24 12:57 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 3.9100 | 3.8500 | 4.1000 | 772.0000 | 43408.00 | 27320.00 | 3608.00 | 111 | 10 | 11303 | 1725 | 6.55246376811594 | 0.660194958876988 | 0.659020307099696 | false | false | false | |||||||||||||||||
| 2d812c3c-7918-4ba7-94ed-921cdafbe06c | 2026-09-24 11:45 | 2026-09-24 11:45 | 2026-09-24 11:45 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 5.7200 | 5.6000 | 5.9000 | 768.2900 | 17165.00 | 0.00 | 17165.00 | 30 | 5 | 9050 | 1725 | 5.2463768115942 | 0.688823476244403 | 0.69295532858382 | false | false | false | |||||||||||||||||
| 0ee2be53-7aec-4db6-ac0d-59fb1a42295a | 2026-09-24 09:53 | 2026-09-24 09:53 | 2026-09-24 09:53 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 11.4800 | 11.1000 | 11.7500 | 754.9500 | 17226.00 | 14950.00 | 2276.00 | 15 | 6 | 3592 | 1725 | 2.08231884057971 | 0.736179119921791 | 0.722962335172439 | false | false | false | |||||||||||||||||
| 08ac50c8-9e50-4493-a4c8-7ce0df851938 | 2026-09-24 09:52 | 2026-09-24 09:52 | 2026-09-24 09:52 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 10.6300 | 10.3500 | 10.6500 | 757.8250 | 64850.00 | 60705.00 | 4145.00 | 61 | 10 | 3388 | 1725 | 1.96405797101449 | 0.76285961592163 | 0.743771108139407 | true | false | false | |||||||||||||||||
| bfdb4de0-1e60-4b8c-8e8d-b88925652f84 | 2026-09-24 09:49 | 2026-09-24 09:49 | 2026-09-24 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 12.1300 | 11.9000 | 12.2500 | 754.5820 | 18190.00 | 13390.00 | 4800.00 | 15 | 5 | 3110 | 1725 | 1.80289855072464 | 0.755325693011471 | 0.750760510601471 | false | false | false | |||||||||||||||||
| c548dbbe-8015-4092-8d15-c21564369ca6 | 2026-09-24 09:36 | 2026-09-24 09:35 | 2026-09-24 09:35 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 13.0000 | 13.0000 | 13.6000 | 754.6450 | 37703.00 | 0.00 | 37703.00 | 29 | 6 | 557 | 1725 | 0.322898550724638 | 0.810071041520535 | 0.816208037635367 | false | false | false | |||||||||||||||||
| a6396be0-e43d-4433-b510-ba939dd9d65c | 2026-09-24 09:35 | 2026-09-24 09:35 | 2026-09-24 09:35 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 13.4900 | 13.2500 | 13.9500 | 753.5100 | 14844.00 | 13490.00 | 1354.00 | 11 | 6 | 523 | 1725 | 0.303188405797101 | 0.814960279448122 | 0.808603180258601 | true | false | false | |||||||||||||||||
| a2f97237-c200-42d6-8cfd-1c651e566e53 | 2026-09-23 10:12 | 2026-09-23 10:12 | 2026-09-23 10:12 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 21.2100 | 21.1000 | 21.5000 | 746.4100 | 33930.00 | 2125.00 | 31805.00 | 16 | 5 | 2487 | 672 | 3.70089285714286 | 0.751913671941318 | 0.751183979423188 | true | false | false | |||||||||||||||||
| 8d3013f9-a5ed-44da-a66b-0c95c83c65a7 | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 15.7700 | 15.7000 | 16.0500 | 755.7009 | 219185.00 | 36445.00 | 182740.00 | 139 | 41 | 935 | 672 | 1.39136904761905 | 0.726914936212648 | 0.725472158614659 | true | false | false | |||||||||||||||||
| defc4a66-aac9-4d8a-b972-b55e6a1e4326 | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 16.0800 | 16.0000 | 16.3000 | 755.2600 | 136645.00 | 4815.00 | 131830.00 | 85 | 13 | 607 | 672 | 0.90327380952381 | 0.731730759563927 | 0.729378587756927 | false | false | false | |||||||||||||||||
| a97f7aa9-ac47-4fc0-8444-5922c13f402a | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 16.1200 | 16.1000 | 16.3500 | 755.2250 | 66110.00 | 32300.00 | 33810.00 | 41 | 5 | 515 | 672 | 0.766369047619048 | 0.733103346852882 | 0.730859950601456 | false | false | false | |||||||||||||||||
| b34f833d-994e-4230-96f8-3375514212e7 | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 16.6800 | 16.5500 | 16.9000 | 754.1953 | 246930.00 | 131775.00 | 115155.00 | 148 | 15 | 363 | 672 | 0.540178571428571 | 0.73300351797274 | 0.732880379600275 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:59:44.374364Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:50:02.461499Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:51:23.785124Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:37:11.678086Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:37:11.678086Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:13:13.809395Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |