PREVIEW / stock_5min / 2009-12-31
file: by_date/stock_5min/2009/2009-12-31.parquet size: 4.5 MB rows: 310,969 symbols: 3,467
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-12-31 08:00:00 | AAPL | Stock | 7.5714 | 7.5857 | 7.5714 | 7.585 | 204680.0 |
| 2009-12-31 08:05:00 | AAPL | Stock | 7.585 | 7.5957 | 7.5821 | 7.5929 | 226940.0 |
| 2009-12-31 08:10:00 | AAPL | Stock | 7.5929 | 7.5986 | 7.5914 | 7.5986 | 264292.0 |
| 2009-12-31 08:15:00 | AAPL | Stock | 7.5989 | 7.6032 | 7.5964 | 7.6004 | 341600.0 |
| 2009-12-31 08:20:00 | AAPL | Stock | 7.6004 | 7.6054 | 7.5964 | 7.6036 | 475636.0 |
| 2009-12-31 08:25:00 | AAPL | Stock | 7.6036 | 7.6039 | 7.5964 | 7.6014 | 349860.0 |
| 2009-12-31 08:30:00 | AAPL | Stock | 7.6011 | 7.6111 | 7.6011 | 7.6054 | 765072.0 |
| 2009-12-31 08:35:00 | AAPL | Stock | 7.6025 | 7.6064 | 7.6 | 7.6061 | 241696.0 |
| 2009-12-31 08:40:00 | AAPL | Stock | 7.6054 | 7.6068 | 7.6018 | 7.6036 | 195160.0 |
| 2009-12-31 08:45:00 | AAPL | Stock | 7.6036 | 7.6036 | 7.5946 | 7.6 | 305760.0 |
| 2009-12-31 08:50:00 | AAPL | Stock | 7.6021 | 7.6021 | 7.5975 | 7.6 | 64568.0 |
| 2009-12-31 08:55:00 | AAPL | Stock | 7.6 | 7.6043 | 7.5989 | 7.6043 | 99400.0 |
| 2009-12-31 09:00:00 | AAPL | Stock | 7.6039 | 7.6143 | 7.6036 | 7.6132 | 560980.0 |
| 2009-12-31 09:05:00 | AAPL | Stock | 7.6139 | 7.6268 | 7.6125 | 7.6214 | 882588.0 |
| 2009-12-31 09:10:00 | AAPL | Stock | 7.6218 | 7.6268 | 7.6193 | 7.6243 | 566692.0 |
| 2009-12-31 09:15:00 | AAPL | Stock | 7.62 | 7.6239 | 7.6193 | 7.6193 | 147840.0 |
| 2009-12-31 09:20:00 | AAPL | Stock | 7.6193 | 7.6193 | 7.6139 | 7.6146 | 349300.0 |
| 2009-12-31 09:25:00 | AAPL | Stock | 7.6143 | 7.6179 | 7.6125 | 7.6125 | 188160.0 |
| 2009-12-31 09:30:00 | AAPL | Stock | 7.6125 | 7.6196 | 7.5918 | 7.6046 | 21333564.0 |
| 2009-12-31 09:35:00 | AAPL | Stock | 7.6032 | 7.6057 | 7.5804 | 7.5889 | 10481912.0 |
| 2009-12-31 09:40:00 | AAPL | Stock | 7.5889 | 7.6082 | 7.5857 | 7.5939 | 9383220.0 |
| 2009-12-31 09:45:00 | AAPL | Stock | 7.5943 | 7.6007 | 7.5732 | 7.5779 | 11758292.0 |
| 2009-12-31 09:50:00 | AAPL | Stock | 7.5777 | 7.5857 | 7.5629 | 7.5629 | 11268656.0 |
| 2009-12-31 09:55:00 | AAPL | Stock | 7.5629 | 7.57 | 7.5607 | 7.5686 | 7046564.0 |
| 2009-12-31 10:00:00 | AAPL | Stock | 7.5686 | 7.5732 | 7.5625 | 7.5675 | 7047796.0 |
| 2009-12-31 10:05:00 | AAPL | Stock | 7.5671 | 7.5696 | 7.5464 | 7.5618 | 9295104.0 |
| 2009-12-31 10:10:00 | AAPL | Stock | 7.5618 | 7.5679 | 7.55 | 7.555 | 7238924.0 |
| 2009-12-31 10:15:00 | AAPL | Stock | 7.5564 | 7.5704 | 7.5525 | 7.5625 | 5362476.0 |
| 2009-12-31 10:20:00 | AAPL | Stock | 7.5618 | 7.5832 | 7.5616 | 7.5811 | 6539876.0 |
| 2009-12-31 10:25:00 | AAPL | Stock | 7.5814 | 7.5818 | 7.5686 | 7.5725 | 4254180.0 |
| 2009-12-31 10:30:00 | AAPL | Stock | 7.5721 | 7.5757 | 7.5646 | 7.5682 | 3564792.0 |
| 2009-12-31 10:35:00 | AAPL | Stock | 7.5682 | 7.5704 | 7.5611 | 7.5638 | 2678816.0 |
| 2009-12-31 10:40:00 | AAPL | Stock | 7.5636 | 7.575 | 7.5629 | 7.5693 | 2772980.0 |
| 2009-12-31 10:45:00 | AAPL | Stock | 7.5693 | 7.5771 | 7.5693 | 7.5757 | 2697520.0 |
| 2009-12-31 10:50:00 | AAPL | Stock | 7.5757 | 7.5807 | 7.575 | 7.5768 | 2932748.0 |
| 2009-12-31 10:55:00 | AAPL | Stock | 7.5771 | 7.58 | 7.5696 | 7.57 | 1822772.0 |
| 2009-12-31 11:00:00 | AAPL | Stock | 7.5707 | 7.5707 | 7.5571 | 7.5571 | 3361036.0 |
| 2009-12-31 11:05:00 | AAPL | Stock | 7.5571 | 7.5639 | 7.55 | 7.55 | 5446924.0 |
| 2009-12-31 11:10:00 | AAPL | Stock | 7.55 | 7.5736 | 7.5429 | 7.555 | 9981664.0 |
| 2009-12-31 11:15:00 | AAPL | Stock | 7.5546 | 7.5661 | 7.5486 | 7.5661 | 4848564.0 |
| 2009-12-31 11:20:00 | AAPL | Stock | 7.5646 | 7.5646 | 7.5564 | 7.5604 | 2696904.0 |
| 2009-12-31 11:25:00 | AAPL | Stock | 7.5593 | 7.5607 | 7.5539 | 7.5546 | 2298940.0 |
| 2009-12-31 11:30:00 | AAPL | Stock | 7.5543 | 7.5589 | 7.5518 | 7.5525 | 2387840.0 |
| 2009-12-31 11:35:00 | AAPL | Stock | 7.5529 | 7.5596 | 7.5518 | 7.5596 | 2080876.0 |
| 2009-12-31 11:40:00 | AAPL | Stock | 7.5593 | 7.5639 | 7.5586 | 7.5639 | 3050656.0 |
| 2009-12-31 11:45:00 | AAPL | Stock | 7.5637 | 7.5732 | 7.5625 | 7.5714 | 6848576.0 |
| 2009-12-31 11:50:00 | AAPL | Stock | 7.5709 | 7.5757 | 7.5682 | 7.5707 | 3429048.0 |
| 2009-12-31 11:55:00 | AAPL | Stock | 7.5707 | 7.5718 | 7.5629 | 7.5629 | 2823660.0 |
| 2009-12-31 12:00:00 | AAPL | Stock | 7.5629 | 7.5675 | 7.56 | 7.5661 | 1958908.0 |
| 2009-12-31 12:05:00 | AAPL | Stock | 7.5661 | 7.5714 | 7.5657 | 7.5712 | 1353716.0 |
> showing 50 of 310,969 rows — these rows as CSV