PREVIEW / stock_30min / 2008-12-11
file: by_date/stock_30min/2008/2008-12-11.parquet size: 1.2 MB rows: 69,545 symbols: 3,342
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-12-11 08:00:00 | AAPL | Stock | 3.5043 | 3.5054 | 3.4793 | 3.4825 | 168560.0 |
| 2008-12-11 08:30:00 | AAPL | Stock | 3.4789 | 3.4961 | 3.4675 | 3.4686 | 658308.0 |
| 2008-12-11 09:00:00 | AAPL | Stock | 3.4679 | 3.4825 | 3.4679 | 3.4696 | 822136.0 |
| 2008-12-11 09:30:00 | AAPL | Stock | 3.4704 | 3.5082 | 3.4207 | 3.5029 | 101263204.0 |
| 2008-12-11 10:00:00 | AAPL | Stock | 3.5032 | 3.5696 | 3.5007 | 3.5639 | 115269140.0 |
| 2008-12-11 10:30:00 | AAPL | Stock | 3.5636 | 3.5936 | 3.5475 | 3.5668 | 94519460.0 |
| 2008-12-11 11:00:00 | AAPL | Stock | 3.5657 | 3.5946 | 3.55 | 3.5618 | 61620468.0 |
| 2008-12-11 11:30:00 | AAPL | Stock | 3.5614 | 3.5875 | 3.5596 | 3.5846 | 45785432.0 |
| 2008-12-11 12:00:00 | AAPL | Stock | 3.5854 | 3.6157 | 3.5793 | 3.5821 | 56665784.0 |
| 2008-12-11 12:30:00 | AAPL | Stock | 3.583 | 3.6018 | 3.5771 | 3.5875 | 37539040.0 |
| 2008-12-11 13:00:00 | AAPL | Stock | 3.5875 | 3.5893 | 3.5461 | 3.5493 | 39845540.0 |
| 2008-12-11 13:30:00 | AAPL | Stock | 3.55 | 3.5679 | 3.5357 | 3.5396 | 37429644.0 |
| 2008-12-11 14:00:00 | AAPL | Stock | 3.5407 | 3.5493 | 3.5014 | 3.5089 | 54936224.0 |
| 2008-12-11 14:30:00 | AAPL | Stock | 3.5093 | 3.5154 | 3.4121 | 3.4214 | 106743084.0 |
| 2008-12-11 15:00:00 | AAPL | Stock | 3.4221 | 3.4289 | 3.3868 | 3.4218 | 131317088.0 |
| 2008-12-11 15:30:00 | AAPL | Stock | 3.4218 | 3.4264 | 3.3893 | 3.3936 | 120071308.0 |
| 2008-12-11 16:00:00 | AAPL | Stock | 3.3936 | 3.5145 | 3.3921 | 3.3936 | 21038836.0 |
| 2008-12-11 16:30:00 | AAPL | Stock | 3.3943 | 3.3964 | 3.3821 | 3.3839 | 10352412.0 |
| 2008-12-11 17:00:00 | AAPL | Stock | 3.3857 | 3.3857 | 3.3704 | 3.3821 | 711732.0 |
| 2008-12-11 17:30:00 | AAPL | Stock | 3.3818 | 3.3929 | 3.3786 | 3.3821 | 149240.0 |
| 2008-12-11 18:00:00 | AAPL | Stock | 3.3839 | 3.3929 | 3.3768 | 3.3804 | 1611400.0 |
| 2008-12-11 18:30:00 | AAPL | Stock | 3.3832 | 3.3836 | 3.3771 | 3.3807 | 241976.0 |
| 2008-12-11 19:00:00 | AAPL | Stock | 3.3768 | 3.3804 | 3.3586 | 3.3646 | 449260.0 |
| 2008-12-11 19:30:00 | AAPL | Stock | 3.3607 | 3.3607 | 3.35 | 3.3571 | 406196.0 |
| 2008-12-11 06:30:00 | MSFT | Stock | 20.61 | 20.61 | 20.61 | 20.61 | 300.0 |
| 2008-12-11 07:00:00 | MSFT | Stock | 20.61 | 20.61 | 20.46 | 20.46 | 5363.0 |
| 2008-12-11 07:30:00 | MSFT | Stock | 20.4 | 20.4 | 20.4 | 20.4 | 398.0 |
| 2008-12-11 08:00:00 | MSFT | Stock | 20.52 | 20.52 | 20.32 | 20.35 | 28272.0 |
| 2008-12-11 08:30:00 | MSFT | Stock | 20.35 | 20.35 | 20.22 | 20.24 | 43102.0 |
| 2008-12-11 09:00:00 | MSFT | Stock | 20.24 | 20.3 | 20.08 | 20.1 | 86752.0 |
| 2008-12-11 09:30:00 | MSFT | Stock | 20.1 | 20.12 | 19.74 | 19.98 | 8632918.0 |
| 2008-12-11 10:00:00 | MSFT | Stock | 19.99 | 20.07 | 19.91 | 20.0 | 7626932.0 |
| 2008-12-11 10:30:00 | MSFT | Stock | 20.0 | 20.05 | 19.82 | 19.87 | 4883593.0 |
| 2008-12-11 11:00:00 | MSFT | Stock | 19.87 | 20.0 | 19.82 | 19.88 | 4208810.0 |
| 2008-12-11 11:30:00 | MSFT | Stock | 19.88 | 19.97 | 19.77 | 19.96 | 3023785.0 |
| 2008-12-11 12:00:00 | MSFT | Stock | 19.96 | 20.02 | 19.84 | 19.881 | 3009814.0 |
| 2008-12-11 12:30:00 | MSFT | Stock | 19.888 | 19.94 | 19.78 | 19.88 | 3498975.0 |
| 2008-12-11 13:00:00 | MSFT | Stock | 19.87 | 19.89 | 19.7 | 19.74 | 5014570.0 |
| 2008-12-11 13:30:00 | MSFT | Stock | 19.75 | 19.86 | 19.68 | 19.7 | 4509943.0 |
| 2008-12-11 14:00:00 | MSFT | Stock | 19.7 | 19.79 | 19.65 | 19.68 | 2809931.0 |
| 2008-12-11 14:30:00 | MSFT | Stock | 19.69 | 19.74 | 19.49 | 19.53 | 6040526.0 |
| 2008-12-11 15:00:00 | MSFT | Stock | 19.528 | 19.85 | 19.32 | 19.54 | 7730729.0 |
| 2008-12-11 15:30:00 | MSFT | Stock | 19.54 | 19.58 | 19.31 | 19.51 | 12107803.0 |
| 2008-12-11 16:00:00 | MSFT | Stock | 19.45 | 19.752 | 19.44 | 19.45 | 7416331.0 |
| 2008-12-11 16:30:00 | MSFT | Stock | 19.45 | 19.975 | 19.3 | 19.4 | 1395781.0 |
| 2008-12-11 17:00:00 | MSFT | Stock | 19.4 | 19.45 | 19.35 | 19.37 | 17056.0 |
| 2008-12-11 17:30:00 | MSFT | Stock | 19.4 | 19.45 | 19.39 | 19.39 | 32220.0 |
| 2008-12-11 18:00:00 | MSFT | Stock | 19.38 | 19.41 | 19.37 | 19.4 | 8820.0 |
| 2008-12-11 18:30:00 | MSFT | Stock | 19.4 | 19.4 | 19.31 | 19.31 | 29226.0 |
| 2008-12-11 19:00:00 | MSFT | Stock | 19.37 | 19.38 | 19.31 | 19.35 | 7360.0 |
> showing 50 of 69,545 rows — these rows as CSV