PREVIEW / stock_5min / 2017-03-17
file: by_date/stock_5min/2017/2017-03-17.parquet size: 5.4 MB rows: 355,777 symbols: 3,084
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 |
|---|---|---|---|---|---|---|---|
| 2017-03-17 04:30:00 | AAPL | Stock | 35.1375 | 35.1375 | 35.1375 | 35.1375 | 3600.0 |
| 2017-03-17 04:35:00 | AAPL | Stock | 35.1375 | 35.1725 | 35.1375 | 35.1725 | 2200.0 |
| 2017-03-17 05:25:00 | AAPL | Stock | 35.1725 | 35.1725 | 35.1725 | 35.1725 | 2000.0 |
| 2017-03-17 05:30:00 | AAPL | Stock | 35.1725 | 35.1725 | 35.1725 | 35.1725 | 660.0 |
| 2017-03-17 06:35:00 | AAPL | Stock | 35.15 | 35.15 | 35.15 | 35.15 | 656.0 |
| 2017-03-17 07:00:00 | AAPL | Stock | 35.1525 | 35.1525 | 35.1525 | 35.1525 | 492.0 |
| 2017-03-17 07:30:00 | AAPL | Stock | 35.185 | 35.2025 | 35.185 | 35.2025 | 5560.0 |
| 2017-03-17 07:40:00 | AAPL | Stock | 35.1725 | 35.1725 | 35.1725 | 35.1725 | 2920.0 |
| 2017-03-17 07:45:00 | AAPL | Stock | 35.1725 | 35.1725 | 35.1725 | 35.1725 | 2080.0 |
| 2017-03-17 07:50:00 | AAPL | Stock | 35.19 | 35.19 | 35.165 | 35.165 | 3200.0 |
| 2017-03-17 08:00:00 | AAPL | Stock | 35.1875 | 35.1875 | 35.1525 | 35.1525 | 9040.0 |
| 2017-03-17 08:10:00 | AAPL | Stock | 35.155 | 35.155 | 35.155 | 35.155 | 400.0 |
| 2017-03-17 08:15:00 | AAPL | Stock | 35.15 | 35.1625 | 35.15 | 35.1625 | 1932.0 |
| 2017-03-17 08:20:00 | AAPL | Stock | 35.1425 | 35.165 | 35.1425 | 35.165 | 1600.0 |
| 2017-03-17 08:25:00 | AAPL | Stock | 35.165 | 35.165 | 35.165 | 35.165 | 2356.0 |
| 2017-03-17 08:30:00 | AAPL | Stock | 35.1725 | 35.175 | 35.1725 | 35.175 | 5600.0 |
| 2017-03-17 08:35:00 | AAPL | Stock | 35.175 | 35.195 | 35.175 | 35.195 | 7192.0 |
| 2017-03-17 08:40:00 | AAPL | Stock | 35.195 | 35.2 | 35.195 | 35.2 | 15848.0 |
| 2017-03-17 08:45:00 | AAPL | Stock | 35.2 | 35.2 | 35.1825 | 35.1975 | 101844.0 |
| 2017-03-17 08:50:00 | AAPL | Stock | 35.1975 | 35.21 | 35.1975 | 35.21 | 12036.0 |
| 2017-03-17 08:55:00 | AAPL | Stock | 35.21 | 35.225 | 35.21 | 35.225 | 21324.0 |
| 2017-03-17 09:00:00 | AAPL | Stock | 35.2075 | 35.22 | 35.2075 | 35.22 | 4620.0 |
| 2017-03-17 09:05:00 | AAPL | Stock | 35.215 | 35.215 | 35.2 | 35.2 | 10564.0 |
| 2017-03-17 09:10:00 | AAPL | Stock | 35.19 | 35.2025 | 35.1725 | 35.1725 | 56124.0 |
| 2017-03-17 09:15:00 | AAPL | Stock | 35.18 | 35.18 | 35.165 | 35.165 | 15700.0 |
| 2017-03-17 09:20:00 | AAPL | Stock | 35.18 | 35.195 | 35.18 | 35.1875 | 13776.0 |
| 2017-03-17 09:25:00 | AAPL | Stock | 35.1875 | 35.275 | 35.1875 | 35.2375 | 500608.0 |
| 2017-03-17 09:30:00 | AAPL | Stock | 35.225 | 35.25 | 35.165 | 35.1912 | 39343552.0 |
| 2017-03-17 09:35:00 | AAPL | Stock | 35.19 | 35.2125 | 35.1825 | 35.195 | 1629368.0 |
| 2017-03-17 09:40:00 | AAPL | Stock | 35.195 | 35.205 | 35.145 | 35.1775 | 1957292.0 |
| 2017-03-17 09:45:00 | AAPL | Stock | 35.1775 | 35.18 | 35.1575 | 35.1725 | 846288.0 |
| 2017-03-17 09:50:00 | AAPL | Stock | 35.1725 | 35.21 | 35.15 | 35.165 | 1548856.0 |
| 2017-03-17 09:55:00 | AAPL | Stock | 35.1662 | 35.1812 | 35.145 | 35.147 | 952120.0 |
| 2017-03-17 10:00:00 | AAPL | Stock | 35.1475 | 35.1675 | 35.125 | 35.1632 | 1143924.0 |
| 2017-03-17 10:05:00 | AAPL | Stock | 35.165 | 35.165 | 35.1375 | 35.1575 | 614400.0 |
| 2017-03-17 10:10:00 | AAPL | Stock | 35.1575 | 35.1625 | 35.135 | 35.14 | 635624.0 |
| 2017-03-17 10:15:00 | AAPL | Stock | 35.1375 | 35.145 | 35.125 | 35.133 | 968524.0 |
| 2017-03-17 10:20:00 | AAPL | Stock | 35.1325 | 35.1538 | 35.125 | 35.1325 | 571496.0 |
| 2017-03-17 10:25:00 | AAPL | Stock | 35.1325 | 35.1425 | 35.1275 | 35.13 | 541240.0 |
| 2017-03-17 10:30:00 | AAPL | Stock | 35.13 | 35.1425 | 35.1045 | 35.1375 | 736264.0 |
| 2017-03-17 10:35:00 | AAPL | Stock | 35.1388 | 35.16 | 35.1375 | 35.1475 | 927100.0 |
| 2017-03-17 10:40:00 | AAPL | Stock | 35.1475 | 35.155 | 35.1325 | 35.14 | 482292.0 |
| 2017-03-17 10:45:00 | AAPL | Stock | 35.1375 | 35.16 | 35.1325 | 35.155 | 702436.0 |
| 2017-03-17 10:50:00 | AAPL | Stock | 35.1525 | 35.1725 | 35.1475 | 35.1648 | 491636.0 |
| 2017-03-17 10:55:00 | AAPL | Stock | 35.1625 | 35.1662 | 35.1475 | 35.16 | 380580.0 |
| 2017-03-17 11:00:00 | AAPL | Stock | 35.1612 | 35.165 | 35.1317 | 35.1372 | 481640.0 |
| 2017-03-17 11:05:00 | AAPL | Stock | 35.135 | 35.15 | 35.1275 | 35.14 | 510300.0 |
| 2017-03-17 11:10:00 | AAPL | Stock | 35.14 | 35.1575 | 35.1362 | 35.1425 | 325924.0 |
| 2017-03-17 11:15:00 | AAPL | Stock | 35.145 | 35.16 | 35.1375 | 35.155 | 375284.0 |
| 2017-03-17 11:20:00 | AAPL | Stock | 35.157 | 35.17 | 35.155 | 35.1622 | 475924.0 |
> showing 50 of 355,777 rows — these rows as CSV