PREVIEW / stock_1hour / 2024-08-13
file: by_date/stock_1hour/2024/2024-08-13.parquet size: 1.3 MB rows: 57,752 symbols: 861
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-08-13 04:00:00 | AAPL | Stock | 218.31 | 218.83 | 218.03 | 218.54 | 12798.0 |
| 2024-08-13 05:00:00 | AAPL | Stock | 218.54 | 218.7 | 218.54 | 218.66 | 5204.0 |
| 2024-08-13 06:00:00 | AAPL | Stock | 218.65 | 218.65 | 217.56 | 217.89 | 16381.0 |
| 2024-08-13 07:00:00 | AAPL | Stock | 217.92 | 218.32 | 217.85 | 218.24 | 18340.0 |
| 2024-08-13 08:00:00 | AAPL | Stock | 217.97 | 219.01 | 217.79 | 218.5009 | 135082.0 |
| 2024-08-13 09:00:00 | AAPL | Stock | 218.58 | 221.47 | 218.15 | 221.13 | 5623983.0 |
| 2024-08-13 10:00:00 | AAPL | Stock | 221.13 | 221.71 | 220.2606 | 220.97 | 4126011.0 |
| 2024-08-13 11:00:00 | AAPL | Stock | 220.98 | 221.5987 | 220.89 | 221.1203 | 2608984.0 |
| 2024-08-13 12:00:00 | AAPL | Stock | 221.1 | 221.59 | 220.92 | 221.585 | 2130567.0 |
| 2024-08-13 13:00:00 | AAPL | Stock | 221.57 | 221.89 | 220.56 | 220.93 | 2378058.0 |
| 2024-08-13 14:00:00 | AAPL | Stock | 220.93 | 221.4849 | 220.71 | 221.23 | 1809710.0 |
| 2024-08-13 15:00:00 | AAPL | Stock | 221.23 | 221.31 | 220.42 | 221.27 | 4162476.0 |
| 2024-08-13 16:00:00 | AAPL | Stock | 221.275 | 221.35 | 220.01 | 220.44 | 8222956.0 |
| 2024-08-13 17:00:00 | AAPL | Stock | 220.45 | 220.7385 | 220.41 | 220.68 | 21728.0 |
| 2024-08-13 18:00:00 | AAPL | Stock | 220.69 | 220.88 | 220.5 | 220.65 | 17692.0 |
| 2024-08-13 19:00:00 | AAPL | Stock | 220.6 | 220.75 | 220.49 | 220.7 | 33756.0 |
| 2024-08-13 04:00:00 | MSFT | Stock | 408.5 | 409.4 | 407.49 | 409.25 | 7222.0 |
| 2024-08-13 05:00:00 | MSFT | Stock | 409.17 | 409.5 | 409.01 | 409.5 | 2068.0 |
| 2024-08-13 06:00:00 | MSFT | Stock | 409.0 | 409.13 | 406.81 | 407.5 | 9352.0 |
| 2024-08-13 07:00:00 | MSFT | Stock | 407.31 | 408.2 | 407.3 | 408.03 | 6322.0 |
| 2024-08-13 08:00:00 | MSFT | Stock | 407.6 | 410.241 | 406.51 | 410.11 | 46908.0 |
| 2024-08-13 09:00:00 | MSFT | Stock | 410.08 | 412.88 | 409.02 | 411.52 | 1264933.0 |
| 2024-08-13 10:00:00 | MSFT | Stock | 411.56 | 412.295 | 409.93 | 412.12 | 1076343.0 |
| 2024-08-13 11:00:00 | MSFT | Stock | 412.11 | 413.77 | 412.06 | 413.22 | 967544.0 |
| 2024-08-13 12:00:00 | MSFT | Stock | 413.22 | 414.95 | 412.88 | 414.8 | 747610.0 |
| 2024-08-13 13:00:00 | MSFT | Stock | 414.79 | 414.87 | 412.85 | 414.0 | 631977.0 |
| 2024-08-13 14:00:00 | MSFT | Stock | 414.0 | 414.63 | 413.73 | 414.6 | 488389.0 |
| 2024-08-13 15:00:00 | MSFT | Stock | 414.65 | 414.84 | 412.51 | 413.96 | 2164593.0 |
| 2024-08-13 16:00:00 | MSFT | Stock | 414.02 | 414.4 | 413.0 | 414.01 | 4785257.0 |
| 2024-08-13 17:00:00 | MSFT | Stock | 414.37 | 414.6299 | 414.0001 | 414.4936 | 12936.0 |
| 2024-08-13 18:00:00 | MSFT | Stock | 414.5 | 414.7 | 414.0 | 414.04 | 4280.0 |
| 2024-08-13 19:00:00 | MSFT | Stock | 414.04 | 414.8 | 414.04 | 414.8 | 4008.0 |
| 2024-08-13 04:00:00 | NVDA | Stock | 110.9 | 111.38 | 109.88 | 110.76 | 936042.0 |
| 2024-08-13 05:00:00 | NVDA | Stock | 110.76 | 111.09 | 110.52 | 110.7 | 417471.0 |
| 2024-08-13 06:00:00 | NVDA | Stock | 110.71 | 110.71 | 109.82 | 109.83 | 453611.0 |
| 2024-08-13 07:00:00 | NVDA | Stock | 109.83 | 111.0 | 109.57 | 110.98 | 1145698.0 |
| 2024-08-13 08:00:00 | NVDA | Stock | 109.68 | 113.3699 | 109.292 | 113.16 | 7965756.0 |
| 2024-08-13 09:00:00 | NVDA | Stock | 113.18 | 113.95 | 111.58 | 113.7816 | 47161909.0 |
| 2024-08-13 10:00:00 | NVDA | Stock | 113.79 | 114.75 | 113.31 | 114.5615 | 47931952.0 |
| 2024-08-13 11:00:00 | NVDA | Stock | 114.56 | 115.0 | 113.93 | 113.9801 | 30295223.0 |
| 2024-08-13 12:00:00 | NVDA | Stock | 113.985 | 115.13 | 113.85 | 115.11 | 23473839.0 |
| 2024-08-13 13:00:00 | NVDA | Stock | 115.11 | 115.73 | 114.4301 | 115.265 | 28164616.0 |
| 2024-08-13 14:00:00 | NVDA | Stock | 115.265 | 116.18 | 115.1 | 115.99 | 23386535.0 |
| 2024-08-13 15:00:00 | NVDA | Stock | 115.99 | 116.23 | 115.14 | 116.17 | 37533572.0 |
| 2024-08-13 16:00:00 | NVDA | Stock | 116.14 | 116.74 | 115.98 | 116.2896 | 29810085.0 |
| 2024-08-13 17:00:00 | NVDA | Stock | 116.29 | 116.59 | 116.22 | 116.58 | 724202.0 |
| 2024-08-13 18:00:00 | NVDA | Stock | 116.58 | 116.73 | 116.4899 | 116.691 | 675156.0 |
| 2024-08-13 19:00:00 | NVDA | Stock | 116.7 | 116.8 | 116.45 | 116.77 | 917252.0 |
| 2024-08-13 04:00:00 | AMZN | Stock | 167.9 | 168.0 | 167.5 | 167.6 | 15725.0 |
| 2024-08-13 05:00:00 | AMZN | Stock | 167.72 | 167.9 | 167.5 | 167.8 | 3760.0 |
> showing 50 of 57,752 rows — these rows as CSV