PREVIEW / stock_5min / 2021-07-23
file: by_date/stock_5min/2021/2021-07-23.parquet size: 7.2 MB rows: 443,142 symbols: 2,814
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-23 04:00:00 | AAPL | Stock | 147.5 | 147.69 | 147.5 | 147.59 | 2965.0 |
| 2021-07-23 04:05:00 | AAPL | Stock | 147.57 | 147.57 | 147.57 | 147.57 | 400.0 |
| 2021-07-23 04:10:00 | AAPL | Stock | 147.5 | 147.5 | 147.5 | 147.5 | 186.0 |
| 2021-07-23 04:15:00 | AAPL | Stock | 147.65 | 147.65 | 147.56 | 147.56 | 358.0 |
| 2021-07-23 04:20:00 | AAPL | Stock | 147.56 | 147.6 | 147.56 | 147.6 | 420.0 |
| 2021-07-23 04:25:00 | AAPL | Stock | 147.63 | 147.69 | 147.63 | 147.69 | 1393.0 |
| 2021-07-23 04:30:00 | AAPL | Stock | 147.75 | 147.9 | 147.75 | 147.9 | 1870.0 |
| 2021-07-23 04:35:00 | AAPL | Stock | 147.89 | 147.9 | 147.81 | 147.89 | 1812.0 |
| 2021-07-23 04:40:00 | AAPL | Stock | 147.82 | 147.82 | 147.82 | 147.82 | 100.0 |
| 2021-07-23 04:45:00 | AAPL | Stock | 147.86 | 147.86 | 147.84 | 147.84 | 457.0 |
| 2021-07-23 04:50:00 | AAPL | Stock | 147.84 | 147.84 | 147.84 | 147.84 | 510.0 |
| 2021-07-23 04:55:00 | AAPL | Stock | 147.78 | 147.78 | 147.78 | 147.78 | 1144.0 |
| 2021-07-23 05:05:00 | AAPL | Stock | 147.75 | 147.75 | 147.75 | 147.75 | 291.0 |
| 2021-07-23 05:10:00 | AAPL | Stock | 147.7 | 147.85 | 147.7 | 147.85 | 546.0 |
| 2021-07-23 05:15:00 | AAPL | Stock | 147.7 | 147.7 | 147.7 | 147.7 | 108.0 |
| 2021-07-23 05:20:00 | AAPL | Stock | 147.8 | 147.8 | 147.8 | 147.8 | 224.0 |
| 2021-07-23 05:30:00 | AAPL | Stock | 147.74 | 147.74 | 147.65 | 147.65 | 2046.0 |
| 2021-07-23 05:35:00 | AAPL | Stock | 147.64 | 147.66 | 147.64 | 147.66 | 963.0 |
| 2021-07-23 05:40:00 | AAPL | Stock | 147.64 | 147.64 | 147.64 | 147.64 | 609.0 |
| 2021-07-23 05:45:00 | AAPL | Stock | 147.66 | 147.66 | 147.66 | 147.66 | 100.0 |
| 2021-07-23 05:50:00 | AAPL | Stock | 147.66 | 147.66 | 147.6 | 147.61 | 1490.0 |
| 2021-07-23 05:55:00 | AAPL | Stock | 147.61 | 147.61 | 147.61 | 147.61 | 887.0 |
| 2021-07-23 06:00:00 | AAPL | Stock | 147.54 | 147.54 | 147.54 | 147.54 | 120.0 |
| 2021-07-23 06:10:00 | AAPL | Stock | 147.49 | 147.49 | 147.49 | 147.49 | 400.0 |
| 2021-07-23 06:15:00 | AAPL | Stock | 147.51 | 147.51 | 147.51 | 147.51 | 1225.0 |
| 2021-07-23 06:25:00 | AAPL | Stock | 147.54 | 147.54 | 147.54 | 147.54 | 241.0 |
| 2021-07-23 06:30:00 | AAPL | Stock | 147.53 | 147.55 | 147.53 | 147.54 | 472.0 |
| 2021-07-23 06:35:00 | AAPL | Stock | 147.55 | 147.6 | 147.52 | 147.6 | 332.0 |
| 2021-07-23 06:40:00 | AAPL | Stock | 147.57 | 147.6 | 147.57 | 147.57 | 1297.0 |
| 2021-07-23 06:45:00 | AAPL | Stock | 147.54 | 147.54 | 147.52 | 147.52 | 400.0 |
| 2021-07-23 06:50:00 | AAPL | Stock | 147.52 | 147.52 | 147.52 | 147.52 | 400.0 |
| 2021-07-23 06:55:00 | AAPL | Stock | 147.53 | 147.55 | 147.52 | 147.52 | 1863.0 |
| 2021-07-23 07:00:00 | AAPL | Stock | 147.58 | 147.8 | 147.53 | 147.69 | 25980.0 |
| 2021-07-23 07:05:00 | AAPL | Stock | 147.68 | 147.68 | 147.54 | 147.57 | 10664.0 |
| 2021-07-23 07:10:00 | AAPL | Stock | 147.57 | 147.57 | 147.52 | 147.53 | 6338.0 |
| 2021-07-23 07:15:00 | AAPL | Stock | 147.53 | 147.53 | 147.4 | 147.5 | 24026.0 |
| 2021-07-23 07:20:00 | AAPL | Stock | 147.5 | 147.54 | 147.43 | 147.43 | 10530.0 |
| 2021-07-23 07:25:00 | AAPL | Stock | 147.44 | 147.5 | 147.43 | 147.44 | 5734.0 |
| 2021-07-23 07:30:00 | AAPL | Stock | 147.43 | 147.46 | 147.33 | 147.33 | 7211.0 |
| 2021-07-23 07:35:00 | AAPL | Stock | 147.38 | 147.43 | 147.35 | 147.36 | 3838.0 |
| 2021-07-23 07:40:00 | AAPL | Stock | 147.4 | 147.42 | 147.39 | 147.41 | 800.0 |
| 2021-07-23 07:45:00 | AAPL | Stock | 147.4 | 147.4 | 147.35 | 147.38 | 3507.0 |
| 2021-07-23 07:50:00 | AAPL | Stock | 147.4 | 147.45 | 147.32 | 147.45 | 3755.0 |
| 2021-07-23 07:55:00 | AAPL | Stock | 147.48 | 147.51 | 147.41 | 147.51 | 7959.0 |
| 2021-07-23 08:00:00 | AAPL | Stock | 147.7 | 147.75 | 147.32 | 147.45 | 158522.0 |
| 2021-07-23 08:05:00 | AAPL | Stock | 147.45 | 147.45 | 147.36 | 147.38 | 12013.0 |
| 2021-07-23 08:10:00 | AAPL | Stock | 147.38 | 147.39 | 147.31 | 147.39 | 17176.0 |
| 2021-07-23 08:15:00 | AAPL | Stock | 147.38 | 147.38 | 147.25 | 147.36 | 12165.0 |
| 2021-07-23 08:20:00 | AAPL | Stock | 147.36 | 147.4 | 147.27 | 147.34 | 21652.0 |
| 2021-07-23 08:25:00 | AAPL | Stock | 147.34 | 147.43 | 147.3 | 147.38 | 11512.0 |
> showing 50 of 443,142 rows — these rows as CSV