PREVIEW / stock_5min / 2022-05-19
file: by_date/stock_5min/2022/2022-05-19.parquet size: 7.1 MB rows: 446,121 symbols: 2,374
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-05-19 04:00:00 | AAPL | Stock | 140.18 | 140.18 | 139.4 | 139.4 | 10991.0 |
| 2022-05-19 04:05:00 | AAPL | Stock | 139.3 | 139.48 | 139.19 | 139.44 | 9318.0 |
| 2022-05-19 04:10:00 | AAPL | Stock | 139.5 | 139.75 | 139.5 | 139.51 | 3582.0 |
| 2022-05-19 04:15:00 | AAPL | Stock | 139.57 | 139.65 | 139.53 | 139.53 | 2307.0 |
| 2022-05-19 04:20:00 | AAPL | Stock | 139.47 | 139.48 | 139.4 | 139.45 | 1696.0 |
| 2022-05-19 04:25:00 | AAPL | Stock | 139.53 | 139.56 | 139.48 | 139.48 | 412.0 |
| 2022-05-19 04:30:00 | AAPL | Stock | 139.42 | 139.47 | 139.15 | 139.15 | 5048.0 |
| 2022-05-19 04:35:00 | AAPL | Stock | 139.17 | 139.25 | 139.17 | 139.17 | 5479.0 |
| 2022-05-19 04:40:00 | AAPL | Stock | 139.18 | 139.3 | 139.15 | 139.24 | 3761.0 |
| 2022-05-19 04:45:00 | AAPL | Stock | 139.22 | 139.34 | 139.22 | 139.23 | 5120.0 |
| 2022-05-19 04:50:00 | AAPL | Stock | 139.26 | 139.44 | 139.26 | 139.4 | 2152.0 |
| 2022-05-19 04:55:00 | AAPL | Stock | 139.4 | 139.45 | 139.03 | 139.07 | 11645.0 |
| 2022-05-19 05:00:00 | AAPL | Stock | 139.02 | 139.02 | 138.85 | 138.92 | 8000.0 |
| 2022-05-19 05:05:00 | AAPL | Stock | 139.08 | 139.16 | 139.08 | 139.16 | 484.0 |
| 2022-05-19 05:10:00 | AAPL | Stock | 139.22 | 139.25 | 138.9 | 138.9 | 4983.0 |
| 2022-05-19 05:15:00 | AAPL | Stock | 139.02 | 139.02 | 138.91 | 138.96 | 2025.0 |
| 2022-05-19 05:20:00 | AAPL | Stock | 138.9 | 139.06 | 138.81 | 138.81 | 3025.0 |
| 2022-05-19 05:25:00 | AAPL | Stock | 138.78 | 138.9 | 138.72 | 138.86 | 6280.0 |
| 2022-05-19 05:30:00 | AAPL | Stock | 138.82 | 138.82 | 138.8 | 138.8 | 1276.0 |
| 2022-05-19 05:35:00 | AAPL | Stock | 138.87 | 138.89 | 138.65 | 138.71 | 5051.0 |
| 2022-05-19 05:40:00 | AAPL | Stock | 138.62 | 138.75 | 138.56 | 138.6 | 7687.0 |
| 2022-05-19 05:45:00 | AAPL | Stock | 138.75 | 138.96 | 138.7 | 138.95 | 881.0 |
| 2022-05-19 05:50:00 | AAPL | Stock | 138.81 | 139.09 | 138.81 | 139.09 | 5030.0 |
| 2022-05-19 05:55:00 | AAPL | Stock | 139.13 | 139.13 | 138.9 | 138.91 | 4692.0 |
| 2022-05-19 06:00:00 | AAPL | Stock | 138.86 | 139.12 | 138.86 | 139.12 | 2389.0 |
| 2022-05-19 06:05:00 | AAPL | Stock | 139.15 | 139.3 | 139.15 | 139.3 | 3333.0 |
| 2022-05-19 06:10:00 | AAPL | Stock | 139.31 | 139.45 | 139.31 | 139.4 | 5073.0 |
| 2022-05-19 06:15:00 | AAPL | Stock | 139.4 | 139.55 | 139.2 | 139.2 | 5801.0 |
| 2022-05-19 06:20:00 | AAPL | Stock | 139.23 | 139.37 | 139.23 | 139.35 | 1616.0 |
| 2022-05-19 06:25:00 | AAPL | Stock | 139.35 | 139.35 | 139.0 | 139.25 | 5887.0 |
| 2022-05-19 06:30:00 | AAPL | Stock | 139.34 | 139.35 | 139.0 | 139.09 | 1934.0 |
| 2022-05-19 06:35:00 | AAPL | Stock | 139.01 | 139.18 | 138.92 | 139.18 | 2779.0 |
| 2022-05-19 06:40:00 | AAPL | Stock | 139.24 | 139.8 | 139.24 | 139.6 | 13125.0 |
| 2022-05-19 06:45:00 | AAPL | Stock | 139.61 | 139.84 | 139.61 | 139.79 | 4292.0 |
| 2022-05-19 06:50:00 | AAPL | Stock | 139.65 | 139.84 | 139.59 | 139.84 | 4433.0 |
| 2022-05-19 06:55:00 | AAPL | Stock | 139.82 | 139.88 | 139.71 | 139.84 | 6596.0 |
| 2022-05-19 07:00:00 | AAPL | Stock | 139.85 | 139.93 | 139.62 | 139.71 | 27638.0 |
| 2022-05-19 07:05:00 | AAPL | Stock | 139.67 | 139.67 | 139.5 | 139.55 | 12248.0 |
| 2022-05-19 07:10:00 | AAPL | Stock | 139.55 | 139.71 | 139.45 | 139.68 | 6374.0 |
| 2022-05-19 07:15:00 | AAPL | Stock | 139.7 | 139.72 | 139.67 | 139.67 | 12416.0 |
| 2022-05-19 07:20:00 | AAPL | Stock | 139.65 | 139.94 | 139.65 | 139.86 | 19272.0 |
| 2022-05-19 07:25:00 | AAPL | Stock | 139.82 | 140.27 | 139.78 | 140.1 | 26290.0 |
| 2022-05-19 07:30:00 | AAPL | Stock | 140.15 | 140.15 | 139.83 | 139.85 | 12246.0 |
| 2022-05-19 07:35:00 | AAPL | Stock | 139.9 | 140.0 | 139.84 | 139.84 | 2684.0 |
| 2022-05-19 07:40:00 | AAPL | Stock | 139.87 | 140.35 | 139.87 | 140.24 | 24292.0 |
| 2022-05-19 07:45:00 | AAPL | Stock | 140.16 | 140.19 | 139.86 | 140.0 | 11532.0 |
| 2022-05-19 07:50:00 | AAPL | Stock | 140.0 | 140.0 | 139.85 | 140.0 | 5566.0 |
| 2022-05-19 07:55:00 | AAPL | Stock | 140.04 | 140.5 | 140.04 | 140.35 | 23389.0 |
| 2022-05-19 08:00:00 | AAPL | Stock | 139.7542 | 140.4899 | 139.2012 | 139.94 | 421503.0 |
| 2022-05-19 08:05:00 | AAPL | Stock | 139.9201 | 140.09 | 139.91 | 139.9999 | 71192.0 |
> showing 50 of 446,121 rows — these rows as CSV