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 |
|---|
| 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 |
|---|
| b1a34690-012a-449d-a308-f418ea4c0c41 | 2026-09-21 15:38 | 2026-09-21 15:38 | 2026-09-21 15:38 | FRMI | FRMI261218P00005000 | put | 5.0000 | 2026-12-18 | 0.9700 | 0.9000 | 1.0500 | 5.0950 | 10128.00 | 10128.00 | 0.00 | 104 | 5 | 133 | 18540 | 0.00717367853290183 | 1.0805826237467 | 1.07004152984395 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3240764781.00 | 2026-11-09 | 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 |
| 39b9a83d-7456-4954-bc1a-84110eba6d7f | 2026-09-15 09:40 | 2026-09-15 09:39 | 2026-09-15 09:39 | FRMI | FRMI261120C00008000 | call | 8.0000 | 2026-11-20 | 0.3000 | 0.2500 | 0.4000 | 5.0250 | 22742.00 | 0.00 | 22742.00 | 750 | 6 | 750 | 6051 | 0.123946455131383 | 1.18661757735279 | 1.18661757735279 | false | false | false | |||||||||||||||||
| f32c3245-c606-43ba-a9bc-a33dca2cc738 | 2026-09-10 11:26 | 2026-09-10 11:26 | 2026-09-10 11:26 | FRMI | FRMI280121C00017500 | call | 17.5000 | 2028-01-21 | 1.1500 | 0.9500 | 1.1500 | 5.4250 | 11470.00 | 11470.00 | 0.00 | 100 | 14 | 100 | 4118 | 0.0242836328314716 | 1.10498119143437 | 1.09278917067329 | false | false | false | |||||||||||||||||
| 301d2ed0-7f36-4f69-a1b7-5010ed579bad | 2026-09-09 11:26 | 2026-09-09 11:26 | 2026-09-09 11:26 | FRMI | FRMI270219C00007000 | call | 7.0000 | 2027-02-19 | 1.3000 | 1.2000 | 1.3000 | 5.5150 | 64800.00 | 64800.00 | 0.00 | 500 | 9 | 1050 | 1484 | 0.707547169811321 | 1.1876066306784 | 1.16023253591812 | false | false | false | |||||||||||||||||
| 8e2180ef-8856-4562-8d9c-6d69fa7d6ecc | 2026-09-08 15:44 | 2026-09-08 15:44 | 2026-09-08 15:44 | FRMI | FRMI261016C00008000 | call | 8.0000 | 2026-10-16 | 0.2500 | 0.2500 | 0.3000 | 5.7714 | 13761.00 | 0.00 | 13761.00 | 550 | 7 | 724 | 6428 | 0.112632233976353 | 1.14253854419085 | 1.12535372919734 | false | false | false | |||||||||||||||||
| a9ddde04-ceb1-47b9-8cb1-4010de7e5444 | 2026-09-08 12:15 | 2026-09-08 12:15 | 2026-09-08 12:15 | FRMI | FRMI261218C00005000 | call | 5.0000 | 2026-12-18 | 1.6900 | 1.4500 | 1.8000 | 5.7750 | 25324.00 | 25324.00 | 0.00 | 150 | 9 | 172 | 1542 | 0.111543450064851 | 1.12372043971877 | 1.12372043971877 | false | false | false | |||||||||||||||||
| 4a74be8e-5763-4e00-9419-d1b1e99310b6 | 2026-09-04 12:36 | 2026-09-04 12:36 | 2026-09-04 12:36 | FRMI | FRMI260911C00005000 | call | 5.0000 | 2026-09-11 | 0.2400 | 0.2000 | 0.3000 | 4.9850 | 12584.00 | 150.00 | 2434.00 | 520 | 8 | 565 | 367 | 1.53950953678474 | 0.927748220546385 | 0.927748220546385 | false | false | false | |||||||||||||||||
| 04592747-0dc3-4d8f-a695-32e8a2ed53f2 | 2026-09-04 12:34 | 2026-09-04 12:34 | 2026-09-04 12:34 | FRMI | FRMI261218C00007500 | call | 7.5000 | 2026-12-18 | 0.5500 | 0.5000 | 0.5500 | 4.9250 | 97606.00 | 97606.00 | 0.00 | 1775 | 33 | 1785 | 13402 | 0.133189076257275 | 1.14824033832086 | 1.14824033832086 | false | false | false | |||||||||||||||||
| 4d1d83f8-03bc-4a08-b75e-ca2e4737c1e9 | 2026-08-27 12:13 | 2026-08-27 12:13 | 2026-08-27 12:13 | FRMI | FRMI261016C00006000 | call | 6.0000 | 2026-10-16 | 0.6900 | 0.6500 | 0.7000 | 5.5300 | 17366.00 | 17366.00 | 0.00 | 250 | 8 | 368 | 1689 | 0.217880402605092 | 1.07364893407802 | 1.05832705525905 | false | false | false | |||||||||||||||||
| 43b903a0-67c5-40fb-b948-fb2914c81a4c | 2026-08-25 13:35 | 2026-08-25 13:35 | 2026-08-25 13:35 | FRMI | FRMI260828C00006000 | call | 6.0000 | 2026-08-28 | 0.2500 | 0.2000 | 0.3000 | 6.0100 | 10565.00 | 10425.00 | 140.00 | 423 | 11 | 2752 | 2517 | 1.09336511720302 | 1.12419915594269 | 1.12419915594269 | false | false | false | |||||||||||||||||
| 0ec8dc24-93e8-4653-afe1-ff8343c2fa8c | 2026-08-24 09:43 | 2026-08-24 09:43 | 2026-08-24 09:43 | FRMI | FRMI260828C00005500 | call | 5.5000 | 2026-08-28 | 0.3300 | 0.3000 | 0.5500 | 5.6750 | 14038.00 | 0.00 | 14038.00 | 420 | 9 | 422 | 1600 | 0.26375 | 1.07854303394546 | 1.07854303394546 | false | false | false | |||||||||||||||||
| b7d5278a-894c-4a84-b15c-092d66a4b936 | 2026-08-21 15:51 | 2026-08-21 15:51 | 2026-08-21 15:51 | FRMI | FRMI260904P00005500 | put | 5.5000 | 2026-09-04 | 0.2100 | 0.2000 | 0.2500 | 5.9499 | 21002.00 | 0.00 | 21002.00 | 1000 | 8 | 2011 | 150 | 13.4066666666667 | 0.916294114292504 | 0.916294114292504 | false | false | false | |||||||||||||||||
| 9277e10c-7fd5-43e4-8432-a5d290681747 | 2026-08-21 15:32 | 2026-08-21 15:32 | 2026-08-21 15:32 | FRMI | FRMI260821C00005500 | call | 5.5000 | 2026-08-21 | 0.4000 | 0.4000 | 0.4500 | 5.9250 | 12850.00 | 0.00 | 12850.00 | 321 | 19 | 754 | 785 | 0.960509554140127 | 9.14943661371336 | 9.14943661371336 | false | false | false | |||||||||||||||||
| ab557b32-e8c7-4f61-89b2-550e735822bc | 2026-08-21 11:44 | 2026-08-21 11:43 | 2026-08-21 11:43 | FRMI | FRMI261016C00006000 | call | 6.0000 | 2026-10-16 | 1.0500 | 1.0000 | 1.0500 | 6.0650 | 20019.00 | 20019.00 | 0.00 | 191 | 13 | 369 | 916 | 0.402838427947598 | 1.07170760466387 | 1.06010901389655 | false | false | false | |||||||||||||||||
| 8485f920-4811-4dd9-83a0-8a61a214ca66 | 2026-08-19 15:48 | 2026-08-19 15:48 | 2026-08-19 15:48 | FRMI | FRMI261218C00015000 | call | 15.0000 | 2026-12-18 | 0.3000 | 0.2500 | 0.3000 | 5.7750 | 111239.00 | 111239.00 | 0.00 | 3709 | 40 | 3710 | 7480 | 0.495989304812834 | 1.27088858029609 | 1.26677948296697 | false | false | false | |||||||||||||||||
| c08b543a-8360-4291-bf39-dd600da7df50 | 2026-08-19 09:49 | 2026-08-19 09:49 | 2026-08-19 09:49 | FRMI | FRMI270115C00010000 | call | 10.0000 | 2027-01-15 | 0.7000 | 0.6000 | 0.7500 | 5.5450 | 962286.00 | 959626.00 | 0.00 | 13756 | 98 | 20054 | 49428 | 0.405721453427207 | 1.18907807641185 | 1.18907807641185 | false | false | false | |||||||||||||||||
| 0612a684-0dca-4ab4-ae12-95389588ad4c | 2026-08-19 09:48 | 2026-08-19 09:48 | 2026-08-19 09:48 | FRMI | FRMI270115C00010000 | call | 10.0000 | 2027-01-15 | 0.6500 | 0.6000 | 0.7000 | 5.5275 | 399136.00 | 395762.00 | 3374.00 | 6144 | 60 | 6198 | 49428 | 0.125394513231367 | 1.16570242094966 | 1.15544113348618 | false | false | false | |||||||||||||||||
| 9f885fae-3ab7-4bea-94ae-fccbccde96eb | 2026-08-18 15:36 | 2026-08-18 15:36 | 2026-08-18 15:36 | FRMI | FRMI260821C00005500 | call | 5.5000 | 2026-08-21 | 0.4000 | 0.3500 | 0.4000 | 5.7850 | 19995.00 | 19995.00 | 0.00 | 500 | 56 | 516 | 65 | 7.93846153846154 | 1.14067856851862 | 1.12110954938917 | false | false | false | |||||||||||||||||
| 73d9ab67-4d5f-44cd-8371-900dbfc7c69f | 2026-08-18 10:52 | 2026-08-18 10:52 | 2026-08-18 10:52 | FRMI | FRMI280121C00010000 | call | 10.0000 | 2028-01-21 | 2.0900 | 2.0500 | 2.2000 | 5.9300 | 10440.00 | 0.00 | 10440.00 | 50 | 6 | 68 | 5689 | 0.011952891545087 | 1.0660701818938 | 1.0660701818938 | false | false | false | |||||||||||||||||
| 48e836c4-2863-4f87-a18e-0a94c7f8a671 | 2026-08-17 15:00 | 2026-08-17 15:00 | 2026-08-17 15:00 | FRMI | FRMI261016C00010000 | call | 10.0000 | 2026-10-16 | 0.2600 | 0.2500 | 0.3000 | 6.1350 | 13054.00 | 0.00 | 13054.00 | 503 | 16 | 589 | 7741 | 0.0760883606769151 | 1.12033510454828 | 1.12322147200969 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:30:57.923324Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:46:45.098903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 3234360107.00 |
| 2026-11-09 |
| 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 |