PREVIEW / stock_1hour / 2001-03-08
file: by_date/stock_1hour/2001/2001-03-08.parquet size: 347 KB rows: 16,354 symbols: 1,263
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 |
|---|---|---|---|---|---|---|---|
| 2001-03-08 08:00:00 | AAPL | Stock | 0.3756 | 0.38 | 0.3616 | 0.3772 | 515200.0 |
| 2001-03-08 09:00:00 | AAPL | Stock | 0.3705 | 0.3739 | 0.365 | 0.3728 | 29831200.0 |
| 2001-03-08 10:00:00 | AAPL | Stock | 0.3717 | 0.3728 | 0.3672 | 0.3683 | 45724000.0 |
| 2001-03-08 11:00:00 | AAPL | Stock | 0.3683 | 0.3772 | 0.3672 | 0.3767 | 35263200.0 |
| 2001-03-08 12:00:00 | AAPL | Stock | 0.3761 | 0.3761 | 0.3705 | 0.3717 | 12885600.0 |
| 2001-03-08 13:00:00 | AAPL | Stock | 0.3717 | 0.3739 | 0.3694 | 0.3717 | 17528000.0 |
| 2001-03-08 14:00:00 | AAPL | Stock | 0.3717 | 0.3717 | 0.3672 | 0.3694 | 25771200.0 |
| 2001-03-08 15:00:00 | AAPL | Stock | 0.3683 | 0.3739 | 0.3683 | 0.3717 | 22058400.0 |
| 2001-03-08 16:00:00 | AAPL | Stock | 0.3717 | 0.375 | 0.3705 | 0.3717 | 9441600.0 |
| 2001-03-08 17:00:00 | AAPL | Stock | 0.3705 | 0.3717 | 0.3594 | 0.3672 | 1013600.0 |
| 2001-03-08 18:00:00 | AAPL | Stock | 0.3672 | 0.3672 | 0.3661 | 0.3661 | 67200.0 |
| 2001-03-08 08:00:00 | MSFT | Stock | 30.375 | 30.375 | 30.0 | 30.0625 | 236600.0 |
| 2001-03-08 09:00:00 | MSFT | Stock | 29.9688 | 30.25 | 29.9688 | 30.0625 | 4799600.0 |
| 2001-03-08 10:00:00 | MSFT | Stock | 30.0625 | 30.1562 | 29.7188 | 29.8125 | 9356200.0 |
| 2001-03-08 11:00:00 | MSFT | Stock | 29.8125 | 30.2969 | 29.6875 | 30.2188 | 5295400.0 |
| 2001-03-08 12:00:00 | MSFT | Stock | 30.25 | 30.25 | 29.7812 | 29.9375 | 5871600.0 |
| 2001-03-08 13:00:00 | MSFT | Stock | 29.9375 | 29.9688 | 29.625 | 29.6562 | 4183200.0 |
| 2001-03-08 14:00:00 | MSFT | Stock | 29.6562 | 29.6875 | 29.2188 | 29.4688 | 7944200.0 |
| 2001-03-08 15:00:00 | MSFT | Stock | 29.5 | 29.8125 | 29.375 | 29.5938 | 10185800.0 |
| 2001-03-08 16:00:00 | MSFT | Stock | 29.5938 | 29.7188 | 29.5 | 29.625 | 3148600.0 |
| 2001-03-08 17:00:00 | MSFT | Stock | 29.5312 | 29.625 | 28.875 | 28.9375 | 547600.0 |
| 2001-03-08 18:00:00 | MSFT | Stock | 28.9531 | 29.0 | 28.9375 | 28.9375 | 22400.0 |
| 2001-03-08 08:00:00 | NVDA | Stock | 0.2177 | 0.2182 | 0.2125 | 0.2135 | 480000.0 |
| 2001-03-08 09:00:00 | NVDA | Stock | 0.2125 | 0.2172 | 0.2109 | 0.2135 | 97584000.0 |
| 2001-03-08 10:00:00 | NVDA | Stock | 0.2135 | 0.225 | 0.212 | 0.2221 | 185880000.0 |
| 2001-03-08 11:00:00 | NVDA | Stock | 0.2219 | 0.2268 | 0.2198 | 0.2253 | 94728000.0 |
| 2001-03-08 12:00:00 | NVDA | Stock | 0.2253 | 0.2255 | 0.2219 | 0.2234 | 75432000.0 |
| 2001-03-08 13:00:00 | NVDA | Stock | 0.2234 | 0.2242 | 0.2208 | 0.2216 | 69840000.0 |
| 2001-03-08 14:00:00 | NVDA | Stock | 0.2219 | 0.2234 | 0.2211 | 0.2227 | 68472000.0 |
| 2001-03-08 15:00:00 | NVDA | Stock | 0.2227 | 0.2263 | 0.2198 | 0.2243 | 190848000.0 |
| 2001-03-08 16:00:00 | NVDA | Stock | 0.2242 | 0.2245 | 0.2202 | 0.2229 | 15168000.0 |
| 2001-03-08 17:00:00 | NVDA | Stock | 0.2216 | 0.2224 | 0.2125 | 0.2148 | 2160000.0 |
| 2001-03-08 18:00:00 | NVDA | Stock | 0.2159 | 0.2159 | 0.2146 | 0.2146 | 216000.0 |
| 2001-03-08 08:00:00 | AMZN | Stock | 0.6016 | 0.6109 | 0.5844 | 0.5875 | 530000.0 |
| 2001-03-08 09:00:00 | AMZN | Stock | 0.5844 | 0.6031 | 0.5812 | 0.5906 | 21920000.0 |
| 2001-03-08 10:00:00 | AMZN | Stock | 0.5906 | 0.5969 | 0.5812 | 0.5906 | 20548000.0 |
| 2001-03-08 11:00:00 | AMZN | Stock | 0.5938 | 0.5969 | 0.5906 | 0.5938 | 14940000.0 |
| 2001-03-08 12:00:00 | AMZN | Stock | 0.5938 | 0.5938 | 0.5875 | 0.5906 | 6716000.0 |
| 2001-03-08 13:00:00 | AMZN | Stock | 0.5906 | 0.5938 | 0.5844 | 0.5875 | 7058000.0 |
| 2001-03-08 14:00:00 | AMZN | Stock | 0.5906 | 0.5906 | 0.5844 | 0.5875 | 9706000.0 |
| 2001-03-08 15:00:00 | AMZN | Stock | 0.5891 | 0.5938 | 0.5812 | 0.5875 | 10704000.0 |
| 2001-03-08 16:00:00 | AMZN | Stock | 0.5844 | 0.5891 | 0.575 | 0.5844 | 2464000.0 |
| 2001-03-08 17:00:00 | AMZN | Stock | 0.5781 | 0.5812 | 0.5781 | 0.5812 | 40000.0 |
| 2001-03-08 18:00:00 | AMZN | Stock | 0.5875 | 0.5875 | 0.5875 | 0.5875 | 10000.0 |
| 2001-03-08 09:00:00 | CL | Stock | 29.375 | 29.5 | 29.35 | 29.435 | 257400.0 |
| 2001-03-08 10:00:00 | CL | Stock | 29.435 | 29.475 | 29.175 | 29.25 | 277600.0 |
| 2001-03-08 11:00:00 | CL | Stock | 29.275 | 29.575 | 29.265 | 29.495 | 440800.0 |
| 2001-03-08 12:00:00 | CL | Stock | 29.495 | 29.565 | 29.47 | 29.52 | 207600.0 |
| 2001-03-08 13:00:00 | CL | Stock | 29.52 | 29.7 | 29.52 | 29.685 | 220600.0 |
| 2001-03-08 14:00:00 | CL | Stock | 29.675 | 29.95 | 29.65 | 29.925 | 488600.0 |
> showing 50 of 16,354 rows — these rows as CSV