PREVIEW / stock_5min / 2005-09-09
file: by_date/stock_5min/2005/2005-09-09.parquet size: 2.7 MB rows: 198,346 symbols: 2,071
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-09 08:00:00 | AAPL | Stock | 1.7854 | 1.7854 | 1.7839 | 1.785 | 12600.0 |
| 2005-09-09 08:05:00 | AAPL | Stock | 1.785 | 1.785 | 1.7843 | 1.7843 | 33600.0 |
| 2005-09-09 08:10:00 | AAPL | Stock | 1.785 | 1.785 | 1.785 | 1.785 | 38920.0 |
| 2005-09-09 08:15:00 | AAPL | Stock | 1.7821 | 1.7839 | 1.7821 | 1.7839 | 15400.0 |
| 2005-09-09 08:25:00 | AAPL | Stock | 1.7829 | 1.7829 | 1.7804 | 1.7804 | 46200.0 |
| 2005-09-09 08:30:00 | AAPL | Stock | 1.7789 | 1.7814 | 1.7789 | 1.7804 | 52500.0 |
| 2005-09-09 08:35:00 | AAPL | Stock | 1.7814 | 1.7814 | 1.7814 | 1.7814 | 23800.0 |
| 2005-09-09 08:40:00 | AAPL | Stock | 1.7818 | 1.7818 | 1.7804 | 1.7818 | 419776.0 |
| 2005-09-09 08:45:00 | AAPL | Stock | 1.7814 | 1.7814 | 1.7804 | 1.7804 | 29120.0 |
| 2005-09-09 08:50:00 | AAPL | Stock | 1.7793 | 1.7818 | 1.7793 | 1.7818 | 78400.0 |
| 2005-09-09 08:55:00 | AAPL | Stock | 1.7818 | 1.7818 | 1.78 | 1.78 | 34160.0 |
| 2005-09-09 09:00:00 | AAPL | Stock | 1.78 | 1.78 | 1.7786 | 1.7786 | 380156.0 |
| 2005-09-09 09:05:00 | AAPL | Stock | 1.7804 | 1.785 | 1.7789 | 1.785 | 222936.0 |
| 2005-09-09 09:10:00 | AAPL | Stock | 1.7821 | 1.7839 | 1.7821 | 1.7839 | 33600.0 |
| 2005-09-09 09:15:00 | AAPL | Stock | 1.7836 | 1.785 | 1.7821 | 1.7836 | 78400.0 |
| 2005-09-09 09:20:00 | AAPL | Stock | 1.7836 | 1.7839 | 1.7836 | 1.7839 | 49140.0 |
| 2005-09-09 09:25:00 | AAPL | Stock | 1.7846 | 1.7871 | 1.7796 | 1.7871 | 671160.0 |
| 2005-09-09 09:30:00 | AAPL | Stock | 1.7882 | 1.7882 | 1.7782 | 1.78 | 15821316.0 |
| 2005-09-09 09:35:00 | AAPL | Stock | 1.78 | 1.7907 | 1.78 | 1.7896 | 15710912.0 |
| 2005-09-09 09:40:00 | AAPL | Stock | 1.79 | 1.7943 | 1.7879 | 1.7911 | 20874084.0 |
| 2005-09-09 09:45:00 | AAPL | Stock | 1.7914 | 1.7932 | 1.7839 | 1.7882 | 15806896.0 |
| 2005-09-09 09:50:00 | AAPL | Stock | 1.7882 | 1.7904 | 1.7821 | 1.7843 | 15767276.0 |
| 2005-09-09 09:55:00 | AAPL | Stock | 1.7839 | 1.7896 | 1.7825 | 1.7882 | 7989380.0 |
| 2005-09-09 10:00:00 | AAPL | Stock | 1.7882 | 1.79 | 1.7836 | 1.7839 | 8539524.0 |
| 2005-09-09 10:05:00 | AAPL | Stock | 1.7839 | 1.7893 | 1.7839 | 1.7864 | 5363568.0 |
| 2005-09-09 10:10:00 | AAPL | Stock | 1.7864 | 1.7907 | 1.7857 | 1.7907 | 9814112.0 |
| 2005-09-09 10:15:00 | AAPL | Stock | 1.79 | 1.7943 | 1.7893 | 1.7929 | 9421216.0 |
| 2005-09-09 10:20:00 | AAPL | Stock | 1.7932 | 1.7936 | 1.7893 | 1.7911 | 5906348.0 |
| 2005-09-09 10:25:00 | AAPL | Stock | 1.7911 | 1.7982 | 1.7907 | 1.7975 | 11639320.0 |
| 2005-09-09 10:30:00 | AAPL | Stock | 1.7971 | 1.7986 | 1.7936 | 1.7979 | 11399220.0 |
| 2005-09-09 10:35:00 | AAPL | Stock | 1.7979 | 1.8018 | 1.7961 | 1.7989 | 17515036.0 |
| 2005-09-09 10:40:00 | AAPL | Stock | 1.7989 | 1.8 | 1.7954 | 1.7957 | 7173488.0 |
| 2005-09-09 10:45:00 | AAPL | Stock | 1.7957 | 1.7999 | 1.7936 | 1.7989 | 6785912.0 |
| 2005-09-09 10:50:00 | AAPL | Stock | 1.7989 | 1.8014 | 1.7975 | 1.7975 | 8855056.0 |
| 2005-09-09 10:55:00 | AAPL | Stock | 1.7975 | 1.7993 | 1.7968 | 1.7989 | 4066552.0 |
| 2005-09-09 11:00:00 | AAPL | Stock | 1.7989 | 1.8025 | 1.7979 | 1.8007 | 10973648.0 |
| 2005-09-09 11:05:00 | AAPL | Stock | 1.8011 | 1.8043 | 1.8004 | 1.8018 | 11514916.0 |
| 2005-09-09 11:10:00 | AAPL | Stock | 1.8021 | 1.805 | 1.8018 | 1.8046 | 10079832.0 |
| 2005-09-09 11:15:00 | AAPL | Stock | 1.8046 | 1.8086 | 1.8043 | 1.8079 | 14002380.0 |
| 2005-09-09 11:20:00 | AAPL | Stock | 1.8071 | 1.8136 | 1.8068 | 1.8121 | 13402928.0 |
| 2005-09-09 11:25:00 | AAPL | Stock | 1.8118 | 1.8121 | 1.8086 | 1.81 | 7616000.0 |
| 2005-09-09 11:30:00 | AAPL | Stock | 1.8097 | 1.8168 | 1.8097 | 1.8164 | 11296852.0 |
| 2005-09-09 11:35:00 | AAPL | Stock | 1.8164 | 1.8182 | 1.8146 | 1.8161 | 11102420.0 |
| 2005-09-09 11:40:00 | AAPL | Stock | 1.8161 | 1.82 | 1.8154 | 1.8182 | 14226100.0 |
| 2005-09-09 11:45:00 | AAPL | Stock | 1.8185 | 1.8196 | 1.8179 | 1.8186 | 7689136.0 |
| 2005-09-09 11:50:00 | AAPL | Stock | 1.8182 | 1.8196 | 1.8179 | 1.8182 | 5313140.0 |
| 2005-09-09 11:55:00 | AAPL | Stock | 1.8186 | 1.8214 | 1.8171 | 1.8211 | 9882404.0 |
| 2005-09-09 12:00:00 | AAPL | Stock | 1.8211 | 1.8214 | 1.8168 | 1.8168 | 11380180.0 |
| 2005-09-09 12:05:00 | AAPL | Stock | 1.8168 | 1.8182 | 1.8154 | 1.8164 | 8114484.0 |
| 2005-09-09 12:10:00 | AAPL | Stock | 1.8164 | 1.8168 | 1.8132 | 1.8132 | 5999784.0 |
> showing 50 of 198,346 rows — these rows as CSV