PREVIEW / stock_5min / 2022-05-25
file: by_date/stock_5min/2022/2022-05-25.parquet size: 6.9 MB rows: 433,128 symbols: 2,342
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-25 04:00:00 | AAPL | Stock | 141.19 | 141.19 | 140.47 | 140.47 | 4641.0 |
| 2022-05-25 04:05:00 | AAPL | Stock | 140.6 | 140.6 | 140.2 | 140.2 | 4789.0 |
| 2022-05-25 04:10:00 | AAPL | Stock | 140.06 | 140.14 | 140.01 | 140.14 | 1518.0 |
| 2022-05-25 04:15:00 | AAPL | Stock | 140.21 | 140.25 | 140.15 | 140.22 | 2697.0 |
| 2022-05-25 04:20:00 | AAPL | Stock | 140.2 | 140.28 | 140.2 | 140.23 | 6436.0 |
| 2022-05-25 04:25:00 | AAPL | Stock | 140.34 | 140.36 | 140.27 | 140.35 | 2815.0 |
| 2022-05-25 04:30:00 | AAPL | Stock | 140.31 | 140.68 | 140.31 | 140.67 | 2632.0 |
| 2022-05-25 04:35:00 | AAPL | Stock | 140.55 | 140.55 | 140.55 | 140.55 | 448.0 |
| 2022-05-25 04:40:00 | AAPL | Stock | 140.65 | 140.65 | 140.55 | 140.57 | 1171.0 |
| 2022-05-25 04:45:00 | AAPL | Stock | 140.57 | 140.58 | 140.57 | 140.58 | 304.0 |
| 2022-05-25 04:50:00 | AAPL | Stock | 140.48 | 140.66 | 140.46 | 140.63 | 1860.0 |
| 2022-05-25 04:55:00 | AAPL | Stock | 140.7 | 140.7 | 140.34 | 140.4 | 1092.0 |
| 2022-05-25 05:00:00 | AAPL | Stock | 140.36 | 140.36 | 140.21 | 140.21 | 2711.0 |
| 2022-05-25 05:05:00 | AAPL | Stock | 140.21 | 140.29 | 140.21 | 140.22 | 1480.0 |
| 2022-05-25 05:10:00 | AAPL | Stock | 140.25 | 140.25 | 139.92 | 139.92 | 4648.0 |
| 2022-05-25 05:15:00 | AAPL | Stock | 139.88 | 140.05 | 139.76 | 140.01 | 3011.0 |
| 2022-05-25 05:20:00 | AAPL | Stock | 140.07 | 140.07 | 139.92 | 139.93 | 1167.0 |
| 2022-05-25 05:25:00 | AAPL | Stock | 139.9 | 140.11 | 139.7 | 140.11 | 1957.0 |
| 2022-05-25 05:30:00 | AAPL | Stock | 140.0 | 140.0 | 139.96 | 139.96 | 1300.0 |
| 2022-05-25 05:35:00 | AAPL | Stock | 140.12 | 140.23 | 140.12 | 140.23 | 573.0 |
| 2022-05-25 05:40:00 | AAPL | Stock | 140.11 | 140.11 | 140.08 | 140.1 | 500.0 |
| 2022-05-25 05:45:00 | AAPL | Stock | 140.09 | 140.1 | 140.09 | 140.1 | 648.0 |
| 2022-05-25 05:50:00 | AAPL | Stock | 140.24 | 140.5 | 140.24 | 140.5 | 8118.0 |
| 2022-05-25 05:55:00 | AAPL | Stock | 140.45 | 140.5 | 140.45 | 140.45 | 5040.0 |
| 2022-05-25 06:00:00 | AAPL | Stock | 140.4 | 140.4 | 140.35 | 140.35 | 345.0 |
| 2022-05-25 06:10:00 | AAPL | Stock | 140.49 | 140.55 | 140.23 | 140.23 | 11440.0 |
| 2022-05-25 06:15:00 | AAPL | Stock | 140.2 | 140.2 | 140.18 | 140.2 | 939.0 |
| 2022-05-25 06:20:00 | AAPL | Stock | 140.28 | 140.38 | 140.25 | 140.25 | 848.0 |
| 2022-05-25 06:25:00 | AAPL | Stock | 140.24 | 140.39 | 140.24 | 140.34 | 4586.0 |
| 2022-05-25 06:30:00 | AAPL | Stock | 140.21 | 140.21 | 140.0 | 140.11 | 7194.0 |
| 2022-05-25 06:35:00 | AAPL | Stock | 140.17 | 140.17 | 140.09 | 140.09 | 1057.0 |
| 2022-05-25 06:40:00 | AAPL | Stock | 140.21 | 140.28 | 140.02 | 140.04 | 3487.0 |
| 2022-05-25 06:45:00 | AAPL | Stock | 140.03 | 140.03 | 139.9 | 139.9 | 1762.0 |
| 2022-05-25 06:50:00 | AAPL | Stock | 139.91 | 139.91 | 139.61 | 139.8 | 26074.0 |
| 2022-05-25 06:55:00 | AAPL | Stock | 139.8 | 139.8 | 139.63 | 139.65 | 7691.0 |
| 2022-05-25 07:00:00 | AAPL | Stock | 139.65 | 139.85 | 139.53 | 139.76 | 41535.0 |
| 2022-05-25 07:05:00 | AAPL | Stock | 139.75 | 139.8 | 139.66 | 139.73 | 4494.0 |
| 2022-05-25 07:10:00 | AAPL | Stock | 139.7 | 139.7 | 139.03 | 139.35 | 30486.0 |
| 2022-05-25 07:15:00 | AAPL | Stock | 139.3 | 139.3 | 139.02 | 139.3 | 8289.0 |
| 2022-05-25 07:20:00 | AAPL | Stock | 139.28 | 139.35 | 138.93 | 138.93 | 16150.0 |
| 2022-05-25 07:25:00 | AAPL | Stock | 138.95 | 139.09 | 138.78 | 139.09 | 66207.0 |
| 2022-05-25 07:30:00 | AAPL | Stock | 139.09 | 139.14 | 138.86 | 138.95 | 12418.0 |
| 2022-05-25 07:35:00 | AAPL | Stock | 138.92 | 139.0 | 138.77 | 138.9 | 10593.0 |
| 2022-05-25 07:40:00 | AAPL | Stock | 138.93 | 138.96 | 138.7 | 138.8 | 16747.0 |
| 2022-05-25 07:45:00 | AAPL | Stock | 138.8 | 139.0 | 138.67 | 139.0 | 25426.0 |
| 2022-05-25 07:50:00 | AAPL | Stock | 139.02 | 139.02 | 138.93 | 139.0 | 22784.0 |
| 2022-05-25 07:55:00 | AAPL | Stock | 138.96 | 139.15 | 138.82 | 138.89 | 17869.0 |
| 2022-05-25 08:00:00 | AAPL | Stock | 139.7945 | 142.13 | 138.08 | 138.71 | 330060.0 |
| 2022-05-25 08:05:00 | AAPL | Stock | 138.75 | 138.76 | 138.52 | 138.56 | 58370.0 |
| 2022-05-25 08:10:00 | AAPL | Stock | 138.6 | 138.79 | 138.51 | 138.77 | 129394.0 |
> showing 50 of 433,128 rows — these rows as CSV