PREVIEW / stock_1hour / 2009-03-18
file: by_date/stock_1hour/2009/2009-03-18.parquet size: 807 KB rows: 40,067 symbols: 3,338
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-18 05:00:00 | AAPL | Stock | 3.55 | 3.55 | 3.55 | 3.55 | 5600.0 |
| 2009-03-18 06:00:00 | AAPL | Stock | 3.5525 | 3.5525 | 3.5525 | 3.5525 | 5600.0 |
| 2009-03-18 07:00:00 | AAPL | Stock | 3.5496 | 3.5625 | 3.5486 | 3.5625 | 18396.0 |
| 2009-03-18 08:00:00 | AAPL | Stock | 3.545 | 3.5864 | 3.5268 | 3.5786 | 2930536.0 |
| 2009-03-18 09:00:00 | AAPL | Stock | 3.5757 | 3.6543 | 3.5536 | 3.6279 | 146899788.0 |
| 2009-03-18 10:00:00 | AAPL | Stock | 3.6275 | 3.6389 | 3.5614 | 3.5825 | 126470848.0 |
| 2009-03-18 11:00:00 | AAPL | Stock | 3.5829 | 3.5996 | 3.5714 | 3.5932 | 63122696.0 |
| 2009-03-18 12:00:00 | AAPL | Stock | 3.5936 | 3.6393 | 3.5932 | 3.6318 | 61153036.0 |
| 2009-03-18 13:00:00 | AAPL | Stock | 3.6318 | 3.6389 | 3.6079 | 3.6236 | 48579916.0 |
| 2009-03-18 14:00:00 | AAPL | Stock | 3.6236 | 3.6957 | 3.6129 | 3.6893 | 153047160.0 |
| 2009-03-18 15:00:00 | AAPL | Stock | 3.6904 | 3.6921 | 3.6036 | 3.6271 | 163623992.0 |
| 2009-03-18 16:00:00 | AAPL | Stock | 3.6271 | 3.6444 | 3.5754 | 3.6232 | 16228324.0 |
| 2009-03-18 17:00:00 | AAPL | Stock | 3.6229 | 3.6282 | 3.6146 | 3.615 | 186704.0 |
| 2009-03-18 18:00:00 | AAPL | Stock | 3.6214 | 3.6257 | 3.6143 | 3.6164 | 184632.0 |
| 2009-03-18 19:00:00 | AAPL | Stock | 3.6171 | 3.6207 | 3.61 | 3.62 | 139216.0 |
| 2009-03-18 07:00:00 | MSFT | Stock | 16.97 | 16.97 | 16.9 | 16.9 | 3100.0 |
| 2009-03-18 08:00:00 | MSFT | Stock | 16.9 | 16.95 | 16.88 | 16.89 | 42262.0 |
| 2009-03-18 09:00:00 | MSFT | Stock | 16.85 | 17.04 | 16.68 | 16.81 | 4967304.0 |
| 2009-03-18 10:00:00 | MSFT | Stock | 16.81 | 16.89 | 16.64 | 16.75 | 6037875.0 |
| 2009-03-18 11:00:00 | MSFT | Stock | 16.75 | 16.76 | 16.6 | 16.66 | 5311631.0 |
| 2009-03-18 12:00:00 | MSFT | Stock | 16.67 | 16.76 | 16.64 | 16.73 | 5178378.0 |
| 2009-03-18 13:00:00 | MSFT | Stock | 16.74 | 16.79 | 16.64 | 16.732 | 6255786.0 |
| 2009-03-18 14:00:00 | MSFT | Stock | 16.74 | 17.22 | 16.67 | 17.18 | 18328186.0 |
| 2009-03-18 15:00:00 | MSFT | Stock | 17.18 | 17.19 | 16.79 | 16.96 | 18770148.0 |
| 2009-03-18 16:00:00 | MSFT | Stock | 16.97 | 17.17 | 16.615 | 17.05 | 4909492.0 |
| 2009-03-18 17:00:00 | MSFT | Stock | 17.1 | 17.17 | 17.1 | 17.12 | 34180.0 |
| 2009-03-18 18:00:00 | MSFT | Stock | 17.11 | 17.17 | 16.96 | 17.17 | 44787.0 |
| 2009-03-18 19:00:00 | MSFT | Stock | 17.14 | 17.17 | 17.08 | 17.14 | 6810.0 |
| 2009-03-18 08:00:00 | NVDA | Stock | 0.2435 | 0.2435 | 0.2435 | 0.2435 | 40000.0 |
| 2009-03-18 09:00:00 | NVDA | Stock | 0.2432 | 0.257 | 0.243 | 0.2547 | 193223160.0 |
| 2009-03-18 10:00:00 | NVDA | Stock | 0.2547 | 0.2575 | 0.2503 | 0.255 | 281679760.0 |
| 2009-03-18 11:00:00 | NVDA | Stock | 0.255 | 0.2553 | 0.2493 | 0.252 | 106496040.0 |
| 2009-03-18 12:00:00 | NVDA | Stock | 0.2519 | 0.253 | 0.25 | 0.2515 | 84283080.0 |
| 2009-03-18 13:00:00 | NVDA | Stock | 0.2515 | 0.2563 | 0.2503 | 0.2554 | 118183080.0 |
| 2009-03-18 14:00:00 | NVDA | Stock | 0.2553 | 0.2623 | 0.255 | 0.2583 | 275723320.0 |
| 2009-03-18 15:00:00 | NVDA | Stock | 0.2583 | 0.259 | 0.2513 | 0.255 | 278579480.0 |
| 2009-03-18 16:00:00 | NVDA | Stock | 0.255 | 0.255 | 0.2533 | 0.255 | 18844040.0 |
| 2009-03-18 17:00:00 | NVDA | Stock | 0.254 | 0.255 | 0.254 | 0.255 | 12000.0 |
| 2009-03-18 19:00:00 | NVDA | Stock | 0.256 | 0.256 | 0.256 | 0.256 | 20000.0 |
| 2009-03-18 08:00:00 | AMZN | Stock | 3.558 | 3.558 | 3.5325 | 3.543 | 165000.0 |
| 2009-03-18 09:00:00 | AMZN | Stock | 3.539 | 3.575 | 3.5065 | 3.542 | 23889700.0 |
| 2009-03-18 10:00:00 | AMZN | Stock | 3.542 | 3.564 | 3.5105 | 3.5485 | 29669240.0 |
| 2009-03-18 11:00:00 | AMZN | Stock | 3.547 | 3.5725 | 3.536 | 3.5675 | 17984540.0 |
| 2009-03-18 12:00:00 | AMZN | Stock | 3.5675 | 3.589 | 3.556 | 3.5855 | 16385540.0 |
| 2009-03-18 13:00:00 | AMZN | Stock | 3.5855 | 3.5935 | 3.563 | 3.5815 | 10721020.0 |
| 2009-03-18 14:00:00 | AMZN | Stock | 3.581 | 3.6955 | 3.5695 | 3.68 | 41977900.0 |
| 2009-03-18 15:00:00 | AMZN | Stock | 3.68 | 3.687 | 3.557 | 3.5625 | 62492840.0 |
| 2009-03-18 16:00:00 | AMZN | Stock | 3.5625 | 3.6134 | 3.56 | 3.5625 | 3304040.0 |
| 2009-03-18 17:00:00 | AMZN | Stock | 3.575 | 3.577 | 3.575 | 3.577 | 13600.0 |
| 2009-03-18 18:00:00 | AMZN | Stock | 3.5795 | 3.58 | 3.5575 | 3.5625 | 42520.0 |
> showing 50 of 40,067 rows — these rows as CSV