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_alerts566,287 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 |
|---|
| f9016bd4-0855-4a05-a486-ee5c595ea460 | 2026-09-01 12:03 | 2026-09-01 12:03 | 2026-09-01 12:03 | GLD | GLD270115C00350000 | call | 350.0000 | 2027-01-15 | 61.0000 | 60.7000 | 61.1000 | 401.0000 | 317200.00 | 12200.00 | 305000.00 | 52 | 5 | 158 | 10286 | 0.0153606844254326 | 0.250261133012944 | 0.250261133012944 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 143675098310.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ad9fe1a1-c3aa-4d96-9af8-4d149af09a78 | 2026-09-11 11:53 | 2026-09-11 11:53 | 2026-09-11 11:53 | GLD | GLD270115C00350000 | call | 350.0000 | 2027-01-15 | 60.1000 | 60.1000 | 60.3500 | 400.4400 | 396660.00 | 0.00 | 396660.00 | 66 | 6 | 352 | 10462 | 0.0336455744599503 | 0.256447760267748 | 0.256447760267748 | false | false | false | |||||||||||||||||
| 71ed764b-0754-4f6c-a8bf-ad9f686f8788 | 2026-09-11 11:54 | 2026-09-11 11:53 | 2026-09-11 11:53 | GLD | GLD270115C00350000 | call | 350.0000 | 2027-01-15 | 60.0500 | 59.9500 | 60.3000 | 400.3900 | 474395.00 | 0.00 | 474395.00 | 79 | 7 | 434 | 10462 | 0.0414834639648251 | 0.256312816935595 | 0.256312816935595 | false | false | false | |||||||||||||||||
| 4ffc5c96-937f-4b87-b06b-580ec9083102 | 2026-09-11 15:56 | 2026-09-11 15:56 | 2026-09-11 15:56 | GLD | GLD270115C00350000 | call | 350.0000 | 2027-01-15 | 58.0000 | 57.9000 | 58.3000 | 398.4100 | 278400.00 | 0.00 | 278400.00 | 48 | 8 | 700 | 10462 | 0.0669088128464921 | 0.249634778012175 | 0.249634778012175 | false | false | false | |||||||||||||||||
| bed1cd92-d803-444d-86e4-ae70698f1381 | 2026-09-11 16:01 | 2026-09-11 16:01 | 2026-09-11 16:01 | GLD | GLD270115C00350000 | call | 350.0000 | 2027-01-15 | 58.4000 | 58.4000 | 58.6500 | 398.6600 | 198560.00 | 0.00 | 198560.00 | 34 | 6 | 740 | 10462 | 0.0707321735805773 | 0.253099079796933 | 0.253099079796933 | false | false | false | |||||||||||||||||
| 4f76ffc2-878c-42a5-a1ee-dae9575387b7 | 2026-09-11 16:02 | 2026-09-11 16:01 | 2026-09-11 16:01 | GLD | GLD270115C00350000 | call | 350.0000 | 2027-01-15 | 58.3000 | 58.3000 | 58.6000 | 398.6600 | 134090.00 | 0.00 | 134090.00 | 23 | 5 | 763 | 10462 | 0.0729306060026764 | 0.251246734195903 | 0.251246734195903 | false | false | false | |||||||||||||||||
| 7a4a7e53-a8a2-4c13-a89c-a25e60fc196c | 2026-09-14 10:14 | 2026-09-14 10:14 | 2026-09-14 10:14 | GLD | GLD270115C00350000 | call | 350.0000 | 2027-01-15 | 52.6000 | 52.6000 | 53.0000 | 392.0000 | 389264.00 | 0.00 | 389264.00 | 74 | 11 | 243 | 11032 | 0.0220268310369833 | 0.248646033979604 | 0.248646033979604 | false | false | false | |||||||||||||||||
| 39c54209-3b6e-4852-9655-633acedeaf84 | 2026-09-14 10:31 | 2026-09-14 10:30 | 2026-09-14 10:30 | GLD | GLD270115C00350000 | call | 350.0000 | 2027-01-15 | 51.9000 | 51.9000 | 52.2500 | 391.4000 | 243930.00 | 0.00 | 243930.00 | 47 | 7 | 399 | 11032 | 0.0361675126903553 | 0.249246440797232 | 0.249726055284908 | false | false | false | |||||||||||||||||
| 922d30b5-d9ae-447c-a2c7-98b17cac59a1 | 2026-09-14 11:10 | 2026-09-14 11:10 | 2026-09-14 11:10 | GLD | GLD270115C00350000 | call | 350.0000 | 2027-01-15 | 53.0000 | 52.9500 | 53.1500 | 392.6400 | 1208400.00 | 5300.00 | 1203100.00 | 228 | 8 | 953 | 11032 | 0.0863850616388687 | 0.250980453223821 | 0.250980453223821 | false | false | false | |||||||||||||||||
| b2dfb841-b8bb-47ee-a212-57389e0c2379 | 2026-09-14 11:19 | 2026-09-14 11:19 | 2026-09-14 11:19 | GLD | GLD270115C00350000 | call | 350.0000 | 2027-01-15 | 52.5000 | 52.5000 | 52.7000 | 392.0800 | 131250.00 | 0.00 | 131250.00 | 25 | 5 | 998 | 11032 | 0.0904641044234953 | 0.250368053876252 | 0.250368053876252 | false | false | false | |||||||||||||||||
| 49d9a7db-d306-4a44-a303-2f65b25dc320 | 2026-09-15 09:37 | 2026-09-15 09:37 | 2026-09-15 09:37 | GLD | GLD270115C00350000 | call | 350.0000 | 2027-01-15 | 53.9500 | 53.9500 | 54.3500 | 393.6900 | 334499.00 | 0.00 | 334499.00 | 62 | 12 | 64 | 12254 | 0.00522278439693161 | 0.261916565834739 | 0.261916565834739 | false | false | false | |||||||||||||||||
| 9146cf71-d05c-4e64-8da3-50cddd835986 | 2026-09-15 09:47 | 2026-09-15 09:47 | 2026-09-15 09:47 | GLD | GLD270115C00350000 | call | 350.0000 | 2027-01-15 | 54.1000 | 54.0500 | 54.4500 | 393.7800 | 124431.00 | 0.00 | 124431.00 | 23 | 9 | 99 | 12254 | 0.00807899461400359 | 0.262784923827067 | 0.263204652072686 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:20:29.379987Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:20:29.379987Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:43:33.165845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |