PREVIEW / stock_5min / 2015-05-20
file: by_date/stock_5min/2015/2015-05-20.parquet size: 5.4 MB rows: 358,055 symbols: 3,517
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 |
|---|---|---|---|---|---|---|---|
| 2015-05-20 04:00:00 | AAPL | Stock | 32.575 | 32.61 | 32.565 | 32.565 | 4200.0 |
| 2015-05-20 04:30:00 | AAPL | Stock | 32.5575 | 32.5575 | 32.5575 | 32.5575 | 800.0 |
| 2015-05-20 04:50:00 | AAPL | Stock | 32.5625 | 32.5625 | 32.5625 | 32.5625 | 452.0 |
| 2015-05-20 04:55:00 | AAPL | Stock | 32.5625 | 32.5625 | 32.5625 | 32.5625 | 15200.0 |
| 2015-05-20 05:00:00 | AAPL | Stock | 32.575 | 32.575 | 32.575 | 32.575 | 2000.0 |
| 2015-05-20 05:15:00 | AAPL | Stock | 32.5725 | 32.5725 | 32.5725 | 32.5725 | 400.0 |
| 2015-05-20 05:25:00 | AAPL | Stock | 32.5825 | 32.5825 | 32.5825 | 32.5825 | 400.0 |
| 2015-05-20 05:30:00 | AAPL | Stock | 32.575 | 32.575 | 32.575 | 32.575 | 4000.0 |
| 2015-05-20 05:35:00 | AAPL | Stock | 32.565 | 32.565 | 32.565 | 32.565 | 2064.0 |
| 2015-05-20 05:40:00 | AAPL | Stock | 32.565 | 32.565 | 32.5575 | 32.5575 | 2000.0 |
| 2015-05-20 06:00:00 | AAPL | Stock | 32.58 | 32.58 | 32.56 | 32.56 | 2400.0 |
| 2015-05-20 06:15:00 | AAPL | Stock | 32.5825 | 32.5875 | 32.5825 | 32.5875 | 1600.0 |
| 2015-05-20 06:25:00 | AAPL | Stock | 32.5875 | 32.5875 | 32.5875 | 32.5875 | 400.0 |
| 2015-05-20 06:35:00 | AAPL | Stock | 32.5875 | 32.5875 | 32.5875 | 32.5875 | 1652.0 |
| 2015-05-20 06:40:00 | AAPL | Stock | 32.5875 | 32.5875 | 32.5775 | 32.5775 | 1752.0 |
| 2015-05-20 06:45:00 | AAPL | Stock | 32.6225 | 32.6225 | 32.6 | 32.6 | 10600.0 |
| 2015-05-20 06:50:00 | AAPL | Stock | 32.6025 | 32.6025 | 32.6 | 32.6 | 1900.0 |
| 2015-05-20 06:55:00 | AAPL | Stock | 32.6 | 32.6 | 32.6 | 32.6 | 10020.0 |
| 2015-05-20 07:00:00 | AAPL | Stock | 32.6 | 32.6 | 32.6 | 32.6 | 1872.0 |
| 2015-05-20 07:05:00 | AAPL | Stock | 32.565 | 32.565 | 32.5375 | 32.5375 | 13128.0 |
| 2015-05-20 07:10:00 | AAPL | Stock | 32.5475 | 32.575 | 32.5475 | 32.575 | 7284.0 |
| 2015-05-20 07:15:00 | AAPL | Stock | 32.5875 | 32.595 | 32.5875 | 32.595 | 9612.0 |
| 2015-05-20 07:20:00 | AAPL | Stock | 32.565 | 32.565 | 32.565 | 32.565 | 800.0 |
| 2015-05-20 07:35:00 | AAPL | Stock | 32.5675 | 32.5875 | 32.5675 | 32.5875 | 8600.0 |
| 2015-05-20 07:55:00 | AAPL | Stock | 32.5675 | 32.575 | 32.5675 | 32.575 | 4524.0 |
| 2015-05-20 08:00:00 | AAPL | Stock | 32.575 | 32.6 | 32.5625 | 32.5625 | 70660.0 |
| 2015-05-20 08:05:00 | AAPL | Stock | 32.5625 | 32.57 | 32.5625 | 32.57 | 8112.0 |
| 2015-05-20 08:10:00 | AAPL | Stock | 32.5625 | 32.565 | 32.55 | 32.565 | 36976.0 |
| 2015-05-20 08:15:00 | AAPL | Stock | 32.5475 | 32.5475 | 32.545 | 32.545 | 2400.0 |
| 2015-05-20 08:20:00 | AAPL | Stock | 32.5575 | 32.5575 | 32.5525 | 32.5525 | 1600.0 |
| 2015-05-20 08:25:00 | AAPL | Stock | 32.56 | 32.56 | 32.5475 | 32.55 | 28124.0 |
| 2015-05-20 08:30:00 | AAPL | Stock | 32.55 | 32.55 | 32.515 | 32.535 | 39888.0 |
| 2015-05-20 08:35:00 | AAPL | Stock | 32.5275 | 32.5275 | 32.52 | 32.525 | 7604.0 |
| 2015-05-20 08:40:00 | AAPL | Stock | 32.5275 | 32.535 | 32.5225 | 32.5325 | 27780.0 |
| 2015-05-20 08:45:00 | AAPL | Stock | 32.5375 | 32.55 | 32.5375 | 32.55 | 11600.0 |
| 2015-05-20 08:50:00 | AAPL | Stock | 32.5575 | 32.5775 | 32.5525 | 32.56 | 58980.0 |
| 2015-05-20 08:55:00 | AAPL | Stock | 32.5525 | 32.575 | 32.5525 | 32.565 | 15704.0 |
| 2015-05-20 09:00:00 | AAPL | Stock | 32.56 | 32.56 | 32.56 | 32.56 | 400.0 |
| 2015-05-20 09:05:00 | AAPL | Stock | 32.5675 | 32.57 | 32.5575 | 32.57 | 36812.0 |
| 2015-05-20 09:10:00 | AAPL | Stock | 32.5672 | 32.5675 | 32.5625 | 32.5625 | 19768.0 |
| 2015-05-20 09:15:00 | AAPL | Stock | 32.5675 | 32.575 | 32.565 | 32.565 | 21204.0 |
| 2015-05-20 09:20:00 | AAPL | Stock | 32.565 | 32.575 | 32.565 | 32.565 | 28400.0 |
| 2015-05-20 09:25:00 | AAPL | Stock | 32.58 | 32.5825 | 32.5 | 32.5 | 113988.0 |
| 2015-05-20 09:30:00 | AAPL | Stock | 32.5 | 32.5475 | 32.46 | 32.4875 | 4977800.0 |
| 2015-05-20 09:35:00 | AAPL | Stock | 32.4875 | 32.5225 | 32.43 | 32.4315 | 3091368.0 |
| 2015-05-20 09:40:00 | AAPL | Stock | 32.4325 | 32.47 | 32.335 | 32.3375 | 4085388.0 |
| 2015-05-20 09:45:00 | AAPL | Stock | 32.3375 | 32.428 | 32.3352 | 32.415 | 2917436.0 |
| 2015-05-20 09:50:00 | AAPL | Stock | 32.415 | 32.44 | 32.3875 | 32.3975 | 1908708.0 |
| 2015-05-20 09:55:00 | AAPL | Stock | 32.395 | 32.4425 | 32.39 | 32.4275 | 2095472.0 |
| 2015-05-20 10:00:00 | AAPL | Stock | 32.43 | 32.4875 | 32.405 | 32.48 | 2186032.0 |
> showing 50 of 358,055 rows — these rows as CSV