PREVIEW / stock_5min / 2022-01-20
file: by_date/stock_5min/2022/2022-01-20.parquet size: 7.6 MB rows: 467,543 symbols: 2,621
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-20 04:00:00 | AAPL | Stock | 166.53 | 166.96 | 166.3 | 166.64 | 9021.0 |
| 2022-01-20 04:05:00 | AAPL | Stock | 166.66 | 166.66 | 166.38 | 166.4 | 8461.0 |
| 2022-01-20 04:10:00 | AAPL | Stock | 166.43 | 166.6 | 166.2 | 166.58 | 5492.0 |
| 2022-01-20 04:15:00 | AAPL | Stock | 166.6 | 166.66 | 166.41 | 166.41 | 2479.0 |
| 2022-01-20 04:20:00 | AAPL | Stock | 166.43 | 166.6 | 166.43 | 166.6 | 1705.0 |
| 2022-01-20 04:25:00 | AAPL | Stock | 166.7 | 166.95 | 166.7 | 166.87 | 2017.0 |
| 2022-01-20 04:30:00 | AAPL | Stock | 166.85 | 167.11 | 166.81 | 167.1 | 2437.0 |
| 2022-01-20 04:35:00 | AAPL | Stock | 167.04 | 167.11 | 167.04 | 167.11 | 682.0 |
| 2022-01-20 04:40:00 | AAPL | Stock | 167.1 | 167.15 | 167.1 | 167.15 | 557.0 |
| 2022-01-20 04:45:00 | AAPL | Stock | 167.12 | 167.14 | 166.99 | 166.99 | 3169.0 |
| 2022-01-20 04:50:00 | AAPL | Stock | 166.98 | 167.06 | 166.98 | 167.05 | 2303.0 |
| 2022-01-20 04:55:00 | AAPL | Stock | 167.02 | 167.05 | 167.02 | 167.05 | 341.0 |
| 2022-01-20 05:00:00 | AAPL | Stock | 167.01 | 167.01 | 167.0 | 167.0 | 472.0 |
| 2022-01-20 05:05:00 | AAPL | Stock | 166.93 | 166.95 | 166.81 | 166.81 | 1293.0 |
| 2022-01-20 05:10:00 | AAPL | Stock | 166.87 | 166.89 | 166.87 | 166.89 | 650.0 |
| 2022-01-20 05:20:00 | AAPL | Stock | 166.92 | 167.03 | 166.91 | 166.91 | 3241.0 |
| 2022-01-20 05:25:00 | AAPL | Stock | 167.08 | 167.12 | 167.06 | 167.12 | 661.0 |
| 2022-01-20 05:35:00 | AAPL | Stock | 166.98 | 166.98 | 166.9 | 166.9 | 585.0 |
| 2022-01-20 05:40:00 | AAPL | Stock | 166.89 | 166.93 | 166.8 | 166.93 | 4111.0 |
| 2022-01-20 05:45:00 | AAPL | Stock | 166.9 | 166.9 | 166.88 | 166.88 | 204.0 |
| 2022-01-20 05:50:00 | AAPL | Stock | 166.91 | 166.93 | 166.8 | 166.81 | 1052.0 |
| 2022-01-20 05:55:00 | AAPL | Stock | 166.95 | 167.0 | 166.88 | 166.88 | 2028.0 |
| 2022-01-20 06:00:00 | AAPL | Stock | 167.1 | 167.23 | 167.1 | 167.23 | 3970.0 |
| 2022-01-20 06:05:00 | AAPL | Stock | 167.25 | 167.26 | 167.16 | 167.24 | 2060.0 |
| 2022-01-20 06:10:00 | AAPL | Stock | 167.11 | 167.36 | 167.11 | 167.26 | 2911.0 |
| 2022-01-20 06:15:00 | AAPL | Stock | 167.29 | 167.41 | 167.29 | 167.39 | 1701.0 |
| 2022-01-20 06:20:00 | AAPL | Stock | 167.44 | 167.44 | 167.34 | 167.34 | 579.0 |
| 2022-01-20 06:25:00 | AAPL | Stock | 167.47 | 167.47 | 167.47 | 167.47 | 1023.0 |
| 2022-01-20 06:30:00 | AAPL | Stock | 167.46 | 167.46 | 167.44 | 167.44 | 366.0 |
| 2022-01-20 06:35:00 | AAPL | Stock | 167.46 | 167.46 | 167.41 | 167.46 | 2232.0 |
| 2022-01-20 06:40:00 | AAPL | Stock | 167.41 | 167.41 | 167.4 | 167.4 | 400.0 |
| 2022-01-20 06:45:00 | AAPL | Stock | 167.32 | 167.33 | 167.2 | 167.33 | 1310.0 |
| 2022-01-20 06:50:00 | AAPL | Stock | 167.34 | 167.34 | 167.3 | 167.3 | 961.0 |
| 2022-01-20 06:55:00 | AAPL | Stock | 167.3 | 167.3 | 167.22 | 167.22 | 240.0 |
| 2022-01-20 07:00:00 | AAPL | Stock | 167.16 | 167.3 | 167.06 | 167.2 | 32129.0 |
| 2022-01-20 07:05:00 | AAPL | Stock | 167.17 | 167.17 | 167.05 | 167.1 | 5699.0 |
| 2022-01-20 07:10:00 | AAPL | Stock | 167.15 | 167.25 | 167.12 | 167.12 | 5526.0 |
| 2022-01-20 07:15:00 | AAPL | Stock | 167.13 | 167.13 | 167.01 | 167.05 | 5352.0 |
| 2022-01-20 07:20:00 | AAPL | Stock | 167.06 | 167.16 | 166.88 | 166.88 | 11265.0 |
| 2022-01-20 07:25:00 | AAPL | Stock | 166.85 | 166.85 | 166.68 | 166.81 | 14807.0 |
| 2022-01-20 07:30:00 | AAPL | Stock | 166.77 | 166.8 | 166.55 | 166.55 | 11195.0 |
| 2022-01-20 07:35:00 | AAPL | Stock | 166.56 | 166.7 | 166.51 | 166.65 | 11254.0 |
| 2022-01-20 07:40:00 | AAPL | Stock | 166.63 | 166.63 | 166.41 | 166.45 | 13011.0 |
| 2022-01-20 07:45:00 | AAPL | Stock | 166.55 | 166.63 | 166.53 | 166.63 | 8280.0 |
| 2022-01-20 07:50:00 | AAPL | Stock | 166.63 | 166.76 | 166.57 | 166.76 | 9924.0 |
| 2022-01-20 07:55:00 | AAPL | Stock | 166.71 | 166.91 | 166.69 | 166.88 | 6631.0 |
| 2022-01-20 08:00:00 | AAPL | Stock | 167.2501 | 167.29 | 165.815 | 166.9399 | 232616.0 |
| 2022-01-20 08:05:00 | AAPL | Stock | 166.95 | 166.95 | 166.77 | 166.88 | 41135.0 |
| 2022-01-20 08:10:00 | AAPL | Stock | 166.87 | 167.1 | 166.81 | 167.1 | 47163.0 |
| 2022-01-20 08:15:00 | AAPL | Stock | 167.05 | 167.17 | 166.92 | 166.92 | 29725.0 |
> showing 50 of 467,543 rows — these rows as CSV