PREVIEW / stock_5min / 2018-08-13
file: by_date/stock_5min/2018/2018-08-13.parquet size: 5.5 MB rows: 348,997 symbols: 2,819
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 |
|---|---|---|---|---|---|---|---|
| 2018-08-13 04:00:00 | AAPL | Stock | 51.675 | 51.675 | 51.65 | 51.65 | 800.0 |
| 2018-08-13 04:25:00 | AAPL | Stock | 51.7775 | 51.7775 | 51.7775 | 51.7775 | 400.0 |
| 2018-08-13 05:30:00 | AAPL | Stock | 51.795 | 51.795 | 51.795 | 51.795 | 1780.0 |
| 2018-08-13 06:15:00 | AAPL | Stock | 51.795 | 51.795 | 51.795 | 51.795 | 800.0 |
| 2018-08-13 06:25:00 | AAPL | Stock | 51.82 | 51.82 | 51.82 | 51.82 | 400.0 |
| 2018-08-13 06:30:00 | AAPL | Stock | 51.8125 | 51.8125 | 51.8125 | 51.8125 | 2000.0 |
| 2018-08-13 06:40:00 | AAPL | Stock | 51.8125 | 51.8125 | 51.8125 | 51.8125 | 800.0 |
| 2018-08-13 07:00:00 | AAPL | Stock | 51.8425 | 51.8675 | 51.8425 | 51.85 | 34760.0 |
| 2018-08-13 07:05:00 | AAPL | Stock | 51.8375 | 51.8375 | 51.83 | 51.83 | 1708.0 |
| 2018-08-13 07:10:00 | AAPL | Stock | 51.8375 | 51.8375 | 51.83 | 51.83 | 1600.0 |
| 2018-08-13 07:15:00 | AAPL | Stock | 51.8675 | 51.8675 | 51.8375 | 51.84 | 3140.0 |
| 2018-08-13 07:20:00 | AAPL | Stock | 51.85 | 51.85 | 51.85 | 51.85 | 2000.0 |
| 2018-08-13 07:30:00 | AAPL | Stock | 51.8375 | 51.8575 | 51.8375 | 51.8575 | 9292.0 |
| 2018-08-13 07:35:00 | AAPL | Stock | 51.8325 | 51.855 | 51.825 | 51.825 | 2800.0 |
| 2018-08-13 07:40:00 | AAPL | Stock | 51.8475 | 51.8475 | 51.825 | 51.825 | 15828.0 |
| 2018-08-13 07:45:00 | AAPL | Stock | 51.845 | 51.865 | 51.8425 | 51.865 | 4400.0 |
| 2018-08-13 07:50:00 | AAPL | Stock | 51.885 | 51.9 | 51.885 | 51.9 | 4780.0 |
| 2018-08-13 07:55:00 | AAPL | Stock | 51.91 | 51.9625 | 51.91 | 51.935 | 23784.0 |
| 2018-08-13 08:00:00 | AAPL | Stock | 51.8375 | 51.9598 | 51.79 | 51.9125 | 25112.0 |
| 2018-08-13 08:05:00 | AAPL | Stock | 51.925 | 51.925 | 51.8975 | 51.9 | 5156.0 |
| 2018-08-13 08:10:00 | AAPL | Stock | 51.9 | 51.9375 | 51.9 | 51.9125 | 80256.0 |
| 2018-08-13 08:15:00 | AAPL | Stock | 51.9275 | 51.9325 | 51.9025 | 51.9175 | 3608.0 |
| 2018-08-13 08:20:00 | AAPL | Stock | 51.925 | 51.925 | 51.9 | 51.9225 | 18720.0 |
| 2018-08-13 08:25:00 | AAPL | Stock | 51.9375 | 52.0125 | 51.925 | 52.0125 | 24792.0 |
| 2018-08-13 08:30:00 | AAPL | Stock | 52.0125 | 52.0125 | 51.965 | 51.975 | 79592.0 |
| 2018-08-13 08:35:00 | AAPL | Stock | 51.9675 | 51.9825 | 51.96 | 51.975 | 6808.0 |
| 2018-08-13 08:40:00 | AAPL | Stock | 51.975 | 51.9975 | 51.975 | 51.9975 | 6364.0 |
| 2018-08-13 08:45:00 | AAPL | Stock | 51.985 | 51.995 | 51.975 | 51.9775 | 10296.0 |
| 2018-08-13 08:50:00 | AAPL | Stock | 52.0 | 52.0 | 51.975 | 51.98 | 11608.0 |
| 2018-08-13 08:55:00 | AAPL | Stock | 51.975 | 51.975 | 51.925 | 51.9375 | 11652.0 |
| 2018-08-13 09:00:00 | AAPL | Stock | 51.9425 | 51.95 | 51.9125 | 51.9492 | 11344.0 |
| 2018-08-13 09:05:00 | AAPL | Stock | 51.9275 | 51.9575 | 51.92 | 51.9575 | 4412.0 |
| 2018-08-13 09:10:00 | AAPL | Stock | 51.96 | 51.975 | 51.96 | 51.975 | 15140.0 |
| 2018-08-13 09:20:00 | AAPL | Stock | 51.9725 | 51.9875 | 51.95 | 51.9875 | 20948.0 |
| 2018-08-13 09:25:00 | AAPL | Stock | 51.975 | 51.975 | 51.91 | 51.915 | 16076.0 |
| 2018-08-13 09:30:00 | AAPL | Stock | 51.925 | 52.16 | 51.925 | 52.1425 | 3006292.0 |
| 2018-08-13 09:35:00 | AAPL | Stock | 52.1425 | 52.2125 | 52.0175 | 52.035 | 1593708.0 |
| 2018-08-13 09:40:00 | AAPL | Stock | 52.0322 | 52.23 | 52.0308 | 52.225 | 1578620.0 |
| 2018-08-13 09:45:00 | AAPL | Stock | 52.221 | 52.3125 | 52.1725 | 52.2775 | 2020532.0 |
| 2018-08-13 09:50:00 | AAPL | Stock | 52.2788 | 52.3445 | 52.245 | 52.3375 | 1712972.0 |
| 2018-08-13 09:55:00 | AAPL | Stock | 52.34 | 52.3725 | 52.3325 | 52.3525 | 1268900.0 |
| 2018-08-13 10:00:00 | AAPL | Stock | 52.355 | 52.4375 | 52.3425 | 52.4362 | 1866104.0 |
| 2018-08-13 10:05:00 | AAPL | Stock | 52.4375 | 52.4975 | 52.4 | 52.4925 | 2197728.0 |
| 2018-08-13 10:10:00 | AAPL | Stock | 52.4925 | 52.71 | 52.49 | 52.67 | 5876556.0 |
| 2018-08-13 10:15:00 | AAPL | Stock | 52.6685 | 52.738 | 52.595 | 52.615 | 2571084.0 |
| 2018-08-13 10:20:00 | AAPL | Stock | 52.62 | 52.7 | 52.6188 | 52.695 | 1337940.0 |
| 2018-08-13 10:25:00 | AAPL | Stock | 52.695 | 52.7175 | 52.65 | 52.68 | 1909816.0 |
| 2018-08-13 10:30:00 | AAPL | Stock | 52.68 | 52.7375 | 52.6625 | 52.6798 | 1944572.0 |
| 2018-08-13 10:35:00 | AAPL | Stock | 52.68 | 52.6975 | 52.615 | 52.6228 | 1334704.0 |
| 2018-08-13 10:40:00 | AAPL | Stock | 52.6235 | 52.6475 | 52.58 | 52.6 | 1461960.0 |
> showing 50 of 348,997 rows — these rows as CSV