PREVIEW / stock_1min / 2008-09-26
file: by_date/stock_1min/2008/2008-09-26.parquet size: 12.2 MB rows: 987,928 symbols: 2,705
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-09-26 05:12:00 | AAPL | Stock | 4.5643 | 4.5643 | 4.5429 | 4.5429 | 5600.0 |
| 2008-09-26 05:14:00 | AAPL | Stock | 4.5429 | 4.5429 | 4.5429 | 4.5429 | 2800.0 |
| 2008-09-26 06:05:00 | AAPL | Stock | 4.5536 | 4.5536 | 4.5536 | 4.5536 | 2800.0 |
| 2008-09-26 06:17:00 | AAPL | Stock | 4.5554 | 4.5554 | 4.5554 | 4.5554 | 2800.0 |
| 2008-09-26 06:21:00 | AAPL | Stock | 4.5414 | 4.5414 | 4.5357 | 4.5357 | 14000.0 |
| 2008-09-26 06:39:00 | AAPL | Stock | 4.5357 | 4.5357 | 4.5357 | 4.5357 | 2800.0 |
| 2008-09-26 06:56:00 | AAPL | Stock | 4.5054 | 4.5054 | 4.5054 | 4.5054 | 28000.0 |
| 2008-09-26 06:58:00 | AAPL | Stock | 4.5054 | 4.5054 | 4.5039 | 4.5039 | 16800.0 |
| 2008-09-26 06:59:00 | AAPL | Stock | 4.4714 | 4.5 | 4.4714 | 4.5 | 59108.0 |
| 2008-09-26 07:00:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 177660.0 |
| 2008-09-26 07:02:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 2800.0 |
| 2008-09-26 07:04:00 | AAPL | Stock | 4.4761 | 4.4761 | 4.4761 | 4.4761 | 2800.0 |
| 2008-09-26 07:08:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 14000.0 |
| 2008-09-26 07:10:00 | AAPL | Stock | 4.4832 | 4.4832 | 4.4832 | 4.4832 | 2800.0 |
| 2008-09-26 07:14:00 | AAPL | Stock | 4.4911 | 4.5 | 4.4911 | 4.5 | 26600.0 |
| 2008-09-26 07:18:00 | AAPL | Stock | 4.4911 | 4.4929 | 4.4911 | 4.4911 | 14000.0 |
| 2008-09-26 07:19:00 | AAPL | Stock | 4.4911 | 4.4911 | 4.4911 | 4.4911 | 2800.0 |
| 2008-09-26 07:20:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4764 | 4.4764 | 39200.0 |
| 2008-09-26 07:22:00 | AAPL | Stock | 4.4957 | 4.4957 | 4.4957 | 4.4957 | 2800.0 |
| 2008-09-26 07:24:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 8120.0 |
| 2008-09-26 07:26:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 2800.0 |
| 2008-09-26 07:27:00 | AAPL | Stock | 4.4839 | 4.4911 | 4.4839 | 4.4911 | 8400.0 |
| 2008-09-26 07:29:00 | AAPL | Stock | 4.5 | 4.5 | 4.4993 | 4.5 | 27748.0 |
| 2008-09-26 07:35:00 | AAPL | Stock | 4.5 | 4.5 | 4.4993 | 4.5 | 93800.0 |
| 2008-09-26 07:36:00 | AAPL | Stock | 4.5 | 4.5 | 4.4993 | 4.4996 | 81200.0 |
| 2008-09-26 07:37:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 2800.0 |
| 2008-09-26 07:39:00 | AAPL | Stock | 4.5 | 4.5 | 4.495 | 4.495 | 23380.0 |
| 2008-09-26 07:41:00 | AAPL | Stock | 4.4996 | 4.5 | 4.4996 | 4.5 | 44520.0 |
| 2008-09-26 07:42:00 | AAPL | Stock | 4.5 | 4.5 | 4.4964 | 4.4964 | 30800.0 |
| 2008-09-26 07:43:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 25844.0 |
| 2008-09-26 07:44:00 | AAPL | Stock | 4.4996 | 4.5 | 4.4964 | 4.4964 | 30800.0 |
| 2008-09-26 07:45:00 | AAPL | Stock | 4.5 | 4.5 | 4.4918 | 4.5 | 76580.0 |
| 2008-09-26 07:46:00 | AAPL | Stock | 4.5 | 4.5 | 4.4964 | 4.4964 | 12600.0 |
| 2008-09-26 07:47:00 | AAPL | Stock | 4.4964 | 4.4964 | 4.4964 | 4.4964 | 2800.0 |
| 2008-09-26 07:48:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 14000.0 |
| 2008-09-26 07:49:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 2800.0 |
| 2008-09-26 07:50:00 | AAPL | Stock | 4.4989 | 4.4996 | 4.4989 | 4.4996 | 16100.0 |
| 2008-09-26 07:52:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 137732.0 |
| 2008-09-26 07:54:00 | AAPL | Stock | 4.4868 | 4.4868 | 4.4825 | 4.4825 | 36400.0 |
| 2008-09-26 07:55:00 | AAPL | Stock | 4.4764 | 4.4821 | 4.4764 | 4.4821 | 30800.0 |
| 2008-09-26 07:56:00 | AAPL | Stock | 4.4943 | 4.4943 | 4.4943 | 4.4943 | 5600.0 |
| 2008-09-26 08:00:00 | AAPL | Stock | 4.4825 | 4.5 | 4.4757 | 4.4943 | 333732.0 |
| 2008-09-26 08:01:00 | AAPL | Stock | 4.5 | 4.5 | 4.4929 | 4.4989 | 53200.0 |
| 2008-09-26 08:02:00 | AAPL | Stock | 4.4993 | 4.5036 | 4.4932 | 4.5 | 114184.0 |
| 2008-09-26 08:03:00 | AAPL | Stock | 4.5 | 4.5 | 4.4911 | 4.4911 | 45752.0 |
| 2008-09-26 08:04:00 | AAPL | Stock | 4.4832 | 4.4843 | 4.4832 | 4.4839 | 34160.0 |
| 2008-09-26 08:05:00 | AAPL | Stock | 4.4921 | 4.4921 | 4.4768 | 4.4768 | 126084.0 |
| 2008-09-26 08:06:00 | AAPL | Stock | 4.4771 | 4.4782 | 4.4643 | 4.4643 | 520716.0 |
| 2008-09-26 08:07:00 | AAPL | Stock | 4.4571 | 4.4664 | 4.4518 | 4.4643 | 68880.0 |
| 2008-09-26 08:08:00 | AAPL | Stock | 4.4732 | 4.475 | 4.4614 | 4.4675 | 120400.0 |
> showing 50 of 987,928 rows — these rows as CSV