PREVIEW / stock_5min / 2021-03-19
file: by_date/stock_5min/2021/2021-03-19.parquet size: 7.8 MB rows: 483,810 symbols: 2,920
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-03-19 04:00:00 | AAPL | Stock | 120.86 | 121.39 | 120.86 | 121.3 | 3661.0 |
| 2021-03-19 04:05:00 | AAPL | Stock | 121.35 | 121.48 | 121.35 | 121.41 | 2025.0 |
| 2021-03-19 04:10:00 | AAPL | Stock | 121.53 | 121.53 | 121.35 | 121.42 | 696.0 |
| 2021-03-19 04:15:00 | AAPL | Stock | 121.39 | 121.46 | 121.39 | 121.46 | 3152.0 |
| 2021-03-19 04:20:00 | AAPL | Stock | 121.5 | 121.5 | 121.38 | 121.4 | 3748.0 |
| 2021-03-19 04:25:00 | AAPL | Stock | 121.4 | 121.45 | 121.39 | 121.44 | 1438.0 |
| 2021-03-19 04:30:00 | AAPL | Stock | 121.44 | 121.65 | 121.44 | 121.65 | 4605.0 |
| 2021-03-19 04:35:00 | AAPL | Stock | 121.57 | 121.63 | 121.56 | 121.63 | 1382.0 |
| 2021-03-19 04:40:00 | AAPL | Stock | 121.64 | 121.68 | 121.55 | 121.59 | 5210.0 |
| 2021-03-19 04:45:00 | AAPL | Stock | 121.6 | 121.6 | 121.5 | 121.6 | 1840.0 |
| 2021-03-19 04:50:00 | AAPL | Stock | 121.61 | 121.64 | 121.6 | 121.64 | 1363.0 |
| 2021-03-19 04:55:00 | AAPL | Stock | 121.64 | 121.7 | 121.64 | 121.7 | 1716.0 |
| 2021-03-19 05:00:00 | AAPL | Stock | 121.63 | 121.66 | 121.58 | 121.61 | 678.0 |
| 2021-03-19 05:05:00 | AAPL | Stock | 121.65 | 121.65 | 121.57 | 121.63 | 1421.0 |
| 2021-03-19 05:10:00 | AAPL | Stock | 121.65 | 121.65 | 121.65 | 121.65 | 500.0 |
| 2021-03-19 05:15:00 | AAPL | Stock | 121.65 | 121.65 | 121.6 | 121.6 | 2362.0 |
| 2021-03-19 05:20:00 | AAPL | Stock | 121.53 | 121.53 | 121.53 | 121.53 | 299.0 |
| 2021-03-19 05:25:00 | AAPL | Stock | 121.63 | 121.63 | 121.63 | 121.63 | 1058.0 |
| 2021-03-19 05:30:00 | AAPL | Stock | 121.51 | 121.51 | 121.51 | 121.51 | 100.0 |
| 2021-03-19 05:35:00 | AAPL | Stock | 121.5 | 121.5 | 121.5 | 121.5 | 200.0 |
| 2021-03-19 05:40:00 | AAPL | Stock | 121.5 | 121.5 | 121.47 | 121.49 | 1613.0 |
| 2021-03-19 05:45:00 | AAPL | Stock | 121.5 | 121.57 | 121.49 | 121.57 | 2173.0 |
| 2021-03-19 05:50:00 | AAPL | Stock | 121.5 | 121.5 | 121.5 | 121.5 | 159.0 |
| 2021-03-19 05:55:00 | AAPL | Stock | 121.51 | 121.55 | 121.51 | 121.55 | 990.0 |
| 2021-03-19 06:00:00 | AAPL | Stock | 121.47 | 121.47 | 121.43 | 121.43 | 777.0 |
| 2021-03-19 06:05:00 | AAPL | Stock | 121.48 | 121.48 | 121.48 | 121.48 | 100.0 |
| 2021-03-19 06:10:00 | AAPL | Stock | 121.37 | 121.37 | 121.25 | 121.25 | 500.0 |
| 2021-03-19 06:15:00 | AAPL | Stock | 121.29 | 121.31 | 121.26 | 121.31 | 1266.0 |
| 2021-03-19 06:20:00 | AAPL | Stock | 121.21 | 121.21 | 121.11 | 121.11 | 3449.0 |
| 2021-03-19 06:25:00 | AAPL | Stock | 121.17 | 121.17 | 121.17 | 121.17 | 409.0 |
| 2021-03-19 06:30:00 | AAPL | Stock | 121.32 | 121.38 | 121.3 | 121.37 | 3146.0 |
| 2021-03-19 06:35:00 | AAPL | Stock | 121.31 | 121.31 | 121.28 | 121.28 | 507.0 |
| 2021-03-19 06:40:00 | AAPL | Stock | 121.28 | 121.28 | 121.28 | 121.28 | 3818.0 |
| 2021-03-19 06:45:00 | AAPL | Stock | 121.28 | 121.38 | 121.27 | 121.38 | 3830.0 |
| 2021-03-19 06:50:00 | AAPL | Stock | 121.38 | 121.59 | 121.38 | 121.44 | 1644.0 |
| 2021-03-19 06:55:00 | AAPL | Stock | 121.36 | 121.4 | 121.3 | 121.3 | 3196.0 |
| 2021-03-19 07:00:00 | AAPL | Stock | 121.27 | 121.37 | 121.03 | 121.24 | 34365.0 |
| 2021-03-19 07:05:00 | AAPL | Stock | 121.22 | 121.22 | 121.13 | 121.13 | 9811.0 |
| 2021-03-19 07:10:00 | AAPL | Stock | 121.15 | 121.19 | 121.09 | 121.12 | 9443.0 |
| 2021-03-19 07:15:00 | AAPL | Stock | 121.1 | 121.19 | 121.07 | 121.15 | 6262.0 |
| 2021-03-19 07:20:00 | AAPL | Stock | 121.15 | 121.2 | 121.0 | 121.0 | 18675.0 |
| 2021-03-19 07:25:00 | AAPL | Stock | 121.02 | 121.2 | 121.01 | 121.19 | 12859.0 |
| 2021-03-19 07:30:00 | AAPL | Stock | 121.17 | 121.17 | 121.11 | 121.14 | 9431.0 |
| 2021-03-19 07:35:00 | AAPL | Stock | 121.15 | 121.2 | 121.14 | 121.19 | 7659.0 |
| 2021-03-19 07:40:00 | AAPL | Stock | 121.19 | 121.39 | 121.19 | 121.38 | 21200.0 |
| 2021-03-19 07:45:00 | AAPL | Stock | 121.38 | 121.41 | 121.34 | 121.39 | 19858.0 |
| 2021-03-19 07:50:00 | AAPL | Stock | 121.39 | 121.4 | 121.29 | 121.29 | 4833.0 |
| 2021-03-19 07:55:00 | AAPL | Stock | 121.3 | 121.4 | 121.3 | 121.32 | 14401.0 |
| 2021-03-19 08:00:00 | AAPL | Stock | 121.2401 | 121.41 | 121.0101 | 121.2 | 181129.0 |
| 2021-03-19 08:05:00 | AAPL | Stock | 121.2 | 121.34 | 121.05 | 121.15 | 37880.0 |
> showing 50 of 483,810 rows — these rows as CSV