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_alerts474,253 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 |
|---|
| e2e7e112-d8fd-4724-abf9-5ada36b5e044 | 2026-08-18 09:48 | 2026-08-18 09:48 | 2026-08-18 09:48 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 12.0700 | 12.0000 | 12.0900 | 768.0000 | 905223.00 | 269161.00 | 636062.00 | 750 | 8 | 942 | 14991 | 0.0628377026215729 | 0.127604295132374 | 0.127374235273104 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 802935622223.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 088a15e5-7d45-4d69-98db-89f92c3a197f | 2026-08-19 11:04 | 2026-08-19 11:04 | 2026-08-19 11:04 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 13.4000 | 13.4000 | 13.4500 | 772.1300 | 469000.00 | 0.00 | 469000.00 | 350 | 6 | 1118 | 15467 | 0.0722829249369626 | 0.124855761694495 | 0.124855761694495 | false | false | false | true | ||||||||||||||||
| c7baa9f0-ca97-4eef-9f1e-6079b8b59562 | 2026-08-20 15:20 | 2026-08-20 15:20 | 2026-08-20 15:20 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 8.4000 | 8.4000 | 8.4300 | 763.2700 | 101640.00 | 0.00 | 101640.00 | 121 | 6 | 2814 | 16086 | 0.174934725848564 | 0.121578417072776 | 0.121578417072776 | false | false | false | true | ||||||||||||||||
| 6c01779c-207d-4ac0-8cbf-1453fe492259 | 2026-08-20 15:20 | 2026-08-20 15:20 | 2026-08-20 15:20 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 8.4000 | 8.4000 | 8.4100 | 763.3000 | 213360.00 | 0.00 | 213360.00 | 254 | 8 | 3080 | 16086 | 0.191470844212359 | 0.121422889044035 | 0.121422889044035 | false | false | false | true | ||||||||||||||||
| 9b847c14-be97-4769-894e-4d1b5b544bc5 | 2026-08-20 15:37 | 2026-08-20 15:37 | 2026-08-20 15:37 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 8.4100 | 8.4100 | 8.4500 | 763.4550 | 298555.00 | 0.00 | 298555.00 | 355 | 21 | 4255 | 16086 | 0.264515727962203 | 0.120735459769791 | 0.120735459769791 | false | false | false | true | ||||||||||||||||
| 634fc999-c302-4cf4-b6ab-f3bf0c5b1662 | 2026-08-20 15:48 | 2026-08-20 15:48 | 2026-08-20 15:48 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 8.2000 | 8.2000 | 8.2400 | 762.9950 | 306680.00 | 0.00 | 306680.00 | 374 | 8 | 4693 | 16086 | 0.291744373989805 | 0.120637795029791 | 0.120637795029791 | false | false | false | true | ||||||||||||||||
| d19de4c4-ee13-423d-8c9a-b1af5ebe7eda | 2026-08-20 15:58 | 2026-08-20 15:58 | 2026-08-20 15:58 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 7.9000 | 7.8700 | 7.9200 | 762.2600 | 335750.00 | 335750.00 | 0.00 | 425 | 6 | 5690 | 16086 | 0.353723734924779 | 0.120823509700785 | 0.120823509700785 | false | false | false | true | ||||||||||||||||
| 4e498db7-00fa-4aa7-b05f-8f6c571d5760 | 2026-08-21 15:25 | 2026-08-21 15:25 | 2026-08-21 15:25 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 9.0200 | 9.0200 | 9.0600 | 766.0700 | 150634.00 | 0.00 | 150634.00 | 167 | 14 | 2509 | 16433 | 0.152680581756222 | 0.116139818650835 | 0.116139818650835 | false | false | false | true | ||||||||||||||||
| 1051e664-dc2e-475f-b4df-7b458f782556 | 2026-08-24 09:39 | 2026-08-24 09:39 | 2026-08-24 09:39 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 7.3700 | 7.3500 | 7.4000 | 763.3050 | 173938.00 | 52327.00 | 100238.00 | 236 | 7 | 505 | 14945 | 0.0337905654064905 | 0.119344588607852 | 0.119390210387353 | false | false | false | true | ||||||||||||||||
| 3480d05c-770a-4f9e-910a-4cf620cf0d98 | 2026-08-24 10:15 | 2026-08-24 10:15 | 2026-08-24 10:15 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 7.2000 | 7.2000 | 7.2200 | 762.9180 | 180000.00 | 0.00 | 180000.00 | 250 | 5 | 2204 | 14945 | 0.147474071595851 | 0.119192342565928 | 0.119192342565928 | false | false | false | true | ||||||||||||||||
| a0a3c8d1-a1fc-464c-9a2d-c1f3c7714cd5 | 2026-08-24 10:21 | 2026-08-24 10:21 | 2026-08-24 10:21 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 7.2600 | 7.2500 | 7.2800 | 763.1100 | 181500.00 | 0.00 | 181500.00 | 250 | 12 | 2479 | 14945 | 0.16587487453998 | 0.118920201804794 | 0.118920201804794 | true | false | false | true | ||||||||||||||||
| b1349ec8-55dd-46e0-92c3-4c2fd1ae4bac | 2026-08-24 12:31 | 2026-08-24 12:31 | 2026-08-24 12:31 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 7.8900 | 7.8900 | 7.9300 | 764.6150 | 132552.00 | 0.00 | 132552.00 | 168 | 8 | 3440 | 14945 | 0.230177316828371 | 0.11856570336741 | 0.11856570336741 | false | false | false | true | ||||||||||||||||
| 7aa7a387-8f76-4857-b9a1-af7d9c673c01 | 2026-08-26 15:35 | 2026-08-26 15:35 | 2026-08-26 15:35 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 8.3700 | 8.3700 | 8.4000 | 766.8650 | 230175.00 | 0.00 | 230175.00 | 275 | 14 | 3291 | 15727 | 0.209257964010937 | 0.117151787670068 | 0.117151787670068 | true | false | false | true | ||||||||||||||||
| 40bb2b0d-a6a6-4e49-9854-449045caaad5 | 2026-08-27 09:44 | 2026-08-27 09:44 | 2026-08-27 09:44 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 8.8700 | 8.8200 | 8.8700 | 768.5046 | 382297.00 | 382297.00 | 0.00 | 431 | 7 | 976 | 16144 | 0.0604558969276511 | 0.116089730458447 | 0.116089730458447 | false | false | false | true | ||||||||||||||||
| 5781a043-f5f9-4907-a8e7-f278107410a0 | 2026-09-02 11:08 | 2026-09-02 11:08 | 2026-09-02 11:08 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 5.5400 | 5.5400 | 5.5500 | 765.2900 | 131298.00 | 0.00 | 131298.00 | 237 | 6 | 1824 | 17514 | 0.104145255224392 | 0.111078978451933 | 0.111078978451933 | true | false | false | true | ||||||||||||||||
| 69712822-60b0-402b-bbc7-e71c7ac16bb9 | 2026-09-03 13:20 | 2026-09-03 13:20 | 2026-09-03 13:20 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 8.7600 | 8.7600 | 8.8000 | 772.2400 | 156804.00 | 0.00 | 156804.00 | 179 | 5 | 5277 | 18163 | 0.29053570445411 | 0.110840168726677 | 0.110840168726677 | true | false | false | true | ||||||||||||||||
| 4649855e-1adf-4849-9cec-abf54cfe6da4 | 2026-09-08 14:49 | 2026-09-08 14:49 | 2026-09-08 14:49 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 4.3300 | 4.2900 | 4.3400 | 766.1200 | 692800.00 | 22949.00 | 669851.00 | 1600 | 7 | 14511 | 18122 | 0.800739432733694 | 0.112884797872233 | 0.113223261071107 | false | false | false | true | ||||||||||||||||
| 400b19bf-80c1-4dc3-9bfc-8592bf25c428 | 2026-09-08 14:55 | 2026-09-08 14:55 | 2026-09-08 14:55 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 4.6200 | 4.6200 | 4.6500 | 766.9700 | 738738.00 | 0.00 | 738738.00 | 1599 | 9 | 16159 | 18122 | 0.89167862266858 | 0.111708311528528 | 0.111708311528528 | true | false | false | true | ||||||||||||||||
| f8a341bc-533d-4992-80e8-682dffa96507 | 2026-09-09 10:02 | 2026-09-09 10:02 | 2026-09-09 10:02 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 3.1200 | 3.1200 | 3.1400 | 763.6000 | 624000.00 | 0.00 | 624000.00 | 2000 | 5 | 4627 | 19100 | 0.242251308900524 | 0.114523250489609 | 0.114523250489609 | false | false | false | true | ||||||||||||||||
| 6175e499-2a31-4b49-9277-51a8de397c91 | 2026-09-09 11:04 | 2026-09-09 11:04 | 2026-09-09 11:04 | SPY | SPY260918C00770000 | call | 770.0000 | 2026-09-18 | 2.9200 | 2.9200 | 2.9300 | 762.7200 | 560932.00 | 0.00 | 560932.00 | 1921 | 6 | 11030 | 19100 | 0.577486910994764 | 0.116214886448099 | 0.116666322885899 | true | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| 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 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:59:19.634890Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:59:19.634890Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:46:45.098903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:21:20.397116Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:35:34.147296Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T16:44:07.615841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T13:49:05.616113Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T17:30:37.600118Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 810275044553.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:03:39.512328Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 810275044553.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:03:39.512328Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 810275044553.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:11:22.686371Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 810275044553.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |