PREVIEW / stock_30min / 2006-04-07
file: by_date/stock_30min/2006/2006-04-07.parquet size: 920 KB rows: 49,345 symbols: 2,226
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-07 06:00:00 | AAPL | Stock | 2.5714 | 2.5732 | 2.5714 | 2.5714 | 14000.0 |
| 2006-04-07 06:30:00 | AAPL | Stock | 2.5696 | 2.5696 | 2.5696 | 2.5696 | 2800.0 |
| 2006-04-07 07:30:00 | AAPL | Stock | 2.5554 | 2.5554 | 2.5429 | 2.5429 | 204148.0 |
| 2006-04-07 08:00:00 | AAPL | Stock | 2.5443 | 2.55 | 2.5179 | 2.5336 | 3731700.0 |
| 2006-04-07 08:30:00 | AAPL | Stock | 2.5339 | 2.5539 | 2.5286 | 2.5382 | 8410444.0 |
| 2006-04-07 09:00:00 | AAPL | Stock | 2.5382 | 2.5439 | 2.5232 | 2.5332 | 11070500.0 |
| 2006-04-07 09:30:00 | AAPL | Stock | 2.5332 | 2.5432 | 2.4914 | 2.495 | 245707532.0 |
| 2006-04-07 10:00:00 | AAPL | Stock | 2.4946 | 2.5139 | 2.4821 | 2.4832 | 135387084.0 |
| 2006-04-07 10:30:00 | AAPL | Stock | 2.4829 | 2.4907 | 2.46 | 2.4707 | 171986108.0 |
| 2006-04-07 11:00:00 | AAPL | Stock | 2.4704 | 2.4745 | 2.4539 | 2.4643 | 112690368.0 |
| 2006-04-07 11:30:00 | AAPL | Stock | 2.4643 | 2.4654 | 2.4454 | 2.4543 | 94134824.0 |
| 2006-04-07 12:00:00 | AAPL | Stock | 2.4543 | 2.4732 | 2.4471 | 2.4711 | 65934148.0 |
| 2006-04-07 12:30:00 | AAPL | Stock | 2.4714 | 2.5 | 2.4675 | 2.495 | 112486332.0 |
| 2006-04-07 13:00:00 | AAPL | Stock | 2.495 | 2.5168 | 2.4846 | 2.5164 | 113953224.0 |
| 2006-04-07 13:30:00 | AAPL | Stock | 2.5164 | 2.5316 | 2.4932 | 2.5021 | 101104836.0 |
| 2006-04-07 14:00:00 | AAPL | Stock | 2.5025 | 2.5068 | 2.4946 | 2.4989 | 55201412.0 |
| 2006-04-07 14:30:00 | AAPL | Stock | 2.4986 | 2.5211 | 2.4975 | 2.5204 | 100622536.0 |
| 2006-04-07 15:00:00 | AAPL | Stock | 2.5207 | 2.5214 | 2.4861 | 2.4896 | 96424944.0 |
| 2006-04-07 15:30:00 | AAPL | Stock | 2.4896 | 2.4989 | 2.4821 | 2.4918 | 97258504.0 |
| 2006-04-07 16:00:00 | AAPL | Stock | 2.4918 | 2.4946 | 2.4893 | 2.4939 | 2766904.0 |
| 2006-04-07 16:30:00 | AAPL | Stock | 2.4943 | 2.4946 | 2.4925 | 2.4925 | 690732.0 |
| 2006-04-07 17:00:00 | AAPL | Stock | 2.4921 | 2.4925 | 2.49 | 2.49 | 589232.0 |
| 2006-04-07 17:30:00 | AAPL | Stock | 2.5243 | 2.5243 | 2.4911 | 2.4918 | 91028.0 |
| 2006-04-07 18:00:00 | AAPL | Stock | 2.4911 | 2.4911 | 2.4893 | 2.49 | 142912.0 |
| 2006-04-07 07:00:00 | MSFT | Stock | 27.56 | 27.56 | 27.56 | 27.56 | 900.0 |
| 2006-04-07 07:30:00 | MSFT | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 360.0 |
| 2006-04-07 08:00:00 | MSFT | Stock | 27.51 | 27.53 | 27.51 | 27.53 | 4100.0 |
| 2006-04-07 08:30:00 | MSFT | Stock | 27.55 | 27.64 | 27.55 | 27.61 | 53134.0 |
| 2006-04-07 09:00:00 | MSFT | Stock | 27.64 | 27.64 | 27.58 | 27.61 | 157571.0 |
| 2006-04-07 09:30:00 | MSFT | Stock | 27.61 | 27.72 | 27.56 | 27.57 | 4429179.0 |
| 2006-04-07 10:00:00 | MSFT | Stock | 27.57 | 27.65 | 27.45 | 27.49 | 2993594.0 |
| 2006-04-07 10:30:00 | MSFT | Stock | 27.49 | 27.58 | 27.36 | 27.41 | 4572567.0 |
| 2006-04-07 11:00:00 | MSFT | Stock | 27.41 | 27.535 | 27.38 | 27.4 | 2338134.0 |
| 2006-04-07 11:30:00 | MSFT | Stock | 27.4 | 27.41 | 27.28 | 27.36 | 4419995.0 |
| 2006-04-07 12:00:00 | MSFT | Stock | 27.35 | 27.38 | 27.32 | 27.38 | 2251424.0 |
| 2006-04-07 12:30:00 | MSFT | Stock | 27.38 | 27.38 | 27.3 | 27.33 | 2926330.0 |
| 2006-04-07 13:00:00 | MSFT | Stock | 27.33 | 27.39 | 27.31 | 27.35 | 1472156.0 |
| 2006-04-07 13:30:00 | MSFT | Stock | 27.35 | 27.36 | 27.26 | 27.29 | 2459548.0 |
| 2006-04-07 14:00:00 | MSFT | Stock | 27.29 | 27.35 | 27.28 | 27.31 | 2050223.0 |
| 2006-04-07 14:30:00 | MSFT | Stock | 27.32 | 27.4 | 27.31 | 27.38 | 2316467.0 |
| 2006-04-07 15:00:00 | MSFT | Stock | 27.38 | 27.39 | 27.24 | 27.25 | 4060379.0 |
| 2006-04-07 15:30:00 | MSFT | Stock | 27.25 | 27.36 | 27.23 | 27.25 | 8720868.0 |
| 2006-04-07 16:00:00 | MSFT | Stock | 27.25 | 27.399 | 27.25 | 27.25 | 657632.0 |
| 2006-04-07 16:30:00 | MSFT | Stock | 27.26 | 27.28 | 27.26 | 27.28 | 5700.0 |
| 2006-04-07 18:00:00 | MSFT | Stock | 27.29 | 27.384 | 27.29 | 27.384 | 4000.0 |
| 2006-04-07 07:00:00 | NVDA | Stock | 0.51 | 0.5102 | 0.505 | 0.5072 | 75000.0 |
| 2006-04-07 07:30:00 | NVDA | Stock | 0.5043 | 0.505 | 0.5008 | 0.5017 | 157560.0 |
| 2006-04-07 08:00:00 | NVDA | Stock | 0.505 | 0.5075 | 0.5007 | 0.505 | 2702400.0 |
| 2006-04-07 08:30:00 | NVDA | Stock | 0.5027 | 0.5078 | 0.5025 | 0.5067 | 4748940.0 |
| 2006-04-07 09:00:00 | NVDA | Stock | 0.5068 | 0.508 | 0.5042 | 0.508 | 10441080.0 |
> showing 50 of 49,345 rows — these rows as CSV