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 |
|---|
| 1253889f-12b3-4404-85db-7ca2957400b6 | 2026-09-29 09:58 | 2026-09-29 09:58 | 2026-09-29 09:58 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 0.9000 | 0.8400 | 0.9000 | 5.0000 | 27090.00 | 27090.00 | 0.00 | 301 | 28 | 304 | 38867 | 0.00782154526976613 | 0.68141638231339 | 0.68141638231339 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 7673833538.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T13:59:42.347553Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 291301f7-355c-486e-86ed-32527070e49e | 2026-09-28 09:43 | 2026-09-28 09:43 | 2026-09-28 09:43 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 0.8900 | 0.8700 | 0.9100 | 5.2450 | 13350.00 | 3115.00 | 10235.00 | 150 | 5 | 350 | 38841 | 0.00901109652171674 | 0.656994647681327 | 0.656994647681327 | false | false | false | true | ||||||||||||||||
| e8e00aaf-75e0-40e3-93c8-aca21efcf879 | 2026-09-24 09:40 | 2026-09-24 09:40 | 2026-09-24 09:40 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 0.9400 | 0.9300 | 1.0000 | 5.3250 | 14194.00 | 0.00 | 14194.00 | 151 | 5 | 151 | 39176 | 0.0038544006534613 | 0.642904394363734 | 0.642904394363734 | false | false | false | true | ||||||||||||||||
| bb8406cf-005c-4322-b5e7-7293161e468c | 2026-09-23 11:36 | 2026-09-23 11:36 | 2026-09-23 11:36 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 0.9400 | 0.9200 | 0.9900 | 5.2850 | 47000.00 | 33370.00 | 13630.00 | 500 | 6 | 2063 | 37164 | 0.0555107092885588 | 0.663680476857095 | 0.663680476857095 | false | false | false | true | ||||||||||||||||
| 6c9cc289-481c-4e7c-b639-1d67bb3de360 | 2026-09-23 10:22 | 2026-09-23 10:22 | 2026-09-23 10:22 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 0.9700 | 0.9500 | 0.9700 | 5.3350 | 10864.00 | 10864.00 | 0.00 | 112 | 11 | 875 | 37164 | 0.023544290173286 | 0.661437970668059 | 0.661437970668059 | false | false | false | true | ||||||||||||||||
| 4cd4265d-c979-4fd7-b1f3-0940364dca22 | 2026-09-18 09:43 | 2026-09-18 09:43 | 2026-09-18 09:43 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 1.1500 | 1.1200 | 1.2400 | 5.5750 | 57500.00 | 49450.00 | 8050.00 | 500 | 13 | 500 | 39904 | 0.0125300721732157 | 0.662205027815834 | 0.662205027815834 | false | false | false | true | ||||||||||||||||
| fb31bbfa-6a91-4ac2-9fc3-6003a7efb9c0 | 2026-09-09 12:22 | 2026-09-09 12:21 | 2026-09-09 12:21 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 0.9400 | 0.9200 | 0.9400 | 5.2300 | 28200.00 | 28200.00 | 0.00 | 300 | 10 | 1045 | 40502 | 0.0258011950027159 | 0.655590901503639 | 0.655045024930059 | false | false | false | true | ||||||||||||||||
| 3cd81742-69e4-4538-86bd-799c9d5200c8 | 2026-09-09 09:41 | 2026-09-09 09:40 | 2026-09-09 09:40 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 1.0000 | 0.9700 | 1.0000 | 5.3100 | 19999.00 | 19999.00 | 0.00 | 200 | 8 | 240 | 40502 | 0.00592563330205916 | 0.662415675023891 | 0.653830319210235 | false | false | false | true | ||||||||||||||||
| f83bd13a-5abb-41ed-95b0-a18ce0457946 | 2026-09-03 11:02 | 2026-09-03 11:02 | 2026-09-03 11:02 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 1.2700 | 1.2700 | 1.3100 | 5.7050 | 15875.00 | 0.00 | 15875.00 | 125 | 7 | 604 | 40778 | 0.0148119083819707 | 0.645900063305341 | 0.645900063305341 | false | false | false | true | ||||||||||||||||
| b8686217-c5bf-4be5-8b05-c896fea827cf | 2026-09-01 10:59 | 2026-09-01 10:59 | 2026-09-01 10:59 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 1.0400 | 1.0400 | 1.0900 | 5.4000 | 30809.00 | 0.00 | 30809.00 | 295 | 9 | 401 | 41045 | 0.0097697648921915 | 0.624832320292354 | 0.624832320292354 | false | false | false | true | ||||||||||||||||
| 1bccbf33-4f13-4f16-b711-a45e89e290c3 | 2026-08-31 09:35 | 2026-08-31 09:35 | 2026-08-31 09:35 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 1.2100 | 1.1500 | 1.2100 | 5.5900 | 35695.00 | 35695.00 | 0.00 | 295 | 9 | 303 | 40650 | 0.00745387453874539 | 0.655688603283067 | 0.655688603283067 | false | false | false | true | ||||||||||||||||
| 9ce5c8d0-3da8-4a63-a678-605ca783f5d1 | 2026-08-27 13:06 | 2026-08-27 13:06 | 2026-08-27 13:06 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 1.1700 | 1.1400 | 1.1700 | 5.5034 | 19773.00 | 19773.00 | 0.00 | 169 | 5 | 371 | 40540 | 0.00915145535273804 | 0.662277442551131 | 0.662277442551131 | false | false | false | true | ||||||||||||||||
| da1b73e2-55a4-4a5b-9a4a-738f30a6434c | 2026-08-24 15:59 | 2026-08-24 15:59 | 2026-08-24 15:59 | SNAP | SNAP270115C00005000 | call | 5.0000 | 2027-01-15 | 1.1800 | 1.1800 | 1.2100 | 5.5400 | 11800.00 | 0.00 | 11800.00 | 100 | 12 | 993 | 40989 | 0.0242260118568396 | 0.642281636016679 | 0.642281636016679 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 7501387840.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:43:35.547112Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 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-24T13:42:52.039375Z"} |
| 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-23T15:41:14.023510Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T14:22:47.791063Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 7946872559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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-09T16:45:40.179334Z"} |
| 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-09T13:46:31.810255Z"} |
| 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-03T15:12:38.137640Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:18:08.991662Z"} |
| 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-31T13:47:44.562652Z"} |
| 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-27T17:21:32.961774Z"} |
| 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-25T13:32:26.163070Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |