PREVIEW / stock_1hour / 2004-12-01
file: by_date/stock_1hour/2004/2004-12-01.parquet size: 561 KB rows: 27,166 symbols: 1,895
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-01 08:00:00 | AAPL | Stock | 1.2054 | 1.2095 | 1.1973 | 1.2043 | 2034592.0 |
| 2004-12-01 09:00:00 | AAPL | Stock | 1.2018 | 1.2134 | 1.1834 | 1.2006 | 199845240.0 |
| 2004-12-01 10:00:00 | AAPL | Stock | 1.2005 | 1.2025 | 1.1873 | 1.1938 | 160158600.0 |
| 2004-12-01 11:00:00 | AAPL | Stock | 1.1934 | 1.2036 | 1.1923 | 1.2004 | 90216672.0 |
| 2004-12-01 12:00:00 | AAPL | Stock | 1.2002 | 1.2057 | 1.1945 | 1.203 | 59286696.0 |
| 2004-12-01 13:00:00 | AAPL | Stock | 1.203 | 1.2098 | 1.2004 | 1.2013 | 56173824.0 |
| 2004-12-01 14:00:00 | AAPL | Stock | 1.2013 | 1.2023 | 1.1975 | 1.2011 | 43432928.0 |
| 2004-12-01 15:00:00 | AAPL | Stock | 1.2009 | 1.2105 | 1.1993 | 1.2105 | 162869896.0 |
| 2004-12-01 16:00:00 | AAPL | Stock | 1.2105 | 1.2107 | 1.2071 | 1.2105 | 8038408.0 |
| 2004-12-01 17:00:00 | AAPL | Stock | 1.2088 | 1.2105 | 1.2079 | 1.2095 | 570360.0 |
| 2004-12-01 18:00:00 | AAPL | Stock | 1.2096 | 1.2111 | 1.2096 | 1.2111 | 271600.0 |
| 2004-12-01 08:00:00 | MSFT | Stock | 26.98 | 27.05 | 26.95 | 26.98 | 180470.0 |
| 2004-12-01 09:00:00 | MSFT | Stock | 26.97 | 27.04 | 26.9 | 26.99 | 11033284.0 |
| 2004-12-01 10:00:00 | MSFT | Stock | 26.99 | 27.04 | 26.95 | 26.98 | 17691937.0 |
| 2004-12-01 11:00:00 | MSFT | Stock | 26.98 | 27.05 | 26.95 | 27.03 | 11564017.0 |
| 2004-12-01 12:00:00 | MSFT | Stock | 27.03 | 27.15 | 27.0 | 27.09 | 14696654.0 |
| 2004-12-01 13:00:00 | MSFT | Stock | 27.1 | 27.14 | 27.06 | 27.11 | 11346211.0 |
| 2004-12-01 14:00:00 | MSFT | Stock | 27.11 | 27.22 | 27.09 | 27.2 | 9269931.0 |
| 2004-12-01 15:00:00 | MSFT | Stock | 27.2 | 27.28 | 27.19 | 27.24 | 18122532.0 |
| 2004-12-01 16:00:00 | MSFT | Stock | 27.24 | 27.25 | 27.07 | 27.21 | 1878886.0 |
| 2004-12-01 17:00:00 | MSFT | Stock | 27.22 | 27.25 | 27.0893 | 27.25 | 1070847.0 |
| 2004-12-01 18:00:00 | MSFT | Stock | 27.24 | 27.24 | 27.23 | 27.24 | 5312.0 |
| 2004-12-01 08:00:00 | NVDA | Stock | 0.1613 | 0.1613 | 0.1595 | 0.1595 | 1068000.0 |
| 2004-12-01 09:00:00 | NVDA | Stock | 0.1613 | 0.1629 | 0.1594 | 0.1602 | 64099320.0 |
| 2004-12-01 10:00:00 | NVDA | Stock | 0.1602 | 0.1612 | 0.1597 | 0.1611 | 87902400.0 |
| 2004-12-01 11:00:00 | NVDA | Stock | 0.1611 | 0.1633 | 0.161 | 0.1618 | 85985160.0 |
| 2004-12-01 12:00:00 | NVDA | Stock | 0.1617 | 0.1627 | 0.1617 | 0.1621 | 44374800.0 |
| 2004-12-01 13:00:00 | NVDA | Stock | 0.162 | 0.1626 | 0.1617 | 0.1623 | 34530000.0 |
| 2004-12-01 14:00:00 | NVDA | Stock | 0.1623 | 0.1625 | 0.1616 | 0.1623 | 58880880.0 |
| 2004-12-01 15:00:00 | NVDA | Stock | 0.1622 | 0.1633 | 0.1621 | 0.1632 | 92562000.0 |
| 2004-12-01 16:00:00 | NVDA | Stock | 0.1633 | 0.1635 | 0.1626 | 0.1631 | 6423480.0 |
| 2004-12-01 17:00:00 | NVDA | Stock | 0.163 | 0.163 | 0.163 | 0.163 | 16560.0 |
| 2004-12-01 18:00:00 | NVDA | Stock | 0.1633 | 0.1633 | 0.1633 | 0.1633 | 30000.0 |
| 2004-12-01 08:00:00 | AMZN | Stock | 1.995 | 1.999 | 1.984 | 1.995 | 315000.0 |
| 2004-12-01 09:00:00 | AMZN | Stock | 1.9985 | 2.0 | 1.973 | 1.975 | 27756820.0 |
| 2004-12-01 10:00:00 | AMZN | Stock | 1.9765 | 1.986 | 1.9625 | 1.979 | 33735920.0 |
| 2004-12-01 11:00:00 | AMZN | Stock | 1.979 | 1.99 | 1.972 | 1.9864 | 31429240.0 |
| 2004-12-01 12:00:00 | AMZN | Stock | 1.9865 | 1.99 | 1.981 | 1.981 | 11225180.0 |
| 2004-12-01 13:00:00 | AMZN | Stock | 1.982 | 1.99 | 1.9755 | 1.977 | 12571300.0 |
| 2004-12-01 14:00:00 | AMZN | Stock | 1.9775 | 1.9825 | 1.9705 | 1.9825 | 11593940.0 |
| 2004-12-01 15:00:00 | AMZN | Stock | 1.983 | 1.9925 | 1.983 | 1.987 | 21689960.0 |
| 2004-12-01 16:00:00 | AMZN | Stock | 1.9895 | 1.999 | 1.985 | 1.9875 | 2006140.0 |
| 2004-12-01 17:00:00 | AMZN | Stock | 1.9905 | 1.992 | 1.9905 | 1.992 | 129380.0 |
| 2004-12-01 18:00:00 | AMZN | Stock | 1.989 | 1.991 | 1.989 | 1.991 | 131600.0 |
| 2004-12-01 09:00:00 | CL | Stock | 23.11 | 23.225 | 23.075 | 23.12 | 553800.0 |
| 2004-12-01 10:00:00 | CL | Stock | 23.125 | 23.225 | 23.115 | 23.18 | 668200.0 |
| 2004-12-01 11:00:00 | CL | Stock | 23.18 | 23.275 | 23.18 | 23.235 | 825400.0 |
| 2004-12-01 12:00:00 | CL | Stock | 23.245 | 23.275 | 23.22 | 23.25 | 258400.0 |
| 2004-12-01 13:00:00 | CL | Stock | 23.25 | 23.275 | 23.25 | 23.265 | 302400.0 |
| 2004-12-01 14:00:00 | CL | Stock | 23.265 | 23.345 | 23.25 | 23.34 | 447400.0 |
> showing 50 of 27,166 rows — these rows as CSV