PREVIEW / stock_5min / 2021-11-23
file: by_date/stock_5min/2021/2021-11-23.parquet size: 7.7 MB rows: 473,225 symbols: 2,704
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-11-23 04:00:00 | AAPL | Stock | 159.99 | 160.06 | 159.51 | 159.6 | 10516.0 |
| 2021-11-23 04:05:00 | AAPL | Stock | 159.65 | 159.93 | 159.56 | 159.76 | 7353.0 |
| 2021-11-23 04:10:00 | AAPL | Stock | 159.69 | 159.74 | 159.65 | 159.71 | 3735.0 |
| 2021-11-23 04:15:00 | AAPL | Stock | 159.7 | 160.2 | 159.7 | 160.11 | 7098.0 |
| 2021-11-23 04:20:00 | AAPL | Stock | 160.02 | 160.2 | 159.99 | 160.17 | 4171.0 |
| 2021-11-23 04:25:00 | AAPL | Stock | 160.18 | 160.18 | 159.88 | 159.9 | 6581.0 |
| 2021-11-23 04:30:00 | AAPL | Stock | 159.92 | 159.95 | 159.9 | 159.9 | 4489.0 |
| 2021-11-23 04:35:00 | AAPL | Stock | 159.9 | 160.0 | 159.9 | 160.0 | 1033.0 |
| 2021-11-23 04:40:00 | AAPL | Stock | 160.2 | 160.33 | 160.19 | 160.32 | 7353.0 |
| 2021-11-23 04:45:00 | AAPL | Stock | 160.27 | 160.6 | 160.27 | 160.53 | 9883.0 |
| 2021-11-23 04:50:00 | AAPL | Stock | 160.58 | 160.68 | 160.54 | 160.67 | 5836.0 |
| 2021-11-23 04:55:00 | AAPL | Stock | 160.61 | 160.67 | 160.56 | 160.66 | 5779.0 |
| 2021-11-23 05:00:00 | AAPL | Stock | 160.79 | 160.79 | 160.75 | 160.78 | 1558.0 |
| 2021-11-23 05:05:00 | AAPL | Stock | 160.64 | 160.7 | 160.64 | 160.7 | 649.0 |
| 2021-11-23 05:10:00 | AAPL | Stock | 160.7 | 160.73 | 160.7 | 160.73 | 1019.0 |
| 2021-11-23 05:15:00 | AAPL | Stock | 160.71 | 160.75 | 160.67 | 160.67 | 2896.0 |
| 2021-11-23 05:20:00 | AAPL | Stock | 160.67 | 160.68 | 160.67 | 160.68 | 531.0 |
| 2021-11-23 05:25:00 | AAPL | Stock | 160.76 | 160.78 | 160.67 | 160.78 | 2243.0 |
| 2021-11-23 05:30:00 | AAPL | Stock | 160.77 | 160.78 | 160.6 | 160.6 | 4034.0 |
| 2021-11-23 05:35:00 | AAPL | Stock | 160.57 | 160.65 | 160.55 | 160.65 | 902.0 |
| 2021-11-23 05:40:00 | AAPL | Stock | 160.45 | 160.56 | 160.45 | 160.52 | 1392.0 |
| 2021-11-23 05:45:00 | AAPL | Stock | 160.65 | 160.65 | 160.65 | 160.65 | 286.0 |
| 2021-11-23 05:50:00 | AAPL | Stock | 160.58 | 160.58 | 160.57 | 160.57 | 494.0 |
| 2021-11-23 05:55:00 | AAPL | Stock | 160.63 | 160.64 | 160.6 | 160.6 | 892.0 |
| 2021-11-23 06:00:00 | AAPL | Stock | 160.52 | 160.52 | 160.45 | 160.45 | 425.0 |
| 2021-11-23 06:05:00 | AAPL | Stock | 160.41 | 160.55 | 160.4 | 160.4 | 6941.0 |
| 2021-11-23 06:10:00 | AAPL | Stock | 160.4 | 160.41 | 160.2 | 160.2 | 9355.0 |
| 2021-11-23 06:15:00 | AAPL | Stock | 160.38 | 160.45 | 160.38 | 160.45 | 1159.0 |
| 2021-11-23 06:20:00 | AAPL | Stock | 160.5 | 160.55 | 160.48 | 160.48 | 527.0 |
| 2021-11-23 06:25:00 | AAPL | Stock | 160.43 | 160.48 | 160.43 | 160.48 | 968.0 |
| 2021-11-23 06:30:00 | AAPL | Stock | 160.52 | 160.52 | 160.5 | 160.5 | 1174.0 |
| 2021-11-23 06:35:00 | AAPL | Stock | 160.44 | 160.45 | 160.44 | 160.45 | 539.0 |
| 2021-11-23 06:40:00 | AAPL | Stock | 160.52 | 160.7 | 160.52 | 160.6 | 2592.0 |
| 2021-11-23 06:45:00 | AAPL | Stock | 160.68 | 160.8 | 160.67 | 160.73 | 3269.0 |
| 2021-11-23 06:50:00 | AAPL | Stock | 160.8 | 160.94 | 160.79 | 160.94 | 3083.0 |
| 2021-11-23 06:55:00 | AAPL | Stock | 160.99 | 161.12 | 160.85 | 160.85 | 7854.0 |
| 2021-11-23 07:00:00 | AAPL | Stock | 160.86 | 161.09 | 160.85 | 160.9 | 11357.0 |
| 2021-11-23 07:05:00 | AAPL | Stock | 160.87 | 161.36 | 160.87 | 161.3 | 17181.0 |
| 2021-11-23 07:10:00 | AAPL | Stock | 161.3 | 161.3 | 161.01 | 161.04 | 15744.0 |
| 2021-11-23 07:15:00 | AAPL | Stock | 161.08 | 161.09 | 160.96 | 160.96 | 27751.0 |
| 2021-11-23 07:20:00 | AAPL | Stock | 160.98 | 161.2 | 160.98 | 161.09 | 5658.0 |
| 2021-11-23 07:25:00 | AAPL | Stock | 161.11 | 161.18 | 160.99 | 161.01 | 38686.0 |
| 2021-11-23 07:30:00 | AAPL | Stock | 161.0 | 161.0 | 160.66 | 160.82 | 28086.0 |
| 2021-11-23 07:35:00 | AAPL | Stock | 160.86 | 161.04 | 160.85 | 160.9 | 7736.0 |
| 2021-11-23 07:40:00 | AAPL | Stock | 160.94 | 161.05 | 160.94 | 161.02 | 6744.0 |
| 2021-11-23 07:45:00 | AAPL | Stock | 161.01 | 161.03 | 160.91 | 160.96 | 8569.0 |
| 2021-11-23 07:50:00 | AAPL | Stock | 160.95 | 160.97 | 160.85 | 160.96 | 4449.0 |
| 2021-11-23 07:55:00 | AAPL | Stock | 160.93 | 160.95 | 160.7 | 160.7 | 5188.0 |
| 2021-11-23 08:00:00 | AAPL | Stock | 161.273 | 161.38 | 160.65 | 160.88 | 71622.0 |
| 2021-11-23 08:05:00 | AAPL | Stock | 160.91 | 161.14 | 160.89 | 160.94 | 58540.0 |
> showing 50 of 473,225 rows — these rows as CSV