PREVIEW / stock_5min / 2011-08-15
file: by_date/stock_5min/2011/2011-08-15.parquet size: 4.9 MB rows: 334,151 symbols: 3,547
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-08-15 04:00:00 | AAPL | Stock | 13.5714 | 13.5714 | 13.5714 | 13.5714 | 8400.0 |
| 2011-08-15 04:10:00 | AAPL | Stock | 13.5893 | 13.5893 | 13.5893 | 13.5893 | 8400.0 |
| 2011-08-15 04:15:00 | AAPL | Stock | 13.6011 | 13.6011 | 13.6011 | 13.6011 | 2800.0 |
| 2011-08-15 04:20:00 | AAPL | Stock | 13.5986 | 13.6007 | 13.5393 | 13.5393 | 25200.0 |
| 2011-08-15 04:25:00 | AAPL | Stock | 13.625 | 13.63 | 13.625 | 13.63 | 16800.0 |
| 2011-08-15 04:35:00 | AAPL | Stock | 13.6111 | 13.6125 | 13.6111 | 13.6125 | 5600.0 |
| 2011-08-15 05:30:00 | AAPL | Stock | 13.6321 | 13.6321 | 13.6321 | 13.6321 | 2800.0 |
| 2011-08-15 05:40:00 | AAPL | Stock | 13.6321 | 13.6321 | 13.625 | 13.625 | 7000.0 |
| 2011-08-15 05:45:00 | AAPL | Stock | 13.6189 | 13.6189 | 13.6189 | 13.6189 | 5600.0 |
| 2011-08-15 05:50:00 | AAPL | Stock | 13.6089 | 13.6089 | 13.6071 | 13.6071 | 5600.0 |
| 2011-08-15 05:55:00 | AAPL | Stock | 13.6075 | 13.6075 | 13.6075 | 13.6075 | 2800.0 |
| 2011-08-15 06:05:00 | AAPL | Stock | 13.575 | 13.575 | 13.575 | 13.575 | 5600.0 |
| 2011-08-15 06:10:00 | AAPL | Stock | 13.5511 | 13.5511 | 13.5464 | 13.5464 | 26600.0 |
| 2011-08-15 06:15:00 | AAPL | Stock | 13.5429 | 13.5429 | 13.5429 | 13.5429 | 14000.0 |
| 2011-08-15 06:20:00 | AAPL | Stock | 13.5539 | 13.5539 | 13.5539 | 13.5539 | 5600.0 |
| 2011-08-15 06:25:00 | AAPL | Stock | 13.5539 | 13.5539 | 13.5539 | 13.5539 | 8400.0 |
| 2011-08-15 06:30:00 | AAPL | Stock | 13.5539 | 13.5539 | 13.5539 | 13.5539 | 33600.0 |
| 2011-08-15 06:50:00 | AAPL | Stock | 13.5375 | 13.5393 | 13.5375 | 13.5393 | 11060.0 |
| 2011-08-15 06:55:00 | AAPL | Stock | 13.5511 | 13.5511 | 13.5511 | 13.5511 | 11200.0 |
| 2011-08-15 07:00:00 | AAPL | Stock | 13.5511 | 13.5539 | 13.5418 | 13.5539 | 66640.0 |
| 2011-08-15 07:05:00 | AAPL | Stock | 13.5536 | 13.5721 | 13.5536 | 13.5721 | 49420.0 |
| 2011-08-15 07:10:00 | AAPL | Stock | 13.5657 | 13.5693 | 13.5536 | 13.5664 | 33600.0 |
| 2011-08-15 07:15:00 | AAPL | Stock | 13.5689 | 13.5714 | 13.5643 | 13.5661 | 36400.0 |
| 2011-08-15 07:20:00 | AAPL | Stock | 13.5643 | 13.5675 | 13.5586 | 13.5675 | 33600.0 |
| 2011-08-15 07:25:00 | AAPL | Stock | 13.5625 | 13.5721 | 13.5625 | 13.5721 | 67060.0 |
| 2011-08-15 07:30:00 | AAPL | Stock | 13.5693 | 13.5725 | 13.4732 | 13.4732 | 434616.0 |
| 2011-08-15 07:35:00 | AAPL | Stock | 13.4804 | 13.4907 | 13.4054 | 13.4225 | 317072.0 |
| 2011-08-15 07:40:00 | AAPL | Stock | 13.42 | 13.4964 | 13.3929 | 13.4964 | 196308.0 |
| 2011-08-15 07:45:00 | AAPL | Stock | 13.4546 | 13.4646 | 13.4311 | 13.4396 | 102396.0 |
| 2011-08-15 07:50:00 | AAPL | Stock | 13.4571 | 13.4821 | 13.45 | 13.4643 | 180320.0 |
| 2011-08-15 07:55:00 | AAPL | Stock | 13.4643 | 13.4821 | 13.4639 | 13.4639 | 155400.0 |
| 2011-08-15 08:00:00 | AAPL | Stock | 13.4639 | 13.4804 | 13.4393 | 13.4636 | 927332.0 |
| 2011-08-15 08:05:00 | AAPL | Stock | 13.4607 | 13.4636 | 13.45 | 13.4564 | 246680.0 |
| 2011-08-15 08:10:00 | AAPL | Stock | 13.4557 | 13.4643 | 13.4554 | 13.4643 | 246568.0 |
| 2011-08-15 08:15:00 | AAPL | Stock | 13.4636 | 13.4657 | 13.4571 | 13.4589 | 205072.0 |
| 2011-08-15 08:20:00 | AAPL | Stock | 13.4589 | 13.4621 | 13.4571 | 13.4618 | 17304.0 |
| 2011-08-15 08:25:00 | AAPL | Stock | 13.4621 | 13.4643 | 13.4614 | 13.4643 | 47460.0 |
| 2011-08-15 08:30:00 | AAPL | Stock | 13.4607 | 13.4607 | 13.4375 | 13.4504 | 158032.0 |
| 2011-08-15 08:35:00 | AAPL | Stock | 13.4504 | 13.4543 | 13.4475 | 13.4475 | 22400.0 |
| 2011-08-15 08:40:00 | AAPL | Stock | 13.4479 | 13.4479 | 13.4375 | 13.44 | 70840.0 |
| 2011-08-15 08:45:00 | AAPL | Stock | 13.4429 | 13.4475 | 13.4282 | 13.4282 | 391552.0 |
| 2011-08-15 08:50:00 | AAPL | Stock | 13.4289 | 13.4375 | 13.4161 | 13.425 | 323988.0 |
| 2011-08-15 08:55:00 | AAPL | Stock | 13.4286 | 13.4393 | 13.425 | 13.4393 | 94584.0 |
| 2011-08-15 09:00:00 | AAPL | Stock | 13.4429 | 13.4464 | 13.4393 | 13.4464 | 75628.0 |
| 2011-08-15 09:05:00 | AAPL | Stock | 13.4532 | 13.4889 | 13.4532 | 13.4889 | 480872.0 |
| 2011-08-15 09:10:00 | AAPL | Stock | 13.4911 | 13.5079 | 13.4825 | 13.5079 | 380492.0 |
| 2011-08-15 09:15:00 | AAPL | Stock | 13.5043 | 13.5214 | 13.5007 | 13.5036 | 487760.0 |
| 2011-08-15 09:20:00 | AAPL | Stock | 13.5036 | 13.5157 | 13.5025 | 13.5046 | 85456.0 |
| 2011-08-15 09:25:00 | AAPL | Stock | 13.5036 | 13.5714 | 13.5 | 13.5582 | 859208.0 |
| 2011-08-15 09:30:00 | AAPL | Stock | 13.5586 | 13.5804 | 13.5032 | 13.5503 | 21642432.0 |
> showing 50 of 334,151 rows — these rows as CSV