PREVIEW / stock_5min / 2004-10-18
file: by_date/stock_5min/2004/2004-10-18.parquet size: 2.4 MB rows: 175,642 symbols: 1,839
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-18 08:10:00 | AAPL | Stock | 0.8123 | 0.8125 | 0.8088 | 0.8125 | 50400.0 |
| 2004-10-18 08:15:00 | AAPL | Stock | 0.8086 | 0.8107 | 0.8086 | 0.8107 | 16800.0 |
| 2004-10-18 08:30:00 | AAPL | Stock | 0.8086 | 0.8089 | 0.8079 | 0.8079 | 280000.0 |
| 2004-10-18 08:35:00 | AAPL | Stock | 0.8079 | 0.8079 | 0.8061 | 0.8066 | 246400.0 |
| 2004-10-18 08:40:00 | AAPL | Stock | 0.8064 | 0.8064 | 0.8054 | 0.8063 | 61600.0 |
| 2004-10-18 08:45:00 | AAPL | Stock | 0.8059 | 0.8064 | 0.805 | 0.805 | 557200.0 |
| 2004-10-18 08:50:00 | AAPL | Stock | 0.805 | 0.805 | 0.805 | 0.805 | 5600.0 |
| 2004-10-18 08:55:00 | AAPL | Stock | 0.805 | 0.8121 | 0.805 | 0.8116 | 403200.0 |
| 2004-10-18 09:00:00 | AAPL | Stock | 0.8071 | 0.8071 | 0.8071 | 0.8071 | 22400.0 |
| 2004-10-18 09:05:00 | AAPL | Stock | 0.8064 | 0.8064 | 0.8036 | 0.8045 | 1405600.0 |
| 2004-10-18 09:10:00 | AAPL | Stock | 0.8046 | 0.8063 | 0.8045 | 0.8063 | 235928.0 |
| 2004-10-18 09:15:00 | AAPL | Stock | 0.8045 | 0.8048 | 0.8027 | 0.8036 | 1397200.0 |
| 2004-10-18 09:20:00 | AAPL | Stock | 0.8029 | 0.8054 | 0.8009 | 0.8045 | 418320.0 |
| 2004-10-18 09:25:00 | AAPL | Stock | 0.8104 | 0.8125 | 0.7964 | 0.7982 | 13191640.0 |
| 2004-10-18 09:30:00 | AAPL | Stock | 0.7998 | 0.805 | 0.7982 | 0.8025 | 63471296.0 |
| 2004-10-18 09:35:00 | AAPL | Stock | 0.8025 | 0.8036 | 0.8009 | 0.8032 | 23989000.0 |
| 2004-10-18 09:40:00 | AAPL | Stock | 0.8032 | 0.8034 | 0.8023 | 0.8032 | 10205440.0 |
| 2004-10-18 09:45:00 | AAPL | Stock | 0.8032 | 0.8052 | 0.8013 | 0.8025 | 30969512.0 |
| 2004-10-18 09:50:00 | AAPL | Stock | 0.8029 | 0.8038 | 0.8014 | 0.803 | 16439080.0 |
| 2004-10-18 09:55:00 | AAPL | Stock | 0.8032 | 0.805 | 0.8025 | 0.805 | 14856296.0 |
| 2004-10-18 10:00:00 | AAPL | Stock | 0.8048 | 0.808 | 0.8036 | 0.8079 | 37855608.0 |
| 2004-10-18 10:05:00 | AAPL | Stock | 0.8077 | 0.8113 | 0.8075 | 0.8095 | 20470016.0 |
| 2004-10-18 10:10:00 | AAPL | Stock | 0.8095 | 0.8111 | 0.8093 | 0.8095 | 9125872.0 |
| 2004-10-18 10:15:00 | AAPL | Stock | 0.8093 | 0.8095 | 0.8061 | 0.8063 | 9501856.0 |
| 2004-10-18 10:20:00 | AAPL | Stock | 0.8063 | 0.8066 | 0.8036 | 0.8048 | 14750624.0 |
| 2004-10-18 10:25:00 | AAPL | Stock | 0.8046 | 0.8054 | 0.8025 | 0.8052 | 13848240.0 |
| 2004-10-18 10:30:00 | AAPL | Stock | 0.8052 | 0.8095 | 0.805 | 0.8095 | 11607120.0 |
| 2004-10-18 10:35:00 | AAPL | Stock | 0.8093 | 0.8114 | 0.8089 | 0.8095 | 6568464.0 |
| 2004-10-18 10:40:00 | AAPL | Stock | 0.8096 | 0.8096 | 0.8068 | 0.807 | 16181704.0 |
| 2004-10-18 10:45:00 | AAPL | Stock | 0.8075 | 0.8095 | 0.8071 | 0.8073 | 13045368.0 |
| 2004-10-18 10:50:00 | AAPL | Stock | 0.8073 | 0.8143 | 0.8071 | 0.8113 | 18228056.0 |
| 2004-10-18 10:55:00 | AAPL | Stock | 0.8113 | 0.8134 | 0.8091 | 0.8091 | 7433104.0 |
| 2004-10-18 11:00:00 | AAPL | Stock | 0.8093 | 0.8123 | 0.8093 | 0.8118 | 12323024.0 |
| 2004-10-18 11:05:00 | AAPL | Stock | 0.8118 | 0.8127 | 0.8105 | 0.8111 | 13476624.0 |
| 2004-10-18 11:10:00 | AAPL | Stock | 0.8111 | 0.8123 | 0.8071 | 0.8084 | 18105920.0 |
| 2004-10-18 11:15:00 | AAPL | Stock | 0.8084 | 0.8121 | 0.8084 | 0.8104 | 6293728.0 |
| 2004-10-18 11:20:00 | AAPL | Stock | 0.81 | 0.8109 | 0.8091 | 0.8102 | 7660800.0 |
| 2004-10-18 11:25:00 | AAPL | Stock | 0.81 | 0.8118 | 0.8095 | 0.8111 | 6299048.0 |
| 2004-10-18 11:30:00 | AAPL | Stock | 0.8098 | 0.8118 | 0.8089 | 0.8107 | 8853880.0 |
| 2004-10-18 11:35:00 | AAPL | Stock | 0.8105 | 0.8129 | 0.8104 | 0.8127 | 10732232.0 |
| 2004-10-18 11:40:00 | AAPL | Stock | 0.8125 | 0.8175 | 0.8121 | 0.8155 | 24101672.0 |
| 2004-10-18 11:45:00 | AAPL | Stock | 0.8154 | 0.8191 | 0.8141 | 0.8161 | 14196056.0 |
| 2004-10-18 11:50:00 | AAPL | Stock | 0.8157 | 0.817 | 0.8143 | 0.8157 | 12429144.0 |
| 2004-10-18 11:55:00 | AAPL | Stock | 0.8155 | 0.817 | 0.8136 | 0.8146 | 8674064.0 |
| 2004-10-18 12:00:00 | AAPL | Stock | 0.8146 | 0.8179 | 0.8138 | 0.8177 | 9143008.0 |
| 2004-10-18 12:05:00 | AAPL | Stock | 0.8177 | 0.8204 | 0.8168 | 0.8198 | 14030520.0 |
| 2004-10-18 12:10:00 | AAPL | Stock | 0.8196 | 0.8211 | 0.8186 | 0.8205 | 17120432.0 |
| 2004-10-18 12:15:00 | AAPL | Stock | 0.8205 | 0.8213 | 0.8191 | 0.8209 | 11829608.0 |
| 2004-10-18 12:20:00 | AAPL | Stock | 0.8209 | 0.8241 | 0.8207 | 0.8223 | 24389008.0 |
| 2004-10-18 12:25:00 | AAPL | Stock | 0.8223 | 0.8238 | 0.8193 | 0.8205 | 10354792.0 |
> showing 50 of 175,642 rows — these rows as CSV