PREVIEW / stock_1hour / 2000-02-08
file: by_date/stock_1hour/2000/2000-02-08.parquet size: 284 KB rows: 14,852 symbols: 1,138
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-02-08 09:00:00 | AAPL | Stock | 1.0179 | 1.034 | 1.0173 | 1.0273 | 87337600.0 |
| 2000-02-08 10:00:00 | AAPL | Stock | 1.0273 | 1.0368 | 1.0223 | 1.0318 | 91459200.0 |
| 2000-02-08 11:00:00 | AAPL | Stock | 1.0313 | 1.0313 | 1.0218 | 1.0223 | 32928000.0 |
| 2000-02-08 12:00:00 | AAPL | Stock | 1.0223 | 1.0268 | 1.0061 | 1.0067 | 27126400.0 |
| 2000-02-08 13:00:00 | AAPL | Stock | 1.0061 | 1.0123 | 0.9933 | 1.0022 | 70022400.0 |
| 2000-02-08 14:00:00 | AAPL | Stock | 1.0017 | 1.024 | 1.0011 | 1.0223 | 28548800.0 |
| 2000-02-08 15:00:00 | AAPL | Stock | 1.0218 | 1.0262 | 1.0 | 1.0257 | 50724800.0 |
| 2000-02-08 16:00:00 | AAPL | Stock | 1.0257 | 1.0262 | 1.0246 | 1.0257 | 2072000.0 |
| 2000-02-08 09:00:00 | MSFT | Stock | 53.2188 | 54.3125 | 53.2188 | 54.0312 | 8171600.0 |
| 2000-02-08 10:00:00 | MSFT | Stock | 54.0312 | 54.625 | 53.9688 | 54.4688 | 9361200.0 |
| 2000-02-08 11:00:00 | MSFT | Stock | 54.4688 | 54.7188 | 54.3438 | 54.5 | 7826800.0 |
| 2000-02-08 12:00:00 | MSFT | Stock | 54.5312 | 54.75 | 54.5 | 54.75 | 5352600.0 |
| 2000-02-08 13:00:00 | MSFT | Stock | 54.75 | 54.875 | 54.5 | 54.7031 | 5058600.0 |
| 2000-02-08 14:00:00 | MSFT | Stock | 54.6875 | 54.9688 | 54.6875 | 54.875 | 5143000.0 |
| 2000-02-08 15:00:00 | MSFT | Stock | 54.875 | 55.0 | 54.5625 | 54.9375 | 10404800.0 |
| 2000-02-08 16:00:00 | MSFT | Stock | 54.9688 | 54.9688 | 54.9375 | 54.9688 | 431000.0 |
| 2000-02-08 09:00:00 | NVDA | Stock | 0.0812 | 0.0828 | 0.0806 | 0.0815 | 38160000.0 |
| 2000-02-08 10:00:00 | NVDA | Stock | 0.0815 | 0.0819 | 0.0801 | 0.0805 | 78720000.0 |
| 2000-02-08 11:00:00 | NVDA | Stock | 0.0801 | 0.081 | 0.0792 | 0.0805 | 76464000.0 |
| 2000-02-08 12:00:00 | NVDA | Stock | 0.0803 | 0.0818 | 0.0802 | 0.0815 | 23184000.0 |
| 2000-02-08 13:00:00 | NVDA | Stock | 0.0814 | 0.0824 | 0.0812 | 0.082 | 72528000.0 |
| 2000-02-08 14:00:00 | NVDA | Stock | 0.0823 | 0.0859 | 0.0812 | 0.0853 | 98256000.0 |
| 2000-02-08 15:00:00 | NVDA | Stock | 0.0854 | 0.0857 | 0.0832 | 0.0833 | 47760000.0 |
| 2000-02-08 16:00:00 | NVDA | Stock | 0.0833 | 0.0833 | 0.0831 | 0.0831 | 144000.0 |
| 2000-02-08 09:00:00 | AMZN | Stock | 3.7 | 3.8469 | 3.6719 | 3.8375 | 28646000.0 |
| 2000-02-08 10:00:00 | AMZN | Stock | 3.8375 | 4.05 | 3.8125 | 4.0156 | 103212000.0 |
| 2000-02-08 11:00:00 | AMZN | Stock | 4.0188 | 4.0469 | 3.9969 | 4.0312 | 39008000.0 |
| 2000-02-08 12:00:00 | AMZN | Stock | 4.0312 | 4.125 | 4.0281 | 4.1031 | 46346000.0 |
| 2000-02-08 13:00:00 | AMZN | Stock | 4.1031 | 4.1625 | 4.0906 | 4.15 | 28474000.0 |
| 2000-02-08 14:00:00 | AMZN | Stock | 4.1594 | 4.1969 | 4.075 | 4.1562 | 51952000.0 |
| 2000-02-08 15:00:00 | AMZN | Stock | 4.1578 | 4.2 | 4.1062 | 4.1625 | 63888000.0 |
| 2000-02-08 16:00:00 | AMZN | Stock | 4.1625 | 4.1812 | 4.1531 | 4.1562 | 440000.0 |
| 2000-02-08 09:00:00 | CL | Stock | 28.1875 | 28.9062 | 28.1875 | 28.6875 | 765400.0 |
| 2000-02-08 10:00:00 | CL | Stock | 28.7188 | 29.25 | 28.7188 | 29.25 | 1481200.0 |
| 2000-02-08 11:00:00 | CL | Stock | 29.25 | 29.3125 | 28.9062 | 29.0938 | 765200.0 |
| 2000-02-08 12:00:00 | CL | Stock | 29.0938 | 29.3125 | 29.0312 | 29.25 | 442200.0 |
| 2000-02-08 13:00:00 | CL | Stock | 29.25 | 29.3438 | 29.125 | 29.2812 | 414400.0 |
| 2000-02-08 14:00:00 | CL | Stock | 29.3125 | 29.5312 | 29.25 | 29.4688 | 588400.0 |
| 2000-02-08 15:00:00 | CL | Stock | 29.5312 | 29.6875 | 29.3438 | 29.4062 | 885600.0 |
| 2000-02-08 16:00:00 | CL | Stock | 29.375 | 29.375 | 29.3438 | 29.3438 | 86800.0 |
> showing 40 of 14,852 rows — these rows as CSV