PREVIEW / stock_30min / 2004-03-18
file: by_date/stock_30min/2004/2004-03-18.parquet size: 727 KB rows: 39,150 symbols: 1,743
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-03-18 08:00:00 | AAPL | Stock | 0.4677 | 0.4677 | 0.4661 | 0.4661 | 84000.0 |
| 2004-03-18 08:30:00 | AAPL | Stock | 0.4659 | 0.4661 | 0.4659 | 0.4659 | 39200.0 |
| 2004-03-18 09:00:00 | AAPL | Stock | 0.4646 | 0.4646 | 0.4464 | 0.4616 | 408800.0 |
| 2004-03-18 09:30:00 | AAPL | Stock | 0.4632 | 0.4654 | 0.4591 | 0.4598 | 42222600.0 |
| 2004-03-18 10:00:00 | AAPL | Stock | 0.4598 | 0.4618 | 0.4579 | 0.4598 | 23572584.0 |
| 2004-03-18 10:30:00 | AAPL | Stock | 0.4598 | 0.46 | 0.458 | 0.4589 | 21351512.0 |
| 2004-03-18 11:00:00 | AAPL | Stock | 0.4589 | 0.4605 | 0.458 | 0.4596 | 8495872.0 |
| 2004-03-18 11:30:00 | AAPL | Stock | 0.4598 | 0.4629 | 0.4591 | 0.4625 | 8067864.0 |
| 2004-03-18 12:00:00 | AAPL | Stock | 0.4623 | 0.4625 | 0.4588 | 0.46 | 15171520.0 |
| 2004-03-18 12:30:00 | AAPL | Stock | 0.4602 | 0.4625 | 0.4595 | 0.4598 | 20701576.0 |
| 2004-03-18 13:00:00 | AAPL | Stock | 0.4596 | 0.4621 | 0.4588 | 0.4613 | 31911824.0 |
| 2004-03-18 13:30:00 | AAPL | Stock | 0.4607 | 0.4622 | 0.4582 | 0.4591 | 14923832.0 |
| 2004-03-18 14:00:00 | AAPL | Stock | 0.4589 | 0.4596 | 0.457 | 0.4577 | 28046144.0 |
| 2004-03-18 14:30:00 | AAPL | Stock | 0.4577 | 0.4589 | 0.457 | 0.4588 | 20032376.0 |
| 2004-03-18 15:00:00 | AAPL | Stock | 0.4586 | 0.4609 | 0.4586 | 0.4607 | 20123880.0 |
| 2004-03-18 15:30:00 | AAPL | Stock | 0.4607 | 0.4625 | 0.4584 | 0.4591 | 45284624.0 |
| 2004-03-18 16:00:00 | AAPL | Stock | 0.4588 | 0.4598 | 0.4555 | 0.458 | 10695104.0 |
| 2004-03-18 17:00:00 | AAPL | Stock | 0.4584 | 0.4595 | 0.4584 | 0.4595 | 201040.0 |
| 2004-03-18 17:30:00 | AAPL | Stock | 0.458 | 0.458 | 0.458 | 0.458 | 78400.0 |
| 2004-03-18 18:00:00 | AAPL | Stock | 0.4575 | 0.4575 | 0.4563 | 0.4563 | 156800.0 |
| 2004-03-18 08:00:00 | MSFT | Stock | 24.81 | 25.135 | 24.7 | 24.95 | 866894.0 |
| 2004-03-18 08:30:00 | MSFT | Stock | 24.96 | 25.18 | 24.6 | 24.99 | 1281450.0 |
| 2004-03-18 09:00:00 | MSFT | Stock | 24.98 | 25.01 | 24.6 | 24.95 | 741506.0 |
| 2004-03-18 09:30:00 | MSFT | Stock | 24.96 | 25.0 | 24.76 | 24.8 | 17388486.0 |
| 2004-03-18 10:00:00 | MSFT | Stock | 24.8 | 24.84 | 24.71 | 24.78 | 15650555.0 |
| 2004-03-18 10:30:00 | MSFT | Stock | 24.78 | 24.79 | 24.58 | 24.65 | 10347000.0 |
| 2004-03-18 11:00:00 | MSFT | Stock | 24.65 | 24.76 | 24.6 | 24.72 | 7760105.0 |
| 2004-03-18 11:30:00 | MSFT | Stock | 24.71 | 24.74 | 24.6199 | 24.65 | 6564264.0 |
| 2004-03-18 12:00:00 | MSFT | Stock | 24.64 | 24.71 | 24.6199 | 24.64 | 11640208.0 |
| 2004-03-18 12:30:00 | MSFT | Stock | 24.64 | 24.78 | 24.63 | 24.68 | 7074913.0 |
| 2004-03-18 13:00:00 | MSFT | Stock | 24.69 | 24.83 | 24.66 | 24.77 | 8942331.0 |
| 2004-03-18 13:30:00 | MSFT | Stock | 24.77 | 24.8 | 24.65 | 24.679 | 4487828.0 |
| 2004-03-18 14:00:00 | MSFT | Stock | 24.68 | 24.74 | 24.64 | 24.67 | 5378833.0 |
| 2004-03-18 14:30:00 | MSFT | Stock | 24.67 | 24.78 | 24.65 | 24.75 | 4667514.0 |
| 2004-03-18 15:00:00 | MSFT | Stock | 24.76 | 24.95 | 24.75 | 24.94 | 7631810.0 |
| 2004-03-18 15:30:00 | MSFT | Stock | 24.93 | 24.95 | 24.86 | 24.9 | 10355984.0 |
| 2004-03-18 16:00:00 | MSFT | Stock | 24.89 | 24.97 | 24.86 | 24.95 | 402206.0 |
| 2004-03-18 16:30:00 | MSFT | Stock | 24.96 | 25.0 | 24.91 | 24.97 | 30620.0 |
| 2004-03-18 17:00:00 | MSFT | Stock | 24.97 | 24.97 | 24.885 | 24.94 | 11303.0 |
| 2004-03-18 17:30:00 | MSFT | Stock | 24.93 | 24.96 | 24.93 | 24.95 | 8600.0 |
| 2004-03-18 18:00:00 | MSFT | Stock | 24.95 | 24.97 | 24.91 | 24.97 | 4421.0 |
| 2004-03-18 08:30:00 | NVDA | Stock | 0.1846 | 0.1846 | 0.1846 | 0.1846 | 180000.0 |
| 2004-03-18 09:00:00 | NVDA | Stock | 0.1847 | 0.1849 | 0.1837 | 0.1847 | 792000.0 |
| 2004-03-18 09:30:00 | NVDA | Stock | 0.1838 | 0.1892 | 0.1833 | 0.1863 | 104910000.0 |
| 2004-03-18 10:00:00 | NVDA | Stock | 0.1862 | 0.1878 | 0.1843 | 0.1875 | 56530800.0 |
| 2004-03-18 10:30:00 | NVDA | Stock | 0.1874 | 0.1876 | 0.1862 | 0.1868 | 25516320.0 |
| 2004-03-18 11:00:00 | NVDA | Stock | 0.1868 | 0.1868 | 0.1849 | 0.1852 | 37632360.0 |
| 2004-03-18 11:30:00 | NVDA | Stock | 0.1852 | 0.1862 | 0.1843 | 0.185 | 23334840.0 |
| 2004-03-18 12:00:00 | NVDA | Stock | 0.185 | 0.1852 | 0.1833 | 0.1839 | 20787600.0 |
| 2004-03-18 12:30:00 | NVDA | Stock | 0.1838 | 0.1867 | 0.1838 | 0.1862 | 30223200.0 |
> showing 50 of 39,150 rows — these rows as CSV