PREVIEW / stock_1hour / 2008-03-24
file: by_date/stock_1hour/2008/2008-03-24.parquet size: 825 KB rows: 41,303 symbols: 3,298
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-03-24 07:00:00 | AAPL | Stock | 4.7686 | 4.7946 | 4.7686 | 4.7786 | 197652.0 |
| 2008-03-24 08:00:00 | AAPL | Stock | 4.7771 | 4.7875 | 4.7679 | 4.7857 | 2081296.0 |
| 2008-03-24 09:00:00 | AAPL | Stock | 4.7857 | 4.8193 | 4.7729 | 4.8104 | 119029652.0 |
| 2008-03-24 10:00:00 | AAPL | Stock | 4.81 | 4.9529 | 4.805 | 4.9214 | 199168956.0 |
| 2008-03-24 11:00:00 | AAPL | Stock | 4.9214 | 4.9989 | 4.9182 | 4.995 | 149194304.0 |
| 2008-03-24 12:00:00 | AAPL | Stock | 4.995 | 5.0304 | 4.9793 | 5.0064 | 152149284.0 |
| 2008-03-24 13:00:00 | AAPL | Stock | 5.0064 | 5.0164 | 4.9843 | 5.0061 | 86115036.0 |
| 2008-03-24 14:00:00 | AAPL | Stock | 5.005 | 5.0064 | 4.9557 | 4.9621 | 122057628.0 |
| 2008-03-24 15:00:00 | AAPL | Stock | 4.9614 | 5.0068 | 4.9518 | 4.9879 | 188620768.0 |
| 2008-03-24 16:00:00 | AAPL | Stock | 4.9879 | 4.9964 | 4.9441 | 4.9804 | 19815684.0 |
| 2008-03-24 17:00:00 | AAPL | Stock | 4.975 | 4.9893 | 4.9441 | 4.9846 | 1530144.0 |
| 2008-03-24 18:00:00 | AAPL | Stock | 4.9725 | 4.9907 | 4.9725 | 4.9879 | 532896.0 |
| 2008-03-24 19:00:00 | AAPL | Stock | 4.9879 | 4.9911 | 4.9861 | 4.9911 | 183876.0 |
| 2008-03-24 08:00:00 | MSFT | Stock | 29.25 | 29.3 | 29.07 | 29.3 | 58627.0 |
| 2008-03-24 09:00:00 | MSFT | Stock | 29.27 | 29.36 | 29.2 | 29.27 | 4699321.0 |
| 2008-03-24 10:00:00 | MSFT | Stock | 29.28 | 29.39 | 29.09 | 29.12 | 10144642.0 |
| 2008-03-24 11:00:00 | MSFT | Stock | 29.11 | 29.21 | 29.09 | 29.19 | 5060852.0 |
| 2008-03-24 12:00:00 | MSFT | Stock | 29.18 | 29.35 | 29.14 | 29.3 | 4890354.0 |
| 2008-03-24 13:00:00 | MSFT | Stock | 29.3 | 29.37 | 29.26 | 29.37 | 4410244.0 |
| 2008-03-24 14:00:00 | MSFT | Stock | 29.37 | 29.4 | 29.25 | 29.26 | 4598771.0 |
| 2008-03-24 15:00:00 | MSFT | Stock | 29.25 | 29.28 | 29.06 | 29.2 | 10371420.0 |
| 2008-03-24 16:00:00 | MSFT | Stock | 29.2 | 29.231 | 29.111 | 29.2 | 2703243.0 |
| 2008-03-24 17:00:00 | MSFT | Stock | 29.2 | 29.23 | 29.19 | 29.19 | 7559.0 |
| 2008-03-24 18:00:00 | MSFT | Stock | 29.21 | 29.3 | 29.17 | 29.18 | 430750.0 |
| 2008-03-24 19:00:00 | MSFT | Stock | 29.18 | 29.2 | 29.1 | 29.2 | 2300.0 |
| 2008-03-24 08:00:00 | NVDA | Stock | 0.4695 | 0.4745 | 0.467 | 0.4738 | 1769120.0 |
| 2008-03-24 09:00:00 | NVDA | Stock | 0.4748 | 0.4832 | 0.4715 | 0.4778 | 112838520.0 |
| 2008-03-24 10:00:00 | NVDA | Stock | 0.4778 | 0.4989 | 0.4775 | 0.4912 | 165129200.0 |
| 2008-03-24 11:00:00 | NVDA | Stock | 0.491 | 0.4985 | 0.4895 | 0.4938 | 113721680.0 |
| 2008-03-24 12:00:00 | NVDA | Stock | 0.4938 | 0.5028 | 0.4928 | 0.4992 | 101258800.0 |
| 2008-03-24 13:00:00 | NVDA | Stock | 0.4992 | 0.5025 | 0.499 | 0.5005 | 71621600.0 |
| 2008-03-24 14:00:00 | NVDA | Stock | 0.5005 | 0.5035 | 0.4978 | 0.4985 | 106000400.0 |
| 2008-03-24 15:00:00 | NVDA | Stock | 0.4985 | 0.502 | 0.4975 | 0.502 | 187439720.0 |
| 2008-03-24 16:00:00 | NVDA | Stock | 0.502 | 0.5022 | 0.4942 | 0.5008 | 8500480.0 |
| 2008-03-24 17:00:00 | NVDA | Stock | 0.5 | 0.5075 | 0.4788 | 0.5038 | 2024000.0 |
| 2008-03-24 18:00:00 | NVDA | Stock | 0.5068 | 0.5068 | 0.5038 | 0.5048 | 48000.0 |
| 2008-03-24 19:00:00 | NVDA | Stock | 0.505 | 0.5075 | 0.5048 | 0.5075 | 96720.0 |
| 2008-03-24 08:00:00 | AMZN | Stock | 3.6595 | 3.6875 | 3.6595 | 3.6755 | 193060.0 |
| 2008-03-24 09:00:00 | AMZN | Stock | 3.68 | 3.695 | 3.6375 | 3.649 | 18745160.0 |
| 2008-03-24 10:00:00 | AMZN | Stock | 3.6495 | 3.7375 | 3.639 | 3.6815 | 30699520.0 |
| 2008-03-24 11:00:00 | AMZN | Stock | 3.681 | 3.7305 | 3.681 | 3.7215 | 13879420.0 |
| 2008-03-24 12:00:00 | AMZN | Stock | 3.722 | 3.7645 | 3.7035 | 3.7595 | 15591640.0 |
| 2008-03-24 13:00:00 | AMZN | Stock | 3.7605 | 3.823 | 3.749 | 3.8115 | 22302140.0 |
| 2008-03-24 14:00:00 | AMZN | Stock | 3.8115 | 3.8465 | 3.772 | 3.7795 | 26343120.0 |
| 2008-03-24 15:00:00 | AMZN | Stock | 3.7802 | 3.81 | 3.7755 | 3.796 | 33454280.0 |
| 2008-03-24 16:00:00 | AMZN | Stock | 3.7975 | 3.7975 | 3.7492 | 3.7975 | 19798320.0 |
| 2008-03-24 17:00:00 | AMZN | Stock | 3.79 | 3.79 | 3.7875 | 3.7885 | 40000.0 |
| 2008-03-24 18:00:00 | AMZN | Stock | 3.789 | 3.79 | 3.7885 | 3.79 | 26000.0 |
| 2008-03-24 19:00:00 | AMZN | Stock | 3.79 | 3.79 | 3.79 | 3.79 | 6000.0 |
| 2008-03-24 08:00:00 | TLT | Stock | 97.0 | 97.02 | 96.75 | 96.75 | 23900.0 |
> showing 50 of 41,303 rows — these rows as CSV