PREVIEW / stock_5min / 2022-08-18
file: by_date/stock_5min/2022/2022-08-18.parquet size: 6.9 MB rows: 425,710 symbols: 2,237
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-08-18 04:00:00 | AAPL | Stock | 173.81 | 173.81 | 173.3 | 173.59 | 13915.0 |
| 2022-08-18 04:05:00 | AAPL | Stock | 173.57 | 173.59 | 173.44 | 173.5 | 15234.0 |
| 2022-08-18 04:10:00 | AAPL | Stock | 173.47 | 173.48 | 173.42 | 173.48 | 4997.0 |
| 2022-08-18 04:15:00 | AAPL | Stock | 173.48 | 173.48 | 173.39 | 173.39 | 2254.0 |
| 2022-08-18 04:20:00 | AAPL | Stock | 173.3 | 173.3 | 173.25 | 173.3 | 1105.0 |
| 2022-08-18 04:25:00 | AAPL | Stock | 173.33 | 173.34 | 173.3 | 173.34 | 5904.0 |
| 2022-08-18 04:30:00 | AAPL | Stock | 173.34 | 173.34 | 173.28 | 173.28 | 8065.0 |
| 2022-08-18 04:40:00 | AAPL | Stock | 173.3 | 173.48 | 173.3 | 173.43 | 3385.0 |
| 2022-08-18 04:45:00 | AAPL | Stock | 173.48 | 173.59 | 173.48 | 173.59 | 5880.0 |
| 2022-08-18 04:50:00 | AAPL | Stock | 173.65 | 173.65 | 173.54 | 173.54 | 2114.0 |
| 2022-08-18 04:55:00 | AAPL | Stock | 173.49 | 173.69 | 173.48 | 173.63 | 2606.0 |
| 2022-08-18 05:00:00 | AAPL | Stock | 173.54 | 173.64 | 173.54 | 173.64 | 650.0 |
| 2022-08-18 05:05:00 | AAPL | Stock | 173.57 | 173.79 | 173.57 | 173.79 | 1418.0 |
| 2022-08-18 05:10:00 | AAPL | Stock | 173.66 | 173.72 | 173.66 | 173.72 | 1398.0 |
| 2022-08-18 05:15:00 | AAPL | Stock | 173.7 | 173.76 | 173.7 | 173.74 | 613.0 |
| 2022-08-18 05:20:00 | AAPL | Stock | 173.8 | 173.8 | 173.77 | 173.77 | 1102.0 |
| 2022-08-18 05:25:00 | AAPL | Stock | 173.8 | 173.94 | 173.8 | 173.94 | 4264.0 |
| 2022-08-18 05:30:00 | AAPL | Stock | 173.9 | 173.9 | 173.9 | 173.9 | 180.0 |
| 2022-08-18 05:35:00 | AAPL | Stock | 173.97 | 173.97 | 173.97 | 173.97 | 500.0 |
| 2022-08-18 05:40:00 | AAPL | Stock | 173.96 | 174.0 | 173.95 | 173.97 | 2348.0 |
| 2022-08-18 05:45:00 | AAPL | Stock | 173.97 | 174.0 | 173.97 | 173.99 | 491.0 |
| 2022-08-18 05:50:00 | AAPL | Stock | 174.13 | 174.15 | 174.13 | 174.15 | 200.0 |
| 2022-08-18 05:55:00 | AAPL | Stock | 174.1 | 174.1 | 174.1 | 174.1 | 100.0 |
| 2022-08-18 06:00:00 | AAPL | Stock | 174.15 | 174.19 | 174.01 | 174.19 | 1912.0 |
| 2022-08-18 06:05:00 | AAPL | Stock | 174.19 | 174.2 | 174.19 | 174.19 | 983.0 |
| 2022-08-18 06:10:00 | AAPL | Stock | 174.15 | 174.15 | 174.15 | 174.15 | 178.0 |
| 2022-08-18 06:15:00 | AAPL | Stock | 174.0 | 174.0 | 173.99 | 174.0 | 400.0 |
| 2022-08-18 06:20:00 | AAPL | Stock | 173.98 | 174.01 | 173.9 | 174.0 | 6589.0 |
| 2022-08-18 06:25:00 | AAPL | Stock | 173.99 | 174.01 | 173.99 | 174.0 | 1055.0 |
| 2022-08-18 06:30:00 | AAPL | Stock | 173.91 | 173.91 | 173.9 | 173.9 | 3024.0 |
| 2022-08-18 06:35:00 | AAPL | Stock | 174.02 | 174.12 | 174.02 | 174.12 | 1521.0 |
| 2022-08-18 06:40:00 | AAPL | Stock | 174.11 | 174.15 | 174.05 | 174.05 | 2991.0 |
| 2022-08-18 06:45:00 | AAPL | Stock | 174.02 | 174.02 | 173.8 | 173.9 | 5102.0 |
| 2022-08-18 06:50:00 | AAPL | Stock | 173.85 | 173.88 | 173.85 | 173.86 | 1233.0 |
| 2022-08-18 06:55:00 | AAPL | Stock | 173.85 | 173.95 | 173.84 | 173.95 | 2975.0 |
| 2022-08-18 07:00:00 | AAPL | Stock | 173.98 | 174.0 | 173.86 | 173.95 | 9235.0 |
| 2022-08-18 07:05:00 | AAPL | Stock | 173.99 | 174.1 | 173.99 | 174.05 | 4318.0 |
| 2022-08-18 07:10:00 | AAPL | Stock | 174.09 | 174.14 | 174.09 | 174.13 | 3658.0 |
| 2022-08-18 07:15:00 | AAPL | Stock | 174.14 | 174.17 | 174.08 | 174.08 | 4332.0 |
| 2022-08-18 07:20:00 | AAPL | Stock | 174.08 | 174.08 | 174.03 | 174.08 | 1966.0 |
| 2022-08-18 07:25:00 | AAPL | Stock | 174.08 | 174.09 | 173.9 | 173.92 | 9313.0 |
| 2022-08-18 07:30:00 | AAPL | Stock | 173.89 | 174.15 | 173.89 | 174.15 | 7269.0 |
| 2022-08-18 07:35:00 | AAPL | Stock | 174.15 | 174.25 | 174.09 | 174.09 | 9714.0 |
| 2022-08-18 07:40:00 | AAPL | Stock | 174.11 | 174.12 | 174.02 | 174.09 | 1854.0 |
| 2022-08-18 07:45:00 | AAPL | Stock | 174.06 | 174.08 | 173.95 | 174.04 | 9812.0 |
| 2022-08-18 07:50:00 | AAPL | Stock | 174.03 | 174.06 | 173.97 | 174.06 | 3580.0 |
| 2022-08-18 07:55:00 | AAPL | Stock | 174.0 | 174.13 | 174.0 | 174.13 | 2116.0 |
| 2022-08-18 08:00:00 | AAPL | Stock | 173.91 | 174.25 | 172.52 | 174.2201 | 152463.0 |
| 2022-08-18 08:05:00 | AAPL | Stock | 174.22 | 174.39 | 174.1 | 174.1 | 47826.0 |
| 2022-08-18 08:10:00 | AAPL | Stock | 174.11 | 174.18 | 173.98 | 174.01 | 27910.0 |
> showing 50 of 425,710 rows — these rows as CSV