PREVIEW / stock_5min / 2023-03-20
file: by_date/stock_5min/2023/2023-03-20.parquet size: 6.9 MB rows: 425,350 symbols: 1,759
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-20 04:00:00 | AAPL | Stock | 154.38 | 154.43 | 151.75 | 154.37 | 4755.0 |
| 2023-03-20 04:05:00 | AAPL | Stock | 154.35 | 154.49 | 154.12 | 154.49 | 8797.0 |
| 2023-03-20 04:10:00 | AAPL | Stock | 154.27 | 154.4 | 154.19 | 154.4 | 23771.0 |
| 2023-03-20 04:15:00 | AAPL | Stock | 154.27 | 154.27 | 153.72 | 153.8 | 4823.0 |
| 2023-03-20 04:20:00 | AAPL | Stock | 153.88 | 153.9 | 153.68 | 153.68 | 2164.0 |
| 2023-03-20 04:25:00 | AAPL | Stock | 153.87 | 154.11 | 153.87 | 154.11 | 4351.0 |
| 2023-03-20 04:30:00 | AAPL | Stock | 153.99 | 154.0 | 153.85 | 153.85 | 1343.0 |
| 2023-03-20 04:35:00 | AAPL | Stock | 154.09 | 154.46 | 154.09 | 154.46 | 1944.0 |
| 2023-03-20 04:40:00 | AAPL | Stock | 154.47 | 154.5 | 154.38 | 154.43 | 3052.0 |
| 2023-03-20 04:45:00 | AAPL | Stock | 154.45 | 154.58 | 154.4 | 154.44 | 1295.0 |
| 2023-03-20 04:50:00 | AAPL | Stock | 154.37 | 154.66 | 154.37 | 154.37 | 4882.0 |
| 2023-03-20 04:55:00 | AAPL | Stock | 154.56 | 154.62 | 154.52 | 154.62 | 1556.0 |
| 2023-03-20 05:00:00 | AAPL | Stock | 154.64 | 154.68 | 154.64 | 154.68 | 4638.0 |
| 2023-03-20 05:05:00 | AAPL | Stock | 154.68 | 154.68 | 154.65 | 154.65 | 300.0 |
| 2023-03-20 05:10:00 | AAPL | Stock | 154.59 | 154.59 | 154.59 | 154.59 | 100.0 |
| 2023-03-20 05:15:00 | AAPL | Stock | 154.23 | 154.55 | 154.21 | 154.55 | 11517.0 |
| 2023-03-20 05:20:00 | AAPL | Stock | 154.55 | 154.88 | 154.55 | 154.63 | 8083.0 |
| 2023-03-20 05:25:00 | AAPL | Stock | 154.62 | 154.74 | 154.47 | 154.65 | 1000.0 |
| 2023-03-20 05:30:00 | AAPL | Stock | 154.74 | 156.0 | 154.72 | 155.8 | 9296.0 |
| 2023-03-20 05:35:00 | AAPL | Stock | 155.8 | 155.8 | 155.42 | 155.55 | 1449.0 |
| 2023-03-20 05:40:00 | AAPL | Stock | 155.39 | 155.55 | 155.36 | 155.36 | 3214.0 |
| 2023-03-20 05:45:00 | AAPL | Stock | 155.4 | 155.4 | 155.4 | 155.4 | 500.0 |
| 2023-03-20 05:50:00 | AAPL | Stock | 155.5 | 155.59 | 155.42 | 155.42 | 5709.0 |
| 2023-03-20 05:55:00 | AAPL | Stock | 155.42 | 155.64 | 155.42 | 155.5 | 2764.0 |
| 2023-03-20 06:00:00 | AAPL | Stock | 155.31 | 155.31 | 155.31 | 155.31 | 200.0 |
| 2023-03-20 06:05:00 | AAPL | Stock | 155.49 | 155.65 | 155.49 | 155.65 | 1449.0 |
| 2023-03-20 06:10:00 | AAPL | Stock | 155.65 | 155.65 | 155.45 | 155.45 | 1922.0 |
| 2023-03-20 06:15:00 | AAPL | Stock | 155.38 | 155.45 | 155.21 | 155.21 | 3386.0 |
| 2023-03-20 06:20:00 | AAPL | Stock | 155.21 | 155.21 | 155.03 | 155.05 | 5472.0 |
| 2023-03-20 06:25:00 | AAPL | Stock | 155.24 | 155.25 | 155.2 | 155.2 | 1549.0 |
| 2023-03-20 06:30:00 | AAPL | Stock | 155.2 | 155.27 | 155.19 | 155.27 | 1869.0 |
| 2023-03-20 06:35:00 | AAPL | Stock | 155.26 | 155.49 | 155.26 | 155.49 | 475.0 |
| 2023-03-20 06:40:00 | AAPL | Stock | 155.35 | 155.35 | 155.35 | 155.35 | 100.0 |
| 2023-03-20 06:45:00 | AAPL | Stock | 155.39 | 155.39 | 155.39 | 155.39 | 100.0 |
| 2023-03-20 06:50:00 | AAPL | Stock | 155.41 | 155.41 | 155.14 | 155.26 | 1889.0 |
| 2023-03-20 06:55:00 | AAPL | Stock | 155.46 | 155.5 | 155.46 | 155.5 | 2040.0 |
| 2023-03-20 07:00:00 | AAPL | Stock | 155.41 | 155.5 | 155.17 | 155.34 | 5169.0 |
| 2023-03-20 07:05:00 | AAPL | Stock | 155.27 | 155.27 | 155.01 | 155.15 | 4089.0 |
| 2023-03-20 07:10:00 | AAPL | Stock | 155.18 | 155.18 | 154.94 | 154.95 | 6405.0 |
| 2023-03-20 07:15:00 | AAPL | Stock | 154.8 | 154.92 | 154.77 | 154.82 | 1943.0 |
| 2023-03-20 07:20:00 | AAPL | Stock | 154.96 | 155.1 | 154.82 | 155.1 | 5327.0 |
| 2023-03-20 07:25:00 | AAPL | Stock | 155.15 | 155.44 | 155.15 | 155.44 | 6726.0 |
| 2023-03-20 07:30:00 | AAPL | Stock | 155.3 | 155.56 | 155.2 | 155.2 | 7318.0 |
| 2023-03-20 07:35:00 | AAPL | Stock | 155.07 | 155.1 | 155.07 | 155.1 | 846.0 |
| 2023-03-20 07:40:00 | AAPL | Stock | 155.07 | 155.2 | 154.85 | 154.85 | 6347.0 |
| 2023-03-20 07:45:00 | AAPL | Stock | 154.87 | 154.9 | 154.7 | 154.82 | 3408.0 |
| 2023-03-20 07:50:00 | AAPL | Stock | 154.88 | 155.1 | 154.88 | 154.95 | 2147.0 |
| 2023-03-20 07:55:00 | AAPL | Stock | 155.0 | 155.1 | 155.0 | 155.1 | 3743.0 |
| 2023-03-20 08:00:00 | AAPL | Stock | 155.15 | 155.45 | 153.68 | 155.11 | 35161.0 |
| 2023-03-20 08:05:00 | AAPL | Stock | 155.02 | 155.0956 | 154.8052 | 154.87 | 7813.0 |
> showing 50 of 425,350 rows — these rows as CSV