PREVIEW / stock_5min / 2021-06-30
file: by_date/stock_5min/2021/2021-06-30.parquet size: 7.7 MB rows: 476,124 symbols: 2,961
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-06-30 04:00:00 | AAPL | Stock | 136.49 | 136.5 | 136.49 | 136.5 | 534.0 |
| 2021-06-30 04:05:00 | AAPL | Stock | 136.43 | 136.43 | 136.35 | 136.35 | 1531.0 |
| 2021-06-30 04:10:00 | AAPL | Stock | 136.33 | 136.34 | 136.15 | 136.15 | 4374.0 |
| 2021-06-30 04:15:00 | AAPL | Stock | 136.2 | 136.2 | 136.18 | 136.18 | 300.0 |
| 2021-06-30 04:20:00 | AAPL | Stock | 136.11 | 136.11 | 136.11 | 136.11 | 352.0 |
| 2021-06-30 04:25:00 | AAPL | Stock | 136.15 | 136.18 | 136.15 | 136.18 | 1171.0 |
| 2021-06-30 04:30:00 | AAPL | Stock | 136.2 | 136.2 | 136.2 | 136.2 | 3016.0 |
| 2021-06-30 04:35:00 | AAPL | Stock | 136.15 | 136.2 | 136.15 | 136.2 | 783.0 |
| 2021-06-30 04:40:00 | AAPL | Stock | 136.21 | 136.28 | 136.2 | 136.28 | 2685.0 |
| 2021-06-30 04:45:00 | AAPL | Stock | 136.2 | 136.2 | 136.2 | 136.2 | 135.0 |
| 2021-06-30 04:50:00 | AAPL | Stock | 136.2 | 136.2 | 136.19 | 136.19 | 400.0 |
| 2021-06-30 04:55:00 | AAPL | Stock | 136.13 | 136.13 | 136.13 | 136.13 | 150.0 |
| 2021-06-30 05:00:00 | AAPL | Stock | 136.11 | 136.11 | 135.9 | 135.9 | 4602.0 |
| 2021-06-30 05:05:00 | AAPL | Stock | 135.91 | 136.02 | 135.84 | 135.95 | 21599.0 |
| 2021-06-30 05:10:00 | AAPL | Stock | 135.91 | 135.91 | 135.84 | 135.84 | 803.0 |
| 2021-06-30 05:15:00 | AAPL | Stock | 135.83 | 135.83 | 135.8 | 135.8 | 1195.0 |
| 2021-06-30 05:20:00 | AAPL | Stock | 135.8 | 135.85 | 135.66 | 135.66 | 1402.0 |
| 2021-06-30 05:25:00 | AAPL | Stock | 135.69 | 135.89 | 135.5 | 135.78 | 4859.0 |
| 2021-06-30 05:30:00 | AAPL | Stock | 135.6 | 135.8 | 135.6 | 135.8 | 1277.0 |
| 2021-06-30 05:35:00 | AAPL | Stock | 135.75 | 135.75 | 135.75 | 135.75 | 156.0 |
| 2021-06-30 05:40:00 | AAPL | Stock | 135.6 | 135.7 | 135.5 | 135.7 | 743.0 |
| 2021-06-30 05:45:00 | AAPL | Stock | 135.7 | 135.82 | 135.7 | 135.82 | 1645.0 |
| 2021-06-30 05:55:00 | AAPL | Stock | 135.84 | 135.84 | 135.84 | 135.84 | 300.0 |
| 2021-06-30 06:00:00 | AAPL | Stock | 135.88 | 135.9 | 135.88 | 135.9 | 842.0 |
| 2021-06-30 06:05:00 | AAPL | Stock | 135.9 | 135.95 | 135.9 | 135.95 | 370.0 |
| 2021-06-30 06:10:00 | AAPL | Stock | 135.93 | 135.93 | 135.93 | 135.93 | 100.0 |
| 2021-06-30 06:15:00 | AAPL | Stock | 135.97 | 135.97 | 135.97 | 135.97 | 395.0 |
| 2021-06-30 06:25:00 | AAPL | Stock | 135.96 | 135.96 | 135.88 | 135.88 | 880.0 |
| 2021-06-30 06:35:00 | AAPL | Stock | 135.87 | 135.87 | 135.87 | 135.87 | 100.0 |
| 2021-06-30 06:40:00 | AAPL | Stock | 135.87 | 135.93 | 135.87 | 135.9 | 2902.0 |
| 2021-06-30 06:45:00 | AAPL | Stock | 135.91 | 135.91 | 135.91 | 135.91 | 100.0 |
| 2021-06-30 06:55:00 | AAPL | Stock | 135.86 | 135.86 | 135.8 | 135.8 | 350.0 |
| 2021-06-30 07:00:00 | AAPL | Stock | 135.85 | 136.1 | 135.75 | 136.01 | 20498.0 |
| 2021-06-30 07:05:00 | AAPL | Stock | 136.03 | 136.08 | 136.03 | 136.05 | 5197.0 |
| 2021-06-30 07:10:00 | AAPL | Stock | 136.07 | 136.15 | 136.04 | 136.12 | 15777.0 |
| 2021-06-30 07:15:00 | AAPL | Stock | 136.12 | 136.15 | 136.09 | 136.15 | 7354.0 |
| 2021-06-30 07:20:00 | AAPL | Stock | 136.15 | 136.25 | 136.15 | 136.15 | 12394.0 |
| 2021-06-30 07:25:00 | AAPL | Stock | 136.16 | 136.181 | 136.09 | 136.1 | 5979.0 |
| 2021-06-30 07:30:00 | AAPL | Stock | 136.101 | 136.16 | 136.1 | 136.12 | 4152.0 |
| 2021-06-30 07:35:00 | AAPL | Stock | 136.12 | 136.17 | 136.05 | 136.1 | 6520.0 |
| 2021-06-30 07:40:00 | AAPL | Stock | 136.12 | 136.14 | 136.03 | 136.07 | 5720.0 |
| 2021-06-30 07:45:00 | AAPL | Stock | 136.12 | 136.12 | 136.1 | 136.1 | 1227.0 |
| 2021-06-30 07:50:00 | AAPL | Stock | 136.19 | 136.19 | 136.08 | 136.08 | 4589.0 |
| 2021-06-30 07:55:00 | AAPL | Stock | 136.12 | 136.12 | 136.11 | 136.11 | 473.0 |
| 2021-06-30 08:00:00 | AAPL | Stock | 136.1201 | 136.2 | 135.9696 | 136.16 | 33211.0 |
| 2021-06-30 08:05:00 | AAPL | Stock | 136.15 | 136.24 | 136.12 | 136.2 | 23949.0 |
| 2021-06-30 08:10:00 | AAPL | Stock | 136.2 | 136.2 | 136.15 | 136.18 | 2006.0 |
| 2021-06-30 08:15:00 | AAPL | Stock | 136.2 | 136.33 | 136.2 | 136.28 | 20857.0 |
| 2021-06-30 08:20:00 | AAPL | Stock | 136.28 | 136.3 | 136.1 | 136.18 | 14200.0 |
| 2021-06-30 08:25:00 | AAPL | Stock | 136.2 | 136.21 | 136.0 | 136.03 | 28613.0 |
> showing 50 of 476,124 rows — these rows as CSV