PREVIEW / stock_5min / 2022-08-11
file: by_date/stock_5min/2022/2022-08-11.parquet size: 7.2 MB rows: 442,243 symbols: 2,276
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 |
|---|---|---|---|---|---|---|---|
| 2022-08-11 04:00:00 | AAPL | Stock | 169.0 | 169.33 | 169.0 | 169.3 | 7422.0 |
| 2022-08-11 04:05:00 | AAPL | Stock | 169.23 | 169.24 | 169.1 | 169.24 | 2959.0 |
| 2022-08-11 04:10:00 | AAPL | Stock | 169.23 | 169.24 | 169.23 | 169.24 | 526.0 |
| 2022-08-11 04:15:00 | AAPL | Stock | 169.3 | 169.35 | 169.3 | 169.35 | 1274.0 |
| 2022-08-11 04:20:00 | AAPL | Stock | 169.35 | 169.35 | 169.26 | 169.26 | 997.0 |
| 2022-08-11 04:25:00 | AAPL | Stock | 169.21 | 169.21 | 169.15 | 169.2 | 349.0 |
| 2022-08-11 04:30:00 | AAPL | Stock | 169.16 | 169.2 | 169.15 | 169.2 | 2959.0 |
| 2022-08-11 04:35:00 | AAPL | Stock | 169.22 | 169.22 | 169.22 | 169.22 | 195.0 |
| 2022-08-11 04:40:00 | AAPL | Stock | 169.22 | 169.22 | 169.17 | 169.21 | 935.0 |
| 2022-08-11 04:50:00 | AAPL | Stock | 169.13 | 169.13 | 169.08 | 169.08 | 334.0 |
| 2022-08-11 04:55:00 | AAPL | Stock | 169.2 | 169.28 | 169.13 | 169.28 | 2088.0 |
| 2022-08-11 05:00:00 | AAPL | Stock | 169.3 | 169.33 | 169.3 | 169.33 | 861.0 |
| 2022-08-11 05:05:00 | AAPL | Stock | 169.31 | 169.31 | 169.29 | 169.29 | 595.0 |
| 2022-08-11 05:10:00 | AAPL | Stock | 169.28 | 169.28 | 169.28 | 169.28 | 784.0 |
| 2022-08-11 05:15:00 | AAPL | Stock | 169.3 | 169.31 | 169.3 | 169.31 | 842.0 |
| 2022-08-11 05:20:00 | AAPL | Stock | 169.35 | 169.36 | 169.31 | 169.31 | 1189.0 |
| 2022-08-11 05:25:00 | AAPL | Stock | 169.35 | 169.37 | 169.35 | 169.37 | 600.0 |
| 2022-08-11 05:30:00 | AAPL | Stock | 169.37 | 169.48 | 169.37 | 169.48 | 3143.0 |
| 2022-08-11 05:35:00 | AAPL | Stock | 169.47 | 169.58 | 169.47 | 169.5 | 2180.0 |
| 2022-08-11 05:40:00 | AAPL | Stock | 169.46 | 169.5 | 169.45 | 169.5 | 2496.0 |
| 2022-08-11 05:45:00 | AAPL | Stock | 169.54 | 169.59 | 169.36 | 169.37 | 4988.0 |
| 2022-08-11 05:50:00 | AAPL | Stock | 169.37 | 169.37 | 169.26 | 169.31 | 5103.0 |
| 2022-08-11 06:05:00 | AAPL | Stock | 169.25 | 169.26 | 169.06 | 169.06 | 5834.0 |
| 2022-08-11 06:10:00 | AAPL | Stock | 169.19 | 169.2 | 169.19 | 169.2 | 1726.0 |
| 2022-08-11 06:15:00 | AAPL | Stock | 169.12 | 169.12 | 169.06 | 169.06 | 4257.0 |
| 2022-08-11 06:20:00 | AAPL | Stock | 169.17 | 169.17 | 169.17 | 169.17 | 283.0 |
| 2022-08-11 06:25:00 | AAPL | Stock | 169.07 | 169.07 | 169.07 | 169.07 | 111.0 |
| 2022-08-11 06:30:00 | AAPL | Stock | 169.22 | 169.22 | 169.22 | 169.22 | 100.0 |
| 2022-08-11 06:45:00 | AAPL | Stock | 169.2 | 169.22 | 169.2 | 169.22 | 1597.0 |
| 2022-08-11 06:50:00 | AAPL | Stock | 169.18 | 169.18 | 169.12 | 169.12 | 785.0 |
| 2022-08-11 07:00:00 | AAPL | Stock | 169.23 | 169.23 | 169.12 | 169.18 | 4033.0 |
| 2022-08-11 07:05:00 | AAPL | Stock | 169.2 | 169.3 | 169.15 | 169.3 | 10988.0 |
| 2022-08-11 07:10:00 | AAPL | Stock | 169.37 | 169.39 | 169.3 | 169.3 | 2550.0 |
| 2022-08-11 07:15:00 | AAPL | Stock | 169.31 | 169.4 | 169.31 | 169.39 | 2771.0 |
| 2022-08-11 07:20:00 | AAPL | Stock | 169.39 | 169.39 | 169.34 | 169.34 | 2258.0 |
| 2022-08-11 07:25:00 | AAPL | Stock | 169.35 | 169.46 | 169.35 | 169.46 | 2047.0 |
| 2022-08-11 07:30:00 | AAPL | Stock | 169.48 | 169.48 | 169.45 | 169.46 | 1983.0 |
| 2022-08-11 07:35:00 | AAPL | Stock | 169.49 | 169.72 | 169.49 | 169.72 | 4558.0 |
| 2022-08-11 07:40:00 | AAPL | Stock | 169.72 | 169.72 | 169.69 | 169.71 | 3550.0 |
| 2022-08-11 07:45:00 | AAPL | Stock | 169.72 | 169.8 | 169.7 | 169.7 | 5616.0 |
| 2022-08-11 07:50:00 | AAPL | Stock | 169.7 | 169.73 | 169.69 | 169.73 | 650.0 |
| 2022-08-11 07:55:00 | AAPL | Stock | 169.67 | 169.75 | 169.65 | 169.75 | 3453.0 |
| 2022-08-11 08:00:00 | AAPL | Stock | 169.1277 | 169.98 | 169.1 | 169.88 | 131837.0 |
| 2022-08-11 08:05:00 | AAPL | Stock | 169.89 | 169.93 | 169.82 | 169.82 | 4678.0 |
| 2022-08-11 08:10:00 | AAPL | Stock | 169.83 | 169.99 | 169.824 | 169.99 | 20381.0 |
| 2022-08-11 08:15:00 | AAPL | Stock | 169.99 | 170.059 | 169.96 | 170.05 | 76705.0 |
| 2022-08-11 08:20:00 | AAPL | Stock | 170.02 | 170.24 | 170.01 | 170.13 | 44235.0 |
| 2022-08-11 08:25:00 | AAPL | Stock | 170.11 | 170.19 | 170.06 | 170.19 | 17641.0 |
| 2022-08-11 08:30:00 | AAPL | Stock | 170.2 | 170.4 | 169.75 | 169.88 | 92766.0 |
| 2022-08-11 08:35:00 | AAPL | Stock | 169.88 | 170.17 | 169.76 | 170.16 | 50003.0 |
> showing 50 of 442,243 rows — these rows as CSV