PREVIEW / stock_30min / 2009-12-30
file: by_date/stock_30min/2009/2009-12-30.parquet size: 1.3 MB rows: 73,983 symbols: 3,461
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-12-30 05:00:00 | AAPL | Stock | 7.4336 | 7.4336 | 7.4336 | 7.4336 | 8400.0 |
| 2009-12-30 06:30:00 | AAPL | Stock | 7.4289 | 7.4289 | 7.4125 | 7.4125 | 53200.0 |
| 2009-12-30 07:00:00 | AAPL | Stock | 7.4211 | 7.4275 | 7.4196 | 7.4275 | 81900.0 |
| 2009-12-30 07:30:00 | AAPL | Stock | 7.4264 | 7.4571 | 7.425 | 7.4468 | 144088.0 |
| 2009-12-30 08:00:00 | AAPL | Stock | 7.4468 | 7.4686 | 7.4461 | 7.4504 | 1565788.0 |
| 2009-12-30 08:30:00 | AAPL | Stock | 7.4504 | 7.4532 | 7.4439 | 7.4507 | 591808.0 |
| 2009-12-30 09:00:00 | AAPL | Stock | 7.4536 | 7.4639 | 7.4464 | 7.4582 | 1044848.0 |
| 2009-12-30 09:30:00 | AAPL | Stock | 7.4579 | 7.5482 | 7.4396 | 7.5239 | 96865636.0 |
| 2009-12-30 10:00:00 | AAPL | Stock | 7.5229 | 7.5357 | 7.4993 | 7.5048 | 49270172.0 |
| 2009-12-30 10:30:00 | AAPL | Stock | 7.5046 | 7.5136 | 7.4707 | 7.4925 | 36109920.0 |
| 2009-12-30 11:00:00 | AAPL | Stock | 7.4931 | 7.5057 | 7.4768 | 7.4782 | 20884864.0 |
| 2009-12-30 11:30:00 | AAPL | Stock | 7.4782 | 7.5246 | 7.4771 | 7.5132 | 21896644.0 |
| 2009-12-30 12:00:00 | AAPL | Stock | 7.5132 | 7.5318 | 7.5129 | 7.5199 | 20536208.0 |
| 2009-12-30 12:30:00 | AAPL | Stock | 7.52 | 7.5268 | 7.5071 | 7.5104 | 14195524.0 |
| 2009-12-30 13:00:00 | AAPL | Stock | 7.5107 | 7.5268 | 7.5082 | 7.5143 | 10883376.0 |
| 2009-12-30 13:30:00 | AAPL | Stock | 7.5152 | 7.5225 | 7.5089 | 7.5196 | 10608864.0 |
| 2009-12-30 14:00:00 | AAPL | Stock | 7.5196 | 7.5261 | 7.5179 | 7.5243 | 7898184.0 |
| 2009-12-30 14:30:00 | AAPL | Stock | 7.5246 | 7.5607 | 7.5243 | 7.5421 | 35274484.0 |
| 2009-12-30 15:00:00 | AAPL | Stock | 7.5421 | 7.5482 | 7.5357 | 7.5429 | 15685124.0 |
| 2009-12-30 15:30:00 | AAPL | Stock | 7.5436 | 7.5714 | 7.5425 | 7.5643 | 52633896.0 |
| 2009-12-30 16:00:00 | AAPL | Stock | 7.5671 | 7.5711 | 7.5195 | 7.5646 | 11046616.0 |
| 2009-12-30 16:30:00 | AAPL | Stock | 7.5205 | 7.5696 | 7.5205 | 7.5696 | 280336.0 |
| 2009-12-30 17:00:00 | AAPL | Stock | 7.5002 | 7.5696 | 7.5002 | 7.5661 | 219856.0 |
| 2009-12-30 17:30:00 | AAPL | Stock | 7.5661 | 7.5679 | 7.5661 | 7.5679 | 187628.0 |
| 2009-12-30 18:00:00 | AAPL | Stock | 7.5679 | 7.57 | 7.5586 | 7.5696 | 549164.0 |
| 2009-12-30 18:30:00 | AAPL | Stock | 7.57 | 7.5711 | 7.5643 | 7.565 | 211988.0 |
| 2009-12-30 19:00:00 | AAPL | Stock | 7.5654 | 7.5686 | 7.565 | 7.5679 | 55440.0 |
| 2009-12-30 19:30:00 | AAPL | Stock | 7.5654 | 7.5714 | 7.5654 | 7.5714 | 255612.0 |
| 2009-12-30 07:30:00 | MSFT | Stock | 31.34 | 31.39 | 31.34 | 31.36 | 10500.0 |
| 2009-12-30 08:00:00 | MSFT | Stock | 31.3 | 31.35 | 31.3 | 31.35 | 5248.0 |
| 2009-12-30 08:30:00 | MSFT | Stock | 31.35 | 31.35 | 31.33 | 31.33 | 6200.0 |
| 2009-12-30 09:00:00 | MSFT | Stock | 31.34 | 31.35 | 31.15 | 31.15 | 88005.0 |
| 2009-12-30 09:30:00 | MSFT | Stock | 31.18 | 31.29 | 31.1 | 31.195 | 4986476.0 |
| 2009-12-30 10:00:00 | MSFT | Stock | 31.2 | 31.26 | 31.12 | 31.12 | 2417233.0 |
| 2009-12-30 10:30:00 | MSFT | Stock | 31.13 | 31.16 | 31.0 | 31.02 | 4133853.0 |
| 2009-12-30 11:00:00 | MSFT | Stock | 31.02 | 31.2 | 30.96 | 30.97 | 4032947.0 |
| 2009-12-30 11:30:00 | MSFT | Stock | 30.965 | 31.0 | 30.93 | 30.96 | 1830440.0 |
| 2009-12-30 12:00:00 | MSFT | Stock | 30.96 | 30.98 | 30.94 | 30.98 | 1546884.0 |
| 2009-12-30 12:30:00 | MSFT | Stock | 30.98 | 31.03 | 30.97 | 30.97 | 1649604.0 |
| 2009-12-30 13:00:00 | MSFT | Stock | 30.97 | 31.0 | 30.9 | 30.905 | 1176045.0 |
| 2009-12-30 13:30:00 | MSFT | Stock | 30.91 | 30.94 | 30.82 | 30.94 | 2231244.0 |
| 2009-12-30 14:00:00 | MSFT | Stock | 30.94 | 30.95 | 30.88 | 30.88 | 1912139.0 |
| 2009-12-30 14:30:00 | MSFT | Stock | 30.88 | 30.93 | 30.85 | 30.898 | 2461593.0 |
| 2009-12-30 15:00:00 | MSFT | Stock | 30.895 | 30.9 | 30.8 | 30.875 | 3159630.0 |
| 2009-12-30 15:30:00 | MSFT | Stock | 30.87 | 31.0 | 30.83 | 30.94 | 6572630.0 |
| 2009-12-30 16:00:00 | MSFT | Stock | 30.95 | 31.007 | 30.816 | 30.984 | 2805171.0 |
| 2009-12-30 16:30:00 | MSFT | Stock | 30.984 | 30.984 | 30.93 | 30.94 | 17812.0 |
| 2009-12-30 17:00:00 | MSFT | Stock | 30.96 | 30.96 | 30.96 | 30.96 | 30421.0 |
| 2009-12-30 18:00:00 | MSFT | Stock | 30.96 | 30.96 | 30.96 | 30.96 | 300.0 |
| 2009-12-30 19:00:00 | MSFT | Stock | 30.96 | 30.96 | 30.96 | 30.96 | 200.0 |
> showing 50 of 73,983 rows — these rows as CSV