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.
Simplify Analyticsuw_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 |
|---|
| 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 |
|---|
| 1b66b9f3-7b7f-43fa-b024-d99fe2d8f604 | 2026-08-19 12:05 | 2026-08-19 12:05 | 2026-08-19 12:05 | HAL | HAL261016C00036000 | call | 36.0000 | 2026-10-16 | 1.5600 | 1.5200 | 1.5600 | 35.0950 | 35879.00 | 35724.00 | 155.00 | 230 | 17 | 266 | 1940 | 0.137113402061856 | 0.332692643928179 | 0.334490038911496 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 29167894149.00 | 2026-10-20 | 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 |
| 9d0b2695-1c43-4656-8d9d-a459ffa034f4 | 2026-08-19 11:47 | 2026-08-19 11:47 | 2026-08-19 11:47 | HAL | HAL260918P00035000 | put | 35.0000 | 2026-09-18 | 1.3500 | 1.2800 | 1.3500 | 35.0250 | 106515.00 | 106515.00 | 0.00 | 789 | 19 | 821 | 6551 | 0.125324377957564 | 0.354250337034532 | 0.354250337034532 | false | false | false | true | false | |||||||||||||||
| ee8c2945-f64f-4bd1-bcec-aa733f2ef397 | 2026-08-19 10:19 | 2026-08-19 10:19 | 2026-08-19 10:19 | HAL | HAL260828C00034000 | call | 34.0000 | 2026-08-28 | 1.4800 | 1.4400 | 1.5600 | 35.1200 | 20128.00 | 19832.00 | 296.00 | 136 | 20 | 424 | 883 | 0.480181200453001 | 0.358478806244479 | 0.356459819412913 | true | false | false | true | false | |||||||||||||||
| ffeb3a54-2983-4b00-9f47-d9b56237933c | 2026-08-18 13:17 | 2026-08-18 13:17 | 2026-08-18 13:17 | HAL | HAL270319C00037000 | call | 37.0000 | 2027-03-19 | 2.8900 | 2.8900 | 2.9500 | 34.6550 | 17629.00 | 0.00 | 17629.00 | 61 | 14 | 120 | 363 | 0.330578512396694 | 0.333375764828208 | 0.333375764828208 | false | false | false | true | false | |||||||||||||||
| d5391b23-aaf5-46be-8f8a-7a94b761ca45 | 2026-08-18 11:08 | 2026-08-18 11:08 | 2026-08-18 11:08 | HAL | HAL260918C00035000 | call | 35.0000 | 2026-09-18 | 1.2100 | 1.2100 | 1.2500 | 34.8350 | 15004.00 | 0.00 | 15004.00 | 124 | 30 | 563 | 28896 | 0.019483665559247 | 0.304967956503512 | 0.304967956503512 | true | false | false | true | false | |||||||||||||||
| 91a7c44a-d422-44b0-a89d-d4f71c610106 | 2026-08-18 11:08 | 2026-08-18 11:08 | 2026-08-18 11:08 | HAL | HAL260918C00035000 | call | 35.0000 | 2026-09-18 | 1.2400 | 1.2400 | 1.2700 | 34.8300 | 11532.00 | 0.00 | 11532.00 | 93 | 13 | 241 | 28896 | 0.00834025470653378 | 0.313009912048769 | 0.313009912048769 | true | false | false | true | false | |||||||||||||||
| 4b450804-a5a4-4bab-9a63-3583572780bc | 2026-08-18 09:51 | 2026-08-18 09:51 | 2026-08-18 09:51 | HAL | HAL260918P00034000 | put | 34.0000 | 2026-09-18 | 0.9000 | 0.9000 | 0.9500 | 34.9489 | 65161.00 | 91.00 | 65070.00 | 724 | 65 | 1052 | 4648 | 0.226333907056799 | 0.341177681194076 | 0.341177681194076 | true | false | false | true | false | |||||||||||||||
| 48fb5801-5a20-4adb-8d63-67f2c9af971c | 2026-08-18 09:51 | 2026-08-18 09:51 | 2026-08-18 09:51 | HAL | HAL260918P00034000 | put | 34.0000 | 2026-09-18 | 0.9100 | 0.8800 | 0.9100 | 34.9450 | 11102.00 | 11102.00 | 0.00 | 122 | 5 | 275 | 4648 | 0.0591652323580034 | 0.343432897069617 | 0.343432897069617 | false | false | false | true | false | |||||||||||||||
| a7a3e4ea-a88f-498b-95c2-d4ceedacc606 | 2026-08-17 13:17 | 2026-08-17 13:17 | 2026-08-17 13:17 | HAL | HAL261016C00040000 | call | 40.0000 | 2026-10-16 | 0.3900 | 0.3500 | 0.4000 | 34.3700 | 37089.00 | 35607.00 | 858.00 | 951 | 38 | 1085 | 697 | 1.55667144906743 | 0.343248970036418 | 0.342534851661485 | false | false | false | true | false | |||||||||||||||
| 4b162c3c-bbdc-4589-89dc-a640b7dcae05 | 2026-08-17 13:01 | 2026-08-17 13:01 | 2026-08-17 13:01 | HAL | HAL261016P00035000 | put | 35.0000 | 2026-10-16 | 2.2300 | 2.2300 | 2.3200 | 34.3201 | 10927.00 | 0.00 | 10927.00 | 49 | 13 | 52 | 245 | 0.212244897959184 | 0.35654673217485 | 0.35654673217485 | false | false | false | true | false | |||||||||||||||
| 8b52fa0d-c4b1-477f-94cf-e090a331e520 | 2026-08-17 10:57 | 2026-08-17 10:57 | 2026-08-17 10:57 | HAL | HAL260918C00033000 | call | 33.0000 | 2026-09-18 | 2.0400 | 2.0400 | 2.1600 | 34.3175 | 14280.00 | 0.00 | 14280.00 | 70 | 7 | 71 | 7545 | 0.00941020543406229 | 0.300641087044205 | 0.300641087044205 | false | false | false | true | false | |||||||||||||||
| 2ed70b4e-54e8-4f3a-9f37-c73f5290c3be | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | HAL | HAL280121P00035000 | put | 35.0000 | 2028-01-21 | 5.3800 | 5.4000 | 5.6500 | 34.4800 | 16150.00 | 0.00 | 16150.00 | 30 | 6 | 30 | 292 | 0.102739726027397 | 0.383982555068573 | 0.383982555068573 | true | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 29167894149.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 29167894149.00 |
| 2026-10-20 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 29167894149.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 29167894149.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:23:23.944279Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 29167894149.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:23:23.944279Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 29167894149.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 29167894149.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 29167894149.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 29167894149.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 29167894149.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 29167894149.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |