PREVIEW / stock_5min / 2004-06-01
file: by_date/stock_5min/2004/2004-06-01.parquet size: 2.4 MB rows: 177,604 symbols: 1,778
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-06-01 08:15:00 | AAPL | Stock | 0.5029 | 0.5029 | 0.502 | 0.502 | 11200.0 |
| 2004-06-01 08:20:00 | AAPL | Stock | 0.5018 | 0.5018 | 0.5018 | 0.5018 | 5600.0 |
| 2004-06-01 08:45:00 | AAPL | Stock | 0.502 | 0.502 | 0.5016 | 0.5016 | 11200.0 |
| 2004-06-01 09:00:00 | AAPL | Stock | 0.5011 | 0.5011 | 0.5011 | 0.5011 | 280000.0 |
| 2004-06-01 09:15:00 | AAPL | Stock | 0.5 | 0.5 | 0.5 | 0.5 | 5600.0 |
| 2004-06-01 09:20:00 | AAPL | Stock | 0.5004 | 0.5004 | 0.5 | 0.5 | 78400.0 |
| 2004-06-01 09:25:00 | AAPL | Stock | 0.4989 | 0.4989 | 0.4966 | 0.4966 | 238224.0 |
| 2004-06-01 09:30:00 | AAPL | Stock | 0.4963 | 0.4993 | 0.4943 | 0.4991 | 6865040.0 |
| 2004-06-01 09:35:00 | AAPL | Stock | 0.4993 | 0.5009 | 0.4991 | 0.5 | 5177424.0 |
| 2004-06-01 09:40:00 | AAPL | Stock | 0.5 | 0.5009 | 0.4995 | 0.5002 | 2808960.0 |
| 2004-06-01 09:45:00 | AAPL | Stock | 0.5002 | 0.5021 | 0.5 | 0.5009 | 4975376.0 |
| 2004-06-01 09:50:00 | AAPL | Stock | 0.5011 | 0.5018 | 0.5 | 0.5004 | 2753464.0 |
| 2004-06-01 09:55:00 | AAPL | Stock | 0.5005 | 0.5007 | 0.4991 | 0.5004 | 3566360.0 |
| 2004-06-01 10:00:00 | AAPL | Stock | 0.5004 | 0.5036 | 0.5002 | 0.5025 | 5120808.0 |
| 2004-06-01 10:05:00 | AAPL | Stock | 0.5025 | 0.503 | 0.502 | 0.502 | 1473192.0 |
| 2004-06-01 10:10:00 | AAPL | Stock | 0.502 | 0.5027 | 0.5004 | 0.5004 | 3425912.0 |
| 2004-06-01 10:15:00 | AAPL | Stock | 0.5005 | 0.5007 | 0.4993 | 0.5 | 2836120.0 |
| 2004-06-01 10:20:00 | AAPL | Stock | 0.4998 | 0.5004 | 0.4979 | 0.5 | 2591344.0 |
| 2004-06-01 10:25:00 | AAPL | Stock | 0.5 | 0.5004 | 0.4982 | 0.4986 | 1789256.0 |
| 2004-06-01 10:30:00 | AAPL | Stock | 0.4989 | 0.5009 | 0.4982 | 0.4991 | 2447032.0 |
| 2004-06-01 10:35:00 | AAPL | Stock | 0.4989 | 0.5003 | 0.4982 | 0.4982 | 2578968.0 |
| 2004-06-01 10:40:00 | AAPL | Stock | 0.4984 | 0.4991 | 0.4979 | 0.4982 | 1589952.0 |
| 2004-06-01 10:45:00 | AAPL | Stock | 0.498 | 0.4991 | 0.498 | 0.4989 | 1038240.0 |
| 2004-06-01 10:50:00 | AAPL | Stock | 0.4988 | 0.4993 | 0.4968 | 0.4993 | 2360512.0 |
| 2004-06-01 10:55:00 | AAPL | Stock | 0.4993 | 0.4995 | 0.4988 | 0.4993 | 1463000.0 |
| 2004-06-01 11:00:00 | AAPL | Stock | 0.4995 | 0.4996 | 0.4993 | 0.4995 | 928984.0 |
| 2004-06-01 11:05:00 | AAPL | Stock | 0.4993 | 0.4995 | 0.4984 | 0.4989 | 1626744.0 |
| 2004-06-01 11:10:00 | AAPL | Stock | 0.4989 | 0.4995 | 0.4986 | 0.4993 | 698544.0 |
| 2004-06-01 11:15:00 | AAPL | Stock | 0.4993 | 0.4995 | 0.4975 | 0.4977 | 2057384.0 |
| 2004-06-01 11:20:00 | AAPL | Stock | 0.4977 | 0.4977 | 0.4966 | 0.4973 | 2417744.0 |
| 2004-06-01 11:25:00 | AAPL | Stock | 0.4973 | 0.4979 | 0.4963 | 0.4968 | 2687104.0 |
| 2004-06-01 11:30:00 | AAPL | Stock | 0.497 | 0.498 | 0.4966 | 0.497 | 2240224.0 |
| 2004-06-01 11:35:00 | AAPL | Stock | 0.497 | 0.4975 | 0.4966 | 0.4966 | 1733760.0 |
| 2004-06-01 11:40:00 | AAPL | Stock | 0.4968 | 0.4975 | 0.4959 | 0.4971 | 1488592.0 |
| 2004-06-01 11:45:00 | AAPL | Stock | 0.497 | 0.4973 | 0.4966 | 0.4968 | 1093680.0 |
| 2004-06-01 11:50:00 | AAPL | Stock | 0.497 | 0.4979 | 0.4966 | 0.497 | 2528176.0 |
| 2004-06-01 11:55:00 | AAPL | Stock | 0.497 | 0.497 | 0.4959 | 0.4966 | 866264.0 |
| 2004-06-01 12:00:00 | AAPL | Stock | 0.4968 | 0.498 | 0.4964 | 0.4964 | 2784208.0 |
| 2004-06-01 12:05:00 | AAPL | Stock | 0.4964 | 0.4975 | 0.4964 | 0.4973 | 601440.0 |
| 2004-06-01 12:10:00 | AAPL | Stock | 0.4971 | 0.4973 | 0.4959 | 0.4964 | 2528008.0 |
| 2004-06-01 12:15:00 | AAPL | Stock | 0.4964 | 0.4966 | 0.4959 | 0.4959 | 610400.0 |
| 2004-06-01 12:20:00 | AAPL | Stock | 0.4959 | 0.4959 | 0.4948 | 0.495 | 2032520.0 |
| 2004-06-01 12:25:00 | AAPL | Stock | 0.495 | 0.4963 | 0.4948 | 0.4959 | 1245608.0 |
| 2004-06-01 12:30:00 | AAPL | Stock | 0.4959 | 0.4979 | 0.4952 | 0.4977 | 2465736.0 |
| 2004-06-01 12:35:00 | AAPL | Stock | 0.4977 | 0.4984 | 0.4973 | 0.4979 | 1845760.0 |
| 2004-06-01 12:40:00 | AAPL | Stock | 0.4975 | 0.4977 | 0.497 | 0.4977 | 863296.0 |
| 2004-06-01 12:45:00 | AAPL | Stock | 0.4977 | 0.4979 | 0.4973 | 0.4975 | 980952.0 |
| 2004-06-01 12:50:00 | AAPL | Stock | 0.4975 | 0.4977 | 0.497 | 0.4977 | 2058280.0 |
| 2004-06-01 12:55:00 | AAPL | Stock | 0.4977 | 0.4984 | 0.4973 | 0.4979 | 3329872.0 |
| 2004-06-01 13:00:00 | AAPL | Stock | 0.4979 | 0.4984 | 0.4975 | 0.4984 | 1022952.0 |
> showing 50 of 177,604 rows — these rows as CSV