PREVIEW / stock_1hour / 2024-04-16
file: by_date/stock_1hour/2024/2024-04-16.parquet size: 1.3 MB rows: 58,781 symbols: 999
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-04-16 04:00:00 | AAPL | Stock | 172.4 | 172.61 | 172.21 | 172.31 | 11311.0 |
| 2024-04-16 05:00:00 | AAPL | Stock | 172.24 | 172.25 | 171.57 | 171.76 | 16300.0 |
| 2024-04-16 06:00:00 | AAPL | Stock | 171.76 | 172.2 | 171.64 | 172.12 | 21828.0 |
| 2024-04-16 07:00:00 | AAPL | Stock | 172.14 | 172.7 | 172.14 | 172.55 | 22148.0 |
| 2024-04-16 08:00:00 | AAPL | Stock | 172.2393 | 173.0 | 171.9667 | 172.82 | 91979.0 |
| 2024-04-16 09:00:00 | AAPL | Stock | 172.75 | 173.7599 | 171.33 | 172.82 | 7651431.0 |
| 2024-04-16 10:00:00 | AAPL | Stock | 172.83 | 172.975 | 169.12 | 169.1452 | 10539135.0 |
| 2024-04-16 11:00:00 | AAPL | Stock | 169.14 | 169.67 | 168.405 | 169.035 | 9626726.0 |
| 2024-04-16 12:00:00 | AAPL | Stock | 169.03 | 169.85 | 168.27 | 169.06 | 6404646.0 |
| 2024-04-16 13:00:00 | AAPL | Stock | 169.07 | 169.73 | 168.4 | 169.445 | 5284460.0 |
| 2024-04-16 14:00:00 | AAPL | Stock | 169.45 | 170.4 | 168.825 | 170.07 | 5604586.0 |
| 2024-04-16 15:00:00 | AAPL | Stock | 170.08 | 170.09 | 169.28 | 169.34 | 7002256.0 |
| 2024-04-16 16:00:00 | AAPL | Stock | 169.38 | 169.55 | 169.22 | 169.5 | 6911977.0 |
| 2024-04-16 17:00:00 | AAPL | Stock | 169.45 | 169.6885 | 169.38 | 169.49 | 42102.0 |
| 2024-04-16 18:00:00 | AAPL | Stock | 169.5 | 169.68 | 169.4729 | 169.62 | 31208.0 |
| 2024-04-16 19:00:00 | AAPL | Stock | 169.63 | 169.85 | 169.61 | 169.8 | 34672.0 |
| 2024-04-16 04:00:00 | MSFT | Stock | 413.57 | 414.47 | 413.52 | 414.47 | 4658.0 |
| 2024-04-16 05:00:00 | MSFT | Stock | 414.78 | 414.79 | 414.01 | 414.01 | 2240.0 |
| 2024-04-16 06:00:00 | MSFT | Stock | 413.97 | 413.97 | 412.22 | 413.48 | 2872.0 |
| 2024-04-16 07:00:00 | MSFT | Stock | 413.38 | 415.57 | 413.38 | 415.41 | 8523.0 |
| 2024-04-16 08:00:00 | MSFT | Stock | 414.31 | 415.6969 | 411.72 | 414.88 | 33135.0 |
| 2024-04-16 09:00:00 | MSFT | Stock | 414.8 | 416.65 | 413.66 | 416.36 | 1477846.0 |
| 2024-04-16 10:00:00 | MSFT | Stock | 416.36 | 417.6443 | 415.0 | 415.79 | 1360008.0 |
| 2024-04-16 11:00:00 | MSFT | Stock | 415.79 | 417.2799 | 415.68 | 415.99 | 877290.0 |
| 2024-04-16 12:00:00 | MSFT | Stock | 416.0 | 416.79 | 415.48 | 416.16 | 630385.0 |
| 2024-04-16 13:00:00 | MSFT | Stock | 416.22 | 417.0 | 414.58 | 416.065 | 785163.0 |
| 2024-04-16 14:00:00 | MSFT | Stock | 416.03 | 418.4 | 414.75 | 417.45 | 870506.0 |
| 2024-04-16 15:00:00 | MSFT | Stock | 417.5 | 417.66 | 414.22 | 414.5 | 1202096.0 |
| 2024-04-16 16:00:00 | MSFT | Stock | 414.58 | 415.41 | 414.57 | 415.2 | 2283069.0 |
| 2024-04-16 17:00:00 | MSFT | Stock | 415.3 | 415.4999 | 414.58 | 415.2 | 4633.0 |
| 2024-04-16 18:00:00 | MSFT | Stock | 415.25 | 415.81 | 415.0001 | 415.81 | 2478.0 |
| 2024-04-16 19:00:00 | MSFT | Stock | 415.6 | 416.05 | 415.6 | 415.9 | 3634.0 |
| 2024-04-16 04:00:00 | NVDA | Stock | 85.752 | 86.26 | 85.711 | 86.1 | 210310.0 |
| 2024-04-16 05:00:00 | NVDA | Stock | 86.012 | 86.071 | 85.2 | 85.401 | 133450.0 |
| 2024-04-16 06:00:00 | NVDA | Stock | 85.25 | 85.884 | 84.93 | 85.758 | 328470.0 |
| 2024-04-16 07:00:00 | NVDA | Stock | 85.761 | 86.828 | 85.75 | 86.5 | 965040.0 |
| 2024-04-16 08:00:00 | NVDA | Stock | 85.899 | 86.83 | 85.5 | 86.636 | 2117580.0 |
| 2024-04-16 09:00:00 | NVDA | Stock | 86.636 | 87.645 | 86.0639 | 87.487 | 50247690.0 |
| 2024-04-16 10:00:00 | NVDA | Stock | 87.47 | 87.9 | 86.612 | 86.9815 | 52357830.0 |
| 2024-04-16 11:00:00 | NVDA | Stock | 86.9815 | 87.55 | 86.72 | 86.9369 | 28861980.0 |
| 2024-04-16 12:00:00 | NVDA | Stock | 86.92 | 87.558 | 86.713 | 87.459 | 23260220.0 |
| 2024-04-16 13:00:00 | NVDA | Stock | 87.46 | 87.778 | 86.801 | 87.4255 | 30242510.0 |
| 2024-04-16 14:00:00 | NVDA | Stock | 87.4065 | 88.118 | 87.24 | 87.9123 | 34884140.0 |
| 2024-04-16 15:00:00 | NVDA | Stock | 87.939 | 88.088 | 87.38 | 87.4139 | 31376850.0 |
| 2024-04-16 16:00:00 | NVDA | Stock | 87.415 | 87.56 | 87.25 | 87.5 | 11085950.0 |
| 2024-04-16 17:00:00 | NVDA | Stock | 87.5115 | 87.5115 | 87.401 | 87.453 | 170340.0 |
| 2024-04-16 18:00:00 | NVDA | Stock | 87.499 | 87.78 | 87.434 | 87.743 | 207520.0 |
| 2024-04-16 19:00:00 | NVDA | Stock | 87.725 | 88.0 | 87.682 | 87.989 | 633050.0 |
| 2024-04-16 04:00:00 | AMZN | Stock | 183.62 | 183.62 | 182.93 | 183.0 | 5195.0 |
| 2024-04-16 05:00:00 | AMZN | Stock | 183.12 | 183.12 | 182.61 | 182.98 | 7239.0 |
> showing 50 of 58,781 rows — these rows as CSV