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_alerts425,429 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 |
|---|
| c7bc4d86-cf98-43f3-8e61-536d006e1d61 | 2026-08-17 09:35 | 2026-08-17 09:35 | 2026-08-17 09:35 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 2.6900 | 2.6700 | 2.7500 | 150.4700 | 14532.00 | 12380.00 | 2152.00 | 54 | 8 | 195 | 12186 | 0.0160019694731659 | 0.723568158591545 | 0.718493154272006 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 42655640476.00 | 2026-10-29 | 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 |
| ce4ec769-a29d-4d5e-8483-e9356f13fd66 | 2026-08-17 09:36 | 2026-08-17 09:36 | 2026-08-17 09:36 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 2.7200 | 2.7200 | 2.8300 | 150.5675 | 27200.00 | 0.00 | 15504.00 | 100 | 6 | 303 | 12186 | 0.0248645987198424 | 0.717561844796418 | 0.717561844796418 | false | false | false | true | ||||||||||||||||
| aba4650b-8545-4556-930c-933f854bc01d | 2026-08-17 09:51 | 2026-08-17 09:51 | 2026-08-17 09:51 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 2.6000 | 2.6000 | 2.6900 | 150.3101 | 26006.00 | 0.00 | 26006.00 | 100 | 5 | 1014 | 12186 | 0.0832102412604628 | 0.718080042802919 | 0.712967734437154 | false | false | false | true | ||||||||||||||||
| d3aa3ffb-5a1e-4bf6-836b-da60561c7c2a | 2026-08-18 09:32 | 2026-08-18 09:31 | 2026-08-18 09:31 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 1.9100 | 1.9100 | 2.0000 | 149.0200 | 17190.00 | 0.00 | 17190.00 | 90 | 8 | 259 | 12898 | 0.0200806326562258 | 0.769904250770152 | 0.769904250770152 | true | false | false | true | ||||||||||||||||
| 2e546a17-fd48-4159-9e24-954a00786157 | 2026-08-18 13:33 | 2026-08-18 13:33 | 2026-08-18 13:33 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 1.5600 | 1.5400 | 1.5600 | 148.7700 | 39000.00 | 39000.00 | 0.00 | 250 | 5 | 4530 | 12898 | 0.351217242983408 | 0.70941412784219 | 0.70941412784219 | false | false | false | true | ||||||||||||||||
| 385d6720-f99f-4b6e-9952-1e4ba9d1c121 | 2026-08-19 09:31 | 2026-08-19 09:31 | 2026-08-19 09:31 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 1.7000 | 1.4100 | 1.7000 | 149.3400 | 19210.00 | 19210.00 | 0.00 | 113 | 13 | 301 | 13014 | 0.0231289380666974 | 0.864255332715135 | 0.864255332715135 | false | false | false | true | ||||||||||||||||
| 3f662a94-6643-4c7e-91be-f88bce77e48f | 2026-08-19 09:31 | 2026-08-19 09:31 | 2026-08-19 09:31 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 1.7600 | 1.7500 | 2.0000 | 150.0800 | 52701.00 | 11264.00 | 17325.00 | 300 | 15 | 724 | 13014 | 0.0556323958813585 | 0.819528770094582 | 0.819528770094582 | false | false | false | true | ||||||||||||||||
| 995b8d52-3a07-472b-a1f1-a7c5e5602761 | 2026-08-19 09:37 | 2026-08-19 09:37 | 2026-08-19 09:37 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 1.9500 | 1.9500 | 2.0600 | 150.6550 | 19500.00 | 0.00 | 19500.00 | 100 | 8 | 2008 | 13014 | 0.154295374212387 | 0.823411990860149 | 0.823411990860149 | false | false | false | true | ||||||||||||||||
| 0ba67e43-7844-4616-9e1f-8c2269f17528 | 2026-08-19 10:03 | 2026-08-19 10:03 | 2026-08-19 10:03 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 2.4800 | 2.3200 | 2.6000 | 152.6900 | 10180.00 | 9680.00 | 500.00 | 41 | 13 | 3232 | 13014 | 0.248347932995236 | 0.822219261568693 | 0.775507075711635 | true | false | false | true | ||||||||||||||||
| 741a3260-56d7-4a64-934e-aa034a4bf0a6 | 2026-08-19 10:06 | 2026-08-19 10:06 | 2026-08-19 10:06 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 3.0000 | 2.9000 | 3.0000 | 153.4350 | 36000.00 | 36000.00 | 0.00 | 120 | 11 | 3794 | 13014 | 0.291532196096511 | 0.816219571919754 | 0.816219571919754 | false | false | false | true | ||||||||||||||||
| 7af1b148-8599-4a91-96cb-46f39a26d2da | 2026-08-19 10:07 | 2026-08-19 10:07 | 2026-08-19 10:07 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 3.0500 | 2.9200 | 3.0500 | 153.4000 | 36881.00 | 36881.00 | 0.00 | 121 | 27 | 4089 | 13014 | 0.314200092208391 | 0.817468457138316 | 0.83083672015148 | true | false | false | true | ||||||||||||||||
| 44c7c412-9b3e-4367-8ad8-622ef8fb5578 | 2026-08-19 10:16 | 2026-08-19 10:16 | 2026-08-19 10:16 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 3.2100 | 3.1500 | 3.3000 | 154.1150 | 65722.00 | 0.00 | 65722.00 | 205 | 15 | 5110 | 13014 | 0.392654064853235 | 0.791221809963928 | 0.800028915531642 | false | false | false | true | ||||||||||||||||
| f77ac74d-e71d-42d3-abf4-f08f213155d6 | 2026-08-19 10:16 | 2026-08-19 10:16 | 2026-08-19 10:16 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 3.2500 | 3.1000 | 3.3000 | 154.0075 | 13961.00 | 13641.00 | 320.00 | 43 | 12 | 5165 | 13014 | 0.396880282772399 | 0.813428375481621 | 0.813428375481621 | true | false | false | true | ||||||||||||||||
| a418d218-fc1a-48ea-ab3e-90d5e09f9aaf | 2026-08-19 11:11 | 2026-08-19 11:10 | 2026-08-19 11:10 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 6.4800 | 6.2500 | 6.6500 | 159.5100 | 13605.00 | 13605.00 | 0.00 | 21 | 10 | 6978 | 13014 | 0.536191793453204 | 0.835840824923297 | 0.795513153463164 | true | false | false | true | ||||||||||||||||
| 5f7ad2f7-98f3-406a-97f4-e7bc4844ed4b | 2026-08-19 11:26 | 2026-08-19 11:26 | 2026-08-19 11:26 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 7.6500 | 7.4000 | 7.6500 | 161.0590 | 11475.00 | 11475.00 | 0.00 | 15 | 6 | 7042 | 13014 | 0.541109574304595 | 0.828448915549833 | 0.828448915549833 | false | false | false | true | ||||||||||||||||
| 16bb6a60-93ae-43b6-b7e3-33ec26cd7a4d | 2026-08-20 09:36 | 2026-08-20 09:36 | 2026-08-20 09:36 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 12.0600 | 12.0000 | 13.9500 | 166.5900 | 162854.00 | 18220.00 | 144634.00 | 135 | 11 | 296 | 9152 | 0.0323426573426573 | 1.0955154235851 | 1.11951978478583 | true | false | false | true | ||||||||||||||||
| 08ef8f00-01f8-4455-b9d4-5c9eb43d0a0d | 2026-08-20 09:37 | 2026-08-20 09:37 | 2026-08-20 09:37 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 12.8800 | 12.7500 | 13.8500 | 167.5700 | 64388.00 | 0.00 | 64388.00 | 50 | 14 | 346 | 9152 | 0.0378059440559441 | 1.06114363673218 | 1.06114363673218 | false | false | false | true | ||||||||||||||||
| fc921e8b-db40-4612-b2f3-50deb9953ee5 | 2026-08-20 10:49 | 2026-08-20 10:49 | 2026-08-20 10:49 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 14.8500 | 14.1000 | 15.3500 | 169.6500 | 105435.00 | 105435.00 | 0.00 | 71 | 6 | 556 | 9152 | 0.0607517482517482 | 1.04767734402747 | 1.04767734402747 | true | false | false | true | ||||||||||||||||
| ef1a6848-bef8-44d8-a546-c836a4e5b0f8 | 2026-08-20 14:48 | 2026-08-20 14:47 | 2026-08-20 14:47 | COIN | COIN260821C00155000 | call | 155.0000 | 2026-08-21 | 16.4000 | 15.7000 | 16.4000 | 171.2000 | 90200.00 | 90200.00 | 0.00 | 55 | 9 | 1128 | 9152 | 0.123251748251748 | 1.1302108015975 | 1.1302108015975 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |