PREVIEW / stock_5min / 2007-08-03
file: by_date/stock_5min/2007/2007-08-03.parquet size: 4.3 MB rows: 307,193 symbols: 3,117
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-03 09:30:00 | AAPL | Stock | 4.8307 | 4.8346 | 4.8129 | 4.8246 | 20987624.0 |
| 2007-08-03 09:35:00 | AAPL | Stock | 4.8246 | 4.8554 | 4.8143 | 4.8443 | 18058068.0 |
| 2007-08-03 09:40:00 | AAPL | Stock | 4.8436 | 4.8511 | 4.8293 | 4.8346 | 13884864.0 |
| 2007-08-03 09:45:00 | AAPL | Stock | 4.835 | 4.8432 | 4.8286 | 4.8393 | 10018372.0 |
| 2007-08-03 09:50:00 | AAPL | Stock | 4.8389 | 4.8432 | 4.825 | 4.8307 | 11397456.0 |
| 2007-08-03 09:55:00 | AAPL | Stock | 4.8307 | 4.8332 | 4.8054 | 4.8121 | 12292056.0 |
| 2007-08-03 10:00:00 | AAPL | Stock | 4.8129 | 4.8182 | 4.7989 | 4.8093 | 13981380.0 |
| 2007-08-03 10:05:00 | AAPL | Stock | 4.8089 | 4.8154 | 4.7954 | 4.8136 | 13941312.0 |
| 2007-08-03 10:10:00 | AAPL | Stock | 4.8136 | 4.8204 | 4.81 | 4.8168 | 6333964.0 |
| 2007-08-03 10:15:00 | AAPL | Stock | 4.8171 | 4.8254 | 4.8104 | 4.8182 | 7018704.0 |
| 2007-08-03 10:20:00 | AAPL | Stock | 4.8179 | 4.8196 | 4.8018 | 4.8189 | 6430956.0 |
| 2007-08-03 10:25:00 | AAPL | Stock | 4.8186 | 4.83 | 4.812 | 4.825 | 9485616.0 |
| 2007-08-03 10:30:00 | AAPL | Stock | 4.8254 | 4.834 | 4.8179 | 4.8179 | 8989372.0 |
| 2007-08-03 10:35:00 | AAPL | Stock | 4.8182 | 4.8196 | 4.8089 | 4.8114 | 8175188.0 |
| 2007-08-03 10:40:00 | AAPL | Stock | 4.8114 | 4.8179 | 4.8036 | 4.8071 | 8181768.0 |
| 2007-08-03 10:45:00 | AAPL | Stock | 4.8071 | 4.8157 | 4.8036 | 4.8107 | 6180496.0 |
| 2007-08-03 10:50:00 | AAPL | Stock | 4.8118 | 4.8179 | 4.8062 | 4.8179 | 4384940.0 |
| 2007-08-03 10:55:00 | AAPL | Stock | 4.8179 | 4.8214 | 4.8089 | 4.8114 | 5425840.0 |
| 2007-08-03 11:00:00 | AAPL | Stock | 4.81 | 4.8249 | 4.8089 | 4.8218 | 7237748.0 |
| 2007-08-03 11:05:00 | AAPL | Stock | 4.8218 | 4.8229 | 4.8161 | 4.8189 | 4277448.0 |
| 2007-08-03 11:10:00 | AAPL | Stock | 4.8175 | 4.8221 | 4.8143 | 4.8157 | 5497688.0 |
| 2007-08-03 11:15:00 | AAPL | Stock | 4.8168 | 4.8182 | 4.8064 | 4.8107 | 6052956.0 |
| 2007-08-03 11:20:00 | AAPL | Stock | 4.8107 | 4.8121 | 4.8036 | 4.8082 | 5687528.0 |
| 2007-08-03 11:25:00 | AAPL | Stock | 4.8082 | 4.82 | 4.8079 | 4.8193 | 8715084.0 |
| 2007-08-03 11:30:00 | AAPL | Stock | 4.8193 | 4.8218 | 4.8107 | 4.8189 | 6333908.0 |
| 2007-08-03 11:35:00 | AAPL | Stock | 4.8186 | 4.8193 | 4.8118 | 4.8175 | 3582012.0 |
| 2007-08-03 11:40:00 | AAPL | Stock | 4.8182 | 4.8204 | 4.8114 | 4.8161 | 4106256.0 |
| 2007-08-03 11:45:00 | AAPL | Stock | 4.8168 | 4.8186 | 4.8093 | 4.8134 | 4728276.0 |
| 2007-08-03 11:50:00 | AAPL | Stock | 4.8125 | 4.8179 | 4.7964 | 4.8079 | 11459672.0 |
| 2007-08-03 11:55:00 | AAPL | Stock | 4.8079 | 4.8189 | 4.805 | 4.8082 | 6304928.0 |
| 2007-08-03 12:00:00 | AAPL | Stock | 4.8082 | 4.8204 | 4.8082 | 4.8193 | 5910688.0 |
| 2007-08-03 12:05:00 | AAPL | Stock | 4.8193 | 4.8293 | 4.8114 | 4.8271 | 8764952.0 |
| 2007-08-03 12:10:00 | AAPL | Stock | 4.8271 | 4.8357 | 4.8257 | 4.8346 | 9817584.0 |
| 2007-08-03 12:15:00 | AAPL | Stock | 4.8354 | 4.8393 | 4.8286 | 4.8307 | 10018652.0 |
| 2007-08-03 12:20:00 | AAPL | Stock | 4.8307 | 4.8321 | 4.8221 | 4.8264 | 6720672.0 |
| 2007-08-03 12:25:00 | AAPL | Stock | 4.8268 | 4.8279 | 4.8168 | 4.8194 | 5326244.0 |
| 2007-08-03 12:30:00 | AAPL | Stock | 4.8189 | 4.8268 | 4.8175 | 4.8193 | 4434752.0 |
| 2007-08-03 12:35:00 | AAPL | Stock | 4.8196 | 4.8268 | 4.8164 | 4.8243 | 3103240.0 |
| 2007-08-03 12:40:00 | AAPL | Stock | 4.8239 | 4.8275 | 4.8196 | 4.8254 | 2909312.0 |
| 2007-08-03 12:45:00 | AAPL | Stock | 4.825 | 4.825 | 4.8132 | 4.8186 | 4004756.0 |
| 2007-08-03 12:50:00 | AAPL | Stock | 4.8189 | 4.8229 | 4.8125 | 4.8179 | 4037824.0 |
| 2007-08-03 12:55:00 | AAPL | Stock | 4.8189 | 4.8207 | 4.8107 | 4.8136 | 3914428.0 |
| 2007-08-03 13:00:00 | AAPL | Stock | 4.8143 | 4.8168 | 4.8107 | 4.8125 | 3207736.0 |
| 2007-08-03 13:05:00 | AAPL | Stock | 4.8126 | 4.8164 | 4.8107 | 4.815 | 3249904.0 |
| 2007-08-03 13:10:00 | AAPL | Stock | 4.8143 | 4.8175 | 4.8118 | 4.8136 | 2428468.0 |
| 2007-08-03 13:15:00 | AAPL | Stock | 4.8129 | 4.8196 | 4.8118 | 4.8146 | 3354204.0 |
| 2007-08-03 13:20:00 | AAPL | Stock | 4.8154 | 4.8182 | 4.8125 | 4.8146 | 2752428.0 |
| 2007-08-03 13:25:00 | AAPL | Stock | 4.8143 | 4.8196 | 4.8139 | 4.815 | 2456244.0 |
| 2007-08-03 13:30:00 | AAPL | Stock | 4.815 | 4.8179 | 4.8136 | 4.8175 | 3280060.0 |
| 2007-08-03 13:35:00 | AAPL | Stock | 4.8171 | 4.8171 | 4.8071 | 4.8118 | 4273108.0 |
> showing 50 of 307,193 rows — these rows as CSV