PREVIEW / stock_1min / 2011-04-25
file: by_date/stock_1min/2011/2011-04-25.parquet size: 12.5 MB rows: 930,297 symbols: 2,888
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-25 07:07:00 | AAPL | Stock | 12.5893 | 12.5893 | 12.5893 | 12.5893 | 2800.0 |
| 2011-04-25 07:18:00 | AAPL | Stock | 12.5843 | 12.5843 | 12.5843 | 12.5843 | 2800.0 |
| 2011-04-25 07:20:00 | AAPL | Stock | 12.5718 | 12.5718 | 12.5718 | 12.5718 | 8400.0 |
| 2011-04-25 07:21:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.5714 | 12.5714 | 8400.0 |
| 2011-04-25 07:22:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.5714 | 12.5714 | 2800.0 |
| 2011-04-25 07:25:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.5714 | 12.5714 | 2800.0 |
| 2011-04-25 07:29:00 | AAPL | Stock | 12.5854 | 12.5854 | 12.5854 | 12.5854 | 2800.0 |
| 2011-04-25 07:45:00 | AAPL | Stock | 12.575 | 12.575 | 12.575 | 12.575 | 2800.0 |
| 2011-04-25 07:46:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.5714 | 12.5714 | 2800.0 |
| 2011-04-25 07:47:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.5714 | 12.5714 | 26460.0 |
| 2011-04-25 07:50:00 | AAPL | Stock | 12.5721 | 12.5721 | 12.5721 | 12.5721 | 11200.0 |
| 2011-04-25 07:52:00 | AAPL | Stock | 12.5625 | 12.5629 | 12.5625 | 12.5625 | 16800.0 |
| 2011-04-25 07:56:00 | AAPL | Stock | 12.5711 | 12.5714 | 12.5711 | 12.5714 | 28000.0 |
| 2011-04-25 07:57:00 | AAPL | Stock | 12.5711 | 12.5711 | 12.5611 | 12.5611 | 8400.0 |
| 2011-04-25 07:59:00 | AAPL | Stock | 12.5589 | 12.5589 | 12.5589 | 12.5589 | 11200.0 |
| 2011-04-25 08:00:00 | AAPL | Stock | 12.5639 | 12.5893 | 12.545 | 12.5564 | 50652.0 |
| 2011-04-25 08:01:00 | AAPL | Stock | 12.545 | 12.545 | 12.5357 | 12.5357 | 53200.0 |
| 2011-04-25 08:02:00 | AAPL | Stock | 12.5357 | 12.5375 | 12.5357 | 12.5357 | 51100.0 |
| 2011-04-25 08:03:00 | AAPL | Stock | 12.5357 | 12.5375 | 12.5357 | 12.5375 | 11200.0 |
| 2011-04-25 08:04:00 | AAPL | Stock | 12.5357 | 12.5421 | 12.5357 | 12.5375 | 39200.0 |
| 2011-04-25 08:05:00 | AAPL | Stock | 12.5357 | 12.5357 | 12.5357 | 12.5357 | 8400.0 |
| 2011-04-25 08:06:00 | AAPL | Stock | 12.5357 | 12.5357 | 12.5357 | 12.5357 | 5600.0 |
| 2011-04-25 08:07:00 | AAPL | Stock | 12.5286 | 12.5286 | 12.5268 | 12.5268 | 35840.0 |
| 2011-04-25 08:08:00 | AAPL | Stock | 12.5182 | 12.5221 | 12.5143 | 12.5179 | 11200.0 |
| 2011-04-25 08:09:00 | AAPL | Stock | 12.5204 | 12.5204 | 12.5143 | 12.52 | 142800.0 |
| 2011-04-25 08:10:00 | AAPL | Stock | 12.5204 | 12.5239 | 12.5204 | 12.5239 | 28000.0 |
| 2011-04-25 08:12:00 | AAPL | Stock | 12.5214 | 12.5214 | 12.5214 | 12.5214 | 2800.0 |
| 2011-04-25 08:13:00 | AAPL | Stock | 12.5268 | 12.5268 | 12.5268 | 12.5268 | 8400.0 |
| 2011-04-25 08:14:00 | AAPL | Stock | 12.5311 | 12.5311 | 12.5271 | 12.5271 | 28560.0 |
| 2011-04-25 08:15:00 | AAPL | Stock | 12.5307 | 12.5307 | 12.5304 | 12.5304 | 11200.0 |
| 2011-04-25 08:16:00 | AAPL | Stock | 12.5304 | 12.5304 | 12.5304 | 12.5304 | 22400.0 |
| 2011-04-25 08:17:00 | AAPL | Stock | 12.5321 | 12.5357 | 12.5321 | 12.5339 | 37800.0 |
| 2011-04-25 08:18:00 | AAPL | Stock | 12.5361 | 12.5425 | 12.5357 | 12.5425 | 43176.0 |
| 2011-04-25 08:19:00 | AAPL | Stock | 12.5425 | 12.5429 | 12.5425 | 12.5429 | 5600.0 |
| 2011-04-25 08:20:00 | AAPL | Stock | 12.5432 | 12.5432 | 12.5432 | 12.5432 | 2800.0 |
| 2011-04-25 08:21:00 | AAPL | Stock | 12.5446 | 12.5446 | 12.5446 | 12.5446 | 14000.0 |
| 2011-04-25 08:22:00 | AAPL | Stock | 12.5436 | 12.5436 | 12.5339 | 12.5339 | 45696.0 |
| 2011-04-25 08:23:00 | AAPL | Stock | 12.5321 | 12.5321 | 12.5321 | 12.5321 | 24360.0 |
| 2011-04-25 08:24:00 | AAPL | Stock | 12.5346 | 12.5346 | 12.5304 | 12.5304 | 45584.0 |
| 2011-04-25 08:28:00 | AAPL | Stock | 12.5357 | 12.5361 | 12.5293 | 12.5321 | 103320.0 |
| 2011-04-25 08:29:00 | AAPL | Stock | 12.5286 | 12.5286 | 12.5282 | 12.5282 | 30800.0 |
| 2011-04-25 08:30:00 | AAPL | Stock | 12.5282 | 12.5286 | 12.5282 | 12.5286 | 75600.0 |
| 2011-04-25 08:31:00 | AAPL | Stock | 12.5286 | 12.5286 | 12.5282 | 12.5282 | 91700.0 |
| 2011-04-25 08:32:00 | AAPL | Stock | 12.5282 | 12.5282 | 12.5282 | 12.5282 | 5600.0 |
| 2011-04-25 08:34:00 | AAPL | Stock | 12.5286 | 12.5289 | 12.5286 | 12.5289 | 23184.0 |
| 2011-04-25 08:35:00 | AAPL | Stock | 12.5282 | 12.5282 | 12.5282 | 12.5282 | 25200.0 |
| 2011-04-25 08:36:00 | AAPL | Stock | 12.5179 | 12.5179 | 12.5179 | 12.5179 | 10808.0 |
| 2011-04-25 08:38:00 | AAPL | Stock | 12.5179 | 12.5214 | 12.5179 | 12.5214 | 33992.0 |
| 2011-04-25 08:41:00 | AAPL | Stock | 12.5279 | 12.5279 | 12.5279 | 12.5279 | 2800.0 |
| 2011-04-25 08:42:00 | AAPL | Stock | 12.5286 | 12.5286 | 12.5286 | 12.5286 | 5180.0 |
> showing 50 of 930,297 rows — these rows as CSV