PREVIEW / stock_1hour / 2009-09-24
file: by_date/stock_1hour/2009/2009-09-24.parquet size: 889 KB rows: 42,654 symbols: 3,394
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-24 04:00:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 8400.0 |
| 2009-09-24 05:00:00 | AAPL | Stock | 6.6786 | 6.6879 | 6.6786 | 6.6879 | 5600.0 |
| 2009-09-24 07:00:00 | AAPL | Stock | 6.6675 | 6.6804 | 6.6675 | 6.6804 | 175000.0 |
| 2009-09-24 08:00:00 | AAPL | Stock | 6.6911 | 6.7139 | 6.6679 | 6.7029 | 3628996.0 |
| 2009-09-24 09:00:00 | AAPL | Stock | 6.7036 | 6.7143 | 6.6193 | 6.6429 | 105527520.0 |
| 2009-09-24 10:00:00 | AAPL | Stock | 6.6321 | 6.6446 | 6.5304 | 6.5786 | 151725980.0 |
| 2009-09-24 11:00:00 | AAPL | Stock | 6.5792 | 6.5993 | 6.555 | 6.5571 | 43540140.0 |
| 2009-09-24 12:00:00 | AAPL | Stock | 6.5575 | 6.5779 | 6.5371 | 6.543 | 42050036.0 |
| 2009-09-24 13:00:00 | AAPL | Stock | 6.5425 | 6.5664 | 6.5286 | 6.5461 | 44677892.0 |
| 2009-09-24 14:00:00 | AAPL | Stock | 6.5446 | 6.5589 | 6.5275 | 6.5561 | 51671676.0 |
| 2009-09-24 15:00:00 | AAPL | Stock | 6.5567 | 6.5786 | 6.5482 | 6.565 | 79473492.0 |
| 2009-09-24 16:00:00 | AAPL | Stock | 6.565 | 6.588 | 6.4546 | 6.4943 | 20356420.0 |
| 2009-09-24 17:00:00 | AAPL | Stock | 6.4946 | 6.565 | 6.4646 | 6.4882 | 3427032.0 |
| 2009-09-24 18:00:00 | AAPL | Stock | 6.4875 | 6.565 | 6.4821 | 6.4875 | 627564.0 |
| 2009-09-24 19:00:00 | AAPL | Stock | 6.4875 | 6.4911 | 6.4821 | 6.4857 | 411460.0 |
| 2009-09-24 08:00:00 | MSFT | Stock | 25.71 | 25.98 | 25.69 | 25.96 | 19910.0 |
| 2009-09-24 09:00:00 | MSFT | Stock | 25.91 | 26.11 | 25.82 | 26.06 | 5255840.0 |
| 2009-09-24 10:00:00 | MSFT | Stock | 26.09 | 26.1 | 25.67 | 25.77 | 11514067.0 |
| 2009-09-24 11:00:00 | MSFT | Stock | 25.77 | 25.87 | 25.66 | 25.74 | 6875415.0 |
| 2009-09-24 12:00:00 | MSFT | Stock | 25.73 | 25.79 | 25.68 | 25.72 | 4078396.0 |
| 2009-09-24 13:00:00 | MSFT | Stock | 25.72 | 25.83 | 25.68 | 25.762 | 5590592.0 |
| 2009-09-24 14:00:00 | MSFT | Stock | 25.76 | 25.94 | 25.75 | 25.891 | 6553708.0 |
| 2009-09-24 15:00:00 | MSFT | Stock | 25.9 | 26.02 | 25.83 | 25.93 | 11978256.0 |
| 2009-09-24 16:00:00 | MSFT | Stock | 25.94 | 25.963 | 25.66 | 25.75 | 3255582.0 |
| 2009-09-24 17:00:00 | MSFT | Stock | 25.8 | 25.966 | 25.7 | 25.7 | 25358.0 |
| 2009-09-24 18:00:00 | MSFT | Stock | 25.94 | 25.94 | 25.72 | 25.73 | 31946.0 |
| 2009-09-24 19:00:00 | MSFT | Stock | 25.77 | 25.77 | 25.72 | 25.75 | 2774.0 |
| 2009-09-24 08:00:00 | NVDA | Stock | 0.3753 | 0.38 | 0.3753 | 0.38 | 368000.0 |
| 2009-09-24 09:00:00 | NVDA | Stock | 0.3778 | 0.3798 | 0.3725 | 0.3763 | 74858720.0 |
| 2009-09-24 10:00:00 | NVDA | Stock | 0.3763 | 0.3771 | 0.3672 | 0.3705 | 151102440.0 |
| 2009-09-24 11:00:00 | NVDA | Stock | 0.3704 | 0.3735 | 0.3698 | 0.37 | 56263240.0 |
| 2009-09-24 12:00:00 | NVDA | Stock | 0.37 | 0.371 | 0.3692 | 0.3695 | 44791000.0 |
| 2009-09-24 13:00:00 | NVDA | Stock | 0.3696 | 0.3715 | 0.369 | 0.3698 | 61136400.0 |
| 2009-09-24 14:00:00 | NVDA | Stock | 0.3698 | 0.37 | 0.3675 | 0.3687 | 45823680.0 |
| 2009-09-24 15:00:00 | NVDA | Stock | 0.3687 | 0.3713 | 0.3682 | 0.369 | 105160480.0 |
| 2009-09-24 16:00:00 | NVDA | Stock | 0.3685 | 0.3706 | 0.3672 | 0.3685 | 7676600.0 |
| 2009-09-24 17:00:00 | NVDA | Stock | 0.368 | 0.3685 | 0.368 | 0.3685 | 132000.0 |
| 2009-09-24 18:00:00 | NVDA | Stock | 0.3685 | 0.3695 | 0.3685 | 0.3695 | 49600.0 |
| 2009-09-24 19:00:00 | NVDA | Stock | 0.3688 | 0.3688 | 0.3688 | 0.3688 | 19600.0 |
| 2009-09-24 08:00:00 | AMZN | Stock | 4.625 | 4.6625 | 4.625 | 4.65 | 128000.0 |
| 2009-09-24 09:00:00 | AMZN | Stock | 4.65 | 4.65 | 4.55 | 4.6005 | 17109720.0 |
| 2009-09-24 10:00:00 | AMZN | Stock | 4.6 | 4.608 | 4.5385 | 4.561 | 21971080.0 |
| 2009-09-24 11:00:00 | AMZN | Stock | 4.561 | 4.597 | 4.559 | 4.572 | 10295800.0 |
| 2009-09-24 12:00:00 | AMZN | Stock | 4.5716 | 4.5785 | 4.555 | 4.5635 | 6441720.0 |
| 2009-09-24 13:00:00 | AMZN | Stock | 4.564 | 4.5885 | 4.563 | 4.572 | 8778380.0 |
| 2009-09-24 14:00:00 | AMZN | Stock | 4.573 | 4.6105 | 4.5705 | 4.6024 | 11934180.0 |
| 2009-09-24 15:00:00 | AMZN | Stock | 4.601 | 4.6255 | 4.595 | 4.6055 | 17384620.0 |
| 2009-09-24 16:00:00 | AMZN | Stock | 4.608 | 4.608 | 4.5445 | 4.6055 | 1988280.0 |
| 2009-09-24 17:00:00 | AMZN | Stock | 4.545 | 4.545 | 4.5305 | 4.54 | 82260.0 |
| 2009-09-24 18:00:00 | AMZN | Stock | 4.6055 | 4.6055 | 4.5355 | 4.55 | 72760.0 |
> showing 50 of 42,654 rows — these rows as CSV