PREVIEW / stock_1hour / 2009-06-23
file: by_date/stock_1hour/2009/2009-06-23.parquet size: 834 KB rows: 40,607 symbols: 3,356
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-06-23 04:00:00 | AAPL | Stock | 4.9061 | 4.9061 | 4.9061 | 4.9061 | 2800.0 |
| 2009-06-23 05:00:00 | AAPL | Stock | 4.9268 | 4.9268 | 4.9268 | 4.9268 | 5012.0 |
| 2009-06-23 06:00:00 | AAPL | Stock | 4.9268 | 4.9279 | 4.9268 | 4.9279 | 51800.0 |
| 2009-06-23 07:00:00 | AAPL | Stock | 4.9139 | 4.9171 | 4.9061 | 4.9071 | 147420.0 |
| 2009-06-23 08:00:00 | AAPL | Stock | 4.9114 | 4.9114 | 4.8775 | 4.8893 | 1775452.0 |
| 2009-06-23 09:00:00 | AAPL | Stock | 4.8875 | 4.8921 | 4.7518 | 4.7589 | 161511756.0 |
| 2009-06-23 10:00:00 | AAPL | Stock | 4.7579 | 4.7957 | 4.7457 | 4.7689 | 175968156.0 |
| 2009-06-23 11:00:00 | AAPL | Stock | 4.7693 | 4.7946 | 4.7554 | 4.7886 | 64015336.0 |
| 2009-06-23 12:00:00 | AAPL | Stock | 4.7886 | 4.7911 | 4.7596 | 4.7696 | 58200324.0 |
| 2009-06-23 13:00:00 | AAPL | Stock | 4.77 | 4.7893 | 4.7646 | 4.7742 | 49357476.0 |
| 2009-06-23 14:00:00 | AAPL | Stock | 4.7725 | 4.825 | 4.77 | 4.8064 | 88795588.0 |
| 2009-06-23 15:00:00 | AAPL | Stock | 4.8061 | 4.8118 | 4.7796 | 4.7843 | 90136396.0 |
| 2009-06-23 16:00:00 | AAPL | Stock | 4.7889 | 4.9061 | 4.7807 | 4.7864 | 10710896.0 |
| 2009-06-23 17:00:00 | AAPL | Stock | 4.7911 | 4.7975 | 4.7871 | 4.7889 | 137508.0 |
| 2009-06-23 18:00:00 | AAPL | Stock | 4.7936 | 4.7946 | 4.7836 | 4.7882 | 1044176.0 |
| 2009-06-23 19:00:00 | AAPL | Stock | 4.7882 | 4.7921 | 4.7757 | 4.7779 | 417788.0 |
| 2009-06-23 06:00:00 | MSFT | Stock | 23.38 | 23.38 | 23.38 | 23.38 | 180.0 |
| 2009-06-23 07:00:00 | MSFT | Stock | 23.45 | 23.46 | 23.45 | 23.46 | 530.0 |
| 2009-06-23 08:00:00 | MSFT | Stock | 23.39 | 23.5 | 23.38 | 23.46 | 36821.0 |
| 2009-06-23 09:00:00 | MSFT | Stock | 23.45 | 23.47 | 23.28 | 23.35 | 7465777.0 |
| 2009-06-23 10:00:00 | MSFT | Stock | 23.35 | 23.49 | 23.21 | 23.432 | 9529632.0 |
| 2009-06-23 11:00:00 | MSFT | Stock | 23.43 | 23.6 | 23.35 | 23.565 | 6396575.0 |
| 2009-06-23 12:00:00 | MSFT | Stock | 23.57 | 23.64 | 23.49 | 23.6 | 7141049.0 |
| 2009-06-23 13:00:00 | MSFT | Stock | 23.6 | 23.66 | 23.5 | 23.5 | 4850487.0 |
| 2009-06-23 14:00:00 | MSFT | Stock | 23.5 | 23.58 | 23.41 | 23.48 | 5484780.0 |
| 2009-06-23 15:00:00 | MSFT | Stock | 23.48 | 23.48 | 23.27 | 23.32 | 12918412.0 |
| 2009-06-23 16:00:00 | MSFT | Stock | 23.33 | 23.5 | 23.25 | 23.33 | 1884955.0 |
| 2009-06-23 17:00:00 | MSFT | Stock | 23.37 | 23.42 | 23.37 | 23.4 | 5650.0 |
| 2009-06-23 18:00:00 | MSFT | Stock | 23.38 | 23.45 | 23.34 | 23.42 | 4584.0 |
| 2009-06-23 19:00:00 | MSFT | Stock | 23.4 | 23.4 | 23.4 | 23.4 | 150.0 |
| 2009-06-23 09:00:00 | NVDA | Stock | 0.2675 | 0.2675 | 0.2563 | 0.26 | 100107880.0 |
| 2009-06-23 10:00:00 | NVDA | Stock | 0.26 | 0.2612 | 0.2527 | 0.255 | 164834480.0 |
| 2009-06-23 11:00:00 | NVDA | Stock | 0.255 | 0.258 | 0.2521 | 0.258 | 103196880.0 |
| 2009-06-23 12:00:00 | NVDA | Stock | 0.258 | 0.2598 | 0.256 | 0.2588 | 55445040.0 |
| 2009-06-23 13:00:00 | NVDA | Stock | 0.2588 | 0.2598 | 0.2585 | 0.2585 | 13498600.0 |
| 2009-06-23 14:00:00 | NVDA | Stock | 0.2585 | 0.2625 | 0.258 | 0.2612 | 44910840.0 |
| 2009-06-23 15:00:00 | NVDA | Stock | 0.2612 | 0.2635 | 0.26 | 0.2623 | 95031040.0 |
| 2009-06-23 16:00:00 | NVDA | Stock | 0.2623 | 0.2625 | 0.2583 | 0.2625 | 10724960.0 |
| 2009-06-23 19:00:00 | NVDA | Stock | 0.2628 | 0.2628 | 0.2625 | 0.2625 | 16000.0 |
| 2009-06-23 07:00:00 | AMZN | Stock | 3.9975 | 3.9975 | 3.9975 | 3.9975 | 6000.0 |
| 2009-06-23 08:00:00 | AMZN | Stock | 3.939 | 3.939 | 3.939 | 3.939 | 4000.0 |
| 2009-06-23 09:00:00 | AMZN | Stock | 3.9625 | 3.9645 | 3.8605 | 3.8765 | 24977640.0 |
| 2009-06-23 10:00:00 | AMZN | Stock | 3.8755 | 3.9535 | 3.8255 | 3.836 | 32590060.0 |
| 2009-06-23 11:00:00 | AMZN | Stock | 3.836 | 3.88 | 3.8125 | 3.867 | 27241980.0 |
| 2009-06-23 12:00:00 | AMZN | Stock | 3.867 | 3.8765 | 3.833 | 3.8703 | 10908800.0 |
| 2009-06-23 13:00:00 | AMZN | Stock | 3.8705 | 3.903 | 3.8595 | 3.863 | 12061180.0 |
| 2009-06-23 14:00:00 | AMZN | Stock | 3.8625 | 3.9005 | 3.8585 | 3.8875 | 12990280.0 |
| 2009-06-23 15:00:00 | AMZN | Stock | 3.888 | 3.897 | 3.8725 | 3.8805 | 21479360.0 |
| 2009-06-23 16:00:00 | AMZN | Stock | 3.876 | 3.8841 | 3.8706 | 3.877 | 2386980.0 |
| 2009-06-23 17:00:00 | AMZN | Stock | 3.894 | 3.894 | 3.894 | 3.894 | 2000.0 |
> showing 50 of 40,607 rows — these rows as CSV