PREVIEW / stock_1min / 2004-03-31
file: by_date/stock_1min/2004/2004-03-31.parquet size: 5.9 MB rows: 496,353 symbols: 1,440
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-03-31 08:00:00 | AAPL | Stock | 0.4986 | 0.5 | 0.4986 | 0.5 | 44800.0 |
| 2004-03-31 08:09:00 | AAPL | Stock | 0.4991 | 0.4991 | 0.4982 | 0.4982 | 33600.0 |
| 2004-03-31 09:14:00 | AAPL | Stock | 0.4982 | 0.4982 | 0.4979 | 0.4979 | 22400.0 |
| 2004-03-31 09:29:00 | AAPL | Stock | 0.4977 | 0.4977 | 0.495 | 0.4964 | 462616.0 |
| 2004-03-31 09:30:00 | AAPL | Stock | 0.4975 | 0.4996 | 0.4961 | 0.4968 | 3456096.0 |
| 2004-03-31 09:31:00 | AAPL | Stock | 0.4977 | 0.4982 | 0.4966 | 0.4982 | 869120.0 |
| 2004-03-31 09:32:00 | AAPL | Stock | 0.498 | 0.4986 | 0.4966 | 0.497 | 1269520.0 |
| 2004-03-31 09:33:00 | AAPL | Stock | 0.4966 | 0.4977 | 0.4964 | 0.497 | 1163904.0 |
| 2004-03-31 09:34:00 | AAPL | Stock | 0.497 | 0.4973 | 0.4966 | 0.4973 | 220528.0 |
| 2004-03-31 09:35:00 | AAPL | Stock | 0.4971 | 0.4971 | 0.4966 | 0.4968 | 268800.0 |
| 2004-03-31 09:36:00 | AAPL | Stock | 0.497 | 0.4971 | 0.495 | 0.495 | 554232.0 |
| 2004-03-31 09:37:00 | AAPL | Stock | 0.4952 | 0.4952 | 0.4943 | 0.4952 | 728560.0 |
| 2004-03-31 09:38:00 | AAPL | Stock | 0.4952 | 0.4955 | 0.495 | 0.4954 | 551040.0 |
| 2004-03-31 09:39:00 | AAPL | Stock | 0.495 | 0.4957 | 0.4948 | 0.4955 | 526120.0 |
| 2004-03-31 09:40:00 | AAPL | Stock | 0.4954 | 0.4957 | 0.495 | 0.495 | 407008.0 |
| 2004-03-31 09:41:00 | AAPL | Stock | 0.4948 | 0.4959 | 0.4939 | 0.4955 | 469784.0 |
| 2004-03-31 09:42:00 | AAPL | Stock | 0.4952 | 0.4959 | 0.4945 | 0.4946 | 442960.0 |
| 2004-03-31 09:43:00 | AAPL | Stock | 0.4948 | 0.4963 | 0.4946 | 0.4959 | 521024.0 |
| 2004-03-31 09:44:00 | AAPL | Stock | 0.4959 | 0.4961 | 0.4959 | 0.4961 | 152880.0 |
| 2004-03-31 09:45:00 | AAPL | Stock | 0.4961 | 0.4963 | 0.4959 | 0.4961 | 298872.0 |
| 2004-03-31 09:46:00 | AAPL | Stock | 0.4963 | 0.4963 | 0.4959 | 0.4961 | 275520.0 |
| 2004-03-31 09:47:00 | AAPL | Stock | 0.4959 | 0.4961 | 0.4959 | 0.4959 | 427616.0 |
| 2004-03-31 09:48:00 | AAPL | Stock | 0.4959 | 0.4964 | 0.4959 | 0.4964 | 1196944.0 |
| 2004-03-31 09:49:00 | AAPL | Stock | 0.4964 | 0.498 | 0.4964 | 0.498 | 1602552.0 |
| 2004-03-31 09:50:00 | AAPL | Stock | 0.4982 | 0.4984 | 0.498 | 0.4982 | 1154160.0 |
| 2004-03-31 09:51:00 | AAPL | Stock | 0.4984 | 0.4991 | 0.4982 | 0.4989 | 2217544.0 |
| 2004-03-31 09:52:00 | AAPL | Stock | 0.4991 | 0.4993 | 0.4988 | 0.4989 | 1288112.0 |
| 2004-03-31 09:53:00 | AAPL | Stock | 0.4989 | 0.4991 | 0.498 | 0.4988 | 1004024.0 |
| 2004-03-31 09:54:00 | AAPL | Stock | 0.4986 | 0.4991 | 0.4986 | 0.4989 | 554064.0 |
| 2004-03-31 09:55:00 | AAPL | Stock | 0.4989 | 0.4989 | 0.4973 | 0.4986 | 3025456.0 |
| 2004-03-31 09:56:00 | AAPL | Stock | 0.4986 | 0.4986 | 0.4968 | 0.4968 | 255192.0 |
| 2004-03-31 09:57:00 | AAPL | Stock | 0.4968 | 0.4979 | 0.4963 | 0.4977 | 652400.0 |
| 2004-03-31 09:58:00 | AAPL | Stock | 0.4975 | 0.4984 | 0.4975 | 0.4979 | 430304.0 |
| 2004-03-31 09:59:00 | AAPL | Stock | 0.4979 | 0.4979 | 0.4975 | 0.4975 | 103600.0 |
| 2004-03-31 10:00:00 | AAPL | Stock | 0.4977 | 0.4977 | 0.4964 | 0.4964 | 771512.0 |
| 2004-03-31 10:01:00 | AAPL | Stock | 0.4966 | 0.497 | 0.4959 | 0.4959 | 704648.0 |
| 2004-03-31 10:02:00 | AAPL | Stock | 0.4959 | 0.4968 | 0.4957 | 0.4957 | 1693888.0 |
| 2004-03-31 10:03:00 | AAPL | Stock | 0.4957 | 0.4968 | 0.4954 | 0.4961 | 1341704.0 |
| 2004-03-31 10:04:00 | AAPL | Stock | 0.4961 | 0.497 | 0.4961 | 0.4968 | 1692152.0 |
| 2004-03-31 10:05:00 | AAPL | Stock | 0.4964 | 0.4968 | 0.4963 | 0.4963 | 591192.0 |
| 2004-03-31 10:06:00 | AAPL | Stock | 0.4963 | 0.4967 | 0.4955 | 0.4964 | 907088.0 |
| 2004-03-31 10:07:00 | AAPL | Stock | 0.4963 | 0.497 | 0.4955 | 0.4963 | 993216.0 |
| 2004-03-31 10:08:00 | AAPL | Stock | 0.4957 | 0.4959 | 0.495 | 0.495 | 487424.0 |
| 2004-03-31 10:09:00 | AAPL | Stock | 0.4952 | 0.4952 | 0.4945 | 0.4946 | 399504.0 |
| 2004-03-31 10:10:00 | AAPL | Stock | 0.4946 | 0.4948 | 0.4939 | 0.4943 | 1174208.0 |
| 2004-03-31 10:11:00 | AAPL | Stock | 0.4946 | 0.4946 | 0.4943 | 0.4945 | 131208.0 |
| 2004-03-31 10:12:00 | AAPL | Stock | 0.4946 | 0.4946 | 0.4941 | 0.4942 | 429128.0 |
| 2004-03-31 10:13:00 | AAPL | Stock | 0.4941 | 0.4963 | 0.4941 | 0.4957 | 807296.0 |
| 2004-03-31 10:14:00 | AAPL | Stock | 0.4955 | 0.4955 | 0.4941 | 0.4941 | 659232.0 |
| 2004-03-31 10:15:00 | AAPL | Stock | 0.4941 | 0.4952 | 0.4939 | 0.4952 | 700392.0 |
> showing 50 of 496,353 rows — these rows as CSV