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 |
|---|
| 90424e8c-540a-46d3-8f52-5587dc2972aa | 2026-09-29 13:26 | 2026-09-29 13:26 | 2026-09-29 13:26 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 12.0000 | 11.7500 | 12.1000 | 728.9100 | 31200.00 | 31200.00 | 0.00 | 26 | 5 | 9607 | 644 | 14.917701863354 | 0.551537626908742 | 0.551537626908742 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1629126891164.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T17:28:10.749874Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| e6474055-3cff-4571-9855-220f8aa4e582 | 2026-09-29 13:22 | 2026-09-29 13:22 | 2026-09-29 13:22 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 10.2000 | 10.0000 | 10.6000 | 726.0000 | 13265.00 | 6125.00 | 7140.00 | 13 | 6 | 9465 | 644 | 14.6972049689441 | 0.535657834524111 | 0.541308966707849 | false | false | false | true | ||||||||||||||||
| a7a45a07-021e-4c42-ab2c-59a36317871a | 2026-09-29 13:19 | 2026-09-29 13:19 | 2026-09-29 13:19 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 7.9100 | 7.7000 | 7.9500 | 722.0100 | 248295.00 | 247505.00 | 790.00 | 314 | 9 | 9238 | 644 | 14.3447204968944 | 0.537340589015899 | 0.537340589015899 | false | false | false | true | ||||||||||||||||
| f4bfbe0d-8667-4e35-9c92-aac3af5a6430 | 2026-09-29 13:10 | 2026-09-29 13:10 | 2026-09-29 13:10 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 7.8000 | 7.7000 | 7.8500 | 721.6550 | 39000.00 | 3900.00 | 35100.00 | 50 | 32 | 8084 | 644 | 12.5527950310559 | 0.542345158283883 | 0.542345158283883 | true | false | false | true | ||||||||||||||||
| eec31294-7afe-4c35-b11a-db7a4d23e27f | 2026-09-29 13:06 | 2026-09-29 13:06 | 2026-09-29 13:06 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 5.1000 | 4.8500 | 5.6500 | 716.0699 | 22440.00 | 21930.00 | 510.00 | 44 | 7 | 7911 | 644 | 12.2841614906832 | 0.536347965400328 | 0.524080499018973 | true | false | false | true | ||||||||||||||||
| b1b8f0b2-cda2-42bb-989c-72eb4ee24c18 | 2026-09-29 13:04 | 2026-09-29 13:04 | 2026-09-29 13:04 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 5.6000 | 5.2000 | 5.6000 | 716.5100 | 12317.00 | 12317.00 | 0.00 | 22 | 7 | 7672 | 644 | 11.9130434782609 | 0.547104613072468 | 0.546410923237088 | false | false | false | true | ||||||||||||||||
| 22f64fd5-f774-4b41-ae5d-d68f5dd5b45a | 2026-09-29 12:51 | 2026-09-29 12:51 | 2026-09-29 12:51 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 6.5000 | 6.5000 | 6.6500 | 719.5100 | 14950.00 | 0.00 | 14950.00 | 23 | 7 | 7436 | 644 | 11.5465838509317 | 0.519133034241896 | 0.522739912270956 | true | false | false | true | ||||||||||||||||
| ae6cf481-2d88-4ab0-9d14-aefe1d859d33 | 2026-09-29 11:11 | 2026-09-29 11:11 | 2026-09-29 11:11 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 6.9000 | 6.9000 | 7.0000 | 720.0000 | 71760.00 | 0.00 | 71760.00 | 104 | 5 | 5212 | 644 | 8.09316770186335 | 0.507206518160561 | 0.507206518160561 | false | false | false | true | ||||||||||||||||
| 2be356f2-7b6e-4b34-be3f-3ecdbb0f8e8e | 2026-09-29 11:09 | 2026-09-29 11:08 | 2026-09-29 11:08 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 7.0000 | 6.9500 | 7.0500 | 721.0000 | 25200.00 | 0.00 | 24500.00 | 36 | 6 | 4996 | 644 | 7.75776397515528 | 0.508961644448607 | 0.508961644448607 | false | false | false | true | ||||||||||||||||
| 9ad86a6b-92c6-440d-96b3-eb7f4be93826 | 2026-09-29 11:00 | 2026-09-29 11:00 | 2026-09-29 11:00 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 7.4500 | 7.4000 | 7.6000 | 721.7350 | 35760.00 | 745.00 | 34270.00 | 48 | 13 | 4558 | 644 | 7.07763975155279 | 0.5165070756182 | 0.5165070756182 | false | false | false | true | ||||||||||||||||
| 1db31d74-6a2e-4fe1-b922-a24ee427cbe8 | 2026-09-29 10:34 | 2026-09-29 10:34 | 2026-09-29 10:34 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 7.4000 | 7.3500 | 7.6000 | 721.3400 | 45135.00 | 0.00 | 45135.00 | 61 | 14 | 3501 | 644 | 5.43633540372671 | 0.525975943195284 | 0.522653728192114 | false | false | false | true | ||||||||||||||||
| 4d588059-becc-4e1f-be28-d588880bffc6 | 2026-09-29 10:21 | 2026-09-29 10:21 | 2026-09-29 10:21 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 6.8500 | 6.8000 | 6.9000 | 720.2200 | 21920.00 | 16440.00 | 5480.00 | 32 | 5 | 2743 | 644 | 4.25931677018634 | 0.524592433129042 | 0.524592433129042 | false | false | false | true | ||||||||||||||||
| 4bdb0e93-f10e-4242-94aa-5eb3ff9be001 | 2026-09-29 10:18 | 2026-09-29 10:18 | 2026-09-29 10:18 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 7.8000 | 7.8000 | 8.0000 | 722.2596 | 17940.00 | 0.00 | 17940.00 | 23 | 10 | 2447 | 644 | 3.79968944099379 | 0.522434936239687 | 0.522434936239687 | true | false | false | true | ||||||||||||||||
| 8b5c20ee-5b57-438b-803f-786d954b4a5a | 2026-09-29 10:06 | 2026-09-29 10:06 | 2026-09-29 10:06 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 7.6500 | 7.4500 | 7.6500 | 721.1400 | 16830.00 | 16830.00 | 0.00 | 22 | 8 | 1834 | 644 | 2.84782608695652 | 0.549004559035929 | 0.549004559035929 | true | false | false | true | ||||||||||||||||
| 0b1a4aed-ba77-42b5-9421-f4495cff937b | 2026-09-29 09:56 | 2026-09-29 09:56 | 2026-09-29 09:56 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 8.7400 | 8.6500 | 8.8500 | 722.0000 | 15732.00 | 0.00 | 15732.00 | 18 | 6 | 1525 | 644 | 2.36801242236025 | 0.567237942404304 | 0.567237942404304 | false | false | false | true | ||||||||||||||||
| fde48669-cdf2-4876-9d05-e7361b3399d9 | 2026-09-29 09:38 | 2026-09-29 09:37 | 2026-09-29 09:37 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 11.1500 | 11.0500 | 11.4500 | 725.7650 | 44590.00 | 0.00 | 44590.00 | 40 | 9 | 582 | 644 | 0.903726708074534 | 0.60098765890847 | 0.613891819423365 | true | false | false | true | ||||||||||||||||
| e2b57c4c-1ca3-4596-8375-65c21f4a8201 | 2026-09-29 09:37 | 2026-09-29 09:37 | 2026-09-29 09:37 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 11.3000 | 10.9500 | 11.4500 | 726.4067 | 16950.00 | 15820.00 | 1130.00 | 15 | 7 | 454 | 644 | 0.704968944099379 | 0.620586018139463 | 0.606170365772878 | false | false | false | true | ||||||||||||||||
| e01da091-6528-4da7-9cb7-71d9950ad8f1 | 2026-09-22 09:51 | 2026-09-22 09:51 | 2026-09-22 09:51 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 35.0500 | 35.0000 | 37.0500 | 745.4550 | 45565.00 | 0.00 | 45565.00 | 13 | 13 | 16 | 56 | 0.285714285714286 | 0.489532434543583 | 0.489532434543583 | false | false | false | true | ||||||||||||||||
| a65b545f-1abc-4371-a07d-4a67d4136a60 | 2026-09-21 10:16 | 2026-09-21 10:16 | 2026-09-21 10:16 | META | META260930C00722500 | call | 722.5000 | 2026-09-30 | 17.2500 | 16.4000 | 18.4000 | 715.0000 | 20700.00 | 18975.00 | 1725.00 | 12 | 5 | 31 | 1 | 31 | 0.452716341946672 | 0.452197459391776 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:23:13.824260Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:23:13.824260Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:16:24.150546Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:09:02.591360Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:09:02.591360Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:54:42.907148Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:12:41.685966Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:12:41.685966Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:02:09.768473Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:37:12.234330Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:23:29.656550Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:20:45.817132Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:06:19.717900Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:39:45.253242Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:39:45.253242Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:52:22.219586Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:16:37.999315Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |