PREVIEW / stock_1min / 2004-04-08
file: by_date/stock_1min/2004/2004-04-08.parquet size: 5.5 MB rows: 459,816 symbols: 1,442
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 |
|---|---|---|---|---|---|---|---|
| 2004-04-08 08:09:00 | AAPL | Stock | 0.498 | 0.498 | 0.498 | 0.498 | 22400.0 |
| 2004-04-08 08:11:00 | AAPL | Stock | 0.498 | 0.498 | 0.498 | 0.498 | 5600.0 |
| 2004-04-08 08:26:00 | AAPL | Stock | 0.5 | 0.5 | 0.5 | 0.5 | 5600.0 |
| 2004-04-08 08:27:00 | AAPL | Stock | 0.5018 | 0.5018 | 0.5 | 0.5 | 11200.0 |
| 2004-04-08 08:40:00 | AAPL | Stock | 0.4971 | 0.4971 | 0.4971 | 0.4971 | 5600.0 |
| 2004-04-08 08:47:00 | AAPL | Stock | 0.497 | 0.497 | 0.497 | 0.497 | 5600.0 |
| 2004-04-08 08:53:00 | AAPL | Stock | 0.498 | 0.498 | 0.4979 | 0.4979 | 39200.0 |
| 2004-04-08 08:54:00 | AAPL | Stock | 0.4982 | 0.4982 | 0.4982 | 0.4982 | 5600.0 |
| 2004-04-08 08:58:00 | AAPL | Stock | 0.4982 | 0.4982 | 0.4982 | 0.4982 | 5600.0 |
| 2004-04-08 09:01:00 | AAPL | Stock | 0.4988 | 0.4988 | 0.4988 | 0.4988 | 22400.0 |
| 2004-04-08 09:02:00 | AAPL | Stock | 0.4998 | 0.4998 | 0.4998 | 0.4998 | 22400.0 |
| 2004-04-08 09:08:00 | AAPL | Stock | 0.4991 | 0.4991 | 0.4991 | 0.4991 | 5600.0 |
| 2004-04-08 09:09:00 | AAPL | Stock | 0.4998 | 0.4998 | 0.4991 | 0.4991 | 39200.0 |
| 2004-04-08 09:10:00 | AAPL | Stock | 0.4991 | 0.4991 | 0.4991 | 0.4991 | 84000.0 |
| 2004-04-08 09:11:00 | AAPL | Stock | 0.4993 | 0.4993 | 0.4993 | 0.4993 | 28000.0 |
| 2004-04-08 09:12:00 | AAPL | Stock | 0.4993 | 0.4993 | 0.4991 | 0.4991 | 56000.0 |
| 2004-04-08 09:13:00 | AAPL | Stock | 0.4991 | 0.4998 | 0.4991 | 0.4998 | 61600.0 |
| 2004-04-08 09:14:00 | AAPL | Stock | 0.5 | 0.5 | 0.5 | 0.5 | 39200.0 |
| 2004-04-08 09:16:00 | AAPL | Stock | 0.5 | 0.5 | 0.5 | 0.5 | 330400.0 |
| 2004-04-08 09:20:00 | AAPL | Stock | 0.5 | 0.5 | 0.5 | 0.5 | 78400.0 |
| 2004-04-08 09:23:00 | AAPL | Stock | 0.4995 | 0.4995 | 0.4993 | 0.4993 | 44800.0 |
| 2004-04-08 09:24:00 | AAPL | Stock | 0.4995 | 0.4995 | 0.4995 | 0.4995 | 5600.0 |
| 2004-04-08 09:25:00 | AAPL | Stock | 0.4995 | 0.4995 | 0.4993 | 0.4993 | 89600.0 |
| 2004-04-08 09:26:00 | AAPL | Stock | 0.4984 | 0.4984 | 0.4984 | 0.4984 | 5600.0 |
| 2004-04-08 09:27:00 | AAPL | Stock | 0.4984 | 0.4984 | 0.4984 | 0.4984 | 44800.0 |
| 2004-04-08 09:29:00 | AAPL | Stock | 0.4979 | 0.4982 | 0.4955 | 0.4968 | 767200.0 |
| 2004-04-08 09:30:00 | AAPL | Stock | 0.4982 | 0.5 | 0.4961 | 0.4979 | 5668824.0 |
| 2004-04-08 09:31:00 | AAPL | Stock | 0.4991 | 0.5 | 0.4979 | 0.4984 | 4930632.0 |
| 2004-04-08 09:32:00 | AAPL | Stock | 0.4982 | 0.4993 | 0.4979 | 0.4979 | 1708224.0 |
| 2004-04-08 09:33:00 | AAPL | Stock | 0.4979 | 0.4998 | 0.4929 | 0.4948 | 6994400.0 |
| 2004-04-08 09:34:00 | AAPL | Stock | 0.4946 | 0.4982 | 0.4938 | 0.4963 | 7209664.0 |
| 2004-04-08 09:35:00 | AAPL | Stock | 0.4959 | 0.4964 | 0.4945 | 0.4961 | 4179448.0 |
| 2004-04-08 09:36:00 | AAPL | Stock | 0.4961 | 0.4961 | 0.4943 | 0.4943 | 959280.0 |
| 2004-04-08 09:37:00 | AAPL | Stock | 0.4948 | 0.495 | 0.4939 | 0.4943 | 268800.0 |
| 2004-04-08 09:38:00 | AAPL | Stock | 0.4946 | 0.4948 | 0.4941 | 0.4946 | 612080.0 |
| 2004-04-08 09:39:00 | AAPL | Stock | 0.4948 | 0.4948 | 0.4938 | 0.4939 | 2453136.0 |
| 2004-04-08 09:40:00 | AAPL | Stock | 0.4939 | 0.4948 | 0.4939 | 0.4941 | 706384.0 |
| 2004-04-08 09:41:00 | AAPL | Stock | 0.4945 | 0.4954 | 0.4945 | 0.495 | 525168.0 |
| 2004-04-08 09:42:00 | AAPL | Stock | 0.4948 | 0.4954 | 0.4948 | 0.4954 | 1129856.0 |
| 2004-04-08 09:43:00 | AAPL | Stock | 0.4954 | 0.4966 | 0.4952 | 0.4957 | 4510576.0 |
| 2004-04-08 09:44:00 | AAPL | Stock | 0.4959 | 0.4964 | 0.4945 | 0.4946 | 3831856.0 |
| 2004-04-08 09:45:00 | AAPL | Stock | 0.4946 | 0.4957 | 0.4946 | 0.4955 | 811664.0 |
| 2004-04-08 09:46:00 | AAPL | Stock | 0.4952 | 0.4961 | 0.4946 | 0.4946 | 795200.0 |
| 2004-04-08 09:47:00 | AAPL | Stock | 0.495 | 0.4954 | 0.4941 | 0.4946 | 1420440.0 |
| 2004-04-08 09:48:00 | AAPL | Stock | 0.4946 | 0.4961 | 0.4945 | 0.4948 | 870800.0 |
| 2004-04-08 09:49:00 | AAPL | Stock | 0.495 | 0.4955 | 0.4948 | 0.495 | 1517600.0 |
| 2004-04-08 09:50:00 | AAPL | Stock | 0.495 | 0.4955 | 0.4948 | 0.4954 | 817600.0 |
| 2004-04-08 09:51:00 | AAPL | Stock | 0.4954 | 0.4961 | 0.4954 | 0.4959 | 994000.0 |
| 2004-04-08 09:52:00 | AAPL | Stock | 0.4957 | 0.4959 | 0.4952 | 0.4954 | 465640.0 |
| 2004-04-08 09:53:00 | AAPL | Stock | 0.4954 | 0.4954 | 0.4946 | 0.4948 | 534800.0 |
> showing 50 of 459,816 rows — these rows as CSV