PREVIEW / stock_1hour / 2009-06-17
file: by_date/stock_1hour/2009/2009-06-17.parquet size: 847 KB rows: 41,267 symbols: 3,329
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-17 05:00:00 | AAPL | Stock | 4.8636 | 4.8636 | 4.8636 | 4.8636 | 16800.0 |
| 2009-06-17 06:00:00 | AAPL | Stock | 4.8536 | 4.8536 | 4.8536 | 4.8536 | 5600.0 |
| 2009-06-17 07:00:00 | AAPL | Stock | 4.8571 | 4.8854 | 4.8571 | 4.8571 | 183848.0 |
| 2009-06-17 08:00:00 | AAPL | Stock | 4.8679 | 4.8968 | 4.8607 | 4.8968 | 532168.0 |
| 2009-06-17 09:00:00 | AAPL | Stock | 4.8929 | 4.9089 | 4.8046 | 4.8104 | 114974468.0 |
| 2009-06-17 10:00:00 | AAPL | Stock | 4.8104 | 4.87 | 4.8075 | 4.8368 | 99379728.0 |
| 2009-06-17 11:00:00 | AAPL | Stock | 4.8364 | 4.8892 | 4.8346 | 4.865 | 77129696.0 |
| 2009-06-17 12:00:00 | AAPL | Stock | 4.8652 | 4.8882 | 4.8607 | 4.8711 | 50382248.0 |
| 2009-06-17 13:00:00 | AAPL | Stock | 4.8704 | 4.8864 | 4.8604 | 4.8789 | 50199380.0 |
| 2009-06-17 14:00:00 | AAPL | Stock | 4.8789 | 4.8868 | 4.8514 | 4.8621 | 52790948.0 |
| 2009-06-17 15:00:00 | AAPL | Stock | 4.8625 | 4.875 | 4.8368 | 4.8446 | 101061408.0 |
| 2009-06-17 16:00:00 | AAPL | Stock | 4.8407 | 4.8857 | 4.8382 | 4.845 | 17755724.0 |
| 2009-06-17 17:00:00 | AAPL | Stock | 4.8446 | 4.8653 | 4.8421 | 4.8421 | 885808.0 |
| 2009-06-17 18:00:00 | AAPL | Stock | 4.8432 | 4.8496 | 4.8414 | 4.8446 | 672924.0 |
| 2009-06-17 19:00:00 | AAPL | Stock | 4.8446 | 4.8507 | 4.8386 | 4.8507 | 181076.0 |
| 2009-06-17 05:00:00 | MSFT | Stock | 23.57 | 23.65 | 23.55 | 23.65 | 2400.0 |
| 2009-06-17 06:00:00 | MSFT | Stock | 23.65 | 23.65 | 23.55 | 23.55 | 1500.0 |
| 2009-06-17 07:00:00 | MSFT | Stock | 23.5 | 23.5 | 23.45 | 23.45 | 4475.0 |
| 2009-06-17 08:00:00 | MSFT | Stock | 23.47 | 23.59 | 23.46 | 23.58 | 39039.0 |
| 2009-06-17 09:00:00 | MSFT | Stock | 23.53 | 23.6 | 23.25 | 23.295 | 12941313.0 |
| 2009-06-17 10:00:00 | MSFT | Stock | 23.29 | 23.39 | 23.17 | 23.225 | 14967117.0 |
| 2009-06-17 11:00:00 | MSFT | Stock | 23.22 | 23.46 | 23.2 | 23.421 | 9341023.0 |
| 2009-06-17 12:00:00 | MSFT | Stock | 23.43 | 23.54 | 23.39 | 23.509 | 8398314.0 |
| 2009-06-17 13:00:00 | MSFT | Stock | 23.5 | 23.82 | 23.5 | 23.72 | 11142628.0 |
| 2009-06-17 14:00:00 | MSFT | Stock | 23.72 | 23.82 | 23.6 | 23.7 | 8835000.0 |
| 2009-06-17 15:00:00 | MSFT | Stock | 23.7 | 23.79 | 23.6 | 23.67 | 16002593.0 |
| 2009-06-17 16:00:00 | MSFT | Stock | 23.71 | 23.74 | 23.332 | 23.63 | 2698987.0 |
| 2009-06-17 17:00:00 | MSFT | Stock | 23.63 | 23.8 | 23.432 | 23.72 | 242623.0 |
| 2009-06-17 18:00:00 | MSFT | Stock | 23.71 | 23.71 | 23.67 | 23.67 | 10856.0 |
| 2009-06-17 19:00:00 | MSFT | Stock | 23.67 | 23.68 | 23.59 | 23.64 | 8520.0 |
| 2009-06-17 08:00:00 | NVDA | Stock | 0.278 | 0.278 | 0.2775 | 0.278 | 59200.0 |
| 2009-06-17 09:00:00 | NVDA | Stock | 0.2778 | 0.281 | 0.2705 | 0.271 | 114821320.0 |
| 2009-06-17 10:00:00 | NVDA | Stock | 0.2705 | 0.2735 | 0.2688 | 0.2728 | 155292560.0 |
| 2009-06-17 11:00:00 | NVDA | Stock | 0.2725 | 0.28 | 0.2723 | 0.28 | 116191440.0 |
| 2009-06-17 12:00:00 | NVDA | Stock | 0.2798 | 0.2838 | 0.2788 | 0.2808 | 89687840.0 |
| 2009-06-17 13:00:00 | NVDA | Stock | 0.2808 | 0.2848 | 0.2798 | 0.2822 | 68407800.0 |
| 2009-06-17 14:00:00 | NVDA | Stock | 0.2822 | 0.2838 | 0.2812 | 0.2828 | 60330000.0 |
| 2009-06-17 15:00:00 | NVDA | Stock | 0.2828 | 0.2832 | 0.2805 | 0.282 | 157486280.0 |
| 2009-06-17 16:00:00 | NVDA | Stock | 0.2815 | 0.2825 | 0.2776 | 0.282 | 5977440.0 |
| 2009-06-17 17:00:00 | NVDA | Stock | 0.282 | 0.282 | 0.28 | 0.28 | 15518880.0 |
| 2009-06-17 08:00:00 | AMZN | Stock | 4.1075 | 4.117 | 4.1075 | 4.117 | 13000.0 |
| 2009-06-17 09:00:00 | AMZN | Stock | 4.11 | 4.1735 | 4.05 | 4.052 | 19871820.0 |
| 2009-06-17 10:00:00 | AMZN | Stock | 4.052 | 4.1275 | 4.032 | 4.0978 | 31616060.0 |
| 2009-06-17 11:00:00 | AMZN | Stock | 4.098 | 4.1675 | 4.095 | 4.1455 | 22429180.0 |
| 2009-06-17 12:00:00 | AMZN | Stock | 4.147 | 4.1775 | 4.143 | 4.1565 | 12825500.0 |
| 2009-06-17 13:00:00 | AMZN | Stock | 4.1555 | 4.215 | 4.1505 | 4.1962 | 19012540.0 |
| 2009-06-17 14:00:00 | AMZN | Stock | 4.1968 | 4.2065 | 4.1595 | 4.1695 | 16838080.0 |
| 2009-06-17 15:00:00 | AMZN | Stock | 4.17 | 4.1775 | 4.1295 | 4.1325 | 26884100.0 |
| 2009-06-17 16:00:00 | AMZN | Stock | 4.1325 | 4.1616 | 4.1075 | 4.132 | 1801160.0 |
| 2009-06-17 17:00:00 | AMZN | Stock | 4.1355 | 4.1355 | 4.1295 | 4.1325 | 1809240.0 |
> showing 50 of 41,267 rows — these rows as CSV