PREVIEW / stock_30min / 2009-12-29
file: by_date/stock_30min/2009/2009-12-29.parquet size: 1.3 MB rows: 71,552 symbols: 3,467
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-29 04:00:00 | AAPL | Stock | 7.5714 | 7.5714 | 7.5714 | 7.5714 | 5600.0 |
| 2009-12-29 05:00:00 | AAPL | Stock | 7.5714 | 7.5714 | 7.5714 | 7.5714 | 2800.0 |
| 2009-12-29 05:30:00 | AAPL | Stock | 7.575 | 7.575 | 7.5714 | 7.5714 | 5600.0 |
| 2009-12-29 06:00:00 | AAPL | Stock | 7.5707 | 7.5707 | 7.5707 | 7.5707 | 2800.0 |
| 2009-12-29 07:00:00 | AAPL | Stock | 7.5836 | 7.5836 | 7.5814 | 7.5814 | 22400.0 |
| 2009-12-29 07:30:00 | AAPL | Stock | 7.5782 | 7.5993 | 7.5782 | 7.5929 | 56140.0 |
| 2009-12-29 08:00:00 | AAPL | Stock | 7.5893 | 7.6036 | 7.5812 | 7.5889 | 1965740.0 |
| 2009-12-29 08:30:00 | AAPL | Stock | 7.5857 | 7.5911 | 7.5804 | 7.5821 | 871556.0 |
| 2009-12-29 09:00:00 | AAPL | Stock | 7.5814 | 7.5957 | 7.5771 | 7.5957 | 1416716.0 |
| 2009-12-29 09:30:00 | AAPL | Stock | 7.5925 | 7.5971 | 7.5243 | 7.5479 | 80768660.0 |
| 2009-12-29 10:00:00 | AAPL | Stock | 7.5479 | 7.5511 | 7.5007 | 7.5307 | 45802568.0 |
| 2009-12-29 10:30:00 | AAPL | Stock | 7.5304 | 7.5479 | 7.5232 | 7.5268 | 30621948.0 |
| 2009-12-29 11:00:00 | AAPL | Stock | 7.5261 | 7.5321 | 7.4789 | 7.485 | 38807328.0 |
| 2009-12-29 11:30:00 | AAPL | Stock | 7.4843 | 7.5068 | 7.4839 | 7.495 | 21903784.0 |
| 2009-12-29 12:00:00 | AAPL | Stock | 7.4946 | 7.4968 | 7.4629 | 7.4714 | 35623224.0 |
| 2009-12-29 12:30:00 | AAPL | Stock | 7.4709 | 7.4875 | 7.4629 | 7.4748 | 18983076.0 |
| 2009-12-29 13:00:00 | AAPL | Stock | 7.4746 | 7.4807 | 7.4654 | 7.4789 | 10988908.0 |
| 2009-12-29 13:30:00 | AAPL | Stock | 7.4789 | 7.5139 | 7.4761 | 7.5014 | 25944128.0 |
| 2009-12-29 14:00:00 | AAPL | Stock | 7.5021 | 7.5025 | 7.4832 | 7.4918 | 18495008.0 |
| 2009-12-29 14:30:00 | AAPL | Stock | 7.4921 | 7.5029 | 7.4732 | 7.4814 | 19374292.0 |
| 2009-12-29 15:00:00 | AAPL | Stock | 7.4804 | 7.4993 | 7.4804 | 7.4989 | 17745700.0 |
| 2009-12-29 15:30:00 | AAPL | Stock | 7.4989 | 7.4989 | 7.4546 | 7.4668 | 51631860.0 |
| 2009-12-29 16:00:00 | AAPL | Stock | 7.4679 | 7.5492 | 7.4604 | 7.4654 | 6375852.0 |
| 2009-12-29 16:30:00 | AAPL | Stock | 7.4643 | 7.4661 | 7.4625 | 7.4657 | 126896.0 |
| 2009-12-29 17:00:00 | AAPL | Stock | 7.4657 | 7.4693 | 7.4643 | 7.4693 | 205100.0 |
| 2009-12-29 17:30:00 | AAPL | Stock | 7.4679 | 7.4804 | 7.4646 | 7.4786 | 641648.0 |
| 2009-12-29 18:00:00 | AAPL | Stock | 7.4782 | 7.4786 | 7.4643 | 7.475 | 703500.0 |
| 2009-12-29 18:30:00 | AAPL | Stock | 7.4718 | 7.4764 | 7.4714 | 7.4764 | 144200.0 |
| 2009-12-29 19:00:00 | AAPL | Stock | 7.4775 | 7.4786 | 7.4721 | 7.4779 | 425040.0 |
| 2009-12-29 19:30:00 | AAPL | Stock | 7.4779 | 7.4779 | 7.4646 | 7.4646 | 257488.0 |
| 2009-12-29 07:00:00 | MSFT | Stock | 31.19 | 31.19 | 31.19 | 31.19 | 200.0 |
| 2009-12-29 08:00:00 | MSFT | Stock | 31.22 | 31.29 | 31.18 | 31.26 | 24858.0 |
| 2009-12-29 08:30:00 | MSFT | Stock | 31.28 | 31.28 | 31.2 | 31.2 | 5298.0 |
| 2009-12-29 09:00:00 | MSFT | Stock | 31.25 | 31.49 | 31.25 | 31.34 | 250878.0 |
| 2009-12-29 09:30:00 | MSFT | Stock | 31.35 | 31.39 | 31.23 | 31.38 | 3444176.0 |
| 2009-12-29 10:00:00 | MSFT | Stock | 31.38 | 31.39 | 31.31 | 31.38 | 1454641.0 |
| 2009-12-29 10:30:00 | MSFT | Stock | 31.385 | 31.42 | 31.26 | 31.3 | 2234866.0 |
| 2009-12-29 11:00:00 | MSFT | Stock | 31.295 | 31.34 | 31.28 | 31.32 | 1349431.0 |
| 2009-12-29 11:30:00 | MSFT | Stock | 31.325 | 31.38 | 31.32 | 31.38 | 1216953.0 |
| 2009-12-29 12:00:00 | MSFT | Stock | 31.375 | 31.4 | 31.35 | 31.36 | 1471095.0 |
| 2009-12-29 12:30:00 | MSFT | Stock | 31.37 | 31.43 | 31.36 | 31.425 | 1081123.0 |
| 2009-12-29 13:00:00 | MSFT | Stock | 31.42 | 31.43 | 31.32 | 31.38 | 1292787.0 |
| 2009-12-29 13:30:00 | MSFT | Stock | 31.37 | 31.4 | 31.37 | 31.392 | 1151589.0 |
| 2009-12-29 14:00:00 | MSFT | Stock | 31.4 | 31.45 | 31.38 | 31.44 | 2042105.0 |
| 2009-12-29 14:30:00 | MSFT | Stock | 31.45 | 31.49 | 31.44 | 31.475 | 2151436.0 |
| 2009-12-29 15:00:00 | MSFT | Stock | 31.48 | 31.5 | 31.465 | 31.48 | 2431983.0 |
| 2009-12-29 15:30:00 | MSFT | Stock | 31.485 | 31.49 | 31.38 | 31.39 | 5308210.0 |
| 2009-12-29 16:00:00 | MSFT | Stock | 31.39 | 31.416 | 31.363 | 31.38 | 1326476.0 |
| 2009-12-29 16:30:00 | MSFT | Stock | 31.38 | 31.39 | 31.38 | 31.39 | 400.0 |
| 2009-12-29 17:00:00 | MSFT | Stock | 31.16 | 31.38 | 31.024 | 31.37 | 216976.0 |
> showing 50 of 71,552 rows — these rows as CSV