PREVIEW / stock_30min / 2008-05-16
file: by_date/stock_30min/2008/2008-05-16.parquet size: 1.3 MB rows: 69,041 symbols: 3,290
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-16 05:30:00 | AAPL | Stock | 6.7857 | 6.79 | 6.7857 | 6.79 | 28000.0 |
| 2008-05-16 07:00:00 | AAPL | Stock | 6.8089 | 6.8089 | 6.7857 | 6.7893 | 266000.0 |
| 2008-05-16 07:30:00 | AAPL | Stock | 6.7893 | 6.7957 | 6.7811 | 6.7811 | 99680.0 |
| 2008-05-16 08:00:00 | AAPL | Stock | 6.7786 | 6.7929 | 6.7625 | 6.7786 | 1383956.0 |
| 2008-05-16 08:30:00 | AAPL | Stock | 6.7786 | 6.8018 | 6.7775 | 6.7996 | 1936088.0 |
| 2008-05-16 09:00:00 | AAPL | Stock | 6.7986 | 6.7986 | 6.7714 | 6.7914 | 2909956.0 |
| 2008-05-16 09:30:00 | AAPL | Stock | 6.7918 | 6.7964 | 6.745 | 6.7771 | 134932588.0 |
| 2008-05-16 10:00:00 | AAPL | Stock | 6.7771 | 6.7839 | 6.6896 | 6.7146 | 90006868.0 |
| 2008-05-16 10:30:00 | AAPL | Stock | 6.7157 | 6.7464 | 6.7054 | 6.7129 | 57286040.0 |
| 2008-05-16 11:00:00 | AAPL | Stock | 6.7129 | 6.7136 | 6.6786 | 6.7007 | 57664824.0 |
| 2008-05-16 11:30:00 | AAPL | Stock | 6.7007 | 6.7382 | 6.6966 | 6.7264 | 46800124.0 |
| 2008-05-16 12:00:00 | AAPL | Stock | 6.7269 | 6.7375 | 6.7161 | 6.7346 | 24802904.0 |
| 2008-05-16 12:30:00 | AAPL | Stock | 6.735 | 6.7489 | 6.7261 | 6.7446 | 30017092.0 |
| 2008-05-16 13:00:00 | AAPL | Stock | 6.7439 | 6.7468 | 6.7186 | 6.7296 | 32830784.0 |
| 2008-05-16 13:30:00 | AAPL | Stock | 6.7289 | 6.7293 | 6.6936 | 6.7143 | 40505836.0 |
| 2008-05-16 14:00:00 | AAPL | Stock | 6.7143 | 6.7314 | 6.7025 | 6.7182 | 36676864.0 |
| 2008-05-16 14:30:00 | AAPL | Stock | 6.7179 | 6.7225 | 6.7057 | 6.7068 | 42718256.0 |
| 2008-05-16 15:00:00 | AAPL | Stock | 6.7061 | 6.7271 | 6.6968 | 6.7139 | 62686708.0 |
| 2008-05-16 15:30:00 | AAPL | Stock | 6.7143 | 6.7161 | 6.6929 | 6.7029 | 78209404.0 |
| 2008-05-16 16:00:00 | AAPL | Stock | 6.7025 | 6.7306 | 6.3411 | 6.7054 | 9167172.0 |
| 2008-05-16 16:30:00 | AAPL | Stock | 6.7054 | 6.7061 | 6.7004 | 6.7054 | 287112.0 |
| 2008-05-16 17:00:00 | AAPL | Stock | 6.7264 | 6.7264 | 6.7043 | 6.7043 | 88228.0 |
| 2008-05-16 17:30:00 | AAPL | Stock | 6.7071 | 6.7089 | 6.7 | 6.7054 | 165844.0 |
| 2008-05-16 18:00:00 | AAPL | Stock | 6.7054 | 6.7082 | 6.7018 | 6.7039 | 178640.0 |
| 2008-05-16 18:30:00 | AAPL | Stock | 6.705 | 6.705 | 6.6964 | 6.6964 | 255360.0 |
| 2008-05-16 19:00:00 | AAPL | Stock | 6.7029 | 6.7029 | 6.6911 | 6.6929 | 44604.0 |
| 2008-05-16 19:30:00 | AAPL | Stock | 6.6989 | 6.7082 | 6.6989 | 6.7082 | 101444.0 |
| 2008-05-16 08:00:00 | MSFT | Stock | 30.45 | 30.45 | 30.36 | 30.38 | 3042.0 |
| 2008-05-16 08:30:00 | MSFT | Stock | 30.38 | 30.42 | 30.38 | 30.42 | 3318.0 |
| 2008-05-16 09:00:00 | MSFT | Stock | 30.42 | 30.5 | 30.38 | 30.49 | 36674.0 |
| 2008-05-16 09:30:00 | MSFT | Stock | 30.46 | 30.5 | 30.09 | 30.12 | 12938746.0 |
| 2008-05-16 10:00:00 | MSFT | Stock | 30.12 | 30.23 | 30.04 | 30.12 | 5623987.0 |
| 2008-05-16 10:30:00 | MSFT | Stock | 30.12 | 30.22 | 30.06 | 30.08 | 5181093.0 |
| 2008-05-16 11:00:00 | MSFT | Stock | 30.08 | 30.21 | 30.0 | 30.13 | 4475181.0 |
| 2008-05-16 11:30:00 | MSFT | Stock | 30.13 | 30.18 | 30.05 | 30.05 | 3632272.0 |
| 2008-05-16 12:00:00 | MSFT | Stock | 30.05 | 30.07 | 30.01 | 30.04 | 4389394.0 |
| 2008-05-16 12:30:00 | MSFT | Stock | 30.03 | 30.105 | 30.0 | 30.05 | 6454984.0 |
| 2008-05-16 13:00:00 | MSFT | Stock | 30.05 | 30.08 | 30.02 | 30.025 | 3721285.0 |
| 2008-05-16 13:30:00 | MSFT | Stock | 30.02 | 30.03 | 29.965 | 29.971 | 6325385.0 |
| 2008-05-16 14:00:00 | MSFT | Stock | 29.97 | 30.01 | 29.92 | 29.97 | 5785827.0 |
| 2008-05-16 14:30:00 | MSFT | Stock | 29.97 | 30.01 | 29.96 | 29.98 | 3532898.0 |
| 2008-05-16 15:00:00 | MSFT | Stock | 29.99 | 30.02 | 29.96 | 29.98 | 5876308.0 |
| 2008-05-16 15:30:00 | MSFT | Stock | 29.97 | 30.04 | 29.95 | 30.0 | 8065606.0 |
| 2008-05-16 16:00:00 | MSFT | Stock | 30.0 | 30.15 | 29.95 | 30.0 | 2908367.0 |
| 2008-05-16 16:30:00 | MSFT | Stock | 30.0 | 30.0 | 29.9 | 29.99 | 137639.0 |
| 2008-05-16 17:00:00 | MSFT | Stock | 29.98 | 30.04 | 29.93 | 30.03 | 6100.0 |
| 2008-05-16 17:30:00 | MSFT | Stock | 30.01 | 30.02 | 30.01 | 30.02 | 4796.0 |
| 2008-05-16 18:00:00 | MSFT | Stock | 30.03 | 30.03 | 29.96 | 29.96 | 3260.0 |
| 2008-05-16 18:30:00 | MSFT | Stock | 29.98 | 29.98 | 29.98 | 29.98 | 100.0 |
| 2008-05-16 19:00:00 | MSFT | Stock | 30.02 | 30.02 | 29.98 | 29.98 | 680.0 |
> showing 50 of 69,041 rows — these rows as CSV