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 |
|---|
| 55171cd4-01f4-470a-a2da-2ca6a1bbd244 | 2026-09-16 10:58 | 2026-09-16 10:58 | 2026-09-16 10:58 | SNPS | SNPS261218C00380000 | call | 380.0000 | 2026-12-18 | 36.7000 | 36.2000 | 36.7000 | 376.2000 | 62390.00 | 22020.00 | 0.00 | 17 | 5 | 1563 | 70 | 22.3285714285714 | 0.484241959962315 | 0.484241959962315 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 72528721412.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 20a71302-adfe-4b1d-a456-c7688708ca80 | 2026-09-16 10:58 | 2026-09-16 10:58 | 2026-09-16 10:58 | SNPS | SNPS261218C00380000 | call | 380.0000 | 2026-12-18 | 36.8000 | 36.2000 | 36.9000 | 376.6000 | 69920.00 | 29440.00 | 40480.00 | 19 | 5 | 1596 | 70 | 22.8 | 0.482643717014197 | 0.482643717014197 | false | false | false | true | ||||||||||||||||
| 0f38855d-cc67-4718-b1f4-2fbfe2cfa217 | 2026-09-16 10:58 | 2026-09-16 10:58 | 2026-09-16 10:58 | SNPS | SNPS261218C00380000 | call | 380.0000 | 2026-12-18 | 37.0000 | 35.6000 | 37.3000 | 376.2000 | 51800.00 | 3700.00 | 14800.00 | 14 | 5 | 1546 | 70 | 22.0857142857143 | 0.488233172685032 | 0.488233172685032 | false | false | false | true | ||||||||||||||||
| f70b71ef-ad65-4bc7-bac9-2705677207f0 | 2026-09-16 10:58 | 2026-09-16 10:58 | 2026-09-16 10:58 | SNPS | SNPS261218C00380000 | call | 380.0000 | 2026-12-18 | 36.6000 | 35.0000 | 37.5000 | 376.1700 | 73200.00 | 18300.00 | 21960.00 | 20 | 5 | 1526 | 70 | 21.8 | 0.483130950759924 | 0.483130950759924 | false | false | false | true | ||||||||||||||||
| ddb9096e-958a-46be-8004-6c6863b4e0d8 | 2026-09-16 10:49 | 2026-09-16 10:49 | 2026-09-16 10:49 | SNPS | SNPS261218C00380000 | call | 380.0000 | 2026-12-18 | 36.5000 | 35.7000 | 36.9000 | 376.5000 | 87600.00 | 51100.00 | 36500.00 | 24 | 5 | 1465 | 70 | 20.9285714285714 | 0.479387338666594 | 0.479387338666594 | false | false | false | true | ||||||||||||||||
| b4465a5b-4524-48f0-a300-d75d6941b8cc | 2026-09-16 10:49 | 2026-09-16 10:49 | 2026-09-16 10:49 | SNPS | SNPS261218C00380000 | call | 380.0000 | 2026-12-18 | 36.7000 | 36.3000 | 36.9000 | 376.7700 | 139460.00 | 36700.00 | 40370.00 | 38 | 5 | 1503 | 70 | 21.4714285714286 | 0.480068045423237 | 0.480068045423237 | false | false | false | true | ||||||||||||||||
| d44caf47-c1f4-4a8f-9d89-e5574a7944fa | 2026-09-16 10:49 | 2026-09-16 10:49 | 2026-09-16 10:49 | SNPS | SNPS261218C00380000 | call | 380.0000 | 2026-12-18 | 36.1000 | 35.5000 | 37.4000 | 376.1100 | 126350.00 | 61370.00 | 36100.00 | 35 | 5 | 1397 | 70 | 19.9571428571429 | 0.476917846136825 | 0.476917846136825 | true | false | false | true | ||||||||||||||||
| 3201cda2-fbdf-4677-a350-f95e8c42c83a | 2026-09-16 10:49 | 2026-09-16 10:49 | 2026-09-16 10:49 | SNPS | SNPS261218C00380000 | call | 380.0000 | 2026-12-18 | 36.3000 | 36.3000 | 36.9000 | 376.1100 | 116160.00 | 0.00 | 116160.00 | 32 | 5 | 1441 | 70 | 20.5857142857143 | 0.479578314636854 | 0.479578314636854 | false | false | false | true | ||||||||||||||||
| 9dbd13cb-9801-4a4f-9308-dc5de3db20a4 | 2026-09-16 10:49 | 2026-09-16 10:49 | 2026-09-16 10:49 | SNPS | SNPS261218C00380000 | call | 380.0000 | 2026-12-18 | 36.3000 | 35.6000 | 36.3000 | 376.1100 | 105270.00 | 83490.00 | 0.00 | 29 | 5 | 1362 | 70 | 19.4571428571429 | 0.479578314636854 | 0.479578314636854 | true | false | false | true | ||||||||||||||||
| 89134cb9-79c8-4b44-840f-9a88fb58e3d2 | 2026-09-16 10:08 | 2026-09-16 10:08 | 2026-09-16 10:08 | SNPS | SNPS261218C00380000 | call | 380.0000 | 2026-12-18 | 34.4000 | 33.8000 | 36.2000 | 372.9700 | 51600.00 | 13760.00 | 10320.00 | 15 | 8 | 1263 | 70 | 18.0428571428571 | 0.476928065951561 | 0.476928065951561 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 72528721412.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 72528721412.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 72528721412.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 72528721412.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 72528721412.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 72528721412.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 72528721412.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 72528721412.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 72528721412.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |