PREVIEW / stock_1hour / 2009-03-04
file: by_date/stock_1hour/2009/2009-03-04.parquet size: 812 KB rows: 40,260 symbols: 3,331
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-03-04 05:00:00 | AAPL | Stock | 3.19 | 3.19 | 3.19 | 3.19 | 2800.0 |
| 2009-03-04 07:00:00 | AAPL | Stock | 3.1925 | 3.2054 | 3.1789 | 3.1789 | 80752.0 |
| 2009-03-04 08:00:00 | AAPL | Stock | 3.1786 | 3.2086 | 3.1707 | 3.2054 | 1817900.0 |
| 2009-03-04 09:00:00 | AAPL | Stock | 3.2054 | 3.2329 | 3.1946 | 3.2225 | 85835596.0 |
| 2009-03-04 10:00:00 | AAPL | Stock | 3.2229 | 3.2607 | 3.2086 | 3.2545 | 113804208.0 |
| 2009-03-04 11:00:00 | AAPL | Stock | 3.2543 | 3.2839 | 3.2539 | 3.2773 | 92793456.0 |
| 2009-03-04 12:00:00 | AAPL | Stock | 3.2768 | 3.2857 | 3.2579 | 3.26 | 70377524.0 |
| 2009-03-04 13:00:00 | AAPL | Stock | 3.2604 | 3.2814 | 3.2464 | 3.2732 | 63348852.0 |
| 2009-03-04 14:00:00 | AAPL | Stock | 3.2732 | 3.3036 | 3.2686 | 3.3004 | 106587208.0 |
| 2009-03-04 15:00:00 | AAPL | Stock | 3.3011 | 3.3132 | 3.2568 | 3.2636 | 180300932.0 |
| 2009-03-04 16:00:00 | AAPL | Stock | 3.2589 | 3.2964 | 3.2143 | 3.2543 | 23870980.0 |
| 2009-03-04 17:00:00 | AAPL | Stock | 3.26 | 3.2675 | 3.2518 | 3.2629 | 558908.0 |
| 2009-03-04 18:00:00 | AAPL | Stock | 3.2646 | 3.2679 | 3.2561 | 3.2671 | 445088.0 |
| 2009-03-04 19:00:00 | AAPL | Stock | 3.2661 | 3.2732 | 3.2661 | 3.2679 | 85820.0 |
| 2009-03-04 07:00:00 | MSFT | Stock | 15.97 | 16.02 | 15.97 | 15.97 | 1400.0 |
| 2009-03-04 08:00:00 | MSFT | Stock | 15.88 | 16.08 | 15.88 | 16.08 | 783678.0 |
| 2009-03-04 09:00:00 | MSFT | Stock | 16.09 | 16.24 | 15.97 | 16.03 | 7208183.0 |
| 2009-03-04 10:00:00 | MSFT | Stock | 16.03 | 16.19 | 15.89 | 16.145 | 9991500.0 |
| 2009-03-04 11:00:00 | MSFT | Stock | 16.16 | 16.36 | 15.98 | 16.32 | 8830197.0 |
| 2009-03-04 12:00:00 | MSFT | Stock | 16.32 | 16.36 | 16.11 | 16.178 | 6622463.0 |
| 2009-03-04 13:00:00 | MSFT | Stock | 16.18 | 16.281 | 16.09 | 16.19 | 5745034.0 |
| 2009-03-04 14:00:00 | MSFT | Stock | 16.19 | 16.35 | 16.16 | 16.335 | 7876544.0 |
| 2009-03-04 15:00:00 | MSFT | Stock | 16.33 | 16.4 | 16.07 | 16.12 | 15655134.0 |
| 2009-03-04 16:00:00 | MSFT | Stock | 16.12 | 16.32 | 16.07 | 16.13 | 4322104.0 |
| 2009-03-04 17:00:00 | MSFT | Stock | 16.12 | 16.19 | 16.12 | 16.19 | 4579.0 |
| 2009-03-04 18:00:00 | MSFT | Stock | 16.12 | 16.12 | 16.11 | 16.11 | 439372.0 |
| 2009-03-04 19:00:00 | MSFT | Stock | 16.13 | 16.2 | 16.12 | 16.2 | 4820.0 |
| 2009-03-04 08:00:00 | NVDA | Stock | 0.1972 | 0.2025 | 0.197 | 0.2025 | 193280.0 |
| 2009-03-04 09:00:00 | NVDA | Stock | 0.2018 | 0.2092 | 0.2005 | 0.2054 | 140145720.0 |
| 2009-03-04 10:00:00 | NVDA | Stock | 0.2053 | 0.2112 | 0.205 | 0.2092 | 158830400.0 |
| 2009-03-04 11:00:00 | NVDA | Stock | 0.2092 | 0.2175 | 0.2092 | 0.2138 | 179739240.0 |
| 2009-03-04 12:00:00 | NVDA | Stock | 0.2135 | 0.2138 | 0.208 | 0.2082 | 182589840.0 |
| 2009-03-04 13:00:00 | NVDA | Stock | 0.2082 | 0.2122 | 0.208 | 0.2108 | 83098040.0 |
| 2009-03-04 14:00:00 | NVDA | Stock | 0.2109 | 0.2132 | 0.2098 | 0.2125 | 118428080.0 |
| 2009-03-04 15:00:00 | NVDA | Stock | 0.2123 | 0.2145 | 0.2105 | 0.2118 | 221379240.0 |
| 2009-03-04 16:00:00 | NVDA | Stock | 0.2118 | 0.214 | 0.2102 | 0.2115 | 15072240.0 |
| 2009-03-04 17:00:00 | NVDA | Stock | 0.2115 | 0.2115 | 0.2115 | 0.2115 | 4760.0 |
| 2009-03-04 18:00:00 | NVDA | Stock | 0.2112 | 0.2112 | 0.2112 | 0.2112 | 12000.0 |
| 2009-03-04 04:00:00 | AMZN | Stock | 3.095 | 3.095 | 3.095 | 3.095 | 10000.0 |
| 2009-03-04 07:00:00 | AMZN | Stock | 3.085 | 3.0925 | 3.085 | 3.0925 | 18000.0 |
| 2009-03-04 08:00:00 | AMZN | Stock | 3.08 | 3.1375 | 3.063 | 3.1375 | 539840.0 |
| 2009-03-04 09:00:00 | AMZN | Stock | 3.1375 | 3.195 | 3.1265 | 3.144 | 33752100.0 |
| 2009-03-04 10:00:00 | AMZN | Stock | 3.1435 | 3.2225 | 3.12 | 3.1958 | 37880760.0 |
| 2009-03-04 11:00:00 | AMZN | Stock | 3.196 | 3.2154 | 3.1765 | 3.201 | 22106540.0 |
| 2009-03-04 12:00:00 | AMZN | Stock | 3.201 | 3.2095 | 3.176 | 3.1933 | 18475080.0 |
| 2009-03-04 13:00:00 | AMZN | Stock | 3.1925 | 3.231 | 3.176 | 3.2155 | 21176360.0 |
| 2009-03-04 14:00:00 | AMZN | Stock | 3.215 | 3.2525 | 3.2065 | 3.246 | 36057920.0 |
| 2009-03-04 15:00:00 | AMZN | Stock | 3.246 | 3.2895 | 3.239 | 3.244 | 64097100.0 |
| 2009-03-04 16:00:00 | AMZN | Stock | 3.244 | 3.25 | 3.2005 | 3.2405 | 4619220.0 |
| 2009-03-04 17:00:00 | AMZN | Stock | 3.2565 | 3.2575 | 3.246 | 3.246 | 35400.0 |
> showing 50 of 40,260 rows — these rows as CSV