PREVIEW / stock_30min / 2007-07-05
file: by_date/stock_30min/2007/2007-07-05.parquet size: 1.1 MB rows: 62,912 symbols: 3,033
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-05 09:30:00 | AAPL | Stock | 4.6 | 4.7054 | 4.5961 | 4.6507 | 329688352.0 |
| 2007-07-05 10:00:00 | AAPL | Stock | 4.6504 | 4.6836 | 4.6357 | 4.67 | 168781368.0 |
| 2007-07-05 10:30:00 | AAPL | Stock | 4.67 | 4.6964 | 4.6682 | 4.6939 | 124432560.0 |
| 2007-07-05 11:00:00 | AAPL | Stock | 4.6946 | 4.6961 | 4.6625 | 4.675 | 96696404.0 |
| 2007-07-05 11:30:00 | AAPL | Stock | 4.6746 | 4.6861 | 4.6686 | 4.6732 | 53115300.0 |
| 2007-07-05 12:00:00 | AAPL | Stock | 4.6729 | 4.6786 | 4.6679 | 4.6718 | 49846244.0 |
| 2007-07-05 12:30:00 | AAPL | Stock | 4.6718 | 4.6743 | 4.6532 | 4.6654 | 61932332.0 |
| 2007-07-05 13:00:00 | AAPL | Stock | 4.6654 | 4.6764 | 4.6646 | 4.6721 | 28362768.0 |
| 2007-07-05 13:30:00 | AAPL | Stock | 4.6721 | 4.6868 | 4.6654 | 4.6725 | 46564056.0 |
| 2007-07-05 14:00:00 | AAPL | Stock | 4.6721 | 4.6939 | 4.6704 | 4.6882 | 51163728.0 |
| 2007-07-05 14:30:00 | AAPL | Stock | 4.6882 | 4.7253 | 4.6879 | 4.7207 | 128779952.0 |
| 2007-07-05 15:00:00 | AAPL | Stock | 4.7207 | 4.7286 | 4.7075 | 4.7243 | 93191140.0 |
| 2007-07-05 15:30:00 | AAPL | Stock | 4.7243 | 4.7489 | 4.7193 | 4.7407 | 144683868.0 |
| 2007-07-05 16:00:00 | AAPL | Stock | 4.7407 | 4.7411 | 4.7407 | 4.7411 | 7950768.0 |
| 2007-07-05 09:30:00 | MSFT | Stock | 30.05 | 30.22 | 29.95 | 30.0 | 7137229.0 |
| 2007-07-05 10:00:00 | MSFT | Stock | 30.01 | 30.06 | 29.95 | 30.01 | 3298209.0 |
| 2007-07-05 10:30:00 | MSFT | Stock | 30.02 | 30.04 | 29.97 | 29.98 | 2256377.0 |
| 2007-07-05 11:00:00 | MSFT | Stock | 29.982 | 30.002 | 29.87 | 29.962 | 3322234.0 |
| 2007-07-05 11:30:00 | MSFT | Stock | 29.97 | 29.99 | 29.93 | 29.94 | 1845170.0 |
| 2007-07-05 12:00:00 | MSFT | Stock | 29.94 | 29.95 | 29.85 | 29.89 | 1951745.0 |
| 2007-07-05 12:30:00 | MSFT | Stock | 29.9 | 29.959 | 29.83 | 29.911 | 2082958.0 |
| 2007-07-05 13:00:00 | MSFT | Stock | 29.92 | 30.0 | 29.9 | 29.96 | 1728731.0 |
| 2007-07-05 13:30:00 | MSFT | Stock | 29.962 | 29.98 | 29.95 | 29.961 | 1333413.0 |
| 2007-07-05 14:00:00 | MSFT | Stock | 29.96 | 30.0 | 29.95 | 29.97 | 4243003.0 |
| 2007-07-05 14:30:00 | MSFT | Stock | 29.98 | 30.0 | 29.96 | 29.96 | 3429993.0 |
| 2007-07-05 15:00:00 | MSFT | Stock | 29.97 | 30.0 | 29.91 | 29.96 | 3664983.0 |
| 2007-07-05 15:30:00 | MSFT | Stock | 29.96 | 30.02 | 29.94 | 29.99 | 5093055.0 |
| 2007-07-05 16:00:00 | MSFT | Stock | 29.99 | 29.99 | 29.99 | 29.99 | 1259217.0 |
| 2007-07-05 08:00:00 | NVDA | Stock | 0.7183 | 0.7183 | 0.715 | 0.715 | 66000.0 |
| 2007-07-05 08:30:00 | NVDA | Stock | 0.7183 | 0.7183 | 0.7167 | 0.7167 | 66000.0 |
| 2007-07-05 09:00:00 | NVDA | Stock | 0.7152 | 0.7172 | 0.715 | 0.7172 | 120000.0 |
| 2007-07-05 09:30:00 | NVDA | Stock | 0.7185 | 0.7233 | 0.715 | 0.7225 | 31468080.0 |
| 2007-07-05 10:00:00 | NVDA | Stock | 0.7225 | 0.725 | 0.7207 | 0.7223 | 39034020.0 |
| 2007-07-05 10:30:00 | NVDA | Stock | 0.7223 | 0.7238 | 0.7203 | 0.7213 | 25109760.0 |
| 2007-07-05 11:00:00 | NVDA | Stock | 0.7215 | 0.723 | 0.7197 | 0.7222 | 25968480.0 |
| 2007-07-05 11:30:00 | NVDA | Stock | 0.7222 | 0.7232 | 0.7217 | 0.7228 | 20490720.0 |
| 2007-07-05 12:00:00 | NVDA | Stock | 0.7227 | 0.7237 | 0.7222 | 0.7225 | 26255700.0 |
| 2007-07-05 12:30:00 | NVDA | Stock | 0.7227 | 0.7245 | 0.7213 | 0.7237 | 23030520.0 |
| 2007-07-05 13:00:00 | NVDA | Stock | 0.7237 | 0.7245 | 0.723 | 0.7235 | 14399100.0 |
| 2007-07-05 13:30:00 | NVDA | Stock | 0.7233 | 0.724 | 0.7227 | 0.723 | 21793920.0 |
| 2007-07-05 14:00:00 | NVDA | Stock | 0.7228 | 0.7245 | 0.7225 | 0.7245 | 17899440.0 |
| 2007-07-05 14:30:00 | NVDA | Stock | 0.7245 | 0.7283 | 0.7243 | 0.7272 | 37478100.0 |
| 2007-07-05 15:00:00 | NVDA | Stock | 0.727 | 0.7275 | 0.7259 | 0.7273 | 29556660.0 |
| 2007-07-05 15:30:00 | NVDA | Stock | 0.7272 | 0.7278 | 0.7253 | 0.7255 | 39046620.0 |
| 2007-07-05 16:00:00 | NVDA | Stock | 0.7258 | 0.7272 | 0.7255 | 0.7272 | 248040.0 |
| 2007-07-05 16:30:00 | NVDA | Stock | 0.7237 | 0.7237 | 0.7237 | 0.7237 | 6000.0 |
| 2007-07-05 18:00:00 | NVDA | Stock | 0.726 | 0.727 | 0.726 | 0.727 | 78000.0 |
| 2007-07-05 19:30:00 | NVDA | Stock | 0.7272 | 0.7272 | 0.7272 | 0.7272 | 72600.0 |
| 2007-07-05 08:00:00 | AMZN | Stock | 3.473 | 3.473 | 3.473 | 3.473 | 10000.0 |
| 2007-07-05 08:30:00 | AMZN | Stock | 3.478 | 3.478 | 3.478 | 3.478 | 5980.0 |
> showing 50 of 62,912 rows — these rows as CSV