PREVIEW / stock_30min / 2010-07-14
file: by_date/stock_30min/2010/2010-07-14.parquet size: 1.3 MB rows: 73,756 symbols: 3,426
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-14 05:30:00 | AAPL | Stock | 9.0714 | 9.0714 | 9.0657 | 9.0657 | 8400.0 |
| 2010-07-14 06:00:00 | AAPL | Stock | 9.0536 | 9.0536 | 9.0536 | 9.0536 | 8400.0 |
| 2010-07-14 06:30:00 | AAPL | Stock | 9.0429 | 9.0446 | 9.0429 | 9.0446 | 16800.0 |
| 2010-07-14 07:00:00 | AAPL | Stock | 9.0446 | 9.0446 | 9.0107 | 9.0179 | 78120.0 |
| 2010-07-14 07:30:00 | AAPL | Stock | 9.0182 | 9.0286 | 8.9725 | 8.9871 | 472136.0 |
| 2010-07-14 08:00:00 | AAPL | Stock | 8.9871 | 9.0125 | 8.8689 | 8.8825 | 4272604.0 |
| 2010-07-14 08:30:00 | AAPL | Stock | 8.8825 | 8.9286 | 8.8786 | 8.8789 | 2901612.0 |
| 2010-07-14 09:00:00 | AAPL | Stock | 8.8789 | 8.9196 | 8.8507 | 8.9061 | 5487300.0 |
| 2010-07-14 09:30:00 | AAPL | Stock | 8.9054 | 9.0104 | 8.8929 | 8.9329 | 117362504.0 |
| 2010-07-14 10:00:00 | AAPL | Stock | 8.9329 | 9.0254 | 8.9225 | 9.0154 | 79969680.0 |
| 2010-07-14 10:30:00 | AAPL | Stock | 9.015 | 9.0639 | 8.9704 | 9.04 | 70080584.0 |
| 2010-07-14 11:00:00 | AAPL | Stock | 9.0393 | 9.1211 | 9.0232 | 9.1032 | 91663740.0 |
| 2010-07-14 11:30:00 | AAPL | Stock | 9.1043 | 9.1357 | 9.1007 | 9.12 | 56812392.0 |
| 2010-07-14 12:00:00 | AAPL | Stock | 9.1214 | 9.125 | 9.0882 | 9.0961 | 31582124.0 |
| 2010-07-14 12:30:00 | AAPL | Stock | 9.0968 | 9.1114 | 9.0596 | 9.06 | 36232728.0 |
| 2010-07-14 13:00:00 | AAPL | Stock | 9.06 | 9.0679 | 9.0232 | 9.0647 | 41228908.0 |
| 2010-07-14 13:30:00 | AAPL | Stock | 9.0659 | 9.0732 | 9.0018 | 9.0179 | 34461056.0 |
| 2010-07-14 14:00:00 | AAPL | Stock | 9.0175 | 9.0236 | 8.975 | 9.0007 | 55743072.0 |
| 2010-07-14 14:30:00 | AAPL | Stock | 9.0007 | 9.055 | 8.9993 | 9.0375 | 52403876.0 |
| 2010-07-14 15:00:00 | AAPL | Stock | 9.0386 | 9.0532 | 9.0 | 9.0357 | 47302416.0 |
| 2010-07-14 15:30:00 | AAPL | Stock | 9.0357 | 9.0396 | 8.9825 | 9.03 | 65124136.0 |
| 2010-07-14 16:00:00 | AAPL | Stock | 9.0279 | 9.0347 | 9.0121 | 9.0186 | 12104260.0 |
| 2010-07-14 16:30:00 | AAPL | Stock | 9.0193 | 9.0311 | 8.9857 | 9.0171 | 1054648.0 |
| 2010-07-14 17:00:00 | AAPL | Stock | 9.1212 | 9.1212 | 9.0161 | 9.0161 | 201376.0 |
| 2010-07-14 17:30:00 | AAPL | Stock | 9.0161 | 9.0161 | 9.0025 | 9.015 | 124124.0 |
| 2010-07-14 18:00:00 | AAPL | Stock | 9.0161 | 9.0261 | 9.015 | 9.0196 | 63840.0 |
| 2010-07-14 18:30:00 | AAPL | Stock | 9.0214 | 9.0214 | 9.0143 | 9.0143 | 22652.0 |
| 2010-07-14 19:00:00 | AAPL | Stock | 9.0161 | 9.0214 | 9.0143 | 9.0214 | 57232.0 |
| 2010-07-14 19:30:00 | AAPL | Stock | 9.0168 | 9.02 | 9.0114 | 9.02 | 97300.0 |
| 2010-07-14 07:00:00 | MSFT | Stock | 25.63 | 25.63 | 25.48 | 25.48 | 3300.0 |
| 2010-07-14 07:30:00 | MSFT | Stock | 25.6 | 25.64 | 25.55 | 25.64 | 13100.0 |
| 2010-07-14 08:00:00 | MSFT | Stock | 25.6 | 25.66 | 25.55 | 25.56 | 121434.0 |
| 2010-07-14 08:30:00 | MSFT | Stock | 25.55 | 25.74 | 25.55 | 25.6 | 119678.0 |
| 2010-07-14 09:00:00 | MSFT | Stock | 25.61 | 25.61 | 25.49 | 25.51 | 226621.0 |
| 2010-07-14 09:30:00 | MSFT | Stock | 25.51 | 25.61 | 25.37 | 25.4 | 11076649.0 |
| 2010-07-14 10:00:00 | MSFT | Stock | 25.4 | 25.5 | 25.29 | 25.39 | 5863105.0 |
| 2010-07-14 10:30:00 | MSFT | Stock | 25.39 | 25.49 | 25.37 | 25.398 | 3029064.0 |
| 2010-07-14 11:00:00 | MSFT | Stock | 25.39 | 25.45 | 25.29 | 25.445 | 4600046.0 |
| 2010-07-14 11:30:00 | MSFT | Stock | 25.45 | 25.54 | 25.41 | 25.48 | 3225839.0 |
| 2010-07-14 12:00:00 | MSFT | Stock | 25.48 | 25.52 | 25.44 | 25.48 | 3753839.0 |
| 2010-07-14 12:30:00 | MSFT | Stock | 25.49 | 25.53 | 25.46 | 25.484 | 3080498.0 |
| 2010-07-14 13:00:00 | MSFT | Stock | 25.48 | 25.5 | 25.38 | 25.4 | 2650559.0 |
| 2010-07-14 13:30:00 | MSFT | Stock | 25.39 | 25.42 | 25.26 | 25.26 | 2826104.0 |
| 2010-07-14 14:00:00 | MSFT | Stock | 25.26 | 25.39 | 25.12 | 25.18 | 4183432.0 |
| 2010-07-14 14:30:00 | MSFT | Stock | 25.172 | 25.5 | 25.17 | 25.31 | 4189399.0 |
| 2010-07-14 15:00:00 | MSFT | Stock | 25.305 | 25.37 | 25.23 | 25.36 | 2720645.0 |
| 2010-07-14 15:30:00 | MSFT | Stock | 25.36 | 25.46 | 25.24 | 25.45 | 8721257.0 |
| 2010-07-14 16:00:00 | MSFT | Stock | 25.449 | 25.48 | 25.397 | 25.46 | 5398947.0 |
| 2010-07-14 16:30:00 | MSFT | Stock | 25.43 | 25.5 | 25.24 | 25.46 | 132847.0 |
| 2010-07-14 17:00:00 | MSFT | Stock | 25.47 | 25.47 | 25.46 | 25.46 | 783.0 |
> showing 50 of 73,756 rows — these rows as CSV