PREVIEW / stock_1hour / 2009-03-19
file: by_date/stock_1hour/2009/2009-03-19.parquet size: 873 KB rows: 43,729 symbols: 3,336
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-19 05:00:00 | AAPL | Stock | 3.6036 | 3.6036 | 3.6036 | 3.6036 | 2800.0 |
| 2009-03-19 07:00:00 | AAPL | Stock | 3.6243 | 3.6393 | 3.6243 | 3.6257 | 42700.0 |
| 2009-03-19 08:00:00 | AAPL | Stock | 3.625 | 3.6404 | 3.5954 | 3.6404 | 760984.0 |
| 2009-03-19 09:00:00 | AAPL | Stock | 3.6307 | 3.6514 | 3.5804 | 3.6036 | 62803776.0 |
| 2009-03-19 10:00:00 | AAPL | Stock | 3.6054 | 3.6857 | 3.5907 | 3.6593 | 99397900.0 |
| 2009-03-19 11:00:00 | AAPL | Stock | 3.6568 | 3.6714 | 3.6071 | 3.6143 | 79543156.0 |
| 2009-03-19 12:00:00 | AAPL | Stock | 3.6143 | 3.6268 | 3.5914 | 3.6046 | 53107880.0 |
| 2009-03-19 13:00:00 | AAPL | Stock | 3.6036 | 3.6264 | 3.5896 | 3.6182 | 48211324.0 |
| 2009-03-19 14:00:00 | AAPL | Stock | 3.6175 | 3.6264 | 3.5982 | 3.6178 | 49217644.0 |
| 2009-03-19 15:00:00 | AAPL | Stock | 3.6171 | 3.6429 | 3.6118 | 3.63 | 81083296.0 |
| 2009-03-19 16:00:00 | AAPL | Stock | 3.6318 | 3.6362 | 3.6176 | 3.6293 | 16267272.0 |
| 2009-03-19 17:00:00 | AAPL | Stock | 3.6293 | 3.6423 | 3.5929 | 3.6179 | 782964.0 |
| 2009-03-19 18:00:00 | AAPL | Stock | 3.6193 | 3.6345 | 3.6071 | 3.6143 | 595140.0 |
| 2009-03-19 19:00:00 | AAPL | Stock | 3.6175 | 3.6207 | 3.6157 | 3.6164 | 83776.0 |
| 2009-03-19 05:00:00 | MSFT | Stock | 17.12 | 17.12 | 17.12 | 17.12 | 500.0 |
| 2009-03-19 07:00:00 | MSFT | Stock | 17.16 | 17.23 | 17.16 | 17.23 | 3000.0 |
| 2009-03-19 08:00:00 | MSFT | Stock | 17.2 | 17.24 | 17.13 | 17.21 | 48991.0 |
| 2009-03-19 09:00:00 | MSFT | Stock | 17.21 | 17.45 | 17.01 | 17.05 | 9852499.0 |
| 2009-03-19 10:00:00 | MSFT | Stock | 17.05 | 17.14 | 16.92 | 17.07 | 8775495.0 |
| 2009-03-19 11:00:00 | MSFT | Stock | 17.07 | 17.12 | 16.99 | 17.11 | 7066559.0 |
| 2009-03-19 12:00:00 | MSFT | Stock | 17.12 | 17.2 | 17.02 | 17.032 | 6476691.0 |
| 2009-03-19 13:00:00 | MSFT | Stock | 17.04 | 17.26 | 17.01 | 17.21 | 5836363.0 |
| 2009-03-19 14:00:00 | MSFT | Stock | 17.211 | 17.27 | 17.05 | 17.1 | 5626301.0 |
| 2009-03-19 15:00:00 | MSFT | Stock | 17.1 | 17.16 | 17.01 | 17.13 | 9199631.0 |
| 2009-03-19 16:00:00 | MSFT | Stock | 17.13 | 17.37 | 16.97 | 17.14 | 3792258.0 |
| 2009-03-19 17:00:00 | MSFT | Stock | 17.14 | 17.25 | 17.0 | 17.07 | 264327.0 |
| 2009-03-19 18:00:00 | MSFT | Stock | 17.115 | 17.14 | 17.02 | 17.07 | 80513.0 |
| 2009-03-19 19:00:00 | MSFT | Stock | 17.05 | 17.07 | 17.05 | 17.07 | 3600.0 |
| 2009-03-19 08:00:00 | NVDA | Stock | 0.255 | 0.2572 | 0.2538 | 0.2572 | 334000.0 |
| 2009-03-19 09:00:00 | NVDA | Stock | 0.2563 | 0.2575 | 0.2513 | 0.2533 | 130274960.0 |
| 2009-03-19 10:00:00 | NVDA | Stock | 0.2533 | 0.2563 | 0.2525 | 0.2535 | 156251560.0 |
| 2009-03-19 11:00:00 | NVDA | Stock | 0.2535 | 0.2546 | 0.251 | 0.2545 | 122963800.0 |
| 2009-03-19 12:00:00 | NVDA | Stock | 0.2543 | 0.2545 | 0.2518 | 0.2527 | 85225960.0 |
| 2009-03-19 13:00:00 | NVDA | Stock | 0.253 | 0.254 | 0.2515 | 0.2523 | 83119440.0 |
| 2009-03-19 14:00:00 | NVDA | Stock | 0.2523 | 0.2535 | 0.2513 | 0.2521 | 93588000.0 |
| 2009-03-19 15:00:00 | NVDA | Stock | 0.2523 | 0.2559 | 0.2503 | 0.252 | 120730120.0 |
| 2009-03-19 16:00:00 | NVDA | Stock | 0.252 | 0.253 | 0.2518 | 0.252 | 15002520.0 |
| 2009-03-19 17:00:00 | NVDA | Stock | 0.2515 | 0.254 | 0.248 | 0.2515 | 1786200.0 |
| 2009-03-19 18:00:00 | NVDA | Stock | 0.2523 | 0.2525 | 0.2503 | 0.2507 | 664000.0 |
| 2009-03-19 19:00:00 | NVDA | Stock | 0.2495 | 0.2495 | 0.2495 | 0.2495 | 4000.0 |
| 2009-03-19 07:00:00 | AMZN | Stock | 3.56 | 3.56 | 3.56 | 3.56 | 6400.0 |
| 2009-03-19 08:00:00 | AMZN | Stock | 3.56 | 3.56 | 3.53 | 3.55 | 193580.0 |
| 2009-03-19 09:00:00 | AMZN | Stock | 3.55 | 3.5955 | 3.523 | 3.545 | 19159980.0 |
| 2009-03-19 10:00:00 | AMZN | Stock | 3.5455 | 3.5558 | 3.5026 | 3.516 | 33695600.0 |
| 2009-03-19 11:00:00 | AMZN | Stock | 3.5145 | 3.5265 | 3.504 | 3.5095 | 18382680.0 |
| 2009-03-19 12:00:00 | AMZN | Stock | 3.509 | 3.5132 | 3.4805 | 3.4892 | 20140220.0 |
| 2009-03-19 13:00:00 | AMZN | Stock | 3.49 | 3.4908 | 3.462 | 3.4805 | 26833880.0 |
| 2009-03-19 14:00:00 | AMZN | Stock | 3.4815 | 3.495 | 3.4625 | 3.4815 | 19776800.0 |
| 2009-03-19 15:00:00 | AMZN | Stock | 3.481 | 3.561 | 3.4775 | 3.5055 | 23482120.0 |
| 2009-03-19 16:00:00 | AMZN | Stock | 3.508 | 3.511 | 3.4824 | 3.505 | 7372520.0 |
> showing 50 of 43,729 rows — these rows as CSV