PREVIEW / stock_5min / 2008-05-20
file: by_date/stock_5min/2008/2008-05-20.parquet size: 4.4 MB rows: 317,942 symbols: 3,318
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-05-20 05:35:00 | AAPL | Stock | 6.5661 | 6.5661 | 6.5614 | 6.5614 | 11200.0 |
| 2008-05-20 06:20:00 | AAPL | Stock | 6.5711 | 6.5711 | 6.5711 | 6.5711 | 5600.0 |
| 2008-05-20 06:40:00 | AAPL | Stock | 6.5539 | 6.5539 | 6.5539 | 6.5539 | 8400.0 |
| 2008-05-20 07:00:00 | AAPL | Stock | 6.5182 | 6.5182 | 6.5182 | 6.5182 | 11088.0 |
| 2008-05-20 07:40:00 | AAPL | Stock | 6.5446 | 6.5446 | 6.5446 | 6.5446 | 2800.0 |
| 2008-05-20 07:45:00 | AAPL | Stock | 6.5279 | 6.5357 | 6.5275 | 6.5321 | 16800.0 |
| 2008-05-20 07:50:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5357 | 6.5357 | 8400.0 |
| 2008-05-20 07:55:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5357 | 6.5357 | 22400.0 |
| 2008-05-20 08:00:00 | AAPL | Stock | 6.5304 | 6.5543 | 6.5304 | 6.5543 | 618996.0 |
| 2008-05-20 08:05:00 | AAPL | Stock | 6.5543 | 6.5621 | 6.5521 | 6.555 | 336308.0 |
| 2008-05-20 08:10:00 | AAPL | Stock | 6.5536 | 6.5539 | 6.5504 | 6.5507 | 175924.0 |
| 2008-05-20 08:15:00 | AAPL | Stock | 6.55 | 6.55 | 6.5357 | 6.5357 | 374584.0 |
| 2008-05-20 08:20:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5268 | 6.5343 | 238532.0 |
| 2008-05-20 08:25:00 | AAPL | Stock | 6.5314 | 6.5357 | 6.5282 | 6.5357 | 124320.0 |
| 2008-05-20 08:30:00 | AAPL | Stock | 6.5404 | 6.5425 | 6.5179 | 6.5193 | 657748.0 |
| 2008-05-20 08:35:00 | AAPL | Stock | 6.5204 | 6.5318 | 6.5179 | 6.5196 | 459452.0 |
| 2008-05-20 08:40:00 | AAPL | Stock | 6.5196 | 6.5221 | 6.5032 | 6.5043 | 938196.0 |
| 2008-05-20 08:45:00 | AAPL | Stock | 6.5057 | 6.5236 | 6.5018 | 6.5136 | 536396.0 |
| 2008-05-20 08:50:00 | AAPL | Stock | 6.5089 | 6.5189 | 6.5089 | 6.5132 | 191240.0 |
| 2008-05-20 08:55:00 | AAPL | Stock | 6.5121 | 6.5121 | 6.5039 | 6.5057 | 262696.0 |
| 2008-05-20 09:00:00 | AAPL | Stock | 6.5054 | 6.5054 | 6.4911 | 6.5029 | 875728.0 |
| 2008-05-20 09:05:00 | AAPL | Stock | 6.5029 | 6.5114 | 6.5029 | 6.5111 | 261828.0 |
| 2008-05-20 09:10:00 | AAPL | Stock | 6.5121 | 6.5143 | 6.5043 | 6.5075 | 681800.0 |
| 2008-05-20 09:15:00 | AAPL | Stock | 6.5093 | 6.5129 | 6.5064 | 6.5071 | 154560.0 |
| 2008-05-20 09:20:00 | AAPL | Stock | 6.5071 | 6.5121 | 6.5061 | 6.5089 | 314104.0 |
| 2008-05-20 09:25:00 | AAPL | Stock | 6.5096 | 6.51 | 6.4932 | 6.4943 | 1434580.0 |
| 2008-05-20 09:30:00 | AAPL | Stock | 6.4929 | 6.5011 | 6.4329 | 6.4714 | 39324516.0 |
| 2008-05-20 09:35:00 | AAPL | Stock | 6.4714 | 6.5179 | 6.4643 | 6.51 | 27415276.0 |
| 2008-05-20 09:40:00 | AAPL | Stock | 6.51 | 6.5464 | 6.4871 | 6.54 | 26675600.0 |
| 2008-05-20 09:45:00 | AAPL | Stock | 6.54 | 6.5779 | 6.5354 | 6.5568 | 28309204.0 |
| 2008-05-20 09:50:00 | AAPL | Stock | 6.5568 | 6.5714 | 6.5486 | 6.5636 | 16407720.0 |
| 2008-05-20 09:55:00 | AAPL | Stock | 6.5647 | 6.565 | 6.5236 | 6.5324 | 25900112.0 |
| 2008-05-20 10:00:00 | AAPL | Stock | 6.5318 | 6.5446 | 6.5204 | 6.5404 | 18863936.0 |
| 2008-05-20 10:05:00 | AAPL | Stock | 6.54 | 6.5646 | 6.5296 | 6.5304 | 19247732.0 |
| 2008-05-20 10:10:00 | AAPL | Stock | 6.5306 | 6.5514 | 6.5204 | 6.5514 | 13951112.0 |
| 2008-05-20 10:15:00 | AAPL | Stock | 6.5498 | 6.5514 | 6.5268 | 6.5346 | 10327100.0 |
| 2008-05-20 10:20:00 | AAPL | Stock | 6.5357 | 6.5488 | 6.5329 | 6.5389 | 11219040.0 |
| 2008-05-20 10:25:00 | AAPL | Stock | 6.5392 | 6.5821 | 6.5325 | 6.5768 | 18870040.0 |
| 2008-05-20 10:30:00 | AAPL | Stock | 6.5768 | 6.5771 | 6.5218 | 6.5225 | 21710696.0 |
| 2008-05-20 10:35:00 | AAPL | Stock | 6.524 | 6.5268 | 6.5036 | 6.52 | 13414156.0 |
| 2008-05-20 10:40:00 | AAPL | Stock | 6.52 | 6.5357 | 6.5146 | 6.5357 | 10097304.0 |
| 2008-05-20 10:45:00 | AAPL | Stock | 6.5357 | 6.5618 | 6.5318 | 6.5614 | 11225592.0 |
| 2008-05-20 10:50:00 | AAPL | Stock | 6.5611 | 6.5664 | 6.5511 | 6.553 | 10675896.0 |
| 2008-05-20 10:55:00 | AAPL | Stock | 6.5529 | 6.5868 | 6.5528 | 6.5843 | 16380448.0 |
| 2008-05-20 11:00:00 | AAPL | Stock | 6.5843 | 6.5864 | 6.5579 | 6.5589 | 11382308.0 |
| 2008-05-20 11:05:00 | AAPL | Stock | 6.5586 | 6.5614 | 6.5364 | 6.5429 | 14597800.0 |
| 2008-05-20 11:10:00 | AAPL | Stock | 6.5432 | 6.5525 | 6.5357 | 6.5518 | 8708140.0 |
| 2008-05-20 11:15:00 | AAPL | Stock | 6.5524 | 6.565 | 6.5475 | 6.5579 | 7663684.0 |
| 2008-05-20 11:20:00 | AAPL | Stock | 6.5571 | 6.5754 | 6.5504 | 6.57 | 8551060.0 |
| 2008-05-20 11:25:00 | AAPL | Stock | 6.5707 | 6.5893 | 6.5707 | 6.5779 | 13196792.0 |
> showing 50 of 317,942 rows — these rows as CSV