PREVIEW / stock_30min / 2010-09-16
file: by_date/stock_30min/2010/2010-09-16.parquet size: 1.3 MB rows: 73,056 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 |
|---|---|---|---|---|---|---|---|
| 2010-09-16 04:30:00 | AAPL | Stock | 9.6536 | 9.6536 | 9.6536 | 9.6536 | 5600.0 |
| 2010-09-16 06:30:00 | AAPL | Stock | 9.6782 | 9.6782 | 9.6782 | 9.6782 | 2800.0 |
| 2010-09-16 07:00:00 | AAPL | Stock | 9.6864 | 9.6864 | 9.6786 | 9.6857 | 145460.0 |
| 2010-09-16 07:30:00 | AAPL | Stock | 9.6861 | 9.6875 | 9.6714 | 9.68 | 248024.0 |
| 2010-09-16 08:00:00 | AAPL | Stock | 9.68 | 9.68 | 9.6643 | 9.6679 | 1104572.0 |
| 2010-09-16 08:30:00 | AAPL | Stock | 9.6714 | 9.6839 | 9.6532 | 9.6625 | 2874396.0 |
| 2010-09-16 09:00:00 | AAPL | Stock | 9.6618 | 9.6721 | 9.6454 | 9.6514 | 1292956.0 |
| 2010-09-16 09:30:00 | AAPL | Stock | 9.6529 | 9.6786 | 9.625 | 9.665 | 62553232.0 |
| 2010-09-16 10:00:00 | AAPL | Stock | 9.6625 | 9.6964 | 9.6411 | 9.6911 | 66752700.0 |
| 2010-09-16 10:30:00 | AAPL | Stock | 9.6911 | 9.7266 | 9.6796 | 9.7161 | 45549000.0 |
| 2010-09-16 11:00:00 | AAPL | Stock | 9.7168 | 9.7311 | 9.7043 | 9.7093 | 52497004.0 |
| 2010-09-16 11:30:00 | AAPL | Stock | 9.7093 | 9.7268 | 9.7071 | 9.7218 | 18436432.0 |
| 2010-09-16 12:00:00 | AAPL | Stock | 9.7211 | 9.73 | 9.7139 | 9.7179 | 22452052.0 |
| 2010-09-16 12:30:00 | AAPL | Stock | 9.7179 | 9.73 | 9.7164 | 9.7286 | 14277592.0 |
| 2010-09-16 13:00:00 | AAPL | Stock | 9.7271 | 9.7329 | 9.715 | 9.7211 | 17857952.0 |
| 2010-09-16 13:30:00 | AAPL | Stock | 9.7211 | 9.7268 | 9.7107 | 9.7175 | 17216668.0 |
| 2010-09-16 14:00:00 | AAPL | Stock | 9.7175 | 9.7468 | 9.7161 | 9.7456 | 27125784.0 |
| 2010-09-16 14:30:00 | AAPL | Stock | 9.745 | 9.8168 | 9.7429 | 9.815 | 93030868.0 |
| 2010-09-16 15:00:00 | AAPL | Stock | 9.8146 | 9.8536 | 9.8036 | 9.8524 | 80637620.0 |
| 2010-09-16 15:30:00 | AAPL | Stock | 9.8521 | 9.8811 | 9.8436 | 9.8775 | 98798840.0 |
| 2010-09-16 16:00:00 | AAPL | Stock | 9.8775 | 9.9218 | 9.6461 | 9.9111 | 18137364.0 |
| 2010-09-16 16:30:00 | AAPL | Stock | 9.9111 | 9.9443 | 9.8342 | 9.9311 | 1784804.0 |
| 2010-09-16 17:00:00 | AAPL | Stock | 9.9318 | 9.9318 | 9.9132 | 9.9196 | 935788.0 |
| 2010-09-16 17:30:00 | AAPL | Stock | 9.9196 | 9.9268 | 9.9146 | 9.9214 | 624652.0 |
| 2010-09-16 18:00:00 | AAPL | Stock | 9.9239 | 9.9264 | 9.8775 | 9.915 | 611632.0 |
| 2010-09-16 18:30:00 | AAPL | Stock | 9.9161 | 9.9179 | 9.915 | 9.9154 | 207060.0 |
| 2010-09-16 19:00:00 | AAPL | Stock | 9.9161 | 9.9196 | 9.915 | 9.9189 | 438844.0 |
| 2010-09-16 19:30:00 | AAPL | Stock | 9.9186 | 9.9214 | 9.9107 | 9.9214 | 310576.0 |
| 2010-09-16 07:00:00 | MSFT | Stock | 25.18 | 25.18 | 25.18 | 25.18 | 600.0 |
| 2010-09-16 07:30:00 | MSFT | Stock | 25.16 | 25.16 | 25.12 | 25.12 | 600.0 |
| 2010-09-16 08:00:00 | MSFT | Stock | 25.1 | 25.13 | 25.07 | 25.1 | 7500.0 |
| 2010-09-16 08:30:00 | MSFT | Stock | 25.11 | 25.11 | 25.01 | 25.05 | 28204.0 |
| 2010-09-16 09:00:00 | MSFT | Stock | 25.05 | 25.08 | 25.03 | 25.06 | 8514.0 |
| 2010-09-16 09:30:00 | MSFT | Stock | 25.06 | 25.2 | 25.05 | 25.13 | 3232875.0 |
| 2010-09-16 10:00:00 | MSFT | Stock | 25.125 | 25.16 | 25.05 | 25.091 | 3954261.0 |
| 2010-09-16 10:30:00 | MSFT | Stock | 25.09 | 25.13 | 25.085 | 25.112 | 3185956.0 |
| 2010-09-16 11:00:00 | MSFT | Stock | 25.12 | 25.23 | 25.11 | 25.21 | 2571508.0 |
| 2010-09-16 11:30:00 | MSFT | Stock | 25.205 | 25.24 | 25.13 | 25.2 | 2705929.0 |
| 2010-09-16 12:00:00 | MSFT | Stock | 25.19 | 25.21 | 25.12 | 25.205 | 2157062.0 |
| 2010-09-16 12:30:00 | MSFT | Stock | 25.205 | 25.25 | 25.2 | 25.21 | 2016200.0 |
| 2010-09-16 13:00:00 | MSFT | Stock | 25.2 | 25.21 | 25.15 | 25.196 | 1580497.0 |
| 2010-09-16 13:30:00 | MSFT | Stock | 25.19 | 25.29 | 25.19 | 25.218 | 2668583.0 |
| 2010-09-16 14:00:00 | MSFT | Stock | 25.219 | 25.32 | 25.21 | 25.3 | 2183658.0 |
| 2010-09-16 14:30:00 | MSFT | Stock | 25.295 | 25.34 | 25.26 | 25.311 | 2730244.0 |
| 2010-09-16 15:00:00 | MSFT | Stock | 25.315 | 25.37 | 25.3 | 25.352 | 3330377.0 |
| 2010-09-16 15:30:00 | MSFT | Stock | 25.355 | 25.36 | 25.28 | 25.32 | 5874183.0 |
| 2010-09-16 16:00:00 | MSFT | Stock | 25.33 | 25.59 | 25.152 | 25.58 | 4735952.0 |
| 2010-09-16 16:30:00 | MSFT | Stock | 25.53 | 25.66 | 25.19 | 25.57 | 76915.0 |
| 2010-09-16 17:00:00 | MSFT | Stock | 25.59 | 25.6 | 25.53 | 25.57 | 26070.0 |
| 2010-09-16 17:30:00 | MSFT | Stock | 25.56 | 25.56 | 25.49 | 25.49 | 3900.0 |
> showing 50 of 73,056 rows — these rows as CSV