PREVIEW / stock_5min / 2004-10-15
file: by_date/stock_5min/2004/2004-10-15.parquet size: 2.4 MB rows: 174,090 symbols: 1,836
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-15 08:00:00 | AAPL | Stock | 0.8005 | 0.8005 | 0.7993 | 0.7993 | 25200.0 |
| 2004-10-15 08:05:00 | AAPL | Stock | 0.8005 | 0.8005 | 0.7995 | 0.7995 | 47600.0 |
| 2004-10-15 08:15:00 | AAPL | Stock | 0.8 | 0.8 | 0.8 | 0.8 | 140000.0 |
| 2004-10-15 08:20:00 | AAPL | Stock | 0.8009 | 0.8009 | 0.8009 | 0.8009 | 16800.0 |
| 2004-10-15 08:25:00 | AAPL | Stock | 0.8009 | 0.8009 | 0.8009 | 0.8009 | 196000.0 |
| 2004-10-15 08:30:00 | AAPL | Stock | 0.8011 | 0.8027 | 0.8011 | 0.8018 | 140000.0 |
| 2004-10-15 08:35:00 | AAPL | Stock | 0.8016 | 0.8036 | 0.8 | 0.8036 | 557648.0 |
| 2004-10-15 08:40:00 | AAPL | Stock | 0.8027 | 0.8036 | 0.8027 | 0.8036 | 39200.0 |
| 2004-10-15 08:45:00 | AAPL | Stock | 0.8027 | 0.8036 | 0.8027 | 0.8036 | 39200.0 |
| 2004-10-15 08:50:00 | AAPL | Stock | 0.8036 | 0.8036 | 0.8036 | 0.8036 | 39200.0 |
| 2004-10-15 08:55:00 | AAPL | Stock | 0.8018 | 0.8032 | 0.8018 | 0.8032 | 39200.0 |
| 2004-10-15 09:00:00 | AAPL | Stock | 0.8032 | 0.8032 | 0.8032 | 0.8032 | 50400.0 |
| 2004-10-15 09:05:00 | AAPL | Stock | 0.8032 | 0.8032 | 0.8018 | 0.8018 | 156800.0 |
| 2004-10-15 09:10:00 | AAPL | Stock | 0.8027 | 0.8027 | 0.8025 | 0.8027 | 173600.0 |
| 2004-10-15 09:15:00 | AAPL | Stock | 0.8027 | 0.8029 | 0.8027 | 0.8027 | 330400.0 |
| 2004-10-15 09:20:00 | AAPL | Stock | 0.8027 | 0.8027 | 0.8027 | 0.8027 | 184800.0 |
| 2004-10-15 09:25:00 | AAPL | Stock | 0.8027 | 0.8027 | 0.8014 | 0.8027 | 829472.0 |
| 2004-10-15 09:30:00 | AAPL | Stock | 0.802 | 0.8039 | 0.7946 | 0.8013 | 39582984.0 |
| 2004-10-15 09:35:00 | AAPL | Stock | 0.8013 | 0.8021 | 0.7959 | 0.7959 | 21274176.0 |
| 2004-10-15 09:40:00 | AAPL | Stock | 0.7961 | 0.7973 | 0.7946 | 0.7964 | 19861240.0 |
| 2004-10-15 09:45:00 | AAPL | Stock | 0.7964 | 0.7971 | 0.7925 | 0.7929 | 17658032.0 |
| 2004-10-15 09:50:00 | AAPL | Stock | 0.7934 | 0.7946 | 0.7895 | 0.7941 | 32131176.0 |
| 2004-10-15 09:55:00 | AAPL | Stock | 0.7941 | 0.7945 | 0.7895 | 0.79 | 20467496.0 |
| 2004-10-15 10:00:00 | AAPL | Stock | 0.79 | 0.7938 | 0.7891 | 0.7918 | 20621888.0 |
| 2004-10-15 10:05:00 | AAPL | Stock | 0.7918 | 0.7961 | 0.7911 | 0.7961 | 23047584.0 |
| 2004-10-15 10:10:00 | AAPL | Stock | 0.7961 | 0.7971 | 0.7945 | 0.7971 | 13896064.0 |
| 2004-10-15 10:15:00 | AAPL | Stock | 0.7973 | 0.7979 | 0.7952 | 0.7959 | 11044208.0 |
| 2004-10-15 10:20:00 | AAPL | Stock | 0.7957 | 0.797 | 0.7957 | 0.7964 | 10481912.0 |
| 2004-10-15 10:25:00 | AAPL | Stock | 0.7966 | 0.7996 | 0.7961 | 0.7993 | 14805560.0 |
| 2004-10-15 10:30:00 | AAPL | Stock | 0.7993 | 0.8025 | 0.7993 | 0.7995 | 22223320.0 |
| 2004-10-15 10:35:00 | AAPL | Stock | 0.7996 | 0.8079 | 0.7993 | 0.8063 | 29238776.0 |
| 2004-10-15 10:40:00 | AAPL | Stock | 0.8063 | 0.8068 | 0.8034 | 0.8034 | 17258696.0 |
| 2004-10-15 10:45:00 | AAPL | Stock | 0.8034 | 0.8061 | 0.8027 | 0.8059 | 12850320.0 |
| 2004-10-15 10:50:00 | AAPL | Stock | 0.8059 | 0.8082 | 0.8039 | 0.8041 | 16942576.0 |
| 2004-10-15 10:55:00 | AAPL | Stock | 0.8045 | 0.8048 | 0.8021 | 0.8038 | 14802816.0 |
| 2004-10-15 11:00:00 | AAPL | Stock | 0.8036 | 0.8041 | 0.8002 | 0.802 | 22963864.0 |
| 2004-10-15 11:05:00 | AAPL | Stock | 0.8018 | 0.8021 | 0.7934 | 0.7952 | 24046960.0 |
| 2004-10-15 11:10:00 | AAPL | Stock | 0.7954 | 0.7986 | 0.7948 | 0.7975 | 8973944.0 |
| 2004-10-15 11:15:00 | AAPL | Stock | 0.7973 | 0.8013 | 0.7971 | 0.8002 | 6085800.0 |
| 2004-10-15 11:20:00 | AAPL | Stock | 0.8002 | 0.8002 | 0.7973 | 0.7975 | 4907056.0 |
| 2004-10-15 11:25:00 | AAPL | Stock | 0.7975 | 0.7988 | 0.7975 | 0.7984 | 2843232.0 |
| 2004-10-15 11:30:00 | AAPL | Stock | 0.798 | 0.7998 | 0.798 | 0.7995 | 2357936.0 |
| 2004-10-15 11:35:00 | AAPL | Stock | 0.7993 | 0.8007 | 0.7993 | 0.8002 | 4453568.0 |
| 2004-10-15 11:40:00 | AAPL | Stock | 0.8002 | 0.8007 | 0.7996 | 0.8 | 2961448.0 |
| 2004-10-15 11:45:00 | AAPL | Stock | 0.8 | 0.8002 | 0.7977 | 0.7979 | 5103616.0 |
| 2004-10-15 11:50:00 | AAPL | Stock | 0.798 | 0.7996 | 0.7977 | 0.7995 | 3451168.0 |
| 2004-10-15 11:55:00 | AAPL | Stock | 0.7993 | 0.8014 | 0.7993 | 0.8011 | 4342632.0 |
| 2004-10-15 12:00:00 | AAPL | Stock | 0.8014 | 0.8027 | 0.8004 | 0.8007 | 12037032.0 |
| 2004-10-15 12:05:00 | AAPL | Stock | 0.8011 | 0.8036 | 0.8 | 0.803 | 7073248.0 |
| 2004-10-15 12:10:00 | AAPL | Stock | 0.8021 | 0.8036 | 0.8021 | 0.8036 | 4343920.0 |
> showing 50 of 174,090 rows — these rows as CSV