PREVIEW / stock_5min / 2015-04-06
file: by_date/stock_5min/2015/2015-04-06.parquet size: 5.4 MB rows: 358,461 symbols: 3,526
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-04-06 04:00:00 | AAPL | Stock | 31.2825 | 31.305 | 31.2 | 31.2 | 12472.0 |
| 2015-04-06 04:15:00 | AAPL | Stock | 31.2 | 31.2 | 31.2 | 31.2 | 400.0 |
| 2015-04-06 04:20:00 | AAPL | Stock | 31.145 | 31.145 | 31.145 | 31.145 | 3200.0 |
| 2015-04-06 04:25:00 | AAPL | Stock | 31.125 | 31.125 | 31.125 | 31.125 | 1844.0 |
| 2015-04-06 04:35:00 | AAPL | Stock | 31.1275 | 31.1275 | 31.125 | 31.125 | 3596.0 |
| 2015-04-06 05:00:00 | AAPL | Stock | 31.125 | 31.125 | 31.125 | 31.125 | 1120.0 |
| 2015-04-06 05:10:00 | AAPL | Stock | 31.125 | 31.125 | 31.125 | 31.125 | 2000.0 |
| 2015-04-06 06:00:00 | AAPL | Stock | 31.15 | 31.15 | 31.1425 | 31.15 | 4404.0 |
| 2015-04-06 06:05:00 | AAPL | Stock | 31.125 | 31.125 | 31.1125 | 31.1125 | 4800.0 |
| 2015-04-06 06:15:00 | AAPL | Stock | 31.125 | 31.1425 | 31.125 | 31.1425 | 800.0 |
| 2015-04-06 06:40:00 | AAPL | Stock | 31.1375 | 31.1375 | 31.0925 | 31.0925 | 4800.0 |
| 2015-04-06 07:05:00 | AAPL | Stock | 31.135 | 31.155 | 31.135 | 31.15 | 28060.0 |
| 2015-04-06 07:10:00 | AAPL | Stock | 31.1425 | 31.1625 | 31.1425 | 31.1625 | 11600.0 |
| 2015-04-06 07:15:00 | AAPL | Stock | 31.13 | 31.1625 | 31.125 | 31.1375 | 17600.0 |
| 2015-04-06 07:20:00 | AAPL | Stock | 31.1425 | 31.1425 | 31.1425 | 31.1425 | 800.0 |
| 2015-04-06 07:25:00 | AAPL | Stock | 31.1375 | 31.14 | 31.125 | 31.1275 | 24720.0 |
| 2015-04-06 07:30:00 | AAPL | Stock | 31.13 | 31.17 | 31.1275 | 31.1525 | 29008.0 |
| 2015-04-06 07:40:00 | AAPL | Stock | 31.1525 | 31.1625 | 31.135 | 31.135 | 20592.0 |
| 2015-04-06 07:45:00 | AAPL | Stock | 31.14 | 31.15 | 31.14 | 31.15 | 8076.0 |
| 2015-04-06 07:50:00 | AAPL | Stock | 31.1525 | 31.16 | 31.15 | 31.16 | 3780.0 |
| 2015-04-06 07:55:00 | AAPL | Stock | 31.15 | 31.15 | 31.1425 | 31.15 | 3600.0 |
| 2015-04-06 08:00:00 | AAPL | Stock | 31.1575 | 31.165 | 31.1 | 31.125 | 186748.0 |
| 2015-04-06 08:05:00 | AAPL | Stock | 31.125 | 31.1325 | 31.1125 | 31.115 | 102628.0 |
| 2015-04-06 08:10:00 | AAPL | Stock | 31.1125 | 31.1175 | 31.105 | 31.105 | 24708.0 |
| 2015-04-06 08:15:00 | AAPL | Stock | 31.1075 | 31.1075 | 31.09 | 31.09 | 62824.0 |
| 2015-04-06 08:20:00 | AAPL | Stock | 31.0975 | 31.1025 | 31.09 | 31.09 | 32280.0 |
| 2015-04-06 08:25:00 | AAPL | Stock | 31.0875 | 31.095 | 31.085 | 31.0875 | 28280.0 |
| 2015-04-06 08:30:00 | AAPL | Stock | 31.0875 | 31.13 | 31.0875 | 31.125 | 61352.0 |
| 2015-04-06 08:35:00 | AAPL | Stock | 31.125 | 31.1322 | 31.0925 | 31.115 | 70360.0 |
| 2015-04-06 08:40:00 | AAPL | Stock | 31.1025 | 31.105 | 31.09 | 31.0925 | 30800.0 |
| 2015-04-06 08:45:00 | AAPL | Stock | 31.1 | 31.125 | 31.0925 | 31.1075 | 45972.0 |
| 2015-04-06 08:50:00 | AAPL | Stock | 31.1075 | 31.1175 | 31.095 | 31.1175 | 22000.0 |
| 2015-04-06 08:55:00 | AAPL | Stock | 31.12 | 31.1225 | 31.1125 | 31.1198 | 31576.0 |
| 2015-04-06 09:00:00 | AAPL | Stock | 31.115 | 31.12 | 31.115 | 31.115 | 28052.0 |
| 2015-04-06 09:05:00 | AAPL | Stock | 31.1175 | 31.125 | 31.115 | 31.125 | 22416.0 |
| 2015-04-06 09:10:00 | AAPL | Stock | 31.1225 | 31.125 | 31.1175 | 31.1225 | 36400.0 |
| 2015-04-06 09:15:00 | AAPL | Stock | 31.1275 | 31.1425 | 31.1225 | 31.1375 | 127604.0 |
| 2015-04-06 09:20:00 | AAPL | Stock | 31.13 | 31.1475 | 31.125 | 31.1475 | 33732.0 |
| 2015-04-06 09:25:00 | AAPL | Stock | 31.14 | 31.145 | 31.095 | 31.1175 | 243044.0 |
| 2015-04-06 09:30:00 | AAPL | Stock | 31.1175 | 31.24 | 31.0825 | 31.215 | 5459884.0 |
| 2015-04-06 09:35:00 | AAPL | Stock | 31.22 | 31.285 | 31.2025 | 31.2525 | 3263444.0 |
| 2015-04-06 09:40:00 | AAPL | Stock | 31.2525 | 31.34 | 31.2525 | 31.29 | 2712084.0 |
| 2015-04-06 09:45:00 | AAPL | Stock | 31.2915 | 31.4475 | 31.2915 | 31.4048 | 3893212.0 |
| 2015-04-06 09:50:00 | AAPL | Stock | 31.4038 | 31.4375 | 31.3725 | 31.4215 | 2492832.0 |
| 2015-04-06 09:55:00 | AAPL | Stock | 31.4225 | 31.4625 | 31.42 | 31.4475 | 2027552.0 |
| 2015-04-06 10:00:00 | AAPL | Stock | 31.4498 | 31.535 | 31.4498 | 31.505 | 3637160.0 |
| 2015-04-06 10:05:00 | AAPL | Stock | 31.5025 | 31.5975 | 31.5025 | 31.5525 | 3525672.0 |
| 2015-04-06 10:10:00 | AAPL | Stock | 31.5518 | 31.59 | 31.515 | 31.58 | 2686052.0 |
| 2015-04-06 10:15:00 | AAPL | Stock | 31.5825 | 31.7125 | 31.5775 | 31.685 | 4933824.0 |
| 2015-04-06 10:20:00 | AAPL | Stock | 31.6875 | 31.7655 | 31.6475 | 31.735 | 3826776.0 |
> showing 50 of 358,461 rows — these rows as CSV