PREVIEW / stock_30min / 2005-03-17
file: by_date/stock_30min/2005/2005-03-17.parquet size: 826 KB rows: 44,057 symbols: 1,934
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-17 08:00:00 | AAPL | Stock | 1.4911 | 1.4911 | 1.4707 | 1.4707 | 2558724.0 |
| 2005-03-17 08:30:00 | AAPL | Stock | 1.4832 | 1.4854 | 1.4793 | 1.4811 | 1389696.0 |
| 2005-03-17 09:00:00 | AAPL | Stock | 1.4811 | 1.49 | 1.4804 | 1.4839 | 1063524.0 |
| 2005-03-17 09:30:00 | AAPL | Stock | 1.4832 | 1.4993 | 1.4757 | 1.4868 | 98301672.0 |
| 2005-03-17 10:00:00 | AAPL | Stock | 1.4868 | 1.5004 | 1.4836 | 1.4975 | 68484276.0 |
| 2005-03-17 10:30:00 | AAPL | Stock | 1.4971 | 1.5061 | 1.49 | 1.5029 | 67689048.0 |
| 2005-03-17 11:00:00 | AAPL | Stock | 1.5029 | 1.5171 | 1.4982 | 1.5125 | 81288312.0 |
| 2005-03-17 11:30:00 | AAPL | Stock | 1.5125 | 1.5275 | 1.5118 | 1.5232 | 76036632.0 |
| 2005-03-17 12:00:00 | AAPL | Stock | 1.5229 | 1.5296 | 1.5182 | 1.5271 | 53379592.0 |
| 2005-03-17 12:30:00 | AAPL | Stock | 1.5268 | 1.5314 | 1.515 | 1.5179 | 38770480.0 |
| 2005-03-17 13:00:00 | AAPL | Stock | 1.5179 | 1.525 | 1.5118 | 1.5157 | 46532136.0 |
| 2005-03-17 13:30:00 | AAPL | Stock | 1.5161 | 1.5189 | 1.5093 | 1.5104 | 28186536.0 |
| 2005-03-17 14:00:00 | AAPL | Stock | 1.5107 | 1.5218 | 1.5039 | 1.5196 | 45177832.0 |
| 2005-03-17 14:30:00 | AAPL | Stock | 1.5196 | 1.5275 | 1.5146 | 1.5261 | 39677540.0 |
| 2005-03-17 15:00:00 | AAPL | Stock | 1.5261 | 1.5261 | 1.5179 | 1.5211 | 41430732.0 |
| 2005-03-17 15:30:00 | AAPL | Stock | 1.5214 | 1.5268 | 1.5089 | 1.5107 | 84774620.0 |
| 2005-03-17 16:00:00 | AAPL | Stock | 1.51 | 1.5143 | 1.5086 | 1.5121 | 3560984.0 |
| 2005-03-17 16:30:00 | AAPL | Stock | 1.5139 | 1.5143 | 1.509 | 1.5143 | 833700.0 |
| 2005-03-17 17:00:00 | AAPL | Stock | 1.5139 | 1.5148 | 1.5089 | 1.5101 | 950208.0 |
| 2005-03-17 17:30:00 | AAPL | Stock | 1.5154 | 1.5179 | 1.5089 | 1.5089 | 425936.0 |
| 2005-03-17 18:00:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 83020.0 |
| 2005-03-17 08:00:00 | MSFT | Stock | 24.65 | 24.66 | 24.61 | 24.61 | 2430.0 |
| 2005-03-17 08:30:00 | MSFT | Stock | 24.63 | 24.64 | 24.61 | 24.62 | 8820.0 |
| 2005-03-17 09:00:00 | MSFT | Stock | 24.62 | 24.65 | 24.62 | 24.64 | 102267.0 |
| 2005-03-17 09:30:00 | MSFT | Stock | 24.64 | 24.68 | 24.53 | 24.54 | 6755834.0 |
| 2005-03-17 10:00:00 | MSFT | Stock | 24.54 | 24.62 | 24.53 | 24.61 | 4972077.0 |
| 2005-03-17 10:30:00 | MSFT | Stock | 24.61 | 24.66 | 24.57 | 24.66 | 4300997.0 |
| 2005-03-17 11:00:00 | MSFT | Stock | 24.66 | 24.67 | 24.61 | 24.61 | 3038889.0 |
| 2005-03-17 11:30:00 | MSFT | Stock | 24.62 | 24.66 | 24.59 | 24.64 | 4125304.0 |
| 2005-03-17 12:00:00 | MSFT | Stock | 24.64 | 24.641 | 24.6 | 24.62 | 2345509.0 |
| 2005-03-17 12:30:00 | MSFT | Stock | 24.63 | 24.65 | 24.62 | 24.63 | 1966339.0 |
| 2005-03-17 13:00:00 | MSFT | Stock | 24.63 | 24.64 | 24.6 | 24.62 | 3200439.0 |
| 2005-03-17 13:30:00 | MSFT | Stock | 24.63 | 24.63 | 24.59 | 24.59 | 3953866.0 |
| 2005-03-17 14:00:00 | MSFT | Stock | 24.59 | 24.67 | 24.56 | 24.65 | 5782098.0 |
| 2005-03-17 14:30:00 | MSFT | Stock | 24.65 | 24.66 | 24.56 | 24.59 | 6289572.0 |
| 2005-03-17 15:00:00 | MSFT | Stock | 24.59 | 24.62 | 24.55 | 24.56 | 5351105.0 |
| 2005-03-17 15:30:00 | MSFT | Stock | 24.56 | 24.59 | 24.54 | 24.54 | 6749752.0 |
| 2005-03-17 16:00:00 | MSFT | Stock | 24.54 | 24.59 | 24.53 | 24.54 | 170594.0 |
| 2005-03-17 16:30:00 | MSFT | Stock | 24.55 | 24.55 | 24.51 | 24.51 | 117222.0 |
| 2005-03-17 17:00:00 | MSFT | Stock | 24.52 | 24.553 | 24.52 | 24.52 | 28502.0 |
| 2005-03-17 17:30:00 | MSFT | Stock | 24.54 | 24.56 | 24.52 | 24.54 | 28805.0 |
| 2005-03-17 18:00:00 | MSFT | Stock | 24.52 | 24.54 | 24.52 | 24.52 | 11962.0 |
| 2005-03-17 09:00:00 | NVDA | Stock | 0.2083 | 0.2092 | 0.2083 | 0.2091 | 240000.0 |
| 2005-03-17 09:30:00 | NVDA | Stock | 0.2083 | 0.2091 | 0.2062 | 0.2072 | 56856240.0 |
| 2005-03-17 10:00:00 | NVDA | Stock | 0.2072 | 0.2083 | 0.2061 | 0.2071 | 53119320.0 |
| 2005-03-17 10:30:00 | NVDA | Stock | 0.207 | 0.2072 | 0.2067 | 0.207 | 38610720.0 |
| 2005-03-17 11:00:00 | NVDA | Stock | 0.207 | 0.2079 | 0.207 | 0.2076 | 28977720.0 |
| 2005-03-17 11:30:00 | NVDA | Stock | 0.2074 | 0.2078 | 0.2072 | 0.2078 | 34828200.0 |
| 2005-03-17 12:00:00 | NVDA | Stock | 0.2077 | 0.2078 | 0.2067 | 0.2069 | 30971040.0 |
| 2005-03-17 12:30:00 | NVDA | Stock | 0.207 | 0.2074 | 0.2051 | 0.2067 | 19947960.0 |
> showing 50 of 44,057 rows — these rows as CSV