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 | 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 |
|---|
| 174f133d-27b9-45d2-8cb5-7475bdf4ce61 | 2026-09-09 10:54 | 2026-09-09 10:53 | 2026-09-09 10:53 | GME | GME261016C00019000 | call | 19.0000 | 2026-10-16 | 1.4900 | 1.4900 | 1.5600 | 19.7450 | 15050.00 | 0.00 | 15050.00 | 101 | 5 | 549 | 9694 | 0.0566329688467093 | 0.423374503683727 | 0.419083120143637 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 10907311404.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b9bd46ba-a4b2-4b5f-bf15-033bf977accf | 2026-09-04 15:05 | 2026-09-04 15:05 | 2026-09-04 15:05 | GME | GME261016C00019000 | call | 19.0000 | 2026-10-16 | 1.4100 | 1.3800 | 1.4100 | 19.1650 | 24675.00 | 24675.00 | 0.00 | 175 | 11 | 1443 | 9273 | 0.155613070203818 | 0.497745015805583 | 0.497745015805583 | false | false | false | true | ||||||||||||||||
| 77348b78-7009-43ad-a1d0-f40e9a01ea59 | 2026-09-04 09:58 | 2026-09-04 09:58 | 2026-09-04 09:58 | GME | GME261016C00019000 | call | 19.0000 | 2026-10-16 | 1.3800 | 1.3800 | 1.5000 | 19.2100 | 16560.00 | 0.00 | 16560.00 | 120 | 7 | 566 | 9273 | 0.0610374204680255 | 0.476052092017442 | 0.476052092017442 | false | false | false | true | ||||||||||||||||
| 97aec0a1-1cae-480a-848f-921b5de9c040 | 2026-09-04 09:56 | 2026-09-04 09:56 | 2026-09-04 09:56 | GME | GME261016C00019000 | call | 19.0000 | 2026-10-16 | 1.4300 | 1.4300 | 1.5000 | 19.2700 | 42900.00 | 0.00 | 42900.00 | 300 | 15 | 442 | 9273 | 0.0476652647471153 | 0.482136491447859 | 0.482136491447859 | false | false | false | true | ||||||||||||||||
| 1f2d0ec0-5fd9-473c-9b0c-1080826797c8 | 2026-09-01 15:46 | 2026-09-01 15:46 | 2026-09-01 15:46 | GME | GME261016C00019000 | call | 19.0000 | 2026-10-16 | 1.3500 | 1.2900 | 1.3700 | 18.8600 | 30780.00 | 20520.00 | 10260.00 | 228 | 34 | 1294 | 9210 | 0.140499457111835 | 0.5203277906221 | 0.5203277906221 | true | false | false | true | ||||||||||||||||
| edb474b7-14b2-4eb5-83b2-80ce7bcc7177 | 2026-08-31 11:24 | 2026-08-31 11:24 | 2026-08-31 11:24 | GME | GME261016C00019000 | call | 19.0000 | 2026-10-16 | 1.1700 | 1.1600 | 1.2500 | 18.7100 | 75389.00 | 585.00 | 74686.00 | 644 | 37 | 1697 | 8607 | 0.197165098175903 | 0.485464437178042 | 0.475991640099904 | false | false | false | true | ||||||||||||||||
| 3efcb0db-ceba-425a-ae08-3f3f2f4c479e | 2026-08-27 14:45 | 2026-08-27 14:45 | 2026-08-27 14:45 | GME | GME261016C00019000 | call | 19.0000 | 2026-10-16 | 1.1800 | 1.1500 | 1.1900 | 18.1910 | 10738.00 | 10738.00 | 0.00 | 91 | 6 | 547 | 8295 | 0.0659433393610609 | 0.551937199104993 | 0.551937199104993 | false | false | false | true | ||||||||||||||||
| 247c71c6-9872-4564-b40c-eea6925a368c | 2026-08-27 12:18 | 2026-08-27 12:18 | 2026-08-27 12:18 | GME | GME261016C00019000 | call | 19.0000 | 2026-10-16 | 1.1700 | 1.1500 | 1.1900 | 18.2800 | 18562.00 | 4522.00 | 14040.00 | 158 | 9 | 291 | 8295 | 0.0350813743218807 | 0.532668265163917 | 0.540095764910649 | false | false | false | true | ||||||||||||||||
| 4d152abb-53ce-4903-998c-39f3d5e73605 | 2026-08-17 15:58 | 2026-08-17 15:58 | 2026-08-17 15:58 | GME | GME261016C00019000 | call | 19.0000 | 2026-10-16 | 1.1200 | 1.0300 | 1.1200 | 18.3799 | 11200.00 | 11200.00 | 0.00 | 100 | 11 | 1409 | 5724 | 0.246156533892383 | 0.450634670041397 | 0.450634670041397 | false | false | false | true | ||||||||||||||||
| 5b8e211d-569b-466f-87bb-c06751bc141a | 2026-08-17 15:56 | 2026-08-17 15:56 | 2026-08-17 15:56 | GME | GME261016C00019000 | call | 19.0000 | 2026-10-16 | 1.1000 | 1.0400 | 1.1200 | 18.3750 | 22019.00 | 8176.00 | 13843.00 | 200 | 5 | 1109 | 5724 | 0.193745632424878 | 0.451423009389766 | 0.441311175603804 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:31:29.863287Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |