PREVIEW / stock_30min / 2009-06-24
file: by_date/stock_30min/2009/2009-06-24.parquet size: 1.3 MB rows: 70,384 symbols: 3,359
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-06-24 06:00:00 | AAPL | Stock | 4.7896 | 4.7896 | 4.7896 | 4.7896 | 2800.0 |
| 2009-06-24 06:30:00 | AAPL | Stock | 4.7857 | 4.7857 | 4.7857 | 4.7857 | 5600.0 |
| 2009-06-24 07:00:00 | AAPL | Stock | 4.8207 | 4.8214 | 4.8168 | 4.8168 | 76608.0 |
| 2009-06-24 07:30:00 | AAPL | Stock | 4.8089 | 4.8096 | 4.8007 | 4.8096 | 57820.0 |
| 2009-06-24 08:00:00 | AAPL | Stock | 4.8043 | 4.8132 | 4.7964 | 4.81 | 817152.0 |
| 2009-06-24 08:30:00 | AAPL | Stock | 4.8089 | 4.8679 | 4.8089 | 4.8604 | 2783228.0 |
| 2009-06-24 09:00:00 | AAPL | Stock | 4.8629 | 4.8643 | 4.8296 | 4.8368 | 1589700.0 |
| 2009-06-24 09:30:00 | AAPL | Stock | 4.8364 | 4.8607 | 4.8164 | 4.8536 | 74577216.0 |
| 2009-06-24 10:00:00 | AAPL | Stock | 4.8536 | 4.9039 | 4.8371 | 4.8879 | 67466112.0 |
| 2009-06-24 10:30:00 | AAPL | Stock | 4.8879 | 4.9089 | 4.8804 | 4.8807 | 36699236.0 |
| 2009-06-24 11:00:00 | AAPL | Stock | 4.8807 | 4.9107 | 4.8807 | 4.9084 | 21839832.0 |
| 2009-06-24 11:30:00 | AAPL | Stock | 4.9086 | 4.9107 | 4.8975 | 4.9043 | 16058280.0 |
| 2009-06-24 12:00:00 | AAPL | Stock | 4.9043 | 4.9057 | 4.8861 | 4.8911 | 14167888.0 |
| 2009-06-24 12:30:00 | AAPL | Stock | 4.8911 | 4.9004 | 4.8857 | 4.8975 | 14868448.0 |
| 2009-06-24 13:00:00 | AAPL | Stock | 4.8975 | 4.9071 | 4.8943 | 4.8981 | 10384640.0 |
| 2009-06-24 13:30:00 | AAPL | Stock | 4.8977 | 4.8979 | 4.8832 | 4.8874 | 14803684.0 |
| 2009-06-24 14:00:00 | AAPL | Stock | 4.8871 | 4.9032 | 4.8704 | 4.8771 | 28866432.0 |
| 2009-06-24 14:30:00 | AAPL | Stock | 4.8764 | 4.8964 | 4.8596 | 4.8818 | 47163872.0 |
| 2009-06-24 15:00:00 | AAPL | Stock | 4.882 | 4.8893 | 4.8375 | 4.8571 | 59188836.0 |
| 2009-06-24 15:30:00 | AAPL | Stock | 4.8579 | 4.8732 | 4.8414 | 4.8668 | 45320716.0 |
| 2009-06-24 16:00:00 | AAPL | Stock | 4.8664 | 4.8731 | 4.8643 | 4.8707 | 17882564.0 |
| 2009-06-24 16:30:00 | AAPL | Stock | 4.8707 | 4.8729 | 4.865 | 4.87 | 95648.0 |
| 2009-06-24 17:00:00 | AAPL | Stock | 4.8714 | 4.8732 | 4.7861 | 4.8732 | 351540.0 |
| 2009-06-24 17:30:00 | AAPL | Stock | 4.8768 | 4.8839 | 4.8768 | 4.8779 | 249480.0 |
| 2009-06-24 18:00:00 | AAPL | Stock | 4.8771 | 4.8796 | 4.865 | 4.8796 | 803348.0 |
| 2009-06-24 18:30:00 | AAPL | Stock | 4.8775 | 4.8804 | 4.8768 | 4.8804 | 63448.0 |
| 2009-06-24 19:00:00 | AAPL | Stock | 4.8782 | 4.8782 | 4.8746 | 4.8746 | 140140.0 |
| 2009-06-24 19:30:00 | AAPL | Stock | 4.8736 | 4.8746 | 4.8704 | 4.8746 | 145936.0 |
| 2009-06-24 07:30:00 | MSFT | Stock | 23.41 | 23.45 | 23.41 | 23.45 | 1100.0 |
| 2009-06-24 08:00:00 | MSFT | Stock | 23.49 | 23.49 | 23.45 | 23.47 | 12100.0 |
| 2009-06-24 08:30:00 | MSFT | Stock | 23.49 | 23.54 | 23.49 | 23.54 | 10434.0 |
| 2009-06-24 09:00:00 | MSFT | Stock | 23.55 | 23.57 | 23.45 | 23.46 | 18987.0 |
| 2009-06-24 09:30:00 | MSFT | Stock | 23.46 | 23.6 | 23.4 | 23.445 | 5843960.0 |
| 2009-06-24 10:00:00 | MSFT | Stock | 23.46 | 23.54 | 23.36 | 23.515 | 6344858.0 |
| 2009-06-24 10:30:00 | MSFT | Stock | 23.52 | 23.7 | 23.49 | 23.7 | 4803404.0 |
| 2009-06-24 11:00:00 | MSFT | Stock | 23.697 | 23.75 | 23.61 | 23.75 | 2843815.0 |
| 2009-06-24 11:30:00 | MSFT | Stock | 23.75 | 23.75 | 23.63 | 23.63 | 1919630.0 |
| 2009-06-24 12:00:00 | MSFT | Stock | 23.63 | 23.65 | 23.59 | 23.62 | 3311037.0 |
| 2009-06-24 12:30:00 | MSFT | Stock | 23.63 | 23.72 | 23.6 | 23.69 | 2308093.0 |
| 2009-06-24 13:00:00 | MSFT | Stock | 23.69 | 23.75 | 23.66 | 23.68 | 1499748.0 |
| 2009-06-24 13:30:00 | MSFT | Stock | 23.68 | 23.7 | 23.64 | 23.675 | 2019269.0 |
| 2009-06-24 14:00:00 | MSFT | Stock | 23.68 | 23.75 | 23.58 | 23.62 | 4686910.0 |
| 2009-06-24 14:30:00 | MSFT | Stock | 23.61 | 23.64 | 23.48 | 23.59 | 5317796.0 |
| 2009-06-24 15:00:00 | MSFT | Stock | 23.59 | 23.64 | 23.39 | 23.49 | 5041551.0 |
| 2009-06-24 15:30:00 | MSFT | Stock | 23.48 | 23.6 | 23.42 | 23.49 | 5252667.0 |
| 2009-06-24 16:00:00 | MSFT | Stock | 23.49 | 23.59 | 23.47 | 23.48 | 2388816.0 |
| 2009-06-24 16:30:00 | MSFT | Stock | 23.47 | 23.54 | 23.47 | 23.49 | 20693.0 |
| 2009-06-24 17:00:00 | MSFT | Stock | 23.34 | 23.34 | 23.34 | 23.34 | 9200.0 |
| 2009-06-24 17:30:00 | MSFT | Stock | 23.5 | 23.51 | 23.5 | 23.5 | 600.0 |
| 2009-06-24 18:00:00 | MSFT | Stock | 23.5 | 23.52 | 23.47 | 23.47 | 7455.0 |
> showing 50 of 70,384 rows — these rows as CSV