PREVIEW / stock_30min / 2009-10-14
file: by_date/stock_30min/2009/2009-10-14.parquet size: 1.4 MB rows: 74,337 symbols: 3,403
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-10-14 04:00:00 | AAPL | Stock | 6.8168 | 6.8168 | 6.8168 | 6.8168 | 2800.0 |
| 2009-10-14 05:30:00 | AAPL | Stock | 6.8536 | 6.8536 | 6.8536 | 6.8536 | 2800.0 |
| 2009-10-14 06:00:00 | AAPL | Stock | 6.8479 | 6.8479 | 6.8479 | 6.8479 | 2800.0 |
| 2009-10-14 06:30:00 | AAPL | Stock | 6.8539 | 6.8571 | 6.8536 | 6.8571 | 129444.0 |
| 2009-10-14 07:00:00 | AAPL | Stock | 6.8571 | 6.8646 | 6.8482 | 6.8646 | 286916.0 |
| 2009-10-14 07:30:00 | AAPL | Stock | 6.8646 | 6.8646 | 6.8564 | 6.8643 | 643244.0 |
| 2009-10-14 08:00:00 | AAPL | Stock | 6.8639 | 6.8739 | 6.8568 | 6.8682 | 1779568.0 |
| 2009-10-14 08:30:00 | AAPL | Stock | 6.8679 | 6.9 | 6.865 | 6.9 | 3431568.0 |
| 2009-10-14 09:00:00 | AAPL | Stock | 6.8964 | 6.9007 | 6.8639 | 6.8661 | 2962512.0 |
| 2009-10-14 09:30:00 | AAPL | Stock | 6.8661 | 6.8686 | 6.7939 | 6.8132 | 89951624.0 |
| 2009-10-14 10:00:00 | AAPL | Stock | 6.8129 | 6.8379 | 6.8057 | 6.8271 | 36481704.0 |
| 2009-10-14 10:30:00 | AAPL | Stock | 6.8271 | 6.8382 | 6.8236 | 6.8368 | 17937724.0 |
| 2009-10-14 11:00:00 | AAPL | Stock | 6.837 | 6.8486 | 6.8354 | 6.8418 | 19182408.0 |
| 2009-10-14 11:30:00 | AAPL | Stock | 6.8419 | 6.8475 | 6.8307 | 6.8311 | 17003980.0 |
| 2009-10-14 12:00:00 | AAPL | Stock | 6.8315 | 6.835 | 6.8225 | 6.8304 | 16520392.0 |
| 2009-10-14 12:30:00 | AAPL | Stock | 6.8301 | 6.8336 | 6.825 | 6.83 | 11839240.0 |
| 2009-10-14 13:00:00 | AAPL | Stock | 6.829 | 6.8368 | 6.825 | 6.825 | 17449936.0 |
| 2009-10-14 13:30:00 | AAPL | Stock | 6.8257 | 6.83 | 6.8214 | 6.8261 | 9728264.0 |
| 2009-10-14 14:00:00 | AAPL | Stock | 6.8261 | 6.8339 | 6.8143 | 6.8189 | 19999280.0 |
| 2009-10-14 14:30:00 | AAPL | Stock | 6.8193 | 6.8254 | 6.8039 | 6.8196 | 19466412.0 |
| 2009-10-14 15:00:00 | AAPL | Stock | 6.8193 | 6.8343 | 6.8157 | 6.8336 | 27186656.0 |
| 2009-10-14 15:30:00 | AAPL | Stock | 6.8332 | 6.8389 | 6.8161 | 6.8321 | 50699712.0 |
| 2009-10-14 16:00:00 | AAPL | Stock | 6.8325 | 6.8393 | 6.8293 | 6.835 | 11153100.0 |
| 2009-10-14 16:30:00 | AAPL | Stock | 6.8339 | 6.8364 | 6.8293 | 6.835 | 329028.0 |
| 2009-10-14 17:00:00 | AAPL | Stock | 6.7864 | 6.8411 | 6.7864 | 6.8396 | 288120.0 |
| 2009-10-14 17:30:00 | AAPL | Stock | 6.8396 | 6.84 | 6.8379 | 6.8389 | 153300.0 |
| 2009-10-14 18:00:00 | AAPL | Stock | 6.8386 | 6.84 | 6.8318 | 6.8393 | 109928.0 |
| 2009-10-14 18:30:00 | AAPL | Stock | 6.8368 | 6.8386 | 6.8361 | 6.8375 | 54180.0 |
| 2009-10-14 19:00:00 | AAPL | Stock | 6.8386 | 6.8425 | 6.8386 | 6.8411 | 71400.0 |
| 2009-10-14 19:30:00 | AAPL | Stock | 6.8411 | 6.8411 | 6.8393 | 6.8407 | 120204.0 |
| 2009-10-14 05:00:00 | MSFT | Stock | 26.2 | 26.2 | 26.2 | 26.2 | 160.0 |
| 2009-10-14 07:00:00 | MSFT | Stock | 26.25 | 26.25 | 26.25 | 26.25 | 1000.0 |
| 2009-10-14 07:30:00 | MSFT | Stock | 26.24 | 26.24 | 26.2 | 26.2 | 500.0 |
| 2009-10-14 08:00:00 | MSFT | Stock | 26.2 | 26.24 | 26.15 | 26.15 | 17375.0 |
| 2009-10-14 08:30:00 | MSFT | Stock | 26.18 | 26.22 | 26.12 | 26.18 | 29723.0 |
| 2009-10-14 09:00:00 | MSFT | Stock | 26.19 | 26.29 | 25.81 | 26.15 | 190517.0 |
| 2009-10-14 09:30:00 | MSFT | Stock | 26.16 | 26.2 | 25.93 | 26.042 | 6636149.0 |
| 2009-10-14 10:00:00 | MSFT | Stock | 26.04 | 26.08 | 25.94 | 25.969 | 4134443.0 |
| 2009-10-14 10:30:00 | MSFT | Stock | 25.96 | 26.01 | 25.9 | 26.0 | 2074505.0 |
| 2009-10-14 11:00:00 | MSFT | Stock | 25.99 | 26.07 | 25.99 | 26.043 | 1759824.0 |
| 2009-10-14 11:30:00 | MSFT | Stock | 26.04 | 26.05 | 25.97 | 25.99 | 1276730.0 |
| 2009-10-14 12:00:00 | MSFT | Stock | 25.99 | 26.0 | 25.92 | 25.94 | 2336033.0 |
| 2009-10-14 12:30:00 | MSFT | Stock | 25.93 | 25.96 | 25.87 | 25.9 | 2332441.0 |
| 2009-10-14 13:00:00 | MSFT | Stock | 25.9 | 25.95 | 25.89 | 25.89 | 2131568.0 |
| 2009-10-14 13:30:00 | MSFT | Stock | 25.89 | 25.91 | 25.82 | 25.842 | 2032443.0 |
| 2009-10-14 14:00:00 | MSFT | Stock | 25.85 | 25.9 | 25.84 | 25.85 | 2168660.0 |
| 2009-10-14 14:30:00 | MSFT | Stock | 25.85 | 25.875 | 25.82 | 25.863 | 2010552.0 |
| 2009-10-14 15:00:00 | MSFT | Stock | 25.87 | 26.0 | 25.86 | 25.977 | 3661566.0 |
| 2009-10-14 15:30:00 | MSFT | Stock | 25.975 | 25.99 | 25.91 | 25.97 | 5973169.0 |
| 2009-10-14 16:00:00 | MSFT | Stock | 25.97 | 25.99 | 25.941 | 25.96 | 5660486.0 |
> showing 50 of 74,337 rows — these rows as CSV