PREVIEW / stock_5min / 2006-05-03
file: by_date/stock_5min/2006/2006-05-03.parquet size: 3.1 MB rows: 225,501 symbols: 2,252
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2006-05-03 04:50:00 | AAPL | Stock | 2.5579 | 2.5579 | 2.5579 | 2.5579 | 2800.0 |
| 2006-05-03 08:00:00 | AAPL | Stock | 2.5571 | 2.5571 | 2.5571 | 2.5571 | 25200.0 |
| 2006-05-03 08:05:00 | AAPL | Stock | 2.5571 | 2.5589 | 2.5571 | 2.5589 | 62160.0 |
| 2006-05-03 08:10:00 | AAPL | Stock | 2.5611 | 2.5714 | 2.5589 | 2.5593 | 381108.0 |
| 2006-05-03 08:15:00 | AAPL | Stock | 2.5643 | 2.5679 | 2.5614 | 2.5636 | 290360.0 |
| 2006-05-03 08:20:00 | AAPL | Stock | 2.5643 | 2.5679 | 2.5639 | 2.5639 | 823760.0 |
| 2006-05-03 08:25:00 | AAPL | Stock | 2.5639 | 2.5661 | 2.5639 | 2.5661 | 59920.0 |
| 2006-05-03 08:30:00 | AAPL | Stock | 2.5661 | 2.5679 | 2.5661 | 2.5671 | 330400.0 |
| 2006-05-03 08:35:00 | AAPL | Stock | 2.5661 | 2.5664 | 2.5654 | 2.5661 | 109200.0 |
| 2006-05-03 08:40:00 | AAPL | Stock | 2.5661 | 2.5664 | 2.5643 | 2.5664 | 99400.0 |
| 2006-05-03 08:45:00 | AAPL | Stock | 2.5661 | 2.5661 | 2.5629 | 2.5643 | 108864.0 |
| 2006-05-03 08:50:00 | AAPL | Stock | 2.5625 | 2.5636 | 2.5589 | 2.5614 | 227220.0 |
| 2006-05-03 08:55:00 | AAPL | Stock | 2.5625 | 2.5661 | 2.5625 | 2.5661 | 215180.0 |
| 2006-05-03 09:00:00 | AAPL | Stock | 2.5646 | 2.5646 | 2.5646 | 2.5646 | 11200.0 |
| 2006-05-03 09:05:00 | AAPL | Stock | 2.5657 | 2.5675 | 2.5646 | 2.5646 | 95060.0 |
| 2006-05-03 09:10:00 | AAPL | Stock | 2.5646 | 2.5657 | 2.5639 | 2.5657 | 131600.0 |
| 2006-05-03 09:15:00 | AAPL | Stock | 2.5643 | 2.5643 | 2.5643 | 2.5643 | 2800.0 |
| 2006-05-03 09:20:00 | AAPL | Stock | 2.5657 | 2.5661 | 2.5657 | 2.5661 | 93800.0 |
| 2006-05-03 09:25:00 | AAPL | Stock | 2.5618 | 2.5732 | 2.5611 | 2.5657 | 3617768.0 |
| 2006-05-03 09:30:00 | AAPL | Stock | 2.5654 | 2.5696 | 2.5554 | 2.5604 | 24676036.0 |
| 2006-05-03 09:35:00 | AAPL | Stock | 2.5604 | 2.5607 | 2.5464 | 2.5471 | 19954452.0 |
| 2006-05-03 09:40:00 | AAPL | Stock | 2.5468 | 2.5496 | 2.5361 | 2.5411 | 19432224.0 |
| 2006-05-03 09:45:00 | AAPL | Stock | 2.5414 | 2.5414 | 2.5164 | 2.5221 | 33149732.0 |
| 2006-05-03 09:50:00 | AAPL | Stock | 2.5225 | 2.5268 | 2.5118 | 2.5175 | 26848388.0 |
| 2006-05-03 09:55:00 | AAPL | Stock | 2.5175 | 2.5189 | 2.5064 | 2.5139 | 29219288.0 |
| 2006-05-03 10:00:00 | AAPL | Stock | 2.5139 | 2.5268 | 2.5136 | 2.5257 | 20543236.0 |
| 2006-05-03 10:05:00 | AAPL | Stock | 2.5257 | 2.5279 | 2.5171 | 2.5189 | 15807400.0 |
| 2006-05-03 10:10:00 | AAPL | Stock | 2.5189 | 2.5236 | 2.5129 | 2.5189 | 8770188.0 |
| 2006-05-03 10:15:00 | AAPL | Stock | 2.5189 | 2.5293 | 2.5146 | 2.5289 | 10919552.0 |
| 2006-05-03 10:20:00 | AAPL | Stock | 2.5289 | 2.5318 | 2.5232 | 2.5289 | 8725164.0 |
| 2006-05-03 10:25:00 | AAPL | Stock | 2.5289 | 2.5329 | 2.5236 | 2.5275 | 7919352.0 |
| 2006-05-03 10:30:00 | AAPL | Stock | 2.5271 | 2.535 | 2.5271 | 2.5311 | 12669356.0 |
| 2006-05-03 10:35:00 | AAPL | Stock | 2.5311 | 2.535 | 2.5286 | 2.5293 | 8206296.0 |
| 2006-05-03 10:40:00 | AAPL | Stock | 2.5293 | 2.5339 | 2.5225 | 2.5232 | 7537488.0 |
| 2006-05-03 10:45:00 | AAPL | Stock | 2.5229 | 2.525 | 2.5186 | 2.5207 | 7274456.0 |
| 2006-05-03 10:50:00 | AAPL | Stock | 2.5207 | 2.5214 | 2.5154 | 2.5182 | 8227268.0 |
| 2006-05-03 10:55:00 | AAPL | Stock | 2.5186 | 2.5243 | 2.5175 | 2.5186 | 5919088.0 |
| 2006-05-03 11:00:00 | AAPL | Stock | 2.5189 | 2.5211 | 2.5125 | 2.5189 | 10581284.0 |
| 2006-05-03 11:05:00 | AAPL | Stock | 2.5189 | 2.5207 | 2.5143 | 2.5175 | 7295624.0 |
| 2006-05-03 11:10:00 | AAPL | Stock | 2.5175 | 2.5204 | 2.5168 | 2.5182 | 4001396.0 |
| 2006-05-03 11:15:00 | AAPL | Stock | 2.5182 | 2.52 | 2.5168 | 2.5179 | 2734816.0 |
| 2006-05-03 11:20:00 | AAPL | Stock | 2.5179 | 2.5182 | 2.5079 | 2.5111 | 9814252.0 |
| 2006-05-03 11:25:00 | AAPL | Stock | 2.5107 | 2.5229 | 2.5104 | 2.5229 | 9973740.0 |
| 2006-05-03 11:30:00 | AAPL | Stock | 2.5229 | 2.5232 | 2.5204 | 2.5214 | 7650104.0 |
| 2006-05-03 11:35:00 | AAPL | Stock | 2.5214 | 2.5229 | 2.5186 | 2.5204 | 3706276.0 |
| 2006-05-03 11:40:00 | AAPL | Stock | 2.5204 | 2.525 | 2.5199 | 2.5225 | 4872700.0 |
| 2006-05-03 11:45:00 | AAPL | Stock | 2.5229 | 2.5268 | 2.52 | 2.5268 | 6487600.0 |
| 2006-05-03 11:50:00 | AAPL | Stock | 2.5268 | 2.5296 | 2.525 | 2.5271 | 6718572.0 |
| 2006-05-03 11:55:00 | AAPL | Stock | 2.5275 | 2.53 | 2.5261 | 2.5267 | 4685772.0 |
| 2006-05-03 12:00:00 | AAPL | Stock | 2.5264 | 2.5311 | 2.5254 | 2.53 | 7902412.0 |
> showing 50 of 225,501 rows — these rows as CSV