PREVIEW / stock_1hour / 2008-09-30
file: by_date/stock_1hour/2008/2008-09-30.parquet size: 878 KB rows: 43,666 symbols: 3,384
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-30 04:00:00 | AAPL | Stock | 3.7882 | 3.8211 | 3.7746 | 3.7821 | 248052.0 |
| 2008-09-30 05:00:00 | AAPL | Stock | 3.7768 | 3.8214 | 3.7768 | 3.8214 | 278460.0 |
| 2008-09-30 06:00:00 | AAPL | Stock | 3.8214 | 3.8214 | 3.7743 | 3.7768 | 822528.0 |
| 2008-09-30 07:00:00 | AAPL | Stock | 3.7768 | 3.8293 | 3.7596 | 3.8111 | 3365712.0 |
| 2008-09-30 08:00:00 | AAPL | Stock | 3.7857 | 3.8661 | 3.7589 | 3.8071 | 11021472.0 |
| 2008-09-30 09:00:00 | AAPL | Stock | 3.8057 | 3.9204 | 3.7964 | 3.8475 | 252229712.0 |
| 2008-09-30 10:00:00 | AAPL | Stock | 3.8475 | 3.9489 | 3.8418 | 3.8941 | 293852692.0 |
| 2008-09-30 11:00:00 | AAPL | Stock | 3.8939 | 3.975 | 3.875 | 3.9596 | 192318980.0 |
| 2008-09-30 12:00:00 | AAPL | Stock | 3.9596 | 3.9857 | 3.9154 | 3.9804 | 142529520.0 |
| 2008-09-30 13:00:00 | AAPL | Stock | 3.9804 | 4.0293 | 3.9579 | 3.9957 | 157742984.0 |
| 2008-09-30 14:00:00 | AAPL | Stock | 3.9954 | 4.0429 | 3.9857 | 4.0082 | 145212004.0 |
| 2008-09-30 15:00:00 | AAPL | Stock | 4.0082 | 4.1071 | 3.9993 | 4.0611 | 295659448.0 |
| 2008-09-30 16:00:00 | AAPL | Stock | 3.8821 | 4.1071 | 3.8821 | 3.9528 | 55643924.0 |
| 2008-09-30 17:00:00 | AAPL | Stock | 4.0586 | 4.0639 | 3.9563 | 4.0607 | 12753188.0 |
| 2008-09-30 18:00:00 | AAPL | Stock | 4.0596 | 4.0693 | 4.05 | 4.05 | 594048.0 |
| 2008-09-30 19:00:00 | AAPL | Stock | 4.0536 | 4.0714 | 4.05 | 4.0707 | 487648.0 |
| 2008-09-30 04:00:00 | MSFT | Stock | 25.0 | 25.23 | 25.0 | 25.22 | 1600.0 |
| 2008-09-30 05:00:00 | MSFT | Stock | 25.45 | 25.45 | 25.45 | 25.45 | 1000.0 |
| 2008-09-30 06:00:00 | MSFT | Stock | 25.36 | 25.53 | 25.36 | 25.43 | 8100.0 |
| 2008-09-30 07:00:00 | MSFT | Stock | 25.43 | 25.6 | 25.43 | 25.51 | 17750.0 |
| 2008-09-30 08:00:00 | MSFT | Stock | 25.58 | 25.7 | 25.45 | 25.66 | 131915.0 |
| 2008-09-30 09:00:00 | MSFT | Stock | 25.66 | 26.0 | 25.54 | 25.7 | 9456561.0 |
| 2008-09-30 10:00:00 | MSFT | Stock | 25.69 | 25.98 | 25.57 | 25.81 | 12588247.0 |
| 2008-09-30 11:00:00 | MSFT | Stock | 25.81 | 25.84 | 25.68 | 25.83 | 11854249.0 |
| 2008-09-30 12:00:00 | MSFT | Stock | 25.82 | 25.87 | 25.66 | 25.735 | 7517484.0 |
| 2008-09-30 13:00:00 | MSFT | Stock | 25.74 | 26.32 | 25.66 | 26.07 | 15619905.0 |
| 2008-09-30 14:00:00 | MSFT | Stock | 26.08 | 26.27 | 25.99 | 26.162 | 9772415.0 |
| 2008-09-30 15:00:00 | MSFT | Stock | 26.17 | 26.69 | 26.06 | 26.68 | 25278797.0 |
| 2008-09-30 16:00:00 | MSFT | Stock | 26.69 | 26.73 | 25.879 | 26.5 | 10351980.0 |
| 2008-09-30 17:00:00 | MSFT | Stock | 26.5 | 26.69 | 26.079 | 26.6 | 1305887.0 |
| 2008-09-30 18:00:00 | MSFT | Stock | 26.6 | 26.69 | 26.5 | 26.5 | 9008.0 |
| 2008-09-30 19:00:00 | MSFT | Stock | 26.5 | 26.65 | 26.5 | 26.58 | 8423.0 |
| 2008-09-30 08:00:00 | NVDA | Stock | 0.2575 | 0.261 | 0.2563 | 0.261 | 429520.0 |
| 2008-09-30 09:00:00 | NVDA | Stock | 0.2628 | 0.2628 | 0.2538 | 0.255 | 63322800.0 |
| 2008-09-30 10:00:00 | NVDA | Stock | 0.255 | 0.2608 | 0.254 | 0.258 | 74874160.0 |
| 2008-09-30 11:00:00 | NVDA | Stock | 0.258 | 0.2623 | 0.2558 | 0.2612 | 51272320.0 |
| 2008-09-30 12:00:00 | NVDA | Stock | 0.2612 | 0.2623 | 0.2595 | 0.2615 | 33961040.0 |
| 2008-09-30 13:00:00 | NVDA | Stock | 0.2615 | 0.264 | 0.2598 | 0.2632 | 130108760.0 |
| 2008-09-30 14:00:00 | NVDA | Stock | 0.2632 | 0.2688 | 0.263 | 0.2663 | 117615720.0 |
| 2008-09-30 15:00:00 | NVDA | Stock | 0.2663 | 0.2703 | 0.264 | 0.268 | 126935120.0 |
| 2008-09-30 16:00:00 | NVDA | Stock | 0.268 | 0.2683 | 0.2624 | 0.264 | 40298480.0 |
| 2008-09-30 17:00:00 | NVDA | Stock | 0.2669 | 0.2678 | 0.2627 | 0.2678 | 7654760.0 |
| 2008-09-30 18:00:00 | NVDA | Stock | 0.2678 | 0.2688 | 0.2678 | 0.2688 | 299560.0 |
| 2008-09-30 08:00:00 | AMZN | Stock | 3.2735 | 3.297 | 3.2735 | 3.2825 | 48060.0 |
| 2008-09-30 09:00:00 | AMZN | Stock | 3.2255 | 3.433 | 3.2255 | 3.4245 | 51533940.0 |
| 2008-09-30 10:00:00 | AMZN | Stock | 3.4245 | 3.471 | 3.3795 | 3.42 | 47698700.0 |
| 2008-09-30 11:00:00 | AMZN | Stock | 3.4205 | 3.45 | 3.384 | 3.446 | 23916360.0 |
| 2008-09-30 12:00:00 | AMZN | Stock | 3.447 | 3.473 | 3.409 | 3.4615 | 14689120.0 |
| 2008-09-30 13:00:00 | AMZN | Stock | 3.4625 | 3.55 | 3.45 | 3.5315 | 27213860.0 |
| 2008-09-30 14:00:00 | AMZN | Stock | 3.532 | 3.5985 | 3.5165 | 3.5625 | 26951720.0 |
> showing 50 of 43,666 rows — these rows as CSV