PREVIEW / stock_5min / 2009-12-02
file: by_date/stock_5min/2009/2009-12-02.parquet size: 4.7 MB rows: 323,345 symbols: 3,428
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-02 04:15:00 | AAPL | Stock | 7.0875 | 7.0875 | 7.0875 | 7.0875 | 2800.0 |
| 2009-12-02 04:35:00 | AAPL | Stock | 7.0732 | 7.0732 | 7.0732 | 7.0732 | 4760.0 |
| 2009-12-02 05:35:00 | AAPL | Stock | 7.0775 | 7.0836 | 7.0775 | 7.0836 | 14784.0 |
| 2009-12-02 05:40:00 | AAPL | Stock | 7.0768 | 7.0768 | 7.0768 | 7.0768 | 2800.0 |
| 2009-12-02 05:45:00 | AAPL | Stock | 7.0746 | 7.0746 | 7.0607 | 7.0714 | 20160.0 |
| 2009-12-02 06:10:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0714 | 7.0714 | 14000.0 |
| 2009-12-02 06:20:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0714 | 7.0714 | 8400.0 |
| 2009-12-02 06:30:00 | AAPL | Stock | 7.0804 | 7.0804 | 7.0804 | 7.0804 | 2800.0 |
| 2009-12-02 06:50:00 | AAPL | Stock | 7.0821 | 7.0821 | 7.0821 | 7.0821 | 2800.0 |
| 2009-12-02 06:55:00 | AAPL | Stock | 7.0779 | 7.0779 | 7.0779 | 7.0779 | 2800.0 |
| 2009-12-02 07:30:00 | AAPL | Stock | 7.0857 | 7.0857 | 7.0857 | 7.0857 | 2800.0 |
| 2009-12-02 07:35:00 | AAPL | Stock | 7.0857 | 7.0857 | 7.0857 | 7.0857 | 2800.0 |
| 2009-12-02 07:45:00 | AAPL | Stock | 7.0793 | 7.0793 | 7.0793 | 7.0793 | 5600.0 |
| 2009-12-02 07:55:00 | AAPL | Stock | 7.0882 | 7.1175 | 7.0882 | 7.0946 | 52640.0 |
| 2009-12-02 08:00:00 | AAPL | Stock | 7.0982 | 7.1018 | 7.0954 | 7.0964 | 174356.0 |
| 2009-12-02 08:05:00 | AAPL | Stock | 7.0982 | 7.1018 | 7.0964 | 7.1018 | 89012.0 |
| 2009-12-02 08:10:00 | AAPL | Stock | 7.1007 | 7.12 | 7.1007 | 7.1125 | 509376.0 |
| 2009-12-02 08:15:00 | AAPL | Stock | 7.1107 | 7.1118 | 7.1075 | 7.1118 | 203420.0 |
| 2009-12-02 08:20:00 | AAPL | Stock | 7.1118 | 7.1136 | 7.0996 | 7.1064 | 334852.0 |
| 2009-12-02 08:25:00 | AAPL | Stock | 7.1064 | 7.1086 | 7.1037 | 7.1071 | 86240.0 |
| 2009-12-02 08:30:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.0346 | 7.105 | 225288.0 |
| 2009-12-02 08:35:00 | AAPL | Stock | 7.1043 | 7.1057 | 7.0982 | 7.0982 | 216608.0 |
| 2009-12-02 08:40:00 | AAPL | Stock | 7.1 | 7.1007 | 7.0948 | 7.0948 | 189868.0 |
| 2009-12-02 08:45:00 | AAPL | Stock | 7.0964 | 7.0982 | 7.0896 | 7.0964 | 170604.0 |
| 2009-12-02 08:50:00 | AAPL | Stock | 7.0993 | 7.1029 | 7.0964 | 7.0964 | 99400.0 |
| 2009-12-02 08:55:00 | AAPL | Stock | 7.0954 | 7.0979 | 7.0939 | 7.0941 | 60200.0 |
| 2009-12-02 09:00:00 | AAPL | Stock | 7.0964 | 7.0982 | 7.0961 | 7.0964 | 123200.0 |
| 2009-12-02 09:05:00 | AAPL | Stock | 7.0989 | 7.1036 | 7.0971 | 7.1029 | 182140.0 |
| 2009-12-02 09:10:00 | AAPL | Stock | 7.1014 | 7.1036 | 7.1 | 7.1 | 96600.0 |
| 2009-12-02 09:15:00 | AAPL | Stock | 7.0996 | 7.105 | 7.0996 | 7.1029 | 57232.0 |
| 2009-12-02 09:20:00 | AAPL | Stock | 7.1032 | 7.1032 | 7.1011 | 7.1032 | 37660.0 |
| 2009-12-02 09:25:00 | AAPL | Stock | 7.1036 | 7.1071 | 7.0939 | 7.1018 | 828800.0 |
| 2009-12-02 09:30:00 | AAPL | Stock | 7.1014 | 7.1343 | 7.0718 | 7.1331 | 24102876.0 |
| 2009-12-02 09:35:00 | AAPL | Stock | 7.1325 | 7.134 | 7.1161 | 7.1232 | 12407920.0 |
| 2009-12-02 09:40:00 | AAPL | Stock | 7.1227 | 7.1343 | 7.0929 | 7.0968 | 12659108.0 |
| 2009-12-02 09:45:00 | AAPL | Stock | 7.0968 | 7.1036 | 7.0829 | 7.0971 | 12412008.0 |
| 2009-12-02 09:50:00 | AAPL | Stock | 7.0986 | 7.1207 | 7.0904 | 7.1127 | 13046460.0 |
| 2009-12-02 09:55:00 | AAPL | Stock | 7.1125 | 7.125 | 7.11 | 7.1179 | 7268436.0 |
| 2009-12-02 10:00:00 | AAPL | Stock | 7.1179 | 7.1314 | 7.1154 | 7.1289 | 7433468.0 |
| 2009-12-02 10:05:00 | AAPL | Stock | 7.1284 | 7.1339 | 7.1164 | 7.1332 | 8943312.0 |
| 2009-12-02 10:10:00 | AAPL | Stock | 7.1325 | 7.1607 | 7.1324 | 7.1586 | 17287900.0 |
| 2009-12-02 10:15:00 | AAPL | Stock | 7.1596 | 7.1607 | 7.1486 | 7.1514 | 12419232.0 |
| 2009-12-02 10:20:00 | AAPL | Stock | 7.1507 | 7.1529 | 7.1402 | 7.1486 | 9312632.0 |
| 2009-12-02 10:25:00 | AAPL | Stock | 7.1486 | 7.1607 | 7.1464 | 7.1582 | 8090544.0 |
| 2009-12-02 10:30:00 | AAPL | Stock | 7.1568 | 7.1861 | 7.1507 | 7.1786 | 19277776.0 |
| 2009-12-02 10:35:00 | AAPL | Stock | 7.1793 | 7.1936 | 7.1718 | 7.1857 | 9471924.0 |
| 2009-12-02 10:40:00 | AAPL | Stock | 7.1868 | 7.1871 | 7.1704 | 7.1718 | 5555172.0 |
| 2009-12-02 10:45:00 | AAPL | Stock | 7.172 | 7.1779 | 7.1618 | 7.1621 | 6557516.0 |
| 2009-12-02 10:50:00 | AAPL | Stock | 7.1618 | 7.1636 | 7.1486 | 7.1571 | 6337772.0 |
| 2009-12-02 10:55:00 | AAPL | Stock | 7.1575 | 7.1575 | 7.1471 | 7.1493 | 5183500.0 |
> showing 50 of 323,345 rows — these rows as CSV