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 | strikenumeric | expirydate |
|---|
| 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 |
|---|
| ddccabd1-0f54-4204-8256-c981ab9dbcdb | 2026-08-31 11:08 | 2026-08-31 11:08 | 2026-08-31 11:08 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.6100 | 0.5700 | 0.6100 | 92.6750 | 12200.00 | 12200.00 | 0.00 | 200 | 6 | 230 | 35272 | 0.0065207530052166 | 0.0354503988873168 | 0.0354503988873168 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 41741256328.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 443013ea-2979-4462-9b2e-9e07a6a2e52a | 2026-09-04 11:54 | 2026-09-04 11:53 | 2026-09-04 11:53 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.5600 | 0.5300 | 0.5600 | 92.3200 | 202160.00 | 202160.00 | 0.00 | 3610 | 52 | 3622 | 35282 | 0.10265857944561 | 0.0418017906685174 | 0.0418017906685174 | false | false | false | true | ||||||||||||||||
| 0ff85ab6-26f0-4b9e-9d64-cd9053d985e6 | 2026-09-04 11:54 | 2026-09-04 11:53 | 2026-09-04 11:53 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.5600 | 0.5300 | 0.5600 | 92.3200 | 77840.00 | 77840.00 | 0.00 | 1390 | 5 | 5012 | 35282 | 0.142055439034068 | 0.0418017906685174 | 0.0418017906685174 | false | false | false | true | ||||||||||||||||
| be9ad2fe-4ee7-429f-bb6d-ca1d5c338a77 | 2026-09-08 14:55 | 2026-09-08 14:54 | 2026-09-08 14:54 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.4900 | 0.4500 | 0.4900 | 92.0692 | 147000.00 | 147000.00 | 0.00 | 3000 | 11 | 3004 | 38152 | 0.0787376808555253 | 0.0445653455454499 | 0.0445653455454499 | false | false | false | true | ||||||||||||||||
| 80b3da79-50a4-4b0f-a4a9-9c98072ca82e | 2026-09-10 09:33 | 2026-09-10 09:33 | 2026-09-10 09:33 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.3800 | 0.3500 | 0.3800 | 91.3901 | 113620.00 | 113620.00 | 0.00 | 2990 | 25 | 3000 | 42152 | 0.0711710001897893 | 0.050793115321382 | 0.050793115321382 | false | false | false | true | ||||||||||||||||
| f55d99ef-5a27-4cdb-bce8-90eafde8c68f | 2026-09-10 14:02 | 2026-09-10 14:02 | 2026-09-10 14:02 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.3900 | 0.3400 | 0.3900 | 91.1801 | 115011.00 | 115011.00 | 0.00 | 2949 | 40 | 6022 | 42152 | 0.142863921047637 | 0.0549705167510831 | 0.0549705167510831 | false | false | false | true | ||||||||||||||||
| c088119c-d21e-41ed-a21d-021e80d4adb5 | 2026-09-10 14:13 | 2026-09-10 14:12 | 2026-09-10 14:12 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.4200 | 0.3700 | 0.4200 | 91.1750 | 63000.00 | 63000.00 | 0.00 | 1500 | 12 | 7522 | 42152 | 0.178449421142532 | 0.0570164418243631 | 0.0570164418243631 | false | false | false | true | ||||||||||||||||
| 8c70c888-d061-44f2-8a18-7dee9e2699c0 | 2026-09-11 15:01 | 2026-09-11 15:00 | 2026-09-11 15:00 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.3700 | 0.3200 | 0.3700 | 91.0000 | 74000.00 | 74000.00 | 0.00 | 2000 | 24 | 2022 | 49439 | 0.0408988854952568 | 0.0585625168552251 | 0.0585625168552251 | false | false | false | true | ||||||||||||||||
| 1774ba8f-166c-42d7-81a0-764c0972d920 | 2026-09-18 14:13 | 2026-09-18 14:13 | 2026-09-18 14:13 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.2900 | 0.2600 | 0.2900 | 90.8550 | 34191.00 | 34191.00 | 0.00 | 1179 | 25 | 2672 | 53015 | 0.0504008299537867 | 0.0561670426986412 | 0.0561670426986412 | false | false | false | true | ||||||||||||||||
| 97ff84e3-b359-43be-a6c3-7dd309e1202a | 2026-09-23 09:55 | 2026-09-23 09:55 | 2026-09-23 09:55 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.2300 | 0.2100 | 0.2300 | 90.5800 | 36823.00 | 36823.00 | 0.00 | 1601 | 20 | 2601 | 55544 | 0.0468277401699553 | 0.0581162688534087 | 0.0581162688534087 | false | false | false | true | ||||||||||||||||
| 7d801817-aea3-4a5a-a88c-14a4b277a008 | 2026-09-23 11:32 | 2026-09-23 11:32 | 2026-09-23 11:32 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.2200 | 0.1900 | 0.2200 | 90.3500 | 43934.00 | 43934.00 | 0.00 | 1997 | 9 | 4603 | 55544 | 0.0828712372173412 | 0.0606784622614487 | 0.0606784622614487 | false | false | false | true | ||||||||||||||||
| 226837cf-92d1-46e1-a425-6ba322b1645a | 2026-09-23 12:51 | 2026-09-23 12:51 | 2026-09-23 12:51 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.2200 | 0.2000 | 0.2200 | 90.2100 | 44000.00 | 44000.00 | 0.00 | 2000 | 12 | 6606 | 55544 | 0.118932738009506 | 0.0627671114537905 | 0.0627671114537905 | false | false | false | true | ||||||||||||||||
| 7a792c19-7aa3-4407-a07c-592195130dad | 2026-09-23 14:32 | 2026-09-23 14:32 | 2026-09-23 14:32 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.2100 | 0.2000 | 0.2100 | 90.0850 | 52500.00 | 52500.00 | 0.00 | 2500 | 31 | 9135 | 55544 | 0.16446420855538 | 0.0636390859586663 | 0.0636390859586663 | false | false | false | true | ||||||||||||||||
| 18ee8964-e4f4-4365-a224-8d6dbd3147a3 | 2026-09-24 11:15 | 2026-09-24 11:15 | 2026-09-24 11:15 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.2100 | 0.2000 | 0.2100 | 89.9050 | 42000.00 | 42000.00 | 0.00 | 2000 | 38 | 2010 | 64617 | 0.0311063651980129 | 0.0667113767763075 | 0.0667113767763075 | false | false | false | true | ||||||||||||||||
| a0685441-ed84-462c-b1ab-a8c4d53c8b6c | 2026-09-28 10:27 | 2026-09-28 10:26 | 2026-09-28 10:26 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.1800 | 0.1500 | 0.1800 | 89.0000 | 45000.00 | 45000.00 | 0.00 | 2500 | 38 | 2500 | 66743 | 0.0374571116072097 | 0.0710530249141414 | 0.0710530249141414 | false | false | false | true | ||||||||||||||||
| 0f726b5c-7205-4b15-9d47-fb0e656b3e50 | 2026-09-30 13:18 | 2026-09-30 13:18 | 2026-09-30 13:18 | IEF | IEF261218C00094000 | call | 94.0000 | 2026-12-18 | 0.1400 | 0.1200 | 0.1400 | 89.1650 | 42000.00 | 42000.00 | 0.00 | 3000 | 8 | 3000 | 69243 | 0.0433256791300204 | 0.0722179876854138 | 0.0722179876854138 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41741256328.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:13:56.145626Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41741256328.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:13:56.145626Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41571493870.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:03:39.512328Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41571493870.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:42:34.192825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41571493870.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:09:00.187388Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41571493870.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41571493870.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42079995839.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42221335971.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:57:01.829367Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42221335971.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:35:15.101362Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42221335971.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:52:42.063868Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42221335971.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:35:00.755474Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41437222647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:16:59.605616Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41570344536.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:31:22.759072Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41283378193.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:19:45.943817Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |