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
active:option_symbol = DRAM261016C00060000×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bb820bf6-124e-447a-a88f-6864800ddc4d | 2026-08-19 12:15 | 2026-08-19 12:15 | 2026-08-19 12:15 | DRAM | DRAM261016C00060000 | call | 60.0000 | 2026-10-16 | 4.8500 | 4.8000 | 5.0000 | 55.4300 | 11640.00 | 485.00 | 11155.00 | 24 | 14 | 1556 | 16713 | 0.0931011787231496 | 0.740284500597179 | 0.740284500597179 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 90f781ce-ed65-4d54-8a18-9434f2c7c7f1 | 2026-08-19 11:11 | 2026-08-19 11:11 | 2026-08-19 11:11 | DRAM | DRAM261016C00060000 | call | 60.0000 | 2026-10-16 | 4.7500 | 4.7000 | 4.8500 | 55.3900 | 237500.00 | 14250.00 | 12825.00 | 500 | 22 | 1490 | 16713 | 0.0891521570035302 | 0.73096729265269 | 0.73096729265269 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 237f046e-df0e-43f4-bbdd-1910067faf44 | 2026-08-19 09:47 | 2026-08-19 09:47 | 2026-08-19 09:47 | DRAM | DRAM261016C00060000 | call | 60.0000 | 2026-10-16 | 5.0000 | 5.0000 | 5.1500 | 56.0200 | 10000.00 | 0.00 | 10000.00 | 20 | 5 | 517 | 16713 | 0.0309340034703524 | 0.726149741961457 | 0.726149741961457 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 995933da-a335-40e2-a3c4-83df872bb699 | 2026-08-19 09:30 | 2026-08-19 09:30 | 2026-08-19 09:30 | DRAM | DRAM261016C00060000 | call | 60.0000 | 2026-10-16 | 5.3000 | 5.3000 | 5.5000 | 56.6250 | 22262.00 | 0.00 | 22262.00 | 42 | 16 | 118 | 16713 | 0.00706037216538024 | 0.727287866213889 | 0.727287866213889 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2cc0ef93-7568-43ab-8286-ff4f6d450c07 | 2026-08-19 09:30 | 2026-08-19 09:30 | 2026-08-19 09:30 | DRAM | DRAM261016C00060000 | call | 60.0000 | 2026-10-16 | 5.3300 | 5.3000 | 5.5000 | 56.6301 | 60727.00 | 2145.00 | 31297.00 | 114 | 54 | 234 | 16713 | 0.0140010770059235 | 0.732030741127974 | 0.738121447363548 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f0c193e8-561d-4f91-ba3a-7cddb6e4f3e0 | 2026-08-19 09:30 | 2026-08-19 09:30 | 2026-08-19 09:30 | DRAM | DRAM261016C00060000 | call | 60.0000 | 2026-10-16 | 5.3000 | 5.3000 | 5.6500 | 56.6300 | 15371.00 | 0.00 | 15371.00 | 29 | 15 | 76 | 16713 | 0.00454735834380422 | 0.727017566690934 | 0.727017566690934 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 582076a5-ad7a-4487-9af5-2cee6c867a6f | 2026-08-19 09:30 | 2026-08-19 09:30 | 2026-08-19 09:30 | DRAM | DRAM261016C00060000 | call | 60.0000 | 2026-10-16 | 5.4500 | 5.3500 | 5.4500 | 56.8925 | 14715.00 | 14715.00 | 0.00 | 27 | 14 | 47 | 16713 | 0.0028121821336684 | 0.729386868908706 | 0.729386868908706 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e37dcde2-837d-4068-b110-e847f095147e | 2026-08-18 12:23 | 2026-08-18 12:23 | 2026-08-18 12:23 | DRAM | DRAM261016C00060000 | call | 60.0000 | 2026-10-16 | 4.7500 | 4.7500 | 4.9000 | 55.4650 | 19010.00 | 960.00 | 18050.00 | 40 | 8 | 2075 | 16354 | 0.126880273939097 | 0.720619743203634 | 0.720619743203634 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 887e75ec-cffd-49d1-beef-08ec3a1991e5 | 2026-08-17 15:57 | 2026-08-17 15:57 | 2026-08-17 15:57 | DRAM | DRAM261016C00060000 | call | 60.0000 | 2026-10-16 | 7.0500 | 7.0500 | 7.3000 | 60.2150 | 21150.00 | 0.00 | 21150.00 | 30 | 6 | 1646 | 16597 | 0.0991745496174007 | 0.698902466226214 | 0.698902466226214 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e0d60839-cf94-421d-bd41-64c2c30ea6fd | 2026-08-17 10:03 | 2026-08-17 10:03 | 2026-08-17 10:03 | DRAM | DRAM261016C00060000 | call | 60.0000 | 2026-10-16 | 7.5700 | 7.5000 | 7.7000 | 60.8680 | 18935.00 | 8355.00 | 4510.00 | 25 | 23 | 529 | 16597 | 0.0318732301018256 | 0.706480183970173 | 0.716876515701336 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c2558ee4-c14f-4c3e-9661-9409fc67c511 | 2026-08-17 09:34 | 2026-08-17 09:34 | 2026-08-17 09:34 | DRAM | DRAM261016C00060000 | call | 60.0000 | 2026-10-16 | 7.0000 | 6.8000 | 7.0500 | 60.0200 | 14700.00 | 14700.00 | 0.00 | 21 | 5 | 165 | 16597 | 0.00994155570283786 | 0.705242655782666 | 0.705242655782666 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 52b17e2a-e20b-48de-9f45-0289da8034bc | 2026-08-14 16:00 | 2026-08-14 15:59 | 2026-08-14 15:59 | DRAM | DRAM261016C00060000 | call | 60.0000 | 2026-10-16 | 5.6000 | 5.5000 | 5.6000 | 57.3400 | 22960.00 | 22960.00 | 0.00 | 41 | 11 | 5988 | 13011 | 0.460225962646991 | 0.690652142547211 | 0.690652142547211 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 286480.00 | — | — | — | 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 |