PREVIEW / stock_5min / 2021-09-10
file: by_date/stock_5min/2021/2021-09-10.parquet size: 7.4 MB rows: 450,021 symbols: 2,701
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-09-10 04:00:00 | AAPL | Stock | 154.94 | 155.03 | 154.8 | 154.98 | 4616.0 |
| 2021-09-10 04:05:00 | AAPL | Stock | 154.93 | 154.98 | 154.9 | 154.9 | 710.0 |
| 2021-09-10 04:10:00 | AAPL | Stock | 154.95 | 154.95 | 154.86 | 154.86 | 3762.0 |
| 2021-09-10 04:15:00 | AAPL | Stock | 154.86 | 154.86 | 154.86 | 154.86 | 945.0 |
| 2021-09-10 04:30:00 | AAPL | Stock | 154.95 | 154.97 | 154.95 | 154.97 | 550.0 |
| 2021-09-10 04:35:00 | AAPL | Stock | 154.98 | 154.98 | 154.98 | 154.98 | 477.0 |
| 2021-09-10 04:40:00 | AAPL | Stock | 154.99 | 154.99 | 154.99 | 154.99 | 210.0 |
| 2021-09-10 04:45:00 | AAPL | Stock | 154.9 | 154.9 | 154.9 | 154.9 | 704.0 |
| 2021-09-10 04:50:00 | AAPL | Stock | 154.91 | 154.91 | 154.91 | 154.91 | 499.0 |
| 2021-09-10 05:00:00 | AAPL | Stock | 154.91 | 154.91 | 154.9 | 154.9 | 697.0 |
| 2021-09-10 05:05:00 | AAPL | Stock | 154.88 | 154.88 | 154.88 | 154.88 | 100.0 |
| 2021-09-10 05:10:00 | AAPL | Stock | 154.89 | 154.89 | 154.85 | 154.89 | 1328.0 |
| 2021-09-10 05:15:00 | AAPL | Stock | 154.85 | 154.88 | 154.82 | 154.82 | 1937.0 |
| 2021-09-10 05:20:00 | AAPL | Stock | 154.8 | 154.8 | 154.78 | 154.78 | 615.0 |
| 2021-09-10 05:25:00 | AAPL | Stock | 154.78 | 154.78 | 154.77 | 154.78 | 807.0 |
| 2021-09-10 05:30:00 | AAPL | Stock | 154.78 | 154.78 | 154.78 | 154.78 | 100.0 |
| 2021-09-10 05:35:00 | AAPL | Stock | 154.78 | 154.8 | 154.78 | 154.8 | 800.0 |
| 2021-09-10 05:40:00 | AAPL | Stock | 154.9 | 154.9 | 154.9 | 154.9 | 1200.0 |
| 2021-09-10 05:45:00 | AAPL | Stock | 154.9 | 154.9 | 154.78 | 154.78 | 2078.0 |
| 2021-09-10 05:50:00 | AAPL | Stock | 154.85 | 154.85 | 154.85 | 154.85 | 100.0 |
| 2021-09-10 05:55:00 | AAPL | Stock | 154.83 | 154.83 | 154.83 | 154.83 | 108.0 |
| 2021-09-10 06:10:00 | AAPL | Stock | 154.93 | 154.93 | 154.89 | 154.89 | 472.0 |
| 2021-09-10 06:15:00 | AAPL | Stock | 154.88 | 154.88 | 154.86 | 154.86 | 1034.0 |
| 2021-09-10 06:20:00 | AAPL | Stock | 154.84 | 154.84 | 154.84 | 154.84 | 1019.0 |
| 2021-09-10 06:25:00 | AAPL | Stock | 154.92 | 154.92 | 154.92 | 154.92 | 179.0 |
| 2021-09-10 06:30:00 | AAPL | Stock | 154.8 | 154.83 | 154.75 | 154.75 | 4201.0 |
| 2021-09-10 06:45:00 | AAPL | Stock | 154.85 | 154.88 | 154.84 | 154.84 | 900.0 |
| 2021-09-10 06:55:00 | AAPL | Stock | 154.9 | 154.9 | 154.9 | 154.9 | 323.0 |
| 2021-09-10 07:00:00 | AAPL | Stock | 154.9 | 154.9 | 154.65 | 154.79 | 34720.0 |
| 2021-09-10 07:05:00 | AAPL | Stock | 154.75 | 154.8 | 154.7 | 154.8 | 6560.0 |
| 2021-09-10 07:10:00 | AAPL | Stock | 154.82 | 154.9 | 154.82 | 154.9 | 9833.0 |
| 2021-09-10 07:15:00 | AAPL | Stock | 154.91 | 154.95 | 154.9 | 154.95 | 5772.0 |
| 2021-09-10 07:20:00 | AAPL | Stock | 154.93 | 154.93 | 154.77 | 154.85 | 4189.0 |
| 2021-09-10 07:25:00 | AAPL | Stock | 154.81 | 154.87 | 154.8 | 154.86 | 3575.0 |
| 2021-09-10 07:30:00 | AAPL | Stock | 154.88 | 154.88 | 154.82 | 154.85 | 4995.0 |
| 2021-09-10 07:35:00 | AAPL | Stock | 154.86 | 154.92 | 154.85 | 154.9 | 19157.0 |
| 2021-09-10 07:40:00 | AAPL | Stock | 154.91 | 154.95 | 154.89 | 154.92 | 5910.0 |
| 2021-09-10 07:45:00 | AAPL | Stock | 154.92 | 154.98 | 154.92 | 154.98 | 7829.0 |
| 2021-09-10 07:50:00 | AAPL | Stock | 154.97 | 154.97 | 154.91 | 154.92 | 5699.0 |
| 2021-09-10 07:55:00 | AAPL | Stock | 154.92 | 154.97 | 154.92 | 154.97 | 4609.0 |
| 2021-09-10 08:00:00 | AAPL | Stock | 154.76 | 155.0 | 154.455 | 154.99 | 89051.0 |
| 2021-09-10 08:05:00 | AAPL | Stock | 155.0 | 155.04 | 154.99 | 155.04 | 17875.0 |
| 2021-09-10 08:10:00 | AAPL | Stock | 155.04 | 155.08 | 155.02 | 155.07 | 15601.0 |
| 2021-09-10 08:15:00 | AAPL | Stock | 155.07 | 155.08 | 154.95 | 154.98 | 7758.0 |
| 2021-09-10 08:20:00 | AAPL | Stock | 154.98 | 155.0 | 154.95 | 154.95 | 7098.0 |
| 2021-09-10 08:25:00 | AAPL | Stock | 154.95 | 154.96 | 154.9 | 154.95 | 10354.0 |
| 2021-09-10 08:30:00 | AAPL | Stock | 154.95 | 154.95 | 154.9 | 154.92 | 27217.0 |
| 2021-09-10 08:35:00 | AAPL | Stock | 154.92 | 154.93 | 154.9 | 154.9201 | 18872.0 |
| 2021-09-10 08:40:00 | AAPL | Stock | 154.93 | 155.0 | 154.93 | 154.95 | 11694.0 |
| 2021-09-10 08:45:00 | AAPL | Stock | 154.95 | 154.96 | 154.87 | 154.88 | 16450.0 |
> showing 50 of 450,021 rows — these rows as CSV