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_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 | expiry |
|---|
| 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 |
|---|
| d83bf98b-b476-49fb-893b-874e82fe25c8 | 2026-08-20 10:04 | 2026-08-20 10:04 | 2026-08-20 10:04 | FSLY | FSLY260918C00025000 | call | 25.0000 | 2026-09-18 | 1.2500 | 1.1500 | 1.3000 | 23.0800 | 12474.00 | 12474.00 | 0.00 | 100 | 6 | 176 | 3414 | 0.0515524311657879 | 0.758097829693876 | 0.758097829693876 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3960198000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 08fbf376-6d5e-43dd-9db7-c072d9549a39 | 2026-08-27 10:23 | 2026-08-27 10:23 | 2026-08-27 10:23 | FSLY | FSLY260904C00026000 | call | 26.0000 | 2026-09-04 | 0.8900 | 0.8500 | 0.9000 | 25.1900 | 54952.00 | 47047.00 | 7905.00 | 617 | 34 | 724 | 200 | 3.62 | 0.831117622358333 | 0.831117622358333 | false | false | false | true | ||||||||||||||||
| 0a7b68b7-0106-40eb-9548-a33bccf0bd7b | 2026-09-02 12:51 | 2026-09-02 12:51 | 2026-09-02 12:51 | FSLY | FSLY260918P00019500 | put | 19.5000 | 2026-09-18 | 0.8000 | 0.7500 | 0.8000 | 20.4300 | 35900.00 | 35900.00 | 0.00 | 449 | 23 | 449 | 58 | 7.74137931034483 | 0.7339764868751 | 0.7339764868751 | false | false | false | true | ||||||||||||||||
| ad3b3f72-c099-4308-bca7-b42b8563ecae | 2026-09-03 09:59 | 2026-09-03 09:59 | 2026-09-03 09:59 | FSLY | FSLY260911C00020000 | call | 20.0000 | 2026-09-11 | 1.1800 | 1.1000 | 1.2000 | 20.4300 | 12950.00 | 9500.00 | 0.00 | 110 | 35 | 600 | 24 | 25 | 0.804997088937143 | 0.78791085651816 | false | false | false | true | ||||||||||||||||
| 91fbe147-db00-4a5a-9f03-7a6f410cc7b1 | 2026-09-08 09:38 | 2026-09-08 09:38 | 2026-09-08 09:38 | FSLY | FSLY260918C00021000 | call | 21.0000 | 2026-09-18 | 1.1000 | 1.0000 | 1.1500 | 20.7600 | 10664.00 | 10664.00 | 0.00 | 97 | 7 | 920 | 91 | 10.1098901098901 | 0.8795558076949 | 0.868615758010836 | false | false | false | true | ||||||||||||||||
| 7d1f3d5b-b160-4a04-9b84-a34d2622e905 | 2026-09-08 12:55 | 2026-09-08 12:54 | 2026-09-08 12:54 | FSLY | FSLY260925C00025000 | call | 25.0000 | 2026-09-25 | 0.7500 | 0.6500 | 0.9500 | 21.6300 | 33821.00 | 33671.00 | 75.00 | 452 | 30 | 2056 | 1707 | 1.20445225541886 | 1.0062286661434 | 0.993575510524931 | true | false | false | true | ||||||||||||||||
| 5fde22cc-11bb-46a4-b6c5-3f37f5a1e151 | 2026-09-10 15:12 | 2026-09-10 15:12 | 2026-09-10 15:12 | FSLY | FSLY270319C00025000 | call | 25.0000 | 2027-03-19 | 5.2200 | 5.1000 | 5.6000 | 22.8700 | 391828.00 | 0.00 | 391828.00 | 750 | 7 | 1544 | 32 | 48.25 | 0.910542758635342 | 0.910542758635342 | false | false | false | true | ||||||||||||||||
| 2cd2986a-c641-4eb6-8bfe-54622ff615b1 | 2026-09-17 10:44 | 2026-09-17 10:44 | 2026-09-17 10:44 | FSLY | FSLY260918C00023000 | call | 23.0000 | 2026-09-18 | 2.5600 | 2.5000 | 2.8500 | 25.5350 | 19984.00 | 0.00 | 19984.00 | 78 | 5 | 370 | 703 | 0.526315789473684 | 1.21796714655271 | 1.21796714655271 | false | false | false | true | ||||||||||||||||
| 5e8c3a85-868b-4cc1-ab65-9c75064d88b3 | 2026-09-18 09:30 | 2026-09-18 09:30 | 2026-09-18 09:30 | FSLY | FSLY261016C00025000 | call | 25.0000 | 2026-10-16 | 2.3100 | 2.2500 | 2.8000 | 24.9000 | 17345.00 | 0.00 | 17345.00 | 75 | 6 | 79 | 2569 | 0.0307512650836902 | 0.860100714975933 | 0.841809678097977 | false | false | false | true | ||||||||||||||||
| b9e23854-3306-41aa-8f08-242a3e0dae6a | 2026-09-18 10:00 | 2026-09-18 09:59 | 2026-09-18 09:59 | FSLY | FSLY261016C00025000 | call | 25.0000 | 2026-10-16 | 1.6100 | 1.6000 | 1.8500 | 23.4100 | 30423.00 | 1530.00 | 28893.00 | 189 | 40 | 348 | 2569 | 0.135461268976255 | 0.883636993784425 | 0.862925030946386 | false | false | false | |||||||||||||||||
| d1903609-3852-4bf8-be88-5ba916676b9e | 2026-09-18 15:03 | 2026-09-18 15:03 | 2026-09-18 15:03 | FSLY | FSLY260925C00023500 | call | 23.5000 | 2026-09-25 | 1.5800 | 1.5500 | 1.9000 | 23.9000 | 12642.00 | 0.00 | 12642.00 | 80 | 6 | 139 | 102 | 1.36274509803922 | 1.05608030322546 | 1.05608030322546 | false | false | false | true | ||||||||||||||||
| 3f5c2f80-7f1a-44a6-81d7-53a72fb0658c | 2026-09-21 11:26 | 2026-09-21 11:26 | 2026-09-21 11:26 | FSLY | FSLY260925C00025000 | call | 25.0000 | 2026-09-25 | 2.2100 | 1.9000 | 2.3500 | 26.4150 | 132330.00 | 132330.00 | 0.00 | 600 | 6 | 848 | 4204 | 0.201712654614653 | 1.25785779504449 | 1.25785779504449 | false | false | false | true | ||||||||||||||||
| 38eff932-793a-48ed-b145-109a87a9c038 | 2026-09-22 12:47 | 2026-09-22 12:47 | 2026-09-22 12:47 | FSLY | FSLY261120C00025000 | call | 25.0000 | 2026-11-20 | 5.3000 | 4.9000 | 5.3000 | 26.8899 | 109608.00 | 109608.00 | 0.00 | 207 | 23 | 215 | 63 | 3.41269841269841 | 1.01830080996687 | 1.01830080996687 | false | false | false | true | ||||||||||||||||
| cc246761-4a86-4935-9db2-5b435afaa158 | 2026-09-22 12:51 | 2026-09-22 12:51 | 2026-09-22 12:51 | FSLY | FSLY260925C00027500 | call | 27.5000 | 2026-09-25 | 1.7300 | 1.4500 | 1.7500 | 27.8400 | 200160.00 | 186320.00 | 9340.00 | 1154 | 15 | 1582 | 295 | 5.36271186440678 | 1.41237261875492 | 1.36851697044237 | true | false | false | |||||||||||||||||
| 6c2ca260-8c4a-46e3-9001-9691b6e02140 | 2026-09-22 12:51 | 2026-09-22 12:51 | 2026-09-22 12:51 | FSLY | FSLY260925C00028500 | call | 28.5000 | 2026-09-25 | 1.3000 | 1.0500 | 1.7000 | 27.8400 | 216020.00 | 199215.00 | 16805.00 | 1667 | 20 | 1755 | 68 | 25.8088235294118 | 1.44951775134947 | 1.42664194915402 | false | false | false | |||||||||||||||||
| ef13fe8c-c7b6-4fa0-90eb-dc8ab152251c | 2026-09-22 13:00 | 2026-09-22 13:00 | 2026-09-22 13:00 | FSLY | FSLY260925C00025000 | call | 25.0000 | 2026-09-25 | 1.4000 | 1.4000 | 1.5500 | 24.0000 | 52935.00 | 0.00 | 8135.00 | 378 | 7 | 5265 | 3556 | 1.48059617547807 | 1.63296257491575 | 1.57744370676921 | false | false | false | true | ||||||||||||||||
| 75123550-86e9-462f-b549-7f8beffdbdc2 | 2026-09-22 13:13 | 2026-09-22 13:13 | 2026-09-22 13:13 | FSLY | FSLY261016C00025000 | call | 25.0000 | 2026-10-16 | 2.5600 | 2.4500 | 2.7000 | 25.2200 | 11533.00 | 765.00 | 10768.00 | 45 | 7 | 579 | 2279 | 0.254058797718297 | 0.949771908210327 | 0.939682423217472 | false | false | false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3960198000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3960198000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3960198000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:10:05.195539Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3960198000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:39:51.680537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3960198000.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3960198000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:25:57.950009Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3914001000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3800898000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:31:27.885359Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3800898000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3800898000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4368006000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:27:55.894324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4154544000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:48:50.097062Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4154544000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:52:20.560244Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4154544000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:52:20.560244Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4154544000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:06:21.234354Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4154544000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:14:46.677665Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |