PREVIEW / stock_1hour / 2009-04-16
file: by_date/stock_1hour/2009/2009-04-16.parquet size: 825 KB rows: 40,425 symbols: 3,344
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-16 07:00:00 | AAPL | Stock | 4.1961 | 4.1961 | 4.1961 | 4.1961 | 5600.0 |
| 2009-04-16 08:00:00 | AAPL | Stock | 4.1961 | 4.2461 | 4.1893 | 4.2361 | 781676.0 |
| 2009-04-16 09:00:00 | AAPL | Stock | 4.2361 | 4.275 | 4.2014 | 4.2741 | 71664264.0 |
| 2009-04-16 10:00:00 | AAPL | Stock | 4.2746 | 4.3168 | 4.2575 | 4.2689 | 95752244.0 |
| 2009-04-16 11:00:00 | AAPL | Stock | 4.2689 | 4.3204 | 4.2689 | 4.3011 | 64776600.0 |
| 2009-04-16 12:00:00 | AAPL | Stock | 4.3018 | 4.3382 | 4.2979 | 4.3314 | 50431808.0 |
| 2009-04-16 13:00:00 | AAPL | Stock | 4.3314 | 4.355 | 4.3304 | 4.3504 | 58330664.0 |
| 2009-04-16 14:00:00 | AAPL | Stock | 4.3504 | 4.3982 | 4.3461 | 4.3879 | 83175036.0 |
| 2009-04-16 15:00:00 | AAPL | Stock | 4.3879 | 4.3893 | 4.3318 | 4.3411 | 142059008.0 |
| 2009-04-16 16:00:00 | AAPL | Stock | 4.3368 | 4.3946 | 4.2714 | 4.3307 | 21542976.0 |
| 2009-04-16 17:00:00 | AAPL | Stock | 4.3318 | 4.3318 | 4.2971 | 4.3214 | 1201368.0 |
| 2009-04-16 18:00:00 | AAPL | Stock | 4.325 | 4.3257 | 4.3157 | 4.3214 | 74200.0 |
| 2009-04-16 19:00:00 | AAPL | Stock | 4.3214 | 4.3286 | 4.3211 | 4.3286 | 78512.0 |
| 2009-04-16 07:00:00 | MSFT | Stock | 18.8 | 18.82 | 18.8 | 18.82 | 300.0 |
| 2009-04-16 08:00:00 | MSFT | Stock | 18.85 | 19.08 | 18.85 | 19.08 | 107417.0 |
| 2009-04-16 09:00:00 | MSFT | Stock | 19.07 | 19.3 | 18.99 | 19.29 | 5925267.0 |
| 2009-04-16 10:00:00 | MSFT | Stock | 19.3 | 19.34 | 19.02 | 19.06 | 8225052.0 |
| 2009-04-16 11:00:00 | MSFT | Stock | 19.06 | 19.23 | 19.06 | 19.2 | 5389556.0 |
| 2009-04-16 12:00:00 | MSFT | Stock | 19.2 | 19.23 | 19.1 | 19.192 | 5139314.0 |
| 2009-04-16 13:00:00 | MSFT | Stock | 19.19 | 19.3 | 19.15 | 19.26 | 5591981.0 |
| 2009-04-16 14:00:00 | MSFT | Stock | 19.268 | 19.78 | 19.252 | 19.649 | 12157709.0 |
| 2009-04-16 15:00:00 | MSFT | Stock | 19.64 | 19.78 | 19.59 | 19.75 | 20888722.0 |
| 2009-04-16 16:00:00 | MSFT | Stock | 19.75 | 19.78 | 19.3 | 19.6 | 3210399.0 |
| 2009-04-16 17:00:00 | MSFT | Stock | 19.6 | 19.74 | 19.56 | 19.57 | 18946.0 |
| 2009-04-16 18:00:00 | MSFT | Stock | 19.58 | 19.65 | 19.58 | 19.65 | 370.0 |
| 2009-04-16 19:00:00 | MSFT | Stock | 19.58 | 19.65 | 19.58 | 19.65 | 2937.0 |
| 2009-04-16 08:00:00 | NVDA | Stock | 0.287 | 0.289 | 0.287 | 0.289 | 110600.0 |
| 2009-04-16 09:00:00 | NVDA | Stock | 0.29 | 0.2955 | 0.2848 | 0.2891 | 135137760.0 |
| 2009-04-16 10:00:00 | NVDA | Stock | 0.2892 | 0.2905 | 0.28 | 0.2808 | 214260480.0 |
| 2009-04-16 11:00:00 | NVDA | Stock | 0.2808 | 0.2862 | 0.279 | 0.2862 | 130553960.0 |
| 2009-04-16 12:00:00 | NVDA | Stock | 0.2862 | 0.2895 | 0.2832 | 0.289 | 114387040.0 |
| 2009-04-16 13:00:00 | NVDA | Stock | 0.289 | 0.2908 | 0.2872 | 0.289 | 77663440.0 |
| 2009-04-16 14:00:00 | NVDA | Stock | 0.2888 | 0.294 | 0.2875 | 0.2935 | 142893200.0 |
| 2009-04-16 15:00:00 | NVDA | Stock | 0.2935 | 0.2938 | 0.2892 | 0.2918 | 199839080.0 |
| 2009-04-16 16:00:00 | NVDA | Stock | 0.2912 | 0.2925 | 0.288 | 0.2925 | 4213600.0 |
| 2009-04-16 17:00:00 | NVDA | Stock | 0.2915 | 0.2915 | 0.288 | 0.288 | 2564000.0 |
| 2009-04-16 07:00:00 | AMZN | Stock | 3.7 | 3.7 | 3.7 | 3.7 | 2000.0 |
| 2009-04-16 08:00:00 | AMZN | Stock | 3.749 | 3.7575 | 3.749 | 3.75 | 32000.0 |
| 2009-04-16 09:00:00 | AMZN | Stock | 3.7545 | 3.8145 | 3.75 | 3.805 | 21589360.0 |
| 2009-04-16 10:00:00 | AMZN | Stock | 3.805 | 3.814 | 3.7755 | 3.783 | 23179880.0 |
| 2009-04-16 11:00:00 | AMZN | Stock | 3.7845 | 3.825 | 3.7805 | 3.808 | 19872440.0 |
| 2009-04-16 12:00:00 | AMZN | Stock | 3.8075 | 3.8275 | 3.801 | 3.8125 | 13857460.0 |
| 2009-04-16 13:00:00 | AMZN | Stock | 3.8125 | 3.8345 | 3.807 | 3.8285 | 16599380.0 |
| 2009-04-16 14:00:00 | AMZN | Stock | 3.828 | 3.864 | 3.8218 | 3.8495 | 14969200.0 |
| 2009-04-16 15:00:00 | AMZN | Stock | 3.8515 | 3.874 | 3.8385 | 3.8625 | 32147140.0 |
| 2009-04-16 16:00:00 | AMZN | Stock | 3.862 | 3.8965 | 3.8192 | 3.835 | 4740600.0 |
| 2009-04-16 17:00:00 | AMZN | Stock | 3.831 | 3.832 | 3.8135 | 3.8305 | 197800.0 |
| 2009-04-16 18:00:00 | AMZN | Stock | 3.8325 | 3.838 | 3.8325 | 3.8375 | 18020.0 |
| 2009-04-16 19:00:00 | AMZN | Stock | 3.838 | 3.8415 | 3.8375 | 3.8375 | 14000.0 |
| 2009-04-16 09:00:00 | TLT | Stock | 103.22 | 103.23 | 102.84 | 103.01 | 111206.0 |
> showing 50 of 40,425 rows — these rows as CSV