PREVIEW / stock_5min / 2009-03-06
file: by_date/stock_5min/2009/2009-03-06.parquet size: 4.5 MB rows: 315,840 symbols: 3,370
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-06 07:20:00 | AAPL | Stock | 3.1625 | 3.1625 | 3.1625 | 3.1625 | 5600.0 |
| 2009-03-06 07:30:00 | AAPL | Stock | 3.1625 | 3.1625 | 3.1571 | 3.1571 | 8540.0 |
| 2009-03-06 07:55:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1532 | 3.1571 | 53200.0 |
| 2009-03-06 08:00:00 | AAPL | Stock | 3.1536 | 3.1646 | 3.1536 | 3.1639 | 80668.0 |
| 2009-03-06 08:05:00 | AAPL | Stock | 3.1639 | 3.185 | 3.1607 | 3.185 | 210448.0 |
| 2009-03-06 08:10:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1732 | 3.1732 | 27860.0 |
| 2009-03-06 08:15:00 | AAPL | Stock | 3.1714 | 3.1736 | 3.1714 | 3.1732 | 45360.0 |
| 2009-03-06 08:20:00 | AAPL | Stock | 3.1768 | 3.1768 | 3.1643 | 3.165 | 90160.0 |
| 2009-03-06 08:25:00 | AAPL | Stock | 3.1657 | 3.175 | 3.1532 | 3.175 | 206696.0 |
| 2009-03-06 08:30:00 | AAPL | Stock | 3.1732 | 3.1943 | 3.1682 | 3.1682 | 871584.0 |
| 2009-03-06 08:35:00 | AAPL | Stock | 3.1679 | 3.1696 | 3.1536 | 3.1593 | 347788.0 |
| 2009-03-06 08:40:00 | AAPL | Stock | 3.1596 | 3.1604 | 3.1554 | 3.1604 | 199556.0 |
| 2009-03-06 08:45:00 | AAPL | Stock | 3.1629 | 3.1714 | 3.1604 | 3.1714 | 281540.0 |
| 2009-03-06 08:50:00 | AAPL | Stock | 3.1707 | 3.1775 | 3.1661 | 3.1775 | 124152.0 |
| 2009-03-06 08:55:00 | AAPL | Stock | 3.1754 | 3.1821 | 3.1714 | 3.1789 | 178248.0 |
| 2009-03-06 09:00:00 | AAPL | Stock | 3.1818 | 3.1821 | 3.1768 | 3.1793 | 77392.0 |
| 2009-03-06 09:05:00 | AAPL | Stock | 3.1757 | 3.1757 | 3.1607 | 3.1643 | 440692.0 |
| 2009-03-06 09:10:00 | AAPL | Stock | 3.1611 | 3.1729 | 3.1611 | 3.165 | 299992.0 |
| 2009-03-06 09:15:00 | AAPL | Stock | 3.1636 | 3.1657 | 3.1625 | 3.1625 | 32340.0 |
| 2009-03-06 09:20:00 | AAPL | Stock | 3.1643 | 3.1643 | 3.1539 | 3.1586 | 338128.0 |
| 2009-03-06 09:25:00 | AAPL | Stock | 3.1589 | 3.1604 | 3.1432 | 3.155 | 1427776.0 |
| 2009-03-06 09:30:00 | AAPL | Stock | 3.155 | 3.1571 | 3.1021 | 3.1064 | 27846504.0 |
| 2009-03-06 09:35:00 | AAPL | Stock | 3.1064 | 3.1232 | 3.0957 | 3.0957 | 21820428.0 |
| 2009-03-06 09:40:00 | AAPL | Stock | 3.0957 | 3.1386 | 3.0757 | 3.1243 | 24245452.0 |
| 2009-03-06 09:45:00 | AAPL | Stock | 3.1243 | 3.1314 | 3.095 | 3.1139 | 17464104.0 |
| 2009-03-06 09:50:00 | AAPL | Stock | 3.1136 | 3.1161 | 3.0893 | 3.0925 | 16178904.0 |
| 2009-03-06 09:55:00 | AAPL | Stock | 3.0921 | 3.1114 | 3.0911 | 3.0996 | 11093264.0 |
| 2009-03-06 10:00:00 | AAPL | Stock | 3.0996 | 3.1089 | 3.0664 | 3.0675 | 20307000.0 |
| 2009-03-06 10:05:00 | AAPL | Stock | 3.0661 | 3.0768 | 3.0536 | 3.0571 | 21027048.0 |
| 2009-03-06 10:10:00 | AAPL | Stock | 3.0579 | 3.0604 | 3.0414 | 3.0482 | 21989408.0 |
| 2009-03-06 10:15:00 | AAPL | Stock | 3.0482 | 3.0654 | 3.0379 | 3.06 | 18707276.0 |
| 2009-03-06 10:20:00 | AAPL | Stock | 3.0604 | 3.0629 | 3.0386 | 3.0507 | 13821472.0 |
| 2009-03-06 10:25:00 | AAPL | Stock | 3.0511 | 3.0614 | 3.0368 | 3.0436 | 14597240.0 |
| 2009-03-06 10:30:00 | AAPL | Stock | 3.0436 | 3.0479 | 3.0182 | 3.02 | 22142232.0 |
| 2009-03-06 10:35:00 | AAPL | Stock | 3.0196 | 3.0229 | 2.9954 | 3.0154 | 27210456.0 |
| 2009-03-06 10:40:00 | AAPL | Stock | 3.0161 | 3.025 | 3.0093 | 3.0164 | 13166944.0 |
| 2009-03-06 10:45:00 | AAPL | Stock | 3.0171 | 3.0207 | 3.0029 | 3.0079 | 10777760.0 |
| 2009-03-06 10:50:00 | AAPL | Stock | 3.0072 | 3.0072 | 2.9732 | 2.9804 | 22556240.0 |
| 2009-03-06 10:55:00 | AAPL | Stock | 2.9804 | 3.0 | 2.9789 | 2.9982 | 16786476.0 |
| 2009-03-06 11:00:00 | AAPL | Stock | 2.9982 | 3.0046 | 2.9614 | 2.9732 | 21712684.0 |
| 2009-03-06 11:05:00 | AAPL | Stock | 2.9732 | 2.9739 | 2.9611 | 2.9671 | 13472900.0 |
| 2009-03-06 11:10:00 | AAPL | Stock | 2.9679 | 2.9768 | 2.9621 | 2.975 | 13591900.0 |
| 2009-03-06 11:15:00 | AAPL | Stock | 2.975 | 2.9793 | 2.9643 | 2.9714 | 11999064.0 |
| 2009-03-06 11:20:00 | AAPL | Stock | 2.9714 | 2.9729 | 2.9543 | 2.9546 | 11035444.0 |
| 2009-03-06 11:25:00 | AAPL | Stock | 2.9546 | 2.9604 | 2.9404 | 2.95 | 16613632.0 |
| 2009-03-06 11:30:00 | AAPL | Stock | 2.9507 | 2.9732 | 2.9479 | 2.9689 | 13656552.0 |
| 2009-03-06 11:35:00 | AAPL | Stock | 2.9689 | 2.9779 | 2.9675 | 2.975 | 9582076.0 |
| 2009-03-06 11:40:00 | AAPL | Stock | 2.9757 | 2.9764 | 2.9614 | 2.9729 | 10365824.0 |
| 2009-03-06 11:45:00 | AAPL | Stock | 2.9721 | 2.9871 | 2.9711 | 2.9864 | 10943548.0 |
| 2009-03-06 11:50:00 | AAPL | Stock | 2.9868 | 3.0082 | 2.9861 | 3.0071 | 16611196.0 |
> showing 50 of 315,840 rows — these rows as CSV