PREVIEW / stock_5min / 2005-10-18
file: by_date/stock_5min/2005/2005-10-18.parquet size: 2.8 MB rows: 203,719 symbols: 2,088
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-18 08:00:00 | AAPL | Stock | 1.9107 | 1.9107 | 1.8707 | 1.875 | 226520.0 |
| 2005-10-18 08:05:00 | AAPL | Stock | 1.8929 | 1.8964 | 1.8929 | 1.8964 | 30576.0 |
| 2005-10-18 08:10:00 | AAPL | Stock | 1.9011 | 1.9011 | 1.9011 | 1.9011 | 36400.0 |
| 2005-10-18 08:15:00 | AAPL | Stock | 1.8982 | 1.9011 | 1.8964 | 1.9011 | 226800.0 |
| 2005-10-18 08:20:00 | AAPL | Stock | 1.9011 | 1.9014 | 1.9011 | 1.9014 | 59836.0 |
| 2005-10-18 08:25:00 | AAPL | Stock | 1.9036 | 1.9054 | 1.9036 | 1.9054 | 22400.0 |
| 2005-10-18 08:30:00 | AAPL | Stock | 1.9054 | 1.9054 | 1.9 | 1.9 | 265552.0 |
| 2005-10-18 08:35:00 | AAPL | Stock | 1.8986 | 1.9018 | 1.8971 | 1.9018 | 64036.0 |
| 2005-10-18 08:40:00 | AAPL | Stock | 1.9018 | 1.9018 | 1.9 | 1.9 | 61964.0 |
| 2005-10-18 08:45:00 | AAPL | Stock | 1.9 | 1.9 | 1.9 | 1.9 | 41636.0 |
| 2005-10-18 08:50:00 | AAPL | Stock | 1.9 | 1.9036 | 1.8986 | 1.9036 | 152600.0 |
| 2005-10-18 08:55:00 | AAPL | Stock | 1.9086 | 1.9086 | 1.9061 | 1.9061 | 128436.0 |
| 2005-10-18 09:00:00 | AAPL | Stock | 1.9032 | 1.9032 | 1.8993 | 1.8993 | 28000.0 |
| 2005-10-18 09:05:00 | AAPL | Stock | 1.9018 | 1.9018 | 1.8986 | 1.9018 | 32200.0 |
| 2005-10-18 09:15:00 | AAPL | Stock | 1.9018 | 1.9018 | 1.9018 | 1.9018 | 2800.0 |
| 2005-10-18 09:20:00 | AAPL | Stock | 1.9018 | 1.9018 | 1.9018 | 1.9018 | 14000.0 |
| 2005-10-18 09:25:00 | AAPL | Stock | 1.9018 | 1.9061 | 1.8957 | 1.9014 | 760900.0 |
| 2005-10-18 09:30:00 | AAPL | Stock | 1.9018 | 1.9068 | 1.8957 | 1.9014 | 13821612.0 |
| 2005-10-18 09:35:00 | AAPL | Stock | 1.9011 | 1.9118 | 1.9011 | 1.9071 | 11876564.0 |
| 2005-10-18 09:40:00 | AAPL | Stock | 1.9075 | 1.9154 | 1.9064 | 1.91 | 12869724.0 |
| 2005-10-18 09:45:00 | AAPL | Stock | 1.9107 | 1.92 | 1.9104 | 1.9139 | 15999004.0 |
| 2005-10-18 09:50:00 | AAPL | Stock | 1.9146 | 1.9193 | 1.9132 | 1.9182 | 10461416.0 |
| 2005-10-18 09:55:00 | AAPL | Stock | 1.9182 | 1.9211 | 1.9146 | 1.9154 | 14032284.0 |
| 2005-10-18 10:00:00 | AAPL | Stock | 1.9146 | 1.9175 | 1.9071 | 1.9168 | 12938604.0 |
| 2005-10-18 10:05:00 | AAPL | Stock | 1.9171 | 1.9268 | 1.9164 | 1.9214 | 20803132.0 |
| 2005-10-18 10:10:00 | AAPL | Stock | 1.9218 | 1.9257 | 1.9196 | 1.9196 | 13047580.0 |
| 2005-10-18 10:15:00 | AAPL | Stock | 1.9196 | 1.9221 | 1.9179 | 1.9207 | 12109944.0 |
| 2005-10-18 10:20:00 | AAPL | Stock | 1.9204 | 1.9254 | 1.9154 | 1.9182 | 15426264.0 |
| 2005-10-18 10:25:00 | AAPL | Stock | 1.919 | 1.9204 | 1.9132 | 1.9132 | 8705228.0 |
| 2005-10-18 10:30:00 | AAPL | Stock | 1.9132 | 1.9164 | 1.9068 | 1.9107 | 14514808.0 |
| 2005-10-18 10:35:00 | AAPL | Stock | 1.9107 | 1.9125 | 1.9068 | 1.9089 | 8500520.0 |
| 2005-10-18 10:40:00 | AAPL | Stock | 1.9089 | 1.9104 | 1.9032 | 1.9043 | 8684480.0 |
| 2005-10-18 10:45:00 | AAPL | Stock | 1.9039 | 1.9082 | 1.9011 | 1.9011 | 6662208.0 |
| 2005-10-18 10:50:00 | AAPL | Stock | 1.9011 | 1.9064 | 1.9007 | 1.9061 | 6502440.0 |
| 2005-10-18 10:55:00 | AAPL | Stock | 1.9061 | 1.9093 | 1.9054 | 1.9054 | 4416552.0 |
| 2005-10-18 11:00:00 | AAPL | Stock | 1.9057 | 1.9082 | 1.905 | 1.9061 | 5978868.0 |
| 2005-10-18 11:05:00 | AAPL | Stock | 1.9061 | 1.9121 | 1.9061 | 1.9086 | 6970124.0 |
| 2005-10-18 11:10:00 | AAPL | Stock | 1.9086 | 1.9086 | 1.9036 | 1.9046 | 8934044.0 |
| 2005-10-18 11:15:00 | AAPL | Stock | 1.9046 | 1.9057 | 1.8993 | 1.9003 | 6141940.0 |
| 2005-10-18 11:20:00 | AAPL | Stock | 1.9004 | 1.9054 | 1.9 | 1.9036 | 4044600.0 |
| 2005-10-18 11:25:00 | AAPL | Stock | 1.9036 | 1.9036 | 1.8968 | 1.8982 | 6649272.0 |
| 2005-10-18 11:30:00 | AAPL | Stock | 1.8982 | 1.9014 | 1.8972 | 1.8996 | 4740288.0 |
| 2005-10-18 11:35:00 | AAPL | Stock | 1.8996 | 1.8996 | 1.8936 | 1.8939 | 8323224.0 |
| 2005-10-18 11:40:00 | AAPL | Stock | 1.8936 | 1.8979 | 1.8907 | 1.896 | 9298408.0 |
| 2005-10-18 11:45:00 | AAPL | Stock | 1.8954 | 1.8979 | 1.8943 | 1.895 | 4479300.0 |
| 2005-10-18 11:50:00 | AAPL | Stock | 1.895 | 1.8982 | 1.8929 | 1.8975 | 4658332.0 |
| 2005-10-18 11:55:00 | AAPL | Stock | 1.8975 | 1.8982 | 1.8943 | 1.8946 | 2635052.0 |
| 2005-10-18 12:00:00 | AAPL | Stock | 1.895 | 1.8964 | 1.8932 | 1.8954 | 2922444.0 |
| 2005-10-18 12:05:00 | AAPL | Stock | 1.8954 | 1.8957 | 1.8896 | 1.8907 | 5580652.0 |
| 2005-10-18 12:10:00 | AAPL | Stock | 1.8907 | 1.8957 | 1.89 | 1.8946 | 5874204.0 |
> showing 50 of 203,719 rows — these rows as CSV