PREVIEW / stock_5min / 2019-02-27
file: by_date/stock_5min/2019/2019-02-27.parquet size: 5.6 MB rows: 358,424 symbols: 2,656
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-27 04:10:00 | AAPL | Stock | 43.415 | 43.415 | 43.415 | 43.415 | 1072.0 |
| 2019-02-27 04:15:00 | AAPL | Stock | 43.4175 | 43.4175 | 43.4175 | 43.4175 | 980.0 |
| 2019-02-27 04:45:00 | AAPL | Stock | 43.4475 | 43.4475 | 43.4475 | 43.4475 | 1276.0 |
| 2019-02-27 05:10:00 | AAPL | Stock | 43.4225 | 43.4225 | 43.42 | 43.42 | 1024.0 |
| 2019-02-27 05:30:00 | AAPL | Stock | 43.3975 | 43.3975 | 43.3925 | 43.3925 | 800.0 |
| 2019-02-27 05:35:00 | AAPL | Stock | 43.4 | 43.42 | 43.4 | 43.42 | 2000.0 |
| 2019-02-27 05:40:00 | AAPL | Stock | 43.445 | 43.445 | 43.445 | 43.445 | 1056.0 |
| 2019-02-27 06:25:00 | AAPL | Stock | 43.445 | 43.445 | 43.445 | 43.445 | 800.0 |
| 2019-02-27 06:30:00 | AAPL | Stock | 43.445 | 43.445 | 43.445 | 43.445 | 1600.0 |
| 2019-02-27 06:45:00 | AAPL | Stock | 43.4 | 43.405 | 43.4 | 43.405 | 2004.0 |
| 2019-02-27 07:00:00 | AAPL | Stock | 43.465 | 43.5275 | 43.45 | 43.5275 | 4564.0 |
| 2019-02-27 07:05:00 | AAPL | Stock | 43.5125 | 43.5125 | 43.47 | 43.47 | 4992.0 |
| 2019-02-27 07:15:00 | AAPL | Stock | 43.4875 | 43.4875 | 43.4875 | 43.4875 | 520.0 |
| 2019-02-27 07:20:00 | AAPL | Stock | 43.4825 | 43.4825 | 43.475 | 43.475 | 1600.0 |
| 2019-02-27 07:30:00 | AAPL | Stock | 43.505 | 43.5225 | 43.505 | 43.5125 | 10600.0 |
| 2019-02-27 07:40:00 | AAPL | Stock | 43.5125 | 43.5125 | 43.5 | 43.5 | 10128.0 |
| 2019-02-27 07:45:00 | AAPL | Stock | 43.5075 | 43.5075 | 43.485 | 43.485 | 1600.0 |
| 2019-02-27 07:50:00 | AAPL | Stock | 43.48 | 43.495 | 43.47 | 43.475 | 6604.0 |
| 2019-02-27 07:55:00 | AAPL | Stock | 43.475 | 43.475 | 43.475 | 43.475 | 400.0 |
| 2019-02-27 08:00:00 | AAPL | Stock | 43.4875 | 43.69 | 43.43 | 43.45 | 38180.0 |
| 2019-02-27 08:05:00 | AAPL | Stock | 43.4375 | 43.4675 | 43.4375 | 43.45 | 7832.0 |
| 2019-02-27 08:10:00 | AAPL | Stock | 43.45 | 43.46 | 43.45 | 43.46 | 2200.0 |
| 2019-02-27 08:15:00 | AAPL | Stock | 43.465 | 43.465 | 43.45 | 43.455 | 12624.0 |
| 2019-02-27 08:20:00 | AAPL | Stock | 43.485 | 43.485 | 43.4 | 43.4 | 12952.0 |
| 2019-02-27 08:25:00 | AAPL | Stock | 43.44 | 43.45 | 43.41 | 43.45 | 9764.0 |
| 2019-02-27 08:30:00 | AAPL | Stock | 43.4625 | 43.4675 | 43.4375 | 43.4375 | 10224.0 |
| 2019-02-27 08:35:00 | AAPL | Stock | 43.4625 | 43.495 | 43.4625 | 43.495 | 7980.0 |
| 2019-02-27 08:40:00 | AAPL | Stock | 43.4775 | 43.495 | 43.465 | 43.465 | 6320.0 |
| 2019-02-27 08:45:00 | AAPL | Stock | 43.4625 | 43.4675 | 43.4625 | 43.4625 | 4800.0 |
| 2019-02-27 08:50:00 | AAPL | Stock | 43.4425 | 43.4425 | 43.4275 | 43.4375 | 10196.0 |
| 2019-02-27 08:55:00 | AAPL | Stock | 43.4375 | 43.5825 | 43.415 | 43.415 | 473636.0 |
| 2019-02-27 09:00:00 | AAPL | Stock | 43.4225 | 43.45 | 43.415 | 43.45 | 6280.0 |
| 2019-02-27 09:05:00 | AAPL | Stock | 43.4575 | 43.485 | 43.4525 | 43.4625 | 7576.0 |
| 2019-02-27 09:10:00 | AAPL | Stock | 43.4725 | 43.4725 | 43.425 | 43.45 | 7476.0 |
| 2019-02-27 09:15:00 | AAPL | Stock | 43.45 | 43.4725 | 43.4225 | 43.4225 | 18896.0 |
| 2019-02-27 09:20:00 | AAPL | Stock | 43.4375 | 43.47 | 43.42 | 43.425 | 14472.0 |
| 2019-02-27 09:25:00 | AAPL | Stock | 43.41 | 43.43 | 43.315 | 43.3375 | 88332.0 |
| 2019-02-27 09:30:00 | AAPL | Stock | 43.315 | 43.6625 | 43.3025 | 43.6175 | 3361324.0 |
| 2019-02-27 09:35:00 | AAPL | Stock | 43.6128 | 43.66 | 43.6 | 43.64 | 1227172.0 |
| 2019-02-27 09:40:00 | AAPL | Stock | 43.64 | 43.725 | 43.61 | 43.635 | 1591528.0 |
| 2019-02-27 09:45:00 | AAPL | Stock | 43.6375 | 43.645 | 43.585 | 43.6225 | 880104.0 |
| 2019-02-27 09:50:00 | AAPL | Stock | 43.625 | 43.6392 | 43.5525 | 43.5935 | 1293152.0 |
| 2019-02-27 09:55:00 | AAPL | Stock | 43.595 | 43.595 | 43.5025 | 43.51 | 1139696.0 |
| 2019-02-27 10:00:00 | AAPL | Stock | 43.5125 | 43.5612 | 43.475 | 43.4873 | 1107856.0 |
| 2019-02-27 10:05:00 | AAPL | Stock | 43.485 | 43.5225 | 43.4485 | 43.5188 | 870816.0 |
| 2019-02-27 10:10:00 | AAPL | Stock | 43.5175 | 43.5175 | 43.375 | 43.42 | 2281160.0 |
| 2019-02-27 10:15:00 | AAPL | Stock | 43.4225 | 43.4275 | 43.32 | 43.4075 | 1425592.0 |
| 2019-02-27 10:20:00 | AAPL | Stock | 43.4088 | 43.4475 | 43.3175 | 43.3425 | 756988.0 |
| 2019-02-27 10:25:00 | AAPL | Stock | 43.3425 | 43.3438 | 43.2128 | 43.265 | 1713364.0 |
| 2019-02-27 10:30:00 | AAPL | Stock | 43.27 | 43.3038 | 43.2025 | 43.22 | 1329852.0 |
> showing 50 of 358,424 rows — these rows as CSV