PREVIEW / stock_1min / 2010-06-18
file: by_date/stock_1min/2010/2010-06-18.parquet size: 12.4 MB rows: 947,865 symbols: 2,824
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-18 04:34:00 | AAPL | Stock | 9.68 | 9.68 | 9.68 | 9.68 | 2800.0 |
| 2010-06-18 04:37:00 | AAPL | Stock | 9.6807 | 9.6807 | 9.6786 | 9.6786 | 16800.0 |
| 2010-06-18 04:40:00 | AAPL | Stock | 9.6732 | 9.6732 | 9.6732 | 9.6732 | 2800.0 |
| 2010-06-18 04:43:00 | AAPL | Stock | 9.6611 | 9.6611 | 9.6611 | 9.6611 | 2912.0 |
| 2010-06-18 04:44:00 | AAPL | Stock | 9.6682 | 9.6682 | 9.6682 | 9.6682 | 2800.0 |
| 2010-06-18 05:18:00 | AAPL | Stock | 9.6732 | 9.6732 | 9.6682 | 9.6682 | 8008.0 |
| 2010-06-18 05:24:00 | AAPL | Stock | 9.6939 | 9.6943 | 9.6939 | 9.6943 | 22400.0 |
| 2010-06-18 06:34:00 | AAPL | Stock | 9.7086 | 9.7086 | 9.7086 | 9.7086 | 2800.0 |
| 2010-06-18 06:37:00 | AAPL | Stock | 9.7086 | 9.7086 | 9.7086 | 9.7086 | 5600.0 |
| 2010-06-18 07:00:00 | AAPL | Stock | 9.7146 | 9.7146 | 9.7146 | 9.7146 | 10360.0 |
| 2010-06-18 07:01:00 | AAPL | Stock | 9.7146 | 9.7146 | 9.7146 | 9.7146 | 3640.0 |
| 2010-06-18 07:03:00 | AAPL | Stock | 9.7293 | 9.7311 | 9.7293 | 9.7311 | 30800.0 |
| 2010-06-18 07:04:00 | AAPL | Stock | 9.7314 | 9.7314 | 9.7311 | 9.7311 | 30800.0 |
| 2010-06-18 07:05:00 | AAPL | Stock | 9.7393 | 9.7464 | 9.7393 | 9.7464 | 56000.0 |
| 2010-06-18 07:06:00 | AAPL | Stock | 9.7421 | 9.7429 | 9.7375 | 9.7375 | 30800.0 |
| 2010-06-18 07:07:00 | AAPL | Stock | 9.72 | 9.72 | 9.72 | 9.72 | 18340.0 |
| 2010-06-18 07:08:00 | AAPL | Stock | 9.7414 | 9.7418 | 9.7411 | 9.7418 | 56000.0 |
| 2010-06-18 07:10:00 | AAPL | Stock | 9.7375 | 9.7375 | 9.7375 | 9.7375 | 2800.0 |
| 2010-06-18 07:11:00 | AAPL | Stock | 9.7214 | 9.7214 | 9.7204 | 9.7204 | 33600.0 |
| 2010-06-18 07:12:00 | AAPL | Stock | 9.7321 | 9.7321 | 9.7214 | 9.7229 | 42000.0 |
| 2010-06-18 07:14:00 | AAPL | Stock | 9.7311 | 9.7318 | 9.7311 | 9.7318 | 12936.0 |
| 2010-06-18 07:15:00 | AAPL | Stock | 9.7336 | 9.7336 | 9.7336 | 9.7336 | 5600.0 |
| 2010-06-18 07:17:00 | AAPL | Stock | 9.7225 | 9.7225 | 9.7225 | 9.7225 | 19600.0 |
| 2010-06-18 07:19:00 | AAPL | Stock | 9.725 | 9.725 | 9.7246 | 9.725 | 14000.0 |
| 2010-06-18 07:20:00 | AAPL | Stock | 9.7286 | 9.7286 | 9.7286 | 9.7286 | 2800.0 |
| 2010-06-18 07:21:00 | AAPL | Stock | 9.7314 | 9.7343 | 9.7314 | 9.7339 | 53200.0 |
| 2010-06-18 07:22:00 | AAPL | Stock | 9.735 | 9.735 | 9.7232 | 9.7332 | 98000.0 |
| 2010-06-18 07:23:00 | AAPL | Stock | 9.7321 | 9.7321 | 9.7321 | 9.7321 | 8400.0 |
| 2010-06-18 07:24:00 | AAPL | Stock | 9.7393 | 9.7436 | 9.7379 | 9.7379 | 78400.0 |
| 2010-06-18 07:25:00 | AAPL | Stock | 9.7411 | 9.7418 | 9.7321 | 9.7375 | 159600.0 |
| 2010-06-18 07:26:00 | AAPL | Stock | 9.7375 | 9.7375 | 9.7375 | 9.7375 | 14000.0 |
| 2010-06-18 07:29:00 | AAPL | Stock | 9.7393 | 9.7414 | 9.7393 | 9.7414 | 56000.0 |
| 2010-06-18 07:31:00 | AAPL | Stock | 9.7393 | 9.7393 | 9.7393 | 9.7393 | 5600.0 |
| 2010-06-18 07:32:00 | AAPL | Stock | 9.7411 | 9.7411 | 9.7411 | 9.7411 | 33180.0 |
| 2010-06-18 07:34:00 | AAPL | Stock | 9.7379 | 9.7418 | 9.7379 | 9.7418 | 5600.0 |
| 2010-06-18 07:35:00 | AAPL | Stock | 9.7411 | 9.7411 | 9.7411 | 9.7411 | 2800.0 |
| 2010-06-18 07:36:00 | AAPL | Stock | 9.7411 | 9.7429 | 9.7411 | 9.7429 | 75712.0 |
| 2010-06-18 07:37:00 | AAPL | Stock | 9.7446 | 9.7496 | 9.7446 | 9.745 | 212800.0 |
| 2010-06-18 07:38:00 | AAPL | Stock | 9.7482 | 9.7496 | 9.7482 | 9.7496 | 56000.0 |
| 2010-06-18 07:39:00 | AAPL | Stock | 9.7514 | 9.7629 | 9.7514 | 9.7629 | 50400.0 |
| 2010-06-18 07:40:00 | AAPL | Stock | 9.7646 | 9.7679 | 9.7611 | 9.7611 | 40600.0 |
| 2010-06-18 07:41:00 | AAPL | Stock | 9.7596 | 9.7625 | 9.7589 | 9.7625 | 85288.0 |
| 2010-06-18 07:42:00 | AAPL | Stock | 9.7639 | 9.7668 | 9.7639 | 9.7661 | 19320.0 |
| 2010-06-18 07:43:00 | AAPL | Stock | 9.7657 | 9.7657 | 9.7593 | 9.7593 | 22680.0 |
| 2010-06-18 07:44:00 | AAPL | Stock | 9.7643 | 9.7643 | 9.7643 | 9.7643 | 4760.0 |
| 2010-06-18 07:45:00 | AAPL | Stock | 9.7607 | 9.7625 | 9.7589 | 9.7589 | 19600.0 |
| 2010-06-18 07:46:00 | AAPL | Stock | 9.7589 | 9.7589 | 9.7589 | 9.7589 | 8820.0 |
| 2010-06-18 07:47:00 | AAPL | Stock | 9.7607 | 9.7696 | 9.7607 | 9.7696 | 51800.0 |
| 2010-06-18 07:48:00 | AAPL | Stock | 9.7746 | 9.7768 | 9.7629 | 9.7629 | 19880.0 |
| 2010-06-18 07:49:00 | AAPL | Stock | 9.7664 | 9.7668 | 9.7661 | 9.7664 | 64400.0 |
> showing 50 of 947,865 rows — these rows as CSV