PREVIEW / stock_30min / 2009-12-03
file: by_date/stock_30min/2009/2009-12-03.parquet size: 1.3 MB rows: 72,217 symbols: 3,423
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-12-03 04:00:00 | AAPL | Stock | 7.0664 | 7.0664 | 7.0664 | 7.0664 | 2800.0 |
| 2009-12-03 04:30:00 | AAPL | Stock | 7.0686 | 7.085 | 7.0682 | 7.085 | 15120.0 |
| 2009-12-03 05:00:00 | AAPL | Stock | 7.0714 | 7.0718 | 7.0696 | 7.0714 | 34720.0 |
| 2009-12-03 05:30:00 | AAPL | Stock | 7.0832 | 7.0836 | 7.0832 | 7.0832 | 22540.0 |
| 2009-12-03 06:00:00 | AAPL | Stock | 7.0725 | 7.0725 | 7.0725 | 7.0725 | 13496.0 |
| 2009-12-03 06:30:00 | AAPL | Stock | 7.0582 | 7.0582 | 7.0582 | 7.0582 | 6160.0 |
| 2009-12-03 07:00:00 | AAPL | Stock | 7.0454 | 7.0732 | 7.0454 | 7.0732 | 151144.0 |
| 2009-12-03 07:30:00 | AAPL | Stock | 7.0629 | 7.0679 | 7.0575 | 7.0575 | 85932.0 |
| 2009-12-03 08:00:00 | AAPL | Stock | 7.06 | 7.0714 | 7.0571 | 7.0639 | 1252468.0 |
| 2009-12-03 08:30:00 | AAPL | Stock | 7.0629 | 7.0718 | 7.0393 | 7.0414 | 1802164.0 |
| 2009-12-03 09:00:00 | AAPL | Stock | 7.0411 | 7.0618 | 7.0393 | 7.0532 | 1806392.0 |
| 2009-12-03 09:30:00 | AAPL | Stock | 7.0536 | 7.085 | 7.0414 | 7.0729 | 69500116.0 |
| 2009-12-03 10:00:00 | AAPL | Stock | 7.0718 | 7.0746 | 7.0096 | 7.0407 | 61977384.0 |
| 2009-12-03 10:30:00 | AAPL | Stock | 7.0404 | 7.0664 | 7.0221 | 7.0596 | 37014740.0 |
| 2009-12-03 11:00:00 | AAPL | Stock | 7.06 | 7.0714 | 7.0539 | 7.0586 | 20318424.0 |
| 2009-12-03 11:30:00 | AAPL | Stock | 7.0575 | 7.0661 | 7.0357 | 7.0483 | 18373348.0 |
| 2009-12-03 12:00:00 | AAPL | Stock | 7.0482 | 7.0614 | 7.0343 | 7.0518 | 18757340.0 |
| 2009-12-03 12:30:00 | AAPL | Stock | 7.0518 | 7.0971 | 7.0425 | 7.0917 | 30739632.0 |
| 2009-12-03 13:00:00 | AAPL | Stock | 7.0914 | 7.0918 | 7.0718 | 7.0832 | 23939216.0 |
| 2009-12-03 13:30:00 | AAPL | Stock | 7.0829 | 7.1064 | 7.08 | 7.0996 | 18618852.0 |
| 2009-12-03 14:00:00 | AAPL | Stock | 7.0993 | 7.1039 | 7.0729 | 7.0764 | 22191176.0 |
| 2009-12-03 14:30:00 | AAPL | Stock | 7.0764 | 7.0964 | 7.0764 | 7.087 | 18027128.0 |
| 2009-12-03 15:00:00 | AAPL | Stock | 7.0864 | 7.0982 | 7.0679 | 7.0732 | 24760848.0 |
| 2009-12-03 15:30:00 | AAPL | Stock | 7.0732 | 7.08 | 7.0179 | 7.0179 | 59590076.0 |
| 2009-12-03 16:00:00 | AAPL | Stock | 7.0179 | 7.0602 | 7.0121 | 7.0232 | 7790916.0 |
| 2009-12-03 16:30:00 | AAPL | Stock | 7.0186 | 7.0218 | 6.9893 | 6.9893 | 921620.0 |
| 2009-12-03 17:00:00 | AAPL | Stock | 6.9929 | 6.9975 | 6.9804 | 6.9804 | 969500.0 |
| 2009-12-03 17:30:00 | AAPL | Stock | 6.9804 | 6.9875 | 6.9732 | 6.9746 | 576940.0 |
| 2009-12-03 18:00:00 | AAPL | Stock | 6.9743 | 7.0171 | 6.9732 | 6.9825 | 189112.0 |
| 2009-12-03 18:30:00 | AAPL | Stock | 6.9857 | 6.9893 | 6.9786 | 6.9825 | 230328.0 |
| 2009-12-03 19:00:00 | AAPL | Stock | 6.9875 | 6.9893 | 6.9821 | 6.9857 | 157584.0 |
| 2009-12-03 19:30:00 | AAPL | Stock | 6.9839 | 6.9889 | 6.9821 | 6.9864 | 226968.0 |
| 2009-12-03 07:30:00 | MSFT | Stock | 29.87 | 29.87 | 29.84 | 29.84 | 1180.0 |
| 2009-12-03 08:00:00 | MSFT | Stock | 29.85 | 29.9 | 29.85 | 29.89 | 5810.0 |
| 2009-12-03 08:30:00 | MSFT | Stock | 29.89 | 29.9 | 29.86 | 29.86 | 10334.0 |
| 2009-12-03 09:00:00 | MSFT | Stock | 29.89 | 29.92 | 29.83 | 29.85 | 38432.0 |
| 2009-12-03 09:30:00 | MSFT | Stock | 29.84 | 30.2 | 29.76 | 30.08 | 7826085.0 |
| 2009-12-03 10:00:00 | MSFT | Stock | 30.08 | 30.1 | 29.91 | 29.95 | 6931578.0 |
| 2009-12-03 10:30:00 | MSFT | Stock | 29.952 | 30.06 | 29.92 | 30.02 | 2629455.0 |
| 2009-12-03 11:00:00 | MSFT | Stock | 30.019 | 30.03 | 29.91 | 30.0 | 2761474.0 |
| 2009-12-03 11:30:00 | MSFT | Stock | 30.0 | 30.02 | 29.95 | 29.98 | 1271278.0 |
| 2009-12-03 12:00:00 | MSFT | Stock | 29.98 | 30.03 | 29.95 | 29.95 | 1616871.0 |
| 2009-12-03 12:30:00 | MSFT | Stock | 29.95 | 29.99 | 29.95 | 29.985 | 1397680.0 |
| 2009-12-03 13:00:00 | MSFT | Stock | 29.98 | 30.01 | 29.95 | 29.99 | 1320036.0 |
| 2009-12-03 13:30:00 | MSFT | Stock | 29.995 | 30.03 | 29.98 | 30.0 | 1004797.0 |
| 2009-12-03 14:00:00 | MSFT | Stock | 29.995 | 30.02 | 29.97 | 29.992 | 1531515.0 |
| 2009-12-03 14:30:00 | MSFT | Stock | 29.995 | 30.05 | 29.99 | 30.03 | 1711189.0 |
| 2009-12-03 15:00:00 | MSFT | Stock | 30.032 | 30.08 | 30.0 | 30.01 | 2597557.0 |
| 2009-12-03 15:30:00 | MSFT | Stock | 30.0 | 30.04 | 29.81 | 29.83 | 8035828.0 |
| 2009-12-03 16:00:00 | MSFT | Stock | 29.83 | 30.003 | 29.7 | 29.7 | 1248432.0 |
> showing 50 of 72,217 rows — these rows as CSV