PREVIEW / stock_1min / 2010-07-28
file: by_date/stock_1min/2010/2010-07-28.parquet size: 12.1 MB rows: 927,542 symbols: 2,802
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-07-28 05:39:00 | AAPL | Stock | 9.4489 | 9.4489 | 9.4489 | 9.4489 | 2800.0 |
| 2010-07-28 07:02:00 | AAPL | Stock | 9.4071 | 9.4071 | 9.4071 | 9.4071 | 2800.0 |
| 2010-07-28 07:03:00 | AAPL | Stock | 9.3993 | 9.3993 | 9.3993 | 9.3993 | 8400.0 |
| 2010-07-28 07:04:00 | AAPL | Stock | 9.3993 | 9.3993 | 9.3993 | 9.3993 | 5600.0 |
| 2010-07-28 07:22:00 | AAPL | Stock | 9.4211 | 9.425 | 9.4211 | 9.425 | 21000.0 |
| 2010-07-28 07:38:00 | AAPL | Stock | 9.4246 | 9.4425 | 9.4246 | 9.4425 | 53004.0 |
| 2010-07-28 07:42:00 | AAPL | Stock | 9.4346 | 9.4425 | 9.4346 | 9.4425 | 22400.0 |
| 2010-07-28 07:45:00 | AAPL | Stock | 9.4393 | 9.4393 | 9.4371 | 9.4371 | 30800.0 |
| 2010-07-28 07:46:00 | AAPL | Stock | 9.4396 | 9.4396 | 9.4379 | 9.4379 | 25200.0 |
| 2010-07-28 07:47:00 | AAPL | Stock | 9.4404 | 9.4404 | 9.4368 | 9.4368 | 11200.0 |
| 2010-07-28 07:48:00 | AAPL | Stock | 9.4379 | 9.4379 | 9.4379 | 9.4379 | 2800.0 |
| 2010-07-28 07:49:00 | AAPL | Stock | 9.4425 | 9.4425 | 9.4425 | 9.4425 | 2800.0 |
| 2010-07-28 07:50:00 | AAPL | Stock | 9.4425 | 9.4464 | 9.4425 | 9.4464 | 18984.0 |
| 2010-07-28 07:51:00 | AAPL | Stock | 9.4404 | 9.4404 | 9.4404 | 9.4404 | 28000.0 |
| 2010-07-28 07:56:00 | AAPL | Stock | 9.4461 | 9.4461 | 9.4461 | 9.4461 | 2800.0 |
| 2010-07-28 07:57:00 | AAPL | Stock | 9.4411 | 9.4411 | 9.4411 | 9.4411 | 12600.0 |
| 2010-07-28 07:58:00 | AAPL | Stock | 9.4461 | 9.4461 | 9.4461 | 9.4461 | 5600.0 |
| 2010-07-28 08:00:00 | AAPL | Stock | 9.4457 | 9.4486 | 9.4411 | 9.4486 | 45584.0 |
| 2010-07-28 08:01:00 | AAPL | Stock | 9.4464 | 9.4536 | 9.4411 | 9.4421 | 250656.0 |
| 2010-07-28 08:02:00 | AAPL | Stock | 9.4464 | 9.4464 | 9.4446 | 9.4446 | 22400.0 |
| 2010-07-28 08:03:00 | AAPL | Stock | 9.4461 | 9.4461 | 9.4329 | 9.4357 | 147000.0 |
| 2010-07-28 08:04:00 | AAPL | Stock | 9.4382 | 9.4382 | 9.4321 | 9.4375 | 378840.0 |
| 2010-07-28 08:05:00 | AAPL | Stock | 9.4318 | 9.4471 | 9.4311 | 9.4379 | 194012.0 |
| 2010-07-28 08:06:00 | AAPL | Stock | 9.4357 | 9.4379 | 9.4332 | 9.4332 | 25200.0 |
| 2010-07-28 08:07:00 | AAPL | Stock | 9.4357 | 9.4389 | 9.4304 | 9.4389 | 53480.0 |
| 2010-07-28 08:08:00 | AAPL | Stock | 9.4389 | 9.4411 | 9.4389 | 9.4393 | 95704.0 |
| 2010-07-28 08:09:00 | AAPL | Stock | 9.4393 | 9.4443 | 9.4393 | 9.4443 | 22400.0 |
| 2010-07-28 08:10:00 | AAPL | Stock | 9.4429 | 9.4443 | 9.4414 | 9.4414 | 33600.0 |
| 2010-07-28 08:11:00 | AAPL | Stock | 9.4421 | 9.4421 | 9.4421 | 9.4421 | 2800.0 |
| 2010-07-28 08:13:00 | AAPL | Stock | 9.4429 | 9.4443 | 9.4429 | 9.4443 | 16100.0 |
| 2010-07-28 08:14:00 | AAPL | Stock | 9.4457 | 9.4471 | 9.4446 | 9.4446 | 22400.0 |
| 2010-07-28 08:15:00 | AAPL | Stock | 9.4443 | 9.4454 | 9.4443 | 9.4454 | 14000.0 |
| 2010-07-28 08:16:00 | AAPL | Stock | 9.4443 | 9.4443 | 9.4393 | 9.4425 | 35364.0 |
| 2010-07-28 08:17:00 | AAPL | Stock | 9.4411 | 9.4425 | 9.4393 | 9.4425 | 25620.0 |
| 2010-07-28 08:19:00 | AAPL | Stock | 9.4389 | 9.4389 | 9.4371 | 9.4389 | 36400.0 |
| 2010-07-28 08:20:00 | AAPL | Stock | 9.4389 | 9.4389 | 9.4325 | 9.4329 | 87808.0 |
| 2010-07-28 08:21:00 | AAPL | Stock | 9.4357 | 9.4357 | 9.4357 | 9.4357 | 8400.0 |
| 2010-07-28 08:22:00 | AAPL | Stock | 9.4371 | 9.4371 | 9.4307 | 9.4307 | 47600.0 |
| 2010-07-28 08:23:00 | AAPL | Stock | 9.4325 | 9.435 | 9.4307 | 9.4332 | 19600.0 |
| 2010-07-28 08:24:00 | AAPL | Stock | 9.4357 | 9.4411 | 9.4357 | 9.4411 | 70000.0 |
| 2010-07-28 08:25:00 | AAPL | Stock | 9.4411 | 9.4411 | 9.4379 | 9.4411 | 81984.0 |
| 2010-07-28 08:26:00 | AAPL | Stock | 9.4379 | 9.4379 | 9.4296 | 9.4296 | 31780.0 |
| 2010-07-28 08:27:00 | AAPL | Stock | 9.4354 | 9.4354 | 9.4354 | 9.4354 | 2800.0 |
| 2010-07-28 08:28:00 | AAPL | Stock | 9.4357 | 9.4375 | 9.4354 | 9.4354 | 86800.0 |
| 2010-07-28 08:29:00 | AAPL | Stock | 9.4357 | 9.4386 | 9.4339 | 9.4386 | 22400.0 |
| 2010-07-28 08:30:00 | AAPL | Stock | 9.4321 | 9.4321 | 9.4143 | 9.4143 | 343392.0 |
| 2010-07-28 08:31:00 | AAPL | Stock | 9.4175 | 9.4186 | 9.4071 | 9.4071 | 275772.0 |
| 2010-07-28 08:32:00 | AAPL | Stock | 9.4071 | 9.4107 | 9.4039 | 9.4075 | 198800.0 |
| 2010-07-28 08:33:00 | AAPL | Stock | 9.4079 | 9.4093 | 9.405 | 9.4089 | 95200.0 |
| 2010-07-28 08:34:00 | AAPL | Stock | 9.4079 | 9.415 | 9.4071 | 9.415 | 71512.0 |
> showing 50 of 927,542 rows — these rows as CSV