PREVIEW / stock_5min / 2012-08-09
file: by_date/stock_5min/2012/2012-08-09.parquet size: 4.6 MB rows: 311,154 symbols: 3,482
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-09 04:00:00 | AAPL | Stock | 22.1179 | 22.1179 | 22.1179 | 22.1179 | 4200.0 |
| 2012-08-09 07:05:00 | AAPL | Stock | 22.0893 | 22.0907 | 22.0714 | 22.075 | 25200.0 |
| 2012-08-09 07:10:00 | AAPL | Stock | 22.0857 | 22.0871 | 22.0857 | 22.0871 | 5880.0 |
| 2012-08-09 07:15:00 | AAPL | Stock | 22.0732 | 22.075 | 22.0661 | 22.0671 | 33600.0 |
| 2012-08-09 07:20:00 | AAPL | Stock | 22.0661 | 22.0714 | 22.0661 | 22.0679 | 22400.0 |
| 2012-08-09 07:30:00 | AAPL | Stock | 22.0664 | 22.0664 | 22.0664 | 22.0664 | 5600.0 |
| 2012-08-09 07:40:00 | AAPL | Stock | 22.0593 | 22.0593 | 22.0593 | 22.0593 | 2800.0 |
| 2012-08-09 07:45:00 | AAPL | Stock | 22.0518 | 22.0518 | 22.0021 | 22.0354 | 206976.0 |
| 2012-08-09 07:50:00 | AAPL | Stock | 22.0275 | 22.0325 | 22.0179 | 22.0214 | 68992.0 |
| 2012-08-09 07:55:00 | AAPL | Stock | 22.0236 | 22.05 | 22.0179 | 22.05 | 378560.0 |
| 2012-08-09 08:00:00 | AAPL | Stock | 22.0536 | 22.0536 | 22.0179 | 22.0318 | 178500.0 |
| 2012-08-09 08:05:00 | AAPL | Stock | 22.0314 | 22.0443 | 22.025 | 22.0443 | 324856.0 |
| 2012-08-09 08:10:00 | AAPL | Stock | 22.0329 | 22.0396 | 22.0293 | 22.0354 | 64260.0 |
| 2012-08-09 08:15:00 | AAPL | Stock | 22.0357 | 22.0393 | 22.0357 | 22.0393 | 33600.0 |
| 2012-08-09 08:20:00 | AAPL | Stock | 22.0429 | 22.0536 | 22.0429 | 22.0464 | 75600.0 |
| 2012-08-09 08:25:00 | AAPL | Stock | 22.0457 | 22.0504 | 22.0446 | 22.045 | 85400.0 |
| 2012-08-09 08:30:00 | AAPL | Stock | 22.05 | 22.0714 | 22.0446 | 22.0536 | 212072.0 |
| 2012-08-09 08:35:00 | AAPL | Stock | 22.0596 | 22.0793 | 22.0582 | 22.0736 | 227724.0 |
| 2012-08-09 08:40:00 | AAPL | Stock | 22.0789 | 22.0889 | 22.0771 | 22.0818 | 197960.0 |
| 2012-08-09 08:45:00 | AAPL | Stock | 22.0814 | 22.0814 | 22.0643 | 22.075 | 165480.0 |
| 2012-08-09 08:50:00 | AAPL | Stock | 22.075 | 22.0782 | 22.0632 | 22.0632 | 94668.0 |
| 2012-08-09 08:55:00 | AAPL | Stock | 22.0643 | 22.0746 | 22.0643 | 22.0714 | 62412.0 |
| 2012-08-09 09:00:00 | AAPL | Stock | 22.075 | 22.0893 | 22.075 | 22.0839 | 272188.0 |
| 2012-08-09 09:05:00 | AAPL | Stock | 22.0804 | 22.0979 | 22.0796 | 22.0968 | 110600.0 |
| 2012-08-09 09:10:00 | AAPL | Stock | 22.0961 | 22.0986 | 22.0871 | 22.0871 | 244720.0 |
| 2012-08-09 09:15:00 | AAPL | Stock | 22.0864 | 22.0879 | 22.0646 | 22.0714 | 326396.0 |
| 2012-08-09 09:20:00 | AAPL | Stock | 22.0768 | 22.0804 | 22.0536 | 22.0536 | 233548.0 |
| 2012-08-09 09:25:00 | AAPL | Stock | 22.0536 | 22.0696 | 22.0536 | 22.0661 | 335132.0 |
| 2012-08-09 09:30:00 | AAPL | Stock | 22.0661 | 22.1339 | 22.0643 | 22.094 | 9435720.0 |
| 2012-08-09 09:35:00 | AAPL | Stock | 22.0939 | 22.1714 | 22.0907 | 22.1636 | 8201340.0 |
| 2012-08-09 09:40:00 | AAPL | Stock | 22.1639 | 22.2 | 22.1471 | 22.1643 | 7165704.0 |
| 2012-08-09 09:45:00 | AAPL | Stock | 22.1661 | 22.1871 | 22.1532 | 22.1625 | 3655484.0 |
| 2012-08-09 09:50:00 | AAPL | Stock | 22.1625 | 22.1729 | 22.1571 | 22.1704 | 2673104.0 |
| 2012-08-09 09:55:00 | AAPL | Stock | 22.1689 | 22.1914 | 22.1493 | 22.1593 | 4998896.0 |
| 2012-08-09 10:00:00 | AAPL | Stock | 22.1554 | 22.1714 | 22.1486 | 22.1546 | 3734472.0 |
| 2012-08-09 10:05:00 | AAPL | Stock | 22.155 | 22.1607 | 22.1311 | 22.1355 | 3360700.0 |
| 2012-08-09 10:10:00 | AAPL | Stock | 22.1375 | 22.15 | 22.1321 | 22.1375 | 2924460.0 |
| 2012-08-09 10:15:00 | AAPL | Stock | 22.1407 | 22.1675 | 22.14 | 22.1668 | 2018576.0 |
| 2012-08-09 10:20:00 | AAPL | Stock | 22.1675 | 22.1843 | 22.1614 | 22.1661 | 3464916.0 |
| 2012-08-09 10:25:00 | AAPL | Stock | 22.1675 | 22.175 | 22.1554 | 22.1709 | 2291688.0 |
| 2012-08-09 10:30:00 | AAPL | Stock | 22.1721 | 22.2046 | 22.1696 | 22.1964 | 3648372.0 |
| 2012-08-09 10:35:00 | AAPL | Stock | 22.1978 | 22.2036 | 22.1786 | 22.1852 | 3792208.0 |
| 2012-08-09 10:40:00 | AAPL | Stock | 22.1871 | 22.1929 | 22.1707 | 22.1789 | 3424232.0 |
| 2012-08-09 10:45:00 | AAPL | Stock | 22.1793 | 22.1896 | 22.1771 | 22.1893 | 2100252.0 |
| 2012-08-09 10:50:00 | AAPL | Stock | 22.1889 | 22.1936 | 22.1732 | 22.1746 | 2540300.0 |
| 2012-08-09 10:55:00 | AAPL | Stock | 22.1732 | 22.1814 | 22.1643 | 22.1793 | 2556400.0 |
| 2012-08-09 11:00:00 | AAPL | Stock | 22.1786 | 22.1825 | 22.1536 | 22.1621 | 2463692.0 |
| 2012-08-09 11:05:00 | AAPL | Stock | 22.1618 | 22.1618 | 22.1429 | 22.1514 | 2232776.0 |
| 2012-08-09 11:10:00 | AAPL | Stock | 22.15 | 22.1629 | 22.1443 | 22.1589 | 1547392.0 |
| 2012-08-09 11:15:00 | AAPL | Stock | 22.1595 | 22.1786 | 22.1504 | 22.175 | 1746556.0 |
> showing 50 of 311,154 rows — these rows as CSV