PREVIEW / stock_1min / 2000-01-12
file: by_date/stock_1min/2000/2000-01-12.parquet size: 2.2 MB rows: 192,206 symbols: 918
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 |
|---|---|---|---|---|---|---|---|
| 2000-01-12 09:30:00 | AAPL | Stock | 0.8482 | 0.8516 | 0.8477 | 0.8482 | 1724800.0 |
| 2000-01-12 09:31:00 | AAPL | Stock | 0.8488 | 0.8527 | 0.8482 | 0.8516 | 6328000.0 |
| 2000-01-12 09:32:00 | AAPL | Stock | 0.851 | 0.8521 | 0.846 | 0.8471 | 1960000.0 |
| 2000-01-12 09:33:00 | AAPL | Stock | 0.8454 | 0.8527 | 0.8426 | 0.8435 | 7537600.0 |
| 2000-01-12 09:34:00 | AAPL | Stock | 0.8438 | 0.8482 | 0.8426 | 0.8426 | 2452800.0 |
| 2000-01-12 09:35:00 | AAPL | Stock | 0.8432 | 0.8432 | 0.8404 | 0.8415 | 1254400.0 |
| 2000-01-12 09:36:00 | AAPL | Stock | 0.841 | 0.8426 | 0.8382 | 0.8393 | 2867200.0 |
| 2000-01-12 09:37:00 | AAPL | Stock | 0.8382 | 0.8398 | 0.8365 | 0.8365 | 1411200.0 |
| 2000-01-12 09:38:00 | AAPL | Stock | 0.8371 | 0.8376 | 0.8337 | 0.8343 | 1075200.0 |
| 2000-01-12 09:39:00 | AAPL | Stock | 0.8343 | 0.8354 | 0.8337 | 0.8337 | 1422400.0 |
| 2000-01-12 09:40:00 | AAPL | Stock | 0.8337 | 0.8343 | 0.8315 | 0.832 | 2027200.0 |
| 2000-01-12 09:41:00 | AAPL | Stock | 0.8315 | 0.8343 | 0.8309 | 0.8326 | 996800.0 |
| 2000-01-12 09:42:00 | AAPL | Stock | 0.8326 | 0.8326 | 0.8315 | 0.832 | 1164800.0 |
| 2000-01-12 09:43:00 | AAPL | Stock | 0.8318 | 0.832 | 0.8315 | 0.832 | 2240000.0 |
| 2000-01-12 09:44:00 | AAPL | Stock | 0.8315 | 0.832 | 0.8304 | 0.8304 | 1400000.0 |
| 2000-01-12 09:45:00 | AAPL | Stock | 0.8304 | 0.8306 | 0.8259 | 0.8259 | 1388800.0 |
| 2000-01-12 09:46:00 | AAPL | Stock | 0.8259 | 0.8265 | 0.8214 | 0.8214 | 1388800.0 |
| 2000-01-12 09:47:00 | AAPL | Stock | 0.8225 | 0.8225 | 0.8203 | 0.8203 | 2262400.0 |
| 2000-01-12 09:48:00 | AAPL | Stock | 0.8214 | 0.8259 | 0.817 | 0.8181 | 1814400.0 |
| 2000-01-12 09:49:00 | AAPL | Stock | 0.8158 | 0.8214 | 0.8136 | 0.8136 | 3113600.0 |
| 2000-01-12 09:50:00 | AAPL | Stock | 0.8142 | 0.817 | 0.8125 | 0.8125 | 2822400.0 |
| 2000-01-12 09:51:00 | AAPL | Stock | 0.8131 | 0.8136 | 0.808 | 0.808 | 4289600.0 |
| 2000-01-12 09:52:00 | AAPL | Stock | 0.808 | 0.8125 | 0.8075 | 0.8086 | 2576000.0 |
| 2000-01-12 09:53:00 | AAPL | Stock | 0.808 | 0.8131 | 0.8069 | 0.8075 | 1366400.0 |
| 2000-01-12 09:54:00 | AAPL | Stock | 0.8086 | 0.8097 | 0.8069 | 0.8092 | 1512000.0 |
| 2000-01-12 09:55:00 | AAPL | Stock | 0.8092 | 0.8103 | 0.8058 | 0.808 | 1881600.0 |
| 2000-01-12 09:56:00 | AAPL | Stock | 0.8058 | 0.8097 | 0.8058 | 0.8058 | 1444800.0 |
| 2000-01-12 09:57:00 | AAPL | Stock | 0.808 | 0.808 | 0.8047 | 0.8075 | 1612800.0 |
| 2000-01-12 09:58:00 | AAPL | Stock | 0.8075 | 0.8075 | 0.8047 | 0.8075 | 4468800.0 |
| 2000-01-12 09:59:00 | AAPL | Stock | 0.8072 | 0.8125 | 0.8058 | 0.8103 | 1668800.0 |
| 2000-01-12 10:00:00 | AAPL | Stock | 0.8119 | 0.8158 | 0.8069 | 0.8136 | 3908800.0 |
| 2000-01-12 10:01:00 | AAPL | Stock | 0.8136 | 0.8136 | 0.8119 | 0.8131 | 1232000.0 |
| 2000-01-12 10:02:00 | AAPL | Stock | 0.8136 | 0.8175 | 0.8125 | 0.8175 | 2486400.0 |
| 2000-01-12 10:03:00 | AAPL | Stock | 0.817 | 0.8181 | 0.8158 | 0.8175 | 1971200.0 |
| 2000-01-12 10:04:00 | AAPL | Stock | 0.8181 | 0.8214 | 0.817 | 0.8181 | 1646400.0 |
| 2000-01-12 10:05:00 | AAPL | Stock | 0.8181 | 0.8186 | 0.8147 | 0.8147 | 1568000.0 |
| 2000-01-12 10:06:00 | AAPL | Stock | 0.8131 | 0.8186 | 0.8125 | 0.8136 | 2363200.0 |
| 2000-01-12 10:07:00 | AAPL | Stock | 0.8158 | 0.817 | 0.8136 | 0.8164 | 1164800.0 |
| 2000-01-12 10:08:00 | AAPL | Stock | 0.8161 | 0.8181 | 0.8142 | 0.8175 | 996800.0 |
| 2000-01-12 10:09:00 | AAPL | Stock | 0.8181 | 0.8186 | 0.8158 | 0.8158 | 1736000.0 |
| 2000-01-12 10:10:00 | AAPL | Stock | 0.817 | 0.8181 | 0.8158 | 0.817 | 156800.0 |
| 2000-01-12 10:11:00 | AAPL | Stock | 0.8181 | 0.8181 | 0.8114 | 0.8114 | 1288000.0 |
| 2000-01-12 10:12:00 | AAPL | Stock | 0.8125 | 0.817 | 0.808 | 0.8086 | 1892800.0 |
| 2000-01-12 10:13:00 | AAPL | Stock | 0.8086 | 0.8097 | 0.8058 | 0.8064 | 2195200.0 |
| 2000-01-12 10:14:00 | AAPL | Stock | 0.8066 | 0.8069 | 0.8041 | 0.8047 | 2486400.0 |
| 2000-01-12 10:15:00 | AAPL | Stock | 0.8036 | 0.8047 | 0.8036 | 0.8036 | 6697600.0 |
| 2000-01-12 10:16:00 | AAPL | Stock | 0.8036 | 0.8164 | 0.798 | 0.798 | 5432000.0 |
| 2000-01-12 10:17:00 | AAPL | Stock | 0.798 | 0.8052 | 0.7946 | 0.7946 | 5174400.0 |
| 2000-01-12 10:18:00 | AAPL | Stock | 0.7946 | 0.7963 | 0.7924 | 0.7958 | 3360000.0 |
| 2000-01-12 10:19:00 | AAPL | Stock | 0.7946 | 0.7963 | 0.7913 | 0.7946 | 3292800.0 |
> showing 50 of 192,206 rows — these rows as CSV