PREVIEW / stock_5min / 2020-09-25
file: by_date/stock_5min/2020/2020-09-25.parquet size: 6.3 MB rows: 399,472 symbols: 2,494
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 |
|---|---|---|---|---|---|---|---|
| 2020-09-25 04:00:00 | AAPL | Stock | 108.53 | 108.53 | 108.22 | 108.42 | 2920.0 |
| 2020-09-25 04:05:00 | AAPL | Stock | 108.5 | 108.5 | 108.02 | 108.11 | 7283.0 |
| 2020-09-25 04:10:00 | AAPL | Stock | 108.07 | 108.15 | 108.07 | 108.15 | 866.0 |
| 2020-09-25 04:15:00 | AAPL | Stock | 108.1 | 108.24 | 108.09 | 108.24 | 2073.0 |
| 2020-09-25 04:20:00 | AAPL | Stock | 108.3 | 108.39 | 108.3 | 108.39 | 850.0 |
| 2020-09-25 04:25:00 | AAPL | Stock | 108.39 | 108.39 | 108.21 | 108.21 | 3652.0 |
| 2020-09-25 04:30:00 | AAPL | Stock | 108.29 | 108.4 | 108.29 | 108.4 | 2327.0 |
| 2020-09-25 04:35:00 | AAPL | Stock | 108.42 | 108.42 | 108.27 | 108.27 | 547.0 |
| 2020-09-25 04:40:00 | AAPL | Stock | 108.42 | 108.42 | 108.31 | 108.31 | 1253.0 |
| 2020-09-25 04:45:00 | AAPL | Stock | 108.31 | 108.31 | 108.29 | 108.29 | 1434.0 |
| 2020-09-25 04:55:00 | AAPL | Stock | 108.4 | 108.4 | 108.4 | 108.4 | 300.0 |
| 2020-09-25 05:00:00 | AAPL | Stock | 108.5 | 108.62 | 108.5 | 108.62 | 1127.0 |
| 2020-09-25 05:05:00 | AAPL | Stock | 108.68 | 108.69 | 108.67 | 108.69 | 820.0 |
| 2020-09-25 05:10:00 | AAPL | Stock | 108.6 | 108.7 | 108.6 | 108.6 | 600.0 |
| 2020-09-25 05:15:00 | AAPL | Stock | 108.6 | 108.6 | 108.6 | 108.6 | 835.0 |
| 2020-09-25 05:20:00 | AAPL | Stock | 108.6 | 108.65 | 108.55 | 108.63 | 847.0 |
| 2020-09-25 05:25:00 | AAPL | Stock | 108.31 | 108.41 | 108.04 | 108.04 | 899.0 |
| 2020-09-25 05:30:00 | AAPL | Stock | 108.3 | 108.3 | 108.11 | 108.11 | 1837.0 |
| 2020-09-25 05:35:00 | AAPL | Stock | 108.18 | 108.22 | 108.18 | 108.22 | 414.0 |
| 2020-09-25 05:40:00 | AAPL | Stock | 108.24 | 108.24 | 107.54 | 107.85 | 4234.0 |
| 2020-09-25 05:45:00 | AAPL | Stock | 107.76 | 107.99 | 107.74 | 107.99 | 2099.0 |
| 2020-09-25 05:50:00 | AAPL | Stock | 107.9 | 108.01 | 107.8 | 108.01 | 3269.0 |
| 2020-09-25 05:55:00 | AAPL | Stock | 108.03 | 108.11 | 108.03 | 108.11 | 248.0 |
| 2020-09-25 06:00:00 | AAPL | Stock | 108.07 | 108.07 | 108.07 | 108.07 | 100.0 |
| 2020-09-25 06:05:00 | AAPL | Stock | 108.02 | 108.4 | 108.01 | 108.22 | 3337.0 |
| 2020-09-25 06:10:00 | AAPL | Stock | 108.13 | 108.22 | 107.9 | 107.9 | 1491.0 |
| 2020-09-25 06:15:00 | AAPL | Stock | 107.91 | 108.0 | 107.8 | 107.8 | 1870.0 |
| 2020-09-25 06:20:00 | AAPL | Stock | 107.74 | 107.89 | 107.65 | 107.75 | 6371.0 |
| 2020-09-25 06:25:00 | AAPL | Stock | 107.79 | 107.85 | 107.79 | 107.8 | 300.0 |
| 2020-09-25 06:30:00 | AAPL | Stock | 107.8 | 107.88 | 107.8 | 107.88 | 1739.0 |
| 2020-09-25 06:35:00 | AAPL | Stock | 107.81 | 107.81 | 107.8 | 107.8 | 227.0 |
| 2020-09-25 06:40:00 | AAPL | Stock | 107.67 | 107.67 | 107.55 | 107.62 | 3202.0 |
| 2020-09-25 06:45:00 | AAPL | Stock | 107.73 | 107.75 | 107.51 | 107.66 | 1862.0 |
| 2020-09-25 06:50:00 | AAPL | Stock | 107.5 | 107.5 | 107.5 | 107.5 | 382.0 |
| 2020-09-25 06:55:00 | AAPL | Stock | 107.37 | 107.5 | 107.27 | 107.5 | 3047.0 |
| 2020-09-25 07:00:00 | AAPL | Stock | 107.62 | 107.79 | 107.2 | 107.64 | 57505.0 |
| 2020-09-25 07:05:00 | AAPL | Stock | 107.61 | 107.64 | 107.36 | 107.64 | 19764.0 |
| 2020-09-25 07:10:00 | AAPL | Stock | 107.64 | 107.74 | 107.62 | 107.62 | 10679.0 |
| 2020-09-25 07:15:00 | AAPL | Stock | 107.62 | 108.0 | 107.6 | 107.83 | 23678.0 |
| 2020-09-25 07:20:00 | AAPL | Stock | 107.85 | 108.27 | 107.85 | 108.03 | 45628.0 |
| 2020-09-25 07:25:00 | AAPL | Stock | 108.03 | 108.1 | 107.8 | 108.03 | 22276.0 |
| 2020-09-25 07:30:00 | AAPL | Stock | 108.01 | 108.06 | 107.66 | 108.06 | 20413.0 |
| 2020-09-25 07:35:00 | AAPL | Stock | 108.06 | 108.35 | 107.9 | 108.26 | 22950.0 |
| 2020-09-25 07:40:00 | AAPL | Stock | 108.3 | 108.37 | 108.22 | 108.37 | 22060.0 |
| 2020-09-25 07:45:00 | AAPL | Stock | 108.38 | 108.38 | 108.17 | 108.25 | 13481.0 |
| 2020-09-25 07:50:00 | AAPL | Stock | 108.25 | 108.62 | 108.25 | 108.6 | 31715.0 |
| 2020-09-25 07:55:00 | AAPL | Stock | 108.55 | 108.67 | 108.42 | 108.56 | 13216.0 |
| 2020-09-25 08:00:00 | AAPL | Stock | 107.45 | 109.0 | 107.25 | 108.84 | 290899.0 |
| 2020-09-25 08:05:00 | AAPL | Stock | 108.82 | 108.82 | 108.7 | 108.7 | 30949.0 |
| 2020-09-25 08:10:00 | AAPL | Stock | 108.66 | 108.7 | 108.524 | 108.61 | 36004.0 |
> showing 50 of 399,472 rows — these rows as CSV