PREVIEW / stock_5min / 2013-03-26
file: by_date/stock_5min/2013/2013-03-26.parquet size: 4.9 MB rows: 325,263 symbols: 3,484
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 |
|---|---|---|---|---|---|---|---|
| 2013-03-26 05:00:00 | AAPL | Stock | 16.5704 | 16.5704 | 16.5704 | 16.5704 | 7000.0 |
| 2013-03-26 06:20:00 | AAPL | Stock | 16.5761 | 16.5761 | 16.5761 | 16.5761 | 2800.0 |
| 2013-03-26 07:00:00 | AAPL | Stock | 16.5893 | 16.5893 | 16.5861 | 16.5861 | 5600.0 |
| 2013-03-26 07:05:00 | AAPL | Stock | 16.5889 | 16.5889 | 16.5889 | 16.5889 | 5152.0 |
| 2013-03-26 07:10:00 | AAPL | Stock | 16.5989 | 16.6079 | 16.5989 | 16.6071 | 30940.0 |
| 2013-03-26 07:15:00 | AAPL | Stock | 16.6193 | 16.6364 | 16.6193 | 16.6364 | 153692.0 |
| 2013-03-26 07:20:00 | AAPL | Stock | 16.6357 | 16.6568 | 16.6296 | 16.6296 | 39200.0 |
| 2013-03-26 07:25:00 | AAPL | Stock | 16.6304 | 16.65 | 16.625 | 16.65 | 116172.0 |
| 2013-03-26 07:30:00 | AAPL | Stock | 16.6464 | 16.6464 | 16.6268 | 16.6268 | 65324.0 |
| 2013-03-26 07:35:00 | AAPL | Stock | 16.6361 | 16.6368 | 16.6361 | 16.6368 | 5600.0 |
| 2013-03-26 07:40:00 | AAPL | Stock | 16.6339 | 16.6414 | 16.6268 | 16.6268 | 64764.0 |
| 2013-03-26 07:45:00 | AAPL | Stock | 16.6268 | 16.6268 | 16.6071 | 16.6071 | 67144.0 |
| 2013-03-26 07:50:00 | AAPL | Stock | 16.6093 | 16.6157 | 16.5957 | 16.5957 | 40460.0 |
| 2013-03-26 07:55:00 | AAPL | Stock | 16.6011 | 16.6011 | 16.5821 | 16.5821 | 79240.0 |
| 2013-03-26 08:00:00 | AAPL | Stock | 16.585 | 16.6464 | 16.5764 | 16.5786 | 480816.0 |
| 2013-03-26 08:05:00 | AAPL | Stock | 16.5771 | 16.5771 | 16.5339 | 16.5557 | 456960.0 |
| 2013-03-26 08:10:00 | AAPL | Stock | 16.54 | 16.5654 | 16.5357 | 16.5589 | 133560.0 |
| 2013-03-26 08:15:00 | AAPL | Stock | 16.5625 | 16.5714 | 16.5582 | 16.5711 | 72240.0 |
| 2013-03-26 08:20:00 | AAPL | Stock | 16.5714 | 16.5714 | 16.5643 | 16.5714 | 168560.0 |
| 2013-03-26 08:25:00 | AAPL | Stock | 16.5654 | 16.5889 | 16.5654 | 16.585 | 91896.0 |
| 2013-03-26 08:30:00 | AAPL | Stock | 16.5718 | 16.5854 | 16.5714 | 16.5768 | 57680.0 |
| 2013-03-26 08:35:00 | AAPL | Stock | 16.5868 | 16.5868 | 16.5739 | 16.5854 | 28000.0 |
| 2013-03-26 08:40:00 | AAPL | Stock | 16.5832 | 16.6014 | 16.5832 | 16.5964 | 97160.0 |
| 2013-03-26 08:45:00 | AAPL | Stock | 16.5989 | 16.5996 | 16.5911 | 16.5982 | 73640.0 |
| 2013-03-26 08:50:00 | AAPL | Stock | 16.5957 | 16.6021 | 16.5818 | 16.5839 | 105560.0 |
| 2013-03-26 08:55:00 | AAPL | Stock | 16.5893 | 16.5896 | 16.575 | 16.5836 | 52080.0 |
| 2013-03-26 09:00:00 | AAPL | Stock | 16.5836 | 16.5964 | 16.5757 | 16.5893 | 171696.0 |
| 2013-03-26 09:05:00 | AAPL | Stock | 16.6007 | 16.6025 | 16.595 | 16.5964 | 344904.0 |
| 2013-03-26 09:10:00 | AAPL | Stock | 16.5979 | 16.6071 | 16.5939 | 16.6068 | 224588.0 |
| 2013-03-26 09:15:00 | AAPL | Stock | 16.6079 | 16.6125 | 16.6054 | 16.6071 | 125860.0 |
| 2013-03-26 09:20:00 | AAPL | Stock | 16.6079 | 16.6268 | 16.6068 | 16.6214 | 439936.0 |
| 2013-03-26 09:25:00 | AAPL | Stock | 16.62 | 16.625 | 16.6018 | 16.6129 | 989828.0 |
| 2013-03-26 09:30:00 | AAPL | Stock | 16.6079 | 16.6371 | 16.5093 | 16.5536 | 17190740.0 |
| 2013-03-26 09:35:00 | AAPL | Stock | 16.5532 | 16.5889 | 16.5436 | 16.5837 | 8774500.0 |
| 2013-03-26 09:40:00 | AAPL | Stock | 16.585 | 16.5879 | 16.5314 | 16.5479 | 6919304.0 |
| 2013-03-26 09:45:00 | AAPL | Stock | 16.5514 | 16.5514 | 16.4843 | 16.515 | 11377016.0 |
| 2013-03-26 09:50:00 | AAPL | Stock | 16.5146 | 16.5296 | 16.4961 | 16.5007 | 5425812.0 |
| 2013-03-26 09:55:00 | AAPL | Stock | 16.4986 | 16.5357 | 16.4986 | 16.5143 | 4170152.0 |
| 2013-03-26 10:00:00 | AAPL | Stock | 16.5154 | 16.5357 | 16.4882 | 16.5189 | 7080864.0 |
| 2013-03-26 10:05:00 | AAPL | Stock | 16.5168 | 16.5664 | 16.5155 | 16.5614 | 7245000.0 |
| 2013-03-26 10:10:00 | AAPL | Stock | 16.5568 | 16.5654 | 16.5275 | 16.5286 | 5305132.0 |
| 2013-03-26 10:15:00 | AAPL | Stock | 16.5279 | 16.5393 | 16.4936 | 16.4961 | 5808012.0 |
| 2013-03-26 10:20:00 | AAPL | Stock | 16.4969 | 16.5164 | 16.4686 | 16.48 | 8145032.0 |
| 2013-03-26 10:25:00 | AAPL | Stock | 16.4789 | 16.4982 | 16.4696 | 16.4732 | 4768820.0 |
| 2013-03-26 10:30:00 | AAPL | Stock | 16.4732 | 16.4882 | 16.45 | 16.4643 | 7428820.0 |
| 2013-03-26 10:35:00 | AAPL | Stock | 16.4642 | 16.4882 | 16.4614 | 16.4754 | 4645872.0 |
| 2013-03-26 10:40:00 | AAPL | Stock | 16.4768 | 16.4936 | 16.4682 | 16.4768 | 3589684.0 |
| 2013-03-26 10:45:00 | AAPL | Stock | 16.4761 | 16.5082 | 16.4611 | 16.4869 | 5772284.0 |
| 2013-03-26 10:50:00 | AAPL | Stock | 16.4898 | 16.5164 | 16.4882 | 16.4961 | 4220748.0 |
| 2013-03-26 10:55:00 | AAPL | Stock | 16.5004 | 16.5225 | 16.4918 | 16.5168 | 3441732.0 |
> showing 50 of 325,263 rows — these rows as CSV