PREVIEW / stock_1hour / 2009-12-28
file: by_date/stock_1hour/2009/2009-12-28.parquet size: 891 KB rows: 43,065 symbols: 3,445
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-12-28 05:00:00 | AAPL | Stock | 7.4771 | 7.4771 | 7.4771 | 7.4771 | 7000.0 |
| 2009-12-28 07:00:00 | AAPL | Stock | 7.4996 | 7.5332 | 7.4921 | 7.4929 | 498428.0 |
| 2009-12-28 08:00:00 | AAPL | Stock | 7.4946 | 7.5779 | 7.4821 | 7.5714 | 8093680.0 |
| 2009-12-28 09:00:00 | AAPL | Stock | 7.5714 | 7.6411 | 7.5393 | 7.6004 | 131372136.0 |
| 2009-12-28 10:00:00 | AAPL | Stock | 7.6 | 7.6232 | 7.5875 | 7.6139 | 90604080.0 |
| 2009-12-28 11:00:00 | AAPL | Stock | 7.6139 | 7.625 | 7.5982 | 7.6029 | 56851872.0 |
| 2009-12-28 12:00:00 | AAPL | Stock | 7.6029 | 7.6029 | 7.5614 | 7.575 | 71332660.0 |
| 2009-12-28 13:00:00 | AAPL | Stock | 7.575 | 7.6068 | 7.575 | 7.5832 | 41280288.0 |
| 2009-12-28 14:00:00 | AAPL | Stock | 7.5831 | 7.5882 | 7.4861 | 7.5376 | 123794300.0 |
| 2009-12-28 15:00:00 | AAPL | Stock | 7.5379 | 7.5654 | 7.5193 | 7.5564 | 96985896.0 |
| 2009-12-28 16:00:00 | AAPL | Stock | 7.5561 | 7.575 | 7.5435 | 7.5575 | 8038604.0 |
| 2009-12-28 17:00:00 | AAPL | Stock | 7.5482 | 7.5575 | 7.54 | 7.5464 | 615524.0 |
| 2009-12-28 18:00:00 | AAPL | Stock | 7.5464 | 7.5575 | 7.5464 | 7.5518 | 652512.0 |
| 2009-12-28 19:00:00 | AAPL | Stock | 7.5518 | 7.5518 | 7.5464 | 7.5496 | 247296.0 |
| 2009-12-28 20:00:00 | AAPL | Stock | 7.6086 | 7.6086 | 7.6086 | 7.6086 | 14000.0 |
| 2009-12-28 08:00:00 | MSFT | Stock | 31.0 | 31.06 | 31.0 | 31.05 | 2979.0 |
| 2009-12-28 09:00:00 | MSFT | Stock | 31.04 | 31.04 | 30.98 | 30.99 | 2792921.0 |
| 2009-12-28 10:00:00 | MSFT | Stock | 30.99 | 31.0 | 30.97 | 30.995 | 2600620.0 |
| 2009-12-28 11:00:00 | MSFT | Stock | 31.0 | 31.0 | 30.98 | 31.0 | 1684878.0 |
| 2009-12-28 12:00:00 | MSFT | Stock | 30.99 | 31.0 | 30.99 | 30.99 | 1626556.0 |
| 2009-12-28 13:00:00 | MSFT | Stock | 31.0 | 31.0 | 30.99 | 31.0 | 1784159.0 |
| 2009-12-28 14:00:00 | MSFT | Stock | 30.992 | 31.02 | 30.89 | 30.97 | 6825038.0 |
| 2009-12-28 15:00:00 | MSFT | Stock | 30.97 | 31.18 | 30.96 | 31.17 | 5780957.0 |
| 2009-12-28 16:00:00 | MSFT | Stock | 31.16 | 31.18 | 30.943 | 31.16 | 1572523.0 |
| 2009-12-28 17:00:00 | MSFT | Stock | 31.16 | 31.17 | 31.13 | 31.15 | 20231.0 |
| 2009-12-28 18:00:00 | MSFT | Stock | 31.11 | 31.11 | 31.11 | 31.11 | 1200.0 |
| 2009-12-28 19:00:00 | MSFT | Stock | 31.15 | 31.17 | 31.15 | 31.17 | 1470.0 |
| 2009-12-28 08:00:00 | NVDA | Stock | 0.4502 | 0.4502 | 0.4462 | 0.4475 | 197000.0 |
| 2009-12-28 09:00:00 | NVDA | Stock | 0.447 | 0.4555 | 0.4468 | 0.451 | 65204600.0 |
| 2009-12-28 10:00:00 | NVDA | Stock | 0.451 | 0.4518 | 0.4475 | 0.449 | 63107680.0 |
| 2009-12-28 11:00:00 | NVDA | Stock | 0.4492 | 0.4494 | 0.4435 | 0.4442 | 89263400.0 |
| 2009-12-28 12:00:00 | NVDA | Stock | 0.4442 | 0.4458 | 0.4438 | 0.4439 | 48110200.0 |
| 2009-12-28 13:00:00 | NVDA | Stock | 0.444 | 0.447 | 0.442 | 0.4465 | 42726880.0 |
| 2009-12-28 14:00:00 | NVDA | Stock | 0.4468 | 0.4468 | 0.4405 | 0.4425 | 87722240.0 |
| 2009-12-28 15:00:00 | NVDA | Stock | 0.4422 | 0.4452 | 0.442 | 0.445 | 61281520.0 |
| 2009-12-28 16:00:00 | NVDA | Stock | 0.445 | 0.447 | 0.444 | 0.445 | 5639040.0 |
| 2009-12-28 17:00:00 | NVDA | Stock | 0.445 | 0.445 | 0.444 | 0.444 | 113680.0 |
| 2009-12-28 20:00:00 | NVDA | Stock | 0.4452 | 0.4452 | 0.4452 | 0.4452 | 532000.0 |
| 2009-12-28 06:00:00 | AMZN | Stock | 6.9375 | 6.978 | 6.9375 | 6.945 | 11200.0 |
| 2009-12-28 07:00:00 | AMZN | Stock | 6.9665 | 6.97 | 6.945 | 6.968 | 38000.0 |
| 2009-12-28 08:00:00 | AMZN | Stock | 6.93 | 6.9825 | 6.93 | 6.9675 | 946620.0 |
| 2009-12-28 09:00:00 | AMZN | Stock | 6.9675 | 7.099 | 6.951 | 7.056 | 34336180.0 |
| 2009-12-28 10:00:00 | AMZN | Stock | 7.0585 | 7.0625 | 7.001 | 7.0225 | 30969700.0 |
| 2009-12-28 11:00:00 | AMZN | Stock | 7.0225 | 7.0795 | 7.0225 | 7.049 | 22919120.0 |
| 2009-12-28 12:00:00 | AMZN | Stock | 7.0485 | 7.0694 | 7.02 | 7.0255 | 15959500.0 |
| 2009-12-28 13:00:00 | AMZN | Stock | 7.0265 | 7.051 | 7.02 | 7.0225 | 10370800.0 |
| 2009-12-28 14:00:00 | AMZN | Stock | 7.023 | 7.03 | 6.9265 | 6.9775 | 30782160.0 |
| 2009-12-28 15:00:00 | AMZN | Stock | 6.978 | 6.992 | 6.939 | 6.965 | 25575000.0 |
| 2009-12-28 16:00:00 | AMZN | Stock | 6.965 | 7.0161 | 6.9485 | 6.9645 | 2594980.0 |
| 2009-12-28 17:00:00 | AMZN | Stock | 6.9645 | 6.9655 | 6.959 | 6.9655 | 56320.0 |
> showing 50 of 43,065 rows — these rows as CSV