PREVIEW / stock_5min / 2021-07-28
file: by_date/stock_5min/2021/2021-07-28.parquet size: 7.2 MB rows: 442,153 symbols: 2,813
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-28 04:00:00 | AAPL | Stock | 144.54 | 145.0 | 144.4 | 144.54 | 37750.0 |
| 2021-07-28 04:05:00 | AAPL | Stock | 144.59 | 144.8 | 144.59 | 144.7 | 7820.0 |
| 2021-07-28 04:10:00 | AAPL | Stock | 144.73 | 144.96 | 144.73 | 144.92 | 12759.0 |
| 2021-07-28 04:15:00 | AAPL | Stock | 144.95 | 145.5 | 144.95 | 145.45 | 13856.0 |
| 2021-07-28 04:20:00 | AAPL | Stock | 145.43 | 145.53 | 145.43 | 145.45 | 20977.0 |
| 2021-07-28 04:25:00 | AAPL | Stock | 145.47 | 145.51 | 145.32 | 145.4 | 3275.0 |
| 2021-07-28 04:30:00 | AAPL | Stock | 145.4 | 145.46 | 145.31 | 145.31 | 3104.0 |
| 2021-07-28 04:35:00 | AAPL | Stock | 145.22 | 145.4 | 145.22 | 145.4 | 1671.0 |
| 2021-07-28 04:40:00 | AAPL | Stock | 145.35 | 145.5 | 145.34 | 145.45 | 11710.0 |
| 2021-07-28 04:45:00 | AAPL | Stock | 145.36 | 145.5 | 145.36 | 145.5 | 5230.0 |
| 2021-07-28 04:50:00 | AAPL | Stock | 145.52 | 145.7 | 145.36 | 145.4 | 5478.0 |
| 2021-07-28 04:55:00 | AAPL | Stock | 145.63 | 145.76 | 145.6 | 145.6 | 7876.0 |
| 2021-07-28 05:00:00 | AAPL | Stock | 145.68 | 145.88 | 145.68 | 145.71 | 5250.0 |
| 2021-07-28 05:05:00 | AAPL | Stock | 145.71 | 145.71 | 145.41 | 145.41 | 15539.0 |
| 2021-07-28 05:10:00 | AAPL | Stock | 145.41 | 145.5 | 145.37 | 145.5 | 949.0 |
| 2021-07-28 05:15:00 | AAPL | Stock | 145.42 | 145.45 | 145.21 | 145.21 | 7369.0 |
| 2021-07-28 05:20:00 | AAPL | Stock | 145.3 | 145.31 | 145.03 | 145.08 | 4086.0 |
| 2021-07-28 05:25:00 | AAPL | Stock | 145.17 | 145.4 | 145.17 | 145.34 | 7756.0 |
| 2021-07-28 05:30:00 | AAPL | Stock | 145.34 | 145.34 | 145.14 | 145.14 | 2213.0 |
| 2021-07-28 05:35:00 | AAPL | Stock | 145.18 | 145.33 | 145.12 | 145.16 | 6277.0 |
| 2021-07-28 05:40:00 | AAPL | Stock | 145.28 | 145.3 | 145.2 | 145.21 | 5805.0 |
| 2021-07-28 05:45:00 | AAPL | Stock | 145.22 | 145.3 | 145.1 | 145.25 | 3096.0 |
| 2021-07-28 05:50:00 | AAPL | Stock | 145.27 | 145.3 | 145.21 | 145.3 | 1958.0 |
| 2021-07-28 05:55:00 | AAPL | Stock | 145.3 | 145.33 | 145.3 | 145.33 | 1626.0 |
| 2021-07-28 06:00:00 | AAPL | Stock | 145.31 | 145.31 | 145.28 | 145.3 | 1996.0 |
| 2021-07-28 06:05:00 | AAPL | Stock | 145.31 | 145.32 | 145.3 | 145.32 | 1476.0 |
| 2021-07-28 06:10:00 | AAPL | Stock | 145.22 | 145.22 | 144.7 | 144.8 | 8991.0 |
| 2021-07-28 06:15:00 | AAPL | Stock | 144.89 | 144.89 | 144.6 | 144.7 | 16463.0 |
| 2021-07-28 06:20:00 | AAPL | Stock | 144.7 | 144.8 | 144.67 | 144.8 | 1913.0 |
| 2021-07-28 06:25:00 | AAPL | Stock | 144.72 | 144.75 | 144.57 | 144.75 | 4205.0 |
| 2021-07-28 06:30:00 | AAPL | Stock | 144.81 | 145.0 | 144.81 | 145.0 | 7282.0 |
| 2021-07-28 06:35:00 | AAPL | Stock | 145.05 | 145.1 | 145.05 | 145.05 | 1210.0 |
| 2021-07-28 06:40:00 | AAPL | Stock | 145.05 | 145.05 | 144.95 | 144.95 | 3327.0 |
| 2021-07-28 06:45:00 | AAPL | Stock | 145.08 | 145.11 | 145.0 | 145.11 | 1589.0 |
| 2021-07-28 06:50:00 | AAPL | Stock | 145.18 | 145.18 | 144.9 | 144.9 | 7519.0 |
| 2021-07-28 06:55:00 | AAPL | Stock | 145.0 | 145.09 | 144.81 | 145.09 | 9377.0 |
| 2021-07-28 07:00:00 | AAPL | Stock | 144.92 | 145.24 | 144.32 | 144.6 | 82375.0 |
| 2021-07-28 07:05:00 | AAPL | Stock | 144.51 | 144.6 | 144.33 | 144.46 | 29840.0 |
| 2021-07-28 07:10:00 | AAPL | Stock | 144.45 | 144.87 | 144.45 | 144.86 | 20307.0 |
| 2021-07-28 07:15:00 | AAPL | Stock | 144.85 | 146.0 | 144.85 | 145.05 | 85031.0 |
| 2021-07-28 07:20:00 | AAPL | Stock | 145.1 | 145.44 | 145.09 | 145.35 | 51634.0 |
| 2021-07-28 07:25:00 | AAPL | Stock | 145.3 | 145.45 | 145.14 | 145.17 | 21834.0 |
| 2021-07-28 07:30:00 | AAPL | Stock | 145.17 | 145.4 | 145.17 | 145.4 | 26803.0 |
| 2021-07-28 07:35:00 | AAPL | Stock | 145.45 | 145.47 | 145.04 | 145.09 | 45765.0 |
| 2021-07-28 07:40:00 | AAPL | Stock | 145.07 | 145.15 | 144.85 | 145.15 | 35615.0 |
| 2021-07-28 07:45:00 | AAPL | Stock | 145.12 | 145.3 | 145.1 | 145.25 | 28448.0 |
| 2021-07-28 07:50:00 | AAPL | Stock | 145.25 | 145.39 | 145.05 | 145.1 | 88614.0 |
| 2021-07-28 07:55:00 | AAPL | Stock | 145.15 | 145.37 | 145.1 | 145.3 | 41648.0 |
| 2021-07-28 08:00:00 | AAPL | Stock | 145.33 | 145.85 | 144.28 | 145.8 | 350300.0 |
| 2021-07-28 08:05:00 | AAPL | Stock | 145.8 | 145.84 | 145.6 | 145.7 | 77959.0 |
> showing 50 of 442,153 rows — these rows as CSV