PREVIEW / stock_5min / 2017-07-13
file: by_date/stock_5min/2017/2017-07-13.parquet size: 5.2 MB rows: 343,214 symbols: 2,992
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 |
|---|---|---|---|---|---|---|---|
| 2017-07-13 04:10:00 | AAPL | Stock | 36.44 | 36.44 | 36.44 | 36.44 | 1424.0 |
| 2017-07-13 04:50:00 | AAPL | Stock | 36.4375 | 36.4375 | 36.4375 | 36.4375 | 1680.0 |
| 2017-07-13 05:00:00 | AAPL | Stock | 36.4675 | 36.4675 | 36.4675 | 36.4675 | 2000.0 |
| 2017-07-13 05:10:00 | AAPL | Stock | 36.47 | 36.4725 | 36.47 | 36.4725 | 2400.0 |
| 2017-07-13 05:15:00 | AAPL | Stock | 36.5 | 36.5 | 36.4875 | 36.49 | 1300.0 |
| 2017-07-13 05:20:00 | AAPL | Stock | 36.5 | 36.5 | 36.5 | 36.5 | 500.0 |
| 2017-07-13 05:40:00 | AAPL | Stock | 36.5 | 36.5 | 36.5 | 36.5 | 2000.0 |
| 2017-07-13 06:10:00 | AAPL | Stock | 36.48 | 36.48 | 36.48 | 36.48 | 3200.0 |
| 2017-07-13 06:15:00 | AAPL | Stock | 36.475 | 36.475 | 36.475 | 36.475 | 936.0 |
| 2017-07-13 06:30:00 | AAPL | Stock | 36.455 | 36.455 | 36.455 | 36.455 | 4000.0 |
| 2017-07-13 06:35:00 | AAPL | Stock | 36.45 | 36.45 | 36.45 | 36.45 | 9508.0 |
| 2017-07-13 07:05:00 | AAPL | Stock | 36.4175 | 36.4275 | 36.4175 | 36.4275 | 1600.0 |
| 2017-07-13 07:10:00 | AAPL | Stock | 36.425 | 36.45 | 36.425 | 36.45 | 2000.0 |
| 2017-07-13 07:15:00 | AAPL | Stock | 36.4375 | 36.4375 | 36.4375 | 36.4375 | 1800.0 |
| 2017-07-13 07:20:00 | AAPL | Stock | 36.425 | 36.4375 | 36.425 | 36.4375 | 3600.0 |
| 2017-07-13 07:25:00 | AAPL | Stock | 36.4375 | 36.4375 | 36.4 | 36.4 | 12896.0 |
| 2017-07-13 07:30:00 | AAPL | Stock | 36.42 | 36.42 | 36.42 | 36.42 | 400.0 |
| 2017-07-13 07:35:00 | AAPL | Stock | 36.4 | 36.42 | 36.4 | 36.42 | 6400.0 |
| 2017-07-13 07:40:00 | AAPL | Stock | 36.39 | 36.39 | 36.38 | 36.385 | 2400.0 |
| 2017-07-13 07:45:00 | AAPL | Stock | 36.38 | 36.385 | 36.38 | 36.385 | 11696.0 |
| 2017-07-13 07:55:00 | AAPL | Stock | 36.385 | 36.405 | 36.385 | 36.405 | 2400.0 |
| 2017-07-13 08:00:00 | AAPL | Stock | 36.4275 | 36.4275 | 36.375 | 36.4075 | 9684.0 |
| 2017-07-13 08:05:00 | AAPL | Stock | 36.4175 | 36.4175 | 36.4 | 36.405 | 7600.0 |
| 2017-07-13 08:10:00 | AAPL | Stock | 36.4175 | 36.4175 | 36.395 | 36.4175 | 8560.0 |
| 2017-07-13 08:15:00 | AAPL | Stock | 36.4025 | 36.4025 | 36.4025 | 36.4025 | 5548.0 |
| 2017-07-13 08:20:00 | AAPL | Stock | 36.41 | 36.41 | 36.41 | 36.41 | 2000.0 |
| 2017-07-13 08:25:00 | AAPL | Stock | 36.4075 | 36.435 | 36.4025 | 36.435 | 8416.0 |
| 2017-07-13 08:30:00 | AAPL | Stock | 36.4225 | 36.45 | 36.4075 | 36.4375 | 17700.0 |
| 2017-07-13 08:40:00 | AAPL | Stock | 36.4375 | 36.445 | 36.435 | 36.435 | 8604.0 |
| 2017-07-13 08:45:00 | AAPL | Stock | 36.4175 | 36.42 | 36.405 | 36.405 | 14064.0 |
| 2017-07-13 08:50:00 | AAPL | Stock | 36.4 | 36.4 | 36.4 | 36.4 | 2000.0 |
| 2017-07-13 08:55:00 | AAPL | Stock | 36.4125 | 36.4125 | 36.4 | 36.4 | 1692.0 |
| 2017-07-13 09:00:00 | AAPL | Stock | 36.4175 | 36.4175 | 36.4175 | 36.4175 | 800.0 |
| 2017-07-13 09:05:00 | AAPL | Stock | 36.4175 | 36.4175 | 36.4 | 36.4025 | 14144.0 |
| 2017-07-13 09:10:00 | AAPL | Stock | 36.405 | 36.405 | 36.3975 | 36.3975 | 24008.0 |
| 2017-07-13 09:15:00 | AAPL | Stock | 36.3875 | 36.3875 | 36.3825 | 36.3875 | 10760.0 |
| 2017-07-13 09:20:00 | AAPL | Stock | 36.39 | 36.39 | 36.36 | 36.3725 | 34944.0 |
| 2017-07-13 09:25:00 | AAPL | Stock | 36.3725 | 36.4 | 36.3575 | 36.3875 | 23516.0 |
| 2017-07-13 09:30:00 | AAPL | Stock | 36.375 | 36.5538 | 36.36 | 36.5375 | 3672584.0 |
| 2017-07-13 09:35:00 | AAPL | Stock | 36.5325 | 36.6125 | 36.5325 | 36.585 | 2413380.0 |
| 2017-07-13 09:40:00 | AAPL | Stock | 36.5875 | 36.605 | 36.555 | 36.5925 | 1387052.0 |
| 2017-07-13 09:45:00 | AAPL | Stock | 36.5925 | 36.6625 | 36.5925 | 36.6425 | 1735068.0 |
| 2017-07-13 09:50:00 | AAPL | Stock | 36.6425 | 36.715 | 36.6425 | 36.71 | 1668632.0 |
| 2017-07-13 09:55:00 | AAPL | Stock | 36.715 | 36.78 | 36.705 | 36.7525 | 2373624.0 |
| 2017-07-13 10:00:00 | AAPL | Stock | 36.755 | 36.8325 | 36.755 | 36.7912 | 1903692.0 |
| 2017-07-13 10:05:00 | AAPL | Stock | 36.79 | 36.8325 | 36.77 | 36.8038 | 1715828.0 |
| 2017-07-13 10:10:00 | AAPL | Stock | 36.8025 | 36.8475 | 36.775 | 36.7875 | 1579060.0 |
| 2017-07-13 10:15:00 | AAPL | Stock | 36.7825 | 36.79 | 36.705 | 36.715 | 1451456.0 |
| 2017-07-13 10:20:00 | AAPL | Stock | 36.7125 | 36.75 | 36.7025 | 36.7275 | 1086244.0 |
| 2017-07-13 10:25:00 | AAPL | Stock | 36.725 | 36.74 | 36.66 | 36.675 | 1227320.0 |
> showing 50 of 343,214 rows — these rows as CSV