PREVIEW / stock_5min / 2012-05-09
file: by_date/stock_5min/2012/2012-05-09.parquet size: 5.0 MB rows: 333,777 symbols: 3,524
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-05-09 04:20:00 | AAPL | Stock | 20.2179 | 20.2179 | 20.2143 | 20.2143 | 5600.0 |
| 2012-05-09 05:10:00 | AAPL | Stock | 20.2004 | 20.2004 | 20.2004 | 20.2004 | 2800.0 |
| 2012-05-09 05:20:00 | AAPL | Stock | 20.1968 | 20.1968 | 20.1968 | 20.1968 | 16800.0 |
| 2012-05-09 05:25:00 | AAPL | Stock | 20.1968 | 20.1968 | 20.1968 | 20.1968 | 2800.0 |
| 2012-05-09 05:30:00 | AAPL | Stock | 20.1968 | 20.1968 | 20.1968 | 20.1968 | 2800.0 |
| 2012-05-09 05:35:00 | AAPL | Stock | 20.1968 | 20.1968 | 20.1968 | 20.1968 | 19600.0 |
| 2012-05-09 05:40:00 | AAPL | Stock | 20.1968 | 20.1968 | 20.1968 | 20.1968 | 14000.0 |
| 2012-05-09 06:20:00 | AAPL | Stock | 20.1968 | 20.1968 | 20.1968 | 20.1968 | 14000.0 |
| 2012-05-09 06:40:00 | AAPL | Stock | 20.1968 | 20.1968 | 20.1968 | 20.1968 | 2800.0 |
| 2012-05-09 06:45:00 | AAPL | Stock | 20.1968 | 20.1968 | 20.1968 | 20.1968 | 54600.0 |
| 2012-05-09 06:50:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.2143 | 20.2143 | 8400.0 |
| 2012-05-09 06:55:00 | AAPL | Stock | 20.1968 | 20.1968 | 20.175 | 20.175 | 33600.0 |
| 2012-05-09 07:00:00 | AAPL | Stock | 20.2018 | 20.2018 | 20.1711 | 20.1714 | 39480.0 |
| 2012-05-09 07:05:00 | AAPL | Stock | 20.1786 | 20.1814 | 20.1711 | 20.1789 | 36008.0 |
| 2012-05-09 07:10:00 | AAPL | Stock | 20.1786 | 20.1786 | 20.1711 | 20.1711 | 55440.0 |
| 2012-05-09 07:15:00 | AAPL | Stock | 20.1839 | 20.1875 | 20.1839 | 20.1875 | 8652.0 |
| 2012-05-09 07:20:00 | AAPL | Stock | 20.1714 | 20.1714 | 20.1643 | 20.1643 | 58744.0 |
| 2012-05-09 07:25:00 | AAPL | Stock | 20.1618 | 20.1757 | 20.1582 | 20.1757 | 32900.0 |
| 2012-05-09 07:30:00 | AAPL | Stock | 20.1604 | 20.1696 | 20.1546 | 20.1546 | 35560.0 |
| 2012-05-09 07:35:00 | AAPL | Stock | 20.1554 | 20.1729 | 20.1486 | 20.1729 | 108248.0 |
| 2012-05-09 07:40:00 | AAPL | Stock | 20.1757 | 20.2082 | 20.1757 | 20.2082 | 19600.0 |
| 2012-05-09 07:45:00 | AAPL | Stock | 20.1768 | 20.1868 | 20.1768 | 20.1864 | 39088.0 |
| 2012-05-09 07:50:00 | AAPL | Stock | 20.1875 | 20.2 | 20.175 | 20.1857 | 162400.0 |
| 2012-05-09 07:55:00 | AAPL | Stock | 20.1864 | 20.1964 | 20.1857 | 20.1864 | 145600.0 |
| 2012-05-09 08:00:00 | AAPL | Stock | 20.1864 | 20.2 | 20.1486 | 20.1911 | 225344.0 |
| 2012-05-09 08:05:00 | AAPL | Stock | 20.1925 | 20.1929 | 20.1746 | 20.1821 | 168252.0 |
| 2012-05-09 08:10:00 | AAPL | Stock | 20.1732 | 20.175 | 20.1118 | 20.13 | 402220.0 |
| 2012-05-09 08:15:00 | AAPL | Stock | 20.125 | 20.13 | 20.0964 | 20.1064 | 498792.0 |
| 2012-05-09 08:20:00 | AAPL | Stock | 20.0986 | 20.1064 | 20.0821 | 20.0986 | 347060.0 |
| 2012-05-09 08:25:00 | AAPL | Stock | 20.0954 | 20.1225 | 20.0821 | 20.1161 | 228676.0 |
| 2012-05-09 08:30:00 | AAPL | Stock | 20.1204 | 20.13 | 20.1057 | 20.1057 | 223692.0 |
| 2012-05-09 08:35:00 | AAPL | Stock | 20.1054 | 20.1064 | 20.0896 | 20.1029 | 84056.0 |
| 2012-05-09 08:40:00 | AAPL | Stock | 20.1071 | 20.1161 | 20.1071 | 20.1125 | 56000.0 |
| 2012-05-09 08:45:00 | AAPL | Stock | 20.1071 | 20.1107 | 20.1071 | 20.1071 | 57120.0 |
| 2012-05-09 08:50:00 | AAPL | Stock | 20.1075 | 20.1121 | 20.0832 | 20.0868 | 143892.0 |
| 2012-05-09 08:55:00 | AAPL | Stock | 20.0918 | 20.1071 | 20.0907 | 20.1071 | 105896.0 |
| 2012-05-09 09:00:00 | AAPL | Stock | 20.1011 | 20.1143 | 20.0929 | 20.1071 | 102256.0 |
| 2012-05-09 09:05:00 | AAPL | Stock | 20.1089 | 20.1214 | 20.0954 | 20.0954 | 217364.0 |
| 2012-05-09 09:10:00 | AAPL | Stock | 20.1071 | 20.1214 | 20.1071 | 20.1207 | 48580.0 |
| 2012-05-09 09:15:00 | AAPL | Stock | 20.1171 | 20.1246 | 20.1071 | 20.1246 | 108976.0 |
| 2012-05-09 09:20:00 | AAPL | Stock | 20.1196 | 20.1357 | 20.1196 | 20.1304 | 129136.0 |
| 2012-05-09 09:25:00 | AAPL | Stock | 20.1293 | 20.1493 | 20.1293 | 20.1332 | 602392.0 |
| 2012-05-09 09:30:00 | AAPL | Stock | 20.1332 | 20.1589 | 20.0504 | 20.1136 | 16051588.0 |
| 2012-05-09 09:35:00 | AAPL | Stock | 20.1132 | 20.1771 | 20.1114 | 20.1479 | 11842656.0 |
| 2012-05-09 09:40:00 | AAPL | Stock | 20.1446 | 20.2175 | 20.1429 | 20.2071 | 12203044.0 |
| 2012-05-09 09:45:00 | AAPL | Stock | 20.2041 | 20.2921 | 20.1996 | 20.2067 | 12455548.0 |
| 2012-05-09 09:50:00 | AAPL | Stock | 20.2036 | 20.2586 | 20.1832 | 20.1857 | 7442680.0 |
| 2012-05-09 09:55:00 | AAPL | Stock | 20.1854 | 20.2396 | 20.1675 | 20.2321 | 7372736.0 |
| 2012-05-09 10:00:00 | AAPL | Stock | 20.2332 | 20.2357 | 20.1789 | 20.2111 | 6661060.0 |
| 2012-05-09 10:05:00 | AAPL | Stock | 20.2114 | 20.2114 | 20.1 | 20.1261 | 10095148.0 |
> showing 50 of 333,777 rows — these rows as CSV