PREVIEW / stock_1hour / 2006-12-19
file: by_date/stock_1hour/2006/2006-12-19.parquet size: 646 KB rows: 30,788 symbols: 2,492
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-19 07:00:00 | AAPL | Stock | 3.035 | 3.0446 | 3.035 | 3.0379 | 120400.0 |
| 2006-12-19 08:00:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0179 | 3.0275 | 4900308.0 |
| 2006-12-19 09:00:00 | AAPL | Stock | 3.0279 | 3.03 | 2.9864 | 3.0239 | 151618040.0 |
| 2006-12-19 10:00:00 | AAPL | Stock | 3.0239 | 3.0646 | 3.0232 | 3.0586 | 198046968.0 |
| 2006-12-19 11:00:00 | AAPL | Stock | 3.0579 | 3.0707 | 3.04 | 3.0539 | 106331624.0 |
| 2006-12-19 12:00:00 | AAPL | Stock | 3.0539 | 3.0886 | 3.0511 | 3.0818 | 124043976.0 |
| 2006-12-19 13:00:00 | AAPL | Stock | 3.0818 | 3.0839 | 3.0514 | 3.0686 | 87117156.0 |
| 2006-12-19 14:00:00 | AAPL | Stock | 3.0682 | 3.0771 | 3.06 | 3.0704 | 77389480.0 |
| 2006-12-19 15:00:00 | AAPL | Stock | 3.0707 | 3.0957 | 3.0699 | 3.0818 | 150769360.0 |
| 2006-12-19 16:00:00 | AAPL | Stock | 3.0829 | 3.0918 | 3.0814 | 3.0857 | 1481172.0 |
| 2006-12-19 17:00:00 | AAPL | Stock | 3.0857 | 3.0889 | 3.0846 | 3.0846 | 157276.0 |
| 2006-12-19 18:00:00 | AAPL | Stock | 3.0857 | 3.0875 | 3.085 | 3.0875 | 163716.0 |
| 2006-12-19 19:00:00 | AAPL | Stock | 3.0875 | 3.0886 | 3.0829 | 3.0846 | 174580.0 |
| 2006-12-19 08:00:00 | MSFT | Stock | 29.8 | 29.8 | 29.75 | 29.75 | 18795.0 |
| 2006-12-19 09:00:00 | MSFT | Stock | 29.75 | 29.75 | 29.6 | 29.71 | 4560801.0 |
| 2006-12-19 10:00:00 | MSFT | Stock | 29.71 | 29.88 | 29.68 | 29.84 | 7448983.0 |
| 2006-12-19 11:00:00 | MSFT | Stock | 29.83 | 29.9 | 29.53 | 29.83 | 4369501.0 |
| 2006-12-19 12:00:00 | MSFT | Stock | 29.821 | 29.9 | 29.74 | 29.847 | 4672174.0 |
| 2006-12-19 13:00:00 | MSFT | Stock | 29.845 | 29.94 | 29.76 | 29.93 | 5076939.0 |
| 2006-12-19 14:00:00 | MSFT | Stock | 29.93 | 30.17 | 29.91 | 30.07 | 6934625.0 |
| 2006-12-19 15:00:00 | MSFT | Stock | 30.07 | 30.16 | 29.93 | 29.99 | 11843788.0 |
| 2006-12-19 16:00:00 | MSFT | Stock | 29.99 | 29.99 | 29.88 | 29.92 | 3788401.0 |
| 2006-12-19 17:00:00 | MSFT | Stock | 29.93 | 29.93 | 29.92 | 29.92 | 1597.0 |
| 2006-12-19 18:00:00 | MSFT | Stock | 29.92 | 29.94 | 29.91 | 29.94 | 750.0 |
| 2006-12-19 19:00:00 | MSFT | Stock | 29.93 | 29.93 | 29.93 | 29.93 | 900.0 |
| 2006-12-19 08:00:00 | NVDA | Stock | 0.6333 | 0.6333 | 0.6268 | 0.6293 | 522480.0 |
| 2006-12-19 09:00:00 | NVDA | Stock | 0.6283 | 0.6342 | 0.6268 | 0.6283 | 75455580.0 |
| 2006-12-19 10:00:00 | NVDA | Stock | 0.6283 | 0.6332 | 0.6282 | 0.6318 | 71122740.0 |
| 2006-12-19 11:00:00 | NVDA | Stock | 0.6318 | 0.6327 | 0.6285 | 0.6303 | 61543500.0 |
| 2006-12-19 12:00:00 | NVDA | Stock | 0.6303 | 0.6375 | 0.6298 | 0.637 | 67345980.0 |
| 2006-12-19 13:00:00 | NVDA | Stock | 0.6368 | 0.6405 | 0.6343 | 0.6403 | 40335720.0 |
| 2006-12-19 14:00:00 | NVDA | Stock | 0.6405 | 0.6452 | 0.6383 | 0.6448 | 60191520.0 |
| 2006-12-19 15:00:00 | NVDA | Stock | 0.6448 | 0.6483 | 0.6437 | 0.6447 | 108242700.0 |
| 2006-12-19 16:00:00 | NVDA | Stock | 0.6447 | 0.6462 | 0.6438 | 0.6438 | 147000.0 |
| 2006-12-19 18:00:00 | NVDA | Stock | 0.6442 | 0.6442 | 0.6442 | 0.6442 | 54000.0 |
| 2006-12-19 08:00:00 | AMZN | Stock | 1.941 | 1.941 | 1.9395 | 1.9395 | 17200.0 |
| 2006-12-19 09:00:00 | AMZN | Stock | 1.9395 | 1.9475 | 1.927 | 1.9275 | 21821840.0 |
| 2006-12-19 10:00:00 | AMZN | Stock | 1.9275 | 1.9365 | 1.926 | 1.9285 | 20573660.0 |
| 2006-12-19 11:00:00 | AMZN | Stock | 1.929 | 1.9325 | 1.9115 | 1.919 | 18034600.0 |
| 2006-12-19 12:00:00 | AMZN | Stock | 1.919 | 1.9465 | 1.918 | 1.9465 | 17559340.0 |
| 2006-12-19 13:00:00 | AMZN | Stock | 1.9465 | 1.95 | 1.935 | 1.9495 | 11488800.0 |
| 2006-12-19 14:00:00 | AMZN | Stock | 1.9495 | 1.9765 | 1.948 | 1.9715 | 22592200.0 |
| 2006-12-19 15:00:00 | AMZN | Stock | 1.972 | 1.986 | 1.9685 | 1.9725 | 32449940.0 |
| 2006-12-19 16:00:00 | AMZN | Stock | 1.9705 | 1.9745 | 1.9685 | 1.971 | 380560.0 |
| 2006-12-19 17:00:00 | AMZN | Stock | 1.971 | 1.971 | 1.971 | 1.971 | 24000.0 |
| 2006-12-19 09:00:00 | CL | Stock | 32.55 | 32.64 | 32.525 | 32.58 | 269000.0 |
| 2006-12-19 10:00:00 | CL | Stock | 32.575 | 32.58 | 32.455 | 32.525 | 337000.0 |
| 2006-12-19 11:00:00 | CL | Stock | 32.524 | 32.55 | 32.415 | 32.465 | 248000.0 |
| 2006-12-19 12:00:00 | CL | Stock | 32.465 | 32.57 | 32.465 | 32.53 | 699000.0 |
| 2006-12-19 13:00:00 | CL | Stock | 32.53 | 32.545 | 32.485 | 32.52 | 369200.0 |
> showing 50 of 30,788 rows — these rows as CSV