PREVIEW / stock_30min / 2009-10-08
file: by_date/stock_30min/2009/2009-10-08.parquet size: 1.3 MB rows: 72,213 symbols: 3,386
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-08 06:00:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8393 | 6.8393 | 2800.0 |
| 2009-10-08 06:30:00 | AAPL | Stock | 6.8446 | 6.8446 | 6.8446 | 6.8446 | 5600.0 |
| 2009-10-08 07:00:00 | AAPL | Stock | 6.8446 | 6.85 | 6.8375 | 6.8375 | 65716.0 |
| 2009-10-08 07:30:00 | AAPL | Stock | 6.8339 | 6.8393 | 6.8221 | 6.8304 | 105560.0 |
| 2009-10-08 08:00:00 | AAPL | Stock | 6.8304 | 6.835 | 6.8221 | 6.8339 | 1553356.0 |
| 2009-10-08 08:30:00 | AAPL | Stock | 6.8339 | 6.8375 | 6.8125 | 6.8229 | 2949156.0 |
| 2009-10-08 09:00:00 | AAPL | Stock | 6.8218 | 6.825 | 6.8 | 6.8129 | 3639496.0 |
| 2009-10-08 09:30:00 | AAPL | Stock | 6.8129 | 6.8375 | 6.7893 | 6.8071 | 74995256.0 |
| 2009-10-08 10:00:00 | AAPL | Stock | 6.8068 | 6.8189 | 6.7864 | 6.8093 | 41106688.0 |
| 2009-10-08 10:30:00 | AAPL | Stock | 6.8079 | 6.8204 | 6.8025 | 6.8132 | 21046620.0 |
| 2009-10-08 11:00:00 | AAPL | Stock | 6.8129 | 6.8346 | 6.8046 | 6.8318 | 24201184.0 |
| 2009-10-08 11:30:00 | AAPL | Stock | 6.8325 | 6.8339 | 6.815 | 6.8204 | 22726452.0 |
| 2009-10-08 12:00:00 | AAPL | Stock | 6.8202 | 6.8287 | 6.8118 | 6.8254 | 13951084.0 |
| 2009-10-08 12:30:00 | AAPL | Stock | 6.8257 | 6.8282 | 6.8179 | 6.8241 | 13237700.0 |
| 2009-10-08 13:00:00 | AAPL | Stock | 6.8232 | 6.8243 | 6.7946 | 6.8054 | 19985224.0 |
| 2009-10-08 13:30:00 | AAPL | Stock | 6.8054 | 6.8086 | 6.7746 | 6.8047 | 32857888.0 |
| 2009-10-08 14:00:00 | AAPL | Stock | 6.805 | 6.8136 | 6.7571 | 6.7682 | 31647420.0 |
| 2009-10-08 14:30:00 | AAPL | Stock | 6.7671 | 6.7979 | 6.7632 | 6.7789 | 27072416.0 |
| 2009-10-08 15:00:00 | AAPL | Stock | 6.7793 | 6.8082 | 6.7771 | 6.7796 | 25418176.0 |
| 2009-10-08 15:30:00 | AAPL | Stock | 6.7796 | 6.78 | 6.7461 | 6.7589 | 61094376.0 |
| 2009-10-08 16:00:00 | AAPL | Stock | 6.7589 | 6.7981 | 6.7532 | 6.7611 | 15712648.0 |
| 2009-10-08 16:30:00 | AAPL | Stock | 6.7596 | 6.7714 | 6.7596 | 6.7671 | 3002608.0 |
| 2009-10-08 17:00:00 | AAPL | Stock | 6.7679 | 6.7679 | 6.7618 | 6.7643 | 105588.0 |
| 2009-10-08 17:30:00 | AAPL | Stock | 6.7625 | 6.7721 | 6.7625 | 6.7679 | 251160.0 |
| 2009-10-08 18:00:00 | AAPL | Stock | 6.7679 | 6.7679 | 6.7596 | 6.7679 | 328020.0 |
| 2009-10-08 18:30:00 | AAPL | Stock | 6.7711 | 6.7711 | 6.7696 | 6.7704 | 8680.0 |
| 2009-10-08 19:00:00 | AAPL | Stock | 6.7682 | 6.7696 | 6.7636 | 6.7696 | 258720.0 |
| 2009-10-08 19:30:00 | AAPL | Stock | 6.7668 | 6.7686 | 6.7639 | 6.7639 | 45780.0 |
| 2009-10-08 20:00:00 | AAPL | Stock | 6.8129 | 6.8129 | 6.8129 | 6.8129 | 64400.0 |
| 2009-10-08 04:00:00 | MSFT | Stock | 25.26 | 25.29 | 25.26 | 25.29 | 600.0 |
| 2009-10-08 04:30:00 | MSFT | Stock | 25.4 | 25.4 | 25.4 | 25.4 | 100.0 |
| 2009-10-08 07:00:00 | MSFT | Stock | 25.35 | 25.35 | 25.3 | 25.35 | 900.0 |
| 2009-10-08 07:30:00 | MSFT | Stock | 25.35 | 25.35 | 25.35 | 25.35 | 250.0 |
| 2009-10-08 08:00:00 | MSFT | Stock | 25.3 | 25.35 | 25.23 | 25.3 | 35320.0 |
| 2009-10-08 08:30:00 | MSFT | Stock | 25.33 | 25.42 | 25.33 | 25.4 | 23846.0 |
| 2009-10-08 09:00:00 | MSFT | Stock | 25.38 | 25.45 | 25.38 | 25.45 | 55947.0 |
| 2009-10-08 09:30:00 | MSFT | Stock | 25.44 | 25.49 | 25.22 | 25.465 | 7691094.0 |
| 2009-10-08 10:00:00 | MSFT | Stock | 25.461 | 25.57 | 25.4 | 25.57 | 6126175.0 |
| 2009-10-08 10:30:00 | MSFT | Stock | 25.565 | 25.73 | 25.56 | 25.67 | 5071556.0 |
| 2009-10-08 11:00:00 | MSFT | Stock | 25.67 | 25.87 | 25.67 | 25.831 | 3956772.0 |
| 2009-10-08 11:30:00 | MSFT | Stock | 25.84 | 25.88 | 25.8 | 25.81 | 3727374.0 |
| 2009-10-08 12:00:00 | MSFT | Stock | 25.81 | 25.85 | 25.73 | 25.84 | 4964716.0 |
| 2009-10-08 12:30:00 | MSFT | Stock | 25.84 | 25.86 | 25.75 | 25.815 | 2343232.0 |
| 2009-10-08 13:00:00 | MSFT | Stock | 25.81 | 25.87 | 25.8 | 25.865 | 2165894.0 |
| 2009-10-08 13:30:00 | MSFT | Stock | 25.86 | 25.9 | 25.81 | 25.89 | 3219859.0 |
| 2009-10-08 14:00:00 | MSFT | Stock | 25.88 | 25.89 | 25.71 | 25.73 | 2398022.0 |
| 2009-10-08 14:30:00 | MSFT | Stock | 25.731 | 25.82 | 25.73 | 25.81 | 1587127.0 |
| 2009-10-08 15:00:00 | MSFT | Stock | 25.819 | 25.86 | 25.76 | 25.77 | 2148997.0 |
| 2009-10-08 15:30:00 | MSFT | Stock | 25.76 | 25.77 | 25.67 | 25.67 | 6070581.0 |
| 2009-10-08 16:00:00 | MSFT | Stock | 25.66 | 25.786 | 25.66 | 25.7 | 5330366.0 |
> showing 50 of 72,213 rows — these rows as CSV