PREVIEW / stock_5min / 2013-02-25
file: by_date/stock_5min/2013/2013-02-25.parquet size: 5.1 MB rows: 337,676 symbols: 3,496
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-25 04:35:00 | AAPL | Stock | 16.1679 | 16.1679 | 16.1679 | 16.1679 | 5600.0 |
| 2013-02-25 05:50:00 | AAPL | Stock | 16.2393 | 16.2393 | 16.2393 | 16.2393 | 2800.0 |
| 2013-02-25 05:55:00 | AAPL | Stock | 16.2429 | 16.2429 | 16.2429 | 16.2429 | 2800.0 |
| 2013-02-25 06:00:00 | AAPL | Stock | 16.2429 | 16.2429 | 16.2429 | 16.2429 | 2800.0 |
| 2013-02-25 06:05:00 | AAPL | Stock | 16.2321 | 16.2321 | 16.2321 | 16.2321 | 2800.0 |
| 2013-02-25 06:10:00 | AAPL | Stock | 16.2107 | 16.2107 | 16.2107 | 16.2107 | 2800.0 |
| 2013-02-25 06:15:00 | AAPL | Stock | 16.2107 | 16.2107 | 16.2107 | 16.2107 | 9800.0 |
| 2013-02-25 06:30:00 | AAPL | Stock | 16.23 | 16.2321 | 16.225 | 16.225 | 9100.0 |
| 2013-02-25 06:45:00 | AAPL | Stock | 16.225 | 16.225 | 16.2143 | 16.2143 | 11200.0 |
| 2013-02-25 06:50:00 | AAPL | Stock | 16.2089 | 16.2089 | 16.2071 | 16.2071 | 5600.0 |
| 2013-02-25 06:55:00 | AAPL | Stock | 16.2079 | 16.2079 | 16.1964 | 16.2071 | 44800.0 |
| 2013-02-25 07:00:00 | AAPL | Stock | 16.2179 | 16.2321 | 16.2143 | 16.2143 | 153300.0 |
| 2013-02-25 07:05:00 | AAPL | Stock | 16.2007 | 16.2143 | 16.2007 | 16.2143 | 24360.0 |
| 2013-02-25 07:10:00 | AAPL | Stock | 16.2146 | 16.2146 | 16.2143 | 16.2143 | 21000.0 |
| 2013-02-25 07:15:00 | AAPL | Stock | 16.2146 | 16.2389 | 16.2143 | 16.2214 | 92092.0 |
| 2013-02-25 07:20:00 | AAPL | Stock | 16.2404 | 16.2411 | 16.235 | 16.235 | 47600.0 |
| 2013-02-25 07:25:00 | AAPL | Stock | 16.2357 | 16.2482 | 16.2357 | 16.2482 | 41664.0 |
| 2013-02-25 07:30:00 | AAPL | Stock | 16.2482 | 16.2536 | 16.2411 | 16.2411 | 46592.0 |
| 2013-02-25 07:35:00 | AAPL | Stock | 16.2375 | 16.2375 | 16.2375 | 16.2375 | 14000.0 |
| 2013-02-25 07:40:00 | AAPL | Stock | 16.2375 | 16.2439 | 16.2339 | 16.2357 | 37100.0 |
| 2013-02-25 07:45:00 | AAPL | Stock | 16.2439 | 16.25 | 16.2414 | 16.25 | 43540.0 |
| 2013-02-25 07:50:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 2800.0 |
| 2013-02-25 07:55:00 | AAPL | Stock | 16.25 | 16.25 | 16.2425 | 16.2429 | 52500.0 |
| 2013-02-25 08:00:00 | AAPL | Stock | 16.2429 | 16.25 | 16.2107 | 16.2107 | 305900.0 |
| 2013-02-25 08:05:00 | AAPL | Stock | 16.0714 | 16.2111 | 16.0714 | 16.1886 | 296856.0 |
| 2013-02-25 08:10:00 | AAPL | Stock | 16.1836 | 16.1882 | 16.1696 | 16.17 | 113568.0 |
| 2013-02-25 08:15:00 | AAPL | Stock | 16.1711 | 16.1711 | 16.1186 | 16.125 | 179900.0 |
| 2013-02-25 08:20:00 | AAPL | Stock | 16.1429 | 16.1736 | 16.1393 | 16.1625 | 87500.0 |
| 2013-02-25 08:25:00 | AAPL | Stock | 16.1611 | 16.1621 | 16.1521 | 16.1607 | 29904.0 |
| 2013-02-25 08:30:00 | AAPL | Stock | 16.1607 | 16.1671 | 16.1529 | 16.1529 | 152180.0 |
| 2013-02-25 08:35:00 | AAPL | Stock | 16.1582 | 16.1593 | 16.1393 | 16.1518 | 165564.0 |
| 2013-02-25 08:40:00 | AAPL | Stock | 16.1521 | 16.1754 | 16.1521 | 16.1754 | 61040.0 |
| 2013-02-25 08:45:00 | AAPL | Stock | 16.1661 | 16.1675 | 16.1546 | 16.1675 | 95844.0 |
| 2013-02-25 08:50:00 | AAPL | Stock | 16.1679 | 16.1679 | 16.1571 | 16.1571 | 14000.0 |
| 2013-02-25 08:55:00 | AAPL | Stock | 16.1571 | 16.1571 | 16.1518 | 16.1518 | 22064.0 |
| 2013-02-25 09:00:00 | AAPL | Stock | 16.1518 | 16.1891 | 16.1443 | 16.1886 | 333648.0 |
| 2013-02-25 09:05:00 | AAPL | Stock | 16.1857 | 16.1929 | 16.1779 | 16.1829 | 87500.0 |
| 2013-02-25 09:10:00 | AAPL | Stock | 16.1868 | 16.2132 | 16.1868 | 16.2132 | 299516.0 |
| 2013-02-25 09:15:00 | AAPL | Stock | 16.2129 | 16.2207 | 16.205 | 16.2082 | 289240.0 |
| 2013-02-25 09:20:00 | AAPL | Stock | 16.2104 | 16.2243 | 16.2093 | 16.2204 | 400316.0 |
| 2013-02-25 09:25:00 | AAPL | Stock | 16.2182 | 16.2286 | 16.2014 | 16.2029 | 524552.0 |
| 2013-02-25 09:30:00 | AAPL | Stock | 16.21 | 16.2321 | 16.1439 | 16.1543 | 17368568.0 |
| 2013-02-25 09:35:00 | AAPL | Stock | 16.1518 | 16.2139 | 16.1443 | 16.1704 | 7930440.0 |
| 2013-02-25 09:40:00 | AAPL | Stock | 16.1696 | 16.225 | 16.1625 | 16.2079 | 7844676.0 |
| 2013-02-25 09:45:00 | AAPL | Stock | 16.2017 | 16.2082 | 16.1761 | 16.1786 | 5252912.0 |
| 2013-02-25 09:50:00 | AAPL | Stock | 16.1796 | 16.2311 | 16.1607 | 16.2311 | 6402004.0 |
| 2013-02-25 09:55:00 | AAPL | Stock | 16.2311 | 16.2432 | 16.2107 | 16.2214 | 5899880.0 |
| 2013-02-25 10:00:00 | AAPL | Stock | 16.2221 | 16.2536 | 16.2214 | 16.2286 | 10296832.0 |
| 2013-02-25 10:05:00 | AAPL | Stock | 16.2296 | 16.2543 | 16.2093 | 16.2182 | 8670256.0 |
| 2013-02-25 10:10:00 | AAPL | Stock | 16.2161 | 16.2321 | 16.2057 | 16.2314 | 5631892.0 |
> showing 50 of 337,676 rows — these rows as CSV