PREVIEW / stock_1min / 2011-09-01
file: by_date/stock_1min/2011/2011-09-01.parquet size: 13.5 MB rows: 1,020,727 symbols: 2,822
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-01 04:46:00 | AAPL | Stock | 13.7511 | 13.7511 | 13.7511 | 13.7511 | 2800.0 |
| 2011-09-01 07:01:00 | AAPL | Stock | 13.7454 | 13.7454 | 13.7454 | 13.7454 | 5600.0 |
| 2011-09-01 07:06:00 | AAPL | Stock | 13.7536 | 13.7536 | 13.7536 | 13.7536 | 2800.0 |
| 2011-09-01 07:14:00 | AAPL | Stock | 13.7414 | 13.7414 | 13.7414 | 13.7414 | 2800.0 |
| 2011-09-01 07:17:00 | AAPL | Stock | 13.7361 | 13.7364 | 13.7343 | 13.7343 | 8400.0 |
| 2011-09-01 07:27:00 | AAPL | Stock | 13.7404 | 13.7496 | 13.7404 | 13.7493 | 39200.0 |
| 2011-09-01 07:28:00 | AAPL | Stock | 13.7493 | 13.75 | 13.7493 | 13.75 | 19600.0 |
| 2011-09-01 07:29:00 | AAPL | Stock | 13.7504 | 13.7604 | 13.7504 | 13.7604 | 5600.0 |
| 2011-09-01 07:32:00 | AAPL | Stock | 13.7582 | 13.7582 | 13.7582 | 13.7582 | 2800.0 |
| 2011-09-01 07:33:00 | AAPL | Stock | 13.7661 | 13.7664 | 13.7661 | 13.7664 | 5600.0 |
| 2011-09-01 07:35:00 | AAPL | Stock | 13.7561 | 13.7561 | 13.7561 | 13.7561 | 2800.0 |
| 2011-09-01 07:37:00 | AAPL | Stock | 13.75 | 13.75 | 13.75 | 13.75 | 2800.0 |
| 2011-09-01 07:41:00 | AAPL | Stock | 13.75 | 13.75 | 13.75 | 13.75 | 8400.0 |
| 2011-09-01 07:46:00 | AAPL | Stock | 13.7571 | 13.7571 | 13.7571 | 13.7571 | 14000.0 |
| 2011-09-01 07:48:00 | AAPL | Stock | 13.7536 | 13.7536 | 13.7536 | 13.7536 | 14000.0 |
| 2011-09-01 07:49:00 | AAPL | Stock | 13.7564 | 13.7571 | 13.7564 | 13.7571 | 14000.0 |
| 2011-09-01 07:56:00 | AAPL | Stock | 13.7621 | 13.7621 | 13.75 | 13.75 | 28028.0 |
| 2011-09-01 07:58:00 | AAPL | Stock | 13.7432 | 13.7471 | 13.7432 | 13.7471 | 5600.0 |
| 2011-09-01 08:00:00 | AAPL | Stock | 13.7532 | 13.7571 | 13.7439 | 13.7439 | 159768.0 |
| 2011-09-01 08:01:00 | AAPL | Stock | 13.7446 | 13.7446 | 13.7414 | 13.7414 | 12600.0 |
| 2011-09-01 08:02:00 | AAPL | Stock | 13.7368 | 13.7368 | 13.7368 | 13.7368 | 14000.0 |
| 2011-09-01 08:03:00 | AAPL | Stock | 13.7379 | 13.7421 | 13.7354 | 13.7421 | 28000.0 |
| 2011-09-01 08:05:00 | AAPL | Stock | 13.7357 | 13.7357 | 13.7286 | 13.7357 | 73836.0 |
| 2011-09-01 08:06:00 | AAPL | Stock | 13.7264 | 13.7264 | 13.7264 | 13.7264 | 11200.0 |
| 2011-09-01 08:07:00 | AAPL | Stock | 13.7236 | 13.7321 | 13.7236 | 13.7254 | 14000.0 |
| 2011-09-01 08:08:00 | AAPL | Stock | 13.7271 | 13.7271 | 13.7271 | 13.7271 | 2800.0 |
| 2011-09-01 08:09:00 | AAPL | Stock | 13.7229 | 13.7279 | 13.7229 | 13.7279 | 5600.0 |
| 2011-09-01 08:10:00 | AAPL | Stock | 13.7321 | 13.7321 | 13.7282 | 13.7321 | 80192.0 |
| 2011-09-01 08:11:00 | AAPL | Stock | 13.7321 | 13.7357 | 13.7321 | 13.7357 | 5600.0 |
| 2011-09-01 08:12:00 | AAPL | Stock | 13.7357 | 13.7357 | 13.7325 | 13.7357 | 14000.0 |
| 2011-09-01 08:14:00 | AAPL | Stock | 13.7418 | 13.7439 | 13.7393 | 13.7393 | 44800.0 |
| 2011-09-01 08:15:00 | AAPL | Stock | 13.745 | 13.745 | 13.745 | 13.745 | 2800.0 |
| 2011-09-01 08:16:00 | AAPL | Stock | 13.7393 | 13.7393 | 13.7393 | 13.7393 | 13160.0 |
| 2011-09-01 08:17:00 | AAPL | Stock | 13.7339 | 13.7375 | 13.7339 | 13.7375 | 6440.0 |
| 2011-09-01 08:18:00 | AAPL | Stock | 13.7425 | 13.7489 | 13.7414 | 13.7468 | 47600.0 |
| 2011-09-01 08:19:00 | AAPL | Stock | 13.7489 | 13.7571 | 13.7418 | 13.7504 | 106568.0 |
| 2011-09-01 08:20:00 | AAPL | Stock | 13.7568 | 13.7625 | 13.7568 | 13.7607 | 84140.0 |
| 2011-09-01 08:21:00 | AAPL | Stock | 13.7521 | 13.7571 | 13.7521 | 13.7571 | 34356.0 |
| 2011-09-01 08:22:00 | AAPL | Stock | 13.7557 | 13.7625 | 13.755 | 13.7625 | 19600.0 |
| 2011-09-01 08:23:00 | AAPL | Stock | 13.7664 | 13.7679 | 13.7596 | 13.7671 | 67396.0 |
| 2011-09-01 08:24:00 | AAPL | Stock | 13.7664 | 13.7671 | 13.7664 | 13.7671 | 5600.0 |
| 2011-09-01 08:25:00 | AAPL | Stock | 13.7611 | 13.7611 | 13.7596 | 13.7596 | 8400.0 |
| 2011-09-01 08:26:00 | AAPL | Stock | 13.7618 | 13.7618 | 13.7589 | 13.7589 | 30800.0 |
| 2011-09-01 08:27:00 | AAPL | Stock | 13.7607 | 13.7607 | 13.7607 | 13.7607 | 10920.0 |
| 2011-09-01 08:28:00 | AAPL | Stock | 13.7643 | 13.7643 | 13.7643 | 13.7643 | 11200.0 |
| 2011-09-01 08:29:00 | AAPL | Stock | 13.7643 | 13.7711 | 13.7618 | 13.7618 | 33376.0 |
| 2011-09-01 08:30:00 | AAPL | Stock | 13.76 | 13.7746 | 13.75 | 13.755 | 126000.0 |
| 2011-09-01 08:31:00 | AAPL | Stock | 13.7561 | 13.7643 | 13.7521 | 13.7521 | 21700.0 |
| 2011-09-01 08:32:00 | AAPL | Stock | 13.7593 | 13.7754 | 13.7529 | 13.775 | 118580.0 |
| 2011-09-01 08:33:00 | AAPL | Stock | 13.7686 | 13.7686 | 13.7579 | 13.7671 | 42000.0 |
> showing 50 of 1,020,727 rows — these rows as CSV