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 |
|---|
| 019bb2b2-bda5-4cdf-93bb-04f720af1904 | 2026-08-17 10:44 | 2026-08-17 10:44 | 2026-08-17 10:44 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 3.8000 | 3.8000 | 3.9000 | 44.5301 | 19000.00 | 0.00 | 3040.00 | 50 | 18 | 113 | 1725 | 0.0655072463768116 | 0.988028195041503 | 0.988028195041503 | false | false | false | true | false | 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-17T14:59:17.821734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 69379a3f-9eba-47c5-9981-4a4c96abb50f | 2026-08-26 14:10 | 2026-08-26 14:10 | 2026-08-26 14:10 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 1.8000 | 1.7500 | 1.8100 | 39.8872 | 79560.00 | 79200.00 | 360.00 | 442 | 40 | 593 | 1805 | 0.328531855955679 | 0.975676458173207 | 0.975676458173207 | false | false | false | true | ||||||||||||||||
| d83d7d1c-9671-46fd-bfe8-1124996e8fc1 | 2026-08-27 09:43 | 2026-08-27 09:43 | 2026-08-27 09:43 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 2.0800 | 1.9100 | 2.0800 | 41.1150 | 19552.00 | 19552.00 | 0.00 | 94 | 15 | 212 | 2470 | 0.08582995951417 | 0.977533405087358 | 0.977533405087358 | false | false | false | true | ||||||||||||||||
| 535e7166-382d-4379-baed-716b4a8d19f7 | 2026-09-03 13:17 | 2026-09-03 13:17 | 2026-09-03 13:17 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 1.1800 | 1.1200 | 1.1800 | 41.2800 | 15222.00 | 15222.00 | 0.00 | 129 | 10 | 1118 | 3040 | 0.367763157894737 | 0.840066393828837 | 0.840066393828837 | false | false | false | true | ||||||||||||||||
| 2cddd149-0a69-45c6-a04e-452a681530b1 | 2026-09-03 14:37 | 2026-09-03 14:37 | 2026-09-03 14:37 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 1.1100 | 1.1000 | 1.1100 | 40.9050 | 14652.00 | 14652.00 | 0.00 | 132 | 18 | 5299 | 3040 | 1.74309210526316 | 0.841113010528376 | 0.841113010528376 | false | false | false | true | ||||||||||||||||
| ca97a8ee-c3d5-4764-b3d2-abbfeb3b989a | 2026-09-04 15:45 | 2026-09-04 15:45 | 2026-09-04 15:45 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 2.0900 | 1.9900 | 2.1000 | 44.2862 | 24034.00 | 23825.00 | 209.00 | 115 | 36 | 1063 | 7243 | 0.146762391274334 | 0.887992254774838 | 0.88792459763956 | false | false | false | true | ||||||||||||||||
| 11db019b-1bc7-45ca-aa8f-f15f438bb554 | 2026-09-08 11:20 | 2026-09-08 11:20 | 2026-09-08 11:20 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 3.5000 | 3.4000 | 3.5250 | 48.4750 | 51100.00 | 50400.00 | 0.00 | 146 | 7 | 1633 | 7843 | 0.208211143695015 | 0.929112862817586 | 0.929112862817586 | false | false | false | true | ||||||||||||||||
| ca9e7318-74dc-4b8b-ba8f-a34b1c5be753 | 2026-09-08 14:46 | 2026-09-08 14:46 | 2026-09-08 14:46 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 3.1000 | 3.0500 | 3.1500 | 48.1000 | 94860.00 | 29760.00 | 38130.00 | 306 | 36 | 2888 | 7843 | 0.368226443962769 | 0.885843418546586 | 0.886483809020642 | false | false | false | true | ||||||||||||||||
| 06a9e47e-b2b4-49e5-98b3-db7f0e888f0d | 2026-09-09 13:49 | 2026-09-09 13:49 | 2026-09-09 13:49 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 2.0700 | 2.0700 | 2.1200 | 45.8100 | 20700.00 | 0.00 | 20700.00 | 100 | 23 | 606 | 7818 | 0.0775134305448964 | 0.852366370138114 | 0.852366370138114 | false | false | false | true | ||||||||||||||||
| 1783497c-039a-4849-b90f-f09675566b3f | 2026-09-15 09:55 | 2026-09-15 09:55 | 2026-09-15 09:55 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 0.9500 | 0.9500 | 0.9800 | 42.2800 | 16625.00 | 0.00 | 16625.00 | 175 | 6 | 206 | 8503 | 0.0242267435022933 | 0.864898096789533 | 0.864898096789533 | false | false | false | true | ||||||||||||||||
| 592a6aa5-2995-46f0-8c9e-b0b761948df5 | 2026-09-15 10:25 | 2026-09-15 10:25 | 2026-09-15 10:25 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 0.9100 | 0.9100 | 0.9200 | 42.0800 | 14196.00 | 0.00 | 14196.00 | 156 | 6 | 500 | 8503 | 0.0588027754910032 | 0.863682004733308 | 0.863682004733308 | false | false | false | true | ||||||||||||||||
| b4fae33b-9266-4390-ac29-b6c1d6e2b0da | 2026-09-15 10:25 | 2026-09-15 10:25 | 2026-09-15 10:25 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 0.9100 | 0.9100 | 0.9200 | 42.0850 | 36309.00 | 0.00 | 36309.00 | 399 | 9 | 899 | 8503 | 0.105727390332824 | 0.863403671305506 | 0.863403671305506 | false | false | false | true | ||||||||||||||||
| 661324b1-94f8-4394-adf4-2863ae26f273 | 2026-09-15 10:25 | 2026-09-15 10:25 | 2026-09-15 10:25 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 0.9100 | 0.9100 | 0.9200 | 42.0850 | 13923.00 | 0.00 | 13923.00 | 153 | 9 | 1052 | 8503 | 0.123721039633071 | 0.863403671305506 | 0.863403671305506 | false | false | false | true | ||||||||||||||||
| c24f83c5-c3a8-4f32-89da-a12ab69ed1d0 | 2026-09-15 10:27 | 2026-09-15 10:27 | 2026-09-15 10:27 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 0.9000 | 0.9000 | 0.9100 | 42.0850 | 21780.00 | 0.00 | 21780.00 | 242 | 8 | 1433 | 8503 | 0.168528754557215 | 0.860265006546125 | 0.860265006546125 | false | false | false | true | ||||||||||||||||
| f6b4c98b-6653-4480-bb07-a1bf314ab404 | 2026-09-18 10:08 | 2026-09-18 10:08 | 2026-09-18 10:08 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 1.0500 | 1.0200 | 1.1000 | 43.7100 | 38115.00 | 15435.00 | 22680.00 | 363 | 6 | 2136 | 10125 | 0.210962962962963 | 0.85783566967342 | 0.857249654982567 | false | false | false | true | ||||||||||||||||
| cb5c4a6e-296f-4583-8aeb-4a1d8bb3bc0d | 2026-09-18 14:02 | 2026-09-18 14:02 | 2026-09-18 14:02 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 1.4500 | 1.3900 | 1.4800 | 45.7850 | 38425.00 | 34800.00 | 3625.00 | 265 | 5 | 4412 | 10125 | 0.435753086419753 | 0.838021964827323 | 0.838021964827323 | false | false | false | true | ||||||||||||||||
| 2d629665-6817-4acc-910b-ddbfbecdfce3 | 2026-09-21 12:47 | 2026-09-21 12:47 | 2026-09-21 12:47 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 1.6500 | 1.5700 | 1.6700 | 47.4050 | 40262.00 | 7262.00 | 33000.00 | 244 | 11 | 4200 | 12648 | 0.332068311195446 | 0.828893979547807 | 0.833625614419002 | true | false | false | true | ||||||||||||||||
| 6db57053-5a22-4d6a-aeaa-ebb7e7b7b66d | 2026-09-21 14:25 | 2026-09-21 14:25 | 2026-09-21 14:25 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 2.0000 | 1.9600 | 2.0000 | 48.4600 | 105600.00 | 105600.00 | 0.00 | 528 | 12 | 5150 | 12648 | 0.407179000632511 | 0.835323781616315 | 0.835323781616315 | true | false | false | true | ||||||||||||||||
| 64007b04-8dc4-4467-9761-87082cf35b39 | 2026-09-22 09:54 | 2026-09-22 09:54 | 2026-09-22 09:54 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 2.0700 | 2.0100 | 2.0800 | 48.7400 | 88960.00 | 88960.00 | 0.00 | 430 | 16 | 612 | 13496 | 0.0453467694131595 | 0.850271509553677 | 0.845862372477005 | false | false | false | true | ||||||||||||||||
| f1a0babc-5d2d-40fe-ab83-27a7c3e5fbee | 2026-09-24 14:25 | 2026-09-24 14:25 | 2026-09-24 14:25 | IREN | IREN261016C00055000 | call | 55.0000 | 2026-10-16 | 1.0500 | 1.0100 | 1.0500 | 46.1900 | 50610.00 | 50610.00 | 0.00 | 482 | 19 | 1370 | 15831 | 0.0865390689154191 | 0.804974146427038 | 0.804974146427038 | 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-26T18:39:51.047298Z"} |
| 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-27T13:49:05.616113Z"} |
| 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-03T17:30:37.600118Z"} |
| 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-03T18:47:01.806289Z"} |
| 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:47:04.296573Z"} |
| 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-08T15:26:49.659255Z"} |
| 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:03:39.512328Z"} |
| 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-09T17:50:47.676652Z"} |
| 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-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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-15T14:36:37.058930Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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-15T14:36:37.058930Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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-15T14:36:37.058930Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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-15T14:36:37.058930Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 18394657689.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 18394657689.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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:51:16.040164Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} |
| 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-22T13:56:25.927111Z"} |
| 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-24T18:26:21.590036Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |