PREVIEW / stock_5min / 2009-05-04
file: by_date/stock_5min/2009/2009-05-04.parquet size: 4.7 MB rows: 323,326 symbols: 3,363
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-05-04 06:10:00 | AAPL | Stock | 4.5696 | 4.5696 | 4.5696 | 4.5696 | 5600.0 |
| 2009-05-04 06:20:00 | AAPL | Stock | 4.585 | 4.585 | 4.585 | 4.585 | 2800.0 |
| 2009-05-04 06:30:00 | AAPL | Stock | 4.585 | 4.585 | 4.585 | 4.585 | 2800.0 |
| 2009-05-04 07:50:00 | AAPL | Stock | 4.5518 | 4.5518 | 4.5518 | 4.5518 | 2800.0 |
| 2009-05-04 08:00:00 | AAPL | Stock | 4.5707 | 4.5714 | 4.5707 | 4.5714 | 22680.0 |
| 2009-05-04 08:05:00 | AAPL | Stock | 4.5796 | 4.5804 | 4.5714 | 4.5714 | 37520.0 |
| 2009-05-04 08:10:00 | AAPL | Stock | 4.5836 | 4.5911 | 4.5786 | 4.5911 | 199528.0 |
| 2009-05-04 08:15:00 | AAPL | Stock | 4.5911 | 4.595 | 4.585 | 4.5911 | 91084.0 |
| 2009-05-04 08:20:00 | AAPL | Stock | 4.585 | 4.585 | 4.5804 | 4.5821 | 154588.0 |
| 2009-05-04 08:25:00 | AAPL | Stock | 4.5857 | 4.5857 | 4.5857 | 4.5857 | 2800.0 |
| 2009-05-04 08:30:00 | AAPL | Stock | 4.5825 | 4.5825 | 4.5821 | 4.5821 | 5600.0 |
| 2009-05-04 08:40:00 | AAPL | Stock | 4.5718 | 4.5718 | 4.5714 | 4.5718 | 28000.0 |
| 2009-05-04 08:45:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5679 | 4.5686 | 31948.0 |
| 2009-05-04 08:50:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5714 | 4.5714 | 147000.0 |
| 2009-05-04 08:55:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5707 | 4.5711 | 70700.0 |
| 2009-05-04 09:00:00 | AAPL | Stock | 4.5711 | 4.5711 | 4.5679 | 4.5679 | 112000.0 |
| 2009-05-04 09:05:00 | AAPL | Stock | 4.57 | 4.5714 | 4.57 | 4.5714 | 99820.0 |
| 2009-05-04 09:10:00 | AAPL | Stock | 4.5704 | 4.5768 | 4.57 | 4.5761 | 111888.0 |
| 2009-05-04 09:15:00 | AAPL | Stock | 4.5761 | 4.5786 | 4.5761 | 4.5786 | 146440.0 |
| 2009-05-04 09:20:00 | AAPL | Stock | 4.5796 | 4.5821 | 4.5786 | 4.5786 | 84000.0 |
| 2009-05-04 09:25:00 | AAPL | Stock | 4.5779 | 4.5821 | 4.575 | 4.5804 | 399924.0 |
| 2009-05-04 09:30:00 | AAPL | Stock | 4.5793 | 4.5911 | 4.5786 | 4.5818 | 20760740.0 |
| 2009-05-04 09:35:00 | AAPL | Stock | 4.5814 | 4.5854 | 4.56 | 4.5657 | 14081256.0 |
| 2009-05-04 09:40:00 | AAPL | Stock | 4.5647 | 4.6 | 4.5643 | 4.5939 | 14090860.0 |
| 2009-05-04 09:45:00 | AAPL | Stock | 4.5929 | 4.6038 | 4.5907 | 4.5929 | 11377156.0 |
| 2009-05-04 09:50:00 | AAPL | Stock | 4.5921 | 4.5986 | 4.5786 | 4.5907 | 9143204.0 |
| 2009-05-04 09:55:00 | AAPL | Stock | 4.5907 | 4.5961 | 4.5754 | 4.5768 | 7944636.0 |
| 2009-05-04 10:00:00 | AAPL | Stock | 4.5782 | 4.5979 | 4.575 | 4.5946 | 12489008.0 |
| 2009-05-04 10:05:00 | AAPL | Stock | 4.5946 | 4.5968 | 4.5896 | 4.5912 | 7239176.0 |
| 2009-05-04 10:10:00 | AAPL | Stock | 4.5911 | 4.6179 | 4.5896 | 4.6125 | 14456596.0 |
| 2009-05-04 10:15:00 | AAPL | Stock | 4.6129 | 4.625 | 4.6118 | 4.6239 | 9687468.0 |
| 2009-05-04 10:20:00 | AAPL | Stock | 4.6236 | 4.6321 | 4.6182 | 4.6196 | 9266236.0 |
| 2009-05-04 10:25:00 | AAPL | Stock | 4.6193 | 4.6345 | 4.6193 | 4.6343 | 8215004.0 |
| 2009-05-04 10:30:00 | AAPL | Stock | 4.6346 | 4.6354 | 4.6204 | 4.635 | 6843480.0 |
| 2009-05-04 10:35:00 | AAPL | Stock | 4.6346 | 4.6411 | 4.6346 | 4.641 | 6085464.0 |
| 2009-05-04 10:40:00 | AAPL | Stock | 4.6408 | 4.6414 | 4.6304 | 4.6307 | 6207376.0 |
| 2009-05-04 10:45:00 | AAPL | Stock | 4.6311 | 4.6364 | 4.6289 | 4.635 | 5020344.0 |
| 2009-05-04 10:50:00 | AAPL | Stock | 4.6346 | 4.6375 | 4.6296 | 4.6307 | 4205740.0 |
| 2009-05-04 10:55:00 | AAPL | Stock | 4.6311 | 4.6336 | 4.6204 | 4.6268 | 5199180.0 |
| 2009-05-04 11:00:00 | AAPL | Stock | 4.6268 | 4.6407 | 4.6264 | 4.6407 | 5253976.0 |
| 2009-05-04 11:05:00 | AAPL | Stock | 4.64 | 4.6425 | 4.6375 | 4.638 | 5911864.0 |
| 2009-05-04 11:10:00 | AAPL | Stock | 4.6379 | 4.6411 | 4.6318 | 4.6404 | 5060580.0 |
| 2009-05-04 11:15:00 | AAPL | Stock | 4.6404 | 4.6411 | 4.6364 | 4.6393 | 5187084.0 |
| 2009-05-04 11:20:00 | AAPL | Stock | 4.6396 | 4.6407 | 4.6354 | 4.6364 | 2863308.0 |
| 2009-05-04 11:25:00 | AAPL | Stock | 4.6375 | 4.64 | 4.6339 | 4.6357 | 3105844.0 |
| 2009-05-04 11:30:00 | AAPL | Stock | 4.6357 | 4.6379 | 4.6311 | 4.6371 | 3402980.0 |
| 2009-05-04 11:35:00 | AAPL | Stock | 4.6371 | 4.6371 | 4.6295 | 4.6332 | 2155664.0 |
| 2009-05-04 11:40:00 | AAPL | Stock | 4.6329 | 4.6354 | 4.6268 | 4.6304 | 3307976.0 |
| 2009-05-04 11:45:00 | AAPL | Stock | 4.6311 | 4.6393 | 4.6307 | 4.6372 | 2075472.0 |
| 2009-05-04 11:50:00 | AAPL | Stock | 4.6373 | 4.6393 | 4.6329 | 4.6333 | 3946488.0 |
> showing 50 of 323,326 rows — these rows as CSV