PREVIEW / stock_5min / 2021-05-25
file: by_date/stock_5min/2021/2021-05-25.parquet size: 7.1 MB rows: 452,791 symbols: 2,977
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-05-25 04:00:00 | AAPL | Stock | 127.99 | 128.0 | 127.9 | 127.9 | 3100.0 |
| 2021-05-25 04:05:00 | AAPL | Stock | 127.97 | 127.97 | 127.92 | 127.95 | 1266.0 |
| 2021-05-25 04:10:00 | AAPL | Stock | 127.91 | 127.95 | 127.89 | 127.89 | 1070.0 |
| 2021-05-25 04:15:00 | AAPL | Stock | 127.76 | 127.8 | 127.76 | 127.8 | 825.0 |
| 2021-05-25 04:20:00 | AAPL | Stock | 127.8 | 127.83 | 127.8 | 127.83 | 1943.0 |
| 2021-05-25 04:25:00 | AAPL | Stock | 127.85 | 127.96 | 127.85 | 127.96 | 6171.0 |
| 2021-05-25 04:30:00 | AAPL | Stock | 127.94 | 127.94 | 127.92 | 127.92 | 891.0 |
| 2021-05-25 04:35:00 | AAPL | Stock | 127.9 | 127.91 | 127.9 | 127.91 | 1268.0 |
| 2021-05-25 04:40:00 | AAPL | Stock | 127.94 | 127.94 | 127.94 | 127.94 | 1850.0 |
| 2021-05-25 04:50:00 | AAPL | Stock | 127.87 | 127.9 | 127.87 | 127.9 | 440.0 |
| 2021-05-25 04:55:00 | AAPL | Stock | 127.88 | 127.88 | 127.87 | 127.87 | 800.0 |
| 2021-05-25 05:00:00 | AAPL | Stock | 127.91 | 127.91 | 127.9 | 127.9 | 1000.0 |
| 2021-05-25 05:05:00 | AAPL | Stock | 127.88 | 127.88 | 127.84 | 127.84 | 1524.0 |
| 2021-05-25 05:10:00 | AAPL | Stock | 127.83 | 127.83 | 127.83 | 127.83 | 369.0 |
| 2021-05-25 05:20:00 | AAPL | Stock | 127.87 | 127.87 | 127.86 | 127.86 | 381.0 |
| 2021-05-25 05:25:00 | AAPL | Stock | 127.86 | 127.89 | 127.86 | 127.89 | 3280.0 |
| 2021-05-25 05:30:00 | AAPL | Stock | 127.89 | 127.89 | 127.84 | 127.84 | 3121.0 |
| 2021-05-25 05:40:00 | AAPL | Stock | 127.83 | 127.84 | 127.83 | 127.84 | 254.0 |
| 2021-05-25 05:45:00 | AAPL | Stock | 127.88 | 127.88 | 127.85 | 127.85 | 1238.0 |
| 2021-05-25 05:50:00 | AAPL | Stock | 127.85 | 127.85 | 127.85 | 127.85 | 798.0 |
| 2021-05-25 06:05:00 | AAPL | Stock | 127.88 | 127.9 | 127.88 | 127.9 | 2048.0 |
| 2021-05-25 06:10:00 | AAPL | Stock | 127.88 | 127.88 | 127.8 | 127.8 | 1556.0 |
| 2021-05-25 06:35:00 | AAPL | Stock | 127.63 | 127.63 | 127.63 | 127.63 | 100.0 |
| 2021-05-25 06:55:00 | AAPL | Stock | 127.69 | 127.69 | 127.69 | 127.69 | 109.0 |
| 2021-05-25 07:00:00 | AAPL | Stock | 127.65 | 127.75 | 127.6 | 127.7 | 13645.0 |
| 2021-05-25 07:05:00 | AAPL | Stock | 127.71 | 127.73 | 127.69 | 127.73 | 3094.0 |
| 2021-05-25 07:10:00 | AAPL | Stock | 127.72 | 127.76 | 127.72 | 127.75 | 4012.0 |
| 2021-05-25 07:15:00 | AAPL | Stock | 127.75 | 127.8 | 127.75 | 127.8 | 3616.0 |
| 2021-05-25 07:20:00 | AAPL | Stock | 127.81 | 127.89 | 127.81 | 127.87 | 7141.0 |
| 2021-05-25 07:25:00 | AAPL | Stock | 127.88 | 127.89 | 127.87 | 127.89 | 4829.0 |
| 2021-05-25 07:30:00 | AAPL | Stock | 127.91 | 127.94 | 127.86 | 127.86 | 8826.0 |
| 2021-05-25 07:35:00 | AAPL | Stock | 127.88 | 127.93 | 127.85 | 127.93 | 5694.0 |
| 2021-05-25 07:40:00 | AAPL | Stock | 127.94 | 127.95 | 127.85 | 127.92 | 5227.0 |
| 2021-05-25 07:45:00 | AAPL | Stock | 127.92 | 127.96 | 127.92 | 127.93 | 2232.0 |
| 2021-05-25 07:50:00 | AAPL | Stock | 127.92 | 127.94 | 127.9 | 127.9 | 5376.0 |
| 2021-05-25 07:55:00 | AAPL | Stock | 127.9 | 127.9 | 127.88 | 127.89 | 1756.0 |
| 2021-05-25 08:00:00 | AAPL | Stock | 127.6701 | 127.97 | 127.58 | 127.84 | 100751.0 |
| 2021-05-25 08:05:00 | AAPL | Stock | 127.84 | 127.88 | 127.82 | 127.86 | 13958.0 |
| 2021-05-25 08:10:00 | AAPL | Stock | 127.84 | 127.865 | 127.75 | 127.78 | 12980.0 |
| 2021-05-25 08:15:00 | AAPL | Stock | 127.79 | 127.79 | 127.6501 | 127.7 | 20349.0 |
| 2021-05-25 08:20:00 | AAPL | Stock | 127.7 | 127.78 | 127.67 | 127.71 | 6395.0 |
| 2021-05-25 08:25:00 | AAPL | Stock | 127.73 | 127.78 | 127.68 | 127.78 | 11383.0 |
| 2021-05-25 08:30:00 | AAPL | Stock | 127.76 | 127.8 | 127.73 | 127.77 | 8366.0 |
| 2021-05-25 08:35:00 | AAPL | Stock | 127.76 | 127.86 | 127.73 | 127.83 | 15095.0 |
| 2021-05-25 08:40:00 | AAPL | Stock | 127.85 | 127.87 | 127.1 | 127.81 | 160466.0 |
| 2021-05-25 08:45:00 | AAPL | Stock | 127.85 | 127.88 | 127.76 | 127.78 | 8599.0 |
| 2021-05-25 08:50:00 | AAPL | Stock | 127.76 | 127.78 | 127.6 | 127.69 | 25509.0 |
| 2021-05-25 08:55:00 | AAPL | Stock | 127.69 | 127.7 | 127.65 | 127.66 | 16232.0 |
| 2021-05-25 09:00:00 | AAPL | Stock | 127.64 | 127.77 | 127.63 | 127.77 | 42064.0 |
| 2021-05-25 09:05:00 | AAPL | Stock | 127.77 | 127.97 | 127.75 | 127.86 | 58971.0 |
> showing 50 of 452,791 rows — these rows as CSV