PREVIEW / stock_30min / 2008-07-24
file: by_date/stock_30min/2008/2008-07-24.parquet size: 1.3 MB rows: 68,963 symbols: 3,330
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-07-24 06:30:00 | AAPL | Stock | 5.945 | 5.945 | 5.945 | 5.945 | 2800.0 |
| 2008-07-24 07:00:00 | AAPL | Stock | 5.9346 | 5.9371 | 5.9346 | 5.9371 | 18900.0 |
| 2008-07-24 07:30:00 | AAPL | Stock | 5.9375 | 5.9375 | 5.9018 | 5.9018 | 190120.0 |
| 2008-07-24 08:00:00 | AAPL | Stock | 5.9211 | 5.9379 | 5.9111 | 5.9375 | 4079180.0 |
| 2008-07-24 08:30:00 | AAPL | Stock | 5.9286 | 5.9379 | 5.8786 | 5.8839 | 1573488.0 |
| 2008-07-24 09:00:00 | AAPL | Stock | 5.8839 | 5.9007 | 5.8571 | 5.8696 | 2860256.0 |
| 2008-07-24 09:30:00 | AAPL | Stock | 5.8711 | 5.9021 | 5.8071 | 5.8621 | 101317244.0 |
| 2008-07-24 10:00:00 | AAPL | Stock | 5.8621 | 5.8625 | 5.7686 | 5.7843 | 88960116.0 |
| 2008-07-24 10:30:00 | AAPL | Stock | 5.7846 | 5.8054 | 5.7332 | 5.7464 | 83122228.0 |
| 2008-07-24 11:00:00 | AAPL | Stock | 5.7468 | 5.7514 | 5.6743 | 5.7104 | 92369732.0 |
| 2008-07-24 11:30:00 | AAPL | Stock | 5.7114 | 5.7457 | 5.7018 | 5.7196 | 53926684.0 |
| 2008-07-24 12:00:00 | AAPL | Stock | 5.7198 | 5.7518 | 5.7104 | 5.7254 | 34751920.0 |
| 2008-07-24 12:30:00 | AAPL | Stock | 5.7254 | 5.7729 | 5.7232 | 5.7464 | 39371024.0 |
| 2008-07-24 13:00:00 | AAPL | Stock | 5.7464 | 5.7857 | 5.7171 | 5.7791 | 47339908.0 |
| 2008-07-24 13:30:00 | AAPL | Stock | 5.7775 | 5.8029 | 5.7593 | 5.7932 | 40512276.0 |
| 2008-07-24 14:00:00 | AAPL | Stock | 5.7932 | 5.7964 | 5.7161 | 5.7229 | 50780016.0 |
| 2008-07-24 14:30:00 | AAPL | Stock | 5.7232 | 5.7357 | 5.7068 | 5.7287 | 38518340.0 |
| 2008-07-24 15:00:00 | AAPL | Stock | 5.7289 | 5.7589 | 5.7121 | 5.7263 | 48934228.0 |
| 2008-07-24 15:30:00 | AAPL | Stock | 5.725 | 5.7386 | 5.6589 | 5.6814 | 79420096.0 |
| 2008-07-24 16:00:00 | AAPL | Stock | 5.6818 | 5.7562 | 5.6754 | 5.68 | 16582552.0 |
| 2008-07-24 16:30:00 | AAPL | Stock | 5.6796 | 5.7537 | 5.6754 | 5.6814 | 3057124.0 |
| 2008-07-24 17:00:00 | AAPL | Stock | 5.6786 | 5.6821 | 5.6732 | 5.6814 | 394296.0 |
| 2008-07-24 17:30:00 | AAPL | Stock | 5.6789 | 5.6789 | 5.665 | 5.6714 | 156688.0 |
| 2008-07-24 18:00:00 | AAPL | Stock | 5.67 | 5.6796 | 5.6661 | 5.6714 | 855148.0 |
| 2008-07-24 18:30:00 | AAPL | Stock | 5.6714 | 5.6714 | 5.65 | 5.6679 | 416976.0 |
| 2008-07-24 19:00:00 | AAPL | Stock | 5.6654 | 5.6679 | 5.6643 | 5.6671 | 46116.0 |
| 2008-07-24 19:30:00 | AAPL | Stock | 5.6654 | 5.6736 | 5.6643 | 5.6736 | 115696.0 |
| 2008-07-24 04:00:00 | MSFT | Stock | 26.43 | 26.43 | 26.43 | 26.43 | 200.0 |
| 2008-07-24 07:00:00 | MSFT | Stock | 26.06 | 26.06 | 26.06 | 26.06 | 1400.0 |
| 2008-07-24 07:30:00 | MSFT | Stock | 26.14 | 26.35 | 26.14 | 26.16 | 10500.0 |
| 2008-07-24 08:00:00 | MSFT | Stock | 26.24 | 26.71 | 26.24 | 26.34 | 902779.0 |
| 2008-07-24 08:30:00 | MSFT | Stock | 26.34 | 26.36 | 26.3 | 26.3 | 44060.0 |
| 2008-07-24 09:00:00 | MSFT | Stock | 26.3 | 26.3 | 26.04 | 26.09 | 192595.0 |
| 2008-07-24 09:30:00 | MSFT | Stock | 26.1 | 26.17 | 25.75 | 25.83 | 6708245.0 |
| 2008-07-24 10:00:00 | MSFT | Stock | 25.83 | 25.83 | 25.54 | 25.591 | 9235911.0 |
| 2008-07-24 10:30:00 | MSFT | Stock | 25.59 | 25.64 | 25.5 | 25.59 | 7384298.0 |
| 2008-07-24 11:00:00 | MSFT | Stock | 25.59 | 25.6 | 25.46 | 25.5 | 4608989.0 |
| 2008-07-24 11:30:00 | MSFT | Stock | 25.49 | 25.635 | 25.44 | 25.592 | 5864338.0 |
| 2008-07-24 12:00:00 | MSFT | Stock | 25.6 | 25.63 | 25.54 | 25.56 | 2713494.0 |
| 2008-07-24 12:30:00 | MSFT | Stock | 25.56 | 25.652 | 25.53 | 25.61 | 3001098.0 |
| 2008-07-24 13:00:00 | MSFT | Stock | 25.61 | 25.71 | 25.53 | 25.71 | 3884189.0 |
| 2008-07-24 13:30:00 | MSFT | Stock | 25.71 | 25.76 | 25.57 | 25.59 | 3805741.0 |
| 2008-07-24 14:00:00 | MSFT | Stock | 25.59 | 25.61 | 25.52 | 25.535 | 3672088.0 |
| 2008-07-24 14:30:00 | MSFT | Stock | 25.531 | 25.61 | 25.52 | 25.58 | 3353983.0 |
| 2008-07-24 15:00:00 | MSFT | Stock | 25.58 | 25.65 | 25.48 | 25.53 | 7042652.0 |
| 2008-07-24 15:30:00 | MSFT | Stock | 25.53 | 25.55 | 25.44 | 25.44 | 12097962.0 |
| 2008-07-24 16:00:00 | MSFT | Stock | 25.45 | 25.608 | 25.41 | 25.45 | 3179260.0 |
| 2008-07-24 16:30:00 | MSFT | Stock | 25.44 | 25.61 | 25.43 | 25.5 | 328263.0 |
| 2008-07-24 17:00:00 | MSFT | Stock | 25.5 | 25.51 | 25.46 | 25.5 | 4000.0 |
| 2008-07-24 17:30:00 | MSFT | Stock | 25.49 | 25.53 | 25.49 | 25.53 | 118237.0 |
> showing 50 of 68,963 rows — these rows as CSV