Options flow alerts (market-wide)
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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0edcac9d-fcb1-4830-8c7a-316327083b1b | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 1.3000 | 1.2000 | 1.3400 | 92.0000 | 20544.00 | 13915.00 | 6629.00 | 158 | 8 | 772 | 10883 | 0.0709363227051364 | 0.789338675662908 | 0.794616227243603 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 21539406738.00 | 2026-11-11 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| c7ea3e66-f590-426b-81ae-9c387e3e86e5 | 2026-09-15 15:10 | 2026-09-15 15:10 | 2026-09-15 15:10 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 1.2800 | 1.2500 | 1.4300 | 87.8745 | 13610.00 | 4004.00 | 9606.00 | 106 | 14 | 1163 | 10895 | 0.106746213859569 | 0.847381441352433 | 0.858322034794354 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 90d3bf54-2003-43e6-9e8f-3b08e6132572 | 2026-09-15 14:48 | 2026-09-15 14:48 | 2026-09-15 14:48 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 1.0600 | 1.0500 | 1.2000 | 85.3681 | 17231.00 | 1456.00 | 15775.00 | 163 | 24 | 806 | 10895 | 0.0739788893988068 | 0.86181289488764 | 0.876375692789334 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 1f366038-ce27-4469-8f49-6cab5f08febf | 2026-09-14 15:27 | 2026-09-14 15:27 | 2026-09-14 15:27 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 3.4000 | 3.2500 | 3.4500 | 97.2400 | 62560.00 | 42840.00 | 19720.00 | 184 | 10 | 776 | 11016 | 0.0704429920116195 | 0.880087039214743 | 0.880087039214743 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fff78024-3416-455a-8000-293647477791 | 2026-09-14 13:50 | 2026-09-14 13:50 | 2026-09-14 13:50 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 3.1500 | 3.1000 | 3.2000 | 96.7950 | 12285.00 | 315.00 | 0.00 | 39 | 6 | 490 | 11016 | 0.044480755265069 | 0.864740883868045 | 0.864740883868045 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| de0c1970-7470-45e5-b48e-f352b9b93775 | 2026-09-11 09:57 | 2026-09-11 09:57 | 2026-09-11 09:57 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 2.6700 | 2.4800 | 2.7800 | 94.0000 | 29620.00 | 13823.00 | 13394.00 | 111 | 14 | 483 | 10676 | 0.0452416635443987 | 0.831113675344774 | 0.838147526811042 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 72c3050c-c91b-47fc-ad33-61787ddd30b2 | 2026-09-09 10:27 | 2026-09-09 10:27 | 2026-09-09 10:27 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 3.4900 | 3.3000 | 3.5000 | 96.0000 | 17425.00 | 12250.00 | 5175.00 | 50 | 6 | 379 | 10549 | 0.0359275760735615 | 0.855018862755758 | 0.855018862755758 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0baf4bbf-3a7f-4151-926d-e1bfc7c017c2 | 2026-09-04 15:46 | 2026-09-04 15:45 | 2026-09-04 15:45 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 5.2000 | 5.2000 | 5.2500 | 101.4700 | 22880.00 | 0.00 | 22880.00 | 44 | 14 | 981 | 9872 | 0.099371961102107 | 0.816467415217925 | 0.816467415217925 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | 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 |
| 5d81fa45-4c43-4c5c-b380-df2a91925939 | 2026-09-04 15:45 | 2026-09-04 15:45 | 2026-09-04 15:45 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 5.2400 | 5.1500 | 5.2500 | 101.4800 | 15734.00 | 14700.00 | 1034.00 | 30 | 8 | 880 | 9872 | 0.0891410048622366 | 0.820233056210447 | 0.813784576526834 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | 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 |
| df59cffd-d5f1-43b7-ad4c-c42560844e11 | 2026-09-04 11:01 | 2026-09-04 11:01 | 2026-09-04 11:01 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 4.0500 | 4.0000 | 4.1000 | 98.3501 | 17010.00 | 6885.00 | 0.00 | 42 | 5 | 492 | 9872 | 0.049837925445705 | 0.799144320013239 | 0.799144320013239 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3235cc9b-432d-4924-9f9d-733c7b83619b | 2026-09-03 15:59 | 2026-09-03 15:59 | 2026-09-03 15:59 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 5.9500 | 5.8500 | 6.0000 | 103.0582 | 68425.00 | 67830.00 | 595.00 | 115 | 14 | 1940 | 9375 | 0.206933333333333 | 0.823442716709527 | 0.823223154986756 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3fcb84f2-1b00-4649-95a4-3d2d59518ab0 | 2026-09-03 15:56 | 2026-09-03 15:56 | 2026-09-03 15:56 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 5.8000 | 5.7000 | 5.9500 | 102.8500 | 54520.00 | 1160.00 | 30160.00 | 94 | 8 | 1819 | 9375 | 0.194026666666667 | 0.817309684126695 | 0.817309684126695 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cb381ffc-90e2-440e-a2a1-13ceacbc902a | 2026-09-03 13:53 | 2026-09-03 13:53 | 2026-09-03 13:53 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 6.0500 | 5.8500 | 6.0500 | 102.8290 | 37510.00 | 37510.00 | 0.00 | 62 | 18 | 1530 | 9375 | 0.1632 | 0.836999716634918 | 0.836999716634918 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4aa64830-a119-4378-b850-0da9def0ca64 | 2026-09-03 13:52 | 2026-09-03 13:52 | 2026-09-03 13:52 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 6.0000 | 5.9000 | 6.0000 | 102.8100 | 10200.00 | 10200.00 | 0.00 | 17 | 5 | 1374 | 9375 | 0.14656 | 0.833692514391397 | 0.833692514391397 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fddb1c0f-cada-4fd7-961e-729005de1852 | 2026-09-03 09:41 | 2026-09-03 09:41 | 2026-09-03 09:41 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 4.5500 | 4.2500 | 4.6500 | 97.5750 | 23645.00 | 22745.00 | 900.00 | 52 | 27 | 268 | 9375 | 0.0285866666666667 | 0.848339216074175 | 0.848339216074175 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:45:03.310585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 102a3501-f7a0-412f-8af2-36308f14333d | 2026-08-27 15:19 | 2026-08-27 15:19 | 2026-08-27 15:19 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 4.3500 | 4.3500 | 4.5000 | 94.0000 | 202720.00 | 0.00 | 202720.00 | 466 | 34 | 906 | 6071 | 0.149234063580959 | 0.841434872663727 | 0.841434872663727 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7a346419-5130-431f-b2fc-72292d2a1ae6 | 2026-08-27 11:27 | 2026-08-27 11:27 | 2026-08-27 11:27 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 4.3000 | 4.3000 | 4.5000 | 94.0600 | 64500.00 | 0.00 | 64500.00 | 150 | 9 | 322 | 6071 | 0.0530390380497447 | 0.851345063296293 | 0.851345063296293 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| df9bab8a-7077-4295-96f6-b66dc65f19c5 | 2026-08-24 11:31 | 2026-08-24 11:31 | 2026-08-24 11:31 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 4.9000 | 4.7500 | 4.9000 | 91.8600 | 12241.00 | 11760.00 | 481.00 | 25 | 6 | 228 | 5808 | 0.0392561983471074 | 0.928330325733772 | 0.920762861831318 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:49:37.820281Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a8ceda75-a367-498f-857a-fa8a6bad4156 | 2026-08-24 11:25 | 2026-08-24 11:24 | 2026-08-24 11:24 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 4.9000 | 4.5500 | 4.9000 | 91.6000 | 49000.00 | 49000.00 | 0.00 | 100 | 7 | 203 | 5808 | 0.0349517906336088 | 0.93459089001561 | 0.93459089001561 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1bcbad22-fd7a-4fc2-a5f0-bf0a57a266da | 2026-08-19 12:02 | 2026-08-19 12:02 | 2026-08-19 12:02 | CRCL | CRCL261016C00120000 | call | 120.0000 | 2026-10-16 | 2.5500 | 2.3900 | 2.5600 | 80.4000 | 10710.00 | 10710.00 | 0.00 | 42 | 6 | 396 | 6011 | 0.0658792214273831 | 0.919037842610836 | 0.919037842610836 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |