PREVIEW / stock_5min / 2016-12-30
file: by_date/stock_5min/2016/2016-12-30.parquet size: 5.4 MB rows: 352,962 symbols: 3,165
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 |
|---|---|---|---|---|---|---|---|
| 2016-12-30 04:00:00 | AAPL | Stock | 29.25 | 29.25 | 29.25 | 29.25 | 5172.0 |
| 2016-12-30 04:05:00 | AAPL | Stock | 29.25 | 29.25 | 29.25 | 29.25 | 520.0 |
| 2016-12-30 04:15:00 | AAPL | Stock | 29.25 | 29.25 | 29.25 | 29.25 | 2268.0 |
| 2016-12-30 05:55:00 | AAPL | Stock | 29.2 | 29.2 | 29.2 | 29.2 | 800.0 |
| 2016-12-30 06:00:00 | AAPL | Stock | 29.2 | 29.2 | 29.2 | 29.2 | 3200.0 |
| 2016-12-30 06:15:00 | AAPL | Stock | 29.125 | 29.15 | 29.125 | 29.15 | 4792.0 |
| 2016-12-30 06:20:00 | AAPL | Stock | 29.15 | 29.15 | 29.12 | 29.12 | 2008.0 |
| 2016-12-30 06:35:00 | AAPL | Stock | 29.2 | 29.2375 | 29.2 | 29.2375 | 4024.0 |
| 2016-12-30 06:40:00 | AAPL | Stock | 29.235 | 29.235 | 29.235 | 29.235 | 1892.0 |
| 2016-12-30 06:50:00 | AAPL | Stock | 29.235 | 29.235 | 29.235 | 29.235 | 1288.0 |
| 2016-12-30 07:00:00 | AAPL | Stock | 29.24 | 29.24 | 29.24 | 29.24 | 6000.0 |
| 2016-12-30 07:05:00 | AAPL | Stock | 29.2275 | 29.2575 | 29.2275 | 29.2575 | 8588.0 |
| 2016-12-30 07:10:00 | AAPL | Stock | 29.2575 | 29.2575 | 29.2575 | 29.2575 | 800.0 |
| 2016-12-30 07:15:00 | AAPL | Stock | 29.26 | 29.275 | 29.26 | 29.275 | 11992.0 |
| 2016-12-30 07:20:00 | AAPL | Stock | 29.275 | 29.275 | 29.275 | 29.275 | 1200.0 |
| 2016-12-30 07:25:00 | AAPL | Stock | 29.275 | 29.275 | 29.275 | 29.275 | 800.0 |
| 2016-12-30 07:30:00 | AAPL | Stock | 29.285 | 29.285 | 29.285 | 29.285 | 1200.0 |
| 2016-12-30 07:35:00 | AAPL | Stock | 29.285 | 29.285 | 29.285 | 29.285 | 2792.0 |
| 2016-12-30 07:40:00 | AAPL | Stock | 29.3125 | 29.3225 | 29.2825 | 29.2825 | 2344.0 |
| 2016-12-30 07:55:00 | AAPL | Stock | 29.27 | 29.27 | 29.27 | 29.27 | 620.0 |
| 2016-12-30 08:00:00 | AAPL | Stock | 29.2775 | 29.28 | 29.2575 | 29.275 | 29440.0 |
| 2016-12-30 08:05:00 | AAPL | Stock | 29.2725 | 29.2725 | 29.2725 | 29.2725 | 4000.0 |
| 2016-12-30 08:10:00 | AAPL | Stock | 29.27 | 29.27 | 29.27 | 29.27 | 860.0 |
| 2016-12-30 08:15:00 | AAPL | Stock | 29.275 | 29.275 | 29.275 | 29.275 | 1200.0 |
| 2016-12-30 08:25:00 | AAPL | Stock | 29.2625 | 29.2625 | 29.2575 | 29.2575 | 4972.0 |
| 2016-12-30 08:30:00 | AAPL | Stock | 29.25 | 29.25 | 29.2275 | 29.2375 | 12664.0 |
| 2016-12-30 08:35:00 | AAPL | Stock | 29.2375 | 29.2475 | 29.2275 | 29.2275 | 24800.0 |
| 2016-12-30 08:40:00 | AAPL | Stock | 29.235 | 29.235 | 29.225 | 29.225 | 2464.0 |
| 2016-12-30 08:50:00 | AAPL | Stock | 29.2325 | 29.2325 | 29.2325 | 29.2325 | 400.0 |
| 2016-12-30 08:55:00 | AAPL | Stock | 29.22 | 29.22 | 29.215 | 29.215 | 2000.0 |
| 2016-12-30 09:00:00 | AAPL | Stock | 29.22 | 29.22 | 29.21 | 29.21 | 29540.0 |
| 2016-12-30 09:05:00 | AAPL | Stock | 29.21 | 29.2125 | 29.2075 | 29.2125 | 21600.0 |
| 2016-12-30 09:10:00 | AAPL | Stock | 29.2 | 29.205 | 29.165 | 29.1875 | 35228.0 |
| 2016-12-30 09:15:00 | AAPL | Stock | 29.1975 | 29.2 | 29.19 | 29.1975 | 2492.0 |
| 2016-12-30 09:20:00 | AAPL | Stock | 29.1975 | 29.1975 | 29.1925 | 29.1975 | 5200.0 |
| 2016-12-30 09:25:00 | AAPL | Stock | 29.205 | 29.205 | 29.155 | 29.165 | 59532.0 |
| 2016-12-30 09:30:00 | AAPL | Stock | 29.1625 | 29.3 | 29.1625 | 29.2625 | 5023244.0 |
| 2016-12-30 09:35:00 | AAPL | Stock | 29.2625 | 29.2738 | 29.2175 | 29.245 | 1715152.0 |
| 2016-12-30 09:40:00 | AAPL | Stock | 29.2438 | 29.265 | 29.2025 | 29.23 | 1499832.0 |
| 2016-12-30 09:45:00 | AAPL | Stock | 29.23 | 29.2575 | 29.2125 | 29.2225 | 1086116.0 |
| 2016-12-30 09:50:00 | AAPL | Stock | 29.2225 | 29.225 | 29.165 | 29.1788 | 1138336.0 |
| 2016-12-30 09:55:00 | AAPL | Stock | 29.1825 | 29.19 | 29.0225 | 29.05 | 2152448.0 |
| 2016-12-30 10:00:00 | AAPL | Stock | 29.05 | 29.105 | 29.0175 | 29.07 | 1610456.0 |
| 2016-12-30 10:05:00 | AAPL | Stock | 29.07 | 29.095 | 29.0375 | 29.075 | 1098596.0 |
| 2016-12-30 10:10:00 | AAPL | Stock | 29.075 | 29.0875 | 29.065 | 29.085 | 833416.0 |
| 2016-12-30 10:15:00 | AAPL | Stock | 29.0875 | 29.1075 | 29.0738 | 29.08 | 1060132.0 |
| 2016-12-30 10:20:00 | AAPL | Stock | 29.08 | 29.0915 | 29.03 | 29.0575 | 1065948.0 |
| 2016-12-30 10:25:00 | AAPL | Stock | 29.0575 | 29.075 | 29.045 | 29.0452 | 743636.0 |
| 2016-12-30 10:30:00 | AAPL | Stock | 29.045 | 29.0825 | 29.045 | 29.0725 | 758356.0 |
| 2016-12-30 10:35:00 | AAPL | Stock | 29.07 | 29.0725 | 29.035 | 29.0488 | 771140.0 |
> showing 50 of 352,962 rows — these rows as CSV