PREVIEW / stock_30min / 2008-07-31
file: by_date/stock_30min/2008/2008-07-31.parquet size: 1.3 MB rows: 69,511 symbols: 3,339
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-07-31 05:30:00 | AAPL | Stock | 5.7164 | 5.7164 | 5.7164 | 5.7164 | 2800.0 |
| 2008-07-31 06:30:00 | AAPL | Stock | 5.6929 | 5.6964 | 5.6929 | 5.6946 | 16800.0 |
| 2008-07-31 07:00:00 | AAPL | Stock | 5.6718 | 5.7143 | 5.6718 | 5.7107 | 53200.0 |
| 2008-07-31 07:30:00 | AAPL | Stock | 5.7107 | 5.7229 | 5.7107 | 5.7229 | 83832.0 |
| 2008-07-31 08:00:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.6911 | 5.7018 | 232680.0 |
| 2008-07-31 08:30:00 | AAPL | Stock | 5.7018 | 5.7018 | 5.6071 | 5.6271 | 2446528.0 |
| 2008-07-31 09:00:00 | AAPL | Stock | 5.6271 | 5.6329 | 5.6 | 5.6311 | 2377704.0 |
| 2008-07-31 09:30:00 | AAPL | Stock | 5.6307 | 5.7518 | 5.6064 | 5.6982 | 114517648.0 |
| 2008-07-31 10:00:00 | AAPL | Stock | 5.6982 | 5.7714 | 5.6857 | 5.7657 | 72023252.0 |
| 2008-07-31 10:30:00 | AAPL | Stock | 5.7654 | 5.7929 | 5.755 | 5.775 | 62416984.0 |
| 2008-07-31 11:00:00 | AAPL | Stock | 5.7736 | 5.7771 | 5.7321 | 5.7349 | 36811124.0 |
| 2008-07-31 11:30:00 | AAPL | Stock | 5.735 | 5.7554 | 5.7247 | 5.7446 | 36779820.0 |
| 2008-07-31 12:00:00 | AAPL | Stock | 5.7457 | 5.7696 | 5.6957 | 5.7154 | 42158088.0 |
| 2008-07-31 12:30:00 | AAPL | Stock | 5.7154 | 5.7621 | 5.7091 | 5.7565 | 30231432.0 |
| 2008-07-31 13:00:00 | AAPL | Stock | 5.7568 | 5.7725 | 5.7271 | 5.7357 | 27176688.0 |
| 2008-07-31 13:30:00 | AAPL | Stock | 5.7357 | 5.7593 | 5.7243 | 5.7339 | 20355356.0 |
| 2008-07-31 14:00:00 | AAPL | Stock | 5.7329 | 5.7582 | 5.7321 | 5.7364 | 19175464.0 |
| 2008-07-31 14:30:00 | AAPL | Stock | 5.7371 | 5.7589 | 5.7321 | 5.7536 | 29230096.0 |
| 2008-07-31 15:00:00 | AAPL | Stock | 5.7536 | 5.765 | 5.7114 | 5.7114 | 37850484.0 |
| 2008-07-31 15:30:00 | AAPL | Stock | 5.7114 | 5.7161 | 5.6504 | 5.6764 | 76237784.0 |
| 2008-07-31 16:00:00 | AAPL | Stock | 5.6764 | 5.7238 | 5.6718 | 5.6854 | 14187320.0 |
| 2008-07-31 16:30:00 | AAPL | Stock | 5.6786 | 5.7176 | 5.6768 | 5.6839 | 138376.0 |
| 2008-07-31 17:00:00 | AAPL | Stock | 5.6839 | 5.6843 | 5.6768 | 5.6839 | 201684.0 |
| 2008-07-31 17:30:00 | AAPL | Stock | 5.6786 | 5.6793 | 5.6768 | 5.6786 | 102480.0 |
| 2008-07-31 18:00:00 | AAPL | Stock | 5.6786 | 5.6821 | 5.6786 | 5.6821 | 53144.0 |
| 2008-07-31 18:30:00 | AAPL | Stock | 5.6804 | 5.6871 | 5.6804 | 5.6857 | 198660.0 |
| 2008-07-31 19:00:00 | AAPL | Stock | 5.6871 | 5.6871 | 5.6775 | 5.6775 | 290444.0 |
| 2008-07-31 19:30:00 | AAPL | Stock | 5.6775 | 5.6775 | 5.6696 | 5.6696 | 163940.0 |
| 2008-07-31 07:00:00 | MSFT | Stock | 26.01 | 26.01 | 26.01 | 26.01 | 100.0 |
| 2008-07-31 07:30:00 | MSFT | Stock | 26.19 | 26.2 | 26.19 | 26.2 | 300.0 |
| 2008-07-31 08:00:00 | MSFT | Stock | 26.25 | 26.25 | 26.2 | 26.2 | 1300.0 |
| 2008-07-31 08:30:00 | MSFT | Stock | 26.29 | 26.29 | 25.98 | 25.98 | 56175.0 |
| 2008-07-31 09:00:00 | MSFT | Stock | 25.96 | 25.97 | 25.82 | 25.86 | 52700.0 |
| 2008-07-31 09:30:00 | MSFT | Stock | 25.86 | 26.13 | 25.79 | 26.0 | 5829248.0 |
| 2008-07-31 10:00:00 | MSFT | Stock | 26.0 | 26.17 | 25.95 | 26.08 | 5370162.0 |
| 2008-07-31 10:30:00 | MSFT | Stock | 26.079 | 26.16 | 26.05 | 26.14 | 3625005.0 |
| 2008-07-31 11:00:00 | MSFT | Stock | 26.13 | 26.28 | 26.11 | 26.23 | 4631780.0 |
| 2008-07-31 11:30:00 | MSFT | Stock | 26.24 | 26.25 | 26.13 | 26.17 | 3159333.0 |
| 2008-07-31 12:00:00 | MSFT | Stock | 26.18 | 26.2 | 26.05 | 26.1 | 3221818.0 |
| 2008-07-31 12:30:00 | MSFT | Stock | 26.1 | 26.18 | 26.03 | 26.04 | 2717046.0 |
| 2008-07-31 13:00:00 | MSFT | Stock | 26.05 | 26.2 | 26.04 | 26.12 | 2579583.0 |
| 2008-07-31 13:30:00 | MSFT | Stock | 26.12 | 26.2 | 26.08 | 26.08 | 1840771.0 |
| 2008-07-31 14:00:00 | MSFT | Stock | 26.09 | 26.19 | 26.08 | 26.11 | 2572308.0 |
| 2008-07-31 14:30:00 | MSFT | Stock | 26.11 | 26.23 | 26.11 | 26.13 | 3340944.0 |
| 2008-07-31 15:00:00 | MSFT | Stock | 26.132 | 26.2 | 25.99 | 26.0 | 4396206.0 |
| 2008-07-31 15:30:00 | MSFT | Stock | 26.0 | 26.04 | 25.71 | 25.74 | 10175362.0 |
| 2008-07-31 16:00:00 | MSFT | Stock | 25.74 | 26.052 | 25.71 | 25.77 | 3069869.0 |
| 2008-07-31 16:30:00 | MSFT | Stock | 25.78 | 25.999 | 25.72 | 25.82 | 164105.0 |
| 2008-07-31 17:00:00 | MSFT | Stock | 25.82 | 25.82 | 25.72 | 25.72 | 23547.0 |
| 2008-07-31 17:30:00 | MSFT | Stock | 25.81 | 26.052 | 25.77 | 25.86 | 13160.0 |
> showing 50 of 69,511 rows — these rows as CSV