PREVIEW / stock_1hour / 2009-07-21
file: by_date/stock_1hour/2009/2009-07-21.parquet size: 844 KB rows: 41,123 symbols: 3,331
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-07-21 04:00:00 | AAPL | Stock | 5.5175 | 5.5175 | 5.5175 | 5.5175 | 8400.0 |
| 2009-07-21 05:00:00 | AAPL | Stock | 5.5175 | 5.5175 | 5.5175 | 5.5175 | 33600.0 |
| 2009-07-21 06:00:00 | AAPL | Stock | 5.495 | 5.495 | 5.495 | 5.495 | 14000.0 |
| 2009-07-21 07:00:00 | AAPL | Stock | 5.4843 | 5.5207 | 5.4821 | 5.5171 | 630504.0 |
| 2009-07-21 08:00:00 | AAPL | Stock | 5.5193 | 5.5286 | 5.485 | 5.4918 | 2729944.0 |
| 2009-07-21 09:00:00 | AAPL | Stock | 5.4929 | 5.4954 | 5.4157 | 5.4285 | 108726520.0 |
| 2009-07-21 10:00:00 | AAPL | Stock | 5.4282 | 5.4411 | 5.4075 | 5.4125 | 95952696.0 |
| 2009-07-21 11:00:00 | AAPL | Stock | 5.4136 | 5.4218 | 5.3482 | 5.3536 | 85104684.0 |
| 2009-07-21 12:00:00 | AAPL | Stock | 5.3532 | 5.3832 | 5.3507 | 5.3693 | 57696828.0 |
| 2009-07-21 13:00:00 | AAPL | Stock | 5.3693 | 5.3914 | 5.3571 | 5.3746 | 52932936.0 |
| 2009-07-21 14:00:00 | AAPL | Stock | 5.375 | 5.3918 | 5.3596 | 5.3907 | 65456720.0 |
| 2009-07-21 15:00:00 | AAPL | Stock | 5.3911 | 5.4179 | 5.3875 | 5.4143 | 149040556.0 |
| 2009-07-21 16:00:00 | AAPL | Stock | 5.4139 | 5.6161 | 5.2139 | 5.6125 | 170871428.0 |
| 2009-07-21 17:00:00 | AAPL | Stock | 5.6129 | 5.6732 | 5.4207 | 5.6536 | 60837952.0 |
| 2009-07-21 18:00:00 | AAPL | Stock | 5.6536 | 5.6643 | 5.4111 | 5.6525 | 7838908.0 |
| 2009-07-21 19:00:00 | AAPL | Stock | 5.6504 | 5.6571 | 5.6468 | 5.6571 | 3019632.0 |
| 2009-07-21 07:00:00 | MSFT | Stock | 24.57 | 24.57 | 24.57 | 24.57 | 100.0 |
| 2009-07-21 08:00:00 | MSFT | Stock | 24.54 | 24.71 | 24.54 | 24.7 | 19364.0 |
| 2009-07-21 09:00:00 | MSFT | Stock | 24.68 | 24.77 | 24.54 | 24.6 | 5535571.0 |
| 2009-07-21 10:00:00 | MSFT | Stock | 24.61 | 24.74 | 24.37 | 24.71 | 8768151.0 |
| 2009-07-21 11:00:00 | MSFT | Stock | 24.72 | 24.8 | 24.6 | 24.643 | 6610306.0 |
| 2009-07-21 12:00:00 | MSFT | Stock | 24.65 | 24.75 | 24.63 | 24.69 | 4400595.0 |
| 2009-07-21 13:00:00 | MSFT | Stock | 24.68 | 24.71 | 24.6 | 24.64 | 4767113.0 |
| 2009-07-21 14:00:00 | MSFT | Stock | 24.65 | 24.75 | 24.63 | 24.745 | 5189952.0 |
| 2009-07-21 15:00:00 | MSFT | Stock | 24.75 | 24.83 | 24.69 | 24.83 | 12272424.0 |
| 2009-07-21 16:00:00 | MSFT | Stock | 24.82 | 24.86 | 24.684 | 24.8 | 2271322.0 |
| 2009-07-21 17:00:00 | MSFT | Stock | 24.86 | 24.98 | 24.84 | 24.95 | 31235.0 |
| 2009-07-21 18:00:00 | MSFT | Stock | 24.83 | 24.98 | 24.83 | 24.95 | 22438.0 |
| 2009-07-21 19:00:00 | MSFT | Stock | 24.93 | 24.93 | 24.93 | 24.93 | 967.0 |
| 2009-07-21 08:00:00 | NVDA | Stock | 0.3038 | 0.3093 | 0.3028 | 0.309 | 296000.0 |
| 2009-07-21 09:00:00 | NVDA | Stock | 0.3075 | 0.3075 | 0.2955 | 0.2984 | 133980080.0 |
| 2009-07-21 10:00:00 | NVDA | Stock | 0.2982 | 0.3032 | 0.2975 | 0.3008 | 151472040.0 |
| 2009-07-21 11:00:00 | NVDA | Stock | 0.3008 | 0.301 | 0.2975 | 0.2985 | 111029680.0 |
| 2009-07-21 12:00:00 | NVDA | Stock | 0.2985 | 0.2988 | 0.2946 | 0.2948 | 118475600.0 |
| 2009-07-21 13:00:00 | NVDA | Stock | 0.2948 | 0.2952 | 0.2922 | 0.294 | 116165520.0 |
| 2009-07-21 14:00:00 | NVDA | Stock | 0.294 | 0.2982 | 0.2932 | 0.2974 | 96033240.0 |
| 2009-07-21 15:00:00 | NVDA | Stock | 0.2975 | 0.2992 | 0.2962 | 0.2992 | 145887840.0 |
| 2009-07-21 16:00:00 | NVDA | Stock | 0.2988 | 0.2995 | 0.2968 | 0.2995 | 46570400.0 |
| 2009-07-21 17:00:00 | NVDA | Stock | 0.2995 | 0.2995 | 0.2982 | 0.2982 | 160000.0 |
| 2009-07-21 18:00:00 | NVDA | Stock | 0.2982 | 0.2982 | 0.2978 | 0.2978 | 68800.0 |
| 2009-07-21 19:00:00 | NVDA | Stock | 0.2978 | 0.2995 | 0.2978 | 0.2995 | 84000.0 |
| 2009-07-21 06:00:00 | AMZN | Stock | 4.425 | 4.425 | 4.3855 | 4.3855 | 5000.0 |
| 2009-07-21 08:00:00 | AMZN | Stock | 4.4115 | 4.4375 | 4.4115 | 4.43 | 715560.0 |
| 2009-07-21 09:00:00 | AMZN | Stock | 4.43 | 4.4375 | 4.37 | 4.3955 | 21967420.0 |
| 2009-07-21 10:00:00 | AMZN | Stock | 4.396 | 4.439 | 4.3755 | 4.424 | 22822500.0 |
| 2009-07-21 11:00:00 | AMZN | Stock | 4.4255 | 4.4365 | 4.3862 | 4.3875 | 15772800.0 |
| 2009-07-21 12:00:00 | AMZN | Stock | 4.3865 | 4.416 | 4.3815 | 4.3929 | 42845540.0 |
| 2009-07-21 13:00:00 | AMZN | Stock | 4.393 | 4.41 | 4.3795 | 4.392 | 8738400.0 |
| 2009-07-21 14:00:00 | AMZN | Stock | 4.393 | 4.4175 | 4.3875 | 4.416 | 10451220.0 |
| 2009-07-21 15:00:00 | AMZN | Stock | 4.4175 | 4.45 | 4.41 | 4.45 | 23200180.0 |
> showing 50 of 41,123 rows — these rows as CSV