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 |
|---|
| 00ac6e24-3e0a-48cf-b450-1c104e5f5517 | 2026-08-20 10:56 | 2026-08-20 10:56 | 2026-08-20 10:56 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.7500 | 1.6800 | 1.7500 | 61.5798 | 28000.00 | 28000.00 | 0.00 | 160 | 7 | 276 | 4735 | 0.0582893347412883 | 0.467523401581949 | 0.467523401581949 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 38529495748.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1d2986af-0908-4843-87b0-ab4931c79694 | 2026-08-20 11:02 | 2026-08-20 11:02 | 2026-08-20 11:02 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.9700 | 1.9000 | 1.9700 | 62.0000 | 13593.00 | 13593.00 | 0.00 | 69 | 7 | 353 | 4735 | 0.0745512143611404 | 0.474228493222562 | 0.474228493222562 | false | false | false | true | ||||||||||||||||
| 63e62e6a-a645-4b58-86a1-cab560ecb1a2 | 2026-08-21 10:04 | 2026-08-21 10:04 | 2026-08-21 10:04 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 2.2000 | 2.1600 | 2.2300 | 62.7450 | 22000.00 | 22000.00 | 0.00 | 100 | 5 | 413 | 4966 | 0.0831655255739025 | 0.464777743680464 | 0.464777743680464 | false | false | false | true | ||||||||||||||||
| 367b868a-664a-466e-a4f2-4022af12de03 | 2026-08-21 15:44 | 2026-08-21 15:44 | 2026-08-21 15:44 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.9800 | 1.9900 | 2.0700 | 62.6200 | 79242.00 | 0.00 | 79242.00 | 401 | 19 | 1163 | 4966 | 0.234192509061619 | 0.436227862795174 | 0.43469053307206 | true | false | false | true | ||||||||||||||||
| f3eea784-4d35-4a02-a16b-1d3e95f3f999 | 2026-08-24 10:18 | 2026-08-24 10:18 | 2026-08-24 10:18 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.7300 | 1.6700 | 1.7400 | 62.1400 | 48613.00 | 48613.00 | 0.00 | 281 | 10 | 860 | 5095 | 0.168792934249264 | 0.485149043470964 | 0.485149043470964 | false | false | false | true | ||||||||||||||||
| 461f32fa-1afd-4e48-8319-268d2929339a | 2026-08-24 14:07 | 2026-08-24 14:07 | 2026-08-24 14:07 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.5300 | 1.5300 | 1.5800 | 61.8950 | 73572.00 | 0.00 | 73572.00 | 480 | 22 | 3176 | 5095 | 0.623356231599608 | 0.463822454984883 | 0.466187131588962 | true | false | false | true | ||||||||||||||||
| 527f5881-abdb-4a6c-bff9-421ac7a7b47c | 2026-08-24 14:07 | 2026-08-24 14:07 | 2026-08-24 14:07 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.5400 | 1.5400 | 1.5800 | 61.9199 | 75460.00 | 0.00 | 75460.00 | 490 | 13 | 3676 | 5095 | 0.721491658488714 | 0.46362402370154 | 0.46362402370154 | true | false | false | true | ||||||||||||||||
| e2a2c0db-99ad-4c1c-b22e-b858bdfcee9a | 2026-08-27 12:53 | 2026-08-27 12:53 | 2026-08-27 12:53 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.6000 | 1.5500 | 1.6100 | 62.7900 | 32000.00 | 32000.00 | 0.00 | 200 | 5 | 3163 | 6294 | 0.502542103590721 | 0.451882455537698 | 0.451882455537698 | false | false | false | true | ||||||||||||||||
| f4e652f3-4503-4268-82a5-b292147fb549 | 2026-08-27 14:01 | 2026-08-27 14:01 | 2026-08-27 14:01 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.4300 | 1.4300 | 1.4900 | 62.4900 | 15015.00 | 0.00 | 15015.00 | 105 | 12 | 10024 | 6294 | 1.59262789958691 | 0.445154612281145 | 0.445154612281145 | false | false | false | true | ||||||||||||||||
| f7c9445b-4046-4771-8ccf-c97e6dbe9772 | 2026-08-27 14:38 | 2026-08-27 14:38 | 2026-08-27 14:38 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.4200 | 1.3900 | 1.4200 | 62.4553 | 28116.00 | 28116.00 | 0.00 | 198 | 19 | 11344 | 6294 | 1.80235144582142 | 0.446846157290945 | 0.446846157290945 | true | false | false | true | ||||||||||||||||
| 0aa034f6-8474-41e9-8601-8fbed2c230e1 | 2026-08-27 14:41 | 2026-08-27 14:40 | 2026-08-27 14:40 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.3800 | 1.3800 | 1.4300 | 62.4250 | 69000.00 | 0.00 | 69000.00 | 500 | 5 | 12644 | 6294 | 2.00889736256752 | 0.439782625440594 | 0.439782625440594 | false | false | false | true | ||||||||||||||||
| cbf03d32-a21a-4e86-80ac-df31afcd94b8 | 2026-08-28 09:53 | 2026-08-28 09:53 | 2026-08-28 09:53 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 2.2500 | 2.1600 | 2.2500 | 64.0950 | 45450.00 | 45450.00 | 0.00 | 202 | 14 | 1581 | 6762 | 0.233806566104703 | 0.460486845952038 | 0.460486845952038 | true | false | false | true | ||||||||||||||||
| 77c09c2d-67fd-4f20-9253-fd19b9c51ece | 2026-08-28 10:03 | 2026-08-28 10:03 | 2026-08-28 10:03 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.8500 | 1.8000 | 1.8500 | 63.5050 | 27750.00 | 27750.00 | 0.00 | 150 | 5 | 3229 | 6762 | 0.477521443359953 | 0.446366055469562 | 0.446366055469562 | true | false | false | true | ||||||||||||||||
| b5868ddb-f332-4526-b48c-472d4b59a18f | 2026-08-28 10:05 | 2026-08-28 10:05 | 2026-08-28 10:05 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.5000 | 1.5000 | 1.6200 | 62.9700 | 15000.00 | 0.00 | 15000.00 | 100 | 10 | 3756 | 6762 | 0.555456965394854 | 0.428978189544134 | 0.428978189544134 | false | false | false | true | ||||||||||||||||
| 27e79b78-c028-4f97-8d83-ca5910635067 | 2026-08-28 10:07 | 2026-08-28 10:07 | 2026-08-28 10:07 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.2400 | 1.2200 | 1.3100 | 62.3550 | 10044.00 | 0.00 | 1984.00 | 81 | 5 | 4651 | 6762 | 0.687814256137237 | 0.439405046731751 | 0.439405046731751 | false | false | false | true | ||||||||||||||||
| 6670096c-782f-4ab3-94f9-cc1f57dc014e | 2026-08-28 10:25 | 2026-08-28 10:25 | 2026-08-28 10:25 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.2200 | 1.1500 | 1.2200 | 62.3400 | 24400.00 | 24400.00 | 0.00 | 200 | 8 | 8791 | 6762 | 1.30005915409642 | 0.435519307989938 | 0.435519307989938 | false | false | false | true | ||||||||||||||||
| e0cc176d-f063-41cc-8283-6014b6bf1a6c | 2026-08-28 10:40 | 2026-08-28 10:40 | 2026-08-28 10:40 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.3600 | 1.3500 | 1.4000 | 62.6900 | 27200.00 | 0.00 | 27200.00 | 200 | 7 | 12025 | 6762 | 1.77832002366164 | 0.428865412544214 | 0.428865412544214 | false | false | false | true | ||||||||||||||||
| a88799fe-de95-4a7c-9591-9a3ca7c02575 | 2026-08-28 11:04 | 2026-08-28 11:04 | 2026-08-28 11:04 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.5600 | 1.5000 | 1.5700 | 63.1500 | 31200.00 | 31200.00 | 0.00 | 200 | 5 | 13962 | 6762 | 2.06477373558119 | 0.41915278605129 | 0.41915278605129 | false | false | false | true | ||||||||||||||||
| d75cddaa-08e6-4a2b-800d-cb71e491def0 | 2026-08-28 11:07 | 2026-08-28 11:07 | 2026-08-28 11:07 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 1.4600 | 1.4600 | 1.5100 | 63.0150 | 29202.00 | 0.00 | 29202.00 | 200 | 7 | 14468 | 6762 | 2.13960366755398 | 0.41080054680259 | 0.413675913413169 | false | false | false | true | ||||||||||||||||
| b3d709b6-4724-4bec-b55f-4aaa53cdbe51 | 2026-08-28 14:36 | 2026-08-28 14:36 | 2026-08-28 14:36 | SLV | SLV260904C00063000 | call | 63.0000 | 2026-09-04 | 0.4200 | 0.4000 | 0.4700 | 59.9862 | 21000.00 | 0.00 | 21000.00 | 500 | 7 | 17576 | 6762 | 2.59923099674652 | 0.425331150455817 | 0.425331150455817 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:21:20.397116Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:57:11.446067Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:08:43.927668Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:08:43.927668Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:08:43.927668Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:38:22.875878Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:54:23.998586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |