PREVIEW / stock_1hour / 2009-03-05
file: by_date/stock_1hour/2009/2009-03-05.parquet size: 836 KB rows: 41,780 symbols: 3,351
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-03-05 04:00:00 | AAPL | Stock | 3.2414 | 3.2414 | 3.2414 | 3.2414 | 16800.0 |
| 2009-03-05 06:00:00 | AAPL | Stock | 3.2336 | 3.2336 | 3.2107 | 3.2107 | 28000.0 |
| 2009-03-05 07:00:00 | AAPL | Stock | 3.2107 | 3.2143 | 3.2107 | 3.2107 | 42000.0 |
| 2009-03-05 08:00:00 | AAPL | Stock | 3.2125 | 3.2357 | 3.2125 | 3.225 | 1449700.0 |
| 2009-03-05 09:00:00 | AAPL | Stock | 3.225 | 3.2811 | 3.2204 | 3.2568 | 76856752.0 |
| 2009-03-05 10:00:00 | AAPL | Stock | 3.2564 | 3.2786 | 3.1875 | 3.1911 | 122987648.0 |
| 2009-03-05 11:00:00 | AAPL | Stock | 3.1911 | 3.2179 | 3.175 | 3.1875 | 90049260.0 |
| 2009-03-05 12:00:00 | AAPL | Stock | 3.1868 | 3.2007 | 3.1589 | 3.1789 | 65605456.0 |
| 2009-03-05 13:00:00 | AAPL | Stock | 3.1782 | 3.2125 | 3.1761 | 3.1957 | 72379804.0 |
| 2009-03-05 14:00:00 | AAPL | Stock | 3.1968 | 3.1986 | 3.16 | 3.1682 | 81813676.0 |
| 2009-03-05 15:00:00 | AAPL | Stock | 3.1686 | 3.2179 | 3.1589 | 3.1775 | 160392624.0 |
| 2009-03-05 16:00:00 | AAPL | Stock | 3.1761 | 3.2013 | 3.1729 | 3.1814 | 22187340.0 |
| 2009-03-05 17:00:00 | AAPL | Stock | 3.1796 | 3.1854 | 3.1729 | 3.1854 | 5087124.0 |
| 2009-03-05 18:00:00 | AAPL | Stock | 3.1676 | 3.2045 | 3.1676 | 3.1714 | 1087856.0 |
| 2009-03-05 19:00:00 | AAPL | Stock | 3.1718 | 3.1718 | 3.1696 | 3.1696 | 117236.0 |
| 2009-03-05 20:00:00 | AAPL | Stock | 3.2289 | 3.2289 | 3.2289 | 3.2289 | 453600.0 |
| 2009-03-05 06:00:00 | MSFT | Stock | 15.94 | 15.94 | 15.8 | 15.8 | 2500.0 |
| 2009-03-05 07:00:00 | MSFT | Stock | 15.88 | 15.95 | 15.81 | 15.91 | 8000.0 |
| 2009-03-05 08:00:00 | MSFT | Stock | 15.94 | 15.99 | 15.87 | 15.9 | 108489.0 |
| 2009-03-05 09:00:00 | MSFT | Stock | 15.94 | 15.99 | 15.74 | 15.79 | 6413612.0 |
| 2009-03-05 10:00:00 | MSFT | Stock | 15.8 | 15.86 | 15.57 | 15.58 | 10759861.0 |
| 2009-03-05 11:00:00 | MSFT | Stock | 15.58 | 15.71 | 15.52 | 15.56 | 7332357.0 |
| 2009-03-05 12:00:00 | MSFT | Stock | 15.552 | 15.58 | 15.41 | 15.46 | 7073474.0 |
| 2009-03-05 13:00:00 | MSFT | Stock | 15.45 | 15.63 | 15.44 | 15.51 | 7866688.0 |
| 2009-03-05 14:00:00 | MSFT | Stock | 15.51 | 15.52 | 15.33 | 15.42 | 12223948.0 |
| 2009-03-05 15:00:00 | MSFT | Stock | 15.42 | 15.6 | 15.28 | 15.29 | 24712594.0 |
| 2009-03-05 16:00:00 | MSFT | Stock | 15.3 | 15.75 | 15.27 | 15.31 | 7313729.0 |
| 2009-03-05 17:00:00 | MSFT | Stock | 15.33 | 15.37 | 15.27 | 15.37 | 1305557.0 |
| 2009-03-05 18:00:00 | MSFT | Stock | 15.36 | 15.566 | 15.27 | 15.34 | 363323.0 |
| 2009-03-05 19:00:00 | MSFT | Stock | 15.34 | 15.37 | 15.31 | 15.36 | 9696.0 |
| 2009-03-05 20:00:00 | MSFT | Stock | 15.55 | 15.55 | 15.55 | 15.55 | 29400.0 |
| 2009-03-05 08:00:00 | NVDA | Stock | 0.2125 | 0.2125 | 0.2125 | 0.2125 | 20000.0 |
| 2009-03-05 09:00:00 | NVDA | Stock | 0.2085 | 0.214 | 0.2055 | 0.2128 | 104442200.0 |
| 2009-03-05 10:00:00 | NVDA | Stock | 0.213 | 0.217 | 0.211 | 0.2115 | 142613120.0 |
| 2009-03-05 11:00:00 | NVDA | Stock | 0.2115 | 0.214 | 0.2108 | 0.2138 | 116256880.0 |
| 2009-03-05 12:00:00 | NVDA | Stock | 0.2138 | 0.2145 | 0.2112 | 0.2118 | 134537760.0 |
| 2009-03-05 13:00:00 | NVDA | Stock | 0.2115 | 0.2122 | 0.2088 | 0.2092 | 88945480.0 |
| 2009-03-05 14:00:00 | NVDA | Stock | 0.2092 | 0.2092 | 0.2058 | 0.2065 | 100861640.0 |
| 2009-03-05 15:00:00 | NVDA | Stock | 0.2065 | 0.21 | 0.206 | 0.2065 | 233673640.0 |
| 2009-03-05 16:00:00 | NVDA | Stock | 0.207 | 0.2106 | 0.2065 | 0.2065 | 7426200.0 |
| 2009-03-05 17:00:00 | NVDA | Stock | 0.2065 | 0.2065 | 0.2065 | 0.2065 | 3649240.0 |
| 2009-03-05 18:00:00 | NVDA | Stock | 0.2038 | 0.2105 | 0.2038 | 0.2105 | 606240.0 |
| 2009-03-05 05:00:00 | AMZN | Stock | 3.2 | 3.2 | 3.2 | 3.2 | 4000.0 |
| 2009-03-05 06:00:00 | AMZN | Stock | 3.175 | 3.175 | 3.175 | 3.175 | 10000.0 |
| 2009-03-05 08:00:00 | AMZN | Stock | 3.2215 | 3.2215 | 3.1985 | 3.2005 | 172820.0 |
| 2009-03-05 09:00:00 | AMZN | Stock | 3.205 | 3.275 | 3.2 | 3.241 | 22733280.0 |
| 2009-03-05 10:00:00 | AMZN | Stock | 3.243 | 3.29 | 3.2235 | 3.2705 | 42867340.0 |
| 2009-03-05 11:00:00 | AMZN | Stock | 3.2715 | 3.279 | 3.1875 | 3.195 | 32214580.0 |
| 2009-03-05 12:00:00 | AMZN | Stock | 3.1951 | 3.235 | 3.18 | 3.2101 | 21998080.0 |
| 2009-03-05 13:00:00 | AMZN | Stock | 3.2095 | 3.263 | 3.204 | 3.2565 | 26899700.0 |
> showing 50 of 41,780 rows — these rows as CSV