PREVIEW / stock_5min / 2021-08-23
file: by_date/stock_5min/2021/2021-08-23.parquet size: 7.4 MB rows: 456,262 symbols: 2,835
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-08-23 04:00:00 | AAPL | Stock | 148.56 | 148.56 | 148.2 | 148.47 | 2804.0 |
| 2021-08-23 04:05:00 | AAPL | Stock | 148.6 | 148.6 | 148.6 | 148.6 | 247.0 |
| 2021-08-23 04:10:00 | AAPL | Stock | 148.6 | 148.6 | 148.59 | 148.59 | 2935.0 |
| 2021-08-23 04:15:00 | AAPL | Stock | 148.52 | 148.52 | 148.52 | 148.52 | 300.0 |
| 2021-08-23 04:20:00 | AAPL | Stock | 148.56 | 148.6 | 148.56 | 148.6 | 1252.0 |
| 2021-08-23 04:25:00 | AAPL | Stock | 148.61 | 148.65 | 148.61 | 148.65 | 550.0 |
| 2021-08-23 04:30:00 | AAPL | Stock | 148.63 | 148.64 | 148.6 | 148.64 | 1337.0 |
| 2021-08-23 04:35:00 | AAPL | Stock | 148.64 | 148.64 | 148.6 | 148.61 | 2931.0 |
| 2021-08-23 04:40:00 | AAPL | Stock | 148.65 | 148.74 | 148.65 | 148.74 | 687.0 |
| 2021-08-23 04:45:00 | AAPL | Stock | 148.75 | 148.8 | 148.75 | 148.8 | 580.0 |
| 2021-08-23 04:50:00 | AAPL | Stock | 148.85 | 148.85 | 148.84 | 148.84 | 200.0 |
| 2021-08-23 04:55:00 | AAPL | Stock | 148.81 | 148.83 | 148.81 | 148.83 | 700.0 |
| 2021-08-23 05:00:00 | AAPL | Stock | 148.85 | 148.85 | 148.85 | 148.85 | 300.0 |
| 2021-08-23 05:05:00 | AAPL | Stock | 148.69 | 148.69 | 148.69 | 148.69 | 482.0 |
| 2021-08-23 05:10:00 | AAPL | Stock | 148.63 | 148.71 | 148.58 | 148.6 | 2236.0 |
| 2021-08-23 05:15:00 | AAPL | Stock | 148.62 | 148.62 | 148.62 | 148.62 | 549.0 |
| 2021-08-23 05:20:00 | AAPL | Stock | 148.66 | 148.66 | 148.66 | 148.66 | 100.0 |
| 2021-08-23 05:25:00 | AAPL | Stock | 148.65 | 148.66 | 148.58 | 148.58 | 2694.0 |
| 2021-08-23 05:30:00 | AAPL | Stock | 148.57 | 148.57 | 148.44 | 148.53 | 962.0 |
| 2021-08-23 05:45:00 | AAPL | Stock | 148.55 | 148.55 | 148.5 | 148.5 | 766.0 |
| 2021-08-23 05:50:00 | AAPL | Stock | 148.51 | 148.59 | 148.51 | 148.59 | 1296.0 |
| 2021-08-23 05:55:00 | AAPL | Stock | 148.58 | 148.58 | 148.5 | 148.52 | 2057.0 |
| 2021-08-23 06:00:00 | AAPL | Stock | 148.52 | 148.52 | 148.43 | 148.45 | 1888.0 |
| 2021-08-23 06:05:00 | AAPL | Stock | 148.4 | 148.5 | 148.4 | 148.41 | 3409.0 |
| 2021-08-23 06:10:00 | AAPL | Stock | 148.44 | 148.44 | 148.35 | 148.35 | 2622.0 |
| 2021-08-23 06:15:00 | AAPL | Stock | 148.4 | 148.4 | 148.4 | 148.4 | 380.0 |
| 2021-08-23 06:20:00 | AAPL | Stock | 148.44 | 148.44 | 148.44 | 148.44 | 100.0 |
| 2021-08-23 06:30:00 | AAPL | Stock | 148.44 | 148.5 | 148.44 | 148.5 | 986.0 |
| 2021-08-23 06:35:00 | AAPL | Stock | 148.53 | 148.53 | 148.53 | 148.53 | 405.0 |
| 2021-08-23 06:40:00 | AAPL | Stock | 148.52 | 148.54 | 148.52 | 148.54 | 1458.0 |
| 2021-08-23 06:55:00 | AAPL | Stock | 148.48 | 148.54 | 148.48 | 148.54 | 401.0 |
| 2021-08-23 07:00:00 | AAPL | Stock | 148.53 | 148.7 | 148.51 | 148.63 | 18954.0 |
| 2021-08-23 07:05:00 | AAPL | Stock | 148.6 | 148.63 | 148.51 | 148.52 | 11315.0 |
| 2021-08-23 07:10:00 | AAPL | Stock | 148.51 | 148.55 | 148.44 | 148.49 | 22215.0 |
| 2021-08-23 07:15:00 | AAPL | Stock | 148.52 | 148.6 | 148.52 | 148.52 | 6115.0 |
| 2021-08-23 07:20:00 | AAPL | Stock | 148.51 | 148.52 | 148.47 | 148.52 | 8025.0 |
| 2021-08-23 07:25:00 | AAPL | Stock | 148.56 | 148.66 | 148.56 | 148.66 | 3384.0 |
| 2021-08-23 07:30:00 | AAPL | Stock | 148.69 | 148.74 | 148.64 | 148.67 | 6479.0 |
| 2021-08-23 07:35:00 | AAPL | Stock | 148.65 | 148.79 | 148.64 | 148.7 | 12712.0 |
| 2021-08-23 07:40:00 | AAPL | Stock | 148.73 | 148.73 | 148.67 | 148.68 | 17948.0 |
| 2021-08-23 07:45:00 | AAPL | Stock | 148.66 | 148.67 | 148.6 | 148.65 | 16200.0 |
| 2021-08-23 07:50:00 | AAPL | Stock | 148.64 | 148.64 | 148.6 | 148.61 | 3046.0 |
| 2021-08-23 07:55:00 | AAPL | Stock | 148.61 | 148.66 | 148.61 | 148.65 | 10533.0 |
| 2021-08-23 08:00:00 | AAPL | Stock | 148.69 | 148.79 | 147.82 | 148.66 | 110460.0 |
| 2021-08-23 08:05:00 | AAPL | Stock | 148.65 | 148.67 | 148.63 | 148.65 | 2794.0 |
| 2021-08-23 08:10:00 | AAPL | Stock | 148.65 | 148.67 | 148.63 | 148.63 | 7099.0 |
| 2021-08-23 08:15:00 | AAPL | Stock | 148.63 | 148.68 | 148.57 | 148.68 | 9471.0 |
| 2021-08-23 08:20:00 | AAPL | Stock | 148.68 | 148.68 | 148.54 | 148.55 | 12430.0 |
| 2021-08-23 08:25:00 | AAPL | Stock | 148.57 | 148.6 | 148.52 | 148.54 | 15285.0 |
| 2021-08-23 08:30:00 | AAPL | Stock | 148.57 | 148.57 | 148.4 | 148.53 | 13213.0 |
> showing 50 of 456,262 rows — these rows as CSV