PREVIEW / stock_5min / 2009-10-02
file: by_date/stock_5min/2009/2009-10-02.parquet size: 4.7 MB rows: 325,917 symbols: 3,385
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-10-02 04:15:00 | AAPL | Stock | 6.535 | 6.535 | 6.535 | 6.535 | 2800.0 |
| 2009-10-02 05:25:00 | AAPL | Stock | 6.5107 | 6.5107 | 6.5107 | 6.5107 | 28000.0 |
| 2009-10-02 05:45:00 | AAPL | Stock | 6.5146 | 6.5146 | 6.5125 | 6.5125 | 139720.0 |
| 2009-10-02 06:05:00 | AAPL | Stock | 6.5114 | 6.5114 | 6.5114 | 6.5114 | 42000.0 |
| 2009-10-02 06:10:00 | AAPL | Stock | 6.5136 | 6.5136 | 6.5136 | 6.5136 | 8400.0 |
| 2009-10-02 06:15:00 | AAPL | Stock | 6.5268 | 6.5268 | 6.5179 | 6.5179 | 50400.0 |
| 2009-10-02 06:20:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 28000.0 |
| 2009-10-02 06:40:00 | AAPL | Stock | 6.5229 | 6.5232 | 6.5179 | 6.5179 | 16800.0 |
| 2009-10-02 07:00:00 | AAPL | Stock | 6.5304 | 6.5304 | 6.5214 | 6.5214 | 28000.0 |
| 2009-10-02 07:05:00 | AAPL | Stock | 6.5214 | 6.5325 | 6.5211 | 6.5325 | 37800.0 |
| 2009-10-02 07:10:00 | AAPL | Stock | 6.5214 | 6.5214 | 6.5214 | 6.5214 | 8400.0 |
| 2009-10-02 07:15:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5089 | 6.5143 | 109620.0 |
| 2009-10-02 07:25:00 | AAPL | Stock | 6.5125 | 6.5179 | 6.5125 | 6.5179 | 11200.0 |
| 2009-10-02 07:30:00 | AAPL | Stock | 6.5104 | 6.5104 | 6.5 | 6.5089 | 203924.0 |
| 2009-10-02 07:35:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 9828.0 |
| 2009-10-02 07:40:00 | AAPL | Stock | 6.5125 | 6.5211 | 6.5125 | 6.5179 | 83972.0 |
| 2009-10-02 07:45:00 | AAPL | Stock | 6.5196 | 6.525 | 6.5182 | 6.5182 | 45780.0 |
| 2009-10-02 07:50:00 | AAPL | Stock | 6.5264 | 6.5264 | 6.5143 | 6.525 | 280560.0 |
| 2009-10-02 07:55:00 | AAPL | Stock | 6.5246 | 6.5321 | 6.5196 | 6.5268 | 283360.0 |
| 2009-10-02 08:00:00 | AAPL | Stock | 6.5232 | 6.5261 | 6.5111 | 6.5171 | 680036.0 |
| 2009-10-02 08:05:00 | AAPL | Stock | 6.5143 | 6.5171 | 6.5039 | 6.5089 | 524692.0 |
| 2009-10-02 08:10:00 | AAPL | Stock | 6.5057 | 6.5104 | 6.5036 | 6.5075 | 473704.0 |
| 2009-10-02 08:15:00 | AAPL | Stock | 6.5118 | 6.5118 | 6.5018 | 6.5089 | 446152.0 |
| 2009-10-02 08:20:00 | AAPL | Stock | 6.5096 | 6.5196 | 6.5089 | 6.5196 | 836864.0 |
| 2009-10-02 08:25:00 | AAPL | Stock | 6.5179 | 6.5232 | 6.5104 | 6.5168 | 1137696.0 |
| 2009-10-02 08:30:00 | AAPL | Stock | 6.5168 | 6.5168 | 6.4786 | 6.4975 | 2699704.0 |
| 2009-10-02 08:35:00 | AAPL | Stock | 6.4993 | 6.5039 | 6.4779 | 6.4821 | 1692460.0 |
| 2009-10-02 08:40:00 | AAPL | Stock | 6.4796 | 6.48 | 6.4643 | 6.4643 | 1627752.0 |
| 2009-10-02 08:45:00 | AAPL | Stock | 6.4621 | 6.4807 | 6.4421 | 6.47 | 1757056.0 |
| 2009-10-02 08:50:00 | AAPL | Stock | 6.4746 | 6.4825 | 6.46 | 6.4604 | 822332.0 |
| 2009-10-02 08:55:00 | AAPL | Stock | 6.4575 | 6.4575 | 6.4429 | 6.4479 | 945084.0 |
| 2009-10-02 09:00:00 | AAPL | Stock | 6.4429 | 6.4507 | 6.4429 | 6.4507 | 373212.0 |
| 2009-10-02 09:05:00 | AAPL | Stock | 6.4507 | 6.4886 | 6.4446 | 6.4754 | 1705172.0 |
| 2009-10-02 09:10:00 | AAPL | Stock | 6.4786 | 6.4925 | 6.4764 | 6.4921 | 815248.0 |
| 2009-10-02 09:15:00 | AAPL | Stock | 6.4925 | 6.495 | 6.4864 | 6.4907 | 659008.0 |
| 2009-10-02 09:20:00 | AAPL | Stock | 6.4907 | 6.4946 | 6.4875 | 6.4946 | 532280.0 |
| 2009-10-02 09:25:00 | AAPL | Stock | 6.4961 | 6.4964 | 6.4754 | 6.4821 | 1003016.0 |
| 2009-10-02 09:30:00 | AAPL | Stock | 6.4786 | 6.5171 | 6.4768 | 6.5143 | 26778444.0 |
| 2009-10-02 09:35:00 | AAPL | Stock | 6.5143 | 6.5618 | 6.5143 | 6.5468 | 24898804.0 |
| 2009-10-02 09:40:00 | AAPL | Stock | 6.5471 | 6.55 | 6.5189 | 6.5311 | 16797172.0 |
| 2009-10-02 09:45:00 | AAPL | Stock | 6.5318 | 6.5625 | 6.5286 | 6.5493 | 16780092.0 |
| 2009-10-02 09:50:00 | AAPL | Stock | 6.5493 | 6.5607 | 6.5382 | 6.5479 | 13257272.0 |
| 2009-10-02 09:55:00 | AAPL | Stock | 6.5479 | 6.5554 | 6.5366 | 6.5402 | 8140328.0 |
| 2009-10-02 10:00:00 | AAPL | Stock | 6.5404 | 6.5679 | 6.5321 | 6.5614 | 18463648.0 |
| 2009-10-02 10:05:00 | AAPL | Stock | 6.5625 | 6.575 | 6.5539 | 6.565 | 13837740.0 |
| 2009-10-02 10:10:00 | AAPL | Stock | 6.5654 | 6.5861 | 6.5604 | 6.5793 | 11336136.0 |
| 2009-10-02 10:15:00 | AAPL | Stock | 6.5804 | 6.5929 | 6.5764 | 6.5764 | 13048896.0 |
| 2009-10-02 10:20:00 | AAPL | Stock | 6.5764 | 6.6071 | 6.5757 | 6.6036 | 11975208.0 |
| 2009-10-02 10:25:00 | AAPL | Stock | 6.6039 | 6.6125 | 6.6007 | 6.6025 | 11257568.0 |
| 2009-10-02 10:30:00 | AAPL | Stock | 6.6025 | 6.6093 | 6.5907 | 6.6079 | 9598680.0 |
> showing 50 of 325,917 rows — these rows as CSV