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_alerts523,327 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 |
|---|
| ce9f6c5a-3812-4cdc-93ea-66741ccd8771 | 2026-08-27 10:14 | 2026-08-27 10:14 | 2026-08-27 10:14 | IGV | IGV260904C00109000 | call | 109.0000 | 2026-09-04 | 2.2000 | 2.1500 | 2.3100 | 109.0350 | 103183.00 | 883.00 | 102300.00 | 469 | 41 | 479 | 110 | 4.35454545454545 | 0.331994103489323 | 0.331994103489323 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 14038397136.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d0326c33-6180-4fe1-af17-92d3cb2ad19f | 2026-08-27 10:08 | 2026-08-27 10:08 | 2026-08-27 10:08 | IGV | IGV260918C00110000 | call | 110.0000 | 2026-09-18 | 2.7500 | 2.7400 | 3.0000 | 108.7850 | 76720.00 | 0.00 | 67095.00 | 279 | 10 | 1042 | 5990 | 0.173956594323873 | 0.298950323046473 | 0.299892122564647 | false | false | false | true | ||||||||||||||||
| cb13fda6-33ea-4e13-ac55-d5b324f2959c | 2026-08-27 09:54 | 2026-08-27 09:54 | 2026-08-27 09:54 | IGV | IGV260904C00114000 | call | 114.0000 | 2026-09-04 | 0.4000 | 0.1700 | 0.4700 | 108.4300 | 15762.00 | 15722.00 | 40.00 | 394 | 7 | 394 | 55 | 7.16363636363636 | 0.318336545413243 | 0.320960347537737 | false | false | false | true | ||||||||||||||||
| 729fe230-09a9-470c-8bdc-f290d2ef5555 | 2026-08-25 14:20 | 2026-08-25 14:20 | 2026-08-25 14:20 | IGV | IGV260925P00100000 | put | 100.0000 | 2026-09-25 | 2.7700 | 2.5800 | 2.7800 | 101.0000 | 33287.00 | 33287.00 | 0.00 | 120 | 5 | 122 | 7 | 17.4285714285714 | 0.308810778910363 | 0.309684303962999 | false | false | false | true | ||||||||||||||||
| 6ff0a3bb-256c-459c-a317-bb89e1499f78 | 2026-08-25 13:40 | 2026-08-25 13:40 | 2026-08-25 13:40 | IGV | IGV260918C00100000 | call | 100.0000 | 2026-09-18 | 4.2000 | 4.1500 | 4.3000 | 101.6550 | 383886.00 | 21000.00 | 362886.00 | 914 | 37 | 5885 | 24008 | 0.245126624458514 | 0.306552291753058 | 0.306552291753058 | false | false | false | true | ||||||||||||||||
| dad17040-87e1-47d8-b435-107a1e26fd96 | 2026-08-25 12:54 | 2026-08-25 12:54 | 2026-08-25 12:54 | IGV | IGV261016C00112000 | call | 112.0000 | 2026-10-16 | 1.5500 | 1.5500 | 1.6500 | 102.0250 | 39062.00 | 0.00 | 39062.00 | 252 | 28 | 264 | 221 | 1.19457013574661 | 0.30318414194823 | 0.30318414194823 | true | false | false | true | ||||||||||||||||
| 3a3ec2e6-f7d7-422f-ab83-3fac7f74f0bb | 2026-08-25 10:36 | 2026-08-25 10:35 | 2026-08-25 10:35 | IGV | IGV260918C00108000 | call | 108.0000 | 2026-09-18 | 1.2500 | 1.1600 | 1.4900 | 102.2400 | 31502.00 | 7875.00 | 23627.00 | 252 | 5 | 252 | 72 | 3.5 | 0.306723353916079 | 0.306723353916079 | false | false | false | true | ||||||||||||||||
| c0c692c6-97d7-4d98-9158-e955bda76db2 | 2026-08-24 09:30 | 2026-08-24 09:30 | 2026-08-24 09:30 | IGV | IGV261218P00090000 | put | 90.0000 | 2026-12-18 | 2.5000 | 2.3900 | 2.6500 | 102.8950 | 65958.00 | 0.00 | 65958.00 | 264 | 11 | 264 | 52533 | 0.00502541259779567 | 0.342891340462313 | 0.343513012300161 | true | false | false | true | ||||||||||||||||
| a286d791-f198-46a9-a5a1-25d53d29c914 | 2026-08-19 15:13 | 2026-08-19 15:13 | 2026-08-19 15:13 | IGV | IGV260918P00097000 | put | 97.0000 | 2026-09-18 | 1.3700 | 1.3600 | 1.4700 | 102.9100 | 205634.00 | 0.00 | 205634.00 | 1500 | 7 | 10841 | 20029 | 0.54126516551001 | 0.321658732352667 | 0.323859173811759 | false | false | false | true | ||||||||||||||||
| f8578dc9-ce81-4b79-ae9d-31dc77611ebf | 2026-08-19 14:42 | 2026-08-19 14:42 | 2026-08-19 14:42 | IGV | IGV260918P00097000 | put | 97.0000 | 2026-09-18 | 1.3800 | 1.3600 | 1.4200 | 102.9200 | 137628.00 | 0.00 | 137628.00 | 1000 | 19 | 9340 | 20029 | 0.466323830445854 | 0.321918077050723 | 0.321918077050723 | false | false | false | true | ||||||||||||||||
| 222e85c7-59c1-4f7a-bd75-6eb5a33d0ae7 | 2026-08-17 15:35 | 2026-08-17 15:35 | 2026-08-17 15:35 | IGV | IGV260918P00097000 | put | 97.0000 | 2026-09-18 | 1.6500 | 1.6300 | 1.6500 | 102.0800 | 41238.00 | 39270.00 | 0.00 | 250 | 13 | 14251 | 255 | 55.8862745098039 | 0.318504798213777 | 0.319511740445314 | false | false | false | true | ||||||||||||||||
| 6cc2ac4b-961b-48f6-b293-5fdd6308a4b3 | 2026-08-17 12:12 | 2026-08-17 12:12 | 2026-08-17 12:12 | IGV | IGV260918P00097000 | put | 97.0000 | 2026-09-18 | 1.6200 | 1.5500 | 1.6300 | 102.3700 | 80867.00 | 56063.00 | 0.00 | 500 | 8 | 5064 | 255 | 19.8588235294118 | 0.32114524044827 | 0.325220210602775 | false | false | false | true | ||||||||||||||||
| 2f6ca836-69e9-419b-ab28-e664da86ec15 | 2026-08-17 10:49 | 2026-08-17 10:49 | 2026-08-17 10:49 | IGV | IGV260918C00110000 | call | 110.0000 | 2026-09-18 | 1.2500 | 1.1500 | 1.4400 | 102.4700 | 13753.00 | 753.00 | 13000.00 | 110 | 20 | 164 | 6052 | 0.0270984798413748 | 0.304083806290573 | 0.305142345899817 | true | false | false | true | ||||||||||||||||
| d0017171-20cb-46f0-a0e9-ae170fddabe6 | 2026-08-17 10:18 | 2026-08-17 10:18 | 2026-08-17 10:18 | IGV | IGV260918P00097000 | put | 97.0000 | 2026-09-18 | 1.5800 | 1.4400 | 1.7700 | 102.6000 | 78923.00 | 59494.00 | 785.00 | 501 | 36 | 505 | 255 | 1.98039215686275 | 0.324087256769893 | 0.325117778401478 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:00:28.149501Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:42:01.576369Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |