PREVIEW / stock_5min / 2020-09-28
file: by_date/stock_5min/2020/2020-09-28.parquet size: 6.5 MB rows: 412,180 symbols: 2,507
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-09-28 04:00:00 | AAPL | Stock | 113.8 | 114.0 | 113.7 | 113.7 | 20971.0 |
| 2020-09-28 04:05:00 | AAPL | Stock | 113.73 | 114.0 | 113.73 | 114.0 | 8799.0 |
| 2020-09-28 04:10:00 | AAPL | Stock | 114.0 | 114.32 | 114.0 | 114.25 | 13216.0 |
| 2020-09-28 04:15:00 | AAPL | Stock | 114.18 | 114.24 | 114.12 | 114.12 | 2340.0 |
| 2020-09-28 04:20:00 | AAPL | Stock | 114.16 | 114.31 | 114.16 | 114.27 | 2786.0 |
| 2020-09-28 04:25:00 | AAPL | Stock | 114.17 | 114.22 | 114.17 | 114.17 | 1283.0 |
| 2020-09-28 04:30:00 | AAPL | Stock | 114.28 | 114.4 | 114.17 | 114.4 | 6232.0 |
| 2020-09-28 04:35:00 | AAPL | Stock | 114.38 | 114.38 | 114.31 | 114.36 | 3166.0 |
| 2020-09-28 04:40:00 | AAPL | Stock | 114.36 | 114.42 | 114.32 | 114.32 | 3276.0 |
| 2020-09-28 04:45:00 | AAPL | Stock | 114.28 | 114.28 | 114.21 | 114.25 | 2571.0 |
| 2020-09-28 04:50:00 | AAPL | Stock | 114.28 | 114.28 | 114.15 | 114.15 | 2430.0 |
| 2020-09-28 04:55:00 | AAPL | Stock | 114.23 | 114.29 | 114.18 | 114.19 | 3466.0 |
| 2020-09-28 05:00:00 | AAPL | Stock | 114.2 | 114.32 | 114.2 | 114.32 | 2703.0 |
| 2020-09-28 05:05:00 | AAPL | Stock | 114.26 | 114.32 | 114.26 | 114.31 | 689.0 |
| 2020-09-28 05:10:00 | AAPL | Stock | 114.35 | 114.35 | 114.2 | 114.25 | 1555.0 |
| 2020-09-28 05:15:00 | AAPL | Stock | 114.21 | 114.3 | 114.21 | 114.3 | 1562.0 |
| 2020-09-28 05:20:00 | AAPL | Stock | 114.3 | 114.35 | 114.3 | 114.31 | 1197.0 |
| 2020-09-28 05:25:00 | AAPL | Stock | 114.33 | 114.33 | 114.3 | 114.3 | 1493.0 |
| 2020-09-28 05:30:00 | AAPL | Stock | 114.27 | 114.4 | 114.25 | 114.35 | 3767.0 |
| 2020-09-28 05:35:00 | AAPL | Stock | 114.36 | 114.36 | 114.22 | 114.22 | 2659.0 |
| 2020-09-28 05:40:00 | AAPL | Stock | 114.28 | 114.33 | 114.22 | 114.3 | 10281.0 |
| 2020-09-28 05:45:00 | AAPL | Stock | 114.28 | 114.29 | 114.28 | 114.29 | 1602.0 |
| 2020-09-28 05:50:00 | AAPL | Stock | 114.3 | 114.3 | 114.2 | 114.3 | 1564.0 |
| 2020-09-28 05:55:00 | AAPL | Stock | 114.27 | 114.3 | 114.26 | 114.26 | 1792.0 |
| 2020-09-28 06:00:00 | AAPL | Stock | 114.21 | 114.57 | 114.18 | 114.53 | 32353.0 |
| 2020-09-28 06:05:00 | AAPL | Stock | 114.46 | 114.58 | 114.41 | 114.58 | 30077.0 |
| 2020-09-28 06:10:00 | AAPL | Stock | 114.54 | 114.59 | 114.43 | 114.5 | 10762.0 |
| 2020-09-28 06:15:00 | AAPL | Stock | 114.48 | 114.8 | 114.42 | 114.78 | 9864.0 |
| 2020-09-28 06:20:00 | AAPL | Stock | 114.78 | 114.78 | 114.63 | 114.72 | 6143.0 |
| 2020-09-28 06:25:00 | AAPL | Stock | 114.65 | 114.68 | 114.56 | 114.64 | 6483.0 |
| 2020-09-28 06:30:00 | AAPL | Stock | 114.64 | 114.8 | 114.58 | 114.68 | 10042.0 |
| 2020-09-28 06:35:00 | AAPL | Stock | 114.68 | 114.79 | 114.68 | 114.7 | 3942.0 |
| 2020-09-28 06:40:00 | AAPL | Stock | 114.7 | 114.81 | 114.64 | 114.64 | 7042.0 |
| 2020-09-28 06:45:00 | AAPL | Stock | 114.62 | 114.75 | 114.62 | 114.75 | 5998.0 |
| 2020-09-28 06:50:00 | AAPL | Stock | 114.82 | 114.9 | 114.75 | 114.76 | 10252.0 |
| 2020-09-28 06:55:00 | AAPL | Stock | 114.71 | 114.74 | 114.65 | 114.7 | 4365.0 |
| 2020-09-28 07:00:00 | AAPL | Stock | 114.6 | 114.85 | 114.35 | 114.61 | 191990.0 |
| 2020-09-28 07:05:00 | AAPL | Stock | 114.62 | 114.87 | 114.6 | 114.8 | 74625.0 |
| 2020-09-28 07:10:00 | AAPL | Stock | 114.75 | 114.94 | 114.75 | 114.9 | 36183.0 |
| 2020-09-28 07:15:00 | AAPL | Stock | 114.9 | 115.05 | 114.74 | 114.89 | 151336.0 |
| 2020-09-28 07:20:00 | AAPL | Stock | 114.9 | 115.1 | 114.89 | 115.0 | 45258.0 |
| 2020-09-28 07:25:00 | AAPL | Stock | 115.03 | 115.1 | 114.88 | 114.94 | 23600.0 |
| 2020-09-28 07:30:00 | AAPL | Stock | 114.94 | 115.05 | 114.939 | 115.03 | 23677.0 |
| 2020-09-28 07:35:00 | AAPL | Stock | 115.02 | 115.02 | 114.94 | 115.0 | 21913.0 |
| 2020-09-28 07:40:00 | AAPL | Stock | 115.0 | 115.05 | 114.96 | 115.0 | 38377.0 |
| 2020-09-28 07:45:00 | AAPL | Stock | 115.0 | 115.0 | 114.93 | 114.93 | 34021.0 |
| 2020-09-28 07:50:00 | AAPL | Stock | 114.93 | 115.18 | 114.93 | 115.07 | 94302.0 |
| 2020-09-28 07:55:00 | AAPL | Stock | 115.07 | 115.45 | 115.06 | 115.4 | 86942.0 |
| 2020-09-28 08:00:00 | AAPL | Stock | 115.41 | 115.43 | 114.35 | 115.33 | 552520.0 |
| 2020-09-28 08:05:00 | AAPL | Stock | 115.33 | 115.5 | 115.32 | 115.38 | 75819.0 |
> showing 50 of 412,180 rows — these rows as CSV