PREVIEW / stock_1hour / 2025-07-14
file: by_date/stock_1hour/2025/2025-07-14.parquet size: 1.5 MB rows: 64,131 symbols: 380
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 |
|---|---|---|---|---|---|---|---|
| 2025-07-14 04:00:00 | AAPL | Stock | 209.8 | 210.0 | 209.2 | 209.21 | 30495.0 |
| 2025-07-14 05:00:00 | AAPL | Stock | 209.24 | 209.41 | 209.14 | 209.18 | 14211.0 |
| 2025-07-14 06:00:00 | AAPL | Stock | 209.21 | 209.3 | 209.1 | 209.28 | 8304.0 |
| 2025-07-14 07:00:00 | AAPL | Stock | 209.33 | 209.46 | 209.2 | 209.37 | 28898.0 |
| 2025-07-14 08:00:00 | AAPL | Stock | 209.2 | 209.9 | 209.11 | 209.48 | 150547.0 |
| 2025-07-14 09:00:00 | AAPL | Stock | 209.4501 | 210.91 | 207.67 | 207.8867 | 5683827.0 |
| 2025-07-14 10:00:00 | AAPL | Stock | 207.9 | 208.78 | 207.54 | 208.485 | 4695855.0 |
| 2025-07-14 11:00:00 | AAPL | Stock | 208.48 | 209.15 | 208.2001 | 208.84 | 3195076.0 |
| 2025-07-14 12:00:00 | AAPL | Stock | 208.83 | 209.245 | 208.68 | 208.9 | 1847665.0 |
| 2025-07-14 13:00:00 | AAPL | Stock | 208.89 | 209.33 | 208.7602 | 209.155 | 1951478.0 |
| 2025-07-14 14:00:00 | AAPL | Stock | 209.16 | 209.45 | 208.9608 | 209.3101 | 1828957.0 |
| 2025-07-14 15:00:00 | AAPL | Stock | 209.315 | 209.36 | 208.52 | 208.54 | 4833609.0 |
| 2025-07-14 16:00:00 | AAPL | Stock | 208.54 | 208.68 | 208.41 | 208.52 | 5555302.0 |
| 2025-07-14 17:00:00 | AAPL | Stock | 208.53 | 208.62 | 208.48 | 208.5186 | 18223.0 |
| 2025-07-14 18:00:00 | AAPL | Stock | 208.49 | 208.52 | 207.78 | 208.15 | 67545.0 |
| 2025-07-14 19:00:00 | AAPL | Stock | 208.15 | 208.19 | 208.0 | 208.01 | 46795.0 |
| 2025-07-14 04:00:00 | MSFT | Stock | 500.5 | 501.5 | 500.5 | 501.38 | 3279.0 |
| 2025-07-14 05:00:00 | MSFT | Stock | 501.44 | 501.44 | 501.01 | 501.01 | 2452.0 |
| 2025-07-14 06:00:00 | MSFT | Stock | 501.0 | 501.41 | 500.89 | 501.41 | 2893.0 |
| 2025-07-14 07:00:00 | MSFT | Stock | 501.21 | 501.7 | 501.02 | 501.45 | 3868.0 |
| 2025-07-14 08:00:00 | MSFT | Stock | 501.55 | 502.062 | 500.01 | 501.39 | 11212.0 |
| 2025-07-14 09:00:00 | MSFT | Stock | 501.39 | 502.89 | 500.9 | 502.58 | 856781.0 |
| 2025-07-14 10:00:00 | MSFT | Stock | 502.55 | 502.92 | 501.1 | 502.86 | 852696.0 |
| 2025-07-14 11:00:00 | MSFT | Stock | 502.86 | 503.97 | 502.3572 | 502.93 | 674331.0 |
| 2025-07-14 12:00:00 | MSFT | Stock | 502.9486 | 503.4 | 502.3006 | 502.33 | 409342.0 |
| 2025-07-14 13:00:00 | MSFT | Stock | 502.34 | 503.08 | 502.16 | 502.71 | 504762.0 |
| 2025-07-14 14:00:00 | MSFT | Stock | 502.66 | 503.33 | 502.1671 | 503.07 | 458874.0 |
| 2025-07-14 15:00:00 | MSFT | Stock | 503.065 | 503.5 | 502.58 | 502.94 | 921564.0 |
| 2025-07-14 16:00:00 | MSFT | Stock | 503.02 | 503.23 | 502.63 | 502.9 | 1318673.0 |
| 2025-07-14 17:00:00 | MSFT | Stock | 503.25 | 503.25 | 502.91 | 503.0 | 1552.0 |
| 2025-07-14 18:00:00 | MSFT | Stock | 503.0 | 503.0433 | 502.85 | 503.0433 | 1847.0 |
| 2025-07-14 19:00:00 | MSFT | Stock | 502.55 | 502.9749 | 502.24 | 502.24 | 1758.0 |
| 2025-07-14 04:00:00 | NVDA | Stock | 164.76 | 165.74 | 164.04 | 165.58 | 280590.0 |
| 2025-07-14 05:00:00 | NVDA | Stock | 165.6 | 166.0 | 165.32 | 165.89 | 152291.0 |
| 2025-07-14 06:00:00 | NVDA | Stock | 165.94 | 165.96 | 164.86 | 164.95 | 349318.0 |
| 2025-07-14 07:00:00 | NVDA | Stock | 164.99 | 165.31 | 164.8 | 164.87 | 431927.0 |
| 2025-07-14 08:00:00 | NVDA | Stock | 165.59 | 165.96 | 164.31 | 165.42 | 1630714.0 |
| 2025-07-14 09:00:00 | NVDA | Stock | 165.43 | 165.9 | 162.02 | 163.14 | 25980733.0 |
| 2025-07-14 10:00:00 | NVDA | Stock | 163.14 | 164.31 | 163.1001 | 164.2847 | 20182101.0 |
| 2025-07-14 11:00:00 | NVDA | Stock | 164.285 | 165.285 | 164.225 | 165.1481 | 17703936.0 |
| 2025-07-14 12:00:00 | NVDA | Stock | 165.14 | 165.18 | 164.57 | 165.02 | 8874368.0 |
| 2025-07-14 13:00:00 | NVDA | Stock | 165.03 | 165.36 | 164.7898 | 164.8206 | 7291570.0 |
| 2025-07-14 14:00:00 | NVDA | Stock | 164.825 | 165.07 | 164.49 | 164.91 | 7215862.0 |
| 2025-07-14 15:00:00 | NVDA | Stock | 164.905 | 164.935 | 164.0 | 164.07 | 15070568.0 |
| 2025-07-14 16:00:00 | NVDA | Stock | 163.95 | 164.19 | 163.7104 | 164.16 | 8189930.0 |
| 2025-07-14 17:00:00 | NVDA | Stock | 164.17 | 164.19 | 164.0 | 164.02 | 150113.0 |
| 2025-07-14 18:00:00 | NVDA | Stock | 164.02 | 164.05 | 163.9 | 163.9699 | 134392.0 |
| 2025-07-14 19:00:00 | NVDA | Stock | 163.97 | 164.0 | 163.86 | 163.8699 | 174308.0 |
| 2025-07-14 04:00:00 | AMZN | Stock | 224.78 | 224.78 | 223.32 | 223.79 | 21321.0 |
| 2025-07-14 05:00:00 | AMZN | Stock | 223.76 | 224.2 | 223.6 | 224.08 | 12747.0 |
> showing 50 of 64,131 rows — these rows as CSV