PREVIEW / stock_1hour / 2009-03-20
file: by_date/stock_1hour/2009/2009-03-20.parquet size: 824 KB rows: 40,709 symbols: 3,304
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-20 07:00:00 | AAPL | Stock | 3.5996 | 3.5996 | 3.5996 | 3.5996 | 2800.0 |
| 2009-03-20 08:00:00 | AAPL | Stock | 3.6079 | 3.6304 | 3.6025 | 3.6232 | 221424.0 |
| 2009-03-20 09:00:00 | AAPL | Stock | 3.6214 | 3.6825 | 3.6196 | 3.665 | 86555784.0 |
| 2009-03-20 10:00:00 | AAPL | Stock | 3.6657 | 3.6786 | 3.6418 | 3.6757 | 79753268.0 |
| 2009-03-20 11:00:00 | AAPL | Stock | 3.6757 | 3.6764 | 3.6414 | 3.6657 | 62454924.0 |
| 2009-03-20 12:00:00 | AAPL | Stock | 3.6655 | 3.6721 | 3.6168 | 3.6304 | 60678660.0 |
| 2009-03-20 13:00:00 | AAPL | Stock | 3.63 | 3.6386 | 3.5954 | 3.6043 | 69088572.0 |
| 2009-03-20 14:00:00 | AAPL | Stock | 3.6046 | 3.625 | 3.5918 | 3.6171 | 72098740.0 |
| 2009-03-20 15:00:00 | AAPL | Stock | 3.6168 | 3.6268 | 3.5975 | 3.6246 | 117451012.0 |
| 2009-03-20 16:00:00 | AAPL | Stock | 3.6254 | 3.6436 | 3.6071 | 3.6284 | 33550552.0 |
| 2009-03-20 17:00:00 | AAPL | Stock | 3.6282 | 3.6282 | 3.6196 | 3.6196 | 208712.0 |
| 2009-03-20 18:00:00 | AAPL | Stock | 3.6161 | 3.6168 | 3.6107 | 3.6125 | 177016.0 |
| 2009-03-20 19:00:00 | AAPL | Stock | 3.6179 | 3.6214 | 3.6129 | 3.6211 | 53200.0 |
| 2009-03-20 08:00:00 | MSFT | Stock | 17.1 | 17.15 | 17.03 | 17.15 | 13566.0 |
| 2009-03-20 09:00:00 | MSFT | Stock | 17.15 | 17.65 | 17.15 | 17.464 | 25655021.0 |
| 2009-03-20 10:00:00 | MSFT | Stock | 17.47 | 17.51 | 17.18 | 17.462 | 9672558.0 |
| 2009-03-20 11:00:00 | MSFT | Stock | 17.46 | 17.475 | 17.31 | 17.38 | 7003658.0 |
| 2009-03-20 12:00:00 | MSFT | Stock | 17.38 | 17.5 | 17.26 | 17.309 | 6453234.0 |
| 2009-03-20 13:00:00 | MSFT | Stock | 17.3 | 17.34 | 16.97 | 17.001 | 6126756.0 |
| 2009-03-20 14:00:00 | MSFT | Stock | 17.0 | 17.5 | 16.88 | 16.97 | 5679612.0 |
| 2009-03-20 15:00:00 | MSFT | Stock | 16.97 | 17.11 | 16.95 | 17.04 | 12473979.0 |
| 2009-03-20 16:00:00 | MSFT | Stock | 17.05 | 17.4 | 16.94 | 17.05 | 6032484.0 |
| 2009-03-20 17:00:00 | MSFT | Stock | 17.05 | 17.1 | 17.04 | 17.1 | 10395.0 |
| 2009-03-20 18:00:00 | MSFT | Stock | 17.1 | 17.1 | 17.05 | 17.05 | 21640.0 |
| 2009-03-20 19:00:00 | MSFT | Stock | 17.09 | 17.1 | 17.04 | 17.08 | 1510.0 |
| 2009-03-20 08:00:00 | NVDA | Stock | 0.252 | 0.252 | 0.2473 | 0.252 | 48000.0 |
| 2009-03-20 09:00:00 | NVDA | Stock | 0.2527 | 0.256 | 0.2453 | 0.2488 | 116167600.0 |
| 2009-03-20 10:00:00 | NVDA | Stock | 0.2488 | 0.251 | 0.2468 | 0.2488 | 194327240.0 |
| 2009-03-20 11:00:00 | NVDA | Stock | 0.249 | 0.2493 | 0.2425 | 0.2438 | 142797760.0 |
| 2009-03-20 12:00:00 | NVDA | Stock | 0.2438 | 0.245 | 0.2388 | 0.2392 | 111281520.0 |
| 2009-03-20 13:00:00 | NVDA | Stock | 0.239 | 0.239 | 0.2318 | 0.2333 | 166194800.0 |
| 2009-03-20 14:00:00 | NVDA | Stock | 0.2335 | 0.2368 | 0.2322 | 0.2365 | 114750600.0 |
| 2009-03-20 15:00:00 | NVDA | Stock | 0.2368 | 0.2422 | 0.2367 | 0.238 | 148810200.0 |
| 2009-03-20 16:00:00 | NVDA | Stock | 0.2382 | 0.2434 | 0.2378 | 0.2384 | 31345520.0 |
| 2009-03-20 17:00:00 | NVDA | Stock | 0.2382 | 0.252 | 0.237 | 0.237 | 366360.0 |
| 2009-03-20 18:00:00 | NVDA | Stock | 0.2388 | 0.2388 | 0.2388 | 0.2388 | 8000.0 |
| 2009-03-20 08:00:00 | AMZN | Stock | 3.5 | 3.5 | 3.485 | 3.485 | 13060.0 |
| 2009-03-20 09:00:00 | AMZN | Stock | 3.498 | 3.5445 | 3.474 | 3.5195 | 16200040.0 |
| 2009-03-20 10:00:00 | AMZN | Stock | 3.52 | 3.5445 | 3.51 | 3.529 | 16785100.0 |
| 2009-03-20 11:00:00 | AMZN | Stock | 3.528 | 3.5295 | 3.504 | 3.5075 | 12388020.0 |
| 2009-03-20 12:00:00 | AMZN | Stock | 3.5065 | 3.5155 | 3.48 | 3.4905 | 14724820.0 |
| 2009-03-20 13:00:00 | AMZN | Stock | 3.488 | 3.492 | 3.463 | 3.4655 | 16325140.0 |
| 2009-03-20 14:00:00 | AMZN | Stock | 3.466 | 3.4885 | 3.454 | 3.4835 | 18083820.0 |
| 2009-03-20 15:00:00 | AMZN | Stock | 3.484 | 3.5102 | 3.4755 | 3.4975 | 35275760.0 |
| 2009-03-20 16:00:00 | AMZN | Stock | 3.4955 | 3.5083 | 3.4955 | 3.4983 | 9163260.0 |
| 2009-03-20 17:00:00 | AMZN | Stock | 3.498 | 3.5 | 3.4975 | 3.5 | 36740.0 |
| 2009-03-20 18:00:00 | AMZN | Stock | 3.4975 | 3.498 | 3.48 | 3.48 | 20000.0 |
| 2009-03-20 19:00:00 | AMZN | Stock | 3.495 | 3.4975 | 3.495 | 3.4975 | 10000.0 |
| 2009-03-20 08:00:00 | TLT | Stock | 105.0 | 105.0 | 104.21 | 104.21 | 2100.0 |
| 2009-03-20 09:00:00 | TLT | Stock | 104.2 | 105.0 | 104.2 | 104.43 | 247525.0 |
> showing 50 of 40,709 rows — these rows as CSV