PREVIEW / stock_1hour / 2009-06-16
file: by_date/stock_1hour/2009/2009-06-16.parquet size: 840 KB rows: 40,993 symbols: 3,338
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-16 05:00:00 | AAPL | Stock | 4.8771 | 4.8771 | 4.87 | 4.87 | 36400.0 |
| 2009-06-16 06:00:00 | AAPL | Stock | 4.8654 | 4.8654 | 4.8571 | 4.8571 | 53200.0 |
| 2009-06-16 07:00:00 | AAPL | Stock | 4.8679 | 4.8875 | 4.8607 | 4.8721 | 137200.0 |
| 2009-06-16 08:00:00 | AAPL | Stock | 4.8679 | 4.8911 | 4.8575 | 4.8846 | 1278172.0 |
| 2009-06-16 09:00:00 | AAPL | Stock | 4.8839 | 4.9234 | 4.8607 | 4.9118 | 87919524.0 |
| 2009-06-16 10:00:00 | AAPL | Stock | 4.9114 | 4.93 | 4.8864 | 4.92 | 83682060.0 |
| 2009-06-16 11:00:00 | AAPL | Stock | 4.92 | 4.9454 | 4.9193 | 4.9307 | 62768272.0 |
| 2009-06-16 12:00:00 | AAPL | Stock | 4.9311 | 4.9432 | 4.8929 | 4.9032 | 66220280.0 |
| 2009-06-16 13:00:00 | AAPL | Stock | 4.9036 | 4.9168 | 4.8864 | 4.9071 | 47076708.0 |
| 2009-06-16 14:00:00 | AAPL | Stock | 4.9061 | 4.9132 | 4.8821 | 4.9 | 61476828.0 |
| 2009-06-16 15:00:00 | AAPL | Stock | 4.9004 | 4.9121 | 4.8675 | 4.8696 | 84194992.0 |
| 2009-06-16 16:00:00 | AAPL | Stock | 4.8696 | 4.9404 | 4.8679 | 4.8725 | 8313928.0 |
| 2009-06-16 17:00:00 | AAPL | Stock | 4.8704 | 4.8729 | 4.8679 | 4.8704 | 355740.0 |
| 2009-06-16 18:00:00 | AAPL | Stock | 4.8725 | 4.8768 | 4.8696 | 4.87 | 205856.0 |
| 2009-06-16 19:00:00 | AAPL | Stock | 4.8704 | 4.8732 | 4.8704 | 4.8721 | 29120.0 |
| 2009-06-16 07:00:00 | MSFT | Stock | 23.4 | 23.54 | 23.4 | 23.54 | 12450.0 |
| 2009-06-16 08:00:00 | MSFT | Stock | 23.5 | 23.53 | 23.45 | 23.5 | 50424.0 |
| 2009-06-16 09:00:00 | MSFT | Stock | 23.5 | 23.94 | 23.47 | 23.85 | 12731467.0 |
| 2009-06-16 10:00:00 | MSFT | Stock | 23.852 | 23.95 | 23.79 | 23.908 | 18551493.0 |
| 2009-06-16 11:00:00 | MSFT | Stock | 23.905 | 24.11 | 23.8 | 23.81 | 18377864.0 |
| 2009-06-16 12:00:00 | MSFT | Stock | 23.808 | 23.96 | 23.71 | 23.77 | 13203552.0 |
| 2009-06-16 13:00:00 | MSFT | Stock | 23.768 | 23.84 | 23.64 | 23.7 | 8973208.0 |
| 2009-06-16 14:00:00 | MSFT | Stock | 23.7 | 23.7 | 23.51 | 23.65 | 8888307.0 |
| 2009-06-16 15:00:00 | MSFT | Stock | 23.64 | 23.73 | 23.44 | 23.45 | 17288622.0 |
| 2009-06-16 16:00:00 | MSFT | Stock | 23.44 | 24.005 | 23.43 | 23.47 | 3451409.0 |
| 2009-06-16 17:00:00 | MSFT | Stock | 23.47 | 23.55 | 23.43 | 23.47 | 13062.0 |
| 2009-06-16 18:00:00 | MSFT | Stock | 23.46 | 23.46 | 23.42 | 23.45 | 7599.0 |
| 2009-06-16 19:00:00 | MSFT | Stock | 23.44 | 23.46 | 23.43 | 23.46 | 4083.0 |
| 2009-06-16 20:00:00 | MSFT | Stock | 23.9 | 23.9 | 23.9 | 23.9 | 3300.0 |
| 2009-06-16 08:00:00 | NVDA | Stock | 0.2818 | 0.2818 | 0.2818 | 0.2818 | 20000.0 |
| 2009-06-16 09:00:00 | NVDA | Stock | 0.2835 | 0.2858 | 0.2812 | 0.2845 | 50418360.0 |
| 2009-06-16 10:00:00 | NVDA | Stock | 0.2841 | 0.2865 | 0.2806 | 0.2825 | 85591800.0 |
| 2009-06-16 11:00:00 | NVDA | Stock | 0.2825 | 0.2835 | 0.2795 | 0.2805 | 67094280.0 |
| 2009-06-16 12:00:00 | NVDA | Stock | 0.2806 | 0.2815 | 0.275 | 0.2765 | 60451360.0 |
| 2009-06-16 13:00:00 | NVDA | Stock | 0.2765 | 0.2768 | 0.274 | 0.2752 | 48194600.0 |
| 2009-06-16 14:00:00 | NVDA | Stock | 0.2752 | 0.2752 | 0.2712 | 0.2728 | 87705960.0 |
| 2009-06-16 15:00:00 | NVDA | Stock | 0.273 | 0.2768 | 0.2728 | 0.2752 | 175798720.0 |
| 2009-06-16 16:00:00 | NVDA | Stock | 0.275 | 0.2778 | 0.2748 | 0.2752 | 16171240.0 |
| 2009-06-16 17:00:00 | NVDA | Stock | 0.2755 | 0.2755 | 0.2755 | 0.2755 | 12000.0 |
| 2009-06-16 19:00:00 | NVDA | Stock | 0.2743 | 0.2743 | 0.2738 | 0.2738 | 8000.0 |
| 2009-06-16 08:00:00 | AMZN | Stock | 4.1598 | 4.161 | 4.1355 | 4.1605 | 41600.0 |
| 2009-06-16 09:00:00 | AMZN | Stock | 4.175 | 4.1975 | 4.1075 | 4.1275 | 18020960.0 |
| 2009-06-16 10:00:00 | AMZN | Stock | 4.1275 | 4.1515 | 4.103 | 4.1335 | 18141640.0 |
| 2009-06-16 11:00:00 | AMZN | Stock | 4.133 | 4.1495 | 4.093 | 4.095 | 12393900.0 |
| 2009-06-16 12:00:00 | AMZN | Stock | 4.0945 | 4.1235 | 4.064 | 4.0925 | 12395680.0 |
| 2009-06-16 13:00:00 | AMZN | Stock | 4.093 | 4.115 | 4.08 | 4.098 | 10753580.0 |
| 2009-06-16 14:00:00 | AMZN | Stock | 4.0975 | 4.1175 | 4.0805 | 4.1145 | 14018520.0 |
| 2009-06-16 15:00:00 | AMZN | Stock | 4.1155 | 4.1355 | 4.0995 | 4.1075 | 20300440.0 |
| 2009-06-16 16:00:00 | AMZN | Stock | 4.107 | 4.115 | 4.0895 | 4.1075 | 2095600.0 |
| 2009-06-16 17:00:00 | AMZN | Stock | 4.1075 | 4.111 | 4.1075 | 4.111 | 14000.0 |
> showing 50 of 40,993 rows — these rows as CSV