uw_flow_alerts728,802 rows| 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 |
|---|
| 151a0eff-d598-4f32-b735-b5d150374e60 | 2026-09-03 12:25 | 2026-09-03 12:25 | 2026-09-03 12:25 | SPXW | SPXW260904P07740000 | put | 7740.0000 | 2026-09-04 | 20.3000 | 20.2000 | 20.3000 | 7739.8700 | 103530.00 | 103530.00 | 0.00 | 51 | 5 | 1859 | 661 | 2.81240544629349 | 0.127675119860427 | 0.127675119860427 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 63bcc4b7-7a4b-43e0-8d2c-824fd04c810c | 2026-09-03 13:07 | 2026-09-03 13:07 | 2026-09-03 13:07 | SPXW | SPXW260904P07740000 | put | 7740.0000 | 2026-09-04 | 18.1000 | 18.0000 | 18.1000 | 7742.9600 | 269690.00 | 269690.00 | 0.00 | 149 | 8 | 2590 | 661 | 3.91830559757943 | 0.123258878456524 | 0.123258878456524 | false | false | false | true | ||||||||||||||||
| fba186ce-34a4-40d1-9333-2dd872ac1468 | 2026-09-03 15:15 | 2026-09-03 15:15 | 2026-09-03 15:15 | SPXW | SPXW260904P07740000 | put | 7740.0000 | 2026-09-04 | 14.1000 | 14.0000 | 14.1000 | 7750.0800 | 269310.00 | 269310.00 | 0.00 | 191 | 7 | 4871 | 661 | 7.36913767019667 | 0.117785113242307 | 0.117785113242307 | false | false | false | true | ||||||||||||||||
| 5925b150-eacb-4462-929f-6a74f6af1389 | 2026-09-04 09:42 | 2026-09-04 09:42 | 2026-09-04 09:42 | SPXW | SPXW260904P07740000 | put | 7740.0000 | 2026-09-04 | 13.3900 | 13.2000 | 13.6000 | 7739.0700 | 167340.00 | 164680.00 | 0.00 | 125 | 28 | 4763 | 1836 | 2.5942265795207 | 0.156367454797684 | 0.159994019294582 | false | false | false | true | ||||||||||||||||
| 59b6822c-bdb2-43c7-9259-7e90e9ea85f2 | 2026-09-04 09:59 | 2026-09-04 09:59 | 2026-09-04 09:59 | SPXW | SPXW260904P07740000 | put | 7740.0000 | 2026-09-04 | 11.5000 | 11.5000 | 11.7000 | 7739.6400 | 115000.00 | 0.00 | 115000.00 | 100 | 20 | 10501 | 1836 | 5.71949891067538 | 0.141167974736343 | 0.141167974736343 | false | false | false | true | ||||||||||||||||
| a68df625-ee7b-4260-a190-e42803d760be | 2026-09-04 10:03 | 2026-09-04 10:03 | 2026-09-04 10:03 | SPXW | SPXW260904P07740000 | put | 7740.0000 | 2026-09-04 | 12.8500 | 12.6000 | 12.9000 | 7737.6300 | 128460.00 | 128460.00 | 0.00 | 100 | 27 | 12289 | 1836 | 6.69335511982571 | 0.145282320511578 | 0.146529185448216 | false | false | false | true | ||||||||||||||||
| 070bbe53-10af-4357-a51b-2d6e6db6570d | 2026-09-04 10:03 | 2026-09-04 10:03 | 2026-09-04 10:03 | SPXW | SPXW260904P07740000 | put | 7740.0000 | 2026-09-04 | 13.0000 | 12.8000 | 13.1000 | 7736.8100 | 131280.00 | 0.00 | 131280.00 | 101 | 29 | 12424 | 1836 | 6.76688453159041 | 0.142347418251293 | 0.139845785749693 | false | false | false | true | ||||||||||||||||
| a9e420f2-d465-4862-a2ee-6d3b77c7673c | 2026-09-04 10:06 | 2026-09-04 10:06 | 2026-09-04 10:06 | SPXW | SPXW260904P07740000 | put | 7740.0000 | 2026-09-04 | 13.1600 | 13.1000 | 13.4000 | 7735.0100 | 131570.00 | 0.00 | 131570.00 | 100 | 22 | 13148 | 1836 | 7.16122004357298 | 0.132895466608233 | 0.131625107401306 | false | false | false | true | ||||||||||||||||
| 0f3ec32f-8d4d-4e08-a27c-a332c2c9a19c | 2026-09-04 10:08 | 2026-09-04 10:07 | 2026-09-04 10:07 | SPXW | SPXW260904P07740000 | put | 7740.0000 | 2026-09-04 | 13.9900 | 13.8000 | 14.1000 | 7734.2300 | 131470.00 | 116210.00 | 5520.00 | 94 | 16 | 13617 | 1836 | 7.41666666666667 | 0.137578651437029 | 0.136300720007542 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T17:30:37.600118Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:45:37.268469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |