PREVIEW / stock_5min / 2015-12-18
file: by_date/stock_5min/2015/2015-12-18.parquet size: 5.7 MB rows: 378,533 symbols: 3,443
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-12-18 04:00:00 | AAPL | Stock | 27.5 | 27.5 | 27.1725 | 27.1725 | 1200.0 |
| 2015-12-18 04:10:00 | AAPL | Stock | 27.09 | 27.1275 | 27.09 | 27.1275 | 4000.0 |
| 2015-12-18 04:15:00 | AAPL | Stock | 27.135 | 27.135 | 27.135 | 27.135 | 1820.0 |
| 2015-12-18 04:20:00 | AAPL | Stock | 27.1375 | 27.1375 | 27.1375 | 27.1375 | 1200.0 |
| 2015-12-18 04:25:00 | AAPL | Stock | 27.155 | 27.155 | 27.155 | 27.155 | 2476.0 |
| 2015-12-18 04:30:00 | AAPL | Stock | 27.13 | 27.1425 | 27.12 | 27.1425 | 6324.0 |
| 2015-12-18 04:35:00 | AAPL | Stock | 27.12 | 27.12 | 27.0925 | 27.0925 | 6876.0 |
| 2015-12-18 04:40:00 | AAPL | Stock | 27.145 | 27.145 | 27.145 | 27.145 | 2400.0 |
| 2015-12-18 04:45:00 | AAPL | Stock | 27.1375 | 27.1675 | 27.1375 | 27.14 | 4200.0 |
| 2015-12-18 04:55:00 | AAPL | Stock | 27.1725 | 27.175 | 27.1625 | 27.1625 | 5800.0 |
| 2015-12-18 05:00:00 | AAPL | Stock | 27.15 | 27.15 | 27.15 | 27.15 | 4000.0 |
| 2015-12-18 05:05:00 | AAPL | Stock | 27.145 | 27.145 | 27.145 | 27.145 | 400.0 |
| 2015-12-18 05:20:00 | AAPL | Stock | 27.15 | 27.15 | 27.15 | 27.15 | 944.0 |
| 2015-12-18 05:40:00 | AAPL | Stock | 27.16 | 27.1775 | 27.16 | 27.1775 | 1200.0 |
| 2015-12-18 06:05:00 | AAPL | Stock | 27.1875 | 27.1875 | 27.14 | 27.14 | 12000.0 |
| 2015-12-18 06:30:00 | AAPL | Stock | 27.1825 | 27.22 | 27.145 | 27.145 | 6800.0 |
| 2015-12-18 06:50:00 | AAPL | Stock | 27.14 | 27.14 | 27.14 | 27.14 | 400.0 |
| 2015-12-18 06:55:00 | AAPL | Stock | 27.13 | 27.13 | 27.12 | 27.12 | 2880.0 |
| 2015-12-18 07:00:00 | AAPL | Stock | 27.1625 | 27.1625 | 27.0925 | 27.1125 | 31584.0 |
| 2015-12-18 07:05:00 | AAPL | Stock | 27.125 | 27.1375 | 27.125 | 27.1375 | 1200.0 |
| 2015-12-18 07:10:00 | AAPL | Stock | 27.1275 | 27.1275 | 27.1 | 27.1 | 7240.0 |
| 2015-12-18 07:15:00 | AAPL | Stock | 27.095 | 27.1 | 27.095 | 27.1 | 41280.0 |
| 2015-12-18 07:20:00 | AAPL | Stock | 27.1 | 27.1125 | 27.1 | 27.1125 | 8500.0 |
| 2015-12-18 07:25:00 | AAPL | Stock | 27.12 | 27.12 | 27.105 | 27.105 | 2400.0 |
| 2015-12-18 07:30:00 | AAPL | Stock | 27.11 | 27.125 | 27.09 | 27.125 | 86088.0 |
| 2015-12-18 07:35:00 | AAPL | Stock | 27.125 | 27.1575 | 27.125 | 27.15 | 18400.0 |
| 2015-12-18 07:40:00 | AAPL | Stock | 27.1375 | 27.1375 | 27.1325 | 27.1325 | 2400.0 |
| 2015-12-18 07:45:00 | AAPL | Stock | 27.13 | 27.13 | 27.13 | 27.13 | 2400.0 |
| 2015-12-18 07:50:00 | AAPL | Stock | 27.145 | 27.145 | 27.1275 | 27.13 | 16164.0 |
| 2015-12-18 07:55:00 | AAPL | Stock | 27.1375 | 27.15 | 27.1325 | 27.1475 | 35604.0 |
| 2015-12-18 08:00:00 | AAPL | Stock | 27.1425 | 27.145 | 27.09 | 27.12 | 90660.0 |
| 2015-12-18 08:05:00 | AAPL | Stock | 27.115 | 27.1225 | 27.1125 | 27.1225 | 25520.0 |
| 2015-12-18 08:10:00 | AAPL | Stock | 27.1175 | 27.125 | 27.1175 | 27.1225 | 15076.0 |
| 2015-12-18 08:15:00 | AAPL | Stock | 26.75 | 27.125 | 26.75 | 27.125 | 22600.0 |
| 2015-12-18 08:20:00 | AAPL | Stock | 27.125 | 27.1525 | 27.1225 | 27.1375 | 158116.0 |
| 2015-12-18 08:25:00 | AAPL | Stock | 27.1325 | 27.15 | 27.1275 | 27.15 | 24264.0 |
| 2015-12-18 08:30:00 | AAPL | Stock | 27.1425 | 27.15 | 27.12 | 27.125 | 45824.0 |
| 2015-12-18 08:35:00 | AAPL | Stock | 27.13 | 27.135 | 27.13 | 27.135 | 12000.0 |
| 2015-12-18 08:40:00 | AAPL | Stock | 27.1425 | 27.145 | 27.125 | 27.125 | 10840.0 |
| 2015-12-18 08:45:00 | AAPL | Stock | 27.1375 | 27.14 | 27.1375 | 27.1375 | 2000.0 |
| 2015-12-18 08:50:00 | AAPL | Stock | 27.1325 | 27.15 | 27.1325 | 27.1475 | 13120.0 |
| 2015-12-18 08:55:00 | AAPL | Stock | 27.1475 | 27.17 | 27.1325 | 27.17 | 20200.0 |
| 2015-12-18 09:00:00 | AAPL | Stock | 27.17 | 27.1775 | 27.1625 | 27.1625 | 39012.0 |
| 2015-12-18 09:05:00 | AAPL | Stock | 27.1625 | 27.2175 | 27.15 | 27.185 | 110576.0 |
| 2015-12-18 09:10:00 | AAPL | Stock | 27.185 | 27.1875 | 27.15 | 27.1875 | 78764.0 |
| 2015-12-18 09:15:00 | AAPL | Stock | 27.1875 | 27.335 | 27.1875 | 27.325 | 172372.0 |
| 2015-12-18 09:20:00 | AAPL | Stock | 27.3225 | 27.3525 | 27.2875 | 27.2875 | 225160.0 |
| 2015-12-18 09:25:00 | AAPL | Stock | 27.3025 | 27.35 | 27.155 | 27.1575 | 435580.0 |
| 2015-12-18 09:30:00 | AAPL | Stock | 27.2275 | 27.32 | 27.115 | 27.2525 | 36193604.0 |
| 2015-12-18 09:35:00 | AAPL | Stock | 27.2475 | 27.2625 | 27.125 | 27.2175 | 3819860.0 |
> showing 50 of 378,533 rows — these rows as CSV