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 |
|---|
| 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 |
|---|
| 2dfecc82-df6d-45e2-af30-36dcb831b0f1 | 2026-09-24 09:46 | 2026-09-24 09:46 | 2026-09-24 09:46 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 0.5500 | 0.5200 | 0.5700 | 239.3726 | 17284.00 | 17284.00 | 0.00 | 314 | 26 | 913 | 5033 | 0.181402741903437 | 1.17086089846597 | 1.18157213478308 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 49732983592.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T13:47:07.799094Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 8ffe08c4-0184-488a-bca6-168571fda2a4 | 2026-09-23 15:43 | 2026-09-23 15:43 | 2026-09-23 15:43 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 2.5000 | 2.4000 | 2.5000 | 228.0000 | 148250.00 | 148250.00 | 0.00 | 593 | 31 | 7125 | 7201 | 0.989445910290237 | 0.883805674185357 | 0.882776631910532 | false | false | false | true | ||||||||||||||||
| e9e49226-91f5-40d9-be61-9aa8dfb8eaf9 | 2026-09-23 12:51 | 2026-09-23 12:51 | 2026-09-23 12:51 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 2.2000 | 2.1200 | 2.2000 | 230.0899 | 215600.00 | 215600.00 | 0.00 | 980 | 20 | 5836 | 7201 | 0.810442994028607 | 0.894746522220633 | 0.894746522220633 | false | false | false | true | ||||||||||||||||
| bb922e1f-207b-4739-8283-99762d79d772 | 2026-09-23 12:40 | 2026-09-23 12:39 | 2026-09-23 12:39 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 2.0300 | 1.9200 | 2.0600 | 231.0000 | 101433.00 | 101433.00 | 0.00 | 500 | 5 | 3818 | 7201 | 0.530204138314123 | 0.901167856297951 | 0.903137258264823 | false | false | false | true | false | |||||||||||||||
| bd83dc3a-1a55-4dc5-a194-2445f009ab09 | 2026-09-22 11:49 | 2026-09-22 11:49 | 2026-09-22 11:49 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 1.9700 | 1.9400 | 2.0200 | 236.2299 | 12990.00 | 10635.00 | 2355.00 | 66 | 21 | 3899 | 5683 | 0.686081295090621 | 0.903696024520789 | 0.903696024520789 | false | false | false | true | ||||||||||||||||
| d488844d-28f6-4059-8d17-c753a6af4078 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 1.5400 | 1.5000 | 1.5600 | 243.1900 | 17864.00 | 6314.00 | 11550.00 | 116 | 5 | 2219 | 5683 | 0.390462783740982 | 1.02778471072902 | 1.02778471072902 | false | false | false | true | false | |||||||||||||||
| 6371b417-7160-4a81-b019-e8bf60724b2d | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 1.5400 | 1.5000 | 1.5500 | 243.1900 | 25410.00 | 15246.00 | 10164.00 | 165 | 6 | 2103 | 5683 | 0.370051029385888 | 1.02778471072902 | 1.02778471072902 | false | false | false | true | false | |||||||||||||||
| 38b12453-ac09-440f-a948-5d41dd06ce2d | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 1.5400 | 1.5000 | 1.5400 | 243.4300 | 27720.00 | 27720.00 | 0.00 | 180 | 15 | 1682 | 5683 | 0.295970438148865 | 1.03446707025786 | 1.03446707025786 | false | false | false | true | false | |||||||||||||||
| c67184d8-fbcd-4b22-bcf6-dbbb953e72a6 | 2026-09-22 09:37 | 2026-09-22 09:36 | 2026-09-22 09:36 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 1.8900 | 1.8000 | 1.9200 | 240.1250 | 43470.00 | 36666.00 | 6804.00 | 230 | 11 | 1175 | 5683 | 0.206756994545135 | 1.01303419801752 | 1.0097391772358 | false | false | false | true | false | |||||||||||||||
| a2d918c1-e788-477c-824b-8b87b906f7bf | 2026-09-22 09:36 | 2026-09-22 09:36 | 2026-09-22 09:36 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 1.8900 | 1.8400 | 1.9400 | 239.8050 | 22302.00 | 6615.00 | 8883.00 | 118 | 8 | 752 | 5683 | 0.132324476508886 | 1.00010768367252 | 1.00010768367252 | false | false | false | true | false | |||||||||||||||
| 0447c15a-b1f5-48dd-a5ba-b1021a4b3734 | 2026-09-22 09:36 | 2026-09-22 09:36 | 2026-09-22 09:36 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 1.8900 | 1.7700 | 1.9400 | 239.7700 | 17766.00 | 17766.00 | 0.00 | 94 | 9 | 595 | 5683 | 0.104698222769664 | 0.997391105989108 | 0.999051642018862 | false | false | false | true | false | |||||||||||||||
| 10d007da-021d-4405-a44e-6f3b40633c64 | 2026-09-22 09:36 | 2026-09-22 09:36 | 2026-09-22 09:36 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 1.8900 | 1.8200 | 1.9100 | 239.7299 | 33384.00 | 33384.00 | 0.00 | 177 | 12 | 428 | 5683 | 0.0753123350343129 | 0.994493325608134 | 0.997841086234853 | false | false | false | true | false | |||||||||||||||
| e322677b-554a-413a-94b1-8dcbc2df3e43 | 2026-09-21 15:59 | 2026-09-21 15:59 | 2026-09-21 15:59 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 3.6000 | 3.5000 | 3.6000 | 232.0000 | 10080.00 | 10080.00 | 0.00 | 28 | 6 | 3621 | 3557 | 1.0179926904695 | 0.905730010960542 | 0.905730010960542 | false | false | false | true | false | |||||||||||||||
| 94d6e5a3-eb8c-489b-8bb3-798b74910999 | 2026-09-21 15:59 | 2026-09-21 15:59 | 2026-09-21 15:59 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 3.5700 | 3.3000 | 3.6000 | 232.0000 | 11768.00 | 11768.00 | 0.00 | 33 | 7 | 3489 | 3557 | 0.98088276637616 | 0.904822861033741 | 0.901002304404916 | false | false | false | true | false | |||||||||||||||
| 42fcbe36-4d66-44e2-999a-6da64d79bfec | 2026-09-21 15:59 | 2026-09-21 15:58 | 2026-09-21 15:58 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 3.5500 | 3.4000 | 3.5500 | 232.8600 | 12070.00 | 12070.00 | 0.00 | 34 | 5 | 3346 | 3557 | 0.940680348608378 | 0.900022844894347 | 0.900022844894347 | false | false | false | true | false | |||||||||||||||
| 1216624e-897a-4d60-92fe-6f5ec1a7909b | 2026-09-18 12:47 | 2026-09-18 12:47 | 2026-09-18 12:47 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 9.6000 | 9.4000 | 9.8000 | 218.9650 | 21119.00 | 20159.00 | 0.00 | 22 | 12 | 3280 | 553 | 5.93128390596745 | 0.756018372691585 | 0.756018372691585 | false | false | false | true | false | |||||||||||||||
| 2028d07a-cb5a-41f2-86d5-30599e8b8510 | 2026-09-18 12:17 | 2026-09-18 12:17 | 2026-09-18 12:17 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 10.2100 | 10.2000 | 10.3500 | 217.0000 | 24514.00 | 0.00 | 24514.00 | 24 | 5 | 3185 | 553 | 5.75949367088608 | 0.746228516682137 | 0.744562001939808 | false | false | false | true | false | |||||||||||||||
| 84d0b98f-f8fb-47b5-b4a2-33b526f70167 | 2026-09-18 09:49 | 2026-09-18 09:49 | 2026-09-18 09:49 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 11.4500 | 11.2500 | 11.4500 | 215.5850 | 19465.00 | 19465.00 | 0.00 | 17 | 9 | 152 | 553 | 0.274864376130199 | 0.762783006959006 | 0.762783006959006 | false | false | false | true | false | |||||||||||||||
| 48c0bb48-22d7-4d92-bbe3-edb6458a95ff | 2026-09-17 09:31 | 2026-09-17 09:30 | 2026-09-17 09:30 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 6.6700 | 4.6500 | 7.0000 | 230.2450 | 14680.00 | 13355.00 | 1325.00 | 22 | 19 | 22 | 1336 | 0.0164670658682635 | 0.839596877424505 | 0.843637792691641 | true | false | false | true | false | |||||||||||||||
| d205b694-c4c8-40c3-8f58-f5c8e2eb0b72 | 2026-09-15 12:42 | 2026-09-15 12:41 | 2026-09-15 12:41 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 16.9600 | 16.9500 | 17.4500 | 209.0000 | 40710.00 | 1725.00 | 38985.00 | 24 | 6 | 54 | 521 | 0.103646833013436 | 0.767795468533862 | 0.767795468533862 | false | false | false | true | ||||||||||||||||
| 424dc6b3-3030-4353-9452-6f5bbbf277d5 | 2026-08-26 12:20 | 2026-08-26 12:20 | 2026-08-26 12:20 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 23.5900 | 23.5000 | 24.7000 | 215.9550 | 68410.00 | 4720.00 | 63690.00 | 29 | 8 | 43 | 277 | 0.155234657039711 | 0.877250395759054 | 0.881307570964703 | false | false | false | true | ||||||||||||||||
| 83d42420-b580-4ae7-a7c0-94a8812edf2c | 2026-08-25 12:49 | 2026-08-25 12:49 | 2026-08-25 12:49 | NBIS | NBIS260925P00220000 | put | 220.0000 | 2026-09-25 | 23.3000 | 22.7500 | 24.0000 | 218.5000 | 16310.00 | 2330.00 | 13980.00 | 7 | 7 | 18 | 263 | 0.0684410646387833 | 0.902501385331609 | 0.902501385331609 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 49732983592.00 |
| — |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:47:37.737983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 49732983592.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:52:42.063868Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 49732983592.00 |
| — |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:43:49.845741Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51820096579.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:56:22.412787Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51820096579.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51820096579.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51820096579.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51820096579.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51820096579.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51820096579.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 51820096579.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51091472486.00 |
| — |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 51091472486.00 |
| — |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51091472486.00 |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 49059225772.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 49059225772.00 |
| — |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 49059225772.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 47841194533.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:32:41.851557Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |