PREVIEW / stock_30min / 2010-07-19
file: by_date/stock_30min/2010/2010-07-19.parquet size: 1.3 MB rows: 72,715 symbols: 3,449
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-07-19 04:00:00 | AAPL | Stock | 8.9461 | 8.9721 | 8.9461 | 8.9721 | 8400.0 |
| 2010-07-19 05:30:00 | AAPL | Stock | 8.9986 | 8.9996 | 8.9961 | 8.9961 | 13720.0 |
| 2010-07-19 06:30:00 | AAPL | Stock | 8.9725 | 9.0175 | 8.9725 | 9.0175 | 109732.0 |
| 2010-07-19 07:00:00 | AAPL | Stock | 8.9771 | 8.9771 | 8.8893 | 8.9036 | 908012.0 |
| 2010-07-19 07:30:00 | AAPL | Stock | 8.9036 | 8.9107 | 8.8807 | 8.8932 | 2671592.0 |
| 2010-07-19 08:00:00 | AAPL | Stock | 8.9043 | 8.9511 | 8.8821 | 8.9396 | 2257528.0 |
| 2010-07-19 08:30:00 | AAPL | Stock | 8.9443 | 8.9446 | 8.9175 | 8.9339 | 2703764.0 |
| 2010-07-19 09:00:00 | AAPL | Stock | 8.9339 | 8.9371 | 8.9143 | 8.9193 | 2037532.0 |
| 2010-07-19 09:30:00 | AAPL | Stock | 8.9243 | 8.9243 | 8.7393 | 8.75 | 174644036.0 |
| 2010-07-19 10:00:00 | AAPL | Stock | 8.75 | 8.8571 | 8.6489 | 8.6543 | 131371128.0 |
| 2010-07-19 10:30:00 | AAPL | Stock | 8.6543 | 8.7143 | 8.5571 | 8.5899 | 143941812.0 |
| 2010-07-19 11:00:00 | AAPL | Stock | 8.5893 | 8.6918 | 8.5782 | 8.6754 | 87940160.0 |
| 2010-07-19 11:30:00 | AAPL | Stock | 8.6779 | 8.6954 | 8.6307 | 8.6571 | 48182260.0 |
| 2010-07-19 12:00:00 | AAPL | Stock | 8.6568 | 8.6743 | 8.6 | 8.6671 | 46741940.0 |
| 2010-07-19 12:30:00 | AAPL | Stock | 8.6661 | 8.6671 | 8.6257 | 8.6396 | 37213036.0 |
| 2010-07-19 13:00:00 | AAPL | Stock | 8.6385 | 8.6489 | 8.6004 | 8.6111 | 30719920.0 |
| 2010-07-19 13:30:00 | AAPL | Stock | 8.6096 | 8.6429 | 8.6018 | 8.6135 | 30077124.0 |
| 2010-07-19 14:00:00 | AAPL | Stock | 8.6121 | 8.7606 | 8.6093 | 8.6921 | 57484336.0 |
| 2010-07-19 14:30:00 | AAPL | Stock | 8.6922 | 8.7425 | 8.6304 | 8.7143 | 66096492.0 |
| 2010-07-19 15:00:00 | AAPL | Stock | 8.7145 | 8.7786 | 8.7057 | 8.725 | 66492720.0 |
| 2010-07-19 15:30:00 | AAPL | Stock | 8.725 | 8.7729 | 8.7107 | 8.7729 | 68852588.0 |
| 2010-07-19 16:00:00 | AAPL | Stock | 8.7707 | 8.7739 | 8.6943 | 8.7007 | 12279232.0 |
| 2010-07-19 16:30:00 | AAPL | Stock | 8.7007 | 8.9268 | 8.6707 | 8.6879 | 2270996.0 |
| 2010-07-19 17:00:00 | AAPL | Stock | 8.6943 | 8.7125 | 8.6875 | 8.7089 | 390768.0 |
| 2010-07-19 17:30:00 | AAPL | Stock | 8.7114 | 8.7114 | 8.6936 | 8.6954 | 260988.0 |
| 2010-07-19 18:00:00 | AAPL | Stock | 8.6929 | 8.7707 | 8.6929 | 8.7 | 231644.0 |
| 2010-07-19 18:30:00 | AAPL | Stock | 8.6989 | 8.7061 | 8.6964 | 8.7007 | 164472.0 |
| 2010-07-19 19:00:00 | AAPL | Stock | 8.7032 | 8.7032 | 8.695 | 8.6982 | 73248.0 |
| 2010-07-19 19:30:00 | AAPL | Stock | 8.6968 | 8.7 | 8.6929 | 8.6929 | 364980.0 |
| 2010-07-19 04:30:00 | MSFT | Stock | 24.97 | 24.97 | 24.97 | 24.97 | 497.0 |
| 2010-07-19 05:00:00 | MSFT | Stock | 24.97 | 25.0 | 24.97 | 25.0 | 1500.0 |
| 2010-07-19 05:30:00 | MSFT | Stock | 25.01 | 25.01 | 25.01 | 25.01 | 197.0 |
| 2010-07-19 07:00:00 | MSFT | Stock | 25.03 | 25.05 | 25.03 | 25.05 | 3000.0 |
| 2010-07-19 07:30:00 | MSFT | Stock | 25.02 | 25.03 | 25.01 | 25.02 | 2362.0 |
| 2010-07-19 08:00:00 | MSFT | Stock | 25.02 | 25.06 | 24.97 | 25.03 | 47747.0 |
| 2010-07-19 08:30:00 | MSFT | Stock | 25.04 | 25.1 | 25.03 | 25.1 | 35100.0 |
| 2010-07-19 09:00:00 | MSFT | Stock | 25.08 | 25.1 | 24.94 | 24.95 | 94457.0 |
| 2010-07-19 09:30:00 | MSFT | Stock | 24.96 | 25.3 | 24.91 | 25.21 | 4763841.0 |
| 2010-07-19 10:00:00 | MSFT | Stock | 25.21 | 25.23 | 25.07 | 25.09 | 3581535.0 |
| 2010-07-19 10:30:00 | MSFT | Stock | 25.09 | 25.17 | 25.05 | 25.11 | 2883267.0 |
| 2010-07-19 11:00:00 | MSFT | Stock | 25.12 | 25.19 | 25.08 | 25.18 | 2845366.0 |
| 2010-07-19 11:30:00 | MSFT | Stock | 25.18 | 25.21 | 25.15 | 25.185 | 1525748.0 |
| 2010-07-19 12:00:00 | MSFT | Stock | 25.18 | 25.19 | 25.07 | 25.185 | 1568248.0 |
| 2010-07-19 12:30:00 | MSFT | Stock | 25.18 | 25.19 | 25.09 | 25.1 | 2292924.0 |
| 2010-07-19 13:00:00 | MSFT | Stock | 25.1 | 25.11 | 25.03 | 25.08 | 1113518.0 |
| 2010-07-19 13:30:00 | MSFT | Stock | 25.07 | 25.11 | 25.04 | 25.1 | 1211139.0 |
| 2010-07-19 14:00:00 | MSFT | Stock | 25.1 | 25.2 | 25.09 | 25.17 | 1718980.0 |
| 2010-07-19 14:30:00 | MSFT | Stock | 25.17 | 25.29 | 25.16 | 25.19 | 2873325.0 |
| 2010-07-19 15:00:00 | MSFT | Stock | 25.19 | 25.285 | 25.17 | 25.18 | 2331340.0 |
| 2010-07-19 15:30:00 | MSFT | Stock | 25.19 | 25.25 | 25.14 | 25.24 | 5105949.0 |
> showing 50 of 72,715 rows — these rows as CSV