PREVIEW / stock_5min / 2013-04-25
file: by_date/stock_5min/2013/2013-04-25.parquet size: 5.0 MB rows: 333,714 symbols: 3,496
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-04-25 04:10:00 | AAPL | Stock | 14.5218 | 14.5354 | 14.5218 | 14.5354 | 20664.0 |
| 2013-04-25 04:15:00 | AAPL | Stock | 14.5339 | 14.5339 | 14.5339 | 14.5339 | 5600.0 |
| 2013-04-25 04:20:00 | AAPL | Stock | 14.5339 | 14.5339 | 14.5243 | 14.5243 | 9800.0 |
| 2013-04-25 04:25:00 | AAPL | Stock | 14.5243 | 14.5243 | 14.5243 | 14.5243 | 6720.0 |
| 2013-04-25 04:50:00 | AAPL | Stock | 14.5232 | 14.5232 | 14.5232 | 14.5232 | 5600.0 |
| 2013-04-25 04:55:00 | AAPL | Stock | 14.5136 | 14.5136 | 14.5136 | 14.5136 | 11200.0 |
| 2013-04-25 05:05:00 | AAPL | Stock | 14.5232 | 14.5232 | 14.5232 | 14.5232 | 5600.0 |
| 2013-04-25 05:10:00 | AAPL | Stock | 14.5254 | 14.5261 | 14.5229 | 14.5229 | 19600.0 |
| 2013-04-25 05:35:00 | AAPL | Stock | 14.5261 | 14.5261 | 14.5261 | 14.5261 | 5600.0 |
| 2013-04-25 06:20:00 | AAPL | Stock | 14.525 | 14.5411 | 14.525 | 14.5411 | 82404.0 |
| 2013-04-25 06:55:00 | AAPL | Stock | 14.5625 | 14.5625 | 14.5625 | 14.5625 | 2800.0 |
| 2013-04-25 07:00:00 | AAPL | Stock | 14.5418 | 14.5418 | 14.5357 | 14.5364 | 56336.0 |
| 2013-04-25 07:05:00 | AAPL | Stock | 14.5361 | 14.5368 | 14.535 | 14.535 | 21700.0 |
| 2013-04-25 07:10:00 | AAPL | Stock | 14.55 | 14.5857 | 14.55 | 14.5857 | 90160.0 |
| 2013-04-25 07:15:00 | AAPL | Stock | 14.5893 | 14.6071 | 14.5839 | 14.5893 | 102480.0 |
| 2013-04-25 07:20:00 | AAPL | Stock | 14.6 | 14.6207 | 14.5925 | 14.6018 | 160664.0 |
| 2013-04-25 07:25:00 | AAPL | Stock | 14.595 | 14.6071 | 14.5714 | 14.5854 | 230748.0 |
| 2013-04-25 07:30:00 | AAPL | Stock | 14.5768 | 14.5768 | 14.5625 | 14.5625 | 14000.0 |
| 2013-04-25 07:35:00 | AAPL | Stock | 14.5711 | 14.5711 | 14.5711 | 14.5711 | 11200.0 |
| 2013-04-25 07:40:00 | AAPL | Stock | 14.5711 | 14.5711 | 14.5368 | 14.5618 | 61320.0 |
| 2013-04-25 07:45:00 | AAPL | Stock | 14.56 | 14.56 | 14.5546 | 14.5546 | 5600.0 |
| 2013-04-25 07:50:00 | AAPL | Stock | 14.5625 | 14.5693 | 14.5625 | 14.5693 | 5600.0 |
| 2013-04-25 07:55:00 | AAPL | Stock | 14.5625 | 14.5625 | 14.5518 | 14.5625 | 16800.0 |
| 2013-04-25 08:00:00 | AAPL | Stock | 14.5518 | 14.6075 | 14.5271 | 14.5357 | 154812.0 |
| 2013-04-25 08:05:00 | AAPL | Stock | 14.5429 | 14.5536 | 14.5393 | 14.5536 | 141120.0 |
| 2013-04-25 08:10:00 | AAPL | Stock | 14.5668 | 14.5893 | 14.565 | 14.5739 | 150360.0 |
| 2013-04-25 08:15:00 | AAPL | Stock | 14.5732 | 14.5893 | 14.5654 | 14.5654 | 98056.0 |
| 2013-04-25 08:20:00 | AAPL | Stock | 14.5743 | 14.6014 | 14.5714 | 14.6007 | 62860.0 |
| 2013-04-25 08:25:00 | AAPL | Stock | 14.5964 | 14.6107 | 14.59 | 14.6071 | 241780.0 |
| 2013-04-25 08:30:00 | AAPL | Stock | 14.6068 | 14.6389 | 14.6068 | 14.6261 | 334656.0 |
| 2013-04-25 08:35:00 | AAPL | Stock | 14.63 | 14.63 | 14.6146 | 14.6161 | 436968.0 |
| 2013-04-25 08:40:00 | AAPL | Stock | 14.6129 | 14.6214 | 14.6121 | 14.6125 | 63700.0 |
| 2013-04-25 08:45:00 | AAPL | Stock | 14.6175 | 14.6393 | 14.6161 | 14.6389 | 202104.0 |
| 2013-04-25 08:50:00 | AAPL | Stock | 14.6346 | 14.6354 | 14.625 | 14.625 | 245588.0 |
| 2013-04-25 08:55:00 | AAPL | Stock | 14.625 | 14.6389 | 14.6161 | 14.6161 | 159600.0 |
| 2013-04-25 09:00:00 | AAPL | Stock | 14.6179 | 14.6243 | 14.6161 | 14.6243 | 183120.0 |
| 2013-04-25 09:05:00 | AAPL | Stock | 14.6214 | 14.64 | 14.6161 | 14.6357 | 550340.0 |
| 2013-04-25 09:10:00 | AAPL | Stock | 14.6357 | 14.6543 | 14.6168 | 14.6418 | 523432.0 |
| 2013-04-25 09:15:00 | AAPL | Stock | 14.6357 | 14.6429 | 14.6254 | 14.6254 | 107884.0 |
| 2013-04-25 09:20:00 | AAPL | Stock | 14.6275 | 14.6286 | 14.6089 | 14.6089 | 181132.0 |
| 2013-04-25 09:25:00 | AAPL | Stock | 14.6071 | 14.6982 | 14.5875 | 14.6982 | 1423044.0 |
| 2013-04-25 09:30:00 | AAPL | Stock | 14.6982 | 14.7836 | 14.6075 | 14.7143 | 31019156.0 |
| 2013-04-25 09:35:00 | AAPL | Stock | 14.7189 | 14.7418 | 14.6121 | 14.6336 | 15396752.0 |
| 2013-04-25 09:40:00 | AAPL | Stock | 14.6411 | 14.7286 | 14.63 | 14.6989 | 11688488.0 |
| 2013-04-25 09:45:00 | AAPL | Stock | 14.7 | 14.7429 | 14.6286 | 14.6854 | 10409896.0 |
| 2013-04-25 09:50:00 | AAPL | Stock | 14.6854 | 14.7121 | 14.6429 | 14.6593 | 7777700.0 |
| 2013-04-25 09:55:00 | AAPL | Stock | 14.6593 | 14.6793 | 14.5911 | 14.6129 | 9393860.0 |
| 2013-04-25 10:00:00 | AAPL | Stock | 14.6161 | 14.6429 | 14.6018 | 14.6052 | 6997676.0 |
| 2013-04-25 10:05:00 | AAPL | Stock | 14.6079 | 14.6232 | 14.5511 | 14.6155 | 9746996.0 |
| 2013-04-25 10:10:00 | AAPL | Stock | 14.6164 | 14.62 | 14.5718 | 14.6118 | 4357612.0 |
> showing 50 of 333,714 rows — these rows as CSV