PREVIEW / stock_1hour / 2009-09-21
file: by_date/stock_1hour/2009/2009-09-21.parquet size: 880 KB rows: 42,729 symbols: 3,394
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-09-21 04:00:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6054 | 6.6054 | 12152.0 |
| 2009-09-21 05:00:00 | AAPL | Stock | 6.6054 | 6.6054 | 6.5754 | 6.5754 | 9324.0 |
| 2009-09-21 07:00:00 | AAPL | Stock | 6.5821 | 6.5829 | 6.5604 | 6.5825 | 327040.0 |
| 2009-09-21 08:00:00 | AAPL | Stock | 6.5832 | 6.5889 | 6.5571 | 6.5668 | 1669752.0 |
| 2009-09-21 09:00:00 | AAPL | Stock | 6.5668 | 6.6129 | 6.4864 | 6.5214 | 88032616.0 |
| 2009-09-21 10:00:00 | AAPL | Stock | 6.5243 | 6.5475 | 6.4982 | 6.5018 | 77677796.0 |
| 2009-09-21 11:00:00 | AAPL | Stock | 6.5018 | 6.5603 | 6.4943 | 6.5545 | 75503848.0 |
| 2009-09-21 12:00:00 | AAPL | Stock | 6.5554 | 6.5639 | 6.5393 | 6.5496 | 34855464.0 |
| 2009-09-21 13:00:00 | AAPL | Stock | 6.5496 | 6.5632 | 6.54 | 6.5554 | 27273960.0 |
| 2009-09-21 14:00:00 | AAPL | Stock | 6.5557 | 6.5611 | 6.5393 | 6.5554 | 34386324.0 |
| 2009-09-21 15:00:00 | AAPL | Stock | 6.5554 | 6.5825 | 6.5471 | 6.5743 | 60718084.0 |
| 2009-09-21 16:00:00 | AAPL | Stock | 6.5718 | 6.5764 | 6.5473 | 6.5764 | 30925524.0 |
| 2009-09-21 17:00:00 | AAPL | Stock | 6.5764 | 6.5804 | 6.5721 | 6.58 | 464576.0 |
| 2009-09-21 18:00:00 | AAPL | Stock | 6.5775 | 6.5796 | 6.5721 | 6.575 | 406420.0 |
| 2009-09-21 19:00:00 | AAPL | Stock | 6.5779 | 6.5804 | 6.5754 | 6.5768 | 119252.0 |
| 2009-09-21 06:00:00 | MSFT | Stock | 25.15 | 25.15 | 25.1 | 25.1 | 200.0 |
| 2009-09-21 07:00:00 | MSFT | Stock | 25.12 | 25.12 | 25.12 | 25.12 | 840.0 |
| 2009-09-21 08:00:00 | MSFT | Stock | 25.12 | 25.2 | 25.11 | 25.11 | 7698.0 |
| 2009-09-21 09:00:00 | MSFT | Stock | 25.12 | 25.31 | 25.1 | 25.14 | 4788829.0 |
| 2009-09-21 10:00:00 | MSFT | Stock | 25.14 | 25.24 | 25.105 | 25.2 | 4808274.0 |
| 2009-09-21 11:00:00 | MSFT | Stock | 25.2 | 25.37 | 25.19 | 25.34 | 3784538.0 |
| 2009-09-21 12:00:00 | MSFT | Stock | 25.345 | 25.35 | 25.25 | 25.27 | 2432813.0 |
| 2009-09-21 13:00:00 | MSFT | Stock | 25.28 | 25.29 | 25.24 | 25.26 | 2176320.0 |
| 2009-09-21 14:00:00 | MSFT | Stock | 25.27 | 25.31 | 25.18 | 25.25 | 3483800.0 |
| 2009-09-21 15:00:00 | MSFT | Stock | 25.25 | 25.33 | 25.2 | 25.3 | 5074469.0 |
| 2009-09-21 16:00:00 | MSFT | Stock | 25.29 | 25.34 | 25.22 | 25.3 | 1699253.0 |
| 2009-09-21 17:00:00 | MSFT | Stock | 25.373 | 25.373 | 25.3 | 25.3 | 1250.0 |
| 2009-09-21 18:00:00 | MSFT | Stock | 25.3 | 26.15 | 25.3 | 25.36 | 10442.0 |
| 2009-09-21 19:00:00 | MSFT | Stock | 25.35 | 25.36 | 25.27 | 25.3 | 3800.0 |
| 2009-09-21 08:00:00 | NVDA | Stock | 0.3825 | 0.3825 | 0.3753 | 0.3768 | 98080.0 |
| 2009-09-21 09:00:00 | NVDA | Stock | 0.377 | 0.3788 | 0.3728 | 0.376 | 97924640.0 |
| 2009-09-21 10:00:00 | NVDA | Stock | 0.3758 | 0.3773 | 0.3733 | 0.377 | 91021520.0 |
| 2009-09-21 11:00:00 | NVDA | Stock | 0.3773 | 0.3853 | 0.377 | 0.382 | 102653920.0 |
| 2009-09-21 12:00:00 | NVDA | Stock | 0.3822 | 0.3828 | 0.38 | 0.382 | 36396160.0 |
| 2009-09-21 13:00:00 | NVDA | Stock | 0.3822 | 0.3822 | 0.3785 | 0.3785 | 50783640.0 |
| 2009-09-21 14:00:00 | NVDA | Stock | 0.3785 | 0.3793 | 0.3773 | 0.3779 | 61858640.0 |
| 2009-09-21 15:00:00 | NVDA | Stock | 0.378 | 0.3798 | 0.3779 | 0.379 | 104892000.0 |
| 2009-09-21 16:00:00 | NVDA | Stock | 0.3785 | 0.3793 | 0.3785 | 0.3793 | 7143520.0 |
| 2009-09-21 17:00:00 | NVDA | Stock | 0.3793 | 0.3793 | 0.3793 | 0.3793 | 12000.0 |
| 2009-09-21 19:00:00 | NVDA | Stock | 0.3793 | 0.3793 | 0.3775 | 0.3793 | 35000.0 |
| 2009-09-21 06:00:00 | AMZN | Stock | 4.4435 | 4.4435 | 4.4435 | 4.4435 | 4000.0 |
| 2009-09-21 07:00:00 | AMZN | Stock | 4.451 | 4.451 | 4.451 | 4.451 | 4000.0 |
| 2009-09-21 08:00:00 | AMZN | Stock | 4.5 | 4.5 | 4.472 | 4.472 | 70060.0 |
| 2009-09-21 09:00:00 | AMZN | Stock | 4.4665 | 4.5 | 4.435 | 4.4355 | 14401900.0 |
| 2009-09-21 10:00:00 | AMZN | Stock | 4.435 | 4.484 | 4.424 | 4.4705 | 14251740.0 |
| 2009-09-21 11:00:00 | AMZN | Stock | 4.4705 | 4.5375 | 4.469 | 4.5125 | 14207820.0 |
| 2009-09-21 12:00:00 | AMZN | Stock | 4.513 | 4.527 | 4.5065 | 4.507 | 7073580.0 |
| 2009-09-21 13:00:00 | AMZN | Stock | 4.5083 | 4.517 | 4.501 | 4.511 | 5021060.0 |
| 2009-09-21 14:00:00 | AMZN | Stock | 4.5115 | 4.5195 | 4.4945 | 4.5115 | 5917260.0 |
| 2009-09-21 15:00:00 | AMZN | Stock | 4.512 | 4.538 | 4.5005 | 4.528 | 17870920.0 |
> showing 50 of 42,729 rows — these rows as CSV