PREVIEW / stock_5min / 2021-07-15
file: by_date/stock_5min/2021/2021-07-15.parquet size: 7.4 MB rows: 457,557 symbols: 2,878
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-07-15 04:00:00 | AAPL | Stock | 149.67 | 149.8 | 149.67 | 149.8 | 9803.0 |
| 2021-07-15 04:05:00 | AAPL | Stock | 149.8 | 149.83 | 149.73 | 149.83 | 3113.0 |
| 2021-07-15 04:10:00 | AAPL | Stock | 149.8 | 149.9 | 149.75 | 149.85 | 13067.0 |
| 2021-07-15 04:15:00 | AAPL | Stock | 149.85 | 149.85 | 149.8 | 149.81 | 2186.0 |
| 2021-07-15 04:20:00 | AAPL | Stock | 149.83 | 149.85 | 149.83 | 149.85 | 3841.0 |
| 2021-07-15 04:25:00 | AAPL | Stock | 149.85 | 149.9 | 149.85 | 149.9 | 1947.0 |
| 2021-07-15 04:30:00 | AAPL | Stock | 149.9 | 149.9 | 149.51 | 149.75 | 3418.0 |
| 2021-07-15 04:35:00 | AAPL | Stock | 149.85 | 149.85 | 149.84 | 149.84 | 700.0 |
| 2021-07-15 04:40:00 | AAPL | Stock | 149.87 | 149.9 | 149.87 | 149.9 | 5846.0 |
| 2021-07-15 04:45:00 | AAPL | Stock | 149.88 | 149.92 | 149.87 | 149.92 | 9304.0 |
| 2021-07-15 04:50:00 | AAPL | Stock | 149.95 | 149.95 | 149.81 | 149.85 | 5359.0 |
| 2021-07-15 04:55:00 | AAPL | Stock | 149.9 | 149.95 | 149.9 | 149.95 | 1697.0 |
| 2021-07-15 05:00:00 | AAPL | Stock | 149.95 | 149.97 | 149.95 | 149.96 | 2952.0 |
| 2021-07-15 05:05:00 | AAPL | Stock | 149.98 | 149.98 | 149.94 | 149.94 | 4004.0 |
| 2021-07-15 05:10:00 | AAPL | Stock | 149.92 | 150.0 | 149.87 | 149.88 | 6129.0 |
| 2021-07-15 05:15:00 | AAPL | Stock | 149.87 | 149.87 | 149.81 | 149.82 | 4326.0 |
| 2021-07-15 05:25:00 | AAPL | Stock | 149.81 | 149.84 | 149.78 | 149.8 | 3894.0 |
| 2021-07-15 05:30:00 | AAPL | Stock | 149.75 | 149.78 | 149.65 | 149.71 | 4942.0 |
| 2021-07-15 05:35:00 | AAPL | Stock | 149.71 | 149.75 | 149.65 | 149.75 | 2429.0 |
| 2021-07-15 05:40:00 | AAPL | Stock | 149.75 | 149.81 | 149.75 | 149.81 | 1334.0 |
| 2021-07-15 05:45:00 | AAPL | Stock | 149.76 | 149.86 | 149.76 | 149.84 | 1292.0 |
| 2021-07-15 05:50:00 | AAPL | Stock | 149.86 | 149.87 | 149.82 | 149.87 | 3058.0 |
| 2021-07-15 06:00:00 | AAPL | Stock | 149.84 | 149.85 | 149.65 | 149.65 | 5102.0 |
| 2021-07-15 06:05:00 | AAPL | Stock | 149.7 | 149.74 | 149.59 | 149.74 | 3610.0 |
| 2021-07-15 06:10:00 | AAPL | Stock | 149.55 | 149.55 | 149.5 | 149.52 | 3995.0 |
| 2021-07-15 06:15:00 | AAPL | Stock | 149.52 | 149.52 | 149.41 | 149.41 | 1431.0 |
| 2021-07-15 06:20:00 | AAPL | Stock | 149.35 | 149.4 | 149.35 | 149.39 | 1254.0 |
| 2021-07-15 06:25:00 | AAPL | Stock | 149.39 | 149.45 | 149.39 | 149.4 | 1069.0 |
| 2021-07-15 06:30:00 | AAPL | Stock | 149.35 | 149.35 | 149.22 | 149.25 | 4353.0 |
| 2021-07-15 06:35:00 | AAPL | Stock | 149.3 | 149.39 | 149.3 | 149.39 | 985.0 |
| 2021-07-15 06:40:00 | AAPL | Stock | 149.51 | 149.51 | 149.5 | 149.5 | 772.0 |
| 2021-07-15 06:45:00 | AAPL | Stock | 149.59 | 149.68 | 149.59 | 149.65 | 1985.0 |
| 2021-07-15 06:50:00 | AAPL | Stock | 149.6 | 149.63 | 149.49 | 149.49 | 3419.0 |
| 2021-07-15 06:55:00 | AAPL | Stock | 149.46 | 149.46 | 149.4 | 149.4 | 2291.0 |
| 2021-07-15 07:00:00 | AAPL | Stock | 149.4 | 149.59 | 149.35 | 149.35 | 34275.0 |
| 2021-07-15 07:05:00 | AAPL | Stock | 149.35 | 149.36 | 149.15 | 149.29 | 27372.0 |
| 2021-07-15 07:10:00 | AAPL | Stock | 149.31 | 149.32 | 149.26 | 149.27 | 6526.0 |
| 2021-07-15 07:15:00 | AAPL | Stock | 149.27 | 149.29 | 148.99 | 149.0 | 39810.0 |
| 2021-07-15 07:20:00 | AAPL | Stock | 148.99 | 149.02 | 148.83 | 148.93 | 21090.0 |
| 2021-07-15 07:25:00 | AAPL | Stock | 148.949 | 149.07 | 148.86 | 149.0 | 21332.0 |
| 2021-07-15 07:30:00 | AAPL | Stock | 148.98 | 149.0 | 148.88 | 148.97 | 29634.0 |
| 2021-07-15 07:35:00 | AAPL | Stock | 148.97 | 149.06 | 148.9 | 148.95 | 22412.0 |
| 2021-07-15 07:40:00 | AAPL | Stock | 148.95 | 149.07 | 148.95 | 149.02 | 12864.0 |
| 2021-07-15 07:45:00 | AAPL | Stock | 149.02 | 149.12 | 148.98 | 149.11 | 11494.0 |
| 2021-07-15 07:50:00 | AAPL | Stock | 149.11 | 149.3 | 149.1 | 149.22 | 28052.0 |
| 2021-07-15 07:55:00 | AAPL | Stock | 149.25 | 149.28 | 149.2 | 149.23 | 14271.0 |
| 2021-07-15 08:00:00 | AAPL | Stock | 149.15 | 149.5 | 148.8501 | 149.17 | 287989.0 |
| 2021-07-15 08:05:00 | AAPL | Stock | 149.2 | 149.26 | 148.778 | 149.2 | 36799.0 |
| 2021-07-15 08:10:00 | AAPL | Stock | 149.15 | 149.22 | 149.01 | 149.1 | 51068.0 |
| 2021-07-15 08:15:00 | AAPL | Stock | 149.1 | 149.21 | 149.08 | 149.15 | 12268.0 |
> showing 50 of 457,557 rows — these rows as CSV