PREVIEW / stock_5min / 2009-09-28
file: by_date/stock_5min/2009/2009-09-28.parquet size: 4.6 MB rows: 323,276 symbols: 3,381
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-09-28 05:25:00 | AAPL | Stock | 6.5371 | 6.5371 | 6.5371 | 6.5371 | 14000.0 |
| 2009-09-28 06:45:00 | AAPL | Stock | 6.5539 | 6.5539 | 6.5539 | 6.5539 | 5600.0 |
| 2009-09-28 07:40:00 | AAPL | Stock | 6.5536 | 6.5536 | 6.5536 | 6.5536 | 2800.0 |
| 2009-09-28 07:45:00 | AAPL | Stock | 6.5536 | 6.5536 | 6.5482 | 6.5536 | 27440.0 |
| 2009-09-28 07:50:00 | AAPL | Stock | 6.5536 | 6.5621 | 6.5536 | 6.5621 | 16800.0 |
| 2009-09-28 07:55:00 | AAPL | Stock | 6.5679 | 6.5679 | 6.5579 | 6.5579 | 15820.0 |
| 2009-09-28 08:00:00 | AAPL | Stock | 6.5571 | 6.5571 | 6.5518 | 6.5536 | 113820.0 |
| 2009-09-28 08:05:00 | AAPL | Stock | 6.5532 | 6.5546 | 6.5396 | 6.5539 | 89656.0 |
| 2009-09-28 08:10:00 | AAPL | Stock | 6.5554 | 6.5682 | 6.5536 | 6.5679 | 338940.0 |
| 2009-09-28 08:15:00 | AAPL | Stock | 6.565 | 6.5696 | 6.5557 | 6.5671 | 104972.0 |
| 2009-09-28 08:20:00 | AAPL | Stock | 6.5671 | 6.5711 | 6.5661 | 6.5711 | 89264.0 |
| 2009-09-28 08:25:00 | AAPL | Stock | 6.5679 | 6.5686 | 6.5679 | 6.5682 | 111860.0 |
| 2009-09-28 08:30:00 | AAPL | Stock | 6.5707 | 6.5843 | 6.5707 | 6.575 | 131292.0 |
| 2009-09-28 08:35:00 | AAPL | Stock | 6.5786 | 6.595 | 6.5775 | 6.595 | 166488.0 |
| 2009-09-28 08:40:00 | AAPL | Stock | 6.5921 | 6.6071 | 6.59 | 6.5914 | 486948.0 |
| 2009-09-28 08:45:00 | AAPL | Stock | 6.5964 | 6.6011 | 6.5939 | 6.5946 | 60956.0 |
| 2009-09-28 08:50:00 | AAPL | Stock | 6.5907 | 6.6014 | 6.5825 | 6.5893 | 226156.0 |
| 2009-09-28 08:55:00 | AAPL | Stock | 6.5879 | 6.5879 | 6.5764 | 6.5857 | 122192.0 |
| 2009-09-28 09:00:00 | AAPL | Stock | 6.5914 | 6.5914 | 6.5818 | 6.5839 | 96012.0 |
| 2009-09-28 09:05:00 | AAPL | Stock | 6.5839 | 6.5857 | 6.5821 | 6.5839 | 28308.0 |
| 2009-09-28 09:10:00 | AAPL | Stock | 6.5821 | 6.5839 | 6.5721 | 6.5743 | 495180.0 |
| 2009-09-28 09:15:00 | AAPL | Stock | 6.5811 | 6.5857 | 6.5793 | 6.5814 | 238000.0 |
| 2009-09-28 09:20:00 | AAPL | Stock | 6.5779 | 6.5786 | 6.5704 | 6.5714 | 334516.0 |
| 2009-09-28 09:25:00 | AAPL | Stock | 6.5671 | 6.5714 | 6.5607 | 6.5657 | 406000.0 |
| 2009-09-28 09:30:00 | AAPL | Stock | 6.5661 | 6.5896 | 6.55 | 6.5761 | 20845496.0 |
| 2009-09-28 09:35:00 | AAPL | Stock | 6.5754 | 6.5786 | 6.5475 | 6.5704 | 10479056.0 |
| 2009-09-28 09:40:00 | AAPL | Stock | 6.5714 | 6.6058 | 6.5704 | 6.5964 | 11704840.0 |
| 2009-09-28 09:45:00 | AAPL | Stock | 6.5964 | 6.6061 | 6.5886 | 6.5925 | 11213412.0 |
| 2009-09-28 09:50:00 | AAPL | Stock | 6.5925 | 6.6 | 6.5839 | 6.5946 | 6271440.0 |
| 2009-09-28 09:55:00 | AAPL | Stock | 6.5939 | 6.596 | 6.5854 | 6.5871 | 4723404.0 |
| 2009-09-28 10:00:00 | AAPL | Stock | 6.5871 | 6.6018 | 6.5861 | 6.5979 | 9967692.0 |
| 2009-09-28 10:05:00 | AAPL | Stock | 6.5976 | 6.6139 | 6.595 | 6.6092 | 10955196.0 |
| 2009-09-28 10:10:00 | AAPL | Stock | 6.6101 | 6.6107 | 6.5936 | 6.5936 | 6035400.0 |
| 2009-09-28 10:15:00 | AAPL | Stock | 6.5946 | 6.6043 | 6.5936 | 6.5984 | 4657044.0 |
| 2009-09-28 10:20:00 | AAPL | Stock | 6.5975 | 6.6018 | 6.5921 | 6.5961 | 3639104.0 |
| 2009-09-28 10:25:00 | AAPL | Stock | 6.5964 | 6.6 | 6.5857 | 6.5964 | 5473720.0 |
| 2009-09-28 10:30:00 | AAPL | Stock | 6.5964 | 6.6054 | 6.5954 | 6.6 | 5905004.0 |
| 2009-09-28 10:35:00 | AAPL | Stock | 6.6 | 6.6061 | 6.5939 | 6.5939 | 2485812.0 |
| 2009-09-28 10:40:00 | AAPL | Stock | 6.5939 | 6.5954 | 6.5904 | 6.5932 | 3025680.0 |
| 2009-09-28 10:45:00 | AAPL | Stock | 6.5943 | 6.605 | 6.5925 | 6.6014 | 2412284.0 |
| 2009-09-28 10:50:00 | AAPL | Stock | 6.6018 | 6.6104 | 6.5986 | 6.6029 | 3947104.0 |
| 2009-09-28 10:55:00 | AAPL | Stock | 6.6018 | 6.6196 | 6.5996 | 6.6154 | 5636736.0 |
| 2009-09-28 11:00:00 | AAPL | Stock | 6.6159 | 6.6204 | 6.6136 | 6.6171 | 3701292.0 |
| 2009-09-28 11:05:00 | AAPL | Stock | 6.6161 | 6.6282 | 6.6146 | 6.6268 | 5063016.0 |
| 2009-09-28 11:10:00 | AAPL | Stock | 6.6261 | 6.6279 | 6.6211 | 6.6221 | 3293276.0 |
| 2009-09-28 11:15:00 | AAPL | Stock | 6.6214 | 6.625 | 6.6186 | 6.6211 | 2245684.0 |
| 2009-09-28 11:20:00 | AAPL | Stock | 6.6211 | 6.6321 | 6.6211 | 6.6282 | 4111016.0 |
| 2009-09-28 11:25:00 | AAPL | Stock | 6.6286 | 6.6361 | 6.625 | 6.6329 | 2949212.0 |
| 2009-09-28 11:30:00 | AAPL | Stock | 6.6329 | 6.6411 | 6.6329 | 6.6393 | 3995712.0 |
| 2009-09-28 11:35:00 | AAPL | Stock | 6.6407 | 6.6464 | 6.6371 | 6.6425 | 5421780.0 |
> showing 50 of 323,276 rows — these rows as CSV