PREVIEW / stock_5min / 2021-04-19
file: by_date/stock_5min/2021/2021-04-19.parquet size: 7.5 MB rows: 464,920 symbols: 2,972
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 |
|---|---|---|---|---|---|---|---|
| 2021-04-19 04:00:00 | AAPL | Stock | 134.24 | 134.3 | 134.16 | 134.18 | 1864.0 |
| 2021-04-19 04:05:00 | AAPL | Stock | 134.25 | 134.39 | 134.25 | 134.28 | 2112.0 |
| 2021-04-19 04:10:00 | AAPL | Stock | 134.24 | 134.3 | 134.24 | 134.3 | 1161.0 |
| 2021-04-19 04:15:00 | AAPL | Stock | 134.3 | 134.3 | 134.2 | 134.3 | 1523.0 |
| 2021-04-19 04:20:00 | AAPL | Stock | 134.25 | 134.26 | 134.25 | 134.26 | 300.0 |
| 2021-04-19 04:25:00 | AAPL | Stock | 134.27 | 134.27 | 134.26 | 134.26 | 723.0 |
| 2021-04-19 04:30:00 | AAPL | Stock | 134.32 | 134.32 | 134.32 | 134.32 | 435.0 |
| 2021-04-19 04:35:00 | AAPL | Stock | 134.31 | 134.37 | 134.31 | 134.37 | 400.0 |
| 2021-04-19 04:40:00 | AAPL | Stock | 134.31 | 134.31 | 134.29 | 134.29 | 501.0 |
| 2021-04-19 04:45:00 | AAPL | Stock | 134.36 | 134.36 | 134.36 | 134.36 | 100.0 |
| 2021-04-19 04:50:00 | AAPL | Stock | 134.4 | 134.4 | 134.4 | 134.4 | 471.0 |
| 2021-04-19 04:55:00 | AAPL | Stock | 134.4 | 134.4 | 134.4 | 134.4 | 520.0 |
| 2021-04-19 05:00:00 | AAPL | Stock | 134.35 | 134.35 | 134.35 | 134.35 | 107.0 |
| 2021-04-19 05:05:00 | AAPL | Stock | 134.35 | 134.35 | 134.33 | 134.33 | 600.0 |
| 2021-04-19 05:10:00 | AAPL | Stock | 134.26 | 134.26 | 134.2 | 134.2 | 1112.0 |
| 2021-04-19 05:15:00 | AAPL | Stock | 134.29 | 134.39 | 134.29 | 134.3 | 824.0 |
| 2021-04-19 05:20:00 | AAPL | Stock | 134.29 | 134.29 | 134.27 | 134.27 | 234.0 |
| 2021-04-19 05:30:00 | AAPL | Stock | 134.24 | 134.24 | 134.24 | 134.24 | 200.0 |
| 2021-04-19 05:35:00 | AAPL | Stock | 134.24 | 134.24 | 134.24 | 134.24 | 148.0 |
| 2021-04-19 05:40:00 | AAPL | Stock | 134.18 | 134.2 | 134.18 | 134.2 | 614.0 |
| 2021-04-19 05:45:00 | AAPL | Stock | 134.21 | 134.21 | 134.21 | 134.21 | 100.0 |
| 2021-04-19 05:55:00 | AAPL | Stock | 134.31 | 134.31 | 134.31 | 134.31 | 741.0 |
| 2021-04-19 06:00:00 | AAPL | Stock | 134.3 | 134.3 | 134.3 | 134.3 | 300.0 |
| 2021-04-19 06:05:00 | AAPL | Stock | 134.3 | 134.3 | 134.3 | 134.3 | 226.0 |
| 2021-04-19 06:20:00 | AAPL | Stock | 134.28 | 134.32 | 134.28 | 134.32 | 1704.0 |
| 2021-04-19 06:30:00 | AAPL | Stock | 134.29 | 134.29 | 134.24 | 134.24 | 851.0 |
| 2021-04-19 06:35:00 | AAPL | Stock | 134.24 | 134.26 | 134.2 | 134.2 | 1462.0 |
| 2021-04-19 06:40:00 | AAPL | Stock | 134.18 | 134.18 | 133.84 | 133.95 | 11204.0 |
| 2021-04-19 06:45:00 | AAPL | Stock | 133.76 | 133.81 | 133.76 | 133.81 | 1145.0 |
| 2021-04-19 06:50:00 | AAPL | Stock | 133.9 | 133.9 | 133.89 | 133.89 | 459.0 |
| 2021-04-19 06:55:00 | AAPL | Stock | 133.9 | 134.01 | 133.9 | 134.01 | 1774.0 |
| 2021-04-19 07:00:00 | AAPL | Stock | 134.01 | 134.12 | 133.97 | 133.98 | 21503.0 |
| 2021-04-19 07:05:00 | AAPL | Stock | 133.98 | 134.0 | 133.94 | 133.96 | 6570.0 |
| 2021-04-19 07:10:00 | AAPL | Stock | 133.96 | 133.99 | 133.9 | 133.97 | 10813.0 |
| 2021-04-19 07:15:00 | AAPL | Stock | 133.96 | 133.97 | 133.89 | 133.9 | 2785.0 |
| 2021-04-19 07:20:00 | AAPL | Stock | 133.92 | 133.94 | 133.87 | 133.88 | 12496.0 |
| 2021-04-19 07:25:00 | AAPL | Stock | 133.84 | 133.89 | 133.79 | 133.83 | 7294.0 |
| 2021-04-19 07:30:00 | AAPL | Stock | 133.83 | 133.93 | 133.82 | 133.93 | 4278.0 |
| 2021-04-19 07:35:00 | AAPL | Stock | 133.93 | 133.98 | 133.93 | 133.96 | 3437.0 |
| 2021-04-19 07:40:00 | AAPL | Stock | 133.96 | 133.96 | 133.9 | 133.9 | 2405.0 |
| 2021-04-19 07:45:00 | AAPL | Stock | 133.94 | 133.98 | 133.94 | 133.98 | 4976.0 |
| 2021-04-19 07:50:00 | AAPL | Stock | 133.98 | 133.98 | 133.88 | 133.88 | 2274.0 |
| 2021-04-19 07:55:00 | AAPL | Stock | 133.89 | 133.99 | 133.89 | 133.96 | 5699.0 |
| 2021-04-19 08:00:00 | AAPL | Stock | 133.99 | 134.14 | 133.79 | 133.84 | 111373.0 |
| 2021-04-19 08:05:00 | AAPL | Stock | 133.83 | 134.495 | 133.8 | 133.81 | 36048.0 |
| 2021-04-19 08:10:00 | AAPL | Stock | 133.8 | 133.87 | 133.8 | 133.85 | 17805.0 |
| 2021-04-19 08:15:00 | AAPL | Stock | 133.83 | 133.85 | 133.7 | 133.82 | 24795.0 |
| 2021-04-19 08:20:00 | AAPL | Stock | 133.82 | 133.87 | 133.75 | 133.81 | 14473.0 |
| 2021-04-19 08:25:00 | AAPL | Stock | 133.81 | 133.89 | 133.8 | 133.81 | 11841.0 |
| 2021-04-19 08:30:00 | AAPL | Stock | 133.8 | 133.81 | 133.72 | 133.8 | 12661.0 |
> showing 50 of 464,920 rows — these rows as CSV