PREVIEW / stock_1hour / 2009-11-24
file: by_date/stock_1hour/2009/2009-11-24.parquet size: 879 KB rows: 42,064 symbols: 3,416
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-11-24 05:00:00 | AAPL | Stock | 7.3514 | 7.3514 | 7.3054 | 7.3054 | 43512.0 |
| 2009-11-24 07:00:00 | AAPL | Stock | 7.3468 | 7.35 | 7.3418 | 7.3418 | 65800.0 |
| 2009-11-24 08:00:00 | AAPL | Stock | 7.3396 | 7.3493 | 7.3143 | 7.3321 | 1193584.0 |
| 2009-11-24 09:00:00 | AAPL | Stock | 7.3343 | 7.3432 | 7.2464 | 7.2564 | 72662324.0 |
| 2009-11-24 10:00:00 | AAPL | Stock | 7.2571 | 7.2946 | 7.25 | 7.2864 | 65585660.0 |
| 2009-11-24 11:00:00 | AAPL | Stock | 7.2862 | 7.2939 | 7.2589 | 7.275 | 30078132.0 |
| 2009-11-24 12:00:00 | AAPL | Stock | 7.2757 | 7.2839 | 7.2646 | 7.2686 | 15250956.0 |
| 2009-11-24 13:00:00 | AAPL | Stock | 7.2676 | 7.2929 | 7.2657 | 7.2871 | 18464096.0 |
| 2009-11-24 14:00:00 | AAPL | Stock | 7.2868 | 7.3268 | 7.2814 | 7.3161 | 38493028.0 |
| 2009-11-24 15:00:00 | AAPL | Stock | 7.3164 | 7.325 | 7.2929 | 7.3014 | 57679104.0 |
| 2009-11-24 16:00:00 | AAPL | Stock | 7.3014 | 7.3105 | 7.2557 | 7.3014 | 10593184.0 |
| 2009-11-24 17:00:00 | AAPL | Stock | 7.3029 | 7.3086 | 7.3029 | 7.3068 | 140476.0 |
| 2009-11-24 18:00:00 | AAPL | Stock | 7.3068 | 7.3089 | 7.3014 | 7.3043 | 254996.0 |
| 2009-11-24 19:00:00 | AAPL | Stock | 7.3054 | 7.3114 | 7.3054 | 7.3089 | 177184.0 |
| 2009-11-24 04:00:00 | MSFT | Stock | 29.76 | 29.76 | 29.76 | 29.76 | 300.0 |
| 2009-11-24 08:00:00 | MSFT | Stock | 29.95 | 29.95 | 29.9 | 29.9 | 4405.0 |
| 2009-11-24 09:00:00 | MSFT | Stock | 29.94 | 30.0 | 29.79 | 29.84 | 6259047.0 |
| 2009-11-24 10:00:00 | MSFT | Stock | 29.81 | 29.99 | 29.75 | 29.98 | 6048492.0 |
| 2009-11-24 11:00:00 | MSFT | Stock | 29.988 | 29.99 | 29.9 | 29.928 | 3873456.0 |
| 2009-11-24 12:00:00 | MSFT | Stock | 29.921 | 29.93 | 29.86 | 29.86 | 1985401.0 |
| 2009-11-24 13:00:00 | MSFT | Stock | 29.87 | 29.94 | 29.85 | 29.87 | 3794979.0 |
| 2009-11-24 14:00:00 | MSFT | Stock | 29.87 | 29.9 | 29.8 | 29.855 | 6224240.0 |
| 2009-11-24 15:00:00 | MSFT | Stock | 29.86 | 29.93 | 29.84 | 29.9 | 6051702.0 |
| 2009-11-24 16:00:00 | MSFT | Stock | 29.92 | 29.94 | 29.87 | 29.91 | 1739841.0 |
| 2009-11-24 17:00:00 | MSFT | Stock | 29.93 | 29.93 | 29.7 | 29.73 | 63845.0 |
| 2009-11-24 18:00:00 | MSFT | Stock | 29.75 | 29.91 | 29.68 | 29.7 | 48587.0 |
| 2009-11-24 19:00:00 | MSFT | Stock | 29.7 | 29.74 | 29.7 | 29.74 | 1901.0 |
| 2009-11-24 08:00:00 | NVDA | Stock | 0.3218 | 0.324 | 0.3218 | 0.324 | 8000.0 |
| 2009-11-24 09:00:00 | NVDA | Stock | 0.3228 | 0.3258 | 0.319 | 0.3198 | 44527360.0 |
| 2009-11-24 10:00:00 | NVDA | Stock | 0.3198 | 0.3218 | 0.3178 | 0.3195 | 114114120.0 |
| 2009-11-24 11:00:00 | NVDA | Stock | 0.3195 | 0.3213 | 0.3188 | 0.321 | 84122720.0 |
| 2009-11-24 12:00:00 | NVDA | Stock | 0.3213 | 0.3225 | 0.321 | 0.3225 | 27680800.0 |
| 2009-11-24 13:00:00 | NVDA | Stock | 0.3225 | 0.3228 | 0.3223 | 0.3224 | 22754200.0 |
| 2009-11-24 14:00:00 | NVDA | Stock | 0.3223 | 0.3253 | 0.322 | 0.3245 | 39981200.0 |
| 2009-11-24 15:00:00 | NVDA | Stock | 0.3245 | 0.325 | 0.323 | 0.323 | 67935680.0 |
| 2009-11-24 16:00:00 | NVDA | Stock | 0.323 | 0.3318 | 0.3215 | 0.323 | 13058120.0 |
| 2009-11-24 17:00:00 | NVDA | Stock | 0.3263 | 0.3265 | 0.325 | 0.325 | 103960.0 |
| 2009-11-24 18:00:00 | NVDA | Stock | 0.3265 | 0.3273 | 0.325 | 0.325 | 100000.0 |
| 2009-11-24 19:00:00 | NVDA | Stock | 0.329 | 0.329 | 0.3275 | 0.3275 | 14000.0 |
| 2009-11-24 07:00:00 | AMZN | Stock | 6.7 | 6.72 | 6.7 | 6.705 | 79360.0 |
| 2009-11-24 08:00:00 | AMZN | Stock | 6.705 | 6.71 | 6.652 | 6.675 | 866460.0 |
| 2009-11-24 09:00:00 | AMZN | Stock | 6.675 | 6.7165 | 6.611 | 6.6325 | 25538760.0 |
| 2009-11-24 10:00:00 | AMZN | Stock | 6.6325 | 6.7025 | 6.6162 | 6.6645 | 33986240.0 |
| 2009-11-24 11:00:00 | AMZN | Stock | 6.6668 | 6.6725 | 6.64 | 6.6518 | 13131120.0 |
| 2009-11-24 12:00:00 | AMZN | Stock | 6.652 | 6.669 | 6.626 | 6.6316 | 15134240.0 |
| 2009-11-24 13:00:00 | AMZN | Stock | 6.632 | 6.6518 | 6.6275 | 6.631 | 9136820.0 |
| 2009-11-24 14:00:00 | AMZN | Stock | 6.63 | 6.651 | 6.616 | 6.6415 | 21596660.0 |
| 2009-11-24 15:00:00 | AMZN | Stock | 6.6405 | 6.6625 | 6.633 | 6.649 | 22590760.0 |
| 2009-11-24 16:00:00 | AMZN | Stock | 6.647 | 6.6585 | 6.646 | 6.647 | 2788780.0 |
| 2009-11-24 17:00:00 | AMZN | Stock | 6.6575 | 6.6625 | 6.6535 | 6.6605 | 148260.0 |
> showing 50 of 42,064 rows — these rows as CSV