PREVIEW / stock_30min / 2009-07-14
file: by_date/stock_30min/2009/2009-07-14.parquet size: 1.3 MB rows: 69,051 symbols: 3,344
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-07-14 07:00:00 | AAPL | Stock | 5.125 | 5.125 | 5.0714 | 5.0714 | 22288.0 |
| 2009-07-14 07:30:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0839 | 5.0893 | 170800.0 |
| 2009-07-14 08:00:00 | AAPL | Stock | 5.0875 | 5.0893 | 5.0714 | 5.0768 | 352296.0 |
| 2009-07-14 08:30:00 | AAPL | Stock | 5.0721 | 5.0804 | 5.0679 | 5.0707 | 861364.0 |
| 2009-07-14 09:00:00 | AAPL | Stock | 5.0679 | 5.0832 | 5.0679 | 5.0714 | 660492.0 |
| 2009-07-14 09:30:00 | AAPL | Stock | 5.0671 | 5.1136 | 5.0415 | 5.0506 | 73305064.0 |
| 2009-07-14 10:00:00 | AAPL | Stock | 5.0518 | 5.0864 | 5.0486 | 5.0646 | 34620180.0 |
| 2009-07-14 10:30:00 | AAPL | Stock | 5.0646 | 5.0796 | 5.0464 | 5.0779 | 27319096.0 |
| 2009-07-14 11:00:00 | AAPL | Stock | 5.0779 | 5.1029 | 5.0743 | 5.0996 | 22190308.0 |
| 2009-07-14 11:30:00 | AAPL | Stock | 5.0993 | 5.1043 | 5.0832 | 5.0879 | 18054568.0 |
| 2009-07-14 12:00:00 | AAPL | Stock | 5.0882 | 5.0889 | 5.0725 | 5.0771 | 15852760.0 |
| 2009-07-14 12:30:00 | AAPL | Stock | 5.0775 | 5.0832 | 5.065 | 5.0793 | 14366576.0 |
| 2009-07-14 13:00:00 | AAPL | Stock | 5.08 | 5.0893 | 5.0743 | 5.0827 | 10386516.0 |
| 2009-07-14 13:30:00 | AAPL | Stock | 5.0818 | 5.0854 | 5.0768 | 5.0789 | 9187724.0 |
| 2009-07-14 14:00:00 | AAPL | Stock | 5.0789 | 5.0821 | 5.0679 | 5.075 | 15401624.0 |
| 2009-07-14 14:30:00 | AAPL | Stock | 5.0757 | 5.0893 | 5.0729 | 5.0825 | 18746728.0 |
| 2009-07-14 15:00:00 | AAPL | Stock | 5.0818 | 5.0854 | 5.0596 | 5.0675 | 24730104.0 |
| 2009-07-14 15:30:00 | AAPL | Stock | 5.0671 | 5.0875 | 5.0571 | 5.0811 | 44381008.0 |
| 2009-07-14 16:00:00 | AAPL | Stock | 5.08 | 5.1382 | 5.0624 | 5.1321 | 8693608.0 |
| 2009-07-14 16:30:00 | AAPL | Stock | 5.1321 | 5.1518 | 5.0811 | 5.1504 | 3274096.0 |
| 2009-07-14 17:00:00 | AAPL | Stock | 5.1518 | 5.1686 | 5.0783 | 5.1675 | 2035880.0 |
| 2009-07-14 17:30:00 | AAPL | Stock | 5.1654 | 5.1714 | 5.1554 | 5.1607 | 467376.0 |
| 2009-07-14 18:00:00 | AAPL | Stock | 5.1607 | 5.1607 | 5.0811 | 5.1589 | 335160.0 |
| 2009-07-14 18:30:00 | AAPL | Stock | 5.1589 | 5.1607 | 5.1557 | 5.1557 | 110600.0 |
| 2009-07-14 19:00:00 | AAPL | Stock | 5.1571 | 5.1607 | 5.1571 | 5.1607 | 72100.0 |
| 2009-07-14 19:30:00 | AAPL | Stock | 5.1607 | 5.1643 | 5.1607 | 5.1607 | 61068.0 |
| 2009-07-14 08:00:00 | MSFT | Stock | 23.16 | 23.25 | 23.16 | 23.24 | 5408.0 |
| 2009-07-14 08:30:00 | MSFT | Stock | 23.17 | 23.22 | 23.13 | 23.16 | 8627.0 |
| 2009-07-14 09:00:00 | MSFT | Stock | 23.17 | 23.31 | 23.15 | 23.19 | 28952.0 |
| 2009-07-14 09:30:00 | MSFT | Stock | 23.2 | 23.2 | 22.92 | 23.08 | 7445383.0 |
| 2009-07-14 10:00:00 | MSFT | Stock | 23.08 | 23.2 | 23.02 | 23.04 | 3727984.0 |
| 2009-07-14 10:30:00 | MSFT | Stock | 23.035 | 23.05 | 22.86 | 22.907 | 3107917.0 |
| 2009-07-14 11:00:00 | MSFT | Stock | 22.91 | 23.13 | 22.9 | 23.11 | 2760811.0 |
| 2009-07-14 11:30:00 | MSFT | Stock | 23.12 | 23.22 | 23.08 | 23.205 | 2466824.0 |
| 2009-07-14 12:00:00 | MSFT | Stock | 23.2 | 23.21 | 23.07 | 23.11 | 1717327.0 |
| 2009-07-14 12:30:00 | MSFT | Stock | 23.11 | 23.15 | 23.07 | 23.12 | 1727200.0 |
| 2009-07-14 13:00:00 | MSFT | Stock | 23.11 | 23.13 | 23.06 | 23.08 | 1426377.0 |
| 2009-07-14 13:30:00 | MSFT | Stock | 23.085 | 23.13 | 23.07 | 23.07 | 1682053.0 |
| 2009-07-14 14:00:00 | MSFT | Stock | 23.072 | 23.11 | 23.01 | 23.06 | 2447327.0 |
| 2009-07-14 14:30:00 | MSFT | Stock | 23.05 | 23.1 | 23.04 | 23.05 | 2331098.0 |
| 2009-07-14 15:00:00 | MSFT | Stock | 23.06 | 23.06 | 22.98 | 22.99 | 4269569.0 |
| 2009-07-14 15:30:00 | MSFT | Stock | 22.98 | 23.11 | 22.95 | 23.11 | 6518868.0 |
| 2009-07-14 16:00:00 | MSFT | Stock | 23.1 | 23.71 | 23.056 | 23.7 | 1664499.0 |
| 2009-07-14 16:30:00 | MSFT | Stock | 23.68 | 23.9 | 23.11 | 23.79 | 843422.0 |
| 2009-07-14 17:00:00 | MSFT | Stock | 23.76 | 23.81 | 23.377 | 23.77 | 71543.0 |
| 2009-07-14 17:30:00 | MSFT | Stock | 23.055 | 23.77 | 23.055 | 23.72 | 50208.0 |
| 2009-07-14 18:00:00 | MSFT | Stock | 23.72 | 23.72 | 23.11 | 23.72 | 33369.0 |
| 2009-07-14 18:30:00 | MSFT | Stock | 23.71 | 23.75 | 23.71 | 23.72 | 11130.0 |
| 2009-07-14 19:00:00 | MSFT | Stock | 23.75 | 23.76 | 23.71 | 23.73 | 4607.0 |
| 2009-07-14 19:30:00 | MSFT | Stock | 23.73 | 23.76 | 23.73 | 23.76 | 4236.0 |
> showing 50 of 69,051 rows — these rows as CSV