PREVIEW / stock_1min / 2013-07-16
file: by_date/stock_1min/2013/2013-07-16.parquet size: 13.4 MB rows: 989,837 symbols: 2,831
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-16 04:00:00 | AAPL | Stock | 15.2786 | 15.2786 | 15.2786 | 15.2786 | 7140.0 |
| 2013-07-16 06:16:00 | AAPL | Stock | 15.2857 | 15.2857 | 15.2857 | 15.2857 | 2800.0 |
| 2013-07-16 07:03:00 | AAPL | Stock | 15.2475 | 15.2475 | 15.2475 | 15.2475 | 6048.0 |
| 2013-07-16 07:08:00 | AAPL | Stock | 15.2607 | 15.3 | 15.2607 | 15.3 | 11200.0 |
| 2013-07-16 07:12:00 | AAPL | Stock | 15.2889 | 15.2889 | 15.2889 | 15.2889 | 2800.0 |
| 2013-07-16 07:17:00 | AAPL | Stock | 15.2682 | 15.2682 | 15.2664 | 15.2664 | 5600.0 |
| 2013-07-16 07:18:00 | AAPL | Stock | 15.2607 | 15.2607 | 15.2607 | 15.2607 | 2800.0 |
| 2013-07-16 07:20:00 | AAPL | Stock | 15.2657 | 15.2657 | 15.2657 | 15.2657 | 2800.0 |
| 2013-07-16 07:28:00 | AAPL | Stock | 15.2657 | 15.2657 | 15.2657 | 15.2657 | 2800.0 |
| 2013-07-16 07:49:00 | AAPL | Stock | 15.2607 | 15.2607 | 15.2607 | 15.2607 | 5600.0 |
| 2013-07-16 07:50:00 | AAPL | Stock | 15.2457 | 15.2457 | 15.2457 | 15.2457 | 2800.0 |
| 2013-07-16 08:00:00 | AAPL | Stock | 15.2432 | 15.2432 | 15.2407 | 15.2411 | 44800.0 |
| 2013-07-16 08:01:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2411 | 15.2411 | 2800.0 |
| 2013-07-16 08:04:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2411 | 15.2411 | 2800.0 |
| 2013-07-16 08:05:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2411 | 15.2411 | 2800.0 |
| 2013-07-16 08:07:00 | AAPL | Stock | 15.2454 | 15.2454 | 15.2454 | 15.2454 | 8400.0 |
| 2013-07-16 08:11:00 | AAPL | Stock | 15.2454 | 15.2454 | 15.2454 | 15.2454 | 3192.0 |
| 2013-07-16 08:13:00 | AAPL | Stock | 15.2454 | 15.2454 | 15.2454 | 15.2454 | 25200.0 |
| 2013-07-16 08:14:00 | AAPL | Stock | 15.2454 | 15.25 | 15.2454 | 15.2468 | 61152.0 |
| 2013-07-16 08:15:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 14280.0 |
| 2013-07-16 08:18:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 15120.0 |
| 2013-07-16 08:20:00 | AAPL | Stock | 15.2471 | 15.2471 | 15.2357 | 15.2357 | 47068.0 |
| 2013-07-16 08:27:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 12460.0 |
| 2013-07-16 08:28:00 | AAPL | Stock | 15.2475 | 15.2475 | 15.2475 | 15.2475 | 2800.0 |
| 2013-07-16 08:29:00 | AAPL | Stock | 15.2493 | 15.2493 | 15.2493 | 15.2493 | 2800.0 |
| 2013-07-16 08:30:00 | AAPL | Stock | 15.25 | 15.25 | 15.2464 | 15.2475 | 20720.0 |
| 2013-07-16 08:31:00 | AAPL | Stock | 15.2429 | 15.2482 | 15.24 | 15.24 | 56000.0 |
| 2013-07-16 08:32:00 | AAPL | Stock | 15.24 | 15.2493 | 15.24 | 15.2493 | 33544.0 |
| 2013-07-16 08:38:00 | AAPL | Stock | 15.2482 | 15.2482 | 15.2482 | 15.2482 | 2800.0 |
| 2013-07-16 08:40:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 13440.0 |
| 2013-07-16 08:41:00 | AAPL | Stock | 15.2446 | 15.2446 | 15.2357 | 15.2357 | 98000.0 |
| 2013-07-16 08:42:00 | AAPL | Stock | 15.2357 | 15.2357 | 15.235 | 15.2357 | 57400.0 |
| 2013-07-16 08:43:00 | AAPL | Stock | 15.2325 | 15.2436 | 15.2304 | 15.2436 | 47600.0 |
| 2013-07-16 08:44:00 | AAPL | Stock | 15.2436 | 15.2436 | 15.2436 | 15.2436 | 11200.0 |
| 2013-07-16 08:46:00 | AAPL | Stock | 15.2464 | 15.2468 | 15.2464 | 15.2468 | 14000.0 |
| 2013-07-16 08:51:00 | AAPL | Stock | 15.2468 | 15.2468 | 15.2468 | 15.2468 | 9940.0 |
| 2013-07-16 08:53:00 | AAPL | Stock | 15.2439 | 15.2439 | 15.2439 | 15.2439 | 2800.0 |
| 2013-07-16 08:55:00 | AAPL | Stock | 15.2439 | 15.2439 | 15.2429 | 15.2429 | 5600.0 |
| 2013-07-16 08:56:00 | AAPL | Stock | 15.2489 | 15.2493 | 15.2368 | 15.2368 | 37800.0 |
| 2013-07-16 08:57:00 | AAPL | Stock | 15.2396 | 15.24 | 15.2396 | 15.24 | 14560.0 |
| 2013-07-16 08:58:00 | AAPL | Stock | 15.2457 | 15.2464 | 15.2457 | 15.2464 | 28000.0 |
| 2013-07-16 08:59:00 | AAPL | Stock | 15.2457 | 15.2493 | 15.2457 | 15.2464 | 47600.0 |
| 2013-07-16 09:01:00 | AAPL | Stock | 15.2457 | 15.2457 | 15.2457 | 15.2457 | 5600.0 |
| 2013-07-16 09:02:00 | AAPL | Stock | 15.245 | 15.245 | 15.2446 | 15.2446 | 34468.0 |
| 2013-07-16 09:05:00 | AAPL | Stock | 15.2425 | 15.2425 | 15.2218 | 15.2218 | 64400.0 |
| 2013-07-16 09:06:00 | AAPL | Stock | 15.2221 | 15.2221 | 15.2154 | 15.2154 | 8400.0 |
| 2013-07-16 09:07:00 | AAPL | Stock | 15.2225 | 15.2275 | 15.2225 | 15.2275 | 8680.0 |
| 2013-07-16 09:08:00 | AAPL | Stock | 15.2254 | 15.2336 | 15.2225 | 15.2336 | 51632.0 |
| 2013-07-16 09:09:00 | AAPL | Stock | 15.2289 | 15.2289 | 15.22 | 15.2246 | 62412.0 |
| 2013-07-16 09:10:00 | AAPL | Stock | 15.2211 | 15.225 | 15.22 | 15.225 | 52248.0 |
> showing 50 of 989,837 rows — these rows as CSV