PREVIEW / stock_5min / 2004-04-20
file: by_date/stock_5min/2004/2004-04-20.parquet size: 2.4 MB rows: 177,118 symbols: 1,752
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-04-20 08:00:00 | AAPL | Stock | 0.5082 | 0.5082 | 0.5082 | 0.5082 | 11200.0 |
| 2004-04-20 08:10:00 | AAPL | Stock | 0.5082 | 0.5082 | 0.5082 | 0.5082 | 11200.0 |
| 2004-04-20 08:15:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5063 | 0.5063 | 25200.0 |
| 2004-04-20 08:30:00 | AAPL | Stock | 0.508 | 0.508 | 0.508 | 0.508 | 112000.0 |
| 2004-04-20 08:35:00 | AAPL | Stock | 0.5071 | 0.5071 | 0.5064 | 0.5064 | 112000.0 |
| 2004-04-20 08:40:00 | AAPL | Stock | 0.5071 | 0.5071 | 0.5071 | 0.5071 | 56000.0 |
| 2004-04-20 08:45:00 | AAPL | Stock | 0.5073 | 0.5075 | 0.5073 | 0.5075 | 60480.0 |
| 2004-04-20 09:00:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5063 | 0.5063 | 38248.0 |
| 2004-04-20 09:05:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5046 | 0.5046 | 218400.0 |
| 2004-04-20 09:10:00 | AAPL | Stock | 0.5063 | 0.5088 | 0.5063 | 0.5088 | 33600.0 |
| 2004-04-20 09:20:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5032 | 0.5032 | 148288.0 |
| 2004-04-20 09:25:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5029 | 0.5038 | 200480.0 |
| 2004-04-20 09:30:00 | AAPL | Stock | 0.5055 | 0.5055 | 0.5038 | 0.5052 | 8905792.0 |
| 2004-04-20 09:35:00 | AAPL | Stock | 0.5052 | 0.5073 | 0.5052 | 0.5066 | 11329752.0 |
| 2004-04-20 09:40:00 | AAPL | Stock | 0.5063 | 0.5068 | 0.505 | 0.5052 | 4093488.0 |
| 2004-04-20 09:45:00 | AAPL | Stock | 0.5052 | 0.5059 | 0.505 | 0.5058 | 3035480.0 |
| 2004-04-20 09:50:00 | AAPL | Stock | 0.5059 | 0.5064 | 0.5057 | 0.5063 | 6477912.0 |
| 2004-04-20 09:55:00 | AAPL | Stock | 0.5061 | 0.5063 | 0.5052 | 0.5061 | 7406224.0 |
| 2004-04-20 10:00:00 | AAPL | Stock | 0.5061 | 0.5063 | 0.505 | 0.5061 | 5261256.0 |
| 2004-04-20 10:05:00 | AAPL | Stock | 0.5061 | 0.5063 | 0.5059 | 0.5061 | 2958760.0 |
| 2004-04-20 10:10:00 | AAPL | Stock | 0.5059 | 0.5061 | 0.505 | 0.5052 | 3428880.0 |
| 2004-04-20 10:15:00 | AAPL | Stock | 0.505 | 0.5059 | 0.5045 | 0.5046 | 4224640.0 |
| 2004-04-20 10:20:00 | AAPL | Stock | 0.5045 | 0.5046 | 0.5027 | 0.503 | 8323448.0 |
| 2004-04-20 10:25:00 | AAPL | Stock | 0.5029 | 0.5034 | 0.5029 | 0.5034 | 4697672.0 |
| 2004-04-20 10:30:00 | AAPL | Stock | 0.5034 | 0.5034 | 0.503 | 0.5031 | 1218392.0 |
| 2004-04-20 10:35:00 | AAPL | Stock | 0.503 | 0.5055 | 0.503 | 0.5041 | 4134648.0 |
| 2004-04-20 10:40:00 | AAPL | Stock | 0.5041 | 0.5045 | 0.5036 | 0.5038 | 7832496.0 |
| 2004-04-20 10:45:00 | AAPL | Stock | 0.5039 | 0.5045 | 0.5038 | 0.5045 | 2876552.0 |
| 2004-04-20 10:50:00 | AAPL | Stock | 0.5045 | 0.5045 | 0.5043 | 0.5043 | 1414392.0 |
| 2004-04-20 10:55:00 | AAPL | Stock | 0.5045 | 0.5045 | 0.5036 | 0.5036 | 5304320.0 |
| 2004-04-20 11:00:00 | AAPL | Stock | 0.5036 | 0.5045 | 0.503 | 0.5039 | 4626440.0 |
| 2004-04-20 11:05:00 | AAPL | Stock | 0.5039 | 0.5041 | 0.5036 | 0.5038 | 1289064.0 |
| 2004-04-20 11:10:00 | AAPL | Stock | 0.5038 | 0.5038 | 0.502 | 0.5021 | 11700304.0 |
| 2004-04-20 11:15:00 | AAPL | Stock | 0.502 | 0.5021 | 0.4995 | 0.5004 | 12581912.0 |
| 2004-04-20 11:20:00 | AAPL | Stock | 0.5002 | 0.5013 | 0.5 | 0.5009 | 10408496.0 |
| 2004-04-20 11:25:00 | AAPL | Stock | 0.5009 | 0.5013 | 0.4993 | 0.4996 | 5924688.0 |
| 2004-04-20 11:30:00 | AAPL | Stock | 0.4998 | 0.5002 | 0.4995 | 0.5 | 5156816.0 |
| 2004-04-20 11:35:00 | AAPL | Stock | 0.5 | 0.5005 | 0.4998 | 0.5004 | 2659048.0 |
| 2004-04-20 11:40:00 | AAPL | Stock | 0.5002 | 0.5023 | 0.5002 | 0.502 | 4265128.0 |
| 2004-04-20 11:45:00 | AAPL | Stock | 0.502 | 0.5021 | 0.5016 | 0.5018 | 2107224.0 |
| 2004-04-20 11:50:00 | AAPL | Stock | 0.5016 | 0.502 | 0.5004 | 0.5009 | 2340520.0 |
| 2004-04-20 11:55:00 | AAPL | Stock | 0.5011 | 0.502 | 0.5009 | 0.502 | 2103304.0 |
| 2004-04-20 12:00:00 | AAPL | Stock | 0.5021 | 0.5036 | 0.5021 | 0.5029 | 2814280.0 |
| 2004-04-20 12:05:00 | AAPL | Stock | 0.5029 | 0.5036 | 0.5011 | 0.5027 | 4503352.0 |
| 2004-04-20 12:10:00 | AAPL | Stock | 0.5027 | 0.5027 | 0.5016 | 0.502 | 1378328.0 |
| 2004-04-20 12:15:00 | AAPL | Stock | 0.5021 | 0.5036 | 0.502 | 0.5034 | 1729728.0 |
| 2004-04-20 12:20:00 | AAPL | Stock | 0.5034 | 0.5036 | 0.5032 | 0.5034 | 3069696.0 |
| 2004-04-20 12:25:00 | AAPL | Stock | 0.5034 | 0.5039 | 0.5034 | 0.5038 | 1947344.0 |
| 2004-04-20 12:30:00 | AAPL | Stock | 0.5039 | 0.5045 | 0.5032 | 0.5043 | 3813712.0 |
| 2004-04-20 12:35:00 | AAPL | Stock | 0.5045 | 0.5046 | 0.5045 | 0.5046 | 2629928.0 |
> showing 50 of 177,118 rows — these rows as CSV