PREVIEW / stock_5min / 2021-07-27
file: by_date/stock_5min/2021/2021-07-27.parquet size: 7.3 MB rows: 449,406 symbols: 2,844
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-07-27 04:00:00 | AAPL | Stock | 148.5 | 148.57 | 148.03 | 148.34 | 9305.0 |
| 2021-07-27 04:05:00 | AAPL | Stock | 148.4 | 148.5 | 148.37 | 148.5 | 4074.0 |
| 2021-07-27 04:10:00 | AAPL | Stock | 148.54 | 148.54 | 148.34 | 148.34 | 4844.0 |
| 2021-07-27 04:15:00 | AAPL | Stock | 148.41 | 148.41 | 148.4 | 148.4 | 894.0 |
| 2021-07-27 04:20:00 | AAPL | Stock | 148.34 | 148.39 | 148.34 | 148.39 | 1160.0 |
| 2021-07-27 04:25:00 | AAPL | Stock | 148.32 | 148.32 | 148.22 | 148.22 | 2041.0 |
| 2021-07-27 04:30:00 | AAPL | Stock | 148.3 | 148.48 | 148.3 | 148.48 | 1026.0 |
| 2021-07-27 04:35:00 | AAPL | Stock | 148.55 | 148.7 | 148.55 | 148.7 | 3289.0 |
| 2021-07-27 04:40:00 | AAPL | Stock | 148.65 | 148.65 | 148.65 | 148.65 | 186.0 |
| 2021-07-27 04:45:00 | AAPL | Stock | 148.61 | 148.61 | 148.61 | 148.61 | 741.0 |
| 2021-07-27 04:50:00 | AAPL | Stock | 148.6 | 148.65 | 148.6 | 148.65 | 347.0 |
| 2021-07-27 04:55:00 | AAPL | Stock | 148.7 | 148.71 | 148.68 | 148.7 | 1936.0 |
| 2021-07-27 05:00:00 | AAPL | Stock | 148.61 | 148.61 | 148.61 | 148.61 | 250.0 |
| 2021-07-27 05:05:00 | AAPL | Stock | 148.62 | 148.64 | 148.5 | 148.5 | 2535.0 |
| 2021-07-27 05:10:00 | AAPL | Stock | 148.52 | 148.6 | 148.3 | 148.3 | 1832.0 |
| 2021-07-27 05:15:00 | AAPL | Stock | 148.33 | 148.52 | 148.3 | 148.52 | 2896.0 |
| 2021-07-27 05:20:00 | AAPL | Stock | 148.51 | 148.6 | 148.42 | 148.6 | 3181.0 |
| 2021-07-27 05:25:00 | AAPL | Stock | 148.69 | 148.69 | 148.63 | 148.63 | 726.0 |
| 2021-07-27 05:35:00 | AAPL | Stock | 148.78 | 148.84 | 148.78 | 148.83 | 3590.0 |
| 2021-07-27 05:40:00 | AAPL | Stock | 148.77 | 148.84 | 148.7 | 148.7 | 3885.0 |
| 2021-07-27 05:45:00 | AAPL | Stock | 148.77 | 148.81 | 148.72 | 148.72 | 592.0 |
| 2021-07-27 05:50:00 | AAPL | Stock | 148.72 | 148.89 | 148.7 | 148.88 | 4004.0 |
| 2021-07-27 05:55:00 | AAPL | Stock | 148.9 | 148.95 | 148.9 | 148.95 | 683.0 |
| 2021-07-27 06:00:00 | AAPL | Stock | 148.82 | 149.05 | 148.82 | 149.05 | 2093.0 |
| 2021-07-27 06:05:00 | AAPL | Stock | 149.03 | 149.04 | 148.94 | 148.94 | 3438.0 |
| 2021-07-27 06:10:00 | AAPL | Stock | 148.93 | 148.95 | 148.88 | 148.88 | 2339.0 |
| 2021-07-27 06:15:00 | AAPL | Stock | 148.9 | 148.9 | 148.9 | 148.9 | 100.0 |
| 2021-07-27 06:25:00 | AAPL | Stock | 148.9 | 148.9 | 148.9 | 148.9 | 300.0 |
| 2021-07-27 06:35:00 | AAPL | Stock | 148.95 | 149.05 | 148.95 | 149.05 | 3524.0 |
| 2021-07-27 06:40:00 | AAPL | Stock | 149.1 | 149.1 | 149.09 | 149.1 | 599.0 |
| 2021-07-27 06:45:00 | AAPL | Stock | 149.06 | 149.06 | 149.06 | 149.06 | 444.0 |
| 2021-07-27 06:50:00 | AAPL | Stock | 149.06 | 149.09 | 149.0 | 149.07 | 2194.0 |
| 2021-07-27 06:55:00 | AAPL | Stock | 149.07 | 149.07 | 149.05 | 149.05 | 668.0 |
| 2021-07-27 07:00:00 | AAPL | Stock | 149.07 | 149.51 | 149.05 | 149.42 | 31188.0 |
| 2021-07-27 07:05:00 | AAPL | Stock | 149.4 | 149.53 | 149.35 | 149.45 | 37190.0 |
| 2021-07-27 07:10:00 | AAPL | Stock | 149.45 | 149.48 | 149.34 | 149.39 | 16931.0 |
| 2021-07-27 07:15:00 | AAPL | Stock | 149.39 | 149.48 | 149.35 | 149.35 | 22094.0 |
| 2021-07-27 07:20:00 | AAPL | Stock | 149.38 | 149.43 | 149.34 | 149.37 | 10111.0 |
| 2021-07-27 07:25:00 | AAPL | Stock | 149.37 | 149.5 | 149.37 | 149.45 | 19068.0 |
| 2021-07-27 07:30:00 | AAPL | Stock | 149.46 | 149.47 | 149.43 | 149.45 | 6823.0 |
| 2021-07-27 07:35:00 | AAPL | Stock | 149.43 | 149.45 | 149.4 | 149.45 | 13500.0 |
| 2021-07-27 07:40:00 | AAPL | Stock | 149.43 | 149.43 | 149.3 | 149.32 | 15946.0 |
| 2021-07-27 07:45:00 | AAPL | Stock | 149.32 | 149.35 | 149.22 | 149.22 | 8522.0 |
| 2021-07-27 07:50:00 | AAPL | Stock | 149.2 | 149.22 | 149.09 | 149.22 | 15077.0 |
| 2021-07-27 07:55:00 | AAPL | Stock | 149.22 | 149.28 | 149.2 | 149.27 | 13959.0 |
| 2021-07-27 08:00:00 | AAPL | Stock | 149.27 | 149.5 | 148.618 | 149.28 | 233461.0 |
| 2021-07-27 08:05:00 | AAPL | Stock | 149.3 | 149.32 | 149.18 | 149.18 | 16483.0 |
| 2021-07-27 08:10:00 | AAPL | Stock | 149.18 | 149.21 | 149.13 | 149.15 | 24799.0 |
| 2021-07-27 08:15:00 | AAPL | Stock | 149.15 | 149.15 | 149.1 | 149.15 | 27691.0 |
| 2021-07-27 08:20:00 | AAPL | Stock | 149.165 | 149.21 | 149.15 | 149.2 | 20624.0 |
> showing 50 of 449,406 rows — these rows as CSV