PREVIEW / stock_1hour / 2009-08-06
file: by_date/stock_1hour/2009/2009-08-06.parquet size: 873 KB rows: 42,333 symbols: 3,341
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-08-06 06:00:00 | AAPL | Stock | 5.8693 | 5.8693 | 5.8693 | 5.8693 | 19656.0 |
| 2009-08-06 07:00:00 | AAPL | Stock | 5.8696 | 5.8857 | 5.8693 | 5.8857 | 74228.0 |
| 2009-08-06 08:00:00 | AAPL | Stock | 5.8968 | 5.9196 | 5.8696 | 5.9161 | 1170540.0 |
| 2009-08-06 09:00:00 | AAPL | Stock | 5.9157 | 5.9468 | 5.8839 | 5.8954 | 62191164.0 |
| 2009-08-06 10:00:00 | AAPL | Stock | 5.8957 | 5.9018 | 5.8543 | 5.8604 | 58697800.0 |
| 2009-08-06 11:00:00 | AAPL | Stock | 5.8603 | 5.8914 | 5.8596 | 5.8725 | 32279688.0 |
| 2009-08-06 12:00:00 | AAPL | Stock | 5.8729 | 5.8804 | 5.8571 | 5.8657 | 26797988.0 |
| 2009-08-06 13:00:00 | AAPL | Stock | 5.8668 | 5.8911 | 5.8571 | 5.8679 | 28801472.0 |
| 2009-08-06 14:00:00 | AAPL | Stock | 5.8675 | 5.87 | 5.8486 | 5.8596 | 44218132.0 |
| 2009-08-06 15:00:00 | AAPL | Stock | 5.8589 | 5.8746 | 5.8246 | 5.8539 | 64107260.0 |
| 2009-08-06 16:00:00 | AAPL | Stock | 5.8539 | 5.8782 | 5.8511 | 5.8571 | 11087496.0 |
| 2009-08-06 17:00:00 | AAPL | Stock | 5.8546 | 5.8571 | 5.8536 | 5.8539 | 414848.0 |
| 2009-08-06 18:00:00 | AAPL | Stock | 5.8539 | 5.8571 | 5.8539 | 5.8543 | 243628.0 |
| 2009-08-06 19:00:00 | AAPL | Stock | 5.8564 | 5.8571 | 5.8539 | 5.8554 | 128156.0 |
| 2009-08-06 08:00:00 | MSFT | Stock | 23.81 | 23.97 | 23.81 | 23.95 | 126143.0 |
| 2009-08-06 09:00:00 | MSFT | Stock | 23.93 | 23.98 | 23.66 | 23.67 | 5600023.0 |
| 2009-08-06 10:00:00 | MSFT | Stock | 23.67 | 23.77 | 23.64 | 23.68 | 8875612.0 |
| 2009-08-06 11:00:00 | MSFT | Stock | 23.672 | 23.76 | 23.62 | 23.62 | 5097360.0 |
| 2009-08-06 12:00:00 | MSFT | Stock | 23.621 | 23.66 | 23.52 | 23.6 | 6399025.0 |
| 2009-08-06 13:00:00 | MSFT | Stock | 23.6 | 23.63 | 23.48 | 23.49 | 6409658.0 |
| 2009-08-06 14:00:00 | MSFT | Stock | 23.48 | 23.49 | 23.27 | 23.37 | 9848914.0 |
| 2009-08-06 15:00:00 | MSFT | Stock | 23.37 | 23.55 | 23.33 | 23.45 | 13466715.0 |
| 2009-08-06 16:00:00 | MSFT | Stock | 23.45 | 23.74 | 23.39 | 23.42 | 2855774.0 |
| 2009-08-06 17:00:00 | MSFT | Stock | 23.42 | 23.46 | 23.41 | 23.45 | 29228.0 |
| 2009-08-06 18:00:00 | MSFT | Stock | 23.46 | 23.46 | 23.4 | 23.4 | 2685.0 |
| 2009-08-06 19:00:00 | MSFT | Stock | 23.43 | 23.46 | 23.41 | 23.42 | 7566.0 |
| 2009-08-06 08:00:00 | NVDA | Stock | 0.3388 | 0.34 | 0.3388 | 0.34 | 420000.0 |
| 2009-08-06 09:00:00 | NVDA | Stock | 0.3375 | 0.3422 | 0.3323 | 0.3328 | 73433120.0 |
| 2009-08-06 10:00:00 | NVDA | Stock | 0.3328 | 0.3338 | 0.3288 | 0.3313 | 137398320.0 |
| 2009-08-06 11:00:00 | NVDA | Stock | 0.3313 | 0.3345 | 0.331 | 0.3339 | 110387200.0 |
| 2009-08-06 12:00:00 | NVDA | Stock | 0.334 | 0.334 | 0.3295 | 0.3298 | 66787840.0 |
| 2009-08-06 13:00:00 | NVDA | Stock | 0.3298 | 0.3323 | 0.3288 | 0.3289 | 117020960.0 |
| 2009-08-06 14:00:00 | NVDA | Stock | 0.3289 | 0.3315 | 0.3275 | 0.3315 | 99080480.0 |
| 2009-08-06 15:00:00 | NVDA | Stock | 0.3313 | 0.3333 | 0.3275 | 0.3283 | 245542480.0 |
| 2009-08-06 16:00:00 | NVDA | Stock | 0.3283 | 0.35 | 0.3265 | 0.3438 | 73952320.0 |
| 2009-08-06 17:00:00 | NVDA | Stock | 0.335 | 0.3592 | 0.328 | 0.357 | 23632360.0 |
| 2009-08-06 18:00:00 | NVDA | Stock | 0.3565 | 0.3595 | 0.3545 | 0.3562 | 2865120.0 |
| 2009-08-06 19:00:00 | NVDA | Stock | 0.3562 | 0.359 | 0.3562 | 0.3575 | 1728000.0 |
| 2009-08-06 08:00:00 | AMZN | Stock | 4.2 | 4.2375 | 4.2 | 4.2375 | 83320.0 |
| 2009-08-06 09:00:00 | AMZN | Stock | 4.231 | 4.242 | 4.1525 | 4.1705 | 15835140.0 |
| 2009-08-06 10:00:00 | AMZN | Stock | 4.1705 | 4.2095 | 4.1645 | 4.186 | 18103680.0 |
| 2009-08-06 11:00:00 | AMZN | Stock | 4.186 | 4.225 | 4.182 | 4.195 | 9333720.0 |
| 2009-08-06 12:00:00 | AMZN | Stock | 4.1965 | 4.2105 | 4.185 | 4.2025 | 9724160.0 |
| 2009-08-06 13:00:00 | AMZN | Stock | 4.203 | 4.2314 | 4.195 | 4.196 | 7907100.0 |
| 2009-08-06 14:00:00 | AMZN | Stock | 4.196 | 4.2056 | 4.1805 | 4.1975 | 10142220.0 |
| 2009-08-06 15:00:00 | AMZN | Stock | 4.1955 | 4.2275 | 4.19 | 4.2195 | 18906160.0 |
| 2009-08-06 16:00:00 | AMZN | Stock | 4.223 | 4.235 | 4.1725 | 4.235 | 2994800.0 |
| 2009-08-06 17:00:00 | AMZN | Stock | 4.2235 | 4.2235 | 4.2235 | 4.2235 | 42600.0 |
| 2009-08-06 18:00:00 | AMZN | Stock | 4.219 | 4.219 | 4.213 | 4.213 | 20500.0 |
| 2009-08-06 08:00:00 | TLT | Stock | 91.0 | 91.08 | 90.59 | 90.94 | 7766.0 |
> showing 50 of 42,333 rows — these rows as CSV