PREVIEW / stock_1min / 2008-01-17
file: by_date/stock_1min/2008/2008-01-17.parquet size: 13.1 MB rows: 1,049,087 symbols: 2,678
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-17 05:31:00 | AAPL | Stock | 5.75 | 5.75 | 5.75 | 5.75 | 12124.0 |
| 2008-01-17 05:39:00 | AAPL | Stock | 5.7679 | 5.7679 | 5.7679 | 5.7679 | 14000.0 |
| 2008-01-17 05:40:00 | AAPL | Stock | 5.7718 | 5.7718 | 5.7718 | 5.7718 | 8400.0 |
| 2008-01-17 06:21:00 | AAPL | Stock | 5.775 | 5.775 | 5.775 | 5.775 | 14000.0 |
| 2008-01-17 06:22:00 | AAPL | Stock | 5.75 | 5.75 | 5.75 | 5.75 | 16800.0 |
| 2008-01-17 06:31:00 | AAPL | Stock | 5.7729 | 5.7732 | 5.7729 | 5.7732 | 39200.0 |
| 2008-01-17 06:39:00 | AAPL | Stock | 5.7661 | 5.7661 | 5.7661 | 5.7661 | 25200.0 |
| 2008-01-17 06:42:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7589 | 5.7589 | 30800.0 |
| 2008-01-17 06:43:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7589 | 5.7589 | 81200.0 |
| 2008-01-17 06:46:00 | AAPL | Stock | 5.7589 | 5.7596 | 5.7536 | 5.7596 | 16800.0 |
| 2008-01-17 06:52:00 | AAPL | Stock | 5.7661 | 5.7661 | 5.7661 | 5.7661 | 15120.0 |
| 2008-01-17 06:53:00 | AAPL | Stock | 5.7661 | 5.7661 | 5.7661 | 5.7661 | 7000.0 |
| 2008-01-17 06:56:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7589 | 5.7589 | 5600.0 |
| 2008-01-17 06:58:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7589 | 5.7589 | 11200.0 |
| 2008-01-17 06:59:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7589 | 5.7589 | 2800.0 |
| 2008-01-17 07:01:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7536 | 5.7536 | 36400.0 |
| 2008-01-17 07:02:00 | AAPL | Stock | 5.7504 | 5.7504 | 5.7504 | 5.7504 | 2800.0 |
| 2008-01-17 07:03:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7589 | 5.7589 | 128800.0 |
| 2008-01-17 07:04:00 | AAPL | Stock | 5.75 | 5.75 | 5.75 | 5.75 | 42000.0 |
| 2008-01-17 07:05:00 | AAPL | Stock | 5.7571 | 5.7571 | 5.75 | 5.75 | 14000.0 |
| 2008-01-17 07:06:00 | AAPL | Stock | 5.75 | 5.755 | 5.7343 | 5.7343 | 130200.0 |
| 2008-01-17 07:07:00 | AAPL | Stock | 5.755 | 5.755 | 5.755 | 5.755 | 119560.0 |
| 2008-01-17 07:08:00 | AAPL | Stock | 5.755 | 5.755 | 5.755 | 5.755 | 2800.0 |
| 2008-01-17 07:10:00 | AAPL | Stock | 5.7546 | 5.7546 | 5.7546 | 5.7546 | 3416.0 |
| 2008-01-17 07:12:00 | AAPL | Stock | 5.7536 | 5.755 | 5.7536 | 5.755 | 22400.0 |
| 2008-01-17 07:13:00 | AAPL | Stock | 5.7546 | 5.755 | 5.7546 | 5.755 | 22400.0 |
| 2008-01-17 07:14:00 | AAPL | Stock | 5.75 | 5.7504 | 5.7357 | 5.75 | 51800.0 |
| 2008-01-17 07:15:00 | AAPL | Stock | 5.7486 | 5.75 | 5.7164 | 5.72 | 207200.0 |
| 2008-01-17 07:17:00 | AAPL | Stock | 5.7436 | 5.7461 | 5.7436 | 5.7461 | 82600.0 |
| 2008-01-17 07:18:00 | AAPL | Stock | 5.7179 | 5.7429 | 5.7179 | 5.7429 | 47600.0 |
| 2008-01-17 07:19:00 | AAPL | Stock | 5.7321 | 5.7393 | 5.7321 | 5.7393 | 120400.0 |
| 2008-01-17 07:20:00 | AAPL | Stock | 5.7425 | 5.7425 | 5.7425 | 5.7425 | 28000.0 |
| 2008-01-17 07:21:00 | AAPL | Stock | 5.7257 | 5.7389 | 5.7257 | 5.7389 | 50400.0 |
| 2008-01-17 07:23:00 | AAPL | Stock | 5.7268 | 5.7268 | 5.7268 | 5.7268 | 6300.0 |
| 2008-01-17 07:24:00 | AAPL | Stock | 5.7425 | 5.7425 | 5.7425 | 5.7425 | 2800.0 |
| 2008-01-17 07:25:00 | AAPL | Stock | 5.7418 | 5.7418 | 5.7418 | 5.7418 | 28000.0 |
| 2008-01-17 07:28:00 | AAPL | Stock | 5.7404 | 5.7404 | 5.7321 | 5.7321 | 11200.0 |
| 2008-01-17 07:30:00 | AAPL | Stock | 5.7318 | 5.7318 | 5.7268 | 5.7268 | 15400.0 |
| 2008-01-17 07:31:00 | AAPL | Stock | 5.7236 | 5.7236 | 5.7143 | 5.7143 | 336000.0 |
| 2008-01-17 07:32:00 | AAPL | Stock | 5.7118 | 5.7232 | 5.7118 | 5.7189 | 82460.0 |
| 2008-01-17 07:33:00 | AAPL | Stock | 5.7168 | 5.7168 | 5.7154 | 5.7154 | 26880.0 |
| 2008-01-17 07:34:00 | AAPL | Stock | 5.7218 | 5.7232 | 5.7214 | 5.7232 | 61600.0 |
| 2008-01-17 07:36:00 | AAPL | Stock | 5.73 | 5.73 | 5.73 | 5.73 | 5600.0 |
| 2008-01-17 07:37:00 | AAPL | Stock | 5.73 | 5.73 | 5.7221 | 5.7221 | 61068.0 |
| 2008-01-17 07:38:00 | AAPL | Stock | 5.7214 | 5.7232 | 5.7214 | 5.7232 | 66220.0 |
| 2008-01-17 07:39:00 | AAPL | Stock | 5.7214 | 5.7232 | 5.7214 | 5.7232 | 14000.0 |
| 2008-01-17 07:41:00 | AAPL | Stock | 5.7429 | 5.7429 | 5.7429 | 5.7429 | 2800.0 |
| 2008-01-17 07:43:00 | AAPL | Stock | 5.7407 | 5.7407 | 5.7357 | 5.7357 | 11200.0 |
| 2008-01-17 07:44:00 | AAPL | Stock | 5.7275 | 5.7404 | 5.7275 | 5.7404 | 20076.0 |
| 2008-01-17 07:45:00 | AAPL | Stock | 5.7393 | 5.7407 | 5.7393 | 5.7407 | 14000.0 |
> showing 50 of 1,049,087 rows — these rows as CSV