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 |
|---|
| f02f9438-fe09-4f48-a802-d2bd24dc43fd | 2026-09-21 11:44 | 2026-09-21 11:44 | 2026-09-21 11:44 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.4800 | 0.4700 | 0.4900 | 770.6200 | 14880.00 | 12000.00 | 0.00 | 310 | 17 | 5114 | 1198 | 4.26878130217028 | 0.105705806780511 | 0.105705806780511 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 785048619408.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:46:21.763749Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 8997a977-2532-41fd-8129-04caf7ac0442 | 2026-09-21 11:53 | 2026-09-21 11:53 | 2026-09-21 11:53 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.5300 | 0.5200 | 0.5300 | 770.8950 | 22419.00 | 22419.00 | 0.00 | 423 | 10 | 6222 | 1198 | 5.19365609348915 | 0.106151399092331 | 0.106151399092331 | false | false | false | true | ||||||||||||||||
| c8810772-bc2e-47ee-8e69-03ced26515dd | 2026-09-21 12:32 | 2026-09-21 12:31 | 2026-09-21 12:31 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.8700 | 0.8600 | 0.8700 | 772.0000 | 13050.00 | 13050.00 | 0.00 | 150 | 7 | 6972 | 1198 | 5.81969949916528 | 0.110480889148862 | 0.110480889148862 | false | false | false | true | ||||||||||||||||
| 767bfa78-8c1d-411b-92ae-e18763a78c5c | 2026-09-21 14:30 | 2026-09-21 14:30 | 2026-09-21 14:30 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 1.1500 | 1.1500 | 1.1600 | 773.0000 | 10005.00 | 0.00 | 10005.00 | 87 | 7 | 8721 | 1198 | 7.279632721202 | 0.101511620142295 | 0.101511620142295 | false | false | false | true | ||||||||||||||||
| 28935e4b-70db-4eaa-a4ae-03c7d80179a6 | 2026-09-21 14:32 | 2026-09-21 14:32 | 2026-09-21 14:32 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 1.0800 | 1.0700 | 1.0800 | 773.0000 | 10692.00 | 10692.00 | 0.00 | 99 | 5 | 8823 | 1198 | 7.36477462437396 | 0.10088976004236 | 0.10088976004236 | false | false | false | true | ||||||||||||||||
| d233bcd4-5340-4a7a-b132-22260f5cbe6f | 2026-09-21 14:39 | 2026-09-21 14:38 | 2026-09-21 14:38 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 1.1100 | 1.0900 | 1.1100 | 773.8600 | 11100.00 | 11100.00 | 0.00 | 100 | 7 | 8945 | 1198 | 7.46661101836394 | 0.100285778902197 | 0.100285778902197 | false | false | false | true | ||||||||||||||||
| e3f4fb2b-1483-4d3e-9c72-83701a55cf96 | 2026-09-21 16:02 | 2026-09-21 16:02 | 2026-09-21 16:02 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 1.0000 | 1.0000 | 1.0100 | 773.0000 | 17000.00 | 0.00 | 17000.00 | 170 | 7 | 11725 | 1198 | 9.78714524207012 | 0.101947586740147 | 0.101947586740147 | false | false | false | true | ||||||||||||||||
| 0843775d-b7ce-4831-a518-62e513984b3c | 2026-09-22 09:31 | 2026-09-22 09:30 | 2026-09-22 09:30 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.9500 | 0.9400 | 0.9500 | 774.2100 | 26600.00 | 26600.00 | 0.00 | 280 | 6 | 522 | 2275 | 0.229450549450549 | 0.124810154405753 | 0.124810154405753 | false | false | false | true | ||||||||||||||||
| 6ea7349f-bb33-4fd2-84c0-a56140802f49 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 1.2200 | 1.2100 | 1.2300 | 775.0200 | 15143.00 | 13435.00 | 488.00 | 124 | 7 | 2825 | 2275 | 1.24175824175824 | 0.126083242628663 | 0.125188621291551 | false | false | false | true | ||||||||||||||||
| 87b37f0b-46b8-4601-9f2d-a02ab6a74690 | 2026-09-22 09:40 | 2026-09-22 09:39 | 2026-09-22 09:39 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 1.2200 | 1.2100 | 1.2300 | 775.0500 | 10370.00 | 244.00 | 10126.00 | 85 | 7 | 3479 | 2275 | 1.52923076923077 | 0.124481444613096 | 0.124481444613096 | true | false | false | true | ||||||||||||||||
| 4db459ad-0c18-454b-8889-6f8ebd8dc3a4 | 2026-09-22 09:40 | 2026-09-22 09:39 | 2026-09-22 09:39 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 1.2100 | 1.2000 | 1.2200 | 774.9950 | 16303.00 | 0.00 | 3840.00 | 135 | 5 | 3629 | 2275 | 1.59516483516484 | 0.123820579943915 | 0.124450837633157 | true | false | false | true | ||||||||||||||||
| 6fffc138-092e-4ed5-a75f-de8f6fa6ad7a | 2026-09-22 09:40 | 2026-09-22 09:40 | 2026-09-22 09:40 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 1.0500 | 1.0400 | 1.0500 | 774.5000 | 11024.00 | 10920.00 | 104.00 | 105 | 5 | 4668 | 2275 | 2.05186813186813 | 0.124860684152415 | 0.125551837246256 | false | false | false | true | ||||||||||||||||
| 09ad211b-e4da-4a3e-9f2b-2df375882dbd | 2026-09-22 09:42 | 2026-09-22 09:42 | 2026-09-22 09:42 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 1.1200 | 1.1100 | 1.1200 | 774.7750 | 87360.00 | 87360.00 | 0.00 | 780 | 17 | 7122 | 2275 | 3.13054945054945 | 0.124175936426444 | 0.124175936426444 | false | false | false | true | ||||||||||||||||
| 3307e590-0565-435b-99c8-ab128a7fa24c | 2026-09-22 09:57 | 2026-09-22 09:57 | 2026-09-22 09:57 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.8000 | 0.7900 | 0.8200 | 774.0200 | 11682.00 | 7041.00 | 81.00 | 146 | 7 | 12017 | 2275 | 5.2821978021978 | 0.118165555062873 | 0.118602253877818 | false | false | false | true | ||||||||||||||||
| f9f2b4c7-35df-4bb5-8ebd-607976bcd4ce | 2026-09-22 10:12 | 2026-09-22 10:12 | 2026-09-22 10:12 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.8400 | 0.8300 | 0.8400 | 774.4098 | 24360.00 | 24360.00 | 0.00 | 290 | 8 | 14372 | 2275 | 6.31736263736264 | 0.112731238696061 | 0.112731238696061 | false | false | false | true | ||||||||||||||||
| 58b29a21-e97e-4594-8754-d3323b2ef1df | 2026-09-22 10:29 | 2026-09-22 10:29 | 2026-09-22 10:29 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.6000 | 0.6000 | 0.6100 | 773.5750 | 14162.00 | 122.00 | 14040.00 | 236 | 14 | 18845 | 2275 | 8.28351648351648 | 0.111054905608858 | 0.111054905608858 | true | false | false | true | ||||||||||||||||
| 7bfd6e9e-b21c-4bad-8561-91e8b4d363ea | 2026-09-22 10:39 | 2026-09-22 10:39 | 2026-09-22 10:39 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.7300 | 0.7000 | 0.7100 | 773.9300 | 14898.00 | 14898.00 | 0.00 | 204 | 5 | 21001 | 2275 | 9.23120879120879 | 0.114414588367034 | 0.116683612502783 | true | false | false | true | ||||||||||||||||
| 5d0b88e3-1f84-486a-a6cc-9e9668fd4eb8 | 2026-09-22 13:52 | 2026-09-22 13:52 | 2026-09-22 13:52 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.5100 | 0.4900 | 0.5000 | 773.5900 | 12444.00 | 12444.00 | 0.00 | 244 | 9 | 28325 | 2275 | 12.4505494505495 | 0.103319087429918 | 0.103319087429918 | true | false | false | true | ||||||||||||||||
| 8cd3a274-cb64-4b60-9b6f-a22ceae082c4 | 2026-09-22 14:24 | 2026-09-22 14:24 | 2026-09-22 14:24 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.6500 | 0.6500 | 0.6600 | 774.3000 | 19565.00 | 0.00 | 19565.00 | 301 | 9 | 31026 | 2275 | 13.6378021978022 | 0.101005098819631 | 0.101005098819631 | false | false | false | true | ||||||||||||||||
| 6f6bc9aa-a03c-477b-b303-83b9f2993b54 | 2026-09-22 15:24 | 2026-09-22 15:24 | 2026-09-22 15:24 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.6100 | 0.5600 | 0.5700 | 774.2600 | 13028.00 | 13028.00 | 0.00 | 214 | 7 | 34151 | 2275 | 15.0114285714286 | 0.100886169904125 | 0.09564543169038 | true | false | false | true | ||||||||||||||||
| b17db1d2-623b-4d63-87e9-1752db60771e | 2026-09-22 15:38 | 2026-09-22 15:38 | 2026-09-22 15:38 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.7500 | 0.7500 | 0.7600 | 774.7599 | 20550.00 | 0.00 | 20550.00 | 274 | 6 | 37101 | 2275 | 16.3081318681319 | 0.0989154558018521 | 0.0989154558018521 | false | false | false | true | ||||||||||||||||
| ae507d63-2ab4-4518-93e3-38e4ae7929c7 | 2026-09-22 15:58 | 2026-09-22 15:58 | 2026-09-22 15:58 | SPY | SPY260923C00777000 | call | 777.0000 | 2026-09-23 | 0.5200 | 0.5200 | 0.5300 | 773.7600 | 33956.00 | 0.00 | 33956.00 | 653 | 28 | 42343 | 2275 | 18.6123076923077 | 0.100865845086824 | 0.101049917412527 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:56:02.019393Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:32:17.927421Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:32:54.184324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:32:54.184324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:42:48.011261Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:31:35.812482Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:41:44.035284Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:58:41.675080Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:13:22.184869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:31:31.654153Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:41:08.297651Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:52:53.749956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:29:55.439380Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:27:59.988967Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |