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_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 | 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 |
|---|
| 651b29a3-72a4-427e-a552-06c8b9bc90ad | 2026-09-21 11:57 | 2026-09-21 11:57 | 2026-09-21 11:57 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 3.0000 | 3.0000 | 3.0500 | 47.3600 | 10203.00 | 303.00 | 9900.00 | 34 | 10 | 2868 | 16795 | 0.170765108663293 | 0.815819668499311 | 0.815819668499311 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-21T16:00:04.115943Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 134e50f9-b49f-4e0d-a6c3-ad5c17ef7ea5 | 2026-09-21 14:23 | 2026-09-21 14:23 | 2026-09-21 14:23 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 3.5000 | 3.4500 | 3.5500 | 48.3550 | 18200.00 | 7350.00 | 0.00 | 52 | 13 | 3788 | 16795 | 0.225543316463233 | 0.823047886291732 | 0.823047886291732 | true | false | false | true | ||||||||||||||||
| 51648847-0b11-45de-b7e4-75f545e4d173 | 2026-09-21 15:05 | 2026-09-21 15:05 | 2026-09-21 15:05 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 3.4500 | 3.4500 | 3.5000 | 48.0000 | 10695.00 | 0.00 | 10695.00 | 31 | 5 | 4892 | 16795 | 0.291277165823162 | 0.820816031264006 | 0.820816031264006 | false | false | false | true | ||||||||||||||||
| c79e2622-e5ef-443a-b58d-d23b991ba155 | 2026-09-22 13:31 | 2026-09-22 13:31 | 2026-09-22 13:31 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 3.2000 | 3.2000 | 3.2500 | 48.0000 | 12171.00 | 0.00 | 12171.00 | 38 | 8 | 1955 | 17037 | 0.114750249457064 | 0.798599266016883 | 0.800633672965159 | false | false | false | true | ||||||||||||||||
| b6c031ca-7ca9-43ba-8adf-d58786134613 | 2026-09-22 14:16 | 2026-09-22 14:16 | 2026-09-22 14:16 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 3.4000 | 3.3500 | 3.4000 | 48.4650 | 13600.00 | 13600.00 | 0.00 | 40 | 6 | 2146 | 17037 | 0.12596114339379 | 0.809476069845002 | 0.809476069845002 | false | false | false | true | ||||||||||||||||
| 9c0c29b2-1e74-4cfb-8c4b-2e193ffb4221 | 2026-09-22 14:29 | 2026-09-22 14:29 | 2026-09-22 14:29 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 3.4200 | 3.4000 | 3.5000 | 48.5700 | 34200.00 | 0.00 | 34200.00 | 100 | 7 | 2293 | 17037 | 0.134589423020485 | 0.803174895713292 | 0.803174895713292 | false | false | false | true | ||||||||||||||||
| 57676813-3c7b-4d13-ac7d-ec6a5043280c | 2026-09-22 14:46 | 2026-09-22 14:46 | 2026-09-22 14:46 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 3.5500 | 3.5000 | 3.5500 | 48.7800 | 12780.00 | 12780.00 | 0.00 | 36 | 6 | 3459 | 17037 | 0.203028702236309 | 0.808433114024719 | 0.808433114024719 | false | false | false | true | ||||||||||||||||
| 436da0ff-8f37-4f26-9e72-62069b114e08 | 2026-09-22 15:29 | 2026-09-22 15:29 | 2026-09-22 15:29 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 3.3000 | 3.2500 | 3.4000 | 48.0000 | 11550.00 | 2310.00 | 9240.00 | 35 | 5 | 3727 | 17037 | 0.21875917121559 | 0.802452102752396 | 0.802452102752396 | false | false | false | true | ||||||||||||||||
| 7a0ee207-34e9-4d72-a43b-fc40760e7a29 | 2026-09-23 10:07 | 2026-09-23 10:07 | 2026-09-23 10:07 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 3.3000 | 3.3000 | 3.5000 | 48.6700 | 49500.00 | 0.00 | 49500.00 | 150 | 34 | 941 | 15654 | 0.0601124313274562 | 0.786160581422064 | 0.786160581422064 | false | false | false | true | ||||||||||||||||
| cc611cd1-d471-42e2-963d-499e8b45c93c | 2026-09-23 10:10 | 2026-09-23 10:10 | 2026-09-23 10:10 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 3.1500 | 3.1500 | 3.3000 | 48.3195 | 12615.00 | 0.00 | 12615.00 | 40 | 7 | 1008 | 15654 | 0.06439248754312 | 0.800478789791318 | 0.790128000220575 | false | false | false | true | ||||||||||||||||
| 7755a20d-f6d4-4c98-8364-3a77a9047538 | 2026-09-23 11:00 | 2026-09-23 11:00 | 2026-09-23 11:00 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 3.6900 | 3.6500 | 3.7500 | 49.0000 | 55300.00 | 0.00 | 55300.00 | 150 | 5 | 1919 | 15654 | 0.122588475788936 | 0.804194792164894 | 0.804194792164894 | false | false | false | true | ||||||||||||||||
| f344b13d-8d9c-43ce-88e9-3bd3bd08253f | 2026-09-23 11:21 | 2026-09-23 11:21 | 2026-09-23 11:21 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 3.4000 | 3.3500 | 3.4500 | 48.8100 | 25840.00 | 22780.00 | 2720.00 | 76 | 9 | 2264 | 15654 | 0.144627571227801 | 0.792503763480804 | 0.792503763480804 | false | false | false | true | ||||||||||||||||
| b07cf567-ea05-41db-a9b7-7956f10c57a9 | 2026-09-24 10:05 | 2026-09-24 10:05 | 2026-09-24 10:05 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 2.0600 | 2.0600 | 2.1000 | 45.9400 | 20600.00 | 0.00 | 20600.00 | 100 | 6 | 1203 | 15229 | 0.0789940245584083 | 0.790421231604066 | 0.790421231604066 | false | false | false | true | ||||||||||||||||
| 10278139-a0f4-4dbb-9d2b-41c5bcd75c9f | 2026-09-24 10:08 | 2026-09-24 10:08 | 2026-09-24 10:08 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 2.1000 | 2.1000 | 2.1300 | 46.0600 | 21210.00 | 0.00 | 21210.00 | 101 | 5 | 1312 | 15229 | 0.0861514216297853 | 0.78839683276049 | 0.789274092302771 | false | false | false | true | ||||||||||||||||
| 0141d7a3-a158-4cc4-842d-4950c3f3721a | 2026-09-24 14:53 | 2026-09-24 14:53 | 2026-09-24 14:53 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 2.2000 | 2.2000 | 2.2500 | 46.5550 | 22001.00 | 0.00 | 22001.00 | 100 | 19 | 2956 | 15229 | 0.194103355440278 | 0.768451302702954 | 0.770726210639663 | false | false | false | true | ||||||||||||||||
| 409686f6-e373-409b-8f53-5781424fab06 | 2026-09-25 09:44 | 2026-09-25 09:44 | 2026-09-25 09:44 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 1.4500 | 1.4500 | 1.4800 | 44.5301 | 29000.00 | 0.00 | 29000.00 | 200 | 12 | 588 | 15469 | 0.0380115068847372 | 0.775386187616164 | 0.775386187616164 | false | false | false | true | ||||||||||||||||
| 6d72e7e0-0102-42a7-a599-d2951d6c293c | 2026-09-25 12:18 | 2026-09-25 12:18 | 2026-09-25 12:18 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 1.5200 | 1.4400 | 1.5200 | 44.0000 | 75882.00 | 75882.00 | 0.00 | 500 | 17 | 2870 | 15469 | 0.185532355032646 | 0.780959412711672 | 0.776685322547522 | false | false | false | true | ||||||||||||||||
| 5b0fbcec-3684-45d6-9b83-6c3c332e1b84 | 2026-09-25 12:39 | 2026-09-25 12:38 | 2026-09-25 12:38 | IREN | IREN261016C00050000 | call | 50.0000 | 2026-10-16 | 1.3000 | 1.2800 | 1.3100 | 44.1900 | 13000.00 | 1560.00 | 11440.00 | 100 | 7 | 3520 | 15469 | 0.227551877949447 | 0.763200014613156 | 0.761628102507907 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-21T19:06:05.917319Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 19131547360.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"} |
| 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-22T18:18:27.911867Z"} |
| 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-22T18:29:55.439380Z"} |
| 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-22T18:55:20.077577Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:33:11.786837Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-23T14:09:27.878659Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 18540459388.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:00:57.901243Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-23T15:23:47.442599Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T14:06:35.686187Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T14:08:54.070178Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T18:57:49.526864Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17387837843.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:45:37.818098Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 17387837843.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:20:53.748346Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 17387837843.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:45:32.616673Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |