PREVIEW / stock_1hour / 2004-01-30
file: by_date/stock_1hour/2004/2004-01-30.parquet size: 510 KB rows: 23,533 symbols: 1,719
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-01-30 08:00:00 | AAPL | Stock | 0.4063 | 0.4063 | 0.4063 | 0.4063 | 56000.0 |
| 2004-01-30 09:00:00 | AAPL | Stock | 0.4045 | 0.408 | 0.402 | 0.4071 | 15025416.0 |
| 2004-01-30 10:00:00 | AAPL | Stock | 0.4071 | 0.4084 | 0.4041 | 0.4041 | 21826952.0 |
| 2004-01-30 11:00:00 | AAPL | Stock | 0.4041 | 0.4061 | 0.4004 | 0.4048 | 19213152.0 |
| 2004-01-30 12:00:00 | AAPL | Stock | 0.4048 | 0.4055 | 0.4018 | 0.4046 | 17056928.0 |
| 2004-01-30 13:00:00 | AAPL | Stock | 0.4046 | 0.4052 | 0.4021 | 0.4045 | 11346496.0 |
| 2004-01-30 14:00:00 | AAPL | Stock | 0.4043 | 0.4045 | 0.4005 | 0.4032 | 17504760.0 |
| 2004-01-30 15:00:00 | AAPL | Stock | 0.4034 | 0.4046 | 0.4004 | 0.4021 | 34727392.0 |
| 2004-01-30 16:00:00 | AAPL | Stock | 0.403 | 0.4036 | 0.4004 | 0.4021 | 2736888.0 |
| 2004-01-30 17:00:00 | AAPL | Stock | 0.4029 | 0.4029 | 0.4029 | 0.4029 | 628712.0 |
| 2004-01-30 08:00:00 | MSFT | Stock | 27.92 | 28.0 | 27.79 | 27.95 | 31116.0 |
| 2004-01-30 09:00:00 | MSFT | Stock | 27.98 | 28.0 | 27.71 | 27.739 | 3578350.0 |
| 2004-01-30 10:00:00 | MSFT | Stock | 27.73 | 27.9 | 27.67 | 27.78 | 6544210.0 |
| 2004-01-30 11:00:00 | MSFT | Stock | 27.78 | 27.81 | 27.65 | 27.73 | 5080054.0 |
| 2004-01-30 12:00:00 | MSFT | Stock | 27.73 | 27.77 | 27.64 | 27.7 | 3066915.0 |
| 2004-01-30 13:00:00 | MSFT | Stock | 27.7 | 27.76 | 27.66 | 27.68 | 2497224.0 |
| 2004-01-30 14:00:00 | MSFT | Stock | 27.67 | 27.7 | 27.58 | 27.6 | 6461914.0 |
| 2004-01-30 15:00:00 | MSFT | Stock | 27.6 | 27.68 | 27.55 | 27.636 | 8565164.0 |
| 2004-01-30 16:00:00 | MSFT | Stock | 27.62 | 27.7 | 27.594 | 27.62 | 1414832.0 |
| 2004-01-30 17:00:00 | MSFT | Stock | 27.65 | 27.7085 | 27.61 | 27.63 | 97316.0 |
| 2004-01-30 18:00:00 | MSFT | Stock | 27.61 | 27.65 | 27.61 | 27.61 | 2600.0 |
| 2004-01-30 08:00:00 | NVDA | Stock | 0.1825 | 0.1872 | 0.1825 | 0.1833 | 912000.0 |
| 2004-01-30 09:00:00 | NVDA | Stock | 0.1828 | 0.1849 | 0.1811 | 0.1837 | 55386480.0 |
| 2004-01-30 10:00:00 | NVDA | Stock | 0.1834 | 0.1842 | 0.1821 | 0.1835 | 94644480.0 |
| 2004-01-30 11:00:00 | NVDA | Stock | 0.1835 | 0.1882 | 0.1835 | 0.1879 | 84149280.0 |
| 2004-01-30 12:00:00 | NVDA | Stock | 0.1877 | 0.1891 | 0.1868 | 0.1886 | 44691120.0 |
| 2004-01-30 13:00:00 | NVDA | Stock | 0.1885 | 0.1896 | 0.1871 | 0.1871 | 49188120.0 |
| 2004-01-30 14:00:00 | NVDA | Stock | 0.1871 | 0.1873 | 0.1852 | 0.1863 | 65934960.0 |
| 2004-01-30 15:00:00 | NVDA | Stock | 0.1862 | 0.1868 | 0.1847 | 0.1853 | 54958560.0 |
| 2004-01-30 16:00:00 | NVDA | Stock | 0.1854 | 0.1855 | 0.185 | 0.1852 | 4431600.0 |
| 2004-01-30 17:00:00 | NVDA | Stock | 0.1852 | 0.1854 | 0.1852 | 0.1852 | 666240.0 |
| 2004-01-30 18:00:00 | NVDA | Stock | 0.1852 | 0.1852 | 0.1852 | 0.1852 | 96000.0 |
| 2004-01-30 08:00:00 | AMZN | Stock | 2.499 | 2.499 | 2.463 | 2.464 | 94000.0 |
| 2004-01-30 09:00:00 | AMZN | Stock | 2.475 | 2.5395 | 2.465 | 2.5175 | 45704120.0 |
| 2004-01-30 10:00:00 | AMZN | Stock | 2.519 | 2.5685 | 2.503 | 2.563 | 56825440.0 |
| 2004-01-30 11:00:00 | AMZN | Stock | 2.564 | 2.5645 | 2.535 | 2.542 | 25606460.0 |
| 2004-01-30 12:00:00 | AMZN | Stock | 2.542 | 2.546 | 2.525 | 2.534 | 18854980.0 |
| 2004-01-30 13:00:00 | AMZN | Stock | 2.535 | 2.539 | 2.5185 | 2.531 | 10177860.0 |
| 2004-01-30 14:00:00 | AMZN | Stock | 2.5305 | 2.531 | 2.4895 | 2.516 | 30909860.0 |
| 2004-01-30 15:00:00 | AMZN | Stock | 2.5155 | 2.5295 | 2.513 | 2.5195 | 25371220.0 |
| 2004-01-30 16:00:00 | AMZN | Stock | 2.52 | 2.525 | 2.514 | 2.524 | 2506140.0 |
| 2004-01-30 17:00:00 | AMZN | Stock | 2.524 | 2.524 | 2.515 | 2.524 | 274140.0 |
| 2004-01-30 09:00:00 | CL | Stock | 26.11 | 26.125 | 25.995 | 26.015 | 962800.0 |
| 2004-01-30 10:00:00 | CL | Stock | 26.015 | 26.08 | 25.96 | 26.05 | 1065600.0 |
| 2004-01-30 11:00:00 | CL | Stock | 26.045 | 26.05 | 25.885 | 25.89 | 588200.0 |
| 2004-01-30 12:00:00 | CL | Stock | 25.885 | 25.885 | 25.71 | 25.735 | 549200.0 |
| 2004-01-30 13:00:00 | CL | Stock | 25.735 | 25.805 | 25.7 | 25.705 | 435000.0 |
| 2004-01-30 14:00:00 | CL | Stock | 25.705 | 25.71 | 25.63 | 25.675 | 660000.0 |
| 2004-01-30 15:00:00 | CL | Stock | 25.69 | 25.7 | 25.58 | 25.65 | 1012600.0 |
| 2004-01-30 16:00:00 | CL | Stock | 25.635 | 25.85 | 25.635 | 25.635 | 421400.0 |
> showing 50 of 23,533 rows — these rows as CSV