PREVIEW / stock_30min / 2007-02-21
file: by_date/stock_30min/2007/2007-02-21.parquet size: 1002 KB rows: 54,224 symbols: 2,532
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-21 07:00:00 | AAPL | Stock | 3.0686 | 3.0804 | 3.0679 | 3.0804 | 95900.0 |
| 2007-02-21 07:30:00 | AAPL | Stock | 3.0761 | 3.0821 | 3.075 | 3.0807 | 218848.0 |
| 2007-02-21 08:00:00 | AAPL | Stock | 3.0814 | 3.0821 | 3.0732 | 3.0786 | 1658300.0 |
| 2007-02-21 08:30:00 | AAPL | Stock | 3.0768 | 3.0818 | 3.0607 | 3.0714 | 2801372.0 |
| 2007-02-21 09:00:00 | AAPL | Stock | 3.0721 | 3.0768 | 3.07 | 3.07 | 1927072.0 |
| 2007-02-21 09:30:00 | AAPL | Stock | 3.0707 | 3.1339 | 3.07 | 3.1246 | 197549268.0 |
| 2007-02-21 10:00:00 | AAPL | Stock | 3.125 | 3.1607 | 3.1229 | 3.1604 | 160440420.0 |
| 2007-02-21 10:30:00 | AAPL | Stock | 3.1607 | 3.1643 | 3.1486 | 3.1593 | 101362996.0 |
| 2007-02-21 11:00:00 | AAPL | Stock | 3.1589 | 3.1682 | 3.1504 | 3.1575 | 78941296.0 |
| 2007-02-21 11:30:00 | AAPL | Stock | 3.1575 | 3.1771 | 3.1575 | 3.1725 | 81796792.0 |
| 2007-02-21 12:00:00 | AAPL | Stock | 3.1721 | 3.1754 | 3.1671 | 3.1696 | 37110920.0 |
| 2007-02-21 12:30:00 | AAPL | Stock | 3.1696 | 3.1736 | 3.1636 | 3.1718 | 41631660.0 |
| 2007-02-21 13:00:00 | AAPL | Stock | 3.1718 | 3.1854 | 3.1707 | 3.1843 | 55879124.0 |
| 2007-02-21 13:30:00 | AAPL | Stock | 3.1843 | 3.1957 | 3.1746 | 3.1786 | 90613068.0 |
| 2007-02-21 14:00:00 | AAPL | Stock | 3.1786 | 3.1843 | 3.1668 | 3.1839 | 71488536.0 |
| 2007-02-21 14:30:00 | AAPL | Stock | 3.1836 | 3.1896 | 3.1796 | 3.1886 | 54563432.0 |
| 2007-02-21 15:00:00 | AAPL | Stock | 3.1889 | 3.1961 | 3.1793 | 3.1825 | 69391532.0 |
| 2007-02-21 15:30:00 | AAPL | Stock | 3.1821 | 3.1886 | 3.175 | 3.1857 | 92343412.0 |
| 2007-02-21 16:00:00 | AAPL | Stock | 3.1854 | 3.1875 | 3.1829 | 3.1861 | 2746380.0 |
| 2007-02-21 16:30:00 | AAPL | Stock | 3.1857 | 3.1857 | 3.1825 | 3.1832 | 233072.0 |
| 2007-02-21 17:00:00 | AAPL | Stock | 3.1832 | 3.1857 | 3.1821 | 3.1825 | 298732.0 |
| 2007-02-21 17:30:00 | AAPL | Stock | 3.1829 | 3.1846 | 3.1821 | 3.1836 | 80080.0 |
| 2007-02-21 18:00:00 | AAPL | Stock | 3.1854 | 3.1857 | 3.1821 | 3.1854 | 117460.0 |
| 2007-02-21 18:30:00 | AAPL | Stock | 3.1829 | 3.1857 | 3.1825 | 3.1854 | 179480.0 |
| 2007-02-21 19:00:00 | AAPL | Stock | 3.1839 | 3.1839 | 3.1818 | 3.1821 | 313600.0 |
| 2007-02-21 19:30:00 | AAPL | Stock | 3.1821 | 3.1854 | 3.1821 | 3.1854 | 96068.0 |
| 2007-02-21 08:00:00 | MSFT | Stock | 28.7 | 28.81 | 28.7 | 28.8 | 9329.0 |
| 2007-02-21 08:30:00 | MSFT | Stock | 28.79 | 28.79 | 28.7 | 28.73 | 32301.0 |
| 2007-02-21 09:00:00 | MSFT | Stock | 28.73 | 28.83 | 28.7 | 28.75 | 1182747.0 |
| 2007-02-21 09:30:00 | MSFT | Stock | 28.75 | 28.98 | 28.74 | 28.93 | 7187775.0 |
| 2007-02-21 10:00:00 | MSFT | Stock | 28.93 | 29.01 | 28.92 | 28.95 | 4361790.0 |
| 2007-02-21 10:30:00 | MSFT | Stock | 28.947 | 29.18 | 28.91 | 29.12 | 5282044.0 |
| 2007-02-21 11:00:00 | MSFT | Stock | 29.12 | 29.12 | 28.9 | 28.98 | 5032448.0 |
| 2007-02-21 11:30:00 | MSFT | Stock | 28.97 | 29.11 | 28.95 | 29.08 | 3528872.0 |
| 2007-02-21 12:00:00 | MSFT | Stock | 29.08 | 29.12 | 29.05 | 29.1 | 3159924.0 |
| 2007-02-21 12:30:00 | MSFT | Stock | 29.101 | 29.15 | 28.99 | 29.1 | 3575636.0 |
| 2007-02-21 13:00:00 | MSFT | Stock | 29.1 | 29.22 | 29.1 | 29.21 | 3421936.0 |
| 2007-02-21 13:30:00 | MSFT | Stock | 29.21 | 29.21 | 29.12 | 29.14 | 3368488.0 |
| 2007-02-21 14:00:00 | MSFT | Stock | 29.14 | 29.21 | 29.13 | 29.16 | 3618517.0 |
| 2007-02-21 14:30:00 | MSFT | Stock | 29.16 | 29.23 | 29.16 | 29.23 | 3316096.0 |
| 2007-02-21 15:00:00 | MSFT | Stock | 29.22 | 29.25 | 29.2 | 29.24 | 4793198.0 |
| 2007-02-21 15:30:00 | MSFT | Stock | 29.241 | 29.39 | 29.23 | 29.34 | 11094998.0 |
| 2007-02-21 16:00:00 | MSFT | Stock | 29.35 | 29.44 | 29.31 | 29.35 | 655577.0 |
| 2007-02-21 16:30:00 | MSFT | Stock | 29.35 | 29.35 | 29.34 | 29.34 | 13085.0 |
| 2007-02-21 17:00:00 | MSFT | Stock | 29.35 | 29.35 | 29.33 | 29.35 | 35523.0 |
| 2007-02-21 17:30:00 | MSFT | Stock | 29.35 | 29.35 | 29.35 | 29.35 | 1100.0 |
| 2007-02-21 18:00:00 | MSFT | Stock | 29.35 | 29.35 | 29.34 | 29.35 | 7075.0 |
| 2007-02-21 18:30:00 | MSFT | Stock | 29.38 | 29.38 | 29.38 | 29.38 | 3966.0 |
| 2007-02-21 19:00:00 | MSFT | Stock | 29.38 | 29.4 | 29.38 | 29.38 | 1130.0 |
| 2007-02-21 19:30:00 | MSFT | Stock | 29.34 | 29.4 | 29.33 | 29.33 | 2086.0 |
> showing 50 of 54,224 rows — these rows as CSV