PREVIEW / stock_1min / 2007-11-27
file: by_date/stock_1min/2007/2007-11-27.parquet size: 12.5 MB rows: 1,014,377 symbols: 2,635
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-11-27 04:17:00 | AAPL | Stock | 6.2125 | 6.2125 | 6.2125 | 6.2125 | 5600.0 |
| 2007-11-27 04:54:00 | AAPL | Stock | 6.245 | 6.245 | 6.245 | 6.245 | 16800.0 |
| 2007-11-27 05:40:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 15400.0 |
| 2007-11-27 05:41:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 2800.0 |
| 2007-11-27 05:43:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 22400.0 |
| 2007-11-27 05:59:00 | AAPL | Stock | 6.2557 | 6.2557 | 6.2557 | 6.2557 | 36400.0 |
| 2007-11-27 06:41:00 | AAPL | Stock | 6.25 | 6.2568 | 6.25 | 6.2568 | 13916.0 |
| 2007-11-27 06:45:00 | AAPL | Stock | 6.2568 | 6.2568 | 6.2568 | 6.2568 | 11200.0 |
| 2007-11-27 07:01:00 | AAPL | Stock | 6.2289 | 6.2289 | 6.2289 | 6.2289 | 2800.0 |
| 2007-11-27 07:02:00 | AAPL | Stock | 6.2429 | 6.25 | 6.2429 | 6.25 | 36400.0 |
| 2007-11-27 07:03:00 | AAPL | Stock | 6.2536 | 6.2554 | 6.2536 | 6.2536 | 8400.0 |
| 2007-11-27 07:04:00 | AAPL | Stock | 6.2536 | 6.2536 | 6.2536 | 6.2536 | 25200.0 |
| 2007-11-27 07:05:00 | AAPL | Stock | 6.25 | 6.25 | 6.245 | 6.2475 | 16800.0 |
| 2007-11-27 07:06:00 | AAPL | Stock | 6.2475 | 6.2475 | 6.245 | 6.245 | 31500.0 |
| 2007-11-27 07:08:00 | AAPL | Stock | 6.2482 | 6.2489 | 6.2482 | 6.2489 | 14000.0 |
| 2007-11-27 07:09:00 | AAPL | Stock | 6.2493 | 6.25 | 6.2493 | 6.25 | 33600.0 |
| 2007-11-27 07:10:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 14000.0 |
| 2007-11-27 07:11:00 | AAPL | Stock | 6.2536 | 6.2536 | 6.2536 | 6.2536 | 2800.0 |
| 2007-11-27 07:13:00 | AAPL | Stock | 6.2618 | 6.2618 | 6.2618 | 6.2618 | 25200.0 |
| 2007-11-27 07:14:00 | AAPL | Stock | 6.2539 | 6.2539 | 6.2539 | 6.2539 | 4452.0 |
| 2007-11-27 07:15:00 | AAPL | Stock | 6.25 | 6.2568 | 6.25 | 6.25 | 19600.0 |
| 2007-11-27 07:17:00 | AAPL | Stock | 6.2504 | 6.2504 | 6.2504 | 6.2504 | 12320.0 |
| 2007-11-27 07:20:00 | AAPL | Stock | 6.2468 | 6.2468 | 6.2468 | 6.2468 | 14000.0 |
| 2007-11-27 07:21:00 | AAPL | Stock | 6.25 | 6.25 | 6.2468 | 6.2468 | 42000.0 |
| 2007-11-27 07:22:00 | AAPL | Stock | 6.2468 | 6.2468 | 6.2468 | 6.2468 | 14000.0 |
| 2007-11-27 07:23:00 | AAPL | Stock | 6.2496 | 6.25 | 6.2496 | 6.25 | 40600.0 |
| 2007-11-27 07:26:00 | AAPL | Stock | 6.2475 | 6.2475 | 6.2475 | 6.2475 | 19600.0 |
| 2007-11-27 07:27:00 | AAPL | Stock | 6.25 | 6.25 | 6.2482 | 6.2482 | 8540.0 |
| 2007-11-27 07:28:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 20328.0 |
| 2007-11-27 07:31:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 104720.0 |
| 2007-11-27 07:33:00 | AAPL | Stock | 6.25 | 6.25 | 6.2475 | 6.2475 | 9800.0 |
| 2007-11-27 07:34:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 84000.0 |
| 2007-11-27 07:35:00 | AAPL | Stock | 6.2482 | 6.2482 | 6.2482 | 6.2482 | 14000.0 |
| 2007-11-27 07:36:00 | AAPL | Stock | 6.2482 | 6.2482 | 6.2482 | 6.2482 | 36400.0 |
| 2007-11-27 07:37:00 | AAPL | Stock | 6.2518 | 6.2518 | 6.2518 | 6.2518 | 58800.0 |
| 2007-11-27 07:40:00 | AAPL | Stock | 6.2518 | 6.2518 | 6.25 | 6.25 | 89600.0 |
| 2007-11-27 07:41:00 | AAPL | Stock | 6.2518 | 6.2518 | 6.25 | 6.25 | 47600.0 |
| 2007-11-27 07:43:00 | AAPL | Stock | 6.2493 | 6.2514 | 6.2493 | 6.25 | 79800.0 |
| 2007-11-27 07:45:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 25928.0 |
| 2007-11-27 07:47:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 14000.0 |
| 2007-11-27 07:48:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 28000.0 |
| 2007-11-27 07:49:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 11200.0 |
| 2007-11-27 07:50:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 22400.0 |
| 2007-11-27 07:51:00 | AAPL | Stock | 6.25 | 6.25 | 6.2454 | 6.2454 | 60200.0 |
| 2007-11-27 07:52:00 | AAPL | Stock | 6.2429 | 6.2429 | 6.2289 | 6.2289 | 51800.0 |
| 2007-11-27 07:53:00 | AAPL | Stock | 6.2382 | 6.2389 | 6.2343 | 6.2343 | 33600.0 |
| 2007-11-27 07:54:00 | AAPL | Stock | 6.2321 | 6.2321 | 6.2321 | 6.2321 | 5600.0 |
| 2007-11-27 07:55:00 | AAPL | Stock | 6.2411 | 6.2411 | 6.2411 | 6.2411 | 2800.0 |
| 2007-11-27 07:58:00 | AAPL | Stock | 6.2314 | 6.2314 | 6.23 | 6.23 | 25200.0 |
| 2007-11-27 07:59:00 | AAPL | Stock | 6.2289 | 6.2321 | 6.2289 | 6.2321 | 30800.0 |
> showing 50 of 1,014,377 rows — these rows as CSV