PREVIEW / stock_1hour / 2024-04-26
file: by_date/stock_1hour/2024/2024-04-26.parquet size: 1.3 MB rows: 57,249 symbols: 964
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-26 04:00:00 | AAPL | Stock | 169.99 | 170.19 | 169.99 | 170.11 | 10107.0 |
| 2024-04-26 05:00:00 | AAPL | Stock | 170.05 | 170.17 | 170.0 | 170.11 | 8337.0 |
| 2024-04-26 06:00:00 | AAPL | Stock | 170.15 | 170.21 | 169.89 | 169.99 | 12155.0 |
| 2024-04-26 07:00:00 | AAPL | Stock | 170.0 | 170.3 | 169.86 | 170.17 | 31045.0 |
| 2024-04-26 08:00:00 | AAPL | Stock | 169.99 | 170.98 | 169.8002 | 170.5802 | 131773.0 |
| 2024-04-26 09:00:00 | AAPL | Stock | 170.67 | 170.85 | 169.54 | 170.1 | 4487741.0 |
| 2024-04-26 10:00:00 | AAPL | Stock | 170.11 | 171.18 | 170.03 | 171.09 | 4935490.0 |
| 2024-04-26 11:00:00 | AAPL | Stock | 171.09 | 171.34 | 170.3832 | 170.52 | 3576696.0 |
| 2024-04-26 12:00:00 | AAPL | Stock | 170.52 | 170.53 | 169.93 | 170.0173 | 3593832.0 |
| 2024-04-26 13:00:00 | AAPL | Stock | 170.0162 | 170.1684 | 169.37 | 169.475 | 3223382.0 |
| 2024-04-26 14:00:00 | AAPL | Stock | 169.48 | 170.02 | 169.37 | 170.015 | 3351940.0 |
| 2024-04-26 15:00:00 | AAPL | Stock | 170.01 | 170.11 | 169.18 | 169.29 | 6323127.0 |
| 2024-04-26 16:00:00 | AAPL | Stock | 169.3 | 169.55 | 169.14 | 169.39 | 6476431.0 |
| 2024-04-26 17:00:00 | AAPL | Stock | 169.43 | 169.49 | 169.33 | 169.43 | 19644.0 |
| 2024-04-26 18:00:00 | AAPL | Stock | 169.4219 | 170.0 | 169.3935 | 169.82 | 69053.0 |
| 2024-04-26 19:00:00 | AAPL | Stock | 169.82 | 169.85 | 169.59 | 169.6 | 19758.0 |
| 2024-04-26 04:00:00 | MSFT | Stock | 415.6 | 418.0 | 413.0 | 414.03 | 32999.0 |
| 2024-04-26 05:00:00 | MSFT | Stock | 414.03 | 415.57 | 414.0 | 414.77 | 19831.0 |
| 2024-04-26 06:00:00 | MSFT | Stock | 414.98 | 415.98 | 414.98 | 415.16 | 7641.0 |
| 2024-04-26 07:00:00 | MSFT | Stock | 415.4 | 416.78 | 415.4 | 415.91 | 41905.0 |
| 2024-04-26 08:00:00 | MSFT | Stock | 416.0 | 417.55 | 412.47 | 413.68 | 259000.0 |
| 2024-04-26 09:00:00 | MSFT | Stock | 413.92 | 414.73 | 405.7601 | 409.09 | 5395254.0 |
| 2024-04-26 10:00:00 | MSFT | Stock | 409.14 | 412.33 | 407.52 | 410.81 | 3698723.0 |
| 2024-04-26 11:00:00 | MSFT | Stock | 410.82 | 412.09 | 408.44 | 409.78 | 1947450.0 |
| 2024-04-26 12:00:00 | MSFT | Stock | 409.74 | 410.11 | 408.145 | 409.56 | 1214080.0 |
| 2024-04-26 13:00:00 | MSFT | Stock | 409.56 | 410.2 | 408.71 | 409.67 | 1210956.0 |
| 2024-04-26 14:00:00 | MSFT | Stock | 409.7 | 409.77 | 408.08 | 409.04 | 1201588.0 |
| 2024-04-26 15:00:00 | MSFT | Stock | 409.05 | 409.69 | 406.09 | 406.14 | 2413537.0 |
| 2024-04-26 16:00:00 | MSFT | Stock | 406.32 | 407.13 | 406.05 | 406.55 | 2980084.0 |
| 2024-04-26 17:00:00 | MSFT | Stock | 406.55 | 406.68 | 406.32 | 406.45 | 10110.0 |
| 2024-04-26 18:00:00 | MSFT | Stock | 406.5 | 406.5 | 406.05 | 406.27 | 12708.0 |
| 2024-04-26 19:00:00 | MSFT | Stock | 406.23 | 406.49 | 406.0 | 406.02 | 21074.0 |
| 2024-04-26 04:00:00 | NVDA | Stock | 84.23 | 84.4 | 83.762 | 83.91 | 259890.0 |
| 2024-04-26 05:00:00 | NVDA | Stock | 83.9 | 83.915 | 83.442 | 83.6 | 167970.0 |
| 2024-04-26 06:00:00 | NVDA | Stock | 83.68 | 83.919 | 83.55 | 83.679 | 147210.0 |
| 2024-04-26 07:00:00 | NVDA | Stock | 83.781 | 84.319 | 83.75 | 84.2 | 762310.0 |
| 2024-04-26 08:00:00 | NVDA | Stock | 83.89 | 84.5811 | 83.655 | 83.999 | 3945610.0 |
| 2024-04-26 09:00:00 | NVDA | Stock | 84.029 | 85.674 | 83.387 | 85.5905 | 61286800.0 |
| 2024-04-26 10:00:00 | NVDA | Stock | 85.609 | 86.98 | 85.2901 | 86.701 | 82420190.0 |
| 2024-04-26 11:00:00 | NVDA | Stock | 86.711 | 87.4141 | 86.45 | 86.528 | 47038050.0 |
| 2024-04-26 12:00:00 | NVDA | Stock | 86.5295 | 87.64 | 86.226 | 87.59 | 40850860.0 |
| 2024-04-26 13:00:00 | NVDA | Stock | 87.59 | 88.3309 | 87.374 | 87.527 | 44530060.0 |
| 2024-04-26 14:00:00 | NVDA | Stock | 87.521 | 87.75 | 86.884 | 87.5782 | 42518730.0 |
| 2024-04-26 15:00:00 | NVDA | Stock | 87.5682 | 87.857 | 87.227 | 87.715 | 47268550.0 |
| 2024-04-26 16:00:00 | NVDA | Stock | 87.735 | 87.9 | 87.7 | 87.735 | 20785990.0 |
| 2024-04-26 17:00:00 | NVDA | Stock | 87.735 | 87.842 | 87.639 | 87.805 | 441280.0 |
| 2024-04-26 18:00:00 | NVDA | Stock | 87.813 | 88.1 | 87.735 | 87.922 | 676350.0 |
| 2024-04-26 19:00:00 | NVDA | Stock | 87.962 | 88.0 | 87.9 | 87.93 | 399260.0 |
| 2024-04-26 04:00:00 | AMZN | Stock | 179.01 | 179.63 | 178.56 | 179.01 | 16779.0 |
| 2024-04-26 05:00:00 | AMZN | Stock | 179.11 | 179.32 | 178.78 | 179.29 | 7096.0 |
> showing 50 of 57,249 rows — these rows as CSV