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.
Simplify Analyticsuw_flow_alerts375,978 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 |
|---|
| ea27c4d6-3d98-4865-8267-ac996f3514f2 | 2026-09-23 09:44 | 2026-09-23 09:44 | 2026-09-23 09:44 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 1.5700 | 1.5500 | 1.6000 | 58.0000 | 353565.00 | 55422.00 | 298143.00 | 2252 | 8 | 2445 | 14186 | 0.172353024108276 | 0.433135282092931 | 0.434268659472772 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 38529495748.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T13:45:53.710169Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 86821840-4746-4452-9752-0ba0cd85d815 | 2026-09-23 09:44 | 2026-09-23 09:44 | 2026-09-23 09:44 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 1.5700 | 1.5700 | 1.6000 | 58.0000 | 117436.00 | 0.00 | 117436.00 | 748 | 5 | 3193 | 14186 | 0.22508106583956 | 0.433135282092931 | 0.433135282092931 | false | false | false | true | false | |||||||||||||||
| facb3db0-41be-4fdb-9e91-774316b7b07e | 2026-09-21 16:14 | 2026-09-21 16:14 | 2026-09-21 16:14 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 1.9100 | 1.8700 | 1.9200 | 59.0000 | 14325.00 | 14325.00 | 0.00 | 75 | 8 | 1599 | 12701 | 0.12589559877175 | 0.432226208671784 | 0.432226208671784 | false | false | false | true | false | |||||||||||||||
| f2ae2a6b-8851-414d-99cc-d029e00d7478 | 2026-09-21 11:08 | 2026-09-21 11:08 | 2026-09-21 11:08 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 1.9600 | 1.9400 | 1.9800 | 59.6895 | 196000.00 | 174440.00 | 16660.00 | 1000 | 8 | 1387 | 12701 | 0.109203999685064 | 0.435106784211692 | 0.435106784211692 | false | false | false | true | false | |||||||||||||||
| 2c3210bf-bbad-4e8c-8b8f-0fd7d58ecf95 | 2026-09-17 13:00 | 2026-09-17 13:00 | 2026-09-17 13:00 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 2.2000 | 2.1800 | 2.2000 | 59.3600 | 66000.00 | 66000.00 | 0.00 | 300 | 6 | 4160 | 10323 | 0.40298362879008 | 0.45747163495229 | 0.45747163495229 | true | false | false | true | false | |||||||||||||||
| c5abe4a5-9fd1-470a-af56-88fa12d04a9a | 2026-09-17 11:06 | 2026-09-17 11:05 | 2026-09-17 11:05 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 2.2600 | 2.2300 | 2.2800 | 59.2750 | 169048.00 | 135600.00 | 33448.00 | 748 | 6 | 962 | 10323 | 0.0931899641577061 | 0.465774096430717 | 0.465774096430717 | true | false | false | true | false | |||||||||||||||
| a066cde6-864f-4740-9c80-2f7a2e8febea | 2026-09-15 14:14 | 2026-09-15 14:14 | 2026-09-15 14:14 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 2.0400 | 2.0000 | 2.0600 | 57.4900 | 10200.00 | 8568.00 | 1632.00 | 50 | 9 | 678 | 9711 | 0.0698177324683349 | 0.48851211996245 | 0.48851211996245 | false | false | false | true | false | |||||||||||||||
| 1d551cb9-3483-421e-82dd-5ef0fb85a82c | 2026-09-15 11:35 | 2026-09-15 11:35 | 2026-09-15 11:35 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 1.9600 | 1.9600 | 1.9700 | 57.0800 | 11760.00 | 0.00 | 11760.00 | 60 | 10 | 198 | 9711 | 0.020389249304912 | 0.491391592105584 | 0.491391592105584 | false | false | false | true | false | |||||||||||||||
| 2df34cff-d235-423a-aeef-9e6c11ee977c | 2026-09-14 09:41 | 2026-09-14 09:41 | 2026-09-14 09:41 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 1.9200 | 1.9200 | 1.9600 | 56.0000 | 19200.00 | 0.00 | 13440.00 | 100 | 6 | 124 | 10035 | 0.0123567513702043 | 0.492657167787408 | 0.492657167787408 | false | false | false | true | false | |||||||||||||||
| c6309e34-ed00-4a7c-b255-8f2dab7ce385 | 2026-09-09 11:26 | 2026-09-09 11:25 | 2026-09-09 11:25 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 3.1000 | 3.1000 | 3.2000 | 60.4750 | 62000.00 | 0.00 | 62000.00 | 200 | 5 | 687 | 11264 | 0.0609907670454545 | 0.487306963770427 | 0.487306963770427 | false | false | false | true | false | |||||||||||||||
| 2a8a0883-01b8-4c3c-86b0-a36f4593a49d | 2026-09-08 10:29 | 2026-09-08 10:29 | 2026-09-08 10:29 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 2.8800 | 2.8800 | 2.9100 | 59.6650 | 71712.00 | 0.00 | 71712.00 | 249 | 40 | 361 | 11127 | 0.0324436056439292 | 0.48927535901459 | 0.48927535901459 | false | false | false | true | false | |||||||||||||||
| 3aa098c6-282c-4c72-9319-74ea4c394b6d | 2026-09-04 09:52 | 2026-09-04 09:52 | 2026-09-04 09:52 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 3.0000 | 2.9600 | 3.0000 | 59.5600 | 11400.00 | 11400.00 | 0.00 | 38 | 5 | 86 | 10990 | 0.00782529572338489 | 0.4926370425509 | 0.4926370425509 | false | false | false | true | false | |||||||||||||||
| adbf9029-c8d2-4ab5-8649-ec8dde3d9ce8 | 2026-09-03 10:16 | 2026-09-03 10:16 | 2026-09-03 10:16 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 3.1000 | 3.0500 | 3.1500 | 59.9550 | 49600.00 | 43400.00 | 0.00 | 160 | 6 | 224 | 9476 | 0.0236386661038413 | 0.487254630064145 | 0.487254630064145 | false | false | false | true | false | |||||||||||||||
| bb0f15f6-704d-4ea0-b49d-f0ab389f5a47 | 2026-08-28 11:54 | 2026-08-28 11:53 | 2026-08-28 11:53 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 4.0500 | 4.0000 | 4.1000 | 62.0000 | 202250.00 | 136640.00 | 48600.00 | 500 | 6 | 1467 | 7505 | 0.195469686875416 | 0.487277793734464 | 0.486522360407705 | false | false | false | true | false | |||||||||||||||
| 4d0c3111-0e35-4998-a195-fc6597599f22 | 2026-08-25 14:56 | 2026-08-25 14:56 | 2026-08-25 14:56 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 4.3000 | 4.2000 | 4.3000 | 62.2200 | 289820.00 | 289820.00 | 0.00 | 674 | 6 | 1239 | 5535 | 0.223848238482385 | 0.49440554145302 | 0.49440554145302 | false | false | false | true | false | |||||||||||||||
| 5214a1b1-a705-411c-a31b-daa751154a0c | 2026-08-25 09:30 | 2026-08-25 09:30 | 2026-08-25 09:30 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 3.7500 | 3.7500 | 3.8500 | 61.1001 | 12750.00 | 0.00 | 12750.00 | 34 | 5 | 162 | 5535 | 0.0292682926829268 | 0.485888688920565 | 0.485888688920565 | false | false | false | true | false | |||||||||||||||
| d6ab53cc-a94c-404a-b3d9-915ba899294b | 2026-08-21 15:46 | 2026-08-21 15:46 | 2026-08-21 15:46 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 4.4000 | 4.4000 | 4.5000 | 62.6570 | 15840.00 | 0.00 | 15840.00 | 36 | 20 | 1005 | 6135 | 0.163814180929095 | 0.47980230589841 | 0.47980230589841 | false | false | false | true | false | |||||||||||||||
| 8636f669-8bd3-4ffc-bcb4-f52caa010492 | 2026-08-20 13:36 | 2026-08-20 13:36 | 2026-08-20 13:36 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 3.9900 | 3.9500 | 4.0000 | 61.6150 | 99815.00 | 99815.00 | 0.00 | 250 | 8 | 960 | 5370 | 0.17877094972067 | 0.478927284194788 | 0.478189139126954 | true | false | false | true | false | |||||||||||||||
| 18de9fa4-66dc-4102-b2f7-05da3c7280ce | 2026-08-20 13:00 | 2026-08-20 12:59 | 2026-08-20 12:59 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 4.0000 | 3.9500 | 4.0000 | 61.6300 | 38400.00 | 38400.00 | 0.00 | 96 | 7 | 636 | 5370 | 0.118435754189944 | 0.478496173149632 | 0.478496173149632 | false | false | false | true | false | |||||||||||||||
| d3cfada6-3973-4f42-ab11-c70fdb478306 | 2026-08-17 14:39 | 2026-08-17 14:39 | 2026-08-17 14:39 | SLV | SLV261218C00070000 | call | 70.0000 | 2026-12-18 | 3.1500 | 3.1000 | 3.2000 | 59.4500 | 15750.00 | 6930.00 | 8820.00 | 50 | 6 | 404 | 3878 | 0.104177411036617 | 0.467424673101129 | 0.467558695637345 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:45:53.710169Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:54:17.138635Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:47:12.085652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:56:18.493427Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:21:53.483381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:32:26.163070Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |