PREVIEW / stock_30min / 2004-06-16
file: by_date/stock_30min/2004/2004-06-16.parquet size: 745 KB rows: 39,959 symbols: 1,786
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-16 08:30:00 | AAPL | Stock | 0.5507 | 0.5516 | 0.5489 | 0.5489 | 61600.0 |
| 2004-06-16 09:00:00 | AAPL | Stock | 0.5479 | 0.548 | 0.5466 | 0.5466 | 95200.0 |
| 2004-06-16 09:30:00 | AAPL | Stock | 0.5468 | 0.5509 | 0.5452 | 0.5505 | 20045144.0 |
| 2004-06-16 10:00:00 | AAPL | Stock | 0.5505 | 0.5589 | 0.5504 | 0.5582 | 50370824.0 |
| 2004-06-16 10:30:00 | AAPL | Stock | 0.5584 | 0.562 | 0.5566 | 0.5616 | 40082280.0 |
| 2004-06-16 11:00:00 | AAPL | Stock | 0.5618 | 0.5638 | 0.5605 | 0.5621 | 41080592.0 |
| 2004-06-16 11:30:00 | AAPL | Stock | 0.5621 | 0.5625 | 0.5584 | 0.5607 | 39499936.0 |
| 2004-06-16 12:00:00 | AAPL | Stock | 0.5609 | 0.5616 | 0.5598 | 0.5614 | 13109208.0 |
| 2004-06-16 12:30:00 | AAPL | Stock | 0.5616 | 0.5657 | 0.5614 | 0.565 | 27118784.0 |
| 2004-06-16 13:00:00 | AAPL | Stock | 0.5652 | 0.5657 | 0.5627 | 0.5639 | 23323216.0 |
| 2004-06-16 13:30:00 | AAPL | Stock | 0.5639 | 0.5695 | 0.5636 | 0.5668 | 52792992.0 |
| 2004-06-16 14:00:00 | AAPL | Stock | 0.5668 | 0.5714 | 0.5654 | 0.5709 | 36450064.0 |
| 2004-06-16 14:30:00 | AAPL | Stock | 0.5709 | 0.5746 | 0.5707 | 0.5736 | 60633664.0 |
| 2004-06-16 15:00:00 | AAPL | Stock | 0.5736 | 0.593 | 0.5736 | 0.5923 | 156719920.0 |
| 2004-06-16 15:30:00 | AAPL | Stock | 0.5923 | 0.595 | 0.5839 | 0.5839 | 208664848.0 |
| 2004-06-16 16:00:00 | AAPL | Stock | 0.5846 | 0.5912 | 0.565 | 0.5863 | 9276680.0 |
| 2004-06-16 16:30:00 | AAPL | Stock | 0.5839 | 0.5856 | 0.5839 | 0.5846 | 4618152.0 |
| 2004-06-16 17:00:00 | AAPL | Stock | 0.5832 | 0.5832 | 0.5832 | 0.5832 | 16800.0 |
| 2004-06-16 17:30:00 | AAPL | Stock | 0.5832 | 0.5843 | 0.583 | 0.5832 | 87920.0 |
| 2004-06-16 18:00:00 | AAPL | Stock | 0.5832 | 0.5832 | 0.5832 | 0.5832 | 5600.0 |
| 2004-06-16 08:00:00 | MSFT | Stock | 27.31 | 27.4 | 27.31 | 27.37 | 18130.0 |
| 2004-06-16 08:30:00 | MSFT | Stock | 27.39 | 27.39 | 27.34 | 27.34 | 16643.0 |
| 2004-06-16 09:00:00 | MSFT | Stock | 27.32 | 27.34 | 27.26 | 27.34 | 131209.0 |
| 2004-06-16 09:30:00 | MSFT | Stock | 27.34 | 27.41 | 27.21 | 27.27 | 8660849.0 |
| 2004-06-16 10:00:00 | MSFT | Stock | 27.27 | 27.32 | 27.24 | 27.291 | 6433874.0 |
| 2004-06-16 10:30:00 | MSFT | Stock | 27.3 | 27.3 | 27.22 | 27.2316 | 4754281.0 |
| 2004-06-16 11:00:00 | MSFT | Stock | 27.23 | 27.24 | 27.15 | 27.169 | 3894770.0 |
| 2004-06-16 11:30:00 | MSFT | Stock | 27.16 | 27.27 | 27.16 | 27.26 | 6772084.0 |
| 2004-06-16 12:00:00 | MSFT | Stock | 27.26 | 27.27 | 27.19 | 27.23 | 3169849.0 |
| 2004-06-16 12:30:00 | MSFT | Stock | 27.23 | 27.27 | 27.19 | 27.25 | 2170156.0 |
| 2004-06-16 13:00:00 | MSFT | Stock | 27.24 | 27.26 | 27.19 | 27.24 | 2385694.0 |
| 2004-06-16 13:30:00 | MSFT | Stock | 27.24 | 27.25 | 27.2 | 27.23 | 1721164.0 |
| 2004-06-16 14:00:00 | MSFT | Stock | 27.22 | 27.34 | 27.22 | 27.27 | 5090105.0 |
| 2004-06-16 14:30:00 | MSFT | Stock | 27.27 | 27.39 | 27.27 | 27.36 | 4739029.0 |
| 2004-06-16 15:00:00 | MSFT | Stock | 27.37 | 27.5 | 27.36 | 27.47 | 5160470.0 |
| 2004-06-16 15:30:00 | MSFT | Stock | 27.47 | 27.49 | 27.29 | 27.33 | 7312649.0 |
| 2004-06-16 16:00:00 | MSFT | Stock | 27.32 | 27.35 | 27.26 | 27.32 | 3597025.0 |
| 2004-06-16 16:30:00 | MSFT | Stock | 27.3 | 27.4237 | 27.28 | 27.28 | 229477.0 |
| 2004-06-16 17:00:00 | MSFT | Stock | 27.27 | 27.32 | 27.26 | 27.32 | 22532.0 |
| 2004-06-16 17:30:00 | MSFT | Stock | 27.26 | 27.28 | 27.26 | 27.27 | 2915.0 |
| 2004-06-16 18:00:00 | MSFT | Stock | 27.27 | 27.27 | 27.26 | 27.26 | 3376.0 |
| 2004-06-16 09:00:00 | NVDA | Stock | 0.1708 | 0.1708 | 0.1698 | 0.1698 | 804000.0 |
| 2004-06-16 09:30:00 | NVDA | Stock | 0.1699 | 0.1703 | 0.1683 | 0.1689 | 34798920.0 |
| 2004-06-16 10:00:00 | NVDA | Stock | 0.1689 | 0.1705 | 0.1688 | 0.1702 | 21854400.0 |
| 2004-06-16 10:30:00 | NVDA | Stock | 0.1702 | 0.171 | 0.1691 | 0.1705 | 33925200.0 |
| 2004-06-16 11:00:00 | NVDA | Stock | 0.1705 | 0.1706 | 0.169 | 0.1692 | 11268600.0 |
| 2004-06-16 11:30:00 | NVDA | Stock | 0.169 | 0.1693 | 0.1687 | 0.1692 | 7601040.0 |
| 2004-06-16 12:00:00 | NVDA | Stock | 0.1692 | 0.1692 | 0.1675 | 0.1677 | 21045480.0 |
| 2004-06-16 12:30:00 | NVDA | Stock | 0.1677 | 0.1681 | 0.1675 | 0.1681 | 17952240.0 |
| 2004-06-16 13:00:00 | NVDA | Stock | 0.1681 | 0.1682 | 0.1676 | 0.1682 | 6168840.0 |
> showing 50 of 39,959 rows — these rows as CSV