PREVIEW / stock_1min / 2007-06-14
file: by_date/stock_1min/2007/2007-06-14.parquet size: 10.8 MB rows: 891,663 symbols: 2,486
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-06-14 09:30:00 | AAPL | Stock | 4.1857 | 4.1861 | 4.1636 | 4.1671 | 13162464.0 |
| 2007-06-14 09:31:00 | AAPL | Stock | 4.1671 | 4.1807 | 4.1579 | 4.1624 | 7906052.0 |
| 2007-06-14 09:32:00 | AAPL | Stock | 4.1614 | 4.18 | 4.1579 | 4.1646 | 8497188.0 |
| 2007-06-14 09:33:00 | AAPL | Stock | 4.1646 | 4.1736 | 4.1629 | 4.1711 | 4114852.0 |
| 2007-06-14 09:34:00 | AAPL | Stock | 4.1711 | 4.1821 | 4.1675 | 4.1789 | 5655216.0 |
| 2007-06-14 09:35:00 | AAPL | Stock | 4.1789 | 4.1875 | 4.1761 | 4.1814 | 4491200.0 |
| 2007-06-14 09:36:00 | AAPL | Stock | 4.1825 | 4.1875 | 4.1789 | 4.1864 | 6139896.0 |
| 2007-06-14 09:37:00 | AAPL | Stock | 4.1864 | 4.1871 | 4.1793 | 4.1811 | 4964792.0 |
| 2007-06-14 09:38:00 | AAPL | Stock | 4.1814 | 4.1814 | 4.1721 | 4.1743 | 5361412.0 |
| 2007-06-14 09:39:00 | AAPL | Stock | 4.175 | 4.1821 | 4.1736 | 4.18 | 4315192.0 |
| 2007-06-14 09:40:00 | AAPL | Stock | 4.1793 | 4.1871 | 4.1786 | 4.1836 | 4563104.0 |
| 2007-06-14 09:41:00 | AAPL | Stock | 4.1832 | 4.2014 | 4.1829 | 4.2007 | 10168620.0 |
| 2007-06-14 09:42:00 | AAPL | Stock | 4.2007 | 4.2207 | 4.1971 | 4.2171 | 13454028.0 |
| 2007-06-14 09:43:00 | AAPL | Stock | 4.2164 | 4.2243 | 4.2129 | 4.2221 | 10060932.0 |
| 2007-06-14 09:44:00 | AAPL | Stock | 4.2221 | 4.2241 | 4.2143 | 4.2175 | 7376264.0 |
| 2007-06-14 09:45:00 | AAPL | Stock | 4.2175 | 4.2196 | 4.2111 | 4.2179 | 6703368.0 |
| 2007-06-14 09:46:00 | AAPL | Stock | 4.2179 | 4.2268 | 4.2121 | 4.225 | 9126348.0 |
| 2007-06-14 09:47:00 | AAPL | Stock | 4.225 | 4.2411 | 4.2243 | 4.2393 | 11959360.0 |
| 2007-06-14 09:48:00 | AAPL | Stock | 4.2389 | 4.2479 | 4.2357 | 4.2479 | 9905392.0 |
| 2007-06-14 09:49:00 | AAPL | Stock | 4.2475 | 4.2604 | 4.2464 | 4.2589 | 13181364.0 |
| 2007-06-14 09:50:00 | AAPL | Stock | 4.2589 | 4.2593 | 4.2429 | 4.2457 | 11759804.0 |
| 2007-06-14 09:51:00 | AAPL | Stock | 4.2457 | 4.2457 | 4.2364 | 4.2379 | 8556296.0 |
| 2007-06-14 09:52:00 | AAPL | Stock | 4.2382 | 4.2454 | 4.2368 | 4.2379 | 4754372.0 |
| 2007-06-14 09:53:00 | AAPL | Stock | 4.2386 | 4.2404 | 4.2325 | 4.235 | 5214020.0 |
| 2007-06-14 09:54:00 | AAPL | Stock | 4.235 | 4.2407 | 4.2304 | 4.2368 | 6724536.0 |
| 2007-06-14 09:55:00 | AAPL | Stock | 4.2357 | 4.2411 | 4.2357 | 4.2393 | 4486580.0 |
| 2007-06-14 09:56:00 | AAPL | Stock | 4.2393 | 4.2421 | 4.2311 | 4.2375 | 4998924.0 |
| 2007-06-14 09:57:00 | AAPL | Stock | 4.2375 | 4.2375 | 4.2321 | 4.2364 | 2408980.0 |
| 2007-06-14 09:58:00 | AAPL | Stock | 4.2367 | 4.2461 | 4.2364 | 4.2436 | 5598572.0 |
| 2007-06-14 09:59:00 | AAPL | Stock | 4.2436 | 4.25 | 4.2421 | 4.2475 | 5483464.0 |
| 2007-06-14 10:00:00 | AAPL | Stock | 4.2475 | 4.255 | 4.2464 | 4.2529 | 5971812.0 |
| 2007-06-14 10:01:00 | AAPL | Stock | 4.2532 | 4.2554 | 4.25 | 4.2511 | 6195616.0 |
| 2007-06-14 10:02:00 | AAPL | Stock | 4.2511 | 4.2511 | 4.2339 | 4.2392 | 8481228.0 |
| 2007-06-14 10:03:00 | AAPL | Stock | 4.2393 | 4.2464 | 4.2354 | 4.2443 | 3833844.0 |
| 2007-06-14 10:04:00 | AAPL | Stock | 4.2443 | 4.25 | 4.2414 | 4.2414 | 3432240.0 |
| 2007-06-14 10:05:00 | AAPL | Stock | 4.2418 | 4.2436 | 4.2371 | 4.2436 | 3917088.0 |
| 2007-06-14 10:06:00 | AAPL | Stock | 4.2436 | 4.2439 | 4.2386 | 4.24 | 2521624.0 |
| 2007-06-14 10:07:00 | AAPL | Stock | 4.2393 | 4.2411 | 4.2364 | 4.24 | 2669380.0 |
| 2007-06-14 10:08:00 | AAPL | Stock | 4.2396 | 4.2411 | 4.2343 | 4.2375 | 3693452.0 |
| 2007-06-14 10:09:00 | AAPL | Stock | 4.2368 | 4.2386 | 4.2257 | 4.2289 | 6686064.0 |
| 2007-06-14 10:10:00 | AAPL | Stock | 4.2293 | 4.2304 | 4.2236 | 4.2279 | 5192432.0 |
| 2007-06-14 10:11:00 | AAPL | Stock | 4.2282 | 4.2314 | 4.2275 | 4.2286 | 2406852.0 |
| 2007-06-14 10:12:00 | AAPL | Stock | 4.2289 | 4.2296 | 4.2214 | 4.2218 | 4318776.0 |
| 2007-06-14 10:13:00 | AAPL | Stock | 4.2221 | 4.2264 | 4.2214 | 4.2239 | 3727388.0 |
| 2007-06-14 10:14:00 | AAPL | Stock | 4.2239 | 4.2279 | 4.2218 | 4.2254 | 3465896.0 |
| 2007-06-14 10:15:00 | AAPL | Stock | 4.2257 | 4.2346 | 4.2254 | 4.2343 | 4059692.0 |
| 2007-06-14 10:16:00 | AAPL | Stock | 4.2339 | 4.2446 | 4.2329 | 4.2379 | 4756500.0 |
| 2007-06-14 10:17:00 | AAPL | Stock | 4.2382 | 4.2414 | 4.2346 | 4.2354 | 3410652.0 |
| 2007-06-14 10:18:00 | AAPL | Stock | 4.2354 | 4.2379 | 4.2321 | 4.2343 | 2875096.0 |
| 2007-06-14 10:19:00 | AAPL | Stock | 4.2339 | 4.2346 | 4.2296 | 4.2314 | 2509500.0 |
> showing 50 of 891,663 rows — these rows as CSV