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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61c056a6-66ca-4ba4-a137-c96c0417ffe4 | 2026-08-14 15:55 | 2026-08-14 15:55 | 2026-08-14 15:55 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 0.7300 | 0.6900 | 0.7300 | 71.8400 | 10870.00 | 10366.00 | 0.00 | 149 | 13 | 3468 | 10954 | 0.316596677012963 | 0.793376744699157 | 0.789529294963876 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0fc4d75b-81d6-447f-94fc-ad60d8722857 | 2026-08-18 11:29 | 2026-08-18 11:29 | 2026-08-18 11:29 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 0.5700 | 0.5500 | 0.5700 | 72.8410 | 18810.00 | 18810.00 | 0.00 | 330 | 34 | 2410 | 11808 | 0.20409891598916 | 1.0163237796969 | 1.0163237796969 | 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-08-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 894f7945-9102-4b73-8638-87df15e9b94a | 2026-08-18 14:29 | 2026-08-18 14:29 | 2026-08-18 14:29 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 0.3700 | 0.3400 | 0.3700 | 71.8600 | 11100.00 | 11100.00 | 0.00 | 300 | 34 | 3786 | 11808 | 0.320630081300813 | 0.976733619884656 | 0.976733619884656 | 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-18T18:49:07.657249Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| abfec095-b303-4244-a74c-39bfa545081a | 2026-08-19 09:35 | 2026-08-19 09:35 | 2026-08-19 09:35 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 1.5400 | 1.5400 | 1.6100 | 77.3350 | 30184.00 | 0.00 | 30184.00 | 196 | 18 | 1192 | 11456 | 0.104050279329609 | 1.14422198837107 | 1.14422198837107 | 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-19T13:40:44.275238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 38a8246e-3ef7-4d92-bd99-a708a5d6a305 | 2026-08-19 09:35 | 2026-08-19 09:35 | 2026-08-19 09:35 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 1.4800 | 1.4800 | 1.5600 | 77.2350 | 35224.00 | 0.00 | 35224.00 | 238 | 18 | 1553 | 11456 | 0.135562150837989 | 1.13286544058031 | 1.13286544058031 | 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-19T13:40:44.275238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ba5ecc5d-d062-4bc6-94f0-357c3eb599d1 | 2026-08-19 10:35 | 2026-08-19 10:35 | 2026-08-19 10:35 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 1.3000 | 1.2600 | 1.3500 | 76.8700 | 12350.00 | 6890.00 | 5460.00 | 95 | 8 | 3716 | 11456 | 0.324371508379888 | 1.10636626913676 | 1.10636626913676 | 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-19T14:37:39.751673Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 73f5fdcb-3c70-4329-bbb7-c5ad8fde147b | 2026-08-19 10:50 | 2026-08-19 10:50 | 2026-08-19 10:50 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 2.0000 | 1.9700 | 2.0200 | 78.7450 | 26802.00 | 26802.00 | 0.00 | 134 | 22 | 4591 | 11456 | 0.400750698324022 | 1.09769101394673 | 1.10638956643043 | 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-19T15:01:13.058297Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4c3187e2-3d89-47f2-9969-c7c3ac966165 | 2026-08-19 11:27 | 2026-08-19 11:27 | 2026-08-19 11:27 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 2.4000 | 2.3200 | 2.4000 | 79.6700 | 10800.00 | 10800.00 | 0.00 | 45 | 9 | 6766 | 11456 | 0.590607541899441 | 1.08355839675417 | 1.08355839675417 | 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-19T15:33:41.628321Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b19c62b8-184e-4de3-acad-2048d6b016b1 | 2026-08-19 11:42 | 2026-08-19 11:42 | 2026-08-19 11:42 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 3.0000 | 2.9600 | 3.0000 | 80.6600 | 13800.00 | 13800.00 | 0.00 | 46 | 10 | 7489 | 11456 | 0.653718575418994 | 1.11667786088399 | 1.11667786088399 | 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-19T15:49:41.153087Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d72b9978-326e-4a4f-ba38-11334f6373f1 | 2026-08-20 09:31 | 2026-08-20 09:31 | 2026-08-20 09:31 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 2.3800 | 2.3800 | 2.6600 | 80.6400 | 95200.00 | 0.00 | 95200.00 | 400 | 25 | 518 | 9627 | 0.0538070011426197 | 1.21627845014203 | 1.21627845014203 | 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-20T13:35:56.061771Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f7d241c1-a216-4ab7-9000-f0d3cba3ec02 | 2026-08-20 09:32 | 2026-08-20 09:32 | 2026-08-20 09:32 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 2.1700 | 2.1700 | 2.2800 | 80.0200 | 10850.00 | 0.00 | 10850.00 | 50 | 6 | 649 | 9627 | 0.0674145632076452 | 1.29066482592453 | 1.29066482592453 | 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-20T13:35:56.061771Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8657127b-19c0-451e-9ca6-a29b33796d61 | 2026-08-20 11:01 | 2026-08-20 11:01 | 2026-08-20 11:01 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 4.0000 | 3.7500 | 4.0000 | 83.1105 | 18000.00 | 18000.00 | 0.00 | 45 | 5 | 2838 | 9627 | 0.294795886569025 | 1.22123020972844 | 1.22123020972844 | 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-20T15:02:58.462752Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 81fe0341-c4ec-4990-9bdd-2d396f3cc5aa | 2026-08-21 09:36 | 2026-08-21 09:36 | 2026-08-21 09:36 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 9.0000 | 9.0000 | 9.8500 | 89.3500 | 14400.00 | 0.00 | 14400.00 | 16 | 5 | 708 | 8443 | 0.0838564491294563 | 3.54639528625572 | 3.54639528625572 | 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-21T13:43:10.748747Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0698067c-365a-476d-ac72-17faffe4cfae | 2026-08-21 09:38 | 2026-08-21 09:38 | 2026-08-21 09:38 | CRCL | CRCL260821C00080000 | call | 80.0000 | 2026-08-21 | 10.0000 | 9.0500 | 10.0000 | 89.8850 | 18000.00 | 18000.00 | 0.00 | 18 | 6 | 736 | 8443 | 0.0871728058746891 | 2.57264969008156 | 2.57264969008156 | 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-21T13:43:10.748747Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |