PREVIEW / stock_5min / 2015-06-19
file: by_date/stock_5min/2015/2015-06-19.parquet size: 5.5 MB rows: 367,226 symbols: 3,514
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 |
|---|---|---|---|---|---|---|---|
| 2015-06-19 04:00:00 | AAPL | Stock | 32.0 | 32.0375 | 32.0 | 32.0375 | 1200.0 |
| 2015-06-19 04:05:00 | AAPL | Stock | 32.0 | 32.0 | 32.0 | 32.0 | 400.0 |
| 2015-06-19 04:10:00 | AAPL | Stock | 32.01 | 32.01 | 32.01 | 32.01 | 400.0 |
| 2015-06-19 05:30:00 | AAPL | Stock | 32.0325 | 32.0325 | 32.0325 | 32.0325 | 800.0 |
| 2015-06-19 05:55:00 | AAPL | Stock | 32.01 | 32.01 | 32.0075 | 32.0075 | 8000.0 |
| 2015-06-19 06:05:00 | AAPL | Stock | 32.03 | 32.03 | 32.03 | 32.03 | 2400.0 |
| 2015-06-19 06:10:00 | AAPL | Stock | 32.03 | 32.03 | 32.03 | 32.03 | 2400.0 |
| 2015-06-19 06:15:00 | AAPL | Stock | 32.03 | 32.03 | 32.03 | 32.03 | 400.0 |
| 2015-06-19 06:40:00 | AAPL | Stock | 32.0375 | 32.0375 | 32.0275 | 32.0275 | 2856.0 |
| 2015-06-19 06:45:00 | AAPL | Stock | 32.0275 | 32.0375 | 32.0275 | 32.0375 | 5744.0 |
| 2015-06-19 06:55:00 | AAPL | Stock | 32.0125 | 32.0125 | 32.0125 | 32.0125 | 1412.0 |
| 2015-06-19 07:10:00 | AAPL | Stock | 32.035 | 32.0375 | 32.025 | 32.025 | 8800.0 |
| 2015-06-19 07:15:00 | AAPL | Stock | 32.025 | 32.025 | 32.025 | 32.025 | 1200.0 |
| 2015-06-19 07:20:00 | AAPL | Stock | 32.015 | 32.015 | 32.015 | 32.015 | 2000.0 |
| 2015-06-19 07:30:00 | AAPL | Stock | 32.02 | 32.02 | 32.02 | 32.02 | 8000.0 |
| 2015-06-19 07:35:00 | AAPL | Stock | 32.02 | 32.035 | 32.02 | 32.035 | 7832.0 |
| 2015-06-19 07:40:00 | AAPL | Stock | 32.025 | 32.025 | 32.025 | 32.025 | 4800.0 |
| 2015-06-19 07:45:00 | AAPL | Stock | 32.025 | 32.025 | 32.025 | 32.025 | 1200.0 |
| 2015-06-19 07:55:00 | AAPL | Stock | 32.02 | 32.02 | 32.0175 | 32.02 | 2360.0 |
| 2015-06-19 08:00:00 | AAPL | Stock | 32.0275 | 32.04 | 31.9125 | 32.0395 | 102316.0 |
| 2015-06-19 08:05:00 | AAPL | Stock | 32.03 | 32.03 | 32.0125 | 32.015 | 43380.0 |
| 2015-06-19 08:10:00 | AAPL | Stock | 32.0225 | 32.0225 | 32.0125 | 32.0125 | 11000.0 |
| 2015-06-19 08:15:00 | AAPL | Stock | 32.0125 | 32.0125 | 32.0125 | 32.0125 | 1600.0 |
| 2015-06-19 08:20:00 | AAPL | Stock | 32.0125 | 32.02 | 32.0125 | 32.02 | 4992.0 |
| 2015-06-19 08:25:00 | AAPL | Stock | 32.02 | 32.025 | 32.0125 | 32.025 | 14620.0 |
| 2015-06-19 08:30:00 | AAPL | Stock | 32.025 | 32.025 | 32.0125 | 32.025 | 8620.0 |
| 2015-06-19 08:35:00 | AAPL | Stock | 32.015 | 32.015 | 32.0 | 32.0075 | 17188.0 |
| 2015-06-19 08:40:00 | AAPL | Stock | 32.0175 | 32.0175 | 32.0075 | 32.0175 | 18356.0 |
| 2015-06-19 08:45:00 | AAPL | Stock | 32.0175 | 32.0175 | 32.0025 | 32.01 | 52360.0 |
| 2015-06-19 08:50:00 | AAPL | Stock | 32.0025 | 32.01 | 31.9925 | 31.995 | 41484.0 |
| 2015-06-19 08:55:00 | AAPL | Stock | 32.0 | 32.005 | 31.995 | 32.005 | 56084.0 |
| 2015-06-19 09:00:00 | AAPL | Stock | 32.01 | 32.02 | 32.01 | 32.0175 | 37696.0 |
| 2015-06-19 09:05:00 | AAPL | Stock | 32.0175 | 32.0175 | 31.98 | 31.9875 | 56996.0 |
| 2015-06-19 09:10:00 | AAPL | Stock | 31.9825 | 31.9975 | 31.975 | 31.9875 | 58900.0 |
| 2015-06-19 09:15:00 | AAPL | Stock | 31.9825 | 32.0 | 31.975 | 31.98 | 69360.0 |
| 2015-06-19 09:20:00 | AAPL | Stock | 31.98 | 31.985 | 31.975 | 31.985 | 55892.0 |
| 2015-06-19 09:25:00 | AAPL | Stock | 31.985 | 31.985 | 31.895 | 31.9325 | 1450676.0 |
| 2015-06-19 09:30:00 | AAPL | Stock | 31.9325 | 31.955 | 31.845 | 31.8675 | 38555648.0 |
| 2015-06-19 09:35:00 | AAPL | Stock | 31.87 | 31.8925 | 31.8375 | 31.845 | 3116820.0 |
| 2015-06-19 09:40:00 | AAPL | Stock | 31.845 | 31.8825 | 31.825 | 31.8775 | 3448428.0 |
| 2015-06-19 09:45:00 | AAPL | Stock | 31.8762 | 31.884 | 31.82 | 31.8225 | 2638584.0 |
| 2015-06-19 09:50:00 | AAPL | Stock | 31.8225 | 31.8775 | 31.82 | 31.84 | 2297136.0 |
| 2015-06-19 09:55:00 | AAPL | Stock | 31.84 | 31.8975 | 31.83 | 31.8825 | 2457776.0 |
| 2015-06-19 10:00:00 | AAPL | Stock | 31.8875 | 31.905 | 31.85 | 31.8545 | 1887160.0 |
| 2015-06-19 10:05:00 | AAPL | Stock | 31.8525 | 31.8725 | 31.8355 | 31.8395 | 1794520.0 |
| 2015-06-19 10:10:00 | AAPL | Stock | 31.8375 | 31.855 | 31.8225 | 31.834 | 2231904.0 |
| 2015-06-19 10:15:00 | AAPL | Stock | 31.835 | 31.845 | 31.82 | 31.8425 | 1714704.0 |
| 2015-06-19 10:20:00 | AAPL | Stock | 31.84 | 31.86 | 31.83 | 31.8375 | 1583104.0 |
| 2015-06-19 10:25:00 | AAPL | Stock | 31.8362 | 31.8525 | 31.8275 | 31.83 | 1270996.0 |
| 2015-06-19 10:30:00 | AAPL | Stock | 31.83 | 31.8325 | 31.8025 | 31.805 | 2316900.0 |
> showing 50 of 367,226 rows — these rows as CSV