PREVIEW / stock_5min / 2015-10-21
file: by_date/stock_5min/2015/2015-10-21.parquet size: 5.3 MB rows: 350,924 symbols: 3,411
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-10-21 04:50:00 | AAPL | Stock | 28.4275 | 28.4275 | 28.4275 | 28.4275 | 400.0 |
| 2015-10-21 05:00:00 | AAPL | Stock | 28.455 | 28.47 | 28.455 | 28.47 | 1600.0 |
| 2015-10-21 05:10:00 | AAPL | Stock | 28.495 | 28.495 | 28.4525 | 28.46 | 2096.0 |
| 2015-10-21 05:20:00 | AAPL | Stock | 28.495 | 28.495 | 28.495 | 28.495 | 1196.0 |
| 2015-10-21 05:30:00 | AAPL | Stock | 28.5125 | 28.5125 | 28.5125 | 28.5125 | 3840.0 |
| 2015-10-21 05:35:00 | AAPL | Stock | 28.4875 | 28.4875 | 28.4875 | 28.4875 | 800.0 |
| 2015-10-21 05:45:00 | AAPL | Stock | 28.4875 | 28.4875 | 28.4875 | 28.4875 | 400.0 |
| 2015-10-21 05:50:00 | AAPL | Stock | 28.4925 | 28.4925 | 28.4925 | 28.4925 | 400.0 |
| 2015-10-21 05:55:00 | AAPL | Stock | 28.4775 | 28.4775 | 28.4775 | 28.4775 | 1352.0 |
| 2015-10-21 06:00:00 | AAPL | Stock | 28.4875 | 28.4925 | 28.4875 | 28.4925 | 3200.0 |
| 2015-10-21 06:05:00 | AAPL | Stock | 28.495 | 28.495 | 28.495 | 28.495 | 400.0 |
| 2015-10-21 06:10:00 | AAPL | Stock | 28.5 | 28.5 | 28.48 | 28.48 | 4400.0 |
| 2015-10-21 06:15:00 | AAPL | Stock | 28.5 | 28.5175 | 28.5 | 28.5175 | 3800.0 |
| 2015-10-21 06:20:00 | AAPL | Stock | 28.52 | 28.525 | 28.52 | 28.525 | 1200.0 |
| 2015-10-21 06:25:00 | AAPL | Stock | 28.5225 | 28.5225 | 28.5225 | 28.5225 | 800.0 |
| 2015-10-21 06:30:00 | AAPL | Stock | 28.525 | 28.525 | 28.525 | 28.525 | 400.0 |
| 2015-10-21 06:35:00 | AAPL | Stock | 28.52 | 28.525 | 28.52 | 28.52 | 2400.0 |
| 2015-10-21 06:40:00 | AAPL | Stock | 28.525 | 28.525 | 28.52 | 28.52 | 4344.0 |
| 2015-10-21 06:45:00 | AAPL | Stock | 28.52 | 28.52 | 28.52 | 28.52 | 848.0 |
| 2015-10-21 06:55:00 | AAPL | Stock | 28.5225 | 28.525 | 28.5 | 28.5 | 9312.0 |
| 2015-10-21 07:00:00 | AAPL | Stock | 28.4825 | 28.4825 | 28.48 | 28.48 | 800.0 |
| 2015-10-21 07:05:00 | AAPL | Stock | 28.465 | 28.465 | 28.4625 | 28.4625 | 1688.0 |
| 2015-10-21 07:10:00 | AAPL | Stock | 28.4625 | 28.4625 | 28.4625 | 28.4625 | 400.0 |
| 2015-10-21 07:15:00 | AAPL | Stock | 28.4625 | 28.4625 | 28.4625 | 28.4625 | 2832.0 |
| 2015-10-21 07:30:00 | AAPL | Stock | 28.4675 | 28.47 | 28.4675 | 28.47 | 1200.0 |
| 2015-10-21 07:35:00 | AAPL | Stock | 28.475 | 28.4825 | 28.475 | 28.4825 | 4072.0 |
| 2015-10-21 07:40:00 | AAPL | Stock | 28.465 | 28.465 | 28.45 | 28.4625 | 5600.0 |
| 2015-10-21 07:45:00 | AAPL | Stock | 28.455 | 28.455 | 28.44 | 28.4425 | 13312.0 |
| 2015-10-21 07:50:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.4375 | 28.4375 | 2800.0 |
| 2015-10-21 07:55:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.4325 | 28.4325 | 4800.0 |
| 2015-10-21 08:00:00 | AAPL | Stock | 28.4175 | 28.52 | 28.4025 | 28.4325 | 76628.0 |
| 2015-10-21 08:05:00 | AAPL | Stock | 28.435 | 28.435 | 28.405 | 28.405 | 21720.0 |
| 2015-10-21 08:10:00 | AAPL | Stock | 28.4 | 28.4 | 28.3775 | 28.38 | 36800.0 |
| 2015-10-21 08:15:00 | AAPL | Stock | 28.38 | 28.39 | 28.3575 | 28.39 | 37204.0 |
| 2015-10-21 08:20:00 | AAPL | Stock | 28.4 | 28.41 | 28.3975 | 28.4075 | 36468.0 |
| 2015-10-21 08:25:00 | AAPL | Stock | 28.4075 | 28.42 | 28.4 | 28.4 | 31560.0 |
| 2015-10-21 08:30:00 | AAPL | Stock | 28.4125 | 28.425 | 28.4125 | 28.425 | 31144.0 |
| 2015-10-21 08:35:00 | AAPL | Stock | 28.435 | 28.4425 | 28.4175 | 28.4375 | 30228.0 |
| 2015-10-21 08:40:00 | AAPL | Stock | 28.43 | 28.4625 | 28.43 | 28.4625 | 65172.0 |
| 2015-10-21 08:45:00 | AAPL | Stock | 28.4625 | 28.475 | 28.45 | 28.475 | 59008.0 |
| 2015-10-21 08:50:00 | AAPL | Stock | 28.4675 | 28.475 | 28.4675 | 28.475 | 5000.0 |
| 2015-10-21 08:55:00 | AAPL | Stock | 28.47 | 28.475 | 28.46 | 28.475 | 42992.0 |
| 2015-10-21 09:00:00 | AAPL | Stock | 28.475 | 28.485 | 28.4625 | 28.4725 | 17108.0 |
| 2015-10-21 09:05:00 | AAPL | Stock | 28.4725 | 28.4725 | 28.43 | 28.4375 | 44404.0 |
| 2015-10-21 09:10:00 | AAPL | Stock | 28.4375 | 28.4475 | 28.4375 | 28.4375 | 20000.0 |
| 2015-10-21 09:15:00 | AAPL | Stock | 28.445 | 28.445 | 28.4275 | 28.4275 | 31360.0 |
| 2015-10-21 09:20:00 | AAPL | Stock | 28.4325 | 28.4375 | 28.43 | 28.43 | 16288.0 |
| 2015-10-21 09:25:00 | AAPL | Stock | 28.435 | 28.5 | 28.425 | 28.48 | 697816.0 |
| 2015-10-21 09:30:00 | AAPL | Stock | 28.49 | 28.5325 | 28.425 | 28.52 | 6177520.0 |
| 2015-10-21 09:35:00 | AAPL | Stock | 28.5175 | 28.5875 | 28.45 | 28.4875 | 5302592.0 |
> showing 50 of 350,924 rows — these rows as CSV