PREVIEW / stock_5min / 2004-05-28
file: by_date/stock_5min/2004/2004-05-28.parquet size: 2.3 MB rows: 174,442 symbols: 1,772
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-05-28 08:00:00 | AAPL | Stock | 0.5043 | 0.5043 | 0.5043 | 0.5043 | 11200.0 |
| 2004-05-28 08:05:00 | AAPL | Stock | 0.4961 | 0.4961 | 0.4961 | 0.4961 | 11200.0 |
| 2004-05-28 08:10:00 | AAPL | Stock | 0.5039 | 0.5039 | 0.5039 | 0.5039 | 5600.0 |
| 2004-05-28 09:20:00 | AAPL | Stock | 0.5021 | 0.5021 | 0.5021 | 0.5021 | 16800.0 |
| 2004-05-28 09:25:00 | AAPL | Stock | 0.5016 | 0.5023 | 0.5016 | 0.5023 | 85960.0 |
| 2004-05-28 09:30:00 | AAPL | Stock | 0.502 | 0.5034 | 0.5009 | 0.5011 | 5710040.0 |
| 2004-05-28 09:35:00 | AAPL | Stock | 0.5011 | 0.5048 | 0.5009 | 0.5013 | 3671416.0 |
| 2004-05-28 09:40:00 | AAPL | Stock | 0.5013 | 0.503 | 0.5007 | 0.5025 | 2105376.0 |
| 2004-05-28 09:45:00 | AAPL | Stock | 0.5025 | 0.5027 | 0.5005 | 0.5013 | 1468936.0 |
| 2004-05-28 09:50:00 | AAPL | Stock | 0.5018 | 0.5023 | 0.5005 | 0.5011 | 1579200.0 |
| 2004-05-28 09:55:00 | AAPL | Stock | 0.5011 | 0.5016 | 0.497 | 0.4971 | 3016944.0 |
| 2004-05-28 10:00:00 | AAPL | Stock | 0.4973 | 0.4995 | 0.4964 | 0.4986 | 6403600.0 |
| 2004-05-28 10:05:00 | AAPL | Stock | 0.4986 | 0.4998 | 0.4971 | 0.4991 | 2917096.0 |
| 2004-05-28 10:10:00 | AAPL | Stock | 0.4991 | 0.4991 | 0.4982 | 0.4988 | 1806168.0 |
| 2004-05-28 10:15:00 | AAPL | Stock | 0.4988 | 0.4993 | 0.4986 | 0.4991 | 3609536.0 |
| 2004-05-28 10:20:00 | AAPL | Stock | 0.4993 | 0.5002 | 0.4979 | 0.4988 | 1834336.0 |
| 2004-05-28 10:25:00 | AAPL | Stock | 0.4991 | 0.4991 | 0.4971 | 0.4986 | 1237040.0 |
| 2004-05-28 10:30:00 | AAPL | Stock | 0.4988 | 0.4995 | 0.4984 | 0.4993 | 1054928.0 |
| 2004-05-28 10:35:00 | AAPL | Stock | 0.4993 | 0.4996 | 0.4991 | 0.4996 | 739200.0 |
| 2004-05-28 10:40:00 | AAPL | Stock | 0.4996 | 0.4996 | 0.4991 | 0.4993 | 943040.0 |
| 2004-05-28 10:45:00 | AAPL | Stock | 0.4993 | 0.4993 | 0.4991 | 0.4993 | 525504.0 |
| 2004-05-28 10:50:00 | AAPL | Stock | 0.4991 | 0.4993 | 0.4982 | 0.4988 | 774984.0 |
| 2004-05-28 10:55:00 | AAPL | Stock | 0.4986 | 0.4995 | 0.4984 | 0.4995 | 1014552.0 |
| 2004-05-28 11:00:00 | AAPL | Stock | 0.4996 | 0.5005 | 0.4995 | 0.5002 | 1772232.0 |
| 2004-05-28 11:05:00 | AAPL | Stock | 0.5004 | 0.5007 | 0.5002 | 0.5002 | 1124928.0 |
| 2004-05-28 11:10:00 | AAPL | Stock | 0.5002 | 0.5004 | 0.5002 | 0.5002 | 1108184.0 |
| 2004-05-28 11:15:00 | AAPL | Stock | 0.5002 | 0.5007 | 0.5 | 0.5005 | 674408.0 |
| 2004-05-28 11:20:00 | AAPL | Stock | 0.5004 | 0.5007 | 0.5002 | 0.5005 | 452704.0 |
| 2004-05-28 11:25:00 | AAPL | Stock | 0.5007 | 0.502 | 0.5005 | 0.502 | 963760.0 |
| 2004-05-28 11:30:00 | AAPL | Stock | 0.502 | 0.5023 | 0.5014 | 0.5016 | 402640.0 |
| 2004-05-28 11:35:00 | AAPL | Stock | 0.5016 | 0.5021 | 0.5016 | 0.502 | 598640.0 |
| 2004-05-28 11:40:00 | AAPL | Stock | 0.502 | 0.502 | 0.5011 | 0.5011 | 1072064.0 |
| 2004-05-28 11:45:00 | AAPL | Stock | 0.5011 | 0.5011 | 0.5 | 0.5009 | 1640800.0 |
| 2004-05-28 11:50:00 | AAPL | Stock | 0.5011 | 0.5013 | 0.5002 | 0.5002 | 758800.0 |
| 2004-05-28 11:55:00 | AAPL | Stock | 0.5 | 0.5007 | 0.4996 | 0.5005 | 585256.0 |
| 2004-05-28 12:00:00 | AAPL | Stock | 0.5007 | 0.5007 | 0.5 | 0.5004 | 2462152.0 |
| 2004-05-28 12:05:00 | AAPL | Stock | 0.5004 | 0.5023 | 0.5004 | 0.5023 | 3560928.0 |
| 2004-05-28 12:10:00 | AAPL | Stock | 0.5023 | 0.5039 | 0.5021 | 0.5025 | 1857800.0 |
| 2004-05-28 12:15:00 | AAPL | Stock | 0.5029 | 0.5029 | 0.5023 | 0.5023 | 219520.0 |
| 2004-05-28 12:20:00 | AAPL | Stock | 0.502 | 0.5021 | 0.5009 | 0.5009 | 956312.0 |
| 2004-05-28 12:25:00 | AAPL | Stock | 0.5007 | 0.5013 | 0.4998 | 0.5 | 1068312.0 |
| 2004-05-28 12:30:00 | AAPL | Stock | 0.5 | 0.5 | 0.4995 | 0.4996 | 3349360.0 |
| 2004-05-28 12:35:00 | AAPL | Stock | 0.4996 | 0.4996 | 0.4995 | 0.4995 | 736624.0 |
| 2004-05-28 12:40:00 | AAPL | Stock | 0.4995 | 0.4996 | 0.4984 | 0.4989 | 2544640.0 |
| 2004-05-28 12:45:00 | AAPL | Stock | 0.4989 | 0.4993 | 0.4988 | 0.4991 | 695856.0 |
| 2004-05-28 12:50:00 | AAPL | Stock | 0.4993 | 0.4998 | 0.4989 | 0.4991 | 1069432.0 |
| 2004-05-28 12:55:00 | AAPL | Stock | 0.4991 | 0.4991 | 0.4988 | 0.4989 | 1463616.0 |
| 2004-05-28 13:00:00 | AAPL | Stock | 0.4991 | 0.4991 | 0.498 | 0.4986 | 1592584.0 |
| 2004-05-28 13:05:00 | AAPL | Stock | 0.4986 | 0.4989 | 0.4986 | 0.4989 | 3970008.0 |
| 2004-05-28 13:10:00 | AAPL | Stock | 0.4989 | 0.4991 | 0.4988 | 0.4991 | 232120.0 |
> showing 50 of 174,442 rows — these rows as CSV