PREVIEW / stock_1hour / 2009-11-18
file: by_date/stock_1hour/2009/2009-11-18.parquet size: 899 KB rows: 43,926 symbols: 3,430
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-18 04:00:00 | AAPL | Stock | 7.3964 | 7.4 | 7.3964 | 7.4 | 5600.0 |
| 2009-11-18 06:00:00 | AAPL | Stock | 7.4618 | 7.4618 | 7.4411 | 7.4411 | 24024.0 |
| 2009-11-18 07:00:00 | AAPL | Stock | 7.4382 | 7.4382 | 7.4232 | 7.425 | 402472.0 |
| 2009-11-18 08:00:00 | AAPL | Stock | 7.4232 | 7.4239 | 7.3786 | 7.39 | 2123240.0 |
| 2009-11-18 09:00:00 | AAPL | Stock | 7.3843 | 7.3929 | 7.3511 | 7.3596 | 52314612.0 |
| 2009-11-18 10:00:00 | AAPL | Stock | 7.3596 | 7.3821 | 7.3375 | 7.3775 | 58653588.0 |
| 2009-11-18 11:00:00 | AAPL | Stock | 7.3771 | 7.3832 | 7.3432 | 7.3607 | 31354232.0 |
| 2009-11-18 12:00:00 | AAPL | Stock | 7.3596 | 7.3639 | 7.3225 | 7.3232 | 57073072.0 |
| 2009-11-18 13:00:00 | AAPL | Stock | 7.3239 | 7.325 | 7.2857 | 7.3104 | 54193776.0 |
| 2009-11-18 14:00:00 | AAPL | Stock | 7.31 | 7.3471 | 7.3057 | 7.3082 | 46980416.0 |
| 2009-11-18 15:00:00 | AAPL | Stock | 7.3089 | 7.3557 | 7.3086 | 7.3557 | 53120508.0 |
| 2009-11-18 16:00:00 | AAPL | Stock | 7.3539 | 7.3611 | 7.3339 | 7.3571 | 11429852.0 |
| 2009-11-18 17:00:00 | AAPL | Stock | 7.3521 | 7.3589 | 7.3521 | 7.3557 | 53508.0 |
| 2009-11-18 18:00:00 | AAPL | Stock | 7.3557 | 7.3564 | 7.35 | 7.35 | 498008.0 |
| 2009-11-18 19:00:00 | AAPL | Stock | 7.3496 | 7.35 | 7.3339 | 7.3339 | 195860.0 |
| 2009-11-18 04:00:00 | MSFT | Stock | 30.0 | 30.0 | 30.0 | 30.0 | 1000.0 |
| 2009-11-18 07:00:00 | MSFT | Stock | 30.05 | 30.05 | 29.97 | 30.0 | 1900.0 |
| 2009-11-18 08:00:00 | MSFT | Stock | 30.0 | 30.15 | 30.0 | 30.07 | 57430.0 |
| 2009-11-18 09:00:00 | MSFT | Stock | 30.08 | 30.08 | 29.81 | 29.84 | 13417796.0 |
| 2009-11-18 10:00:00 | MSFT | Stock | 29.84 | 30.03 | 29.82 | 29.98 | 9048386.0 |
| 2009-11-18 11:00:00 | MSFT | Stock | 29.98 | 30.06 | 29.95 | 30.011 | 8339581.0 |
| 2009-11-18 12:00:00 | MSFT | Stock | 30.01 | 30.08 | 30.0 | 30.01 | 5717789.0 |
| 2009-11-18 13:00:00 | MSFT | Stock | 30.01 | 30.03 | 29.92 | 30.0 | 5664589.0 |
| 2009-11-18 14:00:00 | MSFT | Stock | 30.0 | 30.03 | 29.96 | 30.0 | 4235245.0 |
| 2009-11-18 15:00:00 | MSFT | Stock | 30.0 | 30.14 | 29.97 | 30.11 | 9158192.0 |
| 2009-11-18 16:00:00 | MSFT | Stock | 30.1 | 30.11 | 29.987 | 30.11 | 1964133.0 |
| 2009-11-18 17:00:00 | MSFT | Stock | 30.1 | 30.1 | 30.07 | 30.07 | 1604.0 |
| 2009-11-18 18:00:00 | MSFT | Stock | 30.11 | 30.12 | 30.1 | 30.12 | 11510.0 |
| 2009-11-18 19:00:00 | MSFT | Stock | 30.12 | 30.14 | 30.05 | 30.05 | 8449.0 |
| 2009-11-18 08:00:00 | NVDA | Stock | 0.3425 | 0.3425 | 0.3425 | 0.3425 | 8000.0 |
| 2009-11-18 09:00:00 | NVDA | Stock | 0.3435 | 0.3435 | 0.335 | 0.3353 | 77556520.0 |
| 2009-11-18 10:00:00 | NVDA | Stock | 0.3353 | 0.3385 | 0.335 | 0.3373 | 50314800.0 |
| 2009-11-18 11:00:00 | NVDA | Stock | 0.3373 | 0.338 | 0.3342 | 0.3346 | 57493760.0 |
| 2009-11-18 12:00:00 | NVDA | Stock | 0.3345 | 0.3348 | 0.3335 | 0.3338 | 43973240.0 |
| 2009-11-18 13:00:00 | NVDA | Stock | 0.3338 | 0.335 | 0.3322 | 0.3343 | 47195280.0 |
| 2009-11-18 14:00:00 | NVDA | Stock | 0.3342 | 0.3368 | 0.3342 | 0.3364 | 44813680.0 |
| 2009-11-18 15:00:00 | NVDA | Stock | 0.3362 | 0.3382 | 0.3358 | 0.338 | 111945040.0 |
| 2009-11-18 16:00:00 | NVDA | Stock | 0.338 | 0.3382 | 0.336 | 0.338 | 20293600.0 |
| 2009-11-18 17:00:00 | NVDA | Stock | 0.338 | 0.3382 | 0.338 | 0.3382 | 38000.0 |
| 2009-11-18 19:00:00 | NVDA | Stock | 0.3362 | 0.3362 | 0.334 | 0.334 | 144600.0 |
| 2009-11-18 08:00:00 | AMZN | Stock | 6.555 | 6.555 | 6.535 | 6.547 | 122880.0 |
| 2009-11-18 09:00:00 | AMZN | Stock | 6.5425 | 6.5705 | 6.5145 | 6.5393 | 15047260.0 |
| 2009-11-18 10:00:00 | AMZN | Stock | 6.538 | 6.546 | 6.497 | 6.5295 | 16358680.0 |
| 2009-11-18 11:00:00 | AMZN | Stock | 6.53 | 6.546 | 6.5145 | 6.531 | 7039260.0 |
| 2009-11-18 12:00:00 | AMZN | Stock | 6.531 | 6.539 | 6.5105 | 6.5135 | 7298020.0 |
| 2009-11-18 13:00:00 | AMZN | Stock | 6.5135 | 6.5145 | 6.4765 | 6.5 | 13469940.0 |
| 2009-11-18 14:00:00 | AMZN | Stock | 6.5 | 6.557 | 6.5 | 6.5345 | 18828220.0 |
| 2009-11-18 15:00:00 | AMZN | Stock | 6.5355 | 6.5645 | 6.533 | 6.5645 | 19429180.0 |
| 2009-11-18 16:00:00 | AMZN | Stock | 6.5645 | 6.575 | 6.5304 | 6.571 | 4226600.0 |
| 2009-11-18 17:00:00 | AMZN | Stock | 6.582 | 6.5825 | 6.57 | 6.579 | 66860.0 |
> showing 50 of 43,926 rows — these rows as CSV