PREVIEW / stock_30min / 2004-03-31
file: by_date/stock_30min/2004/2004-03-31.parquet size: 795 KB rows: 42,451 symbols: 1,750
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-03-31 08:00:00 | AAPL | Stock | 0.4986 | 0.5 | 0.4982 | 0.4982 | 78400.0 |
| 2004-03-31 09:00:00 | AAPL | Stock | 0.4982 | 0.4982 | 0.495 | 0.4964 | 485016.0 |
| 2004-03-31 09:30:00 | AAPL | Stock | 0.4975 | 0.4996 | 0.4939 | 0.4975 | 26087936.0 |
| 2004-03-31 10:00:00 | AAPL | Stock | 0.4977 | 0.4977 | 0.4939 | 0.4964 | 20812736.0 |
| 2004-03-31 10:30:00 | AAPL | Stock | 0.4963 | 0.4963 | 0.4934 | 0.4938 | 10789912.0 |
| 2004-03-31 11:00:00 | AAPL | Stock | 0.4938 | 0.4946 | 0.4938 | 0.4945 | 4408432.0 |
| 2004-03-31 11:30:00 | AAPL | Stock | 0.4945 | 0.4968 | 0.4938 | 0.4963 | 14290920.0 |
| 2004-03-31 12:00:00 | AAPL | Stock | 0.4964 | 0.4964 | 0.4941 | 0.4943 | 11214728.0 |
| 2004-03-31 12:30:00 | AAPL | Stock | 0.4945 | 0.4945 | 0.4914 | 0.4916 | 12796560.0 |
| 2004-03-31 13:00:00 | AAPL | Stock | 0.4914 | 0.4938 | 0.4911 | 0.492 | 13135640.0 |
| 2004-03-31 13:30:00 | AAPL | Stock | 0.4918 | 0.492 | 0.488 | 0.4884 | 25784136.0 |
| 2004-03-31 14:00:00 | AAPL | Stock | 0.4884 | 0.4916 | 0.4882 | 0.4911 | 18491144.0 |
| 2004-03-31 14:30:00 | AAPL | Stock | 0.4909 | 0.493 | 0.49 | 0.4907 | 25833584.0 |
| 2004-03-31 15:00:00 | AAPL | Stock | 0.4907 | 0.4907 | 0.4868 | 0.488 | 27175848.0 |
| 2004-03-31 15:30:00 | AAPL | Stock | 0.488 | 0.488 | 0.4813 | 0.4825 | 111904800.0 |
| 2004-03-31 16:00:00 | AAPL | Stock | 0.483 | 0.485 | 0.4814 | 0.4829 | 31759840.0 |
| 2004-03-31 16:30:00 | AAPL | Stock | 0.483 | 0.483 | 0.4829 | 0.4829 | 535024.0 |
| 2004-03-31 17:00:00 | AAPL | Stock | 0.4825 | 0.483 | 0.4825 | 0.483 | 481600.0 |
| 2004-03-31 17:30:00 | AAPL | Stock | 0.483 | 0.483 | 0.483 | 0.483 | 100800.0 |
| 2004-03-31 08:00:00 | MSFT | Stock | 25.2 | 25.26 | 25.2 | 25.21 | 353142.0 |
| 2004-03-31 08:30:00 | MSFT | Stock | 25.2 | 25.24 | 25.1 | 25.18 | 13433.0 |
| 2004-03-31 09:00:00 | MSFT | Stock | 25.2 | 25.2 | 25.15 | 25.19 | 435184.0 |
| 2004-03-31 09:30:00 | MSFT | Stock | 25.19 | 25.2 | 25.0 | 25.04 | 8335338.0 |
| 2004-03-31 10:00:00 | MSFT | Stock | 25.05 | 25.05 | 24.96 | 24.99 | 7817552.0 |
| 2004-03-31 10:30:00 | MSFT | Stock | 24.99 | 25.06 | 24.97 | 25.01 | 4642004.0 |
| 2004-03-31 11:00:00 | MSFT | Stock | 25.01 | 25.04 | 24.96 | 25.0 | 4191875.0 |
| 2004-03-31 11:30:00 | MSFT | Stock | 25.0 | 25.0 | 24.9399 | 24.97 | 3028478.0 |
| 2004-03-31 12:00:00 | MSFT | Stock | 24.97 | 25.04 | 24.97 | 24.99 | 3990800.0 |
| 2004-03-31 12:30:00 | MSFT | Stock | 24.99 | 25.01 | 24.96 | 25.0 | 1499410.0 |
| 2004-03-31 13:00:00 | MSFT | Stock | 24.99 | 25.0 | 24.96 | 24.97 | 1577029.0 |
| 2004-03-31 13:30:00 | MSFT | Stock | 24.96 | 24.97 | 24.8699 | 24.9 | 5760382.0 |
| 2004-03-31 14:00:00 | MSFT | Stock | 24.89 | 25.0 | 24.89 | 24.97 | 3604321.0 |
| 2004-03-31 14:30:00 | MSFT | Stock | 24.97 | 25.08 | 24.97 | 25.05 | 5697203.0 |
| 2004-03-31 15:00:00 | MSFT | Stock | 25.05 | 25.051 | 24.96 | 24.99 | 5031124.0 |
| 2004-03-31 15:30:00 | MSFT | Stock | 24.99 | 25.02 | 24.89 | 24.93 | 7485216.0 |
| 2004-03-31 16:00:00 | MSFT | Stock | 24.93 | 25.0 | 24.92 | 24.94 | 1709826.0 |
| 2004-03-31 16:30:00 | MSFT | Stock | 24.95 | 24.97 | 24.93 | 24.97 | 960720.0 |
| 2004-03-31 17:00:00 | MSFT | Stock | 24.95 | 24.97 | 24.95 | 24.97 | 8279.0 |
| 2004-03-31 17:30:00 | MSFT | Stock | 24.93 | 24.97 | 24.93 | 24.95 | 77494.0 |
| 2004-03-31 18:00:00 | MSFT | Stock | 24.95 | 25.0018 | 24.95 | 24.96 | 9649.0 |
| 2004-03-31 08:00:00 | NVDA | Stock | 0.2189 | 0.2192 | 0.2189 | 0.2192 | 164400.0 |
| 2004-03-31 08:30:00 | NVDA | Stock | 0.22 | 0.22 | 0.2182 | 0.2182 | 258000.0 |
| 2004-03-31 09:00:00 | NVDA | Stock | 0.2182 | 0.2188 | 0.2179 | 0.2188 | 4850160.0 |
| 2004-03-31 09:30:00 | NVDA | Stock | 0.2191 | 0.2223 | 0.2179 | 0.2215 | 111579480.0 |
| 2004-03-31 10:00:00 | NVDA | Stock | 0.2215 | 0.2215 | 0.2189 | 0.2196 | 66452760.0 |
| 2004-03-31 10:30:00 | NVDA | Stock | 0.2194 | 0.2204 | 0.2192 | 0.2195 | 47265600.0 |
| 2004-03-31 11:00:00 | NVDA | Stock | 0.2196 | 0.2202 | 0.2187 | 0.22 | 31996800.0 |
| 2004-03-31 11:30:00 | NVDA | Stock | 0.2201 | 0.2202 | 0.2192 | 0.2194 | 21765960.0 |
| 2004-03-31 12:00:00 | NVDA | Stock | 0.2194 | 0.2203 | 0.2192 | 0.2203 | 17423280.0 |
| 2004-03-31 12:30:00 | NVDA | Stock | 0.2203 | 0.2203 | 0.2197 | 0.2201 | 9834360.0 |
> showing 50 of 42,451 rows — these rows as CSV