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_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 | 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 |
|---|
| 6d3d20d0-aee1-4da9-abef-fab57b282e22 | 2026-09-24 14:33 | 2026-09-24 14:33 | 2026-09-24 14:33 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.5500 | 0.5400 | 0.5500 | 5.3100 | 40535.00 | 40535.00 | 0.00 | 737 | 43 | 2954 | 33717 | 0.0876115905922828 | 0.661730738054204 | 0.661730738054204 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 7601981164.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T18:38:47.854858Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 4f7211dd-14f8-4472-ba8b-cdc245610580 | 2026-09-24 12:39 | 2026-09-24 12:39 | 2026-09-24 12:39 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.5600 | 0.5400 | 0.5700 | 5.3150 | 30968.00 | 15288.00 | 15680.00 | 553 | 24 | 943 | 33717 | 0.0279680873150043 | 0.668311159062197 | 0.668311159062197 | true | false | false | true | ||||||||||||||||
| 2955e428-4259-4be5-8e75-a3400608cccc | 2026-09-24 12:33 | 2026-09-24 12:33 | 2026-09-24 12:33 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.5600 | 0.5300 | 0.5600 | 5.3100 | 10864.00 | 10864.00 | 0.00 | 194 | 33 | 381 | 33717 | 0.0112999377168787 | 0.670264852039148 | 0.670264852039148 | false | false | false | true | false | |||||||||||||||
| 5ab92abe-22c4-4365-945e-e930ae0572c5 | 2026-09-23 14:10 | 2026-09-23 14:10 | 2026-09-23 14:10 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.5500 | 0.5300 | 0.5600 | 5.2850 | 27500.00 | 27500.00 | 0.00 | 500 | 6 | 3328 | 30191 | 0.110231525951442 | 0.668515916024913 | 0.668515916024913 | false | false | false | true | false | |||||||||||||||
| 07284fc0-6af6-4171-9eff-99abfbea46ea | 2026-09-22 10:50 | 2026-09-22 10:50 | 2026-09-22 10:50 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.7300 | 0.7300 | 0.7500 | 5.6950 | 36719.00 | 0.00 | 36719.00 | 503 | 17 | 1012 | 30466 | 0.0332173570537648 | 0.647779384163417 | 0.647779384163417 | false | false | false | true | false | |||||||||||||||
| d0a43e1e-0267-44e5-8a71-1997151bbdeb | 2026-09-15 10:15 | 2026-09-15 10:15 | 2026-09-15 10:15 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.8700 | 0.8500 | 0.9500 | 5.9089 | 165352.00 | 0.00 | 165352.00 | 1900 | 6 | 3705 | 33459 | 0.110732538330494 | 0.651988607694322 | 0.651988607694322 | false | false | false | true | ||||||||||||||||
| 95f8d800-01b5-413b-a8cd-d3fd300e6375 | 2026-09-11 15:24 | 2026-09-11 15:24 | 2026-09-11 15:24 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.7700 | 0.7400 | 0.7700 | 5.7050 | 11781.00 | 11781.00 | 0.00 | 153 | 5 | 412 | 33857 | 0.0121688277165726 | 0.646546220495751 | 0.646546220495751 | false | false | false | true | false | |||||||||||||||
| bad1c4df-28ef-4502-a601-6ebc38c78431 | 2026-09-09 11:21 | 2026-09-09 11:20 | 2026-09-09 11:20 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.5900 | 0.5900 | 0.6200 | 5.3250 | 14573.00 | 0.00 | 14573.00 | 247 | 7 | 452 | 33900 | 0.0133333333333333 | 0.647131576357993 | 0.647131576357993 | false | false | false | true | false | |||||||||||||||
| 27dc1c51-bd04-4fe1-830d-d2c60ff38b33 | 2026-09-02 13:54 | 2026-09-02 13:54 | 2026-09-02 13:54 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.7700 | 0.7600 | 0.8000 | 5.6600 | 13398.00 | 4774.00 | 8624.00 | 174 | 5 | 987 | 35605 | 0.0277208257267238 | 0.638277216023232 | 0.638277216023232 | false | false | false | true | false | |||||||||||||||
| 42f7ada8-4e69-469e-b4a1-88447746a407 | 2026-09-01 11:42 | 2026-09-01 11:42 | 2026-09-01 11:42 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.6300 | 0.6300 | 0.6400 | 5.3755 | 12474.00 | 0.00 | 12474.00 | 198 | 17 | 743 | 36174 | 0.0205396140874661 | 0.638932539751248 | 0.638932539751248 | false | false | false | true | false | |||||||||||||||
| 4effd457-37e9-419b-8b93-90fff9cadb46 | 2026-08-26 15:33 | 2026-08-26 15:32 | 2026-08-26 15:32 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.7200 | 0.7100 | 0.7200 | 5.4600 | 144000.00 | 144000.00 | 0.00 | 2000 | 39 | 5578 | 32065 | 0.173959145485732 | 0.660393852015838 | 0.660393852015838 | true | false | false | true | ||||||||||||||||
| f9f74bae-422d-4681-9b14-23e39de5670d | 2026-08-26 12:30 | 2026-08-26 12:30 | 2026-08-26 12:30 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.6800 | 0.6600 | 0.6900 | 5.3900 | 14960.00 | 2176.00 | 12784.00 | 220 | 6 | 2230 | 32065 | 0.0695462342117574 | 0.656637594188575 | 0.656637594188575 | false | false | false | true | ||||||||||||||||
| df82b4cb-b100-4878-b409-431d125bd3e1 | 2026-08-26 11:29 | 2026-08-26 11:28 | 2026-08-26 11:28 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.7000 | 0.7000 | 0.7100 | 5.4750 | 14027.00 | 1917.00 | 12110.00 | 200 | 12 | 1429 | 32065 | 0.0445657258693279 | 0.638280468792451 | 0.647469124768466 | false | false | false | true | ||||||||||||||||
| 7bebeae7-67d9-42c5-bb41-cc7a02ecbe70 | 2026-08-25 15:59 | 2026-08-25 15:59 | 2026-08-25 15:59 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.9500 | 0.9500 | 0.9800 | 5.9300 | 28500.00 | 0.00 | 28500.00 | 300 | 21 | 2412 | 32806 | 0.0735231360117052 | 0.639419104706123 | 0.639419104706123 | false | false | false | true | ||||||||||||||||
| 413bbf5e-97fa-4210-9161-ce34d1f3bdcc | 2026-08-25 15:58 | 2026-08-25 15:58 | 2026-08-25 15:58 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.9400 | 0.9400 | 0.9600 | 5.9112 | 23406.00 | 0.00 | 23406.00 | 249 | 17 | 1899 | 32806 | 0.0578857526062306 | 0.63853884216452 | 0.640062910899238 | false | false | false | true | false | |||||||||||||||
| 0097a059-4049-4115-9ab9-28735031da6b | 2026-08-25 15:57 | 2026-08-25 15:57 | 2026-08-25 15:57 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.9400 | 0.9300 | 0.9600 | 5.9050 | 18800.00 | 0.00 | 18800.00 | 200 | 5 | 1650 | 32806 | 0.0502956776199476 | 0.642548415685313 | 0.642548415685313 | false | false | false | true | false | |||||||||||||||
| 741f015f-f844-47ec-9b61-5c8e340d2fd0 | 2026-08-24 11:15 | 2026-08-24 11:15 | 2026-08-24 11:15 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.6400 | 0.6400 | 0.6600 | 5.3850 | 25472.00 | 0.00 | 25472.00 | 398 | 7 | 763 | 32212 | 0.0236868247857941 | 0.623911021182095 | 0.623911021182095 | false | false | false | true | false | |||||||||||||||
| 2bb1d537-1ed1-4d2d-a0dc-64dd4b4ce63d | 2026-08-19 14:24 | 2026-08-19 14:24 | 2026-08-19 14:24 | SNAP | SNAP270115C00006000 | call | 6.0000 | 2027-01-15 | 0.6000 | 0.5800 | 0.6000 | 5.2250 | 11160.00 | 11160.00 | 0.00 | 186 | 10 | 616 | 27512 | 0.0223902297179413 | 0.63909365524684 | 0.63909365524684 | false | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 7601981164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:41:33.894916Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 7601981164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:36:42.025876Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 7601981164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:11:21.793472Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8076206832.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:51:29.790694Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:05:44.095975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8392357277.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |