PREVIEW / stock_5min / 2021-11-16
file: by_date/stock_5min/2021/2021-11-16.parquet size: 7.7 MB rows: 475,156 symbols: 2,696
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-16 04:00:00 | AAPL | Stock | 149.92 | 149.92 | 149.92 | 149.92 | 153.0 |
| 2021-11-16 04:30:00 | AAPL | Stock | 149.8 | 149.8 | 149.75 | 149.75 | 5175.0 |
| 2021-11-16 04:35:00 | AAPL | Stock | 149.76 | 149.76 | 149.75 | 149.75 | 629.0 |
| 2021-11-16 04:40:00 | AAPL | Stock | 149.69 | 149.7 | 149.69 | 149.69 | 343.0 |
| 2021-11-16 04:45:00 | AAPL | Stock | 149.6 | 149.61 | 149.6 | 149.61 | 369.0 |
| 2021-11-16 04:50:00 | AAPL | Stock | 149.63 | 149.63 | 149.62 | 149.63 | 759.0 |
| 2021-11-16 04:55:00 | AAPL | Stock | 149.62 | 149.7 | 149.62 | 149.7 | 646.0 |
| 2021-11-16 05:00:00 | AAPL | Stock | 149.62 | 149.62 | 149.61 | 149.62 | 1749.0 |
| 2021-11-16 05:05:00 | AAPL | Stock | 149.6 | 149.6 | 149.6 | 149.6 | 220.0 |
| 2021-11-16 05:15:00 | AAPL | Stock | 149.57 | 149.57 | 149.57 | 149.57 | 137.0 |
| 2021-11-16 05:30:00 | AAPL | Stock | 149.57 | 149.57 | 149.57 | 149.57 | 399.0 |
| 2021-11-16 05:35:00 | AAPL | Stock | 149.58 | 149.58 | 149.58 | 149.58 | 143.0 |
| 2021-11-16 05:40:00 | AAPL | Stock | 149.6 | 149.6 | 149.6 | 149.6 | 1386.0 |
| 2021-11-16 05:45:00 | AAPL | Stock | 149.6 | 149.6 | 149.6 | 149.6 | 228.0 |
| 2021-11-16 05:50:00 | AAPL | Stock | 149.62 | 149.62 | 149.62 | 149.62 | 100.0 |
| 2021-11-16 05:55:00 | AAPL | Stock | 149.65 | 149.68 | 149.65 | 149.68 | 210.0 |
| 2021-11-16 06:00:00 | AAPL | Stock | 149.67 | 149.67 | 149.66 | 149.66 | 940.0 |
| 2021-11-16 06:25:00 | AAPL | Stock | 149.72 | 149.72 | 149.72 | 149.72 | 534.0 |
| 2021-11-16 06:30:00 | AAPL | Stock | 149.75 | 149.82 | 149.75 | 149.82 | 652.0 |
| 2021-11-16 06:35:00 | AAPL | Stock | 149.77 | 149.77 | 149.77 | 149.77 | 199.0 |
| 2021-11-16 06:50:00 | AAPL | Stock | 149.82 | 149.88 | 149.82 | 149.88 | 580.0 |
| 2021-11-16 06:55:00 | AAPL | Stock | 149.98 | 150.0 | 149.97 | 149.99 | 1553.0 |
| 2021-11-16 07:00:00 | AAPL | Stock | 149.98 | 150.12 | 149.98 | 150.09 | 2764.0 |
| 2021-11-16 07:05:00 | AAPL | Stock | 150.09 | 150.13 | 150.07 | 150.1 | 2408.0 |
| 2021-11-16 07:10:00 | AAPL | Stock | 150.1 | 150.15 | 150.09 | 150.12 | 3602.0 |
| 2021-11-16 07:15:00 | AAPL | Stock | 150.12 | 150.14 | 150.09 | 150.14 | 2200.0 |
| 2021-11-16 07:20:00 | AAPL | Stock | 150.14 | 150.14 | 150.05 | 150.09 | 9610.0 |
| 2021-11-16 07:25:00 | AAPL | Stock | 150.09 | 150.12 | 150.08 | 150.09 | 2059.0 |
| 2021-11-16 07:30:00 | AAPL | Stock | 150.08 | 150.12 | 150.07 | 150.12 | 3199.0 |
| 2021-11-16 07:35:00 | AAPL | Stock | 150.12 | 150.23 | 150.1 | 150.22 | 6327.0 |
| 2021-11-16 07:40:00 | AAPL | Stock | 150.24 | 150.24 | 150.14 | 150.15 | 5718.0 |
| 2021-11-16 07:45:00 | AAPL | Stock | 150.17 | 150.17 | 150.081 | 150.13 | 3788.0 |
| 2021-11-16 07:50:00 | AAPL | Stock | 150.14 | 150.14 | 150.02 | 150.09 | 3069.0 |
| 2021-11-16 07:55:00 | AAPL | Stock | 150.13 | 150.14 | 150.13 | 150.13 | 1493.0 |
| 2021-11-16 08:00:00 | AAPL | Stock | 150.08 | 150.22 | 149.625 | 150.22 | 74460.0 |
| 2021-11-16 08:05:00 | AAPL | Stock | 150.22 | 150.22 | 150.17 | 150.2 | 23168.0 |
| 2021-11-16 08:10:00 | AAPL | Stock | 150.2 | 150.21 | 150.15 | 150.19 | 14111.0 |
| 2021-11-16 08:15:00 | AAPL | Stock | 150.19 | 150.19 | 150.15 | 150.15 | 2533.0 |
| 2021-11-16 08:20:00 | AAPL | Stock | 150.15 | 150.16 | 150.13 | 150.14 | 6470.0 |
| 2021-11-16 08:25:00 | AAPL | Stock | 150.14 | 150.16 | 150.1 | 150.1 | 7698.0 |
| 2021-11-16 08:30:00 | AAPL | Stock | 150.1 | 150.12 | 149.91 | 149.96 | 27495.0 |
| 2021-11-16 08:35:00 | AAPL | Stock | 149.98 | 150.25 | 149.98 | 150.23 | 13699.0 |
| 2021-11-16 08:40:00 | AAPL | Stock | 150.21 | 150.24 | 150.05 | 150.05 | 8561.0 |
| 2021-11-16 08:45:00 | AAPL | Stock | 150.02 | 150.02 | 149.87 | 150.01 | 26094.0 |
| 2021-11-16 08:50:00 | AAPL | Stock | 150.03 | 150.06 | 150.0 | 150.04 | 5366.0 |
| 2021-11-16 08:55:00 | AAPL | Stock | 150.05 | 150.05 | 149.99 | 149.99 | 11544.0 |
| 2021-11-16 09:00:00 | AAPL | Stock | 149.99 | 149.99 | 149.82 | 149.93 | 21804.0 |
| 2021-11-16 09:05:00 | AAPL | Stock | 149.93 | 149.96 | 149.92 | 149.92 | 3914.0 |
| 2021-11-16 09:10:00 | AAPL | Stock | 149.92 | 149.9494 | 149.8 | 149.8 | 14481.0 |
| 2021-11-16 09:15:00 | AAPL | Stock | 149.8 | 149.85 | 149.74 | 149.82 | 11375.0 |
> showing 50 of 475,156 rows — these rows as CSV