PREVIEW / stock_5min / 2022-01-28
file: by_date/stock_5min/2022/2022-01-28.parquet size: 7.4 MB rows: 462,417 symbols: 2,646
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-01-28 04:00:00 | AAPL | Stock | 167.8 | 167.8 | 166.06 | 166.15 | 28968.0 |
| 2022-01-28 04:05:00 | AAPL | Stock | 166.09 | 166.2 | 165.75 | 166.2 | 19171.0 |
| 2022-01-28 04:10:00 | AAPL | Stock | 166.2 | 167.36 | 166.2 | 167.02 | 18782.0 |
| 2022-01-28 04:15:00 | AAPL | Stock | 167.02 | 167.04 | 166.7 | 166.71 | 3913.0 |
| 2022-01-28 04:20:00 | AAPL | Stock | 166.6 | 166.92 | 166.57 | 166.86 | 3150.0 |
| 2022-01-28 04:25:00 | AAPL | Stock | 166.85 | 166.9 | 166.6 | 166.62 | 3590.0 |
| 2022-01-28 04:30:00 | AAPL | Stock | 166.68 | 166.75 | 166.5 | 166.5 | 8535.0 |
| 2022-01-28 04:35:00 | AAPL | Stock | 166.56 | 166.6 | 166.18 | 166.29 | 10449.0 |
| 2022-01-28 04:40:00 | AAPL | Stock | 166.26 | 166.4 | 166.15 | 166.28 | 8815.0 |
| 2022-01-28 04:45:00 | AAPL | Stock | 166.17 | 166.25 | 166.0 | 166.0 | 14116.0 |
| 2022-01-28 04:50:00 | AAPL | Stock | 166.0 | 166.08 | 165.75 | 166.0 | 10900.0 |
| 2022-01-28 04:55:00 | AAPL | Stock | 166.05 | 166.22 | 165.79 | 165.91 | 4793.0 |
| 2022-01-28 05:00:00 | AAPL | Stock | 165.99 | 166.0 | 165.6 | 165.75 | 7652.0 |
| 2022-01-28 05:05:00 | AAPL | Stock | 165.75 | 165.87 | 165.36 | 165.48 | 10371.0 |
| 2022-01-28 05:10:00 | AAPL | Stock | 165.4 | 165.6 | 165.4 | 165.57 | 14244.0 |
| 2022-01-28 05:15:00 | AAPL | Stock | 165.6 | 165.6 | 165.15 | 165.15 | 30955.0 |
| 2022-01-28 05:20:00 | AAPL | Stock | 165.2 | 165.61 | 165.15 | 165.58 | 15954.0 |
| 2022-01-28 05:25:00 | AAPL | Stock | 165.55 | 165.9 | 165.55 | 165.6 | 10583.0 |
| 2022-01-28 05:30:00 | AAPL | Stock | 165.58 | 165.6 | 165.37 | 165.51 | 1440.0 |
| 2022-01-28 05:35:00 | AAPL | Stock | 165.44 | 165.5 | 165.1 | 165.1 | 11087.0 |
| 2022-01-28 05:40:00 | AAPL | Stock | 165.21 | 165.59 | 165.1 | 165.59 | 9405.0 |
| 2022-01-28 05:45:00 | AAPL | Stock | 165.57 | 165.67 | 165.5 | 165.58 | 7527.0 |
| 2022-01-28 05:50:00 | AAPL | Stock | 165.55 | 165.55 | 165.04 | 165.19 | 7330.0 |
| 2022-01-28 05:55:00 | AAPL | Stock | 165.11 | 165.67 | 165.02 | 165.67 | 6408.0 |
| 2022-01-28 06:00:00 | AAPL | Stock | 165.68 | 165.76 | 165.52 | 165.52 | 6675.0 |
| 2022-01-28 06:05:00 | AAPL | Stock | 165.43 | 165.51 | 165.31 | 165.31 | 2501.0 |
| 2022-01-28 06:10:00 | AAPL | Stock | 165.35 | 165.35 | 165.01 | 165.01 | 10886.0 |
| 2022-01-28 06:15:00 | AAPL | Stock | 165.01 | 165.01 | 164.31 | 164.4 | 86773.0 |
| 2022-01-28 06:20:00 | AAPL | Stock | 164.49 | 164.95 | 164.29 | 164.95 | 14050.0 |
| 2022-01-28 06:25:00 | AAPL | Stock | 164.93 | 165.34 | 164.85 | 165.26 | 7377.0 |
| 2022-01-28 06:30:00 | AAPL | Stock | 165.35 | 165.4 | 164.75 | 164.75 | 5539.0 |
| 2022-01-28 06:35:00 | AAPL | Stock | 165.0 | 165.26 | 164.9 | 164.9 | 1461.0 |
| 2022-01-28 06:40:00 | AAPL | Stock | 164.8 | 165.13 | 164.65 | 164.99 | 5429.0 |
| 2022-01-28 06:45:00 | AAPL | Stock | 164.76 | 165.46 | 164.76 | 165.04 | 19288.0 |
| 2022-01-28 06:50:00 | AAPL | Stock | 165.35 | 165.35 | 164.95 | 164.95 | 1470.0 |
| 2022-01-28 06:55:00 | AAPL | Stock | 164.99 | 165.5 | 164.96 | 165.4 | 9478.0 |
| 2022-01-28 07:00:00 | AAPL | Stock | 165.5 | 165.94 | 165.14 | 165.59 | 115743.0 |
| 2022-01-28 07:05:00 | AAPL | Stock | 165.41 | 165.7 | 165.13 | 165.13 | 35436.0 |
| 2022-01-28 07:10:00 | AAPL | Stock | 165.12 | 165.39 | 164.9 | 164.92 | 41865.0 |
| 2022-01-28 07:15:00 | AAPL | Stock | 164.95 | 165.0 | 164.43 | 164.55 | 62472.0 |
| 2022-01-28 07:20:00 | AAPL | Stock | 164.55 | 164.73 | 163.93 | 164.21 | 108392.0 |
| 2022-01-28 07:25:00 | AAPL | Stock | 164.23 | 164.48 | 163.7 | 164.3 | 43222.0 |
| 2022-01-28 07:30:00 | AAPL | Stock | 164.3 | 164.3 | 164.0 | 164.24 | 30731.0 |
| 2022-01-28 07:35:00 | AAPL | Stock | 164.22 | 164.25 | 162.8 | 162.99 | 116424.0 |
| 2022-01-28 07:40:00 | AAPL | Stock | 163.04 | 163.64 | 162.88 | 163.0 | 92236.0 |
| 2022-01-28 07:45:00 | AAPL | Stock | 163.0 | 163.3 | 162.88 | 163.21 | 76769.0 |
| 2022-01-28 07:50:00 | AAPL | Stock | 163.18 | 163.8 | 163.1 | 163.7 | 80586.0 |
| 2022-01-28 07:55:00 | AAPL | Stock | 163.66 | 163.7 | 163.22 | 163.39 | 91157.0 |
| 2022-01-28 08:00:00 | AAPL | Stock | 165.4501 | 165.79 | 162.88 | 163.0 | 581794.0 |
| 2022-01-28 08:05:00 | AAPL | Stock | 162.99 | 163.0 | 161.9 | 161.97 | 207327.0 |
> showing 50 of 462,417 rows — these rows as CSV