PREVIEW / stock_5min / 2022-05-18
file: by_date/stock_5min/2022/2022-05-18.parquet size: 7.2 MB rows: 450,714 symbols: 2,415
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-05-18 04:00:00 | AAPL | Stock | 148.79 | 148.85 | 148.3 | 148.65 | 3559.0 |
| 2022-05-18 04:05:00 | AAPL | Stock | 148.65 | 148.65 | 148.4 | 148.4 | 2252.0 |
| 2022-05-18 04:10:00 | AAPL | Stock | 148.51 | 148.56 | 148.5 | 148.56 | 637.0 |
| 2022-05-18 04:15:00 | AAPL | Stock | 148.61 | 148.61 | 148.5 | 148.5 | 1606.0 |
| 2022-05-18 04:20:00 | AAPL | Stock | 148.49 | 148.49 | 148.2 | 148.2 | 2788.0 |
| 2022-05-18 04:25:00 | AAPL | Stock | 148.31 | 148.39 | 148.23 | 148.39 | 1339.0 |
| 2022-05-18 04:30:00 | AAPL | Stock | 148.24 | 148.24 | 148.21 | 148.21 | 880.0 |
| 2022-05-18 04:35:00 | AAPL | Stock | 148.16 | 148.16 | 148.12 | 148.12 | 349.0 |
| 2022-05-18 04:40:00 | AAPL | Stock | 148.18 | 148.18 | 148.18 | 148.18 | 100.0 |
| 2022-05-18 05:00:00 | AAPL | Stock | 148.39 | 148.43 | 148.31 | 148.43 | 1894.0 |
| 2022-05-18 05:05:00 | AAPL | Stock | 148.3 | 148.3 | 148.28 | 148.28 | 818.0 |
| 2022-05-18 05:10:00 | AAPL | Stock | 148.35 | 148.4 | 148.35 | 148.4 | 231.0 |
| 2022-05-18 05:15:00 | AAPL | Stock | 148.3 | 148.3 | 148.3 | 148.3 | 300.0 |
| 2022-05-18 05:20:00 | AAPL | Stock | 148.4 | 148.4 | 148.4 | 148.4 | 300.0 |
| 2022-05-18 05:25:00 | AAPL | Stock | 148.35 | 148.35 | 148.31 | 148.31 | 1303.0 |
| 2022-05-18 05:30:00 | AAPL | Stock | 148.31 | 148.31 | 148.31 | 148.31 | 313.0 |
| 2022-05-18 05:35:00 | AAPL | Stock | 148.41 | 148.58 | 148.41 | 148.58 | 983.0 |
| 2022-05-18 05:40:00 | AAPL | Stock | 148.63 | 148.63 | 148.63 | 148.63 | 100.0 |
| 2022-05-18 05:45:00 | AAPL | Stock | 148.63 | 148.63 | 148.58 | 148.58 | 1113.0 |
| 2022-05-18 05:50:00 | AAPL | Stock | 148.64 | 148.64 | 148.64 | 148.64 | 533.0 |
| 2022-05-18 05:55:00 | AAPL | Stock | 148.56 | 148.56 | 148.44 | 148.52 | 3091.0 |
| 2022-05-18 06:00:00 | AAPL | Stock | 148.7 | 148.73 | 148.58 | 148.58 | 1113.0 |
| 2022-05-18 06:05:00 | AAPL | Stock | 148.65 | 148.73 | 148.65 | 148.71 | 500.0 |
| 2022-05-18 06:10:00 | AAPL | Stock | 148.7 | 148.77 | 148.6 | 148.74 | 4101.0 |
| 2022-05-18 06:15:00 | AAPL | Stock | 148.78 | 148.78 | 148.73 | 148.73 | 934.0 |
| 2022-05-18 06:20:00 | AAPL | Stock | 148.76 | 148.76 | 148.76 | 148.76 | 100.0 |
| 2022-05-18 06:30:00 | AAPL | Stock | 148.59 | 148.59 | 148.58 | 148.58 | 251.0 |
| 2022-05-18 06:35:00 | AAPL | Stock | 148.39 | 148.39 | 148.17 | 148.17 | 7440.0 |
| 2022-05-18 06:40:00 | AAPL | Stock | 148.13 | 148.13 | 148.01 | 148.03 | 10992.0 |
| 2022-05-18 06:50:00 | AAPL | Stock | 148.1 | 148.15 | 148.02 | 148.15 | 4913.0 |
| 2022-05-18 06:55:00 | AAPL | Stock | 148.2 | 148.3 | 148.2 | 148.3 | 415.0 |
| 2022-05-18 07:00:00 | AAPL | Stock | 148.34 | 148.39 | 148.02 | 148.05 | 15371.0 |
| 2022-05-18 07:05:00 | AAPL | Stock | 148.06 | 148.06 | 147.75 | 147.76 | 20398.0 |
| 2022-05-18 07:10:00 | AAPL | Stock | 147.75 | 147.8 | 147.51 | 147.54 | 16661.0 |
| 2022-05-18 07:15:00 | AAPL | Stock | 147.6 | 147.63 | 147.38 | 147.63 | 11600.0 |
| 2022-05-18 07:20:00 | AAPL | Stock | 147.62 | 147.66 | 147.4 | 147.55 | 3777.0 |
| 2022-05-18 07:25:00 | AAPL | Stock | 147.51 | 147.55 | 147.4 | 147.42 | 11101.0 |
| 2022-05-18 07:30:00 | AAPL | Stock | 147.43 | 147.69 | 147.43 | 147.63 | 6981.0 |
| 2022-05-18 07:35:00 | AAPL | Stock | 147.62 | 147.67 | 147.5 | 147.5 | 4898.0 |
| 2022-05-18 07:40:00 | AAPL | Stock | 147.54 | 147.55 | 147.45 | 147.49 | 8812.0 |
| 2022-05-18 07:45:00 | AAPL | Stock | 147.45 | 147.47 | 147.38 | 147.47 | 3176.0 |
| 2022-05-18 07:50:00 | AAPL | Stock | 147.52 | 147.58 | 147.45 | 147.58 | 3249.0 |
| 2022-05-18 07:55:00 | AAPL | Stock | 147.58 | 147.58 | 147.47 | 147.55 | 6683.0 |
| 2022-05-18 08:00:00 | AAPL | Stock | 148.27 | 149.19 | 147.4 | 147.5521 | 238802.0 |
| 2022-05-18 08:05:00 | AAPL | Stock | 147.59 | 147.64 | 147.55 | 147.56 | 15114.0 |
| 2022-05-18 08:10:00 | AAPL | Stock | 147.57 | 147.62 | 147.47 | 147.51 | 33000.0 |
| 2022-05-18 08:15:00 | AAPL | Stock | 147.5899 | 147.7899 | 147.58 | 147.77 | 8743.0 |
| 2022-05-18 08:20:00 | AAPL | Stock | 147.75 | 147.75 | 147.63 | 147.67 | 13762.0 |
| 2022-05-18 08:25:00 | AAPL | Stock | 147.71 | 147.9199 | 147.69 | 147.85 | 16377.0 |
| 2022-05-18 08:30:00 | AAPL | Stock | 147.7999 | 147.7999 | 147.5766 | 147.605 | 10027.0 |
> showing 50 of 450,714 rows — these rows as CSV