PREVIEW / stock_5min / 2010-09-15
file: by_date/stock_5min/2010/2010-09-15.parquet size: 4.6 MB rows: 318,773 symbols: 3,455
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-15 07:00:00 | AAPL | Stock | 9.5893 | 9.5893 | 9.5893 | 9.5893 | 5600.0 |
| 2010-09-15 07:10:00 | AAPL | Stock | 9.5893 | 9.5893 | 9.5743 | 9.5743 | 15400.0 |
| 2010-09-15 07:15:00 | AAPL | Stock | 9.5839 | 9.5839 | 9.5839 | 9.5839 | 8400.0 |
| 2010-09-15 07:20:00 | AAPL | Stock | 9.5946 | 9.5946 | 9.5946 | 9.5946 | 2800.0 |
| 2010-09-15 07:25:00 | AAPL | Stock | 9.5821 | 9.5821 | 9.5821 | 9.5821 | 2800.0 |
| 2010-09-15 07:30:00 | AAPL | Stock | 9.5854 | 9.5871 | 9.5854 | 9.5871 | 5600.0 |
| 2010-09-15 07:40:00 | AAPL | Stock | 9.5939 | 9.5946 | 9.5939 | 9.5946 | 5600.0 |
| 2010-09-15 07:55:00 | AAPL | Stock | 9.6014 | 9.6014 | 9.6 | 9.6 | 19600.0 |
| 2010-09-15 08:00:00 | AAPL | Stock | 9.6004 | 9.6107 | 9.5932 | 9.6011 | 158900.0 |
| 2010-09-15 08:05:00 | AAPL | Stock | 9.5939 | 9.6 | 9.5875 | 9.5875 | 226660.0 |
| 2010-09-15 08:10:00 | AAPL | Stock | 9.5871 | 9.5893 | 9.5829 | 9.5857 | 176260.0 |
| 2010-09-15 08:15:00 | AAPL | Stock | 9.5857 | 9.5857 | 9.5786 | 9.5789 | 114100.0 |
| 2010-09-15 08:20:00 | AAPL | Stock | 9.5857 | 9.5882 | 9.5825 | 9.5829 | 66024.0 |
| 2010-09-15 08:25:00 | AAPL | Stock | 9.5836 | 9.5943 | 9.5821 | 9.5943 | 143500.0 |
| 2010-09-15 08:30:00 | AAPL | Stock | 9.5825 | 9.5943 | 9.5811 | 9.5839 | 238560.0 |
| 2010-09-15 08:35:00 | AAPL | Stock | 9.5782 | 9.5786 | 9.5582 | 9.5779 | 314160.0 |
| 2010-09-15 08:40:00 | AAPL | Stock | 9.5757 | 9.5771 | 9.5679 | 9.5714 | 136080.0 |
| 2010-09-15 08:45:00 | AAPL | Stock | 9.5711 | 9.5725 | 9.5693 | 9.5725 | 113764.0 |
| 2010-09-15 08:50:00 | AAPL | Stock | 9.5704 | 9.5714 | 9.5696 | 9.5714 | 22316.0 |
| 2010-09-15 08:55:00 | AAPL | Stock | 9.5704 | 9.5825 | 9.5696 | 9.5779 | 230356.0 |
| 2010-09-15 09:00:00 | AAPL | Stock | 9.5775 | 9.5775 | 9.5679 | 9.5682 | 123648.0 |
| 2010-09-15 09:05:00 | AAPL | Stock | 9.5711 | 9.5721 | 9.5632 | 9.5714 | 240884.0 |
| 2010-09-15 09:10:00 | AAPL | Stock | 9.5704 | 9.5714 | 9.5686 | 9.5714 | 67200.0 |
| 2010-09-15 09:15:00 | AAPL | Stock | 9.5693 | 9.585 | 9.5668 | 9.5789 | 163044.0 |
| 2010-09-15 09:20:00 | AAPL | Stock | 9.58 | 9.5804 | 9.5775 | 9.5796 | 30800.0 |
| 2010-09-15 09:25:00 | AAPL | Stock | 9.5768 | 9.5832 | 9.5714 | 9.5782 | 255472.0 |
| 2010-09-15 09:30:00 | AAPL | Stock | 9.5775 | 9.6 | 9.5657 | 9.5932 | 14752220.0 |
| 2010-09-15 09:35:00 | AAPL | Stock | 9.5957 | 9.6018 | 9.5786 | 9.5818 | 9939272.0 |
| 2010-09-15 09:40:00 | AAPL | Stock | 9.5839 | 9.5864 | 9.5704 | 9.5846 | 9666384.0 |
| 2010-09-15 09:45:00 | AAPL | Stock | 9.585 | 9.6157 | 9.5675 | 9.6146 | 13629168.0 |
| 2010-09-15 09:50:00 | AAPL | Stock | 9.6129 | 9.6304 | 9.6118 | 9.6282 | 12876948.0 |
| 2010-09-15 09:55:00 | AAPL | Stock | 9.6279 | 9.6296 | 9.6094 | 9.6175 | 9232608.0 |
| 2010-09-15 10:00:00 | AAPL | Stock | 9.6175 | 9.6307 | 9.6007 | 9.6032 | 11801608.0 |
| 2010-09-15 10:05:00 | AAPL | Stock | 9.6036 | 9.6339 | 9.6025 | 9.6311 | 9567488.0 |
| 2010-09-15 10:10:00 | AAPL | Stock | 9.6318 | 9.6343 | 9.6246 | 9.6311 | 7032760.0 |
| 2010-09-15 10:15:00 | AAPL | Stock | 9.6314 | 9.6368 | 9.625 | 9.6332 | 8457176.0 |
| 2010-09-15 10:20:00 | AAPL | Stock | 9.6332 | 9.6368 | 9.6207 | 9.6261 | 6926052.0 |
| 2010-09-15 10:25:00 | AAPL | Stock | 9.6254 | 9.6275 | 9.6204 | 9.6232 | 3984204.0 |
| 2010-09-15 10:30:00 | AAPL | Stock | 9.6243 | 9.6357 | 9.6214 | 9.63 | 5772508.0 |
| 2010-09-15 10:35:00 | AAPL | Stock | 9.6296 | 9.6311 | 9.6157 | 9.6206 | 5977160.0 |
| 2010-09-15 10:40:00 | AAPL | Stock | 9.6207 | 9.6293 | 9.6157 | 9.6261 | 4489828.0 |
| 2010-09-15 10:45:00 | AAPL | Stock | 9.6261 | 9.6264 | 9.6161 | 9.6182 | 3836056.0 |
| 2010-09-15 10:50:00 | AAPL | Stock | 9.6189 | 9.6229 | 9.6154 | 9.6214 | 3659348.0 |
| 2010-09-15 10:55:00 | AAPL | Stock | 9.62 | 9.6357 | 9.6186 | 9.6336 | 5871376.0 |
| 2010-09-15 11:00:00 | AAPL | Stock | 9.6339 | 9.635 | 9.6204 | 9.6239 | 3872848.0 |
| 2010-09-15 11:05:00 | AAPL | Stock | 9.6241 | 9.625 | 9.6114 | 9.6169 | 5656056.0 |
| 2010-09-15 11:10:00 | AAPL | Stock | 9.6171 | 9.6197 | 9.6111 | 9.615 | 4669476.0 |
| 2010-09-15 11:15:00 | AAPL | Stock | 9.615 | 9.6175 | 9.6068 | 9.61 | 5175576.0 |
| 2010-09-15 11:20:00 | AAPL | Stock | 9.6107 | 9.6229 | 9.6079 | 9.6143 | 4112248.0 |
| 2010-09-15 11:25:00 | AAPL | Stock | 9.6164 | 9.6175 | 9.6114 | 9.6114 | 2229864.0 |
> showing 50 of 318,773 rows — these rows as CSV