PREVIEW / stock_30min / 2010-02-11
file: by_date/stock_30min/2010/2010-02-11.parquet size: 1.3 MB rows: 71,676 symbols: 3,414
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-02-11 06:00:00 | AAPL | Stock | 6.9682 | 6.9821 | 6.9643 | 6.9821 | 44324.0 |
| 2010-02-11 07:00:00 | AAPL | Stock | 7.0011 | 7.0011 | 6.9864 | 6.9886 | 64400.0 |
| 2010-02-11 07:30:00 | AAPL | Stock | 6.9911 | 7.0014 | 6.9911 | 6.9979 | 74732.0 |
| 2010-02-11 08:00:00 | AAPL | Stock | 6.9893 | 6.9954 | 6.975 | 6.9832 | 676872.0 |
| 2010-02-11 08:30:00 | AAPL | Stock | 6.9889 | 6.9961 | 6.9782 | 6.9782 | 1124704.0 |
| 2010-02-11 09:00:00 | AAPL | Stock | 6.9782 | 6.9832 | 6.96 | 6.9671 | 1996876.0 |
| 2010-02-11 09:30:00 | AAPL | Stock | 6.9607 | 6.9871 | 6.9429 | 6.9582 | 55841100.0 |
| 2010-02-11 10:00:00 | AAPL | Stock | 6.9586 | 6.9821 | 6.9307 | 6.9707 | 42169484.0 |
| 2010-02-11 10:30:00 | AAPL | Stock | 6.9711 | 6.9732 | 6.9536 | 6.9604 | 27971608.0 |
| 2010-02-11 11:00:00 | AAPL | Stock | 6.9593 | 7.0532 | 6.9589 | 7.0518 | 58747724.0 |
| 2010-02-11 11:30:00 | AAPL | Stock | 7.0532 | 7.0875 | 7.0321 | 7.0721 | 54215924.0 |
| 2010-02-11 12:00:00 | AAPL | Stock | 7.0739 | 7.0979 | 7.0689 | 7.0871 | 41358968.0 |
| 2010-02-11 12:30:00 | AAPL | Stock | 7.0868 | 7.1004 | 7.0775 | 7.0989 | 24586044.0 |
| 2010-02-11 13:00:00 | AAPL | Stock | 7.0989 | 7.1171 | 7.0829 | 7.1139 | 37381036.0 |
| 2010-02-11 13:30:00 | AAPL | Stock | 7.1143 | 7.1329 | 7.1118 | 7.123 | 40937596.0 |
| 2010-02-11 14:00:00 | AAPL | Stock | 7.1239 | 7.1339 | 7.1161 | 7.1249 | 27815620.0 |
| 2010-02-11 14:30:00 | AAPL | Stock | 7.1254 | 7.1332 | 7.1071 | 7.1143 | 27175316.0 |
| 2010-02-11 15:00:00 | AAPL | Stock | 7.1146 | 7.1207 | 7.1014 | 7.1021 | 26888932.0 |
| 2010-02-11 15:30:00 | AAPL | Stock | 7.1021 | 7.1064 | 7.0839 | 7.0971 | 46388216.0 |
| 2010-02-11 16:00:00 | AAPL | Stock | 7.0961 | 7.0996 | 7.0518 | 7.0929 | 16601340.0 |
| 2010-02-11 16:30:00 | AAPL | Stock | 7.0946 | 7.0964 | 7.0932 | 7.0964 | 177296.0 |
| 2010-02-11 17:00:00 | AAPL | Stock | 7.0993 | 7.1064 | 7.0957 | 7.1054 | 214452.0 |
| 2010-02-11 17:30:00 | AAPL | Stock | 7.1054 | 7.11 | 7.1025 | 7.1025 | 3452176.0 |
| 2010-02-11 18:00:00 | AAPL | Stock | 7.1018 | 7.1179 | 7.0954 | 7.1175 | 335076.0 |
| 2010-02-11 18:30:00 | AAPL | Stock | 7.1136 | 7.12 | 7.1136 | 7.1168 | 31192.0 |
| 2010-02-11 19:00:00 | AAPL | Stock | 7.1193 | 7.12 | 7.1161 | 7.1193 | 108976.0 |
| 2010-02-11 19:30:00 | AAPL | Stock | 7.1161 | 7.1171 | 7.1114 | 7.1143 | 138292.0 |
| 2010-02-11 08:00:00 | MSFT | Stock | 28.01 | 28.04 | 28.0 | 28.04 | 3464.0 |
| 2010-02-11 08:30:00 | MSFT | Stock | 28.03 | 28.1 | 28.0 | 28.09 | 617319.0 |
| 2010-02-11 09:00:00 | MSFT | Stock | 28.08 | 28.08 | 27.92 | 27.93 | 147789.0 |
| 2010-02-11 09:30:00 | MSFT | Stock | 27.92 | 28.0 | 27.77 | 27.86 | 4490065.0 |
| 2010-02-11 10:00:00 | MSFT | Stock | 27.85 | 27.89 | 27.76 | 27.82 | 5611769.0 |
| 2010-02-11 10:30:00 | MSFT | Stock | 27.83 | 27.85 | 27.7 | 27.7 | 3928929.0 |
| 2010-02-11 11:00:00 | MSFT | Stock | 27.71 | 28.0 | 27.7 | 28.0 | 4350183.0 |
| 2010-02-11 11:30:00 | MSFT | Stock | 27.999 | 28.24 | 27.95 | 28.22 | 5414195.0 |
| 2010-02-11 12:00:00 | MSFT | Stock | 28.23 | 28.4 | 28.22 | 28.37 | 6157561.0 |
| 2010-02-11 12:30:00 | MSFT | Stock | 28.36 | 28.38 | 28.23 | 28.285 | 4509619.0 |
| 2010-02-11 13:00:00 | MSFT | Stock | 28.29 | 28.3 | 28.21 | 28.25 | 3945026.0 |
| 2010-02-11 13:30:00 | MSFT | Stock | 28.25 | 28.27 | 28.18 | 28.22 | 3379422.0 |
| 2010-02-11 14:00:00 | MSFT | Stock | 28.225 | 28.26 | 28.2 | 28.249 | 4497641.0 |
| 2010-02-11 14:30:00 | MSFT | Stock | 28.24 | 28.255 | 28.06 | 28.15 | 4212687.0 |
| 2010-02-11 15:00:00 | MSFT | Stock | 28.14 | 28.21 | 28.09 | 28.095 | 3351322.0 |
| 2010-02-11 15:30:00 | MSFT | Stock | 28.098 | 28.17 | 28.07 | 28.12 | 6172531.0 |
| 2010-02-11 16:00:00 | MSFT | Stock | 28.12 | 28.328 | 28.085 | 28.285 | 3828466.0 |
| 2010-02-11 16:30:00 | MSFT | Stock | 28.11 | 28.12 | 28.11 | 28.12 | 7225.0 |
| 2010-02-11 17:00:00 | MSFT | Stock | 28.12 | 28.24 | 28.12 | 28.22 | 16380.0 |
| 2010-02-11 17:30:00 | MSFT | Stock | 28.22 | 28.22 | 28.22 | 28.22 | 200.0 |
| 2010-02-11 18:00:00 | MSFT | Stock | 28.13 | 28.18 | 28.13 | 28.18 | 17026.0 |
| 2010-02-11 18:30:00 | MSFT | Stock | 28.18 | 28.18 | 28.18 | 28.18 | 550.0 |
| 2010-02-11 19:00:00 | MSFT | Stock | 28.16 | 28.2 | 28.16 | 28.2 | 600.0 |
> showing 50 of 71,676 rows — these rows as CSV