PREVIEW / stock_5min / 2019-09-27
file: by_date/stock_5min/2019/2019-09-27.parquet size: 5.5 MB rows: 354,024 symbols: 2,540
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-09-27 04:15:00 | AAPL | Stock | 54.975 | 54.975 | 54.975 | 54.975 | 400.0 |
| 2019-09-27 04:20:00 | AAPL | Stock | 55.0125 | 55.0125 | 55.0125 | 55.0125 | 2000.0 |
| 2019-09-27 04:25:00 | AAPL | Stock | 55.025 | 55.025 | 55.025 | 55.025 | 400.0 |
| 2019-09-27 05:30:00 | AAPL | Stock | 55.0975 | 55.1 | 55.075 | 55.075 | 5200.0 |
| 2019-09-27 05:45:00 | AAPL | Stock | 55.0725 | 55.0725 | 55.0725 | 55.0725 | 1200.0 |
| 2019-09-27 06:10:00 | AAPL | Stock | 55.0725 | 55.075 | 55.0725 | 55.075 | 10152.0 |
| 2019-09-27 06:15:00 | AAPL | Stock | 55.16 | 55.16 | 55.16 | 55.16 | 800.0 |
| 2019-09-27 07:00:00 | AAPL | Stock | 55.1025 | 55.15 | 55.1025 | 55.125 | 7800.0 |
| 2019-09-27 07:05:00 | AAPL | Stock | 55.15 | 55.15 | 55.15 | 55.15 | 600.0 |
| 2019-09-27 07:10:00 | AAPL | Stock | 55.145 | 55.145 | 55.13 | 55.13 | 8600.0 |
| 2019-09-27 07:20:00 | AAPL | Stock | 55.13 | 55.13 | 55.125 | 55.125 | 1600.0 |
| 2019-09-27 07:25:00 | AAPL | Stock | 55.075 | 55.1125 | 55.075 | 55.1125 | 2172.0 |
| 2019-09-27 07:30:00 | AAPL | Stock | 55.11 | 55.12 | 55.09 | 55.12 | 4304.0 |
| 2019-09-27 07:35:00 | AAPL | Stock | 55.1125 | 55.1175 | 55.11 | 55.11 | 2392.0 |
| 2019-09-27 07:40:00 | AAPL | Stock | 55.12 | 55.125 | 55.12 | 55.125 | 4300.0 |
| 2019-09-27 07:50:00 | AAPL | Stock | 55.1125 | 55.145 | 55.11 | 55.145 | 5800.0 |
| 2019-09-27 08:00:00 | AAPL | Stock | 55.15 | 55.195 | 55.11 | 55.1275 | 30964.0 |
| 2019-09-27 08:05:00 | AAPL | Stock | 55.1405 | 55.16 | 55.13 | 55.1375 | 30812.0 |
| 2019-09-27 08:10:00 | AAPL | Stock | 55.1375 | 55.14 | 55.1125 | 55.12 | 9536.0 |
| 2019-09-27 08:15:00 | AAPL | Stock | 55.1125 | 55.1125 | 55.08 | 55.0925 | 4420.0 |
| 2019-09-27 08:20:00 | AAPL | Stock | 55.08 | 55.1 | 55.0725 | 55.0975 | 3796.0 |
| 2019-09-27 08:25:00 | AAPL | Stock | 55.105 | 55.105 | 55.105 | 55.105 | 556.0 |
| 2019-09-27 08:30:00 | AAPL | Stock | 55.12 | 55.145 | 55.1 | 55.1 | 3600.0 |
| 2019-09-27 08:35:00 | AAPL | Stock | 55.13 | 55.135 | 55.025 | 55.0625 | 51084.0 |
| 2019-09-27 08:40:00 | AAPL | Stock | 55.0625 | 55.1175 | 55.0625 | 55.09 | 6684.0 |
| 2019-09-27 08:45:00 | AAPL | Stock | 55.1125 | 55.1125 | 55.025 | 55.025 | 13772.0 |
| 2019-09-27 08:50:00 | AAPL | Stock | 55.08 | 55.0875 | 55.0775 | 55.0875 | 2400.0 |
| 2019-09-27 08:55:00 | AAPL | Stock | 55.06 | 55.1122 | 55.06 | 55.1122 | 5680.0 |
| 2019-09-27 09:00:00 | AAPL | Stock | 55.1 | 55.1125 | 55.0925 | 55.1125 | 11272.0 |
| 2019-09-27 09:05:00 | AAPL | Stock | 55.1125 | 55.145 | 55.1125 | 55.1125 | 30972.0 |
| 2019-09-27 09:10:00 | AAPL | Stock | 55.125 | 55.1325 | 55.1 | 55.1325 | 3196.0 |
| 2019-09-27 09:15:00 | AAPL | Stock | 55.1125 | 55.1125 | 55.0925 | 55.1125 | 2788.0 |
| 2019-09-27 09:20:00 | AAPL | Stock | 55.105 | 55.105 | 55.0375 | 55.05 | 31592.0 |
| 2019-09-27 09:25:00 | AAPL | Stock | 55.035 | 55.145 | 55.035 | 55.11 | 34488.0 |
| 2019-09-27 09:30:00 | AAPL | Stock | 55.1075 | 55.24 | 55.0575 | 55.095 | 2386140.0 |
| 2019-09-27 09:35:00 | AAPL | Stock | 55.095 | 55.15 | 55.03 | 55.0625 | 1117148.0 |
| 2019-09-27 09:40:00 | AAPL | Stock | 55.065 | 55.1238 | 55.05 | 55.1175 | 659908.0 |
| 2019-09-27 09:45:00 | AAPL | Stock | 55.12 | 55.1562 | 55.065 | 55.069 | 819264.0 |
| 2019-09-27 09:50:00 | AAPL | Stock | 55.0675 | 55.0692 | 55.0 | 55.005 | 868692.0 |
| 2019-09-27 09:55:00 | AAPL | Stock | 55.005 | 55.075 | 54.99 | 55.06 | 836116.0 |
| 2019-09-27 10:00:00 | AAPL | Stock | 55.045 | 55.1025 | 54.985 | 54.995 | 2264456.0 |
| 2019-09-27 10:05:00 | AAPL | Stock | 54.9975 | 55.0638 | 54.9925 | 55.0375 | 752912.0 |
| 2019-09-27 10:10:00 | AAPL | Stock | 55.04 | 55.0975 | 55.03 | 55.035 | 686960.0 |
| 2019-09-27 10:15:00 | AAPL | Stock | 55.0335 | 55.0675 | 54.9475 | 55.045 | 897692.0 |
| 2019-09-27 10:20:00 | AAPL | Stock | 55.04 | 55.0875 | 55.0025 | 55.016 | 728364.0 |
| 2019-09-27 10:25:00 | AAPL | Stock | 55.0125 | 55.0375 | 54.955 | 55.0175 | 904820.0 |
| 2019-09-27 10:30:00 | AAPL | Stock | 55.015 | 55.03 | 54.8675 | 54.9088 | 1232000.0 |
| 2019-09-27 10:35:00 | AAPL | Stock | 54.9075 | 55.015 | 54.905 | 55.0125 | 926444.0 |
| 2019-09-27 10:40:00 | AAPL | Stock | 55.015 | 55.025 | 54.9725 | 55.0025 | 643648.0 |
| 2019-09-27 10:45:00 | AAPL | Stock | 55.0025 | 55.075 | 54.9812 | 55.0725 | 692600.0 |
> showing 50 of 354,024 rows — these rows as CSV