uw_flow_alerts728,802 rows| iduuid | created_at ↑timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strikenumeric |
|---|
| 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 |
|---|
| 7b98be19-e94f-4a8e-96a2-0ffa04bc954c | 2026-09-21 09:57 | 2026-09-21 09:57 | 2026-09-21 09:57 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.7100 | 0.6900 | 0.7100 | 767.3100 | 14100.00 | 9620.00 | 0.00 | 200 | 12 | 1678 | 2268 | 0.739858906525573 | 0.101066256506503 | 0.101066256506503 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 817569476132.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T13:58:37.660981Z"} | 2026-10-03 | 2026-10-03 00:25 | 2026-10-03 00:25 |
| 121b786f-e3ad-4dc8-93a4-1fe530a544b9 | 2026-09-22 13:57 | 2026-09-22 13:57 | 2026-09-22 13:57 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 2.9200 | 2.9200 | 2.9500 | 774.0000 | 35047.00 | 0.00 | 35047.00 | 120 | 9 | 10768 | 3920 | 2.7469387755102 | 0.104543896337186 | 0.103843828582692 | true | false | false | |||||||||||||||||
| 5085dea4-4232-4b26-bd30-266c6eb6932c | 2026-09-23 09:33 | 2026-09-23 09:33 | 2026-09-23 09:33 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 1.5000 | 1.4800 | 1.5100 | 772.8550 | 14528.00 | 745.00 | 13783.00 | 97 | 9 | 3129 | 5574 | 0.561356297093649 | 0.119293098250461 | 0.118429023381344 | false | false | false | |||||||||||||||||
| e52916db-9c12-4c7b-a2ed-8e4e7d517651 | 2026-09-23 09:35 | 2026-09-23 09:35 | 2026-09-23 09:35 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 1.1400 | 1.1200 | 1.2100 | 772.2900 | 53103.00 | 49075.00 | 4028.00 | 466 | 22 | 5795 | 5574 | 1.03964836742017 | 0.115457233223851 | 0.11704874579531 | true | false | false | |||||||||||||||||
| 3129f01e-5e8e-4736-94f7-dae043d27e42 | 2026-09-23 09:43 | 2026-09-23 09:43 | 2026-09-23 09:43 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.9500 | 0.9500 | 0.9600 | 771.9200 | 11306.00 | 96.00 | 11210.00 | 119 | 12 | 15327 | 5574 | 2.7497308934338 | 0.119915942038979 | 0.118702794625074 | true | false | false | |||||||||||||||||
| 9aa63efc-e80c-4a05-882c-3d64cc4d2704 | 2026-09-23 09:47 | 2026-09-23 09:47 | 2026-09-23 09:47 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.7400 | 0.7400 | 0.7500 | 771.0000 | 24650.00 | 600.00 | 24050.00 | 333 | 7 | 23921 | 5574 | 4.29153211338357 | 0.128689746143238 | 0.127428244519752 | false | false | false | |||||||||||||||||
| 54b6c980-1a25-42fb-bf50-a36b7fd169fb | 2026-09-23 09:53 | 2026-09-23 09:53 | 2026-09-23 09:53 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.6300 | 0.6200 | 0.6400 | 771.1196 | 12463.00 | 3024.00 | 9439.00 | 198 | 20 | 39200 | 5574 | 7.03265159669896 | 0.121316318606248 | 0.121946159636227 | false | false | false | |||||||||||||||||
| 556e2d14-9b54-47f6-875d-daf64b8dcb68 | 2026-09-23 09:58 | 2026-09-23 09:58 | 2026-09-23 09:58 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.5100 | 0.5100 | 0.5200 | 770.8350 | 10414.00 | 520.00 | 9894.00 | 204 | 15 | 54333 | 5574 | 9.7475780409042 | 0.122476405274451 | 0.121099124541826 | false | false | false | |||||||||||||||||
| 4437a471-4dbf-45e9-a450-21b2a9e7efea | 2026-09-23 10:01 | 2026-09-23 10:00 | 2026-09-23 10:00 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.5800 | 0.5700 | 0.5800 | 771.0000 | 10329.00 | 7308.00 | 3021.00 | 179 | 27 | 62443 | 5574 | 11.20254754216 | 0.12188564749564 | 0.120546401515809 | false | false | false | |||||||||||||||||
| babfbc49-c1aa-4b44-a4bb-a79f10c1352c | 2026-09-23 10:03 | 2026-09-23 10:03 | 2026-09-23 10:03 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.4400 | 0.4400 | 0.4500 | 770.5000 | 11177.00 | 45.00 | 11132.00 | 254 | 8 | 69605 | 5574 | 12.4874416935773 | 0.126152462458742 | 0.126347093522886 | false | false | false | |||||||||||||||||
| 550fce63-39bf-4196-ac4e-b59fe13dd38c | 2026-09-23 10:54 | 2026-09-23 10:53 | 2026-09-23 10:53 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.4400 | 0.4400 | 0.4500 | 770.0000 | 90027.00 | 135.00 | 89892.00 | 2046 | 13 | 170353 | 5574 | 30.5620739146035 | 0.143431790950542 | 0.14309310875899 | false | false | false | |||||||||||||||||
| 158d61a0-5e0a-4855-9fce-69162766175d | 2026-09-23 10:54 | 2026-09-23 10:53 | 2026-09-23 10:53 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.4500 | 0.4400 | 0.4500 | 770.0000 | 10391.00 | 10215.00 | 176.00 | 231 | 17 | 170607 | 5574 | 30.6076426264801 | 0.145200319268259 | 0.143141028455252 | false | false | false | |||||||||||||||||
| 9b08875f-46c5-4562-a11f-9e39b50caa94 | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.5000 | 0.4900 | 0.5100 | 770.0000 | 11688.00 | 1203.00 | 10485.00 | 235 | 25 | 173807 | 5574 | 31.1817366343739 | 0.148458740729128 | 0.147355631194333 | false | false | false | |||||||||||||||||
| cbd1aa6b-b929-4851-bbc6-cbaa853e115d | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.4900 | 0.4900 | 0.5000 | 770.0000 | 56070.00 | 700.00 | 55370.00 | 1144 | 18 | 175286 | 5574 | 31.4470757086473 | 0.144612703937522 | 0.143513988948844 | false | false | false | |||||||||||||||||
| 1454a871-9025-4510-9eba-bdd258739e7f | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.4500 | 0.4300 | 0.4600 | 770.0000 | 26566.00 | 138.00 | 24976.00 | 593 | 18 | 176443 | 5574 | 31.6546465733764 | 0.142158776026817 | 0.142004577703174 | true | false | false | |||||||||||||||||
| 0cfa746b-7922-44c3-bfc7-7ece91097fe2 | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.4100 | 0.4000 | 0.4200 | 770.0000 | 16099.00 | 4103.00 | 11996.00 | 393 | 19 | 177891 | 5574 | 31.9144241119483 | 0.141794200820587 | 0.140125348305435 | false | false | false | |||||||||||||||||
| 5bf360ee-96c2-4528-8b92-693384fd2028 | 2026-09-23 10:55 | 2026-09-23 10:55 | 2026-09-23 10:55 | SPY | SPY260923C00772000 | call | 772.0000 | 2026-09-23 | 0.3900 | 0.3400 | 0.4300 | 770.0600 | 18069.00 | 43.00 | 16906.00 | 467 | 52 | 182831 | 5574 | 32.8006817366344 | 0.136666343251758 | 0.138739713064454 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 817569476132.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:35:12.090273Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 817569476132.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:35:12.090273Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:47:39.692401Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:55:29.867504Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:58:49.832976Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:02:33.967509Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:04:12.048624Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:57:22.994560Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |