PREVIEW / stock_5min / 2009-05-26
file: by_date/stock_5min/2009/2009-05-26.parquet size: 4.7 MB rows: 327,056 symbols: 3,353
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-26 04:15:00 | AAPL | Stock | 4.3843 | 4.3843 | 4.3843 | 4.3843 | 2800.0 |
| 2009-05-26 05:05:00 | AAPL | Stock | 4.3836 | 4.385 | 4.3836 | 4.385 | 25256.0 |
| 2009-05-26 05:10:00 | AAPL | Stock | 4.3907 | 4.4032 | 4.3907 | 4.4032 | 23100.0 |
| 2009-05-26 05:20:00 | AAPL | Stock | 4.4179 | 4.4464 | 4.4143 | 4.4464 | 75600.0 |
| 2009-05-26 05:25:00 | AAPL | Stock | 4.4321 | 4.4321 | 4.4286 | 4.4286 | 33600.0 |
| 2009-05-26 06:05:00 | AAPL | Stock | 4.4536 | 4.4536 | 4.4536 | 4.4536 | 7000.0 |
| 2009-05-26 06:20:00 | AAPL | Stock | 4.4557 | 4.4557 | 4.4557 | 4.4557 | 11200.0 |
| 2009-05-26 06:25:00 | AAPL | Stock | 4.4561 | 4.4561 | 4.4561 | 4.4561 | 2800.0 |
| 2009-05-26 06:30:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4643 | 4.4643 | 56000.0 |
| 2009-05-26 06:40:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4643 | 4.4643 | 39200.0 |
| 2009-05-26 06:45:00 | AAPL | Stock | 4.4557 | 4.4643 | 4.4554 | 4.4643 | 57400.0 |
| 2009-05-26 06:50:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4561 | 4.4561 | 145600.0 |
| 2009-05-26 06:55:00 | AAPL | Stock | 4.4561 | 4.4643 | 4.4561 | 4.4643 | 33600.0 |
| 2009-05-26 07:00:00 | AAPL | Stock | 4.4643 | 4.4821 | 4.4643 | 4.4821 | 50400.0 |
| 2009-05-26 07:05:00 | AAPL | Stock | 4.4821 | 4.4839 | 4.4821 | 4.4839 | 36400.0 |
| 2009-05-26 07:10:00 | AAPL | Stock | 4.4839 | 4.4839 | 4.4839 | 4.4839 | 14000.0 |
| 2009-05-26 07:15:00 | AAPL | Stock | 4.4789 | 4.4839 | 4.4786 | 4.4839 | 105000.0 |
| 2009-05-26 07:20:00 | AAPL | Stock | 4.4821 | 4.4839 | 4.4782 | 4.4782 | 41300.0 |
| 2009-05-26 07:25:00 | AAPL | Stock | 4.4818 | 4.4821 | 4.4782 | 4.4782 | 22400.0 |
| 2009-05-26 07:30:00 | AAPL | Stock | 4.475 | 4.4804 | 4.475 | 4.4804 | 23520.0 |
| 2009-05-26 07:35:00 | AAPL | Stock | 4.4779 | 4.4804 | 4.4732 | 4.4732 | 182784.0 |
| 2009-05-26 07:40:00 | AAPL | Stock | 4.4729 | 4.4729 | 4.4729 | 4.4729 | 14000.0 |
| 2009-05-26 07:45:00 | AAPL | Stock | 4.4729 | 4.4729 | 4.4664 | 4.4668 | 39200.0 |
| 2009-05-26 07:50:00 | AAPL | Stock | 4.4696 | 4.4732 | 4.4679 | 4.4729 | 310800.0 |
| 2009-05-26 07:55:00 | AAPL | Stock | 4.4729 | 4.4729 | 4.4714 | 4.4714 | 158900.0 |
| 2009-05-26 08:00:00 | AAPL | Stock | 4.4696 | 4.4732 | 4.4661 | 4.4693 | 616672.0 |
| 2009-05-26 08:05:00 | AAPL | Stock | 4.4686 | 4.4804 | 4.4686 | 4.4793 | 529872.0 |
| 2009-05-26 08:10:00 | AAPL | Stock | 4.4793 | 4.4886 | 4.4768 | 4.4886 | 619220.0 |
| 2009-05-26 08:15:00 | AAPL | Stock | 4.4875 | 4.4918 | 4.485 | 4.4904 | 385000.0 |
| 2009-05-26 08:20:00 | AAPL | Stock | 4.4911 | 4.4911 | 4.4725 | 4.48 | 248864.0 |
| 2009-05-26 08:25:00 | AAPL | Stock | 4.48 | 4.48 | 4.4736 | 4.4736 | 316400.0 |
| 2009-05-26 08:30:00 | AAPL | Stock | 4.4743 | 4.4743 | 4.4689 | 4.4714 | 257096.0 |
| 2009-05-26 08:35:00 | AAPL | Stock | 4.4714 | 4.4721 | 4.4643 | 4.4668 | 375928.0 |
| 2009-05-26 08:40:00 | AAPL | Stock | 4.4668 | 4.4682 | 4.4571 | 4.4675 | 367864.0 |
| 2009-05-26 08:45:00 | AAPL | Stock | 4.4686 | 4.4718 | 4.4682 | 4.4707 | 175252.0 |
| 2009-05-26 08:50:00 | AAPL | Stock | 4.4707 | 4.4707 | 4.4639 | 4.4654 | 293888.0 |
| 2009-05-26 08:55:00 | AAPL | Stock | 4.4664 | 4.4682 | 4.4632 | 4.465 | 132916.0 |
| 2009-05-26 09:00:00 | AAPL | Stock | 4.4654 | 4.4661 | 4.4589 | 4.4607 | 340452.0 |
| 2009-05-26 09:05:00 | AAPL | Stock | 4.4614 | 4.4636 | 4.4589 | 4.4593 | 170380.0 |
| 2009-05-26 09:10:00 | AAPL | Stock | 4.4604 | 4.4679 | 4.4593 | 4.4661 | 166488.0 |
| 2009-05-26 09:15:00 | AAPL | Stock | 4.4679 | 4.47 | 4.465 | 4.4679 | 84112.0 |
| 2009-05-26 09:20:00 | AAPL | Stock | 4.4679 | 4.4689 | 4.465 | 4.4686 | 120400.0 |
| 2009-05-26 09:25:00 | AAPL | Stock | 4.4671 | 4.4686 | 4.4511 | 4.4557 | 754544.0 |
| 2009-05-26 09:30:00 | AAPL | Stock | 4.4557 | 4.5143 | 4.4471 | 4.5096 | 28530040.0 |
| 2009-05-26 09:35:00 | AAPL | Stock | 4.5104 | 4.53 | 4.5089 | 4.5229 | 25605132.0 |
| 2009-05-26 09:40:00 | AAPL | Stock | 4.5222 | 4.555 | 4.5222 | 4.5404 | 21408912.0 |
| 2009-05-26 09:45:00 | AAPL | Stock | 4.5403 | 4.5514 | 4.5307 | 4.5343 | 14097440.0 |
| 2009-05-26 09:50:00 | AAPL | Stock | 4.535 | 4.5468 | 4.5304 | 4.5368 | 11741352.0 |
| 2009-05-26 09:55:00 | AAPL | Stock | 4.5357 | 4.5621 | 4.5357 | 4.5518 | 10801000.0 |
| 2009-05-26 10:00:00 | AAPL | Stock | 4.5518 | 4.5839 | 4.5505 | 4.5771 | 21146132.0 |
> showing 50 of 327,056 rows — these rows as CSV