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 | 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 |
|---|
| a3691ac1-5b5a-4de0-bcf2-d97e907a561a | 2026-08-18 13:12 | 2026-08-18 13:12 | 2026-08-18 13:12 | FIG | FIG280121C00025000 | call | 25.0000 | 2028-01-21 | 10.6900 | 10.4000 | 11.0000 | 26.2200 | 27796.00 | 0.00 | 12816.00 | 26 | 7 | 32 | 6360 | 0.0050314465408805 | 0.813507739427697 | 0.813507739427697 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 10881766439.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5d42a585-9cab-42e4-b467-311c4a50f1e6 | 2026-08-19 10:46 | 2026-08-19 10:46 | 2026-08-19 10:46 | FIG | FIG261016C00025000 | call | 25.0000 | 2026-10-16 | 4.2100 | 3.8000 | 4.3000 | 26.8900 | 18928.00 | 18928.00 | 0.00 | 45 | 5 | 77 | 3899 | 0.0197486535008977 | 0.749901296311496 | 0.749901296311496 | false | false | false | true | ||||||||||||||||
| 4f8bd7fa-afd0-4993-b291-ea0f620eadf0 | 2026-08-19 12:25 | 2026-08-19 12:25 | 2026-08-19 12:25 | FIG | FIG270115C00040000 | call | 40.0000 | 2027-01-15 | 2.2100 | 2.2000 | 2.3900 | 27.0950 | 44660.00 | 0.00 | 44660.00 | 202 | 9 | 526 | 5827 | 0.0902694353869916 | 0.796452638847361 | 0.802937459413566 | false | false | false | true | ||||||||||||||||
| 6a7a5c54-96bb-456d-bd8c-e5ccc1dabaa0 | 2026-08-20 09:44 | 2026-08-20 09:44 | 2026-08-20 09:44 | FIG | FIG260821C00028000 | call | 28.0000 | 2026-08-21 | 0.3900 | 0.3400 | 0.4000 | 27.5200 | 10291.00 | 10174.00 | 78.00 | 265 | 16 | 387 | 4342 | 0.0891294334408107 | 1.01458646694698 | 1.03275661544773 | false | false | false | true | ||||||||||||||||
| 4bf293c3-9624-4a53-860d-132a6d0aff04 | 2026-08-27 11:07 | 2026-08-27 11:06 | 2026-08-27 11:06 | FIG | FIG260828C00030000 | call | 30.0000 | 2026-08-28 | 0.9800 | 0.6900 | 0.9800 | 30.3200 | 19632.00 | 6696.00 | 0.00 | 200 | 12 | 3537 | 9756 | 0.362546125461255 | 1.0166851504926 | 1.29966416478688 | false | false | false | true | ||||||||||||||||
| 268db149-46cc-4d28-8dec-1b65ae8225c2 | 2026-08-27 14:12 | 2026-08-27 14:12 | 2026-08-27 14:12 | FIG | FIG270115C00045000 | call | 45.0000 | 2027-01-15 | 2.3300 | 2.1000 | 2.4600 | 30.8400 | 23273.00 | 0.00 | 23273.00 | 100 | 5 | 325 | 2061 | 0.157690441533236 | 0.746806659878216 | 0.783053742893399 | false | false | false | true | ||||||||||||||||
| 5d5dbe5b-d704-4132-964f-6e24446d4a7e | 2026-08-31 13:16 | 2026-08-31 13:15 | 2026-08-31 13:15 | FIG | FIG261009P00027500 | put | 27.5000 | 2026-10-09 | 2.3000 | 2.1200 | 2.6200 | 27.7450 | 26633.00 | 0.00 | 26633.00 | 116 | 6 | 118 | 22 | 5.36363636363636 | 0.639504602904975 | 0.692769899944823 | false | false | false | true | ||||||||||||||||
| 7d70a940-e7d4-4718-bba8-fa8f8705b3ac | 2026-09-01 09:42 | 2026-09-01 09:42 | 2026-09-01 09:42 | FIG | FIG261016C00030000 | call | 30.0000 | 2026-10-16 | 1.7100 | 1.4500 | 1.7100 | 26.9000 | 34151.00 | 25821.00 | 8330.00 | 200 | 13 | 219 | 7780 | 0.0281491002570694 | 0.744183783893575 | 0.744183783893575 | false | false | false | true | ||||||||||||||||
| 0fc2ef76-177a-458e-9369-454fceeee30a | 2026-09-02 12:12 | 2026-09-02 12:12 | 2026-09-02 12:12 | FIG | FIG261016C00025000 | call | 25.0000 | 2026-10-16 | 3.1500 | 3.1000 | 3.2500 | 26.1250 | 78122.00 | 315.00 | 77807.00 | 248 | 36 | 536 | 5084 | 0.105428796223446 | 0.699260470791185 | 0.703822487471756 | false | false | false | true | ||||||||||||||||
| 2e351fee-b1e7-4574-ba94-be9fcaa2698f | 2026-09-03 14:22 | 2026-09-03 14:22 | 2026-09-03 14:22 | FIG | FIG260904P00026500 | put | 26.5000 | 2026-09-04 | 0.4700 | 0.3600 | 0.4700 | 26.5400 | 19831.00 | 19785.00 | 0.00 | 422 | 32 | 841 | 319 | 2.63636363636364 | 0.868854928139271 | 0.886929501607515 | false | false | false | true | ||||||||||||||||
| 2146420f-845d-464e-808c-f8032986ae0f | 2026-09-08 09:57 | 2026-09-08 09:57 | 2026-09-08 09:57 | FIG | FIG261016C00030000 | call | 30.0000 | 2026-10-16 | 0.5400 | 0.5000 | 0.5400 | 22.9700 | 10831.00 | 10779.00 | 52.00 | 201 | 15 | 351 | 9233 | 0.0380158128452291 | 0.785660205788384 | 0.789844658150765 | false | false | false | true | ||||||||||||||||
| 8aaa6803-c6dc-47d3-8979-5186bea96341 | 2026-09-08 13:51 | 2026-09-08 13:51 | 2026-09-08 13:51 | FIG | FIG261016C00020000 | call | 20.0000 | 2026-10-16 | 3.9900 | 3.8500 | 4.0500 | 23.0750 | 22728.00 | 22728.00 | 0.00 | 57 | 7 | 107 | 3818 | 0.0280251440544788 | 0.73495726760311 | 0.73495726760311 | false | false | false | true | ||||||||||||||||
| 0c3188fc-a804-43e9-93a6-95c22332114f | 2026-09-08 14:31 | 2026-09-08 14:31 | 2026-09-08 14:31 | FIG | FIG261009P00021000 | put | 21.0000 | 2026-10-09 | 1.0000 | 0.8200 | 1.0500 | 22.7850 | 10497.00 | 10497.00 | 0.00 | 105 | 5 | 292 | 346 | 0.84393063583815 | 0.703199955682263 | 0.695885905795249 | false | false | false | true | ||||||||||||||||
| dd8df837-f067-482e-a337-0f21da0ce566 | 2026-09-11 10:10 | 2026-09-11 10:10 | 2026-09-11 10:10 | FIG | FIG261016C00030000 | call | 30.0000 | 2026-10-16 | 0.4300 | 0.3500 | 0.4300 | 22.8700 | 12804.00 | 12804.00 | 0.00 | 300 | 24 | 327 | 10084 | 0.032427608092027 | 0.766078582858081 | 0.771946629365222 | false | false | false | true | ||||||||||||||||
| 31f9ff86-5128-4a67-b3bb-a291d1575c4f | 2026-09-16 15:21 | 2026-09-16 15:21 | 2026-09-16 15:21 | FIG | FIG280121C00050000 | call | 50.0000 | 2028-01-21 | 3.2100 | 3.2000 | 3.5500 | 22.7400 | 92107.00 | 670.00 | 91437.00 | 287 | 14 | 318 | 1968 | 0.161585365853659 | 0.765027677657399 | 0.780400124499686 | true | false | false | true | ||||||||||||||||
| 456d6e4b-f746-429c-844d-0810258ad558 | 2026-09-17 14:02 | 2026-09-17 14:02 | 2026-09-17 14:02 | FIG | FIG260925C00025500 | call | 25.5000 | 2026-09-25 | 0.3300 | 0.2700 | 0.5200 | 23.5100 | 16495.00 | 792.00 | 160.00 | 500 | 7 | 1054 | 1537 | 0.685751463890696 | 0.702129911651608 | 0.71143783844314 | false | false | false | true | ||||||||||||||||
| b80027d4-2c46-4c08-a243-01ba60305290 | 2026-09-18 15:29 | 2026-09-18 15:28 | 2026-09-18 15:28 | FIG | FIG260925C00024000 | call | 24.0000 | 2026-09-25 | 0.3800 | 0.3500 | 0.3800 | 22.8350 | 21718.00 | 21718.00 | 0.00 | 576 | 29 | 1030 | 607 | 1.69686985172982 | 0.633451205489255 | 0.642480695907452 | false | false | false | true | ||||||||||||||||
| 39e57e62-baa4-4249-bbca-66301a30b97a | 2026-09-18 15:37 | 2026-09-18 15:37 | 2026-09-18 15:37 | FIG | FIG261016P00025000 | put | 25.0000 | 2026-10-16 | 3.1000 | 3.0000 | 3.2000 | 22.6750 | 54257.00 | 0.00 | 35037.00 | 175 | 18 | 213 | 3892 | 0.0547276464542652 | 0.664200168857844 | 0.671450119584778 | false | false | false | true | ||||||||||||||||
| 540ea2d4-b07d-47f6-9f26-266cc166cf93 | 2026-09-21 12:10 | 2026-09-21 12:10 | 2026-09-21 12:10 | FIG | FIG261120C00025000 | call | 25.0000 | 2026-11-20 | 1.9500 | 1.9500 | 2.0100 | 22.5300 | 49401.00 | 0.00 | 45111.00 | 253 | 13 | 389 | 89 | 4.37078651685393 | 0.776492858054801 | 0.776492858054801 | true | false | false | true | ||||||||||||||||
| b325e063-3146-4e8c-b341-80f12b0db571 | 2026-09-22 12:09 | 2026-09-22 12:08 | 2026-09-22 12:08 | FIG | FIG280121C00080000 | call | 80.0000 | 2028-01-21 | 1.2500 | 1.2000 | 1.5000 | 21.2500 | 94010.00 | 23758.00 | 70252.00 | 752 | 8 | 755 | 529 | 1.42722117202268 | 0.784694298384317 | 0.791018736739869 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:44:23.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:19:14.278097Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:15:47.972880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:43:21.019108Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10881766439.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:11:33.656123Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10494919870.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:29:08.379560Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10599596000.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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10326527834.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10326527834.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 10162686934.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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 9921476720.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:12:44.237245Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |