PREVIEW / stock_1min / 2010-01-08
file: by_date/stock_1min/2010/2010-01-08.parquet size: 12.2 MB rows: 916,434 symbols: 2,786
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-01-08 06:06:00 | AAPL | Stock | 7.5536 | 7.5536 | 7.5536 | 7.5536 | 2800.0 |
| 2010-01-08 06:39:00 | AAPL | Stock | 7.5529 | 7.5529 | 7.5429 | 7.5429 | 5600.0 |
| 2010-01-08 06:58:00 | AAPL | Stock | 7.5393 | 7.5393 | 7.5393 | 7.5393 | 2800.0 |
| 2010-01-08 07:14:00 | AAPL | Stock | 7.5536 | 7.5536 | 7.5536 | 7.5536 | 24500.0 |
| 2010-01-08 07:32:00 | AAPL | Stock | 7.5536 | 7.5536 | 7.5536 | 7.5536 | 2800.0 |
| 2010-01-08 07:35:00 | AAPL | Stock | 7.5543 | 7.5543 | 7.5543 | 7.5543 | 2800.0 |
| 2010-01-08 07:38:00 | AAPL | Stock | 7.5529 | 7.5529 | 7.5529 | 7.5529 | 14000.0 |
| 2010-01-08 07:40:00 | AAPL | Stock | 7.5436 | 7.5436 | 7.5436 | 7.5436 | 2800.0 |
| 2010-01-08 07:41:00 | AAPL | Stock | 7.5436 | 7.5436 | 7.5429 | 7.5429 | 19264.0 |
| 2010-01-08 07:46:00 | AAPL | Stock | 7.5429 | 7.5429 | 7.5429 | 7.5429 | 2800.0 |
| 2010-01-08 07:48:00 | AAPL | Stock | 7.5421 | 7.5429 | 7.5421 | 7.5429 | 14000.0 |
| 2010-01-08 07:51:00 | AAPL | Stock | 7.5411 | 7.5411 | 7.5411 | 7.5411 | 5600.0 |
| 2010-01-08 07:58:00 | AAPL | Stock | 7.5393 | 7.5393 | 7.5393 | 7.5393 | 5600.0 |
| 2010-01-08 07:59:00 | AAPL | Stock | 7.5357 | 7.5357 | 7.5357 | 7.5357 | 5936.0 |
| 2010-01-08 08:00:00 | AAPL | Stock | 7.5421 | 7.5421 | 7.535 | 7.535 | 19600.0 |
| 2010-01-08 08:01:00 | AAPL | Stock | 7.5346 | 7.5361 | 7.5346 | 7.5357 | 53312.0 |
| 2010-01-08 08:02:00 | AAPL | Stock | 7.5339 | 7.5339 | 7.5339 | 7.5339 | 2800.0 |
| 2010-01-08 08:03:00 | AAPL | Stock | 7.5336 | 7.5336 | 7.5336 | 7.5336 | 5600.0 |
| 2010-01-08 08:04:00 | AAPL | Stock | 7.535 | 7.535 | 7.535 | 7.535 | 2800.0 |
| 2010-01-08 08:08:00 | AAPL | Stock | 7.5357 | 7.5375 | 7.5357 | 7.5375 | 9660.0 |
| 2010-01-08 08:09:00 | AAPL | Stock | 7.5389 | 7.5425 | 7.5389 | 7.5425 | 21840.0 |
| 2010-01-08 08:10:00 | AAPL | Stock | 7.5382 | 7.5411 | 7.5375 | 7.5389 | 73500.0 |
| 2010-01-08 08:11:00 | AAPL | Stock | 7.5361 | 7.5361 | 7.5361 | 7.5361 | 2800.0 |
| 2010-01-08 08:12:00 | AAPL | Stock | 7.5364 | 7.5364 | 7.5336 | 7.5336 | 26404.0 |
| 2010-01-08 08:13:00 | AAPL | Stock | 7.5336 | 7.5336 | 7.5336 | 7.5336 | 35196.0 |
| 2010-01-08 08:14:00 | AAPL | Stock | 7.5318 | 7.5339 | 7.5318 | 7.5339 | 16800.0 |
| 2010-01-08 08:15:00 | AAPL | Stock | 7.5341 | 7.5341 | 7.5286 | 7.5289 | 53200.0 |
| 2010-01-08 08:16:00 | AAPL | Stock | 7.5289 | 7.5289 | 7.5289 | 7.5289 | 54880.0 |
| 2010-01-08 08:17:00 | AAPL | Stock | 7.5318 | 7.5318 | 7.5268 | 7.5275 | 18788.0 |
| 2010-01-08 08:18:00 | AAPL | Stock | 7.5218 | 7.525 | 7.5168 | 7.525 | 57400.0 |
| 2010-01-08 08:19:00 | AAPL | Stock | 7.5246 | 7.5246 | 7.5118 | 7.5118 | 30800.0 |
| 2010-01-08 08:20:00 | AAPL | Stock | 7.5179 | 7.5179 | 7.5143 | 7.5143 | 69832.0 |
| 2010-01-08 08:21:00 | AAPL | Stock | 7.5132 | 7.5139 | 7.5071 | 7.5071 | 82880.0 |
| 2010-01-08 08:22:00 | AAPL | Stock | 7.5107 | 7.5107 | 7.5057 | 7.5057 | 37380.0 |
| 2010-01-08 08:23:00 | AAPL | Stock | 7.51 | 7.5179 | 7.5057 | 7.5179 | 119056.0 |
| 2010-01-08 08:24:00 | AAPL | Stock | 7.5125 | 7.5179 | 7.5118 | 7.5179 | 12600.0 |
| 2010-01-08 08:25:00 | AAPL | Stock | 7.5214 | 7.5214 | 7.5179 | 7.5182 | 22400.0 |
| 2010-01-08 08:26:00 | AAPL | Stock | 7.5146 | 7.5232 | 7.5146 | 7.5232 | 17780.0 |
| 2010-01-08 08:27:00 | AAPL | Stock | 7.5246 | 7.5261 | 7.5246 | 7.5261 | 59360.0 |
| 2010-01-08 08:28:00 | AAPL | Stock | 7.5286 | 7.5311 | 7.5286 | 7.5286 | 56000.0 |
| 2010-01-08 08:29:00 | AAPL | Stock | 7.5354 | 7.5357 | 7.5321 | 7.5357 | 37716.0 |
| 2010-01-08 08:30:00 | AAPL | Stock | 7.5357 | 7.5357 | 7.4893 | 7.5107 | 626948.0 |
| 2010-01-08 08:31:00 | AAPL | Stock | 7.5125 | 7.5286 | 7.5021 | 7.5141 | 453348.0 |
| 2010-01-08 08:32:00 | AAPL | Stock | 7.5079 | 7.5139 | 7.4875 | 7.4893 | 271572.0 |
| 2010-01-08 08:33:00 | AAPL | Stock | 7.4904 | 7.5071 | 7.4904 | 7.5071 | 106540.0 |
| 2010-01-08 08:34:00 | AAPL | Stock | 7.5075 | 7.5107 | 7.5025 | 7.5107 | 26628.0 |
| 2010-01-08 08:35:00 | AAPL | Stock | 7.5018 | 7.5089 | 7.4996 | 7.5 | 115360.0 |
| 2010-01-08 08:36:00 | AAPL | Stock | 7.4996 | 7.5 | 7.4968 | 7.5 | 44800.0 |
| 2010-01-08 08:37:00 | AAPL | Stock | 7.5 | 7.5004 | 7.4932 | 7.4932 | 35924.0 |
| 2010-01-08 08:38:00 | AAPL | Stock | 7.4932 | 7.4932 | 7.4821 | 7.4836 | 195748.0 |
> showing 50 of 916,434 rows — these rows as CSV