PREVIEW / stock_5min / 2018-02-05
file: by_date/stock_5min/2018/2018-02-05.parquet size: 6.2 MB rows: 391,096 symbols: 2,912
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 |
|---|---|---|---|---|---|---|---|
| 2018-02-05 04:00:00 | AAPL | Stock | 40.0 | 40.0 | 40.0 | 40.0 | 9768.0 |
| 2018-02-05 04:05:00 | AAPL | Stock | 39.95 | 40.0 | 39.9375 | 40.0 | 29864.0 |
| 2018-02-05 04:10:00 | AAPL | Stock | 40.0 | 40.0 | 40.0 | 40.0 | 12812.0 |
| 2018-02-05 04:15:00 | AAPL | Stock | 40.0 | 40.025 | 39.9625 | 40.0 | 10848.0 |
| 2018-02-05 04:20:00 | AAPL | Stock | 40.0 | 40.005 | 40.0 | 40.005 | 1600.0 |
| 2018-02-05 04:25:00 | AAPL | Stock | 40.0225 | 40.0375 | 40.0 | 40.0375 | 7096.0 |
| 2018-02-05 04:30:00 | AAPL | Stock | 40.025 | 40.025 | 40.0125 | 40.02 | 2808.0 |
| 2018-02-05 04:40:00 | AAPL | Stock | 40.07 | 40.07 | 40.05 | 40.07 | 13960.0 |
| 2018-02-05 04:45:00 | AAPL | Stock | 40.1225 | 40.1275 | 40.1225 | 40.125 | 3000.0 |
| 2018-02-05 04:50:00 | AAPL | Stock | 40.1675 | 40.175 | 40.15 | 40.15 | 1964.0 |
| 2018-02-05 04:55:00 | AAPL | Stock | 40.1 | 40.125 | 40.1 | 40.125 | 1600.0 |
| 2018-02-05 05:00:00 | AAPL | Stock | 40.09 | 40.09 | 40.0725 | 40.0725 | 4400.0 |
| 2018-02-05 05:10:00 | AAPL | Stock | 40.12 | 40.15 | 40.12 | 40.125 | 4060.0 |
| 2018-02-05 05:15:00 | AAPL | Stock | 40.1275 | 40.1275 | 40.125 | 40.125 | 5600.0 |
| 2018-02-05 05:20:00 | AAPL | Stock | 40.0925 | 40.11 | 40.0925 | 40.11 | 2800.0 |
| 2018-02-05 05:25:00 | AAPL | Stock | 40.09 | 40.0925 | 40.09 | 40.09 | 4460.0 |
| 2018-02-05 05:35:00 | AAPL | Stock | 40.125 | 40.125 | 40.125 | 40.125 | 7592.0 |
| 2018-02-05 05:40:00 | AAPL | Stock | 40.125 | 40.17 | 40.125 | 40.17 | 11236.0 |
| 2018-02-05 05:55:00 | AAPL | Stock | 40.14 | 40.14 | 40.14 | 40.14 | 400.0 |
| 2018-02-05 06:00:00 | AAPL | Stock | 40.1375 | 40.1375 | 40.095 | 40.095 | 10584.0 |
| 2018-02-05 06:05:00 | AAPL | Stock | 40.065 | 40.075 | 40.025 | 40.03 | 24372.0 |
| 2018-02-05 06:10:00 | AAPL | Stock | 40.0 | 40.0225 | 39.965 | 39.965 | 22344.0 |
| 2018-02-05 06:15:00 | AAPL | Stock | 39.965 | 40.0 | 39.9625 | 40.0 | 8312.0 |
| 2018-02-05 06:20:00 | AAPL | Stock | 39.9775 | 40.0 | 39.975 | 40.0 | 5988.0 |
| 2018-02-05 06:25:00 | AAPL | Stock | 40.0 | 40.0 | 39.9725 | 40.0 | 5176.0 |
| 2018-02-05 06:30:00 | AAPL | Stock | 40.0 | 40.0525 | 40.0 | 40.05 | 13104.0 |
| 2018-02-05 06:35:00 | AAPL | Stock | 40.045 | 40.045 | 39.9875 | 39.9875 | 13392.0 |
| 2018-02-05 06:40:00 | AAPL | Stock | 39.975 | 39.975 | 39.75 | 39.845 | 95208.0 |
| 2018-02-05 06:45:00 | AAPL | Stock | 39.855 | 39.9 | 39.855 | 39.895 | 66792.0 |
| 2018-02-05 06:50:00 | AAPL | Stock | 39.895 | 39.895 | 39.895 | 39.895 | 1404.0 |
| 2018-02-05 06:55:00 | AAPL | Stock | 39.9375 | 39.9375 | 39.8825 | 39.8875 | 11680.0 |
| 2018-02-05 07:00:00 | AAPL | Stock | 39.8875 | 39.9 | 39.7275 | 39.75 | 119552.0 |
| 2018-02-05 07:05:00 | AAPL | Stock | 39.7275 | 39.75 | 39.6 | 39.6025 | 85464.0 |
| 2018-02-05 07:10:00 | AAPL | Stock | 39.6025 | 39.675 | 39.5925 | 39.625 | 108180.0 |
| 2018-02-05 07:15:00 | AAPL | Stock | 39.64 | 39.75 | 39.625 | 39.74 | 86604.0 |
| 2018-02-05 07:20:00 | AAPL | Stock | 39.675 | 39.7725 | 39.675 | 39.7575 | 76512.0 |
| 2018-02-05 07:25:00 | AAPL | Stock | 39.765 | 39.775 | 39.6375 | 39.76 | 90580.0 |
| 2018-02-05 07:30:00 | AAPL | Stock | 39.75 | 39.86 | 39.75 | 39.7875 | 70228.0 |
| 2018-02-05 07:35:00 | AAPL | Stock | 39.775 | 39.7825 | 39.675 | 39.7625 | 146604.0 |
| 2018-02-05 07:40:00 | AAPL | Stock | 39.75 | 39.75 | 39.6425 | 39.7075 | 72472.0 |
| 2018-02-05 07:45:00 | AAPL | Stock | 39.685 | 39.7 | 39.625 | 39.625 | 73304.0 |
| 2018-02-05 07:50:00 | AAPL | Stock | 39.6125 | 39.655 | 39.57 | 39.5875 | 94264.0 |
| 2018-02-05 07:55:00 | AAPL | Stock | 39.5875 | 39.6625 | 39.5675 | 39.6625 | 129160.0 |
| 2018-02-05 08:00:00 | AAPL | Stock | 40.0 | 40.0125 | 39.57 | 39.7025 | 280392.0 |
| 2018-02-05 08:05:00 | AAPL | Stock | 39.7125 | 39.7125 | 39.6 | 39.6875 | 171308.0 |
| 2018-02-05 08:10:00 | AAPL | Stock | 39.67 | 39.685 | 39.605 | 39.685 | 80632.0 |
| 2018-02-05 08:15:00 | AAPL | Stock | 39.685 | 39.75 | 39.6625 | 39.705 | 162604.0 |
| 2018-02-05 08:20:00 | AAPL | Stock | 39.745 | 39.805 | 39.705 | 39.75 | 178728.0 |
| 2018-02-05 08:25:00 | AAPL | Stock | 39.76 | 39.7625 | 39.705 | 39.7125 | 146304.0 |
| 2018-02-05 08:30:00 | AAPL | Stock | 39.7125 | 39.765 | 39.7 | 39.7475 | 75908.0 |
> showing 50 of 391,096 rows — these rows as CSV