PREVIEW / stock_30min / 2009-06-05
file: by_date/stock_30min/2009/2009-06-05.parquet size: 1.3 MB rows: 72,071 symbols: 3,351
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-06-05 04:30:00 | AAPL | Stock | 5.2207 | 5.2679 | 5.2207 | 5.2679 | 9464.0 |
| 2009-06-05 05:00:00 | AAPL | Stock | 5.2768 | 5.2768 | 5.2768 | 5.2768 | 4200.0 |
| 2009-06-05 05:30:00 | AAPL | Stock | 5.2857 | 5.2857 | 5.2857 | 5.2857 | 2800.0 |
| 2009-06-05 06:00:00 | AAPL | Stock | 5.2507 | 5.2507 | 5.2507 | 5.2507 | 3500.0 |
| 2009-06-05 06:30:00 | AAPL | Stock | 5.25 | 5.2507 | 5.2411 | 5.25 | 73500.0 |
| 2009-06-05 07:00:00 | AAPL | Stock | 5.2871 | 5.2911 | 5.2114 | 5.2411 | 2169076.0 |
| 2009-06-05 07:30:00 | AAPL | Stock | 5.2393 | 5.25 | 5.2239 | 5.2464 | 731080.0 |
| 2009-06-05 08:00:00 | AAPL | Stock | 5.2418 | 5.2536 | 5.2071 | 5.2196 | 3880268.0 |
| 2009-06-05 08:30:00 | AAPL | Stock | 5.2214 | 5.2518 | 5.2143 | 5.2161 | 5563852.0 |
| 2009-06-05 09:00:00 | AAPL | Stock | 5.2157 | 5.2311 | 5.1893 | 5.19 | 4377128.0 |
| 2009-06-05 09:30:00 | AAPL | Stock | 5.1896 | 5.2286 | 5.1464 | 5.1796 | 158616248.0 |
| 2009-06-05 10:00:00 | AAPL | Stock | 5.1793 | 5.1907 | 5.1386 | 5.1425 | 80390520.0 |
| 2009-06-05 10:30:00 | AAPL | Stock | 5.1407 | 5.1625 | 5.1268 | 5.1368 | 72007740.0 |
| 2009-06-05 11:00:00 | AAPL | Stock | 5.1371 | 5.1779 | 5.135 | 5.1586 | 44336516.0 |
| 2009-06-05 11:30:00 | AAPL | Stock | 5.1589 | 5.1607 | 5.1307 | 5.1524 | 27848128.0 |
| 2009-06-05 12:00:00 | AAPL | Stock | 5.1532 | 5.1743 | 5.1454 | 5.1679 | 18805892.0 |
| 2009-06-05 12:30:00 | AAPL | Stock | 5.1679 | 5.1732 | 5.1607 | 5.1711 | 13890492.0 |
| 2009-06-05 13:00:00 | AAPL | Stock | 5.1704 | 5.1729 | 5.1479 | 5.1507 | 15511412.0 |
| 2009-06-05 13:30:00 | AAPL | Stock | 5.1501 | 5.1686 | 5.1493 | 5.162 | 14519792.0 |
| 2009-06-05 14:00:00 | AAPL | Stock | 5.1586 | 5.1607 | 5.1239 | 5.1296 | 31627204.0 |
| 2009-06-05 14:30:00 | AAPL | Stock | 5.1296 | 5.15 | 5.1146 | 5.1436 | 34962396.0 |
| 2009-06-05 15:00:00 | AAPL | Stock | 5.1432 | 5.1711 | 5.1389 | 5.1627 | 35552468.0 |
| 2009-06-05 15:30:00 | AAPL | Stock | 5.1628 | 5.1768 | 5.1507 | 5.1675 | 52871616.0 |
| 2009-06-05 16:00:00 | AAPL | Stock | 5.1675 | 5.1704 | 5.1429 | 5.1661 | 7600432.0 |
| 2009-06-05 16:30:00 | AAPL | Stock | 5.1614 | 5.1664 | 5.1614 | 5.1654 | 250152.0 |
| 2009-06-05 17:00:00 | AAPL | Stock | 5.1654 | 5.1671 | 5.1357 | 5.15 | 550368.0 |
| 2009-06-05 17:30:00 | AAPL | Stock | 5.15 | 5.1554 | 5.1432 | 5.1536 | 238980.0 |
| 2009-06-05 18:00:00 | AAPL | Stock | 5.1536 | 5.1668 | 5.1529 | 5.1589 | 406756.0 |
| 2009-06-05 18:30:00 | AAPL | Stock | 5.1571 | 5.1607 | 5.1571 | 5.1571 | 99092.0 |
| 2009-06-05 19:00:00 | AAPL | Stock | 5.1596 | 5.1607 | 5.1518 | 5.1607 | 107884.0 |
| 2009-06-05 19:30:00 | AAPL | Stock | 5.1607 | 5.1643 | 5.1557 | 5.1571 | 69160.0 |
| 2009-06-05 08:00:00 | MSFT | Stock | 21.9 | 21.9 | 21.82 | 21.82 | 1977.0 |
| 2009-06-05 08:30:00 | MSFT | Stock | 21.95 | 22.02 | 21.83 | 22.0 | 92392.0 |
| 2009-06-05 09:00:00 | MSFT | Stock | 21.97 | 22.02 | 21.86 | 21.86 | 69147.0 |
| 2009-06-05 09:30:00 | MSFT | Stock | 21.89 | 22.23 | 21.89 | 22.11 | 10023145.0 |
| 2009-06-05 10:00:00 | MSFT | Stock | 22.11 | 22.12 | 21.81 | 21.9 | 6794683.0 |
| 2009-06-05 10:30:00 | MSFT | Stock | 21.898 | 22.08 | 21.87 | 22.06 | 3388418.0 |
| 2009-06-05 11:00:00 | MSFT | Stock | 22.06 | 22.12 | 22.03 | 22.1 | 1844993.0 |
| 2009-06-05 11:30:00 | MSFT | Stock | 22.1 | 22.11 | 21.95 | 22.05 | 2984790.0 |
| 2009-06-05 12:00:00 | MSFT | Stock | 22.065 | 22.09 | 22.0 | 22.08 | 2356332.0 |
| 2009-06-05 12:30:00 | MSFT | Stock | 22.08 | 22.1 | 21.97 | 21.99 | 2778693.0 |
| 2009-06-05 13:00:00 | MSFT | Stock | 22.0 | 22.03 | 21.95 | 22.02 | 2309201.0 |
| 2009-06-05 13:30:00 | MSFT | Stock | 22.018 | 22.05 | 22.0 | 22.04 | 1510522.0 |
| 2009-06-05 14:00:00 | MSFT | Stock | 22.04 | 22.05 | 21.94 | 21.98 | 3846105.0 |
| 2009-06-05 14:30:00 | MSFT | Stock | 21.97 | 22.08 | 21.93 | 22.07 | 2288933.0 |
| 2009-06-05 15:00:00 | MSFT | Stock | 22.075 | 22.23 | 22.06 | 22.18 | 5972025.0 |
| 2009-06-05 15:30:00 | MSFT | Stock | 22.181 | 22.31 | 22.11 | 22.16 | 8612060.0 |
| 2009-06-05 16:00:00 | MSFT | Stock | 22.14 | 22.16 | 22.064 | 22.11 | 2625546.0 |
| 2009-06-05 16:30:00 | MSFT | Stock | 22.11 | 22.13 | 22.11 | 22.13 | 9490.0 |
| 2009-06-05 17:00:00 | MSFT | Stock | 22.12 | 22.14 | 22.12 | 22.14 | 2726.0 |
> showing 50 of 72,071 rows — these rows as CSV