PREVIEW / stock_30min / 2009-12-21
file: by_date/stock_30min/2009/2009-12-21.parquet size: 1.4 MB rows: 73,759 symbols: 3,457
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-21 05:30:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9857 | 6.9857 | 5600.0 |
| 2009-12-21 07:00:00 | AAPL | Stock | 6.9911 | 7.0243 | 6.9911 | 7.0229 | 170408.0 |
| 2009-12-21 07:30:00 | AAPL | Stock | 7.0229 | 7.0229 | 7.0129 | 7.0186 | 229684.0 |
| 2009-12-21 08:00:00 | AAPL | Stock | 7.0129 | 7.0186 | 6.9779 | 6.9929 | 2184028.0 |
| 2009-12-21 08:30:00 | AAPL | Stock | 6.9911 | 7.005 | 6.9864 | 7.0 | 1311688.0 |
| 2009-12-21 09:00:00 | AAPL | Stock | 7.0 | 7.0089 | 6.9989 | 7.0 | 1189748.0 |
| 2009-12-21 09:30:00 | AAPL | Stock | 7.0018 | 7.0604 | 6.9882 | 7.0582 | 65284072.0 |
| 2009-12-21 10:00:00 | AAPL | Stock | 7.0596 | 7.1339 | 7.0579 | 7.1066 | 81636240.0 |
| 2009-12-21 10:30:00 | AAPL | Stock | 7.1064 | 7.1121 | 7.0889 | 7.1032 | 29024688.0 |
| 2009-12-21 11:00:00 | AAPL | Stock | 7.1021 | 7.1304 | 7.0954 | 7.0964 | 28022820.0 |
| 2009-12-21 11:30:00 | AAPL | Stock | 7.0968 | 7.1075 | 7.0943 | 7.0996 | 16385572.0 |
| 2009-12-21 12:00:00 | AAPL | Stock | 7.0993 | 7.1211 | 7.095 | 7.1011 | 18331796.0 |
| 2009-12-21 12:30:00 | AAPL | Stock | 7.1004 | 7.1054 | 7.0714 | 7.0857 | 22967924.0 |
| 2009-12-21 13:00:00 | AAPL | Stock | 7.0864 | 7.0907 | 7.0671 | 7.0871 | 19776260.0 |
| 2009-12-21 13:30:00 | AAPL | Stock | 7.0871 | 7.0921 | 7.0704 | 7.0871 | 13199060.0 |
| 2009-12-21 14:00:00 | AAPL | Stock | 7.0864 | 7.1064 | 7.0779 | 7.096 | 16301880.0 |
| 2009-12-21 14:30:00 | AAPL | Stock | 7.0957 | 7.1046 | 7.0861 | 7.1017 | 14289128.0 |
| 2009-12-21 15:00:00 | AAPL | Stock | 7.1024 | 7.1024 | 7.0657 | 7.0714 | 25193084.0 |
| 2009-12-21 15:30:00 | AAPL | Stock | 7.0714 | 7.0839 | 7.0664 | 7.0796 | 35014308.0 |
| 2009-12-21 16:00:00 | AAPL | Stock | 7.0782 | 7.0826 | 6.9796 | 7.0796 | 5488980.0 |
| 2009-12-21 16:30:00 | AAPL | Stock | 7.0796 | 7.0826 | 7.0746 | 7.0796 | 101080.0 |
| 2009-12-21 17:00:00 | AAPL | Stock | 7.0793 | 7.0857 | 7.0789 | 7.0829 | 390684.0 |
| 2009-12-21 17:30:00 | AAPL | Stock | 7.0796 | 7.0837 | 7.0793 | 7.083 | 120120.0 |
| 2009-12-21 18:00:00 | AAPL | Stock | 7.0834 | 7.0839 | 6.9817 | 7.0837 | 2972340.0 |
| 2009-12-21 18:30:00 | AAPL | Stock | 7.0839 | 7.0854 | 7.08 | 7.0854 | 90468.0 |
| 2009-12-21 19:00:00 | AAPL | Stock | 7.0854 | 7.087 | 7.0654 | 7.0654 | 232204.0 |
| 2009-12-21 19:30:00 | AAPL | Stock | 7.0714 | 7.0836 | 7.0707 | 7.0836 | 151228.0 |
| 2009-12-21 07:30:00 | MSFT | Stock | 30.4 | 30.4 | 30.4 | 30.4 | 200.0 |
| 2009-12-21 08:00:00 | MSFT | Stock | 30.5 | 30.5 | 30.36 | 30.42 | 8250.0 |
| 2009-12-21 08:30:00 | MSFT | Stock | 30.38 | 30.44 | 30.36 | 30.37 | 30100.0 |
| 2009-12-21 09:00:00 | MSFT | Stock | 30.37 | 30.4 | 30.37 | 30.4 | 76050.0 |
| 2009-12-21 09:30:00 | MSFT | Stock | 30.4 | 30.52 | 30.36 | 30.46 | 6170591.0 |
| 2009-12-21 10:00:00 | MSFT | Stock | 30.47 | 30.55 | 30.45 | 30.51 | 3865316.0 |
| 2009-12-21 10:30:00 | MSFT | Stock | 30.52 | 30.56 | 30.44 | 30.47 | 2868459.0 |
| 2009-12-21 11:00:00 | MSFT | Stock | 30.48 | 30.66 | 30.47 | 30.66 | 3151115.0 |
| 2009-12-21 11:30:00 | MSFT | Stock | 30.66 | 30.74 | 30.54 | 30.74 | 3766778.0 |
| 2009-12-21 12:00:00 | MSFT | Stock | 30.74 | 30.84 | 30.72 | 30.77 | 3203536.0 |
| 2009-12-21 12:30:00 | MSFT | Stock | 30.775 | 30.79 | 30.64 | 30.71 | 2324662.0 |
| 2009-12-21 13:00:00 | MSFT | Stock | 30.715 | 30.72 | 30.56 | 30.57 | 1647048.0 |
| 2009-12-21 13:30:00 | MSFT | Stock | 30.572 | 30.6 | 30.5 | 30.57 | 1291746.0 |
| 2009-12-21 14:00:00 | MSFT | Stock | 30.58 | 30.63 | 30.53 | 30.59 | 1359709.0 |
| 2009-12-21 14:30:00 | MSFT | Stock | 30.59 | 30.62 | 30.58 | 30.601 | 1635183.0 |
| 2009-12-21 15:00:00 | MSFT | Stock | 30.605 | 30.61 | 30.48 | 30.499 | 1795102.0 |
| 2009-12-21 15:30:00 | MSFT | Stock | 30.495 | 30.57 | 30.48 | 30.56 | 3558085.0 |
| 2009-12-21 16:00:00 | MSFT | Stock | 30.56 | 30.58 | 30.36 | 30.5 | 1990575.0 |
| 2009-12-21 16:30:00 | MSFT | Stock | 30.52 | 30.577 | 30.48 | 30.577 | 15050.0 |
| 2009-12-21 17:00:00 | MSFT | Stock | 30.47 | 30.47 | 30.47 | 30.47 | 22900.0 |
| 2009-12-21 17:30:00 | MSFT | Stock | 30.48 | 30.51 | 30.48 | 30.51 | 1500.0 |
| 2009-12-21 18:00:00 | MSFT | Stock | 30.252 | 30.52 | 30.252 | 30.48 | 223240.0 |
| 2009-12-21 18:30:00 | MSFT | Stock | 30.47 | 30.47 | 30.47 | 30.47 | 100.0 |
> showing 50 of 73,759 rows — these rows as CSV