PREVIEW / stock_1min / 2012-07-13
file: by_date/stock_1min/2012/2012-07-13.parquet size: 12.2 MB rows: 910,931 symbols: 2,826
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 |
|---|---|---|---|---|---|---|---|
| 2012-07-13 06:32:00 | AAPL | Stock | 21.4536 | 21.4536 | 21.4536 | 21.4536 | 8400.0 |
| 2012-07-13 06:46:00 | AAPL | Stock | 21.4643 | 21.4643 | 21.4643 | 21.4643 | 5600.0 |
| 2012-07-13 06:58:00 | AAPL | Stock | 21.4843 | 21.4889 | 21.4821 | 21.4821 | 18200.0 |
| 2012-07-13 07:00:00 | AAPL | Stock | 21.4821 | 21.4821 | 21.4821 | 21.4821 | 2800.0 |
| 2012-07-13 07:03:00 | AAPL | Stock | 21.4732 | 21.4732 | 21.4732 | 21.4732 | 2800.0 |
| 2012-07-13 07:04:00 | AAPL | Stock | 21.475 | 21.475 | 21.475 | 21.475 | 4480.0 |
| 2012-07-13 07:05:00 | AAPL | Stock | 21.4554 | 21.4554 | 21.4554 | 21.4554 | 2800.0 |
| 2012-07-13 07:08:00 | AAPL | Stock | 21.4571 | 21.4571 | 21.4571 | 21.4571 | 2800.0 |
| 2012-07-13 07:09:00 | AAPL | Stock | 21.4364 | 21.4364 | 21.4329 | 21.4329 | 11200.0 |
| 2012-07-13 07:18:00 | AAPL | Stock | 21.4396 | 21.4396 | 21.4396 | 21.4396 | 2800.0 |
| 2012-07-13 07:19:00 | AAPL | Stock | 21.4514 | 21.4529 | 21.4514 | 21.4529 | 8400.0 |
| 2012-07-13 07:22:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 5600.0 |
| 2012-07-13 07:25:00 | AAPL | Stock | 21.4439 | 21.4439 | 21.4286 | 21.4286 | 30800.0 |
| 2012-07-13 07:27:00 | AAPL | Stock | 21.4321 | 21.4321 | 21.4321 | 21.4321 | 5600.0 |
| 2012-07-13 07:33:00 | AAPL | Stock | 21.4536 | 21.4639 | 21.4536 | 21.4639 | 7840.0 |
| 2012-07-13 07:35:00 | AAPL | Stock | 21.45 | 21.45 | 21.45 | 21.45 | 2800.0 |
| 2012-07-13 07:41:00 | AAPL | Stock | 21.4461 | 21.4461 | 21.4461 | 21.4461 | 2800.0 |
| 2012-07-13 07:42:00 | AAPL | Stock | 21.4596 | 21.4596 | 21.4554 | 21.4554 | 5600.0 |
| 2012-07-13 07:45:00 | AAPL | Stock | 21.4596 | 21.4607 | 21.4593 | 21.4593 | 33040.0 |
| 2012-07-13 07:47:00 | AAPL | Stock | 21.4589 | 21.4589 | 21.4486 | 21.4486 | 8316.0 |
| 2012-07-13 07:48:00 | AAPL | Stock | 21.4486 | 21.4486 | 21.4486 | 21.4486 | 2800.0 |
| 2012-07-13 07:49:00 | AAPL | Stock | 21.4579 | 21.4643 | 21.4486 | 21.4486 | 74228.0 |
| 2012-07-13 07:51:00 | AAPL | Stock | 21.4571 | 21.4571 | 21.4571 | 21.4571 | 7000.0 |
| 2012-07-13 07:52:00 | AAPL | Stock | 21.4571 | 21.4571 | 21.4482 | 21.4482 | 19600.0 |
| 2012-07-13 07:56:00 | AAPL | Stock | 21.4504 | 21.4504 | 21.4504 | 21.4504 | 2800.0 |
| 2012-07-13 07:58:00 | AAPL | Stock | 21.4496 | 21.4496 | 21.4496 | 21.4496 | 2800.0 |
| 2012-07-13 07:59:00 | AAPL | Stock | 21.4496 | 21.4504 | 21.4496 | 21.4504 | 25200.0 |
| 2012-07-13 08:00:00 | AAPL | Stock | 21.4464 | 21.4571 | 21.4464 | 21.4471 | 80220.0 |
| 2012-07-13 08:01:00 | AAPL | Stock | 21.4468 | 21.4564 | 21.4464 | 21.4564 | 22400.0 |
| 2012-07-13 08:02:00 | AAPL | Stock | 21.45 | 21.45 | 21.45 | 21.45 | 2800.0 |
| 2012-07-13 08:03:00 | AAPL | Stock | 21.4536 | 21.4554 | 21.4536 | 21.4554 | 28420.0 |
| 2012-07-13 08:04:00 | AAPL | Stock | 21.4518 | 21.4571 | 21.4514 | 21.4557 | 27468.0 |
| 2012-07-13 08:05:00 | AAPL | Stock | 21.4571 | 21.4571 | 21.4507 | 21.4511 | 45948.0 |
| 2012-07-13 08:07:00 | AAPL | Stock | 21.4286 | 21.4571 | 21.4286 | 21.4571 | 50400.0 |
| 2012-07-13 08:08:00 | AAPL | Stock | 21.4518 | 21.4657 | 21.4518 | 21.4657 | 49532.0 |
| 2012-07-13 08:09:00 | AAPL | Stock | 21.4768 | 21.4768 | 21.4768 | 21.4768 | 2800.0 |
| 2012-07-13 08:10:00 | AAPL | Stock | 21.4732 | 21.4757 | 21.4732 | 21.4757 | 30828.0 |
| 2012-07-13 08:11:00 | AAPL | Stock | 21.4757 | 21.4821 | 21.4743 | 21.4821 | 39200.0 |
| 2012-07-13 08:12:00 | AAPL | Stock | 21.4854 | 21.4882 | 21.4854 | 21.4882 | 8288.0 |
| 2012-07-13 08:13:00 | AAPL | Stock | 21.4868 | 21.4868 | 21.4821 | 21.4821 | 16800.0 |
| 2012-07-13 08:14:00 | AAPL | Stock | 21.4821 | 21.4821 | 21.4821 | 21.4821 | 5600.0 |
| 2012-07-13 08:15:00 | AAPL | Stock | 21.4875 | 21.4911 | 21.4875 | 21.4911 | 21000.0 |
| 2012-07-13 08:16:00 | AAPL | Stock | 21.4911 | 21.4957 | 21.4911 | 21.4957 | 22400.0 |
| 2012-07-13 08:17:00 | AAPL | Stock | 21.4957 | 21.4957 | 21.4879 | 21.4879 | 11648.0 |
| 2012-07-13 08:18:00 | AAPL | Stock | 21.4811 | 21.4818 | 21.4786 | 21.4804 | 61992.0 |
| 2012-07-13 08:19:00 | AAPL | Stock | 21.4796 | 21.4804 | 21.4796 | 21.48 | 15400.0 |
| 2012-07-13 08:20:00 | AAPL | Stock | 21.48 | 21.4804 | 21.48 | 21.4804 | 14000.0 |
| 2012-07-13 08:21:00 | AAPL | Stock | 21.48 | 21.4804 | 21.48 | 21.4804 | 14700.0 |
| 2012-07-13 08:22:00 | AAPL | Stock | 21.48 | 21.4821 | 21.48 | 21.4804 | 15120.0 |
| 2012-07-13 08:23:00 | AAPL | Stock | 21.4893 | 21.4893 | 21.4829 | 21.4829 | 11200.0 |
> showing 50 of 910,931 rows — these rows as CSV