PREVIEW / stock_5min / 2009-12-28
file: by_date/stock_5min/2009/2009-12-28.parquet size: 4.5 MB rows: 314,247 symbols: 3,445
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-28 05:00:00 | AAPL | Stock | 7.4771 | 7.4771 | 7.4771 | 7.4771 | 7000.0 |
| 2009-12-28 07:00:00 | AAPL | Stock | 7.4996 | 7.5332 | 7.4996 | 7.5107 | 61236.0 |
| 2009-12-28 07:05:00 | AAPL | Stock | 7.5107 | 7.5179 | 7.5004 | 7.5004 | 24500.0 |
| 2009-12-28 07:10:00 | AAPL | Stock | 7.5 | 7.5054 | 7.5 | 7.5054 | 39200.0 |
| 2009-12-28 07:20:00 | AAPL | Stock | 7.5086 | 7.5107 | 7.5054 | 7.5054 | 72184.0 |
| 2009-12-28 07:25:00 | AAPL | Stock | 7.5071 | 7.5071 | 7.5071 | 7.5071 | 6748.0 |
| 2009-12-28 07:30:00 | AAPL | Stock | 7.5107 | 7.5107 | 7.5107 | 7.5107 | 2800.0 |
| 2009-12-28 07:35:00 | AAPL | Stock | 7.5093 | 7.5093 | 7.5071 | 7.5071 | 35560.0 |
| 2009-12-28 07:40:00 | AAPL | Stock | 7.5039 | 7.5039 | 7.4968 | 7.5029 | 42000.0 |
| 2009-12-28 07:45:00 | AAPL | Stock | 7.5036 | 7.5036 | 7.5036 | 7.5036 | 16800.0 |
| 2009-12-28 07:50:00 | AAPL | Stock | 7.5036 | 7.5036 | 7.4921 | 7.4929 | 189000.0 |
| 2009-12-28 07:55:00 | AAPL | Stock | 7.4929 | 7.4929 | 7.4929 | 7.4929 | 8400.0 |
| 2009-12-28 08:00:00 | AAPL | Stock | 7.4946 | 7.5036 | 7.4821 | 7.5036 | 610120.0 |
| 2009-12-28 08:05:00 | AAPL | Stock | 7.5036 | 7.5036 | 7.4943 | 7.5036 | 232400.0 |
| 2009-12-28 08:10:00 | AAPL | Stock | 7.5039 | 7.53 | 7.5039 | 7.53 | 374528.0 |
| 2009-12-28 08:15:00 | AAPL | Stock | 7.5286 | 7.5464 | 7.5257 | 7.5446 | 1038940.0 |
| 2009-12-28 08:20:00 | AAPL | Stock | 7.5429 | 7.5618 | 7.5429 | 7.56 | 1355228.0 |
| 2009-12-28 08:25:00 | AAPL | Stock | 7.5593 | 7.5607 | 7.5454 | 7.5454 | 727944.0 |
| 2009-12-28 08:30:00 | AAPL | Stock | 7.5446 | 7.5518 | 7.5446 | 7.55 | 485604.0 |
| 2009-12-28 08:35:00 | AAPL | Stock | 7.55 | 7.55 | 7.5411 | 7.5471 | 697256.0 |
| 2009-12-28 08:40:00 | AAPL | Stock | 7.5446 | 7.5486 | 7.5446 | 7.5464 | 200984.0 |
| 2009-12-28 08:45:00 | AAPL | Stock | 7.5464 | 7.5596 | 7.545 | 7.5589 | 670040.0 |
| 2009-12-28 08:50:00 | AAPL | Stock | 7.5596 | 7.5632 | 7.5571 | 7.5618 | 561988.0 |
| 2009-12-28 08:55:00 | AAPL | Stock | 7.5639 | 7.5779 | 7.5629 | 7.5714 | 1138648.0 |
| 2009-12-28 09:00:00 | AAPL | Stock | 7.5714 | 7.5839 | 7.5661 | 7.5786 | 962220.0 |
| 2009-12-28 09:05:00 | AAPL | Stock | 7.5775 | 7.5821 | 7.5714 | 7.5743 | 970032.0 |
| 2009-12-28 09:10:00 | AAPL | Stock | 7.5739 | 7.5757 | 7.5682 | 7.5682 | 413784.0 |
| 2009-12-28 09:15:00 | AAPL | Stock | 7.5686 | 7.5757 | 7.5536 | 7.5718 | 936096.0 |
| 2009-12-28 09:20:00 | AAPL | Stock | 7.5721 | 7.5757 | 7.5677 | 7.5677 | 935116.0 |
| 2009-12-28 09:25:00 | AAPL | Stock | 7.5679 | 7.5714 | 7.5511 | 7.5589 | 1431304.0 |
| 2009-12-28 09:30:00 | AAPL | Stock | 7.5614 | 7.6339 | 7.5393 | 7.6307 | 42170772.0 |
| 2009-12-28 09:35:00 | AAPL | Stock | 7.6311 | 7.6411 | 7.6171 | 7.6221 | 26437264.0 |
| 2009-12-28 09:40:00 | AAPL | Stock | 7.6221 | 7.632 | 7.6036 | 7.605 | 19240760.0 |
| 2009-12-28 09:45:00 | AAPL | Stock | 7.605 | 7.6232 | 7.6036 | 7.6039 | 15757896.0 |
| 2009-12-28 09:50:00 | AAPL | Stock | 7.605 | 7.6154 | 7.5939 | 7.6111 | 13433000.0 |
| 2009-12-28 09:55:00 | AAPL | Stock | 7.6118 | 7.6132 | 7.5975 | 7.6004 | 8683892.0 |
| 2009-12-28 10:00:00 | AAPL | Stock | 7.6 | 7.6021 | 7.5893 | 7.5943 | 11397624.0 |
| 2009-12-28 10:05:00 | AAPL | Stock | 7.5943 | 7.6136 | 7.5904 | 7.6129 | 8808800.0 |
| 2009-12-28 10:10:00 | AAPL | Stock | 7.6129 | 7.6232 | 7.6032 | 7.6039 | 12207832.0 |
| 2009-12-28 10:15:00 | AAPL | Stock | 7.6039 | 7.605 | 7.5904 | 7.5971 | 12672940.0 |
| 2009-12-28 10:20:00 | AAPL | Stock | 7.5968 | 7.6029 | 7.5875 | 7.5982 | 8521716.0 |
| 2009-12-28 10:25:00 | AAPL | Stock | 7.5989 | 7.6146 | 7.5932 | 7.6086 | 8599388.0 |
| 2009-12-28 10:30:00 | AAPL | Stock | 7.6093 | 7.6125 | 7.5961 | 7.5986 | 6152300.0 |
| 2009-12-28 10:35:00 | AAPL | Stock | 7.5982 | 7.6036 | 7.5929 | 7.602 | 4744964.0 |
| 2009-12-28 10:40:00 | AAPL | Stock | 7.6029 | 7.6036 | 7.5961 | 7.5989 | 2971248.0 |
| 2009-12-28 10:45:00 | AAPL | Stock | 7.5996 | 7.6029 | 7.5964 | 7.5993 | 4542552.0 |
| 2009-12-28 10:50:00 | AAPL | Stock | 7.5989 | 7.6054 | 7.5975 | 7.6029 | 3651508.0 |
| 2009-12-28 10:55:00 | AAPL | Stock | 7.6032 | 7.6161 | 7.6029 | 7.6139 | 6333208.0 |
| 2009-12-28 11:00:00 | AAPL | Stock | 7.6139 | 7.6207 | 7.6118 | 7.62 | 6865152.0 |
| 2009-12-28 11:05:00 | AAPL | Stock | 7.6207 | 7.625 | 7.6079 | 7.6148 | 9839816.0 |
> showing 50 of 314,247 rows — these rows as CSV