PREVIEW / stock_1min / 2007-07-13
file: by_date/stock_1min/2007/2007-07-13.parquet size: 10.7 MB rows: 876,511 symbols: 2,500
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-07-13 09:30:00 | AAPL | Stock | 4.8225 | 4.8236 | 4.8104 | 4.8125 | 14434504.0 |
| 2007-07-13 09:31:00 | AAPL | Stock | 4.8125 | 4.8232 | 4.8114 | 4.8182 | 4568620.0 |
| 2007-07-13 09:32:00 | AAPL | Stock | 4.8181 | 4.8339 | 4.8179 | 4.8332 | 11468072.0 |
| 2007-07-13 09:33:00 | AAPL | Stock | 4.8339 | 4.8375 | 4.8239 | 4.8325 | 8944544.0 |
| 2007-07-13 09:34:00 | AAPL | Stock | 4.8325 | 4.8379 | 4.8171 | 4.8246 | 11235756.0 |
| 2007-07-13 09:35:00 | AAPL | Stock | 4.8246 | 4.8334 | 4.8136 | 4.8175 | 5994156.0 |
| 2007-07-13 09:36:00 | AAPL | Stock | 4.8176 | 4.8214 | 4.8161 | 4.8171 | 4444468.0 |
| 2007-07-13 09:37:00 | AAPL | Stock | 4.8171 | 4.8239 | 4.8164 | 4.8196 | 2970968.0 |
| 2007-07-13 09:38:00 | AAPL | Stock | 4.82 | 4.8286 | 4.8179 | 4.8221 | 3199812.0 |
| 2007-07-13 09:39:00 | AAPL | Stock | 4.8264 | 4.8293 | 4.8214 | 4.8261 | 3185560.0 |
| 2007-07-13 09:40:00 | AAPL | Stock | 4.8257 | 4.8275 | 4.8225 | 4.8236 | 3292296.0 |
| 2007-07-13 09:41:00 | AAPL | Stock | 4.8239 | 4.8279 | 4.8232 | 4.8261 | 3012128.0 |
| 2007-07-13 09:42:00 | AAPL | Stock | 4.825 | 4.8275 | 4.8243 | 4.8254 | 4171076.0 |
| 2007-07-13 09:43:00 | AAPL | Stock | 4.825 | 4.8268 | 4.8182 | 4.8232 | 5125960.0 |
| 2007-07-13 09:44:00 | AAPL | Stock | 4.8257 | 4.8286 | 4.8214 | 4.8261 | 2774968.0 |
| 2007-07-13 09:45:00 | AAPL | Stock | 4.8268 | 4.8321 | 4.8261 | 4.8318 | 4797044.0 |
| 2007-07-13 09:46:00 | AAPL | Stock | 4.8321 | 4.8321 | 4.8221 | 4.8243 | 3412612.0 |
| 2007-07-13 09:47:00 | AAPL | Stock | 4.8243 | 4.8289 | 4.8225 | 4.8257 | 2734620.0 |
| 2007-07-13 09:48:00 | AAPL | Stock | 4.8261 | 4.8279 | 4.8232 | 4.8232 | 1764812.0 |
| 2007-07-13 09:49:00 | AAPL | Stock | 4.8236 | 4.8246 | 4.8214 | 4.8214 | 4426940.0 |
| 2007-07-13 09:50:00 | AAPL | Stock | 4.8214 | 4.8275 | 4.8182 | 4.8205 | 7609532.0 |
| 2007-07-13 09:51:00 | AAPL | Stock | 4.8204 | 4.8211 | 4.8186 | 4.8189 | 4348400.0 |
| 2007-07-13 09:52:00 | AAPL | Stock | 4.8193 | 4.8225 | 4.8179 | 4.8179 | 3920308.0 |
| 2007-07-13 09:53:00 | AAPL | Stock | 4.8179 | 4.8189 | 4.815 | 4.8157 | 4416020.0 |
| 2007-07-13 09:54:00 | AAPL | Stock | 4.8157 | 4.8196 | 4.8154 | 4.8189 | 2841916.0 |
| 2007-07-13 09:55:00 | AAPL | Stock | 4.8193 | 4.8221 | 4.8168 | 4.8171 | 3192980.0 |
| 2007-07-13 09:56:00 | AAPL | Stock | 4.8175 | 4.8175 | 4.8154 | 4.8157 | 2771384.0 |
| 2007-07-13 09:57:00 | AAPL | Stock | 4.8161 | 4.8182 | 4.8043 | 4.8079 | 5985112.0 |
| 2007-07-13 09:58:00 | AAPL | Stock | 4.8071 | 4.8089 | 4.8057 | 4.8086 | 2921912.0 |
| 2007-07-13 09:59:00 | AAPL | Stock | 4.8089 | 4.8107 | 4.8088 | 4.8107 | 3080560.0 |
| 2007-07-13 10:00:00 | AAPL | Stock | 4.8107 | 4.8175 | 4.8104 | 4.8146 | 3430476.0 |
| 2007-07-13 10:01:00 | AAPL | Stock | 4.815 | 4.8239 | 4.8143 | 4.8193 | 6952764.0 |
| 2007-07-13 10:02:00 | AAPL | Stock | 4.8189 | 4.8204 | 4.8146 | 4.8179 | 3689420.0 |
| 2007-07-13 10:03:00 | AAPL | Stock | 4.8179 | 4.8182 | 4.8146 | 4.8154 | 1908228.0 |
| 2007-07-13 10:04:00 | AAPL | Stock | 4.815 | 4.8175 | 4.8143 | 4.8154 | 1950284.0 |
| 2007-07-13 10:05:00 | AAPL | Stock | 4.8154 | 4.8157 | 4.8111 | 4.8121 | 2151940.0 |
| 2007-07-13 10:06:00 | AAPL | Stock | 4.8118 | 4.8218 | 4.8096 | 4.8207 | 3902080.0 |
| 2007-07-13 10:07:00 | AAPL | Stock | 4.8204 | 4.8207 | 4.8132 | 4.8161 | 2702784.0 |
| 2007-07-13 10:08:00 | AAPL | Stock | 4.8161 | 4.8161 | 4.8114 | 4.8121 | 1519980.0 |
| 2007-07-13 10:09:00 | AAPL | Stock | 4.8121 | 4.8154 | 4.8082 | 4.8086 | 2952180.0 |
| 2007-07-13 10:10:00 | AAPL | Stock | 4.8082 | 4.8121 | 4.8071 | 4.8111 | 3369912.0 |
| 2007-07-13 10:11:00 | AAPL | Stock | 4.8111 | 4.8129 | 4.8107 | 4.8107 | 2204356.0 |
| 2007-07-13 10:12:00 | AAPL | Stock | 4.8107 | 4.8114 | 4.8071 | 4.8071 | 1974700.0 |
| 2007-07-13 10:13:00 | AAPL | Stock | 4.8071 | 4.8104 | 4.8068 | 4.8086 | 2554440.0 |
| 2007-07-13 10:14:00 | AAPL | Stock | 4.8093 | 4.8104 | 4.8068 | 4.8086 | 1691676.0 |
| 2007-07-13 10:15:00 | AAPL | Stock | 4.8089 | 4.8121 | 4.8068 | 4.8107 | 1573124.0 |
| 2007-07-13 10:16:00 | AAPL | Stock | 4.8118 | 4.8121 | 4.8064 | 4.8071 | 1946112.0 |
| 2007-07-13 10:17:00 | AAPL | Stock | 4.8068 | 4.8096 | 4.8064 | 4.8096 | 1572424.0 |
| 2007-07-13 10:18:00 | AAPL | Stock | 4.8096 | 4.8121 | 4.8089 | 4.8107 | 1626772.0 |
| 2007-07-13 10:19:00 | AAPL | Stock | 4.8107 | 4.8129 | 4.8089 | 4.8093 | 1213044.0 |
> showing 50 of 876,511 rows — these rows as CSV