PREVIEW / stock_5min / 2020-07-13
file: by_date/stock_5min/2020/2020-07-13.parquet size: 6.8 MB rows: 427,921 symbols: 2,458
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 |
|---|---|---|---|---|---|---|---|
| 2020-07-13 04:00:00 | AAPL | Stock | 96.6 | 96.8 | 96.575 | 96.6775 | 32576.0 |
| 2020-07-13 04:05:00 | AAPL | Stock | 96.6675 | 96.775 | 96.6675 | 96.75 | 2780.0 |
| 2020-07-13 04:10:00 | AAPL | Stock | 96.75 | 96.7725 | 96.75 | 96.75 | 3596.0 |
| 2020-07-13 04:15:00 | AAPL | Stock | 96.75 | 96.75 | 96.625 | 96.625 | 8328.0 |
| 2020-07-13 04:20:00 | AAPL | Stock | 96.68 | 96.7 | 96.625 | 96.7 | 17988.0 |
| 2020-07-13 04:25:00 | AAPL | Stock | 96.7 | 96.7 | 96.625 | 96.625 | 9592.0 |
| 2020-07-13 04:30:00 | AAPL | Stock | 96.6325 | 96.6325 | 96.6 | 96.6 | 9716.0 |
| 2020-07-13 04:35:00 | AAPL | Stock | 96.605 | 96.7725 | 96.6 | 96.7525 | 16556.0 |
| 2020-07-13 04:40:00 | AAPL | Stock | 96.8125 | 96.8175 | 96.7725 | 96.8125 | 15988.0 |
| 2020-07-13 04:45:00 | AAPL | Stock | 96.8125 | 96.8525 | 96.8125 | 96.8525 | 4140.0 |
| 2020-07-13 04:50:00 | AAPL | Stock | 96.8375 | 96.8525 | 96.8375 | 96.8375 | 2852.0 |
| 2020-07-13 04:55:00 | AAPL | Stock | 96.8375 | 96.9225 | 96.8375 | 96.875 | 4864.0 |
| 2020-07-13 05:00:00 | AAPL | Stock | 96.9625 | 96.975 | 96.9625 | 96.975 | 6200.0 |
| 2020-07-13 05:05:00 | AAPL | Stock | 96.9625 | 96.995 | 96.9625 | 96.975 | 6400.0 |
| 2020-07-13 05:10:00 | AAPL | Stock | 96.9625 | 96.9625 | 96.9625 | 96.9625 | 6440.0 |
| 2020-07-13 05:15:00 | AAPL | Stock | 96.9625 | 97.025 | 96.9625 | 97.025 | 2920.0 |
| 2020-07-13 05:20:00 | AAPL | Stock | 96.98 | 96.98 | 96.7575 | 96.7575 | 10652.0 |
| 2020-07-13 05:25:00 | AAPL | Stock | 96.8 | 96.8 | 96.8 | 96.8 | 408.0 |
| 2020-07-13 05:30:00 | AAPL | Stock | 96.85 | 96.85 | 96.85 | 96.85 | 728.0 |
| 2020-07-13 05:40:00 | AAPL | Stock | 96.9 | 96.9 | 96.9 | 96.9 | 1880.0 |
| 2020-07-13 05:50:00 | AAPL | Stock | 96.95 | 96.95 | 96.95 | 96.95 | 1960.0 |
| 2020-07-13 05:55:00 | AAPL | Stock | 96.95 | 97.0 | 96.95 | 97.0 | 5800.0 |
| 2020-07-13 06:00:00 | AAPL | Stock | 97.0 | 97.0 | 96.9525 | 96.9525 | 2480.0 |
| 2020-07-13 06:05:00 | AAPL | Stock | 96.9875 | 97.0025 | 96.9 | 96.9 | 2140.0 |
| 2020-07-13 06:10:00 | AAPL | Stock | 97.05 | 97.0575 | 97.0125 | 97.0125 | 3040.0 |
| 2020-07-13 06:20:00 | AAPL | Stock | 97.0975 | 97.1175 | 97.0975 | 97.1175 | 1632.0 |
| 2020-07-13 06:30:00 | AAPL | Stock | 97.125 | 97.1675 | 97.075 | 97.075 | 1840.0 |
| 2020-07-13 06:35:00 | AAPL | Stock | 97.125 | 97.1275 | 97.05 | 97.0525 | 3516.0 |
| 2020-07-13 06:40:00 | AAPL | Stock | 96.95 | 96.9575 | 96.95 | 96.9575 | 4800.0 |
| 2020-07-13 06:50:00 | AAPL | Stock | 96.9725 | 97.0 | 96.9725 | 97.0 | 1604.0 |
| 2020-07-13 07:00:00 | AAPL | Stock | 97.0625 | 97.125 | 96.875 | 96.975 | 150132.0 |
| 2020-07-13 07:05:00 | AAPL | Stock | 96.9775 | 97.075 | 96.935 | 97.0025 | 58336.0 |
| 2020-07-13 07:10:00 | AAPL | Stock | 97.0 | 97.0625 | 96.945 | 97.0425 | 26064.0 |
| 2020-07-13 07:15:00 | AAPL | Stock | 97.025 | 97.07 | 97.0 | 97.0325 | 44080.0 |
| 2020-07-13 07:20:00 | AAPL | Stock | 97.045 | 97.0875 | 97.0375 | 97.05 | 13192.0 |
| 2020-07-13 07:25:00 | AAPL | Stock | 97.05 | 97.05 | 96.96 | 96.96 | 25560.0 |
| 2020-07-13 07:30:00 | AAPL | Stock | 96.985 | 97.02 | 96.9725 | 97.005 | 22612.0 |
| 2020-07-13 07:35:00 | AAPL | Stock | 97.0 | 97.0425 | 97.0 | 97.0425 | 13892.0 |
| 2020-07-13 07:40:00 | AAPL | Stock | 97.045 | 97.0625 | 97.0 | 97.0375 | 55824.0 |
| 2020-07-13 07:45:00 | AAPL | Stock | 97.025 | 97.0375 | 96.975 | 97.0225 | 47004.0 |
| 2020-07-13 07:50:00 | AAPL | Stock | 97.0225 | 97.045 | 97.0 | 97.025 | 34812.0 |
| 2020-07-13 07:55:00 | AAPL | Stock | 97.005 | 97.0175 | 96.98 | 97.015 | 16860.0 |
| 2020-07-13 08:00:00 | AAPL | Stock | 97.0062 | 97.105 | 96.85 | 97.0 | 227536.0 |
| 2020-07-13 08:05:00 | AAPL | Stock | 97.0125 | 97.035 | 97.0 | 97.035 | 22232.0 |
| 2020-07-13 08:10:00 | AAPL | Stock | 97.0325 | 97.045 | 96.9875 | 96.9975 | 41352.0 |
| 2020-07-13 08:15:00 | AAPL | Stock | 96.995 | 97.0175 | 96.9625 | 96.9625 | 23644.0 |
| 2020-07-13 08:20:00 | AAPL | Stock | 96.9875 | 97.025 | 96.965 | 97.02 | 46580.0 |
| 2020-07-13 08:25:00 | AAPL | Stock | 97.02 | 97.025 | 96.95 | 96.97 | 24052.0 |
| 2020-07-13 08:30:00 | AAPL | Stock | 96.97 | 97.0175 | 96.97 | 97.0025 | 35592.0 |
| 2020-07-13 08:35:00 | AAPL | Stock | 97.01 | 97.025 | 96.9975 | 97.0025 | 40216.0 |
> showing 50 of 427,921 rows — these rows as CSV