PREVIEW / stock_30min / 2005-09-16
file: by_date/stock_30min/2005/2005-09-16.parquet size: 889 KB rows: 48,004 symbols: 2,068
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-16 07:30:00 | AAPL | Stock | 1.7861 | 1.7932 | 1.7861 | 1.7932 | 45920.0 |
| 2005-09-16 08:00:00 | AAPL | Stock | 1.7932 | 1.7946 | 1.7911 | 1.7946 | 346948.0 |
| 2005-09-16 08:30:00 | AAPL | Stock | 1.7921 | 1.8043 | 1.7921 | 1.7996 | 1076684.0 |
| 2005-09-16 09:00:00 | AAPL | Stock | 1.8 | 1.8014 | 1.7936 | 1.7936 | 1349880.0 |
| 2005-09-16 09:30:00 | AAPL | Stock | 1.7939 | 1.8036 | 1.7864 | 1.7932 | 142758784.0 |
| 2005-09-16 10:00:00 | AAPL | Stock | 1.7932 | 1.7986 | 1.7896 | 1.7918 | 34523664.0 |
| 2005-09-16 10:30:00 | AAPL | Stock | 1.7914 | 1.7936 | 1.7854 | 1.79 | 27525148.0 |
| 2005-09-16 11:00:00 | AAPL | Stock | 1.79 | 1.7946 | 1.7839 | 1.7932 | 32852316.0 |
| 2005-09-16 11:30:00 | AAPL | Stock | 1.7932 | 1.7975 | 1.7896 | 1.7918 | 19035492.0 |
| 2005-09-16 12:00:00 | AAPL | Stock | 1.7918 | 1.7993 | 1.7911 | 1.7982 | 22918336.0 |
| 2005-09-16 12:30:00 | AAPL | Stock | 1.7982 | 1.8036 | 1.7975 | 1.8 | 28218176.0 |
| 2005-09-16 13:00:00 | AAPL | Stock | 1.8 | 1.8036 | 1.7982 | 1.7996 | 13570788.0 |
| 2005-09-16 13:30:00 | AAPL | Stock | 1.7996 | 1.8025 | 1.7971 | 1.8018 | 15225700.0 |
| 2005-09-16 14:00:00 | AAPL | Stock | 1.8018 | 1.8068 | 1.7989 | 1.8039 | 25229148.0 |
| 2005-09-16 14:30:00 | AAPL | Stock | 1.8043 | 1.8161 | 1.8029 | 1.8143 | 31009384.0 |
| 2005-09-16 15:00:00 | AAPL | Stock | 1.8146 | 1.8182 | 1.8121 | 1.8161 | 33249664.0 |
| 2005-09-16 15:30:00 | AAPL | Stock | 1.8161 | 1.8286 | 1.8121 | 1.8286 | 88114684.0 |
| 2005-09-16 16:00:00 | AAPL | Stock | 1.8279 | 1.8289 | 1.8196 | 1.8289 | 4368644.0 |
| 2005-09-16 16:30:00 | AAPL | Stock | 1.8246 | 1.8268 | 1.8243 | 1.8268 | 37800.0 |
| 2005-09-16 17:00:00 | AAPL | Stock | 1.8275 | 1.8289 | 1.825 | 1.8282 | 1644860.0 |
| 2005-09-16 17:30:00 | AAPL | Stock | 1.8289 | 1.8304 | 1.8057 | 1.8289 | 177940.0 |
| 2005-09-16 18:00:00 | AAPL | Stock | 1.8289 | 1.8289 | 1.8268 | 1.8268 | 499268.0 |
| 2005-09-16 08:00:00 | MSFT | Stock | 26.35 | 26.36 | 26.32 | 26.32 | 8550.0 |
| 2005-09-16 08:30:00 | MSFT | Stock | 26.31 | 26.37 | 26.31 | 26.31 | 13190.0 |
| 2005-09-16 09:00:00 | MSFT | Stock | 26.35 | 26.39 | 26.26 | 26.36 | 1039196.0 |
| 2005-09-16 09:30:00 | MSFT | Stock | 26.34 | 26.4 | 26.2 | 26.29 | 25974944.0 |
| 2005-09-16 10:00:00 | MSFT | Stock | 26.28 | 26.33 | 26.22 | 26.268 | 4153633.0 |
| 2005-09-16 10:30:00 | MSFT | Stock | 26.26 | 26.26 | 26.15 | 26.172 | 4523687.0 |
| 2005-09-16 11:00:00 | MSFT | Stock | 26.18 | 26.299 | 26.07 | 26.1 | 5978234.0 |
| 2005-09-16 11:30:00 | MSFT | Stock | 26.1 | 26.13 | 26.06 | 26.11 | 4694140.0 |
| 2005-09-16 12:00:00 | MSFT | Stock | 26.11 | 26.12 | 26.03 | 26.058 | 3285360.0 |
| 2005-09-16 12:30:00 | MSFT | Stock | 26.06 | 26.11 | 26.02 | 26.078 | 5138756.0 |
| 2005-09-16 13:00:00 | MSFT | Stock | 26.07 | 26.08 | 26.01 | 26.04 | 4022062.0 |
| 2005-09-16 13:30:00 | MSFT | Stock | 26.03 | 26.05 | 25.97 | 26.04 | 6074773.0 |
| 2005-09-16 14:00:00 | MSFT | Stock | 26.04 | 26.12 | 26.031 | 26.07 | 5794312.0 |
| 2005-09-16 14:30:00 | MSFT | Stock | 26.06 | 26.15 | 26.03 | 26.12 | 4445647.0 |
| 2005-09-16 15:00:00 | MSFT | Stock | 26.12 | 26.24 | 25.99 | 26.18 | 6392153.0 |
| 2005-09-16 15:30:00 | MSFT | Stock | 26.19 | 26.19 | 26.01 | 26.06 | 23353910.0 |
| 2005-09-16 16:00:00 | MSFT | Stock | 26.07 | 26.16 | 26.05 | 26.07 | 5219997.0 |
| 2005-09-16 16:30:00 | MSFT | Stock | 26.13 | 26.14 | 26.1 | 26.13 | 1567124.0 |
| 2005-09-16 17:00:00 | MSFT | Stock | 26.13 | 26.14 | 26.07 | 26.11 | 1248329.0 |
| 2005-09-16 17:30:00 | MSFT | Stock | 26.08 | 26.13 | 26.07 | 26.11 | 744485.0 |
| 2005-09-16 18:00:00 | MSFT | Stock | 26.14 | 26.14 | 26.06 | 26.07 | 3820399.0 |
| 2005-09-16 08:00:00 | NVDA | Stock | 0.2791 | 0.2791 | 0.2791 | 0.2791 | 36000.0 |
| 2005-09-16 08:30:00 | NVDA | Stock | 0.2789 | 0.2789 | 0.2789 | 0.2789 | 12000.0 |
| 2005-09-16 09:00:00 | NVDA | Stock | 0.2788 | 0.2803 | 0.2783 | 0.2802 | 1500000.0 |
| 2005-09-16 09:30:00 | NVDA | Stock | 0.2792 | 0.2807 | 0.2768 | 0.278 | 77199120.0 |
| 2005-09-16 10:00:00 | NVDA | Stock | 0.278 | 0.2784 | 0.277 | 0.278 | 41452920.0 |
| 2005-09-16 10:30:00 | NVDA | Stock | 0.2779 | 0.2783 | 0.2773 | 0.278 | 29462520.0 |
| 2005-09-16 11:00:00 | NVDA | Stock | 0.278 | 0.2781 | 0.2771 | 0.2772 | 34347240.0 |
> showing 50 of 48,004 rows — these rows as CSV