PREVIEW / stock_5min / 2015-08-18
file: by_date/stock_5min/2015/2015-08-18.parquet size: 5.3 MB rows: 351,225 symbols: 3,444
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-18 04:00:00 | AAPL | Stock | 29.205 | 29.285 | 29.205 | 29.225 | 17592.0 |
| 2015-08-18 04:15:00 | AAPL | Stock | 29.24 | 29.24 | 29.24 | 29.24 | 800.0 |
| 2015-08-18 04:20:00 | AAPL | Stock | 29.2375 | 29.2375 | 29.2375 | 29.2375 | 400.0 |
| 2015-08-18 04:30:00 | AAPL | Stock | 29.215 | 29.215 | 29.215 | 29.215 | 400.0 |
| 2015-08-18 04:35:00 | AAPL | Stock | 29.245 | 29.245 | 29.245 | 29.245 | 440.0 |
| 2015-08-18 05:05:00 | AAPL | Stock | 29.225 | 29.225 | 29.225 | 29.225 | 480.0 |
| 2015-08-18 05:30:00 | AAPL | Stock | 29.2025 | 29.2025 | 29.2025 | 29.2025 | 5368.0 |
| 2015-08-18 05:55:00 | AAPL | Stock | 29.1625 | 29.1625 | 29.1325 | 29.1325 | 3860.0 |
| 2015-08-18 06:05:00 | AAPL | Stock | 29.1625 | 29.1625 | 29.14 | 29.14 | 2000.0 |
| 2015-08-18 06:10:00 | AAPL | Stock | 29.145 | 29.145 | 29.145 | 29.145 | 400.0 |
| 2015-08-18 06:20:00 | AAPL | Stock | 29.1475 | 29.1475 | 29.1475 | 29.1475 | 400.0 |
| 2015-08-18 06:25:00 | AAPL | Stock | 29.175 | 29.175 | 29.175 | 29.175 | 18668.0 |
| 2015-08-18 06:30:00 | AAPL | Stock | 29.175 | 29.175 | 29.175 | 29.175 | 12612.0 |
| 2015-08-18 06:40:00 | AAPL | Stock | 29.1525 | 29.1525 | 29.15 | 29.15 | 2000.0 |
| 2015-08-18 06:45:00 | AAPL | Stock | 29.17 | 29.17 | 29.155 | 29.155 | 800.0 |
| 2015-08-18 06:55:00 | AAPL | Stock | 29.2 | 29.2 | 29.2 | 29.2 | 632.0 |
| 2015-08-18 07:00:00 | AAPL | Stock | 29.2 | 29.2 | 29.125 | 29.125 | 18896.0 |
| 2015-08-18 07:05:00 | AAPL | Stock | 29.105 | 29.125 | 29.105 | 29.125 | 12160.0 |
| 2015-08-18 07:15:00 | AAPL | Stock | 29.11 | 29.11 | 29.1 | 29.1 | 6968.0 |
| 2015-08-18 07:20:00 | AAPL | Stock | 29.1075 | 29.1075 | 29.085 | 29.0875 | 9216.0 |
| 2015-08-18 07:25:00 | AAPL | Stock | 29.0875 | 29.105 | 29.0875 | 29.09 | 8060.0 |
| 2015-08-18 07:30:00 | AAPL | Stock | 29.0925 | 29.1 | 29.0925 | 29.1 | 4824.0 |
| 2015-08-18 07:35:00 | AAPL | Stock | 29.105 | 29.125 | 29.1 | 29.125 | 10304.0 |
| 2015-08-18 07:40:00 | AAPL | Stock | 29.1125 | 29.1125 | 29.1125 | 29.1125 | 1600.0 |
| 2015-08-18 07:45:00 | AAPL | Stock | 29.1125 | 29.1175 | 29.1125 | 29.1175 | 15428.0 |
| 2015-08-18 07:55:00 | AAPL | Stock | 29.1125 | 29.115 | 29.1125 | 29.1125 | 7600.0 |
| 2015-08-18 08:00:00 | AAPL | Stock | 29.1125 | 29.155 | 29.0825 | 29.1125 | 221872.0 |
| 2015-08-18 08:05:00 | AAPL | Stock | 29.115 | 29.125 | 29.1125 | 29.1125 | 15080.0 |
| 2015-08-18 08:10:00 | AAPL | Stock | 29.1245 | 29.1245 | 29.1125 | 29.12 | 39232.0 |
| 2015-08-18 08:15:00 | AAPL | Stock | 29.125 | 29.125 | 29.11 | 29.11 | 36776.0 |
| 2015-08-18 08:20:00 | AAPL | Stock | 29.105 | 29.115 | 29.105 | 29.115 | 13000.0 |
| 2015-08-18 08:25:00 | AAPL | Stock | 29.115 | 29.125 | 29.11 | 29.1208 | 13984.0 |
| 2015-08-18 08:30:00 | AAPL | Stock | 29.1375 | 29.155 | 29.125 | 29.1375 | 49708.0 |
| 2015-08-18 08:35:00 | AAPL | Stock | 29.1375 | 29.1375 | 29.13 | 29.135 | 12952.0 |
| 2015-08-18 08:40:00 | AAPL | Stock | 29.155 | 29.185 | 29.1525 | 29.17 | 72852.0 |
| 2015-08-18 08:45:00 | AAPL | Stock | 29.155 | 29.1725 | 29.155 | 29.1725 | 25716.0 |
| 2015-08-18 08:50:00 | AAPL | Stock | 29.1725 | 29.19 | 29.1725 | 29.1825 | 47220.0 |
| 2015-08-18 08:55:00 | AAPL | Stock | 29.185 | 29.185 | 29.1575 | 29.1575 | 53036.0 |
| 2015-08-18 09:00:00 | AAPL | Stock | 29.1575 | 29.1675 | 29.15 | 29.15 | 10340.0 |
| 2015-08-18 09:05:00 | AAPL | Stock | 29.16 | 29.1625 | 29.15 | 29.15 | 41172.0 |
| 2015-08-18 09:10:00 | AAPL | Stock | 29.1475 | 29.1575 | 29.1475 | 29.1575 | 21620.0 |
| 2015-08-18 09:15:00 | AAPL | Stock | 29.1575 | 29.165 | 29.1575 | 29.16 | 10840.0 |
| 2015-08-18 09:20:00 | AAPL | Stock | 29.16 | 29.165 | 29.1375 | 29.1508 | 32520.0 |
| 2015-08-18 09:25:00 | AAPL | Stock | 29.1525 | 29.155 | 29.055 | 29.1075 | 352240.0 |
| 2015-08-18 09:30:00 | AAPL | Stock | 29.1075 | 29.2325 | 29.0025 | 29.2025 | 7058156.0 |
| 2015-08-18 09:35:00 | AAPL | Stock | 29.2025 | 29.225 | 29.125 | 29.1302 | 2912640.0 |
| 2015-08-18 09:40:00 | AAPL | Stock | 29.1288 | 29.15 | 29.05 | 29.0675 | 3850512.0 |
| 2015-08-18 09:45:00 | AAPL | Stock | 29.0685 | 29.1182 | 29.0425 | 29.09 | 3729412.0 |
| 2015-08-18 09:50:00 | AAPL | Stock | 29.0878 | 29.095 | 29.0325 | 29.0575 | 2964540.0 |
| 2015-08-18 09:55:00 | AAPL | Stock | 29.0575 | 29.1675 | 29.05 | 29.1212 | 3392328.0 |
> showing 50 of 351,225 rows — these rows as CSV