PREVIEW / stock_5min / 2020-09-03
file: by_date/stock_5min/2020/2020-09-03.parquet size: 6.8 MB rows: 422,777 symbols: 2,474
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-03 04:00:00 | AAPL | Stock | 131.9 | 132.25 | 131.62 | 131.86 | 12819.0 |
| 2020-09-03 04:05:00 | AAPL | Stock | 131.85 | 131.97 | 131.01 | 131.02 | 8956.0 |
| 2020-09-03 04:10:00 | AAPL | Stock | 131.02 | 131.02 | 130.31 | 130.5 | 12441.0 |
| 2020-09-03 04:15:00 | AAPL | Stock | 130.41 | 130.59 | 130.35 | 130.59 | 4298.0 |
| 2020-09-03 04:20:00 | AAPL | Stock | 130.65 | 130.88 | 130.65 | 130.68 | 2525.0 |
| 2020-09-03 04:25:00 | AAPL | Stock | 130.71 | 130.89 | 130.65 | 130.81 | 3468.0 |
| 2020-09-03 04:30:00 | AAPL | Stock | 130.94 | 131.0 | 130.88 | 131.0 | 5001.0 |
| 2020-09-03 04:35:00 | AAPL | Stock | 130.99 | 131.04 | 130.61 | 130.61 | 9890.0 |
| 2020-09-03 04:40:00 | AAPL | Stock | 130.7 | 130.73 | 130.45 | 130.5 | 4177.0 |
| 2020-09-03 04:45:00 | AAPL | Stock | 130.5 | 130.82 | 130.46 | 130.78 | 3646.0 |
| 2020-09-03 04:50:00 | AAPL | Stock | 130.63 | 130.8 | 130.61 | 130.8 | 4167.0 |
| 2020-09-03 04:55:00 | AAPL | Stock | 130.72 | 130.79 | 130.5 | 130.5 | 2766.0 |
| 2020-09-03 05:00:00 | AAPL | Stock | 130.79 | 130.79 | 130.32 | 130.49 | 3967.0 |
| 2020-09-03 05:05:00 | AAPL | Stock | 130.49 | 130.5 | 130.1 | 130.25 | 5345.0 |
| 2020-09-03 05:10:00 | AAPL | Stock | 130.12 | 130.29 | 129.9 | 129.92 | 13440.0 |
| 2020-09-03 05:15:00 | AAPL | Stock | 129.99 | 130.1 | 129.86 | 130.04 | 7277.0 |
| 2020-09-03 05:20:00 | AAPL | Stock | 130.02 | 130.04 | 129.33 | 129.5 | 20226.0 |
| 2020-09-03 05:25:00 | AAPL | Stock | 129.5 | 129.68 | 129.47 | 129.52 | 21862.0 |
| 2020-09-03 05:30:00 | AAPL | Stock | 129.68 | 129.81 | 129.5 | 129.55 | 9283.0 |
| 2020-09-03 05:35:00 | AAPL | Stock | 129.55 | 129.73 | 129.27 | 129.5 | 12547.0 |
| 2020-09-03 05:40:00 | AAPL | Stock | 129.5 | 129.5 | 129.09 | 129.15 | 7385.0 |
| 2020-09-03 05:45:00 | AAPL | Stock | 129.13 | 129.18 | 128.85 | 129.04 | 9565.0 |
| 2020-09-03 05:50:00 | AAPL | Stock | 129.05 | 129.05 | 128.83 | 128.83 | 5307.0 |
| 2020-09-03 05:55:00 | AAPL | Stock | 128.85 | 128.85 | 128.32 | 128.32 | 17019.0 |
| 2020-09-03 06:00:00 | AAPL | Stock | 128.31 | 128.5 | 128.18 | 128.5 | 20512.0 |
| 2020-09-03 06:05:00 | AAPL | Stock | 128.5 | 128.73 | 128.48 | 128.73 | 13144.0 |
| 2020-09-03 06:10:00 | AAPL | Stock | 128.75 | 128.96 | 128.75 | 128.9 | 18452.0 |
| 2020-09-03 06:15:00 | AAPL | Stock | 128.8 | 128.9 | 128.7 | 128.9 | 8165.0 |
| 2020-09-03 06:20:00 | AAPL | Stock | 128.96 | 128.98 | 128.65 | 128.91 | 15692.0 |
| 2020-09-03 06:25:00 | AAPL | Stock | 128.82 | 129.0 | 128.81 | 129.0 | 2261.0 |
| 2020-09-03 06:30:00 | AAPL | Stock | 129.06 | 129.39 | 128.96 | 129.03 | 5007.0 |
| 2020-09-03 06:35:00 | AAPL | Stock | 129.1 | 129.48 | 129.1 | 129.41 | 5130.0 |
| 2020-09-03 06:40:00 | AAPL | Stock | 129.47 | 129.49 | 129.2 | 129.2 | 15504.0 |
| 2020-09-03 06:45:00 | AAPL | Stock | 129.2 | 129.2 | 128.87 | 129.02 | 9248.0 |
| 2020-09-03 06:50:00 | AAPL | Stock | 129.03 | 129.07 | 128.65 | 129.03 | 16411.0 |
| 2020-09-03 06:55:00 | AAPL | Stock | 128.93 | 129.15 | 128.92 | 129.15 | 2746.0 |
| 2020-09-03 07:00:00 | AAPL | Stock | 129.1 | 129.7 | 129.0 | 129.23 | 119166.0 |
| 2020-09-03 07:05:00 | AAPL | Stock | 129.2 | 129.45 | 129.15 | 129.17 | 30539.0 |
| 2020-09-03 07:10:00 | AAPL | Stock | 129.17 | 129.21 | 128.38 | 128.54 | 92186.0 |
| 2020-09-03 07:15:00 | AAPL | Stock | 128.55 | 128.65 | 128.32 | 128.43 | 49180.0 |
| 2020-09-03 07:20:00 | AAPL | Stock | 128.43 | 128.6 | 128.21 | 128.25 | 55608.0 |
| 2020-09-03 07:25:00 | AAPL | Stock | 128.25 | 128.4 | 127.7 | 128.1 | 145825.0 |
| 2020-09-03 07:30:00 | AAPL | Stock | 128.05 | 128.5 | 128.0 | 128.2 | 54675.0 |
| 2020-09-03 07:35:00 | AAPL | Stock | 128.19 | 128.49 | 128.19 | 128.4 | 33702.0 |
| 2020-09-03 07:40:00 | AAPL | Stock | 128.4 | 128.48 | 128.11 | 128.48 | 41739.0 |
| 2020-09-03 07:45:00 | AAPL | Stock | 128.47 | 128.95 | 128.36 | 128.87 | 35223.0 |
| 2020-09-03 07:50:00 | AAPL | Stock | 128.82 | 128.82 | 128.26 | 128.28 | 47699.0 |
| 2020-09-03 07:55:00 | AAPL | Stock | 128.29 | 128.9 | 128.25 | 128.4 | 34021.0 |
| 2020-09-03 08:00:00 | AAPL | Stock | 129.25 | 129.696 | 127.8 | 128.6 | 569990.0 |
| 2020-09-03 08:05:00 | AAPL | Stock | 128.628 | 128.8 | 128.0 | 128.09 | 107610.0 |
> showing 50 of 422,777 rows — these rows as CSV