PREVIEW / stock_5min / 2009-10-07
file: by_date/stock_5min/2009/2009-10-07.parquet size: 4.5 MB rows: 310,386 symbols: 3,374
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-07 06:05:00 | AAPL | Stock | 6.8157 | 6.8157 | 6.8157 | 6.8157 | 16800.0 |
| 2009-10-07 06:10:00 | AAPL | Stock | 6.8154 | 6.8154 | 6.8154 | 6.8154 | 2800.0 |
| 2009-10-07 06:30:00 | AAPL | Stock | 6.8071 | 6.8107 | 6.7993 | 6.7993 | 16800.0 |
| 2009-10-07 06:50:00 | AAPL | Stock | 6.7964 | 6.7964 | 6.7964 | 6.7964 | 23268.0 |
| 2009-10-07 07:15:00 | AAPL | Stock | 6.7979 | 6.7982 | 6.7979 | 6.7982 | 5600.0 |
| 2009-10-07 07:20:00 | AAPL | Stock | 6.7929 | 6.7929 | 6.7925 | 6.7925 | 28000.0 |
| 2009-10-07 07:25:00 | AAPL | Stock | 6.7864 | 6.7864 | 6.7682 | 6.7682 | 75880.0 |
| 2009-10-07 07:30:00 | AAPL | Stock | 6.7682 | 6.7839 | 6.7679 | 6.7839 | 56840.0 |
| 2009-10-07 07:35:00 | AAPL | Stock | 6.7786 | 6.78 | 6.7743 | 6.7743 | 11200.0 |
| 2009-10-07 07:40:00 | AAPL | Stock | 6.7732 | 6.7732 | 6.7732 | 6.7732 | 25200.0 |
| 2009-10-07 07:45:00 | AAPL | Stock | 6.7732 | 6.7732 | 6.7732 | 6.7732 | 8400.0 |
| 2009-10-07 08:00:00 | AAPL | Stock | 6.7732 | 6.785 | 6.7679 | 6.7732 | 263564.0 |
| 2009-10-07 08:05:00 | AAPL | Stock | 6.7732 | 6.7732 | 6.7679 | 6.7696 | 120260.0 |
| 2009-10-07 08:10:00 | AAPL | Stock | 6.7714 | 6.7714 | 6.7614 | 6.7696 | 103320.0 |
| 2009-10-07 08:15:00 | AAPL | Stock | 6.7671 | 6.7714 | 6.7668 | 6.7696 | 18480.0 |
| 2009-10-07 08:20:00 | AAPL | Stock | 6.7714 | 6.775 | 6.7675 | 6.775 | 188160.0 |
| 2009-10-07 08:25:00 | AAPL | Stock | 6.7746 | 6.78 | 6.7746 | 6.78 | 114408.0 |
| 2009-10-07 08:30:00 | AAPL | Stock | 6.7782 | 6.78 | 6.7739 | 6.7739 | 210924.0 |
| 2009-10-07 08:35:00 | AAPL | Stock | 6.7739 | 6.7739 | 6.7729 | 6.7729 | 42476.0 |
| 2009-10-07 08:40:00 | AAPL | Stock | 6.775 | 6.775 | 6.7725 | 6.7725 | 14840.0 |
| 2009-10-07 08:45:00 | AAPL | Stock | 6.7725 | 6.7746 | 6.7696 | 6.7696 | 161504.0 |
| 2009-10-07 08:50:00 | AAPL | Stock | 6.7696 | 6.7714 | 6.7646 | 6.7654 | 390488.0 |
| 2009-10-07 08:55:00 | AAPL | Stock | 6.7654 | 6.7675 | 6.7646 | 6.7646 | 61376.0 |
| 2009-10-07 09:00:00 | AAPL | Stock | 6.765 | 6.7679 | 6.7643 | 6.7679 | 61600.0 |
| 2009-10-07 09:05:00 | AAPL | Stock | 6.7661 | 6.7671 | 6.7646 | 6.7661 | 49700.0 |
| 2009-10-07 09:10:00 | AAPL | Stock | 6.7657 | 6.7711 | 6.7657 | 6.7696 | 244328.0 |
| 2009-10-07 09:15:00 | AAPL | Stock | 6.7682 | 6.7707 | 6.7664 | 6.7664 | 30240.0 |
| 2009-10-07 09:20:00 | AAPL | Stock | 6.7686 | 6.7696 | 6.7671 | 6.7696 | 22400.0 |
| 2009-10-07 09:25:00 | AAPL | Stock | 6.7696 | 6.78 | 6.7675 | 6.7779 | 256816.0 |
| 2009-10-07 09:30:00 | AAPL | Stock | 6.7743 | 6.8 | 6.7607 | 6.7857 | 18811240.0 |
| 2009-10-07 09:35:00 | AAPL | Stock | 6.7829 | 6.7954 | 6.7625 | 6.788 | 16552424.0 |
| 2009-10-07 09:40:00 | AAPL | Stock | 6.7879 | 6.7911 | 6.7571 | 6.7764 | 15955940.0 |
| 2009-10-07 09:45:00 | AAPL | Stock | 6.7761 | 6.7807 | 6.7618 | 6.7725 | 9527308.0 |
| 2009-10-07 09:50:00 | AAPL | Stock | 6.7725 | 6.7993 | 6.7721 | 6.7825 | 15739248.0 |
| 2009-10-07 09:55:00 | AAPL | Stock | 6.7829 | 6.8054 | 6.7786 | 6.7789 | 13317220.0 |
| 2009-10-07 10:00:00 | AAPL | Stock | 6.78 | 6.7836 | 6.7679 | 6.7768 | 10346000.0 |
| 2009-10-07 10:05:00 | AAPL | Stock | 6.7781 | 6.7836 | 6.7714 | 6.78 | 5998412.0 |
| 2009-10-07 10:10:00 | AAPL | Stock | 6.7804 | 6.7964 | 6.7764 | 6.7932 | 10545556.0 |
| 2009-10-07 10:15:00 | AAPL | Stock | 6.7932 | 6.7954 | 6.7736 | 6.7771 | 8594964.0 |
| 2009-10-07 10:20:00 | AAPL | Stock | 6.7768 | 6.78 | 6.7643 | 6.7732 | 9500176.0 |
| 2009-10-07 10:25:00 | AAPL | Stock | 6.7729 | 6.7839 | 6.77 | 6.7819 | 6234704.0 |
| 2009-10-07 10:30:00 | AAPL | Stock | 6.7821 | 6.7825 | 6.7686 | 6.7714 | 8057336.0 |
| 2009-10-07 10:35:00 | AAPL | Stock | 6.7704 | 6.7839 | 6.77 | 6.7793 | 7565236.0 |
| 2009-10-07 10:40:00 | AAPL | Stock | 6.7796 | 6.7825 | 6.7704 | 6.7732 | 5299056.0 |
| 2009-10-07 10:45:00 | AAPL | Stock | 6.7732 | 6.7746 | 6.7607 | 6.7614 | 7263760.0 |
| 2009-10-07 10:50:00 | AAPL | Stock | 6.7621 | 6.7771 | 6.7604 | 6.7732 | 7101024.0 |
| 2009-10-07 10:55:00 | AAPL | Stock | 6.7739 | 6.7814 | 6.7732 | 6.7804 | 4789120.0 |
| 2009-10-07 11:00:00 | AAPL | Stock | 6.7804 | 6.7971 | 6.78 | 6.7896 | 9179156.0 |
| 2009-10-07 11:05:00 | AAPL | Stock | 6.7904 | 6.7929 | 6.7804 | 6.7805 | 6247192.0 |
| 2009-10-07 11:10:00 | AAPL | Stock | 6.7814 | 6.7836 | 6.7732 | 6.7789 | 5547304.0 |
> showing 50 of 310,386 rows — these rows as CSV