PREVIEW / stock_30min / 2009-09-30
file: by_date/stock_30min/2009/2009-09-30.parquet size: 1.4 MB rows: 75,147 symbols: 3,400
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-30 06:00:00 | AAPL | Stock | 6.6671 | 6.6671 | 6.6671 | 6.6671 | 2800.0 |
| 2009-09-30 06:30:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 2800.0 |
| 2009-09-30 07:00:00 | AAPL | Stock | 6.6257 | 6.65 | 6.6257 | 6.645 | 47460.0 |
| 2009-09-30 07:30:00 | AAPL | Stock | 6.6446 | 6.6564 | 6.6446 | 6.6518 | 51800.0 |
| 2009-09-30 08:00:00 | AAPL | Stock | 6.6554 | 6.6625 | 6.6429 | 6.6564 | 624260.0 |
| 2009-09-30 08:30:00 | AAPL | Stock | 6.6589 | 6.6661 | 6.6454 | 6.6486 | 678104.0 |
| 2009-09-30 09:00:00 | AAPL | Stock | 6.6489 | 6.6536 | 6.6429 | 6.6475 | 339612.0 |
| 2009-09-30 09:30:00 | AAPL | Stock | 6.6475 | 6.6543 | 6.5219 | 6.5485 | 82877172.0 |
| 2009-09-30 10:00:00 | AAPL | Stock | 6.5475 | 6.56 | 6.5286 | 6.5504 | 45292884.0 |
| 2009-09-30 10:30:00 | AAPL | Stock | 6.5504 | 6.5671 | 6.5375 | 6.5454 | 30333436.0 |
| 2009-09-30 11:00:00 | AAPL | Stock | 6.545 | 6.5864 | 6.5436 | 6.5779 | 34239016.0 |
| 2009-09-30 11:30:00 | AAPL | Stock | 6.5786 | 6.6061 | 6.5764 | 6.5979 | 29052128.0 |
| 2009-09-30 12:00:00 | AAPL | Stock | 6.5972 | 6.6046 | 6.5821 | 6.6018 | 19085500.0 |
| 2009-09-30 12:30:00 | AAPL | Stock | 6.6021 | 6.65 | 6.6021 | 6.6436 | 45404772.0 |
| 2009-09-30 13:00:00 | AAPL | Stock | 6.6432 | 6.6589 | 6.6321 | 6.6332 | 34639304.0 |
| 2009-09-30 13:30:00 | AAPL | Stock | 6.6336 | 6.6536 | 6.6293 | 6.6386 | 23246888.0 |
| 2009-09-30 14:00:00 | AAPL | Stock | 6.6382 | 6.6429 | 6.6268 | 6.6293 | 18465244.0 |
| 2009-09-30 14:30:00 | AAPL | Stock | 6.6289 | 6.6429 | 6.6093 | 6.6096 | 26535180.0 |
| 2009-09-30 15:00:00 | AAPL | Stock | 6.6096 | 6.6175 | 6.5798 | 6.6036 | 48215412.0 |
| 2009-09-30 15:30:00 | AAPL | Stock | 6.6036 | 6.6439 | 6.5964 | 6.6204 | 55970096.0 |
| 2009-09-30 16:00:00 | AAPL | Stock | 6.6196 | 6.6221 | 6.5996 | 6.62 | 37913512.0 |
| 2009-09-30 16:30:00 | AAPL | Stock | 6.62 | 6.6371 | 6.6039 | 6.6229 | 1341256.0 |
| 2009-09-30 17:00:00 | AAPL | Stock | 6.6207 | 6.6286 | 6.6207 | 6.6254 | 19600.0 |
| 2009-09-30 17:30:00 | AAPL | Stock | 6.625 | 6.6257 | 6.6214 | 6.6214 | 129500.0 |
| 2009-09-30 18:00:00 | AAPL | Stock | 6.6196 | 6.6246 | 6.6179 | 6.6196 | 57372.0 |
| 2009-09-30 18:30:00 | AAPL | Stock | 6.6196 | 6.6214 | 6.6161 | 6.6214 | 37184.0 |
| 2009-09-30 19:00:00 | AAPL | Stock | 6.6232 | 6.6321 | 6.62 | 6.6321 | 157164.0 |
| 2009-09-30 19:30:00 | AAPL | Stock | 6.6254 | 6.6375 | 6.6254 | 6.6375 | 65688.0 |
| 2009-09-30 06:00:00 | MSFT | Stock | 25.88 | 25.88 | 25.88 | 25.88 | 290.0 |
| 2009-09-30 07:30:00 | MSFT | Stock | 25.79 | 25.79 | 25.79 | 25.79 | 390.0 |
| 2009-09-30 08:00:00 | MSFT | Stock | 25.8 | 25.8 | 25.77 | 25.77 | 1800.0 |
| 2009-09-30 08:30:00 | MSFT | Stock | 25.84 | 25.88 | 25.83 | 25.88 | 2654.0 |
| 2009-09-30 09:00:00 | MSFT | Stock | 25.87 | 25.89 | 25.74 | 25.74 | 23344.0 |
| 2009-09-30 09:30:00 | MSFT | Stock | 25.76 | 25.88 | 25.38 | 25.46 | 7418619.0 |
| 2009-09-30 10:00:00 | MSFT | Stock | 25.45 | 25.57 | 25.43 | 25.48 | 5668355.0 |
| 2009-09-30 10:30:00 | MSFT | Stock | 25.485 | 25.57 | 25.46 | 25.485 | 4717477.0 |
| 2009-09-30 11:00:00 | MSFT | Stock | 25.48 | 25.57 | 25.47 | 25.56 | 2371995.0 |
| 2009-09-30 11:30:00 | MSFT | Stock | 25.56 | 25.61 | 25.5 | 25.573 | 1707044.0 |
| 2009-09-30 12:00:00 | MSFT | Stock | 25.57 | 25.74 | 25.555 | 25.711 | 2159965.0 |
| 2009-09-30 12:30:00 | MSFT | Stock | 25.72 | 25.93 | 25.71 | 25.88 | 3434053.0 |
| 2009-09-30 13:00:00 | MSFT | Stock | 25.88 | 25.99 | 25.88 | 25.97 | 3716429.0 |
| 2009-09-30 13:30:00 | MSFT | Stock | 25.96 | 25.99 | 25.91 | 25.96 | 2638661.0 |
| 2009-09-30 14:00:00 | MSFT | Stock | 25.96 | 25.98 | 25.93 | 25.95 | 1598870.0 |
| 2009-09-30 14:30:00 | MSFT | Stock | 25.95 | 25.96 | 25.86 | 25.87 | 3382049.0 |
| 2009-09-30 15:00:00 | MSFT | Stock | 25.87 | 25.87 | 25.69 | 25.695 | 5072075.0 |
| 2009-09-30 15:30:00 | MSFT | Stock | 25.69 | 25.83 | 25.69 | 25.81 | 9360396.0 |
| 2009-09-30 16:00:00 | MSFT | Stock | 25.81 | 25.95 | 25.7 | 25.896 | 6111575.0 |
| 2009-09-30 16:30:00 | MSFT | Stock | 25.89 | 25.911 | 25.8 | 25.89 | 336814.0 |
| 2009-09-30 17:00:00 | MSFT | Stock | 25.83 | 25.84 | 25.83 | 25.84 | 500.0 |
| 2009-09-30 17:30:00 | MSFT | Stock | 25.8 | 25.84 | 25.8 | 25.84 | 1527.0 |
> showing 50 of 75,147 rows — these rows as CSV