PREVIEW / stock_5min / 2022-02-22
file: by_date/stock_5min/2022/2022-02-22.parquet size: 7.5 MB rows: 463,806 symbols: 2,547
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-02-22 04:00:00 | AAPL | Stock | 166.0 | 166.0 | 162.24 | 163.09 | 25638.0 |
| 2022-02-22 04:05:00 | AAPL | Stock | 163.02 | 163.2 | 162.95 | 163.04 | 8697.0 |
| 2022-02-22 04:10:00 | AAPL | Stock | 163.24 | 163.26 | 163.06 | 163.22 | 4726.0 |
| 2022-02-22 04:15:00 | AAPL | Stock | 163.39 | 163.55 | 163.23 | 163.55 | 4940.0 |
| 2022-02-22 04:20:00 | AAPL | Stock | 163.54 | 163.82 | 163.52 | 163.52 | 27468.0 |
| 2022-02-22 04:25:00 | AAPL | Stock | 163.59 | 163.88 | 163.51 | 163.8 | 8542.0 |
| 2022-02-22 04:30:00 | AAPL | Stock | 163.9 | 164.09 | 163.9 | 164.02 | 6685.0 |
| 2022-02-22 04:35:00 | AAPL | Stock | 164.09 | 164.15 | 164.0 | 164.15 | 6104.0 |
| 2022-02-22 04:40:00 | AAPL | Stock | 164.09 | 164.09 | 163.91 | 163.96 | 4569.0 |
| 2022-02-22 04:45:00 | AAPL | Stock | 163.92 | 164.02 | 163.89 | 163.91 | 5001.0 |
| 2022-02-22 04:50:00 | AAPL | Stock | 163.9 | 164.15 | 163.9 | 164.1 | 3862.0 |
| 2022-02-22 04:55:00 | AAPL | Stock | 164.1 | 164.1 | 163.72 | 163.84 | 3937.0 |
| 2022-02-22 05:00:00 | AAPL | Stock | 163.84 | 163.91 | 163.71 | 163.86 | 4376.0 |
| 2022-02-22 05:05:00 | AAPL | Stock | 163.96 | 164.16 | 163.96 | 164.16 | 2039.0 |
| 2022-02-22 05:10:00 | AAPL | Stock | 164.1 | 164.56 | 164.0 | 164.4 | 5220.0 |
| 2022-02-22 05:15:00 | AAPL | Stock | 164.41 | 164.57 | 164.41 | 164.57 | 4243.0 |
| 2022-02-22 05:20:00 | AAPL | Stock | 164.7 | 165.1 | 164.6 | 165.1 | 6453.0 |
| 2022-02-22 05:25:00 | AAPL | Stock | 165.05 | 165.29 | 165.05 | 165.29 | 8057.0 |
| 2022-02-22 05:30:00 | AAPL | Stock | 165.09 | 165.2 | 165.0 | 165.0 | 2905.0 |
| 2022-02-22 05:35:00 | AAPL | Stock | 165.09 | 165.99 | 165.09 | 165.99 | 6638.0 |
| 2022-02-22 05:40:00 | AAPL | Stock | 165.99 | 166.43 | 165.99 | 166.0 | 13545.0 |
| 2022-02-22 05:45:00 | AAPL | Stock | 166.06 | 166.06 | 165.88 | 165.99 | 3127.0 |
| 2022-02-22 05:50:00 | AAPL | Stock | 165.99 | 166.6 | 165.99 | 166.51 | 5238.0 |
| 2022-02-22 05:55:00 | AAPL | Stock | 166.32 | 166.32 | 165.99 | 165.99 | 2472.0 |
| 2022-02-22 06:00:00 | AAPL | Stock | 166.0 | 166.0 | 165.99 | 165.99 | 974.0 |
| 2022-02-22 06:05:00 | AAPL | Stock | 165.81 | 165.82 | 165.71 | 165.82 | 1508.0 |
| 2022-02-22 06:10:00 | AAPL | Stock | 165.76 | 166.08 | 165.76 | 166.08 | 1316.0 |
| 2022-02-22 06:20:00 | AAPL | Stock | 166.0 | 166.15 | 165.98 | 165.98 | 1972.0 |
| 2022-02-22 06:25:00 | AAPL | Stock | 165.98 | 165.98 | 165.85 | 165.85 | 899.0 |
| 2022-02-22 06:30:00 | AAPL | Stock | 165.85 | 165.85 | 165.85 | 165.85 | 589.0 |
| 2022-02-22 06:35:00 | AAPL | Stock | 165.5 | 165.5 | 165.5 | 165.5 | 250.0 |
| 2022-02-22 06:40:00 | AAPL | Stock | 165.5 | 165.83 | 165.5 | 165.82 | 1175.0 |
| 2022-02-22 06:45:00 | AAPL | Stock | 165.89 | 165.9 | 165.8 | 165.89 | 1785.0 |
| 2022-02-22 06:50:00 | AAPL | Stock | 165.77 | 166.12 | 165.77 | 166.12 | 4179.0 |
| 2022-02-22 06:55:00 | AAPL | Stock | 165.94 | 165.94 | 165.9 | 165.9 | 419.0 |
| 2022-02-22 07:00:00 | AAPL | Stock | 165.92 | 166.01 | 165.52 | 165.65 | 20216.0 |
| 2022-02-22 07:05:00 | AAPL | Stock | 165.64 | 165.87 | 165.5 | 165.5 | 14144.0 |
| 2022-02-22 07:10:00 | AAPL | Stock | 165.5 | 166.06 | 165.3 | 165.88 | 26182.0 |
| 2022-02-22 07:15:00 | AAPL | Stock | 165.9 | 166.34 | 165.89 | 166.3 | 28854.0 |
| 2022-02-22 07:20:00 | AAPL | Stock | 166.35 | 166.48 | 166.25 | 166.25 | 11072.0 |
| 2022-02-22 07:25:00 | AAPL | Stock | 166.29 | 166.3 | 166.11 | 166.26 | 13261.0 |
| 2022-02-22 07:30:00 | AAPL | Stock | 166.27 | 166.48 | 166.17 | 166.4 | 20574.0 |
| 2022-02-22 07:35:00 | AAPL | Stock | 166.32 | 166.35 | 165.75 | 165.95 | 23081.0 |
| 2022-02-22 07:40:00 | AAPL | Stock | 165.95 | 166.35 | 165.92 | 166.19 | 6717.0 |
| 2022-02-22 07:45:00 | AAPL | Stock | 166.19 | 166.48 | 166.0 | 166.04 | 15356.0 |
| 2022-02-22 07:50:00 | AAPL | Stock | 166.13 | 166.25 | 166.13 | 166.18 | 5215.0 |
| 2022-02-22 07:55:00 | AAPL | Stock | 166.25 | 166.3 | 166.17 | 166.18 | 2874.0 |
| 2022-02-22 08:00:00 | AAPL | Stock | 165.5109 | 167.718 | 160.0 | 166.0499 | 130892.0 |
| 2022-02-22 08:05:00 | AAPL | Stock | 165.9546 | 166.21 | 165.9546 | 166.21 | 5714.0 |
| 2022-02-22 08:10:00 | AAPL | Stock | 166.07 | 166.16 | 165.7 | 165.7 | 11007.0 |
> showing 50 of 463,806 rows — these rows as CSV