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_alerts474,253 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 |
|---|
| 4aebc724-bfbb-48a5-9b9f-0174832ba7e0 | 2026-08-20 09:42 | 2026-08-20 09:42 | 2026-08-20 09:42 | FUTU | FUTU261016C00110000 | call | 110.0000 | 2026-10-16 | 8.3000 | 6.7500 | 8.7000 | 108.6200 | 58930.00 | 49800.00 | 9130.00 | 71 | 61 | 71 | 240 | 0.295833333333333 | 0.504800221097808 | 0.504800221097808 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Financial Services | 10635851529.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 699e31b4-c33c-40be-a44e-e9278b85473e | 2026-08-20 09:40 | 2026-08-20 09:40 | 2026-08-20 09:40 | FUTU | FUTU261016P00100000 | put | 100.0000 | 2026-10-16 | 4.8000 | 3.9000 | 4.8000 | 107.5200 | 67680.00 | 67680.00 | 0.00 | 141 | 24 | 147 | 19 | 7.73684210526316 | 0.505539343500029 | 0.505539343500029 | false | false | false | true | ||||||||||||||||
| a96c7c4a-4358-4693-b206-3b8b1044a158 | 2026-08-19 15:51 | 2026-08-19 15:51 | 2026-08-19 15:51 | FUTU | FUTU260821C00107000 | call | 107.0000 | 2026-08-21 | 5.5000 | 4.0500 | 6.8500 | 109.7950 | 13750.00 | 12100.00 | 1650.00 | 25 | 6 | 25 | 33 | 0.757575757575758 | 1.21345258887429 | 1.22891237360047 | false | false | false | true | ||||||||||||||||
| dc988ce5-d4a7-4e72-ab3c-d82c9137ae8d | 2026-08-19 11:04 | 2026-08-19 11:04 | 2026-08-19 11:04 | FUTU | FUTU261120C00142450 | call | 142.4500 | 2026-11-20 | 3.9500 | 3.5500 | 4.1500 | 111.6850 | 16590.00 | 16195.00 | 395.00 | 42 | 23 | 42 | 166 | 0.253012048192771 | 0.554345489001532 | 0.554345489001532 | false | false | false | true | ||||||||||||||||
| 9f81aad3-3658-4207-8104-a9b59c15e545 | 2026-08-19 10:46 | 2026-08-19 10:46 | 2026-08-19 10:46 | FUTU | FUTU260821C00113000 | call | 113.0000 | 2026-08-21 | 2.5000 | 2.2000 | 2.5000 | 111.1200 | 12249.00 | 12249.00 | 0.00 | 49 | 6 | 87 | 112 | 0.776785714285714 | 1.03407358622699 | 1.01167344767133 | true | false | false | true | ||||||||||||||||
| 92b85a81-fee6-4acc-89a0-7d190b57ed95 | 2026-08-19 10:29 | 2026-08-19 10:29 | 2026-08-19 10:29 | FUTU | FUTU260821C00115000 | call | 115.0000 | 2026-08-21 | 1.5600 | 1.4100 | 1.7000 | 110.6500 | 16235.00 | 14351.00 | 1884.00 | 104 | 8 | 314 | 468 | 0.670940170940171 | 1.02139457264248 | 0.98461215271475 | false | false | false | true | ||||||||||||||||
| d893b378-982a-456f-bfb2-9ed41616d024 | 2026-08-19 10:14 | 2026-08-19 10:14 | 2026-08-19 10:14 | FUTU | FUTU260821C00115000 | call | 115.0000 | 2026-08-21 | 1.3900 | 1.1000 | 1.4300 | 110.1550 | 13761.00 | 4170.00 | 9452.00 | 99 | 6 | 175 | 468 | 0.373931623931624 | 0.977153287365468 | 0.977153287365468 | false | false | false | true | ||||||||||||||||
| 1dd91b89-87d4-4a9c-9a86-56a745a7949c | 2026-08-18 15:04 | 2026-08-18 15:03 | 2026-08-18 15:03 | FUTU | FUTU261016P00090000 | put | 90.0000 | 2026-10-16 | 2.0300 | 1.5500 | 2.0300 | 108.7300 | 67599.00 | 67599.00 | 0.00 | 333 | 30 | 333 | 1306 | 0.254977029096478 | 0.528903402075367 | 0.528903402075367 | false | false | false | true | ||||||||||||||||
| 03cb2fc3-e995-4ee1-9c1a-fba6164a3522 | 2026-08-18 13:46 | 2026-08-18 13:46 | 2026-08-18 13:46 | FUTU | FUTU261016P00095000 | put | 95.0000 | 2026-10-16 | 3.0500 | 2.7700 | 3.0500 | 109.0400 | 70150.00 | 70150.00 | 0.00 | 230 | 21 | 230 | 206 | 1.11650485436893 | 0.517719044509122 | 0.517719044509122 | false | false | false | true | ||||||||||||||||
| f3860b17-18d9-4bb5-900c-fee9331f00f8 | 2026-08-18 12:30 | 2026-08-18 12:29 | 2026-08-18 12:29 | FUTU | FUTU261016C00105000 | call | 105.0000 | 2026-10-16 | 11.2500 | 10.3500 | 11.2500 | 108.6200 | 148500.00 | 148500.00 | 0.00 | 132 | 25 | 132 | 14 | 9.42857142857143 | 0.525378838385143 | 0.525378838385143 | false | false | false | true | ||||||||||||||||
| ff81bb2d-8a1f-49fc-a7a5-749904f08cc4 | 2026-08-18 10:22 | 2026-08-18 10:22 | 2026-08-18 10:22 | FUTU | FUTU261016C00110000 | call | 110.0000 | 2026-10-16 | 8.6500 | 7.9000 | 8.6500 | 108.2300 | 58820.00 | 58820.00 | 0.00 | 68 | 20 | 68 | 213 | 0.31924882629108 | 0.527500787693252 | 0.527500787693252 | false | false | false | true | ||||||||||||||||
| 7fb14dab-e14f-422d-b82d-95c1b8bc3863 | 2026-08-18 10:00 | 2026-08-18 10:00 | 2026-08-18 10:00 | FUTU | FUTU270219P00110000 | put | 110.0000 | 2027-02-19 | 15.7000 | 15.7000 | 16.3000 | 108.9200 | 81640.00 | 0.00 | 81640.00 | 52 | 6 | 52 | 8 | 6.5 | 0.531424710646466 | 0.531424710646466 | false | false | false | true | ||||||||||||||||
| e571c2e7-2470-4b2b-86ed-8d99e62bf77b | 2026-08-17 15:01 | 2026-08-17 15:01 | 2026-08-17 15:01 | FUTU | FUTU261016C00115000 | call | 115.0000 | 2026-10-16 | 7.1500 | 6.5500 | 7.1500 | 109.5700 | 58630.00 | 58630.00 | 0.00 | 82 | 22 | 84 | 112 | 0.75 | 0.515656620468476 | 0.515656620468476 | false | false | false | true | ||||||||||||||||
| bb20a6c2-ef0a-4ff2-b895-4c5b070e5e03 | 2026-08-17 14:58 | 2026-08-17 14:58 | 2026-08-17 14:58 | FUTU | FUTU260904P00100000 | put | 100.0000 | 2026-09-04 | 1.8800 | 1.8000 | 2.2100 | 109.5100 | 18800.00 | 18612.00 | 188.00 | 100 | 12 | 135 | 70 | 1.92857142857143 | 0.58307666511127 | 0.58307666511127 | false | false | false | true | ||||||||||||||||
| aa3e3821-94f4-48dc-9a39-69acb3338de1 | 2026-08-17 11:20 | 2026-08-17 11:20 | 2026-08-17 11:20 | FUTU | FUTU260828C00120000 | call | 120.0000 | 2026-08-28 | 1.2800 | 1.0600 | 1.2800 | 109.1500 | 14848.00 | 14848.00 | 0.00 | 116 | 22 | 159 | 250 | 0.636 | 0.61536732119911 | 0.61536732119911 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Financial Services |
| 10635851529.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |