PREVIEW / stock_5min / 2010-06-30
file: by_date/stock_5min/2010/2010-06-30.parquet size: 4.9 MB rows: 337,671 symbols: 3,483
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-06-30 04:15:00 | AAPL | Stock | 9.2139 | 9.2139 | 9.2139 | 9.2139 | 2800.0 |
| 2010-06-30 05:10:00 | AAPL | Stock | 9.1782 | 9.1782 | 9.1782 | 9.1782 | 2800.0 |
| 2010-06-30 05:15:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 5348.0 |
| 2010-06-30 05:20:00 | AAPL | Stock | 9.225 | 9.225 | 9.225 | 9.225 | 28000.0 |
| 2010-06-30 05:25:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 2800.0 |
| 2010-06-30 05:55:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 11592.0 |
| 2010-06-30 06:00:00 | AAPL | Stock | 9.2489 | 9.2493 | 9.2489 | 9.2493 | 8680.0 |
| 2010-06-30 06:10:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 3052.0 |
| 2010-06-30 06:15:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 7224.0 |
| 2010-06-30 06:40:00 | AAPL | Stock | 9.2286 | 9.2286 | 9.2286 | 9.2286 | 25200.0 |
| 2010-06-30 06:45:00 | AAPL | Stock | 9.2264 | 9.2264 | 9.2264 | 9.2264 | 2800.0 |
| 2010-06-30 07:00:00 | AAPL | Stock | 9.2264 | 9.2264 | 9.2189 | 9.2246 | 105784.0 |
| 2010-06-30 07:05:00 | AAPL | Stock | 9.2264 | 9.2479 | 9.2232 | 9.2479 | 86800.0 |
| 2010-06-30 07:10:00 | AAPL | Stock | 9.2393 | 9.2407 | 9.2393 | 9.2407 | 19600.0 |
| 2010-06-30 07:15:00 | AAPL | Stock | 9.2304 | 9.2482 | 9.2304 | 9.2482 | 95340.0 |
| 2010-06-30 07:20:00 | AAPL | Stock | 9.2443 | 9.2639 | 9.2443 | 9.2589 | 64960.0 |
| 2010-06-30 07:25:00 | AAPL | Stock | 9.2629 | 9.2661 | 9.25 | 9.25 | 106232.0 |
| 2010-06-30 07:30:00 | AAPL | Stock | 9.2493 | 9.25 | 9.2357 | 9.2357 | 47152.0 |
| 2010-06-30 07:35:00 | AAPL | Stock | 9.225 | 9.2411 | 9.225 | 9.2411 | 19600.0 |
| 2010-06-30 07:40:00 | AAPL | Stock | 9.2261 | 9.2393 | 9.2261 | 9.2393 | 32816.0 |
| 2010-06-30 07:45:00 | AAPL | Stock | 9.2321 | 9.2321 | 9.2214 | 9.2214 | 19600.0 |
| 2010-06-30 07:50:00 | AAPL | Stock | 9.2211 | 9.2211 | 9.2168 | 9.2168 | 11200.0 |
| 2010-06-30 07:55:00 | AAPL | Stock | 9.2211 | 9.2268 | 9.2093 | 9.2093 | 99120.0 |
| 2010-06-30 08:00:00 | AAPL | Stock | 9.2143 | 9.2286 | 9.2018 | 9.2096 | 937020.0 |
| 2010-06-30 08:05:00 | AAPL | Stock | 9.2107 | 9.2179 | 9.2054 | 9.2054 | 208348.0 |
| 2010-06-30 08:10:00 | AAPL | Stock | 9.2036 | 9.2229 | 9.1986 | 9.2125 | 271600.0 |
| 2010-06-30 08:15:00 | AAPL | Stock | 9.2143 | 9.2179 | 9.1896 | 9.1932 | 1031324.0 |
| 2010-06-30 08:20:00 | AAPL | Stock | 9.1904 | 9.1982 | 9.1839 | 9.1979 | 336056.0 |
| 2010-06-30 08:25:00 | AAPL | Stock | 9.1982 | 9.2107 | 9.1964 | 9.2071 | 411600.0 |
| 2010-06-30 08:30:00 | AAPL | Stock | 9.205 | 9.2071 | 9.2 | 9.2054 | 140084.0 |
| 2010-06-30 08:35:00 | AAPL | Stock | 9.2054 | 9.2057 | 9.1907 | 9.1964 | 118104.0 |
| 2010-06-30 08:40:00 | AAPL | Stock | 9.1939 | 9.2061 | 9.1889 | 9.2011 | 518112.0 |
| 2010-06-30 08:45:00 | AAPL | Stock | 9.2029 | 9.2029 | 9.1911 | 9.1929 | 266672.0 |
| 2010-06-30 08:50:00 | AAPL | Stock | 9.1943 | 9.1946 | 9.1725 | 9.175 | 506184.0 |
| 2010-06-30 08:55:00 | AAPL | Stock | 9.1743 | 9.1743 | 9.1518 | 9.1589 | 603484.0 |
| 2010-06-30 09:00:00 | AAPL | Stock | 9.1589 | 9.1654 | 9.1507 | 9.1539 | 170968.0 |
| 2010-06-30 09:05:00 | AAPL | Stock | 9.1525 | 9.1525 | 9.1259 | 9.1354 | 473956.0 |
| 2010-06-30 09:10:00 | AAPL | Stock | 9.1339 | 9.1361 | 9.1225 | 9.125 | 359044.0 |
| 2010-06-30 09:15:00 | AAPL | Stock | 9.125 | 9.1507 | 9.125 | 9.1507 | 243432.0 |
| 2010-06-30 09:20:00 | AAPL | Stock | 9.1539 | 9.1704 | 9.1452 | 9.1604 | 342636.0 |
| 2010-06-30 09:25:00 | AAPL | Stock | 9.1607 | 9.1768 | 9.1604 | 9.1657 | 295848.0 |
| 2010-06-30 09:30:00 | AAPL | Stock | 9.1682 | 9.1921 | 9.13 | 9.1432 | 32171888.0 |
| 2010-06-30 09:35:00 | AAPL | Stock | 9.1407 | 9.1666 | 9.0929 | 9.0979 | 27858992.0 |
| 2010-06-30 09:40:00 | AAPL | Stock | 9.0996 | 9.1446 | 9.0825 | 9.1214 | 24522596.0 |
| 2010-06-30 09:45:00 | AAPL | Stock | 9.1211 | 9.1639 | 9.1007 | 9.1564 | 24002076.0 |
| 2010-06-30 09:50:00 | AAPL | Stock | 9.1557 | 9.1696 | 9.1364 | 9.1489 | 20266596.0 |
| 2010-06-30 09:55:00 | AAPL | Stock | 9.1486 | 9.15 | 9.1254 | 9.1264 | 13810188.0 |
| 2010-06-30 10:00:00 | AAPL | Stock | 9.1264 | 9.175 | 9.1232 | 9.1686 | 19390616.0 |
| 2010-06-30 10:05:00 | AAPL | Stock | 9.1679 | 9.2132 | 9.1636 | 9.1775 | 19892264.0 |
| 2010-06-30 10:10:00 | AAPL | Stock | 9.1757 | 9.1846 | 9.155 | 9.1818 | 9415588.0 |
> showing 50 of 337,671 rows — these rows as CSV