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 | expirydate |
|---|
| 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 |
|---|
| 12378da6-2d36-4b82-b464-43a4428c94aa | 2026-08-17 12:10 | 2026-08-17 12:10 | 2026-08-17 12:10 | IBIT | IBIT281215P00020000 | put | 20.0000 | 2028-12-15 | 3.1100 | 2.8100 | 3.3000 | 36.2750 | 4719326.00 | 4661306.00 | 27520.00 | 15190 | 141 | 15190 | 2143 | 7.08819412039197 | 0.616719310253005 | 0.616719310253005 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 64762757065.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b4dcc854-b3cd-4c3d-8ca0-d1ebbe38a505 | 2026-08-17 12:10 | 2026-08-17 12:10 | 2026-08-17 12:10 | IBIT | IBIT281215P00020000 | put | 20.0000 | 2028-12-15 | 3.2700 | 2.8200 | 3.4000 | 36.2850 | 1366655.00 | 1092445.00 | 274210.00 | 4176 | 37 | 30320 | 2143 | 14.1483901073262 | 0.640116990264628 | 0.640116990264628 | false | false | false | true | ||||||||||||||||
| 479a5307-bb0a-4f25-8afe-7db735781eb4 | 2026-08-17 12:10 | 2026-08-17 12:10 | 2026-08-17 12:10 | IBIT | IBIT281215P00020000 | put | 20.0000 | 2028-12-15 | 3.2400 | 2.8200 | 3.5000 | 36.2850 | 3547648.00 | 1807003.00 | 1081635.00 | 10954 | 107 | 26144 | 2143 | 12.1997200186654 | 0.621504774011833 | 0.640116990264628 | true | false | false | true | ||||||||||||||||
| 3d5af44c-9519-4269-af16-fd29d91110ea | 2026-08-17 12:10 | 2026-08-17 12:10 | 2026-08-17 12:10 | IBIT | IBIT281215P00020000 | put | 20.0000 | 2028-12-15 | 3.2000 | 3.0000 | 3.2000 | 36.2850 | 3200086.00 | 3197646.00 | 1525.00 | 10005 | 46 | 40380 | 2143 | 18.8427438170789 | 0.616825942179981 | 0.630830489350499 | false | false | false | true | ||||||||||||||||
| a1267893-858a-4a74-99ef-74d7028afd7e | 2026-08-17 12:11 | 2026-08-17 12:10 | 2026-08-17 12:11 | IBIT | IBIT281215P00020000 | put | 20.0000 | 2028-12-15 | 3.2000 | 0.0000 | 0.0000 | 36.2650 | 596250.00 | 478305.00 | 68775.00 | 1838 | 24 | 41409 | 2143 | 19.3229118058796 | 0 | 0 | true | true | false | true | false | |||||||||||||||
| 0b833bc5-8a62-4a1f-a32a-e2e0db99b40a | 2026-08-18 14:16 | 2026-08-18 14:16 | 2026-08-18 14:16 | IBIT | IBIT281215P00020000 | put | 20.0000 | 2028-12-15 | 3.0500 | 3.0500 | 3.1000 | 36.6450 | 61000.00 | 0.00 | 61000.00 | 200 | 11 | 7131 | 101965 | 0.0699357622713676 | 0.621237883752821 | 0.621237883752821 | false | false | false | true | ||||||||||||||||
| 77216299-6729-4685-ba6e-296a5b388d47 | 2026-09-09 09:42 | 2026-09-09 09:42 | 2026-09-09 09:42 | IBIT | IBIT281215P00020000 | put | 20.0000 | 2028-12-15 | 2.1000 | 2.1000 | 2.2600 | 44.8850 | 74983.00 | 215.00 | 74768.00 | 357 | 9 | 460 | 166378 | 0.00276478861387924 | 0.611317133598472 | 0.61653884944291 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| SweepsFollowedByFloor |
| 36cb34b2-bfec-40a0-b347-859cae1cf152 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:46:31.810255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |