PREVIEW / stock_30min / 2009-03-02
file: by_date/stock_30min/2009/2009-03-02.parquet size: 1.3 MB rows: 70,814 symbols: 3,354
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-02 07:00:00 | AAPL | Stock | 3.1214 | 3.1279 | 3.1214 | 3.1214 | 39200.0 |
| 2009-03-02 07:30:00 | AAPL | Stock | 3.1214 | 3.1314 | 3.1214 | 3.1314 | 27300.0 |
| 2009-03-02 08:00:00 | AAPL | Stock | 3.1314 | 3.1482 | 3.1311 | 3.1411 | 397908.0 |
| 2009-03-02 08:30:00 | AAPL | Stock | 3.1407 | 3.1489 | 3.1343 | 3.1486 | 443044.0 |
| 2009-03-02 09:00:00 | AAPL | Stock | 3.1489 | 3.1693 | 3.1429 | 3.1429 | 935452.0 |
| 2009-03-02 09:30:00 | AAPL | Stock | 3.1486 | 3.2571 | 3.1357 | 3.2321 | 100434768.0 |
| 2009-03-02 10:00:00 | AAPL | Stock | 3.2311 | 3.2486 | 3.1989 | 3.2169 | 61915392.0 |
| 2009-03-02 10:30:00 | AAPL | Stock | 3.2171 | 3.2296 | 3.195 | 3.1982 | 41007428.0 |
| 2009-03-02 11:00:00 | AAPL | Stock | 3.1982 | 3.2411 | 3.1607 | 3.2179 | 57617840.0 |
| 2009-03-02 11:30:00 | AAPL | Stock | 3.2186 | 3.2232 | 3.1429 | 3.1832 | 55461336.0 |
| 2009-03-02 12:00:00 | AAPL | Stock | 3.1832 | 3.2011 | 3.1736 | 3.1964 | 43236536.0 |
| 2009-03-02 12:30:00 | AAPL | Stock | 3.1968 | 3.2068 | 3.1536 | 3.16 | 40488700.0 |
| 2009-03-02 13:00:00 | AAPL | Stock | 3.1604 | 3.18 | 3.15 | 3.1657 | 36717016.0 |
| 2009-03-02 13:30:00 | AAPL | Stock | 3.1657 | 3.1896 | 3.1507 | 3.1893 | 37048172.0 |
| 2009-03-02 14:00:00 | AAPL | Stock | 3.1889 | 3.1893 | 3.1486 | 3.1607 | 36811320.0 |
| 2009-03-02 14:30:00 | AAPL | Stock | 3.1603 | 3.1875 | 3.1539 | 3.1579 | 42987560.0 |
| 2009-03-02 15:00:00 | AAPL | Stock | 3.1586 | 3.1661 | 3.1343 | 3.1489 | 61013680.0 |
| 2009-03-02 15:30:00 | AAPL | Stock | 3.1496 | 3.2036 | 3.1311 | 3.1468 | 96788412.0 |
| 2009-03-02 16:00:00 | AAPL | Stock | 3.1425 | 3.2564 | 3.1407 | 3.1461 | 23684052.0 |
| 2009-03-02 16:30:00 | AAPL | Stock | 3.1454 | 3.1479 | 3.1407 | 3.1479 | 14268100.0 |
| 2009-03-02 17:00:00 | AAPL | Stock | 3.145 | 3.2393 | 3.145 | 3.2393 | 161672.0 |
| 2009-03-02 17:30:00 | AAPL | Stock | 3.1454 | 3.1896 | 3.1454 | 3.1896 | 108332.0 |
| 2009-03-02 18:00:00 | AAPL | Stock | 3.1407 | 3.1482 | 3.1407 | 3.1457 | 7316568.0 |
| 2009-03-02 18:30:00 | AAPL | Stock | 3.1457 | 3.1514 | 3.1457 | 3.1514 | 29400.0 |
| 2009-03-02 19:00:00 | AAPL | Stock | 3.1518 | 3.1536 | 3.1518 | 3.1536 | 53200.0 |
| 2009-03-02 19:30:00 | AAPL | Stock | 3.1536 | 3.1536 | 3.1464 | 3.1468 | 115416.0 |
| 2009-03-02 04:00:00 | MSFT | Stock | 15.84 | 16.0 | 15.84 | 16.0 | 700.0 |
| 2009-03-02 06:00:00 | MSFT | Stock | 15.9 | 15.9 | 15.9 | 15.9 | 200.0 |
| 2009-03-02 06:30:00 | MSFT | Stock | 15.87 | 15.87 | 15.87 | 15.87 | 700.0 |
| 2009-03-02 07:00:00 | MSFT | Stock | 15.82 | 15.97 | 15.82 | 15.97 | 1115.0 |
| 2009-03-02 07:30:00 | MSFT | Stock | 15.9 | 15.9 | 15.85 | 15.88 | 1200.0 |
| 2009-03-02 08:00:00 | MSFT | Stock | 15.95 | 16.0 | 15.85 | 15.99 | 28017.0 |
| 2009-03-02 08:30:00 | MSFT | Stock | 15.96 | 16.06 | 15.96 | 15.97 | 42731.0 |
| 2009-03-02 09:00:00 | MSFT | Stock | 15.98 | 16.05 | 15.9 | 15.99 | 64039.0 |
| 2009-03-02 09:30:00 | MSFT | Stock | 15.99 | 16.25 | 15.9 | 16.14 | 9633620.0 |
| 2009-03-02 10:00:00 | MSFT | Stock | 16.14 | 16.16 | 15.99 | 16.02 | 5860414.0 |
| 2009-03-02 10:30:00 | MSFT | Stock | 16.005 | 16.14 | 15.96 | 16.009 | 5452907.0 |
| 2009-03-02 11:00:00 | MSFT | Stock | 16.002 | 16.05 | 15.95 | 15.99 | 4866569.0 |
| 2009-03-02 11:30:00 | MSFT | Stock | 15.99 | 16.05 | 15.9 | 15.92 | 5153809.0 |
| 2009-03-02 12:00:00 | MSFT | Stock | 15.93 | 15.98 | 15.86 | 15.98 | 5137298.0 |
| 2009-03-02 12:30:00 | MSFT | Stock | 15.98 | 16.025 | 15.85 | 15.851 | 3892265.0 |
| 2009-03-02 13:00:00 | MSFT | Stock | 15.85 | 15.94 | 15.83 | 15.87 | 3564067.0 |
| 2009-03-02 13:30:00 | MSFT | Stock | 15.87 | 16.0 | 15.82 | 16.0 | 3468601.0 |
| 2009-03-02 14:00:00 | MSFT | Stock | 15.992 | 16.0 | 15.85 | 15.87 | 2791382.0 |
| 2009-03-02 14:30:00 | MSFT | Stock | 15.87 | 16.0 | 15.84 | 15.89 | 3891141.0 |
| 2009-03-02 15:00:00 | MSFT | Stock | 15.89 | 15.95 | 15.83 | 15.92 | 6131594.0 |
| 2009-03-02 15:30:00 | MSFT | Stock | 15.92 | 15.979 | 15.72 | 15.8 | 13972208.0 |
| 2009-03-02 16:00:00 | MSFT | Stock | 15.8 | 15.95 | 15.77 | 15.85 | 5340996.0 |
| 2009-03-02 16:30:00 | MSFT | Stock | 15.881 | 15.926 | 15.81 | 15.81 | 4586.0 |
| 2009-03-02 17:00:00 | MSFT | Stock | 15.83 | 15.83 | 15.82 | 15.83 | 11438.0 |
> showing 50 of 70,814 rows — these rows as CSV