PREVIEW / stock_5min / 2020-12-30
file: by_date/stock_5min/2020/2020-12-30.parquet size: 7.4 MB rows: 460,455 symbols: 2,672
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-12-30 04:00:00 | AAPL | Stock | 135.41 | 135.5 | 135.41 | 135.49 | 2933.0 |
| 2020-12-30 04:05:00 | AAPL | Stock | 135.45 | 135.47 | 135.39 | 135.47 | 1872.0 |
| 2020-12-30 04:10:00 | AAPL | Stock | 135.47 | 135.47 | 135.39 | 135.42 | 2845.0 |
| 2020-12-30 04:15:00 | AAPL | Stock | 135.35 | 135.35 | 135.32 | 135.33 | 1241.0 |
| 2020-12-30 04:20:00 | AAPL | Stock | 135.36 | 135.5 | 135.3 | 135.5 | 2514.0 |
| 2020-12-30 04:25:00 | AAPL | Stock | 135.47 | 135.47 | 135.47 | 135.47 | 300.0 |
| 2020-12-30 04:35:00 | AAPL | Stock | 135.42 | 135.43 | 135.37 | 135.41 | 2403.0 |
| 2020-12-30 04:40:00 | AAPL | Stock | 135.41 | 135.45 | 135.41 | 135.45 | 2058.0 |
| 2020-12-30 04:45:00 | AAPL | Stock | 135.44 | 135.44 | 135.44 | 135.44 | 127.0 |
| 2020-12-30 05:05:00 | AAPL | Stock | 135.49 | 135.55 | 135.47 | 135.52 | 1026.0 |
| 2020-12-30 05:15:00 | AAPL | Stock | 135.61 | 135.61 | 135.6 | 135.6 | 2188.0 |
| 2020-12-30 05:20:00 | AAPL | Stock | 135.62 | 135.62 | 135.62 | 135.62 | 100.0 |
| 2020-12-30 05:25:00 | AAPL | Stock | 135.7 | 135.7 | 135.65 | 135.65 | 760.0 |
| 2020-12-30 05:30:00 | AAPL | Stock | 135.68 | 135.68 | 135.66 | 135.66 | 732.0 |
| 2020-12-30 05:35:00 | AAPL | Stock | 135.59 | 135.59 | 135.59 | 135.59 | 399.0 |
| 2020-12-30 05:40:00 | AAPL | Stock | 135.66 | 135.68 | 135.66 | 135.68 | 217.0 |
| 2020-12-30 05:45:00 | AAPL | Stock | 135.68 | 135.68 | 135.66 | 135.66 | 470.0 |
| 2020-12-30 05:50:00 | AAPL | Stock | 135.64 | 135.64 | 135.64 | 135.64 | 150.0 |
| 2020-12-30 05:55:00 | AAPL | Stock | 135.68 | 135.68 | 135.68 | 135.68 | 300.0 |
| 2020-12-30 06:00:00 | AAPL | Stock | 135.7 | 135.75 | 135.7 | 135.75 | 400.0 |
| 2020-12-30 06:10:00 | AAPL | Stock | 135.74 | 135.74 | 135.74 | 135.74 | 200.0 |
| 2020-12-30 06:15:00 | AAPL | Stock | 135.65 | 135.65 | 135.62 | 135.62 | 1600.0 |
| 2020-12-30 06:20:00 | AAPL | Stock | 135.66 | 135.66 | 135.5 | 135.5 | 4700.0 |
| 2020-12-30 06:25:00 | AAPL | Stock | 135.58 | 135.58 | 135.58 | 135.58 | 150.0 |
| 2020-12-30 06:35:00 | AAPL | Stock | 135.59 | 135.59 | 135.4 | 135.5 | 4592.0 |
| 2020-12-30 06:40:00 | AAPL | Stock | 135.5 | 135.63 | 135.5 | 135.63 | 1729.0 |
| 2020-12-30 06:45:00 | AAPL | Stock | 135.64 | 135.68 | 135.64 | 135.68 | 2531.0 |
| 2020-12-30 06:50:00 | AAPL | Stock | 135.73 | 135.8 | 135.7 | 135.79 | 1748.0 |
| 2020-12-30 06:55:00 | AAPL | Stock | 135.79 | 135.8 | 135.76 | 135.8 | 1342.0 |
| 2020-12-30 07:00:00 | AAPL | Stock | 135.75 | 135.84 | 135.62 | 135.64 | 47443.0 |
| 2020-12-30 07:05:00 | AAPL | Stock | 135.64 | 135.65 | 135.53 | 135.57 | 17362.0 |
| 2020-12-30 07:10:00 | AAPL | Stock | 135.57 | 135.6 | 135.5 | 135.52 | 16089.0 |
| 2020-12-30 07:15:00 | AAPL | Stock | 135.51 | 135.53 | 135.43 | 135.43 | 10741.0 |
| 2020-12-30 07:20:00 | AAPL | Stock | 135.46 | 135.5 | 135.44 | 135.5 | 14101.0 |
| 2020-12-30 07:25:00 | AAPL | Stock | 135.5 | 135.5 | 135.43 | 135.45 | 3884.0 |
| 2020-12-30 07:30:00 | AAPL | Stock | 135.45 | 135.51 | 135.43 | 135.44 | 10214.0 |
| 2020-12-30 07:35:00 | AAPL | Stock | 135.45 | 135.48 | 135.19 | 135.24 | 29331.0 |
| 2020-12-30 07:40:00 | AAPL | Stock | 135.3 | 135.47 | 135.3 | 135.47 | 12349.0 |
| 2020-12-30 07:45:00 | AAPL | Stock | 135.47 | 135.53 | 135.45 | 135.48 | 10374.0 |
| 2020-12-30 07:50:00 | AAPL | Stock | 135.49 | 135.57 | 135.48 | 135.56 | 26192.0 |
| 2020-12-30 07:55:00 | AAPL | Stock | 135.531 | 135.65 | 135.531 | 135.639 | 11368.0 |
| 2020-12-30 08:00:00 | AAPL | Stock | 135.66 | 135.8 | 135.19 | 135.5 | 158697.0 |
| 2020-12-30 08:05:00 | AAPL | Stock | 135.5 | 135.57 | 135.47 | 135.55 | 14220.0 |
| 2020-12-30 08:10:00 | AAPL | Stock | 135.57 | 135.65 | 135.57 | 135.62 | 14194.0 |
| 2020-12-30 08:15:00 | AAPL | Stock | 135.62 | 135.65 | 135.59 | 135.62 | 22801.0 |
| 2020-12-30 08:20:00 | AAPL | Stock | 135.64 | 135.68 | 135.59 | 135.68 | 14158.0 |
| 2020-12-30 08:25:00 | AAPL | Stock | 135.68 | 135.8 | 135.67 | 135.77 | 49324.0 |
| 2020-12-30 08:30:00 | AAPL | Stock | 135.77 | 135.82 | 135.7 | 135.81 | 28210.0 |
| 2020-12-30 08:35:00 | AAPL | Stock | 135.8 | 135.81 | 135.71 | 135.76 | 20381.0 |
| 2020-12-30 08:40:00 | AAPL | Stock | 135.77 | 135.81 | 135.77 | 135.8 | 16375.0 |
> showing 50 of 460,455 rows — these rows as CSV