PREVIEW / stock_5min / 2009-10-09
file: by_date/stock_5min/2009/2009-10-09.parquet size: 4.5 MB rows: 310,825 symbols: 3,381
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-10-09 04:50:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 2800.0 |
| 2009-10-09 06:15:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 6020.0 |
| 2009-10-09 06:45:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 2800.0 |
| 2009-10-09 07:00:00 | AAPL | Stock | 6.7714 | 6.7714 | 6.7714 | 6.7714 | 2800.0 |
| 2009-10-09 07:35:00 | AAPL | Stock | 6.7711 | 6.7711 | 6.7679 | 6.7679 | 11200.0 |
| 2009-10-09 07:40:00 | AAPL | Stock | 6.7679 | 6.7679 | 6.7679 | 6.7679 | 8400.0 |
| 2009-10-09 07:50:00 | AAPL | Stock | 6.7693 | 6.7693 | 6.7693 | 6.7693 | 2800.0 |
| 2009-10-09 07:55:00 | AAPL | Stock | 6.7721 | 6.7721 | 6.7714 | 6.7714 | 5600.0 |
| 2009-10-09 08:00:00 | AAPL | Stock | 6.7718 | 6.7732 | 6.76 | 6.7679 | 86268.0 |
| 2009-10-09 08:05:00 | AAPL | Stock | 6.7646 | 6.7646 | 6.7607 | 6.7607 | 25200.0 |
| 2009-10-09 08:10:00 | AAPL | Stock | 6.7589 | 6.7596 | 6.7589 | 6.7596 | 5600.0 |
| 2009-10-09 08:15:00 | AAPL | Stock | 6.7582 | 6.7589 | 6.7393 | 6.7454 | 248220.0 |
| 2009-10-09 08:20:00 | AAPL | Stock | 6.7454 | 6.75 | 6.7375 | 6.7375 | 228228.0 |
| 2009-10-09 08:25:00 | AAPL | Stock | 6.7411 | 6.7454 | 6.7411 | 6.7446 | 44800.0 |
| 2009-10-09 08:30:00 | AAPL | Stock | 6.7414 | 6.7454 | 6.7332 | 6.7332 | 143360.0 |
| 2009-10-09 08:35:00 | AAPL | Stock | 6.7393 | 6.7454 | 6.7393 | 6.7429 | 62440.0 |
| 2009-10-09 08:40:00 | AAPL | Stock | 6.7439 | 6.7439 | 6.7375 | 6.7375 | 68040.0 |
| 2009-10-09 08:45:00 | AAPL | Stock | 6.7371 | 6.7432 | 6.7371 | 6.7432 | 21952.0 |
| 2009-10-09 08:50:00 | AAPL | Stock | 6.7429 | 6.7429 | 6.7411 | 6.7411 | 25200.0 |
| 2009-10-09 08:55:00 | AAPL | Stock | 6.7446 | 6.7482 | 6.7411 | 6.7429 | 133392.0 |
| 2009-10-09 09:00:00 | AAPL | Stock | 6.7429 | 6.7429 | 6.7393 | 6.7393 | 61600.0 |
| 2009-10-09 09:05:00 | AAPL | Stock | 6.7371 | 6.7407 | 6.7368 | 6.7368 | 33600.0 |
| 2009-10-09 09:10:00 | AAPL | Stock | 6.7371 | 6.7411 | 6.7357 | 6.7411 | 22400.0 |
| 2009-10-09 09:15:00 | AAPL | Stock | 6.7407 | 6.7454 | 6.7407 | 6.7454 | 32648.0 |
| 2009-10-09 09:20:00 | AAPL | Stock | 6.7411 | 6.7429 | 6.7407 | 6.7429 | 21000.0 |
| 2009-10-09 09:25:00 | AAPL | Stock | 6.7414 | 6.7604 | 6.7325 | 6.7464 | 446460.0 |
| 2009-10-09 09:30:00 | AAPL | Stock | 6.7489 | 6.78 | 6.7364 | 6.7732 | 13312796.0 |
| 2009-10-09 09:35:00 | AAPL | Stock | 6.7725 | 6.7857 | 6.7664 | 6.7775 | 11062968.0 |
| 2009-10-09 09:40:00 | AAPL | Stock | 6.78 | 6.8093 | 6.7779 | 6.7979 | 13919304.0 |
| 2009-10-09 09:45:00 | AAPL | Stock | 6.7986 | 6.8107 | 6.7929 | 6.7971 | 8134196.0 |
| 2009-10-09 09:50:00 | AAPL | Stock | 6.7982 | 6.805 | 6.7957 | 6.7971 | 7535584.0 |
| 2009-10-09 09:55:00 | AAPL | Stock | 6.7968 | 6.8054 | 6.79 | 6.7929 | 6993196.0 |
| 2009-10-09 10:00:00 | AAPL | Stock | 6.7929 | 6.795 | 6.7757 | 6.7786 | 7369236.0 |
| 2009-10-09 10:05:00 | AAPL | Stock | 6.7782 | 6.7946 | 6.7782 | 6.7925 | 5801432.0 |
| 2009-10-09 10:10:00 | AAPL | Stock | 6.7925 | 6.8054 | 6.7914 | 6.7914 | 6822648.0 |
| 2009-10-09 10:15:00 | AAPL | Stock | 6.7914 | 6.7946 | 6.7857 | 6.7882 | 4204256.0 |
| 2009-10-09 10:20:00 | AAPL | Stock | 6.7893 | 6.7921 | 6.7804 | 6.7918 | 4188324.0 |
| 2009-10-09 10:25:00 | AAPL | Stock | 6.7911 | 6.7961 | 6.7882 | 6.7943 | 2922220.0 |
| 2009-10-09 10:30:00 | AAPL | Stock | 6.7946 | 6.8032 | 6.7939 | 6.8 | 3895164.0 |
| 2009-10-09 10:35:00 | AAPL | Stock | 6.8001 | 6.8004 | 6.7896 | 6.7939 | 3330628.0 |
| 2009-10-09 10:40:00 | AAPL | Stock | 6.7947 | 6.7986 | 6.7864 | 6.7879 | 2631636.0 |
| 2009-10-09 10:45:00 | AAPL | Stock | 6.788 | 6.7939 | 6.7861 | 6.7929 | 2394896.0 |
| 2009-10-09 10:50:00 | AAPL | Stock | 6.7924 | 6.7979 | 6.7893 | 6.7943 | 2481108.0 |
| 2009-10-09 10:55:00 | AAPL | Stock | 6.7943 | 6.7957 | 6.7821 | 6.7829 | 2942016.0 |
| 2009-10-09 11:00:00 | AAPL | Stock | 6.7829 | 6.7893 | 6.78 | 6.7862 | 2593920.0 |
| 2009-10-09 11:05:00 | AAPL | Stock | 6.7861 | 6.79 | 6.7825 | 6.7857 | 1235892.0 |
| 2009-10-09 11:10:00 | AAPL | Stock | 6.7854 | 6.7889 | 6.7811 | 6.7832 | 2132032.0 |
| 2009-10-09 11:15:00 | AAPL | Stock | 6.7829 | 6.7871 | 6.7811 | 6.7856 | 1630776.0 |
| 2009-10-09 11:20:00 | AAPL | Stock | 6.7857 | 6.7968 | 6.7854 | 6.795 | 4279212.0 |
| 2009-10-09 11:25:00 | AAPL | Stock | 6.795 | 6.7964 | 6.7904 | 6.7904 | 4941720.0 |
> showing 50 of 310,825 rows — these rows as CSV