PREVIEW / stock_30min / 2005-01-05
file: by_date/stock_30min/2005/2005-01-05.parquet size: 853 KB rows: 45,185 symbols: 1,909
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-01-05 08:00:00 | AAPL | Stock | 1.152 | 1.1598 | 1.1475 | 1.1563 | 2234960.0 |
| 2005-01-05 08:30:00 | AAPL | Stock | 1.1577 | 1.158 | 1.15 | 1.1502 | 1529584.0 |
| 2005-01-05 09:00:00 | AAPL | Stock | 1.1418 | 1.153 | 1.1418 | 1.1521 | 2391032.0 |
| 2005-01-05 09:30:00 | AAPL | Stock | 1.1491 | 1.1652 | 1.1491 | 1.1563 | 164635296.0 |
| 2005-01-05 10:00:00 | AAPL | Stock | 1.1563 | 1.1607 | 1.1509 | 1.1516 | 66718680.0 |
| 2005-01-05 10:30:00 | AAPL | Stock | 1.1516 | 1.1568 | 1.1446 | 1.1484 | 58934960.0 |
| 2005-01-05 11:00:00 | AAPL | Stock | 1.1486 | 1.1568 | 1.1466 | 1.1495 | 46508448.0 |
| 2005-01-05 11:30:00 | AAPL | Stock | 1.1493 | 1.1538 | 1.1486 | 1.1505 | 25349576.0 |
| 2005-01-05 12:00:00 | AAPL | Stock | 1.1507 | 1.1518 | 1.1496 | 1.15 | 22352120.0 |
| 2005-01-05 12:30:00 | AAPL | Stock | 1.1498 | 1.1507 | 1.1438 | 1.1496 | 35769160.0 |
| 2005-01-05 13:00:00 | AAPL | Stock | 1.1496 | 1.155 | 1.1484 | 1.1541 | 40872272.0 |
| 2005-01-05 13:30:00 | AAPL | Stock | 1.1543 | 1.1555 | 1.153 | 1.1545 | 26330304.0 |
| 2005-01-05 14:00:00 | AAPL | Stock | 1.1541 | 1.1568 | 1.1534 | 1.1554 | 30965592.0 |
| 2005-01-05 14:30:00 | AAPL | Stock | 1.1554 | 1.1566 | 1.1536 | 1.1539 | 23122120.0 |
| 2005-01-05 15:00:00 | AAPL | Stock | 1.1543 | 1.162 | 1.1539 | 1.1573 | 57861048.0 |
| 2005-01-05 15:30:00 | AAPL | Stock | 1.1573 | 1.158 | 1.1518 | 1.152 | 67808384.0 |
| 2005-01-05 16:00:00 | AAPL | Stock | 1.1518 | 1.1527 | 1.1514 | 1.1518 | 2867144.0 |
| 2005-01-05 16:30:00 | AAPL | Stock | 1.1509 | 1.1518 | 1.1505 | 1.1505 | 487200.0 |
| 2005-01-05 17:00:00 | AAPL | Stock | 1.1507 | 1.1518 | 1.1502 | 1.1505 | 200088.0 |
| 2005-01-05 17:30:00 | AAPL | Stock | 1.1518 | 1.153 | 1.1518 | 1.153 | 276920.0 |
| 2005-01-05 18:00:00 | AAPL | Stock | 1.1543 | 1.1545 | 1.1543 | 1.1543 | 28000.0 |
| 2005-01-05 08:00:00 | MSFT | Stock | 26.8 | 26.9 | 26.8 | 26.9 | 18600.0 |
| 2005-01-05 08:30:00 | MSFT | Stock | 26.9 | 26.9 | 26.82 | 26.83 | 6516.0 |
| 2005-01-05 09:00:00 | MSFT | Stock | 26.83 | 26.88 | 26.8 | 26.84 | 94328.0 |
| 2005-01-05 09:30:00 | MSFT | Stock | 26.84 | 26.98 | 26.82 | 26.9 | 8946674.0 |
| 2005-01-05 10:00:00 | MSFT | Stock | 26.9 | 27.0 | 26.9 | 26.93 | 6144518.0 |
| 2005-01-05 10:30:00 | MSFT | Stock | 26.93 | 26.98 | 26.85 | 26.92 | 4878937.0 |
| 2005-01-05 11:00:00 | MSFT | Stock | 26.92 | 26.98 | 26.89 | 26.93 | 4581170.0 |
| 2005-01-05 11:30:00 | MSFT | Stock | 26.93 | 26.99 | 26.91 | 26.95 | 3461293.0 |
| 2005-01-05 12:00:00 | MSFT | Stock | 26.95 | 26.98 | 26.93 | 26.959 | 2691933.0 |
| 2005-01-05 12:30:00 | MSFT | Stock | 26.95 | 26.99 | 26.91 | 26.98 | 4312766.0 |
| 2005-01-05 13:00:00 | MSFT | Stock | 26.98 | 27.05 | 26.97 | 27.05 | 6275821.0 |
| 2005-01-05 13:30:00 | MSFT | Stock | 27.04 | 27.1 | 26.97 | 27.01 | 4053678.0 |
| 2005-01-05 14:00:00 | MSFT | Stock | 27.01 | 27.04 | 26.92 | 26.95 | 4819835.0 |
| 2005-01-05 14:30:00 | MSFT | Stock | 26.95 | 27.05 | 26.9 | 26.92 | 4048871.0 |
| 2005-01-05 15:00:00 | MSFT | Stock | 26.91 | 26.96 | 26.87 | 26.883 | 4638888.0 |
| 2005-01-05 15:30:00 | MSFT | Stock | 26.88 | 26.9 | 26.76 | 26.77 | 8122525.0 |
| 2005-01-05 16:00:00 | MSFT | Stock | 26.78 | 26.79 | 26.72 | 26.75 | 2002078.0 |
| 2005-01-05 16:30:00 | MSFT | Stock | 26.74 | 26.75 | 26.74 | 26.75 | 24550.0 |
| 2005-01-05 17:00:00 | MSFT | Stock | 26.75 | 26.78 | 26.75 | 26.75 | 26220.0 |
| 2005-01-05 17:30:00 | MSFT | Stock | 26.75 | 26.77 | 26.75 | 26.77 | 11441.0 |
| 2005-01-05 18:00:00 | MSFT | Stock | 26.78 | 26.79 | 26.78 | 26.79 | 7600.0 |
| 2005-01-05 08:00:00 | NVDA | Stock | 0.1867 | 0.1867 | 0.1867 | 0.1867 | 204000.0 |
| 2005-01-05 08:30:00 | NVDA | Stock | 0.1864 | 0.1864 | 0.1842 | 0.1842 | 621600.0 |
| 2005-01-05 09:00:00 | NVDA | Stock | 0.1842 | 0.1863 | 0.1842 | 0.1842 | 2040000.0 |
| 2005-01-05 09:30:00 | NVDA | Stock | 0.1852 | 0.1908 | 0.1842 | 0.1899 | 95354280.0 |
| 2005-01-05 10:00:00 | NVDA | Stock | 0.1899 | 0.1912 | 0.1887 | 0.1888 | 61702200.0 |
| 2005-01-05 10:30:00 | NVDA | Stock | 0.1888 | 0.1896 | 0.1857 | 0.1869 | 72563040.0 |
| 2005-01-05 11:00:00 | NVDA | Stock | 0.187 | 0.1884 | 0.1864 | 0.1865 | 37471320.0 |
| 2005-01-05 11:30:00 | NVDA | Stock | 0.1864 | 0.1878 | 0.1859 | 0.1872 | 31377600.0 |
> showing 50 of 45,185 rows — these rows as CSV