PREVIEW / stock_1hour / 2009-10-21
file: by_date/stock_1hour/2009/2009-10-21.parquet size: 892 KB rows: 42,389 symbols: 3,400
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-10-21 04:00:00 | AAPL | Stock | 7.1607 | 7.1607 | 7.1343 | 7.1343 | 5600.0 |
| 2009-10-21 05:00:00 | AAPL | Stock | 7.1107 | 7.1107 | 7.1107 | 7.1107 | 8400.0 |
| 2009-10-21 06:00:00 | AAPL | Stock | 7.1082 | 7.1082 | 7.1082 | 7.1082 | 2800.0 |
| 2009-10-21 07:00:00 | AAPL | Stock | 7.1086 | 7.1225 | 7.1036 | 7.1189 | 276640.0 |
| 2009-10-21 08:00:00 | AAPL | Stock | 7.1164 | 7.125 | 7.1071 | 7.1168 | 2094876.0 |
| 2009-10-21 09:00:00 | AAPL | Stock | 7.1161 | 7.2118 | 7.0993 | 7.2104 | 124527284.0 |
| 2009-10-21 10:00:00 | AAPL | Stock | 7.21 | 7.3393 | 7.2025 | 7.3271 | 273672252.0 |
| 2009-10-21 11:00:00 | AAPL | Stock | 7.3257 | 7.3643 | 7.3125 | 7.3182 | 148644104.0 |
| 2009-10-21 12:00:00 | AAPL | Stock | 7.3182 | 7.355 | 7.3011 | 7.3518 | 77399420.0 |
| 2009-10-21 13:00:00 | AAPL | Stock | 7.3514 | 7.4318 | 7.3471 | 7.4318 | 145137832.0 |
| 2009-10-21 14:00:00 | AAPL | Stock | 7.4307 | 7.4539 | 7.3875 | 7.4136 | 168402136.0 |
| 2009-10-21 15:00:00 | AAPL | Stock | 7.4136 | 7.4157 | 7.2993 | 7.3207 | 235274564.0 |
| 2009-10-21 16:00:00 | AAPL | Stock | 7.32 | 7.3318 | 7.3107 | 7.3318 | 8017352.0 |
| 2009-10-21 17:00:00 | AAPL | Stock | 7.0986 | 7.335 | 7.0986 | 7.3286 | 962136.0 |
| 2009-10-21 18:00:00 | AAPL | Stock | 7.3304 | 7.3339 | 7.3186 | 7.3221 | 1785812.0 |
| 2009-10-21 19:00:00 | AAPL | Stock | 7.3221 | 7.325 | 7.3189 | 7.3214 | 497224.0 |
| 2009-10-21 07:00:00 | MSFT | Stock | 26.37 | 26.48 | 26.35 | 26.37 | 4143.0 |
| 2009-10-21 08:00:00 | MSFT | Stock | 26.37 | 26.4 | 26.21 | 26.4 | 5599.0 |
| 2009-10-21 09:00:00 | MSFT | Stock | 26.37 | 26.7 | 26.35 | 26.618 | 6179906.0 |
| 2009-10-21 10:00:00 | MSFT | Stock | 26.62 | 26.75 | 26.58 | 26.61 | 10740345.0 |
| 2009-10-21 11:00:00 | MSFT | Stock | 26.62 | 26.63 | 26.5 | 26.54 | 7081490.0 |
| 2009-10-21 12:00:00 | MSFT | Stock | 26.54 | 26.65 | 26.51 | 26.61 | 5073254.0 |
| 2009-10-21 13:00:00 | MSFT | Stock | 26.612 | 26.68 | 26.55 | 26.65 | 4674444.0 |
| 2009-10-21 14:00:00 | MSFT | Stock | 26.63 | 26.71 | 26.53 | 26.65 | 6012219.0 |
| 2009-10-21 15:00:00 | MSFT | Stock | 26.65 | 26.74 | 26.45 | 26.61 | 16077920.0 |
| 2009-10-21 16:00:00 | MSFT | Stock | 26.61 | 26.62 | 26.52 | 26.55 | 3162171.0 |
| 2009-10-21 17:00:00 | MSFT | Stock | 26.37 | 26.66 | 26.37 | 26.55 | 10876.0 |
| 2009-10-21 18:00:00 | MSFT | Stock | 26.58 | 26.6 | 26.55 | 26.55 | 16309.0 |
| 2009-10-21 19:00:00 | MSFT | Stock | 26.59 | 26.59 | 26.56 | 26.56 | 7700.0 |
| 2009-10-21 08:00:00 | NVDA | Stock | 0.3378 | 0.3413 | 0.3378 | 0.3413 | 36000.0 |
| 2009-10-21 09:00:00 | NVDA | Stock | 0.342 | 0.3458 | 0.3402 | 0.3433 | 51833720.0 |
| 2009-10-21 10:00:00 | NVDA | Stock | 0.3433 | 0.3468 | 0.343 | 0.343 | 87379400.0 |
| 2009-10-21 11:00:00 | NVDA | Stock | 0.343 | 0.3433 | 0.3395 | 0.3398 | 57476960.0 |
| 2009-10-21 12:00:00 | NVDA | Stock | 0.3396 | 0.3405 | 0.3375 | 0.3382 | 50086560.0 |
| 2009-10-21 13:00:00 | NVDA | Stock | 0.338 | 0.3388 | 0.3368 | 0.3385 | 47273320.0 |
| 2009-10-21 14:00:00 | NVDA | Stock | 0.3388 | 0.3395 | 0.337 | 0.3382 | 52880400.0 |
| 2009-10-21 15:00:00 | NVDA | Stock | 0.3382 | 0.34 | 0.3328 | 0.3345 | 141907720.0 |
| 2009-10-21 16:00:00 | NVDA | Stock | 0.3345 | 0.3394 | 0.3328 | 0.3328 | 8892960.0 |
| 2009-10-21 17:00:00 | NVDA | Stock | 0.3338 | 0.3345 | 0.3338 | 0.3338 | 93040.0 |
| 2009-10-21 18:00:00 | NVDA | Stock | 0.3338 | 0.3338 | 0.3338 | 0.3338 | 32000.0 |
| 2009-10-21 19:00:00 | NVDA | Stock | 0.3342 | 0.3345 | 0.3342 | 0.3345 | 28000.0 |
| 2009-10-21 08:00:00 | AMZN | Stock | 4.7475 | 4.75 | 4.735 | 4.737 | 33000.0 |
| 2009-10-21 09:00:00 | AMZN | Stock | 4.737 | 4.8315 | 4.737 | 4.7885 | 16834700.0 |
| 2009-10-21 10:00:00 | AMZN | Stock | 4.787 | 4.82 | 4.765 | 4.7695 | 24543820.0 |
| 2009-10-21 11:00:00 | AMZN | Stock | 4.77 | 4.797 | 4.753 | 4.765 | 19259020.0 |
| 2009-10-21 12:00:00 | AMZN | Stock | 4.7655 | 4.775 | 4.74 | 4.753 | 13012940.0 |
| 2009-10-21 13:00:00 | AMZN | Stock | 4.7535 | 4.7695 | 4.743 | 4.7615 | 12648840.0 |
| 2009-10-21 14:00:00 | AMZN | Stock | 4.7625 | 4.764 | 4.7185 | 4.733 | 15509620.0 |
| 2009-10-21 15:00:00 | AMZN | Stock | 4.7325 | 4.735 | 4.6456 | 4.671 | 46010420.0 |
| 2009-10-21 16:00:00 | AMZN | Stock | 4.671 | 4.7449 | 4.617 | 4.7436 | 4835880.0 |
> showing 50 of 42,389 rows — these rows as CSV