PREVIEW / stock_1min / 2007-05-11
file: by_date/stock_1min/2007/2007-05-11.parquet size: 10.2 MB rows: 850,911 symbols: 2,237
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-05-11 09:42:00 | AAPL | Stock | 3.8479 | 3.8557 | 3.8476 | 3.8557 | 968296.0 |
| 2007-05-11 09:43:00 | AAPL | Stock | 3.8564 | 3.8661 | 3.8546 | 3.8661 | 2378068.0 |
| 2007-05-11 09:44:00 | AAPL | Stock | 3.8661 | 3.8675 | 3.8593 | 3.8632 | 1243340.0 |
| 2007-05-11 09:45:00 | AAPL | Stock | 3.8632 | 3.8636 | 3.8582 | 3.8604 | 1000832.0 |
| 2007-05-11 09:46:00 | AAPL | Stock | 3.8604 | 3.8605 | 3.8536 | 3.8543 | 1048880.0 |
| 2007-05-11 09:47:00 | AAPL | Stock | 3.855 | 3.8586 | 3.8543 | 3.8579 | 1999760.0 |
| 2007-05-11 09:48:00 | AAPL | Stock | 3.8575 | 3.8582 | 3.8454 | 3.8461 | 4503716.0 |
| 2007-05-11 09:49:00 | AAPL | Stock | 3.8461 | 3.8493 | 3.8443 | 3.8471 | 3068604.0 |
| 2007-05-11 09:50:00 | AAPL | Stock | 3.8475 | 3.8525 | 3.8464 | 3.8504 | 2803416.0 |
| 2007-05-11 09:51:00 | AAPL | Stock | 3.8507 | 3.8525 | 3.8421 | 3.8425 | 2900772.0 |
| 2007-05-11 09:52:00 | AAPL | Stock | 3.8432 | 3.8475 | 3.8096 | 3.8304 | 6040748.0 |
| 2007-05-11 09:53:00 | AAPL | Stock | 3.8311 | 3.8354 | 3.8264 | 3.835 | 4027324.0 |
| 2007-05-11 09:54:00 | AAPL | Stock | 3.835 | 3.8371 | 3.8321 | 3.8357 | 1938132.0 |
| 2007-05-11 09:55:00 | AAPL | Stock | 3.8357 | 3.8429 | 3.835 | 3.8414 | 2342788.0 |
| 2007-05-11 09:56:00 | AAPL | Stock | 3.8418 | 3.8429 | 3.8364 | 3.8368 | 2312240.0 |
| 2007-05-11 09:57:00 | AAPL | Stock | 3.8371 | 3.8414 | 3.8368 | 3.8407 | 1211756.0 |
| 2007-05-11 09:58:00 | AAPL | Stock | 3.8411 | 3.8411 | 3.8343 | 3.8354 | 1398992.0 |
| 2007-05-11 09:59:00 | AAPL | Stock | 3.8354 | 3.8357 | 3.8286 | 3.8314 | 3223360.0 |
| 2007-05-11 10:00:00 | AAPL | Stock | 3.8318 | 3.8393 | 3.8307 | 3.8386 | 2019276.0 |
| 2007-05-11 10:01:00 | AAPL | Stock | 3.8389 | 3.8429 | 3.8379 | 3.8407 | 1707832.0 |
| 2007-05-11 10:02:00 | AAPL | Stock | 3.8407 | 3.845 | 3.8393 | 3.8436 | 3431092.0 |
| 2007-05-11 10:03:00 | AAPL | Stock | 3.8439 | 3.8443 | 3.8346 | 3.8364 | 2996252.0 |
| 2007-05-11 10:04:00 | AAPL | Stock | 3.8364 | 3.8393 | 3.8339 | 3.8343 | 3463152.0 |
| 2007-05-11 10:05:00 | AAPL | Stock | 3.8339 | 3.8343 | 3.8182 | 3.8187 | 6515040.0 |
| 2007-05-11 10:06:00 | AAPL | Stock | 3.8182 | 3.8225 | 3.8136 | 3.8214 | 5202484.0 |
| 2007-05-11 10:07:00 | AAPL | Stock | 3.8221 | 3.8264 | 3.8204 | 3.8211 | 2380224.0 |
| 2007-05-11 10:08:00 | AAPL | Stock | 3.8218 | 3.8261 | 3.8196 | 3.825 | 1950592.0 |
| 2007-05-11 10:09:00 | AAPL | Stock | 3.8254 | 3.8318 | 3.8254 | 3.8279 | 2130156.0 |
| 2007-05-11 10:10:00 | AAPL | Stock | 3.8279 | 3.8293 | 3.8268 | 3.8275 | 1621956.0 |
| 2007-05-11 10:11:00 | AAPL | Stock | 3.8275 | 3.8296 | 3.8257 | 3.8282 | 1599052.0 |
| 2007-05-11 10:12:00 | AAPL | Stock | 3.8286 | 3.8321 | 3.8282 | 3.8321 | 1439592.0 |
| 2007-05-11 10:13:00 | AAPL | Stock | 3.8314 | 3.8382 | 3.8314 | 3.8361 | 2235436.0 |
| 2007-05-11 10:14:00 | AAPL | Stock | 3.8357 | 3.8389 | 3.8357 | 3.8379 | 1583624.0 |
| 2007-05-11 10:15:00 | AAPL | Stock | 3.8385 | 3.8414 | 3.8371 | 3.8375 | 2216116.0 |
| 2007-05-11 10:16:00 | AAPL | Stock | 3.838 | 3.8418 | 3.8375 | 3.8393 | 1395968.0 |
| 2007-05-11 10:17:00 | AAPL | Stock | 3.84 | 3.8425 | 3.8393 | 3.8414 | 1783684.0 |
| 2007-05-11 10:18:00 | AAPL | Stock | 3.8418 | 3.8429 | 3.84 | 3.8421 | 1784720.0 |
| 2007-05-11 10:19:00 | AAPL | Stock | 3.8425 | 3.8425 | 3.8411 | 3.8411 | 1645448.0 |
| 2007-05-11 10:20:00 | AAPL | Stock | 3.8411 | 3.8429 | 3.8392 | 3.8396 | 2492028.0 |
| 2007-05-11 10:21:00 | AAPL | Stock | 3.84 | 3.8418 | 3.8371 | 3.8386 | 2119544.0 |
| 2007-05-11 10:22:00 | AAPL | Stock | 3.8389 | 3.8414 | 3.8375 | 3.8411 | 1752352.0 |
| 2007-05-11 10:23:00 | AAPL | Stock | 3.8411 | 3.8418 | 3.8389 | 3.8389 | 1219540.0 |
| 2007-05-11 10:24:00 | AAPL | Stock | 3.8393 | 3.8407 | 3.8386 | 3.8396 | 1595776.0 |
| 2007-05-11 10:25:00 | AAPL | Stock | 3.8396 | 3.8454 | 3.8396 | 3.8443 | 2174676.0 |
| 2007-05-11 10:26:00 | AAPL | Stock | 3.8446 | 3.8475 | 3.8418 | 3.8471 | 1319192.0 |
| 2007-05-11 10:27:00 | AAPL | Stock | 3.8471 | 3.8471 | 3.8439 | 3.8461 | 2188424.0 |
| 2007-05-11 10:28:00 | AAPL | Stock | 3.8461 | 3.8464 | 3.8461 | 3.8461 | 1618932.0 |
| 2007-05-11 10:29:00 | AAPL | Stock | 3.8461 | 3.8464 | 3.8446 | 3.8461 | 1356544.0 |
| 2007-05-11 10:30:00 | AAPL | Stock | 3.8461 | 3.8529 | 3.8461 | 3.8529 | 5197724.0 |
| 2007-05-11 10:31:00 | AAPL | Stock | 3.8514 | 3.8532 | 3.8489 | 3.8504 | 2777852.0 |
> showing 50 of 850,911 rows — these rows as CSV