PREVIEW / stock_1hour / 2008-09-04
file: by_date/stock_1hour/2008/2008-09-04.parquet size: 848 KB rows: 41,025 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-09-04 07:00:00 | AAPL | Stock | 5.9629 | 5.9629 | 5.9429 | 5.9575 | 32956.0 |
| 2008-09-04 08:00:00 | AAPL | Stock | 5.9568 | 5.9646 | 5.935 | 5.9371 | 908880.0 |
| 2008-09-04 09:00:00 | AAPL | Stock | 5.9411 | 5.9969 | 5.9125 | 5.955 | 82710544.0 |
| 2008-09-04 10:00:00 | AAPL | Stock | 5.9554 | 5.9761 | 5.8861 | 5.9168 | 115887856.0 |
| 2008-09-04 11:00:00 | AAPL | Stock | 5.9161 | 5.9393 | 5.8643 | 5.8911 | 76898612.0 |
| 2008-09-04 12:00:00 | AAPL | Stock | 5.8911 | 5.9286 | 5.8571 | 5.8717 | 61131224.0 |
| 2008-09-04 13:00:00 | AAPL | Stock | 5.8714 | 5.8782 | 5.75 | 5.7593 | 128805348.0 |
| 2008-09-04 14:00:00 | AAPL | Stock | 5.7589 | 5.8025 | 5.7432 | 5.8007 | 110991160.0 |
| 2008-09-04 15:00:00 | AAPL | Stock | 5.8018 | 5.8468 | 5.7582 | 5.7582 | 139631996.0 |
| 2008-09-04 16:00:00 | AAPL | Stock | 5.7593 | 5.8548 | 5.7504 | 5.7604 | 18465048.0 |
| 2008-09-04 17:00:00 | AAPL | Stock | 5.7625 | 5.7679 | 5.7579 | 5.7679 | 915124.0 |
| 2008-09-04 18:00:00 | AAPL | Stock | 5.7714 | 5.7714 | 5.7461 | 5.7461 | 1045688.0 |
| 2008-09-04 19:00:00 | AAPL | Stock | 5.7439 | 5.75 | 5.7432 | 5.75 | 206080.0 |
| 2008-09-04 08:00:00 | MSFT | Stock | 26.9 | 26.9 | 26.75 | 26.84 | 297100.0 |
| 2008-09-04 09:00:00 | MSFT | Stock | 26.77 | 26.87 | 26.6 | 26.76 | 5655520.0 |
| 2008-09-04 10:00:00 | MSFT | Stock | 26.77 | 26.89 | 26.62 | 26.67 | 9155915.0 |
| 2008-09-04 11:00:00 | MSFT | Stock | 26.67 | 26.78 | 26.64 | 26.7 | 5910746.0 |
| 2008-09-04 12:00:00 | MSFT | Stock | 26.7 | 26.79 | 26.615 | 26.62 | 5667544.0 |
| 2008-09-04 13:00:00 | MSFT | Stock | 26.63 | 26.65 | 26.57 | 26.622 | 4886085.0 |
| 2008-09-04 14:00:00 | MSFT | Stock | 26.62 | 26.63 | 26.5 | 26.56 | 9831537.0 |
| 2008-09-04 15:00:00 | MSFT | Stock | 26.56 | 26.63 | 26.35 | 26.35 | 18856880.0 |
| 2008-09-04 16:00:00 | MSFT | Stock | 26.35 | 26.725 | 26.333 | 26.4 | 4063982.0 |
| 2008-09-04 17:00:00 | MSFT | Stock | 26.35 | 26.47 | 26.35 | 26.37 | 146327.0 |
| 2008-09-04 18:00:00 | MSFT | Stock | 26.528 | 26.528 | 26.34 | 26.34 | 793136.0 |
| 2008-09-04 19:00:00 | MSFT | Stock | 26.33 | 26.38 | 26.33 | 26.38 | 1150.0 |
| 2008-09-04 08:00:00 | NVDA | Stock | 0.2938 | 0.2938 | 0.2875 | 0.2878 | 227800.0 |
| 2008-09-04 09:00:00 | NVDA | Stock | 0.2875 | 0.2898 | 0.285 | 0.2877 | 54514840.0 |
| 2008-09-04 10:00:00 | NVDA | Stock | 0.2878 | 0.2912 | 0.2865 | 0.288 | 152227240.0 |
| 2008-09-04 11:00:00 | NVDA | Stock | 0.288 | 0.2888 | 0.2868 | 0.2875 | 70939320.0 |
| 2008-09-04 12:00:00 | NVDA | Stock | 0.2875 | 0.2895 | 0.2872 | 0.288 | 43322480.0 |
| 2008-09-04 13:00:00 | NVDA | Stock | 0.288 | 0.2885 | 0.2858 | 0.2868 | 74461240.0 |
| 2008-09-04 14:00:00 | NVDA | Stock | 0.2865 | 0.288 | 0.2862 | 0.2872 | 132188320.0 |
| 2008-09-04 15:00:00 | NVDA | Stock | 0.2872 | 0.289 | 0.287 | 0.2875 | 150480160.0 |
| 2008-09-04 16:00:00 | NVDA | Stock | 0.2875 | 0.2888 | 0.2871 | 0.2878 | 18692640.0 |
| 2008-09-04 17:00:00 | NVDA | Stock | 0.2875 | 0.2875 | 0.2875 | 0.2875 | 443080.0 |
| 2008-09-04 18:00:00 | NVDA | Stock | 0.2862 | 0.2878 | 0.2862 | 0.2878 | 36000.0 |
| 2008-09-04 19:00:00 | NVDA | Stock | 0.2898 | 0.2898 | 0.287 | 0.287 | 47000.0 |
| 2008-09-04 08:00:00 | AMZN | Stock | 4.036 | 4.0365 | 4.036 | 4.0365 | 4000.0 |
| 2008-09-04 09:00:00 | AMZN | Stock | 4.024 | 4.0405 | 4.0 | 4.006 | 13123620.0 |
| 2008-09-04 10:00:00 | AMZN | Stock | 4.006 | 4.04 | 3.944 | 3.969 | 29160900.0 |
| 2008-09-04 11:00:00 | AMZN | Stock | 3.966 | 3.9835 | 3.932 | 3.975 | 20831560.0 |
| 2008-09-04 12:00:00 | AMZN | Stock | 3.9758 | 4.008 | 3.966 | 3.9725 | 19805940.0 |
| 2008-09-04 13:00:00 | AMZN | Stock | 3.9735 | 3.9815 | 3.9355 | 3.9476 | 22165060.0 |
| 2008-09-04 14:00:00 | AMZN | Stock | 3.948 | 3.9735 | 3.932 | 3.948 | 23327700.0 |
| 2008-09-04 15:00:00 | AMZN | Stock | 3.9465 | 3.973 | 3.902 | 3.903 | 31147840.0 |
| 2008-09-04 16:00:00 | AMZN | Stock | 3.901 | 3.9656 | 3.901 | 3.9015 | 4368460.0 |
| 2008-09-04 17:00:00 | AMZN | Stock | 3.9015 | 3.92 | 3.9015 | 3.92 | 119900.0 |
| 2008-09-04 18:00:00 | AMZN | Stock | 3.905 | 3.905 | 3.905 | 3.905 | 8000.0 |
| 2008-09-04 19:00:00 | AMZN | Stock | 3.905 | 3.905 | 3.905 | 3.905 | 2000.0 |
| 2008-09-04 09:00:00 | TLT | Stock | 94.95 | 95.07 | 94.88 | 94.98 | 374730.0 |
> showing 50 of 41,025 rows — these rows as CSV