PREVIEW / stock_1hour / 2009-03-12
file: by_date/stock_1hour/2009/2009-03-12.parquet size: 828 KB rows: 41,176 symbols: 3,318
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-12 04:00:00 | AAPL | Stock | 3.3186 | 3.3236 | 3.2946 | 3.2946 | 44800.0 |
| 2009-03-12 07:00:00 | AAPL | Stock | 3.2814 | 3.2943 | 3.2814 | 3.2893 | 51548.0 |
| 2009-03-12 08:00:00 | AAPL | Stock | 3.3068 | 3.3321 | 3.2904 | 3.3139 | 1078952.0 |
| 2009-03-12 09:00:00 | AAPL | Stock | 3.3161 | 3.3661 | 3.2857 | 3.3107 | 102495120.0 |
| 2009-03-12 10:00:00 | AAPL | Stock | 3.3114 | 3.3536 | 3.2971 | 3.3496 | 106485736.0 |
| 2009-03-12 11:00:00 | AAPL | Stock | 3.35 | 3.3857 | 3.3361 | 3.3764 | 86215836.0 |
| 2009-03-12 12:00:00 | AAPL | Stock | 3.3764 | 3.4196 | 3.3704 | 3.4168 | 115797164.0 |
| 2009-03-12 13:00:00 | AAPL | Stock | 3.4171 | 3.4286 | 3.4 | 3.4143 | 75824476.0 |
| 2009-03-12 14:00:00 | AAPL | Stock | 3.4141 | 3.4321 | 3.3982 | 3.4144 | 94845828.0 |
| 2009-03-12 15:00:00 | AAPL | Stock | 3.4146 | 3.4493 | 3.3961 | 3.4407 | 158096652.0 |
| 2009-03-12 16:00:00 | AAPL | Stock | 3.44 | 3.4598 | 3.3388 | 3.4411 | 21110180.0 |
| 2009-03-12 17:00:00 | AAPL | Stock | 3.4289 | 3.445 | 3.4286 | 3.4393 | 244076.0 |
| 2009-03-12 18:00:00 | AAPL | Stock | 3.4393 | 3.4439 | 3.4339 | 3.4393 | 723912.0 |
| 2009-03-12 19:00:00 | AAPL | Stock | 3.4375 | 3.4443 | 3.4293 | 3.4293 | 310436.0 |
| 2009-03-12 06:00:00 | MSFT | Stock | 16.91 | 16.91 | 16.91 | 16.91 | 300.0 |
| 2009-03-12 08:00:00 | MSFT | Stock | 17.0 | 17.03 | 16.86 | 17.03 | 54730.0 |
| 2009-03-12 09:00:00 | MSFT | Stock | 17.03 | 17.09 | 16.55 | 16.6 | 8087223.0 |
| 2009-03-12 10:00:00 | MSFT | Stock | 16.6 | 16.74 | 16.5 | 16.66 | 15444390.0 |
| 2009-03-12 11:00:00 | MSFT | Stock | 16.66 | 16.66 | 16.54 | 16.57 | 7650872.0 |
| 2009-03-12 12:00:00 | MSFT | Stock | 16.57 | 16.72 | 16.48 | 16.69 | 8912631.0 |
| 2009-03-12 13:00:00 | MSFT | Stock | 16.69 | 16.76 | 16.65 | 16.69 | 8838853.0 |
| 2009-03-12 14:00:00 | MSFT | Stock | 16.68 | 16.95 | 16.65 | 16.84 | 10333887.0 |
| 2009-03-12 15:00:00 | MSFT | Stock | 16.84 | 17.01 | 16.76 | 17.01 | 29619269.0 |
| 2009-03-12 16:00:00 | MSFT | Stock | 17.01 | 17.01 | 16.555 | 17.01 | 3175662.0 |
| 2009-03-12 17:00:00 | MSFT | Stock | 16.93 | 17.0 | 16.52 | 16.98 | 97119.0 |
| 2009-03-12 18:00:00 | MSFT | Stock | 16.98 | 17.01 | 16.97 | 17.0 | 61054.0 |
| 2009-03-12 19:00:00 | MSFT | Stock | 17.0 | 17.02 | 16.91 | 16.91 | 22349.0 |
| 2009-03-12 08:00:00 | NVDA | Stock | 0.2265 | 0.2265 | 0.2265 | 0.2265 | 20000.0 |
| 2009-03-12 09:00:00 | NVDA | Stock | 0.2318 | 0.2342 | 0.2288 | 0.2312 | 117107400.0 |
| 2009-03-12 10:00:00 | NVDA | Stock | 0.2312 | 0.247 | 0.2308 | 0.2435 | 270553920.0 |
| 2009-03-12 11:00:00 | NVDA | Stock | 0.2432 | 0.2473 | 0.239 | 0.2462 | 367469320.0 |
| 2009-03-12 12:00:00 | NVDA | Stock | 0.2465 | 0.2475 | 0.244 | 0.246 | 125543800.0 |
| 2009-03-12 13:00:00 | NVDA | Stock | 0.246 | 0.248 | 0.2448 | 0.2458 | 194040280.0 |
| 2009-03-12 14:00:00 | NVDA | Stock | 0.2458 | 0.2488 | 0.2445 | 0.2458 | 225569560.0 |
| 2009-03-12 15:00:00 | NVDA | Stock | 0.2458 | 0.2473 | 0.2442 | 0.2462 | 274840680.0 |
| 2009-03-12 16:00:00 | NVDA | Stock | 0.246 | 0.248 | 0.2434 | 0.2462 | 17446680.0 |
| 2009-03-12 17:00:00 | NVDA | Stock | 0.246 | 0.2468 | 0.2422 | 0.246 | 1614080.0 |
| 2009-03-12 18:00:00 | NVDA | Stock | 0.242 | 0.242 | 0.2412 | 0.2412 | 120000.0 |
| 2009-03-12 19:00:00 | NVDA | Stock | 0.2415 | 0.2415 | 0.2415 | 0.2415 | 22400.0 |
| 2009-03-12 07:00:00 | AMZN | Stock | 3.4125 | 3.4125 | 3.395 | 3.395 | 60000.0 |
| 2009-03-12 08:00:00 | AMZN | Stock | 3.4 | 3.4295 | 3.3875 | 3.4145 | 208020.0 |
| 2009-03-12 09:00:00 | AMZN | Stock | 3.4245 | 3.4565 | 3.382 | 3.4 | 25864640.0 |
| 2009-03-12 10:00:00 | AMZN | Stock | 3.4 | 3.449 | 3.3625 | 3.435 | 40601920.0 |
| 2009-03-12 11:00:00 | AMZN | Stock | 3.4345 | 3.4425 | 3.397 | 3.423 | 28572800.0 |
| 2009-03-12 12:00:00 | AMZN | Stock | 3.4245 | 3.445 | 3.407 | 3.423 | 21947100.0 |
| 2009-03-12 13:00:00 | AMZN | Stock | 3.423 | 3.4385 | 3.4015 | 3.4125 | 23748940.0 |
| 2009-03-12 14:00:00 | AMZN | Stock | 3.413 | 3.4605 | 3.3975 | 3.437 | 31149680.0 |
| 2009-03-12 15:00:00 | AMZN | Stock | 3.438 | 3.4935 | 3.43 | 3.48 | 44624080.0 |
| 2009-03-12 16:00:00 | AMZN | Stock | 3.48 | 3.49 | 3.4286 | 3.479 | 6440180.0 |
| 2009-03-12 17:00:00 | AMZN | Stock | 3.479 | 3.479 | 3.422 | 3.479 | 24000.0 |
> showing 50 of 41,176 rows — these rows as CSV