PREVIEW / stock_1min / 2010-04-06
file: by_date/stock_1min/2010/2010-04-06.parquet size: 12.8 MB rows: 967,930 symbols: 2,818
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-06 04:17:00 | AAPL | Stock | 8.5089 | 8.5089 | 8.5089 | 8.5089 | 8400.0 |
| 2010-04-06 04:28:00 | AAPL | Stock | 8.5346 | 8.5346 | 8.5346 | 8.5346 | 11200.0 |
| 2010-04-06 04:44:00 | AAPL | Stock | 8.5375 | 8.5393 | 8.5375 | 8.5393 | 6440.0 |
| 2010-04-06 05:08:00 | AAPL | Stock | 8.5393 | 8.5393 | 8.5393 | 8.5393 | 3920.0 |
| 2010-04-06 05:33:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5307 | 8.5307 | 14000.0 |
| 2010-04-06 05:41:00 | AAPL | Stock | 8.525 | 8.525 | 8.525 | 8.525 | 2800.0 |
| 2010-04-06 05:47:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5357 | 8.5357 | 8400.0 |
| 2010-04-06 05:58:00 | AAPL | Stock | 8.5393 | 8.5393 | 8.5393 | 8.5393 | 2800.0 |
| 2010-04-06 06:09:00 | AAPL | Stock | 8.5361 | 8.5361 | 8.5361 | 8.5361 | 2800.0 |
| 2010-04-06 06:14:00 | AAPL | Stock | 8.5393 | 8.5393 | 8.5393 | 8.5393 | 2800.0 |
| 2010-04-06 06:16:00 | AAPL | Stock | 8.5382 | 8.5386 | 8.5382 | 8.5386 | 5600.0 |
| 2010-04-06 06:17:00 | AAPL | Stock | 8.5382 | 8.5382 | 8.5382 | 8.5382 | 2800.0 |
| 2010-04-06 06:58:00 | AAPL | Stock | 8.5386 | 8.5386 | 8.5386 | 8.5386 | 5040.0 |
| 2010-04-06 07:01:00 | AAPL | Stock | 8.5293 | 8.5293 | 8.5293 | 8.5293 | 2800.0 |
| 2010-04-06 07:03:00 | AAPL | Stock | 8.5354 | 8.5357 | 8.5354 | 8.5357 | 11200.0 |
| 2010-04-06 07:04:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5321 | 8.5357 | 16800.0 |
| 2010-04-06 07:05:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5357 | 8.5357 | 11200.0 |
| 2010-04-06 07:06:00 | AAPL | Stock | 8.5321 | 8.5321 | 8.5321 | 8.5321 | 43400.0 |
| 2010-04-06 07:09:00 | AAPL | Stock | 8.5321 | 8.5321 | 8.5321 | 8.5321 | 8400.0 |
| 2010-04-06 07:10:00 | AAPL | Stock | 8.5354 | 8.5354 | 8.5354 | 8.5354 | 11200.0 |
| 2010-04-06 07:12:00 | AAPL | Stock | 8.5354 | 8.5361 | 8.5354 | 8.5354 | 25340.0 |
| 2010-04-06 07:17:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5357 | 8.5357 | 4452.0 |
| 2010-04-06 07:21:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5357 | 8.5357 | 11200.0 |
| 2010-04-06 07:24:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5314 | 8.5314 | 33040.0 |
| 2010-04-06 07:25:00 | AAPL | Stock | 8.5314 | 8.5314 | 8.5289 | 8.5289 | 39200.0 |
| 2010-04-06 07:26:00 | AAPL | Stock | 8.5289 | 8.5289 | 8.5286 | 8.5286 | 14000.0 |
| 2010-04-06 07:28:00 | AAPL | Stock | 8.5293 | 8.5293 | 8.5271 | 8.5271 | 22400.0 |
| 2010-04-06 07:29:00 | AAPL | Stock | 8.5257 | 8.5257 | 8.5239 | 8.525 | 39200.0 |
| 2010-04-06 07:30:00 | AAPL | Stock | 8.5239 | 8.5239 | 8.5239 | 8.5239 | 2800.0 |
| 2010-04-06 07:31:00 | AAPL | Stock | 8.5232 | 8.5232 | 8.5232 | 8.5232 | 8400.0 |
| 2010-04-06 07:32:00 | AAPL | Stock | 8.5236 | 8.5236 | 8.5236 | 8.5236 | 5600.0 |
| 2010-04-06 07:33:00 | AAPL | Stock | 8.5214 | 8.5214 | 8.5214 | 8.5214 | 12628.0 |
| 2010-04-06 07:34:00 | AAPL | Stock | 8.52 | 8.52 | 8.5196 | 8.5196 | 11200.0 |
| 2010-04-06 07:35:00 | AAPL | Stock | 8.5214 | 8.5214 | 8.5214 | 8.5214 | 8400.0 |
| 2010-04-06 07:38:00 | AAPL | Stock | 8.5196 | 8.5246 | 8.5196 | 8.5246 | 13608.0 |
| 2010-04-06 07:39:00 | AAPL | Stock | 8.5261 | 8.5264 | 8.5246 | 8.5264 | 22400.0 |
| 2010-04-06 07:41:00 | AAPL | Stock | 8.5336 | 8.5339 | 8.5336 | 8.5339 | 25200.0 |
| 2010-04-06 07:45:00 | AAPL | Stock | 8.5336 | 8.5339 | 8.5336 | 8.5339 | 18200.0 |
| 2010-04-06 07:47:00 | AAPL | Stock | 8.5304 | 8.5304 | 8.5268 | 8.5268 | 9800.0 |
| 2010-04-06 07:52:00 | AAPL | Stock | 8.5321 | 8.5321 | 8.5321 | 8.5321 | 2800.0 |
| 2010-04-06 07:53:00 | AAPL | Stock | 8.5336 | 8.5339 | 8.5336 | 8.5339 | 16800.0 |
| 2010-04-06 07:54:00 | AAPL | Stock | 8.5354 | 8.5354 | 8.5354 | 8.5354 | 2800.0 |
| 2010-04-06 07:59:00 | AAPL | Stock | 8.5304 | 8.5304 | 8.5304 | 8.5304 | 2800.0 |
| 2010-04-06 08:00:00 | AAPL | Stock | 8.5304 | 8.5304 | 8.5132 | 8.5164 | 158060.0 |
| 2010-04-06 08:01:00 | AAPL | Stock | 8.5179 | 8.5179 | 8.5146 | 8.5146 | 25200.0 |
| 2010-04-06 08:02:00 | AAPL | Stock | 8.5136 | 8.5182 | 8.5089 | 8.5161 | 292040.0 |
| 2010-04-06 08:03:00 | AAPL | Stock | 8.5186 | 8.5232 | 8.5129 | 8.5132 | 82936.0 |
| 2010-04-06 08:04:00 | AAPL | Stock | 8.5136 | 8.5136 | 8.5132 | 8.5132 | 9044.0 |
| 2010-04-06 08:05:00 | AAPL | Stock | 8.5132 | 8.5143 | 8.5107 | 8.5107 | 107324.0 |
| 2010-04-06 08:06:00 | AAPL | Stock | 8.5107 | 8.5107 | 8.5064 | 8.5071 | 99092.0 |
> showing 50 of 967,930 rows — these rows as CSV