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_alerts609,118 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 | strike |
|---|
| 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 |
|---|
| d801f8f4-01fe-4923-9aff-8a0038d644ca | 2026-09-29 12:14 | 2026-09-29 12:14 | 2026-09-29 12:14 | GGAL | GGAL270115C00045000 | call | 45.0000 | 2027-01-15 | 1.5000 | 1.5000 | 1.5500 | 36.9600 | 22500.00 | 0.00 | 22500.00 | 150 | 5 | 500 | 383 | 1.30548302872063 | 0.481127975352031 | 0.481127975352031 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Financial Services | 1041082548.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T16:22:19.511373Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 81716c99-a5e6-4973-ac92-1e1ae369b182 | 2026-09-29 10:58 | 2026-09-29 10:57 | 2026-09-29 10:57 | GGAL | GGAL270115C00040000 | call | 40.0000 | 2027-01-15 | 2.8500 | 2.7000 | 3.1000 | 37.0000 | 14250.00 | 13965.00 | 285.00 | 50 | 5 | 50 | 596 | 0.0838926174496644 | 0.466991596475437 | 0.466991596475437 | false | false | false | |||||||||||||||||
| de514a06-ab2e-4219-8fa1-aa20573a5b47 | 2026-09-28 12:34 | 2026-09-28 12:34 | 2026-09-28 12:34 | GGAL | GGAL261120P00035000 | put | 35.0000 | 2026-11-20 | 1.5700 | 1.3500 | 1.8000 | 37.3500 | 266900.00 | 108800.00 | 158100.00 | 1700 | 2 | 1706 | 1700 | 1.00352941176471 | 0.491400704971595 | 0.491400704971595 | false | true | false | |||||||||||||||||
| 502bac92-67bd-42f3-9b8e-b581cbee09a0 | 2026-09-21 10:46 | 2026-09-21 10:46 | 2026-09-21 10:46 | GGAL | GGAL261016C00042000 | call | 42.0000 | 2026-10-16 | 1.5500 | 1.5500 | 3.0000 | 41.4800 | 19375.00 | 0.00 | 19375.00 | 125 | 8 | 125 | 73 | 1.71232876712329 | 0.401256667750434 | 0.401256667750434 | false | false | false | |||||||||||||||||
| d2b1f698-d5bf-4908-bfb4-39b03207a2ff | 2026-09-09 13:47 | 2026-09-09 13:47 | 2026-09-09 13:47 | GGAL | GGAL270115C00041000 | call | 41.0000 | 2027-01-15 | 7.1000 | 6.7500 | 7.1000 | 44.5100 | 71000.00 | 71000.00 | 0.00 | 100 | 21 | 100 | 50 | 2 | 0.478887920910105 | 0.478887920910105 | false | false | false | |||||||||||||||||
| 89331bcb-4645-4c73-9426-14b9b8aae970 | 2026-09-08 11:30 | 2026-09-08 11:30 | 2026-09-08 11:30 | GGAL | GGAL261016C00050000 | call | 50.0000 | 2026-10-16 | 0.8000 | 0.7000 | 0.9500 | 43.8950 | 11120.00 | 11040.00 | 80.00 | 139 | 19 | 139 | 3466 | 0.0401038661281016 | 0.469461504574525 | 0.469461504574525 | false | false | false | |||||||||||||||||
| 39896952-f95d-41b9-b15b-33a29f5db446 | 2026-09-02 11:12 | 2026-09-02 11:12 | 2026-09-02 11:12 | GGAL | GGAL261016C00045000 | call | 45.0000 | 2026-10-16 | 2.6500 | 2.3000 | 2.6500 | 44.4600 | 13515.00 | 13515.00 | 0.00 | 51 | 16 | 51 | 161 | 0.316770186335404 | 0.45535710763393 | 0.45535710763393 | false | false | false | |||||||||||||||||
| f6cdd72d-0ad9-47f9-91b0-a498a2e90e97 | 2026-09-01 10:23 | 2026-09-01 10:23 | 2026-09-01 10:23 | GGAL | GGAL260918C00046000 | call | 46.0000 | 2026-09-18 | 1.2000 | 0.8500 | 2.3500 | 44.5900 | 18000.00 | 0.00 | 18000.00 | 150 | 5 | 150 | 376 | 0.398936170212766 | 0.458715670628605 | 0.458715670628605 | false | false | false | |||||||||||||||||
| 25dad9db-7d26-4c7d-b260-9fd24161f793 | 2026-08-25 11:32 | 2026-08-25 11:32 | 2026-08-25 11:32 | GGAL | GGAL261016C00044000 | call | 44.0000 | 2026-10-16 | 2.9500 | 2.7000 | 2.9500 | 43.0300 | 12685.00 | 12685.00 | 0.00 | 43 | 24 | 49 | 16 | 3.0625 | 0.506293344449832 | 0.506293344449832 | false | false | false | |||||||||||||||||
| bd0da312-1d86-4cd2-aa4e-26da70885236 | 2026-08-20 14:38 | 2026-08-20 14:38 | 2026-08-20 14:38 | GGAL | GGAL260918P00041000 | put | 41.0000 | 2026-09-18 | 2.3000 | 2.0000 | 2.3000 | 40.8100 | 27830.00 | 27830.00 | 0.00 | 121 | 22 | 131 | 57 | 2.29824561403509 | 0.493801337203222 | 0.493801337203222 | false | false | false | |||||||||||||||||
| c677defb-68bb-4a7f-ace1-67f54388a3b0 | 2026-08-19 13:53 | 2026-08-19 13:52 | 2026-08-19 13:52 | GGAL | GGAL260918C00040000 | call | 40.0000 | 2026-09-18 | 3.0000 | 2.6500 | 3.0000 | 41.1100 | 12300.00 | 12300.00 | 0.00 | 41 | 6 | 41 | 52 | 0.788461538461538 | 0.503825331148144 | 0.503825331148144 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 1041082548.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:59:11.940359Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 1039957662.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:39:53.834597Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 1174381610.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:47:49.730853Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 1208128208.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:50:47.676652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 1208128208.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:43:32.720264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 1208128208.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 1208128208.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 1208128208.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 1208128208.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 1208128208.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |