PREVIEW / stock_5min / 2020-10-14
file: by_date/stock_5min/2020/2020-10-14.parquet size: 6.4 MB rows: 397,544 symbols: 2,495
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-14 04:00:00 | AAPL | Stock | 121.55 | 122.4 | 121.31 | 122.3 | 15450.0 |
| 2020-10-14 04:05:00 | AAPL | Stock | 122.25 | 122.57 | 122.25 | 122.3 | 19473.0 |
| 2020-10-14 04:10:00 | AAPL | Stock | 122.3 | 122.45 | 122.25 | 122.38 | 12171.0 |
| 2020-10-14 04:15:00 | AAPL | Stock | 122.33 | 122.38 | 122.0 | 122.01 | 8958.0 |
| 2020-10-14 04:20:00 | AAPL | Stock | 122.09 | 122.15 | 121.89 | 122.14 | 16167.0 |
| 2020-10-14 04:25:00 | AAPL | Stock | 122.14 | 122.2 | 122.14 | 122.16 | 2692.0 |
| 2020-10-14 04:30:00 | AAPL | Stock | 122.3 | 122.39 | 122.2 | 122.2 | 4135.0 |
| 2020-10-14 04:35:00 | AAPL | Stock | 122.29 | 122.29 | 122.02 | 122.03 | 14950.0 |
| 2020-10-14 04:40:00 | AAPL | Stock | 122.08 | 122.19 | 122.03 | 122.18 | 4867.0 |
| 2020-10-14 04:45:00 | AAPL | Stock | 122.23 | 122.38 | 122.23 | 122.3 | 11018.0 |
| 2020-10-14 04:50:00 | AAPL | Stock | 122.2 | 122.3 | 122.2 | 122.23 | 2587.0 |
| 2020-10-14 04:55:00 | AAPL | Stock | 122.23 | 122.23 | 122.16 | 122.19 | 1243.0 |
| 2020-10-14 05:00:00 | AAPL | Stock | 122.25 | 122.31 | 122.2 | 122.21 | 5457.0 |
| 2020-10-14 05:05:00 | AAPL | Stock | 122.29 | 122.29 | 122.12 | 122.16 | 5813.0 |
| 2020-10-14 05:10:00 | AAPL | Stock | 122.11 | 122.11 | 121.58 | 122.0 | 9082.0 |
| 2020-10-14 05:15:00 | AAPL | Stock | 121.95 | 122.07 | 121.9 | 121.9 | 5241.0 |
| 2020-10-14 05:20:00 | AAPL | Stock | 121.9 | 121.95 | 121.89 | 121.89 | 1598.0 |
| 2020-10-14 05:25:00 | AAPL | Stock | 121.87 | 121.87 | 121.7 | 121.75 | 4243.0 |
| 2020-10-14 05:30:00 | AAPL | Stock | 121.74 | 121.76 | 121.58 | 121.6 | 2679.0 |
| 2020-10-14 05:35:00 | AAPL | Stock | 121.6 | 121.6 | 121.47 | 121.5 | 7348.0 |
| 2020-10-14 05:40:00 | AAPL | Stock | 121.44 | 121.56 | 121.4 | 121.41 | 5085.0 |
| 2020-10-14 05:45:00 | AAPL | Stock | 121.43 | 121.47 | 121.35 | 121.4 | 5573.0 |
| 2020-10-14 05:50:00 | AAPL | Stock | 121.4 | 121.47 | 121.33 | 121.36 | 1705.0 |
| 2020-10-14 05:55:00 | AAPL | Stock | 121.46 | 121.47 | 121.28 | 121.35 | 4794.0 |
| 2020-10-14 06:00:00 | AAPL | Stock | 121.42 | 121.55 | 121.36 | 121.51 | 5738.0 |
| 2020-10-14 06:05:00 | AAPL | Stock | 121.55 | 121.57 | 120.6 | 120.9 | 14785.0 |
| 2020-10-14 06:10:00 | AAPL | Stock | 120.85 | 120.89 | 120.65 | 120.7 | 10631.0 |
| 2020-10-14 06:15:00 | AAPL | Stock | 120.65 | 120.86 | 120.6 | 120.86 | 5805.0 |
| 2020-10-14 06:20:00 | AAPL | Stock | 120.9 | 121.29 | 120.9 | 121.14 | 11021.0 |
| 2020-10-14 06:25:00 | AAPL | Stock | 121.14 | 121.29 | 121.0 | 121.0 | 15494.0 |
| 2020-10-14 06:30:00 | AAPL | Stock | 121.1 | 121.1 | 120.8 | 120.82 | 7842.0 |
| 2020-10-14 06:35:00 | AAPL | Stock | 120.9 | 120.97 | 120.7 | 120.7 | 5759.0 |
| 2020-10-14 06:40:00 | AAPL | Stock | 120.83 | 120.91 | 120.83 | 120.85 | 4420.0 |
| 2020-10-14 06:45:00 | AAPL | Stock | 120.82 | 121.05 | 120.8 | 121.0 | 4266.0 |
| 2020-10-14 06:50:00 | AAPL | Stock | 121.09 | 121.1 | 121.07 | 121.1 | 2002.0 |
| 2020-10-14 06:55:00 | AAPL | Stock | 121.03 | 121.03 | 120.7 | 120.9 | 6422.0 |
| 2020-10-14 07:00:00 | AAPL | Stock | 121.06 | 121.2 | 120.73 | 120.85 | 112784.0 |
| 2020-10-14 07:05:00 | AAPL | Stock | 120.84 | 121.07 | 120.84 | 121.05 | 34845.0 |
| 2020-10-14 07:10:00 | AAPL | Stock | 121.05 | 121.1 | 120.98 | 121.06 | 14360.0 |
| 2020-10-14 07:15:00 | AAPL | Stock | 121.06 | 121.21 | 120.95 | 121.201 | 17239.0 |
| 2020-10-14 07:20:00 | AAPL | Stock | 121.21 | 121.39 | 121.16 | 121.33 | 21186.0 |
| 2020-10-14 07:25:00 | AAPL | Stock | 121.34 | 121.55 | 121.28 | 121.54 | 39184.0 |
| 2020-10-14 07:30:00 | AAPL | Stock | 121.54 | 121.55 | 121.46 | 121.53 | 49993.0 |
| 2020-10-14 07:35:00 | AAPL | Stock | 121.53 | 121.6 | 121.48 | 121.48 | 27949.0 |
| 2020-10-14 07:40:00 | AAPL | Stock | 121.48 | 121.48 | 121.32 | 121.47 | 40157.0 |
| 2020-10-14 07:45:00 | AAPL | Stock | 121.4 | 121.45 | 121.32 | 121.45 | 14446.0 |
| 2020-10-14 07:50:00 | AAPL | Stock | 121.47 | 121.55 | 121.43 | 121.52 | 14204.0 |
| 2020-10-14 07:55:00 | AAPL | Stock | 121.51 | 121.54 | 121.38 | 121.42 | 27032.0 |
| 2020-10-14 08:00:00 | AAPL | Stock | 120.85 | 121.6 | 120.73 | 121.57 | 354517.0 |
| 2020-10-14 08:05:00 | AAPL | Stock | 121.57 | 121.6 | 121.51 | 121.52 | 44831.0 |
> showing 50 of 397,544 rows — these rows as CSV