PREVIEW / stock_5min / 2021-04-13
file: by_date/stock_5min/2021/2021-04-13.parquet size: 7.5 MB rows: 464,818 symbols: 2,950
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-04-13 04:00:00 | AAPL | Stock | 131.03 | 131.1 | 131.03 | 131.1 | 625.0 |
| 2021-04-13 04:05:00 | AAPL | Stock | 131.22 | 131.22 | 131.11 | 131.11 | 2967.0 |
| 2021-04-13 04:10:00 | AAPL | Stock | 131.16 | 131.16 | 131.12 | 131.12 | 299.0 |
| 2021-04-13 04:15:00 | AAPL | Stock | 131.02 | 131.03 | 131.0 | 131.0 | 1642.0 |
| 2021-04-13 04:20:00 | AAPL | Stock | 130.92 | 130.95 | 130.92 | 130.94 | 1380.0 |
| 2021-04-13 04:25:00 | AAPL | Stock | 131.0 | 131.0 | 130.99 | 131.0 | 927.0 |
| 2021-04-13 04:30:00 | AAPL | Stock | 131.0 | 131.0 | 130.97 | 130.99 | 1332.0 |
| 2021-04-13 04:35:00 | AAPL | Stock | 130.95 | 130.99 | 130.93 | 130.99 | 1636.0 |
| 2021-04-13 04:40:00 | AAPL | Stock | 130.99 | 131.04 | 130.95 | 130.96 | 596.0 |
| 2021-04-13 04:45:00 | AAPL | Stock | 130.96 | 130.98 | 130.96 | 130.98 | 1078.0 |
| 2021-04-13 04:50:00 | AAPL | Stock | 130.94 | 130.94 | 130.9 | 130.9 | 1163.0 |
| 2021-04-13 04:55:00 | AAPL | Stock | 130.87 | 130.87 | 130.81 | 130.81 | 803.0 |
| 2021-04-13 05:00:00 | AAPL | Stock | 130.87 | 130.87 | 130.82 | 130.82 | 236.0 |
| 2021-04-13 05:05:00 | AAPL | Stock | 130.81 | 130.81 | 130.8 | 130.8 | 500.0 |
| 2021-04-13 05:10:00 | AAPL | Stock | 130.83 | 130.85 | 130.8 | 130.85 | 903.0 |
| 2021-04-13 05:15:00 | AAPL | Stock | 130.87 | 130.87 | 130.85 | 130.85 | 499.0 |
| 2021-04-13 05:20:00 | AAPL | Stock | 130.85 | 130.85 | 130.85 | 130.85 | 588.0 |
| 2021-04-13 05:25:00 | AAPL | Stock | 130.85 | 130.89 | 130.85 | 130.89 | 273.0 |
| 2021-04-13 05:30:00 | AAPL | Stock | 130.82 | 130.82 | 130.82 | 130.82 | 500.0 |
| 2021-04-13 05:35:00 | AAPL | Stock | 130.82 | 130.82 | 130.82 | 130.82 | 112.0 |
| 2021-04-13 05:40:00 | AAPL | Stock | 130.87 | 131.0 | 130.87 | 131.0 | 2925.0 |
| 2021-04-13 05:45:00 | AAPL | Stock | 130.99 | 130.99 | 130.82 | 130.82 | 5663.0 |
| 2021-04-13 05:50:00 | AAPL | Stock | 130.85 | 130.85 | 130.81 | 130.81 | 1200.0 |
| 2021-04-13 05:55:00 | AAPL | Stock | 130.93 | 131.09 | 130.93 | 131.09 | 3351.0 |
| 2021-04-13 06:00:00 | AAPL | Stock | 131.08 | 131.08 | 131.08 | 131.08 | 100.0 |
| 2021-04-13 06:10:00 | AAPL | Stock | 130.96 | 131.0 | 130.96 | 130.98 | 752.0 |
| 2021-04-13 06:15:00 | AAPL | Stock | 130.94 | 130.95 | 130.94 | 130.95 | 723.0 |
| 2021-04-13 06:20:00 | AAPL | Stock | 130.85 | 130.86 | 130.85 | 130.85 | 1159.0 |
| 2021-04-13 06:30:00 | AAPL | Stock | 130.82 | 130.82 | 130.82 | 130.82 | 297.0 |
| 2021-04-13 06:35:00 | AAPL | Stock | 130.84 | 130.84 | 130.72 | 130.72 | 1392.0 |
| 2021-04-13 06:45:00 | AAPL | Stock | 130.91 | 130.91 | 130.91 | 130.91 | 129.0 |
| 2021-04-13 06:50:00 | AAPL | Stock | 130.87 | 130.87 | 130.87 | 130.87 | 100.0 |
| 2021-04-13 06:55:00 | AAPL | Stock | 130.8 | 130.8 | 130.71 | 130.71 | 950.0 |
| 2021-04-13 07:00:00 | AAPL | Stock | 130.84 | 130.87 | 130.67 | 130.76 | 23421.0 |
| 2021-04-13 07:05:00 | AAPL | Stock | 130.75 | 130.93 | 130.75 | 130.8 | 9718.0 |
| 2021-04-13 07:10:00 | AAPL | Stock | 130.79 | 130.8 | 130.7 | 130.76 | 13062.0 |
| 2021-04-13 07:15:00 | AAPL | Stock | 130.75 | 130.94 | 130.75 | 130.86 | 16404.0 |
| 2021-04-13 07:20:00 | AAPL | Stock | 130.85 | 130.88 | 130.82 | 130.82 | 9951.0 |
| 2021-04-13 07:25:00 | AAPL | Stock | 130.81 | 130.81 | 130.7 | 130.74 | 10558.0 |
| 2021-04-13 07:30:00 | AAPL | Stock | 130.75 | 130.77 | 130.62 | 130.72 | 31547.0 |
| 2021-04-13 07:35:00 | AAPL | Stock | 130.73 | 130.91 | 130.73 | 130.89 | 9934.0 |
| 2021-04-13 07:40:00 | AAPL | Stock | 130.9 | 130.901 | 130.83 | 130.83 | 4740.0 |
| 2021-04-13 07:45:00 | AAPL | Stock | 130.83 | 130.85 | 130.74 | 130.85 | 8539.0 |
| 2021-04-13 07:50:00 | AAPL | Stock | 130.81 | 130.82 | 130.78 | 130.8 | 2513.0 |
| 2021-04-13 07:55:00 | AAPL | Stock | 130.8 | 130.82 | 130.77 | 130.78 | 1946.0 |
| 2021-04-13 08:00:00 | AAPL | Stock | 130.8 | 131.568 | 130.65 | 130.89 | 83937.0 |
| 2021-04-13 08:05:00 | AAPL | Stock | 130.9 | 131.0 | 130.85 | 130.96 | 22284.0 |
| 2021-04-13 08:10:00 | AAPL | Stock | 130.96 | 131.02 | 130.86 | 130.97 | 44386.0 |
| 2021-04-13 08:15:00 | AAPL | Stock | 131.0 | 131.15 | 130.99 | 131.01 | 62680.0 |
| 2021-04-13 08:20:00 | AAPL | Stock | 131.02 | 131.2 | 130.95 | 131.2 | 11600.0 |
> showing 50 of 464,818 rows — these rows as CSV