PREVIEW / stock_5min / 2021-08-12
file: by_date/stock_5min/2021/2021-08-12.parquet size: 7.3 MB rows: 446,380 symbols: 2,813
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 |
|---|---|---|---|---|---|---|---|
| 2021-08-12 04:00:00 | AAPL | Stock | 145.61 | 145.67 | 145.59 | 145.62 | 2188.0 |
| 2021-08-12 04:05:00 | AAPL | Stock | 145.55 | 145.55 | 145.51 | 145.51 | 850.0 |
| 2021-08-12 04:10:00 | AAPL | Stock | 145.5 | 145.5 | 145.5 | 145.5 | 281.0 |
| 2021-08-12 04:30:00 | AAPL | Stock | 145.61 | 145.69 | 145.61 | 145.69 | 702.0 |
| 2021-08-12 04:35:00 | AAPL | Stock | 145.7 | 145.7 | 145.7 | 145.7 | 117.0 |
| 2021-08-12 04:40:00 | AAPL | Stock | 145.84 | 145.84 | 145.84 | 145.84 | 400.0 |
| 2021-08-12 05:00:00 | AAPL | Stock | 145.75 | 145.75 | 145.75 | 145.75 | 100.0 |
| 2021-08-12 05:05:00 | AAPL | Stock | 145.76 | 145.82 | 145.76 | 145.82 | 268.0 |
| 2021-08-12 05:30:00 | AAPL | Stock | 145.78 | 145.78 | 145.78 | 145.78 | 931.0 |
| 2021-08-12 05:40:00 | AAPL | Stock | 145.75 | 145.76 | 145.75 | 145.76 | 1234.0 |
| 2021-08-12 06:10:00 | AAPL | Stock | 145.74 | 145.74 | 145.74 | 145.74 | 130.0 |
| 2021-08-12 06:25:00 | AAPL | Stock | 145.72 | 145.77 | 145.72 | 145.77 | 622.0 |
| 2021-08-12 06:30:00 | AAPL | Stock | 145.8 | 145.8 | 145.8 | 145.8 | 500.0 |
| 2021-08-12 06:40:00 | AAPL | Stock | 145.8 | 145.8 | 145.8 | 145.8 | 239.0 |
| 2021-08-12 06:45:00 | AAPL | Stock | 145.91 | 145.92 | 145.91 | 145.92 | 523.0 |
| 2021-08-12 06:50:00 | AAPL | Stock | 145.92 | 145.92 | 145.92 | 145.92 | 200.0 |
| 2021-08-12 06:55:00 | AAPL | Stock | 145.91 | 145.91 | 145.91 | 145.91 | 251.0 |
| 2021-08-12 07:00:00 | AAPL | Stock | 145.9 | 145.96 | 145.85 | 145.85 | 4485.0 |
| 2021-08-12 07:05:00 | AAPL | Stock | 145.87 | 146.05 | 145.86 | 146.05 | 7922.0 |
| 2021-08-12 07:10:00 | AAPL | Stock | 146.04 | 146.04 | 145.97 | 146.0 | 7426.0 |
| 2021-08-12 07:15:00 | AAPL | Stock | 146.01 | 146.1 | 146.01 | 146.1 | 4839.0 |
| 2021-08-12 07:20:00 | AAPL | Stock | 146.09 | 146.1 | 146.06 | 146.07 | 1899.0 |
| 2021-08-12 07:25:00 | AAPL | Stock | 146.07 | 146.07 | 146.05 | 146.05 | 2675.0 |
| 2021-08-12 07:30:00 | AAPL | Stock | 146.05 | 146.09 | 146.05 | 146.08 | 2652.0 |
| 2021-08-12 07:35:00 | AAPL | Stock | 146.08 | 146.08 | 146.05 | 146.07 | 3063.0 |
| 2021-08-12 07:40:00 | AAPL | Stock | 146.08 | 146.08 | 146.06 | 146.07 | 1844.0 |
| 2021-08-12 07:45:00 | AAPL | Stock | 146.06 | 146.07 | 146.06 | 146.07 | 1488.0 |
| 2021-08-12 07:50:00 | AAPL | Stock | 146.08 | 146.08 | 146.06 | 146.06 | 3137.0 |
| 2021-08-12 07:55:00 | AAPL | Stock | 146.05 | 146.07 | 146.02 | 146.04 | 2930.0 |
| 2021-08-12 08:00:00 | AAPL | Stock | 146.0495 | 146.1 | 145.496 | 146.02 | 38838.0 |
| 2021-08-12 08:05:00 | AAPL | Stock | 146.0 | 146.0 | 145.89 | 145.98 | 11347.0 |
| 2021-08-12 08:10:00 | AAPL | Stock | 145.94 | 145.96 | 145.94 | 145.94 | 2774.0 |
| 2021-08-12 08:15:00 | AAPL | Stock | 145.95 | 146.0 | 145.95 | 145.99 | 6102.0 |
| 2021-08-12 08:20:00 | AAPL | Stock | 145.96 | 145.97 | 145.92 | 145.94 | 8289.0 |
| 2021-08-12 08:25:00 | AAPL | Stock | 145.94 | 145.95 | 145.88 | 145.95 | 5024.0 |
| 2021-08-12 08:30:00 | AAPL | Stock | 145.91 | 145.94 | 145.79 | 145.91 | 12430.0 |
| 2021-08-12 08:35:00 | AAPL | Stock | 145.87 | 145.93 | 145.829 | 145.86 | 15120.0 |
| 2021-08-12 08:40:00 | AAPL | Stock | 145.85 | 145.86 | 145.71 | 145.7101 | 24048.0 |
| 2021-08-12 08:45:00 | AAPL | Stock | 145.72 | 145.73 | 145.6 | 145.6601 | 35953.0 |
| 2021-08-12 08:50:00 | AAPL | Stock | 145.6999 | 145.7 | 145.55 | 145.58 | 20538.0 |
| 2021-08-12 08:55:00 | AAPL | Stock | 145.58 | 145.6 | 145.57 | 145.6 | 14299.0 |
| 2021-08-12 09:00:00 | AAPL | Stock | 145.61 | 145.65 | 145.57 | 145.63 | 26554.0 |
| 2021-08-12 09:05:00 | AAPL | Stock | 145.63 | 145.69 | 145.63 | 145.66 | 17677.0 |
| 2021-08-12 09:10:00 | AAPL | Stock | 145.65 | 145.71 | 145.62 | 145.635 | 25157.0 |
| 2021-08-12 09:15:00 | AAPL | Stock | 145.64 | 145.69 | 145.6 | 145.67 | 9883.0 |
| 2021-08-12 09:20:00 | AAPL | Stock | 145.67 | 145.78 | 145.62 | 145.78 | 13106.0 |
| 2021-08-12 09:25:00 | AAPL | Stock | 145.8 | 146.28 | 145.57 | 146.19 | 166739.0 |
| 2021-08-12 09:30:00 | AAPL | Stock | 146.2 | 146.64 | 145.99 | 146.408 | 2753421.0 |
| 2021-08-12 09:35:00 | AAPL | Stock | 146.39 | 146.39 | 145.84 | 146.245 | 1342650.0 |
| 2021-08-12 09:40:00 | AAPL | Stock | 146.23 | 146.47 | 146.02 | 146.435 | 1167010.0 |
> showing 50 of 446,380 rows — these rows as CSV