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.
uw_flow_alerts566,287 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 |
|---|
| 3d1ee09f-b35d-4b3a-943d-8d7b006cb04f | 2026-09-18 15:25 | 2026-09-18 15:25 | 2026-09-18 15:25 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 2.0000 | 1.6000 | 3.1000 | 107.9900 | 14800.00 | 11800.00 | 3000.00 | 74 | 5 | 1007 | 1655 | 0.608459214501511 | 1.05919162761411 | 1.05919162761411 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 40083917143.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| f5b3f459-a7a1-43b2-8cd0-7f5961770975 | 2026-09-03 15:33 | 2026-09-03 15:33 | 2026-09-03 15:33 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 6.5000 | 6.2000 | 6.5000 | 107.5300 | 48750.00 | 48750.00 | 0.00 | 75 | 14 | 1225 | 1453 | 0.84308327598073 | 0.600221411011135 | 0.600221411011135 | false | false | false | |||||||||||||||||
| 9d66959e-8b5b-4082-afc0-001371073b3e | 2026-09-03 15:33 | 2026-09-03 15:33 | 2026-09-03 15:33 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 6.5000 | 6.2000 | 6.5000 | 107.5800 | 48750.00 | 29250.00 | 0.00 | 75 | 12 | 1150 | 1453 | 0.791465932553338 | 0.60336714746702 | 0.60336714746702 | false | false | false | |||||||||||||||||
| 87d45806-15fe-40a7-bbae-99c48ce59596 | 2026-09-03 15:29 | 2026-09-03 15:29 | 2026-09-03 15:29 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 6.4000 | 6.2000 | 6.4000 | 107.5850 | 39040.00 | 39040.00 | 0.00 | 61 | 7 | 1075 | 1453 | 0.739848589125946 | 0.592118561627158 | 0.592118561627158 | false | false | false | |||||||||||||||||
| c1956c56-6cd7-447b-855c-68fbbe046ecc | 2026-09-03 15:29 | 2026-09-03 15:29 | 2026-09-03 15:29 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 6.4000 | 6.2000 | 6.5000 | 107.6300 | 24320.00 | 4480.00 | 5120.00 | 38 | 5 | 983 | 1453 | 0.676531314521679 | 0.594946363808543 | 0.594946363808543 | false | false | false | |||||||||||||||||
| 9c69689c-a3e2-43fc-ab5a-efb072773678 | 2026-09-03 15:07 | 2026-09-03 15:07 | 2026-09-03 15:07 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 6.2000 | 6.2000 | 6.4000 | 107.8700 | 17980.00 | 0.00 | 17980.00 | 29 | 5 | 782 | 1453 | 0.53819683413627 | 0.586816964662162 | 0.586816964662162 | false | false | false | |||||||||||||||||
| 11ba05be-a2a9-46fd-904d-33a5c7b4cf01 | 2026-09-03 14:54 | 2026-09-03 14:53 | 2026-09-03 14:53 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 6.2000 | 5.9000 | 6.3000 | 107.9050 | 16120.00 | 9920.00 | 6200.00 | 26 | 5 | 579 | 1453 | 0.398485891259463 | 0.588975024944891 | 0.588975024944891 | false | false | false | |||||||||||||||||
| 03fa78ff-7a63-44b8-8d4d-6ef5d4c67f4d | 2026-09-03 14:54 | 2026-09-03 14:53 | 2026-09-03 14:53 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 6.2000 | 5.9000 | 6.2000 | 107.9050 | 13020.00 | 13020.00 | 0.00 | 21 | 7 | 600 | 1453 | 0.412938747419133 | 0.588975024944891 | 0.588975024944891 | false | false | false | |||||||||||||||||
| 69b25c27-cba8-4e95-9b43-fd843175c315 | 2026-09-03 14:53 | 2026-09-03 14:53 | 2026-09-03 14:53 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 6.1500 | 5.9000 | 6.2000 | 107.8800 | 69550.00 | 57350.00 | 6100.00 | 113 | 22 | 553 | 1453 | 0.380591878871301 | 0.587125685804332 | 0.575923146588523 | false | false | false | |||||||||||||||||
| 020aa92f-ea78-41de-8162-c70280859749 | 2026-09-03 14:53 | 2026-09-03 14:53 | 2026-09-03 14:53 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 6.2000 | 5.9000 | 6.5000 | 107.8750 | 53320.00 | 21080.00 | 10540.00 | 86 | 16 | 440 | 1453 | 0.302821748107364 | 0.587125685804332 | 0.587125685804332 | false | false | false | |||||||||||||||||
| d4458cfa-9f7f-42f3-91b2-96260349c783 | 2026-09-03 10:17 | 2026-09-03 10:17 | 2026-09-03 10:17 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 8.7000 | 8.4000 | 9.1000 | 103.7750 | 21750.00 | 4350.00 | 8700.00 | 25 | 5 | 327 | 1453 | 0.225051617343427 | 0.592643043191578 | 0.592643043191578 | false | false | false | |||||||||||||||||
| 707b13a3-3574-4520-98d5-86b53084981c | 2026-09-03 10:17 | 2026-09-03 10:16 | 2026-09-03 10:16 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 8.7000 | 8.7000 | 9.3000 | 103.7500 | 54810.00 | 0.00 | 54810.00 | 63 | 5 | 290 | 1453 | 0.199587061252581 | 0.590499702771784 | 0.590499702771784 | false | false | false | |||||||||||||||||
| d9a10547-b639-4f23-b016-766c6f78c60e | 2026-09-03 10:01 | 2026-09-03 10:01 | 2026-09-03 10:01 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 8.0000 | 7.5000 | 8.4000 | 104.7100 | 24000.00 | 13600.00 | 5600.00 | 30 | 5 | 102 | 1453 | 0.0701995870612526 | 0.58061320532137 | 0.58061320532137 | false | false | false | |||||||||||||||||
| 0f4b55a0-ff8b-4fc9-b2dd-019ee13afbb0 | 2026-09-03 09:45 | 2026-09-03 09:45 | 2026-09-03 09:45 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 8.4000 | 7.3000 | 8.4000 | 104.2000 | 42000.00 | 42000.00 | 0.00 | 50 | 5 | 51 | 1453 | 0.0350997935306263 | 0.589802477268738 | 0.589802477268738 | false | false | false | |||||||||||||||||
| 08ea66ae-605f-47fb-b98f-0be495dc8076 | 2026-08-27 12:12 | 2026-08-27 12:12 | 2026-08-27 12:12 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 4.2000 | 4.1000 | 4.4000 | 115.5400 | 147420.00 | 76440.00 | 70980.00 | 351 | 10 | 368 | 1229 | 0.299430431244915 | 0.608108929770708 | 0.608108929770708 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:48:49.580975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:48:49.580975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| 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 |