PREVIEW / stock_1min / 2004-04-23
file: by_date/stock_1min/2004/2004-04-23.parquet size: 5.7 MB rows: 480,634 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-23 08:00:00 | AAPL | Stock | 0.4979 | 0.4979 | 0.4979 | 0.4979 | 28000.0 |
| 2004-04-23 08:01:00 | AAPL | Stock | 0.4964 | 0.4964 | 0.4963 | 0.4964 | 151200.0 |
| 2004-04-23 08:16:00 | AAPL | Stock | 0.4964 | 0.4964 | 0.4964 | 0.4964 | 5600.0 |
| 2004-04-23 08:39:00 | AAPL | Stock | 0.4959 | 0.4963 | 0.4959 | 0.4963 | 56000.0 |
| 2004-04-23 08:42:00 | AAPL | Stock | 0.4963 | 0.4964 | 0.4963 | 0.4964 | 173824.0 |
| 2004-04-23 08:47:00 | AAPL | Stock | 0.4964 | 0.4964 | 0.4964 | 0.4964 | 50176.0 |
| 2004-04-23 09:01:00 | AAPL | Stock | 0.4964 | 0.4964 | 0.4964 | 0.4964 | 112000.0 |
| 2004-04-23 09:23:00 | AAPL | Stock | 0.4959 | 0.4959 | 0.4959 | 0.4959 | 16800.0 |
| 2004-04-23 09:29:00 | AAPL | Stock | 0.4964 | 0.4964 | 0.4955 | 0.4955 | 89600.0 |
| 2004-04-23 09:30:00 | AAPL | Stock | 0.4946 | 0.4963 | 0.4929 | 0.4936 | 2834832.0 |
| 2004-04-23 09:31:00 | AAPL | Stock | 0.4955 | 0.4955 | 0.4916 | 0.4921 | 1644272.0 |
| 2004-04-23 09:32:00 | AAPL | Stock | 0.4921 | 0.4932 | 0.4916 | 0.4925 | 1118712.0 |
| 2004-04-23 09:33:00 | AAPL | Stock | 0.4927 | 0.4932 | 0.4918 | 0.4918 | 1199632.0 |
| 2004-04-23 09:34:00 | AAPL | Stock | 0.4921 | 0.4923 | 0.4907 | 0.4907 | 1878576.0 |
| 2004-04-23 09:35:00 | AAPL | Stock | 0.4909 | 0.4929 | 0.4907 | 0.4916 | 1483832.0 |
| 2004-04-23 09:36:00 | AAPL | Stock | 0.4921 | 0.4946 | 0.4921 | 0.4929 | 1007440.0 |
| 2004-04-23 09:37:00 | AAPL | Stock | 0.4929 | 0.4934 | 0.4905 | 0.4913 | 868336.0 |
| 2004-04-23 09:38:00 | AAPL | Stock | 0.4914 | 0.4927 | 0.4913 | 0.4918 | 341600.0 |
| 2004-04-23 09:39:00 | AAPL | Stock | 0.4916 | 0.4927 | 0.4914 | 0.4927 | 348264.0 |
| 2004-04-23 09:40:00 | AAPL | Stock | 0.4925 | 0.4939 | 0.4907 | 0.4939 | 3004456.0 |
| 2004-04-23 09:41:00 | AAPL | Stock | 0.4939 | 0.4961 | 0.4938 | 0.4939 | 1110088.0 |
| 2004-04-23 09:42:00 | AAPL | Stock | 0.4945 | 0.4979 | 0.4945 | 0.4979 | 828688.0 |
| 2004-04-23 09:43:00 | AAPL | Stock | 0.498 | 0.4986 | 0.4979 | 0.4984 | 2023224.0 |
| 2004-04-23 09:44:00 | AAPL | Stock | 0.4982 | 0.4984 | 0.4961 | 0.4982 | 546560.0 |
| 2004-04-23 09:45:00 | AAPL | Stock | 0.4984 | 0.4996 | 0.4982 | 0.4996 | 1069040.0 |
| 2004-04-23 09:46:00 | AAPL | Stock | 0.4996 | 0.5 | 0.4988 | 0.4991 | 1781192.0 |
| 2004-04-23 09:47:00 | AAPL | Stock | 0.4993 | 0.4998 | 0.4989 | 0.4996 | 668472.0 |
| 2004-04-23 09:48:00 | AAPL | Stock | 0.4996 | 0.4998 | 0.4991 | 0.4991 | 1291920.0 |
| 2004-04-23 09:49:00 | AAPL | Stock | 0.4996 | 0.4996 | 0.4977 | 0.498 | 1892240.0 |
| 2004-04-23 09:50:00 | AAPL | Stock | 0.4984 | 0.4984 | 0.4977 | 0.4984 | 1002344.0 |
| 2004-04-23 09:51:00 | AAPL | Stock | 0.4984 | 0.4986 | 0.4977 | 0.498 | 363272.0 |
| 2004-04-23 09:52:00 | AAPL | Stock | 0.498 | 0.4993 | 0.4979 | 0.4986 | 723128.0 |
| 2004-04-23 09:53:00 | AAPL | Stock | 0.4988 | 0.4991 | 0.4984 | 0.4986 | 666400.0 |
| 2004-04-23 09:54:00 | AAPL | Stock | 0.4986 | 0.4988 | 0.4984 | 0.4988 | 603680.0 |
| 2004-04-23 09:55:00 | AAPL | Stock | 0.4986 | 0.4986 | 0.4984 | 0.4984 | 408800.0 |
| 2004-04-23 09:56:00 | AAPL | Stock | 0.4982 | 0.4986 | 0.4977 | 0.4982 | 1159648.0 |
| 2004-04-23 09:57:00 | AAPL | Stock | 0.4984 | 0.4998 | 0.4984 | 0.4998 | 574560.0 |
| 2004-04-23 09:58:00 | AAPL | Stock | 0.4998 | 0.4998 | 0.4996 | 0.4998 | 240408.0 |
| 2004-04-23 09:59:00 | AAPL | Stock | 0.4996 | 0.4996 | 0.4986 | 0.4986 | 137200.0 |
| 2004-04-23 10:00:00 | AAPL | Stock | 0.4989 | 0.4995 | 0.4989 | 0.4993 | 481600.0 |
| 2004-04-23 10:01:00 | AAPL | Stock | 0.4989 | 0.4989 | 0.4984 | 0.4986 | 408800.0 |
| 2004-04-23 10:02:00 | AAPL | Stock | 0.4986 | 0.4986 | 0.4971 | 0.4973 | 715624.0 |
| 2004-04-23 10:03:00 | AAPL | Stock | 0.4973 | 0.4988 | 0.4966 | 0.4977 | 1478400.0 |
| 2004-04-23 10:04:00 | AAPL | Stock | 0.4979 | 0.4988 | 0.4975 | 0.498 | 784000.0 |
| 2004-04-23 10:05:00 | AAPL | Stock | 0.498 | 0.4984 | 0.4977 | 0.4977 | 502544.0 |
| 2004-04-23 10:06:00 | AAPL | Stock | 0.4977 | 0.498 | 0.4977 | 0.4977 | 959280.0 |
| 2004-04-23 10:07:00 | AAPL | Stock | 0.4977 | 0.4979 | 0.4977 | 0.4979 | 403200.0 |
| 2004-04-23 10:08:00 | AAPL | Stock | 0.4979 | 0.4982 | 0.4977 | 0.4982 | 694400.0 |
| 2004-04-23 10:09:00 | AAPL | Stock | 0.4982 | 0.4982 | 0.498 | 0.498 | 348376.0 |
| 2004-04-23 10:10:00 | AAPL | Stock | 0.498 | 0.4982 | 0.498 | 0.498 | 919744.0 |
> showing 50 of 480,634 rows — these rows as CSV