PREVIEW / stock_1min / 2009-07-27
file: by_date/stock_1min/2009/2009-07-27.parquet size: 12.5 MB rows: 953,850 symbols: 2,723
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-27 07:00:00 | AAPL | Stock | 5.7511 | 5.7511 | 5.7511 | 5.7511 | 8400.0 |
| 2009-07-27 07:07:00 | AAPL | Stock | 5.7607 | 5.7607 | 5.7607 | 5.7607 | 11200.0 |
| 2009-07-27 07:14:00 | AAPL | Stock | 5.7629 | 5.7629 | 5.7629 | 5.7629 | 2800.0 |
| 2009-07-27 07:28:00 | AAPL | Stock | 5.7596 | 5.7596 | 5.7596 | 5.7596 | 28000.0 |
| 2009-07-27 07:30:00 | AAPL | Stock | 5.7514 | 5.7514 | 5.7504 | 5.7507 | 46900.0 |
| 2009-07-27 07:31:00 | AAPL | Stock | 5.7493 | 5.7493 | 5.7464 | 5.7464 | 46060.0 |
| 2009-07-27 07:40:00 | AAPL | Stock | 5.7464 | 5.7464 | 5.7464 | 5.7464 | 16800.0 |
| 2009-07-27 07:41:00 | AAPL | Stock | 5.7471 | 5.7471 | 5.7464 | 5.7464 | 11200.0 |
| 2009-07-27 07:42:00 | AAPL | Stock | 5.7532 | 5.7675 | 5.7532 | 5.7675 | 5600.0 |
| 2009-07-27 07:43:00 | AAPL | Stock | 5.7504 | 5.7504 | 5.7504 | 5.7504 | 14000.0 |
| 2009-07-27 07:51:00 | AAPL | Stock | 5.7486 | 5.7486 | 5.7486 | 5.7486 | 14000.0 |
| 2009-07-27 07:55:00 | AAPL | Stock | 5.7493 | 5.7493 | 5.7493 | 5.7493 | 8400.0 |
| 2009-07-27 07:56:00 | AAPL | Stock | 5.7446 | 5.7486 | 5.7446 | 5.7486 | 5600.0 |
| 2009-07-27 07:58:00 | AAPL | Stock | 5.7493 | 5.7493 | 5.7493 | 5.7493 | 2800.0 |
| 2009-07-27 07:59:00 | AAPL | Stock | 5.7464 | 5.7464 | 5.7454 | 5.7464 | 11200.0 |
| 2009-07-27 08:00:00 | AAPL | Stock | 5.7493 | 5.7504 | 5.7429 | 5.7464 | 488712.0 |
| 2009-07-27 08:01:00 | AAPL | Stock | 5.7486 | 5.7489 | 5.7446 | 5.7457 | 109200.0 |
| 2009-07-27 08:02:00 | AAPL | Stock | 5.7464 | 5.7475 | 5.7443 | 5.7443 | 271320.0 |
| 2009-07-27 08:03:00 | AAPL | Stock | 5.7439 | 5.7439 | 5.7393 | 5.7429 | 37940.0 |
| 2009-07-27 08:04:00 | AAPL | Stock | 5.7429 | 5.7446 | 5.7382 | 5.7382 | 50400.0 |
| 2009-07-27 08:05:00 | AAPL | Stock | 5.7382 | 5.7382 | 5.7375 | 5.7375 | 62160.0 |
| 2009-07-27 08:06:00 | AAPL | Stock | 5.7375 | 5.7382 | 5.7375 | 5.7375 | 14000.0 |
| 2009-07-27 08:07:00 | AAPL | Stock | 5.7389 | 5.7389 | 5.7371 | 5.7371 | 11200.0 |
| 2009-07-27 08:08:00 | AAPL | Stock | 5.7375 | 5.7375 | 5.7332 | 5.7336 | 48860.0 |
| 2009-07-27 08:09:00 | AAPL | Stock | 5.7336 | 5.7357 | 5.7336 | 5.7357 | 8400.0 |
| 2009-07-27 08:11:00 | AAPL | Stock | 5.7375 | 5.7407 | 5.7375 | 5.7379 | 30380.0 |
| 2009-07-27 08:12:00 | AAPL | Stock | 5.7379 | 5.7393 | 5.7357 | 5.7375 | 52192.0 |
| 2009-07-27 08:14:00 | AAPL | Stock | 5.7386 | 5.7396 | 5.7386 | 5.7396 | 8400.0 |
| 2009-07-27 08:15:00 | AAPL | Stock | 5.7404 | 5.7429 | 5.7404 | 5.7418 | 56000.0 |
| 2009-07-27 08:18:00 | AAPL | Stock | 5.7418 | 5.7418 | 5.7418 | 5.7418 | 8400.0 |
| 2009-07-27 08:19:00 | AAPL | Stock | 5.7418 | 5.7421 | 5.7418 | 5.7418 | 39200.0 |
| 2009-07-27 08:20:00 | AAPL | Stock | 5.7429 | 5.7439 | 5.7429 | 5.7439 | 5600.0 |
| 2009-07-27 08:21:00 | AAPL | Stock | 5.7439 | 5.7439 | 5.7411 | 5.7411 | 25900.0 |
| 2009-07-27 08:22:00 | AAPL | Stock | 5.7429 | 5.7432 | 5.7418 | 5.7418 | 22400.0 |
| 2009-07-27 08:23:00 | AAPL | Stock | 5.7418 | 5.7436 | 5.7418 | 5.7436 | 5600.0 |
| 2009-07-27 08:24:00 | AAPL | Stock | 5.7432 | 5.7454 | 5.7432 | 5.7439 | 36260.0 |
| 2009-07-27 08:25:00 | AAPL | Stock | 5.7446 | 5.7446 | 5.7439 | 5.7439 | 26040.0 |
| 2009-07-27 08:26:00 | AAPL | Stock | 5.7429 | 5.7443 | 5.7321 | 5.7321 | 163660.0 |
| 2009-07-27 08:27:00 | AAPL | Stock | 5.7382 | 5.7386 | 5.7336 | 5.7336 | 8400.0 |
| 2009-07-27 08:28:00 | AAPL | Stock | 5.7382 | 5.7421 | 5.7379 | 5.7379 | 16800.0 |
| 2009-07-27 08:29:00 | AAPL | Stock | 5.7407 | 5.7407 | 5.7357 | 5.7375 | 36960.0 |
| 2009-07-27 08:30:00 | AAPL | Stock | 5.7386 | 5.7386 | 5.7386 | 5.7386 | 2800.0 |
| 2009-07-27 08:32:00 | AAPL | Stock | 5.7404 | 5.7411 | 5.7375 | 5.7411 | 26040.0 |
| 2009-07-27 08:34:00 | AAPL | Stock | 5.7382 | 5.7382 | 5.7382 | 5.7382 | 2800.0 |
| 2009-07-27 08:35:00 | AAPL | Stock | 5.7379 | 5.7379 | 5.7321 | 5.7321 | 102200.0 |
| 2009-07-27 08:36:00 | AAPL | Stock | 5.7311 | 5.7311 | 5.7304 | 5.7304 | 5600.0 |
| 2009-07-27 08:37:00 | AAPL | Stock | 5.73 | 5.7304 | 5.7271 | 5.7271 | 36400.0 |
| 2009-07-27 08:38:00 | AAPL | Stock | 5.7275 | 5.7275 | 5.7254 | 5.7257 | 53200.0 |
| 2009-07-27 08:39:00 | AAPL | Stock | 5.7254 | 5.7257 | 5.7214 | 5.725 | 113512.0 |
| 2009-07-27 08:40:00 | AAPL | Stock | 5.725 | 5.725 | 5.7204 | 5.725 | 83328.0 |
> showing 50 of 953,850 rows — these rows as CSV