PREVIEW / stock_5min / 2021-03-29
file: by_date/stock_5min/2021/2021-03-29.parquet size: 7.6 MB rows: 477,283 symbols: 2,938
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 |
|---|---|---|---|---|---|---|---|
| 2021-03-29 04:00:00 | AAPL | Stock | 120.69 | 120.72 | 120.38 | 120.38 | 6002.0 |
| 2021-03-29 04:05:00 | AAPL | Stock | 120.47 | 120.5 | 120.44 | 120.5 | 829.0 |
| 2021-03-29 04:10:00 | AAPL | Stock | 120.37 | 120.47 | 120.37 | 120.43 | 3063.0 |
| 2021-03-29 04:15:00 | AAPL | Stock | 120.43 | 120.43 | 120.21 | 120.3 | 4284.0 |
| 2021-03-29 04:20:00 | AAPL | Stock | 120.3 | 120.34 | 120.3 | 120.34 | 459.0 |
| 2021-03-29 04:25:00 | AAPL | Stock | 120.4 | 120.4 | 120.4 | 120.4 | 251.0 |
| 2021-03-29 04:30:00 | AAPL | Stock | 120.4 | 120.48 | 120.36 | 120.48 | 1103.0 |
| 2021-03-29 04:45:00 | AAPL | Stock | 120.48 | 120.48 | 120.47 | 120.47 | 387.0 |
| 2021-03-29 04:50:00 | AAPL | Stock | 120.51 | 120.53 | 120.51 | 120.53 | 432.0 |
| 2021-03-29 04:55:00 | AAPL | Stock | 120.53 | 120.53 | 120.47 | 120.5 | 1983.0 |
| 2021-03-29 05:00:00 | AAPL | Stock | 120.5 | 120.5 | 120.46 | 120.46 | 205.0 |
| 2021-03-29 05:05:00 | AAPL | Stock | 120.45 | 120.48 | 120.43 | 120.43 | 349.0 |
| 2021-03-29 05:10:00 | AAPL | Stock | 120.5 | 120.6 | 120.5 | 120.6 | 2014.0 |
| 2021-03-29 05:15:00 | AAPL | Stock | 120.56 | 120.56 | 120.56 | 120.56 | 200.0 |
| 2021-03-29 05:20:00 | AAPL | Stock | 120.51 | 120.51 | 120.5 | 120.5 | 948.0 |
| 2021-03-29 05:25:00 | AAPL | Stock | 120.55 | 120.6 | 120.55 | 120.6 | 734.0 |
| 2021-03-29 05:30:00 | AAPL | Stock | 120.55 | 120.59 | 120.55 | 120.59 | 620.0 |
| 2021-03-29 05:35:00 | AAPL | Stock | 120.59 | 120.59 | 120.52 | 120.58 | 3266.0 |
| 2021-03-29 05:40:00 | AAPL | Stock | 120.56 | 120.56 | 120.56 | 120.56 | 180.0 |
| 2021-03-29 05:45:00 | AAPL | Stock | 120.52 | 120.55 | 120.52 | 120.55 | 401.0 |
| 2021-03-29 05:50:00 | AAPL | Stock | 120.59 | 120.8 | 120.59 | 120.8 | 901.0 |
| 2021-03-29 05:55:00 | AAPL | Stock | 120.8 | 120.88 | 120.8 | 120.88 | 504.0 |
| 2021-03-29 06:00:00 | AAPL | Stock | 120.81 | 120.81 | 120.81 | 120.81 | 115.0 |
| 2021-03-29 06:10:00 | AAPL | Stock | 120.8 | 120.8 | 120.8 | 120.8 | 111.0 |
| 2021-03-29 06:20:00 | AAPL | Stock | 120.75 | 120.75 | 120.75 | 120.75 | 100.0 |
| 2021-03-29 06:25:00 | AAPL | Stock | 120.74 | 120.74 | 120.74 | 120.74 | 100.0 |
| 2021-03-29 06:30:00 | AAPL | Stock | 120.8 | 120.85 | 120.8 | 120.85 | 200.0 |
| 2021-03-29 06:40:00 | AAPL | Stock | 120.82 | 120.85 | 120.8 | 120.85 | 4899.0 |
| 2021-03-29 06:45:00 | AAPL | Stock | 120.84 | 120.84 | 120.84 | 120.84 | 236.0 |
| 2021-03-29 06:50:00 | AAPL | Stock | 120.95 | 120.96 | 120.95 | 120.96 | 613.0 |
| 2021-03-29 06:55:00 | AAPL | Stock | 120.87 | 120.87 | 120.85 | 120.85 | 661.0 |
| 2021-03-29 07:00:00 | AAPL | Stock | 120.86 | 121.19 | 120.84 | 121.19 | 24077.0 |
| 2021-03-29 07:05:00 | AAPL | Stock | 121.14 | 121.17 | 121.07 | 121.07 | 7004.0 |
| 2021-03-29 07:10:00 | AAPL | Stock | 121.12 | 121.44 | 121.11 | 121.23 | 12098.0 |
| 2021-03-29 07:15:00 | AAPL | Stock | 121.19 | 121.19 | 121.13 | 121.15 | 2180.0 |
| 2021-03-29 07:20:00 | AAPL | Stock | 121.13 | 121.13 | 121.08 | 121.1 | 3474.0 |
| 2021-03-29 07:25:00 | AAPL | Stock | 121.09 | 121.12 | 121.07 | 121.07 | 11495.0 |
| 2021-03-29 07:30:00 | AAPL | Stock | 121.03 | 121.09 | 121.03 | 121.05 | 4547.0 |
| 2021-03-29 07:35:00 | AAPL | Stock | 121.09 | 121.12 | 120.96 | 120.96 | 8153.0 |
| 2021-03-29 07:40:00 | AAPL | Stock | 120.99 | 121.12 | 120.99 | 121.09 | 13323.0 |
| 2021-03-29 07:45:00 | AAPL | Stock | 121.07 | 121.07 | 120.97 | 121.05 | 7126.0 |
| 2021-03-29 07:50:00 | AAPL | Stock | 121.06 | 121.08 | 120.98 | 121.01 | 2155.0 |
| 2021-03-29 07:55:00 | AAPL | Stock | 121.03 | 121.06 | 121.02 | 121.05 | 2067.0 |
| 2021-03-29 08:00:00 | AAPL | Stock | 121.0999 | 121.513 | 120.8 | 121.1 | 149530.0 |
| 2021-03-29 08:05:00 | AAPL | Stock | 121.11 | 121.48 | 121.1 | 121.48 | 43913.0 |
| 2021-03-29 08:10:00 | AAPL | Stock | 121.48 | 122.0 | 121.46 | 121.93 | 78527.0 |
| 2021-03-29 08:15:00 | AAPL | Stock | 121.9 | 121.9 | 121.62 | 121.6699 | 40509.0 |
| 2021-03-29 08:20:00 | AAPL | Stock | 121.65 | 121.9 | 121.65 | 121.82 | 29225.0 |
| 2021-03-29 08:25:00 | AAPL | Stock | 121.83 | 121.87 | 121.55 | 121.66 | 24203.0 |
| 2021-03-29 08:30:00 | AAPL | Stock | 121.71 | 121.71 | 121.6 | 121.63 | 22225.0 |
> showing 50 of 477,283 rows — these rows as CSV