PREVIEW / stock_1hour / 2009-06-29
file: by_date/stock_1hour/2009/2009-06-29.parquet size: 848 KB rows: 40,913 symbols: 3,330
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-29 05:00:00 | AAPL | Stock | 5.0679 | 5.0679 | 5.0679 | 5.0679 | 2800.0 |
| 2009-06-29 06:00:00 | AAPL | Stock | 5.0575 | 5.0661 | 5.0575 | 5.0661 | 16800.0 |
| 2009-06-29 07:00:00 | AAPL | Stock | 5.1061 | 5.1168 | 5.0886 | 5.1168 | 193284.0 |
| 2009-06-29 08:00:00 | AAPL | Stock | 5.1211 | 5.1404 | 5.1125 | 5.1221 | 1652336.0 |
| 2009-06-29 09:00:00 | AAPL | Stock | 5.1225 | 5.1411 | 5.0871 | 5.1 | 82858692.0 |
| 2009-06-29 10:00:00 | AAPL | Stock | 5.1 | 5.1068 | 5.0668 | 5.0779 | 79754752.0 |
| 2009-06-29 11:00:00 | AAPL | Stock | 5.0779 | 5.1157 | 5.0729 | 5.1143 | 59334212.0 |
| 2009-06-29 12:00:00 | AAPL | Stock | 5.1143 | 5.1404 | 5.0971 | 5.1004 | 96074132.0 |
| 2009-06-29 13:00:00 | AAPL | Stock | 5.0996 | 5.1096 | 5.0714 | 5.0796 | 52485916.0 |
| 2009-06-29 14:00:00 | AAPL | Stock | 5.0796 | 5.0904 | 5.0632 | 5.0861 | 55113912.0 |
| 2009-06-29 15:00:00 | AAPL | Stock | 5.0861 | 5.0964 | 5.055 | 5.07 | 87687488.0 |
| 2009-06-29 16:00:00 | AAPL | Stock | 5.07 | 5.0949 | 5.0614 | 5.0668 | 47458656.0 |
| 2009-06-29 17:00:00 | AAPL | Stock | 5.0675 | 5.0928 | 5.0625 | 5.0696 | 414904.0 |
| 2009-06-29 18:00:00 | AAPL | Stock | 5.0704 | 5.0704 | 5.0657 | 5.0696 | 79856.0 |
| 2009-06-29 19:00:00 | AAPL | Stock | 5.065 | 5.0693 | 5.0636 | 5.0679 | 47740.0 |
| 2009-06-29 07:00:00 | MSFT | Stock | 23.55 | 23.55 | 23.55 | 23.55 | 3800.0 |
| 2009-06-29 08:00:00 | MSFT | Stock | 23.55 | 23.61 | 23.5 | 23.57 | 47615.0 |
| 2009-06-29 09:00:00 | MSFT | Stock | 23.54 | 23.89 | 23.54 | 23.881 | 10785480.0 |
| 2009-06-29 10:00:00 | MSFT | Stock | 23.88 | 24.03 | 23.75 | 23.935 | 13265023.0 |
| 2009-06-29 11:00:00 | MSFT | Stock | 23.94 | 23.99 | 23.87 | 23.94 | 6346701.0 |
| 2009-06-29 12:00:00 | MSFT | Stock | 23.94 | 23.96 | 23.83 | 23.84 | 5012450.0 |
| 2009-06-29 13:00:00 | MSFT | Stock | 23.845 | 23.89 | 23.74 | 23.78 | 4610272.0 |
| 2009-06-29 14:00:00 | MSFT | Stock | 23.77 | 23.84 | 23.69 | 23.75 | 6285757.0 |
| 2009-06-29 15:00:00 | MSFT | Stock | 23.755 | 23.89 | 23.71 | 23.82 | 11370690.0 |
| 2009-06-29 16:00:00 | MSFT | Stock | 23.85 | 23.87 | 23.81 | 23.86 | 3818038.0 |
| 2009-06-29 17:00:00 | MSFT | Stock | 23.86 | 24.024 | 23.844 | 23.88 | 68784.0 |
| 2009-06-29 18:00:00 | MSFT | Stock | 23.89 | 23.9 | 23.86 | 23.9 | 4938.0 |
| 2009-06-29 19:00:00 | MSFT | Stock | 23.9 | 23.91 | 23.87 | 23.9 | 7699.0 |
| 2009-06-29 08:00:00 | NVDA | Stock | 0.2905 | 0.2905 | 0.2905 | 0.2905 | 40000.0 |
| 2009-06-29 09:00:00 | NVDA | Stock | 0.2892 | 0.2945 | 0.2865 | 0.2878 | 113961280.0 |
| 2009-06-29 10:00:00 | NVDA | Stock | 0.2878 | 0.2925 | 0.2862 | 0.2905 | 98492160.0 |
| 2009-06-29 11:00:00 | NVDA | Stock | 0.2905 | 0.293 | 0.2902 | 0.2922 | 71663640.0 |
| 2009-06-29 12:00:00 | NVDA | Stock | 0.2925 | 0.293 | 0.29 | 0.29 | 39181760.0 |
| 2009-06-29 13:00:00 | NVDA | Stock | 0.29 | 0.2902 | 0.2875 | 0.2885 | 30836200.0 |
| 2009-06-29 14:00:00 | NVDA | Stock | 0.2888 | 0.2892 | 0.2875 | 0.2892 | 32209120.0 |
| 2009-06-29 15:00:00 | NVDA | Stock | 0.2892 | 0.29 | 0.2875 | 0.289 | 85948080.0 |
| 2009-06-29 16:00:00 | NVDA | Stock | 0.2892 | 0.2898 | 0.289 | 0.2898 | 24903400.0 |
| 2009-06-29 17:00:00 | NVDA | Stock | 0.2901 | 0.2901 | 0.2901 | 0.2901 | 9204000.0 |
| 2009-06-29 08:00:00 | AMZN | Stock | 4.1955 | 4.215 | 4.1955 | 4.2135 | 61320.0 |
| 2009-06-29 09:00:00 | AMZN | Stock | 4.2035 | 4.21 | 4.1205 | 4.146 | 17490000.0 |
| 2009-06-29 10:00:00 | AMZN | Stock | 4.1455 | 4.204 | 4.128 | 4.172 | 26021520.0 |
| 2009-06-29 11:00:00 | AMZN | Stock | 4.172 | 4.201 | 4.165 | 4.1995 | 14717160.0 |
| 2009-06-29 12:00:00 | AMZN | Stock | 4.2 | 4.209 | 4.1885 | 4.1915 | 11587880.0 |
| 2009-06-29 13:00:00 | AMZN | Stock | 4.191 | 4.198 | 4.163 | 4.1775 | 10910020.0 |
| 2009-06-29 14:00:00 | AMZN | Stock | 4.1775 | 4.1775 | 4.1525 | 4.158 | 13276540.0 |
| 2009-06-29 15:00:00 | AMZN | Stock | 4.159 | 4.1695 | 4.138 | 4.1515 | 22357820.0 |
| 2009-06-29 16:00:00 | AMZN | Stock | 4.15 | 4.1756 | 4.13 | 4.1665 | 5506560.0 |
| 2009-06-29 17:00:00 | AMZN | Stock | 4.15 | 4.1872 | 4.15 | 4.16 | 430300.0 |
| 2009-06-29 18:00:00 | AMZN | Stock | 4.1515 | 4.1515 | 4.1515 | 4.1515 | 4000.0 |
| 2009-06-29 19:00:00 | AMZN | Stock | 4.1595 | 4.1595 | 4.15 | 4.15 | 18260.0 |
> showing 50 of 40,913 rows — these rows as CSV