PREVIEW / stock_5min / 2022-04-14
file: by_date/stock_5min/2022/2022-04-14.parquet size: 7.1 MB rows: 434,400 symbols: 2,463
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-04-14 04:00:00 | AAPL | Stock | 170.52 | 170.52 | 170.3 | 170.4 | 6906.0 |
| 2022-04-14 04:05:00 | AAPL | Stock | 170.4 | 170.7 | 170.4 | 170.7 | 2437.0 |
| 2022-04-14 04:10:00 | AAPL | Stock | 170.65 | 170.65 | 170.6 | 170.6 | 352.0 |
| 2022-04-14 04:15:00 | AAPL | Stock | 170.5 | 170.5 | 170.43 | 170.43 | 1299.0 |
| 2022-04-14 04:20:00 | AAPL | Stock | 170.38 | 170.39 | 170.35 | 170.37 | 2985.0 |
| 2022-04-14 04:25:00 | AAPL | Stock | 170.35 | 170.35 | 170.1 | 170.1 | 3929.0 |
| 2022-04-14 04:30:00 | AAPL | Stock | 170.11 | 170.16 | 170.1 | 170.1 | 2532.0 |
| 2022-04-14 04:35:00 | AAPL | Stock | 170.1 | 170.1 | 170.1 | 170.1 | 885.0 |
| 2022-04-14 04:40:00 | AAPL | Stock | 170.11 | 170.13 | 170.11 | 170.12 | 1372.0 |
| 2022-04-14 04:45:00 | AAPL | Stock | 170.28 | 170.28 | 170.13 | 170.18 | 1231.0 |
| 2022-04-14 04:55:00 | AAPL | Stock | 170.18 | 170.28 | 170.12 | 170.28 | 1192.0 |
| 2022-04-14 05:00:00 | AAPL | Stock | 170.17 | 170.17 | 170.16 | 170.16 | 200.0 |
| 2022-04-14 05:05:00 | AAPL | Stock | 170.11 | 170.21 | 170.1 | 170.21 | 1610.0 |
| 2022-04-14 05:10:00 | AAPL | Stock | 170.07 | 170.12 | 170.05 | 170.12 | 1391.0 |
| 2022-04-14 05:20:00 | AAPL | Stock | 170.16 | 170.16 | 170.16 | 170.16 | 100.0 |
| 2022-04-14 05:30:00 | AAPL | Stock | 170.12 | 170.12 | 170.12 | 170.12 | 100.0 |
| 2022-04-14 05:50:00 | AAPL | Stock | 170.25 | 170.25 | 170.1 | 170.17 | 2936.0 |
| 2022-04-14 05:55:00 | AAPL | Stock | 170.2 | 170.29 | 170.2 | 170.29 | 283.0 |
| 2022-04-14 06:00:00 | AAPL | Stock | 170.34 | 170.45 | 170.34 | 170.39 | 3222.0 |
| 2022-04-14 06:05:00 | AAPL | Stock | 170.39 | 170.39 | 170.39 | 170.39 | 100.0 |
| 2022-04-14 06:20:00 | AAPL | Stock | 170.25 | 170.25 | 170.25 | 170.25 | 189.0 |
| 2022-04-14 06:25:00 | AAPL | Stock | 170.1 | 170.1 | 170.1 | 170.1 | 740.0 |
| 2022-04-14 06:30:00 | AAPL | Stock | 170.11 | 170.11 | 170.0 | 170.0 | 6619.0 |
| 2022-04-14 06:35:00 | AAPL | Stock | 170.06 | 170.06 | 170.06 | 170.06 | 100.0 |
| 2022-04-14 06:40:00 | AAPL | Stock | 170.06 | 170.1 | 170.04 | 170.1 | 983.0 |
| 2022-04-14 06:50:00 | AAPL | Stock | 170.1 | 170.12 | 170.1 | 170.12 | 285.0 |
| 2022-04-14 06:55:00 | AAPL | Stock | 170.22 | 170.22 | 170.22 | 170.22 | 255.0 |
| 2022-04-14 07:00:00 | AAPL | Stock | 170.2 | 170.48 | 170.2 | 170.48 | 3914.0 |
| 2022-04-14 07:05:00 | AAPL | Stock | 170.4 | 170.47 | 170.35 | 170.41 | 1910.0 |
| 2022-04-14 07:10:00 | AAPL | Stock | 170.38 | 170.47 | 170.38 | 170.47 | 380.0 |
| 2022-04-14 07:15:00 | AAPL | Stock | 170.43 | 170.48 | 170.4 | 170.4 | 3463.0 |
| 2022-04-14 07:20:00 | AAPL | Stock | 170.35 | 170.35 | 170.23 | 170.29 | 2691.0 |
| 2022-04-14 07:25:00 | AAPL | Stock | 170.3 | 170.37 | 170.29 | 170.3 | 1364.0 |
| 2022-04-14 07:30:00 | AAPL | Stock | 170.27 | 170.31 | 170.21 | 170.27 | 11112.0 |
| 2022-04-14 07:35:00 | AAPL | Stock | 170.24 | 170.24 | 170.2 | 170.22 | 3287.0 |
| 2022-04-14 07:40:00 | AAPL | Stock | 170.28 | 170.34 | 170.28 | 170.34 | 773.0 |
| 2022-04-14 07:45:00 | AAPL | Stock | 170.39 | 170.66 | 170.39 | 170.6 | 6743.0 |
| 2022-04-14 07:50:00 | AAPL | Stock | 170.61 | 170.61 | 170.15 | 170.15 | 21325.0 |
| 2022-04-14 07:55:00 | AAPL | Stock | 170.11 | 170.23 | 170.06 | 170.13 | 9803.0 |
| 2022-04-14 08:00:00 | AAPL | Stock | 170.2299 | 170.93 | 169.974 | 170.2 | 99490.0 |
| 2022-04-14 08:05:00 | AAPL | Stock | 170.32 | 170.38 | 170.21 | 170.21 | 1825.0 |
| 2022-04-14 08:10:00 | AAPL | Stock | 170.28 | 170.42 | 170.28 | 170.37 | 5350.0 |
| 2022-04-14 08:15:00 | AAPL | Stock | 170.3 | 170.39 | 170.3 | 170.39 | 1347.0 |
| 2022-04-14 08:20:00 | AAPL | Stock | 170.4497 | 170.45 | 170.4 | 170.4 | 12664.0 |
| 2022-04-14 08:25:00 | AAPL | Stock | 170.5 | 170.5 | 170.39 | 170.39 | 2550.0 |
| 2022-04-14 08:30:00 | AAPL | Stock | 170.49 | 170.6 | 170.26 | 170.29 | 35106.0 |
| 2022-04-14 08:35:00 | AAPL | Stock | 170.31 | 170.33 | 170.19 | 170.19 | 33682.0 |
| 2022-04-14 08:40:00 | AAPL | Stock | 170.22 | 170.33 | 170.12 | 170.33 | 5334.0 |
| 2022-04-14 08:45:00 | AAPL | Stock | 170.27 | 170.28 | 170.1 | 170.22 | 20185.0 |
| 2022-04-14 08:50:00 | AAPL | Stock | 170.2199 | 170.23 | 170.11 | 170.15 | 9419.0 |
> showing 50 of 434,400 rows — these rows as CSV