PREVIEW / stock_1hour / 2004-08-13
file: by_date/stock_1hour/2004/2004-08-13.parquet size: 490 KB rows: 23,454 symbols: 1,820
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-13 08:00:00 | AAPL | Stock | 0.5491 | 0.5491 | 0.5482 | 0.5482 | 67200.0 |
| 2004-08-13 09:00:00 | AAPL | Stock | 0.5475 | 0.5586 | 0.5455 | 0.5563 | 29780576.0 |
| 2004-08-13 10:00:00 | AAPL | Stock | 0.5563 | 0.5573 | 0.5525 | 0.5564 | 32531912.0 |
| 2004-08-13 11:00:00 | AAPL | Stock | 0.5566 | 0.5577 | 0.5525 | 0.5532 | 34138944.0 |
| 2004-08-13 12:00:00 | AAPL | Stock | 0.5532 | 0.5536 | 0.5446 | 0.5463 | 44401056.0 |
| 2004-08-13 13:00:00 | AAPL | Stock | 0.5463 | 0.548 | 0.5429 | 0.5477 | 29702008.0 |
| 2004-08-13 14:00:00 | AAPL | Stock | 0.5477 | 0.5495 | 0.5438 | 0.548 | 43323224.0 |
| 2004-08-13 15:00:00 | AAPL | Stock | 0.5482 | 0.5548 | 0.547 | 0.5509 | 75689600.0 |
| 2004-08-13 16:00:00 | AAPL | Stock | 0.5509 | 0.5532 | 0.5489 | 0.5513 | 5044200.0 |
| 2004-08-13 17:00:00 | AAPL | Stock | 0.5509 | 0.5509 | 0.5504 | 0.5504 | 44800.0 |
| 2004-08-13 08:00:00 | MSFT | Stock | 27.12 | 27.15 | 27.04 | 27.06 | 56072.0 |
| 2004-08-13 09:00:00 | MSFT | Stock | 27.07 | 27.19 | 27.0 | 27.17 | 8965235.0 |
| 2004-08-13 10:00:00 | MSFT | Stock | 27.17 | 27.22 | 27.1 | 27.15 | 7528249.0 |
| 2004-08-13 11:00:00 | MSFT | Stock | 27.14 | 27.251 | 27.14 | 27.21 | 4900439.0 |
| 2004-08-13 12:00:00 | MSFT | Stock | 27.22 | 27.22 | 27.02 | 27.12 | 4366302.0 |
| 2004-08-13 13:00:00 | MSFT | Stock | 27.12 | 27.17 | 27.08 | 27.12 | 3046751.0 |
| 2004-08-13 14:00:00 | MSFT | Stock | 27.12 | 27.15 | 26.91 | 26.93 | 5447256.0 |
| 2004-08-13 15:00:00 | MSFT | Stock | 26.93 | 27.08 | 26.9 | 27.0 | 7145331.0 |
| 2004-08-13 16:00:00 | MSFT | Stock | 27.03 | 27.08 | 26.98 | 27.07 | 322919.0 |
| 2004-08-13 17:00:00 | MSFT | Stock | 27.1112 | 27.1112 | 27.04 | 27.11 | 37187.0 |
| 2004-08-13 18:00:00 | MSFT | Stock | 27.11 | 27.11 | 27.11 | 27.11 | 300.0 |
| 2004-08-13 08:00:00 | NVDA | Stock | 0.0852 | 0.0854 | 0.0852 | 0.0854 | 156000.0 |
| 2004-08-13 09:00:00 | NVDA | Stock | 0.0853 | 0.0867 | 0.0853 | 0.0862 | 85161720.0 |
| 2004-08-13 10:00:00 | NVDA | Stock | 0.0862 | 0.0867 | 0.0852 | 0.0866 | 149817960.0 |
| 2004-08-13 11:00:00 | NVDA | Stock | 0.0866 | 0.0876 | 0.0863 | 0.0875 | 103464600.0 |
| 2004-08-13 12:00:00 | NVDA | Stock | 0.0874 | 0.0875 | 0.0869 | 0.0871 | 69120240.0 |
| 2004-08-13 13:00:00 | NVDA | Stock | 0.0871 | 0.0879 | 0.0871 | 0.0877 | 72541320.0 |
| 2004-08-13 14:00:00 | NVDA | Stock | 0.0878 | 0.0881 | 0.0872 | 0.0874 | 92397840.0 |
| 2004-08-13 15:00:00 | NVDA | Stock | 0.0873 | 0.0881 | 0.0866 | 0.0875 | 209329680.0 |
| 2004-08-13 16:00:00 | NVDA | Stock | 0.0876 | 0.0877 | 0.087 | 0.087 | 3587760.0 |
| 2004-08-13 18:00:00 | NVDA | Stock | 0.0875 | 0.0875 | 0.0875 | 0.0875 | 30000.0 |
| 2004-08-13 08:00:00 | AMZN | Stock | 1.8275 | 1.8275 | 1.8245 | 1.8265 | 19000.0 |
| 2004-08-13 09:00:00 | AMZN | Stock | 1.825 | 1.85 | 1.821 | 1.8305 | 15844780.0 |
| 2004-08-13 10:00:00 | AMZN | Stock | 1.831 | 1.8345 | 1.796 | 1.806 | 24613320.0 |
| 2004-08-13 11:00:00 | AMZN | Stock | 1.806 | 1.8215 | 1.8055 | 1.814 | 12033020.0 |
| 2004-08-13 12:00:00 | AMZN | Stock | 1.814 | 1.816 | 1.8045 | 1.811 | 9634900.0 |
| 2004-08-13 13:00:00 | AMZN | Stock | 1.811 | 1.8115 | 1.805 | 1.808 | 5645940.0 |
| 2004-08-13 14:00:00 | AMZN | Stock | 1.808 | 1.8125 | 1.8 | 1.8 | 10638840.0 |
| 2004-08-13 15:00:00 | AMZN | Stock | 1.8 | 1.8095 | 1.7935 | 1.806 | 17933740.0 |
| 2004-08-13 16:00:00 | AMZN | Stock | 1.806 | 1.8095 | 1.806 | 1.809 | 611580.0 |
| 2004-08-13 17:00:00 | AMZN | Stock | 1.8065 | 1.8065 | 1.804 | 1.804 | 38680.0 |
| 2004-08-13 09:00:00 | CL | Stock | 26.05 | 26.075 | 26.005 | 26.02 | 197400.0 |
| 2004-08-13 10:00:00 | CL | Stock | 26.04 | 26.095 | 25.965 | 26.03 | 292800.0 |
| 2004-08-13 11:00:00 | CL | Stock | 26.03 | 26.085 | 26.01 | 26.04 | 250000.0 |
| 2004-08-13 12:00:00 | CL | Stock | 26.035 | 26.04 | 25.935 | 25.945 | 280800.0 |
| 2004-08-13 13:00:00 | CL | Stock | 25.935 | 26.024 | 25.9 | 25.985 | 202000.0 |
| 2004-08-13 14:00:00 | CL | Stock | 25.985 | 25.985 | 25.77 | 25.775 | 192000.0 |
| 2004-08-13 15:00:00 | CL | Stock | 25.775 | 25.87 | 25.75 | 25.86 | 787200.0 |
| 2004-08-13 16:00:00 | CL | Stock | 25.865 | 25.926 | 25.815 | 25.815 | 53000.0 |
> showing 49 of 23,454 rows — these rows as CSV