PREVIEW / stock_5min / 2008-04-17
file: by_date/stock_5min/2008/2008-04-17.parquet size: 4.3 MB rows: 308,413 symbols: 3,287
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-17 05:15:00 | AAPL | Stock | 5.5357 | 5.5357 | 5.5357 | 5.5357 | 15680.0 |
| 2008-04-17 06:20:00 | AAPL | Stock | 5.4896 | 5.4957 | 5.4896 | 5.4957 | 5600.0 |
| 2008-04-17 06:55:00 | AAPL | Stock | 5.5011 | 5.5011 | 5.5011 | 5.5011 | 2800.0 |
| 2008-04-17 07:15:00 | AAPL | Stock | 5.4896 | 5.4896 | 5.4896 | 5.4896 | 11200.0 |
| 2008-04-17 07:25:00 | AAPL | Stock | 5.4861 | 5.4879 | 5.4861 | 5.4879 | 8400.0 |
| 2008-04-17 07:45:00 | AAPL | Stock | 5.4946 | 5.5 | 5.4946 | 5.5 | 33600.0 |
| 2008-04-17 07:50:00 | AAPL | Stock | 5.5036 | 5.5089 | 5.5036 | 5.5089 | 46984.0 |
| 2008-04-17 07:55:00 | AAPL | Stock | 5.5089 | 5.5096 | 5.5082 | 5.5089 | 87416.0 |
| 2008-04-17 08:00:00 | AAPL | Stock | 5.5082 | 5.5121 | 5.4986 | 5.5082 | 323092.0 |
| 2008-04-17 08:05:00 | AAPL | Stock | 5.5089 | 5.5179 | 5.5089 | 5.5121 | 241332.0 |
| 2008-04-17 08:10:00 | AAPL | Stock | 5.5121 | 5.5121 | 5.4964 | 5.4964 | 320460.0 |
| 2008-04-17 08:15:00 | AAPL | Stock | 5.4968 | 5.4982 | 5.4893 | 5.4929 | 413392.0 |
| 2008-04-17 08:20:00 | AAPL | Stock | 5.4954 | 5.4982 | 5.4936 | 5.4946 | 198800.0 |
| 2008-04-17 08:25:00 | AAPL | Stock | 5.4939 | 5.4964 | 5.4929 | 5.4929 | 113736.0 |
| 2008-04-17 08:30:00 | AAPL | Stock | 5.4929 | 5.4964 | 5.4893 | 5.4911 | 358708.0 |
| 2008-04-17 08:35:00 | AAPL | Stock | 5.4929 | 5.4929 | 5.4825 | 5.4857 | 231168.0 |
| 2008-04-17 08:40:00 | AAPL | Stock | 5.4886 | 5.4929 | 5.4857 | 5.4857 | 312536.0 |
| 2008-04-17 08:45:00 | AAPL | Stock | 5.4846 | 5.4857 | 5.4821 | 5.4857 | 50400.0 |
| 2008-04-17 08:50:00 | AAPL | Stock | 5.4875 | 5.4875 | 5.4754 | 5.4754 | 212380.0 |
| 2008-04-17 08:55:00 | AAPL | Stock | 5.475 | 5.4782 | 5.4732 | 5.4739 | 166460.0 |
| 2008-04-17 09:00:00 | AAPL | Stock | 5.4739 | 5.4768 | 5.4732 | 5.4732 | 90720.0 |
| 2008-04-17 09:05:00 | AAPL | Stock | 5.4729 | 5.4854 | 5.4729 | 5.4839 | 195860.0 |
| 2008-04-17 09:10:00 | AAPL | Stock | 5.4843 | 5.4861 | 5.4839 | 5.4839 | 114800.0 |
| 2008-04-17 09:15:00 | AAPL | Stock | 5.4857 | 5.4911 | 5.4846 | 5.4911 | 141400.0 |
| 2008-04-17 09:20:00 | AAPL | Stock | 5.4896 | 5.4929 | 5.4875 | 5.4911 | 227892.0 |
| 2008-04-17 09:25:00 | AAPL | Stock | 5.4907 | 5.5046 | 5.4886 | 5.5046 | 1701644.0 |
| 2008-04-17 09:30:00 | AAPL | Stock | 5.5054 | 5.5125 | 5.4768 | 5.5089 | 24363612.0 |
| 2008-04-17 09:35:00 | AAPL | Stock | 5.5089 | 5.5164 | 5.4839 | 5.5089 | 20853196.0 |
| 2008-04-17 09:40:00 | AAPL | Stock | 5.5089 | 5.5304 | 5.5079 | 5.5239 | 20570368.0 |
| 2008-04-17 09:45:00 | AAPL | Stock | 5.5246 | 5.5429 | 5.5146 | 5.5425 | 18082876.0 |
| 2008-04-17 09:50:00 | AAPL | Stock | 5.5421 | 5.5529 | 5.5365 | 5.54 | 18934188.0 |
| 2008-04-17 09:55:00 | AAPL | Stock | 5.54 | 5.5493 | 5.5268 | 5.5357 | 17691548.0 |
| 2008-04-17 10:00:00 | AAPL | Stock | 5.5357 | 5.5364 | 5.5143 | 5.5289 | 19612292.0 |
| 2008-04-17 10:05:00 | AAPL | Stock | 5.5282 | 5.53 | 5.5107 | 5.5225 | 11816224.0 |
| 2008-04-17 10:10:00 | AAPL | Stock | 5.5229 | 5.5446 | 5.52 | 5.5396 | 15249360.0 |
| 2008-04-17 10:15:00 | AAPL | Stock | 5.5393 | 5.5475 | 5.5332 | 5.5425 | 15593340.0 |
| 2008-04-17 10:20:00 | AAPL | Stock | 5.5418 | 5.5632 | 5.5404 | 5.5579 | 18607148.0 |
| 2008-04-17 10:25:00 | AAPL | Stock | 5.5579 | 5.5614 | 5.5507 | 5.5525 | 9719472.0 |
| 2008-04-17 10:30:00 | AAPL | Stock | 5.5532 | 5.5571 | 5.5436 | 5.5525 | 10769696.0 |
| 2008-04-17 10:35:00 | AAPL | Stock | 5.5532 | 5.5714 | 5.5525 | 5.5679 | 15217580.0 |
| 2008-04-17 10:40:00 | AAPL | Stock | 5.5686 | 5.5714 | 5.5493 | 5.5539 | 11778956.0 |
| 2008-04-17 10:45:00 | AAPL | Stock | 5.5539 | 5.5554 | 5.5454 | 5.5479 | 6839616.0 |
| 2008-04-17 10:50:00 | AAPL | Stock | 5.5479 | 5.5536 | 5.5368 | 5.5382 | 6820492.0 |
| 2008-04-17 10:55:00 | AAPL | Stock | 5.5375 | 5.5425 | 5.5304 | 5.5389 | 8521436.0 |
| 2008-04-17 11:00:00 | AAPL | Stock | 5.5382 | 5.5475 | 5.5361 | 5.5439 | 8164856.0 |
| 2008-04-17 11:05:00 | AAPL | Stock | 5.5439 | 5.5493 | 5.5304 | 5.5362 | 7716688.0 |
| 2008-04-17 11:10:00 | AAPL | Stock | 5.5375 | 5.5446 | 5.53 | 5.5432 | 6468952.0 |
| 2008-04-17 11:15:00 | AAPL | Stock | 5.5418 | 5.5496 | 5.5364 | 5.5454 | 5388292.0 |
| 2008-04-17 11:20:00 | AAPL | Stock | 5.5443 | 5.545 | 5.5254 | 5.5257 | 6558720.0 |
| 2008-04-17 11:25:00 | AAPL | Stock | 5.5257 | 5.5307 | 5.515 | 5.525 | 11020884.0 |
> showing 50 of 308,413 rows — these rows as CSV