PREVIEW / stock_5min / 2007-06-13
file: by_date/stock_5min/2007/2007-06-13.parquet size: 4.0 MB rows: 292,517 symbols: 3,023
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-13 09:30:00 | AAPL | Stock | 4.3268 | 4.3282 | 4.2954 | 4.3086 | 34926724.0 |
| 2007-06-13 09:35:00 | AAPL | Stock | 4.3086 | 4.3193 | 4.2632 | 4.2961 | 21768908.0 |
| 2007-06-13 09:40:00 | AAPL | Stock | 4.2954 | 4.3071 | 4.2829 | 4.2889 | 27263964.0 |
| 2007-06-13 09:45:00 | AAPL | Stock | 4.2893 | 4.3 | 4.2789 | 4.2879 | 21389760.0 |
| 2007-06-13 09:50:00 | AAPL | Stock | 4.2875 | 4.3257 | 4.2861 | 4.3004 | 17597552.0 |
| 2007-06-13 09:55:00 | AAPL | Stock | 4.3007 | 4.3039 | 4.2857 | 4.2875 | 13052928.0 |
| 2007-06-13 10:00:00 | AAPL | Stock | 4.2871 | 4.2896 | 4.2768 | 4.2789 | 17443216.0 |
| 2007-06-13 10:05:00 | AAPL | Stock | 4.2789 | 4.2911 | 4.2754 | 4.2761 | 15939280.0 |
| 2007-06-13 10:10:00 | AAPL | Stock | 4.2766 | 4.2868 | 4.2736 | 4.2818 | 16558500.0 |
| 2007-06-13 10:15:00 | AAPL | Stock | 4.2821 | 4.2982 | 4.2818 | 4.295 | 13944084.0 |
| 2007-06-13 10:20:00 | AAPL | Stock | 4.2954 | 4.2993 | 4.2793 | 4.2818 | 16003540.0 |
| 2007-06-13 10:25:00 | AAPL | Stock | 4.2814 | 4.2818 | 4.2732 | 4.2757 | 17371956.0 |
| 2007-06-13 10:30:00 | AAPL | Stock | 4.2757 | 4.2804 | 4.2693 | 4.275 | 14791364.0 |
| 2007-06-13 10:35:00 | AAPL | Stock | 4.275 | 4.2846 | 4.2707 | 4.2721 | 13916896.0 |
| 2007-06-13 10:40:00 | AAPL | Stock | 4.2721 | 4.2732 | 4.25 | 4.2511 | 22084860.0 |
| 2007-06-13 10:45:00 | AAPL | Stock | 4.2514 | 4.2657 | 4.2507 | 4.2636 | 17513384.0 |
| 2007-06-13 10:50:00 | AAPL | Stock | 4.2639 | 4.2654 | 4.2475 | 4.2486 | 19041232.0 |
| 2007-06-13 10:55:00 | AAPL | Stock | 4.2489 | 4.2582 | 4.2482 | 4.2536 | 13419112.0 |
| 2007-06-13 11:00:00 | AAPL | Stock | 4.2536 | 4.2625 | 4.245 | 4.2614 | 19931212.0 |
| 2007-06-13 11:05:00 | AAPL | Stock | 4.2618 | 4.2675 | 4.2561 | 4.2571 | 16270324.0 |
| 2007-06-13 11:10:00 | AAPL | Stock | 4.2564 | 4.2586 | 4.2432 | 4.2443 | 12824728.0 |
| 2007-06-13 11:15:00 | AAPL | Stock | 4.2439 | 4.2486 | 4.2321 | 4.2357 | 22945804.0 |
| 2007-06-13 11:20:00 | AAPL | Stock | 4.2357 | 4.2571 | 4.2043 | 4.2143 | 40984412.0 |
| 2007-06-13 11:25:00 | AAPL | Stock | 4.2146 | 4.2161 | 4.1879 | 4.2071 | 70037660.0 |
| 2007-06-13 11:30:00 | AAPL | Stock | 4.2068 | 4.2143 | 4.175 | 4.1843 | 52849468.0 |
| 2007-06-13 11:35:00 | AAPL | Stock | 4.1846 | 4.1907 | 4.1696 | 4.1893 | 48696060.0 |
| 2007-06-13 11:40:00 | AAPL | Stock | 4.19 | 4.1939 | 4.1786 | 4.1861 | 24011092.0 |
| 2007-06-13 11:45:00 | AAPL | Stock | 4.1861 | 4.1904 | 4.1732 | 4.1904 | 28329112.0 |
| 2007-06-13 11:50:00 | AAPL | Stock | 4.19 | 4.1921 | 4.1786 | 4.1893 | 16806860.0 |
| 2007-06-13 11:55:00 | AAPL | Stock | 4.1896 | 4.1925 | 4.1789 | 4.1825 | 15589196.0 |
| 2007-06-13 12:00:00 | AAPL | Stock | 4.1825 | 4.1868 | 4.1675 | 4.175 | 20945848.0 |
| 2007-06-13 12:05:00 | AAPL | Stock | 4.175 | 4.1829 | 4.1729 | 4.1779 | 18001060.0 |
| 2007-06-13 12:10:00 | AAPL | Stock | 4.1775 | 4.1782 | 4.1629 | 4.1689 | 27456996.0 |
| 2007-06-13 12:15:00 | AAPL | Stock | 4.1689 | 4.1729 | 4.1596 | 4.1671 | 23878512.0 |
| 2007-06-13 12:20:00 | AAPL | Stock | 4.1671 | 4.1707 | 4.1536 | 4.1561 | 20658876.0 |
| 2007-06-13 12:25:00 | AAPL | Stock | 4.1561 | 4.1604 | 4.1364 | 4.1468 | 40957392.0 |
| 2007-06-13 12:30:00 | AAPL | Stock | 4.1468 | 4.1475 | 4.1214 | 4.1393 | 34071940.0 |
| 2007-06-13 12:35:00 | AAPL | Stock | 4.1396 | 4.1629 | 4.1371 | 4.1626 | 30739044.0 |
| 2007-06-13 12:40:00 | AAPL | Stock | 4.1625 | 4.1729 | 4.1521 | 4.1571 | 29717772.0 |
| 2007-06-13 12:45:00 | AAPL | Stock | 4.1575 | 4.1589 | 4.1482 | 4.1539 | 13499192.0 |
| 2007-06-13 12:50:00 | AAPL | Stock | 4.1539 | 4.1561 | 4.1368 | 4.1421 | 21519680.0 |
| 2007-06-13 12:55:00 | AAPL | Stock | 4.1414 | 4.1511 | 4.1404 | 4.1421 | 14264012.0 |
| 2007-06-13 13:00:00 | AAPL | Stock | 4.1421 | 4.15 | 4.1386 | 4.1457 | 13796664.0 |
| 2007-06-13 13:05:00 | AAPL | Stock | 4.1482 | 4.1525 | 4.14 | 4.1439 | 13420288.0 |
| 2007-06-13 13:10:00 | AAPL | Stock | 4.1439 | 4.1529 | 4.1429 | 4.1493 | 10655260.0 |
| 2007-06-13 13:15:00 | AAPL | Stock | 4.1493 | 4.1525 | 4.1418 | 4.1493 | 14915992.0 |
| 2007-06-13 13:20:00 | AAPL | Stock | 4.1496 | 4.1614 | 4.1468 | 4.1546 | 15675352.0 |
| 2007-06-13 13:25:00 | AAPL | Stock | 4.1539 | 4.1554 | 4.1475 | 4.1493 | 10764292.0 |
| 2007-06-13 13:30:00 | AAPL | Stock | 4.1496 | 4.1507 | 4.1393 | 4.1393 | 11946396.0 |
| 2007-06-13 13:35:00 | AAPL | Stock | 4.1404 | 4.1439 | 4.1268 | 4.1432 | 20256096.0 |
> showing 50 of 292,517 rows — these rows as CSV