PREVIEW / stock_1hour / 2004-03-30
file: by_date/stock_1hour/2004/2004-03-30.parquet size: 514 KB rows: 23,962 symbols: 1,748
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-03-30 08:00:00 | AAPL | Stock | 0.5013 | 0.5036 | 0.4863 | 0.4973 | 78400.0 |
| 2004-03-30 09:00:00 | AAPL | Stock | 0.4959 | 0.4991 | 0.4946 | 0.4968 | 32408152.0 |
| 2004-03-30 10:00:00 | AAPL | Stock | 0.4968 | 0.4975 | 0.4929 | 0.4957 | 82490968.0 |
| 2004-03-30 11:00:00 | AAPL | Stock | 0.4957 | 0.4966 | 0.4914 | 0.4918 | 59627344.0 |
| 2004-03-30 12:00:00 | AAPL | Stock | 0.4918 | 0.4929 | 0.4882 | 0.4889 | 31724560.0 |
| 2004-03-30 13:00:00 | AAPL | Stock | 0.489 | 0.4932 | 0.4889 | 0.4927 | 38890040.0 |
| 2004-03-30 14:00:00 | AAPL | Stock | 0.4929 | 0.495 | 0.4905 | 0.4946 | 32268544.0 |
| 2004-03-30 15:00:00 | AAPL | Stock | 0.4946 | 0.4986 | 0.4943 | 0.498 | 56949032.0 |
| 2004-03-30 16:00:00 | AAPL | Stock | 0.498 | 0.4988 | 0.4966 | 0.4986 | 10934224.0 |
| 2004-03-30 17:00:00 | AAPL | Stock | 0.4986 | 0.4986 | 0.4986 | 0.4986 | 22400.0 |
| 2004-03-30 18:00:00 | AAPL | Stock | 0.4975 | 0.4975 | 0.4975 | 0.4975 | 28000.0 |
| 2004-03-30 08:00:00 | MSFT | Stock | 25.29 | 25.29 | 25.17 | 25.22 | 6050.0 |
| 2004-03-30 09:00:00 | MSFT | Stock | 25.22 | 25.31 | 25.15 | 25.29 | 6077811.0 |
| 2004-03-30 10:00:00 | MSFT | Stock | 25.29 | 25.33 | 25.22 | 25.28 | 7438867.0 |
| 2004-03-30 11:00:00 | MSFT | Stock | 25.28 | 25.28 | 25.16 | 25.16 | 7048525.0 |
| 2004-03-30 12:00:00 | MSFT | Stock | 25.16 | 25.2 | 25.03 | 25.09 | 5840586.0 |
| 2004-03-30 13:00:00 | MSFT | Stock | 25.08 | 25.16 | 25.07 | 25.14 | 6736784.0 |
| 2004-03-30 14:00:00 | MSFT | Stock | 25.15 | 25.18 | 25.08 | 25.12 | 9475699.0 |
| 2004-03-30 15:00:00 | MSFT | Stock | 25.13 | 25.21 | 25.09 | 25.19 | 13431738.0 |
| 2004-03-30 16:00:00 | MSFT | Stock | 25.2 | 25.23 | 25.102 | 25.2 | 685897.0 |
| 2004-03-30 17:00:00 | MSFT | Stock | 25.21 | 25.21 | 25.18 | 25.21 | 3900.0 |
| 2004-03-30 18:00:00 | MSFT | Stock | 25.21 | 25.21 | 25.21 | 25.21 | 3200.0 |
| 2004-03-30 08:00:00 | NVDA | Stock | 0.2108 | 0.2108 | 0.2102 | 0.2104 | 492000.0 |
| 2004-03-30 09:00:00 | NVDA | Stock | 0.2107 | 0.2146 | 0.2101 | 0.2134 | 96193200.0 |
| 2004-03-30 10:00:00 | NVDA | Stock | 0.2134 | 0.2143 | 0.2117 | 0.2139 | 96897240.0 |
| 2004-03-30 11:00:00 | NVDA | Stock | 0.2138 | 0.2146 | 0.2133 | 0.2139 | 61125480.0 |
| 2004-03-30 12:00:00 | NVDA | Stock | 0.2139 | 0.215 | 0.2122 | 0.2137 | 91332360.0 |
| 2004-03-30 13:00:00 | NVDA | Stock | 0.2136 | 0.2162 | 0.2134 | 0.2157 | 44988480.0 |
| 2004-03-30 14:00:00 | NVDA | Stock | 0.2157 | 0.2175 | 0.2151 | 0.2173 | 106103760.0 |
| 2004-03-30 15:00:00 | NVDA | Stock | 0.2174 | 0.2187 | 0.2164 | 0.2179 | 159166680.0 |
| 2004-03-30 16:00:00 | NVDA | Stock | 0.218 | 0.2206 | 0.2174 | 0.2192 | 43673880.0 |
| 2004-03-30 17:00:00 | NVDA | Stock | 0.2189 | 0.2199 | 0.2189 | 0.2199 | 251400.0 |
| 2004-03-30 18:00:00 | NVDA | Stock | 0.2192 | 0.2198 | 0.2191 | 0.2198 | 235800.0 |
| 2004-03-30 08:00:00 | AMZN | Stock | 2.138 | 2.138 | 2.126 | 2.13 | 173700.0 |
| 2004-03-30 09:00:00 | AMZN | Stock | 2.13 | 2.1575 | 2.128 | 2.1575 | 15670400.0 |
| 2004-03-30 10:00:00 | AMZN | Stock | 2.1575 | 2.165 | 2.1395 | 2.1575 | 20826640.0 |
| 2004-03-30 11:00:00 | AMZN | Stock | 2.157 | 2.159 | 2.148 | 2.15 | 12142180.0 |
| 2004-03-30 12:00:00 | AMZN | Stock | 2.1505 | 2.1575 | 2.1455 | 2.15 | 9436020.0 |
| 2004-03-30 13:00:00 | AMZN | Stock | 2.15 | 2.165 | 2.15 | 2.163 | 6696840.0 |
| 2004-03-30 14:00:00 | AMZN | Stock | 2.163 | 2.187 | 2.1585 | 2.183 | 13597100.0 |
| 2004-03-30 15:00:00 | AMZN | Stock | 2.183 | 2.1965 | 2.1795 | 2.1895 | 24827020.0 |
| 2004-03-30 16:00:00 | AMZN | Stock | 2.19 | 2.1935 | 2.1865 | 2.1935 | 923680.0 |
| 2004-03-30 17:00:00 | AMZN | Stock | 2.1935 | 2.1935 | 2.19 | 2.1935 | 296560.0 |
| 2004-03-30 18:00:00 | AMZN | Stock | 2.193 | 2.1935 | 2.193 | 2.1935 | 59000.0 |
| 2004-03-30 09:00:00 | CL | Stock | 27.65 | 27.875 | 27.635 | 27.875 | 360000.0 |
| 2004-03-30 10:00:00 | CL | Stock | 27.875 | 27.94 | 27.85 | 27.86 | 757000.0 |
| 2004-03-30 11:00:00 | CL | Stock | 27.855 | 27.925 | 27.835 | 27.895 | 293800.0 |
| 2004-03-30 12:00:00 | CL | Stock | 27.895 | 27.955 | 27.88 | 27.95 | 352800.0 |
| 2004-03-30 13:00:00 | CL | Stock | 27.95 | 27.965 | 27.91 | 27.955 | 271200.0 |
| 2004-03-30 14:00:00 | CL | Stock | 27.96 | 28.075 | 27.95 | 27.98 | 902000.0 |
> showing 50 of 23,962 rows — these rows as CSV