PREVIEW / stock_1hour / 2005-05-16
file: by_date/stock_1hour/2005/2005-05-16.parquet size: 553 KB rows: 26,274 symbols: 1,996
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-16 08:00:00 | AAPL | Stock | 1.2421 | 1.2486 | 1.2357 | 1.2407 | 910000.0 |
| 2005-05-16 09:00:00 | AAPL | Stock | 1.24 | 1.2754 | 1.2332 | 1.2429 | 74532248.0 |
| 2005-05-16 10:00:00 | AAPL | Stock | 1.2432 | 1.2661 | 1.2396 | 1.2632 | 96701724.0 |
| 2005-05-16 11:00:00 | AAPL | Stock | 1.2629 | 1.2639 | 1.2561 | 1.2575 | 42130508.0 |
| 2005-05-16 12:00:00 | AAPL | Stock | 1.2575 | 1.2589 | 1.2479 | 1.2589 | 54074384.0 |
| 2005-05-16 13:00:00 | AAPL | Stock | 1.2589 | 1.27 | 1.255 | 1.265 | 63127512.0 |
| 2005-05-16 14:00:00 | AAPL | Stock | 1.2646 | 1.275 | 1.2632 | 1.2718 | 71579312.0 |
| 2005-05-16 15:00:00 | AAPL | Stock | 1.2718 | 1.275 | 1.2679 | 1.2689 | 65381512.0 |
| 2005-05-16 16:00:00 | AAPL | Stock | 1.2689 | 1.2704 | 1.2679 | 1.2704 | 2389072.0 |
| 2005-05-16 17:00:00 | AAPL | Stock | 1.2696 | 1.2696 | 1.2682 | 1.2696 | 185892.0 |
| 2005-05-16 18:00:00 | AAPL | Stock | 1.2682 | 1.2689 | 1.2682 | 1.2689 | 58800.0 |
| 2005-05-16 08:00:00 | MSFT | Stock | 25.3 | 25.3 | 25.25 | 25.28 | 2900.0 |
| 2005-05-16 09:00:00 | MSFT | Stock | 25.25 | 25.34 | 25.19 | 25.29 | 3985012.0 |
| 2005-05-16 10:00:00 | MSFT | Stock | 25.29 | 25.42 | 24.31 | 25.37 | 7564830.0 |
| 2005-05-16 11:00:00 | MSFT | Stock | 25.37 | 25.45 | 25.31 | 25.43 | 5820296.0 |
| 2005-05-16 12:00:00 | MSFT | Stock | 25.43 | 25.47 | 25.4 | 25.47 | 5033349.0 |
| 2005-05-16 13:00:00 | MSFT | Stock | 25.46 | 25.49 | 25.42 | 25.47 | 5932682.0 |
| 2005-05-16 14:00:00 | MSFT | Stock | 25.47 | 25.5 | 25.33 | 25.389 | 7446217.0 |
| 2005-05-16 15:00:00 | MSFT | Stock | 25.38 | 25.49 | 25.3 | 25.49 | 13221669.0 |
| 2005-05-16 16:00:00 | MSFT | Stock | 25.48 | 25.5 | 25.47 | 25.49 | 420900.0 |
| 2005-05-16 17:00:00 | MSFT | Stock | 25.49 | 25.49 | 25.44 | 25.44 | 102100.0 |
| 2005-05-16 18:00:00 | MSFT | Stock | 25.48 | 25.49 | 25.48 | 25.49 | 2780.0 |
| 2005-05-16 08:00:00 | NVDA | Stock | 0.2116 | 0.2117 | 0.2108 | 0.2115 | 1658400.0 |
| 2005-05-16 09:00:00 | NVDA | Stock | 0.2114 | 0.2127 | 0.2085 | 0.2113 | 152155440.0 |
| 2005-05-16 10:00:00 | NVDA | Stock | 0.2112 | 0.2118 | 0.2088 | 0.2102 | 101747880.0 |
| 2005-05-16 11:00:00 | NVDA | Stock | 0.2102 | 0.2103 | 0.2086 | 0.2092 | 51903480.0 |
| 2005-05-16 12:00:00 | NVDA | Stock | 0.2092 | 0.2106 | 0.2087 | 0.2104 | 52382640.0 |
| 2005-05-16 13:00:00 | NVDA | Stock | 0.2105 | 0.2107 | 0.2097 | 0.2104 | 42750720.0 |
| 2005-05-16 14:00:00 | NVDA | Stock | 0.2104 | 0.2112 | 0.2096 | 0.2101 | 69028680.0 |
| 2005-05-16 15:00:00 | NVDA | Stock | 0.2101 | 0.2132 | 0.2097 | 0.2119 | 134479080.0 |
| 2005-05-16 16:00:00 | NVDA | Stock | 0.2119 | 0.2124 | 0.2118 | 0.2119 | 1390920.0 |
| 2005-05-16 17:00:00 | NVDA | Stock | 0.2118 | 0.2123 | 0.2117 | 0.2123 | 348600.0 |
| 2005-05-16 18:00:00 | NVDA | Stock | 0.2122 | 0.2122 | 0.2122 | 0.2122 | 130800.0 |
| 2005-05-16 08:00:00 | AMZN | Stock | 1.697 | 1.697 | 1.697 | 1.697 | 10000.0 |
| 2005-05-16 09:00:00 | AMZN | Stock | 1.699 | 1.7195 | 1.693 | 1.7165 | 10517540.0 |
| 2005-05-16 10:00:00 | AMZN | Stock | 1.716 | 1.7385 | 1.7155 | 1.737 | 17106200.0 |
| 2005-05-16 11:00:00 | AMZN | Stock | 1.737 | 1.7375 | 1.725 | 1.7255 | 8957100.0 |
| 2005-05-16 12:00:00 | AMZN | Stock | 1.7255 | 1.734 | 1.7205 | 1.734 | 6560400.0 |
| 2005-05-16 13:00:00 | AMZN | Stock | 1.734 | 1.738 | 1.7315 | 1.732 | 7280900.0 |
| 2005-05-16 14:00:00 | AMZN | Stock | 1.732 | 1.732 | 1.723 | 1.7245 | 9742560.0 |
| 2005-05-16 15:00:00 | AMZN | Stock | 1.7245 | 1.7375 | 1.7175 | 1.7275 | 24429020.0 |
| 2005-05-16 16:00:00 | AMZN | Stock | 1.727 | 1.7285 | 1.7245 | 1.726 | 274140.0 |
| 2005-05-16 17:00:00 | AMZN | Stock | 1.727 | 1.7295 | 1.727 | 1.7295 | 140000.0 |
| 2005-05-16 18:00:00 | AMZN | Stock | 1.727 | 1.7295 | 1.727 | 1.7295 | 166000.0 |
| 2005-05-16 09:00:00 | CL | Stock | 24.375 | 24.49 | 24.3485 | 24.445 | 414000.0 |
| 2005-05-16 10:00:00 | CL | Stock | 24.44 | 24.6 | 24.42 | 24.555 | 513800.0 |
| 2005-05-16 11:00:00 | CL | Stock | 24.55 | 24.625 | 24.5 | 24.545 | 717400.0 |
| 2005-05-16 12:00:00 | CL | Stock | 24.54 | 24.565 | 24.505 | 24.535 | 495400.0 |
| 2005-05-16 13:00:00 | CL | Stock | 24.535 | 24.635 | 24.5245 | 24.595 | 463200.0 |
| 2005-05-16 14:00:00 | CL | Stock | 24.585 | 24.635 | 24.57 | 24.58 | 336200.0 |
> showing 50 of 26,274 rows — these rows as CSV