PREVIEW / stock_5min / 2008-01-07
file: by_date/stock_5min/2008/2008-01-07.parquet size: 4.6 MB rows: 330,132 symbols: 3,246
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-01-07 04:05:00 | AAPL | Stock | 6.4643 | 6.4643 | 6.4643 | 6.4643 | 11312.0 |
| 2008-01-07 05:50:00 | AAPL | Stock | 6.4911 | 6.4911 | 6.4911 | 6.4911 | 11200.0 |
| 2008-01-07 06:25:00 | AAPL | Stock | 6.4821 | 6.4821 | 6.4821 | 6.4821 | 24220.0 |
| 2008-01-07 06:35:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 14000.0 |
| 2008-01-07 06:45:00 | AAPL | Stock | 6.5254 | 6.5268 | 6.5254 | 6.5268 | 8400.0 |
| 2008-01-07 06:50:00 | AAPL | Stock | 6.5268 | 6.5268 | 6.5268 | 6.5268 | 50400.0 |
| 2008-01-07 06:55:00 | AAPL | Stock | 6.5268 | 6.5268 | 6.5268 | 6.5268 | 8400.0 |
| 2008-01-07 07:00:00 | AAPL | Stock | 6.5268 | 6.5286 | 6.5214 | 6.5214 | 120400.0 |
| 2008-01-07 07:05:00 | AAPL | Stock | 6.5304 | 6.5304 | 6.5232 | 6.5232 | 194740.0 |
| 2008-01-07 07:10:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5271 | 6.5271 | 37044.0 |
| 2008-01-07 07:15:00 | AAPL | Stock | 6.5232 | 6.53 | 6.5229 | 6.5282 | 75600.0 |
| 2008-01-07 07:20:00 | AAPL | Stock | 6.5243 | 6.525 | 6.5232 | 6.5232 | 198800.0 |
| 2008-01-07 07:25:00 | AAPL | Stock | 6.5246 | 6.525 | 6.5007 | 6.5136 | 136164.0 |
| 2008-01-07 07:30:00 | AAPL | Stock | 6.5136 | 6.525 | 6.5136 | 6.5179 | 267148.0 |
| 2008-01-07 07:35:00 | AAPL | Stock | 6.5179 | 6.5229 | 6.5161 | 6.52 | 371224.0 |
| 2008-01-07 07:40:00 | AAPL | Stock | 6.52 | 6.5218 | 6.5093 | 6.51 | 374500.0 |
| 2008-01-07 07:45:00 | AAPL | Stock | 6.51 | 6.5125 | 6.5071 | 6.5125 | 81200.0 |
| 2008-01-07 07:50:00 | AAPL | Stock | 6.5157 | 6.5179 | 6.5157 | 6.5179 | 75600.0 |
| 2008-01-07 07:55:00 | AAPL | Stock | 6.5182 | 6.5182 | 6.5011 | 6.5132 | 147000.0 |
| 2008-01-07 08:00:00 | AAPL | Stock | 6.5107 | 6.5207 | 6.4304 | 6.5004 | 1366596.0 |
| 2008-01-07 08:05:00 | AAPL | Stock | 6.5018 | 6.5071 | 6.4911 | 6.4925 | 539028.0 |
| 2008-01-07 08:10:00 | AAPL | Stock | 6.4911 | 6.4929 | 6.4304 | 6.4879 | 813848.0 |
| 2008-01-07 08:15:00 | AAPL | Stock | 6.4861 | 6.4982 | 6.4861 | 6.4875 | 285712.0 |
| 2008-01-07 08:20:00 | AAPL | Stock | 6.4893 | 6.4893 | 6.4768 | 6.4818 | 457240.0 |
| 2008-01-07 08:25:00 | AAPL | Stock | 6.4786 | 6.4789 | 6.4664 | 6.47 | 699552.0 |
| 2008-01-07 08:30:00 | AAPL | Stock | 6.4714 | 6.4804 | 6.4696 | 6.4718 | 562772.0 |
| 2008-01-07 08:35:00 | AAPL | Stock | 6.4746 | 6.4786 | 6.4304 | 6.4696 | 4154500.0 |
| 2008-01-07 08:40:00 | AAPL | Stock | 6.47 | 6.47 | 6.4557 | 6.4643 | 551600.0 |
| 2008-01-07 08:45:00 | AAPL | Stock | 6.4675 | 6.4893 | 6.4643 | 6.4875 | 1790824.0 |
| 2008-01-07 08:50:00 | AAPL | Stock | 6.4857 | 6.4871 | 6.4714 | 6.4714 | 759220.0 |
| 2008-01-07 08:55:00 | AAPL | Stock | 6.4714 | 6.48 | 6.4643 | 6.48 | 603232.0 |
| 2008-01-07 09:00:00 | AAPL | Stock | 6.4746 | 6.475 | 6.4568 | 6.4714 | 491064.0 |
| 2008-01-07 09:05:00 | AAPL | Stock | 6.4671 | 6.4725 | 6.4643 | 6.4725 | 357140.0 |
| 2008-01-07 09:10:00 | AAPL | Stock | 6.4732 | 6.4821 | 6.4643 | 6.4725 | 615412.0 |
| 2008-01-07 09:15:00 | AAPL | Stock | 6.4718 | 6.4757 | 6.4568 | 6.4671 | 733320.0 |
| 2008-01-07 09:20:00 | AAPL | Stock | 6.4696 | 6.4696 | 6.4464 | 6.4479 | 576380.0 |
| 2008-01-07 09:25:00 | AAPL | Stock | 6.4479 | 6.4818 | 6.4418 | 6.4736 | 3390688.0 |
| 2008-01-07 09:30:00 | AAPL | Stock | 6.4714 | 6.5268 | 6.4643 | 6.4989 | 50103564.0 |
| 2008-01-07 09:35:00 | AAPL | Stock | 6.4966 | 6.5 | 6.4361 | 6.4593 | 41917456.0 |
| 2008-01-07 09:40:00 | AAPL | Stock | 6.4593 | 6.4954 | 6.4525 | 6.4943 | 36027236.0 |
| 2008-01-07 09:45:00 | AAPL | Stock | 6.4957 | 6.5243 | 6.4821 | 6.4911 | 30310812.0 |
| 2008-01-07 09:50:00 | AAPL | Stock | 6.4914 | 6.5107 | 6.4636 | 6.4854 | 24965472.0 |
| 2008-01-07 09:55:00 | AAPL | Stock | 6.4864 | 6.5571 | 6.4761 | 6.5229 | 33801376.0 |
| 2008-01-07 10:00:00 | AAPL | Stock | 6.5243 | 6.5343 | 6.4768 | 6.4825 | 23337720.0 |
| 2008-01-07 10:05:00 | AAPL | Stock | 6.4825 | 6.5357 | 6.4818 | 6.5157 | 24969028.0 |
| 2008-01-07 10:10:00 | AAPL | Stock | 6.5175 | 6.5471 | 6.4725 | 6.4732 | 23203152.0 |
| 2008-01-07 10:15:00 | AAPL | Stock | 6.4732 | 6.4768 | 6.4096 | 6.4096 | 37360120.0 |
| 2008-01-07 10:20:00 | AAPL | Stock | 6.41 | 6.4314 | 6.25 | 6.2679 | 86304596.0 |
| 2008-01-07 10:25:00 | AAPL | Stock | 6.2679 | 6.3082 | 6.2321 | 6.2429 | 55538924.0 |
| 2008-01-07 10:30:00 | AAPL | Stock | 6.2425 | 6.2679 | 6.0796 | 6.1039 | 81754512.0 |
> showing 50 of 330,132 rows — these rows as CSV