PREVIEW / stock_1hour / 2001-05-21
file: by_date/stock_1hour/2001/2001-05-21.parquet size: 370 KB rows: 17,426 symbols: 1,302
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 |
|---|---|---|---|---|---|---|---|
| 2001-05-21 09:00:00 | AAPL | Stock | 0.4202 | 0.4241 | 0.4132 | 0.4136 | 31561600.0 |
| 2001-05-21 10:00:00 | AAPL | Stock | 0.4136 | 0.4229 | 0.4116 | 0.4196 | 63851200.0 |
| 2001-05-21 11:00:00 | AAPL | Stock | 0.4198 | 0.4252 | 0.4152 | 0.4252 | 66600800.0 |
| 2001-05-21 12:00:00 | AAPL | Stock | 0.4252 | 0.427 | 0.4204 | 0.4216 | 37990400.0 |
| 2001-05-21 13:00:00 | AAPL | Stock | 0.4218 | 0.4241 | 0.4168 | 0.418 | 24819200.0 |
| 2001-05-21 14:00:00 | AAPL | Stock | 0.418 | 0.4196 | 0.4155 | 0.4179 | 76826400.0 |
| 2001-05-21 15:00:00 | AAPL | Stock | 0.4179 | 0.4225 | 0.4155 | 0.4205 | 105056000.0 |
| 2001-05-21 16:00:00 | AAPL | Stock | 0.4205 | 0.4232 | 0.4161 | 0.4207 | 29366400.0 |
| 2001-05-21 17:00:00 | AAPL | Stock | 0.417 | 0.4204 | 0.417 | 0.4202 | 1125600.0 |
| 2001-05-21 18:00:00 | AAPL | Stock | 0.4196 | 0.4196 | 0.4196 | 0.4196 | 5600.0 |
| 2001-05-21 08:00:00 | MSFT | Stock | 34.055 | 34.055 | 33.8 | 34.025 | 41600.0 |
| 2001-05-21 09:00:00 | MSFT | Stock | 34.05 | 34.225 | 33.875 | 34.2 | 8531000.0 |
| 2001-05-21 10:00:00 | MSFT | Stock | 34.215 | 34.695 | 34.2 | 34.605 | 16695400.0 |
| 2001-05-21 11:00:00 | MSFT | Stock | 34.6 | 34.925 | 34.595 | 34.77 | 11645400.0 |
| 2001-05-21 12:00:00 | MSFT | Stock | 34.775 | 34.945 | 34.755 | 34.875 | 7070800.0 |
| 2001-05-21 13:00:00 | MSFT | Stock | 34.875 | 34.925 | 34.4 | 34.43 | 9131200.0 |
| 2001-05-21 14:00:00 | MSFT | Stock | 34.43 | 34.67 | 34.31 | 34.655 | 10601000.0 |
| 2001-05-21 15:00:00 | MSFT | Stock | 34.66 | 34.71 | 34.36 | 34.4 | 24278800.0 |
| 2001-05-21 16:00:00 | MSFT | Stock | 34.395 | 34.62 | 34.33 | 34.375 | 11449000.0 |
| 2001-05-21 17:00:00 | MSFT | Stock | 34.395 | 34.475 | 34.025 | 34.025 | 628400.0 |
| 2001-05-21 18:00:00 | MSFT | Stock | 34.4 | 34.425 | 34.4 | 34.425 | 1800.0 |
| 2001-05-21 08:00:00 | NVDA | Stock | 0.3608 | 0.3608 | 0.3592 | 0.3592 | 168000.0 |
| 2001-05-21 09:00:00 | NVDA | Stock | 0.3596 | 0.3596 | 0.3525 | 0.3553 | 79056000.0 |
| 2001-05-21 10:00:00 | NVDA | Stock | 0.3553 | 0.3694 | 0.3551 | 0.3694 | 200616000.0 |
| 2001-05-21 11:00:00 | NVDA | Stock | 0.3693 | 0.3775 | 0.3692 | 0.3727 | 232080000.0 |
| 2001-05-21 12:00:00 | NVDA | Stock | 0.3727 | 0.3833 | 0.3723 | 0.3762 | 140616000.0 |
| 2001-05-21 13:00:00 | NVDA | Stock | 0.3763 | 0.3804 | 0.3709 | 0.3714 | 95952000.0 |
| 2001-05-21 14:00:00 | NVDA | Stock | 0.3714 | 0.375 | 0.3663 | 0.374 | 118848000.0 |
| 2001-05-21 15:00:00 | NVDA | Stock | 0.3742 | 0.3771 | 0.3645 | 0.3758 | 143040000.0 |
| 2001-05-21 16:00:00 | NVDA | Stock | 0.3758 | 0.3767 | 0.3585 | 0.3758 | 12840000.0 |
| 2001-05-21 17:00:00 | NVDA | Stock | 0.3758 | 0.3758 | 0.3746 | 0.3758 | 1176000.0 |
| 2001-05-21 18:00:00 | NVDA | Stock | 0.377 | 0.377 | 0.3758 | 0.3758 | 48000.0 |
| 2001-05-21 08:00:00 | AMZN | Stock | 0.75 | 0.75 | 0.745 | 0.745 | 26000.0 |
| 2001-05-21 09:00:00 | AMZN | Stock | 0.75 | 0.75 | 0.7375 | 0.7435 | 10180000.0 |
| 2001-05-21 10:00:00 | AMZN | Stock | 0.745 | 0.75 | 0.7415 | 0.7495 | 21598000.0 |
| 2001-05-21 11:00:00 | AMZN | Stock | 0.7495 | 0.781 | 0.7485 | 0.773 | 27812000.0 |
| 2001-05-21 12:00:00 | AMZN | Stock | 0.7725 | 0.7815 | 0.77 | 0.7725 | 16640000.0 |
| 2001-05-21 13:00:00 | AMZN | Stock | 0.7735 | 0.7775 | 0.7685 | 0.7705 | 12508000.0 |
| 2001-05-21 14:00:00 | AMZN | Stock | 0.769 | 0.7815 | 0.7625 | 0.7815 | 13764000.0 |
| 2001-05-21 15:00:00 | AMZN | Stock | 0.7815 | 0.821 | 0.7775 | 0.8195 | 29198000.0 |
| 2001-05-21 16:00:00 | AMZN | Stock | 0.8185 | 0.8215 | 0.81 | 0.819 | 3556000.0 |
| 2001-05-21 17:00:00 | AMZN | Stock | 0.81 | 0.819 | 0.801 | 0.819 | 64000.0 |
| 2001-05-21 18:00:00 | AMZN | Stock | 0.81 | 0.81 | 0.808 | 0.808 | 6000.0 |
| 2001-05-21 09:00:00 | CL | Stock | 28.575 | 28.58 | 28.35 | 28.525 | 324600.0 |
| 2001-05-21 10:00:00 | CL | Stock | 28.52 | 28.6 | 28.43 | 28.5 | 385800.0 |
| 2001-05-21 11:00:00 | CL | Stock | 28.5 | 28.575 | 28.475 | 28.575 | 238000.0 |
| 2001-05-21 12:00:00 | CL | Stock | 28.575 | 28.6 | 28.39 | 28.45 | 266400.0 |
| 2001-05-21 13:00:00 | CL | Stock | 28.47 | 28.5 | 28.375 | 28.4 | 403200.0 |
| 2001-05-21 14:00:00 | CL | Stock | 28.385 | 28.56 | 28.375 | 28.555 | 173200.0 |
| 2001-05-21 15:00:00 | CL | Stock | 28.555 | 28.9 | 28.555 | 28.85 | 439400.0 |
> showing 50 of 17,426 rows — these rows as CSV