PREVIEW / stock_1hour / 2022-05-11
file: by_date/stock_1hour/2022/2022-05-11.parquet size: 1.4 MB rows: 65,277 symbols: 2,511
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 |
|---|---|---|---|---|---|---|---|
| 2022-05-11 04:00:00 | AAPL | Stock | 155.28 | 156.36 | 155.15 | 156.22 | 74775.0 |
| 2022-05-11 05:00:00 | AAPL | Stock | 156.22 | 156.89 | 156.12 | 156.48 | 30190.0 |
| 2022-05-11 06:00:00 | AAPL | Stock | 156.44 | 156.74 | 156.11 | 156.52 | 32362.0 |
| 2022-05-11 07:00:00 | AAPL | Stock | 156.41 | 156.6 | 156.15 | 156.39 | 139526.0 |
| 2022-05-11 08:00:00 | AAPL | Stock | 156.2009 | 156.6 | 152.0 | 152.43 | 1387491.0 |
| 2022-05-11 09:00:00 | AAPL | Stock | 152.4299 | 155.45 | 151.35 | 153.86 | 12205946.0 |
| 2022-05-11 10:00:00 | AAPL | Stock | 153.87 | 154.21 | 152.36 | 152.77 | 13505990.0 |
| 2022-05-11 11:00:00 | AAPL | Stock | 152.78 | 153.84 | 151.9 | 152.5145 | 9424478.0 |
| 2022-05-11 12:00:00 | AAPL | Stock | 152.51 | 152.53 | 149.56 | 149.92 | 12915822.0 |
| 2022-05-11 13:00:00 | AAPL | Stock | 149.9118 | 149.98 | 146.82 | 147.03 | 17526899.0 |
| 2022-05-11 14:00:00 | AAPL | Stock | 147.02 | 148.27 | 146.51 | 146.91 | 16531325.0 |
| 2022-05-11 15:00:00 | AAPL | Stock | 146.89 | 147.01 | 145.81 | 146.59 | 23783636.0 |
| 2022-05-11 16:00:00 | AAPL | Stock | 146.6 | 147.2 | 146.3203 | 146.8 | 10502430.0 |
| 2022-05-11 17:00:00 | AAPL | Stock | 146.77 | 146.8 | 146.0 | 146.5 | 408304.0 |
| 2022-05-11 18:00:00 | AAPL | Stock | 146.52 | 146.57 | 146.0 | 146.49 | 140615.0 |
| 2022-05-11 19:00:00 | AAPL | Stock | 146.5 | 146.68 | 146.15 | 146.67 | 170399.0 |
| 2022-05-11 04:00:00 | MSFT | Stock | 270.5 | 272.96 | 270.5 | 272.74 | 2551.0 |
| 2022-05-11 05:00:00 | MSFT | Stock | 272.96 | 273.5 | 272.64 | 272.85 | 3244.0 |
| 2022-05-11 06:00:00 | MSFT | Stock | 272.66 | 273.73 | 272.44 | 273.73 | 6844.0 |
| 2022-05-11 07:00:00 | MSFT | Stock | 273.32 | 273.8 | 272.55 | 273.2 | 31364.0 |
| 2022-05-11 08:00:00 | MSFT | Stock | 272.8018 | 273.8799 | 263.75 | 264.5 | 167888.0 |
| 2022-05-11 09:00:00 | MSFT | Stock | 264.7923 | 271.36 | 263.75 | 269.34 | 3578693.0 |
| 2022-05-11 10:00:00 | MSFT | Stock | 269.39 | 269.61 | 264.9 | 265.76 | 3865607.0 |
| 2022-05-11 11:00:00 | MSFT | Stock | 265.8 | 267.52 | 263.7903 | 265.45 | 2579002.0 |
| 2022-05-11 12:00:00 | MSFT | Stock | 265.42 | 266.3 | 263.28 | 263.28 | 2453281.0 |
| 2022-05-11 13:00:00 | MSFT | Stock | 263.27 | 264.05 | 261.275 | 261.364 | 2799064.0 |
| 2022-05-11 14:00:00 | MSFT | Stock | 261.42 | 264.4279 | 261.12 | 261.57 | 3420858.0 |
| 2022-05-11 15:00:00 | MSFT | Stock | 261.46 | 262.37 | 259.3 | 260.66 | 6560624.0 |
| 2022-05-11 16:00:00 | MSFT | Stock | 260.66 | 261.99 | 260.54 | 261.2899 | 5172709.0 |
| 2022-05-11 17:00:00 | MSFT | Stock | 261.29 | 261.29 | 260.24 | 260.9441 | 31567.0 |
| 2022-05-11 18:00:00 | MSFT | Stock | 260.8 | 261.07 | 260.05 | 261.0 | 24361.0 |
| 2022-05-11 19:00:00 | MSFT | Stock | 260.98 | 261.5 | 260.0 | 261.5 | 33506.0 |
| 2022-05-11 04:00:00 | NVDA | Stock | 17.807 | 18.0 | 17.729 | 17.95 | 442630.0 |
| 2022-05-11 05:00:00 | NVDA | Stock | 17.96 | 17.978 | 17.889 | 17.963 | 153880.0 |
| 2022-05-11 06:00:00 | NVDA | Stock | 17.903 | 18.05 | 17.885 | 18.027 | 96320.0 |
| 2022-05-11 07:00:00 | NVDA | Stock | 17.998 | 18.001 | 17.9 | 17.92 | 901060.0 |
| 2022-05-11 08:00:00 | NVDA | Stock | 17.937 | 18.0 | 17.041 | 17.081 | 5447500.0 |
| 2022-05-11 09:00:00 | NVDA | Stock | 17.099 | 17.751 | 16.946 | 17.4 | 78576450.0 |
| 2022-05-11 10:00:00 | NVDA | Stock | 17.407 | 17.753 | 17.167 | 17.477 | 89266040.0 |
| 2022-05-11 11:00:00 | NVDA | Stock | 17.479 | 17.5248 | 17.009 | 17.313 | 72426070.0 |
| 2022-05-11 12:00:00 | NVDA | Stock | 17.305 | 17.444 | 16.991 | 17.061 | 49148280.0 |
| 2022-05-11 13:00:00 | NVDA | Stock | 17.0624 | 17.135 | 16.818 | 16.836 | 53931870.0 |
| 2022-05-11 14:00:00 | NVDA | Stock | 16.839 | 17.104 | 16.774 | 16.811 | 63133050.0 |
| 2022-05-11 15:00:00 | NVDA | Stock | 16.806 | 16.835 | 16.568 | 16.64 | 80615810.0 |
| 2022-05-11 16:00:00 | NVDA | Stock | 16.63 | 16.749 | 16.62 | 16.679 | 28300530.0 |
| 2022-05-11 17:00:00 | NVDA | Stock | 16.67 | 16.689 | 16.595 | 16.668 | 479350.0 |
| 2022-05-11 18:00:00 | NVDA | Stock | 16.655 | 16.669 | 16.601 | 16.667 | 310150.0 |
| 2022-05-11 19:00:00 | NVDA | Stock | 16.669 | 16.7 | 16.642 | 16.681 | 323640.0 |
| 2022-05-11 04:00:00 | AMZN | Stock | 110.005 | 110.505 | 110.005 | 110.505 | 4320.0 |
| 2022-05-11 05:00:00 | AMZN | Stock | 110.75 | 110.9 | 110.75 | 110.9 | 8000.0 |
> showing 50 of 65,277 rows — these rows as CSV