PREVIEW / stock_30min / 2010-10-13
file: by_date/stock_30min/2010/2010-10-13.parquet size: 1.4 MB rows: 76,679 symbols: 3,502
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-10-13 04:00:00 | AAPL | Stock | 10.7257 | 10.7257 | 10.7257 | 10.7257 | 4340.0 |
| 2010-10-13 04:30:00 | AAPL | Stock | 10.7339 | 10.7339 | 10.7339 | 10.7339 | 5600.0 |
| 2010-10-13 05:00:00 | AAPL | Stock | 10.7679 | 10.7679 | 10.7679 | 10.7679 | 4200.0 |
| 2010-10-13 06:00:00 | AAPL | Stock | 10.7621 | 10.7621 | 10.7621 | 10.7621 | 9884.0 |
| 2010-10-13 07:00:00 | AAPL | Stock | 10.7596 | 10.7596 | 10.7143 | 10.7304 | 197344.0 |
| 2010-10-13 07:30:00 | AAPL | Stock | 10.7354 | 10.7743 | 10.7268 | 10.7468 | 1285844.0 |
| 2010-10-13 08:00:00 | AAPL | Stock | 10.7468 | 10.7714 | 10.725 | 10.7571 | 3819648.0 |
| 2010-10-13 08:30:00 | AAPL | Stock | 10.7571 | 10.7607 | 10.7371 | 10.7486 | 2358300.0 |
| 2010-10-13 09:00:00 | AAPL | Stock | 10.7482 | 10.7482 | 10.7143 | 10.7179 | 3620540.0 |
| 2010-10-13 09:30:00 | AAPL | Stock | 10.7214 | 10.7757 | 10.7143 | 10.7586 | 106054872.0 |
| 2010-10-13 10:00:00 | AAPL | Stock | 10.7589 | 10.7779 | 10.7325 | 10.7536 | 62116796.0 |
| 2010-10-13 10:30:00 | AAPL | Stock | 10.7529 | 10.7625 | 10.7386 | 10.7621 | 31223752.0 |
| 2010-10-13 11:00:00 | AAPL | Stock | 10.7613 | 10.7843 | 10.745 | 10.7607 | 48377896.0 |
| 2010-10-13 11:30:00 | AAPL | Stock | 10.76 | 10.7679 | 10.7539 | 10.7636 | 19226144.0 |
| 2010-10-13 12:00:00 | AAPL | Stock | 10.7636 | 10.7686 | 10.7557 | 10.765 | 16474780.0 |
| 2010-10-13 12:30:00 | AAPL | Stock | 10.7646 | 10.7671 | 10.7429 | 10.7461 | 19963636.0 |
| 2010-10-13 13:00:00 | AAPL | Stock | 10.7469 | 10.7489 | 10.7143 | 10.7275 | 41803048.0 |
| 2010-10-13 13:30:00 | AAPL | Stock | 10.7279 | 10.7536 | 10.7246 | 10.7396 | 22374128.0 |
| 2010-10-13 14:00:00 | AAPL | Stock | 10.74 | 10.7571 | 10.7314 | 10.7407 | 27369384.0 |
| 2010-10-13 14:30:00 | AAPL | Stock | 10.74 | 10.75 | 10.7071 | 10.7371 | 43901928.0 |
| 2010-10-13 15:00:00 | AAPL | Stock | 10.7368 | 10.7536 | 10.7186 | 10.7364 | 34771576.0 |
| 2010-10-13 15:30:00 | AAPL | Stock | 10.735 | 10.7454 | 10.7118 | 10.7171 | 47552064.0 |
| 2010-10-13 16:00:00 | AAPL | Stock | 10.7193 | 10.7458 | 10.7176 | 10.7196 | 16099804.0 |
| 2010-10-13 16:30:00 | AAPL | Stock | 10.7196 | 11.0628 | 10.7171 | 10.7541 | 54487608.0 |
| 2010-10-13 17:00:00 | AAPL | Stock | 10.7229 | 10.7232 | 10.7146 | 10.7171 | 971544.0 |
| 2010-10-13 17:30:00 | AAPL | Stock | 10.7179 | 10.7196 | 10.7154 | 10.7154 | 91196.0 |
| 2010-10-13 18:00:00 | AAPL | Stock | 10.7154 | 10.7196 | 10.7143 | 10.7154 | 454244.0 |
| 2010-10-13 18:30:00 | AAPL | Stock | 10.715 | 10.7168 | 10.7104 | 10.7132 | 403732.0 |
| 2010-10-13 19:00:00 | AAPL | Stock | 10.7132 | 10.7168 | 10.7111 | 10.7143 | 293972.0 |
| 2010-10-13 19:30:00 | AAPL | Stock | 10.7143 | 10.7286 | 10.7143 | 10.7143 | 246680.0 |
| 2010-10-13 20:00:00 | AAPL | Stock | 10.6736 | 10.6736 | 10.6736 | 10.6736 | 6816600.0 |
| 2010-10-13 04:00:00 | MSFT | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 200.0 |
| 2010-10-13 05:30:00 | MSFT | Stock | 25.05 | 25.05 | 25.05 | 25.05 | 100.0 |
| 2010-10-13 07:00:00 | MSFT | Stock | 25.05 | 25.1 | 25.05 | 25.1 | 1900.0 |
| 2010-10-13 07:30:00 | MSFT | Stock | 25.1 | 25.1 | 25.05 | 25.05 | 3960.0 |
| 2010-10-13 08:00:00 | MSFT | Stock | 25.03 | 25.05 | 25.02 | 25.03 | 31894.0 |
| 2010-10-13 08:30:00 | MSFT | Stock | 25.02 | 25.07 | 25.02 | 25.05 | 16984.0 |
| 2010-10-13 09:00:00 | MSFT | Stock | 25.05 | 25.07 | 25.0 | 25.01 | 84707.0 |
| 2010-10-13 09:30:00 | MSFT | Stock | 25.02 | 25.09 | 24.96 | 24.97 | 8830679.0 |
| 2010-10-13 10:00:00 | MSFT | Stock | 24.975 | 24.99 | 24.89 | 24.97 | 5089044.0 |
| 2010-10-13 10:30:00 | MSFT | Stock | 24.97 | 25.07 | 24.965 | 25.07 | 3176639.0 |
| 2010-10-13 11:00:00 | MSFT | Stock | 25.07 | 25.12 | 25.04 | 25.12 | 4117917.0 |
| 2010-10-13 11:30:00 | MSFT | Stock | 25.11 | 25.17 | 25.09 | 25.165 | 3015868.0 |
| 2010-10-13 12:00:00 | MSFT | Stock | 25.17 | 25.25 | 25.15 | 25.25 | 4502762.0 |
| 2010-10-13 12:30:00 | MSFT | Stock | 25.25 | 25.255 | 25.19 | 25.24 | 2376629.0 |
| 2010-10-13 13:00:00 | MSFT | Stock | 25.23 | 25.25 | 25.16 | 25.22 | 2667705.0 |
| 2010-10-13 13:30:00 | MSFT | Stock | 25.225 | 25.3 | 25.2 | 25.3 | 4366234.0 |
| 2010-10-13 14:00:00 | MSFT | Stock | 25.3 | 25.4 | 25.29 | 25.36 | 5476827.0 |
| 2010-10-13 14:30:00 | MSFT | Stock | 25.351 | 25.41 | 25.33 | 25.408 | 5832991.0 |
| 2010-10-13 15:00:00 | MSFT | Stock | 25.4 | 25.54 | 25.36 | 25.45 | 10507646.0 |
> showing 50 of 76,679 rows — these rows as CSV