PREVIEW / stock_30min / 2005-08-11
file: by_date/stock_30min/2005/2005-08-11.parquet size: 837 KB rows: 44,899 symbols: 2,054
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-08-11 08:00:00 | AAPL | Stock | 1.5536 | 1.5571 | 1.5493 | 1.5536 | 195608.0 |
| 2005-08-11 08:30:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5493 | 1.55 | 81004.0 |
| 2005-08-11 09:00:00 | AAPL | Stock | 1.5493 | 1.55 | 1.5454 | 1.5457 | 719180.0 |
| 2005-08-11 09:30:00 | AAPL | Stock | 1.5496 | 1.5586 | 1.5446 | 1.555 | 30585604.0 |
| 2005-08-11 10:00:00 | AAPL | Stock | 1.5554 | 1.5721 | 1.5546 | 1.5685 | 33939500.0 |
| 2005-08-11 10:30:00 | AAPL | Stock | 1.5682 | 1.5714 | 1.5654 | 1.5675 | 18858672.0 |
| 2005-08-11 11:00:00 | AAPL | Stock | 1.5675 | 1.5704 | 1.5629 | 1.5643 | 14287812.0 |
| 2005-08-11 11:30:00 | AAPL | Stock | 1.5639 | 1.5686 | 1.5607 | 1.5679 | 14901488.0 |
| 2005-08-11 12:00:00 | AAPL | Stock | 1.5675 | 1.5679 | 1.5607 | 1.5611 | 18547564.0 |
| 2005-08-11 12:30:00 | AAPL | Stock | 1.5611 | 1.5629 | 1.5593 | 1.5625 | 6252260.0 |
| 2005-08-11 13:00:00 | AAPL | Stock | 1.5625 | 1.5664 | 1.5614 | 1.5636 | 7649180.0 |
| 2005-08-11 13:30:00 | AAPL | Stock | 1.5639 | 1.5664 | 1.5625 | 1.565 | 7867944.0 |
| 2005-08-11 14:00:00 | AAPL | Stock | 1.5654 | 1.5664 | 1.5632 | 1.5654 | 20962676.0 |
| 2005-08-11 14:30:00 | AAPL | Stock | 1.565 | 1.5707 | 1.565 | 1.5679 | 16456720.0 |
| 2005-08-11 15:00:00 | AAPL | Stock | 1.5682 | 1.5711 | 1.5664 | 1.57 | 19434604.0 |
| 2005-08-11 15:30:00 | AAPL | Stock | 1.5704 | 1.5757 | 1.57 | 1.5707 | 49464380.0 |
| 2005-08-11 16:00:00 | AAPL | Stock | 1.5714 | 1.5725 | 1.5593 | 1.5643 | 4726036.0 |
| 2005-08-11 16:30:00 | AAPL | Stock | 1.5625 | 1.5714 | 1.5614 | 1.5614 | 2706928.0 |
| 2005-08-11 17:00:00 | AAPL | Stock | 1.5618 | 1.57 | 1.5607 | 1.5625 | 414400.0 |
| 2005-08-11 17:30:00 | AAPL | Stock | 1.5625 | 1.5643 | 1.5621 | 1.5625 | 189364.0 |
| 2005-08-11 18:00:00 | AAPL | Stock | 1.5714 | 1.5714 | 1.5625 | 1.5629 | 40096.0 |
| 2005-08-11 07:30:00 | MSFT | Stock | 26.99 | 26.99 | 26.99 | 26.99 | 500.0 |
| 2005-08-11 08:00:00 | MSFT | Stock | 27.0 | 27.04 | 26.95 | 27.02 | 26650.0 |
| 2005-08-11 08:30:00 | MSFT | Stock | 27.02 | 27.05 | 26.97 | 27.0 | 22564.0 |
| 2005-08-11 09:00:00 | MSFT | Stock | 27.02 | 27.05 | 26.96 | 26.98 | 40031.0 |
| 2005-08-11 09:30:00 | MSFT | Stock | 26.98 | 27.18 | 26.97 | 27.071 | 5549208.0 |
| 2005-08-11 10:00:00 | MSFT | Stock | 27.08 | 27.3 | 27.06 | 27.27 | 4781537.0 |
| 2005-08-11 10:30:00 | MSFT | Stock | 27.28 | 27.29 | 27.12 | 27.19 | 4397183.0 |
| 2005-08-11 11:00:00 | MSFT | Stock | 27.19 | 27.201 | 27.1 | 27.11 | 1864460.0 |
| 2005-08-11 11:30:00 | MSFT | Stock | 27.11 | 27.12 | 27.039 | 27.1 | 2255976.0 |
| 2005-08-11 12:00:00 | MSFT | Stock | 27.11 | 27.11 | 26.95 | 26.96 | 2706637.0 |
| 2005-08-11 12:30:00 | MSFT | Stock | 26.95 | 27.05 | 26.95 | 27.05 | 2123733.0 |
| 2005-08-11 13:00:00 | MSFT | Stock | 27.05 | 27.07 | 26.98 | 26.99 | 2396526.0 |
| 2005-08-11 13:30:00 | MSFT | Stock | 26.99 | 27.05 | 26.92 | 26.95 | 3246520.0 |
| 2005-08-11 14:00:00 | MSFT | Stock | 26.95 | 26.99 | 26.89 | 26.97 | 2464151.0 |
| 2005-08-11 14:30:00 | MSFT | Stock | 26.97 | 27.08 | 26.96 | 27.07 | 3084449.0 |
| 2005-08-11 15:00:00 | MSFT | Stock | 27.07 | 27.23 | 27.06 | 27.19 | 4380650.0 |
| 2005-08-11 15:30:00 | MSFT | Stock | 27.19 | 27.3 | 27.18 | 27.29 | 6679181.0 |
| 2005-08-11 16:00:00 | MSFT | Stock | 27.26 | 27.31 | 27.0 | 27.15 | 809861.0 |
| 2005-08-11 16:30:00 | MSFT | Stock | 27.16 | 27.331 | 27.06 | 27.1 | 392619.0 |
| 2005-08-11 17:00:00 | MSFT | Stock | 27.29 | 27.29 | 27.12 | 27.12 | 3500.0 |
| 2005-08-11 17:30:00 | MSFT | Stock | 27.15 | 27.23 | 27.12 | 27.17 | 10104.0 |
| 2005-08-11 18:00:00 | MSFT | Stock | 27.29 | 27.29 | 27.14 | 27.16 | 37708.0 |
| 2005-08-11 08:00:00 | NVDA | Stock | 0.2325 | 0.2325 | 0.2321 | 0.2321 | 126000.0 |
| 2005-08-11 08:30:00 | NVDA | Stock | 0.2321 | 0.2321 | 0.2321 | 0.2321 | 78000.0 |
| 2005-08-11 09:00:00 | NVDA | Stock | 0.2321 | 0.2328 | 0.2306 | 0.2316 | 1410360.0 |
| 2005-08-11 09:30:00 | NVDA | Stock | 0.2322 | 0.2329 | 0.2299 | 0.2307 | 58156560.0 |
| 2005-08-11 10:00:00 | NVDA | Stock | 0.2307 | 0.2324 | 0.2307 | 0.2317 | 65606040.0 |
| 2005-08-11 10:30:00 | NVDA | Stock | 0.2317 | 0.2337 | 0.2316 | 0.2327 | 52713360.0 |
| 2005-08-11 11:00:00 | NVDA | Stock | 0.2327 | 0.2348 | 0.2326 | 0.2343 | 63337320.0 |
> showing 50 of 44,899 rows — these rows as CSV