PREVIEW / stock_5min / 2010-11-30
file: by_date/stock_5min/2010/2010-11-30.parquet size: 4.9 MB rows: 336,431 symbols: 3,510
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-30 04:00:00 | AAPL | Stock | 11.25 | 11.25 | 11.25 | 11.25 | 2800.0 |
| 2010-11-30 04:05:00 | AAPL | Stock | 11.25 | 11.25 | 11.25 | 11.25 | 8400.0 |
| 2010-11-30 04:15:00 | AAPL | Stock | 11.25 | 11.25 | 11.25 | 11.25 | 2800.0 |
| 2010-11-30 04:20:00 | AAPL | Stock | 11.2443 | 11.2443 | 11.2336 | 11.2336 | 5600.0 |
| 2010-11-30 04:35:00 | AAPL | Stock | 11.2411 | 11.2411 | 11.2411 | 11.2411 | 2800.0 |
| 2010-11-30 04:40:00 | AAPL | Stock | 11.2411 | 11.2411 | 11.2411 | 11.2411 | 39200.0 |
| 2010-11-30 04:50:00 | AAPL | Stock | 11.2214 | 11.2214 | 11.2214 | 11.2214 | 2800.0 |
| 2010-11-30 04:55:00 | AAPL | Stock | 11.2286 | 11.2286 | 11.2286 | 11.2286 | 2800.0 |
| 2010-11-30 05:25:00 | AAPL | Stock | 11.2296 | 11.2332 | 11.2296 | 11.2332 | 11200.0 |
| 2010-11-30 05:30:00 | AAPL | Stock | 11.2332 | 11.2332 | 11.2332 | 11.2332 | 19600.0 |
| 2010-11-30 05:35:00 | AAPL | Stock | 11.2582 | 11.2586 | 11.2582 | 11.2586 | 19600.0 |
| 2010-11-30 05:40:00 | AAPL | Stock | 11.2586 | 11.2586 | 11.2586 | 11.2586 | 11200.0 |
| 2010-11-30 06:20:00 | AAPL | Stock | 11.2536 | 11.2536 | 11.2536 | 11.2536 | 2800.0 |
| 2010-11-30 06:40:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-11-30 06:50:00 | AAPL | Stock | 11.2721 | 11.2725 | 11.2721 | 11.2725 | 5600.0 |
| 2010-11-30 07:00:00 | AAPL | Stock | 11.2611 | 11.2611 | 11.2611 | 11.2611 | 2800.0 |
| 2010-11-30 07:05:00 | AAPL | Stock | 11.2607 | 11.2671 | 11.2607 | 11.2671 | 18480.0 |
| 2010-11-30 07:10:00 | AAPL | Stock | 11.2607 | 11.2611 | 11.2607 | 11.2611 | 8400.0 |
| 2010-11-30 07:15:00 | AAPL | Stock | 11.2668 | 11.2671 | 11.2657 | 11.2657 | 11200.0 |
| 2010-11-30 07:20:00 | AAPL | Stock | 11.2679 | 11.2679 | 11.2536 | 11.2536 | 53480.0 |
| 2010-11-30 07:30:00 | AAPL | Stock | 11.2661 | 11.2661 | 11.2661 | 11.2661 | 5600.0 |
| 2010-11-30 07:35:00 | AAPL | Stock | 11.2696 | 11.2696 | 11.2696 | 11.2696 | 2800.0 |
| 2010-11-30 07:40:00 | AAPL | Stock | 11.2696 | 11.2718 | 11.2696 | 11.2718 | 5600.0 |
| 2010-11-30 07:50:00 | AAPL | Stock | 11.2721 | 11.2721 | 11.2632 | 11.2632 | 30800.0 |
| 2010-11-30 07:55:00 | AAPL | Stock | 11.2575 | 11.2575 | 11.2325 | 11.25 | 125860.0 |
| 2010-11-30 08:00:00 | AAPL | Stock | 11.2568 | 11.2679 | 11.2421 | 11.25 | 419776.0 |
| 2010-11-30 08:05:00 | AAPL | Stock | 11.2536 | 11.2579 | 11.2511 | 11.255 | 48244.0 |
| 2010-11-30 08:10:00 | AAPL | Stock | 11.2589 | 11.2625 | 11.2536 | 11.2554 | 203672.0 |
| 2010-11-30 08:15:00 | AAPL | Stock | 11.2518 | 11.2554 | 11.2443 | 11.2496 | 416976.0 |
| 2010-11-30 08:20:00 | AAPL | Stock | 11.2482 | 11.25 | 11.2446 | 11.2457 | 292796.0 |
| 2010-11-30 08:25:00 | AAPL | Stock | 11.2457 | 11.2475 | 11.2314 | 11.2396 | 311136.0 |
| 2010-11-30 08:30:00 | AAPL | Stock | 11.2386 | 11.2389 | 11.2146 | 11.2146 | 247800.0 |
| 2010-11-30 08:35:00 | AAPL | Stock | 11.2186 | 11.2186 | 11.1971 | 11.2089 | 560000.0 |
| 2010-11-30 08:40:00 | AAPL | Stock | 11.2139 | 11.2139 | 11.2054 | 11.2107 | 251132.0 |
| 2010-11-30 08:45:00 | AAPL | Stock | 11.2107 | 11.2243 | 11.2071 | 11.2232 | 248472.0 |
| 2010-11-30 08:50:00 | AAPL | Stock | 11.2236 | 11.2236 | 11.2146 | 11.2164 | 182056.0 |
| 2010-11-30 08:55:00 | AAPL | Stock | 11.2175 | 11.2182 | 11.2089 | 11.215 | 346892.0 |
| 2010-11-30 09:00:00 | AAPL | Stock | 11.2136 | 11.215 | 11.2018 | 11.2136 | 492800.0 |
| 2010-11-30 09:05:00 | AAPL | Stock | 11.2136 | 11.215 | 11.2107 | 11.2107 | 172088.0 |
| 2010-11-30 09:10:00 | AAPL | Stock | 11.2136 | 11.2179 | 11.2136 | 11.2179 | 132608.0 |
| 2010-11-30 09:15:00 | AAPL | Stock | 11.2179 | 11.2225 | 11.2164 | 11.2225 | 57512.0 |
| 2010-11-30 09:20:00 | AAPL | Stock | 11.2225 | 11.2268 | 11.2186 | 11.2232 | 411152.0 |
| 2010-11-30 09:25:00 | AAPL | Stock | 11.2236 | 11.2261 | 11.2036 | 11.2036 | 709828.0 |
| 2010-11-30 09:30:00 | AAPL | Stock | 11.2032 | 11.2186 | 11.1832 | 11.1964 | 15557500.0 |
| 2010-11-30 09:35:00 | AAPL | Stock | 11.1964 | 11.2036 | 11.1393 | 11.1518 | 20207964.0 |
| 2010-11-30 09:40:00 | AAPL | Stock | 11.1511 | 11.1782 | 11.1268 | 11.1656 | 17757264.0 |
| 2010-11-30 09:45:00 | AAPL | Stock | 11.1661 | 11.1929 | 11.1586 | 11.169 | 13666408.0 |
| 2010-11-30 09:50:00 | AAPL | Stock | 11.1711 | 11.1761 | 11.1468 | 11.1557 | 8998276.0 |
| 2010-11-30 09:55:00 | AAPL | Stock | 11.1521 | 11.185 | 11.1521 | 11.1757 | 8267616.0 |
| 2010-11-30 10:00:00 | AAPL | Stock | 11.1757 | 11.19 | 11.1682 | 11.1736 | 10631236.0 |
> showing 50 of 336,431 rows — these rows as CSV