PREVIEW / stock_5min / 2020-06-16
file: by_date/stock_5min/2020/2020-06-16.parquet size: 6.8 MB rows: 435,701 symbols: 2,419
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-06-16 04:00:00 | AAPL | Stock | 86.575 | 86.895 | 86.575 | 86.825 | 4380.0 |
| 2020-06-16 04:05:00 | AAPL | Stock | 86.8125 | 86.8125 | 86.7475 | 86.75 | 27636.0 |
| 2020-06-16 04:15:00 | AAPL | Stock | 86.8975 | 86.8975 | 86.8975 | 86.8975 | 400.0 |
| 2020-06-16 04:25:00 | AAPL | Stock | 86.795 | 86.85 | 86.795 | 86.8125 | 2152.0 |
| 2020-06-16 04:30:00 | AAPL | Stock | 86.825 | 86.825 | 86.825 | 86.825 | 1040.0 |
| 2020-06-16 04:35:00 | AAPL | Stock | 86.825 | 86.875 | 86.825 | 86.875 | 1256.0 |
| 2020-06-16 04:40:00 | AAPL | Stock | 86.885 | 86.885 | 86.8775 | 86.8775 | 1044.0 |
| 2020-06-16 04:45:00 | AAPL | Stock | 86.825 | 86.8975 | 86.825 | 86.8975 | 1040.0 |
| 2020-06-16 04:55:00 | AAPL | Stock | 86.9075 | 86.9075 | 86.9 | 86.9 | 12276.0 |
| 2020-06-16 05:05:00 | AAPL | Stock | 86.835 | 86.9525 | 86.835 | 86.9525 | 11912.0 |
| 2020-06-16 05:10:00 | AAPL | Stock | 86.99 | 87.0 | 86.99 | 87.0 | 1320.0 |
| 2020-06-16 05:20:00 | AAPL | Stock | 86.92 | 86.92 | 86.92 | 86.92 | 608.0 |
| 2020-06-16 05:25:00 | AAPL | Stock | 86.93 | 86.935 | 86.93 | 86.935 | 1040.0 |
| 2020-06-16 05:30:00 | AAPL | Stock | 87.0 | 87.0 | 86.905 | 86.905 | 7392.0 |
| 2020-06-16 05:35:00 | AAPL | Stock | 86.99 | 87.0025 | 86.99 | 87.0025 | 2800.0 |
| 2020-06-16 05:40:00 | AAPL | Stock | 86.9625 | 87.0675 | 86.9625 | 87.0675 | 14360.0 |
| 2020-06-16 05:45:00 | AAPL | Stock | 87.015 | 87.015 | 86.5025 | 86.7475 | 36332.0 |
| 2020-06-16 05:50:00 | AAPL | Stock | 86.7 | 86.7 | 86.7 | 86.7 | 7388.0 |
| 2020-06-16 05:55:00 | AAPL | Stock | 86.8 | 86.8 | 86.8 | 86.8 | 520.0 |
| 2020-06-16 06:00:00 | AAPL | Stock | 86.7975 | 86.8075 | 86.7975 | 86.8075 | 2080.0 |
| 2020-06-16 06:05:00 | AAPL | Stock | 86.8125 | 86.985 | 86.8125 | 86.985 | 6132.0 |
| 2020-06-16 06:10:00 | AAPL | Stock | 86.9725 | 87.115 | 86.9 | 86.9425 | 10460.0 |
| 2020-06-16 06:15:00 | AAPL | Stock | 86.9425 | 87.11 | 86.9425 | 87.0 | 6064.0 |
| 2020-06-16 06:25:00 | AAPL | Stock | 86.975 | 87.0 | 86.95 | 87.0 | 6800.0 |
| 2020-06-16 06:30:00 | AAPL | Stock | 87.0 | 87.0875 | 86.95 | 87.0875 | 8528.0 |
| 2020-06-16 06:35:00 | AAPL | Stock | 87.11 | 87.1125 | 87.0 | 87.0 | 1320.0 |
| 2020-06-16 06:55:00 | AAPL | Stock | 86.8875 | 86.8875 | 86.8875 | 86.8875 | 4716.0 |
| 2020-06-16 07:00:00 | AAPL | Stock | 86.82 | 86.925 | 86.7525 | 86.82 | 72896.0 |
| 2020-06-16 07:05:00 | AAPL | Stock | 86.79 | 86.79 | 86.6875 | 86.725 | 23248.0 |
| 2020-06-16 07:10:00 | AAPL | Stock | 86.725 | 86.7875 | 86.7 | 86.775 | 27580.0 |
| 2020-06-16 07:15:00 | AAPL | Stock | 86.7775 | 86.815 | 86.775 | 86.805 | 35052.0 |
| 2020-06-16 07:20:00 | AAPL | Stock | 86.825 | 86.825 | 86.7875 | 86.8 | 6252.0 |
| 2020-06-16 07:25:00 | AAPL | Stock | 86.825 | 86.875 | 86.8225 | 86.875 | 20252.0 |
| 2020-06-16 07:30:00 | AAPL | Stock | 86.8725 | 86.9 | 86.865 | 86.9 | 22704.0 |
| 2020-06-16 07:35:00 | AAPL | Stock | 86.91 | 87.0 | 86.8875 | 86.9525 | 28964.0 |
| 2020-06-16 07:40:00 | AAPL | Stock | 86.975 | 86.9925 | 86.9475 | 86.9625 | 15308.0 |
| 2020-06-16 07:45:00 | AAPL | Stock | 86.99 | 87.125 | 86.99 | 87.125 | 49040.0 |
| 2020-06-16 07:50:00 | AAPL | Stock | 87.15 | 87.3375 | 87.15 | 87.2825 | 111812.0 |
| 2020-06-16 07:55:00 | AAPL | Stock | 87.27 | 87.375 | 87.2475 | 87.2875 | 58700.0 |
| 2020-06-16 08:00:00 | AAPL | Stock | 86.775 | 87.38 | 86.6925 | 87.3025 | 195404.0 |
| 2020-06-16 08:05:00 | AAPL | Stock | 87.3028 | 87.375 | 87.2925 | 87.3375 | 27860.0 |
| 2020-06-16 08:10:00 | AAPL | Stock | 87.3575 | 87.4375 | 87.315 | 87.435 | 40256.0 |
| 2020-06-16 08:15:00 | AAPL | Stock | 87.435 | 87.475 | 87.4025 | 87.45 | 49748.0 |
| 2020-06-16 08:20:00 | AAPL | Stock | 87.415 | 87.4525 | 87.3625 | 87.3975 | 34488.0 |
| 2020-06-16 08:25:00 | AAPL | Stock | 87.3625 | 87.475 | 87.359 | 87.45 | 30992.0 |
| 2020-06-16 08:30:00 | AAPL | Stock | 87.4825 | 87.62 | 87.4825 | 87.62 | 152060.0 |
| 2020-06-16 08:35:00 | AAPL | Stock | 87.6175 | 87.75 | 87.5762 | 87.7325 | 227960.0 |
| 2020-06-16 08:40:00 | AAPL | Stock | 87.7402 | 88.0 | 87.7135 | 87.988 | 112020.0 |
| 2020-06-16 08:45:00 | AAPL | Stock | 88.045 | 88.125 | 87.875 | 87.9375 | 94956.0 |
| 2020-06-16 08:50:00 | AAPL | Stock | 87.9625 | 87.9825 | 87.8875 | 87.98 | 70196.0 |
> showing 50 of 435,701 rows — these rows as CSV