PREVIEW / stock_30min / 2009-06-26
file: by_date/stock_30min/2009/2009-06-26.parquet size: 1.5 MB rows: 78,896 symbols: 3,328
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-06-26 07:00:00 | AAPL | Stock | 4.9907 | 4.9907 | 4.9789 | 4.9789 | 47180.0 |
| 2009-06-26 07:30:00 | AAPL | Stock | 4.9821 | 4.9821 | 4.9821 | 4.9821 | 32900.0 |
| 2009-06-26 08:00:00 | AAPL | Stock | 4.9861 | 4.9893 | 4.9821 | 4.9893 | 138292.0 |
| 2009-06-26 08:30:00 | AAPL | Stock | 4.9893 | 5.0071 | 4.9893 | 4.9932 | 1061536.0 |
| 2009-06-26 09:00:00 | AAPL | Stock | 4.9975 | 4.9993 | 4.9857 | 4.9857 | 300272.0 |
| 2009-06-26 09:30:00 | AAPL | Stock | 4.9925 | 5.0782 | 4.9907 | 5.0604 | 96014968.0 |
| 2009-06-26 10:00:00 | AAPL | Stock | 5.0589 | 5.0732 | 5.0421 | 5.0621 | 41247696.0 |
| 2009-06-26 10:30:00 | AAPL | Stock | 5.0624 | 5.0661 | 5.0536 | 5.0596 | 24552640.0 |
| 2009-06-26 11:00:00 | AAPL | Stock | 5.0596 | 5.0639 | 5.0504 | 5.0604 | 18035556.0 |
| 2009-06-26 11:30:00 | AAPL | Stock | 5.06 | 5.0768 | 5.06 | 5.0714 | 20889820.0 |
| 2009-06-26 12:00:00 | AAPL | Stock | 5.0714 | 5.0825 | 5.0664 | 5.0704 | 18807264.0 |
| 2009-06-26 12:30:00 | AAPL | Stock | 5.0704 | 5.0821 | 5.0625 | 5.0721 | 19751060.0 |
| 2009-06-26 13:00:00 | AAPL | Stock | 5.0721 | 5.0768 | 5.0657 | 5.0743 | 12914608.0 |
| 2009-06-26 13:30:00 | AAPL | Stock | 5.0742 | 5.0804 | 5.0714 | 5.0764 | 16584988.0 |
| 2009-06-26 14:00:00 | AAPL | Stock | 5.0768 | 5.08 | 5.075 | 5.0786 | 12757976.0 |
| 2009-06-26 14:30:00 | AAPL | Stock | 5.0786 | 5.0893 | 5.0764 | 5.0886 | 20781404.0 |
| 2009-06-26 15:00:00 | AAPL | Stock | 5.0886 | 5.0929 | 5.0807 | 5.0861 | 29234660.0 |
| 2009-06-26 15:30:00 | AAPL | Stock | 5.0857 | 5.1271 | 5.0729 | 5.0893 | 46776184.0 |
| 2009-06-26 16:00:00 | AAPL | Stock | 5.0843 | 5.1071 | 5.0641 | 5.0857 | 29539832.0 |
| 2009-06-26 16:30:00 | AAPL | Stock | 5.0857 | 5.0914 | 5.0768 | 5.0827 | 6950524.0 |
| 2009-06-26 17:00:00 | AAPL | Stock | 5.0832 | 5.0921 | 5.0832 | 5.0852 | 2880920.0 |
| 2009-06-26 17:30:00 | AAPL | Stock | 5.0852 | 5.0964 | 5.0852 | 5.0964 | 688268.0 |
| 2009-06-26 18:00:00 | AAPL | Stock | 5.0871 | 5.0914 | 5.0871 | 5.0914 | 943264.0 |
| 2009-06-26 18:30:00 | AAPL | Stock | 5.0914 | 5.0914 | 5.0893 | 5.0893 | 30800.0 |
| 2009-06-26 19:00:00 | AAPL | Stock | 5.0964 | 5.0964 | 5.0964 | 5.0964 | 2800.0 |
| 2009-06-26 19:30:00 | AAPL | Stock | 5.0943 | 5.0957 | 5.0911 | 5.0929 | 54600.0 |
| 2009-06-26 08:00:00 | MSFT | Stock | 23.75 | 23.86 | 23.71 | 23.85 | 4859.0 |
| 2009-06-26 08:30:00 | MSFT | Stock | 23.8 | 23.8 | 23.72 | 23.75 | 12593.0 |
| 2009-06-26 09:00:00 | MSFT | Stock | 23.71 | 23.71 | 23.52 | 23.53 | 50672.0 |
| 2009-06-26 09:30:00 | MSFT | Stock | 23.58 | 23.69 | 23.44 | 23.52 | 5210159.0 |
| 2009-06-26 10:00:00 | MSFT | Stock | 23.52 | 23.62 | 23.48 | 23.57 | 3447634.0 |
| 2009-06-26 10:30:00 | MSFT | Stock | 23.57 | 23.63 | 23.53 | 23.55 | 4204578.0 |
| 2009-06-26 11:00:00 | MSFT | Stock | 23.54 | 23.56 | 23.46 | 23.465 | 2841200.0 |
| 2009-06-26 11:30:00 | MSFT | Stock | 23.46 | 23.53 | 23.45 | 23.53 | 2005280.0 |
| 2009-06-26 12:00:00 | MSFT | Stock | 23.52 | 23.58 | 23.52 | 23.56 | 1754056.0 |
| 2009-06-26 12:30:00 | MSFT | Stock | 23.56 | 23.6 | 23.52 | 23.548 | 1675591.0 |
| 2009-06-26 13:00:00 | MSFT | Stock | 23.548 | 23.55 | 23.42 | 23.45 | 2291165.0 |
| 2009-06-26 13:30:00 | MSFT | Stock | 23.452 | 23.47 | 23.41 | 23.45 | 5165489.0 |
| 2009-06-26 14:00:00 | MSFT | Stock | 23.44 | 23.45 | 23.39 | 23.42 | 2326026.0 |
| 2009-06-26 14:30:00 | MSFT | Stock | 23.41 | 23.44 | 23.4 | 23.44 | 2026998.0 |
| 2009-06-26 15:00:00 | MSFT | Stock | 23.435 | 23.46 | 23.36 | 23.36 | 3963507.0 |
| 2009-06-26 15:30:00 | MSFT | Stock | 23.36 | 23.41 | 23.32 | 23.35 | 9192514.0 |
| 2009-06-26 16:00:00 | MSFT | Stock | 23.35 | 23.97 | 23.34 | 23.37 | 10881165.0 |
| 2009-06-26 16:30:00 | MSFT | Stock | 23.37 | 23.55 | 23.356 | 23.48 | 3600227.0 |
| 2009-06-26 17:00:00 | MSFT | Stock | 23.382 | 23.55 | 23.37 | 23.42 | 1480351.0 |
| 2009-06-26 17:30:00 | MSFT | Stock | 23.368 | 23.49 | 23.368 | 23.45 | 207329.0 |
| 2009-06-26 18:00:00 | MSFT | Stock | 23.35 | 23.35 | 23.35 | 23.35 | 13920.0 |
| 2009-06-26 18:30:00 | MSFT | Stock | 23.45 | 23.45 | 23.45 | 23.45 | 500.0 |
| 2009-06-26 19:00:00 | MSFT | Stock | 23.45 | 23.45 | 23.45 | 23.45 | 320.0 |
| 2009-06-26 19:30:00 | MSFT | Stock | 23.43 | 23.45 | 23.4 | 23.45 | 12016.0 |
> showing 50 of 78,896 rows — these rows as CSV