PREVIEW / stock_5min / 2021-10-01
file: by_date/stock_5min/2021/2021-10-01.parquet size: 7.3 MB rows: 449,963 symbols: 2,745
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-10-01 04:00:00 | AAPL | Stock | 140.72 | 141.3 | 140.65 | 140.72 | 8189.0 |
| 2021-10-01 04:05:00 | AAPL | Stock | 140.7 | 140.75 | 140.55 | 140.62 | 6918.0 |
| 2021-10-01 04:10:00 | AAPL | Stock | 140.61 | 140.61 | 140.53 | 140.6 | 2689.0 |
| 2021-10-01 04:15:00 | AAPL | Stock | 140.67 | 140.67 | 140.67 | 140.67 | 100.0 |
| 2021-10-01 04:25:00 | AAPL | Stock | 140.65 | 140.82 | 140.65 | 140.82 | 3269.0 |
| 2021-10-01 04:30:00 | AAPL | Stock | 140.82 | 140.82 | 140.7 | 140.7 | 2958.0 |
| 2021-10-01 04:35:00 | AAPL | Stock | 140.7 | 140.7 | 140.7 | 140.7 | 100.0 |
| 2021-10-01 04:40:00 | AAPL | Stock | 140.65 | 140.69 | 140.65 | 140.69 | 682.0 |
| 2021-10-01 04:45:00 | AAPL | Stock | 140.73 | 140.77 | 140.63 | 140.71 | 3229.0 |
| 2021-10-01 04:50:00 | AAPL | Stock | 140.71 | 140.71 | 140.67 | 140.67 | 325.0 |
| 2021-10-01 04:55:00 | AAPL | Stock | 140.57 | 140.61 | 140.55 | 140.59 | 1349.0 |
| 2021-10-01 05:00:00 | AAPL | Stock | 140.65 | 140.69 | 140.65 | 140.65 | 894.0 |
| 2021-10-01 05:05:00 | AAPL | Stock | 140.64 | 140.71 | 140.64 | 140.71 | 739.0 |
| 2021-10-01 05:10:00 | AAPL | Stock | 140.71 | 140.8 | 140.68 | 140.8 | 1667.0 |
| 2021-10-01 05:15:00 | AAPL | Stock | 140.68 | 140.68 | 140.68 | 140.68 | 775.0 |
| 2021-10-01 05:25:00 | AAPL | Stock | 140.73 | 140.8 | 140.73 | 140.79 | 892.0 |
| 2021-10-01 05:30:00 | AAPL | Stock | 140.82 | 140.85 | 140.82 | 140.83 | 1840.0 |
| 2021-10-01 05:35:00 | AAPL | Stock | 140.71 | 140.71 | 140.71 | 140.71 | 600.0 |
| 2021-10-01 05:45:00 | AAPL | Stock | 140.69 | 140.75 | 140.69 | 140.75 | 836.0 |
| 2021-10-01 05:50:00 | AAPL | Stock | 140.8 | 140.85 | 140.8 | 140.85 | 2817.0 |
| 2021-10-01 05:55:00 | AAPL | Stock | 140.81 | 140.81 | 140.75 | 140.75 | 35826.0 |
| 2021-10-01 06:00:00 | AAPL | Stock | 140.75 | 140.82 | 140.75 | 140.82 | 5319.0 |
| 2021-10-01 06:05:00 | AAPL | Stock | 140.83 | 140.83 | 140.82 | 140.82 | 1329.0 |
| 2021-10-01 06:10:00 | AAPL | Stock | 140.88 | 140.89 | 140.88 | 140.89 | 911.0 |
| 2021-10-01 06:15:00 | AAPL | Stock | 140.95 | 141.12 | 140.95 | 141.12 | 8972.0 |
| 2021-10-01 06:20:00 | AAPL | Stock | 141.15 | 141.15 | 140.82 | 140.82 | 4067.0 |
| 2021-10-01 06:30:00 | AAPL | Stock | 141.0 | 141.18 | 141.0 | 141.1 | 4923.0 |
| 2021-10-01 06:35:00 | AAPL | Stock | 141.08 | 141.08 | 141.0 | 141.02 | 2164.0 |
| 2021-10-01 06:40:00 | AAPL | Stock | 140.95 | 141.0 | 140.92 | 141.0 | 3657.0 |
| 2021-10-01 06:45:00 | AAPL | Stock | 140.99 | 140.99 | 140.93 | 140.95 | 2492.0 |
| 2021-10-01 06:50:00 | AAPL | Stock | 140.95 | 141.05 | 140.95 | 141.03 | 4938.0 |
| 2021-10-01 06:55:00 | AAPL | Stock | 141.08 | 141.34 | 141.08 | 141.34 | 9548.0 |
| 2021-10-01 07:00:00 | AAPL | Stock | 141.2 | 141.45 | 141.15 | 141.45 | 54418.0 |
| 2021-10-01 07:05:00 | AAPL | Stock | 141.44 | 141.51 | 141.41 | 141.41 | 15329.0 |
| 2021-10-01 07:10:00 | AAPL | Stock | 141.45 | 141.6 | 141.43 | 141.6 | 17875.0 |
| 2021-10-01 07:15:00 | AAPL | Stock | 141.61 | 141.77 | 141.61 | 141.73 | 17727.0 |
| 2021-10-01 07:20:00 | AAPL | Stock | 141.72 | 141.89 | 141.72 | 141.87 | 19242.0 |
| 2021-10-01 07:25:00 | AAPL | Stock | 141.89 | 142.15 | 141.87 | 142.1 | 21159.0 |
| 2021-10-01 07:30:00 | AAPL | Stock | 142.01 | 142.15 | 142.0 | 142.13 | 5071.0 |
| 2021-10-01 07:35:00 | AAPL | Stock | 142.13 | 142.3 | 142.0 | 142.0 | 91451.0 |
| 2021-10-01 07:40:00 | AAPL | Stock | 141.99 | 142.04 | 141.81 | 141.94 | 79794.0 |
| 2021-10-01 07:45:00 | AAPL | Stock | 141.94 | 142.12 | 141.93 | 142.11 | 47991.0 |
| 2021-10-01 07:50:00 | AAPL | Stock | 142.11 | 142.11 | 141.85 | 141.85 | 54846.0 |
| 2021-10-01 07:55:00 | AAPL | Stock | 141.9 | 142.01 | 141.86 | 142.0 | 8576.0 |
| 2021-10-01 08:00:00 | AAPL | Stock | 142.0 | 142.28 | 141.21 | 142.0 | 357756.0 |
| 2021-10-01 08:05:00 | AAPL | Stock | 141.95 | 141.99 | 141.9 | 141.9499 | 21953.0 |
| 2021-10-01 08:10:00 | AAPL | Stock | 141.93 | 141.95 | 141.82 | 141.92 | 40618.0 |
| 2021-10-01 08:15:00 | AAPL | Stock | 141.92 | 142.09 | 141.9 | 142.09 | 87365.0 |
| 2021-10-01 08:20:00 | AAPL | Stock | 142.15 | 142.24 | 142.0 | 142.0 | 44582.0 |
| 2021-10-01 08:25:00 | AAPL | Stock | 142.0399 | 142.13 | 142.01 | 142.09 | 18511.0 |
> showing 50 of 449,963 rows — these rows as CSV