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_alerts326,449 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 |
|---|
| 3aba8cf8-4c80-4558-b6ab-728d4cc39ac3 | 2026-09-21 15:58 | 2026-09-21 15:58 | 2026-09-21 15:58 | YELP | YELP261120P00020000 | put | 20.0000 | 2026-11-20 | 2.0000 | 1.5500 | 2.0000 | 19.3950 | 27400.00 | 27400.00 | 0.00 | 137 | 12 | 1986 | 127 | 15.6377952755906 | 0.553798725998781 | 0.553798725998781 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1053256884.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| ed962160-1fb8-4517-8722-8d8459cad499 | 2026-09-21 15:53 | 2026-09-21 15:53 | 2026-09-21 15:53 | YELP | YELP261120P00020000 | put | 20.0000 | 2026-11-20 | 1.9500 | 1.7500 | 1.9500 | 19.0000 | 28860.00 | 28860.00 | 0.00 | 148 | 14 | 1849 | 127 | 14.5590551181102 | 0.548913601231705 | 0.548913601231705 | false | false | false | true | ||||||||||||||||
| d02c7919-c42c-4e6c-bdf2-aadc1f90c388 | 2026-09-21 15:48 | 2026-09-21 15:47 | 2026-09-21 15:47 | YELP | YELP261120P00020000 | put | 20.0000 | 2026-11-20 | 1.9500 | 1.0500 | 1.9500 | 19.0000 | 27885.00 | 27885.00 | 0.00 | 143 | 10 | 1701 | 127 | 13.3937007874016 | 0.546563556009765 | 0.546563556009765 | false | false | false | true | ||||||||||||||||
| e2427508-4e80-44d3-81f4-b06af24096c5 | 2026-09-21 15:43 | 2026-09-21 15:43 | 2026-09-21 15:43 | YELP | YELP261120P00020000 | put | 20.0000 | 2026-11-20 | 1.9500 | 1.7500 | 1.9500 | 19.4500 | 16575.00 | 16575.00 | 0.00 | 85 | 6 | 1558 | 127 | 12.2677165354331 | 0.546563556009765 | 0.546563556009765 | false | false | false | true | ||||||||||||||||
| fb8dd1da-42d9-4296-8dcb-16091b7e4a61 | 2026-09-21 15:37 | 2026-09-21 15:37 | 2026-09-21 15:37 | YELP | YELP261120P00020000 | put | 20.0000 | 2026-11-20 | 1.9000 | 1.6500 | 1.9500 | 19.4700 | 27375.00 | 27375.00 | 0.00 | 144 | 15 | 1410 | 127 | 11.1023622047244 | 0.533815229816499 | 0.549694757521571 | false | false | false | true | ||||||||||||||||
| ba449130-4a39-4204-94b0-89709f86a1bc | 2026-09-21 15:32 | 2026-09-21 15:32 | 2026-09-21 15:32 | YELP | YELP261120P00020000 | put | 20.0000 | 2026-11-20 | 1.9000 | 1.7500 | 1.9000 | 19.0000 | 20140.00 | 20140.00 | 0.00 | 106 | 9 | 1266 | 127 | 9.96850393700787 | 0.540053881634318 | 0.540053881634318 | false | false | false | true | ||||||||||||||||
| c2c69321-8906-43c2-8079-cb83f4d36fc3 | 2026-09-21 15:27 | 2026-09-21 15:27 | 2026-09-21 15:27 | YELP | YELP261120P00020000 | put | 20.0000 | 2026-11-20 | 1.9000 | 1.8000 | 1.9000 | 19.4600 | 15770.00 | 15770.00 | 0.00 | 83 | 8 | 1126 | 127 | 8.86614173228346 | 0.532244443851189 | 0.532244443851189 | false | false | false | true | ||||||||||||||||
| 49644742-b737-45a2-8f21-a7c00dbbdb10 | 2026-09-21 15:22 | 2026-09-21 15:22 | 2026-09-21 15:22 | YELP | YELP261120P00020000 | put | 20.0000 | 2026-11-20 | 1.8500 | 1.5500 | 1.8500 | 19.5200 | 20350.00 | 20350.00 | 0.00 | 110 | 9 | 877 | 127 | 6.90551181102362 | 0.525760602425415 | 0.525760602425415 | false | false | false | true | ||||||||||||||||
| 5113a9c7-0d2f-41a9-b489-1bbf7fc3544d | 2026-09-21 15:12 | 2026-09-21 15:12 | 2026-09-21 15:12 | YELP | YELP261120P00020000 | put | 20.0000 | 2026-11-20 | 1.8000 | 1.7000 | 1.8000 | 19.5050 | 12240.00 | 12240.00 | 0.00 | 68 | 21 | 588 | 127 | 4.62992125984252 | 0.50757477522331 | 0.50757477522331 | false | false | false | true | ||||||||||||||||
| 4aa3e581-18df-4c59-9669-8f42aedbfd13 | 2026-09-21 15:07 | 2026-09-21 15:07 | 2026-09-21 15:07 | YELP | YELP261120P00020000 | put | 20.0000 | 2026-11-20 | 1.8500 | 1.6000 | 1.8500 | 19.4700 | 26825.00 | 26825.00 | 0.00 | 145 | 12 | 444 | 127 | 3.49606299212598 | 0.517937148821863 | 0.517937148821863 | false | false | false | true | ||||||||||||||||
| 9532bd81-640b-49a6-8921-4024d4fce5e4 | 2026-09-21 15:02 | 2026-09-21 15:02 | 2026-09-21 15:02 | YELP | YELP261120P00020000 | put | 20.0000 | 2026-11-20 | 1.8000 | 1.6500 | 1.8000 | 19.0000 | 13320.00 | 13320.00 | 0.00 | 74 | 9 | 299 | 127 | 2.35433070866142 | 0.515355003398317 | 0.515355003398317 | false | false | false | true | ||||||||||||||||
| 8f3a679b-3b8b-4cad-ad5a-4e55ae674c27 | 2026-09-21 14:55 | 2026-09-21 14:55 | 2026-09-21 14:55 | YELP | YELP261120P00020000 | put | 20.0000 | 2026-11-20 | 1.7500 | 1.7000 | 1.8000 | 19.5100 | 22050.00 | 175.00 | 6825.00 | 126 | 6 | 135 | 127 | 1.06299212598425 | 0.492512365758857 | 0.492512365758857 | false | false | false | true | ||||||||||||||||
| 4180453a-41c4-44c3-b914-b81efa6c729c | 2026-09-18 10:24 | 2026-09-18 10:23 | 2026-09-18 10:23 | YELP | YELP261016C00019000 | call | 19.0000 | 2026-10-16 | 2.8600 | 0.5500 | 3.7000 | 20.1100 | 12310.00 | 9250.00 | 3060.00 | 43 | 5 | 43 | 0 | 0 | 1.44699502085101 | 0.468869267510585 | false | false | false | true | ||||||||||||||||
| 7ffb44fd-0e5c-4aa1-8d32-d5b7aae0b365 | 2026-09-04 14:54 | 2026-09-04 14:53 | 2026-09-04 14:53 | YELP | YELP260918P00022000 | put | 22.0000 | 2026-09-18 | 1.7300 | 0.7500 | 1.7500 | 21.7200 | 34590.00 | 20650.00 | 0.00 | 200 | 16 | 200 | 286 | 0.699300699300699 | 0.952430050510086 | 0.922953322779446 | false | false | false | true | ||||||||||||||||
| 31f6e6e9-26c7-4ba0-8d06-7b03acee9dd7 | 2026-09-02 15:47 | 2026-09-02 15:46 | 2026-09-02 15:46 | YELP | YELP260918P00026000 | put | 26.0000 | 2026-09-18 | 3.5000 | 3.2000 | 3.5000 | 22.6300 | 24500.00 | 24500.00 | 0.00 | 70 | 5 | 1202 | 3043 | 0.39500492934604 | 0.564310572901563 | 0.564310572901563 | false | false | false | true | ||||||||||||||||
| fa634df2-08e1-4a37-800a-de47f4f2d51a | 2026-09-02 15:43 | 2026-09-02 15:43 | 2026-09-02 15:43 | YELP | YELP260918P00026000 | put | 26.0000 | 2026-09-18 | 3.5000 | 3.1000 | 3.5000 | 22.7300 | 28000.00 | 28000.00 | 0.00 | 80 | 5 | 1132 | 3043 | 0.372001314492277 | 0.638484115450846 | 0.638484115450846 | false | false | false | true | ||||||||||||||||
| cdbbca8d-e0f3-44af-a711-3d1d0de00830 | 2026-09-02 15:35 | 2026-09-02 15:35 | 2026-09-02 15:35 | YELP | YELP260918P00026000 | put | 26.0000 | 2026-09-18 | 3.4000 | 2.7000 | 4.0000 | 22.7300 | 306000.00 | 306000.00 | 0.00 | 900 | 1 | 900 | 3043 | 0.295760762405521 | 0.551176322742003 | 0.551176322742003 | false | true | true | false | ||||||||||||||||
| 8700732b-9ed4-4ea1-9a8c-ac9fc457181e | 2026-08-26 10:32 | 2026-08-26 10:32 | 2026-08-26 10:32 | YELP | YELP260918C00026000 | call | 26.0000 | 2026-09-18 | 0.2400 | 0.2000 | 0.4500 | 23.0900 | 11325.00 | 8800.00 | 2525.00 | 463 | 20 | 670 | 73 | 9.17808219178082 | 0.473854272263064 | 0.472085777618829 | false | false | false | true | ||||||||||||||||
| fe191cbb-2a40-4730-bdf5-4a6316f11c94 | 2026-08-26 10:31 | 2026-08-26 10:30 | 2026-08-26 10:30 | YELP | YELP260918P00026000 | put | 26.0000 | 2026-09-18 | 3.1900 | 2.0000 | 3.4000 | 23.0000 | 478500.00 | 478500.00 | 0.00 | 1500 | 2 | 1500 | 43 | 34.8837209302326 | 0.419269645697607 | 0.419269645697607 | false | true | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1053256884.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1053256884.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:50:07.722851Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1053256884.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:46:53.809312Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1053256884.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1053256884.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1053256884.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1053256884.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:25:50.208697Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1053256884.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1053256884.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1053256884.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:06:05.917319Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1053256884.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:56:46.399450Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1065194880.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1184574846.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1184574846.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1184574846.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeSmallCap |
| f5350e0c-ce0c-4a4d-9480-d500b0bdaf3a |
| 1 |
| Common Stock |
| Communication Services |
| 1184574846.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:37:03.508091Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1184574846.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Communication Services |
| 1184574846.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |