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 |
|---|
| f9c09cd9-157c-41e5-86f2-fee73f707f0c | 2026-09-01 14:13 | 2026-09-01 14:12 | 2026-09-01 14:12 | SPXW | SPXW260918C07600000 | call | 7600.0000 | 2026-09-18 | 110.7500 | 110.3000 | 110.9000 | 7632.2500 | 553760.00 | 553760.00 | 0.00 | 50 | 5 | 59 | 3649 | 0.016168813373527 | 0.130849596961939 | 0.131161925257146 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:15:43.135015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e73f5a85-886f-42c3-9976-1a8afb39e1bf | 2026-09-10 09:54 | 2026-09-10 09:54 | 2026-09-10 09:54 | SPXW | SPXW260918C07600000 | call | 7600.0000 | 2026-09-18 | 67.1000 | 67.1000 | 67.2000 | 7589.4500 | 516670.00 | 0.00 | 516670.00 | 77 | 5 | 218 | 3683 | 0.0591908770024437 | 0.154300665823956 | 0.154300665823956 | false | false | false | true | ||||||||||||||||
| fdb0ac23-258b-4172-b008-a5bbd1576cfa | 2026-09-14 12:15 | 2026-09-14 12:15 | 2026-09-14 12:15 | SPXW | SPXW260918C07600000 | call | 7600.0000 | 2026-09-18 | 71.0000 | 70.7000 | 71.2000 | 7630.1200 | 284000.00 | 284000.00 | 0.00 | 40 | 10 | 882 | 3811 | 0.23143531881396 | 0.16551516600007 | 0.16551516600007 | false | false | false | true | ||||||||||||||||
| 0e55f9be-68f4-4f3e-b34a-1d5513173558 | 2026-09-16 12:54 | 2026-09-16 12:53 | 2026-09-16 12:53 | SPXW | SPXW260918C07600000 | call | 7600.0000 | 2026-09-18 | 51.4700 | 51.4000 | 51.8000 | 7609.3600 | 514720.00 | 283250.00 | 231470.00 | 100 | 14 | 680 | 4452 | 0.152740341419587 | 0.203929076701461 | 0.203481675721391 | true | false | false | true | ||||||||||||||||
| ee871d14-a7fe-472f-a971-921ed0478faa | 2026-09-17 09:35 | 2026-09-17 09:35 | 2026-09-17 09:35 | SPXW | SPXW260918C07600000 | call | 7600.0000 | 2026-09-18 | 46.0000 | 45.8000 | 46.2000 | 7626.2700 | 524400.00 | 312800.00 | 78200.00 | 114 | 10 | 238 | 4785 | 0.0497387669801463 | 0.192249148682512 | 0.192249148682512 | false | false | false | true | ||||||||||||||||
| 72a8f45d-440f-40a1-8f60-7b488d0915e4 | 2026-09-17 09:35 | 2026-09-17 09:35 | 2026-09-17 09:35 | SPXW | SPXW260918C07600000 | call | 7600.0000 | 2026-09-18 | 46.0000 | 45.8000 | 46.0000 | 7626.2700 | 165600.00 | 165600.00 | 0.00 | 36 | 8 | 124 | 4785 | 0.025914315569488 | 0.192249148682512 | 0.192249148682512 | false | false | false | true | ||||||||||||||||
| e564e92e-2a83-4ff6-9491-2db9c365993f | 2026-09-17 09:37 | 2026-09-17 09:37 | 2026-09-17 09:37 | SPXW | SPXW260918C07600000 | call | 7600.0000 | 2026-09-18 | 44.0000 | 43.9000 | 44.4000 | 7623.9800 | 110000.00 | 70400.00 | 39600.00 | 25 | 6 | 357 | 4785 | 0.0746081504702194 | 0.188618633201673 | 0.188618633201673 | false | false | false | true | ||||||||||||||||
| 6c3a444f-a751-4868-af32-5d9da8e30126 | 2026-09-17 09:37 | 2026-09-17 09:37 | 2026-09-17 09:37 | SPXW | SPXW260918C07600000 | call | 7600.0000 | 2026-09-18 | 44.0800 | 43.9000 | 44.5000 | 7623.9800 | 330580.00 | 13200.00 | 317380.00 | 75 | 22 | 332 | 4785 | 0.0693834900731452 | 0.189946916777753 | 0.188618633201673 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:06:33.692120Z"} |
| 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-14T16:23:59.234542Z"} |
| 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-16T17:08:32.093964Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |