PREVIEW / stock_1min / 2011-11-10
file: by_date/stock_1min/2011/2011-11-10.parquet size: 13.0 MB rows: 979,667 symbols: 2,813
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-10 04:06:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 5600.0 |
| 2011-11-10 04:07:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 22400.0 |
| 2011-11-10 04:12:00 | AAPL | Stock | 14.1607 | 14.1607 | 14.1607 | 14.1607 | 13720.0 |
| 2011-11-10 04:29:00 | AAPL | Stock | 14.1514 | 14.1514 | 14.1514 | 14.1514 | 2800.0 |
| 2011-11-10 04:40:00 | AAPL | Stock | 14.175 | 14.1786 | 14.175 | 14.1786 | 14000.0 |
| 2011-11-10 04:45:00 | AAPL | Stock | 14.1971 | 14.1971 | 14.1971 | 14.1971 | 5600.0 |
| 2011-11-10 05:29:00 | AAPL | Stock | 14.1875 | 14.1875 | 14.1875 | 14.1875 | 2800.0 |
| 2011-11-10 07:00:00 | AAPL | Stock | 14.1875 | 14.1875 | 14.1875 | 14.1875 | 14000.0 |
| 2011-11-10 07:01:00 | AAPL | Stock | 14.1871 | 14.1875 | 14.1871 | 14.1875 | 14000.0 |
| 2011-11-10 07:03:00 | AAPL | Stock | 14.2089 | 14.2089 | 14.2089 | 14.2089 | 2800.0 |
| 2011-11-10 07:05:00 | AAPL | Stock | 14.2054 | 14.2861 | 14.2054 | 14.2857 | 149044.0 |
| 2011-11-10 07:06:00 | AAPL | Stock | 14.2857 | 14.2857 | 14.25 | 14.25 | 72800.0 |
| 2011-11-10 07:07:00 | AAPL | Stock | 14.2329 | 14.2329 | 14.2311 | 14.2311 | 19600.0 |
| 2011-11-10 07:08:00 | AAPL | Stock | 14.2214 | 14.2214 | 14.2214 | 14.2214 | 28000.0 |
| 2011-11-10 07:09:00 | AAPL | Stock | 14.2239 | 14.2239 | 14.2239 | 14.2239 | 5600.0 |
| 2011-11-10 07:10:00 | AAPL | Stock | 14.2164 | 14.2164 | 14.2161 | 14.2161 | 16800.0 |
| 2011-11-10 07:11:00 | AAPL | Stock | 14.2161 | 14.2161 | 14.2143 | 14.2143 | 95200.0 |
| 2011-11-10 07:12:00 | AAPL | Stock | 14.2143 | 14.2143 | 14.2143 | 14.2143 | 22400.0 |
| 2011-11-10 07:13:00 | AAPL | Stock | 14.2143 | 14.2143 | 14.1964 | 14.1964 | 28000.0 |
| 2011-11-10 07:14:00 | AAPL | Stock | 14.1964 | 14.1964 | 14.1964 | 14.1964 | 5600.0 |
| 2011-11-10 07:16:00 | AAPL | Stock | 14.2132 | 14.2132 | 14.2132 | 14.2132 | 11200.0 |
| 2011-11-10 07:17:00 | AAPL | Stock | 14.2157 | 14.2179 | 14.2143 | 14.2143 | 43680.0 |
| 2011-11-10 07:18:00 | AAPL | Stock | 14.23 | 14.23 | 14.23 | 14.23 | 2800.0 |
| 2011-11-10 07:19:00 | AAPL | Stock | 14.2175 | 14.225 | 14.2157 | 14.225 | 109200.0 |
| 2011-11-10 07:20:00 | AAPL | Stock | 14.225 | 14.225 | 14.225 | 14.225 | 5600.0 |
| 2011-11-10 07:21:00 | AAPL | Stock | 14.225 | 14.225 | 14.225 | 14.225 | 39340.0 |
| 2011-11-10 07:22:00 | AAPL | Stock | 14.2232 | 14.25 | 14.2232 | 14.2325 | 144200.0 |
| 2011-11-10 07:23:00 | AAPL | Stock | 14.2482 | 14.2507 | 14.2482 | 14.25 | 72800.0 |
| 2011-11-10 07:24:00 | AAPL | Stock | 14.25 | 14.2568 | 14.2357 | 14.2507 | 83916.0 |
| 2011-11-10 07:25:00 | AAPL | Stock | 14.2536 | 14.2571 | 14.25 | 14.2507 | 31920.0 |
| 2011-11-10 07:26:00 | AAPL | Stock | 14.2518 | 14.2518 | 14.25 | 14.25 | 5600.0 |
| 2011-11-10 07:29:00 | AAPL | Stock | 14.2371 | 14.2411 | 14.2371 | 14.2411 | 5600.0 |
| 2011-11-10 07:30:00 | AAPL | Stock | 14.2464 | 14.2464 | 14.2464 | 14.2464 | 2800.0 |
| 2011-11-10 07:31:00 | AAPL | Stock | 14.2411 | 14.2411 | 14.2411 | 14.2411 | 28000.0 |
| 2011-11-10 07:33:00 | AAPL | Stock | 14.2411 | 14.2411 | 14.2411 | 14.2411 | 8400.0 |
| 2011-11-10 07:34:00 | AAPL | Stock | 14.2446 | 14.2446 | 14.2446 | 14.2446 | 42280.0 |
| 2011-11-10 07:35:00 | AAPL | Stock | 14.2446 | 14.2446 | 14.2321 | 14.2321 | 68600.0 |
| 2011-11-10 07:37:00 | AAPL | Stock | 14.2479 | 14.25 | 14.2357 | 14.25 | 47516.0 |
| 2011-11-10 07:38:00 | AAPL | Stock | 14.2357 | 14.2357 | 14.2321 | 14.2321 | 11200.0 |
| 2011-11-10 07:39:00 | AAPL | Stock | 14.2321 | 14.2321 | 14.2321 | 14.2321 | 22400.0 |
| 2011-11-10 07:40:00 | AAPL | Stock | 14.2389 | 14.2393 | 14.2389 | 14.2393 | 28000.0 |
| 2011-11-10 07:41:00 | AAPL | Stock | 14.2396 | 14.2571 | 14.2396 | 14.2568 | 96460.0 |
| 2011-11-10 07:45:00 | AAPL | Stock | 14.2429 | 14.2475 | 14.2411 | 14.2411 | 30800.0 |
| 2011-11-10 07:46:00 | AAPL | Stock | 14.24 | 14.2521 | 14.24 | 14.25 | 40040.0 |
| 2011-11-10 07:47:00 | AAPL | Stock | 14.2489 | 14.2489 | 14.2489 | 14.2489 | 2800.0 |
| 2011-11-10 07:48:00 | AAPL | Stock | 14.2486 | 14.25 | 14.245 | 14.245 | 54712.0 |
| 2011-11-10 07:49:00 | AAPL | Stock | 14.245 | 14.2496 | 14.245 | 14.2496 | 5600.0 |
| 2011-11-10 07:52:00 | AAPL | Stock | 14.2446 | 14.2446 | 14.2393 | 14.2393 | 17920.0 |
| 2011-11-10 07:53:00 | AAPL | Stock | 14.2325 | 14.2393 | 14.2325 | 14.2346 | 123452.0 |
| 2011-11-10 07:54:00 | AAPL | Stock | 14.2386 | 14.2386 | 14.2304 | 14.2304 | 5600.0 |
> showing 50 of 979,667 rows — these rows as CSV