PREVIEW / stock_30min / 2007-05-02
file: by_date/stock_30min/2007/2007-05-02.parquet size: 1.1 MB rows: 58,347 symbols: 2,695
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-02 09:30:00 | AAPL | Stock | 3.5589 | 3.5829 | 3.5525 | 3.5739 | 68581856.0 |
| 2007-05-02 10:00:00 | AAPL | Stock | 3.5739 | 3.58 | 3.5614 | 3.5657 | 41457920.0 |
| 2007-05-02 10:30:00 | AAPL | Stock | 3.5657 | 3.5714 | 3.5632 | 3.5654 | 33638584.0 |
| 2007-05-02 11:00:00 | AAPL | Stock | 3.5657 | 3.5689 | 3.5571 | 3.5632 | 33242076.0 |
| 2007-05-02 11:30:00 | AAPL | Stock | 3.5636 | 3.5711 | 3.5607 | 3.5689 | 24158456.0 |
| 2007-05-02 12:00:00 | AAPL | Stock | 3.5689 | 3.58 | 3.5661 | 3.5729 | 29186416.0 |
| 2007-05-02 12:30:00 | AAPL | Stock | 3.5729 | 3.5768 | 3.5711 | 3.5736 | 17499692.0 |
| 2007-05-02 13:00:00 | AAPL | Stock | 3.5739 | 3.58 | 3.5714 | 3.5786 | 19183276.0 |
| 2007-05-02 13:30:00 | AAPL | Stock | 3.5786 | 3.5807 | 3.5736 | 3.5771 | 22632036.0 |
| 2007-05-02 14:00:00 | AAPL | Stock | 3.5771 | 3.5907 | 3.575 | 3.5886 | 37710540.0 |
| 2007-05-02 14:30:00 | AAPL | Stock | 3.5889 | 3.5904 | 3.5821 | 3.5843 | 32937408.0 |
| 2007-05-02 15:00:00 | AAPL | Stock | 3.5843 | 3.5871 | 3.5782 | 3.5871 | 47350660.0 |
| 2007-05-02 15:30:00 | AAPL | Stock | 3.5868 | 3.5879 | 3.5814 | 3.5857 | 56157612.0 |
| 2007-05-02 16:00:00 | AAPL | Stock | 3.5854 | 3.5854 | 3.5854 | 3.5854 | 7257852.0 |
| 2007-05-02 09:30:00 | MSFT | Stock | 30.39 | 30.56 | 30.3 | 30.44 | 10235459.0 |
| 2007-05-02 10:00:00 | MSFT | Stock | 30.44 | 30.5 | 30.36 | 30.42 | 7010537.0 |
| 2007-05-02 10:30:00 | MSFT | Stock | 30.43 | 30.49 | 30.39 | 30.43 | 4940302.0 |
| 2007-05-02 11:00:00 | MSFT | Stock | 30.43 | 30.47 | 30.4 | 30.42 | 3476149.0 |
| 2007-05-02 11:30:00 | MSFT | Stock | 30.42 | 30.48 | 30.41 | 30.44 | 3318338.0 |
| 2007-05-02 12:00:00 | MSFT | Stock | 30.44 | 30.48 | 30.43 | 30.47 | 3103445.0 |
| 2007-05-02 12:30:00 | MSFT | Stock | 30.46 | 30.48 | 30.45 | 30.45 | 2047104.0 |
| 2007-05-02 13:00:00 | MSFT | Stock | 30.45 | 30.54 | 30.44 | 30.51 | 3584446.0 |
| 2007-05-02 13:30:00 | MSFT | Stock | 30.51 | 30.57 | 30.5 | 30.56 | 3619190.0 |
| 2007-05-02 14:00:00 | MSFT | Stock | 30.57 | 30.69 | 30.57 | 30.66 | 8217180.0 |
| 2007-05-02 14:30:00 | MSFT | Stock | 30.66 | 30.67 | 30.56 | 30.61 | 6981193.0 |
| 2007-05-02 15:00:00 | MSFT | Stock | 30.61 | 30.65 | 30.55 | 30.6 | 6831137.0 |
| 2007-05-02 15:30:00 | MSFT | Stock | 30.61 | 30.65 | 30.52 | 30.61 | 8970377.0 |
| 2007-05-02 16:00:00 | MSFT | Stock | 30.58 | 30.61 | 30.58 | 30.61 | 1273233.0 |
| 2007-05-02 08:30:00 | NVDA | Stock | 0.5583 | 0.5583 | 0.5583 | 0.5583 | 30000.0 |
| 2007-05-02 09:00:00 | NVDA | Stock | 0.5567 | 0.5568 | 0.5558 | 0.5567 | 76800.0 |
| 2007-05-02 09:30:00 | NVDA | Stock | 0.5568 | 0.5592 | 0.5528 | 0.5543 | 41645640.0 |
| 2007-05-02 10:00:00 | NVDA | Stock | 0.5545 | 0.5563 | 0.5493 | 0.55 | 59168820.0 |
| 2007-05-02 10:30:00 | NVDA | Stock | 0.55 | 0.5538 | 0.5477 | 0.5505 | 42317220.0 |
| 2007-05-02 11:00:00 | NVDA | Stock | 0.5505 | 0.5505 | 0.548 | 0.5485 | 38700360.0 |
| 2007-05-02 11:30:00 | NVDA | Stock | 0.5485 | 0.551 | 0.5485 | 0.5498 | 42591660.0 |
| 2007-05-02 12:00:00 | NVDA | Stock | 0.5498 | 0.5508 | 0.5492 | 0.5498 | 32805240.0 |
| 2007-05-02 12:30:00 | NVDA | Stock | 0.5498 | 0.55 | 0.5478 | 0.5483 | 35336340.0 |
| 2007-05-02 13:00:00 | NVDA | Stock | 0.5483 | 0.5493 | 0.5477 | 0.5483 | 24529620.0 |
| 2007-05-02 13:30:00 | NVDA | Stock | 0.5483 | 0.5507 | 0.5483 | 0.5498 | 33519000.0 |
| 2007-05-02 14:00:00 | NVDA | Stock | 0.55 | 0.553 | 0.5497 | 0.5518 | 63633780.0 |
| 2007-05-02 14:30:00 | NVDA | Stock | 0.5518 | 0.5518 | 0.5492 | 0.5503 | 47156160.0 |
| 2007-05-02 15:00:00 | NVDA | Stock | 0.5505 | 0.551 | 0.5461 | 0.547 | 52928940.0 |
| 2007-05-02 15:30:00 | NVDA | Stock | 0.547 | 0.5475 | 0.5447 | 0.5475 | 92270340.0 |
| 2007-05-02 16:00:00 | NVDA | Stock | 0.5475 | 0.5475 | 0.547 | 0.5472 | 7988880.0 |
| 2007-05-02 16:30:00 | NVDA | Stock | 0.5472 | 0.55 | 0.5472 | 0.55 | 206820.0 |
| 2007-05-02 17:00:00 | NVDA | Stock | 0.547 | 0.547 | 0.5462 | 0.5462 | 36000.0 |
| 2007-05-02 18:30:00 | NVDA | Stock | 0.546 | 0.546 | 0.5458 | 0.5458 | 60000.0 |
| 2007-05-02 19:00:00 | NVDA | Stock | 0.5447 | 0.549 | 0.5443 | 0.549 | 56460.0 |
| 2007-05-02 19:30:00 | NVDA | Stock | 0.5467 | 0.5467 | 0.5467 | 0.5467 | 12000.0 |
| 2007-05-02 04:00:00 | AMZN | Stock | 3.0535 | 3.0935 | 3.0535 | 3.0935 | 10000.0 |
> showing 50 of 58,347 rows — these rows as CSV