PREVIEW / stock_5min / 2020-09-18
file: by_date/stock_5min/2020/2020-09-18.parquet size: 6.6 MB rows: 410,749 symbols: 2,492
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-18 04:00:00 | AAPL | Stock | 111.0 | 111.1 | 110.6 | 110.98 | 7293.0 |
| 2020-09-18 04:05:00 | AAPL | Stock | 110.86 | 111.3 | 110.86 | 111.27 | 5315.0 |
| 2020-09-18 04:10:00 | AAPL | Stock | 111.28 | 111.28 | 111.1 | 111.18 | 3509.0 |
| 2020-09-18 04:15:00 | AAPL | Stock | 111.24 | 111.61 | 111.24 | 111.5 | 7108.0 |
| 2020-09-18 04:20:00 | AAPL | Stock | 111.49 | 111.5 | 111.35 | 111.43 | 2396.0 |
| 2020-09-18 04:25:00 | AAPL | Stock | 111.43 | 111.55 | 111.39 | 111.45 | 2557.0 |
| 2020-09-18 04:30:00 | AAPL | Stock | 111.49 | 111.5 | 111.04 | 111.04 | 3186.0 |
| 2020-09-18 04:35:00 | AAPL | Stock | 111.1 | 111.21 | 110.8 | 111.21 | 4520.0 |
| 2020-09-18 04:40:00 | AAPL | Stock | 111.21 | 111.39 | 111.21 | 111.39 | 800.0 |
| 2020-09-18 04:45:00 | AAPL | Stock | 111.33 | 111.45 | 111.26 | 111.3 | 1655.0 |
| 2020-09-18 04:50:00 | AAPL | Stock | 111.27 | 111.32 | 111.27 | 111.31 | 714.0 |
| 2020-09-18 04:55:00 | AAPL | Stock | 111.31 | 111.34 | 111.25 | 111.3 | 2309.0 |
| 2020-09-18 05:00:00 | AAPL | Stock | 111.23 | 111.37 | 111.23 | 111.27 | 990.0 |
| 2020-09-18 05:05:00 | AAPL | Stock | 111.37 | 111.37 | 111.26 | 111.26 | 704.0 |
| 2020-09-18 05:10:00 | AAPL | Stock | 111.3 | 111.42 | 111.3 | 111.42 | 3607.0 |
| 2020-09-18 05:15:00 | AAPL | Stock | 111.4 | 111.45 | 111.4 | 111.45 | 1652.0 |
| 2020-09-18 05:20:00 | AAPL | Stock | 111.4 | 111.4 | 111.36 | 111.36 | 1245.0 |
| 2020-09-18 05:25:00 | AAPL | Stock | 111.35 | 111.52 | 111.35 | 111.51 | 3434.0 |
| 2020-09-18 05:30:00 | AAPL | Stock | 111.52 | 111.55 | 111.5 | 111.52 | 1021.0 |
| 2020-09-18 05:35:00 | AAPL | Stock | 111.5 | 111.74 | 111.5 | 111.59 | 3416.0 |
| 2020-09-18 05:40:00 | AAPL | Stock | 111.6 | 111.7 | 111.6 | 111.7 | 974.0 |
| 2020-09-18 05:45:00 | AAPL | Stock | 111.7 | 111.9 | 111.7 | 111.8 | 2387.0 |
| 2020-09-18 05:50:00 | AAPL | Stock | 111.65 | 111.65 | 111.5 | 111.6 | 1927.0 |
| 2020-09-18 05:55:00 | AAPL | Stock | 111.5 | 111.5 | 111.5 | 111.5 | 200.0 |
| 2020-09-18 06:00:00 | AAPL | Stock | 111.45 | 111.45 | 111.35 | 111.35 | 2465.0 |
| 2020-09-18 06:05:00 | AAPL | Stock | 111.36 | 111.45 | 111.36 | 111.4 | 1899.0 |
| 2020-09-18 06:10:00 | AAPL | Stock | 111.41 | 111.45 | 111.31 | 111.45 | 1359.0 |
| 2020-09-18 06:15:00 | AAPL | Stock | 111.39 | 111.42 | 111.35 | 111.42 | 2386.0 |
| 2020-09-18 06:20:00 | AAPL | Stock | 111.49 | 111.5 | 111.49 | 111.5 | 300.0 |
| 2020-09-18 06:25:00 | AAPL | Stock | 111.5 | 111.5 | 111.43 | 111.5 | 1211.0 |
| 2020-09-18 06:30:00 | AAPL | Stock | 111.5 | 111.6 | 111.5 | 111.6 | 1268.0 |
| 2020-09-18 06:35:00 | AAPL | Stock | 111.6 | 111.7 | 111.54 | 111.55 | 6955.0 |
| 2020-09-18 06:40:00 | AAPL | Stock | 111.6 | 111.63 | 111.35 | 111.45 | 3233.0 |
| 2020-09-18 06:45:00 | AAPL | Stock | 111.45 | 111.45 | 111.12 | 111.38 | 3705.0 |
| 2020-09-18 06:50:00 | AAPL | Stock | 111.32 | 111.32 | 111.32 | 111.32 | 200.0 |
| 2020-09-18 06:55:00 | AAPL | Stock | 111.25 | 111.49 | 111.25 | 111.4 | 4425.0 |
| 2020-09-18 07:00:00 | AAPL | Stock | 111.42 | 111.52 | 110.6 | 110.83 | 290607.0 |
| 2020-09-18 07:05:00 | AAPL | Stock | 110.84 | 111.1 | 110.77 | 110.9 | 23020.0 |
| 2020-09-18 07:10:00 | AAPL | Stock | 110.89 | 111.17 | 110.89 | 111.17 | 26059.0 |
| 2020-09-18 07:15:00 | AAPL | Stock | 111.13 | 111.24 | 111.1 | 111.23 | 11954.0 |
| 2020-09-18 07:20:00 | AAPL | Stock | 111.17 | 111.28 | 111.1 | 111.28 | 31774.0 |
| 2020-09-18 07:25:00 | AAPL | Stock | 111.29 | 111.5 | 111.29 | 111.5 | 46065.0 |
| 2020-09-18 07:30:00 | AAPL | Stock | 111.49 | 111.55 | 111.23 | 111.49 | 104738.0 |
| 2020-09-18 07:35:00 | AAPL | Stock | 111.44 | 111.44 | 111.06 | 111.11 | 40428.0 |
| 2020-09-18 07:40:00 | AAPL | Stock | 111.11 | 111.2 | 111.02 | 111.09 | 29291.0 |
| 2020-09-18 07:45:00 | AAPL | Stock | 111.05 | 111.34 | 110.89 | 111.25 | 29537.0 |
| 2020-09-18 07:50:00 | AAPL | Stock | 111.3 | 111.3 | 111.05 | 111.1 | 13657.0 |
| 2020-09-18 07:55:00 | AAPL | Stock | 111.1 | 111.1 | 110.72 | 110.92 | 70041.0 |
| 2020-09-18 08:00:00 | AAPL | Stock | 110.89 | 111.54 | 110.5 | 110.51 | 525661.0 |
| 2020-09-18 08:05:00 | AAPL | Stock | 110.51 | 110.7 | 110.391 | 110.4 | 112947.0 |
> showing 50 of 410,749 rows — these rows as CSV