PREVIEW / stock_1hour / 2009-06-22
file: by_date/stock_1hour/2009/2009-06-22.parquet size: 852 KB rows: 41,532 symbols: 3,350
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-06-22 04:00:00 | AAPL | Stock | 4.9811 | 4.9857 | 4.9811 | 4.9857 | 19600.0 |
| 2009-06-22 06:00:00 | AAPL | Stock | 4.9343 | 4.9496 | 4.9325 | 4.9325 | 44380.0 |
| 2009-06-22 07:00:00 | AAPL | Stock | 4.9325 | 4.9621 | 4.9204 | 4.9382 | 230160.0 |
| 2009-06-22 08:00:00 | AAPL | Stock | 4.9371 | 5.0282 | 4.9221 | 5.0079 | 9113552.0 |
| 2009-06-22 09:00:00 | AAPL | Stock | 5.0071 | 5.0557 | 4.9654 | 4.9746 | 135824584.0 |
| 2009-06-22 10:00:00 | AAPL | Stock | 4.9746 | 4.975 | 4.8929 | 4.8982 | 133992208.0 |
| 2009-06-22 11:00:00 | AAPL | Stock | 4.8986 | 4.9214 | 4.8689 | 4.9018 | 90186824.0 |
| 2009-06-22 12:00:00 | AAPL | Stock | 4.9024 | 4.9025 | 4.8714 | 4.8929 | 46176424.0 |
| 2009-06-22 13:00:00 | AAPL | Stock | 4.8925 | 4.9014 | 4.8775 | 4.9011 | 41758052.0 |
| 2009-06-22 14:00:00 | AAPL | Stock | 4.9007 | 4.9207 | 4.8971 | 4.9096 | 51314900.0 |
| 2009-06-22 15:00:00 | AAPL | Stock | 4.9104 | 4.9329 | 4.9007 | 4.9057 | 93518796.0 |
| 2009-06-22 16:00:00 | AAPL | Stock | 4.905 | 4.9319 | 4.8906 | 4.9036 | 21308840.0 |
| 2009-06-22 17:00:00 | AAPL | Stock | 4.9061 | 4.95 | 4.8857 | 4.8971 | 4913048.0 |
| 2009-06-22 18:00:00 | AAPL | Stock | 4.8943 | 4.9061 | 4.8929 | 4.8957 | 950292.0 |
| 2009-06-22 19:00:00 | AAPL | Stock | 4.8936 | 4.8982 | 4.875 | 4.8768 | 664748.0 |
| 2009-06-22 04:00:00 | MSFT | Stock | 24.11 | 24.11 | 24.11 | 24.11 | 900.0 |
| 2009-06-22 05:00:00 | MSFT | Stock | 24.06 | 24.06 | 24.06 | 24.06 | 300.0 |
| 2009-06-22 06:00:00 | MSFT | Stock | 24.06 | 24.11 | 24.06 | 24.09 | 1122.0 |
| 2009-06-22 07:00:00 | MSFT | Stock | 24.04 | 24.04 | 23.93 | 24.0 | 3889.0 |
| 2009-06-22 08:00:00 | MSFT | Stock | 24.0 | 24.07 | 23.89 | 23.91 | 52068.0 |
| 2009-06-22 09:00:00 | MSFT | Stock | 23.91 | 24.0 | 23.65 | 23.65 | 8904666.0 |
| 2009-06-22 10:00:00 | MSFT | Stock | 23.66 | 23.71 | 23.54 | 23.62 | 10291829.0 |
| 2009-06-22 11:00:00 | MSFT | Stock | 23.63 | 23.63 | 23.48 | 23.58 | 6146430.0 |
| 2009-06-22 12:00:00 | MSFT | Stock | 23.578 | 23.595 | 23.32 | 23.36 | 9129983.0 |
| 2009-06-22 13:00:00 | MSFT | Stock | 23.34 | 23.44 | 23.33 | 23.43 | 6114601.0 |
| 2009-06-22 14:00:00 | MSFT | Stock | 23.43 | 23.44 | 23.28 | 23.305 | 8037562.0 |
| 2009-06-22 15:00:00 | MSFT | Stock | 23.3 | 23.43 | 23.25 | 23.29 | 17260315.0 |
| 2009-06-22 16:00:00 | MSFT | Stock | 23.29 | 23.66 | 23.26 | 23.34 | 4633551.0 |
| 2009-06-22 17:00:00 | MSFT | Stock | 23.37 | 23.476 | 23.3 | 23.3 | 211231.0 |
| 2009-06-22 18:00:00 | MSFT | Stock | 23.3 | 23.39 | 23.27 | 23.3 | 14780.0 |
| 2009-06-22 19:00:00 | MSFT | Stock | 23.32 | 23.35 | 23.29 | 23.29 | 3523.0 |
| 2009-06-22 08:00:00 | NVDA | Stock | 0.2792 | 0.2795 | 0.2775 | 0.2775 | 80000.0 |
| 2009-06-22 09:00:00 | NVDA | Stock | 0.2775 | 0.2805 | 0.276 | 0.2768 | 52016000.0 |
| 2009-06-22 10:00:00 | NVDA | Stock | 0.277 | 0.277 | 0.2688 | 0.269 | 185106640.0 |
| 2009-06-22 11:00:00 | NVDA | Stock | 0.2692 | 0.2695 | 0.2638 | 0.2645 | 82617520.0 |
| 2009-06-22 12:00:00 | NVDA | Stock | 0.2646 | 0.2665 | 0.2628 | 0.2665 | 56886000.0 |
| 2009-06-22 13:00:00 | NVDA | Stock | 0.2665 | 0.2665 | 0.2632 | 0.2658 | 32113560.0 |
| 2009-06-22 14:00:00 | NVDA | Stock | 0.2658 | 0.2668 | 0.2643 | 0.266 | 40516520.0 |
| 2009-06-22 15:00:00 | NVDA | Stock | 0.266 | 0.2663 | 0.2635 | 0.2635 | 92174280.0 |
| 2009-06-22 16:00:00 | NVDA | Stock | 0.2632 | 0.2719 | 0.263 | 0.2643 | 31471840.0 |
| 2009-06-22 17:00:00 | NVDA | Stock | 0.2643 | 0.2643 | 0.2643 | 0.2643 | 10000.0 |
| 2009-06-22 08:00:00 | AMZN | Stock | 4.1125 | 4.148 | 4.112 | 4.112 | 38440.0 |
| 2009-06-22 09:00:00 | AMZN | Stock | 4.11 | 4.1345 | 4.0525 | 4.0685 | 12622920.0 |
| 2009-06-22 10:00:00 | AMZN | Stock | 4.069 | 4.094 | 4.032 | 4.041 | 17471120.0 |
| 2009-06-22 11:00:00 | AMZN | Stock | 4.0402 | 4.0415 | 3.9565 | 3.9585 | 29788760.0 |
| 2009-06-22 12:00:00 | AMZN | Stock | 3.9595 | 3.968 | 3.928 | 3.966 | 26815260.0 |
| 2009-06-22 13:00:00 | AMZN | Stock | 3.966 | 3.979 | 3.9475 | 3.9705 | 46523460.0 |
| 2009-06-22 14:00:00 | AMZN | Stock | 3.97 | 3.977 | 3.944 | 3.957 | 14692720.0 |
| 2009-06-22 15:00:00 | AMZN | Stock | 3.9575 | 3.9885 | 3.9435 | 3.957 | 39120380.0 |
| 2009-06-22 16:00:00 | AMZN | Stock | 3.9575 | 3.9897 | 3.943 | 3.947 | 2734540.0 |
> showing 50 of 41,532 rows — these rows as CSV