PREVIEW / stock_1min / 2007-10-08
file: by_date/stock_1min/2007/2007-10-08.parquet size: 10.7 MB rows: 877,301 symbols: 2,538
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-10-08 05:40:00 | AAPL | Stock | 5.8014 | 5.8014 | 5.8014 | 5.8014 | 11200.0 |
| 2007-10-08 05:45:00 | AAPL | Stock | 5.7875 | 5.7875 | 5.7875 | 5.7875 | 28000.0 |
| 2007-10-08 05:46:00 | AAPL | Stock | 5.7875 | 5.7875 | 5.7875 | 5.7875 | 42000.0 |
| 2007-10-08 07:02:00 | AAPL | Stock | 5.7796 | 5.7796 | 5.7782 | 5.7782 | 58800.0 |
| 2007-10-08 07:03:00 | AAPL | Stock | 5.7946 | 5.7946 | 5.7946 | 5.7946 | 2800.0 |
| 2007-10-08 07:07:00 | AAPL | Stock | 5.7986 | 5.7986 | 5.7936 | 5.7986 | 28000.0 |
| 2007-10-08 07:14:00 | AAPL | Stock | 5.7929 | 5.7929 | 5.7929 | 5.7929 | 2800.0 |
| 2007-10-08 07:17:00 | AAPL | Stock | 5.8214 | 5.8214 | 5.7986 | 5.8207 | 39200.0 |
| 2007-10-08 07:21:00 | AAPL | Stock | 5.7982 | 5.7982 | 5.7982 | 5.7982 | 11200.0 |
| 2007-10-08 07:30:00 | AAPL | Stock | 5.7982 | 5.7982 | 5.7982 | 5.7982 | 2800.0 |
| 2007-10-08 07:41:00 | AAPL | Stock | 5.8079 | 5.8079 | 5.8079 | 5.8079 | 28000.0 |
| 2007-10-08 07:44:00 | AAPL | Stock | 5.8057 | 5.8061 | 5.8057 | 5.8061 | 14000.0 |
| 2007-10-08 07:45:00 | AAPL | Stock | 5.8061 | 5.8071 | 5.8061 | 5.8071 | 39200.0 |
| 2007-10-08 07:49:00 | AAPL | Stock | 5.8114 | 5.8114 | 5.8036 | 5.8036 | 5600.0 |
| 2007-10-08 07:50:00 | AAPL | Stock | 5.8036 | 5.8036 | 5.8036 | 5.8036 | 25200.0 |
| 2007-10-08 07:58:00 | AAPL | Stock | 5.8036 | 5.8036 | 5.8036 | 5.8036 | 11200.0 |
| 2007-10-08 07:59:00 | AAPL | Stock | 5.8071 | 5.8071 | 5.8036 | 5.8036 | 5600.0 |
| 2007-10-08 08:00:00 | AAPL | Stock | 5.8 | 5.8336 | 5.7982 | 5.8214 | 531608.0 |
| 2007-10-08 08:01:00 | AAPL | Stock | 5.8304 | 5.8304 | 5.8268 | 5.8268 | 89600.0 |
| 2007-10-08 08:02:00 | AAPL | Stock | 5.8286 | 5.8357 | 5.8239 | 5.8304 | 443884.0 |
| 2007-10-08 08:03:00 | AAPL | Stock | 5.8332 | 5.8371 | 5.8268 | 5.8325 | 453292.0 |
| 2007-10-08 08:04:00 | AAPL | Stock | 5.8357 | 5.8418 | 5.8357 | 5.8418 | 227612.0 |
| 2007-10-08 08:05:00 | AAPL | Stock | 5.8446 | 5.8454 | 5.8393 | 5.8393 | 188076.0 |
| 2007-10-08 08:06:00 | AAPL | Stock | 5.8389 | 5.8393 | 5.8361 | 5.8389 | 49980.0 |
| 2007-10-08 08:07:00 | AAPL | Stock | 5.8361 | 5.8389 | 5.8339 | 5.8375 | 141204.0 |
| 2007-10-08 08:08:00 | AAPL | Stock | 5.8343 | 5.8371 | 5.8339 | 5.8368 | 61600.0 |
| 2007-10-08 08:09:00 | AAPL | Stock | 5.8368 | 5.8371 | 5.8286 | 5.8336 | 268576.0 |
| 2007-10-08 08:10:00 | AAPL | Stock | 5.8339 | 5.8389 | 5.8304 | 5.8375 | 60620.0 |
| 2007-10-08 08:11:00 | AAPL | Stock | 5.8361 | 5.8361 | 5.8336 | 5.8336 | 65016.0 |
| 2007-10-08 08:12:00 | AAPL | Stock | 5.8361 | 5.84 | 5.8361 | 5.84 | 42000.0 |
| 2007-10-08 08:13:00 | AAPL | Stock | 5.8418 | 5.8518 | 5.8411 | 5.8471 | 246176.0 |
| 2007-10-08 08:14:00 | AAPL | Stock | 5.8511 | 5.8511 | 5.8425 | 5.8482 | 199360.0 |
| 2007-10-08 08:15:00 | AAPL | Stock | 5.8482 | 5.8486 | 5.8461 | 5.8461 | 71512.0 |
| 2007-10-08 08:16:00 | AAPL | Stock | 5.8479 | 5.8479 | 5.8457 | 5.8457 | 84784.0 |
| 2007-10-08 08:17:00 | AAPL | Stock | 5.8446 | 5.8471 | 5.8446 | 5.8471 | 237160.0 |
| 2007-10-08 08:18:00 | AAPL | Stock | 5.8457 | 5.8464 | 5.8457 | 5.8464 | 11200.0 |
| 2007-10-08 08:19:00 | AAPL | Stock | 5.8464 | 5.8464 | 5.8461 | 5.8464 | 9800.0 |
| 2007-10-08 08:20:00 | AAPL | Stock | 5.8432 | 5.8464 | 5.8396 | 5.84 | 117600.0 |
| 2007-10-08 08:21:00 | AAPL | Stock | 5.8475 | 5.8479 | 5.84 | 5.84 | 78820.0 |
| 2007-10-08 08:22:00 | AAPL | Stock | 5.8404 | 5.8429 | 5.84 | 5.8425 | 94220.0 |
| 2007-10-08 08:23:00 | AAPL | Stock | 5.8461 | 5.8464 | 5.8429 | 5.8436 | 37380.0 |
| 2007-10-08 08:24:00 | AAPL | Stock | 5.8436 | 5.8457 | 5.8432 | 5.8446 | 57400.0 |
| 2007-10-08 08:25:00 | AAPL | Stock | 5.845 | 5.8461 | 5.8446 | 5.8457 | 62860.0 |
| 2007-10-08 08:26:00 | AAPL | Stock | 5.8446 | 5.8464 | 5.8425 | 5.8425 | 115528.0 |
| 2007-10-08 08:27:00 | AAPL | Stock | 5.8432 | 5.8446 | 5.8429 | 5.8446 | 44800.0 |
| 2007-10-08 08:28:00 | AAPL | Stock | 5.8457 | 5.8493 | 5.8443 | 5.8475 | 175896.0 |
| 2007-10-08 08:29:00 | AAPL | Stock | 5.8454 | 5.8454 | 5.8446 | 5.8446 | 44800.0 |
| 2007-10-08 08:30:00 | AAPL | Stock | 5.8446 | 5.8464 | 5.8446 | 5.8446 | 172340.0 |
| 2007-10-08 08:31:00 | AAPL | Stock | 5.8446 | 5.8446 | 5.8429 | 5.8429 | 53228.0 |
| 2007-10-08 08:32:00 | AAPL | Stock | 5.8429 | 5.8446 | 5.8429 | 5.8446 | 43260.0 |
> showing 50 of 877,301 rows — these rows as CSV