PREVIEW / stock_1hour / 2024-03-05
file: by_date/stock_1hour/2024/2024-03-05.parquet size: 1.4 MB rows: 60,511 symbols: 1,119
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-05 04:00:00 | AAPL | Stock | 173.0 | 173.4 | 172.21 | 172.48 | 51522.0 |
| 2024-03-05 05:00:00 | AAPL | Stock | 172.48 | 172.53 | 172.33 | 172.44 | 18836.0 |
| 2024-03-05 06:00:00 | AAPL | Stock | 172.42 | 172.48 | 171.65 | 171.82 | 55179.0 |
| 2024-03-05 07:00:00 | AAPL | Stock | 171.76 | 172.22 | 171.0 | 171.02 | 266542.0 |
| 2024-03-05 08:00:00 | AAPL | Stock | 172.18 | 174.33 | 170.78 | 171.1765 | 750863.0 |
| 2024-03-05 09:00:00 | AAPL | Stock | 171.2 | 172.04 | 170.07 | 170.485 | 14389031.0 |
| 2024-03-05 10:00:00 | AAPL | Stock | 170.5 | 171.0 | 169.62 | 170.41 | 13917925.0 |
| 2024-03-05 11:00:00 | AAPL | Stock | 170.41 | 170.82 | 169.86 | 170.25 | 7086269.0 |
| 2024-03-05 12:00:00 | AAPL | Stock | 170.2501 | 170.895 | 170.11 | 170.2979 | 5625319.0 |
| 2024-03-05 13:00:00 | AAPL | Stock | 170.3 | 170.76 | 169.95 | 169.985 | 5792614.0 |
| 2024-03-05 14:00:00 | AAPL | Stock | 169.99 | 170.38 | 169.79 | 170.045 | 6083180.0 |
| 2024-03-05 15:00:00 | AAPL | Stock | 170.0401 | 170.25 | 169.8 | 170.17 | 10725553.0 |
| 2024-03-05 16:00:00 | AAPL | Stock | 170.12 | 170.3599 | 170.0335 | 170.32 | 12329140.0 |
| 2024-03-05 17:00:00 | AAPL | Stock | 170.321 | 170.49 | 170.11 | 170.22 | 81196.0 |
| 2024-03-05 18:00:00 | AAPL | Stock | 170.1723 | 170.25 | 169.83 | 169.92 | 65761.0 |
| 2024-03-05 19:00:00 | AAPL | Stock | 169.9 | 170.06 | 169.8 | 169.86 | 53632.0 |
| 2024-03-05 04:00:00 | MSFT | Stock | 412.85 | 413.18 | 411.7 | 412.73 | 7460.0 |
| 2024-03-05 05:00:00 | MSFT | Stock | 412.7 | 412.75 | 412.4 | 412.4 | 1853.0 |
| 2024-03-05 06:00:00 | MSFT | Stock | 412.35 | 412.87 | 412.35 | 412.87 | 1754.0 |
| 2024-03-05 07:00:00 | MSFT | Stock | 412.75 | 414.34 | 412.49 | 413.58 | 26850.0 |
| 2024-03-05 08:00:00 | MSFT | Stock | 412.5 | 414.149 | 412.36 | 412.52 | 27122.0 |
| 2024-03-05 09:00:00 | MSFT | Stock | 412.5 | 414.25 | 406.27 | 407.07 | 2685589.0 |
| 2024-03-05 10:00:00 | MSFT | Stock | 407.07 | 407.46 | 402.12 | 403.43 | 3827744.0 |
| 2024-03-05 11:00:00 | MSFT | Stock | 403.45 | 405.19 | 402.92 | 404.14 | 1613689.0 |
| 2024-03-05 12:00:00 | MSFT | Stock | 404.18 | 404.71 | 403.36 | 403.37 | 896442.0 |
| 2024-03-05 13:00:00 | MSFT | Stock | 403.38 | 403.47 | 401.2491 | 401.53 | 1325234.0 |
| 2024-03-05 14:00:00 | MSFT | Stock | 401.53 | 402.59 | 400.66 | 401.31 | 1304533.0 |
| 2024-03-05 15:00:00 | MSFT | Stock | 401.32 | 402.85 | 400.64 | 402.85 | 3115513.0 |
| 2024-03-05 16:00:00 | MSFT | Stock | 402.65 | 404.27 | 402.65 | 404.27 | 4500881.0 |
| 2024-03-05 17:00:00 | MSFT | Stock | 404.31 | 404.34 | 403.9 | 403.9 | 19207.0 |
| 2024-03-05 18:00:00 | MSFT | Stock | 403.9 | 404.088 | 403.01 | 403.4 | 12122.0 |
| 2024-03-05 19:00:00 | MSFT | Stock | 403.15 | 403.75 | 403.0 | 403.0401 | 8686.0 |
| 2024-03-05 04:00:00 | NVDA | Stock | 85.339 | 85.495 | 83.621 | 83.71 | 817130.0 |
| 2024-03-05 05:00:00 | NVDA | Stock | 83.686 | 84.789 | 83.165 | 84.72 | 1032440.0 |
| 2024-03-05 06:00:00 | NVDA | Stock | 84.723 | 84.949 | 84.43 | 84.941 | 205990.0 |
| 2024-03-05 07:00:00 | NVDA | Stock | 84.928 | 86.39 | 84.77 | 86.044 | 2257180.0 |
| 2024-03-05 08:00:00 | NVDA | Stock | 84.973 | 86.6 | 83.5154 | 85.6315 | 5418110.0 |
| 2024-03-05 09:00:00 | NVDA | Stock | 85.6 | 86.097 | 84.3993 | 85.294 | 63108720.0 |
| 2024-03-05 10:00:00 | NVDA | Stock | 85.326 | 85.76 | 83.417 | 84.4115 | 77198450.0 |
| 2024-03-05 11:00:00 | NVDA | Stock | 84.43 | 84.86 | 84.138 | 84.774 | 43992570.0 |
| 2024-03-05 12:00:00 | NVDA | Stock | 84.7665 | 85.408 | 84.668 | 85.3155 | 38555180.0 |
| 2024-03-05 13:00:00 | NVDA | Stock | 85.3155 | 85.336 | 84.459 | 84.6455 | 33957350.0 |
| 2024-03-05 14:00:00 | NVDA | Stock | 84.6546 | 85.181 | 84.487 | 84.9469 | 32690240.0 |
| 2024-03-05 15:00:00 | NVDA | Stock | 84.94 | 86.0 | 84.651 | 85.994 | 53199070.0 |
| 2024-03-05 16:00:00 | NVDA | Stock | 86.087 | 86.4 | 85.801 | 86.158 | 24320470.0 |
| 2024-03-05 17:00:00 | NVDA | Stock | 86.107 | 86.2939 | 86.05 | 86.22 | 896750.0 |
| 2024-03-05 18:00:00 | NVDA | Stock | 86.22 | 86.22 | 85.58 | 85.751 | 908670.0 |
| 2024-03-05 19:00:00 | NVDA | Stock | 85.79 | 85.79 | 85.48 | 85.511 | 942490.0 |
| 2024-03-05 04:00:00 | AMZN | Stock | 176.0 | 176.73 | 176.0 | 176.45 | 25177.0 |
| 2024-03-05 05:00:00 | AMZN | Stock | 176.42 | 176.42 | 176.1 | 176.15 | 8649.0 |
> showing 50 of 60,511 rows — these rows as CSV