PREVIEW / stock_1hour / 2009-10-16
file: by_date/stock_1hour/2009/2009-10-16.parquet size: 881 KB rows: 42,002 symbols: 3,391
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-10-16 06:00:00 | AAPL | Stock | 6.8286 | 6.8286 | 6.7857 | 6.8057 | 215600.0 |
| 2009-10-16 07:00:00 | AAPL | Stock | 6.8025 | 6.8025 | 6.7686 | 6.7686 | 221312.0 |
| 2009-10-16 08:00:00 | AAPL | Stock | 6.7818 | 6.7836 | 6.7446 | 6.7489 | 2801316.0 |
| 2009-10-16 09:00:00 | AAPL | Stock | 6.75 | 6.7986 | 6.7282 | 6.7721 | 90938204.0 |
| 2009-10-16 10:00:00 | AAPL | Stock | 6.7721 | 6.7729 | 6.7339 | 6.7386 | 71884176.0 |
| 2009-10-16 11:00:00 | AAPL | Stock | 6.7382 | 6.7504 | 6.7293 | 6.7355 | 42601132.0 |
| 2009-10-16 12:00:00 | AAPL | Stock | 6.7364 | 6.75 | 6.7336 | 6.7443 | 33350800.0 |
| 2009-10-16 13:00:00 | AAPL | Stock | 6.7438 | 6.7693 | 6.7339 | 6.7552 | 44813580.0 |
| 2009-10-16 14:00:00 | AAPL | Stock | 6.755 | 6.76 | 6.7432 | 6.7453 | 29846180.0 |
| 2009-10-16 15:00:00 | AAPL | Stock | 6.7453 | 6.7607 | 6.7086 | 6.7179 | 88388076.0 |
| 2009-10-16 16:00:00 | AAPL | Stock | 6.7182 | 6.7472 | 6.6982 | 6.7089 | 11968460.0 |
| 2009-10-16 17:00:00 | AAPL | Stock | 6.7086 | 6.7186 | 6.6964 | 6.7179 | 1088416.0 |
| 2009-10-16 18:00:00 | AAPL | Stock | 6.7182 | 6.7221 | 6.6793 | 6.6821 | 2275616.0 |
| 2009-10-16 19:00:00 | AAPL | Stock | 6.685 | 6.6904 | 6.6775 | 6.6857 | 315504.0 |
| 2009-10-16 07:00:00 | MSFT | Stock | 26.58 | 26.58 | 26.58 | 26.58 | 1000.0 |
| 2009-10-16 08:00:00 | MSFT | Stock | 26.6 | 26.6 | 26.45 | 26.48 | 19191.0 |
| 2009-10-16 09:00:00 | MSFT | Stock | 26.48 | 26.71 | 26.41 | 26.44 | 5140371.0 |
| 2009-10-16 10:00:00 | MSFT | Stock | 26.44 | 26.55 | 26.16 | 26.165 | 8664445.0 |
| 2009-10-16 11:00:00 | MSFT | Stock | 26.16 | 26.2 | 26.1 | 26.19 | 5910985.0 |
| 2009-10-16 12:00:00 | MSFT | Stock | 26.18 | 26.27 | 26.1 | 26.17 | 4651132.0 |
| 2009-10-16 13:00:00 | MSFT | Stock | 26.171 | 26.56 | 26.15 | 26.44 | 7355165.0 |
| 2009-10-16 14:00:00 | MSFT | Stock | 26.44 | 26.53 | 26.38 | 26.43 | 4700063.0 |
| 2009-10-16 15:00:00 | MSFT | Stock | 26.42 | 26.54 | 26.41 | 26.49 | 8744233.0 |
| 2009-10-16 16:00:00 | MSFT | Stock | 26.49 | 26.567 | 26.344 | 26.47 | 4892125.0 |
| 2009-10-16 17:00:00 | MSFT | Stock | 26.45 | 26.47 | 26.32 | 26.32 | 9650.0 |
| 2009-10-16 18:00:00 | MSFT | Stock | 26.32 | 26.5 | 26.31 | 26.31 | 19754.0 |
| 2009-10-16 19:00:00 | MSFT | Stock | 26.36 | 26.37 | 26.33 | 26.33 | 1990.0 |
| 2009-10-16 07:00:00 | NVDA | Stock | 0.335 | 0.3353 | 0.335 | 0.335 | 120000.0 |
| 2009-10-16 08:00:00 | NVDA | Stock | 0.3382 | 0.3382 | 0.3338 | 0.335 | 10673640.0 |
| 2009-10-16 09:00:00 | NVDA | Stock | 0.3353 | 0.3358 | 0.3278 | 0.332 | 192789840.0 |
| 2009-10-16 10:00:00 | NVDA | Stock | 0.3315 | 0.3315 | 0.3288 | 0.3293 | 124646480.0 |
| 2009-10-16 11:00:00 | NVDA | Stock | 0.3293 | 0.3294 | 0.3245 | 0.3258 | 158748160.0 |
| 2009-10-16 12:00:00 | NVDA | Stock | 0.326 | 0.3298 | 0.326 | 0.329 | 107363800.0 |
| 2009-10-16 13:00:00 | NVDA | Stock | 0.3288 | 0.3335 | 0.328 | 0.3315 | 109799040.0 |
| 2009-10-16 14:00:00 | NVDA | Stock | 0.3317 | 0.3317 | 0.328 | 0.3308 | 139693160.0 |
| 2009-10-16 15:00:00 | NVDA | Stock | 0.3308 | 0.3315 | 0.3295 | 0.3305 | 157718920.0 |
| 2009-10-16 16:00:00 | NVDA | Stock | 0.33 | 0.3313 | 0.3295 | 0.3313 | 6100880.0 |
| 2009-10-16 17:00:00 | NVDA | Stock | 0.33 | 0.33 | 0.33 | 0.33 | 20000.0 |
| 2009-10-16 18:00:00 | NVDA | Stock | 0.3303 | 0.3303 | 0.3303 | 0.3303 | 5600.0 |
| 2009-10-16 19:00:00 | NVDA | Stock | 0.3303 | 0.3303 | 0.3295 | 0.3295 | 88000.0 |
| 2009-10-16 04:00:00 | AMZN | Stock | 4.825 | 4.825 | 4.825 | 4.825 | 2000.0 |
| 2009-10-16 06:00:00 | AMZN | Stock | 4.8 | 4.8 | 4.8 | 4.8 | 8420.0 |
| 2009-10-16 08:00:00 | AMZN | Stock | 4.805 | 4.805 | 4.7405 | 4.7575 | 467000.0 |
| 2009-10-16 09:00:00 | AMZN | Stock | 4.8005 | 4.806 | 4.711 | 4.7285 | 28798280.0 |
| 2009-10-16 10:00:00 | AMZN | Stock | 4.7285 | 4.731 | 4.6805 | 4.722 | 29005820.0 |
| 2009-10-16 11:00:00 | AMZN | Stock | 4.7205 | 4.748 | 4.713 | 4.7265 | 14799940.0 |
| 2009-10-16 12:00:00 | AMZN | Stock | 4.7252 | 4.7445 | 4.722 | 4.7425 | 9990460.0 |
| 2009-10-16 13:00:00 | AMZN | Stock | 4.743 | 4.7655 | 4.7325 | 4.7475 | 12686240.0 |
| 2009-10-16 14:00:00 | AMZN | Stock | 4.7475 | 4.7595 | 4.7335 | 4.738 | 10049300.0 |
| 2009-10-16 15:00:00 | AMZN | Stock | 4.7385 | 4.768 | 4.7375 | 4.766 | 29223960.0 |
> showing 50 of 42,002 rows — these rows as CSV