PREVIEW / stock_5min / 2009-02-12
file: by_date/stock_5min/2009/2009-02-12.parquet size: 4.3 MB rows: 299,873 symbols: 3,278
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-12 05:15:00 | AAPL | Stock | 3.4214 | 3.4214 | 3.4214 | 3.4214 | 2800.0 |
| 2009-02-12 05:20:00 | AAPL | Stock | 3.4107 | 3.4107 | 3.4107 | 3.4107 | 2800.0 |
| 2009-02-12 07:55:00 | AAPL | Stock | 3.4157 | 3.4157 | 3.4146 | 3.4146 | 13720.0 |
| 2009-02-12 08:00:00 | AAPL | Stock | 3.4339 | 3.4386 | 3.4268 | 3.4268 | 169400.0 |
| 2009-02-12 08:05:00 | AAPL | Stock | 3.425 | 3.4393 | 3.4243 | 3.4393 | 144200.0 |
| 2009-02-12 08:10:00 | AAPL | Stock | 3.4293 | 3.4293 | 3.4286 | 3.4286 | 30800.0 |
| 2009-02-12 08:15:00 | AAPL | Stock | 3.4346 | 3.4346 | 3.425 | 3.425 | 23100.0 |
| 2009-02-12 08:20:00 | AAPL | Stock | 3.4246 | 3.4246 | 3.4214 | 3.4214 | 98448.0 |
| 2009-02-12 08:25:00 | AAPL | Stock | 3.4232 | 3.4268 | 3.4214 | 3.4268 | 66080.0 |
| 2009-02-12 08:30:00 | AAPL | Stock | 3.4318 | 3.44 | 3.4286 | 3.44 | 86380.0 |
| 2009-02-12 08:35:00 | AAPL | Stock | 3.4421 | 3.4446 | 3.4386 | 3.4436 | 91000.0 |
| 2009-02-12 08:40:00 | AAPL | Stock | 3.4407 | 3.4407 | 3.4393 | 3.4407 | 73920.0 |
| 2009-02-12 08:45:00 | AAPL | Stock | 3.4389 | 3.4464 | 3.4389 | 3.4432 | 67256.0 |
| 2009-02-12 08:50:00 | AAPL | Stock | 3.4454 | 3.4525 | 3.4454 | 3.45 | 201096.0 |
| 2009-02-12 08:55:00 | AAPL | Stock | 3.4482 | 3.45 | 3.4479 | 3.4479 | 54600.0 |
| 2009-02-12 09:00:00 | AAPL | Stock | 3.4471 | 3.4471 | 3.4396 | 3.4396 | 29400.0 |
| 2009-02-12 09:05:00 | AAPL | Stock | 3.4375 | 3.4375 | 3.4279 | 3.4279 | 218680.0 |
| 2009-02-12 09:10:00 | AAPL | Stock | 3.4279 | 3.4286 | 3.425 | 3.425 | 47852.0 |
| 2009-02-12 09:15:00 | AAPL | Stock | 3.4286 | 3.4286 | 3.4204 | 3.4214 | 146300.0 |
| 2009-02-12 09:20:00 | AAPL | Stock | 3.4214 | 3.4257 | 3.4204 | 3.4204 | 109452.0 |
| 2009-02-12 09:25:00 | AAPL | Stock | 3.4225 | 3.4286 | 3.4207 | 3.4246 | 361536.0 |
| 2009-02-12 09:30:00 | AAPL | Stock | 3.4246 | 3.4671 | 3.4225 | 3.4375 | 19927712.0 |
| 2009-02-12 09:35:00 | AAPL | Stock | 3.4373 | 3.4711 | 3.4368 | 3.4649 | 20132616.0 |
| 2009-02-12 09:40:00 | AAPL | Stock | 3.4646 | 3.4886 | 3.4632 | 3.4857 | 17510052.0 |
| 2009-02-12 09:45:00 | AAPL | Stock | 3.4864 | 3.4961 | 3.4804 | 3.4846 | 17447780.0 |
| 2009-02-12 09:50:00 | AAPL | Stock | 3.4846 | 3.4875 | 3.4668 | 3.48 | 16665908.0 |
| 2009-02-12 09:55:00 | AAPL | Stock | 3.4804 | 3.4875 | 3.4639 | 3.4861 | 13948564.0 |
| 2009-02-12 10:00:00 | AAPL | Stock | 3.4854 | 3.4864 | 3.46 | 3.4711 | 18146380.0 |
| 2009-02-12 10:05:00 | AAPL | Stock | 3.4711 | 3.4718 | 3.445 | 3.4561 | 15215200.0 |
| 2009-02-12 10:10:00 | AAPL | Stock | 3.4561 | 3.4671 | 3.4521 | 3.4629 | 10439072.0 |
| 2009-02-12 10:15:00 | AAPL | Stock | 3.4632 | 3.4643 | 3.4429 | 3.4511 | 11882388.0 |
| 2009-02-12 10:20:00 | AAPL | Stock | 3.4514 | 3.4782 | 3.4464 | 3.4754 | 14057708.0 |
| 2009-02-12 10:25:00 | AAPL | Stock | 3.4754 | 3.48 | 3.4636 | 3.4739 | 10211376.0 |
| 2009-02-12 10:30:00 | AAPL | Stock | 3.4736 | 3.4771 | 3.4604 | 3.4714 | 9331560.0 |
| 2009-02-12 10:35:00 | AAPL | Stock | 3.4714 | 3.4768 | 3.4675 | 3.4704 | 5746440.0 |
| 2009-02-12 10:40:00 | AAPL | Stock | 3.4699 | 3.4793 | 3.4646 | 3.4793 | 8455748.0 |
| 2009-02-12 10:45:00 | AAPL | Stock | 3.4795 | 3.5032 | 3.4782 | 3.5021 | 14766836.0 |
| 2009-02-12 10:50:00 | AAPL | Stock | 3.5021 | 3.5193 | 3.4975 | 3.5161 | 17346504.0 |
| 2009-02-12 10:55:00 | AAPL | Stock | 3.5161 | 3.5161 | 3.5036 | 3.5046 | 13082972.0 |
| 2009-02-12 11:00:00 | AAPL | Stock | 3.5043 | 3.5054 | 3.4918 | 3.4996 | 10994060.0 |
| 2009-02-12 11:05:00 | AAPL | Stock | 3.5 | 3.5104 | 3.4979 | 3.5064 | 10506692.0 |
| 2009-02-12 11:10:00 | AAPL | Stock | 3.5064 | 3.5107 | 3.5014 | 3.5046 | 8232336.0 |
| 2009-02-12 11:15:00 | AAPL | Stock | 3.5045 | 3.5045 | 3.4936 | 3.4993 | 9217264.0 |
| 2009-02-12 11:20:00 | AAPL | Stock | 3.4989 | 3.5014 | 3.4936 | 3.4964 | 5766656.0 |
| 2009-02-12 11:25:00 | AAPL | Stock | 3.4961 | 3.5143 | 3.495 | 3.5061 | 6507284.0 |
| 2009-02-12 11:30:00 | AAPL | Stock | 3.5061 | 3.5146 | 3.5061 | 3.5118 | 6140988.0 |
| 2009-02-12 11:35:00 | AAPL | Stock | 3.5107 | 3.5132 | 3.505 | 3.5061 | 6463800.0 |
| 2009-02-12 11:40:00 | AAPL | Stock | 3.5057 | 3.5271 | 3.5057 | 3.5268 | 12146512.0 |
| 2009-02-12 11:45:00 | AAPL | Stock | 3.5268 | 3.5318 | 3.5214 | 3.5254 | 9909312.0 |
| 2009-02-12 11:50:00 | AAPL | Stock | 3.5254 | 3.5304 | 3.5225 | 3.5257 | 8283744.0 |
> showing 50 of 299,873 rows — these rows as CSV