PREVIEW / stock_5min / 2018-04-10
file: by_date/stock_5min/2018/2018-04-10.parquet size: 5.6 MB rows: 362,986 symbols: 2,868
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 |
|---|---|---|---|---|---|---|---|
| 2018-04-10 04:00:00 | AAPL | Stock | 43.0575 | 43.2 | 43.0575 | 43.1 | 4776.0 |
| 2018-04-10 04:10:00 | AAPL | Stock | 43.1825 | 43.2625 | 43.1825 | 43.1825 | 9132.0 |
| 2018-04-10 04:15:00 | AAPL | Stock | 43.1825 | 43.1825 | 43.1825 | 43.1825 | 2000.0 |
| 2018-04-10 04:20:00 | AAPL | Stock | 43.1825 | 43.1825 | 43.1825 | 43.1825 | 1200.0 |
| 2018-04-10 04:35:00 | AAPL | Stock | 43.19 | 43.19 | 43.19 | 43.19 | 400.0 |
| 2018-04-10 04:40:00 | AAPL | Stock | 43.175 | 43.175 | 43.175 | 43.175 | 800.0 |
| 2018-04-10 04:45:00 | AAPL | Stock | 43.1825 | 43.1825 | 43.1825 | 43.1825 | 400.0 |
| 2018-04-10 04:55:00 | AAPL | Stock | 43.1875 | 43.1875 | 43.1875 | 43.1875 | 4000.0 |
| 2018-04-10 05:00:00 | AAPL | Stock | 43.15 | 43.19 | 43.15 | 43.19 | 800.0 |
| 2018-04-10 05:05:00 | AAPL | Stock | 43.1975 | 43.25 | 43.1975 | 43.2375 | 2480.0 |
| 2018-04-10 05:10:00 | AAPL | Stock | 43.2725 | 43.3 | 43.2725 | 43.3 | 18920.0 |
| 2018-04-10 05:20:00 | AAPL | Stock | 43.25 | 43.25 | 43.25 | 43.25 | 4000.0 |
| 2018-04-10 05:25:00 | AAPL | Stock | 43.225 | 43.225 | 43.225 | 43.225 | 3200.0 |
| 2018-04-10 05:35:00 | AAPL | Stock | 43.265 | 43.265 | 43.2125 | 43.215 | 5200.0 |
| 2018-04-10 05:50:00 | AAPL | Stock | 43.1775 | 43.1775 | 43.175 | 43.175 | 8000.0 |
| 2018-04-10 06:00:00 | AAPL | Stock | 43.18 | 43.18 | 43.18 | 43.18 | 828.0 |
| 2018-04-10 06:10:00 | AAPL | Stock | 43.2125 | 43.2125 | 43.2125 | 43.2125 | 400.0 |
| 2018-04-10 06:30:00 | AAPL | Stock | 43.2 | 43.2 | 43.2 | 43.2 | 400.0 |
| 2018-04-10 06:35:00 | AAPL | Stock | 43.2625 | 43.2625 | 43.2625 | 43.2625 | 600.0 |
| 2018-04-10 06:40:00 | AAPL | Stock | 43.25 | 43.25 | 43.25 | 43.25 | 800.0 |
| 2018-04-10 06:45:00 | AAPL | Stock | 43.25 | 43.25 | 43.25 | 43.25 | 2360.0 |
| 2018-04-10 06:55:00 | AAPL | Stock | 43.2375 | 43.2375 | 43.2375 | 43.2375 | 400.0 |
| 2018-04-10 07:00:00 | AAPL | Stock | 43.2 | 43.25 | 43.165 | 43.2 | 33192.0 |
| 2018-04-10 07:05:00 | AAPL | Stock | 43.2025 | 43.2275 | 43.2 | 43.225 | 28364.0 |
| 2018-04-10 07:10:00 | AAPL | Stock | 43.225 | 43.25 | 43.225 | 43.225 | 29568.0 |
| 2018-04-10 07:15:00 | AAPL | Stock | 43.235 | 43.2375 | 43.2075 | 43.225 | 14628.0 |
| 2018-04-10 07:20:00 | AAPL | Stock | 43.2225 | 43.2375 | 43.2 | 43.2 | 23232.0 |
| 2018-04-10 07:25:00 | AAPL | Stock | 43.1875 | 43.2125 | 43.165 | 43.2125 | 17432.0 |
| 2018-04-10 07:30:00 | AAPL | Stock | 43.2 | 43.22 | 43.19 | 43.22 | 5536.0 |
| 2018-04-10 07:35:00 | AAPL | Stock | 43.225 | 43.235 | 43.225 | 43.225 | 7532.0 |
| 2018-04-10 07:40:00 | AAPL | Stock | 43.2125 | 43.225 | 43.2025 | 43.2025 | 9316.0 |
| 2018-04-10 07:45:00 | AAPL | Stock | 43.1825 | 43.2025 | 43.1825 | 43.185 | 1800.0 |
| 2018-04-10 07:50:00 | AAPL | Stock | 43.2 | 43.225 | 43.1875 | 43.21 | 37076.0 |
| 2018-04-10 07:55:00 | AAPL | Stock | 43.21 | 43.225 | 43.21 | 43.225 | 11884.0 |
| 2018-04-10 08:00:00 | AAPL | Stock | 43.25 | 43.25 | 43.175 | 43.2125 | 103420.0 |
| 2018-04-10 08:05:00 | AAPL | Stock | 43.2 | 43.2 | 43.1525 | 43.1525 | 19968.0 |
| 2018-04-10 08:10:00 | AAPL | Stock | 43.175 | 43.175 | 43.125 | 43.1375 | 23688.0 |
| 2018-04-10 08:15:00 | AAPL | Stock | 43.1375 | 43.175 | 43.1375 | 43.175 | 24120.0 |
| 2018-04-10 08:20:00 | AAPL | Stock | 43.175 | 43.1875 | 43.16 | 43.1612 | 12000.0 |
| 2018-04-10 08:25:00 | AAPL | Stock | 43.175 | 43.175 | 43.1475 | 43.1625 | 41924.0 |
| 2018-04-10 08:30:00 | AAPL | Stock | 43.1425 | 43.15 | 43.1 | 43.1375 | 43424.0 |
| 2018-04-10 08:35:00 | AAPL | Stock | 43.1375 | 43.17 | 43.125 | 43.1625 | 27560.0 |
| 2018-04-10 08:40:00 | AAPL | Stock | 43.14 | 43.1675 | 43.125 | 43.15 | 24360.0 |
| 2018-04-10 08:45:00 | AAPL | Stock | 43.17 | 43.17 | 43.14 | 43.1625 | 11896.0 |
| 2018-04-10 08:50:00 | AAPL | Stock | 43.17 | 43.175 | 43.15 | 43.1625 | 51148.0 |
| 2018-04-10 08:55:00 | AAPL | Stock | 43.1725 | 43.2175 | 43.1625 | 43.165 | 47604.0 |
| 2018-04-10 09:00:00 | AAPL | Stock | 43.165 | 43.195 | 43.165 | 43.195 | 15912.0 |
| 2018-04-10 09:05:00 | AAPL | Stock | 43.1925 | 43.2225 | 43.1925 | 43.2 | 29640.0 |
| 2018-04-10 09:10:00 | AAPL | Stock | 43.2 | 43.2375 | 43.1775 | 43.225 | 94368.0 |
| 2018-04-10 09:15:00 | AAPL | Stock | 43.2275 | 43.2675 | 43.2275 | 43.2375 | 123248.0 |
> showing 50 of 362,986 rows — these rows as CSV