PREVIEW / stock_1hour / 2009-05-14
file: by_date/stock_1hour/2009/2009-05-14.parquet size: 831 KB rows: 40,666 symbols: 3,312
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-05-14 07:00:00 | AAPL | Stock | 4.2532 | 4.2857 | 4.2496 | 4.2857 | 178500.0 |
| 2009-05-14 08:00:00 | AAPL | Stock | 4.2707 | 4.2768 | 4.25 | 4.2643 | 1853964.0 |
| 2009-05-14 09:00:00 | AAPL | Stock | 4.2654 | 4.3168 | 4.2614 | 4.3109 | 70141960.0 |
| 2009-05-14 10:00:00 | AAPL | Stock | 4.3118 | 4.35 | 4.31 | 4.3461 | 81672444.0 |
| 2009-05-14 11:00:00 | AAPL | Stock | 4.3461 | 4.3739 | 4.3439 | 4.3696 | 50345988.0 |
| 2009-05-14 12:00:00 | AAPL | Stock | 4.3689 | 4.3914 | 4.3661 | 4.3814 | 39925368.0 |
| 2009-05-14 13:00:00 | AAPL | Stock | 4.3811 | 4.3896 | 4.3464 | 4.3789 | 30909256.0 |
| 2009-05-14 14:00:00 | AAPL | Stock | 4.3786 | 4.4118 | 4.3779 | 4.4004 | 51308040.0 |
| 2009-05-14 15:00:00 | AAPL | Stock | 4.4007 | 4.41 | 4.3796 | 4.3911 | 88425008.0 |
| 2009-05-14 16:00:00 | AAPL | Stock | 4.3875 | 4.3979 | 4.3592 | 4.3911 | 23073400.0 |
| 2009-05-14 17:00:00 | AAPL | Stock | 4.3911 | 4.3929 | 4.3886 | 4.3904 | 109200.0 |
| 2009-05-14 18:00:00 | AAPL | Stock | 4.3904 | 4.3961 | 4.3904 | 4.3961 | 1523452.0 |
| 2009-05-14 19:00:00 | AAPL | Stock | 4.3946 | 4.3946 | 4.3907 | 4.3911 | 71540.0 |
| 2009-05-14 08:00:00 | MSFT | Stock | 19.7 | 19.75 | 19.65 | 19.75 | 11324.0 |
| 2009-05-14 09:00:00 | MSFT | Stock | 19.74 | 20.0 | 19.68 | 19.93 | 5599496.0 |
| 2009-05-14 10:00:00 | MSFT | Stock | 19.93 | 19.99 | 19.83 | 19.878 | 6920986.0 |
| 2009-05-14 11:00:00 | MSFT | Stock | 19.88 | 20.04 | 19.87 | 20.008 | 6255564.0 |
| 2009-05-14 12:00:00 | MSFT | Stock | 20.01 | 20.06 | 19.97 | 20.0 | 3392257.0 |
| 2009-05-14 13:00:00 | MSFT | Stock | 20.01 | 20.03 | 19.94 | 19.98 | 2956805.0 |
| 2009-05-14 14:00:00 | MSFT | Stock | 19.99 | 20.22 | 19.98 | 20.202 | 9381617.0 |
| 2009-05-14 15:00:00 | MSFT | Stock | 20.21 | 20.23 | 20.02 | 20.02 | 13132902.0 |
| 2009-05-14 16:00:00 | MSFT | Stock | 20.02 | 20.09 | 19.98 | 20.06 | 6026348.0 |
| 2009-05-14 17:00:00 | MSFT | Stock | 20.01 | 20.02 | 20.01 | 20.02 | 1885.0 |
| 2009-05-14 18:00:00 | MSFT | Stock | 20.06 | 20.06 | 20.05 | 20.05 | 49173.0 |
| 2009-05-14 19:00:00 | MSFT | Stock | 20.06 | 20.06 | 20.02 | 20.02 | 4450.0 |
| 2009-05-14 05:00:00 | NVDA | Stock | 0.2112 | 0.2112 | 0.2112 | 0.2112 | 20000.0 |
| 2009-05-14 08:00:00 | NVDA | Stock | 0.2112 | 0.2112 | 0.2088 | 0.2095 | 760520.0 |
| 2009-05-14 09:00:00 | NVDA | Stock | 0.2095 | 0.2172 | 0.2082 | 0.2105 | 152759280.0 |
| 2009-05-14 10:00:00 | NVDA | Stock | 0.2105 | 0.2125 | 0.2092 | 0.211 | 165082480.0 |
| 2009-05-14 11:00:00 | NVDA | Stock | 0.2112 | 0.2132 | 0.2102 | 0.2128 | 141267480.0 |
| 2009-05-14 12:00:00 | NVDA | Stock | 0.213 | 0.2163 | 0.2128 | 0.2148 | 107991960.0 |
| 2009-05-14 13:00:00 | NVDA | Stock | 0.215 | 0.2158 | 0.212 | 0.2143 | 106146440.0 |
| 2009-05-14 14:00:00 | NVDA | Stock | 0.2143 | 0.2175 | 0.214 | 0.2165 | 134672760.0 |
| 2009-05-14 15:00:00 | NVDA | Stock | 0.2168 | 0.2168 | 0.2118 | 0.213 | 163249280.0 |
| 2009-05-14 16:00:00 | NVDA | Stock | 0.213 | 0.2134 | 0.2125 | 0.213 | 31744600.0 |
| 2009-05-14 17:00:00 | NVDA | Stock | 0.2125 | 0.2135 | 0.2125 | 0.2135 | 220880.0 |
| 2009-05-14 18:00:00 | NVDA | Stock | 0.213 | 0.2135 | 0.213 | 0.2135 | 159320.0 |
| 2009-05-14 19:00:00 | NVDA | Stock | 0.2135 | 0.214 | 0.2135 | 0.2138 | 68000.0 |
| 2009-05-14 04:00:00 | AMZN | Stock | 3.6805 | 3.6805 | 3.6805 | 3.6805 | 2000.0 |
| 2009-05-14 07:00:00 | AMZN | Stock | 3.664 | 3.6995 | 3.664 | 3.6995 | 49580.0 |
| 2009-05-14 08:00:00 | AMZN | Stock | 3.695 | 3.695 | 3.6725 | 3.68 | 134520.0 |
| 2009-05-14 09:00:00 | AMZN | Stock | 3.6795 | 3.7555 | 3.6655 | 3.6985 | 24392340.0 |
| 2009-05-14 10:00:00 | AMZN | Stock | 3.6995 | 3.764 | 3.699 | 3.742 | 31556060.0 |
| 2009-05-14 11:00:00 | AMZN | Stock | 3.741 | 3.7735 | 3.738 | 3.771 | 19736720.0 |
| 2009-05-14 12:00:00 | AMZN | Stock | 3.7715 | 3.778 | 3.747 | 3.7685 | 10006320.0 |
| 2009-05-14 13:00:00 | AMZN | Stock | 3.7685 | 3.79 | 3.766 | 3.779 | 21739160.0 |
| 2009-05-14 14:00:00 | AMZN | Stock | 3.78 | 3.803 | 3.775 | 3.787 | 17760860.0 |
| 2009-05-14 15:00:00 | AMZN | Stock | 3.7865 | 3.7945 | 3.7345 | 3.755 | 45878800.0 |
| 2009-05-14 16:00:00 | AMZN | Stock | 3.7505 | 3.7578 | 3.744 | 3.7578 | 5411740.0 |
| 2009-05-14 17:00:00 | AMZN | Stock | 3.7575 | 3.7575 | 3.7575 | 3.7575 | 6000.0 |
> showing 50 of 40,666 rows — these rows as CSV