PREVIEW / stock_5min / 2013-02-04
file: by_date/stock_5min/2013/2013-02-04.parquet size: 4.9 MB rows: 333,016 symbols: 3,480
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-04 04:00:00 | AAPL | Stock | 16.2218 | 16.2218 | 16.2218 | 16.2218 | 5600.0 |
| 2013-02-04 05:30:00 | AAPL | Stock | 16.2143 | 16.2143 | 16.2143 | 16.2143 | 27860.0 |
| 2013-02-04 05:55:00 | AAPL | Stock | 16.2143 | 16.2143 | 16.2143 | 16.2143 | 2800.0 |
| 2013-02-04 06:25:00 | AAPL | Stock | 16.2071 | 16.2071 | 16.2018 | 16.2018 | 19600.0 |
| 2013-02-04 06:30:00 | AAPL | Stock | 16.2264 | 16.2264 | 16.2264 | 16.2264 | 2800.0 |
| 2013-02-04 06:50:00 | AAPL | Stock | 16.2261 | 16.2261 | 16.1879 | 16.1879 | 27916.0 |
| 2013-02-04 07:00:00 | AAPL | Stock | 16.2036 | 16.2036 | 16.2036 | 16.2036 | 40460.0 |
| 2013-02-04 07:05:00 | AAPL | Stock | 16.2121 | 16.2214 | 16.2 | 16.2007 | 33600.0 |
| 2013-02-04 07:10:00 | AAPL | Stock | 16.2007 | 16.2007 | 16.1929 | 16.1929 | 44800.0 |
| 2013-02-04 07:15:00 | AAPL | Stock | 16.1843 | 16.1843 | 16.1786 | 16.1786 | 33600.0 |
| 2013-02-04 07:20:00 | AAPL | Stock | 16.1696 | 16.1786 | 16.1696 | 16.1786 | 8400.0 |
| 2013-02-04 07:25:00 | AAPL | Stock | 16.1643 | 16.1643 | 16.1407 | 16.1421 | 99316.0 |
| 2013-02-04 07:30:00 | AAPL | Stock | 16.1432 | 16.1786 | 16.1429 | 16.1786 | 39004.0 |
| 2013-02-04 07:35:00 | AAPL | Stock | 16.15 | 16.1857 | 16.15 | 16.1786 | 117964.0 |
| 2013-02-04 07:40:00 | AAPL | Stock | 16.1786 | 16.1804 | 16.1786 | 16.1786 | 42000.0 |
| 2013-02-04 07:45:00 | AAPL | Stock | 16.1754 | 16.1754 | 16.175 | 16.175 | 8400.0 |
| 2013-02-04 07:50:00 | AAPL | Stock | 16.1786 | 16.1786 | 16.1679 | 16.1679 | 64848.0 |
| 2013-02-04 08:00:00 | AAPL | Stock | 16.1879 | 16.2 | 16.125 | 16.1286 | 217168.0 |
| 2013-02-04 08:05:00 | AAPL | Stock | 16.125 | 16.1393 | 16.1082 | 16.1082 | 184884.0 |
| 2013-02-04 08:10:00 | AAPL | Stock | 16.1107 | 16.1175 | 16.0414 | 16.0414 | 271684.0 |
| 2013-02-04 08:15:00 | AAPL | Stock | 16.0457 | 16.1521 | 16.0457 | 16.0525 | 341656.0 |
| 2013-02-04 08:20:00 | AAPL | Stock | 16.05 | 16.0557 | 16.0268 | 16.0536 | 394716.0 |
| 2013-02-04 08:25:00 | AAPL | Stock | 16.05 | 16.0514 | 16.0368 | 16.0421 | 43400.0 |
| 2013-02-04 08:30:00 | AAPL | Stock | 16.0511 | 16.0625 | 16.0507 | 16.0621 | 99400.0 |
| 2013-02-04 08:35:00 | AAPL | Stock | 16.0625 | 16.0918 | 16.0625 | 16.0918 | 121212.0 |
| 2013-02-04 08:40:00 | AAPL | Stock | 16.1018 | 16.1321 | 16.0943 | 16.1204 | 295344.0 |
| 2013-02-04 08:45:00 | AAPL | Stock | 16.1182 | 16.125 | 16.1118 | 16.1214 | 181160.0 |
| 2013-02-04 08:50:00 | AAPL | Stock | 16.1164 | 16.1261 | 16.1111 | 16.125 | 146440.0 |
| 2013-02-04 08:55:00 | AAPL | Stock | 16.12 | 16.1429 | 16.1171 | 16.1257 | 293272.0 |
| 2013-02-04 09:00:00 | AAPL | Stock | 16.1329 | 16.1343 | 16.125 | 16.1264 | 128520.0 |
| 2013-02-04 09:05:00 | AAPL | Stock | 16.1329 | 16.1514 | 16.1321 | 16.1514 | 39200.0 |
| 2013-02-04 09:10:00 | AAPL | Stock | 16.1464 | 16.2411 | 16.1461 | 16.2143 | 923440.0 |
| 2013-02-04 09:15:00 | AAPL | Stock | 16.2225 | 16.2804 | 16.2146 | 16.2482 | 729680.0 |
| 2013-02-04 09:20:00 | AAPL | Stock | 16.2461 | 16.2482 | 16.2261 | 16.2321 | 490784.0 |
| 2013-02-04 09:25:00 | AAPL | Stock | 16.2379 | 16.2411 | 16.1921 | 16.2146 | 945952.0 |
| 2013-02-04 09:30:00 | AAPL | Stock | 16.2121 | 16.2836 | 16.1932 | 16.2607 | 21509516.0 |
| 2013-02-04 09:35:00 | AAPL | Stock | 16.2614 | 16.2636 | 16.1457 | 16.1736 | 11878580.0 |
| 2013-02-04 09:40:00 | AAPL | Stock | 16.1679 | 16.1693 | 16.0918 | 16.1254 | 9897692.0 |
| 2013-02-04 09:45:00 | AAPL | Stock | 16.1218 | 16.1679 | 16.0929 | 16.1568 | 8109080.0 |
| 2013-02-04 09:50:00 | AAPL | Stock | 16.1625 | 16.1646 | 16.1111 | 16.1279 | 6101004.0 |
| 2013-02-04 09:55:00 | AAPL | Stock | 16.1285 | 16.1693 | 16.0825 | 16.0865 | 6891332.0 |
| 2013-02-04 10:00:00 | AAPL | Stock | 16.0843 | 16.1071 | 16.0571 | 16.0757 | 12515580.0 |
| 2013-02-04 10:05:00 | AAPL | Stock | 16.0714 | 16.1189 | 16.0632 | 16.1096 | 6453916.0 |
| 2013-02-04 10:10:00 | AAPL | Stock | 16.1064 | 16.115 | 16.0504 | 16.0671 | 6686596.0 |
| 2013-02-04 10:15:00 | AAPL | Stock | 16.0664 | 16.1071 | 16.0446 | 16.0668 | 5443256.0 |
| 2013-02-04 10:20:00 | AAPL | Stock | 16.0668 | 16.1161 | 16.0604 | 16.1008 | 5777772.0 |
| 2013-02-04 10:25:00 | AAPL | Stock | 16.1007 | 16.1018 | 16.0586 | 16.0886 | 5165888.0 |
| 2013-02-04 10:30:00 | AAPL | Stock | 16.0811 | 16.0954 | 16.0639 | 16.0871 | 4063668.0 |
| 2013-02-04 10:35:00 | AAPL | Stock | 16.0854 | 16.1386 | 16.0765 | 16.1261 | 9701384.0 |
| 2013-02-04 10:40:00 | AAPL | Stock | 16.1311 | 16.1529 | 16.1168 | 16.1354 | 7281904.0 |
> showing 50 of 333,016 rows — these rows as CSV