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_alerts425,429 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 |
|---|
| 4fde1180-d3fc-4867-ab1c-84b856450e95 | 2026-09-21 12:11 | 2026-09-21 12:11 | 2026-09-21 12:11 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 40.3500 | 40.1500 | 40.3500 | 724.3900 | 173505.00 | 173505.00 | 0.00 | 43 | 19 | 91 | 15 | 6.06666666666667 | 0.433900096340241 | 0.433900096340241 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:13:06.153982Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 42916b51-b7ec-4902-b155-d2e918c28c4e | 2026-09-21 12:16 | 2026-09-21 12:15 | 2026-09-21 12:16 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 39.6000 | 39.0500 | 39.6000 | 726.1600 | 142560.00 | 142560.00 | 0.00 | 36 | 14 | 147 | 15 | 9.8 | 0.436585642414679 | 0.436585642414679 | true | false | false | true | ||||||||||||||||
| 81df1bdb-cb97-4669-9368-3fc11bf75748 | 2026-09-21 14:13 | 2026-09-21 14:13 | 2026-09-21 14:13 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 32.6000 | 32.5000 | 32.8000 | 743.2250 | 22820.00 | 3260.00 | 19560.00 | 7 | 6 | 437 | 15 | 29.1333333333333 | 0.454910778942598 | 0.454910778942598 | false | false | false | |||||||||||||||||
| e325cadb-0982-451a-9b2b-b36630e70f56 | 2026-09-21 15:14 | 2026-09-21 15:14 | 2026-09-21 15:14 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 31.8000 | 31.5500 | 31.8000 | 744.6900 | 79500.00 | 79500.00 | 0.00 | 25 | 8 | 790 | 15 | 52.6666666666667 | 0.45307252440467 | 0.45307252440467 | true | false | false | true | ||||||||||||||||
| f9bef223-125e-4223-8f0e-dfdf2dba7a70 | 2026-09-21 15:39 | 2026-09-21 15:39 | 2026-09-21 15:39 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 30.1000 | 29.9000 | 30.1000 | 749.2307 | 114380.00 | 114380.00 | 0.00 | 38 | 14 | 1010 | 15 | 67.3333333333333 | 0.458093870793169 | 0.456710828369009 | true | false | false | |||||||||||||||||
| 6a8304db-8a22-471d-9534-e70fc27cf143 | 2026-09-22 13:57 | 2026-09-22 13:57 | 2026-09-22 13:57 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 30.4000 | 30.1000 | 30.7000 | 742.6300 | 30400.00 | 27360.00 | 3040.00 | 10 | 10 | 707 | 484 | 1.46074380165289 | 0.431008694404892 | 0.431008694404892 | false | false | false | |||||||||||||||||
| f72fa57a-db63-4506-a712-817f2ca8dedd | 2026-09-22 14:18 | 2026-09-22 14:18 | 2026-09-22 14:18 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 30.4000 | 29.9500 | 30.7500 | 743.2050 | 33440.00 | 6080.00 | 27360.00 | 11 | 7 | 1017 | 484 | 2.10123966942149 | 0.434469648010278 | 0.434469648010278 | false | false | false | |||||||||||||||||
| b37596c4-e5e0-41b4-a911-1e41b1181ccf | 2026-09-23 09:56 | 2026-09-23 09:56 | 2026-09-23 09:56 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 23.7000 | 23.4500 | 23.7000 | 761.9400 | 26070.00 | 26070.00 | 0.00 | 11 | 11 | 351 | 1256 | 0.279458598726115 | 0.45679287420571 | 0.45679287420571 | false | false | false | |||||||||||||||||
| fc501254-2784-4eda-bebb-5b38d41d33ed | 2026-09-23 12:53 | 2026-09-23 12:53 | 2026-09-23 12:53 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 26.6000 | 26.4500 | 26.6000 | 755.5743 | 61180.00 | 61180.00 | 0.00 | 23 | 11 | 692 | 1256 | 0.550955414012739 | 0.463098857280089 | 0.463098857280089 | true | false | false | |||||||||||||||||
| 23a0dc51-ebe5-40df-994a-ed1edaa4bec6 | 2026-09-23 14:37 | 2026-09-23 14:37 | 2026-09-23 14:37 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 29.3000 | 29.1500 | 29.3000 | 748.1650 | 17580.00 | 17580.00 | 0.00 | 6 | 5 | 1658 | 1256 | 1.32006369426752 | 0.458086700755896 | 0.458086700755896 | false | false | false | |||||||||||||||||
| a8506871-462d-4f70-b527-30bc4fb6288e | 2026-09-23 15:33 | 2026-09-23 15:33 | 2026-09-23 15:33 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 28.0000 | 27.9500 | 28.1000 | 750.1924 | 36405.00 | 5605.00 | 28000.00 | 13 | 8 | 1934 | 1256 | 1.53980891719745 | 0.452164336375553 | 0.452164336375553 | false | false | false | |||||||||||||||||
| 2f4f10cf-70ae-45a1-8c02-56105d7a6310 | 2026-09-23 15:54 | 2026-09-23 15:54 | 2026-09-23 15:54 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 30.0000 | 29.8500 | 30.0500 | 745.6300 | 780000.00 | 30000.00 | 750000.00 | 260 | 8 | 2387 | 1256 | 1.90047770700637 | 0.452585627341747 | 0.452585627341747 | true | false | false | |||||||||||||||||
| ed4887ee-200f-4c74-ad74-b7ad13d31ba8 | 2026-09-23 15:58 | 2026-09-23 15:57 | 2026-09-23 15:57 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 30.3900 | 30.1500 | 30.4000 | 744.0000 | 21275.00 | 18240.00 | 3035.00 | 7 | 7 | 2412 | 1256 | 1.9203821656051 | 0.452859805553914 | 0.452183254097259 | false | false | false | |||||||||||||||||
| 9924a37f-199f-4611-97bf-1129c8343789 | 2026-09-23 15:58 | 2026-09-23 15:57 | 2026-09-23 15:57 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 30.4000 | 30.2000 | 30.6500 | 744.0000 | 72955.00 | 66880.00 | 6075.00 | 24 | 12 | 2436 | 1256 | 1.93949044585987 | 0.452859805553914 | 0.452859805553914 | true | false | false | |||||||||||||||||
| 26fa364f-d6a5-4200-9d20-791fc9cff133 | 2026-09-24 09:33 | 2026-09-24 09:32 | 2026-09-24 09:32 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 26.1000 | 25.4000 | 26.5500 | 753.1100 | 44370.00 | 41760.00 | 2610.00 | 17 | 12 | 575 | 1815 | 0.316804407713499 | 0.452246687398886 | 0.452246687398886 | true | false | false | |||||||||||||||||
| a52cce41-5672-4687-b239-731d743e7bcd | 2026-09-24 09:45 | 2026-09-24 09:45 | 2026-09-24 09:45 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 25.6000 | 24.7000 | 25.6000 | 755.1240 | 640000.00 | 640000.00 | 0.00 | 250 | 9 | 959 | 1815 | 0.528374655647383 | 0.456584386258506 | 0.456584386258506 | false | false | false | |||||||||||||||||
| 8f733469-803a-4606-9ceb-6e975fbca543 | 2026-09-24 09:47 | 2026-09-24 09:47 | 2026-09-24 09:47 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 25.0000 | 24.3000 | 25.0000 | 756.3600 | 625000.00 | 625000.00 | 0.00 | 250 | 5 | 1210 | 1815 | 0.666666666666667 | 0.455025101173127 | 0.455025101173127 | false | false | false | |||||||||||||||||
| 20e2e97c-8fe5-40b2-9e2c-6a997139d62b | 2026-09-24 14:11 | 2026-09-24 14:11 | 2026-09-24 14:11 | META | META261016P00740000 | put | 740.0000 | 2026-10-16 | 17.9000 | 17.9000 | 18.3500 | 772.7818 | 17900.00 | 0.00 | 17900.00 | 10 | 5 | 2072 | 1815 | 1.14159779614325 | 0.436511576529418 | 0.436511576529418 | true | false | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:17:17.704519Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:15:35.599753Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:43:03.886437Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:57:38.128984Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:23:27.944500Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:56:20.780869Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:40:32.778143Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:37:14.904379Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:54:40.302966Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:34:09.637313Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:47:07.799094Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:48:47.718536Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:15:40.223371Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |