PREVIEW / stock_5min / 2020-10-21
file: by_date/stock_5min/2020/2020-10-21.parquet size: 6.5 MB rows: 400,796 symbols: 2,515
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-10-21 04:00:00 | AAPL | Stock | 117.61 | 117.61 | 117.39 | 117.39 | 4792.0 |
| 2020-10-21 04:05:00 | AAPL | Stock | 117.41 | 117.88 | 117.2 | 117.31 | 4132.0 |
| 2020-10-21 04:10:00 | AAPL | Stock | 117.21 | 117.33 | 117.2 | 117.33 | 5690.0 |
| 2020-10-21 04:15:00 | AAPL | Stock | 117.24 | 117.29 | 117.23 | 117.26 | 678.0 |
| 2020-10-21 04:20:00 | AAPL | Stock | 117.22 | 117.25 | 116.64 | 116.89 | 6792.0 |
| 2020-10-21 04:25:00 | AAPL | Stock | 116.72 | 116.83 | 116.72 | 116.73 | 2651.0 |
| 2020-10-21 04:30:00 | AAPL | Stock | 117.0 | 117.2 | 117.0 | 117.2 | 4850.0 |
| 2020-10-21 04:35:00 | AAPL | Stock | 117.2 | 117.28 | 117.2 | 117.23 | 602.0 |
| 2020-10-21 04:40:00 | AAPL | Stock | 117.3 | 117.3 | 117.2 | 117.2 | 2792.0 |
| 2020-10-21 04:45:00 | AAPL | Stock | 117.1 | 117.1 | 117.0 | 117.06 | 3763.0 |
| 2020-10-21 04:50:00 | AAPL | Stock | 117.1 | 117.11 | 117.1 | 117.1 | 2342.0 |
| 2020-10-21 04:55:00 | AAPL | Stock | 117.0 | 117.0 | 116.53 | 116.59 | 9567.0 |
| 2020-10-21 05:00:00 | AAPL | Stock | 116.65 | 116.77 | 116.5 | 116.7 | 8493.0 |
| 2020-10-21 05:05:00 | AAPL | Stock | 116.77 | 117.0 | 116.77 | 117.0 | 1809.0 |
| 2020-10-21 05:10:00 | AAPL | Stock | 116.94 | 116.95 | 116.84 | 116.84 | 3320.0 |
| 2020-10-21 05:15:00 | AAPL | Stock | 116.88 | 117.08 | 116.88 | 117.08 | 1180.0 |
| 2020-10-21 05:20:00 | AAPL | Stock | 117.02 | 117.2 | 117.01 | 117.2 | 2340.0 |
| 2020-10-21 05:25:00 | AAPL | Stock | 117.19 | 117.23 | 117.15 | 117.23 | 1494.0 |
| 2020-10-21 05:30:00 | AAPL | Stock | 117.25 | 117.3 | 117.2 | 117.2 | 1448.0 |
| 2020-10-21 05:35:00 | AAPL | Stock | 117.27 | 117.72 | 117.27 | 117.53 | 2273.0 |
| 2020-10-21 05:40:00 | AAPL | Stock | 117.59 | 117.6 | 117.51 | 117.51 | 3198.0 |
| 2020-10-21 05:45:00 | AAPL | Stock | 117.5 | 117.51 | 117.5 | 117.5 | 1265.0 |
| 2020-10-21 05:50:00 | AAPL | Stock | 117.58 | 117.79 | 117.5 | 117.5 | 2433.0 |
| 2020-10-21 05:55:00 | AAPL | Stock | 117.5 | 117.5 | 117.39 | 117.4 | 582.0 |
| 2020-10-21 06:00:00 | AAPL | Stock | 117.5 | 117.63 | 117.5 | 117.54 | 2780.0 |
| 2020-10-21 06:05:00 | AAPL | Stock | 117.45 | 117.52 | 117.45 | 117.52 | 1111.0 |
| 2020-10-21 06:10:00 | AAPL | Stock | 117.53 | 117.55 | 117.51 | 117.51 | 10074.0 |
| 2020-10-21 06:15:00 | AAPL | Stock | 117.49 | 117.5 | 117.25 | 117.28 | 2247.0 |
| 2020-10-21 06:20:00 | AAPL | Stock | 117.37 | 117.86 | 117.37 | 117.6 | 3730.0 |
| 2020-10-21 06:25:00 | AAPL | Stock | 117.6 | 117.6 | 117.6 | 117.6 | 150.0 |
| 2020-10-21 06:30:00 | AAPL | Stock | 117.6 | 117.67 | 117.59 | 117.59 | 706.0 |
| 2020-10-21 06:35:00 | AAPL | Stock | 117.61 | 117.94 | 117.61 | 117.73 | 2201.0 |
| 2020-10-21 06:40:00 | AAPL | Stock | 117.72 | 117.72 | 117.42 | 117.42 | 4843.0 |
| 2020-10-21 06:45:00 | AAPL | Stock | 117.5 | 117.5 | 117.49 | 117.5 | 4302.0 |
| 2020-10-21 06:50:00 | AAPL | Stock | 117.46 | 117.46 | 117.34 | 117.34 | 407.0 |
| 2020-10-21 06:55:00 | AAPL | Stock | 117.43 | 117.46 | 117.33 | 117.33 | 5325.0 |
| 2020-10-21 07:00:00 | AAPL | Stock | 117.35 | 117.5 | 117.18 | 117.18 | 42061.0 |
| 2020-10-21 07:05:00 | AAPL | Stock | 117.17 | 117.17 | 117.02 | 117.08 | 15294.0 |
| 2020-10-21 07:10:00 | AAPL | Stock | 117.12 | 117.2 | 117.0 | 117.0 | 25107.0 |
| 2020-10-21 07:15:00 | AAPL | Stock | 117.0 | 117.1 | 116.95 | 117.1 | 14674.0 |
| 2020-10-21 07:20:00 | AAPL | Stock | 117.12 | 117.14 | 117.0 | 117.14 | 8591.0 |
| 2020-10-21 07:25:00 | AAPL | Stock | 117.11 | 117.11 | 116.9 | 117.0 | 21212.0 |
| 2020-10-21 07:30:00 | AAPL | Stock | 117.03 | 117.03 | 116.8 | 116.94 | 30026.0 |
| 2020-10-21 07:35:00 | AAPL | Stock | 116.87 | 116.91 | 116.77 | 116.86 | 10006.0 |
| 2020-10-21 07:40:00 | AAPL | Stock | 116.82 | 117.04 | 116.82 | 117.0 | 18341.0 |
| 2020-10-21 07:45:00 | AAPL | Stock | 116.95 | 117.01 | 116.84 | 116.97 | 12221.0 |
| 2020-10-21 07:50:00 | AAPL | Stock | 116.95 | 117.04 | 116.9 | 116.93 | 9077.0 |
| 2020-10-21 07:55:00 | AAPL | Stock | 116.99 | 117.02 | 116.82 | 116.82 | 11250.0 |
| 2020-10-21 08:00:00 | AAPL | Stock | 117.12 | 117.5 | 116.8 | 116.99 | 138350.0 |
| 2020-10-21 08:05:00 | AAPL | Stock | 117.0 | 117.04 | 116.85 | 116.97 | 17334.0 |
> showing 50 of 400,796 rows — these rows as CSV