PREVIEW / stock_5min / 2010-12-17
file: by_date/stock_5min/2010/2010-12-17.parquet size: 5.2 MB rows: 351,777 symbols: 3,536
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-12-17 06:15:00 | AAPL | Stock | 11.4736 | 11.4736 | 11.4736 | 11.4736 | 2800.0 |
| 2010-12-17 06:45:00 | AAPL | Stock | 11.4736 | 11.4736 | 11.4736 | 11.4736 | 2800.0 |
| 2010-12-17 07:00:00 | AAPL | Stock | 11.4725 | 11.4725 | 11.4725 | 11.4725 | 2800.0 |
| 2010-12-17 07:10:00 | AAPL | Stock | 11.4768 | 11.4786 | 11.4768 | 11.4786 | 19600.0 |
| 2010-12-17 07:15:00 | AAPL | Stock | 11.4732 | 11.4732 | 11.4732 | 11.4732 | 8400.0 |
| 2010-12-17 07:25:00 | AAPL | Stock | 11.4679 | 11.4679 | 11.4679 | 11.4679 | 4648.0 |
| 2010-12-17 07:45:00 | AAPL | Stock | 11.4775 | 11.4775 | 11.4775 | 11.4775 | 2800.0 |
| 2010-12-17 07:50:00 | AAPL | Stock | 11.4786 | 11.5 | 11.4786 | 11.5 | 39200.0 |
| 2010-12-17 07:55:00 | AAPL | Stock | 11.5071 | 11.5071 | 11.4893 | 11.4893 | 42000.0 |
| 2010-12-17 08:00:00 | AAPL | Stock | 11.4821 | 11.4982 | 11.4804 | 11.4896 | 312228.0 |
| 2010-12-17 08:05:00 | AAPL | Stock | 11.4911 | 11.4925 | 11.4875 | 11.4875 | 58800.0 |
| 2010-12-17 08:10:00 | AAPL | Stock | 11.4857 | 11.4982 | 11.4846 | 11.4982 | 156380.0 |
| 2010-12-17 08:15:00 | AAPL | Stock | 11.4979 | 11.4982 | 11.4936 | 11.4964 | 53200.0 |
| 2010-12-17 08:20:00 | AAPL | Stock | 11.4964 | 11.51 | 11.4964 | 11.5054 | 306376.0 |
| 2010-12-17 08:25:00 | AAPL | Stock | 11.5054 | 11.5054 | 11.4989 | 11.4989 | 321440.0 |
| 2010-12-17 08:30:00 | AAPL | Stock | 11.4946 | 11.4989 | 11.4911 | 11.4932 | 163576.0 |
| 2010-12-17 08:35:00 | AAPL | Stock | 11.4946 | 11.4968 | 11.4893 | 11.4968 | 137060.0 |
| 2010-12-17 08:40:00 | AAPL | Stock | 11.4964 | 11.4968 | 11.4914 | 11.4968 | 8400.0 |
| 2010-12-17 08:45:00 | AAPL | Stock | 11.4989 | 11.4989 | 11.4989 | 11.4989 | 2800.0 |
| 2010-12-17 08:50:00 | AAPL | Stock | 11.4996 | 11.5036 | 11.4939 | 11.5004 | 112168.0 |
| 2010-12-17 08:55:00 | AAPL | Stock | 11.4982 | 11.4982 | 11.4929 | 11.4929 | 19880.0 |
| 2010-12-17 09:00:00 | AAPL | Stock | 11.5007 | 11.5007 | 11.4946 | 11.4946 | 8400.0 |
| 2010-12-17 09:05:00 | AAPL | Stock | 11.4989 | 11.4989 | 11.4946 | 11.4986 | 36400.0 |
| 2010-12-17 09:10:00 | AAPL | Stock | 11.4989 | 11.5 | 11.4975 | 11.4975 | 44772.0 |
| 2010-12-17 09:15:00 | AAPL | Stock | 11.4982 | 11.4989 | 11.4982 | 11.4989 | 17640.0 |
| 2010-12-17 09:20:00 | AAPL | Stock | 11.4982 | 11.4989 | 11.4943 | 11.4943 | 22400.0 |
| 2010-12-17 09:25:00 | AAPL | Stock | 11.4929 | 11.5018 | 11.47 | 11.47 | 480956.0 |
| 2010-12-17 09:30:00 | AAPL | Stock | 11.475 | 11.4925 | 11.4571 | 11.4829 | 8321348.0 |
| 2010-12-17 09:35:00 | AAPL | Stock | 11.4817 | 11.4842 | 11.4679 | 11.4739 | 5633712.0 |
| 2010-12-17 09:40:00 | AAPL | Stock | 11.4743 | 11.4755 | 11.4589 | 11.4725 | 5642924.0 |
| 2010-12-17 09:45:00 | AAPL | Stock | 11.4711 | 11.4804 | 11.4654 | 11.4791 | 5840660.0 |
| 2010-12-17 09:50:00 | AAPL | Stock | 11.4757 | 11.4814 | 11.4671 | 11.4682 | 5188596.0 |
| 2010-12-17 09:55:00 | AAPL | Stock | 11.4693 | 11.4732 | 11.4629 | 11.4707 | 4152260.0 |
| 2010-12-17 10:00:00 | AAPL | Stock | 11.4707 | 11.4721 | 11.4607 | 11.4625 | 3493588.0 |
| 2010-12-17 10:05:00 | AAPL | Stock | 11.465 | 11.4704 | 11.4479 | 11.4479 | 5930568.0 |
| 2010-12-17 10:10:00 | AAPL | Stock | 11.4475 | 11.4636 | 11.4407 | 11.4632 | 4785284.0 |
| 2010-12-17 10:15:00 | AAPL | Stock | 11.4636 | 11.4714 | 11.4571 | 11.4686 | 3257912.0 |
| 2010-12-17 10:20:00 | AAPL | Stock | 11.47 | 11.474 | 11.4654 | 11.4654 | 3205804.0 |
| 2010-12-17 10:25:00 | AAPL | Stock | 11.4654 | 11.4736 | 11.4632 | 11.4721 | 2987152.0 |
| 2010-12-17 10:30:00 | AAPL | Stock | 11.4707 | 11.4729 | 11.4679 | 11.4714 | 988456.0 |
| 2010-12-17 10:35:00 | AAPL | Stock | 11.4707 | 11.4721 | 11.4618 | 11.4696 | 2144464.0 |
| 2010-12-17 10:40:00 | AAPL | Stock | 11.4696 | 11.4696 | 11.4554 | 11.4584 | 2611812.0 |
| 2010-12-17 10:45:00 | AAPL | Stock | 11.4579 | 11.4632 | 11.4539 | 11.4611 | 3359608.0 |
| 2010-12-17 10:50:00 | AAPL | Stock | 11.4611 | 11.4625 | 11.4568 | 11.461 | 1142932.0 |
| 2010-12-17 10:55:00 | AAPL | Stock | 11.4589 | 11.4668 | 11.4579 | 11.4639 | 1794520.0 |
| 2010-12-17 11:00:00 | AAPL | Stock | 11.4646 | 11.4686 | 11.4614 | 11.4686 | 1243424.0 |
| 2010-12-17 11:05:00 | AAPL | Stock | 11.4686 | 11.4721 | 11.4646 | 11.465 | 2830632.0 |
| 2010-12-17 11:10:00 | AAPL | Stock | 11.4654 | 11.4714 | 11.4636 | 11.4689 | 1593340.0 |
| 2010-12-17 11:15:00 | AAPL | Stock | 11.4693 | 11.4707 | 11.4646 | 11.4679 | 2000460.0 |
| 2010-12-17 11:20:00 | AAPL | Stock | 11.4668 | 11.4729 | 11.4646 | 11.47 | 1714580.0 |
> showing 50 of 351,777 rows — these rows as CSV