Options 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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c715de40-e35f-4111-b1d5-8e82b6f9535f | 2026-08-17 11:06 | 2026-08-17 11:06 | 2026-08-17 11:06 | LMND | LMND260821C00050000 | call | 50.0000 | 2026-08-21 | 1.7000 | 1.4500 | 1.7000 | 50.6600 | 144980.00 | 144980.00 | 0.00 | 853 | 47 | 861 | 116 | 7.42241379310345 | 0.633969796516543 | 0.633969796516543 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 3872152648.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| db6ed879-26be-42bf-b069-2fd1b6b80434 | 2026-08-21 11:12 | 2026-08-21 11:12 | 2026-08-21 11:12 | LMND | LMND261016P00050000 | put | 50.0000 | 2026-10-16 | 3.3000 | 3.1000 | 3.3000 | 52.3650 | 141550.00 | 141550.00 | 0.00 | 429 | 34 | 432 | 1 | 432 | 0.565960798079265 | 0.565960798079265 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 3872152648.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 |
| 32b48a0e-9b3e-4a1a-900c-3ba67ef1da35 | 2026-09-01 10:38 | 2026-09-01 10:38 | 2026-09-01 10:38 | LMND | LMND260904C00050000 | call | 50.0000 | 2026-09-04 | 2.4000 | 2.1500 | 2.4000 | 51.7700 | 99580.00 | 99580.00 | 0.00 | 415 | 41 | 415 | 26 | 15.9615384615385 | 0.717269493076022 | 0.717269493076022 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 3872152648.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:59:17.018627Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f77856c9-b07e-4d6e-8bb0-e91f3b22a137 | 2026-09-09 10:38 | 2026-09-09 10:38 | 2026-09-09 10:38 | LMND | LMND261016C00045000 | call | 45.0000 | 2026-10-16 | 5.7000 | 5.3000 | 5.9000 | 48.0000 | 479344.00 | 477064.00 | 2280.00 | 841 | 50 | 841 | 3 | 280.333333333333 | 0.596061867584599 | 0.549366543845895 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 3872152648.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dc650cf4-6f3c-4d49-8284-d4a9670f0b26 | 2026-09-11 09:50 | 2026-09-11 09:50 | 2026-09-11 09:50 | LMND | LMND270617P00035000 | put | 35.0000 | 2027-06-17 | 3.8500 | 3.8000 | 4.2000 | 49.0000 | 69304.00 | 0.00 | 69304.00 | 180 | 5 | 200 | 64 | 3.125 | 0.691216091406353 | 0.691216091406353 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 3872152648.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b9eca215-7187-4f78-b077-1ebab8c08717 | 2026-09-11 12:23 | 2026-09-11 12:23 | 2026-09-11 12:23 | LMND | LMND260918C00050000 | call | 50.0000 | 2026-09-18 | 1.1000 | 1.1000 | 1.4000 | 49.1800 | 11020.00 | 0.00 | 11020.00 | 100 | 5 | 107 | 764 | 0.140052356020942 | 0.536228767679491 | 0.536228767679491 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 3872152648.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9371c957-fe39-40bd-9bc4-c3009f7f3d15 | 2026-09-11 15:41 | 2026-09-11 15:41 | 2026-09-11 15:41 | LMND | LMND260918P00049500 | put | 49.5000 | 2026-09-18 | 1.2500 | 1.2500 | 1.7000 | 49.5000 | 12503.00 | 0.00 | 12503.00 | 100 | 5 | 107 | 65 | 1.64615384615385 | 0.471406346415445 | 0.4640859961372 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 3872152648.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 262d4bac-3a8a-4848-84e3-19193c5efd43 | 2026-09-15 15:31 | 2026-09-15 15:31 | 2026-09-15 15:31 | LMND | LMND261016P00045000 | put | 45.0000 | 2026-10-16 | 1.1000 | 0.9500 | 1.2000 | 49.8300 | 23995.00 | 555.00 | 23210.00 | 218 | 6 | 256 | 402 | 0.63681592039801 | 0.53800069255122 | 0.536230041921108 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 3872152648.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 4f7430da-14ce-4e64-abe0-6d1c618bac7a | 2026-09-18 09:33 | 2026-09-18 09:33 | 2026-09-18 09:33 | LMND | LMND260925P00050000 | put | 50.0000 | 2026-09-25 | 2.3600 | 2.3000 | 2.4000 | 48.7000 | 55190.00 | 32880.00 | 21160.00 | 234 | 20 | 234 | 111 | 2.10810810810811 | 0.622075986036746 | 0.622075986036746 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 3644606600.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:40:42.153741Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 4346e615-3eba-4eb6-a93b-d9d1e226a0ee | 2026-09-18 09:33 | 2026-09-18 09:33 | 2026-09-18 09:33 | LMND | LMND260918P00049500 | put | 49.5000 | 2026-09-18 | 1.3000 | 0.5000 | 1.3000 | 48.7000 | 24414.00 | 24414.00 | 0.00 | 188 | 24 | 188 | 263 | 0.714828897338403 | 1.58344449592294 | 1.58344449592294 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 3644606600.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:40:42.153741Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |