PREVIEW / stock_1hour / 2001-12-14
file: by_date/stock_1hour/2001/2001-12-14.parquet size: 374 KB rows: 17,969 symbols: 1,365
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-12-14 08:00:00 | AAPL | Stock | 0.373 | 0.373 | 0.373 | 0.373 | 28000.0 |
| 2001-12-14 09:00:00 | AAPL | Stock | 0.3714 | 0.3734 | 0.3679 | 0.3689 | 19241600.0 |
| 2001-12-14 10:00:00 | AAPL | Stock | 0.3682 | 0.3686 | 0.3613 | 0.3671 | 34910400.0 |
| 2001-12-14 11:00:00 | AAPL | Stock | 0.3671 | 0.3679 | 0.3634 | 0.3668 | 15120000.0 |
| 2001-12-14 12:00:00 | AAPL | Stock | 0.3668 | 0.367 | 0.3595 | 0.3611 | 14280000.0 |
| 2001-12-14 13:00:00 | AAPL | Stock | 0.3613 | 0.3638 | 0.3588 | 0.3618 | 19409600.0 |
| 2001-12-14 14:00:00 | AAPL | Stock | 0.3623 | 0.3661 | 0.3609 | 0.3655 | 21812000.0 |
| 2001-12-14 15:00:00 | AAPL | Stock | 0.3655 | 0.367 | 0.3638 | 0.3641 | 36198400.0 |
| 2001-12-14 16:00:00 | AAPL | Stock | 0.3639 | 0.3682 | 0.3639 | 0.3641 | 6703200.0 |
| 2001-12-14 17:00:00 | AAPL | Stock | 0.3641 | 0.3641 | 0.3641 | 0.3641 | 1243200.0 |
| 2001-12-14 08:00:00 | MSFT | Stock | 33.07 | 33.255 | 33.07 | 33.135 | 66400.0 |
| 2001-12-14 09:00:00 | MSFT | Stock | 33.15 | 33.36 | 32.965 | 33.24 | 5897000.0 |
| 2001-12-14 10:00:00 | MSFT | Stock | 33.235 | 33.485 | 33.105 | 33.46 | 6902600.0 |
| 2001-12-14 11:00:00 | MSFT | Stock | 33.465 | 33.555 | 33.285 | 33.51 | 4637200.0 |
| 2001-12-14 12:00:00 | MSFT | Stock | 33.4955 | 33.575 | 33.3245 | 33.435 | 3484200.0 |
| 2001-12-14 13:00:00 | MSFT | Stock | 33.44 | 33.625 | 33.375 | 33.525 | 3555800.0 |
| 2001-12-14 14:00:00 | MSFT | Stock | 33.525 | 33.865 | 33.47 | 33.81 | 5534400.0 |
| 2001-12-14 15:00:00 | MSFT | Stock | 33.81 | 33.975 | 33.65 | 33.725 | 8731000.0 |
| 2001-12-14 16:00:00 | MSFT | Stock | 33.75 | 33.825 | 33.311 | 33.775 | 2732400.0 |
| 2001-12-14 17:00:00 | MSFT | Stock | 33.72 | 33.83 | 33.72 | 33.72 | 296600.0 |
| 2001-12-14 18:00:00 | MSFT | Stock | 33.75 | 33.75 | 33.725 | 33.725 | 3800.0 |
| 2001-12-14 08:00:00 | NVDA | Stock | 0.5277 | 0.5292 | 0.5239 | 0.525 | 852000.0 |
| 2001-12-14 09:00:00 | NVDA | Stock | 0.5245 | 0.5337 | 0.5209 | 0.5307 | 78144000.0 |
| 2001-12-14 10:00:00 | NVDA | Stock | 0.5306 | 0.5312 | 0.5229 | 0.5279 | 122736000.0 |
| 2001-12-14 11:00:00 | NVDA | Stock | 0.5281 | 0.5348 | 0.5261 | 0.5325 | 74676000.0 |
| 2001-12-14 12:00:00 | NVDA | Stock | 0.5325 | 0.5341 | 0.5299 | 0.533 | 58392000.0 |
| 2001-12-14 13:00:00 | NVDA | Stock | 0.533 | 0.5333 | 0.5297 | 0.5305 | 62100000.0 |
| 2001-12-14 14:00:00 | NVDA | Stock | 0.5306 | 0.5417 | 0.53 | 0.5412 | 130968000.0 |
| 2001-12-14 15:00:00 | NVDA | Stock | 0.5412 | 0.5496 | 0.5408 | 0.5472 | 170628000.0 |
| 2001-12-14 16:00:00 | NVDA | Stock | 0.5472 | 0.5494 | 0.5347 | 0.5348 | 42636000.0 |
| 2001-12-14 17:00:00 | NVDA | Stock | 0.5483 | 0.5487 | 0.5462 | 0.5487 | 1332000.0 |
| 2001-12-14 18:00:00 | NVDA | Stock | 0.5487 | 0.5487 | 0.5472 | 0.5472 | 24000.0 |
| 2001-12-14 08:00:00 | AMZN | Stock | 0.5505 | 0.5575 | 0.5505 | 0.556 | 502000.0 |
| 2001-12-14 09:00:00 | AMZN | Stock | 0.5565 | 0.56 | 0.5475 | 0.5505 | 18694000.0 |
| 2001-12-14 10:00:00 | AMZN | Stock | 0.5505 | 0.5525 | 0.5425 | 0.552 | 22608000.0 |
| 2001-12-14 11:00:00 | AMZN | Stock | 0.552 | 0.5525 | 0.545 | 0.546 | 11654000.0 |
| 2001-12-14 12:00:00 | AMZN | Stock | 0.546 | 0.547 | 0.5035 | 0.5105 | 43932000.0 |
| 2001-12-14 13:00:00 | AMZN | Stock | 0.5105 | 0.525 | 0.5065 | 0.5235 | 32082000.0 |
| 2001-12-14 14:00:00 | AMZN | Stock | 0.525 | 0.5415 | 0.521 | 0.541 | 25616000.0 |
| 2001-12-14 15:00:00 | AMZN | Stock | 0.541 | 0.5526 | 0.5365 | 0.55 | 33610000.0 |
| 2001-12-14 16:00:00 | AMZN | Stock | 0.5525 | 0.554 | 0.5339 | 0.5535 | 4442000.0 |
| 2001-12-14 17:00:00 | AMZN | Stock | 0.5535 | 0.5545 | 0.55 | 0.554 | 396000.0 |
| 2001-12-14 18:00:00 | AMZN | Stock | 0.5535 | 0.5545 | 0.5535 | 0.5545 | 48000.0 |
| 2001-12-14 09:00:00 | CL | Stock | 28.55 | 28.55 | 28.25 | 28.275 | 275800.0 |
| 2001-12-14 10:00:00 | CL | Stock | 28.265 | 28.275 | 28.14 | 28.225 | 337400.0 |
| 2001-12-14 11:00:00 | CL | Stock | 28.22 | 28.22 | 27.935 | 28.0 | 532800.0 |
| 2001-12-14 12:00:00 | CL | Stock | 28.025 | 28.16 | 28.025 | 28.11 | 243800.0 |
| 2001-12-14 13:00:00 | CL | Stock | 28.115 | 28.21 | 28.1 | 28.18 | 205400.0 |
| 2001-12-14 14:00:00 | CL | Stock | 28.175 | 28.36 | 28.175 | 28.36 | 289800.0 |
| 2001-12-14 15:00:00 | CL | Stock | 28.355 | 28.42 | 28.225 | 28.27 | 471800.0 |
> showing 50 of 17,969 rows — these rows as CSV