Simplify AnalyticsOptions flow alerts (market-wide)
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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| abd2b25e-475d-478d-9bd6-5e8b3f99a1c2 | 2026-08-17 09:38 | 2026-08-17 09:38 | 2026-08-17 09:38 | FIG | FIG260918C00025000 | call | 25.0000 | 2026-09-18 | 2.4100 | 2.4200 | 2.7400 | 25.6300 | 120569.00 | 0.00 | 120569.00 | 500 | 7 | 702 | 12920 | 0.0543343653250774 | 0.712928061392943 | 0.682332479679813 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 32d8bd01-ec5d-4084-9c0f-1f8f868213d3 | 2026-08-17 09:39 | 2026-08-17 09:39 | 2026-08-17 09:39 | FIG | FIG270115C00025000 | call | 25.0000 | 2027-01-15 | 5.3000 | 4.6500 | 5.7000 | 25.3400 | 106030.00 | 106030.00 | 0.00 | 200 | 7 | 202 | 4610 | 0.0438177874186551 | 0.777357097862624 | 0.777357097862624 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4bc96f53-a98d-4d86-af21-bf1348f04d69 | 2026-08-17 14:50 | 2026-08-17 14:50 | 2026-08-17 14:50 | FIG | FIG270115C00030000 | call | 30.0000 | 2027-01-15 | 3.4600 | 3.4000 | 3.6000 | 25.1050 | 231514.00 | 0.00 | 231514.00 | 669 | 5 | 1045 | 9535 | 0.109596224436287 | 0.778908614758475 | 0.778908614758475 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 29c75c97-032f-4f77-a10d-8f7297be2bcd | 2026-08-19 10:31 | 2026-08-19 10:31 | 2026-08-19 10:31 | FIG | FIG270115C00035000 | call | 35.0000 | 2027-01-15 | 2.9500 | 2.9100 | 2.9700 | 26.6400 | 14726.00 | 7670.00 | 4704.00 | 50 | 6 | 88 | 3243 | 0.0271353684859698 | 0.792385875618354 | 0.790864552229653 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c6690c5d-1cc7-4994-a069-05862206f3ed | 2026-08-19 10:37 | 2026-08-19 10:36 | 2026-08-19 10:36 | FIG | FIG270115C00035000 | call | 35.0000 | 2027-01-15 | 3.1000 | 3.1000 | 3.2000 | 26.9800 | 11790.00 | 0.00 | 11790.00 | 38 | 6 | 143 | 3243 | 0.0440949737897009 | 0.795737602424262 | 0.794245615721037 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2fc9bf60-8a5a-42f0-bb34-5fd4135d8d1d | 2026-08-20 09:52 | 2026-08-20 09:52 | 2026-08-20 09:52 | FIG | FIG260821C00028000 | call | 28.0000 | 2026-08-21 | 0.5000 | 0.4000 | 0.5700 | 27.7150 | 10163.00 | 5200.00 | 4963.00 | 204 | 16 | 1125 | 4342 | 0.259097190234915 | 1.08502280445044 | 1.08502280445044 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4d723fcd-8616-4b6f-b248-0ebd67a68f0d | 2026-08-20 10:40 | 2026-08-20 10:39 | 2026-08-20 10:39 | FIG | FIG260821C00023500 | call | 23.5000 | 2026-08-21 | 4.0200 | 3.9500 | 4.3000 | 27.5550 | 20104.00 | 0.00 | 20104.00 | 50 | 7 | 252 | 1331 | 0.189331329827198 | 2.73228090933871 | 2.73228090933871 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 460bd00c-802c-4cf7-9220-39ffdacaf792 | 2026-08-21 11:12 | 2026-08-21 11:12 | 2026-08-21 11:12 | FIG | FIG261016P00025000 | put | 25.0000 | 2026-10-16 | 1.8100 | 1.7400 | 2.0000 | 27.5350 | 33663.00 | 33484.00 | 179.00 | 186 | 25 | 202 | 1430 | 0.141258741258741 | 0.72592623179101 | 0.720650935571491 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2b9edb5c-cc0a-4a90-8698-5cff39d32fd3 | 2026-08-21 11:49 | 2026-08-21 11:49 | 2026-08-21 11:49 | FIG | FIG260821C00025000 | call | 25.0000 | 2026-08-21 | 2.4900 | 2.4000 | 2.7100 | 27.4800 | 17429.00 | 813.00 | 16616.00 | 70 | 6 | 260 | 7756 | 0.0335224342444559 | 4.49633035443443 | 4.42606497185184 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 62c68611-2c2b-47f2-a9d0-e6c8ceabb839 | 2026-08-27 15:23 | 2026-08-27 15:23 | 2026-08-27 15:23 | FIG | FIG260904C00035000 | call | 35.0000 | 2026-09-04 | 0.3400 | 0.1500 | 0.3500 | 31.0000 | 11391.00 | 11391.00 | 0.00 | 335 | 13 | 1122 | 373 | 3.00804289544236 | 0.803099190676885 | 0.802351754018182 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 12f328aa-b9a4-4ca2-91f2-235236c0966a | 2026-08-28 13:51 | 2026-08-28 13:51 | 2026-08-28 13:51 | FIG | FIG260918C00035000 | call | 35.0000 | 2026-09-18 | 0.3500 | 0.3400 | 0.3900 | 29.0550 | 17770.00 | 0.00 | 17770.00 | 515 | 27 | 1149 | 7413 | 0.154997976527722 | 0.6882900445894 | 0.6882900445894 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T18:18:32.282709Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 44c39a91-dda1-45f9-b973-4f08ca1791fe | 2026-08-31 09:37 | 2026-08-31 09:37 | 2026-08-31 09:37 | FIG | FIG260911C00026000 | call | 26.0000 | 2026-09-11 | 2.5200 | 2.2000 | 2.5900 | 27.9000 | 20160.00 | 20160.00 | 0.00 | 80 | 5 | 123 | 461 | 0.266811279826464 | 0.762834292611674 | 0.712530572529534 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4efc483d-5465-45da-bbe1-841f53818f01 | 2026-08-31 13:43 | 2026-08-31 13:43 | 2026-08-31 13:43 | FIG | FIG270115C00030000 | call | 30.0000 | 2027-01-15 | 4.3700 | 4.2500 | 4.5000 | 27.6000 | 21825.00 | 2250.00 | 0.00 | 50 | 5 | 499 | 8837 | 0.0564671268530044 | 0.78374570475563 | 0.761414452386415 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6c38baff-ab04-4609-8bbd-d91c72f6e3b7 | 2026-09-01 10:24 | 2026-09-01 10:24 | 2026-09-01 10:24 | FIG | FIG261016P00025000 | put | 25.0000 | 2026-10-16 | 1.3800 | 1.2700 | 1.4200 | 27.9200 | 119642.00 | 119507.00 | 135.00 | 867 | 53 | 882 | 2383 | 0.370121695342006 | 0.712605144912316 | 0.702642773240499 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 30cffb12-c76b-4a76-9ee1-a198d04f174c | 2026-09-01 12:01 | 2026-09-01 12:00 | 2026-09-01 12:00 | FIG | FIG261016C00030000 | call | 30.0000 | 2026-10-16 | 1.9200 | 1.9200 | 2.1000 | 27.9050 | 57608.00 | 0.00 | 57608.00 | 300 | 9 | 874 | 7780 | 0.112339331619537 | 0.71229978463079 | 0.691595978235746 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | 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 |
| 29e8f084-4f43-49a5-92c2-c698de53f319 | 2026-09-02 09:37 | 2026-09-02 09:37 | 2026-09-02 09:37 | FIG | FIG261016C00030000 | call | 30.0000 | 2026-10-16 | 1.7000 | 1.5000 | 1.7000 | 26.7000 | 16963.00 | 10710.00 | 0.00 | 100 | 21 | 135 | 8013 | 0.0168476226132535 | 0.774246654988499 | 0.774246654988499 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T13:42:51.501101Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cbc1002c-ba06-4ea7-a986-500237e4841e | 2026-09-02 12:12 | 2026-09-02 12:12 | 2026-09-02 12:12 | FIG | FIG261016C00025000 | call | 25.0000 | 2026-10-16 | 3.1000 | 3.0500 | 3.2500 | 26.0850 | 277800.00 | 21420.00 | 256380.00 | 895 | 63 | 1431 | 5084 | 0.28147128245476 | 0.703822487471756 | 0.696548701142765 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T16:19:14.278097Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6ab11d78-2e5f-46e9-b675-4dd8105b2f5a | 2026-09-04 12:59 | 2026-09-04 12:59 | 2026-09-04 12:59 | FIG | FIG260911C00024500 | call | 24.5000 | 2026-09-11 | 0.8800 | 0.8700 | 0.9000 | 24.4700 | 36615.00 | 17910.00 | 18705.00 | 414 | 10 | 576 | 81 | 7.11111111111111 | 0.670235477324384 | 0.648026594598004 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 897a6104-e952-4876-aa72-3b3a46d6c242 | 2026-09-08 15:04 | 2026-09-08 15:04 | 2026-09-08 15:04 | FIG | FIG260918C00023000 | call | 23.0000 | 2026-09-18 | 1.0100 | 0.9500 | 1.0200 | 22.6900 | 21226.00 | 1632.00 | 404.00 | 210 | 8 | 528 | 7 | 75.4285714285714 | 0.76820913273004 | 0.761530635720293 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T19:30:09.198364Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b80791b4-58ab-44bb-bdc9-b993dd94b583 | 2026-09-09 09:56 | 2026-09-09 09:56 | 2026-09-09 09:56 | FIG | FIG261016C00030000 | call | 30.0000 | 2026-10-16 | 0.4100 | 0.3700 | 0.4300 | 22.1499 | 16456.00 | 16456.00 | 0.00 | 400 | 8 | 502 | 9528 | 0.0526868178001679 | 0.827424517225439 | 0.815538118838539 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 385650b1-dd09-4bda-82d9-41e753751f8c | 2026-09-16 14:51 | 2026-09-16 14:51 | 2026-09-16 14:51 | FIG | FIG260918C00022500 | call | 22.5000 | 2026-09-18 | 0.8200 | 0.7000 | 0.8200 | 22.9200 | 25910.00 | 12627.00 | 81.00 | 316 | 9 | 1005 | 1712 | 0.587032710280374 | 0.88909288064859 | 0.854174098791535 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10494919870.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 6c59cfd3-7626-41e3-951c-f34a11e84782 | 2026-09-21 12:56 | 2026-09-21 12:56 | 2026-09-21 12:56 | FIG | FIG270115C00025000 | call | 25.0000 | 2027-01-15 | 2.9300 | 2.8600 | 2.9600 | 22.0000 | 23477.00 | 15096.00 | 8381.00 | 80 | 6 | 420 | 4705 | 0.0892667375132837 | 0.760691673227174 | 0.746793396515559 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 10162686934.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |