PREVIEW / stock_5min / 2010-08-11
file: by_date/stock_5min/2010/2010-08-11.parquet size: 4.8 MB rows: 336,282 symbols: 3,454
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-11 05:45:00 | AAPL | Stock | 9.1982 | 9.1982 | 9.1929 | 9.1929 | 8400.0 |
| 2010-08-11 05:50:00 | AAPL | Stock | 9.1696 | 9.1696 | 9.1696 | 9.1696 | 2800.0 |
| 2010-08-11 07:00:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 2800.0 |
| 2010-08-11 07:05:00 | AAPL | Stock | 9.1661 | 9.1679 | 9.1661 | 9.1661 | 32200.0 |
| 2010-08-11 07:10:00 | AAPL | Stock | 9.1643 | 9.1761 | 9.1643 | 9.1761 | 44800.0 |
| 2010-08-11 07:15:00 | AAPL | Stock | 9.1761 | 9.1761 | 9.175 | 9.175 | 8400.0 |
| 2010-08-11 07:20:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 4200.0 |
| 2010-08-11 07:25:00 | AAPL | Stock | 9.1786 | 9.1789 | 9.1786 | 9.1789 | 18900.0 |
| 2010-08-11 07:30:00 | AAPL | Stock | 9.1804 | 9.1804 | 9.175 | 9.175 | 30800.0 |
| 2010-08-11 07:40:00 | AAPL | Stock | 9.1793 | 9.1793 | 9.175 | 9.1768 | 19600.0 |
| 2010-08-11 07:45:00 | AAPL | Stock | 9.1857 | 9.1857 | 9.175 | 9.175 | 77168.0 |
| 2010-08-11 07:50:00 | AAPL | Stock | 9.1818 | 9.1836 | 9.1807 | 9.1836 | 8400.0 |
| 2010-08-11 07:55:00 | AAPL | Stock | 9.1804 | 9.1804 | 9.1804 | 9.1804 | 224224.0 |
| 2010-08-11 08:00:00 | AAPL | Stock | 9.1829 | 9.1957 | 9.1757 | 9.1821 | 461020.0 |
| 2010-08-11 08:05:00 | AAPL | Stock | 9.1839 | 9.1839 | 9.1786 | 9.1789 | 426300.0 |
| 2010-08-11 08:10:00 | AAPL | Stock | 9.1775 | 9.1775 | 9.1629 | 9.1711 | 378168.0 |
| 2010-08-11 08:15:00 | AAPL | Stock | 9.1696 | 9.1696 | 9.1589 | 9.1589 | 129920.0 |
| 2010-08-11 08:20:00 | AAPL | Stock | 9.1579 | 9.1696 | 9.1579 | 9.1639 | 128744.0 |
| 2010-08-11 08:25:00 | AAPL | Stock | 9.1629 | 9.1689 | 9.1618 | 9.1643 | 117180.0 |
| 2010-08-11 08:30:00 | AAPL | Stock | 9.1643 | 9.1646 | 9.1529 | 9.1571 | 209048.0 |
| 2010-08-11 08:35:00 | AAPL | Stock | 9.1554 | 9.1639 | 9.1554 | 9.1629 | 166600.0 |
| 2010-08-11 08:40:00 | AAPL | Stock | 9.1625 | 9.1629 | 9.1518 | 9.1539 | 148008.0 |
| 2010-08-11 08:45:00 | AAPL | Stock | 9.1536 | 9.1554 | 9.1429 | 9.1529 | 412860.0 |
| 2010-08-11 08:50:00 | AAPL | Stock | 9.1493 | 9.1507 | 9.1379 | 9.1429 | 292460.0 |
| 2010-08-11 08:55:00 | AAPL | Stock | 9.1429 | 9.1482 | 9.1429 | 9.1482 | 75964.0 |
| 2010-08-11 09:00:00 | AAPL | Stock | 9.1504 | 9.1518 | 9.1429 | 9.1429 | 191436.0 |
| 2010-08-11 09:05:00 | AAPL | Stock | 9.1436 | 9.1482 | 9.1429 | 9.1482 | 61600.0 |
| 2010-08-11 09:10:00 | AAPL | Stock | 9.1471 | 9.1471 | 9.1429 | 9.1446 | 246148.0 |
| 2010-08-11 09:15:00 | AAPL | Stock | 9.1436 | 9.1436 | 9.1379 | 9.1421 | 312060.0 |
| 2010-08-11 09:20:00 | AAPL | Stock | 9.1404 | 9.1486 | 9.1396 | 9.1479 | 290920.0 |
| 2010-08-11 09:25:00 | AAPL | Stock | 9.1482 | 9.1486 | 9.1189 | 9.1193 | 617988.0 |
| 2010-08-11 09:30:00 | AAPL | Stock | 9.1193 | 9.1318 | 9.0239 | 9.0326 | 41530832.0 |
| 2010-08-11 09:35:00 | AAPL | Stock | 9.0286 | 9.065 | 9.0214 | 9.0546 | 19853512.0 |
| 2010-08-11 09:40:00 | AAPL | Stock | 9.0532 | 9.0696 | 9.0407 | 9.0529 | 13472032.0 |
| 2010-08-11 09:45:00 | AAPL | Stock | 9.0506 | 9.0539 | 9.0357 | 9.0479 | 10006136.0 |
| 2010-08-11 09:50:00 | AAPL | Stock | 9.0479 | 9.0486 | 9.0289 | 9.0414 | 12600980.0 |
| 2010-08-11 09:55:00 | AAPL | Stock | 9.0411 | 9.0643 | 9.0339 | 9.0559 | 11957960.0 |
| 2010-08-11 10:00:00 | AAPL | Stock | 9.055 | 9.07 | 9.0482 | 9.0632 | 7944832.0 |
| 2010-08-11 10:05:00 | AAPL | Stock | 9.0621 | 9.0779 | 9.0561 | 9.0721 | 9516612.0 |
| 2010-08-11 10:10:00 | AAPL | Stock | 9.0731 | 9.0732 | 9.0539 | 9.0632 | 6912248.0 |
| 2010-08-11 10:15:00 | AAPL | Stock | 9.0618 | 9.0635 | 9.0446 | 9.0489 | 6705692.0 |
| 2010-08-11 10:20:00 | AAPL | Stock | 9.0504 | 9.0725 | 9.0468 | 9.0604 | 5412428.0 |
| 2010-08-11 10:25:00 | AAPL | Stock | 9.06 | 9.0621 | 9.0464 | 9.0518 | 4977588.0 |
| 2010-08-11 10:30:00 | AAPL | Stock | 9.0525 | 9.0539 | 9.0421 | 9.0502 | 6469120.0 |
| 2010-08-11 10:35:00 | AAPL | Stock | 9.0489 | 9.0525 | 9.0411 | 9.0508 | 4357052.0 |
| 2010-08-11 10:40:00 | AAPL | Stock | 9.0507 | 9.063 | 9.0411 | 9.0454 | 6799884.0 |
| 2010-08-11 10:45:00 | AAPL | Stock | 9.0457 | 9.0475 | 9.0354 | 9.0393 | 7847504.0 |
| 2010-08-11 10:50:00 | AAPL | Stock | 9.0393 | 9.04 | 9.0279 | 9.0282 | 7235816.0 |
| 2010-08-11 10:55:00 | AAPL | Stock | 9.0282 | 9.0304 | 8.9871 | 9.0014 | 14840644.0 |
| 2010-08-11 11:00:00 | AAPL | Stock | 9.0016 | 9.0086 | 8.9914 | 9.0086 | 7852488.0 |
> showing 50 of 336,282 rows — these rows as CSV