PREVIEW / stock_5min / 2020-11-18
file: by_date/stock_5min/2020/2020-11-18.parquet size: 7.0 MB rows: 427,937 symbols: 2,559
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-11-18 04:00:00 | AAPL | Stock | 119.4 | 119.43 | 119.4 | 119.43 | 461.0 |
| 2020-11-18 04:05:00 | AAPL | Stock | 119.5 | 119.56 | 119.49 | 119.51 | 2319.0 |
| 2020-11-18 04:10:00 | AAPL | Stock | 119.51 | 119.56 | 119.5 | 119.56 | 2011.0 |
| 2020-11-18 04:20:00 | AAPL | Stock | 119.5 | 119.5 | 119.46 | 119.46 | 542.0 |
| 2020-11-18 04:25:00 | AAPL | Stock | 119.56 | 119.56 | 119.51 | 119.52 | 3352.0 |
| 2020-11-18 04:35:00 | AAPL | Stock | 119.41 | 119.41 | 119.41 | 119.41 | 176.0 |
| 2020-11-18 04:40:00 | AAPL | Stock | 119.4 | 119.4 | 119.4 | 119.4 | 560.0 |
| 2020-11-18 04:45:00 | AAPL | Stock | 119.48 | 119.49 | 119.47 | 119.47 | 741.0 |
| 2020-11-18 04:50:00 | AAPL | Stock | 119.41 | 119.41 | 119.41 | 119.41 | 363.0 |
| 2020-11-18 04:55:00 | AAPL | Stock | 119.4 | 119.46 | 119.4 | 119.46 | 307.0 |
| 2020-11-18 05:00:00 | AAPL | Stock | 119.42 | 119.42 | 119.42 | 119.42 | 100.0 |
| 2020-11-18 05:05:00 | AAPL | Stock | 119.5 | 119.56 | 119.5 | 119.5 | 3906.0 |
| 2020-11-18 05:10:00 | AAPL | Stock | 119.52 | 119.63 | 119.5 | 119.57 | 6700.0 |
| 2020-11-18 05:15:00 | AAPL | Stock | 119.61 | 119.61 | 119.54 | 119.54 | 450.0 |
| 2020-11-18 05:20:00 | AAPL | Stock | 119.57 | 119.57 | 119.57 | 119.57 | 100.0 |
| 2020-11-18 05:25:00 | AAPL | Stock | 119.65 | 119.65 | 119.51 | 119.53 | 1196.0 |
| 2020-11-18 05:30:00 | AAPL | Stock | 119.62 | 119.62 | 119.58 | 119.59 | 454.0 |
| 2020-11-18 05:35:00 | AAPL | Stock | 119.6 | 119.6 | 119.59 | 119.59 | 1450.0 |
| 2020-11-18 05:40:00 | AAPL | Stock | 119.67 | 119.74 | 119.66 | 119.74 | 1284.0 |
| 2020-11-18 05:45:00 | AAPL | Stock | 119.74 | 119.77 | 119.74 | 119.77 | 242.0 |
| 2020-11-18 05:50:00 | AAPL | Stock | 119.8 | 119.8 | 119.7 | 119.73 | 1666.0 |
| 2020-11-18 05:55:00 | AAPL | Stock | 119.76 | 119.86 | 119.76 | 119.86 | 14992.0 |
| 2020-11-18 06:00:00 | AAPL | Stock | 119.75 | 119.88 | 118.75 | 119.21 | 28909.0 |
| 2020-11-18 06:05:00 | AAPL | Stock | 119.3 | 119.3 | 119.0 | 119.0 | 21462.0 |
| 2020-11-18 06:10:00 | AAPL | Stock | 119.04 | 119.2 | 118.97 | 119.1 | 14876.0 |
| 2020-11-18 06:15:00 | AAPL | Stock | 119.15 | 119.18 | 119.05 | 119.17 | 3779.0 |
| 2020-11-18 06:20:00 | AAPL | Stock | 119.12 | 119.29 | 119.1 | 119.29 | 500.0 |
| 2020-11-18 06:25:00 | AAPL | Stock | 119.26 | 119.26 | 118.9 | 119.0 | 12136.0 |
| 2020-11-18 06:30:00 | AAPL | Stock | 119.24 | 119.25 | 118.99 | 119.1 | 10913.0 |
| 2020-11-18 06:35:00 | AAPL | Stock | 119.09 | 119.09 | 118.7 | 118.7 | 5229.0 |
| 2020-11-18 06:40:00 | AAPL | Stock | 118.7 | 118.79 | 118.64 | 118.73 | 8652.0 |
| 2020-11-18 06:45:00 | AAPL | Stock | 118.63 | 118.73 | 118.63 | 118.68 | 4796.0 |
| 2020-11-18 06:50:00 | AAPL | Stock | 118.68 | 118.75 | 118.65 | 118.75 | 12375.0 |
| 2020-11-18 06:55:00 | AAPL | Stock | 118.76 | 118.96 | 118.74 | 118.96 | 3122.0 |
| 2020-11-18 07:00:00 | AAPL | Stock | 118.98 | 119.3 | 118.97 | 119.05 | 26986.0 |
| 2020-11-18 07:05:00 | AAPL | Stock | 119.08 | 119.27 | 119.06 | 119.26 | 23166.0 |
| 2020-11-18 07:10:00 | AAPL | Stock | 119.22 | 119.3 | 119.21 | 119.26 | 9537.0 |
| 2020-11-18 07:15:00 | AAPL | Stock | 119.22 | 119.31 | 119.21 | 119.31 | 8910.0 |
| 2020-11-18 07:20:00 | AAPL | Stock | 119.31 | 119.5 | 119.3 | 119.5 | 6831.0 |
| 2020-11-18 07:25:00 | AAPL | Stock | 119.49 | 119.49 | 119.37 | 119.43 | 72152.0 |
| 2020-11-18 07:30:00 | AAPL | Stock | 119.43 | 119.43 | 119.22 | 119.3 | 19386.0 |
| 2020-11-18 07:35:00 | AAPL | Stock | 119.27 | 119.29 | 119.2 | 119.25 | 22544.0 |
| 2020-11-18 07:40:00 | AAPL | Stock | 119.25 | 119.33 | 119.2 | 119.26 | 22510.0 |
| 2020-11-18 07:45:00 | AAPL | Stock | 119.26 | 119.32 | 119.15 | 119.18 | 19539.0 |
| 2020-11-18 07:50:00 | AAPL | Stock | 119.2 | 119.22 | 119.11 | 119.22 | 17192.0 |
| 2020-11-18 07:55:00 | AAPL | Stock | 119.24 | 119.28 | 119.24 | 119.27 | 3838.0 |
| 2020-11-18 08:00:00 | AAPL | Stock | 119.2 | 119.53 | 119.03 | 119.17 | 135375.0 |
| 2020-11-18 08:05:00 | AAPL | Stock | 119.16 | 119.19 | 119.1 | 119.18 | 19560.0 |
| 2020-11-18 08:10:00 | AAPL | Stock | 119.18 | 119.23 | 118.96 | 119.03 | 71489.0 |
| 2020-11-18 08:15:00 | AAPL | Stock | 119.04 | 119.07 | 118.97 | 119.0 | 39713.0 |
> showing 50 of 427,937 rows — these rows as CSV