PREVIEW / stock_5min / 2021-12-20
file: by_date/stock_5min/2021/2021-12-20.parquet size: 7.7 MB rows: 478,824 symbols: 2,647
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-20 04:00:00 | AAPL | Stock | 167.98 | 168.49 | 167.11 | 167.49 | 20057.0 |
| 2021-12-20 04:05:00 | AAPL | Stock | 167.37 | 167.41 | 167.05 | 167.32 | 6693.0 |
| 2021-12-20 04:10:00 | AAPL | Stock | 167.5 | 167.85 | 167.25 | 167.25 | 7598.0 |
| 2021-12-20 04:15:00 | AAPL | Stock | 167.18 | 167.34 | 167.13 | 167.31 | 15723.0 |
| 2021-12-20 04:20:00 | AAPL | Stock | 167.31 | 167.57 | 167.29 | 167.53 | 4819.0 |
| 2021-12-20 04:25:00 | AAPL | Stock | 167.51 | 167.51 | 167.33 | 167.41 | 1926.0 |
| 2021-12-20 04:30:00 | AAPL | Stock | 167.44 | 167.71 | 167.44 | 167.7 | 7765.0 |
| 2021-12-20 04:35:00 | AAPL | Stock | 167.58 | 167.7 | 167.55 | 167.67 | 2101.0 |
| 2021-12-20 04:40:00 | AAPL | Stock | 167.7 | 167.7 | 167.48 | 167.53 | 2959.0 |
| 2021-12-20 04:45:00 | AAPL | Stock | 167.59 | 167.6 | 167.56 | 167.6 | 1683.0 |
| 2021-12-20 04:50:00 | AAPL | Stock | 167.57 | 167.57 | 167.43 | 167.46 | 1826.0 |
| 2021-12-20 04:55:00 | AAPL | Stock | 167.49 | 167.7 | 167.46 | 167.7 | 3170.0 |
| 2021-12-20 05:00:00 | AAPL | Stock | 167.77 | 167.88 | 167.77 | 167.86 | 1972.0 |
| 2021-12-20 05:05:00 | AAPL | Stock | 167.9 | 167.9 | 167.78 | 167.8 | 2288.0 |
| 2021-12-20 05:10:00 | AAPL | Stock | 167.81 | 167.88 | 167.45 | 167.88 | 26829.0 |
| 2021-12-20 05:15:00 | AAPL | Stock | 167.7 | 167.73 | 167.63 | 167.64 | 1038.0 |
| 2021-12-20 05:20:00 | AAPL | Stock | 167.72 | 167.99 | 167.7 | 167.9 | 3026.0 |
| 2021-12-20 05:25:00 | AAPL | Stock | 167.63 | 167.7 | 167.63 | 167.64 | 580.0 |
| 2021-12-20 05:40:00 | AAPL | Stock | 167.64 | 167.67 | 167.64 | 167.67 | 812.0 |
| 2021-12-20 05:45:00 | AAPL | Stock | 167.8 | 167.9 | 167.8 | 167.9 | 5522.0 |
| 2021-12-20 05:50:00 | AAPL | Stock | 167.9 | 167.9 | 167.83 | 167.9 | 4930.0 |
| 2021-12-20 05:55:00 | AAPL | Stock | 167.89 | 167.99 | 167.89 | 167.91 | 2798.0 |
| 2021-12-20 06:00:00 | AAPL | Stock | 167.9 | 167.9 | 167.8 | 167.8 | 1524.0 |
| 2021-12-20 06:05:00 | AAPL | Stock | 167.73 | 167.8 | 167.73 | 167.78 | 3127.0 |
| 2021-12-20 06:10:00 | AAPL | Stock | 167.88 | 168.3 | 167.71 | 168.1 | 30807.0 |
| 2021-12-20 06:15:00 | AAPL | Stock | 168.07 | 168.08 | 167.81 | 168.02 | 4060.0 |
| 2021-12-20 06:20:00 | AAPL | Stock | 168.01 | 168.04 | 167.94 | 168.0 | 4600.0 |
| 2021-12-20 06:25:00 | AAPL | Stock | 168.04 | 168.04 | 168.04 | 168.04 | 1650.0 |
| 2021-12-20 06:30:00 | AAPL | Stock | 168.03 | 168.2 | 168.03 | 168.2 | 2023.0 |
| 2021-12-20 06:35:00 | AAPL | Stock | 168.32 | 168.5 | 168.11 | 168.11 | 3640.0 |
| 2021-12-20 06:40:00 | AAPL | Stock | 168.09 | 168.1 | 168.04 | 168.04 | 2108.0 |
| 2021-12-20 06:45:00 | AAPL | Stock | 168.1 | 168.1 | 167.8 | 167.8 | 2088.0 |
| 2021-12-20 06:50:00 | AAPL | Stock | 167.99 | 168.16 | 167.9 | 168.15 | 2782.0 |
| 2021-12-20 06:55:00 | AAPL | Stock | 168.11 | 168.39 | 168.1 | 168.38 | 4071.0 |
| 2021-12-20 07:00:00 | AAPL | Stock | 168.39 | 168.74 | 168.16 | 168.41 | 54283.0 |
| 2021-12-20 07:05:00 | AAPL | Stock | 168.41 | 168.79 | 168.36 | 168.7 | 26616.0 |
| 2021-12-20 07:10:00 | AAPL | Stock | 168.72 | 168.72 | 168.43 | 168.51 | 8633.0 |
| 2021-12-20 07:15:00 | AAPL | Stock | 168.52 | 168.57 | 168.25 | 168.25 | 11980.0 |
| 2021-12-20 07:20:00 | AAPL | Stock | 168.27 | 168.33 | 168.16 | 168.16 | 13891.0 |
| 2021-12-20 07:25:00 | AAPL | Stock | 168.18 | 168.21 | 167.95 | 167.95 | 29782.0 |
| 2021-12-20 07:30:00 | AAPL | Stock | 167.94 | 168.09 | 167.91 | 168.06 | 22278.0 |
| 2021-12-20 07:35:00 | AAPL | Stock | 168.09 | 168.17 | 168.0 | 168.11 | 10268.0 |
| 2021-12-20 07:40:00 | AAPL | Stock | 168.14 | 168.25 | 168.14 | 168.18 | 2429.0 |
| 2021-12-20 07:45:00 | AAPL | Stock | 168.2 | 168.23 | 167.99 | 168.15 | 29948.0 |
| 2021-12-20 07:50:00 | AAPL | Stock | 168.15 | 168.15 | 167.93 | 167.95 | 27982.0 |
| 2021-12-20 07:55:00 | AAPL | Stock | 167.99 | 168.04 | 167.81 | 167.81 | 30432.0 |
| 2021-12-20 08:00:00 | AAPL | Stock | 168.4999 | 168.8292 | 167.73 | 167.78 | 333809.0 |
| 2021-12-20 08:05:00 | AAPL | Stock | 167.78 | 168.13 | 167.75 | 168.04 | 68698.0 |
| 2021-12-20 08:10:00 | AAPL | Stock | 168.01 | 168.07 | 167.77 | 167.85 | 36720.0 |
| 2021-12-20 08:15:00 | AAPL | Stock | 167.82 | 167.87 | 167.7 | 167.8 | 26669.0 |
> showing 50 of 478,824 rows — these rows as CSV