PREVIEW / stock_5min / 2018-01-17
file: by_date/stock_5min/2018/2018-01-17.parquet size: 5.8 MB rows: 370,913 symbols: 2,910
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-01-17 04:00:00 | AAPL | Stock | 43.5525 | 43.735 | 43.3 | 43.4375 | 107936.0 |
| 2018-01-17 04:05:00 | AAPL | Stock | 43.425 | 43.5 | 43.425 | 43.4625 | 25708.0 |
| 2018-01-17 04:10:00 | AAPL | Stock | 43.4625 | 43.525 | 43.4625 | 43.5 | 36796.0 |
| 2018-01-17 04:15:00 | AAPL | Stock | 43.5 | 43.5 | 43.5 | 43.5 | 824.0 |
| 2018-01-17 04:25:00 | AAPL | Stock | 43.5025 | 43.56 | 43.5 | 43.56 | 11464.0 |
| 2018-01-17 04:30:00 | AAPL | Stock | 43.5025 | 43.5025 | 43.5 | 43.5 | 19600.0 |
| 2018-01-17 04:35:00 | AAPL | Stock | 43.5425 | 43.55 | 43.5425 | 43.55 | 3868.0 |
| 2018-01-17 04:40:00 | AAPL | Stock | 43.5725 | 43.575 | 43.54 | 43.575 | 15832.0 |
| 2018-01-17 04:45:00 | AAPL | Stock | 43.565 | 43.5875 | 43.55 | 43.5875 | 9200.0 |
| 2018-01-17 04:55:00 | AAPL | Stock | 43.5875 | 43.6 | 43.5875 | 43.6 | 2400.0 |
| 2018-01-17 05:00:00 | AAPL | Stock | 43.6225 | 43.625 | 43.6225 | 43.625 | 15800.0 |
| 2018-01-17 05:05:00 | AAPL | Stock | 43.62 | 43.6475 | 43.62 | 43.6475 | 5572.0 |
| 2018-01-17 05:10:00 | AAPL | Stock | 43.66 | 43.66 | 43.66 | 43.66 | 400.0 |
| 2018-01-17 05:15:00 | AAPL | Stock | 43.625 | 43.625 | 43.625 | 43.625 | 400.0 |
| 2018-01-17 05:25:00 | AAPL | Stock | 43.66 | 43.66 | 43.66 | 43.66 | 1680.0 |
| 2018-01-17 05:30:00 | AAPL | Stock | 43.625 | 43.625 | 43.5875 | 43.5875 | 4828.0 |
| 2018-01-17 05:35:00 | AAPL | Stock | 43.6175 | 43.6175 | 43.6175 | 43.6175 | 4000.0 |
| 2018-01-17 05:40:00 | AAPL | Stock | 43.6175 | 43.625 | 43.6175 | 43.625 | 1800.0 |
| 2018-01-17 05:50:00 | AAPL | Stock | 43.625 | 43.6475 | 43.625 | 43.625 | 2000.0 |
| 2018-01-17 05:55:00 | AAPL | Stock | 43.6475 | 43.6475 | 43.6475 | 43.6475 | 1612.0 |
| 2018-01-17 06:00:00 | AAPL | Stock | 43.6475 | 43.7125 | 43.6475 | 43.685 | 13012.0 |
| 2018-01-17 06:05:00 | AAPL | Stock | 43.7175 | 43.8475 | 43.7175 | 43.8475 | 22144.0 |
| 2018-01-17 06:10:00 | AAPL | Stock | 43.8475 | 43.85 | 43.7575 | 43.805 | 16316.0 |
| 2018-01-17 06:15:00 | AAPL | Stock | 43.8125 | 43.8775 | 43.8125 | 43.8575 | 9196.0 |
| 2018-01-17 06:20:00 | AAPL | Stock | 43.825 | 43.825 | 43.825 | 43.825 | 400.0 |
| 2018-01-17 06:25:00 | AAPL | Stock | 43.825 | 43.825 | 43.825 | 43.825 | 3824.0 |
| 2018-01-17 06:40:00 | AAPL | Stock | 43.815 | 44.005 | 43.815 | 44.0 | 43592.0 |
| 2018-01-17 06:45:00 | AAPL | Stock | 44.0 | 44.0 | 43.8825 | 43.9 | 23372.0 |
| 2018-01-17 06:50:00 | AAPL | Stock | 43.8875 | 43.9 | 43.8875 | 43.9 | 12000.0 |
| 2018-01-17 06:55:00 | AAPL | Stock | 43.9 | 43.9 | 43.875 | 43.875 | 19564.0 |
| 2018-01-17 07:00:00 | AAPL | Stock | 43.875 | 44.0 | 43.8375 | 43.975 | 34028.0 |
| 2018-01-17 07:05:00 | AAPL | Stock | 43.98 | 44.05 | 43.98 | 44.05 | 21512.0 |
| 2018-01-17 07:10:00 | AAPL | Stock | 44.045 | 44.045 | 43.985 | 44.03 | 3120.0 |
| 2018-01-17 07:15:00 | AAPL | Stock | 43.9925 | 44.0 | 43.95 | 43.9875 | 20976.0 |
| 2018-01-17 07:20:00 | AAPL | Stock | 43.965 | 44.0 | 43.9525 | 43.9925 | 12568.0 |
| 2018-01-17 07:25:00 | AAPL | Stock | 43.9775 | 43.9975 | 43.975 | 43.9875 | 10272.0 |
| 2018-01-17 07:30:00 | AAPL | Stock | 43.975 | 44.0 | 43.9725 | 43.9725 | 28792.0 |
| 2018-01-17 07:35:00 | AAPL | Stock | 43.9625 | 43.9625 | 43.9575 | 43.9575 | 7160.0 |
| 2018-01-17 07:40:00 | AAPL | Stock | 43.945 | 43.945 | 43.91 | 43.925 | 30736.0 |
| 2018-01-17 07:45:00 | AAPL | Stock | 43.925 | 43.9375 | 43.9025 | 43.9025 | 6760.0 |
| 2018-01-17 07:50:00 | AAPL | Stock | 43.9125 | 43.9125 | 43.9 | 43.9025 | 10476.0 |
| 2018-01-17 07:55:00 | AAPL | Stock | 43.91 | 43.91 | 43.8875 | 43.905 | 11436.0 |
| 2018-01-17 08:00:00 | AAPL | Stock | 43.8775 | 44.0475 | 43.8775 | 43.9075 | 39224.0 |
| 2018-01-17 08:05:00 | AAPL | Stock | 43.9125 | 43.9375 | 43.9 | 43.9225 | 48268.0 |
| 2018-01-17 08:10:00 | AAPL | Stock | 43.905 | 43.9375 | 43.89 | 43.935 | 35056.0 |
| 2018-01-17 08:15:00 | AAPL | Stock | 43.935 | 43.935 | 43.8925 | 43.9025 | 13200.0 |
| 2018-01-17 08:20:00 | AAPL | Stock | 43.9025 | 43.9025 | 43.8575 | 43.8575 | 32684.0 |
| 2018-01-17 08:25:00 | AAPL | Stock | 43.855 | 43.855 | 43.83 | 43.85 | 28340.0 |
| 2018-01-17 08:30:00 | AAPL | Stock | 43.83 | 43.85 | 43.825 | 43.8375 | 22296.0 |
| 2018-01-17 08:35:00 | AAPL | Stock | 43.84 | 43.925 | 43.84 | 43.925 | 20036.0 |
> showing 50 of 370,913 rows — these rows as CSV