PREVIEW / stock_1min / 2009-10-12
file: by_date/stock_1min/2009/2009-10-12.parquet size: 11.9 MB rows: 906,368 symbols: 2,724
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-10-12 06:04:00 | AAPL | Stock | 6.8529 | 6.8529 | 6.8529 | 6.8529 | 2800.0 |
| 2009-10-12 06:51:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8214 | 6.8214 | 18312.0 |
| 2009-10-12 06:52:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8214 | 6.8214 | 8344.0 |
| 2009-10-12 07:02:00 | AAPL | Stock | 6.8571 | 6.8579 | 6.8536 | 6.8536 | 50400.0 |
| 2009-10-12 07:07:00 | AAPL | Stock | 6.8554 | 6.8554 | 6.8554 | 6.8554 | 2800.0 |
| 2009-10-12 07:10:00 | AAPL | Stock | 6.8482 | 6.8482 | 6.8482 | 6.8482 | 5656.0 |
| 2009-10-12 07:22:00 | AAPL | Stock | 6.8464 | 6.8554 | 6.8464 | 6.8554 | 5600.0 |
| 2009-10-12 07:32:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8393 | 6.8393 | 8400.0 |
| 2009-10-12 07:34:00 | AAPL | Stock | 6.8411 | 6.8411 | 6.8411 | 6.8411 | 5264.0 |
| 2009-10-12 07:53:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8393 | 6.8393 | 4900.0 |
| 2009-10-12 07:59:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8393 | 6.8393 | 10332.0 |
| 2009-10-12 08:00:00 | AAPL | Stock | 6.8393 | 6.8482 | 6.8393 | 6.8393 | 76104.0 |
| 2009-10-12 08:02:00 | AAPL | Stock | 6.8411 | 6.8411 | 6.8411 | 6.8411 | 8148.0 |
| 2009-10-12 08:03:00 | AAPL | Stock | 6.8393 | 6.8411 | 6.8393 | 6.8411 | 31528.0 |
| 2009-10-12 08:04:00 | AAPL | Stock | 6.8411 | 6.8411 | 6.8411 | 6.8411 | 67200.0 |
| 2009-10-12 08:06:00 | AAPL | Stock | 6.8407 | 6.8457 | 6.8407 | 6.8457 | 7000.0 |
| 2009-10-12 08:08:00 | AAPL | Stock | 6.8479 | 6.8479 | 6.8479 | 6.8479 | 2800.0 |
| 2009-10-12 08:09:00 | AAPL | Stock | 6.8457 | 6.8457 | 6.8457 | 6.8457 | 5600.0 |
| 2009-10-12 08:10:00 | AAPL | Stock | 6.845 | 6.845 | 6.8361 | 6.8361 | 64260.0 |
| 2009-10-12 08:11:00 | AAPL | Stock | 6.8357 | 6.8357 | 6.8357 | 6.8357 | 8932.0 |
| 2009-10-12 08:12:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8393 | 6.8393 | 25760.0 |
| 2009-10-12 08:13:00 | AAPL | Stock | 6.8329 | 6.8329 | 6.8329 | 6.8329 | 2800.0 |
| 2009-10-12 08:15:00 | AAPL | Stock | 6.835 | 6.8354 | 6.835 | 6.8354 | 5600.0 |
| 2009-10-12 08:16:00 | AAPL | Stock | 6.8354 | 6.8354 | 6.8346 | 6.8354 | 14000.0 |
| 2009-10-12 08:17:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8054 | 6.815 | 246680.0 |
| 2009-10-12 08:18:00 | AAPL | Stock | 6.8236 | 6.8243 | 6.8236 | 6.8243 | 12600.0 |
| 2009-10-12 08:19:00 | AAPL | Stock | 6.8182 | 6.825 | 6.8161 | 6.825 | 31192.0 |
| 2009-10-12 08:20:00 | AAPL | Stock | 6.8246 | 6.8314 | 6.8246 | 6.8314 | 14000.0 |
| 2009-10-12 08:22:00 | AAPL | Stock | 6.8279 | 6.8279 | 6.8279 | 6.8279 | 9800.0 |
| 2009-10-12 08:25:00 | AAPL | Stock | 6.8264 | 6.8264 | 6.8264 | 6.8264 | 11200.0 |
| 2009-10-12 08:26:00 | AAPL | Stock | 6.8286 | 6.8286 | 6.8286 | 6.8286 | 5600.0 |
| 2009-10-12 08:28:00 | AAPL | Stock | 6.8286 | 6.8314 | 6.8286 | 6.8286 | 49112.0 |
| 2009-10-12 08:29:00 | AAPL | Stock | 6.8286 | 6.8286 | 6.8286 | 6.8286 | 7364.0 |
| 2009-10-12 08:30:00 | AAPL | Stock | 6.8286 | 6.8307 | 6.8246 | 6.8279 | 68880.0 |
| 2009-10-12 08:32:00 | AAPL | Stock | 6.8318 | 6.8336 | 6.8318 | 6.8336 | 23940.0 |
| 2009-10-12 08:34:00 | AAPL | Stock | 6.8336 | 6.8336 | 6.8321 | 6.8321 | 14000.0 |
| 2009-10-12 08:35:00 | AAPL | Stock | 6.8336 | 6.8336 | 6.8336 | 6.8336 | 2800.0 |
| 2009-10-12 08:36:00 | AAPL | Stock | 6.8321 | 6.8321 | 6.8321 | 6.8321 | 11200.0 |
| 2009-10-12 08:37:00 | AAPL | Stock | 6.8314 | 6.8314 | 6.8314 | 6.8314 | 5600.0 |
| 2009-10-12 08:38:00 | AAPL | Stock | 6.8314 | 6.8314 | 6.8314 | 6.8314 | 5600.0 |
| 2009-10-12 08:41:00 | AAPL | Stock | 6.8289 | 6.8314 | 6.8286 | 6.8296 | 23800.0 |
| 2009-10-12 08:44:00 | AAPL | Stock | 6.8304 | 6.8304 | 6.8304 | 6.8304 | 2800.0 |
| 2009-10-12 08:46:00 | AAPL | Stock | 6.8325 | 6.8325 | 6.8325 | 6.8325 | 2800.0 |
| 2009-10-12 08:47:00 | AAPL | Stock | 6.8325 | 6.8332 | 6.8325 | 6.8332 | 5600.0 |
| 2009-10-12 08:48:00 | AAPL | Stock | 6.8346 | 6.835 | 6.8346 | 6.835 | 27272.0 |
| 2009-10-12 08:51:00 | AAPL | Stock | 6.8332 | 6.8332 | 6.8325 | 6.8325 | 46620.0 |
| 2009-10-12 08:53:00 | AAPL | Stock | 6.8314 | 6.8339 | 6.8311 | 6.8339 | 14000.0 |
| 2009-10-12 08:55:00 | AAPL | Stock | 6.8329 | 6.835 | 6.8329 | 6.835 | 30800.0 |
| 2009-10-12 08:56:00 | AAPL | Stock | 6.8336 | 6.8357 | 6.8336 | 6.8357 | 16800.0 |
| 2009-10-12 08:57:00 | AAPL | Stock | 6.8357 | 6.8364 | 6.8357 | 6.8364 | 12712.0 |
> showing 50 of 906,368 rows — these rows as CSV