PREVIEW / stock_1hour / 2009-09-25
file: by_date/stock_1hour/2009/2009-09-25.parquet size: 876 KB rows: 42,224 symbols: 3,390
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-09-25 06:00:00 | AAPL | Stock | 6.4996 | 6.4996 | 6.4996 | 6.4996 | 2800.0 |
| 2009-09-25 07:00:00 | AAPL | Stock | 6.4661 | 6.5 | 6.4643 | 6.4932 | 532784.0 |
| 2009-09-25 08:00:00 | AAPL | Stock | 6.4864 | 6.5179 | 6.475 | 6.4929 | 2611672.0 |
| 2009-09-25 09:00:00 | AAPL | Stock | 6.4929 | 6.6193 | 6.4821 | 6.5914 | 113019788.0 |
| 2009-09-25 10:00:00 | AAPL | Stock | 6.5907 | 6.625 | 6.5718 | 6.5971 | 76367256.0 |
| 2009-09-25 11:00:00 | AAPL | Stock | 6.5972 | 6.6036 | 6.5411 | 6.545 | 46777780.0 |
| 2009-09-25 12:00:00 | AAPL | Stock | 6.5446 | 6.5643 | 6.5225 | 6.5327 | 39507356.0 |
| 2009-09-25 13:00:00 | AAPL | Stock | 6.5325 | 6.5714 | 6.5 | 6.5707 | 42529508.0 |
| 2009-09-25 14:00:00 | AAPL | Stock | 6.5711 | 6.5864 | 6.5468 | 6.5672 | 42037576.0 |
| 2009-09-25 15:00:00 | AAPL | Stock | 6.5693 | 6.5714 | 6.48 | 6.5064 | 67343556.0 |
| 2009-09-25 16:00:00 | AAPL | Stock | 6.52 | 6.5608 | 6.5046 | 6.5286 | 9360680.0 |
| 2009-09-25 17:00:00 | AAPL | Stock | 6.565 | 6.565 | 6.5214 | 6.5214 | 144956.0 |
| 2009-09-25 18:00:00 | AAPL | Stock | 6.5214 | 6.5214 | 6.5125 | 6.5129 | 373464.0 |
| 2009-09-25 19:00:00 | AAPL | Stock | 6.5125 | 6.5179 | 6.5125 | 6.5129 | 30800.0 |
| 2009-09-25 07:00:00 | MSFT | Stock | 25.99 | 25.99 | 25.8 | 25.8 | 4500.0 |
| 2009-09-25 08:00:00 | MSFT | Stock | 25.8 | 25.94 | 25.7 | 25.75 | 299542.0 |
| 2009-09-25 09:00:00 | MSFT | Stock | 25.75 | 25.82 | 25.6 | 25.69 | 4881169.0 |
| 2009-09-25 10:00:00 | MSFT | Stock | 25.68 | 25.82 | 25.6 | 25.633 | 7051093.0 |
| 2009-09-25 11:00:00 | MSFT | Stock | 25.64 | 25.73 | 25.61 | 25.67 | 5149099.0 |
| 2009-09-25 12:00:00 | MSFT | Stock | 25.67 | 25.7 | 25.55 | 25.56 | 4700654.0 |
| 2009-09-25 13:00:00 | MSFT | Stock | 25.55 | 25.67 | 25.52 | 25.65 | 5886420.0 |
| 2009-09-25 14:00:00 | MSFT | Stock | 25.648 | 25.69 | 25.59 | 25.65 | 6107554.0 |
| 2009-09-25 15:00:00 | MSFT | Stock | 25.66 | 25.68 | 25.53 | 25.57 | 8464472.0 |
| 2009-09-25 16:00:00 | MSFT | Stock | 25.57 | 25.7 | 25.45 | 25.5 | 2560208.0 |
| 2009-09-25 17:00:00 | MSFT | Stock | 25.94 | 25.94 | 25.49 | 25.5 | 3000.0 |
| 2009-09-25 18:00:00 | MSFT | Stock | 25.5 | 25.55 | 25.5 | 25.5 | 51534.0 |
| 2009-09-25 19:00:00 | MSFT | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 950.0 |
| 2009-09-25 08:00:00 | NVDA | Stock | 0.3685 | 0.3685 | 0.3685 | 0.3685 | 12680.0 |
| 2009-09-25 09:00:00 | NVDA | Stock | 0.3675 | 0.3675 | 0.3612 | 0.3652 | 61728800.0 |
| 2009-09-25 10:00:00 | NVDA | Stock | 0.365 | 0.3682 | 0.3622 | 0.365 | 64496240.0 |
| 2009-09-25 11:00:00 | NVDA | Stock | 0.365 | 0.3658 | 0.3622 | 0.3622 | 41546600.0 |
| 2009-09-25 12:00:00 | NVDA | Stock | 0.3622 | 0.3625 | 0.36 | 0.361 | 48349840.0 |
| 2009-09-25 13:00:00 | NVDA | Stock | 0.361 | 0.3628 | 0.3598 | 0.3628 | 22613800.0 |
| 2009-09-25 14:00:00 | NVDA | Stock | 0.3628 | 0.3648 | 0.3625 | 0.3632 | 46509160.0 |
| 2009-09-25 15:00:00 | NVDA | Stock | 0.3635 | 0.3635 | 0.3615 | 0.3625 | 76211520.0 |
| 2009-09-25 16:00:00 | NVDA | Stock | 0.3625 | 0.3632 | 0.3625 | 0.3625 | 13488240.0 |
| 2009-09-25 17:00:00 | NVDA | Stock | 0.3625 | 0.3625 | 0.3625 | 0.3625 | 40000.0 |
| 2009-09-25 18:00:00 | NVDA | Stock | 0.3645 | 0.3645 | 0.3645 | 0.3645 | 20000.0 |
| 2009-09-25 19:00:00 | NVDA | Stock | 0.3675 | 0.3675 | 0.3675 | 0.3675 | 4000.0 |
| 2009-09-25 07:00:00 | AMZN | Stock | 4.55 | 4.6005 | 4.55 | 4.6005 | 4000.0 |
| 2009-09-25 08:00:00 | AMZN | Stock | 4.552 | 4.559 | 4.535 | 4.5475 | 71000.0 |
| 2009-09-25 09:00:00 | AMZN | Stock | 4.5625 | 4.6125 | 4.5435 | 4.581 | 11316540.0 |
| 2009-09-25 10:00:00 | AMZN | Stock | 4.581 | 4.59 | 4.548 | 4.5605 | 12937820.0 |
| 2009-09-25 11:00:00 | AMZN | Stock | 4.56 | 4.563 | 4.5275 | 4.533 | 9898400.0 |
| 2009-09-25 12:00:00 | AMZN | Stock | 4.529 | 4.5315 | 4.4875 | 4.5185 | 13780440.0 |
| 2009-09-25 13:00:00 | AMZN | Stock | 4.5185 | 4.543 | 4.504 | 4.5415 | 7383020.0 |
| 2009-09-25 14:00:00 | AMZN | Stock | 4.542 | 4.553 | 4.516 | 4.5445 | 10101500.0 |
| 2009-09-25 15:00:00 | AMZN | Stock | 4.5445 | 4.551 | 4.5182 | 4.5255 | 15399500.0 |
| 2009-09-25 16:00:00 | AMZN | Stock | 4.5295 | 4.5434 | 4.515 | 4.526 | 927820.0 |
| 2009-09-25 17:00:00 | AMZN | Stock | 4.6055 | 4.6055 | 4.6055 | 4.6055 | 2000.0 |
> showing 50 of 42,224 rows — these rows as CSV