PREVIEW / stock_5min / 2016-06-13
file: by_date/stock_5min/2016/2016-06-13.parquet size: 5.4 MB rows: 363,215 symbols: 3,296
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 |
|---|---|---|---|---|---|---|---|
| 2016-06-13 04:00:00 | AAPL | Stock | 24.71 | 24.71 | 24.625 | 24.625 | 9560.0 |
| 2016-06-13 04:10:00 | AAPL | Stock | 24.6125 | 24.6125 | 24.6125 | 24.6125 | 512.0 |
| 2016-06-13 04:30:00 | AAPL | Stock | 24.5625 | 24.5625 | 24.55 | 24.55 | 3308.0 |
| 2016-06-13 04:35:00 | AAPL | Stock | 24.55 | 24.55 | 24.525 | 24.525 | 2220.0 |
| 2016-06-13 05:05:00 | AAPL | Stock | 24.505 | 24.505 | 24.505 | 24.505 | 452.0 |
| 2016-06-13 05:10:00 | AAPL | Stock | 24.505 | 24.505 | 24.475 | 24.475 | 1652.0 |
| 2016-06-13 05:35:00 | AAPL | Stock | 24.49 | 24.49 | 24.49 | 24.49 | 400.0 |
| 2016-06-13 05:50:00 | AAPL | Stock | 24.4875 | 24.4875 | 24.4875 | 24.4875 | 400.0 |
| 2016-06-13 06:00:00 | AAPL | Stock | 24.525 | 24.53 | 24.525 | 24.53 | 800.0 |
| 2016-06-13 06:05:00 | AAPL | Stock | 24.54 | 24.55 | 24.54 | 24.55 | 4324.0 |
| 2016-06-13 06:10:00 | AAPL | Stock | 24.525 | 24.55 | 24.525 | 24.55 | 4800.0 |
| 2016-06-13 06:15:00 | AAPL | Stock | 24.55 | 24.55 | 24.55 | 24.55 | 4000.0 |
| 2016-06-13 06:30:00 | AAPL | Stock | 24.5625 | 24.5625 | 24.55 | 24.55 | 3600.0 |
| 2016-06-13 07:00:00 | AAPL | Stock | 24.5625 | 24.575 | 24.55 | 24.5625 | 10508.0 |
| 2016-06-13 07:05:00 | AAPL | Stock | 24.575 | 24.575 | 24.4775 | 24.485 | 36972.0 |
| 2016-06-13 07:10:00 | AAPL | Stock | 24.5 | 24.51 | 24.4 | 24.4 | 65196.0 |
| 2016-06-13 07:15:00 | AAPL | Stock | 24.4 | 24.425 | 24.3725 | 24.4 | 20900.0 |
| 2016-06-13 07:20:00 | AAPL | Stock | 24.4225 | 24.46 | 24.4225 | 24.46 | 28980.0 |
| 2016-06-13 07:25:00 | AAPL | Stock | 24.4425 | 24.4625 | 24.4425 | 24.4625 | 22480.0 |
| 2016-06-13 07:30:00 | AAPL | Stock | 24.4625 | 24.5 | 24.4625 | 24.5 | 23824.0 |
| 2016-06-13 07:40:00 | AAPL | Stock | 24.5125 | 24.5125 | 24.475 | 24.475 | 1184.0 |
| 2016-06-13 07:45:00 | AAPL | Stock | 24.5 | 24.5 | 24.475 | 24.475 | 5940.0 |
| 2016-06-13 07:50:00 | AAPL | Stock | 24.4975 | 24.5 | 24.4975 | 24.5 | 13332.0 |
| 2016-06-13 07:55:00 | AAPL | Stock | 24.52 | 24.52 | 24.52 | 24.52 | 1276.0 |
| 2016-06-13 08:00:00 | AAPL | Stock | 24.5125 | 24.5625 | 24.425 | 24.525 | 40680.0 |
| 2016-06-13 08:05:00 | AAPL | Stock | 24.53 | 24.5325 | 24.45 | 24.5225 | 82888.0 |
| 2016-06-13 08:10:00 | AAPL | Stock | 24.5225 | 24.5225 | 24.5225 | 24.5225 | 800.0 |
| 2016-06-13 08:15:00 | AAPL | Stock | 24.5125 | 24.5325 | 24.5125 | 24.5325 | 5224.0 |
| 2016-06-13 08:20:00 | AAPL | Stock | 24.5375 | 24.545 | 24.5375 | 24.5425 | 10800.0 |
| 2016-06-13 08:25:00 | AAPL | Stock | 24.5425 | 24.5425 | 24.5275 | 24.5275 | 13584.0 |
| 2016-06-13 08:30:00 | AAPL | Stock | 24.5375 | 24.5625 | 24.5375 | 24.5625 | 28196.0 |
| 2016-06-13 08:35:00 | AAPL | Stock | 24.5475 | 24.55 | 24.5425 | 24.545 | 21928.0 |
| 2016-06-13 08:40:00 | AAPL | Stock | 24.545 | 24.5525 | 24.5375 | 24.55 | 25432.0 |
| 2016-06-13 08:45:00 | AAPL | Stock | 24.5475 | 24.5575 | 24.545 | 24.545 | 24824.0 |
| 2016-06-13 08:50:00 | AAPL | Stock | 24.55 | 24.56 | 24.55 | 24.56 | 8948.0 |
| 2016-06-13 08:55:00 | AAPL | Stock | 24.5425 | 24.575 | 24.5425 | 24.5625 | 26324.0 |
| 2016-06-13 09:00:00 | AAPL | Stock | 24.5525 | 24.56 | 24.5375 | 24.5575 | 18660.0 |
| 2016-06-13 09:05:00 | AAPL | Stock | 24.56 | 24.5825 | 24.5575 | 24.5725 | 32580.0 |
| 2016-06-13 09:10:00 | AAPL | Stock | 24.575 | 24.6125 | 24.575 | 24.6 | 79648.0 |
| 2016-06-13 09:15:00 | AAPL | Stock | 24.61 | 24.6225 | 24.5825 | 24.5825 | 27540.0 |
| 2016-06-13 09:20:00 | AAPL | Stock | 24.5825 | 24.6 | 24.575 | 24.5875 | 38660.0 |
| 2016-06-13 09:25:00 | AAPL | Stock | 24.6 | 24.6725 | 24.6 | 24.65 | 94036.0 |
| 2016-06-13 09:30:00 | AAPL | Stock | 24.65 | 24.78 | 24.645 | 24.705 | 5006504.0 |
| 2016-06-13 09:35:00 | AAPL | Stock | 24.705 | 24.72 | 24.5125 | 24.5175 | 3859232.0 |
| 2016-06-13 09:40:00 | AAPL | Stock | 24.52 | 24.5225 | 24.42 | 24.4225 | 4799212.0 |
| 2016-06-13 09:45:00 | AAPL | Stock | 24.42 | 24.5 | 24.4125 | 24.4875 | 3099444.0 |
| 2016-06-13 09:50:00 | AAPL | Stock | 24.4875 | 24.5225 | 24.45 | 24.4575 | 2956176.0 |
| 2016-06-13 09:55:00 | AAPL | Stock | 24.455 | 24.465 | 24.3825 | 24.42 | 3406964.0 |
| 2016-06-13 10:00:00 | AAPL | Stock | 24.42 | 24.475 | 24.3425 | 24.345 | 3388064.0 |
| 2016-06-13 10:05:00 | AAPL | Stock | 24.3475 | 24.3775 | 24.3 | 24.3125 | 3054788.0 |
> showing 50 of 363,215 rows — these rows as CSV