PREVIEW / stock_1min / 2009-07-31
file: by_date/stock_1min/2009/2009-07-31.parquet size: 12.6 MB rows: 956,695 symbols: 2,731
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-31 07:05:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8393 | 5.8393 | 5572.0 |
| 2009-07-31 07:25:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8393 | 5.8393 | 3024.0 |
| 2009-07-31 07:34:00 | AAPL | Stock | 5.8339 | 5.8339 | 5.8339 | 5.8339 | 2800.0 |
| 2009-07-31 07:42:00 | AAPL | Stock | 5.8286 | 5.8286 | 5.8286 | 5.8286 | 27720.0 |
| 2009-07-31 07:44:00 | AAPL | Stock | 5.8289 | 5.8289 | 5.8289 | 5.8289 | 5600.0 |
| 2009-07-31 07:47:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8393 | 5.8393 | 10808.0 |
| 2009-07-31 07:53:00 | AAPL | Stock | 5.8418 | 5.8418 | 5.8418 | 5.8418 | 5600.0 |
| 2009-07-31 07:58:00 | AAPL | Stock | 5.8425 | 5.8425 | 5.8425 | 5.8425 | 2800.0 |
| 2009-07-31 07:59:00 | AAPL | Stock | 5.8425 | 5.8425 | 5.8425 | 5.8425 | 2800.0 |
| 2009-07-31 08:00:00 | AAPL | Stock | 5.8218 | 5.8286 | 5.8214 | 5.8286 | 62160.0 |
| 2009-07-31 08:01:00 | AAPL | Stock | 5.8257 | 5.8257 | 5.8221 | 5.825 | 26488.0 |
| 2009-07-31 08:02:00 | AAPL | Stock | 5.825 | 5.825 | 5.8218 | 5.8225 | 33600.0 |
| 2009-07-31 08:03:00 | AAPL | Stock | 5.8214 | 5.8214 | 5.8214 | 5.8214 | 19600.0 |
| 2009-07-31 08:05:00 | AAPL | Stock | 5.8214 | 5.8214 | 5.8214 | 5.8214 | 2940.0 |
| 2009-07-31 08:08:00 | AAPL | Stock | 5.8218 | 5.8257 | 5.8214 | 5.8257 | 31024.0 |
| 2009-07-31 08:09:00 | AAPL | Stock | 5.8286 | 5.8286 | 5.8286 | 5.8286 | 5600.0 |
| 2009-07-31 08:11:00 | AAPL | Stock | 5.8282 | 5.8286 | 5.8282 | 5.8286 | 25200.0 |
| 2009-07-31 08:13:00 | AAPL | Stock | 5.8321 | 5.8321 | 5.8321 | 5.8321 | 14000.0 |
| 2009-07-31 08:15:00 | AAPL | Stock | 5.8321 | 5.8325 | 5.8321 | 5.8321 | 15736.0 |
| 2009-07-31 08:16:00 | AAPL | Stock | 5.8321 | 5.8336 | 5.8321 | 5.8336 | 16800.0 |
| 2009-07-31 08:18:00 | AAPL | Stock | 5.8336 | 5.8336 | 5.8336 | 5.8336 | 28000.0 |
| 2009-07-31 08:19:00 | AAPL | Stock | 5.8375 | 5.8375 | 5.8375 | 5.8375 | 4900.0 |
| 2009-07-31 08:20:00 | AAPL | Stock | 5.8368 | 5.8368 | 5.8368 | 5.8368 | 2800.0 |
| 2009-07-31 08:21:00 | AAPL | Stock | 5.8386 | 5.8389 | 5.8386 | 5.8389 | 30800.0 |
| 2009-07-31 08:22:00 | AAPL | Stock | 5.8389 | 5.8389 | 5.8389 | 5.8389 | 2800.0 |
| 2009-07-31 08:23:00 | AAPL | Stock | 5.8389 | 5.8389 | 5.8361 | 5.8361 | 15400.0 |
| 2009-07-31 08:24:00 | AAPL | Stock | 5.8375 | 5.8375 | 5.8375 | 5.8375 | 5600.0 |
| 2009-07-31 08:26:00 | AAPL | Stock | 5.8379 | 5.8379 | 5.8379 | 5.8379 | 2800.0 |
| 2009-07-31 08:27:00 | AAPL | Stock | 5.8357 | 5.8361 | 5.8357 | 5.8357 | 16800.0 |
| 2009-07-31 08:28:00 | AAPL | Stock | 5.8357 | 5.8393 | 5.8357 | 5.8393 | 55300.0 |
| 2009-07-31 08:29:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8393 | 5.8393 | 22512.0 |
| 2009-07-31 08:30:00 | AAPL | Stock | 5.8393 | 5.8479 | 5.8307 | 5.8357 | 185220.0 |
| 2009-07-31 08:31:00 | AAPL | Stock | 5.8354 | 5.8386 | 5.8318 | 5.8386 | 30800.0 |
| 2009-07-31 08:32:00 | AAPL | Stock | 5.8325 | 5.8332 | 5.8286 | 5.8286 | 82544.0 |
| 2009-07-31 08:33:00 | AAPL | Stock | 5.8229 | 5.8261 | 5.8161 | 5.8161 | 202216.0 |
| 2009-07-31 08:34:00 | AAPL | Stock | 5.8179 | 5.8179 | 5.8161 | 5.8179 | 36400.0 |
| 2009-07-31 08:35:00 | AAPL | Stock | 5.8179 | 5.8179 | 5.815 | 5.815 | 70000.0 |
| 2009-07-31 08:36:00 | AAPL | Stock | 5.8132 | 5.8146 | 5.8107 | 5.8107 | 36400.0 |
| 2009-07-31 08:37:00 | AAPL | Stock | 5.81 | 5.8104 | 5.8082 | 5.8104 | 78792.0 |
| 2009-07-31 08:38:00 | AAPL | Stock | 5.8079 | 5.8107 | 5.8025 | 5.8057 | 166264.0 |
| 2009-07-31 08:39:00 | AAPL | Stock | 5.8018 | 5.8025 | 5.7996 | 5.7996 | 103880.0 |
| 2009-07-31 08:40:00 | AAPL | Stock | 5.7989 | 5.8025 | 5.7971 | 5.7971 | 28000.0 |
| 2009-07-31 08:41:00 | AAPL | Stock | 5.7993 | 5.7993 | 5.7989 | 5.7989 | 16800.0 |
| 2009-07-31 08:42:00 | AAPL | Stock | 5.7993 | 5.8 | 5.7993 | 5.8 | 37940.0 |
| 2009-07-31 08:43:00 | AAPL | Stock | 5.8004 | 5.8004 | 5.8004 | 5.8004 | 5600.0 |
| 2009-07-31 08:44:00 | AAPL | Stock | 5.7996 | 5.8 | 5.7964 | 5.7964 | 44800.0 |
| 2009-07-31 08:45:00 | AAPL | Stock | 5.7968 | 5.7989 | 5.795 | 5.7975 | 69160.0 |
| 2009-07-31 08:46:00 | AAPL | Stock | 5.7982 | 5.8 | 5.7982 | 5.8 | 87780.0 |
| 2009-07-31 08:47:00 | AAPL | Stock | 5.8036 | 5.81 | 5.8036 | 5.8089 | 30716.0 |
| 2009-07-31 08:48:00 | AAPL | Stock | 5.8071 | 5.8121 | 5.8061 | 5.8096 | 69300.0 |
> showing 50 of 956,695 rows — these rows as CSV