PREVIEW / stock_1hour / 2006-12-18
file: by_date/stock_1hour/2006/2006-12-18.parquet size: 648 KB rows: 30,874 symbols: 2,494
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-12-18 06:00:00 | AAPL | Stock | 3.1368 | 3.1368 | 3.1368 | 3.1368 | 5600.0 |
| 2006-12-18 07:00:00 | AAPL | Stock | 3.1411 | 3.1661 | 3.1411 | 3.1611 | 245000.0 |
| 2006-12-18 08:00:00 | AAPL | Stock | 3.1657 | 3.1668 | 3.1443 | 3.1471 | 2052120.0 |
| 2006-12-18 09:00:00 | AAPL | Stock | 3.145 | 3.145 | 3.1018 | 3.1301 | 85588916.0 |
| 2006-12-18 10:00:00 | AAPL | Stock | 3.1304 | 3.1371 | 3.0954 | 3.1054 | 105754936.0 |
| 2006-12-18 11:00:00 | AAPL | Stock | 3.1054 | 3.1086 | 3.0861 | 3.0914 | 76109348.0 |
| 2006-12-18 12:00:00 | AAPL | Stock | 3.0911 | 3.1046 | 3.0807 | 3.1014 | 73153416.0 |
| 2006-12-18 13:00:00 | AAPL | Stock | 3.1018 | 3.1046 | 3.0882 | 3.0954 | 44288608.0 |
| 2006-12-18 14:00:00 | AAPL | Stock | 3.0961 | 3.0961 | 3.0482 | 3.0521 | 99182580.0 |
| 2006-12-18 15:00:00 | AAPL | Stock | 3.0521 | 3.0679 | 3.0211 | 3.0511 | 221641140.0 |
| 2006-12-18 16:00:00 | AAPL | Stock | 3.0507 | 3.055 | 3.0464 | 3.0525 | 2473576.0 |
| 2006-12-18 17:00:00 | AAPL | Stock | 3.0525 | 3.0525 | 3.0468 | 3.0468 | 2932692.0 |
| 2006-12-18 18:00:00 | AAPL | Stock | 3.0475 | 3.0493 | 3.0439 | 3.0464 | 582960.0 |
| 2006-12-18 19:00:00 | AAPL | Stock | 3.0461 | 3.0471 | 3.0446 | 3.0464 | 220892.0 |
| 2006-12-18 07:00:00 | MSFT | Stock | 30.2 | 30.2 | 30.2 | 30.2 | 1036.0 |
| 2006-12-18 08:00:00 | MSFT | Stock | 30.21 | 30.28 | 30.17 | 30.28 | 59630.0 |
| 2006-12-18 09:00:00 | MSFT | Stock | 30.28 | 30.28 | 30.09 | 30.19 | 5912203.0 |
| 2006-12-18 10:00:00 | MSFT | Stock | 30.2 | 30.26 | 30.12 | 30.2 | 6154417.0 |
| 2006-12-18 11:00:00 | MSFT | Stock | 30.202 | 30.21 | 30.05 | 30.06 | 3982771.0 |
| 2006-12-18 12:00:00 | MSFT | Stock | 30.05 | 30.06 | 29.9 | 29.97 | 5494317.0 |
| 2006-12-18 13:00:00 | MSFT | Stock | 29.96 | 30.02 | 29.91 | 29.97 | 4909442.0 |
| 2006-12-18 14:00:00 | MSFT | Stock | 29.96 | 29.99 | 29.78 | 29.9 | 6563212.0 |
| 2006-12-18 15:00:00 | MSFT | Stock | 29.9 | 30.0 | 29.8 | 29.87 | 13810068.0 |
| 2006-12-18 16:00:00 | MSFT | Stock | 29.89 | 29.9 | 29.85 | 29.85 | 4552310.0 |
| 2006-12-18 17:00:00 | MSFT | Stock | 29.82 | 29.89 | 29.8 | 29.89 | 95844.0 |
| 2006-12-18 19:00:00 | MSFT | Stock | 29.84 | 29.85 | 29.84 | 29.85 | 3500.0 |
| 2006-12-18 07:00:00 | NVDA | Stock | 0.625 | 0.625 | 0.625 | 0.625 | 30000.0 |
| 2006-12-18 08:00:00 | NVDA | Stock | 0.6267 | 0.6282 | 0.6267 | 0.6282 | 241800.0 |
| 2006-12-18 09:00:00 | NVDA | Stock | 0.628 | 0.6395 | 0.625 | 0.6393 | 91194120.0 |
| 2006-12-18 10:00:00 | NVDA | Stock | 0.6393 | 0.6433 | 0.6378 | 0.641 | 143492580.0 |
| 2006-12-18 11:00:00 | NVDA | Stock | 0.6412 | 0.642 | 0.639 | 0.6395 | 80687580.0 |
| 2006-12-18 12:00:00 | NVDA | Stock | 0.6395 | 0.6395 | 0.6342 | 0.6373 | 70116420.0 |
| 2006-12-18 13:00:00 | NVDA | Stock | 0.6373 | 0.6387 | 0.6347 | 0.6373 | 55202400.0 |
| 2006-12-18 14:00:00 | NVDA | Stock | 0.6375 | 0.6387 | 0.6353 | 0.637 | 98255400.0 |
| 2006-12-18 15:00:00 | NVDA | Stock | 0.6368 | 0.6382 | 0.634 | 0.636 | 110530440.0 |
| 2006-12-18 16:00:00 | NVDA | Stock | 0.6365 | 0.6367 | 0.6352 | 0.6367 | 2707500.0 |
| 2006-12-18 17:00:00 | NVDA | Stock | 0.6367 | 0.6375 | 0.6347 | 0.6347 | 148200.0 |
| 2006-12-18 18:00:00 | NVDA | Stock | 0.635 | 0.6365 | 0.635 | 0.6365 | 271800.0 |
| 2006-12-18 08:00:00 | AMZN | Stock | 2.01 | 2.0185 | 2.01 | 2.0105 | 51800.0 |
| 2006-12-18 09:00:00 | AMZN | Stock | 2.0005 | 2.032 | 2.0005 | 2.0265 | 16336520.0 |
| 2006-12-18 10:00:00 | AMZN | Stock | 2.0265 | 2.03 | 2.017 | 2.0205 | 23150380.0 |
| 2006-12-18 11:00:00 | AMZN | Stock | 2.02 | 2.021 | 1.9975 | 1.9975 | 20111240.0 |
| 2006-12-18 12:00:00 | AMZN | Stock | 1.9975 | 1.9975 | 1.983 | 1.9845 | 15435080.0 |
| 2006-12-18 13:00:00 | AMZN | Stock | 1.984 | 1.987 | 1.9705 | 1.984 | 11219940.0 |
| 2006-12-18 14:00:00 | AMZN | Stock | 1.984 | 1.9845 | 1.951 | 1.9565 | 12266120.0 |
| 2006-12-18 15:00:00 | AMZN | Stock | 1.956 | 1.9655 | 1.943 | 1.962 | 23661040.0 |
| 2006-12-18 16:00:00 | AMZN | Stock | 1.962 | 1.963 | 1.959 | 1.96 | 325400.0 |
| 2006-12-18 18:00:00 | AMZN | Stock | 1.96 | 1.96 | 1.959 | 1.959 | 14000.0 |
| 2006-12-18 19:00:00 | AMZN | Stock | 1.959 | 1.959 | 1.959 | 1.959 | 2000.0 |
| 2006-12-18 09:00:00 | CL | Stock | 32.545 | 32.7 | 32.545 | 32.615 | 250400.0 |
> showing 50 of 30,874 rows — these rows as CSV