PREVIEW / stock_30min / 2009-02-06
file: by_date/stock_30min/2009/2009-02-06.parquet size: 1.2 MB rows: 67,122 symbols: 3,318
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-02-06 04:30:00 | AAPL | Stock | 3.4593 | 3.4593 | 3.4486 | 3.4486 | 19600.0 |
| 2009-02-06 07:00:00 | AAPL | Stock | 3.4707 | 3.4707 | 3.4707 | 3.4707 | 2800.0 |
| 2009-02-06 08:00:00 | AAPL | Stock | 3.4589 | 3.4589 | 3.4321 | 3.4393 | 225708.0 |
| 2009-02-06 08:30:00 | AAPL | Stock | 3.4357 | 3.4804 | 3.4293 | 3.47 | 1890896.0 |
| 2009-02-06 09:00:00 | AAPL | Stock | 3.4682 | 3.4704 | 3.4489 | 3.4664 | 738192.0 |
| 2009-02-06 09:30:00 | AAPL | Stock | 3.4682 | 3.5129 | 3.4643 | 3.5025 | 79849616.0 |
| 2009-02-06 10:00:00 | AAPL | Stock | 3.5025 | 3.5143 | 3.4893 | 3.4932 | 49853916.0 |
| 2009-02-06 10:30:00 | AAPL | Stock | 3.4932 | 3.5357 | 3.4864 | 3.5282 | 62277600.0 |
| 2009-02-06 11:00:00 | AAPL | Stock | 3.5283 | 3.55 | 3.5254 | 3.535 | 56360892.0 |
| 2009-02-06 11:30:00 | AAPL | Stock | 3.5361 | 3.5464 | 3.5268 | 3.5379 | 30840236.0 |
| 2009-02-06 12:00:00 | AAPL | Stock | 3.5375 | 3.5414 | 3.5286 | 3.53 | 25258716.0 |
| 2009-02-06 12:30:00 | AAPL | Stock | 3.53 | 3.5446 | 3.5293 | 3.5321 | 26569620.0 |
| 2009-02-06 13:00:00 | AAPL | Stock | 3.5321 | 3.5607 | 3.5304 | 3.5493 | 40430348.0 |
| 2009-02-06 13:30:00 | AAPL | Stock | 3.5489 | 3.5675 | 3.5489 | 3.5668 | 45429496.0 |
| 2009-02-06 14:00:00 | AAPL | Stock | 3.5668 | 3.5696 | 3.5543 | 3.5636 | 43878744.0 |
| 2009-02-06 14:30:00 | AAPL | Stock | 3.5639 | 3.5714 | 3.5443 | 3.5529 | 53047092.0 |
| 2009-02-06 15:00:00 | AAPL | Stock | 3.5525 | 3.5607 | 3.5379 | 3.5554 | 54285644.0 |
| 2009-02-06 15:30:00 | AAPL | Stock | 3.555 | 3.5689 | 3.5543 | 3.5689 | 76228684.0 |
| 2009-02-06 16:00:00 | AAPL | Stock | 3.5596 | 3.5679 | 3.5369 | 3.5607 | 21289408.0 |
| 2009-02-06 16:30:00 | AAPL | Stock | 3.5586 | 3.5625 | 3.5579 | 3.5611 | 132216.0 |
| 2009-02-06 17:00:00 | AAPL | Stock | 3.5607 | 3.5625 | 3.5607 | 3.5614 | 137228.0 |
| 2009-02-06 17:30:00 | AAPL | Stock | 3.5618 | 3.5714 | 3.5607 | 3.5675 | 159460.0 |
| 2009-02-06 18:00:00 | AAPL | Stock | 3.5704 | 3.5704 | 3.5614 | 3.5696 | 12322940.0 |
| 2009-02-06 18:30:00 | AAPL | Stock | 3.5679 | 3.57 | 3.5668 | 3.57 | 74004.0 |
| 2009-02-06 19:00:00 | AAPL | Stock | 3.5679 | 3.5714 | 3.5679 | 3.5714 | 126224.0 |
| 2009-02-06 19:30:00 | AAPL | Stock | 3.5675 | 3.5836 | 3.5632 | 3.5786 | 215572.0 |
| 2009-02-06 06:30:00 | MSFT | Stock | 19.1 | 19.1 | 19.1 | 19.1 | 5000.0 |
| 2009-02-06 07:00:00 | MSFT | Stock | 19.0 | 19.0 | 19.0 | 19.0 | 1900.0 |
| 2009-02-06 08:00:00 | MSFT | Stock | 19.0 | 19.03 | 18.96 | 18.96 | 1235.0 |
| 2009-02-06 08:30:00 | MSFT | Stock | 18.94 | 19.1 | 18.94 | 19.08 | 25714.0 |
| 2009-02-06 09:00:00 | MSFT | Stock | 19.1 | 19.2 | 19.09 | 19.13 | 42493.0 |
| 2009-02-06 09:30:00 | MSFT | Stock | 19.19 | 19.63 | 19.06 | 19.625 | 7314873.0 |
| 2009-02-06 10:00:00 | MSFT | Stock | 19.62 | 19.64 | 19.47 | 19.57 | 8102399.0 |
| 2009-02-06 10:30:00 | MSFT | Stock | 19.563 | 19.75 | 19.55 | 19.71 | 8612890.0 |
| 2009-02-06 11:00:00 | MSFT | Stock | 19.705 | 19.84 | 19.65 | 19.75 | 7030257.0 |
| 2009-02-06 11:30:00 | MSFT | Stock | 19.75 | 19.84 | 19.69 | 19.73 | 4449622.0 |
| 2009-02-06 12:00:00 | MSFT | Stock | 19.73 | 19.75 | 19.64 | 19.66 | 3825044.0 |
| 2009-02-06 12:30:00 | MSFT | Stock | 19.67 | 19.78 | 19.65 | 19.762 | 5706797.0 |
| 2009-02-06 13:00:00 | MSFT | Stock | 19.76 | 19.9 | 19.72 | 19.88 | 5139241.0 |
| 2009-02-06 13:30:00 | MSFT | Stock | 19.88 | 19.93 | 19.682 | 19.82 | 4994786.0 |
| 2009-02-06 14:00:00 | MSFT | Stock | 19.81 | 19.82 | 19.62 | 19.69 | 7095739.0 |
| 2009-02-06 14:30:00 | MSFT | Stock | 19.7 | 19.78 | 19.61 | 19.68 | 3624509.0 |
| 2009-02-06 15:00:00 | MSFT | Stock | 19.68 | 19.69 | 19.57 | 19.61 | 4709215.0 |
| 2009-02-06 15:30:00 | MSFT | Stock | 19.61 | 19.77 | 19.59 | 19.7 | 10188044.0 |
| 2009-02-06 16:00:00 | MSFT | Stock | 19.67 | 19.85 | 19.65 | 19.66 | 4146670.0 |
| 2009-02-06 16:30:00 | MSFT | Stock | 19.79 | 19.79 | 19.66 | 19.79 | 8694.0 |
| 2009-02-06 17:00:00 | MSFT | Stock | 19.8 | 19.83 | 19.66 | 19.66 | 4331.0 |
| 2009-02-06 17:30:00 | MSFT | Stock | 19.79 | 19.81 | 19.78 | 19.81 | 7275.0 |
| 2009-02-06 18:00:00 | MSFT | Stock | 19.81 | 19.85 | 19.66 | 19.85 | 21303.0 |
| 2009-02-06 18:30:00 | MSFT | Stock | 19.86 | 19.88 | 19.78 | 19.78 | 1479.0 |
> showing 50 of 67,122 rows — these rows as CSV