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 | 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 |
|---|
| f4ec1767-e0f7-4ccf-b939-8b7ea1e7916e | 2026-08-17 14:18 | 2026-08-17 14:18 | 2026-08-17 14:18 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.9400 | 0.9400 | 0.9800 | 17.5800 | 188200.00 | 0.00 | 178600.00 | 2000 | 13 | 4968 | 25665 | 0.193571011104617 | 0.865793289672392 | 0.865793289672392 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 7719045433.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 666055ca-bdd6-4b7d-946b-c2026f619023 | 2026-08-18 13:01 | 2026-08-18 13:01 | 2026-08-18 13:01 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.5500 | 0.5500 | 0.5800 | 16.2450 | 55000.00 | 0.00 | 55000.00 | 1000 | 5 | 1433 | 26407 | 0.0542659143408945 | 0.87744103789624 | 0.87744103789624 | false | false | false | true | ||||||||||||||||
| 0a250296-d10c-4b3a-9dce-00062d69143a | 2026-08-21 09:33 | 2026-08-21 09:33 | 2026-08-21 09:33 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.8200 | 0.8000 | 0.8500 | 17.3000 | 13694.00 | 13038.00 | 656.00 | 167 | 20 | 278 | 23332 | 0.0119149665695183 | 0.909755786254381 | 0.902167934579816 | false | false | false | true | ||||||||||||||||
| ada7eef9-8706-4758-b071-d53bbd98db45 | 2026-08-21 09:33 | 2026-08-21 09:33 | 2026-08-21 09:33 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.8000 | 0.7900 | 0.8000 | 17.2473 | 11520.00 | 11520.00 | 0.00 | 144 | 17 | 788 | 23332 | 0.0337733584776273 | 0.90191455053675 | 0.90191455053675 | false | false | false | true | ||||||||||||||||
| 4b6b0308-eed4-49cf-b73c-2ae2ca576dfb | 2026-08-21 09:33 | 2026-08-21 09:33 | 2026-08-21 09:33 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.7900 | 0.7900 | 0.8200 | 17.2400 | 19047.00 | 640.00 | 18407.00 | 241 | 10 | 644 | 23332 | 0.0276015772329847 | 0.896078652931311 | 0.90191455053675 | false | false | false | true | ||||||||||||||||
| dc8e9e42-f40a-4810-a6f0-15eb9152ea40 | 2026-08-21 09:33 | 2026-08-21 09:33 | 2026-08-21 09:33 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.8000 | 0.7900 | 0.8200 | 17.2700 | 33769.00 | 20640.00 | 13129.00 | 424 | 38 | 1212 | 23332 | 0.0519458254757415 | 0.89043783702004 | 0.896256791480955 | false | false | false | true | ||||||||||||||||
| d33d688f-6457-4114-8363-44a081a59e63 | 2026-08-21 09:33 | 2026-08-21 09:33 | 2026-08-21 09:33 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.8100 | 0.7900 | 0.8100 | 17.2700 | 20250.00 | 20250.00 | 0.00 | 250 | 18 | 1462 | 23332 | 0.0626607234699126 | 0.902063666403898 | 0.902063666403898 | false | false | false | true | ||||||||||||||||
| 61a95e0b-1540-4145-ae58-c21b8c90e945 | 2026-08-21 09:33 | 2026-08-21 09:33 | 2026-08-21 09:33 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.7900 | 0.7900 | 0.8200 | 17.3000 | 12956.00 | 0.00 | 12956.00 | 164 | 12 | 1626 | 23332 | 0.0696896965540888 | 0.884797376788002 | 0.884797376788002 | false | false | false | true | ||||||||||||||||
| fd001a4f-4b65-415e-a632-b3c9efa66231 | 2026-08-21 09:43 | 2026-08-21 09:42 | 2026-08-21 09:42 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.8600 | 0.8200 | 0.8600 | 17.4700 | 26144.00 | 9116.00 | 0.00 | 304 | 21 | 2137 | 23332 | 0.0915909480541745 | 0.892555274834023 | 0.892555274834023 | false | false | false | true | ||||||||||||||||
| d88ea8fb-74aa-4154-9be1-fd0b407d71b9 | 2026-08-21 09:43 | 2026-08-21 09:42 | 2026-08-21 09:42 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.8500 | 0.8300 | 0.8800 | 17.4700 | 80428.00 | 40770.00 | 588.00 | 946 | 56 | 3083 | 23332 | 0.132136122064118 | 0.885074373416801 | 0.892555274834023 | false | false | false | true | ||||||||||||||||
| 2ee0f6df-6497-4ee9-841e-c4389d1345fc | 2026-08-21 09:43 | 2026-08-21 09:43 | 2026-08-21 09:43 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.8500 | 0.8500 | 0.8700 | 17.4600 | 21334.00 | 6880.00 | 14110.00 | 250 | 26 | 3333 | 23332 | 0.142851020058289 | 0.888825173839223 | 0.894473953908249 | false | false | false | true | ||||||||||||||||
| de9695b5-af63-4b7e-abcb-fae39616d71a | 2026-08-24 12:27 | 2026-08-24 12:27 | 2026-08-24 12:27 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.4400 | 0.4200 | 0.4300 | 16.0650 | 13948.00 | 13948.00 | 0.00 | 317 | 5 | 2694 | 20856 | 0.129171461449942 | 0.926716473499201 | 0.926716473499201 | false | false | false | true | ||||||||||||||||
| 7d8beb10-d03c-4e84-80c6-5ae1d92a7573 | 2026-08-24 13:04 | 2026-08-24 13:04 | 2026-08-24 13:04 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.3600 | 0.3600 | 0.3800 | 15.8750 | 14148.00 | 0.00 | 14148.00 | 393 | 12 | 4755 | 20856 | 0.227991944764097 | 0.892783543942772 | 0.892783543942772 | false | false | false | true | ||||||||||||||||
| bdc16580-0f26-457f-bac0-0af98c6eba56 | 2026-08-25 11:48 | 2026-08-25 11:47 | 2026-08-25 11:47 | WULF | WULF260918C00020000 | call | 20.0000 | 2026-09-18 | 0.4600 | 0.4400 | 0.4600 | 16.2300 | 12052.00 | 12052.00 | 0.00 | 262 | 23 | 608 | 17936 | 0.0338983050847458 | 0.932380591531791 | 0.932380591531791 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| 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 |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| unknown |
| — |
| 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 |
| Common Stock |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7719045433.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |