PREVIEW / stock_5min / 2016-07-07
file: by_date/stock_5min/2016/2016-07-07.parquet size: 5.3 MB rows: 352,959 symbols: 3,261
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-07 05:50:00 | AAPL | Stock | 23.9225 | 23.9225 | 23.9225 | 23.9225 | 644.0 |
| 2016-07-07 06:10:00 | AAPL | Stock | 23.9225 | 23.9225 | 23.9225 | 23.9225 | 2956.0 |
| 2016-07-07 06:15:00 | AAPL | Stock | 23.9225 | 23.9225 | 23.9225 | 23.9225 | 400.0 |
| 2016-07-07 06:25:00 | AAPL | Stock | 23.9 | 23.9 | 23.9 | 23.9 | 400.0 |
| 2016-07-07 07:00:00 | AAPL | Stock | 23.92 | 23.92 | 23.9 | 23.9 | 1600.0 |
| 2016-07-07 07:05:00 | AAPL | Stock | 23.9225 | 23.94 | 23.9125 | 23.9125 | 15876.0 |
| 2016-07-07 07:10:00 | AAPL | Stock | 23.9125 | 23.9125 | 23.9125 | 23.9125 | 2000.0 |
| 2016-07-07 07:15:00 | AAPL | Stock | 23.905 | 23.905 | 23.9 | 23.9 | 2944.0 |
| 2016-07-07 07:30:00 | AAPL | Stock | 23.8875 | 23.8875 | 23.885 | 23.885 | 1476.0 |
| 2016-07-07 07:40:00 | AAPL | Stock | 23.88 | 23.88 | 23.88 | 23.88 | 4000.0 |
| 2016-07-07 07:45:00 | AAPL | Stock | 23.8775 | 23.8775 | 23.8775 | 23.8775 | 7464.0 |
| 2016-07-07 08:00:00 | AAPL | Stock | 23.9 | 23.9 | 23.89 | 23.8975 | 12700.0 |
| 2016-07-07 08:05:00 | AAPL | Stock | 23.8975 | 23.9 | 23.8975 | 23.9 | 10528.0 |
| 2016-07-07 08:10:00 | AAPL | Stock | 23.8875 | 23.8875 | 23.8875 | 23.8875 | 2000.0 |
| 2016-07-07 08:15:00 | AAPL | Stock | 23.89 | 23.895 | 23.89 | 23.895 | 3168.0 |
| 2016-07-07 08:20:00 | AAPL | Stock | 23.91 | 23.915 | 23.91 | 23.915 | 3120.0 |
| 2016-07-07 08:25:00 | AAPL | Stock | 23.9 | 23.9125 | 23.895 | 23.9 | 23380.0 |
| 2016-07-07 08:30:00 | AAPL | Stock | 23.9125 | 23.9125 | 23.9025 | 23.91 | 3480.0 |
| 2016-07-07 08:35:00 | AAPL | Stock | 23.9025 | 23.9125 | 23.8925 | 23.8925 | 11000.0 |
| 2016-07-07 08:40:00 | AAPL | Stock | 23.9 | 23.905 | 23.9 | 23.905 | 5600.0 |
| 2016-07-07 08:45:00 | AAPL | Stock | 23.905 | 23.9125 | 23.9 | 23.9125 | 5380.0 |
| 2016-07-07 08:50:00 | AAPL | Stock | 23.9125 | 23.925 | 23.9125 | 23.925 | 3120.0 |
| 2016-07-07 08:55:00 | AAPL | Stock | 23.925 | 23.93 | 23.915 | 23.93 | 4000.0 |
| 2016-07-07 09:00:00 | AAPL | Stock | 23.9375 | 23.9375 | 23.9325 | 23.9325 | 5500.0 |
| 2016-07-07 09:05:00 | AAPL | Stock | 23.9325 | 23.935 | 23.92 | 23.9275 | 10320.0 |
| 2016-07-07 09:10:00 | AAPL | Stock | 23.9175 | 23.9225 | 23.9125 | 23.9125 | 17524.0 |
| 2016-07-07 09:15:00 | AAPL | Stock | 23.93 | 23.935 | 23.915 | 23.935 | 4360.0 |
| 2016-07-07 09:20:00 | AAPL | Stock | 23.935 | 23.935 | 23.935 | 23.935 | 23272.0 |
| 2016-07-07 09:25:00 | AAPL | Stock | 23.925 | 23.95 | 23.925 | 23.935 | 27432.0 |
| 2016-07-07 09:30:00 | AAPL | Stock | 23.925 | 24.0 | 23.9225 | 23.98 | 4007668.0 |
| 2016-07-07 09:35:00 | AAPL | Stock | 23.98 | 24.0288 | 23.965 | 24.0125 | 3032888.0 |
| 2016-07-07 09:40:00 | AAPL | Stock | 24.0125 | 24.09 | 24.005 | 24.055 | 3272124.0 |
| 2016-07-07 09:45:00 | AAPL | Stock | 24.0538 | 24.07 | 24.035 | 24.0625 | 2181136.0 |
| 2016-07-07 09:50:00 | AAPL | Stock | 24.06 | 24.1225 | 24.06 | 24.1 | 2834132.0 |
| 2016-07-07 09:55:00 | AAPL | Stock | 24.1025 | 24.1075 | 24.07 | 24.0812 | 1822236.0 |
| 2016-07-07 10:00:00 | AAPL | Stock | 24.08 | 24.085 | 24.0525 | 24.0675 | 1565552.0 |
| 2016-07-07 10:05:00 | AAPL | Stock | 24.0625 | 24.095 | 24.055 | 24.0625 | 1019572.0 |
| 2016-07-07 10:10:00 | AAPL | Stock | 24.065 | 24.065 | 24.0475 | 24.055 | 1033620.0 |
| 2016-07-07 10:15:00 | AAPL | Stock | 24.055 | 24.095 | 24.0525 | 24.075 | 1928280.0 |
| 2016-07-07 10:20:00 | AAPL | Stock | 24.0725 | 24.0837 | 24.0588 | 24.0725 | 1031648.0 |
| 2016-07-07 10:25:00 | AAPL | Stock | 24.075 | 24.0875 | 24.065 | 24.065 | 1068180.0 |
| 2016-07-07 10:30:00 | AAPL | Stock | 24.0675 | 24.1125 | 24.0672 | 24.111 | 1680788.0 |
| 2016-07-07 10:35:00 | AAPL | Stock | 24.11 | 24.1225 | 24.1075 | 24.116 | 1346052.0 |
| 2016-07-07 10:40:00 | AAPL | Stock | 24.1162 | 24.125 | 24.08 | 24.0805 | 1837332.0 |
| 2016-07-07 10:45:00 | AAPL | Stock | 24.08 | 24.085 | 24.0625 | 24.0725 | 828280.0 |
| 2016-07-07 10:50:00 | AAPL | Stock | 24.0725 | 24.075 | 24.025 | 24.03 | 855164.0 |
| 2016-07-07 10:55:00 | AAPL | Stock | 24.03 | 24.04 | 24.005 | 24.025 | 1170940.0 |
| 2016-07-07 11:00:00 | AAPL | Stock | 24.025 | 24.0425 | 24.0075 | 24.0075 | 965576.0 |
| 2016-07-07 11:05:00 | AAPL | Stock | 24.01 | 24.0525 | 24.0075 | 24.0375 | 911504.0 |
| 2016-07-07 11:10:00 | AAPL | Stock | 24.0365 | 24.0578 | 24.03 | 24.0475 | 668936.0 |
> showing 50 of 352,959 rows — these rows as CSV