PREVIEW / stock_5min / 2020-12-29
file: by_date/stock_5min/2020/2020-12-29.parquet size: 7.5 MB rows: 465,665 symbols: 2,685
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-12-29 04:00:00 | AAPL | Stock | 137.5 | 137.95 | 137.5 | 137.95 | 8670.0 |
| 2020-12-29 04:05:00 | AAPL | Stock | 137.91 | 137.94 | 137.43 | 137.5 | 17043.0 |
| 2020-12-29 04:10:00 | AAPL | Stock | 137.5 | 137.5 | 137.35 | 137.35 | 7070.0 |
| 2020-12-29 04:15:00 | AAPL | Stock | 137.38 | 137.4 | 137.15 | 137.4 | 12104.0 |
| 2020-12-29 04:20:00 | AAPL | Stock | 137.44 | 137.57 | 137.43 | 137.57 | 3734.0 |
| 2020-12-29 04:25:00 | AAPL | Stock | 137.5 | 137.54 | 137.5 | 137.54 | 5939.0 |
| 2020-12-29 04:30:00 | AAPL | Stock | 137.52 | 137.63 | 137.52 | 137.6 | 8614.0 |
| 2020-12-29 04:35:00 | AAPL | Stock | 137.55 | 137.6 | 137.55 | 137.6 | 1000.0 |
| 2020-12-29 04:40:00 | AAPL | Stock | 137.58 | 137.58 | 137.58 | 137.58 | 100.0 |
| 2020-12-29 04:45:00 | AAPL | Stock | 137.53 | 137.6 | 137.53 | 137.6 | 300.0 |
| 2020-12-29 04:50:00 | AAPL | Stock | 137.65 | 137.65 | 137.53 | 137.53 | 3758.0 |
| 2020-12-29 04:55:00 | AAPL | Stock | 137.53 | 137.53 | 137.51 | 137.51 | 635.0 |
| 2020-12-29 05:00:00 | AAPL | Stock | 137.5 | 137.53 | 137.5 | 137.5 | 1760.0 |
| 2020-12-29 05:05:00 | AAPL | Stock | 137.49 | 137.53 | 137.49 | 137.53 | 921.0 |
| 2020-12-29 05:10:00 | AAPL | Stock | 137.53 | 137.6 | 137.53 | 137.58 | 600.0 |
| 2020-12-29 05:15:00 | AAPL | Stock | 137.55 | 137.6 | 137.52 | 137.6 | 1797.0 |
| 2020-12-29 05:20:00 | AAPL | Stock | 137.58 | 137.58 | 137.58 | 137.58 | 492.0 |
| 2020-12-29 05:30:00 | AAPL | Stock | 137.55 | 137.55 | 137.55 | 137.55 | 597.0 |
| 2020-12-29 05:35:00 | AAPL | Stock | 137.57 | 137.57 | 137.01 | 137.49 | 1827.0 |
| 2020-12-29 05:45:00 | AAPL | Stock | 137.47 | 137.53 | 137.47 | 137.53 | 205.0 |
| 2020-12-29 05:50:00 | AAPL | Stock | 137.55 | 137.65 | 137.55 | 137.65 | 6133.0 |
| 2020-12-29 05:55:00 | AAPL | Stock | 137.64 | 137.64 | 137.6 | 137.6 | 1765.0 |
| 2020-12-29 06:00:00 | AAPL | Stock | 137.61 | 137.63 | 137.61 | 137.61 | 1927.0 |
| 2020-12-29 06:05:00 | AAPL | Stock | 137.6 | 137.6 | 137.5 | 137.5 | 1430.0 |
| 2020-12-29 06:10:00 | AAPL | Stock | 137.42 | 137.48 | 137.42 | 137.44 | 2042.0 |
| 2020-12-29 06:15:00 | AAPL | Stock | 137.49 | 137.53 | 137.4 | 137.4 | 1522.0 |
| 2020-12-29 06:20:00 | AAPL | Stock | 137.51 | 137.51 | 137.4 | 137.4 | 1439.0 |
| 2020-12-29 06:25:00 | AAPL | Stock | 137.32 | 137.34 | 137.3 | 137.3 | 1440.0 |
| 2020-12-29 06:30:00 | AAPL | Stock | 137.3 | 137.3 | 137.3 | 137.3 | 2696.0 |
| 2020-12-29 06:35:00 | AAPL | Stock | 137.33 | 137.44 | 137.33 | 137.44 | 6254.0 |
| 2020-12-29 06:40:00 | AAPL | Stock | 137.44 | 137.44 | 137.4 | 137.4 | 5911.0 |
| 2020-12-29 06:45:00 | AAPL | Stock | 137.4 | 137.4 | 137.36 | 137.36 | 475.0 |
| 2020-12-29 06:50:00 | AAPL | Stock | 137.35 | 137.36 | 137.35 | 137.36 | 1040.0 |
| 2020-12-29 06:55:00 | AAPL | Stock | 137.34 | 137.35 | 137.33 | 137.35 | 1586.0 |
| 2020-12-29 07:00:00 | AAPL | Stock | 137.33 | 137.9 | 137.33 | 137.77 | 109185.0 |
| 2020-12-29 07:05:00 | AAPL | Stock | 137.8 | 137.98 | 137.7 | 137.95 | 38693.0 |
| 2020-12-29 07:10:00 | AAPL | Stock | 137.95 | 138.1 | 137.84 | 137.99 | 71987.0 |
| 2020-12-29 07:15:00 | AAPL | Stock | 137.99 | 138.2 | 137.98 | 138.18 | 82739.0 |
| 2020-12-29 07:20:00 | AAPL | Stock | 138.2 | 138.21 | 138.13 | 138.21 | 33181.0 |
| 2020-12-29 07:25:00 | AAPL | Stock | 138.21 | 138.25 | 138.1 | 138.2 | 60570.0 |
| 2020-12-29 07:30:00 | AAPL | Stock | 138.22 | 138.25 | 138.18 | 138.2 | 18560.0 |
| 2020-12-29 07:35:00 | AAPL | Stock | 138.171 | 138.2 | 138.16 | 138.19 | 20747.0 |
| 2020-12-29 07:40:00 | AAPL | Stock | 138.19 | 138.19 | 137.95 | 137.95 | 43603.0 |
| 2020-12-29 07:45:00 | AAPL | Stock | 137.95 | 138.07 | 137.91 | 138.07 | 38997.0 |
| 2020-12-29 07:50:00 | AAPL | Stock | 138.08 | 138.19 | 138.06 | 138.08 | 29218.0 |
| 2020-12-29 07:55:00 | AAPL | Stock | 138.09 | 138.1 | 138.0 | 138.1 | 16528.0 |
| 2020-12-29 08:00:00 | AAPL | Stock | 137.7 | 138.25 | 137.35 | 137.97 | 334396.0 |
| 2020-12-29 08:05:00 | AAPL | Stock | 138.0 | 138.0 | 137.87 | 137.89 | 68288.0 |
| 2020-12-29 08:10:00 | AAPL | Stock | 137.88 | 137.96 | 137.86 | 137.94 | 30604.0 |
| 2020-12-29 08:15:00 | AAPL | Stock | 137.94 | 138.0 | 137.9 | 137.99 | 34552.0 |
> showing 50 of 465,665 rows — these rows as CSV