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_alerts658,639 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 | expiry |
|---|
| 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 |
|---|
| 34a7d616-0e49-48de-ba8d-622de2708bf8 | 2026-09-28 15:22 | 2026-09-28 15:22 | 2026-09-28 15:22 | CIFR | CIFR270115C00017000 | call | 17.0000 | 2027-01-15 | 3.5000 | 3.5000 | 3.6000 | 16.8950 | 249900.00 | 0.00 | 249900.00 | 714 | 34 | 875 | 5586 | 0.156641604010025 | 0.948481205122023 | 0.948481205122023 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 6947614286.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T19:23:02.177643Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| a54cf30d-d488-4d96-82fd-3cf5825cd841 | 2026-09-17 15:07 | 2026-09-17 15:06 | 2026-09-17 15:06 | CIFR | CIFR270115C00017000 | call | 17.0000 | 2027-01-15 | 3.8000 | 3.7500 | 3.9000 | 17.1300 | 11400.00 | 7980.00 | 1900.00 | 30 | 9 | 178 | 5695 | 0.0312554872695347 | 0.943778759262612 | 0.943778759262612 | false | false | false | true | ||||||||||||||||
| 38d3851d-b8bb-4de2-b9fc-61027873297d | 2026-09-17 14:46 | 2026-09-17 14:46 | 2026-09-17 14:46 | CIFR | CIFR270115C00017000 | call | 17.0000 | 2027-01-15 | 3.8500 | 3.7500 | 3.9000 | 17.2000 | 20020.00 | 12320.00 | 0.00 | 52 | 6 | 148 | 5695 | 0.0259877085162423 | 0.945481429378769 | 0.945481429378769 | false | false | false | true | ||||||||||||||||
| 719c5d78-6cab-450e-a7f9-5d3ae4fad61d | 2026-09-08 10:54 | 2026-09-08 10:53 | 2026-09-08 10:53 | CIFR | CIFR270115C00017000 | call | 17.0000 | 2027-01-15 | 5.1000 | 4.8500 | 5.1500 | 18.6350 | 63750.00 | 38250.00 | 25500.00 | 125 | 6 | 145 | 5586 | 0.0259577515216613 | 0.989942400715935 | 0.990806291643487 | false | false | false | true | ||||||||||||||||
| da1d4739-fb81-4440-b7db-017da7497227 | 2026-09-04 10:56 | 2026-09-04 10:56 | 2026-09-04 10:56 | CIFR | CIFR270115C00017000 | call | 17.0000 | 2027-01-15 | 4.3500 | 4.2500 | 4.4500 | 17.7050 | 14355.00 | 1740.00 | 5220.00 | 33 | 8 | 48 | 5611 | 0.00855462484405632 | 0.942411559417373 | 0.942411559417373 | false | false | false | true | ||||||||||||||||
| 6f39791d-bf7a-4961-9ce4-461c0d6fdb47 | 2026-08-31 12:28 | 2026-08-31 12:28 | 2026-08-31 12:28 | CIFR | CIFR270115C00017000 | call | 17.0000 | 2027-01-15 | 2.9500 | 2.9500 | 2.9900 | 14.9300 | 22420.00 | 0.00 | 22420.00 | 76 | 8 | 230 | 5429 | 0.0423650764413336 | 0.99502018067227 | 0.99502018067227 | false | false | false | true | ||||||||||||||||
| 65fae44a-aba7-4ff7-b443-a9b7223d969d | 2026-08-31 12:28 | 2026-08-31 12:28 | 2026-08-31 12:28 | CIFR | CIFR270115C00017000 | call | 17.0000 | 2027-01-15 | 2.9500 | 2.9500 | 3.0500 | 14.9300 | 12980.00 | 0.00 | 12980.00 | 44 | 10 | 154 | 5429 | 0.0283661816172407 | 0.99502018067227 | 0.99502018067227 | false | false | false | true | ||||||||||||||||
| af7582f1-671d-4682-8a8f-8c44115f2906 | 2026-08-21 12:51 | 2026-08-21 12:50 | 2026-08-21 12:50 | CIFR | CIFR270115C00017000 | call | 17.0000 | 2027-01-15 | 3.6000 | 3.6000 | 3.9500 | 15.6150 | 21600.00 | 0.00 | 21600.00 | 60 | 16 | 335 | 5311 | 0.0630766334023724 | 1.02809137666341 | 1.02809137666341 | false | false | false | true | ||||||||||||||||
| 446d772e-293e-45bb-8d31-86549d8b552e | 2026-08-21 11:15 | 2026-08-21 11:15 | 2026-08-21 11:15 | CIFR | CIFR270115C00017000 | call | 17.0000 | 2027-01-15 | 3.9000 | 3.8000 | 3.9000 | 15.9250 | 17550.00 | 17550.00 | 0.00 | 45 | 5 | 231 | 5311 | 0.0434946337789493 | 1.0578622884458 | 1.0578622884458 | false | false | false | true | ||||||||||||||||
| 3b6de861-cfd1-4102-ba72-3e732650b0ef | 2026-08-18 13:27 | 2026-08-18 13:26 | 2026-08-18 13:26 | CIFR | CIFR270115C00017000 | call | 17.0000 | 2027-01-15 | 4.2000 | 4.2000 | 4.3000 | 16.5350 | 18900.00 | 0.00 | 8400.00 | 45 | 12 | 118 | 4652 | 0.0253654342218401 | 1.02813379464126 | 1.02813379464126 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7030620431.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:28:01.580099Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7030620431.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |