PREVIEW / stock_30min / 2010-05-26
file: by_date/stock_30min/2010/2010-05-26.parquet size: 1.4 MB rows: 75,953 symbols: 3,468
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-05-26 04:00:00 | AAPL | Stock | 8.8839 | 8.8839 | 8.8571 | 8.8571 | 5600.0 |
| 2010-05-26 04:30:00 | AAPL | Stock | 8.8571 | 8.8746 | 8.8571 | 8.8746 | 12600.0 |
| 2010-05-26 05:00:00 | AAPL | Stock | 8.8839 | 8.8839 | 8.8839 | 8.8839 | 14000.0 |
| 2010-05-26 05:30:00 | AAPL | Stock | 8.8875 | 8.8929 | 8.8875 | 8.8929 | 5852.0 |
| 2010-05-26 06:00:00 | AAPL | Stock | 8.8839 | 8.8839 | 8.8643 | 8.8643 | 43120.0 |
| 2010-05-26 06:30:00 | AAPL | Stock | 8.8629 | 8.8732 | 8.8554 | 8.8661 | 78400.0 |
| 2010-05-26 07:00:00 | AAPL | Stock | 8.87 | 8.9018 | 8.8675 | 8.8839 | 637616.0 |
| 2010-05-26 07:30:00 | AAPL | Stock | 8.8779 | 8.9007 | 8.8771 | 8.8929 | 546280.0 |
| 2010-05-26 08:00:00 | AAPL | Stock | 8.8679 | 8.9482 | 8.8679 | 8.9304 | 5352676.0 |
| 2010-05-26 08:30:00 | AAPL | Stock | 8.9286 | 8.9407 | 8.9 | 8.9146 | 4659760.0 |
| 2010-05-26 09:00:00 | AAPL | Stock | 8.9136 | 8.9375 | 8.8946 | 8.9296 | 4666900.0 |
| 2010-05-26 09:30:00 | AAPL | Stock | 8.9296 | 8.9921 | 8.905 | 8.9754 | 130412212.0 |
| 2010-05-26 10:00:00 | AAPL | Stock | 8.9768 | 9.0046 | 8.9611 | 8.9854 | 70168868.0 |
| 2010-05-26 10:30:00 | AAPL | Stock | 8.9857 | 9.0 | 8.9514 | 8.9557 | 52777228.0 |
| 2010-05-26 11:00:00 | AAPL | Stock | 8.9564 | 8.9929 | 8.8978 | 8.905 | 61156004.0 |
| 2010-05-26 11:30:00 | AAPL | Stock | 8.9066 | 8.9257 | 8.8714 | 8.9193 | 50536192.0 |
| 2010-05-26 12:00:00 | AAPL | Stock | 8.9196 | 8.9429 | 8.9021 | 8.9071 | 29188068.0 |
| 2010-05-26 12:30:00 | AAPL | Stock | 8.9061 | 8.9457 | 8.8929 | 8.9425 | 32169228.0 |
| 2010-05-26 13:00:00 | AAPL | Stock | 8.945 | 8.9457 | 8.9139 | 8.9193 | 22626968.0 |
| 2010-05-26 13:30:00 | AAPL | Stock | 8.9193 | 8.9586 | 8.9071 | 8.9354 | 30928660.0 |
| 2010-05-26 14:00:00 | AAPL | Stock | 8.9354 | 8.9414 | 8.8968 | 8.9114 | 28504728.0 |
| 2010-05-26 14:30:00 | AAPL | Stock | 8.9118 | 8.9736 | 8.8211 | 8.8693 | 73103884.0 |
| 2010-05-26 15:00:00 | AAPL | Stock | 8.8682 | 8.8843 | 8.7054 | 8.7607 | 89534928.0 |
| 2010-05-26 15:30:00 | AAPL | Stock | 8.76 | 8.7854 | 8.7054 | 8.7182 | 124650288.0 |
| 2010-05-26 16:00:00 | AAPL | Stock | 8.7179 | 8.8913 | 8.6725 | 8.675 | 22382640.0 |
| 2010-05-26 16:30:00 | AAPL | Stock | 8.6786 | 8.8902 | 8.6714 | 8.6964 | 2252404.0 |
| 2010-05-26 17:00:00 | AAPL | Stock | 8.6964 | 8.9086 | 8.6718 | 8.6718 | 663264.0 |
| 2010-05-26 17:30:00 | AAPL | Stock | 8.6786 | 8.6861 | 8.6714 | 8.6782 | 966280.0 |
| 2010-05-26 18:00:00 | AAPL | Stock | 8.675 | 8.7182 | 8.6732 | 8.6786 | 228732.0 |
| 2010-05-26 18:30:00 | AAPL | Stock | 8.6807 | 8.6821 | 8.6786 | 8.6821 | 111552.0 |
| 2010-05-26 19:00:00 | AAPL | Stock | 8.6821 | 8.6893 | 8.6732 | 8.6732 | 200676.0 |
| 2010-05-26 19:30:00 | AAPL | Stock | 8.6829 | 8.7082 | 8.6821 | 8.7082 | 246288.0 |
| 2010-05-26 20:00:00 | AAPL | Stock | 8.7593 | 8.9043 | 8.7593 | 8.9043 | 254800.0 |
| 2010-05-26 07:00:00 | MSFT | Stock | 26.34 | 26.34 | 26.24 | 26.24 | 2200.0 |
| 2010-05-26 07:30:00 | MSFT | Stock | 26.31 | 26.32 | 26.26 | 26.29 | 2600.0 |
| 2010-05-26 08:00:00 | MSFT | Stock | 26.26 | 26.4 | 26.116 | 26.36 | 32312.0 |
| 2010-05-26 08:30:00 | MSFT | Stock | 26.36 | 26.39 | 26.26 | 26.35 | 54181.0 |
| 2010-05-26 09:00:00 | MSFT | Stock | 26.35 | 26.45 | 26.21 | 26.22 | 139098.0 |
| 2010-05-26 09:30:00 | MSFT | Stock | 26.23 | 26.36 | 26.05 | 26.33 | 11166584.0 |
| 2010-05-26 10:00:00 | MSFT | Stock | 26.33 | 26.42 | 26.28 | 26.32 | 5878609.0 |
| 2010-05-26 10:30:00 | MSFT | Stock | 26.31 | 26.605 | 26.3 | 26.32 | 6859565.0 |
| 2010-05-26 11:00:00 | MSFT | Stock | 26.32 | 26.32 | 26.1 | 26.11 | 6281116.0 |
| 2010-05-26 11:30:00 | MSFT | Stock | 26.112 | 26.15 | 25.9 | 26.049 | 6619325.0 |
| 2010-05-26 12:00:00 | MSFT | Stock | 26.045 | 26.1 | 25.99 | 26.028 | 3807020.0 |
| 2010-05-26 12:30:00 | MSFT | Stock | 26.03 | 26.05 | 25.92 | 26.04 | 5945102.0 |
| 2010-05-26 13:00:00 | MSFT | Stock | 26.04 | 26.1 | 26.0 | 26.02 | 3857729.0 |
| 2010-05-26 13:30:00 | MSFT | Stock | 26.025 | 26.12 | 26.01 | 26.05 | 3447145.0 |
| 2010-05-26 14:00:00 | MSFT | Stock | 26.045 | 26.07 | 25.75 | 25.8 | 6360070.0 |
| 2010-05-26 14:30:00 | MSFT | Stock | 25.81 | 25.83 | 25.28 | 25.49 | 15157441.0 |
| 2010-05-26 15:00:00 | MSFT | Stock | 25.49 | 25.52 | 24.56 | 24.79 | 36955865.0 |
> showing 50 of 75,953 rows — these rows as CSV