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_alerts326,449 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 |
|---|
| f0a75dd7-cc27-46ed-b6fb-f3680e65f002 | 2026-08-28 15:50 | 2026-08-28 15:50 | 2026-08-28 15:50 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 22.3500 | 22.0000 | 22.5000 | 576.7550 | 167639.00 | 167639.00 | 0.00 | 75 | 7 | 1064 | 2711 | 0.392475101438584 | 0.32983742707262 | 0.330022890801579 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 1467733535590.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T19:57:19.773601Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e45fe6ab-c31c-4b37-8b61-49421810db90 | 2026-08-24 15:17 | 2026-08-24 15:17 | 2026-08-24 15:17 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 16.8400 | 16.6000 | 17.0000 | 560.3650 | 223984.00 | 223984.00 | 0.00 | 133 | 8 | 427 | 2462 | 0.173436230706742 | 0.351065306018796 | 0.351065306018796 | false | false | false | true | ||||||||||||||||
| afa52d12-d520-4a18-a459-7c9b3f97de77 | 2026-08-21 12:50 | 2026-08-21 12:50 | 2026-08-21 12:50 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 14.4500 | 14.4500 | 14.6500 | 552.5700 | 117045.00 | 0.00 | 117045.00 | 81 | 7 | 515 | 2119 | 0.243039169419538 | 0.345703283745007 | 0.346009416142536 | true | false | false | true | ||||||||||||||||
| a2cc283f-f1a6-4c45-ae6a-72299cfb0a04 | 2026-08-21 12:18 | 2026-08-21 12:18 | 2026-08-21 12:18 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 13.4700 | 13.2000 | 13.5000 | 550.2900 | 111802.00 | 111802.00 | 0.00 | 83 | 6 | 389 | 2119 | 0.183577159037282 | 0.344633298100684 | 0.344633298100684 | false | false | false | true | ||||||||||||||||
| bdf206ca-9b8b-4efb-bd8f-7995cf4048ae | 2026-08-19 11:53 | 2026-08-19 11:52 | 2026-08-19 11:52 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 15.4100 | 15.3000 | 15.8000 | 552.1050 | 154110.00 | 0.00 | 154110.00 | 100 | 5 | 2232 | 1591 | 1.40289126335638 | 0.352497202029439 | 0.352497202029439 | false | false | false | true | ||||||||||||||||
| fc6c927e-2fdb-4bc9-ac67-163553afe091 | 2026-08-19 11:52 | 2026-08-19 11:52 | 2026-08-19 11:52 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 15.4500 | 15.3000 | 15.8000 | 552.2700 | 154468.00 | 0.00 | 154468.00 | 100 | 7 | 2132 | 1591 | 1.34003771213074 | 0.351890500322683 | 0.351890500322683 | false | false | false | true | ||||||||||||||||
| a060fb2b-248e-425c-9da9-cfae22ad7305 | 2026-08-19 11:14 | 2026-08-19 11:14 | 2026-08-19 11:14 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 13.3500 | 13.3000 | 13.7000 | 547.1550 | 267056.00 | 0.00 | 267056.00 | 200 | 6 | 1540 | 1591 | 0.967944688874921 | 0.350670348392572 | 0.350670348392572 | false | false | false | true | ||||||||||||||||
| a327e887-0cbe-450a-821d-70b6c4ded21e | 2026-08-19 11:11 | 2026-08-19 11:11 | 2026-08-19 11:11 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 13.6500 | 13.6000 | 14.1000 | 547.9700 | 273029.00 | 19110.00 | 253919.00 | 200 | 32 | 1337 | 1591 | 0.840351979886864 | 0.350040282559497 | 0.350071912246206 | true | false | false | true | ||||||||||||||||
| 39ad6fc0-4f49-48c5-bb55-a6a8dd7fc03a | 2026-08-19 10:49 | 2026-08-19 10:49 | 2026-08-19 10:49 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 13.9700 | 13.6000 | 14.0000 | 548.5300 | 139728.00 | 139728.00 | 0.00 | 100 | 8 | 1012 | 1591 | 0.63607793840352 | 0.351696429675016 | 0.35202983074932 | false | false | false | true | ||||||||||||||||
| aa5d2d27-6949-4a32-b23a-25ba3172e31e | 2026-08-19 10:49 | 2026-08-19 10:49 | 2026-08-19 10:49 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 13.9400 | 13.6000 | 14.0000 | 548.4300 | 139400.00 | 139400.00 | 0.00 | 100 | 5 | 912 | 1591 | 0.573224387177876 | 0.351999897122322 | 0.351999897122322 | false | false | false | true | ||||||||||||||||
| 74ca17c6-b4c0-4566-8409-3bb4e0d86db0 | 2026-08-19 10:18 | 2026-08-19 10:17 | 2026-08-19 10:17 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 13.4000 | 13.1500 | 13.5500 | 546.3700 | 108540.00 | 108540.00 | 0.00 | 81 | 5 | 286 | 1591 | 0.179761156505343 | 0.355923172214387 | 0.355923172214387 | false | false | false | true | ||||||||||||||||
| 3fee8357-e59c-40ec-a0fb-18fa7f74b13f | 2026-08-18 12:28 | 2026-08-18 12:28 | 2026-08-18 12:28 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 15.4800 | 15.2500 | 15.8000 | 552.3700 | 156299.00 | 0.00 | 156299.00 | 101 | 5 | 4044 | 1209 | 3.34491315136476 | 0.345531790092909 | 0.345531790092909 | false | false | false | true | ||||||||||||||||
| bef7c061-9465-4c21-a878-d75ee1855ebf | 2026-08-18 12:18 | 2026-08-18 12:17 | 2026-08-18 12:17 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 16.0400 | 15.8500 | 16.2500 | 553.7150 | 160436.00 | 0.00 | 102656.00 | 100 | 5 | 3840 | 1209 | 3.17617866004963 | 0.345741403165183 | 0.345741403165183 | false | false | false | true | ||||||||||||||||
| 37007ce4-fcce-466d-ada3-a0e752204586 | 2026-08-18 12:16 | 2026-08-18 12:16 | 2026-08-18 12:16 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 15.9500 | 15.9500 | 16.3000 | 553.4000 | 108460.00 | 0.00 | 108460.00 | 68 | 19 | 3739 | 1209 | 3.09263854425145 | 0.346242881120459 | 0.346242881120459 | true | false | false | true | ||||||||||||||||
| d54961d9-d13a-4d4e-8f04-ba4234c2584b | 2026-08-18 12:16 | 2026-08-18 12:16 | 2026-08-18 12:16 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 16.0300 | 16.0000 | 16.3000 | 553.4650 | 160259.00 | 0.00 | 160259.00 | 100 | 6 | 3639 | 1209 | 3.00992555831266 | 0.347241873985883 | 0.347241873985883 | false | false | false | true | ||||||||||||||||
| 400c0c2a-b267-4746-9e77-6d5b540d8af1 | 2026-08-18 10:54 | 2026-08-18 10:54 | 2026-08-18 10:54 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 14.4400 | 14.2000 | 14.5500 | 548.7400 | 144400.00 | 144400.00 | 0.00 | 100 | 5 | 2047 | 1209 | 1.69313482216708 | 0.352069028349393 | 0.352069028349393 | false | false | false | true | ||||||||||||||||
| 96028419-10dc-49e9-b1a1-a7658d7123d9 | 2026-08-17 13:29 | 2026-08-17 13:29 | 2026-08-17 13:29 | META | META260918C00570000 | call | 570.0000 | 2026-09-18 | 21.7500 | 21.7500 | 22.1500 | 566.3000 | 160950.00 | 0.00 | 160950.00 | 74 | 5 | 441 | 1266 | 0.348341232227488 | 0.338025574689432 | 0.338025574689432 | true | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| 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 |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| 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 |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |