PREVIEW / stock_30min / 2008-05-05
file: by_date/stock_30min/2008/2008-05-05.parquet size: 1.2 MB rows: 68,864 symbols: 3,288
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-05 05:00:00 | AAPL | Stock | 6.4114 | 6.4114 | 6.4114 | 6.4114 | 13300.0 |
| 2008-05-05 06:30:00 | AAPL | Stock | 6.4586 | 6.4586 | 6.4586 | 6.4586 | 2800.0 |
| 2008-05-05 07:00:00 | AAPL | Stock | 6.4461 | 6.4461 | 6.4214 | 6.4286 | 36400.0 |
| 2008-05-05 07:30:00 | AAPL | Stock | 6.4321 | 6.445 | 6.4286 | 6.4421 | 157024.0 |
| 2008-05-05 08:00:00 | AAPL | Stock | 6.4375 | 6.4693 | 6.4371 | 6.4621 | 1049608.0 |
| 2008-05-05 08:30:00 | AAPL | Stock | 6.4632 | 6.4846 | 6.4536 | 6.4821 | 1909320.0 |
| 2008-05-05 09:00:00 | AAPL | Stock | 6.4807 | 6.5179 | 6.4621 | 6.4964 | 6007204.0 |
| 2008-05-05 09:30:00 | AAPL | Stock | 6.4979 | 6.5818 | 6.4661 | 6.5643 | 148498336.0 |
| 2008-05-05 10:00:00 | AAPL | Stock | 6.5639 | 6.6182 | 6.5629 | 6.5736 | 131239500.0 |
| 2008-05-05 10:30:00 | AAPL | Stock | 6.5729 | 6.6086 | 6.5646 | 6.5836 | 73678416.0 |
| 2008-05-05 11:00:00 | AAPL | Stock | 6.5832 | 6.5964 | 6.5643 | 6.5739 | 49377272.0 |
| 2008-05-05 11:30:00 | AAPL | Stock | 6.5743 | 6.5982 | 6.5714 | 6.5943 | 36721384.0 |
| 2008-05-05 12:00:00 | AAPL | Stock | 6.5946 | 6.615 | 6.5764 | 6.5874 | 41389292.0 |
| 2008-05-05 12:30:00 | AAPL | Stock | 6.5875 | 6.5982 | 6.5796 | 6.5861 | 21209580.0 |
| 2008-05-05 13:00:00 | AAPL | Stock | 6.586 | 6.5893 | 6.5386 | 6.5461 | 44936164.0 |
| 2008-05-05 13:30:00 | AAPL | Stock | 6.5454 | 6.56 | 6.52 | 6.5414 | 57365784.0 |
| 2008-05-05 14:00:00 | AAPL | Stock | 6.5414 | 6.5786 | 6.5332 | 6.5768 | 42206248.0 |
| 2008-05-05 14:30:00 | AAPL | Stock | 6.5768 | 6.5971 | 6.5714 | 6.5749 | 49029988.0 |
| 2008-05-05 15:00:00 | AAPL | Stock | 6.5746 | 6.5861 | 6.5482 | 6.5675 | 56548604.0 |
| 2008-05-05 15:30:00 | AAPL | Stock | 6.5671 | 6.5986 | 6.5618 | 6.5896 | 67948244.0 |
| 2008-05-05 16:00:00 | AAPL | Stock | 6.5907 | 6.5975 | 6.5679 | 6.5821 | 12789728.0 |
| 2008-05-05 16:30:00 | AAPL | Stock | 6.5821 | 6.5975 | 6.5621 | 6.5886 | 341180.0 |
| 2008-05-05 17:00:00 | AAPL | Stock | 6.5918 | 6.5918 | 6.5857 | 6.5864 | 63448.0 |
| 2008-05-05 17:30:00 | AAPL | Stock | 6.4621 | 6.5971 | 6.4621 | 6.5893 | 593656.0 |
| 2008-05-05 18:00:00 | AAPL | Stock | 6.5918 | 6.5925 | 6.5882 | 6.5925 | 42504.0 |
| 2008-05-05 18:30:00 | AAPL | Stock | 6.5925 | 6.5929 | 6.5925 | 6.5929 | 37100.0 |
| 2008-05-05 19:00:00 | AAPL | Stock | 6.5925 | 6.5925 | 6.5893 | 6.5918 | 69160.0 |
| 2008-05-05 19:30:00 | AAPL | Stock | 6.5925 | 6.5929 | 6.5911 | 6.5929 | 119252.0 |
| 2008-05-05 20:00:00 | AAPL | Stock | 6.5604 | 6.5604 | 6.5604 | 6.5604 | 424536.0 |
| 2008-05-05 04:00:00 | MSFT | Stock | 30.4 | 30.5 | 30.25 | 30.5 | 7254.0 |
| 2008-05-05 04:30:00 | MSFT | Stock | 30.3 | 30.3 | 30.3 | 30.3 | 17000.0 |
| 2008-05-05 05:00:00 | MSFT | Stock | 30.3 | 30.5 | 30.3 | 30.5 | 19922.0 |
| 2008-05-05 05:30:00 | MSFT | Stock | 30.25 | 30.25 | 30.25 | 30.25 | 2805.0 |
| 2008-05-05 06:00:00 | MSFT | Stock | 30.45 | 30.51 | 30.35 | 30.51 | 10970.0 |
| 2008-05-05 06:30:00 | MSFT | Stock | 30.55 | 31.13 | 30.55 | 30.9 | 105788.0 |
| 2008-05-05 07:00:00 | MSFT | Stock | 30.9 | 31.0 | 30.4 | 30.6 | 754754.0 |
| 2008-05-05 07:30:00 | MSFT | Stock | 30.58 | 30.86 | 30.45 | 30.6 | 997109.0 |
| 2008-05-05 08:00:00 | MSFT | Stock | 30.55 | 31.0 | 29.8 | 29.97 | 4279023.0 |
| 2008-05-05 08:30:00 | MSFT | Stock | 29.98 | 30.0 | 29.77 | 29.9 | 2644220.0 |
| 2008-05-05 09:00:00 | MSFT | Stock | 29.9 | 30.07 | 29.24 | 29.92 | 2531153.0 |
| 2008-05-05 09:30:00 | MSFT | Stock | 29.92 | 30.23 | 29.86 | 29.92 | 18226912.0 |
| 2008-05-05 10:00:00 | MSFT | Stock | 29.91 | 30.06 | 29.79 | 29.84 | 11305136.0 |
| 2008-05-05 10:30:00 | MSFT | Stock | 29.84 | 30.05 | 29.8 | 29.847 | 6626301.0 |
| 2008-05-05 11:00:00 | MSFT | Stock | 29.85 | 29.95 | 29.75 | 29.76 | 6108914.0 |
| 2008-05-05 11:30:00 | MSFT | Stock | 29.76 | 29.81 | 29.625 | 29.69 | 5404109.0 |
| 2008-05-05 12:00:00 | MSFT | Stock | 29.69 | 29.72 | 29.32 | 29.45 | 8594052.0 |
| 2008-05-05 12:30:00 | MSFT | Stock | 29.45 | 29.52 | 29.37 | 29.44 | 4378271.0 |
| 2008-05-05 13:00:00 | MSFT | Stock | 29.44 | 29.445 | 29.24 | 29.28 | 4362238.0 |
| 2008-05-05 13:30:00 | MSFT | Stock | 29.27 | 29.33 | 29.22 | 29.305 | 6013729.0 |
| 2008-05-05 14:00:00 | MSFT | Stock | 29.3 | 29.41 | 29.21 | 29.24 | 5863475.0 |
> showing 50 of 68,864 rows — these rows as CSV