PREVIEW / stock_5min / 2010-04-30
file: by_date/stock_5min/2010/2010-04-30.parquet size: 5.0 MB rows: 337,800 symbols: 3,499
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-04-30 04:25:00 | AAPL | Stock | 9.6268 | 9.6268 | 9.6107 | 9.625 | 33600.0 |
| 2010-04-30 04:40:00 | AAPL | Stock | 9.6571 | 9.6571 | 9.6571 | 9.6571 | 5600.0 |
| 2010-04-30 04:45:00 | AAPL | Stock | 9.6636 | 9.6636 | 9.6636 | 9.6636 | 2800.0 |
| 2010-04-30 05:05:00 | AAPL | Stock | 9.6429 | 9.6429 | 9.6429 | 9.6429 | 2800.0 |
| 2010-04-30 05:25:00 | AAPL | Stock | 9.6429 | 9.6429 | 9.6429 | 9.6429 | 8400.0 |
| 2010-04-30 05:30:00 | AAPL | Stock | 9.6429 | 9.6429 | 9.6429 | 9.6429 | 8400.0 |
| 2010-04-30 05:35:00 | AAPL | Stock | 9.6407 | 9.6407 | 9.6407 | 9.6407 | 8400.0 |
| 2010-04-30 06:10:00 | AAPL | Stock | 9.6346 | 9.6346 | 9.6346 | 9.6346 | 14000.0 |
| 2010-04-30 06:15:00 | AAPL | Stock | 9.6357 | 9.6357 | 9.6357 | 9.6357 | 2800.0 |
| 2010-04-30 06:30:00 | AAPL | Stock | 9.6357 | 9.6429 | 9.6357 | 9.6429 | 11200.0 |
| 2010-04-30 06:45:00 | AAPL | Stock | 9.6339 | 9.6339 | 9.6339 | 9.6339 | 5516.0 |
| 2010-04-30 06:55:00 | AAPL | Stock | 9.6279 | 9.6279 | 9.6275 | 9.6275 | 14000.0 |
| 2010-04-30 07:00:00 | AAPL | Stock | 9.6275 | 9.6275 | 9.6196 | 9.6196 | 25200.0 |
| 2010-04-30 07:05:00 | AAPL | Stock | 9.625 | 9.625 | 9.625 | 9.625 | 25732.0 |
| 2010-04-30 07:10:00 | AAPL | Stock | 9.6286 | 9.6329 | 9.6286 | 9.6329 | 16800.0 |
| 2010-04-30 07:15:00 | AAPL | Stock | 9.6329 | 9.6329 | 9.6329 | 9.6329 | 2800.0 |
| 2010-04-30 07:20:00 | AAPL | Stock | 9.625 | 9.6286 | 9.625 | 9.6286 | 11200.0 |
| 2010-04-30 07:30:00 | AAPL | Stock | 9.6389 | 9.6396 | 9.6264 | 9.6264 | 42056.0 |
| 2010-04-30 07:35:00 | AAPL | Stock | 9.6493 | 9.6493 | 9.6493 | 9.6493 | 5600.0 |
| 2010-04-30 07:45:00 | AAPL | Stock | 9.6268 | 9.6268 | 9.6268 | 9.6268 | 14000.0 |
| 2010-04-30 07:55:00 | AAPL | Stock | 9.6296 | 9.6389 | 9.6296 | 9.6304 | 16800.0 |
| 2010-04-30 08:00:00 | AAPL | Stock | 9.6304 | 9.6393 | 9.6268 | 9.6393 | 180348.0 |
| 2010-04-30 08:05:00 | AAPL | Stock | 9.6393 | 9.6429 | 9.6357 | 9.6407 | 139160.0 |
| 2010-04-30 08:10:00 | AAPL | Stock | 9.6357 | 9.6404 | 9.6357 | 9.6396 | 100716.0 |
| 2010-04-30 08:15:00 | AAPL | Stock | 9.6393 | 9.6464 | 9.6393 | 9.6446 | 340732.0 |
| 2010-04-30 08:20:00 | AAPL | Stock | 9.6429 | 9.6475 | 9.6429 | 9.6464 | 147616.0 |
| 2010-04-30 08:25:00 | AAPL | Stock | 9.6464 | 9.6486 | 9.6429 | 9.6439 | 153720.0 |
| 2010-04-30 08:30:00 | AAPL | Stock | 9.6432 | 9.6468 | 9.6114 | 9.6114 | 603568.0 |
| 2010-04-30 08:35:00 | AAPL | Stock | 9.6146 | 9.6261 | 9.6114 | 9.6225 | 109200.0 |
| 2010-04-30 08:40:00 | AAPL | Stock | 9.6207 | 9.6246 | 9.6182 | 9.6221 | 42140.0 |
| 2010-04-30 08:45:00 | AAPL | Stock | 9.6218 | 9.6393 | 9.6218 | 9.6357 | 49980.0 |
| 2010-04-30 08:50:00 | AAPL | Stock | 9.6339 | 9.6439 | 9.6304 | 9.6375 | 316484.0 |
| 2010-04-30 08:55:00 | AAPL | Stock | 9.6357 | 9.6357 | 9.6143 | 9.6204 | 284480.0 |
| 2010-04-30 09:00:00 | AAPL | Stock | 9.6321 | 9.6332 | 9.6118 | 9.615 | 138600.0 |
| 2010-04-30 09:05:00 | AAPL | Stock | 9.6157 | 9.6268 | 9.6143 | 9.6218 | 156520.0 |
| 2010-04-30 09:10:00 | AAPL | Stock | 9.6214 | 9.6418 | 9.6189 | 9.6218 | 156660.0 |
| 2010-04-30 09:15:00 | AAPL | Stock | 9.6216 | 9.6225 | 9.6139 | 9.6179 | 128800.0 |
| 2010-04-30 09:20:00 | AAPL | Stock | 9.6179 | 9.6179 | 9.6121 | 9.6121 | 70952.0 |
| 2010-04-30 09:25:00 | AAPL | Stock | 9.6129 | 9.6218 | 9.605 | 9.62 | 588476.0 |
| 2010-04-30 09:30:00 | AAPL | Stock | 9.6182 | 9.6632 | 9.5989 | 9.6171 | 15970696.0 |
| 2010-04-30 09:35:00 | AAPL | Stock | 9.6171 | 9.6275 | 9.595 | 9.6171 | 9087344.0 |
| 2010-04-30 09:40:00 | AAPL | Stock | 9.6187 | 9.6193 | 9.5682 | 9.6 | 14295176.0 |
| 2010-04-30 09:45:00 | AAPL | Stock | 9.5995 | 9.605 | 9.5821 | 9.5857 | 7380464.0 |
| 2010-04-30 09:50:00 | AAPL | Stock | 9.5861 | 9.5954 | 9.5036 | 9.5378 | 17451224.0 |
| 2010-04-30 09:55:00 | AAPL | Stock | 9.5379 | 9.5536 | 9.5321 | 9.5321 | 8802864.0 |
| 2010-04-30 10:00:00 | AAPL | Stock | 9.5321 | 9.5343 | 9.4679 | 9.4714 | 13536432.0 |
| 2010-04-30 10:05:00 | AAPL | Stock | 9.4717 | 9.5161 | 9.4679 | 9.5 | 10808000.0 |
| 2010-04-30 10:10:00 | AAPL | Stock | 9.4996 | 9.5186 | 9.4889 | 9.4914 | 6466376.0 |
| 2010-04-30 10:15:00 | AAPL | Stock | 9.4933 | 9.5071 | 9.4721 | 9.4896 | 8874012.0 |
| 2010-04-30 10:20:00 | AAPL | Stock | 9.4911 | 9.5161 | 9.4861 | 9.5154 | 6948396.0 |
> showing 50 of 337,800 rows — these rows as CSV