PREVIEW / stock_1hour / 2000-08-30
file: by_date/stock_1hour/2000/2000-08-30.parquet size: 294 KB rows: 15,022 symbols: 1,216
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 |
|---|---|---|---|---|---|---|---|
| 2000-08-30 08:00:00 | AAPL | Stock | 1.0558 | 1.0619 | 1.0536 | 1.0536 | 89600.0 |
| 2000-08-30 09:00:00 | AAPL | Stock | 1.0513 | 1.0714 | 1.0491 | 1.0603 | 48473600.0 |
| 2000-08-30 10:00:00 | AAPL | Stock | 1.0614 | 1.0625 | 1.0558 | 1.0592 | 34260800.0 |
| 2000-08-30 11:00:00 | AAPL | Stock | 1.058 | 1.0603 | 1.0513 | 1.0547 | 30469600.0 |
| 2000-08-30 12:00:00 | AAPL | Stock | 1.0536 | 1.0547 | 1.048 | 1.0513 | 28638400.0 |
| 2000-08-30 13:00:00 | AAPL | Stock | 1.0502 | 1.0603 | 1.0502 | 1.0569 | 33695200.0 |
| 2000-08-30 14:00:00 | AAPL | Stock | 1.058 | 1.0603 | 1.0558 | 1.058 | 40600000.0 |
| 2000-08-30 15:00:00 | AAPL | Stock | 1.058 | 1.0625 | 1.0564 | 1.0625 | 42313600.0 |
| 2000-08-30 16:00:00 | AAPL | Stock | 1.0625 | 1.0692 | 1.058 | 1.0625 | 20473600.0 |
| 2000-08-30 08:00:00 | MSFT | Stock | 35.4688 | 35.5 | 35.0 | 35.4375 | 29000.0 |
| 2000-08-30 09:00:00 | MSFT | Stock | 35.4375 | 35.5625 | 35.1875 | 35.2188 | 7907400.0 |
| 2000-08-30 10:00:00 | MSFT | Stock | 35.2188 | 35.2188 | 35.0 | 35.1562 | 12166600.0 |
| 2000-08-30 11:00:00 | MSFT | Stock | 35.1562 | 35.1562 | 35.0 | 35.0312 | 7783000.0 |
| 2000-08-30 12:00:00 | MSFT | Stock | 35.0312 | 35.0312 | 34.9062 | 34.9688 | 5584600.0 |
| 2000-08-30 13:00:00 | MSFT | Stock | 34.9688 | 35.0 | 34.8438 | 34.9688 | 3404800.0 |
| 2000-08-30 14:00:00 | MSFT | Stock | 34.9688 | 35.0 | 34.8438 | 35.0 | 4876800.0 |
| 2000-08-30 15:00:00 | MSFT | Stock | 34.9688 | 35.0625 | 34.9375 | 34.9688 | 10058000.0 |
| 2000-08-30 16:00:00 | MSFT | Stock | 34.9844 | 35.0625 | 34.7812 | 34.9688 | 1240600.0 |
| 2000-08-30 17:00:00 | MSFT | Stock | 34.9375 | 34.9375 | 34.875 | 34.9375 | 1200.0 |
| 2000-08-30 18:00:00 | MSFT | Stock | 34.9062 | 35.0 | 34.9062 | 34.9375 | 1400.0 |
| 2000-08-30 09:00:00 | NVDA | Stock | 0.3206 | 0.3292 | 0.3193 | 0.3271 | 43176000.0 |
| 2000-08-30 10:00:00 | NVDA | Stock | 0.3271 | 0.3271 | 0.3172 | 0.3208 | 39480000.0 |
| 2000-08-30 11:00:00 | NVDA | Stock | 0.3214 | 0.326 | 0.3208 | 0.325 | 15384000.0 |
| 2000-08-30 12:00:00 | NVDA | Stock | 0.325 | 0.326 | 0.3245 | 0.3258 | 10320000.0 |
| 2000-08-30 13:00:00 | NVDA | Stock | 0.325 | 0.3289 | 0.325 | 0.3268 | 9552000.0 |
| 2000-08-30 14:00:00 | NVDA | Stock | 0.3268 | 0.3271 | 0.3227 | 0.324 | 8088000.0 |
| 2000-08-30 15:00:00 | NVDA | Stock | 0.3253 | 0.3307 | 0.3232 | 0.3273 | 49104000.0 |
| 2000-08-30 16:00:00 | NVDA | Stock | 0.3271 | 0.3292 | 0.3253 | 0.3292 | 2328000.0 |
| 2000-08-30 08:00:00 | AMZN | Stock | 2.0375 | 2.1688 | 2.0375 | 2.1188 | 6060000.0 |
| 2000-08-30 09:00:00 | AMZN | Stock | 2.1125 | 2.1844 | 2.0969 | 2.1719 | 88806000.0 |
| 2000-08-30 10:00:00 | AMZN | Stock | 2.1719 | 2.1984 | 2.125 | 2.1281 | 55794000.0 |
| 2000-08-30 11:00:00 | AMZN | Stock | 2.1312 | 2.1375 | 2.1 | 2.1312 | 24866000.0 |
| 2000-08-30 12:00:00 | AMZN | Stock | 2.1312 | 2.1469 | 2.1125 | 2.1469 | 9826000.0 |
| 2000-08-30 13:00:00 | AMZN | Stock | 2.1438 | 2.1562 | 2.1312 | 2.1531 | 18688000.0 |
| 2000-08-30 14:00:00 | AMZN | Stock | 2.15 | 2.1656 | 2.1375 | 2.1469 | 15682000.0 |
| 2000-08-30 15:00:00 | AMZN | Stock | 2.1438 | 2.1562 | 2.1219 | 2.1438 | 25942000.0 |
| 2000-08-30 16:00:00 | AMZN | Stock | 2.1438 | 2.175 | 2.1219 | 2.15 | 9480000.0 |
| 2000-08-30 17:00:00 | AMZN | Stock | 2.1469 | 2.15 | 2.1438 | 2.1469 | 66000.0 |
| 2000-08-30 09:00:00 | CL | Stock | 25.8125 | 25.9062 | 25.7812 | 25.8438 | 109600.0 |
| 2000-08-30 10:00:00 | CL | Stock | 25.8125 | 26.0 | 25.7188 | 25.7188 | 375600.0 |
| 2000-08-30 11:00:00 | CL | Stock | 25.7188 | 25.8438 | 25.5 | 25.8125 | 544600.0 |
| 2000-08-30 12:00:00 | CL | Stock | 25.7812 | 25.7812 | 25.5 | 25.5625 | 369000.0 |
| 2000-08-30 13:00:00 | CL | Stock | 25.5312 | 25.8438 | 25.5 | 25.8438 | 215200.0 |
| 2000-08-30 14:00:00 | CL | Stock | 25.7812 | 25.8125 | 25.6875 | 25.8125 | 258600.0 |
| 2000-08-30 15:00:00 | CL | Stock | 25.75 | 25.8438 | 25.6875 | 25.7188 | 564400.0 |
| 2000-08-30 16:00:00 | CL | Stock | 25.7188 | 25.7188 | 25.6875 | 25.7188 | 143400.0 |
> showing 46 of 15,022 rows — these rows as CSV