PREVIEW / stock_1min / 2021-01-19
file: by_date/stock_1min/2021/2021-01-19.parquet size: 26.3 MB rows: 1,535,124 symbols: 2,306
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-01-19 04:00:00 | AAPL | Stock | 128.55 | 129.0 | 128.55 | 129.0 | 8939.0 |
| 2021-01-19 04:01:00 | AAPL | Stock | 128.72 | 128.96 | 128.57 | 128.76 | 2635.0 |
| 2021-01-19 04:02:00 | AAPL | Stock | 128.69 | 128.69 | 128.64 | 128.64 | 582.0 |
| 2021-01-19 04:03:00 | AAPL | Stock | 128.65 | 128.99 | 128.65 | 128.76 | 1664.0 |
| 2021-01-19 04:04:00 | AAPL | Stock | 128.76 | 128.97 | 128.76 | 128.97 | 2149.0 |
| 2021-01-19 04:05:00 | AAPL | Stock | 128.9 | 128.9 | 128.82 | 128.88 | 1111.0 |
| 2021-01-19 04:06:00 | AAPL | Stock | 128.88 | 128.88 | 128.88 | 128.88 | 816.0 |
| 2021-01-19 04:07:00 | AAPL | Stock | 128.79 | 128.79 | 128.69 | 128.69 | 1613.0 |
| 2021-01-19 04:08:00 | AAPL | Stock | 128.7 | 128.71 | 128.69 | 128.69 | 1929.0 |
| 2021-01-19 04:09:00 | AAPL | Stock | 128.78 | 128.79 | 128.7 | 128.71 | 793.0 |
| 2021-01-19 04:10:00 | AAPL | Stock | 128.71 | 128.79 | 128.69 | 128.74 | 6409.0 |
| 2021-01-19 04:11:00 | AAPL | Stock | 128.78 | 128.99 | 128.73 | 128.73 | 1569.0 |
| 2021-01-19 04:12:00 | AAPL | Stock | 128.88 | 128.95 | 128.78 | 128.78 | 2093.0 |
| 2021-01-19 04:13:00 | AAPL | Stock | 128.78 | 128.78 | 128.73 | 128.78 | 1372.0 |
| 2021-01-19 04:14:00 | AAPL | Stock | 128.72 | 128.75 | 128.72 | 128.75 | 400.0 |
| 2021-01-19 04:15:00 | AAPL | Stock | 128.71 | 128.73 | 128.7 | 128.7 | 1563.0 |
| 2021-01-19 04:16:00 | AAPL | Stock | 128.7 | 128.7 | 128.7 | 128.7 | 100.0 |
| 2021-01-19 04:18:00 | AAPL | Stock | 128.64 | 128.66 | 128.64 | 128.66 | 580.0 |
| 2021-01-19 04:19:00 | AAPL | Stock | 128.61 | 128.61 | 128.6 | 128.6 | 2064.0 |
| 2021-01-19 04:20:00 | AAPL | Stock | 128.6 | 128.7 | 128.6 | 128.7 | 1837.0 |
| 2021-01-19 04:21:00 | AAPL | Stock | 128.73 | 128.73 | 128.73 | 128.73 | 320.0 |
| 2021-01-19 04:22:00 | AAPL | Stock | 128.71 | 128.71 | 128.6 | 128.6 | 2442.0 |
| 2021-01-19 04:23:00 | AAPL | Stock | 128.63 | 128.7 | 128.63 | 128.7 | 2532.0 |
| 2021-01-19 04:25:00 | AAPL | Stock | 128.7 | 128.73 | 128.63 | 128.63 | 3458.0 |
| 2021-01-19 04:29:00 | AAPL | Stock | 128.67 | 128.73 | 128.67 | 128.73 | 862.0 |
| 2021-01-19 04:30:00 | AAPL | Stock | 128.63 | 128.63 | 128.63 | 128.63 | 100.0 |
| 2021-01-19 04:31:00 | AAPL | Stock | 128.63 | 128.63 | 128.51 | 128.51 | 1000.0 |
| 2021-01-19 04:32:00 | AAPL | Stock | 128.56 | 128.59 | 128.55 | 128.59 | 632.0 |
| 2021-01-19 04:33:00 | AAPL | Stock | 128.6 | 128.61 | 128.6 | 128.61 | 570.0 |
| 2021-01-19 04:35:00 | AAPL | Stock | 128.65 | 128.65 | 128.65 | 128.65 | 300.0 |
| 2021-01-19 04:36:00 | AAPL | Stock | 128.65 | 128.65 | 128.65 | 128.65 | 100.0 |
| 2021-01-19 04:37:00 | AAPL | Stock | 128.65 | 128.65 | 128.65 | 128.65 | 100.0 |
| 2021-01-19 04:38:00 | AAPL | Stock | 128.65 | 128.65 | 128.65 | 128.65 | 100.0 |
| 2021-01-19 04:40:00 | AAPL | Stock | 128.65 | 128.65 | 128.65 | 128.65 | 800.0 |
| 2021-01-19 04:45:00 | AAPL | Stock | 128.74 | 128.74 | 128.74 | 128.74 | 100.0 |
| 2021-01-19 04:46:00 | AAPL | Stock | 128.78 | 128.78 | 128.78 | 128.78 | 2198.0 |
| 2021-01-19 04:47:00 | AAPL | Stock | 128.86 | 128.86 | 128.86 | 128.86 | 300.0 |
| 2021-01-19 04:48:00 | AAPL | Stock | 128.89 | 128.89 | 128.89 | 128.89 | 200.0 |
| 2021-01-19 04:49:00 | AAPL | Stock | 128.85 | 128.85 | 128.85 | 128.85 | 436.0 |
| 2021-01-19 04:53:00 | AAPL | Stock | 128.87 | 128.87 | 128.86 | 128.86 | 408.0 |
| 2021-01-19 04:57:00 | AAPL | Stock | 128.89 | 128.9 | 128.89 | 128.9 | 2373.0 |
| 2021-01-19 04:59:00 | AAPL | Stock | 128.85 | 128.9 | 128.85 | 128.9 | 296.0 |
| 2021-01-19 05:02:00 | AAPL | Stock | 128.87 | 128.87 | 128.87 | 128.87 | 200.0 |
| 2021-01-19 05:03:00 | AAPL | Stock | 128.87 | 128.88 | 128.85 | 128.85 | 968.0 |
| 2021-01-19 05:05:00 | AAPL | Stock | 128.85 | 128.88 | 128.85 | 128.88 | 520.0 |
| 2021-01-19 05:07:00 | AAPL | Stock | 128.88 | 128.88 | 128.88 | 128.88 | 372.0 |
| 2021-01-19 05:08:00 | AAPL | Stock | 128.88 | 128.88 | 128.88 | 128.88 | 116.0 |
| 2021-01-19 05:09:00 | AAPL | Stock | 128.85 | 128.85 | 128.82 | 128.82 | 678.0 |
| 2021-01-19 05:10:00 | AAPL | Stock | 128.8 | 128.8 | 128.8 | 128.8 | 150.0 |
| 2021-01-19 05:14:00 | AAPL | Stock | 128.85 | 128.9 | 128.85 | 128.9 | 1549.0 |
> showing 50 of 1,535,124 rows — these rows as CSV