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 |
|---|
| d6e6b2ee-a3c2-43f3-9838-59c5e6a4839e | 2026-08-17 12:57 | 2026-08-17 12:57 | 2026-08-17 12:57 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 6.5200 | 6.3000 | 6.8500 | 46.2742 | 130328.00 | 0.00 | 130328.00 | 200 | 12 | 488 | 15376 | 0.0317377731529657 | 0.989477907896827 | 0.989477907896827 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 17011511834.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 20ceeb66-d36b-444e-b7a1-d7789c13aedb | 2026-08-18 10:35 | 2026-08-18 10:35 | 2026-08-18 10:35 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 5.1000 | 5.0500 | 5.3500 | 43.3800 | 27030.00 | 0.00 | 27030.00 | 53 | 22 | 113 | 15587 | 0.00724963110284211 | 0.97511074696658 | 0.97511074696658 | false | false | false | true | ||||||||||||||||
| 02d8e2d1-c498-4916-9673-6e0167f2d452 | 2026-08-21 10:57 | 2026-08-21 10:57 | 2026-08-21 10:57 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 4.4000 | 4.4000 | 4.5000 | 41.3850 | 22000.00 | 0.00 | 1760.00 | 50 | 18 | 126 | 15619 | 0.00806709776554197 | 0.994038882376908 | 0.994038882376908 | false | false | false | true | ||||||||||||||||
| 7954c062-a9d6-464d-8440-659eab06c429 | 2026-08-31 12:28 | 2026-08-31 12:28 | 2026-08-31 12:28 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 1.8200 | 1.7600 | 1.8300 | 36.2750 | 26208.00 | 17654.00 | 0.00 | 144 | 5 | 201 | 15078 | 0.0133306804615997 | 0.892059080755701 | 0.892059080755701 | false | false | false | true | ||||||||||||||||
| 72028f12-fb8b-4993-9035-f0671b57a6e9 | 2026-09-04 15:18 | 2026-09-04 15:18 | 2026-09-04 15:18 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 4.2000 | 4.2000 | 4.2500 | 43.8450 | 26040.00 | 0.00 | 26040.00 | 62 | 9 | 406 | 15287 | 0.0265585137698698 | 0.932359286550227 | 0.932359286550227 | false | false | false | true | ||||||||||||||||
| 504706ef-2f45-4181-9d15-784fc937db3a | 2026-09-04 15:18 | 2026-09-04 15:18 | 2026-09-04 15:18 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 4.2000 | 4.2000 | 4.2500 | 43.8401 | 22680.00 | 0.00 | 22680.00 | 54 | 8 | 321 | 15287 | 0.0209982337934192 | 0.932560368902282 | 0.932560368902282 | false | false | false | true | ||||||||||||||||
| 1a929ffa-b252-4861-8668-4452aee64dac | 2026-09-04 15:18 | 2026-09-04 15:18 | 2026-09-04 15:18 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 4.2500 | 4.0500 | 4.3000 | 43.8600 | 190400.00 | 141950.00 | 48450.00 | 448 | 25 | 854 | 15287 | 0.0558644599986917 | 0.937411247736004 | 0.937411247736004 | true | false | false | true | ||||||||||||||||
| cd5f9af4-945b-4377-b3bc-eae5f2d865df | 2026-09-04 15:20 | 2026-09-04 15:20 | 2026-09-04 15:20 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 4.2500 | 4.0500 | 4.3000 | 43.8550 | 22525.00 | 17850.00 | 425.00 | 53 | 20 | 907 | 15287 | 0.059331458101655 | 0.937411247736004 | 0.937617106282918 | true | false | false | true | ||||||||||||||||
| b9d3ae84-2099-4505-aecf-e4a1d95d2fea | 2026-09-04 15:20 | 2026-09-04 15:20 | 2026-09-04 15:20 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 4.2500 | 4.2000 | 4.3000 | 43.8800 | 160225.00 | 0.00 | 20400.00 | 377 | 7 | 1284 | 15287 | 0.083992935173677 | 0.936587992278051 | 0.936587992278051 | true | false | false | true | ||||||||||||||||
| f6ffce39-5e9b-4a42-a81b-c6e08d360a14 | 2026-09-04 15:20 | 2026-09-04 15:20 | 2026-09-04 15:20 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 4.2500 | 4.2500 | 4.3000 | 43.8800 | 13600.00 | 0.00 | 13600.00 | 32 | 5 | 1316 | 15287 | 0.0860862170471643 | 0.936587992278051 | 0.936587992278051 | false | false | false | true | ||||||||||||||||
| ba1d559a-bb65-4fba-b61e-c34f0113a983 | 2026-09-04 15:20 | 2026-09-04 15:20 | 2026-09-04 15:20 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 4.2500 | 4.2500 | 4.3000 | 43.8700 | 10200.00 | 0.00 | 10200.00 | 24 | 9 | 1341 | 15287 | 0.0877215935108262 | 0.936999584278759 | 0.936999584278759 | false | false | false | true | ||||||||||||||||
| fd31b3a4-f14f-4b24-bd09-058752725296 | 2026-09-08 15:22 | 2026-09-08 15:22 | 2026-09-08 15:22 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 5.7000 | 5.6500 | 5.7000 | 47.6800 | 10830.00 | 10830.00 | 0.00 | 19 | 8 | 4674 | 15651 | 0.298639064596511 | 0.950141114061834 | 0.950141114061834 | false | false | false | true | ||||||||||||||||
| 6f60ba44-5f02-415a-94fe-6505fbb2cfb4 | 2026-09-08 15:30 | 2026-09-08 15:30 | 2026-09-08 15:30 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 5.7000 | 5.6500 | 5.7500 | 47.6903 | 49020.00 | 38190.00 | 5130.00 | 86 | 7 | 5096 | 15651 | 0.325602197942623 | 0.949695330096046 | 0.949695330096046 | false | false | false | true | ||||||||||||||||
| 3b041fb5-5da2-4bc2-93b6-bc877f66d69a | 2026-09-09 12:45 | 2026-09-09 12:45 | 2026-09-09 12:45 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 4.5000 | 4.5000 | 4.5500 | 45.0000 | 27900.00 | 0.00 | 27900.00 | 62 | 6 | 314 | 14265 | 0.0220119172800561 | 0.925688634483876 | 0.926107108390735 | false | false | false | true | ||||||||||||||||
| 9f25341c-3a51-4765-92c7-f33417d52785 | 2026-09-21 14:22 | 2026-09-21 14:22 | 2026-09-21 14:22 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 4.8500 | 4.6500 | 4.8500 | 48.3000 | 267641.00 | 267641.00 | 0.00 | 552 | 56 | 3655 | 14550 | 0.251202749140893 | 0.899077610359427 | 0.899077610359427 | true | false | false | true | ||||||||||||||||
| 124597ed-16dd-41f4-9a5a-d6d8db125909 | 2026-09-21 14:31 | 2026-09-21 14:31 | 2026-09-21 14:31 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 5.0000 | 4.8000 | 5.0000 | 48.0000 | 26500.00 | 26500.00 | 0.00 | 53 | 7 | 4177 | 14550 | 0.287079037800687 | 0.900838877077186 | 0.900838877077186 | false | false | false | true | ||||||||||||||||
| 3270b494-9bfb-4f50-a0fb-e6d031aba1c1 | 2026-09-22 10:35 | 2026-09-22 10:35 | 2026-09-22 10:35 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 5.0500 | 4.8500 | 5.1000 | 48.7000 | 105545.00 | 105040.00 | 505.00 | 209 | 24 | 796 | 15949 | 0.049909085209104 | 0.909711605085027 | 0.908379500210768 | true | false | false | true | ||||||||||||||||
| 60e9aec7-2e7c-4150-bde0-0d8ae4259eb5 | 2026-09-22 15:52 | 2026-09-22 15:52 | 2026-09-22 15:52 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 4.8500 | 4.8500 | 5.0000 | 48.6400 | 18433.00 | 0.00 | 18433.00 | 38 | 13 | 1124 | 15949 | 0.0704746379083328 | 0.889340335053129 | 0.889340335053129 | false | false | false | true | ||||||||||||||||
| 2ba40235-6d88-47fd-9c7e-399d12e1b2f2 | 2026-09-23 12:44 | 2026-09-23 12:44 | 2026-09-23 12:44 | IREN | IREN261218C00060000 | call | 60.0000 | 2026-12-18 | 4.4200 | 4.4000 | 4.5000 | 47.9450 | 26500.00 | 0.00 | 26500.00 | 60 | 5 | 316 | 16194 | 0.0195134000247005 | 0.87522449693543 | 0.877472151946608 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:30:09.198364Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17011511834.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 18611389945.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:23:56.707397Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 18611389945.00 |
| 2026-11-05 |
| unknown |
| 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 |
| Common Stock |
| Financial Services |
| 19131547360.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:35:47.926453Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 19131547360.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 18540459388.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:47:02.093743Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |