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_alerts326,449 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 |
|---|
| 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 |
|---|
| e9fb388f-a6e6-44b5-96dd-02665630e14a | 2026-09-22 13:17 | 2026-09-22 13:17 | 2026-09-22 13:17 | EQIX | EQIX261016P00990000 | put | 990.0000 | 2026-10-16 | 8.6000 | 8.5000 | 9.7000 | 1051.8850 | 30960.00 | 860.00 | 30100.00 | 36 | 13 | 38 | 14 | 2.71428571428571 | 0.293771464348654 | 0.293771464348654 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Real Estate | 104518970112.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T17:23:35.118331Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| ba7422c7-011c-42f2-9b53-f5de9835add5 | 2026-09-22 13:17 | 2026-09-22 13:17 | 2026-09-22 13:17 | EQIX | EQIX261016P00980000 | put | 980.0000 | 2026-10-16 | 6.9000 | 6.9000 | 8.9000 | 1051.8850 | 26220.00 | 0.00 | 26220.00 | 38 | 14 | 39 | 21 | 1.85714285714286 | 0.297176672735797 | 0.297176672735797 | false | false | false | true | ||||||||||||||||
| 3934898b-eba9-4e19-8d46-10cf95d9b2b4 | 2026-09-21 12:37 | 2026-09-21 12:37 | 2026-09-21 12:37 | EQIX | EQIX261218C01160000 | call | 1160.0000 | 2026-12-18 | 25.7500 | 23.0000 | 29.1000 | 1053.1600 | 121030.00 | 0.00 | 121030.00 | 47 | 2 | 47 | 24 | 1.95833333333333 | 0.288784237187004 | 0.288784237187004 | false | true | false | true | ||||||||||||||||
| f335bd32-5594-4e70-9321-038c493bb9bf | 2026-09-17 15:40 | 2026-09-17 15:39 | 2026-09-17 15:39 | EQIX | EQIX261016C01060000 | call | 1060.0000 | 2026-10-16 | 19.6000 | 19.6000 | 21.2000 | 1026.0600 | 98000.00 | 0.00 | 98000.00 | 50 | 21 | 53 | 8 | 6.625 | 0.278886153807402 | 0.278886153807402 | false | false | false | true | ||||||||||||||||
| 5cfe8113-f608-4716-8c41-43d717ea48ff | 2026-09-17 13:43 | 2026-09-17 13:43 | 2026-09-17 13:43 | EQIX | EQIX270917P01000000 | put | 1000.0000 | 2027-09-17 | 101.8000 | 99.0000 | 103.4000 | 1025.6800 | 71260.00 | 71260.00 | 0.00 | 7 | 7 | 26 | 1 | 26 | 0.339557616141854 | 0.339557616141854 | false | false | false | true | ||||||||||||||||
| c99bf57e-fb17-45dc-a7f5-28fb29e944c4 | 2026-09-14 12:14 | 2026-09-14 12:14 | 2026-09-14 12:14 | EQIX | EQIX270917C01090000 | call | 1090.0000 | 2027-09-17 | 105.8000 | 105.8000 | 107.8000 | 1010.9300 | 116380.00 | 0.00 | 116380.00 | 11 | 5 | 41 | 1 | 41 | 0.303571789628625 | 0.303571789628625 | false | false | false | true | ||||||||||||||||
| 5d064633-7ab9-4ca3-8139-166ebb78e9c1 | 2026-09-14 09:32 | 2026-09-14 09:32 | 2026-09-14 09:32 | EQIX | EQIX261016P01140000 | put | 1140.0000 | 2026-10-16 | 122.4000 | 112.4000 | 126.1000 | 1020.7200 | 61200.00 | 61200.00 | 0.00 | 5 | 5 | 5 | 0 | 0 | 0.323952972636632 | 0.323952972636632 | false | false | false | true | ||||||||||||||||
| 2d637b0c-501c-4c06-b7ca-0c7d621fb71d | 2026-09-09 13:20 | 2026-09-09 13:20 | 2026-09-09 13:20 | EQIX | EQIX260918P01050000 | put | 1050.0000 | 2026-09-18 | 24.7000 | 22.7000 | 24.7000 | 1040.1500 | 98800.00 | 98800.00 | 0.00 | 40 | 20 | 40 | 176 | 0.227272727272727 | 0.304985196342552 | 0.304985196342552 | false | false | false | true | ||||||||||||||||
| be65f0cd-838c-4c0c-b7f5-19b64ca6072a | 2026-09-08 11:01 | 2026-09-08 11:01 | 2026-09-08 11:01 | EQIX | EQIX261016P01120000 | put | 1120.0000 | 2026-10-16 | 86.2000 | 81.0000 | 86.2000 | 1044.4650 | 422380.00 | 422380.00 | 0.00 | 49 | 18 | 49 | 0 | 0 | 0.29779172232222 | 0.29779172232222 | false | false | false | true | ||||||||||||||||
| f4f53fae-17bf-4332-8ae0-5f79749bb73f | 2026-09-02 13:56 | 2026-09-02 13:56 | 2026-09-02 13:56 | EQIX | EQIX270917P01080000 | put | 1080.0000 | 2027-09-17 | 151.4400 | 149.5000 | 151.7000 | 1011.1650 | 75720.00 | 75720.00 | 0.00 | 5 | 5 | 72 | 0 | 0 | 0.341244548462038 | 0.338065155878797 | false | false | false | true | ||||||||||||||||
| 069309d0-cdf0-44aa-af49-c9b18c3fb15b | 2026-09-02 13:56 | 2026-09-02 13:56 | 2026-09-02 13:56 | EQIX | EQIX270917C01080000 | call | 1080.0000 | 2027-09-17 | 109.5000 | 105.2000 | 109.5000 | 1011.1650 | 54750.00 | 54750.00 | 0.00 | 5 | 5 | 73 | 0 | 0 | 0.288477027212769 | 0.288477027212769 | false | false | false | true | ||||||||||||||||
| 2b50f043-62b8-46f5-b82f-010a55c1984c | 2026-09-02 13:56 | 2026-09-02 13:56 | 2026-09-02 13:56 | EQIX | EQIX270917C01080000 | call | 1080.0000 | 2027-09-17 | 109.5400 | 105.1000 | 110.0000 | 1011.1650 | 76680.00 | 76680.00 | 0.00 | 7 | 7 | 23 | 0 | 0 | 0.28969560479558 | 0.285796462903006 | false | false | false | true | ||||||||||||||||
| 664d5c11-ce9a-4624-b226-c066a07e2ef9 | 2026-08-31 14:20 | 2026-08-31 14:20 | 2026-08-31 14:20 | EQIX | EQIX261120C01170000 | call | 1170.0000 | 2026-11-20 | 23.1000 | 21.2000 | 23.1000 | 1035.0000 | 127050.00 | 127050.00 | 0.00 | 55 | 11 | 59 | 34 | 1.73529411764706 | 0.319854835667542 | 0.319854835667542 | false | false | false | true | ||||||||||||||||
| f389b34e-255d-4e17-a8ec-cd3ca706952a | 2026-08-31 10:18 | 2026-08-31 10:18 | 2026-08-31 10:18 | EQIX | EQIX261120C01060000 | call | 1060.0000 | 2026-11-20 | 58.1000 | 54.4000 | 58.8000 | 1034.8400 | 557760.00 | 546140.00 | 11620.00 | 96 | 33 | 96 | 3 | 32 | 0.336104797786704 | 0.336104797786704 | false | false | false | true | ||||||||||||||||
| 2c1d6699-fdb0-4780-a116-d56737689ef6 | 2026-08-26 11:45 | 2026-08-26 11:45 | 2026-08-26 11:45 | EQIX | EQIX261120C01170000 | call | 1170.0000 | 2026-11-20 | 35.6000 | 33.7000 | 35.6000 | 1078.2675 | 121040.00 | 121040.00 | 0.00 | 34 | 13 | 34 | 0 | 0 | 0.317445065292623 | 0.317445065292623 | false | false | false | true | ||||||||||||||||
| 96047ed7-8310-4bd4-8156-03948770cc99 | 2026-08-25 15:19 | 2026-08-25 15:19 | 2026-08-25 15:19 | EQIX | EQIX261218C01140000 | call | 1140.0000 | 2026-12-18 | 54.7000 | 52.8000 | 54.9000 | 1076.3800 | 443070.00 | 443070.00 | 0.00 | 81 | 20 | 181 | 25 | 7.24 | 0.312746165066492 | 0.312746165066492 | false | false | false | true | ||||||||||||||||
| 8fd57546-8a18-4845-b87c-894a556f6768 | 2026-08-25 12:28 | 2026-08-25 12:28 | 2026-08-25 12:28 | EQIX | EQIX261120C01140000 | call | 1140.0000 | 2026-11-20 | 47.7000 | 45.6000 | 48.9000 | 1082.5700 | 176490.00 | 176490.00 | 0.00 | 37 | 12 | 37 | 0 | 0 | 0.318994734569317 | 0.318994734569317 | false | false | false | true | ||||||||||||||||
| b110e2db-61c6-4a7a-84f2-4f786cb7b566 | 2026-08-25 10:45 | 2026-08-25 10:45 | 2026-08-25 10:45 | EQIX | EQIX260918C01150000 | call | 1150.0000 | 2026-09-18 | 8.9000 | 7.5000 | 9.0000 | 1079.9300 | 57850.00 | 56960.00 | 890.00 | 65 | 23 | 66 | 313 | 0.210862619808307 | 0.279625254265359 | 0.279625254265359 | false | false | false | true | ||||||||||||||||
| db9d5381-1587-48de-b85a-9b8bfee35de9 | 2026-08-25 10:37 | 2026-08-25 10:37 | 2026-08-25 10:37 | EQIX | EQIX261218C01140000 | call | 1140.0000 | 2026-12-18 | 54.8000 | 50.5000 | 54.8000 | 1076.1400 | 443880.00 | 443880.00 | 0.00 | 81 | 29 | 81 | 25 | 3.24 | 0.315869706923504 | 0.313604219956311 | false | false | false | true | ||||||||||||||||
| 9d9c8300-7e3d-4326-8fba-428bc27e2459 | 2026-08-21 11:27 | 2026-08-21 11:26 | 2026-08-21 11:26 | EQIX | EQIX261016C01120000 | call | 1120.0000 | 2026-10-16 | 26.1000 | 23.5000 | 26.1000 | 1061.1700 | 180090.00 | 180090.00 | 0.00 | 69 | 25 | 76 | 1 | 76 | 0.281385662740497 | 0.281385662740497 | false | false | false | true | ||||||||||||||||
| 351efda0-8207-4c90-8373-51ab62e089d2 | 2026-08-17 14:09 | 2026-08-17 14:09 | 2026-08-17 14:09 | EQIX | EQIX260918C01080000 | call | 1080.0000 | 2026-09-18 | 46.0000 | 46.0000 | 48.6000 | 1095.0000 | 142600.00 | 0.00 | 142600.00 | 31 | 19 | 32 | 32 | 1 | 0.241804860229276 | 0.241804860229276 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 104518970112.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:23:35.118331Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 104321626740.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 101231229535.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 101231229535.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:50:47.676652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:05:44.095975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:05:44.095975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:05:44.095975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T18:25:38.432903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:29:52.792110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 98545386242.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |