PREVIEW / stock_1hour / 2024-03-12
file: by_date/stock_1hour/2024/2024-03-12.parquet size: 1.4 MB rows: 59,995 symbols: 1,104
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-12 04:00:00 | AAPL | Stock | 173.5 | 173.86 | 173.29 | 173.3 | 11269.0 |
| 2024-03-12 05:00:00 | AAPL | Stock | 173.3 | 173.49 | 172.91 | 173.36 | 19657.0 |
| 2024-03-12 06:00:00 | AAPL | Stock | 173.3 | 173.5 | 173.3 | 173.49 | 10076.0 |
| 2024-03-12 07:00:00 | AAPL | Stock | 173.5 | 173.57 | 173.3 | 173.37 | 27005.0 |
| 2024-03-12 08:00:00 | AAPL | Stock | 173.43 | 174.32 | 172.75 | 173.25 | 292087.0 |
| 2024-03-12 09:00:00 | AAPL | Stock | 173.37 | 173.4899 | 171.01 | 171.455 | 6600938.0 |
| 2024-03-12 10:00:00 | AAPL | Stock | 171.48 | 172.9 | 171.45 | 172.61 | 7064710.0 |
| 2024-03-12 11:00:00 | AAPL | Stock | 172.62 | 172.91 | 172.3201 | 172.585 | 4370294.0 |
| 2024-03-12 12:00:00 | AAPL | Stock | 172.5854 | 173.1 | 171.94 | 172.5274 | 5400858.0 |
| 2024-03-12 13:00:00 | AAPL | Stock | 172.5236 | 173.49 | 172.38 | 173.2637 | 4341851.0 |
| 2024-03-12 14:00:00 | AAPL | Stock | 173.27 | 173.97 | 173.19 | 173.7344 | 4057993.0 |
| 2024-03-12 15:00:00 | AAPL | Stock | 173.73 | 174.03 | 173.15 | 173.22 | 7164026.0 |
| 2024-03-12 16:00:00 | AAPL | Stock | 173.22 | 173.26 | 172.85 | 173.09 | 7167163.0 |
| 2024-03-12 17:00:00 | AAPL | Stock | 173.09 | 173.23 | 173.05 | 173.0799 | 36846.0 |
| 2024-03-12 18:00:00 | AAPL | Stock | 173.06 | 173.1 | 172.85 | 173.0118 | 42935.0 |
| 2024-03-12 19:00:00 | AAPL | Stock | 173.01 | 173.18 | 172.92 | 173.0 | 30603.0 |
| 2024-03-12 04:00:00 | MSFT | Stock | 406.55 | 406.55 | 406.15 | 406.22 | 2433.0 |
| 2024-03-12 05:00:00 | MSFT | Stock | 406.61 | 406.61 | 406.61 | 406.61 | 100.0 |
| 2024-03-12 06:00:00 | MSFT | Stock | 406.39 | 406.39 | 406.3 | 406.3 | 522.0 |
| 2024-03-12 07:00:00 | MSFT | Stock | 406.6 | 406.75 | 406.54 | 406.7 | 4150.0 |
| 2024-03-12 08:00:00 | MSFT | Stock | 406.6 | 407.7563 | 404.4 | 407.15 | 57207.0 |
| 2024-03-12 09:00:00 | MSFT | Stock | 407.15 | 409.677 | 405.5 | 409.61 | 1519954.0 |
| 2024-03-12 10:00:00 | MSFT | Stock | 409.625 | 414.45 | 409.51 | 413.3 | 2274097.0 |
| 2024-03-12 11:00:00 | MSFT | Stock | 413.3 | 414.21 | 412.62 | 413.22 | 1275524.0 |
| 2024-03-12 12:00:00 | MSFT | Stock | 413.225 | 413.7 | 411.8 | 412.4923 | 1314118.0 |
| 2024-03-12 13:00:00 | MSFT | Stock | 412.4604 | 414.89 | 411.6 | 414.1 | 1437785.0 |
| 2024-03-12 14:00:00 | MSFT | Stock | 414.12 | 415.49 | 413.95 | 414.83 | 1377274.0 |
| 2024-03-12 15:00:00 | MSFT | Stock | 414.83 | 415.57 | 414.43 | 415.26 | 2042996.0 |
| 2024-03-12 16:00:00 | MSFT | Stock | 415.23 | 415.44 | 414.5179 | 415.3 | 3237889.0 |
| 2024-03-12 17:00:00 | MSFT | Stock | 415.25 | 415.48 | 415.05 | 415.1 | 48186.0 |
| 2024-03-12 18:00:00 | MSFT | Stock | 415.3 | 415.49 | 414.81 | 415.43 | 6185.0 |
| 2024-03-12 19:00:00 | MSFT | Stock | 415.3 | 415.6 | 414.61 | 415.02 | 8570.0 |
| 2024-03-12 04:00:00 | NVDA | Stock | 87.32 | 87.7 | 86.921 | 87.057 | 416870.0 |
| 2024-03-12 05:00:00 | NVDA | Stock | 87.06 | 87.42 | 87.013 | 87.194 | 108380.0 |
| 2024-03-12 06:00:00 | NVDA | Stock | 87.25 | 87.5 | 87.15 | 87.2 | 182300.0 |
| 2024-03-12 07:00:00 | NVDA | Stock | 87.212 | 87.341 | 86.58 | 86.96 | 1001250.0 |
| 2024-03-12 08:00:00 | NVDA | Stock | 87.2 | 88.2 | 86.223 | 87.67 | 7989410.0 |
| 2024-03-12 09:00:00 | NVDA | Stock | 87.67 | 88.2 | 86.1501 | 87.721 | 68613390.0 |
| 2024-03-12 10:00:00 | NVDA | Stock | 87.728 | 90.54 | 87.46 | 89.945 | 99562420.0 |
| 2024-03-12 11:00:00 | NVDA | Stock | 89.999 | 91.2 | 89.821 | 90.8192 | 73165780.0 |
| 2024-03-12 12:00:00 | NVDA | Stock | 90.843 | 90.879 | 89.456 | 89.501 | 47579990.0 |
| 2024-03-12 13:00:00 | NVDA | Stock | 89.515 | 90.361 | 89.0423 | 89.9579 | 47162330.0 |
| 2024-03-12 14:00:00 | NVDA | Stock | 89.9548 | 90.649 | 89.9 | 90.452 | 39011450.0 |
| 2024-03-12 15:00:00 | NVDA | Stock | 90.4448 | 91.96 | 90.195 | 91.938 | 56962380.0 |
| 2024-03-12 16:00:00 | NVDA | Stock | 91.913 | 92.788 | 90.2814 | 92.633 | 28793900.0 |
| 2024-03-12 17:00:00 | NVDA | Stock | 92.625 | 92.7 | 91.913 | 92.65 | 1768750.0 |
| 2024-03-12 18:00:00 | NVDA | Stock | 92.636 | 92.998 | 92.6 | 92.971 | 1651210.0 |
| 2024-03-12 19:00:00 | NVDA | Stock | 92.977 | 93.232 | 92.9 | 93.118 | 1824180.0 |
| 2024-03-12 04:00:00 | AMZN | Stock | 173.0 | 173.41 | 172.79 | 172.85 | 5192.0 |
| 2024-03-12 05:00:00 | AMZN | Stock | 172.77 | 172.9 | 172.77 | 172.85 | 2501.0 |
> showing 50 of 59,995 rows — these rows as CSV