PREVIEW / stock_1hour / 2024-08-01
file: by_date/stock_1hour/2024/2024-08-01.parquet size: 1.3 MB rows: 59,951 symbols: 875
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-01 04:00:00 | AAPL | Stock | 223.8 | 223.8 | 222.7 | 223.05 | 20916.0 |
| 2024-08-01 05:00:00 | AAPL | Stock | 223.26 | 223.65 | 223.26 | 223.62 | 9297.0 |
| 2024-08-01 06:00:00 | AAPL | Stock | 223.6 | 224.08 | 223.6 | 224.0 | 10830.0 |
| 2024-08-01 07:00:00 | AAPL | Stock | 224.0 | 224.84 | 223.97 | 224.25 | 73209.0 |
| 2024-08-01 08:00:00 | AAPL | Stock | 223.98 | 224.88 | 223.5 | 224.44 | 227401.0 |
| 2024-08-01 09:00:00 | AAPL | Stock | 224.44 | 224.7 | 222.56 | 224.28 | 4642958.0 |
| 2024-08-01 10:00:00 | AAPL | Stock | 224.24 | 224.31 | 220.3503 | 220.985 | 5915801.0 |
| 2024-08-01 11:00:00 | AAPL | Stock | 221.0 | 221.175 | 219.21 | 219.8 | 3579517.0 |
| 2024-08-01 12:00:00 | AAPL | Stock | 219.7901 | 220.17 | 218.455 | 218.74 | 3189150.0 |
| 2024-08-01 13:00:00 | AAPL | Stock | 218.72 | 218.9 | 217.19 | 218.63 | 3535947.0 |
| 2024-08-01 14:00:00 | AAPL | Stock | 218.62 | 218.8 | 217.02 | 217.495 | 4582106.0 |
| 2024-08-01 15:00:00 | AAPL | Stock | 217.48 | 219.14 | 217.12 | 218.28 | 7772845.0 |
| 2024-08-01 16:00:00 | AAPL | Stock | 218.36 | 223.9 | 214.0 | 219.77 | 10409948.0 |
| 2024-08-01 17:00:00 | AAPL | Stock | 219.75 | 220.7999 | 212.35 | 219.0 | 2735414.0 |
| 2024-08-01 18:00:00 | AAPL | Stock | 220.0 | 221.1803 | 218.36 | 220.0 | 463798.0 |
| 2024-08-01 19:00:00 | AAPL | Stock | 220.0 | 220.05 | 219.0 | 219.6 | 225850.0 |
| 2024-08-01 04:00:00 | MSFT | Stock | 419.96 | 420.5 | 417.86 | 419.35 | 9128.0 |
| 2024-08-01 05:00:00 | MSFT | Stock | 420.0 | 420.7 | 419.78 | 420.7 | 2030.0 |
| 2024-08-01 06:00:00 | MSFT | Stock | 420.51 | 420.66 | 420.03 | 420.2 | 1035.0 |
| 2024-08-01 07:00:00 | MSFT | Stock | 419.97 | 420.03 | 417.55 | 417.89 | 23643.0 |
| 2024-08-01 08:00:00 | MSFT | Stock | 419.99 | 421.66 | 417.7001 | 420.49 | 85389.0 |
| 2024-08-01 09:00:00 | MSFT | Stock | 420.65 | 427.29 | 418.2 | 427.04 | 3268518.0 |
| 2024-08-01 10:00:00 | MSFT | Stock | 426.94 | 427.46 | 422.45 | 423.71 | 2744774.0 |
| 2024-08-01 11:00:00 | MSFT | Stock | 423.73 | 424.025 | 416.66 | 417.61 | 2009217.0 |
| 2024-08-01 12:00:00 | MSFT | Stock | 417.73 | 421.08 | 417.35 | 417.7 | 1564445.0 |
| 2024-08-01 13:00:00 | MSFT | Stock | 417.68 | 418.29 | 413.0901 | 415.7 | 1520333.0 |
| 2024-08-01 14:00:00 | MSFT | Stock | 415.65 | 416.02 | 413.68 | 414.8336 | 1045985.0 |
| 2024-08-01 15:00:00 | MSFT | Stock | 414.7208 | 418.31 | 414.26 | 417.05 | 2307010.0 |
| 2024-08-01 16:00:00 | MSFT | Stock | 417.11 | 417.12 | 413.0 | 414.45 | 4618767.0 |
| 2024-08-01 17:00:00 | MSFT | Stock | 414.4 | 417.11 | 414.1 | 415.28 | 223631.0 |
| 2024-08-01 18:00:00 | MSFT | Stock | 416.0 | 417.11 | 414.02 | 414.0217 | 35765.0 |
| 2024-08-01 19:00:00 | MSFT | Stock | 414.12 | 417.11 | 414.02 | 415.3262 | 22745.0 |
| 2024-08-01 04:00:00 | NVDA | Stock | 120.86 | 121.25 | 115.03 | 116.71 | 2376957.0 |
| 2024-08-01 05:00:00 | NVDA | Stock | 116.6 | 118.88 | 116.5 | 118.14 | 1003187.0 |
| 2024-08-01 06:00:00 | NVDA | Stock | 118.1 | 118.75 | 117.65 | 118.71 | 483376.0 |
| 2024-08-01 07:00:00 | NVDA | Stock | 118.74 | 120.8 | 118.68 | 119.9 | 2288534.0 |
| 2024-08-01 08:00:00 | NVDA | Stock | 119.0 | 121.3 | 115.8036 | 119.12 | 4721757.0 |
| 2024-08-01 09:00:00 | NVDA | Stock | 119.12 | 120.16 | 116.68 | 118.8871 | 52988927.0 |
| 2024-08-01 10:00:00 | NVDA | Stock | 118.88 | 119.27 | 113.53 | 113.97 | 69740310.0 |
| 2024-08-01 11:00:00 | NVDA | Stock | 113.98 | 114.8 | 111.89 | 112.69 | 56407124.0 |
| 2024-08-01 12:00:00 | NVDA | Stock | 112.689 | 113.85 | 110.72 | 111.25 | 45181384.0 |
| 2024-08-01 13:00:00 | NVDA | Stock | 111.24 | 111.54 | 107.41 | 109.73 | 66358075.0 |
| 2024-08-01 14:00:00 | NVDA | Stock | 109.72 | 109.97 | 106.8104 | 107.065 | 56497767.0 |
| 2024-08-01 15:00:00 | NVDA | Stock | 107.0634 | 109.49 | 107.0 | 109.34 | 66038521.0 |
| 2024-08-01 16:00:00 | NVDA | Stock | 109.34 | 111.4671 | 108.1579 | 110.62 | 35245429.0 |
| 2024-08-01 17:00:00 | NVDA | Stock | 110.57 | 111.0 | 108.2 | 109.28 | 3389959.0 |
| 2024-08-01 18:00:00 | NVDA | Stock | 109.22 | 109.6 | 106.67 | 107.0 | 2290203.0 |
| 2024-08-01 19:00:00 | NVDA | Stock | 106.99 | 108.39 | 106.58 | 108.1 | 1819062.0 |
| 2024-08-01 04:00:00 | AMZN | Stock | 190.18 | 190.2 | 188.68 | 188.78 | 28241.0 |
| 2024-08-01 05:00:00 | AMZN | Stock | 188.61 | 189.44 | 188.41 | 189.2 | 17096.0 |
> showing 50 of 59,951 rows — these rows as CSV