PREVIEW / stock_1hour / 2009-04-14
file: by_date/stock_1hour/2009/2009-04-14.parquet size: 833 KB rows: 41,004 symbols: 3,328
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-04-14 04:00:00 | AAPL | Stock | 4.2696 | 4.2696 | 4.2696 | 4.2696 | 14000.0 |
| 2009-04-14 05:00:00 | AAPL | Stock | 4.3011 | 4.3011 | 4.3011 | 4.3011 | 2800.0 |
| 2009-04-14 06:00:00 | AAPL | Stock | 4.3129 | 4.3129 | 4.2896 | 4.2896 | 5600.0 |
| 2009-04-14 07:00:00 | AAPL | Stock | 4.2936 | 4.2936 | 4.2857 | 4.2857 | 19600.0 |
| 2009-04-14 08:00:00 | AAPL | Stock | 4.2929 | 4.3143 | 4.2593 | 4.2661 | 1275708.0 |
| 2009-04-14 09:00:00 | AAPL | Stock | 4.2657 | 4.2918 | 4.25 | 4.2718 | 60869004.0 |
| 2009-04-14 10:00:00 | AAPL | Stock | 4.2714 | 4.2718 | 4.2289 | 4.2439 | 77093156.0 |
| 2009-04-14 11:00:00 | AAPL | Stock | 4.2436 | 4.2561 | 4.2232 | 4.2364 | 42430920.0 |
| 2009-04-14 12:00:00 | AAPL | Stock | 4.2364 | 4.2489 | 4.1882 | 4.1889 | 49510776.0 |
| 2009-04-14 13:00:00 | AAPL | Stock | 4.1896 | 4.2121 | 4.1875 | 4.2018 | 53348680.0 |
| 2009-04-14 14:00:00 | AAPL | Stock | 4.2021 | 4.2246 | 4.1918 | 4.2246 | 56239596.0 |
| 2009-04-14 15:00:00 | AAPL | Stock | 4.2243 | 4.25 | 4.2165 | 4.2257 | 90567512.0 |
| 2009-04-14 16:00:00 | AAPL | Stock | 4.2257 | 4.2529 | 4.1918 | 4.2064 | 8932616.0 |
| 2009-04-14 17:00:00 | AAPL | Stock | 4.2068 | 4.2254 | 4.1964 | 4.1971 | 362880.0 |
| 2009-04-14 18:00:00 | AAPL | Stock | 4.1971 | 4.2254 | 4.1918 | 4.1996 | 600376.0 |
| 2009-04-14 19:00:00 | AAPL | Stock | 4.195 | 4.1964 | 4.1893 | 4.1964 | 76720.0 |
| 2009-04-14 07:00:00 | MSFT | Stock | 19.5 | 19.5 | 19.45 | 19.45 | 500.0 |
| 2009-04-14 08:00:00 | MSFT | Stock | 19.5 | 19.67 | 19.5 | 19.56 | 19108.0 |
| 2009-04-14 09:00:00 | MSFT | Stock | 19.52 | 19.56 | 19.22 | 19.53 | 6809584.0 |
| 2009-04-14 10:00:00 | MSFT | Stock | 19.53 | 19.55 | 19.4 | 19.455 | 7823256.0 |
| 2009-04-14 11:00:00 | MSFT | Stock | 19.45 | 19.53 | 19.16 | 19.23 | 11222568.0 |
| 2009-04-14 12:00:00 | MSFT | Stock | 19.23 | 19.26 | 19.0 | 19.052 | 6369720.0 |
| 2009-04-14 13:00:00 | MSFT | Stock | 19.06 | 19.13 | 19.02 | 19.13 | 5054510.0 |
| 2009-04-14 14:00:00 | MSFT | Stock | 19.13 | 19.26 | 19.1 | 19.26 | 6743395.0 |
| 2009-04-14 15:00:00 | MSFT | Stock | 19.25 | 19.48 | 19.14 | 19.33 | 14418583.0 |
| 2009-04-14 16:00:00 | MSFT | Stock | 19.33 | 19.49 | 18.91 | 19.254 | 3377509.0 |
| 2009-04-14 17:00:00 | MSFT | Stock | 19.07 | 19.35 | 19.04 | 19.04 | 10126.0 |
| 2009-04-14 18:00:00 | MSFT | Stock | 19.35 | 19.35 | 19.04 | 19.13 | 216764.0 |
| 2009-04-14 19:00:00 | MSFT | Stock | 19.06 | 19.11 | 19.06 | 19.11 | 3215.0 |
| 2009-04-14 08:00:00 | NVDA | Stock | 0.2938 | 0.2938 | 0.2875 | 0.291 | 166000.0 |
| 2009-04-14 09:00:00 | NVDA | Stock | 0.2888 | 0.3 | 0.286 | 0.298 | 87032640.0 |
| 2009-04-14 10:00:00 | NVDA | Stock | 0.2982 | 0.2992 | 0.2941 | 0.2965 | 117707400.0 |
| 2009-04-14 11:00:00 | NVDA | Stock | 0.2962 | 0.2975 | 0.2938 | 0.2938 | 74380200.0 |
| 2009-04-14 12:00:00 | NVDA | Stock | 0.2938 | 0.2945 | 0.2888 | 0.2897 | 69887400.0 |
| 2009-04-14 13:00:00 | NVDA | Stock | 0.29 | 0.291 | 0.288 | 0.2895 | 80874960.0 |
| 2009-04-14 14:00:00 | NVDA | Stock | 0.2892 | 0.2918 | 0.2885 | 0.2912 | 106139120.0 |
| 2009-04-14 15:00:00 | NVDA | Stock | 0.2912 | 0.2952 | 0.291 | 0.293 | 150905600.0 |
| 2009-04-14 16:00:00 | NVDA | Stock | 0.2922 | 0.2962 | 0.28 | 0.293 | 7198400.0 |
| 2009-04-14 17:00:00 | NVDA | Stock | 0.293 | 0.293 | 0.2803 | 0.2803 | 1013160.0 |
| 2009-04-14 18:00:00 | NVDA | Stock | 0.282 | 0.2845 | 0.282 | 0.2845 | 230000.0 |
| 2009-04-14 19:00:00 | NVDA | Stock | 0.281 | 0.281 | 0.281 | 0.281 | 178240.0 |
| 2009-04-14 08:00:00 | AMZN | Stock | 3.9595 | 3.9595 | 3.895 | 3.895 | 115700.0 |
| 2009-04-14 09:00:00 | AMZN | Stock | 3.9145 | 3.945 | 3.89 | 3.9395 | 10727900.0 |
| 2009-04-14 10:00:00 | AMZN | Stock | 3.939 | 3.973 | 3.9105 | 3.9385 | 19294600.0 |
| 2009-04-14 11:00:00 | AMZN | Stock | 3.939 | 3.953 | 3.9145 | 3.9205 | 13808860.0 |
| 2009-04-14 12:00:00 | AMZN | Stock | 3.9195 | 3.924 | 3.887 | 3.8925 | 13567500.0 |
| 2009-04-14 13:00:00 | AMZN | Stock | 3.8925 | 3.8955 | 3.857 | 3.875 | 17258440.0 |
| 2009-04-14 14:00:00 | AMZN | Stock | 3.874 | 3.8825 | 3.859 | 3.88 | 13490160.0 |
| 2009-04-14 15:00:00 | AMZN | Stock | 3.8805 | 3.8855 | 3.847 | 3.861 | 30207200.0 |
| 2009-04-14 16:00:00 | AMZN | Stock | 3.8605 | 3.9211 | 3.8375 | 3.861 | 2769400.0 |
> showing 50 of 41,004 rows — these rows as CSV