PREVIEW / stock_1hour / 2004-12-13
file: by_date/stock_1hour/2004/2004-12-13.parquet size: 553 KB rows: 25,894 symbols: 1,893
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-12-13 08:00:00 | AAPL | Stock | 1.1639 | 1.1732 | 1.1639 | 1.1721 | 1249248.0 |
| 2004-12-13 09:00:00 | AAPL | Stock | 1.1714 | 1.1768 | 1.1618 | 1.1666 | 77512176.0 |
| 2004-12-13 10:00:00 | AAPL | Stock | 1.1663 | 1.1688 | 1.1563 | 1.1575 | 81144056.0 |
| 2004-12-13 11:00:00 | AAPL | Stock | 1.1575 | 1.1596 | 1.1536 | 1.1589 | 58399936.0 |
| 2004-12-13 12:00:00 | AAPL | Stock | 1.1588 | 1.1623 | 1.1574 | 1.1601 | 30414440.0 |
| 2004-12-13 13:00:00 | AAPL | Stock | 1.1602 | 1.162 | 1.158 | 1.1605 | 25603312.0 |
| 2004-12-13 14:00:00 | AAPL | Stock | 1.1604 | 1.1638 | 1.1579 | 1.1616 | 50234688.0 |
| 2004-12-13 15:00:00 | AAPL | Stock | 1.1616 | 1.1621 | 1.1564 | 1.1589 | 55734728.0 |
| 2004-12-13 16:00:00 | AAPL | Stock | 1.1596 | 1.1609 | 1.1573 | 1.1591 | 6641152.0 |
| 2004-12-13 17:00:00 | AAPL | Stock | 1.1593 | 1.1602 | 1.1588 | 1.1589 | 638344.0 |
| 2004-12-13 18:00:00 | AAPL | Stock | 1.1588 | 1.1588 | 1.1573 | 1.1588 | 75600.0 |
| 2004-12-13 08:00:00 | MSFT | Stock | 27.16 | 27.17 | 27.11 | 27.17 | 31331.0 |
| 2004-12-13 09:00:00 | MSFT | Stock | 27.16 | 27.25 | 27.07 | 27.16 | 8309460.0 |
| 2004-12-13 10:00:00 | MSFT | Stock | 27.16 | 27.2 | 27.06 | 27.07 | 12594899.0 |
| 2004-12-13 11:00:00 | MSFT | Stock | 27.071 | 27.08 | 26.93 | 27.03 | 12588730.0 |
| 2004-12-13 12:00:00 | MSFT | Stock | 27.04 | 27.07 | 26.91 | 26.94 | 9296021.0 |
| 2004-12-13 13:00:00 | MSFT | Stock | 26.94 | 27.02 | 26.91 | 26.99 | 8047744.0 |
| 2004-12-13 14:00:00 | MSFT | Stock | 26.99 | 27.1 | 26.98 | 27.08 | 11329654.0 |
| 2004-12-13 15:00:00 | MSFT | Stock | 27.08 | 27.28 | 27.05 | 27.25 | 18647633.0 |
| 2004-12-13 16:00:00 | MSFT | Stock | 27.26 | 27.307 | 27.21 | 27.24 | 8398765.0 |
| 2004-12-13 17:00:00 | MSFT | Stock | 27.21 | 27.2518 | 27.09 | 27.2 | 31350.0 |
| 2004-12-13 18:00:00 | MSFT | Stock | 27.24 | 27.24 | 27.19 | 27.19 | 2300.0 |
| 2004-12-13 08:00:00 | NVDA | Stock | 0.19 | 0.1931 | 0.1875 | 0.1901 | 2286600.0 |
| 2004-12-13 09:00:00 | NVDA | Stock | 0.1901 | 0.1936 | 0.188 | 0.1895 | 173552160.0 |
| 2004-12-13 10:00:00 | NVDA | Stock | 0.1895 | 0.1938 | 0.1891 | 0.1929 | 139445760.0 |
| 2004-12-13 11:00:00 | NVDA | Stock | 0.193 | 0.1931 | 0.1908 | 0.1912 | 59406000.0 |
| 2004-12-13 12:00:00 | NVDA | Stock | 0.1912 | 0.1917 | 0.1897 | 0.1899 | 57162360.0 |
| 2004-12-13 13:00:00 | NVDA | Stock | 0.1899 | 0.1901 | 0.1892 | 0.19 | 75071880.0 |
| 2004-12-13 14:00:00 | NVDA | Stock | 0.19 | 0.1902 | 0.1893 | 0.19 | 69984240.0 |
| 2004-12-13 15:00:00 | NVDA | Stock | 0.19 | 0.1901 | 0.1887 | 0.1889 | 137639640.0 |
| 2004-12-13 16:00:00 | NVDA | Stock | 0.1889 | 0.19 | 0.1888 | 0.19 | 12816480.0 |
| 2004-12-13 17:00:00 | NVDA | Stock | 0.1894 | 0.1902 | 0.1891 | 0.1891 | 516000.0 |
| 2004-12-13 08:00:00 | AMZN | Stock | 1.9515 | 1.9515 | 1.95 | 1.95 | 8000.0 |
| 2004-12-13 09:00:00 | AMZN | Stock | 1.9565 | 1.9754 | 1.941 | 1.962 | 15513300.0 |
| 2004-12-13 10:00:00 | AMZN | Stock | 1.962 | 1.977 | 1.9555 | 1.9725 | 17565100.0 |
| 2004-12-13 11:00:00 | AMZN | Stock | 1.972 | 1.9925 | 1.968 | 1.9915 | 16349360.0 |
| 2004-12-13 12:00:00 | AMZN | Stock | 1.991 | 2.002 | 1.989 | 1.9985 | 15327060.0 |
| 2004-12-13 13:00:00 | AMZN | Stock | 1.9985 | 2.014 | 1.99 | 2.002 | 20692900.0 |
| 2004-12-13 14:00:00 | AMZN | Stock | 2.002 | 2.007 | 1.9975 | 1.9995 | 11048940.0 |
| 2004-12-13 15:00:00 | AMZN | Stock | 1.9995 | 2.002 | 1.9836 | 1.9935 | 20312720.0 |
| 2004-12-13 16:00:00 | AMZN | Stock | 1.9935 | 1.9935 | 1.9905 | 1.9915 | 1168480.0 |
| 2004-12-13 17:00:00 | AMZN | Stock | 1.99 | 1.9915 | 1.9835 | 1.9915 | 298400.0 |
| 2004-12-13 09:00:00 | CL | Stock | 25.05 | 25.055 | 24.695 | 24.76 | 814000.0 |
| 2004-12-13 10:00:00 | CL | Stock | 24.77 | 25.015 | 24.735 | 24.905 | 1247400.0 |
| 2004-12-13 11:00:00 | CL | Stock | 24.905 | 24.985 | 24.88 | 24.94 | 1206600.0 |
| 2004-12-13 12:00:00 | CL | Stock | 24.93 | 24.98 | 24.92 | 24.955 | 814400.0 |
| 2004-12-13 13:00:00 | CL | Stock | 24.955 | 24.99 | 24.945 | 24.99 | 603200.0 |
| 2004-12-13 14:00:00 | CL | Stock | 24.975 | 25.015 | 24.95 | 24.96 | 1007600.0 |
| 2004-12-13 15:00:00 | CL | Stock | 24.96 | 25.065 | 24.955 | 25.02 | 1149200.0 |
| 2004-12-13 16:00:00 | CL | Stock | 25.035 | 25.035 | 25.01 | 25.035 | 2200.0 |
> showing 50 of 25,894 rows — these rows as CSV