PREVIEW / stock_1min / 2004-04-16
file: by_date/stock_1min/2004/2004-04-16.parquet size: 5.6 MB rows: 469,505 symbols: 1,444
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-16 08:00:00 | AAPL | Stock | 0.5231 | 0.5231 | 0.5231 | 0.5231 | 123200.0 |
| 2004-04-16 08:21:00 | AAPL | Stock | 0.5188 | 0.5188 | 0.5188 | 0.5188 | 5600.0 |
| 2004-04-16 08:23:00 | AAPL | Stock | 0.518 | 0.518 | 0.518 | 0.518 | 5600.0 |
| 2004-04-16 08:27:00 | AAPL | Stock | 0.518 | 0.518 | 0.518 | 0.518 | 56000.0 |
| 2004-04-16 08:29:00 | AAPL | Stock | 0.5179 | 0.5179 | 0.5179 | 0.5179 | 22400.0 |
| 2004-04-16 08:30:00 | AAPL | Stock | 0.518 | 0.518 | 0.518 | 0.518 | 22400.0 |
| 2004-04-16 08:32:00 | AAPL | Stock | 0.518 | 0.518 | 0.518 | 0.518 | 27160.0 |
| 2004-04-16 08:33:00 | AAPL | Stock | 0.518 | 0.518 | 0.518 | 0.518 | 78400.0 |
| 2004-04-16 08:34:00 | AAPL | Stock | 0.518 | 0.518 | 0.518 | 0.518 | 56000.0 |
| 2004-04-16 08:36:00 | AAPL | Stock | 0.518 | 0.518 | 0.518 | 0.518 | 16800.0 |
| 2004-04-16 08:37:00 | AAPL | Stock | 0.5205 | 0.5205 | 0.518 | 0.518 | 61040.0 |
| 2004-04-16 08:43:00 | AAPL | Stock | 0.5193 | 0.5193 | 0.5188 | 0.5188 | 56000.0 |
| 2004-04-16 08:45:00 | AAPL | Stock | 0.5188 | 0.5196 | 0.5188 | 0.5196 | 11200.0 |
| 2004-04-16 08:46:00 | AAPL | Stock | 0.5188 | 0.5188 | 0.5188 | 0.5188 | 5600.0 |
| 2004-04-16 08:51:00 | AAPL | Stock | 0.518 | 0.518 | 0.518 | 0.518 | 28000.0 |
| 2004-04-16 08:54:00 | AAPL | Stock | 0.5188 | 0.5188 | 0.5188 | 0.5188 | 5600.0 |
| 2004-04-16 08:55:00 | AAPL | Stock | 0.5196 | 0.5196 | 0.5196 | 0.5196 | 5600.0 |
| 2004-04-16 08:56:00 | AAPL | Stock | 0.5196 | 0.5196 | 0.5196 | 0.5196 | 11200.0 |
| 2004-04-16 09:07:00 | AAPL | Stock | 0.5198 | 0.5198 | 0.5196 | 0.5196 | 16800.0 |
| 2004-04-16 09:10:00 | AAPL | Stock | 0.5198 | 0.5198 | 0.5198 | 0.5198 | 107240.0 |
| 2004-04-16 09:12:00 | AAPL | Stock | 0.5198 | 0.5198 | 0.5198 | 0.5198 | 56000.0 |
| 2004-04-16 09:13:00 | AAPL | Stock | 0.5198 | 0.5198 | 0.5198 | 0.5198 | 112000.0 |
| 2004-04-16 09:14:00 | AAPL | Stock | 0.5198 | 0.5202 | 0.5198 | 0.5202 | 33600.0 |
| 2004-04-16 09:15:00 | AAPL | Stock | 0.52 | 0.52 | 0.52 | 0.52 | 5600.0 |
| 2004-04-16 09:19:00 | AAPL | Stock | 0.5193 | 0.5195 | 0.5193 | 0.5195 | 84000.0 |
| 2004-04-16 09:20:00 | AAPL | Stock | 0.5202 | 0.5204 | 0.5202 | 0.5204 | 47936.0 |
| 2004-04-16 09:22:00 | AAPL | Stock | 0.5193 | 0.5193 | 0.5193 | 0.5193 | 22400.0 |
| 2004-04-16 09:23:00 | AAPL | Stock | 0.5202 | 0.5202 | 0.5202 | 0.5202 | 11760.0 |
| 2004-04-16 09:24:00 | AAPL | Stock | 0.5196 | 0.5196 | 0.5196 | 0.5196 | 33600.0 |
| 2004-04-16 09:25:00 | AAPL | Stock | 0.5189 | 0.5189 | 0.5189 | 0.5189 | 33600.0 |
| 2004-04-16 09:26:00 | AAPL | Stock | 0.5182 | 0.5182 | 0.5182 | 0.5182 | 16800.0 |
| 2004-04-16 09:27:00 | AAPL | Stock | 0.5188 | 0.5188 | 0.5188 | 0.5188 | 72800.0 |
| 2004-04-16 09:29:00 | AAPL | Stock | 0.518 | 0.5188 | 0.518 | 0.5186 | 530880.0 |
| 2004-04-16 09:30:00 | AAPL | Stock | 0.5179 | 0.5205 | 0.5152 | 0.5163 | 6178536.0 |
| 2004-04-16 09:31:00 | AAPL | Stock | 0.5163 | 0.5189 | 0.5161 | 0.5186 | 2361744.0 |
| 2004-04-16 09:32:00 | AAPL | Stock | 0.5186 | 0.5196 | 0.5179 | 0.5193 | 1672216.0 |
| 2004-04-16 09:33:00 | AAPL | Stock | 0.5193 | 0.5216 | 0.5179 | 0.5179 | 2631608.0 |
| 2004-04-16 09:34:00 | AAPL | Stock | 0.52 | 0.5214 | 0.5198 | 0.5207 | 1396416.0 |
| 2004-04-16 09:35:00 | AAPL | Stock | 0.5204 | 0.5225 | 0.5204 | 0.5223 | 2232216.0 |
| 2004-04-16 09:36:00 | AAPL | Stock | 0.5223 | 0.5229 | 0.5207 | 0.5207 | 758744.0 |
| 2004-04-16 09:37:00 | AAPL | Stock | 0.5212 | 0.5212 | 0.5184 | 0.5188 | 808640.0 |
| 2004-04-16 09:38:00 | AAPL | Stock | 0.5188 | 0.52 | 0.5188 | 0.5195 | 550032.0 |
| 2004-04-16 09:39:00 | AAPL | Stock | 0.5191 | 0.5196 | 0.5188 | 0.5195 | 595224.0 |
| 2004-04-16 09:40:00 | AAPL | Stock | 0.5198 | 0.5198 | 0.5188 | 0.5188 | 1119496.0 |
| 2004-04-16 09:41:00 | AAPL | Stock | 0.5189 | 0.5204 | 0.5188 | 0.52 | 1247064.0 |
| 2004-04-16 09:42:00 | AAPL | Stock | 0.5198 | 0.52 | 0.5193 | 0.5196 | 814968.0 |
| 2004-04-16 09:43:00 | AAPL | Stock | 0.5195 | 0.5195 | 0.5188 | 0.5193 | 1276800.0 |
| 2004-04-16 09:44:00 | AAPL | Stock | 0.5193 | 0.5193 | 0.5191 | 0.5193 | 481600.0 |
| 2004-04-16 09:45:00 | AAPL | Stock | 0.5191 | 0.5191 | 0.5188 | 0.5188 | 2005360.0 |
| 2004-04-16 09:46:00 | AAPL | Stock | 0.5188 | 0.5193 | 0.5188 | 0.5188 | 1002400.0 |
> showing 50 of 469,505 rows — these rows as CSV