PREVIEW / stock_5min / 2015-04-10
file: by_date/stock_5min/2015/2015-04-10.parquet size: 5.3 MB rows: 351,658 symbols: 3,511
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-10 04:00:00 | AAPL | Stock | 31.5625 | 31.5975 | 31.4625 | 31.4625 | 45048.0 |
| 2015-04-10 04:10:00 | AAPL | Stock | 31.4775 | 31.5 | 31.465 | 31.5 | 9688.0 |
| 2015-04-10 04:15:00 | AAPL | Stock | 31.545 | 31.545 | 31.545 | 31.545 | 716.0 |
| 2015-04-10 04:20:00 | AAPL | Stock | 31.545 | 31.545 | 31.5225 | 31.5225 | 4524.0 |
| 2015-04-10 04:25:00 | AAPL | Stock | 31.5225 | 31.5225 | 31.4975 | 31.5 | 9280.0 |
| 2015-04-10 04:30:00 | AAPL | Stock | 31.5 | 31.5 | 31.4725 | 31.4725 | 2204.0 |
| 2015-04-10 04:35:00 | AAPL | Stock | 31.5 | 31.5025 | 31.4475 | 31.45 | 14568.0 |
| 2015-04-10 04:45:00 | AAPL | Stock | 31.4525 | 31.4525 | 31.375 | 31.375 | 8400.0 |
| 2015-04-10 04:50:00 | AAPL | Stock | 31.345 | 31.3775 | 31.2625 | 31.3775 | 11636.0 |
| 2015-04-10 04:55:00 | AAPL | Stock | 31.3775 | 31.3775 | 31.3775 | 31.3775 | 1600.0 |
| 2015-04-10 05:00:00 | AAPL | Stock | 31.4 | 31.4 | 31.4 | 31.4 | 8000.0 |
| 2015-04-10 05:05:00 | AAPL | Stock | 31.3775 | 31.3775 | 31.3775 | 31.3775 | 4120.0 |
| 2015-04-10 05:30:00 | AAPL | Stock | 31.42 | 31.42 | 31.42 | 31.42 | 1200.0 |
| 2015-04-10 05:35:00 | AAPL | Stock | 31.4125 | 31.4125 | 31.4125 | 31.4125 | 800.0 |
| 2015-04-10 05:40:00 | AAPL | Stock | 31.4 | 31.4125 | 31.4 | 31.4125 | 2412.0 |
| 2015-04-10 05:45:00 | AAPL | Stock | 31.4125 | 31.425 | 31.3775 | 31.3775 | 3200.0 |
| 2015-04-10 05:55:00 | AAPL | Stock | 31.4125 | 31.4125 | 31.4 | 31.4 | 3520.0 |
| 2015-04-10 06:00:00 | AAPL | Stock | 31.4725 | 31.52 | 31.455 | 31.5175 | 41472.0 |
| 2015-04-10 06:05:00 | AAPL | Stock | 31.495 | 31.495 | 31.44 | 31.44 | 13984.0 |
| 2015-04-10 06:10:00 | AAPL | Stock | 31.45 | 31.45 | 31.4125 | 31.425 | 14564.0 |
| 2015-04-10 06:15:00 | AAPL | Stock | 31.425 | 31.425 | 31.425 | 31.425 | 800.0 |
| 2015-04-10 06:25:00 | AAPL | Stock | 31.44 | 31.44 | 31.425 | 31.4325 | 5320.0 |
| 2015-04-10 06:30:00 | AAPL | Stock | 31.415 | 31.415 | 31.4125 | 31.4125 | 1200.0 |
| 2015-04-10 06:35:00 | AAPL | Stock | 31.435 | 31.4375 | 31.4125 | 31.4375 | 5296.0 |
| 2015-04-10 06:40:00 | AAPL | Stock | 31.4175 | 31.42 | 31.4125 | 31.4125 | 7024.0 |
| 2015-04-10 06:45:00 | AAPL | Stock | 31.4125 | 31.4375 | 31.4125 | 31.4375 | 6888.0 |
| 2015-04-10 06:50:00 | AAPL | Stock | 31.4275 | 31.4275 | 31.42 | 31.42 | 3960.0 |
| 2015-04-10 06:55:00 | AAPL | Stock | 31.4125 | 31.4125 | 31.4125 | 31.4125 | 400.0 |
| 2015-04-10 07:00:00 | AAPL | Stock | 31.425 | 31.475 | 31.425 | 31.46 | 23756.0 |
| 2015-04-10 07:05:00 | AAPL | Stock | 31.4725 | 31.4775 | 31.43 | 31.43 | 53156.0 |
| 2015-04-10 07:10:00 | AAPL | Stock | 31.44 | 31.4625 | 31.4225 | 31.445 | 36796.0 |
| 2015-04-10 07:15:00 | AAPL | Stock | 31.45 | 31.4875 | 31.45 | 31.4875 | 49028.0 |
| 2015-04-10 07:20:00 | AAPL | Stock | 31.475 | 31.48 | 31.4525 | 31.48 | 14312.0 |
| 2015-04-10 07:25:00 | AAPL | Stock | 31.49 | 31.5 | 31.4875 | 31.495 | 19600.0 |
| 2015-04-10 07:30:00 | AAPL | Stock | 31.48 | 31.4825 | 31.475 | 31.4825 | 21120.0 |
| 2015-04-10 07:35:00 | AAPL | Stock | 31.495 | 31.5 | 31.475 | 31.495 | 68772.0 |
| 2015-04-10 07:40:00 | AAPL | Stock | 31.495 | 31.5225 | 31.475 | 31.515 | 115604.0 |
| 2015-04-10 07:45:00 | AAPL | Stock | 31.5075 | 31.5275 | 31.5 | 31.5175 | 132880.0 |
| 2015-04-10 07:50:00 | AAPL | Stock | 31.5225 | 31.525 | 31.5125 | 31.5125 | 6400.0 |
| 2015-04-10 07:55:00 | AAPL | Stock | 31.525 | 31.5375 | 31.4775 | 31.4775 | 68100.0 |
| 2015-04-10 08:00:00 | AAPL | Stock | 31.5 | 31.5262 | 31.425 | 31.51 | 239504.0 |
| 2015-04-10 08:05:00 | AAPL | Stock | 31.51 | 31.5375 | 31.51 | 31.525 | 101664.0 |
| 2015-04-10 08:10:00 | AAPL | Stock | 31.525 | 31.545 | 31.5175 | 31.5175 | 32872.0 |
| 2015-04-10 08:15:00 | AAPL | Stock | 31.5225 | 31.5225 | 31.475 | 31.495 | 55612.0 |
| 2015-04-10 08:20:00 | AAPL | Stock | 31.495 | 31.505 | 31.475 | 31.4875 | 80240.0 |
| 2015-04-10 08:25:00 | AAPL | Stock | 31.4825 | 31.5125 | 31.4825 | 31.4875 | 40680.0 |
| 2015-04-10 08:30:00 | AAPL | Stock | 31.4875 | 31.51 | 31.4875 | 31.5025 | 24128.0 |
| 2015-04-10 08:35:00 | AAPL | Stock | 31.5025 | 31.5225 | 31.5025 | 31.505 | 72104.0 |
| 2015-04-10 08:40:00 | AAPL | Stock | 31.51 | 31.51 | 31.495 | 31.5 | 79920.0 |
| 2015-04-10 08:45:00 | AAPL | Stock | 31.505 | 31.51 | 31.4775 | 31.49 | 93352.0 |
> showing 50 of 351,658 rows — these rows as CSV