PREVIEW / stock_5min / 2016-05-04
file: by_date/stock_5min/2016/2016-05-04.parquet size: 5.4 MB rows: 360,070 symbols: 3,292
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-05-04 04:00:00 | AAPL | Stock | 23.8875 | 23.8875 | 23.815 | 23.815 | 10888.0 |
| 2016-05-04 04:20:00 | AAPL | Stock | 23.85 | 23.85 | 23.825 | 23.8325 | 9600.0 |
| 2016-05-04 04:25:00 | AAPL | Stock | 23.845 | 23.845 | 23.83 | 23.83 | 6728.0 |
| 2016-05-04 04:35:00 | AAPL | Stock | 23.8375 | 23.8375 | 23.8375 | 23.8375 | 6400.0 |
| 2016-05-04 04:40:00 | AAPL | Stock | 23.8025 | 23.8025 | 23.8 | 23.8 | 2952.0 |
| 2016-05-04 04:45:00 | AAPL | Stock | 23.8025 | 23.8025 | 23.8 | 23.8 | 1616.0 |
| 2016-05-04 04:50:00 | AAPL | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 2220.0 |
| 2016-05-04 04:55:00 | AAPL | Stock | 23.805 | 23.805 | 23.795 | 23.795 | 1440.0 |
| 2016-05-04 05:00:00 | AAPL | Stock | 23.795 | 23.795 | 23.795 | 23.795 | 1416.0 |
| 2016-05-04 05:05:00 | AAPL | Stock | 23.7925 | 23.7925 | 23.775 | 23.775 | 2800.0 |
| 2016-05-04 05:10:00 | AAPL | Stock | 23.7525 | 23.7525 | 23.75 | 23.75 | 4400.0 |
| 2016-05-04 05:20:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 600.0 |
| 2016-05-04 05:40:00 | AAPL | Stock | 23.7025 | 23.7025 | 23.6475 | 23.6475 | 7200.0 |
| 2016-05-04 05:45:00 | AAPL | Stock | 23.6575 | 23.6575 | 23.6575 | 23.6575 | 2800.0 |
| 2016-05-04 05:50:00 | AAPL | Stock | 23.65 | 23.65 | 23.65 | 23.65 | 400.0 |
| 2016-05-04 05:55:00 | AAPL | Stock | 23.65 | 23.65 | 23.64 | 23.64 | 2000.0 |
| 2016-05-04 06:00:00 | AAPL | Stock | 23.64 | 23.64 | 23.64 | 23.64 | 400.0 |
| 2016-05-04 06:10:00 | AAPL | Stock | 23.64 | 23.64 | 23.64 | 23.64 | 400.0 |
| 2016-05-04 06:20:00 | AAPL | Stock | 23.625 | 23.64 | 23.6225 | 23.64 | 5600.0 |
| 2016-05-04 06:25:00 | AAPL | Stock | 23.635 | 23.635 | 23.635 | 23.635 | 456.0 |
| 2016-05-04 06:30:00 | AAPL | Stock | 23.625 | 23.625 | 23.62 | 23.62 | 7900.0 |
| 2016-05-04 06:35:00 | AAPL | Stock | 23.6125 | 23.6125 | 23.6125 | 23.6125 | 400.0 |
| 2016-05-04 06:40:00 | AAPL | Stock | 23.6325 | 23.65 | 23.6325 | 23.65 | 5468.0 |
| 2016-05-04 06:50:00 | AAPL | Stock | 23.6475 | 23.65 | 23.6475 | 23.65 | 2400.0 |
| 2016-05-04 06:55:00 | AAPL | Stock | 23.6275 | 23.6275 | 23.6275 | 23.6275 | 400.0 |
| 2016-05-04 07:00:00 | AAPL | Stock | 23.625 | 23.6475 | 23.615 | 23.625 | 17276.0 |
| 2016-05-04 07:05:00 | AAPL | Stock | 23.6475 | 23.6475 | 23.6125 | 23.625 | 8800.0 |
| 2016-05-04 07:10:00 | AAPL | Stock | 23.6225 | 23.625 | 23.6225 | 23.6225 | 10400.0 |
| 2016-05-04 07:15:00 | AAPL | Stock | 23.6325 | 23.6375 | 23.63 | 23.6375 | 8000.0 |
| 2016-05-04 07:20:00 | AAPL | Stock | 23.65 | 23.65 | 23.6475 | 23.6475 | 1000.0 |
| 2016-05-04 07:25:00 | AAPL | Stock | 23.64 | 23.65 | 23.64 | 23.65 | 13496.0 |
| 2016-05-04 07:30:00 | AAPL | Stock | 23.635 | 23.6625 | 23.635 | 23.6625 | 1288.0 |
| 2016-05-04 07:35:00 | AAPL | Stock | 23.67 | 23.67 | 23.65 | 23.65 | 13144.0 |
| 2016-05-04 07:40:00 | AAPL | Stock | 23.6625 | 23.6625 | 23.6625 | 23.6625 | 1840.0 |
| 2016-05-04 07:45:00 | AAPL | Stock | 23.65 | 23.6625 | 23.65 | 23.6625 | 1936.0 |
| 2016-05-04 07:50:00 | AAPL | Stock | 23.6625 | 23.6625 | 23.6625 | 23.6625 | 760.0 |
| 2016-05-04 07:55:00 | AAPL | Stock | 23.655 | 23.6675 | 23.6525 | 23.6675 | 3400.0 |
| 2016-05-04 08:00:00 | AAPL | Stock | 23.67 | 23.7175 | 23.6125 | 23.7075 | 85344.0 |
| 2016-05-04 08:05:00 | AAPL | Stock | 23.7 | 23.735 | 23.7 | 23.735 | 34752.0 |
| 2016-05-04 08:10:00 | AAPL | Stock | 23.735 | 23.74 | 23.725 | 23.74 | 15588.0 |
| 2016-05-04 08:15:00 | AAPL | Stock | 23.7375 | 23.7375 | 23.7 | 23.7 | 57160.0 |
| 2016-05-04 08:20:00 | AAPL | Stock | 23.7025 | 23.745 | 23.7025 | 23.745 | 56940.0 |
| 2016-05-04 08:25:00 | AAPL | Stock | 23.7425 | 23.7425 | 23.71 | 23.725 | 53616.0 |
| 2016-05-04 08:30:00 | AAPL | Stock | 23.725 | 23.7375 | 23.715 | 23.7275 | 27332.0 |
| 2016-05-04 08:35:00 | AAPL | Stock | 23.735 | 23.7375 | 23.73 | 23.7375 | 5328.0 |
| 2016-05-04 08:40:00 | AAPL | Stock | 23.73 | 23.75 | 23.715 | 23.7225 | 59292.0 |
| 2016-05-04 08:45:00 | AAPL | Stock | 23.72 | 23.7225 | 23.715 | 23.715 | 33140.0 |
| 2016-05-04 08:50:00 | AAPL | Stock | 23.7125 | 23.7125 | 23.7 | 23.7 | 28292.0 |
| 2016-05-04 08:55:00 | AAPL | Stock | 23.715 | 23.715 | 23.715 | 23.715 | 5492.0 |
| 2016-05-04 09:00:00 | AAPL | Stock | 23.6925 | 23.71 | 23.6925 | 23.705 | 12000.0 |
> showing 50 of 360,070 rows — these rows as CSV