PREVIEW / stock_1hour / 2002-01-03
file: by_date/stock_1hour/2002/2002-01-03.parquet size: 400 KB rows: 18,778 symbols: 1,357
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-03 08:00:00 | AAPL | Stock | 0.4195 | 0.4195 | 0.4089 | 0.4107 | 1282400.0 |
| 2002-01-03 09:00:00 | AAPL | Stock | 0.4107 | 0.4145 | 0.4066 | 0.4116 | 145818400.0 |
| 2002-01-03 10:00:00 | AAPL | Stock | 0.4116 | 0.4141 | 0.4098 | 0.412 | 77834400.0 |
| 2002-01-03 11:00:00 | AAPL | Stock | 0.4121 | 0.4139 | 0.4096 | 0.4116 | 79956800.0 |
| 2002-01-03 12:00:00 | AAPL | Stock | 0.4116 | 0.4134 | 0.4107 | 0.4127 | 60412800.0 |
| 2002-01-03 13:00:00 | AAPL | Stock | 0.4127 | 0.4134 | 0.4116 | 0.4121 | 33454400.0 |
| 2002-01-03 14:00:00 | AAPL | Stock | 0.4121 | 0.4138 | 0.4107 | 0.413 | 59651200.0 |
| 2002-01-03 15:00:00 | AAPL | Stock | 0.413 | 0.4241 | 0.413 | 0.4205 | 135004800.0 |
| 2002-01-03 16:00:00 | AAPL | Stock | 0.4211 | 0.4277 | 0.4154 | 0.4179 | 5432000.0 |
| 2002-01-03 17:00:00 | AAPL | Stock | 0.4211 | 0.4241 | 0.4207 | 0.4241 | 1187200.0 |
| 2002-01-03 18:00:00 | AAPL | Stock | 0.4239 | 0.4241 | 0.4196 | 0.4196 | 744800.0 |
| 2002-01-03 08:00:00 | MSFT | Stock | 33.6 | 33.685 | 33.5225 | 33.57 | 210800.0 |
| 2002-01-03 09:00:00 | MSFT | Stock | 33.575 | 34.025 | 33.505 | 34.005 | 9408000.0 |
| 2002-01-03 10:00:00 | MSFT | Stock | 34.0 | 34.335 | 33.93 | 34.325 | 11569600.0 |
| 2002-01-03 11:00:00 | MSFT | Stock | 34.315 | 34.47 | 34.275 | 34.36 | 7308400.0 |
| 2002-01-03 12:00:00 | MSFT | Stock | 34.36 | 34.43 | 34.14 | 34.385 | 5434800.0 |
| 2002-01-03 13:00:00 | MSFT | Stock | 34.385 | 34.475 | 34.255 | 34.345 | 5846000.0 |
| 2002-01-03 14:00:00 | MSFT | Stock | 34.34 | 34.43 | 34.175 | 34.33 | 6847000.0 |
| 2002-01-03 15:00:00 | MSFT | Stock | 34.33 | 34.625 | 34.28 | 34.62 | 17121200.0 |
| 2002-01-03 16:00:00 | MSFT | Stock | 34.62 | 34.64 | 34.3004 | 34.625 | 2221600.0 |
| 2002-01-03 17:00:00 | MSFT | Stock | 34.615 | 34.62 | 34.58 | 34.58 | 193000.0 |
| 2002-01-03 18:00:00 | MSFT | Stock | 34.6 | 34.615 | 34.58 | 34.6 | 97800.0 |
| 2002-01-03 08:00:00 | NVDA | Stock | 0.5647 | 0.5746 | 0.5542 | 0.5583 | 1956000.0 |
| 2002-01-03 09:00:00 | NVDA | Stock | 0.5617 | 0.5812 | 0.5583 | 0.5797 | 178824000.0 |
| 2002-01-03 10:00:00 | NVDA | Stock | 0.5796 | 0.5828 | 0.5759 | 0.5825 | 238980000.0 |
| 2002-01-03 11:00:00 | NVDA | Stock | 0.5823 | 0.5883 | 0.5809 | 0.583 | 226200000.0 |
| 2002-01-03 12:00:00 | NVDA | Stock | 0.5831 | 0.5912 | 0.5816 | 0.5903 | 123060000.0 |
| 2002-01-03 13:00:00 | NVDA | Stock | 0.5905 | 0.5933 | 0.5883 | 0.5899 | 148488000.0 |
| 2002-01-03 14:00:00 | NVDA | Stock | 0.5896 | 0.5946 | 0.5879 | 0.5944 | 179520000.0 |
| 2002-01-03 15:00:00 | NVDA | Stock | 0.5944 | 0.6 | 0.5926 | 0.5967 | 224124000.0 |
| 2002-01-03 16:00:00 | NVDA | Stock | 0.5969 | 0.5982 | 0.575 | 0.5959 | 23880000.0 |
| 2002-01-03 17:00:00 | NVDA | Stock | 0.5976 | 0.5976 | 0.5957 | 0.5967 | 1044000.0 |
| 2002-01-03 18:00:00 | NVDA | Stock | 0.5967 | 0.5976 | 0.5964 | 0.5964 | 504000.0 |
| 2002-01-03 08:00:00 | AMZN | Stock | 0.549 | 0.5505 | 0.548 | 0.5485 | 388000.0 |
| 2002-01-03 09:00:00 | AMZN | Stock | 0.5486 | 0.568 | 0.5474 | 0.568 | 30950000.0 |
| 2002-01-03 10:00:00 | AMZN | Stock | 0.567 | 0.58 | 0.567 | 0.5795 | 48074000.0 |
| 2002-01-03 11:00:00 | AMZN | Stock | 0.5795 | 0.597 | 0.579 | 0.5835 | 32590000.0 |
| 2002-01-03 12:00:00 | AMZN | Stock | 0.5835 | 0.585 | 0.5755 | 0.5825 | 15460000.0 |
| 2002-01-03 13:00:00 | AMZN | Stock | 0.5826 | 0.5875 | 0.57 | 0.5845 | 15644000.0 |
| 2002-01-03 14:00:00 | AMZN | Stock | 0.584 | 0.584 | 0.57 | 0.577 | 18950000.0 |
| 2002-01-03 15:00:00 | AMZN | Stock | 0.577 | 0.595 | 0.576 | 0.595 | 41832000.0 |
| 2002-01-03 16:00:00 | AMZN | Stock | 0.5925 | 0.5975 | 0.56 | 0.59 | 5342000.0 |
| 2002-01-03 17:00:00 | AMZN | Stock | 0.589 | 0.595 | 0.5885 | 0.5895 | 490000.0 |
| 2002-01-03 18:00:00 | AMZN | Stock | 0.5895 | 0.595 | 0.588 | 0.588 | 358000.0 |
| 2002-01-03 09:00:00 | CL | Stock | 28.685 | 28.69 | 28.45 | 28.465 | 321000.0 |
| 2002-01-03 10:00:00 | CL | Stock | 28.495 | 28.6 | 28.435 | 28.475 | 568800.0 |
| 2002-01-03 11:00:00 | CL | Stock | 28.47 | 28.545 | 28.455 | 28.545 | 204600.0 |
| 2002-01-03 12:00:00 | CL | Stock | 28.545 | 28.675 | 28.545 | 28.6 | 113000.0 |
| 2002-01-03 13:00:00 | CL | Stock | 28.6 | 28.61 | 28.5 | 28.53 | 166200.0 |
| 2002-01-03 14:00:00 | CL | Stock | 28.525 | 28.575 | 28.485 | 28.51 | 131600.0 |
> showing 50 of 18,778 rows — these rows as CSV