PREVIEW / stock_30min / 2004-06-14
file: by_date/stock_30min/2004/2004-06-14.parquet size: 782 KB rows: 42,638 symbols: 1,785
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-06-14 08:00:00 | AAPL | Stock | 0.5455 | 0.5489 | 0.5445 | 0.5489 | 268800.0 |
| 2004-06-14 08:30:00 | AAPL | Stock | 0.5446 | 0.5455 | 0.5438 | 0.5455 | 173600.0 |
| 2004-06-14 09:00:00 | AAPL | Stock | 0.5455 | 0.5477 | 0.545 | 0.5473 | 615944.0 |
| 2004-06-14 09:30:00 | AAPL | Stock | 0.5473 | 0.5479 | 0.5427 | 0.5443 | 32249112.0 |
| 2004-06-14 10:00:00 | AAPL | Stock | 0.5439 | 0.5446 | 0.5413 | 0.5441 | 28523320.0 |
| 2004-06-14 10:30:00 | AAPL | Stock | 0.5439 | 0.5443 | 0.5388 | 0.5402 | 24668224.0 |
| 2004-06-14 11:00:00 | AAPL | Stock | 0.5402 | 0.542 | 0.5393 | 0.5402 | 14536760.0 |
| 2004-06-14 11:30:00 | AAPL | Stock | 0.54 | 0.5416 | 0.5393 | 0.5395 | 5677392.0 |
| 2004-06-14 12:00:00 | AAPL | Stock | 0.5395 | 0.5396 | 0.5359 | 0.5363 | 17458280.0 |
| 2004-06-14 12:30:00 | AAPL | Stock | 0.5361 | 0.5363 | 0.5341 | 0.5345 | 16246048.0 |
| 2004-06-14 13:00:00 | AAPL | Stock | 0.5345 | 0.5361 | 0.5341 | 0.5348 | 12640600.0 |
| 2004-06-14 13:30:00 | AAPL | Stock | 0.5348 | 0.5384 | 0.5348 | 0.5375 | 13048392.0 |
| 2004-06-14 14:00:00 | AAPL | Stock | 0.5375 | 0.5375 | 0.5361 | 0.5361 | 6278216.0 |
| 2004-06-14 14:30:00 | AAPL | Stock | 0.5363 | 0.5363 | 0.5339 | 0.5348 | 10530296.0 |
| 2004-06-14 15:00:00 | AAPL | Stock | 0.5348 | 0.538 | 0.5348 | 0.5379 | 15770664.0 |
| 2004-06-14 15:30:00 | AAPL | Stock | 0.5379 | 0.5384 | 0.5352 | 0.537 | 22905400.0 |
| 2004-06-14 16:00:00 | AAPL | Stock | 0.5368 | 0.5379 | 0.5368 | 0.5373 | 2757384.0 |
| 2004-06-14 16:30:00 | AAPL | Stock | 0.5379 | 0.5379 | 0.5373 | 0.5373 | 1053976.0 |
| 2004-06-14 17:00:00 | AAPL | Stock | 0.5379 | 0.5379 | 0.5379 | 0.5379 | 359520.0 |
| 2004-06-14 08:00:00 | MSFT | Stock | 26.67 | 26.79 | 26.5 | 26.6 | 65600.0 |
| 2004-06-14 08:30:00 | MSFT | Stock | 26.62 | 26.62 | 26.61 | 26.62 | 8100.0 |
| 2004-06-14 09:00:00 | MSFT | Stock | 26.61 | 27.0 | 26.55 | 26.56 | 834284.0 |
| 2004-06-14 09:30:00 | MSFT | Stock | 26.56 | 26.671 | 26.53 | 26.64 | 7421316.0 |
| 2004-06-14 10:00:00 | MSFT | Stock | 26.65 | 26.82 | 26.64 | 26.8 | 6059435.0 |
| 2004-06-14 10:30:00 | MSFT | Stock | 26.79 | 26.8701 | 26.7013 | 26.82 | 6067947.0 |
| 2004-06-14 11:00:00 | MSFT | Stock | 26.82 | 26.85 | 26.75 | 26.76 | 5360488.0 |
| 2004-06-14 11:30:00 | MSFT | Stock | 26.76 | 26.8 | 26.74 | 26.77 | 3088776.0 |
| 2004-06-14 12:00:00 | MSFT | Stock | 26.77 | 26.78 | 26.66 | 26.75 | 4163276.0 |
| 2004-06-14 12:30:00 | MSFT | Stock | 26.74 | 26.77 | 26.68 | 26.75 | 2141737.0 |
| 2004-06-14 13:00:00 | MSFT | Stock | 26.75 | 26.77 | 26.68 | 26.68 | 2622106.0 |
| 2004-06-14 13:30:00 | MSFT | Stock | 26.68 | 26.8 | 26.66 | 26.78 | 3292320.0 |
| 2004-06-14 14:00:00 | MSFT | Stock | 26.77 | 26.79 | 26.73 | 26.75 | 2638104.0 |
| 2004-06-14 14:30:00 | MSFT | Stock | 26.75 | 26.75 | 26.67 | 26.7 | 4111262.0 |
| 2004-06-14 15:00:00 | MSFT | Stock | 26.7 | 26.72 | 26.65 | 26.7 | 4729982.0 |
| 2004-06-14 15:30:00 | MSFT | Stock | 26.69 | 26.89 | 26.66 | 26.86 | 11019761.0 |
| 2004-06-14 16:00:00 | MSFT | Stock | 26.86 | 26.92 | 26.7652 | 26.91 | 1991678.0 |
| 2004-06-14 16:30:00 | MSFT | Stock | 26.91 | 26.93 | 26.9 | 26.91 | 140471.0 |
| 2004-06-14 17:00:00 | MSFT | Stock | 26.89 | 27.11 | 26.88 | 27.09 | 50691.0 |
| 2004-06-14 17:30:00 | MSFT | Stock | 27.1 | 27.36 | 27.1 | 27.15 | 170851.0 |
| 2004-06-14 18:00:00 | MSFT | Stock | 27.15 | 27.23 | 27.13 | 27.2 | 10100.0 |
| 2004-06-14 08:30:00 | NVDA | Stock | 0.1728 | 0.1728 | 0.1728 | 0.1728 | 120000.0 |
| 2004-06-14 09:00:00 | NVDA | Stock | 0.1724 | 0.1724 | 0.1713 | 0.1713 | 492000.0 |
| 2004-06-14 09:30:00 | NVDA | Stock | 0.1724 | 0.1724 | 0.1709 | 0.1715 | 34428960.0 |
| 2004-06-14 10:00:00 | NVDA | Stock | 0.1716 | 0.1717 | 0.1706 | 0.1709 | 26803800.0 |
| 2004-06-14 10:30:00 | NVDA | Stock | 0.171 | 0.1711 | 0.1703 | 0.1705 | 21485160.0 |
| 2004-06-14 11:00:00 | NVDA | Stock | 0.1704 | 0.1707 | 0.169 | 0.1694 | 41608080.0 |
| 2004-06-14 11:30:00 | NVDA | Stock | 0.1694 | 0.1697 | 0.1687 | 0.1689 | 24302520.0 |
| 2004-06-14 12:00:00 | NVDA | Stock | 0.1689 | 0.1691 | 0.1682 | 0.1683 | 23918880.0 |
| 2004-06-14 12:30:00 | NVDA | Stock | 0.1682 | 0.1685 | 0.1678 | 0.168 | 30213000.0 |
| 2004-06-14 13:00:00 | NVDA | Stock | 0.168 | 0.1686 | 0.1671 | 0.1673 | 31101000.0 |
> showing 50 of 42,638 rows — these rows as CSV