PREVIEW / stock_5min / 2012-12-11
file: by_date/stock_5min/2012/2012-12-11.parquet size: 4.9 MB rows: 333,324 symbols: 3,494
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-12-11 04:00:00 | AAPL | Stock | 19.0179 | 19.0486 | 19.0179 | 19.0486 | 8400.0 |
| 2012-12-11 04:05:00 | AAPL | Stock | 19.0511 | 19.0729 | 19.0511 | 19.0729 | 9800.0 |
| 2012-12-11 04:10:00 | AAPL | Stock | 19.0839 | 19.0839 | 19.0839 | 19.0839 | 2800.0 |
| 2012-12-11 04:15:00 | AAPL | Stock | 19.0557 | 19.0975 | 19.0554 | 19.0975 | 11200.0 |
| 2012-12-11 04:20:00 | AAPL | Stock | 19.0546 | 19.0546 | 19.0357 | 19.0357 | 17136.0 |
| 2012-12-11 04:35:00 | AAPL | Stock | 19.0368 | 19.0368 | 19.0368 | 19.0368 | 2800.0 |
| 2012-12-11 04:40:00 | AAPL | Stock | 19.0186 | 19.0186 | 19.0186 | 19.0186 | 2800.0 |
| 2012-12-11 04:45:00 | AAPL | Stock | 19.0818 | 19.0818 | 19.0818 | 19.0818 | 10640.0 |
| 2012-12-11 05:05:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0654 | 19.0654 | 5600.0 |
| 2012-12-11 05:10:00 | AAPL | Stock | 19.0518 | 19.0714 | 19.0518 | 19.0714 | 25200.0 |
| 2012-12-11 05:20:00 | AAPL | Stock | 19.0804 | 19.0804 | 19.0804 | 19.0804 | 5600.0 |
| 2012-12-11 05:25:00 | AAPL | Stock | 19.0839 | 19.0839 | 19.0839 | 19.0839 | 5600.0 |
| 2012-12-11 05:45:00 | AAPL | Stock | 19.0571 | 19.0571 | 19.0571 | 19.0571 | 2800.0 |
| 2012-12-11 05:50:00 | AAPL | Stock | 19.0807 | 19.0807 | 19.0536 | 19.0536 | 16800.0 |
| 2012-12-11 06:05:00 | AAPL | Stock | 19.0586 | 19.0586 | 19.0586 | 19.0586 | 2800.0 |
| 2012-12-11 06:10:00 | AAPL | Stock | 19.0446 | 19.0446 | 19.0446 | 19.0446 | 2800.0 |
| 2012-12-11 06:15:00 | AAPL | Stock | 19.0693 | 19.0693 | 19.0693 | 19.0693 | 2800.0 |
| 2012-12-11 06:30:00 | AAPL | Stock | 19.0511 | 19.0511 | 19.0511 | 19.0511 | 2800.0 |
| 2012-12-11 06:35:00 | AAPL | Stock | 19.0525 | 19.0546 | 19.0525 | 19.0546 | 5600.0 |
| 2012-12-11 06:40:00 | AAPL | Stock | 19.0446 | 19.0446 | 19.0446 | 19.0446 | 2800.0 |
| 2012-12-11 06:45:00 | AAPL | Stock | 19.0486 | 19.0536 | 19.0446 | 19.0446 | 14000.0 |
| 2012-12-11 06:50:00 | AAPL | Stock | 19.0607 | 19.0679 | 19.0607 | 19.0632 | 19600.0 |
| 2012-12-11 06:55:00 | AAPL | Stock | 19.0668 | 19.0668 | 19.0668 | 19.0668 | 2800.0 |
| 2012-12-11 07:00:00 | AAPL | Stock | 19.0614 | 19.0614 | 19.0071 | 19.0268 | 47600.0 |
| 2012-12-11 07:05:00 | AAPL | Stock | 19.02 | 19.0357 | 19.02 | 19.0357 | 11816.0 |
| 2012-12-11 07:10:00 | AAPL | Stock | 19.0446 | 19.0486 | 19.0446 | 19.0482 | 54460.0 |
| 2012-12-11 07:15:00 | AAPL | Stock | 19.0396 | 19.0396 | 19.0329 | 19.0386 | 27860.0 |
| 2012-12-11 07:20:00 | AAPL | Stock | 19.0446 | 19.0625 | 19.0446 | 19.0446 | 49252.0 |
| 2012-12-11 07:25:00 | AAPL | Stock | 19.0536 | 19.1 | 19.0536 | 19.1 | 48468.0 |
| 2012-12-11 07:30:00 | AAPL | Stock | 19.0993 | 19.1 | 19.0804 | 19.0875 | 71680.0 |
| 2012-12-11 07:35:00 | AAPL | Stock | 19.0939 | 19.0975 | 19.0796 | 19.0796 | 32060.0 |
| 2012-12-11 07:40:00 | AAPL | Stock | 19.0761 | 19.0857 | 19.0714 | 19.0714 | 44660.0 |
| 2012-12-11 07:45:00 | AAPL | Stock | 19.0718 | 19.0721 | 19.0714 | 19.0721 | 34720.0 |
| 2012-12-11 07:50:00 | AAPL | Stock | 19.0721 | 19.0839 | 19.0714 | 19.0804 | 33600.0 |
| 2012-12-11 07:55:00 | AAPL | Stock | 19.0839 | 19.0861 | 19.0807 | 19.0854 | 22400.0 |
| 2012-12-11 08:00:00 | AAPL | Stock | 19.0954 | 19.1407 | 19.0357 | 19.125 | 614600.0 |
| 2012-12-11 08:05:00 | AAPL | Stock | 19.1296 | 19.1779 | 19.125 | 19.1629 | 642208.0 |
| 2012-12-11 08:10:00 | AAPL | Stock | 19.1764 | 19.1979 | 19.1729 | 19.1964 | 556416.0 |
| 2012-12-11 08:15:00 | AAPL | Stock | 19.2029 | 19.2236 | 19.1829 | 19.2107 | 429128.0 |
| 2012-12-11 08:20:00 | AAPL | Stock | 19.2093 | 19.2096 | 19.185 | 19.1886 | 273224.0 |
| 2012-12-11 08:25:00 | AAPL | Stock | 19.1861 | 19.1929 | 19.1825 | 19.1875 | 98588.0 |
| 2012-12-11 08:30:00 | AAPL | Stock | 19.1875 | 19.1911 | 19.1825 | 19.1825 | 482076.0 |
| 2012-12-11 08:35:00 | AAPL | Stock | 19.1825 | 19.1875 | 19.1521 | 19.1657 | 557760.0 |
| 2012-12-11 08:40:00 | AAPL | Stock | 19.1661 | 19.1729 | 19.1614 | 19.1629 | 217868.0 |
| 2012-12-11 08:45:00 | AAPL | Stock | 19.1686 | 19.1764 | 19.1646 | 19.1721 | 190064.0 |
| 2012-12-11 08:50:00 | AAPL | Stock | 19.1721 | 19.1721 | 19.1521 | 19.1521 | 220360.0 |
| 2012-12-11 08:55:00 | AAPL | Stock | 19.1521 | 19.1668 | 19.1521 | 19.1575 | 130452.0 |
| 2012-12-11 09:00:00 | AAPL | Stock | 19.1596 | 19.1689 | 19.1586 | 19.1689 | 111916.0 |
| 2012-12-11 09:05:00 | AAPL | Stock | 19.1689 | 19.1875 | 19.1689 | 19.1839 | 193256.0 |
| 2012-12-11 09:10:00 | AAPL | Stock | 19.1829 | 19.2089 | 19.1821 | 19.1996 | 586432.0 |
> showing 50 of 333,324 rows — these rows as CSV