PREVIEW / stock_1min / 2004-02-18
file: by_date/stock_1min/2004/2004-02-18.parquet size: 5.8 MB rows: 471,633 symbols: 1,416
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-02-18 08:49:00 | AAPL | Stock | 0.4143 | 0.4143 | 0.4143 | 0.4143 | 5600.0 |
| 2004-02-18 08:55:00 | AAPL | Stock | 0.4138 | 0.4145 | 0.4138 | 0.4145 | 448000.0 |
| 2004-02-18 08:56:00 | AAPL | Stock | 0.4138 | 0.4141 | 0.4138 | 0.4141 | 381080.0 |
| 2004-02-18 09:04:00 | AAPL | Stock | 0.4139 | 0.4139 | 0.4139 | 0.4139 | 140000.0 |
| 2004-02-18 09:05:00 | AAPL | Stock | 0.4139 | 0.4139 | 0.4139 | 0.4139 | 16800.0 |
| 2004-02-18 09:19:00 | AAPL | Stock | 0.412 | 0.412 | 0.4109 | 0.4109 | 100800.0 |
| 2004-02-18 09:23:00 | AAPL | Stock | 0.4111 | 0.4113 | 0.4111 | 0.4113 | 84000.0 |
| 2004-02-18 09:25:00 | AAPL | Stock | 0.4118 | 0.4118 | 0.4118 | 0.4118 | 16800.0 |
| 2004-02-18 09:28:00 | AAPL | Stock | 0.4125 | 0.4132 | 0.4125 | 0.4132 | 89600.0 |
| 2004-02-18 09:29:00 | AAPL | Stock | 0.4125 | 0.4127 | 0.4114 | 0.4121 | 484512.0 |
| 2004-02-18 09:30:00 | AAPL | Stock | 0.4139 | 0.4139 | 0.4116 | 0.412 | 3444616.0 |
| 2004-02-18 09:31:00 | AAPL | Stock | 0.4118 | 0.4127 | 0.4116 | 0.4118 | 2916088.0 |
| 2004-02-18 09:32:00 | AAPL | Stock | 0.4118 | 0.4127 | 0.4116 | 0.4116 | 585424.0 |
| 2004-02-18 09:33:00 | AAPL | Stock | 0.4116 | 0.4127 | 0.4116 | 0.4123 | 827176.0 |
| 2004-02-18 09:34:00 | AAPL | Stock | 0.4125 | 0.4134 | 0.4125 | 0.4125 | 749168.0 |
| 2004-02-18 09:35:00 | AAPL | Stock | 0.4125 | 0.4132 | 0.4118 | 0.4132 | 1016344.0 |
| 2004-02-18 09:36:00 | AAPL | Stock | 0.4132 | 0.4132 | 0.4118 | 0.4121 | 7272160.0 |
| 2004-02-18 09:37:00 | AAPL | Stock | 0.4125 | 0.4125 | 0.4121 | 0.4125 | 705488.0 |
| 2004-02-18 09:38:00 | AAPL | Stock | 0.4123 | 0.4134 | 0.4123 | 0.4132 | 159824.0 |
| 2004-02-18 09:39:00 | AAPL | Stock | 0.4136 | 0.4136 | 0.412 | 0.412 | 1246336.0 |
| 2004-02-18 09:40:00 | AAPL | Stock | 0.412 | 0.413 | 0.4118 | 0.412 | 579208.0 |
| 2004-02-18 09:41:00 | AAPL | Stock | 0.412 | 0.4127 | 0.4118 | 0.4126 | 1168272.0 |
| 2004-02-18 09:42:00 | AAPL | Stock | 0.4127 | 0.4132 | 0.4125 | 0.4125 | 552776.0 |
| 2004-02-18 09:43:00 | AAPL | Stock | 0.412 | 0.4127 | 0.412 | 0.4127 | 1069600.0 |
| 2004-02-18 09:44:00 | AAPL | Stock | 0.4127 | 0.4131 | 0.4125 | 0.4125 | 585200.0 |
| 2004-02-18 09:45:00 | AAPL | Stock | 0.4125 | 0.4129 | 0.4125 | 0.4125 | 386400.0 |
| 2004-02-18 09:46:00 | AAPL | Stock | 0.4127 | 0.4134 | 0.4125 | 0.4134 | 586376.0 |
| 2004-02-18 09:47:00 | AAPL | Stock | 0.4134 | 0.4139 | 0.4132 | 0.4139 | 815752.0 |
| 2004-02-18 09:48:00 | AAPL | Stock | 0.4134 | 0.4136 | 0.4132 | 0.4136 | 223664.0 |
| 2004-02-18 09:49:00 | AAPL | Stock | 0.4138 | 0.4138 | 0.4132 | 0.4132 | 5808264.0 |
| 2004-02-18 09:50:00 | AAPL | Stock | 0.4136 | 0.4139 | 0.4136 | 0.4139 | 126000.0 |
| 2004-02-18 09:51:00 | AAPL | Stock | 0.4139 | 0.4139 | 0.4136 | 0.4138 | 717640.0 |
| 2004-02-18 09:52:00 | AAPL | Stock | 0.4138 | 0.4138 | 0.413 | 0.4134 | 439824.0 |
| 2004-02-18 09:53:00 | AAPL | Stock | 0.4136 | 0.4138 | 0.413 | 0.4136 | 1049160.0 |
| 2004-02-18 09:54:00 | AAPL | Stock | 0.4139 | 0.4139 | 0.4132 | 0.4132 | 143696.0 |
| 2004-02-18 09:55:00 | AAPL | Stock | 0.4131 | 0.4134 | 0.4129 | 0.4134 | 515648.0 |
| 2004-02-18 09:56:00 | AAPL | Stock | 0.4134 | 0.4134 | 0.4132 | 0.4134 | 310464.0 |
| 2004-02-18 09:57:00 | AAPL | Stock | 0.4134 | 0.4134 | 0.413 | 0.4134 | 730632.0 |
| 2004-02-18 09:58:00 | AAPL | Stock | 0.4134 | 0.4138 | 0.413 | 0.4138 | 277760.0 |
| 2004-02-18 09:59:00 | AAPL | Stock | 0.4138 | 0.4139 | 0.4138 | 0.4139 | 251720.0 |
| 2004-02-18 10:00:00 | AAPL | Stock | 0.4141 | 0.4143 | 0.4139 | 0.4143 | 572152.0 |
| 2004-02-18 10:01:00 | AAPL | Stock | 0.4139 | 0.4146 | 0.4139 | 0.4145 | 672000.0 |
| 2004-02-18 10:02:00 | AAPL | Stock | 0.4145 | 0.4148 | 0.4143 | 0.4148 | 532000.0 |
| 2004-02-18 10:03:00 | AAPL | Stock | 0.4146 | 0.4152 | 0.4145 | 0.4152 | 730856.0 |
| 2004-02-18 10:04:00 | AAPL | Stock | 0.4152 | 0.4152 | 0.4146 | 0.415 | 2480968.0 |
| 2004-02-18 10:05:00 | AAPL | Stock | 0.415 | 0.4152 | 0.415 | 0.415 | 616000.0 |
| 2004-02-18 10:06:00 | AAPL | Stock | 0.415 | 0.4155 | 0.415 | 0.4153 | 1793008.0 |
| 2004-02-18 10:07:00 | AAPL | Stock | 0.4154 | 0.4159 | 0.4154 | 0.4155 | 326200.0 |
| 2004-02-18 10:08:00 | AAPL | Stock | 0.4159 | 0.4168 | 0.4159 | 0.4168 | 465248.0 |
| 2004-02-18 10:09:00 | AAPL | Stock | 0.4168 | 0.4173 | 0.4157 | 0.4164 | 2530472.0 |
> showing 50 of 471,633 rows — these rows as CSV