PREVIEW / stock_1min / 2010-10-13
file: by_date/stock_1min/2010/2010-10-13.parquet size: 13.2 MB rows: 997,871 symbols: 2,844
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-10-13 04:25:00 | AAPL | Stock | 10.7257 | 10.7257 | 10.7257 | 10.7257 | 4340.0 |
| 2010-10-13 04:32:00 | AAPL | Stock | 10.7339 | 10.7339 | 10.7339 | 10.7339 | 5600.0 |
| 2010-10-13 05:19:00 | AAPL | Stock | 10.7679 | 10.7679 | 10.7679 | 10.7679 | 4200.0 |
| 2010-10-13 06:10:00 | AAPL | Stock | 10.7621 | 10.7621 | 10.7621 | 10.7621 | 9884.0 |
| 2010-10-13 07:01:00 | AAPL | Stock | 10.7596 | 10.7596 | 10.7596 | 10.7596 | 2800.0 |
| 2010-10-13 07:03:00 | AAPL | Stock | 10.7357 | 10.7357 | 10.7286 | 10.7286 | 9800.0 |
| 2010-10-13 07:04:00 | AAPL | Stock | 10.7321 | 10.7321 | 10.7321 | 10.7321 | 6160.0 |
| 2010-10-13 07:05:00 | AAPL | Stock | 10.7332 | 10.7332 | 10.7332 | 10.7332 | 2800.0 |
| 2010-10-13 07:06:00 | AAPL | Stock | 10.7321 | 10.7321 | 10.7321 | 10.7321 | 2800.0 |
| 2010-10-13 07:07:00 | AAPL | Stock | 10.7321 | 10.7321 | 10.7286 | 10.7286 | 27440.0 |
| 2010-10-13 07:08:00 | AAPL | Stock | 10.7304 | 10.7304 | 10.7304 | 10.7304 | 2800.0 |
| 2010-10-13 07:09:00 | AAPL | Stock | 10.7254 | 10.7254 | 10.7254 | 10.7254 | 2800.0 |
| 2010-10-13 07:12:00 | AAPL | Stock | 10.7218 | 10.725 | 10.7218 | 10.725 | 11144.0 |
| 2010-10-13 07:13:00 | AAPL | Stock | 10.715 | 10.715 | 10.7143 | 10.715 | 15400.0 |
| 2010-10-13 07:19:00 | AAPL | Stock | 10.725 | 10.725 | 10.725 | 10.725 | 47600.0 |
| 2010-10-13 07:20:00 | AAPL | Stock | 10.725 | 10.725 | 10.7179 | 10.7179 | 25200.0 |
| 2010-10-13 07:23:00 | AAPL | Stock | 10.7246 | 10.725 | 10.7246 | 10.725 | 24920.0 |
| 2010-10-13 07:27:00 | AAPL | Stock | 10.7268 | 10.7268 | 10.7268 | 10.7268 | 2800.0 |
| 2010-10-13 07:29:00 | AAPL | Stock | 10.7304 | 10.7304 | 10.7304 | 10.7304 | 12880.0 |
| 2010-10-13 07:30:00 | AAPL | Stock | 10.7354 | 10.7354 | 10.7354 | 10.7354 | 2800.0 |
| 2010-10-13 07:32:00 | AAPL | Stock | 10.7354 | 10.7354 | 10.7354 | 10.7354 | 5600.0 |
| 2010-10-13 07:33:00 | AAPL | Stock | 10.7354 | 10.7354 | 10.7321 | 10.7321 | 19992.0 |
| 2010-10-13 07:34:00 | AAPL | Stock | 10.7354 | 10.75 | 10.7339 | 10.7357 | 77420.0 |
| 2010-10-13 07:35:00 | AAPL | Stock | 10.7321 | 10.7346 | 10.7321 | 10.7346 | 19600.0 |
| 2010-10-13 07:36:00 | AAPL | Stock | 10.7321 | 10.7321 | 10.7321 | 10.7321 | 8400.0 |
| 2010-10-13 07:37:00 | AAPL | Stock | 10.7357 | 10.7357 | 10.7357 | 10.7357 | 2800.0 |
| 2010-10-13 07:38:00 | AAPL | Stock | 10.7307 | 10.7321 | 10.7286 | 10.7286 | 25200.0 |
| 2010-10-13 07:39:00 | AAPL | Stock | 10.7289 | 10.7289 | 10.7268 | 10.7268 | 32256.0 |
| 2010-10-13 07:40:00 | AAPL | Stock | 10.7268 | 10.7286 | 10.7268 | 10.7286 | 8764.0 |
| 2010-10-13 07:41:00 | AAPL | Stock | 10.7357 | 10.7357 | 10.7293 | 10.7314 | 50400.0 |
| 2010-10-13 07:44:00 | AAPL | Stock | 10.7357 | 10.7357 | 10.7357 | 10.7357 | 2800.0 |
| 2010-10-13 07:45:00 | AAPL | Stock | 10.7357 | 10.7357 | 10.7314 | 10.7314 | 19656.0 |
| 2010-10-13 07:46:00 | AAPL | Stock | 10.7354 | 10.7446 | 10.7354 | 10.7446 | 119644.0 |
| 2010-10-13 07:47:00 | AAPL | Stock | 10.7446 | 10.7493 | 10.7446 | 10.7493 | 43400.0 |
| 2010-10-13 07:48:00 | AAPL | Stock | 10.7493 | 10.7575 | 10.7493 | 10.7575 | 32200.0 |
| 2010-10-13 07:49:00 | AAPL | Stock | 10.7557 | 10.7639 | 10.7557 | 10.7639 | 126700.0 |
| 2010-10-13 07:50:00 | AAPL | Stock | 10.7639 | 10.7743 | 10.7639 | 10.7679 | 136220.0 |
| 2010-10-13 07:51:00 | AAPL | Stock | 10.7679 | 10.7679 | 10.7618 | 10.7618 | 129500.0 |
| 2010-10-13 07:52:00 | AAPL | Stock | 10.7621 | 10.7621 | 10.7621 | 10.7621 | 54740.0 |
| 2010-10-13 07:53:00 | AAPL | Stock | 10.7693 | 10.7725 | 10.7643 | 10.7725 | 52920.0 |
| 2010-10-13 07:54:00 | AAPL | Stock | 10.7696 | 10.7696 | 10.7657 | 10.7679 | 53508.0 |
| 2010-10-13 07:56:00 | AAPL | Stock | 10.7625 | 10.7625 | 10.7586 | 10.7586 | 85316.0 |
| 2010-10-13 07:57:00 | AAPL | Stock | 10.7586 | 10.7586 | 10.7471 | 10.7471 | 120008.0 |
| 2010-10-13 07:58:00 | AAPL | Stock | 10.7479 | 10.75 | 10.7468 | 10.75 | 44800.0 |
| 2010-10-13 07:59:00 | AAPL | Stock | 10.7493 | 10.7493 | 10.7468 | 10.7468 | 11200.0 |
| 2010-10-13 08:00:00 | AAPL | Stock | 10.7468 | 10.7607 | 10.725 | 10.7536 | 441896.0 |
| 2010-10-13 08:01:00 | AAPL | Stock | 10.7589 | 10.7607 | 10.7564 | 10.7596 | 182448.0 |
| 2010-10-13 08:02:00 | AAPL | Stock | 10.7564 | 10.7629 | 10.7554 | 10.7618 | 290864.0 |
| 2010-10-13 08:03:00 | AAPL | Stock | 10.76 | 10.7643 | 10.7557 | 10.7571 | 122500.0 |
| 2010-10-13 08:04:00 | AAPL | Stock | 10.7571 | 10.7714 | 10.7571 | 10.7654 | 327432.0 |
> showing 50 of 997,871 rows — these rows as CSV