Simplify AnalyticsOptions 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9441907f-8848-4b2a-a5ca-b0d2df229d3d | 2026-09-10 15:08 | 2026-09-10 15:08 | 2026-09-10 15:08 | GLXY | GLXY261218C00035000 | call | 35.0000 | 2026-12-18 | 1.5800 | 1.5700 | 1.6700 | 24.1850 | 12642.00 | 0.00 | 12642.00 | 80 | 9 | 118 | 15590 | 0.00756895445798589 | 0.875618165366712 | 0.870959512891853 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 4688275419.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:25:57.950009Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cbad17dd-8691-43d6-a350-5b50100c9c3e | 2026-09-03 09:53 | 2026-09-03 09:53 | 2026-09-03 09:53 | GLXY | GLXY270115C00050000 | call | 50.0000 | 2027-01-15 | 1.1300 | 0.8700 | 1.1400 | 25.6300 | 18011.00 | 565.00 | 2367.00 | 160 | 37 | 704 | 4645 | 0.151560818083961 | 0.916268345002349 | 0.913844837575346 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 4688275419.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c179a112-a7c2-4eb2-adb1-ff78ec302fcf | 2026-09-03 09:53 | 2026-09-03 09:53 | 2026-09-03 09:53 | GLXY | GLXY270115C00050000 | call | 50.0000 | 2027-01-15 | 1.0800 | 1.0800 | 1.1000 | 25.6000 | 21468.00 | 0.00 | 9724.00 | 198 | 33 | 535 | 4645 | 0.115177610333692 | 0.907848858078361 | 0.905387708407972 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 4688275419.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b89c8df5-6c5a-44eb-8589-ec34646eb767 | 2026-08-27 11:11 | 2026-08-27 11:10 | 2026-08-27 11:10 | GLXY | GLXY261218P00022500 | put | 22.5000 | 2026-12-18 | 3.0500 | 2.8200 | 3.3500 | 25.6710 | 152658.00 | 0.00 | 152658.00 | 500 | 6 | 500 | 1116 | 0.448028673835125 | 0.870550438776731 | 0.870550438776731 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 4688275419.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 186de84e-ba38-4401-855e-9df5e0dbb1d6 | 2026-08-24 13:36 | 2026-08-24 13:36 | 2026-08-24 13:36 | GLXY | GLXY261016C00027500 | call | 27.5000 | 2026-10-16 | 1.6300 | 1.6300 | 1.6800 | 23.0700 | 45315.00 | 0.00 | 45315.00 | 278 | 10 | 1408 | 6098 | 0.230895375532962 | 0.881456358263003 | 0.878435607929916 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 4688275419.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 84b232ab-c147-4add-a50a-2fa7af9d05bb | 2026-08-24 11:09 | 2026-08-24 11:08 | 2026-08-24 11:08 | GLXY | GLXY261218C00022500 | call | 22.5000 | 2026-12-18 | 5.1500 | 5.1500 | 5.4000 | 23.3300 | 150390.00 | 0.00 | 150390.00 | 292 | 20 | 292 | 1035 | 0.282125603864734 | 0.913115443092828 | 0.902980880807729 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 4688275419.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:09:19.758040Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5ef5c387-c8cd-4b7c-b91a-1f653929309f | 2026-08-21 12:48 | 2026-08-21 12:48 | 2026-08-21 12:48 | GLXY | GLXY270115C00030000 | call | 30.0000 | 2027-01-15 | 3.5600 | 3.5000 | 3.8000 | 23.8700 | 71136.00 | 0.00 | 71136.00 | 200 | 6 | 410 | 8362 | 0.0490313322171729 | 0.898084561332435 | 0.898084561332435 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 4688275419.00 | 2026-10-20 | 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 |
| 08b9e1c0-74a0-4cb8-8535-94d0f4db9809 | 2026-08-19 14:25 | 2026-08-19 14:25 | 2026-08-19 14:25 | GLXY | GLXY260821P00022500 | put | 22.5000 | 2026-08-21 | 1.3300 | 1.2700 | 1.3500 | 21.4750 | 13329.00 | 11979.00 | 0.00 | 100 | 19 | 160 | 1725 | 0.0927536231884058 | 1.12345383168506 | 1.12345383168506 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 4688275419.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 73fe128c-5e25-4e41-b03f-63998fc022ba | 2026-08-18 12:39 | 2026-08-18 12:38 | 2026-08-18 12:38 | GLXY | GLXY270115C00030000 | call | 30.0000 | 2027-01-15 | 2.2300 | 2.0300 | 2.2800 | 20.8000 | 23145.00 | 23145.00 | 0.00 | 104 | 8 | 210 | 8166 | 0.0257163850110213 | 0.889613817884381 | 0.871701896201321 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 4688275419.00 | 2026-10-20 | unknown | — | 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 |