PREVIEW / stock_1hour / 2009-07-30
file: by_date/stock_1hour/2009/2009-07-30.parquet size: 860 KB rows: 41,842 symbols: 3,367
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-30 04:00:00 | AAPL | Stock | 5.7261 | 5.7264 | 5.7261 | 5.7264 | 5600.0 |
| 2009-07-30 07:00:00 | AAPL | Stock | 5.75 | 5.7704 | 5.7393 | 5.7586 | 312900.0 |
| 2009-07-30 08:00:00 | AAPL | Stock | 5.7536 | 5.7764 | 5.75 | 5.775 | 2379496.0 |
| 2009-07-30 09:00:00 | AAPL | Stock | 5.7746 | 5.8743 | 5.7679 | 5.8725 | 95950764.0 |
| 2009-07-30 10:00:00 | AAPL | Stock | 5.8725 | 5.8782 | 5.8446 | 5.8636 | 81300492.0 |
| 2009-07-30 11:00:00 | AAPL | Stock | 5.8639 | 5.87 | 5.85 | 5.8501 | 43967280.0 |
| 2009-07-30 12:00:00 | AAPL | Stock | 5.8511 | 5.8554 | 5.8364 | 5.843 | 40706008.0 |
| 2009-07-30 13:00:00 | AAPL | Stock | 5.8429 | 5.8604 | 5.8404 | 5.8489 | 38032232.0 |
| 2009-07-30 14:00:00 | AAPL | Stock | 5.8493 | 5.8732 | 5.8364 | 5.8679 | 51603608.0 |
| 2009-07-30 15:00:00 | AAPL | Stock | 5.8679 | 5.8829 | 5.7857 | 5.8125 | 96567016.0 |
| 2009-07-30 16:00:00 | AAPL | Stock | 5.8136 | 5.8571 | 5.7154 | 5.7964 | 12387676.0 |
| 2009-07-30 17:00:00 | AAPL | Stock | 5.7986 | 5.8121 | 5.7911 | 5.7982 | 165144.0 |
| 2009-07-30 18:00:00 | AAPL | Stock | 5.7968 | 5.8139 | 5.7968 | 5.8064 | 792204.0 |
| 2009-07-30 19:00:00 | AAPL | Stock | 5.8086 | 5.8132 | 5.8054 | 5.8121 | 213976.0 |
| 2009-07-30 05:00:00 | MSFT | Stock | 23.91 | 23.92 | 23.91 | 23.92 | 670.0 |
| 2009-07-30 07:00:00 | MSFT | Stock | 24.0 | 24.05 | 23.95 | 23.95 | 8521.0 |
| 2009-07-30 08:00:00 | MSFT | Stock | 23.93 | 24.0 | 23.85 | 23.99 | 81005.0 |
| 2009-07-30 09:00:00 | MSFT | Stock | 23.99 | 24.3 | 23.96 | 24.22 | 10401180.0 |
| 2009-07-30 10:00:00 | MSFT | Stock | 24.23 | 24.43 | 24.2 | 24.38 | 12234693.0 |
| 2009-07-30 11:00:00 | MSFT | Stock | 24.38 | 24.43 | 24.0 | 24.0 | 10606948.0 |
| 2009-07-30 12:00:00 | MSFT | Stock | 24.01 | 24.1 | 23.92 | 24.07 | 6767236.0 |
| 2009-07-30 13:00:00 | MSFT | Stock | 24.07 | 24.15 | 23.99 | 23.99 | 4916738.0 |
| 2009-07-30 14:00:00 | MSFT | Stock | 23.99 | 24.0 | 23.88 | 23.97 | 4674790.0 |
| 2009-07-30 15:00:00 | MSFT | Stock | 23.96 | 24.02 | 23.71 | 23.81 | 13883707.0 |
| 2009-07-30 16:00:00 | MSFT | Stock | 23.81 | 24.09 | 23.68 | 23.69 | 2709660.0 |
| 2009-07-30 17:00:00 | MSFT | Stock | 23.69 | 23.72 | 23.66 | 23.7 | 17268.0 |
| 2009-07-30 18:00:00 | MSFT | Stock | 23.7 | 23.81 | 23.68 | 23.68 | 10044.0 |
| 2009-07-30 19:00:00 | MSFT | Stock | 23.68 | 23.73 | 23.68 | 23.71 | 13832.0 |
| 2009-07-30 08:00:00 | NVDA | Stock | 0.3275 | 0.3275 | 0.3215 | 0.3258 | 116400.0 |
| 2009-07-30 09:00:00 | NVDA | Stock | 0.326 | 0.3293 | 0.324 | 0.3285 | 72160960.0 |
| 2009-07-30 10:00:00 | NVDA | Stock | 0.3285 | 0.3293 | 0.3265 | 0.3283 | 82813800.0 |
| 2009-07-30 11:00:00 | NVDA | Stock | 0.3283 | 0.3285 | 0.3203 | 0.321 | 73772840.0 |
| 2009-07-30 12:00:00 | NVDA | Stock | 0.3213 | 0.3228 | 0.3193 | 0.3208 | 62470280.0 |
| 2009-07-30 13:00:00 | NVDA | Stock | 0.3208 | 0.3233 | 0.3208 | 0.3215 | 30990800.0 |
| 2009-07-30 14:00:00 | NVDA | Stock | 0.3215 | 0.3243 | 0.3213 | 0.3235 | 31116560.0 |
| 2009-07-30 15:00:00 | NVDA | Stock | 0.3238 | 0.3248 | 0.3205 | 0.322 | 100489240.0 |
| 2009-07-30 16:00:00 | NVDA | Stock | 0.322 | 0.3244 | 0.3155 | 0.322 | 12998240.0 |
| 2009-07-30 17:00:00 | NVDA | Stock | 0.3175 | 0.3225 | 0.3175 | 0.3225 | 28000.0 |
| 2009-07-30 19:00:00 | NVDA | Stock | 0.3225 | 0.3225 | 0.3225 | 0.3225 | 32000.0 |
| 2009-07-30 05:00:00 | AMZN | Stock | 4.25 | 4.25 | 4.25 | 4.25 | 2000.0 |
| 2009-07-30 07:00:00 | AMZN | Stock | 4.225 | 4.2375 | 4.225 | 4.2375 | 16000.0 |
| 2009-07-30 08:00:00 | AMZN | Stock | 4.2375 | 4.277 | 4.228 | 4.268 | 402580.0 |
| 2009-07-30 09:00:00 | AMZN | Stock | 4.27 | 4.3215 | 4.2585 | 4.3088 | 20197760.0 |
| 2009-07-30 10:00:00 | AMZN | Stock | 4.31 | 4.325 | 4.2835 | 4.3165 | 28961320.0 |
| 2009-07-30 11:00:00 | AMZN | Stock | 4.317 | 4.334 | 4.3025 | 4.3085 | 20951380.0 |
| 2009-07-30 12:00:00 | AMZN | Stock | 4.309 | 4.322 | 4.306 | 4.3105 | 11075560.0 |
| 2009-07-30 13:00:00 | AMZN | Stock | 4.3115 | 4.322 | 4.308 | 4.316 | 11606260.0 |
| 2009-07-30 14:00:00 | AMZN | Stock | 4.316 | 4.3625 | 4.3155 | 4.351 | 22041860.0 |
| 2009-07-30 15:00:00 | AMZN | Stock | 4.351 | 4.3625 | 4.3005 | 4.3055 | 26013500.0 |
| 2009-07-30 16:00:00 | AMZN | Stock | 4.305 | 4.3199 | 4.3005 | 4.305 | 2882880.0 |
> showing 50 of 41,842 rows — these rows as CSV