PREVIEW / stock_1min / 2007-08-08
file: by_date/stock_1min/2007/2007-08-08.parquet size: 14.7 MB rows: 1,151,935 symbols: 2,557
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-08 09:30:00 | AAPL | Stock | 4.8843 | 4.885 | 4.8618 | 4.8789 | 7706860.0 |
| 2007-08-08 09:31:00 | AAPL | Stock | 4.875 | 4.8871 | 4.863 | 4.8811 | 3564372.0 |
| 2007-08-08 09:32:00 | AAPL | Stock | 4.8779 | 4.8879 | 4.8779 | 4.8814 | 2966516.0 |
| 2007-08-08 09:33:00 | AAPL | Stock | 4.8818 | 4.8871 | 4.8571 | 4.8596 | 4263504.0 |
| 2007-08-08 09:34:00 | AAPL | Stock | 4.8607 | 4.8661 | 4.8421 | 4.8489 | 6393492.0 |
| 2007-08-08 09:35:00 | AAPL | Stock | 4.8561 | 4.8661 | 4.8421 | 4.8561 | 3626476.0 |
| 2007-08-08 09:36:00 | AAPL | Stock | 4.8557 | 4.8625 | 4.85 | 4.855 | 2895508.0 |
| 2007-08-08 09:37:00 | AAPL | Stock | 4.8561 | 4.8571 | 4.8482 | 4.8486 | 2914324.0 |
| 2007-08-08 09:38:00 | AAPL | Stock | 4.8493 | 4.8496 | 4.8393 | 4.8432 | 2676576.0 |
| 2007-08-08 09:39:00 | AAPL | Stock | 4.8432 | 4.8511 | 4.8329 | 4.8389 | 5343408.0 |
| 2007-08-08 09:40:00 | AAPL | Stock | 4.8411 | 4.8488 | 4.8389 | 4.8396 | 2270940.0 |
| 2007-08-08 09:41:00 | AAPL | Stock | 4.8407 | 4.8471 | 4.8261 | 4.8293 | 3018820.0 |
| 2007-08-08 09:42:00 | AAPL | Stock | 4.8307 | 4.84 | 4.8286 | 4.8392 | 2718128.0 |
| 2007-08-08 09:43:00 | AAPL | Stock | 4.8393 | 4.8396 | 4.8229 | 4.825 | 3209976.0 |
| 2007-08-08 09:44:00 | AAPL | Stock | 4.8254 | 4.8311 | 4.8132 | 4.8215 | 5210660.0 |
| 2007-08-08 09:45:00 | AAPL | Stock | 4.8218 | 4.8311 | 4.8207 | 4.8275 | 2805320.0 |
| 2007-08-08 09:46:00 | AAPL | Stock | 4.8286 | 4.8332 | 4.8239 | 4.8314 | 2939916.0 |
| 2007-08-08 09:47:00 | AAPL | Stock | 4.8316 | 4.8375 | 4.8275 | 4.8368 | 2844156.0 |
| 2007-08-08 09:48:00 | AAPL | Stock | 4.8366 | 4.8368 | 4.8304 | 4.8325 | 2549092.0 |
| 2007-08-08 09:49:00 | AAPL | Stock | 4.8321 | 4.8321 | 4.8236 | 4.8293 | 2222500.0 |
| 2007-08-08 09:50:00 | AAPL | Stock | 4.8286 | 4.84 | 4.8286 | 4.8314 | 3273004.0 |
| 2007-08-08 09:51:00 | AAPL | Stock | 4.8311 | 4.8357 | 4.8293 | 4.8304 | 1835428.0 |
| 2007-08-08 09:52:00 | AAPL | Stock | 4.8304 | 4.8357 | 4.8143 | 4.8246 | 4634252.0 |
| 2007-08-08 09:53:00 | AAPL | Stock | 4.8254 | 4.8286 | 4.8157 | 4.8164 | 3836056.0 |
| 2007-08-08 09:54:00 | AAPL | Stock | 4.8164 | 4.8175 | 4.8036 | 4.8104 | 5149060.0 |
| 2007-08-08 09:55:00 | AAPL | Stock | 4.8107 | 4.8193 | 4.8036 | 4.8168 | 4584356.0 |
| 2007-08-08 09:56:00 | AAPL | Stock | 4.8168 | 4.8175 | 4.8079 | 4.8125 | 1596756.0 |
| 2007-08-08 09:57:00 | AAPL | Stock | 4.8121 | 4.8125 | 4.7989 | 4.8025 | 2795072.0 |
| 2007-08-08 09:58:00 | AAPL | Stock | 4.8011 | 4.81 | 4.7989 | 4.8011 | 2850932.0 |
| 2007-08-08 09:59:00 | AAPL | Stock | 4.8007 | 4.8168 | 4.8004 | 4.8157 | 2881872.0 |
| 2007-08-08 10:00:00 | AAPL | Stock | 4.8157 | 4.8193 | 4.8125 | 4.8189 | 3056956.0 |
| 2007-08-08 10:01:00 | AAPL | Stock | 4.8189 | 4.8293 | 4.8175 | 4.8218 | 4322808.0 |
| 2007-08-08 10:02:00 | AAPL | Stock | 4.8221 | 4.8279 | 4.8214 | 4.8264 | 2687104.0 |
| 2007-08-08 10:03:00 | AAPL | Stock | 4.8264 | 4.8279 | 4.825 | 4.8257 | 2549680.0 |
| 2007-08-08 10:04:00 | AAPL | Stock | 4.8261 | 4.8325 | 4.8257 | 4.8282 | 2544836.0 |
| 2007-08-08 10:05:00 | AAPL | Stock | 4.8279 | 4.8311 | 4.8268 | 4.8293 | 1863260.0 |
| 2007-08-08 10:06:00 | AAPL | Stock | 4.8304 | 4.8314 | 4.8214 | 4.825 | 3263680.0 |
| 2007-08-08 10:07:00 | AAPL | Stock | 4.8243 | 4.8257 | 4.8175 | 4.8207 | 2148496.0 |
| 2007-08-08 10:08:00 | AAPL | Stock | 4.8207 | 4.8225 | 4.8164 | 4.8189 | 1573040.0 |
| 2007-08-08 10:09:00 | AAPL | Stock | 4.8186 | 4.8214 | 4.8071 | 4.8075 | 1944040.0 |
| 2007-08-08 10:10:00 | AAPL | Stock | 4.8079 | 4.8232 | 4.8075 | 4.8157 | 3274376.0 |
| 2007-08-08 10:11:00 | AAPL | Stock | 4.815 | 4.8176 | 4.8093 | 4.8121 | 2049040.0 |
| 2007-08-08 10:12:00 | AAPL | Stock | 4.8116 | 4.8193 | 4.8116 | 4.8146 | 1491504.0 |
| 2007-08-08 10:13:00 | AAPL | Stock | 4.8139 | 4.8186 | 4.8136 | 4.8146 | 1552432.0 |
| 2007-08-08 10:14:00 | AAPL | Stock | 4.8136 | 4.8214 | 4.8132 | 4.8207 | 1869644.0 |
| 2007-08-08 10:15:00 | AAPL | Stock | 4.8204 | 4.8282 | 4.8203 | 4.8214 | 2044504.0 |
| 2007-08-08 10:16:00 | AAPL | Stock | 4.8214 | 4.8282 | 4.8182 | 4.8243 | 1849344.0 |
| 2007-08-08 10:17:00 | AAPL | Stock | 4.8246 | 4.8286 | 4.8214 | 4.8271 | 2898280.0 |
| 2007-08-08 10:18:00 | AAPL | Stock | 4.8268 | 4.8279 | 4.8214 | 4.825 | 2098096.0 |
| 2007-08-08 10:19:00 | AAPL | Stock | 4.8225 | 4.825 | 4.8171 | 4.8186 | 2919308.0 |
> showing 50 of 1,151,935 rows — these rows as CSV