PREVIEW / stock_5min / 2016-07-21
file: by_date/stock_5min/2016/2016-07-21.parquet size: 5.3 MB rows: 351,781 symbols: 3,249
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-07-21 05:00:00 | AAPL | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 1056.0 |
| 2016-07-21 06:15:00 | AAPL | Stock | 25.07 | 25.07 | 25.07 | 25.07 | 2496.0 |
| 2016-07-21 06:35:00 | AAPL | Stock | 25.07 | 25.07 | 25.0225 | 25.0225 | 5760.0 |
| 2016-07-21 07:10:00 | AAPL | Stock | 25.05 | 25.05 | 25.0375 | 25.0375 | 7200.0 |
| 2016-07-21 07:15:00 | AAPL | Stock | 25.0375 | 25.0375 | 25.0375 | 25.0375 | 400.0 |
| 2016-07-21 07:20:00 | AAPL | Stock | 25.025 | 25.025 | 25.025 | 25.025 | 1200.0 |
| 2016-07-21 07:25:00 | AAPL | Stock | 25.025 | 25.025 | 25.025 | 25.025 | 400.0 |
| 2016-07-21 07:35:00 | AAPL | Stock | 25.025 | 25.025 | 25.025 | 25.025 | 1456.0 |
| 2016-07-21 07:40:00 | AAPL | Stock | 25.0275 | 25.0375 | 25.025 | 25.0375 | 13608.0 |
| 2016-07-21 07:45:00 | AAPL | Stock | 25.025 | 25.025 | 25.025 | 25.025 | 2540.0 |
| 2016-07-21 07:55:00 | AAPL | Stock | 25.03 | 25.03 | 25.03 | 25.03 | 1600.0 |
| 2016-07-21 08:00:00 | AAPL | Stock | 25.0125 | 25.0375 | 25.0125 | 25.03 | 25800.0 |
| 2016-07-21 08:05:00 | AAPL | Stock | 25.015 | 25.025 | 25.015 | 25.025 | 6000.0 |
| 2016-07-21 08:10:00 | AAPL | Stock | 25.0175 | 25.03 | 25.0175 | 25.03 | 10000.0 |
| 2016-07-21 08:15:00 | AAPL | Stock | 25.025 | 25.045 | 25.025 | 25.045 | 46880.0 |
| 2016-07-21 08:20:00 | AAPL | Stock | 25.035 | 25.035 | 25.0325 | 25.0325 | 8400.0 |
| 2016-07-21 08:25:00 | AAPL | Stock | 25.0325 | 25.035 | 25.0325 | 25.035 | 8000.0 |
| 2016-07-21 08:30:00 | AAPL | Stock | 25.0375 | 25.0475 | 25.0325 | 25.0325 | 21272.0 |
| 2016-07-21 08:35:00 | AAPL | Stock | 25.045 | 25.045 | 25.045 | 25.045 | 25868.0 |
| 2016-07-21 08:40:00 | AAPL | Stock | 25.045 | 25.0575 | 25.0375 | 25.0375 | 23052.0 |
| 2016-07-21 08:45:00 | AAPL | Stock | 25.0475 | 25.0475 | 25.03 | 25.03 | 6120.0 |
| 2016-07-21 08:50:00 | AAPL | Stock | 25.03 | 25.03 | 25.03 | 25.03 | 2800.0 |
| 2016-07-21 08:55:00 | AAPL | Stock | 25.0325 | 25.0325 | 25.0325 | 25.0325 | 2400.0 |
| 2016-07-21 09:00:00 | AAPL | Stock | 25.035 | 25.0625 | 25.0325 | 25.0625 | 16484.0 |
| 2016-07-21 09:05:00 | AAPL | Stock | 25.055 | 25.055 | 25.045 | 25.045 | 36156.0 |
| 2016-07-21 09:15:00 | AAPL | Stock | 25.0375 | 25.0375 | 25.0225 | 25.0225 | 40612.0 |
| 2016-07-21 09:20:00 | AAPL | Stock | 25.0125 | 25.0125 | 25.01 | 25.01 | 5504.0 |
| 2016-07-21 09:25:00 | AAPL | Stock | 25.0075 | 25.0075 | 24.955 | 24.955 | 67308.0 |
| 2016-07-21 09:30:00 | AAPL | Stock | 24.955 | 25.0625 | 24.955 | 25.0075 | 4603804.0 |
| 2016-07-21 09:35:00 | AAPL | Stock | 25.01 | 25.115 | 25.005 | 25.1075 | 3636468.0 |
| 2016-07-21 09:40:00 | AAPL | Stock | 25.1075 | 25.2325 | 25.105 | 25.2275 | 6259328.0 |
| 2016-07-21 09:45:00 | AAPL | Stock | 25.2288 | 25.25 | 25.21 | 25.2438 | 3671392.0 |
| 2016-07-21 09:50:00 | AAPL | Stock | 25.2438 | 25.25 | 25.19 | 25.1925 | 3610820.0 |
| 2016-07-21 09:55:00 | AAPL | Stock | 25.1925 | 25.195 | 25.125 | 25.1688 | 2410608.0 |
| 2016-07-21 10:00:00 | AAPL | Stock | 25.17 | 25.21 | 25.1625 | 25.1875 | 2025400.0 |
| 2016-07-21 10:05:00 | AAPL | Stock | 25.1862 | 25.1875 | 25.14 | 25.155 | 1557784.0 |
| 2016-07-21 10:10:00 | AAPL | Stock | 25.155 | 25.1875 | 25.155 | 25.1775 | 1683604.0 |
| 2016-07-21 10:15:00 | AAPL | Stock | 25.1758 | 25.1775 | 25.145 | 25.145 | 1246456.0 |
| 2016-07-21 10:20:00 | AAPL | Stock | 25.1475 | 25.1575 | 25.105 | 25.1125 | 1522888.0 |
| 2016-07-21 10:25:00 | AAPL | Stock | 25.1125 | 25.1125 | 25.075 | 25.1045 | 2300412.0 |
| 2016-07-21 10:30:00 | AAPL | Stock | 25.105 | 25.1125 | 25.055 | 25.07 | 2119032.0 |
| 2016-07-21 10:35:00 | AAPL | Stock | 25.07 | 25.08 | 25.0425 | 25.0575 | 2103204.0 |
| 2016-07-21 10:40:00 | AAPL | Stock | 25.0575 | 25.065 | 25.0425 | 25.0475 | 1370592.0 |
| 2016-07-21 10:45:00 | AAPL | Stock | 25.0475 | 25.0475 | 25.0125 | 25.02 | 1810896.0 |
| 2016-07-21 10:50:00 | AAPL | Stock | 25.0225 | 25.05 | 25.02 | 25.0325 | 1254308.0 |
| 2016-07-21 10:55:00 | AAPL | Stock | 25.035 | 25.0375 | 25.015 | 25.02 | 834500.0 |
| 2016-07-21 11:00:00 | AAPL | Stock | 25.018 | 25.04 | 25.0175 | 25.04 | 1050304.0 |
| 2016-07-21 11:05:00 | AAPL | Stock | 25.04 | 25.045 | 25.0325 | 25.04 | 860328.0 |
| 2016-07-21 11:10:00 | AAPL | Stock | 25.039 | 25.0462 | 25.0275 | 25.0372 | 781504.0 |
| 2016-07-21 11:15:00 | AAPL | Stock | 25.0375 | 25.0475 | 25.03 | 25.0475 | 785728.0 |
> showing 50 of 351,781 rows — these rows as CSV