PREVIEW / stock_1hour / 2008-04-11
file: by_date/stock_1hour/2008/2008-04-11.parquet size: 806 KB rows: 40,481 symbols: 3,293
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-11 04:00:00 | AAPL | Stock | 5.5789 | 5.5789 | 5.5789 | 5.5789 | 5600.0 |
| 2008-04-11 05:00:00 | AAPL | Stock | 5.5871 | 5.5871 | 5.5871 | 5.5871 | 2800.0 |
| 2008-04-11 06:00:00 | AAPL | Stock | 5.5411 | 5.5411 | 5.4979 | 5.4979 | 85148.0 |
| 2008-04-11 07:00:00 | AAPL | Stock | 5.4857 | 5.495 | 5.4643 | 5.475 | 451080.0 |
| 2008-04-11 08:00:00 | AAPL | Stock | 5.4732 | 5.4857 | 5.4507 | 5.455 | 4665388.0 |
| 2008-04-11 09:00:00 | AAPL | Stock | 5.455 | 5.475 | 5.4418 | 5.4461 | 135045988.0 |
| 2008-04-11 10:00:00 | AAPL | Stock | 5.4475 | 5.4568 | 5.415 | 5.4293 | 163579192.0 |
| 2008-04-11 11:00:00 | AAPL | Stock | 5.4289 | 5.4386 | 5.4086 | 5.4275 | 89583816.0 |
| 2008-04-11 12:00:00 | AAPL | Stock | 5.4279 | 5.4286 | 5.3804 | 5.3904 | 109485992.0 |
| 2008-04-11 13:00:00 | AAPL | Stock | 5.3897 | 5.3911 | 5.2764 | 5.3014 | 201157684.0 |
| 2008-04-11 14:00:00 | AAPL | Stock | 5.3007 | 5.3071 | 5.2507 | 5.2693 | 216241452.0 |
| 2008-04-11 15:00:00 | AAPL | Stock | 5.2696 | 5.2764 | 5.2286 | 5.2579 | 260156876.0 |
| 2008-04-11 16:00:00 | AAPL | Stock | 5.2584 | 5.3475 | 5.25 | 5.2586 | 14417480.0 |
| 2008-04-11 17:00:00 | AAPL | Stock | 5.2586 | 5.2963 | 5.2543 | 5.2568 | 768796.0 |
| 2008-04-11 18:00:00 | AAPL | Stock | 5.2571 | 5.2571 | 5.2479 | 5.25 | 4764536.0 |
| 2008-04-11 19:00:00 | AAPL | Stock | 5.25 | 5.2504 | 5.235 | 5.2439 | 1227072.0 |
| 2008-04-11 06:00:00 | MSFT | Stock | 29.14 | 29.14 | 29.03 | 29.03 | 620.0 |
| 2008-04-11 07:00:00 | MSFT | Stock | 29.0 | 29.0 | 28.95 | 28.95 | 3800.0 |
| 2008-04-11 08:00:00 | MSFT | Stock | 28.95 | 29.0 | 28.82 | 28.88 | 52746.0 |
| 2008-04-11 09:00:00 | MSFT | Stock | 28.85 | 29.01 | 28.65 | 28.7 | 4962469.0 |
| 2008-04-11 10:00:00 | MSFT | Stock | 28.71 | 28.73 | 28.55 | 28.59 | 9037582.0 |
| 2008-04-11 11:00:00 | MSFT | Stock | 28.6 | 28.69 | 28.55 | 28.65 | 5689847.0 |
| 2008-04-11 12:00:00 | MSFT | Stock | 28.65 | 28.66 | 28.48 | 28.529 | 5401707.0 |
| 2008-04-11 13:00:00 | MSFT | Stock | 28.52 | 28.61 | 28.44 | 28.49 | 3434227.0 |
| 2008-04-11 14:00:00 | MSFT | Stock | 28.48 | 28.51 | 28.34 | 28.36 | 5432572.0 |
| 2008-04-11 15:00:00 | MSFT | Stock | 28.37 | 28.65 | 28.21 | 28.32 | 10650165.0 |
| 2008-04-11 16:00:00 | MSFT | Stock | 28.28 | 28.525 | 28.263 | 28.36 | 3306686.0 |
| 2008-04-11 17:00:00 | MSFT | Stock | 28.35 | 28.412 | 28.32 | 28.32 | 1400.0 |
| 2008-04-11 18:00:00 | MSFT | Stock | 28.32 | 28.37 | 28.28 | 28.35 | 5358521.0 |
| 2008-04-11 19:00:00 | MSFT | Stock | 28.35 | 28.37 | 28.29 | 28.29 | 3585.0 |
| 2008-04-11 05:00:00 | NVDA | Stock | 0.5125 | 0.514 | 0.5125 | 0.514 | 44000.0 |
| 2008-04-11 08:00:00 | NVDA | Stock | 0.495 | 0.495 | 0.4855 | 0.4862 | 1717360.0 |
| 2008-04-11 09:00:00 | NVDA | Stock | 0.4872 | 0.4905 | 0.4763 | 0.4822 | 148103520.0 |
| 2008-04-11 10:00:00 | NVDA | Stock | 0.482 | 0.4848 | 0.4782 | 0.4803 | 203117280.0 |
| 2008-04-11 11:00:00 | NVDA | Stock | 0.4803 | 0.4805 | 0.4768 | 0.4785 | 120839160.0 |
| 2008-04-11 12:00:00 | NVDA | Stock | 0.4785 | 0.4793 | 0.475 | 0.4755 | 104684600.0 |
| 2008-04-11 13:00:00 | NVDA | Stock | 0.4758 | 0.477 | 0.4692 | 0.4698 | 111133440.0 |
| 2008-04-11 14:00:00 | NVDA | Stock | 0.4695 | 0.47 | 0.4633 | 0.4635 | 109029160.0 |
| 2008-04-11 15:00:00 | NVDA | Stock | 0.4635 | 0.464 | 0.4603 | 0.4633 | 219937320.0 |
| 2008-04-11 16:00:00 | NVDA | Stock | 0.4638 | 0.4739 | 0.463 | 0.4652 | 55934760.0 |
| 2008-04-11 17:00:00 | NVDA | Stock | 0.4652 | 0.4662 | 0.4652 | 0.4655 | 148000.0 |
| 2008-04-11 18:00:00 | NVDA | Stock | 0.4655 | 0.4675 | 0.4633 | 0.4662 | 4084000.0 |
| 2008-04-11 19:00:00 | NVDA | Stock | 0.4658 | 0.4668 | 0.4655 | 0.4662 | 138960.0 |
| 2008-04-11 08:00:00 | AMZN | Stock | 3.7415 | 3.7415 | 3.685 | 3.695 | 963000.0 |
| 2008-04-11 09:00:00 | AMZN | Stock | 3.688 | 3.715 | 3.6655 | 3.6935 | 10364420.0 |
| 2008-04-11 10:00:00 | AMZN | Stock | 3.694 | 3.705 | 3.679 | 3.6915 | 12620540.0 |
| 2008-04-11 11:00:00 | AMZN | Stock | 3.6915 | 3.6925 | 3.66 | 3.6825 | 11007480.0 |
| 2008-04-11 12:00:00 | AMZN | Stock | 3.6815 | 3.6825 | 3.63 | 3.6335 | 12555260.0 |
| 2008-04-11 13:00:00 | AMZN | Stock | 3.635 | 3.641 | 3.6 | 3.608 | 11259940.0 |
| 2008-04-11 14:00:00 | AMZN | Stock | 3.608 | 3.63 | 3.6055 | 3.622 | 11769220.0 |
> showing 50 of 40,481 rows — these rows as CSV