PREVIEW / stock_1hour / 2024-03-06
file: by_date/stock_1hour/2024/2024-03-06.parquet size: 1.4 MB rows: 61,002 symbols: 1,120
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-06 04:00:00 | AAPL | Stock | 170.12 | 172.0 | 169.63 | 170.99 | 43896.0 |
| 2024-03-06 05:00:00 | AAPL | Stock | 171.05 | 171.38 | 170.89 | 171.04 | 20833.0 |
| 2024-03-06 06:00:00 | AAPL | Stock | 170.99 | 171.3 | 170.75 | 170.81 | 22591.0 |
| 2024-03-06 07:00:00 | AAPL | Stock | 170.86 | 170.88 | 170.38 | 170.82 | 67117.0 |
| 2024-03-06 08:00:00 | AAPL | Stock | 170.69 | 171.6396 | 169.93 | 171.63 | 351432.0 |
| 2024-03-06 09:00:00 | AAPL | Stock | 171.64 | 171.75 | 168.93 | 169.8 | 10384443.0 |
| 2024-03-06 10:00:00 | AAPL | Stock | 169.805 | 170.05 | 168.98 | 169.545 | 7692981.0 |
| 2024-03-06 11:00:00 | AAPL | Stock | 169.55 | 170.01 | 169.315 | 169.745 | 5523316.0 |
| 2024-03-06 12:00:00 | AAPL | Stock | 169.75 | 170.35 | 169.7 | 170.1209 | 5181614.0 |
| 2024-03-06 13:00:00 | AAPL | Stock | 170.125 | 170.225 | 169.04 | 169.38 | 4721955.0 |
| 2024-03-06 14:00:00 | AAPL | Stock | 169.38 | 169.5 | 168.68 | 168.84 | 5443582.0 |
| 2024-03-06 15:00:00 | AAPL | Stock | 168.83 | 169.4 | 168.75 | 169.12 | 7104744.0 |
| 2024-03-06 16:00:00 | AAPL | Stock | 169.12 | 169.24 | 168.81 | 168.87 | 5481105.0 |
| 2024-03-06 17:00:00 | AAPL | Stock | 168.87 | 169.12 | 168.87 | 169.0678 | 103939.0 |
| 2024-03-06 18:00:00 | AAPL | Stock | 169.05 | 169.12 | 168.8011 | 168.82 | 65742.0 |
| 2024-03-06 19:00:00 | AAPL | Stock | 168.85 | 168.91 | 168.45 | 168.45 | 46085.0 |
| 2024-03-06 04:00:00 | MSFT | Stock | 404.48 | 406.35 | 404.31 | 405.11 | 13955.0 |
| 2024-03-06 05:00:00 | MSFT | Stock | 405.67 | 406.44 | 405.1 | 405.5 | 9746.0 |
| 2024-03-06 06:00:00 | MSFT | Stock | 405.37 | 405.37 | 404.3 | 404.3 | 2836.0 |
| 2024-03-06 07:00:00 | MSFT | Stock | 404.95 | 406.1 | 404.56 | 405.8 | 17546.0 |
| 2024-03-06 08:00:00 | MSFT | Stock | 404.66 | 406.5 | 403.45 | 405.99 | 68188.0 |
| 2024-03-06 09:00:00 | MSFT | Stock | 405.96 | 405.96 | 401.18 | 401.535 | 2357136.0 |
| 2024-03-06 10:00:00 | MSFT | Stock | 401.495 | 402.8691 | 398.39 | 402.35 | 2947319.0 |
| 2024-03-06 11:00:00 | MSFT | Stock | 402.35 | 404.8862 | 401.93 | 404.6 | 1919216.0 |
| 2024-03-06 12:00:00 | MSFT | Stock | 404.57 | 405.16 | 403.56 | 403.8735 | 1165942.0 |
| 2024-03-06 13:00:00 | MSFT | Stock | 403.84 | 404.52 | 402.0 | 403.07 | 1138174.0 |
| 2024-03-06 14:00:00 | MSFT | Stock | 403.05 | 403.21 | 401.11 | 401.49 | 1427832.0 |
| 2024-03-06 15:00:00 | MSFT | Stock | 401.47 | 402.83 | 400.42 | 402.3 | 2392202.0 |
| 2024-03-06 16:00:00 | MSFT | Stock | 402.09 | 402.56 | 401.73 | 402.11 | 2477654.0 |
| 2024-03-06 17:00:00 | MSFT | Stock | 402.2392 | 402.4 | 402.0 | 402.0 | 2798.0 |
| 2024-03-06 18:00:00 | MSFT | Stock | 402.11 | 402.1603 | 401.5 | 401.5 | 7458.0 |
| 2024-03-06 19:00:00 | MSFT | Stock | 401.8 | 401.8 | 400.36 | 400.88 | 5701.0 |
| 2024-03-06 04:00:00 | NVDA | Stock | 86.416 | 87.036 | 86.366 | 86.772 | 433210.0 |
| 2024-03-06 05:00:00 | NVDA | Stock | 86.785 | 87.1 | 86.785 | 86.891 | 209630.0 |
| 2024-03-06 06:00:00 | NVDA | Stock | 86.92 | 87.17 | 86.888 | 86.9 | 219990.0 |
| 2024-03-06 07:00:00 | NVDA | Stock | 86.931 | 87.462 | 86.772 | 87.365 | 1888670.0 |
| 2024-03-06 08:00:00 | NVDA | Stock | 87.125 | 87.566 | 86.197 | 87.566 | 4470720.0 |
| 2024-03-06 09:00:00 | NVDA | Stock | 87.566 | 88.969 | 87.406 | 87.9345 | 79022840.0 |
| 2024-03-06 10:00:00 | NVDA | Stock | 87.964 | 88.67 | 87.03 | 88.275 | 75950680.0 |
| 2024-03-06 11:00:00 | NVDA | Stock | 88.2771 | 88.78 | 87.868 | 88.46 | 40770180.0 |
| 2024-03-06 12:00:00 | NVDA | Stock | 88.4485 | 88.9905 | 88.4485 | 88.7714 | 34043150.0 |
| 2024-03-06 13:00:00 | NVDA | Stock | 88.78 | 89.724 | 88.441 | 89.071 | 59835310.0 |
| 2024-03-06 14:00:00 | NVDA | Stock | 89.068 | 89.497 | 88.474 | 88.646 | 43348380.0 |
| 2024-03-06 15:00:00 | NVDA | Stock | 88.64 | 88.898 | 87.6418 | 88.7445 | 60773810.0 |
| 2024-03-06 16:00:00 | NVDA | Stock | 88.7 | 89.17 | 88.52 | 88.85 | 23483840.0 |
| 2024-03-06 17:00:00 | NVDA | Stock | 88.845 | 89.127 | 88.803 | 88.945 | 1003470.0 |
| 2024-03-06 18:00:00 | NVDA | Stock | 88.95 | 89.0 | 88.9155 | 88.93 | 437650.0 |
| 2024-03-06 19:00:00 | NVDA | Stock | 88.925 | 89.0 | 88.461 | 88.53 | 1179800.0 |
| 2024-03-06 04:00:00 | AMZN | Stock | 174.88 | 175.44 | 174.7 | 175.06 | 9554.0 |
| 2024-03-06 05:00:00 | AMZN | Stock | 175.11 | 175.6 | 175.09 | 175.41 | 19332.0 |
> showing 50 of 61,002 rows — these rows as CSV