PREVIEW / stock_1hour / 2008-07-30
file: by_date/stock_1hour/2008/2008-07-30.parquet size: 836 KB rows: 40,131 symbols: 3,318
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-07-30 08:00:00 | AAPL | Stock | 5.6161 | 5.6589 | 5.6089 | 5.6486 | 2784852.0 |
| 2008-07-30 09:00:00 | AAPL | Stock | 5.6496 | 5.6743 | 5.5971 | 5.6521 | 97336148.0 |
| 2008-07-30 10:00:00 | AAPL | Stock | 5.6518 | 5.7318 | 5.6514 | 5.7007 | 146958840.0 |
| 2008-07-30 11:00:00 | AAPL | Stock | 5.7007 | 5.7107 | 5.6754 | 5.7054 | 62312544.0 |
| 2008-07-30 12:00:00 | AAPL | Stock | 5.7054 | 5.7089 | 5.6211 | 5.6229 | 76462120.0 |
| 2008-07-30 13:00:00 | AAPL | Stock | 5.6229 | 5.6539 | 5.5743 | 5.6439 | 110372388.0 |
| 2008-07-30 14:00:00 | AAPL | Stock | 5.6443 | 5.6671 | 5.6114 | 5.6546 | 75933032.0 |
| 2008-07-30 15:00:00 | AAPL | Stock | 5.6543 | 5.715 | 5.6086 | 5.7136 | 135850288.0 |
| 2008-07-30 16:00:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.61 | 5.7025 | 10071712.0 |
| 2008-07-30 17:00:00 | AAPL | Stock | 5.7029 | 5.7054 | 5.61 | 5.7021 | 595028.0 |
| 2008-07-30 18:00:00 | AAPL | Stock | 5.7061 | 5.7214 | 5.6964 | 5.7025 | 925036.0 |
| 2008-07-30 19:00:00 | AAPL | Stock | 5.7036 | 5.7107 | 5.7036 | 5.7057 | 54180.0 |
| 2008-07-30 08:00:00 | MSFT | Stock | 26.12 | 26.19 | 26.11 | 26.19 | 8516.0 |
| 2008-07-30 09:00:00 | MSFT | Stock | 26.19 | 26.49 | 26.08 | 26.08 | 5944028.0 |
| 2008-07-30 10:00:00 | MSFT | Stock | 26.09 | 26.49 | 26.08 | 26.3 | 8196665.0 |
| 2008-07-30 11:00:00 | MSFT | Stock | 26.29 | 26.34 | 26.14 | 26.261 | 5324377.0 |
| 2008-07-30 12:00:00 | MSFT | Stock | 26.27 | 26.28 | 25.98 | 26.05 | 5320779.0 |
| 2008-07-30 13:00:00 | MSFT | Stock | 26.04 | 26.11 | 25.93 | 25.98 | 6527476.0 |
| 2008-07-30 14:00:00 | MSFT | Stock | 25.99 | 26.1 | 25.91 | 26.07 | 8644358.0 |
| 2008-07-30 15:00:00 | MSFT | Stock | 26.07 | 26.29 | 25.9 | 26.23 | 9535243.0 |
| 2008-07-30 16:00:00 | MSFT | Stock | 26.21 | 26.23 | 26.05 | 26.18 | 1992121.0 |
| 2008-07-30 17:00:00 | MSFT | Stock | 26.17 | 26.2 | 26.17 | 26.18 | 1000.0 |
| 2008-07-30 18:00:00 | MSFT | Stock | 26.2 | 26.23 | 26.2 | 26.2 | 10961.0 |
| 2008-07-30 19:00:00 | MSFT | Stock | 26.2 | 26.2 | 26.18 | 26.18 | 1727.0 |
| 2008-07-30 08:00:00 | NVDA | Stock | 0.2925 | 0.2968 | 0.2925 | 0.2968 | 208000.0 |
| 2008-07-30 09:00:00 | NVDA | Stock | 0.2958 | 0.2975 | 0.2865 | 0.287 | 83940960.0 |
| 2008-07-30 10:00:00 | NVDA | Stock | 0.287 | 0.2935 | 0.2868 | 0.2875 | 117424040.0 |
| 2008-07-30 11:00:00 | NVDA | Stock | 0.2875 | 0.2899 | 0.2842 | 0.286 | 79568280.0 |
| 2008-07-30 12:00:00 | NVDA | Stock | 0.2858 | 0.286 | 0.2805 | 0.2822 | 82346240.0 |
| 2008-07-30 13:00:00 | NVDA | Stock | 0.2822 | 0.2842 | 0.2808 | 0.2838 | 64115200.0 |
| 2008-07-30 14:00:00 | NVDA | Stock | 0.2838 | 0.2858 | 0.282 | 0.2856 | 62277320.0 |
| 2008-07-30 15:00:00 | NVDA | Stock | 0.2858 | 0.288 | 0.2828 | 0.2868 | 86586800.0 |
| 2008-07-30 16:00:00 | NVDA | Stock | 0.2865 | 0.2882 | 0.2844 | 0.2862 | 10931440.0 |
| 2008-07-30 17:00:00 | NVDA | Stock | 0.2862 | 0.2862 | 0.2858 | 0.2858 | 24000.0 |
| 2008-07-30 18:00:00 | NVDA | Stock | 0.287 | 0.2875 | 0.287 | 0.2875 | 54680.0 |
| 2008-07-30 19:00:00 | NVDA | Stock | 0.2858 | 0.2875 | 0.2858 | 0.2875 | 8000.0 |
| 2008-07-30 08:00:00 | AMZN | Stock | 3.937 | 3.9435 | 3.937 | 3.94 | 25800.0 |
| 2008-07-30 09:00:00 | AMZN | Stock | 3.9485 | 3.9925 | 3.9165 | 3.9305 | 19593560.0 |
| 2008-07-30 10:00:00 | AMZN | Stock | 3.932 | 3.95 | 3.895 | 3.925 | 35469580.0 |
| 2008-07-30 11:00:00 | AMZN | Stock | 3.9245 | 3.968 | 3.9145 | 3.923 | 17355800.0 |
| 2008-07-30 12:00:00 | AMZN | Stock | 3.924 | 3.9315 | 3.871 | 3.8775 | 18917740.0 |
| 2008-07-30 13:00:00 | AMZN | Stock | 3.876 | 3.897 | 3.8515 | 3.87 | 12737000.0 |
| 2008-07-30 14:00:00 | AMZN | Stock | 3.8705 | 3.898 | 3.8465 | 3.8535 | 16482420.0 |
| 2008-07-30 15:00:00 | AMZN | Stock | 3.854 | 3.9105 | 3.821 | 3.9105 | 27141700.0 |
| 2008-07-30 16:00:00 | AMZN | Stock | 3.907 | 3.9105 | 3.901 | 3.9105 | 506340.0 |
| 2008-07-30 17:00:00 | AMZN | Stock | 3.905 | 3.9125 | 3.905 | 3.9125 | 26200.0 |
| 2008-07-30 18:00:00 | AMZN | Stock | 3.915 | 3.9175 | 3.915 | 3.915 | 12000.0 |
| 2008-07-30 19:00:00 | AMZN | Stock | 3.9105 | 3.9225 | 3.91 | 3.9225 | 54040.0 |
| 2008-07-30 08:00:00 | TLT | Stock | 90.46 | 90.46 | 90.35 | 90.35 | 6000.0 |
| 2008-07-30 09:00:00 | TLT | Stock | 90.3 | 90.3 | 90.03 | 90.26 | 168744.0 |
> showing 50 of 40,131 rows — these rows as CSV