PREVIEW / stock_5min / 2021-12-10
file: by_date/stock_5min/2021/2021-12-10.parquet size: 7.4 MB rows: 454,175 symbols: 2,668
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-12-10 04:00:00 | AAPL | Stock | 174.73 | 174.93 | 174.56 | 174.92 | 2248.0 |
| 2021-12-10 04:05:00 | AAPL | Stock | 174.88 | 175.15 | 174.71 | 174.95 | 11951.0 |
| 2021-12-10 04:10:00 | AAPL | Stock | 174.89 | 174.89 | 174.67 | 174.67 | 1734.0 |
| 2021-12-10 04:15:00 | AAPL | Stock | 174.7 | 175.0 | 174.7 | 175.0 | 3142.0 |
| 2021-12-10 04:20:00 | AAPL | Stock | 175.07 | 175.07 | 175.0 | 175.0 | 885.0 |
| 2021-12-10 04:25:00 | AAPL | Stock | 174.76 | 174.83 | 174.76 | 174.83 | 556.0 |
| 2021-12-10 04:30:00 | AAPL | Stock | 174.83 | 174.86 | 174.76 | 174.86 | 3764.0 |
| 2021-12-10 04:35:00 | AAPL | Stock | 174.92 | 175.01 | 174.92 | 174.99 | 2998.0 |
| 2021-12-10 04:40:00 | AAPL | Stock | 175.06 | 175.09 | 174.93 | 174.93 | 3835.0 |
| 2021-12-10 04:45:00 | AAPL | Stock | 174.97 | 174.97 | 174.9 | 174.94 | 774.0 |
| 2021-12-10 04:50:00 | AAPL | Stock | 174.95 | 174.95 | 174.94 | 174.94 | 1775.0 |
| 2021-12-10 04:55:00 | AAPL | Stock | 174.93 | 175.0 | 174.93 | 175.0 | 887.0 |
| 2021-12-10 05:00:00 | AAPL | Stock | 174.96 | 174.97 | 174.95 | 174.95 | 1333.0 |
| 2021-12-10 05:10:00 | AAPL | Stock | 174.83 | 174.83 | 174.72 | 174.72 | 237.0 |
| 2021-12-10 05:15:00 | AAPL | Stock | 174.61 | 174.62 | 174.61 | 174.62 | 691.0 |
| 2021-12-10 05:20:00 | AAPL | Stock | 174.48 | 174.6 | 174.48 | 174.6 | 857.0 |
| 2021-12-10 05:25:00 | AAPL | Stock | 174.77 | 174.77 | 174.64 | 174.64 | 307.0 |
| 2021-12-10 05:30:00 | AAPL | Stock | 174.68 | 174.74 | 174.68 | 174.74 | 400.0 |
| 2021-12-10 05:40:00 | AAPL | Stock | 174.66 | 174.66 | 174.66 | 174.66 | 892.0 |
| 2021-12-10 05:45:00 | AAPL | Stock | 174.69 | 174.69 | 174.63 | 174.64 | 2267.0 |
| 2021-12-10 05:50:00 | AAPL | Stock | 174.61 | 174.65 | 174.61 | 174.65 | 1012.0 |
| 2021-12-10 05:55:00 | AAPL | Stock | 174.63 | 174.68 | 174.63 | 174.68 | 413.0 |
| 2021-12-10 06:00:00 | AAPL | Stock | 174.66 | 174.75 | 174.66 | 174.75 | 1435.0 |
| 2021-12-10 06:05:00 | AAPL | Stock | 174.74 | 174.8 | 174.74 | 174.8 | 902.0 |
| 2021-12-10 06:10:00 | AAPL | Stock | 174.8 | 174.81 | 174.75 | 174.75 | 900.0 |
| 2021-12-10 06:15:00 | AAPL | Stock | 174.76 | 174.76 | 174.76 | 174.76 | 393.0 |
| 2021-12-10 06:20:00 | AAPL | Stock | 174.76 | 174.82 | 174.76 | 174.82 | 3718.0 |
| 2021-12-10 06:25:00 | AAPL | Stock | 174.88 | 174.99 | 174.86 | 174.99 | 6288.0 |
| 2021-12-10 06:30:00 | AAPL | Stock | 174.92 | 175.08 | 174.8 | 174.8 | 18735.0 |
| 2021-12-10 06:35:00 | AAPL | Stock | 174.85 | 174.94 | 174.85 | 174.9 | 10814.0 |
| 2021-12-10 06:40:00 | AAPL | Stock | 174.88 | 175.1 | 174.88 | 175.1 | 3477.0 |
| 2021-12-10 06:45:00 | AAPL | Stock | 175.11 | 175.11 | 175.1 | 175.1 | 1011.0 |
| 2021-12-10 06:50:00 | AAPL | Stock | 175.14 | 175.19 | 175.14 | 175.19 | 1802.0 |
| 2021-12-10 06:55:00 | AAPL | Stock | 175.15 | 175.15 | 175.04 | 175.05 | 1338.0 |
| 2021-12-10 07:00:00 | AAPL | Stock | 175.01 | 175.15 | 174.9 | 174.99 | 21271.0 |
| 2021-12-10 07:05:00 | AAPL | Stock | 175.0 | 175.0 | 174.88 | 174.93 | 6257.0 |
| 2021-12-10 07:10:00 | AAPL | Stock | 174.92 | 174.95 | 174.85 | 174.85 | 5117.0 |
| 2021-12-10 07:15:00 | AAPL | Stock | 174.89 | 174.9 | 174.73 | 174.8 | 10866.0 |
| 2021-12-10 07:20:00 | AAPL | Stock | 174.77 | 174.94 | 174.77 | 174.94 | 13165.0 |
| 2021-12-10 07:25:00 | AAPL | Stock | 174.93 | 174.96 | 174.86 | 174.95 | 8411.0 |
| 2021-12-10 07:30:00 | AAPL | Stock | 174.95 | 175.06 | 174.83 | 174.83 | 12224.0 |
| 2021-12-10 07:35:00 | AAPL | Stock | 174.85 | 174.95 | 174.8 | 174.95 | 10588.0 |
| 2021-12-10 07:40:00 | AAPL | Stock | 174.97 | 174.97 | 174.8 | 174.82 | 6759.0 |
| 2021-12-10 07:45:00 | AAPL | Stock | 174.81 | 174.81 | 174.63 | 174.74 | 8774.0 |
| 2021-12-10 07:50:00 | AAPL | Stock | 174.74 | 174.78 | 174.7 | 174.78 | 2181.0 |
| 2021-12-10 07:55:00 | AAPL | Stock | 174.8 | 174.83 | 174.74 | 174.74 | 5875.0 |
| 2021-12-10 08:00:00 | AAPL | Stock | 174.85 | 175.15 | 174.124 | 174.63 | 187672.0 |
| 2021-12-10 08:05:00 | AAPL | Stock | 174.6201 | 174.73 | 174.51 | 174.57 | 23697.0 |
| 2021-12-10 08:10:00 | AAPL | Stock | 174.55 | 174.6 | 174.55 | 174.55 | 12833.0 |
| 2021-12-10 08:15:00 | AAPL | Stock | 174.57 | 174.82 | 174.57 | 174.81 | 42077.0 |
> showing 50 of 454,175 rows — these rows as CSV