PREVIEW / stock_5min / 2022-09-22
file: by_date/stock_5min/2022/2022-09-22.parquet size: 6.9 MB rows: 428,669 symbols: 2,234
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-09-22 04:00:00 | AAPL | Stock | 153.02 | 154.25 | 153.02 | 154.25 | 12949.0 |
| 2022-09-22 04:05:00 | AAPL | Stock | 154.14 | 154.5 | 153.85 | 153.88 | 7467.0 |
| 2022-09-22 04:10:00 | AAPL | Stock | 153.88 | 154.0 | 153.75 | 153.75 | 6249.0 |
| 2022-09-22 04:15:00 | AAPL | Stock | 153.75 | 154.09 | 153.75 | 154.05 | 7063.0 |
| 2022-09-22 04:20:00 | AAPL | Stock | 154.2 | 154.96 | 154.14 | 154.19 | 5300.0 |
| 2022-09-22 04:25:00 | AAPL | Stock | 154.21 | 154.25 | 154.03 | 154.03 | 1221.0 |
| 2022-09-22 04:30:00 | AAPL | Stock | 154.2 | 154.26 | 154.16 | 154.26 | 3955.0 |
| 2022-09-22 04:35:00 | AAPL | Stock | 154.38 | 154.57 | 154.36 | 154.44 | 9038.0 |
| 2022-09-22 04:40:00 | AAPL | Stock | 154.44 | 154.79 | 154.37 | 154.78 | 7246.0 |
| 2022-09-22 04:45:00 | AAPL | Stock | 154.79 | 154.9 | 154.46 | 154.52 | 4307.0 |
| 2022-09-22 04:50:00 | AAPL | Stock | 154.52 | 154.55 | 154.41 | 154.41 | 4513.0 |
| 2022-09-22 04:55:00 | AAPL | Stock | 154.42 | 154.59 | 154.4 | 154.46 | 4841.0 |
| 2022-09-22 05:00:00 | AAPL | Stock | 154.5 | 154.53 | 154.12 | 154.24 | 2899.0 |
| 2022-09-22 05:05:00 | AAPL | Stock | 154.13 | 154.13 | 153.86 | 153.87 | 15023.0 |
| 2022-09-22 05:10:00 | AAPL | Stock | 153.98 | 154.15 | 153.98 | 154.15 | 1556.0 |
| 2022-09-22 05:15:00 | AAPL | Stock | 154.19 | 154.3 | 153.9 | 153.9 | 2174.0 |
| 2022-09-22 05:20:00 | AAPL | Stock | 154.0 | 154.0 | 153.84 | 153.98 | 2500.0 |
| 2022-09-22 05:25:00 | AAPL | Stock | 153.89 | 153.95 | 153.89 | 153.95 | 200.0 |
| 2022-09-22 05:30:00 | AAPL | Stock | 153.91 | 154.13 | 153.88 | 154.13 | 848.0 |
| 2022-09-22 05:35:00 | AAPL | Stock | 153.9 | 153.9 | 153.63 | 153.7 | 3684.0 |
| 2022-09-22 05:40:00 | AAPL | Stock | 153.65 | 153.67 | 153.6 | 153.64 | 2969.0 |
| 2022-09-22 05:45:00 | AAPL | Stock | 153.7 | 153.92 | 153.64 | 153.72 | 2142.0 |
| 2022-09-22 05:50:00 | AAPL | Stock | 153.7 | 153.7 | 153.57 | 153.57 | 1297.0 |
| 2022-09-22 05:55:00 | AAPL | Stock | 153.85 | 153.88 | 153.84 | 153.88 | 1657.0 |
| 2022-09-22 06:00:00 | AAPL | Stock | 153.78 | 153.82 | 153.58 | 153.58 | 615.0 |
| 2022-09-22 06:10:00 | AAPL | Stock | 153.84 | 153.84 | 153.77 | 153.77 | 380.0 |
| 2022-09-22 06:20:00 | AAPL | Stock | 153.72 | 153.72 | 153.55 | 153.55 | 2217.0 |
| 2022-09-22 06:30:00 | AAPL | Stock | 153.93 | 154.0 | 153.93 | 153.95 | 3430.0 |
| 2022-09-22 06:35:00 | AAPL | Stock | 153.84 | 153.99 | 153.83 | 153.99 | 2088.0 |
| 2022-09-22 06:55:00 | AAPL | Stock | 153.84 | 153.98 | 153.81 | 153.98 | 450.0 |
| 2022-09-22 07:00:00 | AAPL | Stock | 153.9 | 154.0 | 153.6 | 153.7 | 10745.0 |
| 2022-09-22 07:05:00 | AAPL | Stock | 153.77 | 153.77 | 153.41 | 153.41 | 6208.0 |
| 2022-09-22 07:10:00 | AAPL | Stock | 153.35 | 153.36 | 153.2 | 153.2 | 4972.0 |
| 2022-09-22 07:15:00 | AAPL | Stock | 153.24 | 153.45 | 153.24 | 153.28 | 10008.0 |
| 2022-09-22 07:20:00 | AAPL | Stock | 153.33 | 153.34 | 153.11 | 153.27 | 3339.0 |
| 2022-09-22 07:25:00 | AAPL | Stock | 153.28 | 153.28 | 153.0 | 153.0 | 7618.0 |
| 2022-09-22 07:30:00 | AAPL | Stock | 153.05 | 153.1 | 153.01 | 153.08 | 4248.0 |
| 2022-09-22 07:35:00 | AAPL | Stock | 153.1 | 153.4 | 153.1 | 153.31 | 4903.0 |
| 2022-09-22 07:40:00 | AAPL | Stock | 153.27 | 153.35 | 153.22 | 153.35 | 2908.0 |
| 2022-09-22 07:45:00 | AAPL | Stock | 153.31 | 153.31 | 153.08 | 153.11 | 4373.0 |
| 2022-09-22 07:50:00 | AAPL | Stock | 153.19 | 153.5 | 153.19 | 153.45 | 6194.0 |
| 2022-09-22 07:55:00 | AAPL | Stock | 153.48 | 153.75 | 153.47 | 153.53 | 5996.0 |
| 2022-09-22 08:00:00 | AAPL | Stock | 153.581 | 154.0 | 152.91 | 153.6676 | 64247.0 |
| 2022-09-22 08:05:00 | AAPL | Stock | 153.67 | 153.67 | 153.45 | 153.64 | 3850.0 |
| 2022-09-22 08:10:00 | AAPL | Stock | 153.62 | 153.88 | 153.62 | 153.85 | 14234.0 |
| 2022-09-22 08:15:00 | AAPL | Stock | 153.86 | 153.94 | 153.8 | 153.83 | 19059.0 |
| 2022-09-22 08:20:00 | AAPL | Stock | 153.83 | 153.86 | 153.61 | 153.6101 | 9033.0 |
| 2022-09-22 08:25:00 | AAPL | Stock | 153.64 | 153.9 | 153.64 | 153.64 | 14685.0 |
| 2022-09-22 08:30:00 | AAPL | Stock | 153.6 | 153.6 | 153.01 | 153.49 | 22123.0 |
| 2022-09-22 08:35:00 | AAPL | Stock | 153.45 | 153.88 | 153.38 | 153.66 | 18748.0 |
> showing 50 of 428,669 rows — these rows as CSV