PREVIEW / stock_1hour / 2024-03-19
file: by_date/stock_1hour/2024/2024-03-19.parquet size: 1.3 MB rows: 59,856 symbols: 1,072
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-19 04:00:00 | AAPL | Stock | 173.9 | 174.38 | 173.32 | 174.1 | 10566.0 |
| 2024-03-19 05:00:00 | AAPL | Stock | 174.15 | 174.2 | 173.74 | 173.86 | 7807.0 |
| 2024-03-19 06:00:00 | AAPL | Stock | 174.04 | 174.41 | 173.96 | 174.01 | 9452.0 |
| 2024-03-19 07:00:00 | AAPL | Stock | 174.03 | 174.07 | 173.15 | 173.35 | 29479.0 |
| 2024-03-19 08:00:00 | AAPL | Stock | 173.74 | 174.3 | 173.0593 | 174.22 | 134825.0 |
| 2024-03-19 09:00:00 | AAPL | Stock | 174.23 | 174.84 | 173.03 | 174.46 | 5685422.0 |
| 2024-03-19 10:00:00 | AAPL | Stock | 174.455 | 175.37 | 174.435 | 174.88 | 6670323.0 |
| 2024-03-19 11:00:00 | AAPL | Stock | 174.88 | 175.415 | 174.62 | 175.21 | 3958536.0 |
| 2024-03-19 12:00:00 | AAPL | Stock | 175.215 | 175.475 | 174.88 | 175.3245 | 2814684.0 |
| 2024-03-19 13:00:00 | AAPL | Stock | 175.3202 | 176.12 | 175.3202 | 176.115 | 3533231.0 |
| 2024-03-19 14:00:00 | AAPL | Stock | 176.12 | 176.605 | 176.0721 | 176.2199 | 4135647.0 |
| 2024-03-19 15:00:00 | AAPL | Stock | 176.21 | 176.54 | 175.79 | 176.08 | 7026084.0 |
| 2024-03-19 16:00:00 | AAPL | Stock | 176.31 | 176.31 | 175.59 | 175.75 | 9529332.0 |
| 2024-03-19 17:00:00 | AAPL | Stock | 175.76 | 176.08 | 175.6501 | 175.72 | 64190.0 |
| 2024-03-19 18:00:00 | AAPL | Stock | 175.72 | 175.87 | 175.6 | 175.6 | 28247.0 |
| 2024-03-19 19:00:00 | AAPL | Stock | 175.78 | 175.78 | 175.4 | 175.65 | 39666.0 |
| 2024-03-19 04:00:00 | MSFT | Stock | 416.59 | 417.54 | 416.28 | 417.54 | 3630.0 |
| 2024-03-19 05:00:00 | MSFT | Stock | 417.49 | 417.58 | 416.44 | 416.45 | 2665.0 |
| 2024-03-19 06:00:00 | MSFT | Stock | 416.35 | 417.6 | 416.35 | 416.69 | 3095.0 |
| 2024-03-19 07:00:00 | MSFT | Stock | 416.7 | 416.7 | 415.1 | 415.31 | 13875.0 |
| 2024-03-19 08:00:00 | MSFT | Stock | 416.18 | 416.68 | 414.15 | 414.7509 | 32445.0 |
| 2024-03-19 09:00:00 | MSFT | Stock | 414.75 | 419.22 | 414.37 | 418.58 | 1491651.0 |
| 2024-03-19 10:00:00 | MSFT | Stock | 418.55 | 420.6399 | 418.14 | 419.97 | 1590047.0 |
| 2024-03-19 11:00:00 | MSFT | Stock | 419.92 | 421.6656 | 419.86 | 420.925 | 1214521.0 |
| 2024-03-19 12:00:00 | MSFT | Stock | 420.9154 | 421.6 | 420.46 | 420.605 | 1260495.0 |
| 2024-03-19 13:00:00 | MSFT | Stock | 420.62 | 421.44 | 420.09 | 420.21 | 911593.0 |
| 2024-03-19 14:00:00 | MSFT | Stock | 420.2 | 420.24 | 419.09 | 419.5 | 1150306.0 |
| 2024-03-19 15:00:00 | MSFT | Stock | 419.48 | 421.55 | 419.31 | 421.37 | 1538992.0 |
| 2024-03-19 16:00:00 | MSFT | Stock | 421.41 | 421.53 | 420.41 | 420.69 | 5011966.0 |
| 2024-03-19 17:00:00 | MSFT | Stock | 420.54 | 420.85 | 420.54 | 420.7 | 2293.0 |
| 2024-03-19 18:00:00 | MSFT | Stock | 420.75 | 420.99 | 419.98 | 420.57 | 4271.0 |
| 2024-03-19 19:00:00 | MSFT | Stock | 420.87 | 420.87 | 420.6 | 420.75 | 1358.0 |
| 2024-03-19 04:00:00 | NVDA | Stock | 87.699 | 88.8 | 86.933 | 88.32 | 715160.0 |
| 2024-03-19 05:00:00 | NVDA | Stock | 88.244 | 88.6 | 87.669 | 87.9 | 361640.0 |
| 2024-03-19 06:00:00 | NVDA | Stock | 87.949 | 88.23 | 87.406 | 87.638 | 135730.0 |
| 2024-03-19 07:00:00 | NVDA | Stock | 87.703 | 87.703 | 86.57 | 86.944 | 1096890.0 |
| 2024-03-19 08:00:00 | NVDA | Stock | 87.419 | 87.8 | 85.8 | 86.273 | 6142620.0 |
| 2024-03-19 09:00:00 | NVDA | Stock | 86.2166 | 87.776 | 85.01 | 85.672 | 78551220.0 |
| 2024-03-19 10:00:00 | NVDA | Stock | 85.672 | 87.155 | 85.324 | 86.4355 | 73753360.0 |
| 2024-03-19 11:00:00 | NVDA | Stock | 86.447 | 87.342 | 86.337 | 86.7502 | 43357560.0 |
| 2024-03-19 12:00:00 | NVDA | Stock | 86.796 | 89.7 | 86.754 | 88.9401 | 76744140.0 |
| 2024-03-19 13:00:00 | NVDA | Stock | 88.934 | 89.796 | 88.529 | 89.6855 | 56037420.0 |
| 2024-03-19 14:00:00 | NVDA | Stock | 89.6961 | 90.544 | 89.256 | 89.6936 | 54802880.0 |
| 2024-03-19 15:00:00 | NVDA | Stock | 89.684 | 89.871 | 88.107 | 89.4 | 65216920.0 |
| 2024-03-19 16:00:00 | NVDA | Stock | 89.398 | 89.398 | 88.858 | 88.858 | 18301710.0 |
| 2024-03-19 17:00:00 | NVDA | Stock | 88.9 | 89.074 | 88.72 | 88.983 | 1028430.0 |
| 2024-03-19 18:00:00 | NVDA | Stock | 88.974 | 89.298 | 88.974 | 89.139 | 830450.0 |
| 2024-03-19 19:00:00 | NVDA | Stock | 89.11 | 89.123 | 88.9 | 89.045 | 670900.0 |
| 2024-03-19 04:00:00 | AMZN | Stock | 174.34 | 174.45 | 173.8 | 174.37 | 7510.0 |
| 2024-03-19 05:00:00 | AMZN | Stock | 174.39 | 174.39 | 174.01 | 174.02 | 4798.0 |
> showing 50 of 59,856 rows — these rows as CSV