PREVIEW / stock_5min / 2007-11-27
file: by_date/stock_5min/2007/2007-11-27.parquet size: 4.4 MB rows: 320,109 symbols: 3,225
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:15:00 | AAPL | Stock | 6.2125 | 6.2125 | 6.2125 | 6.2125 | 5600.0 |
| 2007-11-27 04:50: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 | 40600.0 |
| 2007-11-27 05:55:00 | AAPL | Stock | 6.2557 | 6.2557 | 6.2557 | 6.2557 | 36400.0 |
| 2007-11-27 06:40: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:00:00 | AAPL | Stock | 6.2289 | 6.2554 | 6.2289 | 6.2536 | 72800.0 |
| 2007-11-27 07:05:00 | AAPL | Stock | 6.25 | 6.25 | 6.245 | 6.25 | 95900.0 |
| 2007-11-27 07:10:00 | AAPL | Stock | 6.25 | 6.2618 | 6.25 | 6.2539 | 46452.0 |
| 2007-11-27 07:15:00 | AAPL | Stock | 6.25 | 6.2568 | 6.25 | 6.2504 | 31920.0 |
| 2007-11-27 07:20:00 | AAPL | Stock | 6.2468 | 6.25 | 6.2468 | 6.25 | 110600.0 |
| 2007-11-27 07:25:00 | AAPL | Stock | 6.2475 | 6.25 | 6.2475 | 6.25 | 48468.0 |
| 2007-11-27 07:30:00 | AAPL | Stock | 6.25 | 6.25 | 6.2475 | 6.25 | 198520.0 |
| 2007-11-27 07:35:00 | AAPL | Stock | 6.2482 | 6.2518 | 6.2482 | 6.2518 | 109200.0 |
| 2007-11-27 07:40:00 | AAPL | Stock | 6.2518 | 6.2518 | 6.2493 | 6.25 | 217000.0 |
| 2007-11-27 07:45:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 79128.0 |
| 2007-11-27 07:50:00 | AAPL | Stock | 6.25 | 6.25 | 6.2289 | 6.2321 | 173600.0 |
| 2007-11-27 07:55:00 | AAPL | Stock | 6.2411 | 6.2411 | 6.2289 | 6.2321 | 58800.0 |
| 2007-11-27 08:00:00 | AAPL | Stock | 6.2289 | 6.2411 | 6.2161 | 6.225 | 1357496.0 |
| 2007-11-27 08:05:00 | AAPL | Stock | 6.2264 | 6.2268 | 6.1622 | 6.2143 | 964096.0 |
| 2007-11-27 08:10:00 | AAPL | Stock | 6.2129 | 6.2254 | 6.2075 | 6.225 | 934080.0 |
| 2007-11-27 08:15:00 | AAPL | Stock | 6.225 | 6.2411 | 6.2232 | 6.2321 | 611940.0 |
| 2007-11-27 08:20:00 | AAPL | Stock | 6.2321 | 6.2375 | 6.2271 | 6.2271 | 529088.0 |
| 2007-11-27 08:25:00 | AAPL | Stock | 6.2254 | 6.2268 | 6.2182 | 6.2214 | 335468.0 |
| 2007-11-27 08:30:00 | AAPL | Stock | 6.2196 | 6.2204 | 6.2143 | 6.2179 | 199836.0 |
| 2007-11-27 08:35:00 | AAPL | Stock | 6.22 | 6.2318 | 6.2161 | 6.2286 | 160440.0 |
| 2007-11-27 08:40:00 | AAPL | Stock | 6.2286 | 6.23 | 6.2246 | 6.2264 | 303100.0 |
| 2007-11-27 08:45:00 | AAPL | Stock | 6.2286 | 6.2354 | 6.2268 | 6.2346 | 286496.0 |
| 2007-11-27 08:50:00 | AAPL | Stock | 6.2321 | 6.25 | 6.2321 | 6.2411 | 1126440.0 |
| 2007-11-27 08:55:00 | AAPL | Stock | 6.2429 | 6.2489 | 6.2393 | 6.2482 | 624988.0 |
| 2007-11-27 09:00:00 | AAPL | Stock | 6.2486 | 6.25 | 6.2379 | 6.2379 | 723268.0 |
| 2007-11-27 09:05:00 | AAPL | Stock | 6.2404 | 6.2404 | 6.2318 | 6.2375 | 348544.0 |
| 2007-11-27 09:10:00 | AAPL | Stock | 6.2382 | 6.2518 | 6.2286 | 6.2504 | 1607452.0 |
| 2007-11-27 09:15:00 | AAPL | Stock | 6.2507 | 6.2564 | 6.2493 | 6.2543 | 1471456.0 |
| 2007-11-27 09:20:00 | AAPL | Stock | 6.2543 | 6.2589 | 6.25 | 6.2504 | 1059632.0 |
| 2007-11-27 09:25:00 | AAPL | Stock | 6.25 | 6.2668 | 6.2489 | 6.2575 | 1565172.0 |
| 2007-11-27 09:30:00 | AAPL | Stock | 6.2579 | 6.2618 | 6.225 | 6.2504 | 33208056.0 |
| 2007-11-27 09:35:00 | AAPL | Stock | 6.25 | 6.2782 | 6.2494 | 6.2554 | 32405324.0 |
| 2007-11-27 09:40:00 | AAPL | Stock | 6.2554 | 6.2661 | 6.235 | 6.2382 | 24053848.0 |
| 2007-11-27 09:45:00 | AAPL | Stock | 6.2382 | 6.2571 | 6.2375 | 6.2525 | 19338060.0 |
| 2007-11-27 09:50:00 | AAPL | Stock | 6.2511 | 6.2754 | 6.25 | 6.2618 | 24309684.0 |
| 2007-11-27 09:55:00 | AAPL | Stock | 6.2614 | 6.2768 | 6.25 | 6.2617 | 16962092.0 |
| 2007-11-27 10:00:00 | AAPL | Stock | 6.26 | 6.2657 | 6.2411 | 6.2418 | 26926116.0 |
| 2007-11-27 10:05:00 | AAPL | Stock | 6.2418 | 6.2429 | 6.1811 | 6.1893 | 36260448.0 |
| 2007-11-27 10:10:00 | AAPL | Stock | 6.1904 | 6.1946 | 6.0961 | 6.1046 | 43598380.0 |
| 2007-11-27 10:15:00 | AAPL | Stock | 6.0968 | 6.1339 | 6.0718 | 6.1204 | 48782916.0 |
| 2007-11-27 10:20:00 | AAPL | Stock | 6.1204 | 6.1646 | 6.1146 | 6.1621 | 29479800.0 |
| 2007-11-27 10:25:00 | AAPL | Stock | 6.1621 | 6.1904 | 6.1518 | 6.1871 | 27693680.0 |
| 2007-11-27 10:30:00 | AAPL | Stock | 6.1868 | 6.2336 | 6.1796 | 6.215 | 30531844.0 |
| 2007-11-27 10:35:00 | AAPL | Stock | 6.2146 | 6.2336 | 6.1825 | 6.2189 | 19885096.0 |
> showing 50 of 320,109 rows — these rows as CSV