PREVIEW / stock_30min / 2009-10-15
file: by_date/stock_30min/2009/2009-10-15.parquet size: 1.4 MB rows: 73,248 symbols: 3,384
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-10-15 05:30:00 | AAPL | Stock | 6.8364 | 6.8364 | 6.8364 | 6.8364 | 4620.0 |
| 2009-10-15 07:00:00 | AAPL | Stock | 6.8036 | 6.8321 | 6.7871 | 6.8089 | 24920.0 |
| 2009-10-15 07:30:00 | AAPL | Stock | 6.8036 | 6.8036 | 6.7925 | 6.7929 | 56084.0 |
| 2009-10-15 08:00:00 | AAPL | Stock | 6.8036 | 6.8136 | 6.7814 | 6.7821 | 1237964.0 |
| 2009-10-15 08:30:00 | AAPL | Stock | 6.7857 | 6.7896 | 6.7768 | 6.7839 | 1333976.0 |
| 2009-10-15 09:00:00 | AAPL | Stock | 6.7839 | 6.7839 | 6.76 | 6.7732 | 1462412.0 |
| 2009-10-15 09:30:00 | AAPL | Stock | 6.7725 | 6.7918 | 6.7704 | 6.79 | 40045544.0 |
| 2009-10-15 10:00:00 | AAPL | Stock | 6.79 | 6.8186 | 6.7832 | 6.8061 | 43689856.0 |
| 2009-10-15 10:30:00 | AAPL | Stock | 6.8061 | 6.8143 | 6.7875 | 6.7893 | 30463580.0 |
| 2009-10-15 11:00:00 | AAPL | Stock | 6.7896 | 6.8 | 6.7807 | 6.7868 | 26042268.0 |
| 2009-10-15 11:30:00 | AAPL | Stock | 6.7864 | 6.8 | 6.7843 | 6.7982 | 13821892.0 |
| 2009-10-15 12:00:00 | AAPL | Stock | 6.7986 | 6.8064 | 6.7946 | 6.7946 | 15429988.0 |
| 2009-10-15 12:30:00 | AAPL | Stock | 6.7948 | 6.7979 | 6.7807 | 6.7836 | 16044224.0 |
| 2009-10-15 13:00:00 | AAPL | Stock | 6.7829 | 6.7889 | 6.7818 | 6.7865 | 12797316.0 |
| 2009-10-15 13:30:00 | AAPL | Stock | 6.7864 | 6.7911 | 6.7811 | 6.7844 | 17925516.0 |
| 2009-10-15 14:00:00 | AAPL | Stock | 6.785 | 6.7868 | 6.7689 | 6.7705 | 23441516.0 |
| 2009-10-15 14:30:00 | AAPL | Stock | 6.7705 | 6.8 | 6.7689 | 6.7914 | 29057784.0 |
| 2009-10-15 15:00:00 | AAPL | Stock | 6.7918 | 6.7929 | 6.7821 | 6.7861 | 21121688.0 |
| 2009-10-15 15:30:00 | AAPL | Stock | 6.7861 | 6.8057 | 6.7779 | 6.8057 | 43109360.0 |
| 2009-10-15 16:00:00 | AAPL | Stock | 6.8057 | 6.825 | 6.7868 | 6.8057 | 21495012.0 |
| 2009-10-15 16:30:00 | AAPL | Stock | 6.7964 | 6.8132 | 6.7954 | 6.8023 | 2534784.0 |
| 2009-10-15 17:00:00 | AAPL | Stock | 6.7964 | 6.8107 | 6.7964 | 6.8089 | 225652.0 |
| 2009-10-15 17:30:00 | AAPL | Stock | 6.81 | 6.8114 | 6.8086 | 6.8089 | 138936.0 |
| 2009-10-15 18:00:00 | AAPL | Stock | 6.8107 | 6.8143 | 6.805 | 6.8107 | 163268.0 |
| 2009-10-15 18:30:00 | AAPL | Stock | 6.805 | 6.8125 | 6.805 | 6.8125 | 69020.0 |
| 2009-10-15 19:00:00 | AAPL | Stock | 6.8136 | 6.8211 | 6.8132 | 6.8175 | 183540.0 |
| 2009-10-15 19:30:00 | AAPL | Stock | 6.8171 | 6.8171 | 6.8136 | 6.8136 | 120316.0 |
| 2009-10-15 05:00:00 | MSFT | Stock | 26.11 | 26.11 | 26.11 | 26.11 | 700.0 |
| 2009-10-15 06:30:00 | MSFT | Stock | 26.27 | 26.27 | 26.26 | 26.26 | 750.0 |
| 2009-10-15 07:00:00 | MSFT | Stock | 26.16 | 26.16 | 26.0 | 26.0 | 2100.0 |
| 2009-10-15 07:30:00 | MSFT | Stock | 25.98 | 25.98 | 25.9 | 25.9 | 4398.0 |
| 2009-10-15 08:00:00 | MSFT | Stock | 25.96 | 25.98 | 25.9 | 25.91 | 6293.0 |
| 2009-10-15 08:30:00 | MSFT | Stock | 25.9 | 25.9 | 25.83 | 25.87 | 14500.0 |
| 2009-10-15 09:00:00 | MSFT | Stock | 25.87 | 25.91 | 25.87 | 25.9 | 13024.0 |
| 2009-10-15 09:30:00 | MSFT | Stock | 25.9 | 26.23 | 25.89 | 26.23 | 5181522.0 |
| 2009-10-15 10:00:00 | MSFT | Stock | 26.23 | 26.33 | 26.15 | 26.31 | 4945123.0 |
| 2009-10-15 10:30:00 | MSFT | Stock | 26.31 | 26.32 | 26.17 | 26.24 | 3595854.0 |
| 2009-10-15 11:00:00 | MSFT | Stock | 26.25 | 26.27 | 26.14 | 26.22 | 2286420.0 |
| 2009-10-15 11:30:00 | MSFT | Stock | 26.21 | 26.33 | 26.2 | 26.305 | 2137902.0 |
| 2009-10-15 12:00:00 | MSFT | Stock | 26.305 | 26.5 | 26.3 | 26.465 | 6291722.0 |
| 2009-10-15 12:30:00 | MSFT | Stock | 26.47 | 26.55 | 26.46 | 26.51 | 4416075.0 |
| 2009-10-15 13:00:00 | MSFT | Stock | 26.51 | 26.58 | 26.5 | 26.56 | 2149568.0 |
| 2009-10-15 13:30:00 | MSFT | Stock | 26.57 | 26.58 | 26.3 | 26.5 | 2343252.0 |
| 2009-10-15 14:00:00 | MSFT | Stock | 26.49 | 26.53 | 26.47 | 26.5 | 3467782.0 |
| 2009-10-15 14:30:00 | MSFT | Stock | 26.495 | 26.57 | 26.49 | 26.55 | 4406514.0 |
| 2009-10-15 15:00:00 | MSFT | Stock | 26.541 | 26.65 | 26.53 | 26.61 | 5788573.0 |
| 2009-10-15 15:30:00 | MSFT | Stock | 26.62 | 26.71 | 26.55 | 26.71 | 8451914.0 |
| 2009-10-15 16:00:00 | MSFT | Stock | 26.71 | 26.72 | 26.394 | 26.57 | 5922380.0 |
| 2009-10-15 16:30:00 | MSFT | Stock | 26.71 | 26.71 | 26.484 | 26.697 | 701086.0 |
| 2009-10-15 17:00:00 | MSFT | Stock | 26.56 | 26.59 | 26.47 | 26.59 | 1958536.0 |
> showing 50 of 73,248 rows — these rows as CSV