PREVIEW / stock_30min / 2004-01-16
file: by_date/stock_30min/2004/2004-01-16.parquet size: 767 KB rows: 39,959 symbols: 1,713
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-16 08:00:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.408 | 0.4107 | 207200.0 |
| 2004-01-16 08:30:00 | AAPL | Stock | 0.4109 | 0.412 | 0.4107 | 0.4107 | 673512.0 |
| 2004-01-16 09:00:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4084 | 0.4098 | 2052624.0 |
| 2004-01-16 09:30:00 | AAPL | Stock | 0.4106 | 0.4113 | 0.4061 | 0.4091 | 75923232.0 |
| 2004-01-16 10:00:00 | AAPL | Stock | 0.4089 | 0.4102 | 0.4073 | 0.4085 | 55007904.0 |
| 2004-01-16 10:30:00 | AAPL | Stock | 0.4086 | 0.4102 | 0.4057 | 0.4057 | 27679288.0 |
| 2004-01-16 11:00:00 | AAPL | Stock | 0.4057 | 0.4079 | 0.4054 | 0.4077 | 12580680.0 |
| 2004-01-16 11:30:00 | AAPL | Stock | 0.4073 | 0.4086 | 0.4055 | 0.4081 | 17714480.0 |
| 2004-01-16 12:00:00 | AAPL | Stock | 0.408 | 0.4086 | 0.407 | 0.4077 | 10196760.0 |
| 2004-01-16 12:30:00 | AAPL | Stock | 0.4077 | 0.4088 | 0.4073 | 0.4086 | 10134152.0 |
| 2004-01-16 13:00:00 | AAPL | Stock | 0.4088 | 0.41 | 0.4061 | 0.4062 | 12364800.0 |
| 2004-01-16 13:30:00 | AAPL | Stock | 0.4061 | 0.4084 | 0.4057 | 0.4082 | 20815200.0 |
| 2004-01-16 14:00:00 | AAPL | Stock | 0.4084 | 0.4086 | 0.4071 | 0.4082 | 12543664.0 |
| 2004-01-16 14:30:00 | AAPL | Stock | 0.4079 | 0.4079 | 0.4043 | 0.4046 | 22522136.0 |
| 2004-01-16 15:00:00 | AAPL | Stock | 0.4046 | 0.4064 | 0.4041 | 0.4048 | 27148520.0 |
| 2004-01-16 15:30:00 | AAPL | Stock | 0.4048 | 0.4061 | 0.4043 | 0.4043 | 39887344.0 |
| 2004-01-16 16:00:00 | AAPL | Stock | 0.4043 | 0.4071 | 0.4038 | 0.4071 | 9611224.0 |
| 2004-01-16 16:30:00 | AAPL | Stock | 0.4063 | 0.4071 | 0.4054 | 0.4054 | 330400.0 |
| 2004-01-16 17:00:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.404 | 0.4054 | 558880.0 |
| 2004-01-16 17:30:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4046 | 0.4046 | 50400.0 |
| 2004-01-16 18:00:00 | AAPL | Stock | 0.4043 | 0.4043 | 0.4038 | 0.4038 | 16800.0 |
| 2004-01-16 08:00:00 | MSFT | Stock | 27.59 | 27.7 | 27.59 | 27.65 | 46100.0 |
| 2004-01-16 08:30:00 | MSFT | Stock | 27.65 | 27.65 | 27.6 | 27.64 | 17743.0 |
| 2004-01-16 09:00:00 | MSFT | Stock | 27.64 | 27.74 | 27.6 | 27.73 | 256929.0 |
| 2004-01-16 09:30:00 | MSFT | Stock | 27.74 | 27.74 | 27.6 | 27.62 | 8030861.0 |
| 2004-01-16 10:00:00 | MSFT | Stock | 27.61 | 27.66 | 27.57 | 27.65 | 4408398.0 |
| 2004-01-16 10:30:00 | MSFT | Stock | 27.65 | 27.72 | 27.58 | 27.64 | 4920608.0 |
| 2004-01-16 11:00:00 | MSFT | Stock | 27.64 | 27.69 | 27.63 | 27.68 | 2146105.0 |
| 2004-01-16 11:30:00 | MSFT | Stock | 27.69 | 27.72 | 27.64 | 27.71 | 5455683.0 |
| 2004-01-16 12:00:00 | MSFT | Stock | 27.71 | 27.72 | 27.68 | 27.71 | 1981232.0 |
| 2004-01-16 12:30:00 | MSFT | Stock | 27.72 | 27.75 | 27.69 | 27.74 | 3064948.0 |
| 2004-01-16 13:00:00 | MSFT | Stock | 27.74 | 27.82 | 27.74 | 27.76 | 4366392.0 |
| 2004-01-16 13:30:00 | MSFT | Stock | 27.76 | 27.82 | 27.75 | 27.81 | 4116393.0 |
| 2004-01-16 14:00:00 | MSFT | Stock | 27.81 | 27.82 | 27.77 | 27.81 | 3243064.0 |
| 2004-01-16 14:30:00 | MSFT | Stock | 27.81 | 27.82 | 27.66 | 27.72 | 3777637.0 |
| 2004-01-16 15:00:00 | MSFT | Stock | 27.73 | 27.78 | 27.71 | 27.74 | 3156761.0 |
| 2004-01-16 15:30:00 | MSFT | Stock | 27.73 | 27.84 | 27.71 | 27.82 | 5521424.0 |
| 2004-01-16 16:00:00 | MSFT | Stock | 27.82 | 27.88 | 27.76 | 27.81 | 1152640.0 |
| 2004-01-16 16:30:00 | MSFT | Stock | 27.82 | 27.85 | 27.73 | 27.83 | 26990.0 |
| 2004-01-16 17:00:00 | MSFT | Stock | 27.8655 | 27.8655 | 27.83 | 27.83 | 51486.0 |
| 2004-01-16 17:30:00 | MSFT | Stock | 27.82 | 27.84 | 27.78 | 27.84 | 13160.0 |
| 2004-01-16 18:00:00 | MSFT | Stock | 27.84 | 27.85 | 27.66 | 27.66 | 13270.0 |
| 2004-01-16 08:00:00 | NVDA | Stock | 0.2083 | 0.2083 | 0.2033 | 0.2033 | 492000.0 |
| 2004-01-16 08:30:00 | NVDA | Stock | 0.2058 | 0.2058 | 0.2054 | 0.2054 | 288000.0 |
| 2004-01-16 09:00:00 | NVDA | Stock | 0.205 | 0.205 | 0.2038 | 0.2038 | 540000.0 |
| 2004-01-16 09:30:00 | NVDA | Stock | 0.2049 | 0.2056 | 0.2028 | 0.2032 | 55330440.0 |
| 2004-01-16 10:00:00 | NVDA | Stock | 0.203 | 0.2043 | 0.2026 | 0.2042 | 35829840.0 |
| 2004-01-16 10:30:00 | NVDA | Stock | 0.2042 | 0.2048 | 0.2032 | 0.2038 | 21393840.0 |
| 2004-01-16 11:00:00 | NVDA | Stock | 0.2038 | 0.2047 | 0.2037 | 0.2041 | 24823800.0 |
| 2004-01-16 11:30:00 | NVDA | Stock | 0.204 | 0.2049 | 0.2038 | 0.2044 | 23416560.0 |
> showing 50 of 39,959 rows — these rows as CSV