PREVIEW / stock_5min / 2022-10-18
file: by_date/stock_5min/2022/2022-10-18.parquet size: 6.8 MB rows: 424,258 symbols: 2,174
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-10-18 04:00:00 | AAPL | Stock | 144.21 | 145.25 | 144.02 | 144.76 | 11927.0 |
| 2022-10-18 04:05:00 | AAPL | Stock | 144.9 | 145.0 | 144.76 | 144.76 | 7620.0 |
| 2022-10-18 04:10:00 | AAPL | Stock | 144.79 | 144.85 | 144.74 | 144.8 | 9446.0 |
| 2022-10-18 04:15:00 | AAPL | Stock | 144.79 | 144.89 | 144.75 | 144.75 | 11095.0 |
| 2022-10-18 04:20:00 | AAPL | Stock | 144.73 | 144.73 | 144.6 | 144.65 | 2258.0 |
| 2022-10-18 04:25:00 | AAPL | Stock | 144.65 | 144.95 | 144.65 | 144.88 | 4816.0 |
| 2022-10-18 04:30:00 | AAPL | Stock | 144.89 | 144.89 | 144.75 | 144.75 | 2961.0 |
| 2022-10-18 04:35:00 | AAPL | Stock | 144.73 | 144.74 | 144.59 | 144.59 | 1425.0 |
| 2022-10-18 04:40:00 | AAPL | Stock | 144.56 | 144.59 | 144.41 | 144.48 | 2926.0 |
| 2022-10-18 04:45:00 | AAPL | Stock | 144.4 | 144.53 | 144.4 | 144.53 | 3497.0 |
| 2022-10-18 04:50:00 | AAPL | Stock | 144.56 | 144.56 | 144.56 | 144.56 | 100.0 |
| 2022-10-18 04:55:00 | AAPL | Stock | 144.45 | 144.45 | 144.21 | 144.23 | 4333.0 |
| 2022-10-18 05:00:00 | AAPL | Stock | 144.21 | 144.25 | 144.02 | 144.25 | 8212.0 |
| 2022-10-18 05:05:00 | AAPL | Stock | 144.06 | 144.18 | 143.66 | 143.78 | 6382.0 |
| 2022-10-18 05:10:00 | AAPL | Stock | 143.8 | 144.02 | 143.75 | 143.95 | 3910.0 |
| 2022-10-18 05:15:00 | AAPL | Stock | 143.85 | 144.02 | 143.83 | 143.99 | 1089.0 |
| 2022-10-18 05:20:00 | AAPL | Stock | 144.0 | 144.0 | 143.8 | 143.83 | 5991.0 |
| 2022-10-18 05:25:00 | AAPL | Stock | 143.96 | 143.98 | 143.96 | 143.98 | 2208.0 |
| 2022-10-18 05:30:00 | AAPL | Stock | 143.76 | 143.76 | 143.76 | 143.76 | 172.0 |
| 2022-10-18 05:40:00 | AAPL | Stock | 143.84 | 143.85 | 143.84 | 143.85 | 390.0 |
| 2022-10-18 05:45:00 | AAPL | Stock | 143.86 | 144.1 | 143.82 | 144.03 | 3143.0 |
| 2022-10-18 05:50:00 | AAPL | Stock | 144.0 | 144.2 | 144.0 | 144.2 | 7780.0 |
| 2022-10-18 05:55:00 | AAPL | Stock | 144.16 | 144.38 | 144.16 | 144.38 | 3155.0 |
| 2022-10-18 06:00:00 | AAPL | Stock | 144.36 | 144.38 | 144.34 | 144.37 | 2651.0 |
| 2022-10-18 06:05:00 | AAPL | Stock | 144.37 | 144.37 | 144.32 | 144.32 | 542.0 |
| 2022-10-18 06:10:00 | AAPL | Stock | 144.21 | 144.29 | 144.21 | 144.29 | 1320.0 |
| 2022-10-18 06:15:00 | AAPL | Stock | 144.29 | 144.34 | 144.29 | 144.34 | 442.0 |
| 2022-10-18 06:20:00 | AAPL | Stock | 144.37 | 144.5 | 144.37 | 144.5 | 3731.0 |
| 2022-10-18 06:25:00 | AAPL | Stock | 144.4 | 144.46 | 144.38 | 144.38 | 2946.0 |
| 2022-10-18 06:30:00 | AAPL | Stock | 144.21 | 144.24 | 144.18 | 144.2 | 3328.0 |
| 2022-10-18 06:35:00 | AAPL | Stock | 144.32 | 144.82 | 144.32 | 144.65 | 15073.0 |
| 2022-10-18 06:40:00 | AAPL | Stock | 144.64 | 144.77 | 144.54 | 144.54 | 4040.0 |
| 2022-10-18 06:45:00 | AAPL | Stock | 144.48 | 144.5 | 144.48 | 144.49 | 1163.0 |
| 2022-10-18 06:50:00 | AAPL | Stock | 144.39 | 144.39 | 144.39 | 144.39 | 400.0 |
| 2022-10-18 06:55:00 | AAPL | Stock | 144.28 | 144.28 | 144.2 | 144.23 | 2345.0 |
| 2022-10-18 07:00:00 | AAPL | Stock | 144.23 | 144.56 | 144.16 | 144.55 | 17751.0 |
| 2022-10-18 07:05:00 | AAPL | Stock | 144.49 | 144.65 | 144.36 | 144.64 | 7575.0 |
| 2022-10-18 07:10:00 | AAPL | Stock | 144.55 | 144.75 | 144.37 | 144.55 | 8160.0 |
| 2022-10-18 07:15:00 | AAPL | Stock | 144.55 | 144.67 | 144.5 | 144.55 | 11484.0 |
| 2022-10-18 07:20:00 | AAPL | Stock | 144.59 | 144.62 | 144.59 | 144.62 | 7633.0 |
| 2022-10-18 07:25:00 | AAPL | Stock | 144.6 | 144.76 | 144.6 | 144.75 | 6488.0 |
| 2022-10-18 07:30:00 | AAPL | Stock | 144.77 | 145.0 | 144.77 | 144.93 | 9587.0 |
| 2022-10-18 07:35:00 | AAPL | Stock | 144.94 | 145.01 | 144.86 | 145.01 | 16500.0 |
| 2022-10-18 07:40:00 | AAPL | Stock | 145.0 | 145.0 | 144.7 | 144.7 | 28126.0 |
| 2022-10-18 07:45:00 | AAPL | Stock | 144.69 | 144.79 | 144.6 | 144.79 | 15801.0 |
| 2022-10-18 07:50:00 | AAPL | Stock | 144.8 | 144.9 | 144.72 | 144.81 | 15249.0 |
| 2022-10-18 07:55:00 | AAPL | Stock | 144.81 | 144.83 | 144.74 | 144.74 | 10060.0 |
| 2022-10-18 08:00:00 | AAPL | Stock | 144.35 | 145.66 | 142.054 | 144.75 | 85904.0 |
| 2022-10-18 08:05:00 | AAPL | Stock | 144.6705 | 144.89 | 144.65 | 144.89 | 16360.0 |
| 2022-10-18 08:10:00 | AAPL | Stock | 144.93 | 145.16 | 144.87 | 145.05 | 37780.0 |
> showing 50 of 424,258 rows — these rows as CSV