PREVIEW / stock_5min / 2022-07-28
file: by_date/stock_5min/2022/2022-07-28.parquet size: 7.0 MB rows: 431,754 symbols: 2,290
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-07-28 04:00:00 | AAPL | Stock | 155.39 | 156.09 | 155.39 | 155.91 | 8069.0 |
| 2022-07-28 04:05:00 | AAPL | Stock | 155.77 | 155.77 | 155.42 | 155.57 | 4346.0 |
| 2022-07-28 04:10:00 | AAPL | Stock | 155.83 | 155.93 | 155.73 | 155.93 | 6440.0 |
| 2022-07-28 04:15:00 | AAPL | Stock | 155.93 | 155.95 | 155.88 | 155.91 | 2046.0 |
| 2022-07-28 04:20:00 | AAPL | Stock | 155.89 | 155.95 | 155.59 | 155.59 | 5291.0 |
| 2022-07-28 04:25:00 | AAPL | Stock | 155.62 | 155.66 | 155.53 | 155.53 | 1001.0 |
| 2022-07-28 04:30:00 | AAPL | Stock | 155.56 | 155.69 | 155.52 | 155.54 | 5955.0 |
| 2022-07-28 04:35:00 | AAPL | Stock | 155.52 | 155.58 | 155.52 | 155.56 | 906.0 |
| 2022-07-28 04:40:00 | AAPL | Stock | 155.56 | 155.68 | 155.56 | 155.64 | 1801.0 |
| 2022-07-28 04:45:00 | AAPL | Stock | 155.62 | 155.62 | 155.61 | 155.61 | 400.0 |
| 2022-07-28 04:50:00 | AAPL | Stock | 155.6 | 155.67 | 155.53 | 155.53 | 3704.0 |
| 2022-07-28 04:55:00 | AAPL | Stock | 155.53 | 155.57 | 155.53 | 155.57 | 1023.0 |
| 2022-07-28 05:00:00 | AAPL | Stock | 155.52 | 155.64 | 155.52 | 155.64 | 558.0 |
| 2022-07-28 05:05:00 | AAPL | Stock | 155.64 | 155.64 | 155.52 | 155.52 | 700.0 |
| 2022-07-28 05:10:00 | AAPL | Stock | 155.52 | 155.53 | 155.45 | 155.45 | 2567.0 |
| 2022-07-28 05:15:00 | AAPL | Stock | 155.4 | 155.4 | 155.39 | 155.39 | 2283.0 |
| 2022-07-28 05:20:00 | AAPL | Stock | 155.39 | 155.41 | 155.38 | 155.4 | 975.0 |
| 2022-07-28 05:25:00 | AAPL | Stock | 155.35 | 155.35 | 155.3 | 155.3 | 1358.0 |
| 2022-07-28 05:30:00 | AAPL | Stock | 155.34 | 155.44 | 155.34 | 155.44 | 1718.0 |
| 2022-07-28 05:35:00 | AAPL | Stock | 155.46 | 155.66 | 155.41 | 155.66 | 4715.0 |
| 2022-07-28 05:40:00 | AAPL | Stock | 155.65 | 155.71 | 155.64 | 155.65 | 3882.0 |
| 2022-07-28 05:45:00 | AAPL | Stock | 155.67 | 155.73 | 155.65 | 155.68 | 5938.0 |
| 2022-07-28 05:50:00 | AAPL | Stock | 155.7 | 155.75 | 155.64 | 155.73 | 2634.0 |
| 2022-07-28 05:55:00 | AAPL | Stock | 155.72 | 155.84 | 155.68 | 155.84 | 8003.0 |
| 2022-07-28 06:00:00 | AAPL | Stock | 155.84 | 155.89 | 155.82 | 155.82 | 6449.0 |
| 2022-07-28 06:05:00 | AAPL | Stock | 155.81 | 155.89 | 155.8 | 155.8 | 4886.0 |
| 2022-07-28 06:10:00 | AAPL | Stock | 155.75 | 155.79 | 155.69 | 155.69 | 1989.0 |
| 2022-07-28 06:15:00 | AAPL | Stock | 155.67 | 155.89 | 155.67 | 155.88 | 7318.0 |
| 2022-07-28 06:20:00 | AAPL | Stock | 155.79 | 155.8 | 155.79 | 155.8 | 800.0 |
| 2022-07-28 06:30:00 | AAPL | Stock | 155.9 | 155.9 | 155.87 | 155.87 | 500.0 |
| 2022-07-28 06:35:00 | AAPL | Stock | 155.9 | 155.9 | 155.9 | 155.9 | 114.0 |
| 2022-07-28 06:40:00 | AAPL | Stock | 155.9 | 155.9 | 155.89 | 155.9 | 338.0 |
| 2022-07-28 06:45:00 | AAPL | Stock | 155.89 | 155.9 | 155.81 | 155.85 | 902.0 |
| 2022-07-28 06:50:00 | AAPL | Stock | 155.8 | 155.81 | 155.71 | 155.71 | 1159.0 |
| 2022-07-28 06:55:00 | AAPL | Stock | 155.79 | 155.81 | 155.75 | 155.81 | 3872.0 |
| 2022-07-28 07:00:00 | AAPL | Stock | 155.84 | 156.14 | 155.8 | 156.1 | 11923.0 |
| 2022-07-28 07:05:00 | AAPL | Stock | 156.14 | 156.14 | 156.02 | 156.1 | 7489.0 |
| 2022-07-28 07:10:00 | AAPL | Stock | 156.1 | 156.1 | 156.0 | 156.1 | 4067.0 |
| 2022-07-28 07:15:00 | AAPL | Stock | 156.1 | 156.19 | 156.1 | 156.13 | 6499.0 |
| 2022-07-28 07:20:00 | AAPL | Stock | 156.06 | 156.06 | 156.0 | 156.05 | 2783.0 |
| 2022-07-28 07:25:00 | AAPL | Stock | 156.05 | 156.07 | 156.02 | 156.07 | 844.0 |
| 2022-07-28 07:30:00 | AAPL | Stock | 156.03 | 156.05 | 156.03 | 156.05 | 1531.0 |
| 2022-07-28 07:35:00 | AAPL | Stock | 156.03 | 156.03 | 156.0 | 156.0 | 676.0 |
| 2022-07-28 07:40:00 | AAPL | Stock | 155.99 | 155.99 | 155.9 | 155.93 | 2124.0 |
| 2022-07-28 07:45:00 | AAPL | Stock | 155.95 | 155.95 | 155.92 | 155.92 | 600.0 |
| 2022-07-28 07:50:00 | AAPL | Stock | 155.95 | 155.99 | 155.95 | 155.99 | 1067.0 |
| 2022-07-28 07:55:00 | AAPL | Stock | 155.98 | 155.98 | 155.95 | 155.96 | 1367.0 |
| 2022-07-28 08:00:00 | AAPL | Stock | 156.12 | 156.399 | 155.8 | 155.8117 | 63603.0 |
| 2022-07-28 08:05:00 | AAPL | Stock | 155.82 | 155.86 | 155.78 | 155.83 | 9557.0 |
| 2022-07-28 08:10:00 | AAPL | Stock | 155.84 | 155.92 | 155.84 | 155.9 | 3527.0 |
> showing 50 of 431,754 rows — these rows as CSV