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 |
|---|
| 52aea8ac-ae16-4bc2-9767-4f9c1cb7540d | 2026-08-20 09:51 | 2026-08-20 09:51 | 2026-08-20 09:51 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.5000 | 2.5000 | 2.6400 | 147.5800 | 27000.00 | 0.00 | 27000.00 | 108 | 7 | 305 | 719 | 0.424200278164117 | 0.602418464384198 | 0.602418464384198 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 23724237616.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fb3af95a-6f60-4baa-a3a3-31542b5503ed | 2026-08-20 09:52 | 2026-08-20 09:52 | 2026-08-20 09:52 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.5000 | 2.5000 | 2.6700 | 147.4500 | 19750.00 | 0.00 | 19750.00 | 79 | 11 | 484 | 719 | 0.673157162726008 | 0.607639969033677 | 0.607639969033677 | false | false | false | |||||||||||||||||
| d2540e75-a351-4a78-bd82-0d0ba43339f6 | 2026-08-20 09:52 | 2026-08-20 09:52 | 2026-08-20 09:52 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.5000 | 2.4400 | 2.7400 | 147.5201 | 24500.00 | 0.00 | 24500.00 | 98 | 9 | 405 | 719 | 0.563282336578581 | 0.604825783747571 | 0.604825783747571 | false | false | false | |||||||||||||||||
| 702876a6-e4ff-4188-99cf-6842fd82a6f5 | 2026-08-20 09:53 | 2026-08-20 09:53 | 2026-08-20 09:53 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.4800 | 2.4800 | 2.5300 | 147.5300 | 12400.00 | 0.00 | 12400.00 | 50 | 5 | 559 | 719 | 0.777468706536857 | 0.601828095238356 | 0.601828095238356 | false | false | false | |||||||||||||||||
| ae1a1cab-94fb-444e-b59e-93e28e72d06f | 2026-08-20 09:54 | 2026-08-20 09:53 | 2026-08-20 09:53 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.4900 | 2.3800 | 2.6200 | 147.2500 | 23399.00 | 243.00 | 12449.00 | 94 | 8 | 711 | 719 | 0.988873435326843 | 0.613032999443287 | 0.606472160002671 | true | false | false | |||||||||||||||||
| 27227ba9-bda1-439b-a6fa-0ce59bb3fa40 | 2026-08-20 10:05 | 2026-08-20 10:04 | 2026-08-20 10:04 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.4900 | 2.4400 | 2.5600 | 147.4500 | 20667.00 | 0.00 | 20667.00 | 83 | 5 | 887 | 719 | 1.2336578581363 | 0.606337780114981 | 0.606337780114981 | false | false | false | |||||||||||||||||
| 9f95bd08-c61c-444d-b3d6-dccdf1560e95 | 2026-08-20 10:05 | 2026-08-20 10:04 | 2026-08-20 10:04 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.4900 | 2.4900 | 2.5600 | 147.4400 | 16683.00 | 0.00 | 16683.00 | 67 | 10 | 966 | 719 | 1.34353268428373 | 0.606738640448531 | 0.606738640448531 | false | false | false | |||||||||||||||||
| de1a07dd-65a7-4a04-afef-0afbe0f260a5 | 2026-08-20 10:12 | 2026-08-20 10:12 | 2026-08-20 10:12 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.1900 | 2.1900 | 2.2500 | 146.5000 | 17958.00 | 0.00 | 3723.00 | 82 | 5 | 1189 | 719 | 1.65368567454798 | 0.60733291365358 | 0.60733291365358 | false | false | false | |||||||||||||||||
| 895d4e54-8bef-4eca-914f-60ca9fe8a290 | 2026-08-20 10:12 | 2026-08-20 10:12 | 2026-08-20 10:12 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.1900 | 2.0600 | 2.2500 | 146.5000 | 21462.00 | 3504.00 | 0.00 | 98 | 6 | 1107 | 719 | 1.53963838664812 | 0.603679087167993 | 0.603679087167993 | false | false | false | |||||||||||||||||
| f4f9a47f-be7f-4c4e-8650-7a084e375c79 | 2026-08-20 10:23 | 2026-08-20 10:23 | 2026-08-20 10:23 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.1000 | 2.1000 | 2.2100 | 145.8400 | 20580.00 | 0.00 | 20580.00 | 98 | 6 | 1545 | 719 | 2.14881780250348 | 0.616413727655125 | 0.616413727655125 | false | false | false | |||||||||||||||||
| 06ea16da-6688-4b4d-9509-98f6e3becb23 | 2026-08-20 10:42 | 2026-08-20 10:42 | 2026-08-20 10:42 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.0500 | 2.0500 | 2.2100 | 146.0600 | 12915.00 | 0.00 | 12915.00 | 63 | 6 | 1686 | 719 | 2.34492350486787 | 0.601101405864977 | 0.601101405864977 | false | false | false | |||||||||||||||||
| 08e2e15f-8827-4035-95a8-a7a5b10d8141 | 2026-08-20 10:42 | 2026-08-20 10:42 | 2026-08-20 10:42 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.0500 | 2.0500 | 2.1000 | 145.8100 | 16810.00 | 0.00 | 16810.00 | 82 | 5 | 1806 | 719 | 2.51182197496523 | 0.610521289008275 | 0.610521289008275 | false | false | false | |||||||||||||||||
| ae805f8d-d539-4772-8cf4-836e655db4d4 | 2026-08-21 10:06 | 2026-08-21 10:05 | 2026-08-21 10:05 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 4.5000 | 4.3500 | 4.6000 | 154.0950 | 16200.00 | 16200.00 | 0.00 | 36 | 8 | 442 | 2242 | 0.1971454058876 | 0.572580776517105 | 0.572580776517105 | false | false | false | |||||||||||||||||
| 6dcdf5f2-0014-4593-9d15-c85b60fcb12f | 2026-08-21 10:06 | 2026-08-21 10:05 | 2026-08-21 10:05 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 4.5000 | 4.3500 | 4.6000 | 154.1900 | 23400.00 | 6300.00 | 4500.00 | 52 | 6 | 593 | 2242 | 0.264495985727029 | 0.567097871791022 | 0.567097871791022 | false | false | false | |||||||||||||||||
| 52827a89-cc7c-49af-80bc-7b9fc11bc622 | 2026-08-21 10:06 | 2026-08-21 10:05 | 2026-08-21 10:05 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 4.5000 | 4.3500 | 4.5000 | 154.1900 | 44550.00 | 44550.00 | 0.00 | 99 | 10 | 541 | 2242 | 0.241302408563782 | 0.567097871791022 | 0.567097871791022 | false | false | false | |||||||||||||||||
| c10c6925-fa5f-49b0-9f63-6664b0b7f000 | 2026-08-21 10:07 | 2026-08-21 10:07 | 2026-08-21 10:07 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 4.3500 | 4.3500 | 4.6000 | 153.8900 | 29145.00 | 0.00 | 29145.00 | 67 | 7 | 663 | 2242 | 0.295718108831401 | 0.566667297924359 | 0.566667297924359 | false | false | false | |||||||||||||||||
| f0197c87-fe7a-4053-b22c-bd78aa92617f | 2026-08-24 13:24 | 2026-08-24 13:24 | 2026-08-24 13:24 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 2.4600 | 2.2800 | 2.4600 | 151.2950 | 145877.00 | 145632.00 | 245.00 | 593 | 53 | 1045 | 2550 | 0.409803921568627 | 0.628917654711419 | 0.627247139771061 | false | false | false | |||||||||||||||||
| eaaac651-b513-4105-bcd9-9794bc712211 | 2026-08-25 10:29 | 2026-08-25 10:29 | 2026-08-25 10:29 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 6.0000 | 5.5500 | 6.3000 | 158.6600 | 34800.00 | 34800.00 | 0.00 | 58 | 5 | 872 | 3142 | 0.277530235518778 | 0.688095456666507 | 0.681851931152212 | false | false | false | |||||||||||||||||
| de38c32a-1f8d-47e4-b1e4-aa4914887b2e | 2026-08-25 12:02 | 2026-08-25 12:02 | 2026-08-25 12:02 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 7.0000 | 6.8500 | 7.0000 | 160.2000 | 29400.00 | 29400.00 | 0.00 | 42 | 8 | 1138 | 3142 | 0.362189688096754 | 0.669619868479853 | 0.669619868479853 | true | false | false | |||||||||||||||||
| 93dcd738-11bd-49c2-a9cc-7446b1482faa | 2026-08-25 14:11 | 2026-08-25 14:11 | 2026-08-25 14:11 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 6.5300 | 6.2500 | 6.5500 | 159.0000 | 15019.00 | 15019.00 | 0.00 | 23 | 10 | 1365 | 3142 | 0.434436664544876 | 0.639498653941943 | 0.639498653941943 | false | false | false | |||||||||||||||||
| 2cce27ab-7ab2-4ae3-9394-c4f885840af7 | 2026-08-25 14:11 | 2026-08-25 14:11 | 2026-08-25 14:11 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 6.5400 | 6.2500 | 6.8000 | 159.0000 | 96826.00 | 33956.00 | 62870.00 | 148 | 10 | 1513 | 3142 | 0.481540420114577 | 0.629523033058837 | 0.63562150410692 | false | false | false | |||||||||||||||||
| ef19c189-33ae-460f-aba5-61b085b8ac4c | 2026-08-27 09:52 | 2026-08-27 09:52 | 2026-08-27 09:52 | RDDT | RDDT260828C00155000 | call | 155.0000 | 2026-08-28 | 4.0000 | 3.6500 | 4.1000 | 157.3150 | 39600.00 | 39600.00 | 0.00 | 99 | 5 | 340 | 1805 | 0.188365650969529 | 0.820282807879544 | 0.820282807879544 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:42:01.576369Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:29:52.792110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:00:28.149501Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |