PREVIEW / stock_5min / 2022-10-10
file: by_date/stock_5min/2022/2022-10-10.parquet size: 6.5 MB rows: 402,141 symbols: 2,135
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-10 04:00:00 | AAPL | Stock | 139.95 | 139.95 | 139.16 | 139.16 | 4171.0 |
| 2022-10-10 04:05:00 | AAPL | Stock | 139.13 | 139.3 | 139.1 | 139.3 | 2469.0 |
| 2022-10-10 04:10:00 | AAPL | Stock | 139.32 | 139.32 | 139.25 | 139.25 | 13626.0 |
| 2022-10-10 04:15:00 | AAPL | Stock | 139.2 | 139.2 | 139.02 | 139.12 | 4567.0 |
| 2022-10-10 04:20:00 | AAPL | Stock | 139.2 | 139.26 | 139.16 | 139.19 | 651.0 |
| 2022-10-10 04:25:00 | AAPL | Stock | 139.09 | 139.4 | 139.05 | 139.1 | 14872.0 |
| 2022-10-10 04:30:00 | AAPL | Stock | 139.1 | 139.1 | 138.95 | 138.95 | 8599.0 |
| 2022-10-10 04:35:00 | AAPL | Stock | 138.97 | 139.08 | 138.9 | 139.08 | 8457.0 |
| 2022-10-10 04:40:00 | AAPL | Stock | 139.07 | 139.11 | 139.05 | 139.05 | 1094.0 |
| 2022-10-10 04:45:00 | AAPL | Stock | 139.08 | 139.18 | 139.08 | 139.12 | 722.0 |
| 2022-10-10 04:50:00 | AAPL | Stock | 139.18 | 139.24 | 139.11 | 139.21 | 2215.0 |
| 2022-10-10 04:55:00 | AAPL | Stock | 139.24 | 139.29 | 139.21 | 139.24 | 2773.0 |
| 2022-10-10 05:00:00 | AAPL | Stock | 139.26 | 139.35 | 139.26 | 139.35 | 1267.0 |
| 2022-10-10 05:05:00 | AAPL | Stock | 139.35 | 139.35 | 139.35 | 139.35 | 200.0 |
| 2022-10-10 05:10:00 | AAPL | Stock | 139.35 | 139.35 | 139.3 | 139.3 | 1738.0 |
| 2022-10-10 05:15:00 | AAPL | Stock | 139.35 | 139.35 | 139.35 | 139.35 | 1400.0 |
| 2022-10-10 05:25:00 | AAPL | Stock | 139.39 | 139.46 | 139.39 | 139.44 | 800.0 |
| 2022-10-10 05:30:00 | AAPL | Stock | 139.44 | 139.54 | 139.44 | 139.54 | 2615.0 |
| 2022-10-10 05:35:00 | AAPL | Stock | 139.41 | 139.42 | 139.41 | 139.41 | 1074.0 |
| 2022-10-10 05:40:00 | AAPL | Stock | 139.52 | 139.59 | 139.43 | 139.59 | 4180.0 |
| 2022-10-10 05:45:00 | AAPL | Stock | 139.7 | 139.89 | 139.7 | 139.85 | 6424.0 |
| 2022-10-10 05:50:00 | AAPL | Stock | 139.79 | 139.85 | 139.79 | 139.85 | 857.0 |
| 2022-10-10 05:55:00 | AAPL | Stock | 139.8 | 139.9 | 139.8 | 139.9 | 3999.0 |
| 2022-10-10 06:00:00 | AAPL | Stock | 139.95 | 140.08 | 139.95 | 140.08 | 10505.0 |
| 2022-10-10 06:05:00 | AAPL | Stock | 140.0 | 140.04 | 139.94 | 140.04 | 15776.0 |
| 2022-10-10 06:10:00 | AAPL | Stock | 140.05 | 140.05 | 139.96 | 139.99 | 1900.0 |
| 2022-10-10 06:15:00 | AAPL | Stock | 139.9 | 140.01 | 139.9 | 140.01 | 9438.0 |
| 2022-10-10 06:20:00 | AAPL | Stock | 140.03 | 140.04 | 139.89 | 140.04 | 15981.0 |
| 2022-10-10 06:25:00 | AAPL | Stock | 140.02 | 140.02 | 139.86 | 139.87 | 3621.0 |
| 2022-10-10 06:30:00 | AAPL | Stock | 139.91 | 139.91 | 139.91 | 139.91 | 245.0 |
| 2022-10-10 06:35:00 | AAPL | Stock | 139.84 | 139.87 | 139.84 | 139.87 | 440.0 |
| 2022-10-10 06:40:00 | AAPL | Stock | 139.91 | 139.96 | 139.9 | 139.95 | 5778.0 |
| 2022-10-10 06:45:00 | AAPL | Stock | 139.96 | 139.96 | 139.95 | 139.96 | 2920.0 |
| 2022-10-10 06:50:00 | AAPL | Stock | 139.95 | 140.03 | 139.92 | 139.99 | 3553.0 |
| 2022-10-10 06:55:00 | AAPL | Stock | 139.9 | 139.93 | 139.88 | 139.93 | 513.0 |
| 2022-10-10 07:00:00 | AAPL | Stock | 139.95 | 140.18 | 139.9 | 140.15 | 28113.0 |
| 2022-10-10 07:05:00 | AAPL | Stock | 140.13 | 140.17 | 140.07 | 140.08 | 5720.0 |
| 2022-10-10 07:10:00 | AAPL | Stock | 140.07 | 140.16 | 140.03 | 140.09 | 6176.0 |
| 2022-10-10 07:15:00 | AAPL | Stock | 140.1 | 140.2 | 140.1 | 140.2 | 35085.0 |
| 2022-10-10 07:20:00 | AAPL | Stock | 140.16 | 140.23 | 140.16 | 140.23 | 2093.0 |
| 2022-10-10 07:25:00 | AAPL | Stock | 140.23 | 140.4 | 140.23 | 140.28 | 16726.0 |
| 2022-10-10 07:30:00 | AAPL | Stock | 140.32 | 140.34 | 140.25 | 140.34 | 5316.0 |
| 2022-10-10 07:35:00 | AAPL | Stock | 140.3 | 140.3 | 140.25 | 140.29 | 3253.0 |
| 2022-10-10 07:40:00 | AAPL | Stock | 140.26 | 140.26 | 140.15 | 140.19 | 13545.0 |
| 2022-10-10 07:45:00 | AAPL | Stock | 140.15 | 140.15 | 140.13 | 140.13 | 497.0 |
| 2022-10-10 07:50:00 | AAPL | Stock | 140.14 | 140.29 | 140.12 | 140.26 | 3788.0 |
| 2022-10-10 07:55:00 | AAPL | Stock | 140.12 | 140.25 | 140.09 | 140.18 | 8334.0 |
| 2022-10-10 08:00:00 | AAPL | Stock | 140.14 | 140.35 | 139.8115 | 140.13 | 37533.0 |
| 2022-10-10 08:05:00 | AAPL | Stock | 140.058 | 140.24 | 140.058 | 140.16 | 7854.0 |
| 2022-10-10 08:10:00 | AAPL | Stock | 140.16 | 140.21 | 140.03 | 140.03 | 7908.0 |
> showing 50 of 402,141 rows — these rows as CSV