PREVIEW / stock_5min / 2014-04-24
file: by_date/stock_5min/2014/2014-04-24.parquet size: 5.3 MB rows: 356,122 symbols: 3,539
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-24 04:00:00 | AAPL | Stock | 20.1411 | 20.1629 | 20.1357 | 20.15 | 97132.0 |
| 2014-04-24 04:05:00 | AAPL | Stock | 20.1518 | 20.1607 | 20.1518 | 20.1607 | 30912.0 |
| 2014-04-24 04:10:00 | AAPL | Stock | 20.1511 | 20.1571 | 20.1511 | 20.1521 | 14000.0 |
| 2014-04-24 04:15:00 | AAPL | Stock | 20.1446 | 20.1446 | 20.1357 | 20.1357 | 60592.0 |
| 2014-04-24 04:20:00 | AAPL | Stock | 20.1304 | 20.1304 | 20.1254 | 20.1254 | 19600.0 |
| 2014-04-24 04:25:00 | AAPL | Stock | 20.1071 | 20.1143 | 20.1071 | 20.1143 | 5600.0 |
| 2014-04-24 04:30:00 | AAPL | Stock | 20.1121 | 20.1121 | 20.1121 | 20.1121 | 5600.0 |
| 2014-04-24 04:35:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 2800.0 |
| 2014-04-24 04:40:00 | AAPL | Stock | 20.1036 | 20.115 | 20.1036 | 20.115 | 8400.0 |
| 2014-04-24 04:45:00 | AAPL | Stock | 20.1143 | 20.1179 | 20.1143 | 20.1179 | 11200.0 |
| 2014-04-24 04:50:00 | AAPL | Stock | 20.1018 | 20.125 | 20.1007 | 20.125 | 39200.0 |
| 2014-04-24 04:55:00 | AAPL | Stock | 20.095 | 20.095 | 20.095 | 20.095 | 2884.0 |
| 2014-04-24 05:05:00 | AAPL | Stock | 20.1143 | 20.1207 | 20.1143 | 20.1143 | 8400.0 |
| 2014-04-24 05:10:00 | AAPL | Stock | 20.1218 | 20.1218 | 20.1218 | 20.1218 | 2800.0 |
| 2014-04-24 05:35:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 2800.0 |
| 2014-04-24 05:40:00 | AAPL | Stock | 20.1132 | 20.1429 | 20.1132 | 20.1429 | 65072.0 |
| 2014-04-24 05:45:00 | AAPL | Stock | 20.1268 | 20.1268 | 20.1236 | 20.1236 | 16800.0 |
| 2014-04-24 05:50:00 | AAPL | Stock | 20.1182 | 20.1439 | 20.1182 | 20.1439 | 50596.0 |
| 2014-04-24 05:55:00 | AAPL | Stock | 20.1325 | 20.1325 | 20.1325 | 20.1325 | 2800.0 |
| 2014-04-24 06:00:00 | AAPL | Stock | 20.1325 | 20.1504 | 20.1325 | 20.1504 | 53200.0 |
| 2014-04-24 06:05:00 | AAPL | Stock | 20.1643 | 20.1679 | 20.1536 | 20.1536 | 17976.0 |
| 2014-04-24 06:10:00 | AAPL | Stock | 20.1386 | 20.1714 | 20.1386 | 20.1571 | 99232.0 |
| 2014-04-24 06:15:00 | AAPL | Stock | 20.1446 | 20.1446 | 20.1429 | 20.1429 | 12404.0 |
| 2014-04-24 06:25:00 | AAPL | Stock | 20.1332 | 20.1607 | 20.1332 | 20.1607 | 39256.0 |
| 2014-04-24 06:30:00 | AAPL | Stock | 20.1568 | 20.1568 | 20.1568 | 20.1568 | 2800.0 |
| 2014-04-24 06:35:00 | AAPL | Stock | 20.1607 | 20.1714 | 20.1607 | 20.1714 | 74060.0 |
| 2014-04-24 06:40:00 | AAPL | Stock | 20.1786 | 20.1986 | 20.1786 | 20.1986 | 71820.0 |
| 2014-04-24 06:45:00 | AAPL | Stock | 20.1786 | 20.1879 | 20.1786 | 20.1879 | 12600.0 |
| 2014-04-24 06:50:00 | AAPL | Stock | 20.2014 | 20.2014 | 20.1911 | 20.1911 | 30128.0 |
| 2014-04-24 06:55:00 | AAPL | Stock | 20.1964 | 20.2411 | 20.1957 | 20.2411 | 145320.0 |
| 2014-04-24 07:00:00 | AAPL | Stock | 20.2143 | 20.2439 | 20.2143 | 20.2439 | 134764.0 |
| 2014-04-24 07:05:00 | AAPL | Stock | 20.2404 | 20.25 | 20.2143 | 20.2143 | 87304.0 |
| 2014-04-24 07:10:00 | AAPL | Stock | 20.2107 | 20.2404 | 20.2061 | 20.2061 | 182168.0 |
| 2014-04-24 07:15:00 | AAPL | Stock | 20.2018 | 20.2018 | 20.1896 | 20.1896 | 33600.0 |
| 2014-04-24 07:20:00 | AAPL | Stock | 20.1968 | 20.2111 | 20.1786 | 20.2071 | 156380.0 |
| 2014-04-24 07:25:00 | AAPL | Stock | 20.1964 | 20.2757 | 20.1964 | 20.2454 | 337372.0 |
| 2014-04-24 07:30:00 | AAPL | Stock | 20.2675 | 20.3171 | 20.25 | 20.2893 | 477288.0 |
| 2014-04-24 07:35:00 | AAPL | Stock | 20.3 | 20.35 | 20.2857 | 20.3214 | 1051736.0 |
| 2014-04-24 07:40:00 | AAPL | Stock | 20.3214 | 20.4286 | 20.3214 | 20.4214 | 899332.0 |
| 2014-04-24 07:45:00 | AAPL | Stock | 20.4261 | 20.4375 | 20.3571 | 20.3625 | 907424.0 |
| 2014-04-24 07:50:00 | AAPL | Stock | 20.3668 | 20.375 | 20.3443 | 20.3554 | 421400.0 |
| 2014-04-24 07:55:00 | AAPL | Stock | 20.3496 | 20.3564 | 20.3243 | 20.3564 | 671384.0 |
| 2014-04-24 08:00:00 | AAPL | Stock | 20.355 | 20.4282 | 20.3171 | 20.3893 | 1578304.0 |
| 2014-04-24 08:05:00 | AAPL | Stock | 20.3464 | 20.35 | 20.2857 | 20.3407 | 1231720.0 |
| 2014-04-24 08:10:00 | AAPL | Stock | 20.3407 | 20.3564 | 20.3289 | 20.3393 | 559132.0 |
| 2014-04-24 08:15:00 | AAPL | Stock | 20.3396 | 20.3429 | 20.3114 | 20.3154 | 734440.0 |
| 2014-04-24 08:20:00 | AAPL | Stock | 20.3118 | 20.3204 | 20.2982 | 20.3046 | 1183728.0 |
| 2014-04-24 08:25:00 | AAPL | Stock | 20.3093 | 20.315 | 20.2821 | 20.3036 | 441056.0 |
| 2014-04-24 08:30:00 | AAPL | Stock | 20.31 | 20.315 | 20.2904 | 20.3079 | 639240.0 |
| 2014-04-24 08:35:00 | AAPL | Stock | 20.315 | 20.3486 | 20.3107 | 20.3393 | 1168916.0 |
> showing 50 of 356,122 rows — these rows as CSV