PREVIEW / stock_1hour / 2008-08-01
file: by_date/stock_1hour/2008/2008-08-01.parquet size: 833 KB rows: 40,276 symbols: 3,300
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-08-01 06:00:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6786 | 5.6786 | 5600.0 |
| 2008-08-01 08:00:00 | AAPL | Stock | 5.6786 | 5.7421 | 5.6632 | 5.7086 | 5068868.0 |
| 2008-08-01 09:00:00 | AAPL | Stock | 5.7104 | 5.7246 | 5.5625 | 5.6011 | 96216876.0 |
| 2008-08-01 10:00:00 | AAPL | Stock | 5.6011 | 5.6336 | 5.5682 | 5.6054 | 103784044.0 |
| 2008-08-01 11:00:00 | AAPL | Stock | 5.6054 | 5.6482 | 5.5729 | 5.6414 | 67001424.0 |
| 2008-08-01 12:00:00 | AAPL | Stock | 5.6393 | 5.6421 | 5.5725 | 5.5879 | 51906904.0 |
| 2008-08-01 13:00:00 | AAPL | Stock | 5.5871 | 5.6336 | 5.5829 | 5.6093 | 49248304.0 |
| 2008-08-01 14:00:00 | AAPL | Stock | 5.6089 | 5.6221 | 5.5757 | 5.6139 | 57375640.0 |
| 2008-08-01 15:00:00 | AAPL | Stock | 5.6143 | 5.6339 | 5.5825 | 5.595 | 79170924.0 |
| 2008-08-01 16:00:00 | AAPL | Stock | 5.595 | 5.6768 | 5.5896 | 5.6011 | 8150268.0 |
| 2008-08-01 17:00:00 | AAPL | Stock | 5.6061 | 5.6111 | 5.595 | 5.6043 | 21758016.0 |
| 2008-08-01 18:00:00 | AAPL | Stock | 5.6025 | 5.6036 | 5.6025 | 5.6036 | 16100.0 |
| 2008-08-01 19:00:00 | AAPL | Stock | 5.6032 | 5.6032 | 5.5821 | 5.5982 | 170856.0 |
| 2008-08-01 07:00:00 | MSFT | Stock | 25.85 | 25.85 | 25.85 | 25.85 | 500.0 |
| 2008-08-01 08:00:00 | MSFT | Stock | 25.86 | 25.95 | 25.82 | 25.9 | 6680.0 |
| 2008-08-01 09:00:00 | MSFT | Stock | 25.9 | 26.0 | 25.07 | 25.24 | 10283769.0 |
| 2008-08-01 10:00:00 | MSFT | Stock | 25.24 | 25.37 | 25.18 | 25.25 | 18675093.0 |
| 2008-08-01 11:00:00 | MSFT | Stock | 25.25 | 25.27 | 25.18 | 25.24 | 9298010.0 |
| 2008-08-01 12:00:00 | MSFT | Stock | 25.248 | 25.27 | 25.19 | 25.25 | 7223572.0 |
| 2008-08-01 13:00:00 | MSFT | Stock | 25.24 | 25.48 | 25.23 | 25.39 | 8407413.0 |
| 2008-08-01 14:00:00 | MSFT | Stock | 25.38 | 25.51 | 25.25 | 25.49 | 9227023.0 |
| 2008-08-01 15:00:00 | MSFT | Stock | 25.48 | 25.52 | 25.37 | 25.44 | 12466702.0 |
| 2008-08-01 16:00:00 | MSFT | Stock | 25.44 | 25.53 | 25.322 | 25.44 | 2173655.0 |
| 2008-08-01 17:00:00 | MSFT | Stock | 25.44 | 25.44 | 25.342 | 25.44 | 3280430.0 |
| 2008-08-01 18:00:00 | MSFT | Stock | 25.42 | 25.42 | 25.41 | 25.41 | 950.0 |
| 2008-08-01 19:00:00 | MSFT | Stock | 25.45 | 25.45 | 25.41 | 25.41 | 3910.0 |
| 2008-08-01 08:00:00 | NVDA | Stock | 0.286 | 0.288 | 0.286 | 0.2862 | 504000.0 |
| 2008-08-01 09:00:00 | NVDA | Stock | 0.286 | 0.286 | 0.271 | 0.2728 | 181926160.0 |
| 2008-08-01 10:00:00 | NVDA | Stock | 0.273 | 0.2755 | 0.2675 | 0.2728 | 183324800.0 |
| 2008-08-01 11:00:00 | NVDA | Stock | 0.2728 | 0.276 | 0.2712 | 0.2748 | 86416000.0 |
| 2008-08-01 12:00:00 | NVDA | Stock | 0.2745 | 0.275 | 0.2703 | 0.2712 | 79387680.0 |
| 2008-08-01 13:00:00 | NVDA | Stock | 0.2715 | 0.2723 | 0.2692 | 0.2705 | 121149440.0 |
| 2008-08-01 14:00:00 | NVDA | Stock | 0.2705 | 0.271 | 0.2688 | 0.2708 | 93591800.0 |
| 2008-08-01 15:00:00 | NVDA | Stock | 0.2708 | 0.2725 | 0.2692 | 0.2712 | 120835040.0 |
| 2008-08-01 16:00:00 | NVDA | Stock | 0.271 | 0.2723 | 0.271 | 0.272 | 3723440.0 |
| 2008-08-01 17:00:00 | NVDA | Stock | 0.272 | 0.2722 | 0.272 | 0.272 | 240000.0 |
| 2008-08-01 18:00:00 | NVDA | Stock | 0.2718 | 0.2718 | 0.2718 | 0.2718 | 16000.0 |
| 2008-08-01 19:00:00 | NVDA | Stock | 0.2718 | 0.2723 | 0.2712 | 0.2723 | 239200.0 |
| 2008-08-01 08:00:00 | AMZN | Stock | 3.8 | 3.837 | 3.8 | 3.8145 | 1201000.0 |
| 2008-08-01 09:00:00 | AMZN | Stock | 3.8395 | 3.85 | 3.7205 | 3.753 | 17156700.0 |
| 2008-08-01 10:00:00 | AMZN | Stock | 3.753 | 3.7925 | 3.7025 | 3.7625 | 18934600.0 |
| 2008-08-01 11:00:00 | AMZN | Stock | 3.7635 | 3.794 | 3.7395 | 3.786 | 8583220.0 |
| 2008-08-01 12:00:00 | AMZN | Stock | 3.7865 | 3.7865 | 3.753 | 3.7595 | 7209100.0 |
| 2008-08-01 13:00:00 | AMZN | Stock | 3.7585 | 3.809 | 3.7545 | 3.7925 | 10161780.0 |
| 2008-08-01 14:00:00 | AMZN | Stock | 3.794 | 3.82 | 3.7725 | 3.8059 | 11586300.0 |
| 2008-08-01 15:00:00 | AMZN | Stock | 3.805 | 3.8205 | 3.783 | 3.788 | 17543040.0 |
| 2008-08-01 16:00:00 | AMZN | Stock | 3.7885 | 3.7988 | 3.777 | 3.7875 | 2672880.0 |
| 2008-08-01 17:00:00 | AMZN | Stock | 3.7925 | 3.7925 | 3.777 | 3.777 | 17000.0 |
| 2008-08-01 19:00:00 | AMZN | Stock | 3.784 | 3.784 | 3.784 | 3.784 | 2000.0 |
| 2008-08-01 08:00:00 | TLT | Stock | 91.2 | 91.21 | 91.0 | 91.0 | 6600.0 |
> showing 50 of 40,276 rows — these rows as CSV