PREVIEW / stock_1hour / 2009-10-19
file: by_date/stock_1hour/2009/2009-10-19.parquet size: 899 KB rows: 42,529 symbols: 3,406
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-19 04:00:00 | AAPL | Stock | 6.7429 | 6.7607 | 6.7254 | 6.7282 | 104972.0 |
| 2009-10-19 05:00:00 | AAPL | Stock | 6.7496 | 6.7496 | 6.7286 | 6.7286 | 30800.0 |
| 2009-10-19 06:00:00 | AAPL | Stock | 6.7279 | 6.7429 | 6.725 | 6.7321 | 184464.0 |
| 2009-10-19 07:00:00 | AAPL | Stock | 6.7329 | 6.75 | 6.7179 | 6.7179 | 909944.0 |
| 2009-10-19 08:00:00 | AAPL | Stock | 6.7286 | 6.7321 | 6.6821 | 6.7143 | 3984232.0 |
| 2009-10-19 09:00:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.6268 | 6.6604 | 100857288.0 |
| 2009-10-19 10:00:00 | AAPL | Stock | 6.6596 | 6.7014 | 6.645 | 6.6918 | 83843284.0 |
| 2009-10-19 11:00:00 | AAPL | Stock | 6.6918 | 6.7411 | 6.6379 | 6.7257 | 88647468.0 |
| 2009-10-19 12:00:00 | AAPL | Stock | 6.7264 | 6.7518 | 6.7204 | 6.7471 | 44889404.0 |
| 2009-10-19 13:00:00 | AAPL | Stock | 6.7471 | 6.7618 | 6.7254 | 6.7321 | 62478164.0 |
| 2009-10-19 14:00:00 | AAPL | Stock | 6.7321 | 6.735 | 6.6714 | 6.6854 | 91135688.0 |
| 2009-10-19 15:00:00 | AAPL | Stock | 6.6847 | 6.7857 | 6.6832 | 6.7843 | 190619968.0 |
| 2009-10-19 16:00:00 | AAPL | Stock | 6.7839 | 7.3161 | 6.6929 | 7.255 | 181767488.0 |
| 2009-10-19 17:00:00 | AAPL | Stock | 7.255 | 7.255 | 6.7312 | 7.1889 | 60750228.0 |
| 2009-10-19 18:00:00 | AAPL | Stock | 7.1875 | 7.2089 | 6.7807 | 7.2036 | 16054108.0 |
| 2009-10-19 19:00:00 | AAPL | Stock | 7.2043 | 7.2318 | 7.2032 | 7.2286 | 6929468.0 |
| 2009-10-19 06:00:00 | MSFT | Stock | 26.75 | 26.75 | 26.75 | 26.75 | 300.0 |
| 2009-10-19 07:00:00 | MSFT | Stock | 26.73 | 26.73 | 26.7 | 26.71 | 2100.0 |
| 2009-10-19 08:00:00 | MSFT | Stock | 26.59 | 26.7 | 26.35 | 26.52 | 50265.0 |
| 2009-10-19 09:00:00 | MSFT | Stock | 26.51 | 26.58 | 26.25 | 26.27 | 4578186.0 |
| 2009-10-19 10:00:00 | MSFT | Stock | 26.27 | 26.51 | 26.25 | 26.43 | 6082920.0 |
| 2009-10-19 11:00:00 | MSFT | Stock | 26.43 | 26.55 | 26.37 | 26.52 | 4689724.0 |
| 2009-10-19 12:00:00 | MSFT | Stock | 26.52 | 26.52 | 26.36 | 26.365 | 4987372.0 |
| 2009-10-19 13:00:00 | MSFT | Stock | 26.36 | 26.39 | 26.26 | 26.29 | 7473221.0 |
| 2009-10-19 14:00:00 | MSFT | Stock | 26.29 | 26.33 | 26.28 | 26.31 | 4076079.0 |
| 2009-10-19 15:00:00 | MSFT | Stock | 26.3 | 26.38 | 26.26 | 26.35 | 10470084.0 |
| 2009-10-19 16:00:00 | MSFT | Stock | 26.35 | 26.5 | 26.16 | 26.5 | 4624791.0 |
| 2009-10-19 17:00:00 | MSFT | Stock | 26.397 | 26.555 | 26.363 | 26.45 | 72400.0 |
| 2009-10-19 18:00:00 | MSFT | Stock | 26.44 | 26.46 | 26.36 | 26.44 | 38324.0 |
| 2009-10-19 19:00:00 | MSFT | Stock | 26.45 | 26.46 | 26.44 | 26.46 | 3490.0 |
| 2009-10-19 09:00:00 | NVDA | Stock | 0.3318 | 0.335 | 0.3305 | 0.3322 | 60998520.0 |
| 2009-10-19 10:00:00 | NVDA | Stock | 0.3325 | 0.3395 | 0.331 | 0.3382 | 156633800.0 |
| 2009-10-19 11:00:00 | NVDA | Stock | 0.338 | 0.3453 | 0.3368 | 0.3428 | 141876040.0 |
| 2009-10-19 12:00:00 | NVDA | Stock | 0.3428 | 0.343 | 0.3402 | 0.3425 | 49851880.0 |
| 2009-10-19 13:00:00 | NVDA | Stock | 0.3425 | 0.344 | 0.3413 | 0.344 | 68932440.0 |
| 2009-10-19 14:00:00 | NVDA | Stock | 0.3438 | 0.3445 | 0.342 | 0.3429 | 54294320.0 |
| 2009-10-19 15:00:00 | NVDA | Stock | 0.343 | 0.3435 | 0.3418 | 0.3425 | 151434760.0 |
| 2009-10-19 16:00:00 | NVDA | Stock | 0.3428 | 0.3475 | 0.34 | 0.345 | 3376760.0 |
| 2009-10-19 17:00:00 | NVDA | Stock | 0.3475 | 0.3475 | 0.345 | 0.3473 | 498080.0 |
| 2009-10-19 19:00:00 | NVDA | Stock | 0.3462 | 0.3462 | 0.3462 | 0.3462 | 44000.0 |
| 2009-10-19 07:00:00 | AMZN | Stock | 4.774 | 4.774 | 4.774 | 4.774 | 6000.0 |
| 2009-10-19 08:00:00 | AMZN | Stock | 4.7825 | 4.7825 | 4.745 | 4.75 | 231900.0 |
| 2009-10-19 09:00:00 | AMZN | Stock | 4.75 | 4.7895 | 4.718 | 4.722 | 14648760.0 |
| 2009-10-19 10:00:00 | AMZN | Stock | 4.722 | 4.765 | 4.7125 | 4.748 | 22753440.0 |
| 2009-10-19 11:00:00 | AMZN | Stock | 4.749 | 4.8139 | 4.7465 | 4.799 | 19862760.0 |
| 2009-10-19 12:00:00 | AMZN | Stock | 4.799 | 4.801 | 4.7725 | 4.7845 | 10117280.0 |
| 2009-10-19 13:00:00 | AMZN | Stock | 4.7835 | 4.79 | 4.7605 | 4.7609 | 9684040.0 |
| 2009-10-19 14:00:00 | AMZN | Stock | 4.7615 | 4.767 | 4.7335 | 4.746 | 13070820.0 |
| 2009-10-19 15:00:00 | AMZN | Stock | 4.746 | 4.747 | 4.7275 | 4.734 | 25994800.0 |
| 2009-10-19 16:00:00 | AMZN | Stock | 4.734 | 4.795 | 4.7295 | 4.795 | 2839240.0 |
> showing 50 of 42,529 rows — these rows as CSV