PREVIEW / stock_1hour / 2009-07-27
file: by_date/stock_1hour/2009/2009-07-27.parquet size: 857 KB rows: 41,949 symbols: 3,349
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-27 07:00:00 | AAPL | Stock | 5.7511 | 5.7675 | 5.7446 | 5.7464 | 232960.0 |
| 2009-07-27 08:00:00 | AAPL | Stock | 5.7493 | 5.7504 | 5.7204 | 5.7339 | 2329880.0 |
| 2009-07-27 09:00:00 | AAPL | Stock | 5.7346 | 5.7457 | 5.6911 | 5.6971 | 79488780.0 |
| 2009-07-27 10:00:00 | AAPL | Stock | 5.6971 | 5.725 | 5.6164 | 5.6582 | 105021280.0 |
| 2009-07-27 11:00:00 | AAPL | Stock | 5.6582 | 5.6957 | 5.6536 | 5.6793 | 58985332.0 |
| 2009-07-27 12:00:00 | AAPL | Stock | 5.6789 | 5.7021 | 5.6761 | 5.6812 | 36173200.0 |
| 2009-07-27 13:00:00 | AAPL | Stock | 5.6814 | 5.7089 | 5.6732 | 5.7061 | 34590248.0 |
| 2009-07-27 14:00:00 | AAPL | Stock | 5.7061 | 5.7132 | 5.695 | 5.6996 | 38973956.0 |
| 2009-07-27 15:00:00 | AAPL | Stock | 5.6996 | 5.7186 | 5.6775 | 5.7182 | 68116188.0 |
| 2009-07-27 16:00:00 | AAPL | Stock | 5.7182 | 5.7196 | 5.688 | 5.7179 | 6489280.0 |
| 2009-07-27 17:00:00 | AAPL | Stock | 5.7146 | 5.7146 | 5.7114 | 5.7125 | 123648.0 |
| 2009-07-27 18:00:00 | AAPL | Stock | 5.7146 | 5.7179 | 5.6821 | 5.7018 | 756980.0 |
| 2009-07-27 19:00:00 | AAPL | Stock | 5.7 | 5.7018 | 5.6861 | 5.6882 | 202384.0 |
| 2009-07-27 04:00:00 | MSFT | Stock | 23.55 | 23.55 | 23.55 | 23.55 | 175.0 |
| 2009-07-27 05:00:00 | MSFT | Stock | 23.56 | 23.57 | 23.56 | 23.57 | 350.0 |
| 2009-07-27 06:00:00 | MSFT | Stock | 23.6 | 23.6 | 23.6 | 23.6 | 287.0 |
| 2009-07-27 07:00:00 | MSFT | Stock | 23.61 | 23.68 | 23.4 | 23.48 | 40968.0 |
| 2009-07-27 08:00:00 | MSFT | Stock | 23.48 | 23.5 | 23.3 | 23.37 | 73813.0 |
| 2009-07-27 09:00:00 | MSFT | Stock | 23.36 | 23.45 | 23.05 | 23.29 | 11065713.0 |
| 2009-07-27 10:00:00 | MSFT | Stock | 23.3 | 23.44 | 23.03 | 23.11 | 13715094.0 |
| 2009-07-27 11:00:00 | MSFT | Stock | 23.11 | 23.19 | 23.05 | 23.08 | 9216606.0 |
| 2009-07-27 12:00:00 | MSFT | Stock | 23.079 | 23.12 | 23.0 | 23.05 | 8375619.0 |
| 2009-07-27 13:00:00 | MSFT | Stock | 23.05 | 23.05 | 22.9 | 23.008 | 8528850.0 |
| 2009-07-27 14:00:00 | MSFT | Stock | 23.01 | 23.08 | 23.0 | 23.03 | 7869357.0 |
| 2009-07-27 15:00:00 | MSFT | Stock | 23.03 | 23.1 | 22.92 | 23.1 | 14767700.0 |
| 2009-07-27 16:00:00 | MSFT | Stock | 23.11 | 23.18 | 23.05 | 23.14 | 4080654.0 |
| 2009-07-27 17:00:00 | MSFT | Stock | 23.15 | 23.15 | 23.11 | 23.12 | 16770.0 |
| 2009-07-27 18:00:00 | MSFT | Stock | 23.12 | 23.12 | 23.07 | 23.08 | 19276.0 |
| 2009-07-27 19:00:00 | MSFT | Stock | 23.07 | 23.12 | 23.07 | 23.09 | 5929.0 |
| 2009-07-27 20:00:00 | MSFT | Stock | 23.45 | 23.45 | 23.06 | 23.06 | 36000.0 |
| 2009-07-27 08:00:00 | NVDA | Stock | 0.325 | 0.325 | 0.3215 | 0.3215 | 76000.0 |
| 2009-07-27 09:00:00 | NVDA | Stock | 0.3215 | 0.3283 | 0.3203 | 0.3265 | 102681000.0 |
| 2009-07-27 10:00:00 | NVDA | Stock | 0.3268 | 0.3303 | 0.318 | 0.3203 | 198929280.0 |
| 2009-07-27 11:00:00 | NVDA | Stock | 0.3203 | 0.3255 | 0.32 | 0.3232 | 73936840.0 |
| 2009-07-27 12:00:00 | NVDA | Stock | 0.323 | 0.3255 | 0.3228 | 0.3243 | 45857360.0 |
| 2009-07-27 13:00:00 | NVDA | Stock | 0.3243 | 0.325 | 0.3235 | 0.324 | 53319800.0 |
| 2009-07-27 14:00:00 | NVDA | Stock | 0.3242 | 0.3255 | 0.323 | 0.3245 | 89386000.0 |
| 2009-07-27 15:00:00 | NVDA | Stock | 0.3248 | 0.326 | 0.3225 | 0.3258 | 97109720.0 |
| 2009-07-27 16:00:00 | NVDA | Stock | 0.3258 | 0.3258 | 0.3236 | 0.3255 | 10350600.0 |
| 2009-07-27 17:00:00 | NVDA | Stock | 0.3263 | 0.3263 | 0.3263 | 0.3263 | 20000.0 |
| 2009-07-27 06:00:00 | AMZN | Stock | 4.3295 | 4.3295 | 4.3295 | 4.3295 | 2000.0 |
| 2009-07-27 07:00:00 | AMZN | Stock | 4.3375 | 4.345 | 4.3295 | 4.3425 | 30000.0 |
| 2009-07-27 08:00:00 | AMZN | Stock | 4.3445 | 4.3485 | 4.3 | 4.3 | 252900.0 |
| 2009-07-27 09:00:00 | AMZN | Stock | 4.304 | 4.3245 | 4.2125 | 4.2388 | 38418620.0 |
| 2009-07-27 10:00:00 | AMZN | Stock | 4.2385 | 4.2685 | 4.186 | 4.2133 | 44388480.0 |
| 2009-07-27 11:00:00 | AMZN | Stock | 4.213 | 4.249 | 4.211 | 4.228 | 28420460.0 |
| 2009-07-27 12:00:00 | AMZN | Stock | 4.228 | 4.2305 | 4.2022 | 4.2065 | 11683280.0 |
| 2009-07-27 13:00:00 | AMZN | Stock | 4.2075 | 4.2095 | 4.1875 | 4.1925 | 12509380.0 |
| 2009-07-27 14:00:00 | AMZN | Stock | 4.193 | 4.2275 | 4.178 | 4.207 | 31418960.0 |
| 2009-07-27 15:00:00 | AMZN | Stock | 4.208 | 4.215 | 4.1905 | 4.2075 | 42349140.0 |
> showing 50 of 41,949 rows — these rows as CSV