PREVIEW / stock_1hour / 2024-03-21
file: by_date/stock_1hour/2024/2024-03-21.parquet size: 1.4 MB rows: 61,063 symbols: 1,077
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-21 04:00:00 | AAPL | Stock | 177.03 | 177.03 | 176.11 | 176.79 | 42201.0 |
| 2024-03-21 05:00:00 | AAPL | Stock | 176.78 | 176.78 | 176.34 | 176.58 | 12565.0 |
| 2024-03-21 06:00:00 | AAPL | Stock | 176.62 | 176.62 | 176.36 | 176.46 | 19554.0 |
| 2024-03-21 07:00:00 | AAPL | Stock | 176.52 | 177.02 | 176.4 | 176.9 | 73549.0 |
| 2024-03-21 08:00:00 | AAPL | Stock | 176.68 | 177.66 | 176.4 | 177.53 | 258510.0 |
| 2024-03-21 09:00:00 | AAPL | Stock | 177.47 | 177.5799 | 175.99 | 176.05 | 7121834.0 |
| 2024-03-21 10:00:00 | AAPL | Stock | 176.05 | 176.19 | 172.58 | 172.5907 | 18252705.0 |
| 2024-03-21 11:00:00 | AAPL | Stock | 172.61 | 173.24 | 171.83 | 171.98 | 17385384.0 |
| 2024-03-21 12:00:00 | AAPL | Stock | 171.985 | 172.6 | 171.86 | 172.14 | 7574265.0 |
| 2024-03-21 13:00:00 | AAPL | Stock | 172.14 | 172.41 | 171.07 | 171.095 | 7107607.0 |
| 2024-03-21 14:00:00 | AAPL | Stock | 171.095 | 171.48 | 170.85 | 171.1174 | 8148256.0 |
| 2024-03-21 15:00:00 | AAPL | Stock | 171.1199 | 171.57 | 170.84 | 171.4 | 11907249.0 |
| 2024-03-21 16:00:00 | AAPL | Stock | 171.37 | 171.64 | 171.04 | 171.54 | 10173014.0 |
| 2024-03-21 17:00:00 | AAPL | Stock | 171.52 | 171.79 | 171.5 | 171.55 | 136497.0 |
| 2024-03-21 18:00:00 | AAPL | Stock | 171.55 | 171.78 | 171.37 | 171.65 | 176341.0 |
| 2024-03-21 19:00:00 | AAPL | Stock | 171.6789 | 171.75 | 171.6 | 171.6999 | 85222.0 |
| 2024-03-21 04:00:00 | MSFT | Stock | 428.99 | 428.99 | 427.51 | 427.86 | 5283.0 |
| 2024-03-21 05:00:00 | MSFT | Stock | 427.93 | 428.1 | 427.3 | 428.0 | 4134.0 |
| 2024-03-21 06:00:00 | MSFT | Stock | 427.8 | 428.09 | 427.8 | 428.06 | 1596.0 |
| 2024-03-21 07:00:00 | MSFT | Stock | 428.06 | 429.44 | 428.0 | 429.44 | 22065.0 |
| 2024-03-21 08:00:00 | MSFT | Stock | 428.0 | 429.89 | 428.0 | 429.22 | 61002.0 |
| 2024-03-21 09:00:00 | MSFT | Stock | 429.33 | 430.82 | 425.23 | 429.3 | 2156739.0 |
| 2024-03-21 10:00:00 | MSFT | Stock | 429.27 | 429.525 | 427.16 | 427.96 | 1607052.0 |
| 2024-03-21 11:00:00 | MSFT | Stock | 428.0 | 429.1 | 427.22 | 428.9 | 1222097.0 |
| 2024-03-21 12:00:00 | MSFT | Stock | 428.88 | 430.535 | 428.85 | 430.135 | 1685603.0 |
| 2024-03-21 13:00:00 | MSFT | Stock | 430.125 | 430.13 | 428.84 | 429.17 | 808341.0 |
| 2024-03-21 14:00:00 | MSFT | Stock | 429.13 | 429.91 | 428.62 | 429.26 | 839253.0 |
| 2024-03-21 15:00:00 | MSFT | Stock | 429.24 | 429.93 | 428.85 | 429.37 | 1516349.0 |
| 2024-03-21 16:00:00 | MSFT | Stock | 429.35 | 429.9 | 428.52 | 429.44 | 4128153.0 |
| 2024-03-21 17:00:00 | MSFT | Stock | 429.27 | 429.64 | 429.21 | 429.5111 | 6066.0 |
| 2024-03-21 18:00:00 | MSFT | Stock | 429.84 | 429.85 | 429.35 | 429.84 | 2405.0 |
| 2024-03-21 19:00:00 | MSFT | Stock | 429.8499 | 430.0 | 429.65 | 430.0 | 7067.0 |
| 2024-03-21 04:00:00 | NVDA | Stock | 91.609 | 91.685 | 91.1 | 91.5 | 431230.0 |
| 2024-03-21 05:00:00 | NVDA | Stock | 91.544 | 91.6 | 91.23 | 91.41 | 209460.0 |
| 2024-03-21 06:00:00 | NVDA | Stock | 91.422 | 91.659 | 91.38 | 91.463 | 199010.0 |
| 2024-03-21 07:00:00 | NVDA | Stock | 91.466 | 92.3 | 91.401 | 92.05 | 2712270.0 |
| 2024-03-21 08:00:00 | NVDA | Stock | 91.718 | 92.4 | 91.34 | 92.298 | 4323630.0 |
| 2024-03-21 09:00:00 | NVDA | Stock | 92.325 | 92.648 | 90.405 | 90.9655 | 71708500.0 |
| 2024-03-21 10:00:00 | NVDA | Stock | 90.946 | 91.75 | 90.666 | 91.424 | 56409930.0 |
| 2024-03-21 11:00:00 | NVDA | Stock | 91.448 | 92.493 | 91.33 | 92.1105 | 45648030.0 |
| 2024-03-21 12:00:00 | NVDA | Stock | 92.1176 | 92.62 | 91.855 | 92.271 | 35538790.0 |
| 2024-03-21 13:00:00 | NVDA | Stock | 92.265 | 92.395 | 91.57 | 91.6885 | 28201440.0 |
| 2024-03-21 14:00:00 | NVDA | Stock | 91.671 | 91.776 | 90.83 | 91.089 | 34848180.0 |
| 2024-03-21 15:00:00 | NVDA | Stock | 91.0876 | 91.683 | 90.952 | 91.381 | 35769100.0 |
| 2024-03-21 16:00:00 | NVDA | Stock | 91.375 | 91.435 | 91.112 | 91.185 | 19481200.0 |
| 2024-03-21 17:00:00 | NVDA | Stock | 91.16 | 91.315 | 91.152 | 91.234 | 318970.0 |
| 2024-03-21 18:00:00 | NVDA | Stock | 91.259 | 91.338 | 91.145 | 91.338 | 395580.0 |
| 2024-03-21 19:00:00 | NVDA | Stock | 91.34 | 91.5 | 91.3 | 91.49 | 462910.0 |
| 2024-03-21 04:00:00 | AMZN | Stock | 179.26 | 179.36 | 178.91 | 179.15 | 19025.0 |
| 2024-03-21 05:00:00 | AMZN | Stock | 179.15 | 179.15 | 178.75 | 178.93 | 11186.0 |
> showing 50 of 61,063 rows — these rows as CSV