PREVIEW / stock_30min / 2008-01-22
file: by_date/stock_30min/2008/2008-01-22.parquet size: 1.3 MB rows: 74,439 symbols: 3,289
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-01-22 04:00:00 | AAPL | Stock | 5.1289 | 5.5 | 5.0893 | 5.1068 | 68656.0 |
| 2008-01-22 04:30:00 | AAPL | Stock | 5.0982 | 5.2057 | 5.0982 | 5.1964 | 204400.0 |
| 2008-01-22 05:00:00 | AAPL | Stock | 5.2232 | 5.25 | 5.2054 | 5.25 | 65548.0 |
| 2008-01-22 05:30:00 | AAPL | Stock | 5.2836 | 5.3211 | 5.25 | 5.2836 | 143808.0 |
| 2008-01-22 06:00:00 | AAPL | Stock | 5.2821 | 5.3707 | 5.2821 | 5.3696 | 346416.0 |
| 2008-01-22 06:30:00 | AAPL | Stock | 5.3571 | 5.375 | 5.2857 | 5.2857 | 375900.0 |
| 2008-01-22 07:00:00 | AAPL | Stock | 5.3482 | 5.4839 | 5.2818 | 5.4179 | 3262784.0 |
| 2008-01-22 07:30:00 | AAPL | Stock | 5.4239 | 5.475 | 5.4071 | 5.4289 | 2666468.0 |
| 2008-01-22 08:00:00 | AAPL | Stock | 5.3571 | 5.7393 | 5.2857 | 5.535 | 43510824.0 |
| 2008-01-22 08:30:00 | AAPL | Stock | 5.53 | 5.565 | 5.3729 | 5.4036 | 34346228.0 |
| 2008-01-22 09:00:00 | AAPL | Stock | 5.3989 | 5.4275 | 5.2857 | 5.2879 | 26319944.0 |
| 2008-01-22 09:30:00 | AAPL | Stock | 5.2879 | 5.6071 | 5.2143 | 5.5457 | 315738808.0 |
| 2008-01-22 10:00:00 | AAPL | Stock | 5.5482 | 5.6429 | 5.5107 | 5.6217 | 184031820.0 |
| 2008-01-22 10:30:00 | AAPL | Stock | 5.6204 | 5.6571 | 5.5643 | 5.6004 | 137372676.0 |
| 2008-01-22 11:00:00 | AAPL | Stock | 5.6004 | 5.7068 | 5.5732 | 5.5911 | 138590480.0 |
| 2008-01-22 11:30:00 | AAPL | Stock | 5.5904 | 5.5929 | 5.545 | 5.5511 | 91738584.0 |
| 2008-01-22 12:00:00 | AAPL | Stock | 5.5513 | 5.6139 | 5.5361 | 5.5732 | 88041212.0 |
| 2008-01-22 12:30:00 | AAPL | Stock | 5.5729 | 5.6254 | 5.5607 | 5.6243 | 81998728.0 |
| 2008-01-22 13:00:00 | AAPL | Stock | 5.6243 | 5.7136 | 5.6125 | 5.6603 | 129493140.0 |
| 2008-01-22 13:30:00 | AAPL | Stock | 5.6596 | 5.6843 | 5.6043 | 5.6104 | 96906936.0 |
| 2008-01-22 14:00:00 | AAPL | Stock | 5.6089 | 5.6729 | 5.5739 | 5.6425 | 129709076.0 |
| 2008-01-22 14:30:00 | AAPL | Stock | 5.6436 | 5.6471 | 5.5818 | 5.6018 | 116628708.0 |
| 2008-01-22 15:00:00 | AAPL | Stock | 5.5979 | 5.6321 | 5.545 | 5.5679 | 154127988.0 |
| 2008-01-22 15:30:00 | AAPL | Stock | 5.5679 | 5.6789 | 5.5668 | 5.625 | 253814456.0 |
| 2008-01-22 16:00:00 | AAPL | Stock | 5.6236 | 5.7629 | 5.4464 | 5.4646 | 55830488.0 |
| 2008-01-22 16:30:00 | AAPL | Stock | 5.4468 | 5.6936 | 4.8146 | 4.9686 | 225669640.0 |
| 2008-01-22 17:00:00 | AAPL | Stock | 4.9654 | 5.5586 | 4.8754 | 4.8911 | 76519408.0 |
| 2008-01-22 17:30:00 | AAPL | Stock | 4.8925 | 5.563 | 4.8779 | 4.9657 | 24398696.0 |
| 2008-01-22 18:00:00 | AAPL | Stock | 4.9657 | 5.6846 | 4.925 | 4.9475 | 16645860.0 |
| 2008-01-22 18:30:00 | AAPL | Stock | 4.9471 | 5.6042 | 4.9193 | 4.9539 | 4421536.0 |
| 2008-01-22 19:00:00 | AAPL | Stock | 4.9554 | 4.9568 | 4.9286 | 4.9321 | 1925840.0 |
| 2008-01-22 19:30:00 | AAPL | Stock | 4.9304 | 4.9321 | 4.92 | 4.9261 | 1988448.0 |
| 2008-01-22 04:00:00 | MSFT | Stock | 30.77 | 30.8 | 30.77 | 30.8 | 600.0 |
| 2008-01-22 04:30:00 | MSFT | Stock | 30.62 | 30.62 | 30.62 | 30.62 | 100.0 |
| 2008-01-22 05:00:00 | MSFT | Stock | 30.4 | 30.89 | 30.4 | 30.46 | 1162.0 |
| 2008-01-22 05:30:00 | MSFT | Stock | 30.41 | 31.08 | 30.41 | 30.86 | 2100.0 |
| 2008-01-22 06:00:00 | MSFT | Stock | 31.06 | 31.2 | 30.89 | 31.16 | 13633.0 |
| 2008-01-22 06:30:00 | MSFT | Stock | 31.3 | 31.35 | 31.2 | 31.29 | 5025.0 |
| 2008-01-22 07:00:00 | MSFT | Stock | 31.29 | 31.6 | 31.29 | 31.45 | 55426.0 |
| 2008-01-22 07:30:00 | MSFT | Stock | 31.42 | 31.54 | 31.25 | 31.53 | 65450.0 |
| 2008-01-22 08:00:00 | MSFT | Stock | 31.5 | 32.69 | 31.4 | 31.9 | 296347.0 |
| 2008-01-22 08:30:00 | MSFT | Stock | 31.9 | 32.44 | 31.7 | 31.98 | 188351.0 |
| 2008-01-22 09:00:00 | MSFT | Stock | 31.97 | 32.05 | 31.54 | 31.54 | 194503.0 |
| 2008-01-22 09:30:00 | MSFT | Stock | 31.56 | 32.33 | 31.5 | 31.85 | 15265133.0 |
| 2008-01-22 10:00:00 | MSFT | Stock | 31.85 | 32.53 | 31.81 | 32.34 | 11214957.0 |
| 2008-01-22 10:30:00 | MSFT | Stock | 32.34 | 32.35 | 31.8 | 31.92 | 8729440.0 |
| 2008-01-22 11:00:00 | MSFT | Stock | 31.91 | 32.25 | 31.87 | 32.04 | 7944679.0 |
| 2008-01-22 11:30:00 | MSFT | Stock | 32.03 | 32.03 | 31.8 | 31.89 | 5538577.0 |
| 2008-01-22 12:00:00 | MSFT | Stock | 31.89 | 32.12 | 31.82 | 31.88 | 4797321.0 |
| 2008-01-22 12:30:00 | MSFT | Stock | 31.88 | 32.05 | 31.84 | 32.04 | 3469118.0 |
> showing 50 of 74,439 rows — these rows as CSV