PREVIEW / stock_5min / 2016-09-16
file: by_date/stock_5min/2016/2016-09-16.parquet size: 5.3 MB rows: 353,963 symbols: 3,231
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-09-16 04:00:00 | AAPL | Stock | 28.8325 | 28.8325 | 28.7575 | 28.7625 | 2800.0 |
| 2016-09-16 04:05:00 | AAPL | Stock | 28.8 | 28.8125 | 28.7875 | 28.8125 | 1200.0 |
| 2016-09-16 04:10:00 | AAPL | Stock | 28.815 | 28.815 | 28.815 | 28.815 | 684.0 |
| 2016-09-16 04:15:00 | AAPL | Stock | 28.83 | 28.83 | 28.83 | 28.83 | 800.0 |
| 2016-09-16 04:20:00 | AAPL | Stock | 28.8375 | 28.8375 | 28.825 | 28.825 | 2000.0 |
| 2016-09-16 04:25:00 | AAPL | Stock | 28.7675 | 28.7675 | 28.765 | 28.765 | 2028.0 |
| 2016-09-16 04:30:00 | AAPL | Stock | 28.765 | 28.765 | 28.765 | 28.765 | 3172.0 |
| 2016-09-16 04:35:00 | AAPL | Stock | 28.8125 | 28.8125 | 28.8125 | 28.8125 | 4208.0 |
| 2016-09-16 05:00:00 | AAPL | Stock | 28.7675 | 28.7675 | 28.7675 | 28.7675 | 1120.0 |
| 2016-09-16 05:05:00 | AAPL | Stock | 28.7975 | 28.7975 | 28.7975 | 28.7975 | 400.0 |
| 2016-09-16 05:10:00 | AAPL | Stock | 28.795 | 28.795 | 28.795 | 28.795 | 1372.0 |
| 2016-09-16 05:15:00 | AAPL | Stock | 28.7975 | 28.8025 | 28.7975 | 28.8025 | 13516.0 |
| 2016-09-16 05:20:00 | AAPL | Stock | 28.8025 | 28.8025 | 28.8025 | 28.8025 | 10412.0 |
| 2016-09-16 05:25:00 | AAPL | Stock | 28.795 | 28.795 | 28.795 | 28.795 | 800.0 |
| 2016-09-16 05:30:00 | AAPL | Stock | 28.7975 | 28.7975 | 28.7925 | 28.7975 | 14400.0 |
| 2016-09-16 05:35:00 | AAPL | Stock | 28.8 | 28.8 | 28.7925 | 28.7925 | 6000.0 |
| 2016-09-16 05:40:00 | AAPL | Stock | 28.795 | 28.795 | 28.795 | 28.795 | 2000.0 |
| 2016-09-16 05:55:00 | AAPL | Stock | 28.8 | 28.8 | 28.8 | 28.8 | 1836.0 |
| 2016-09-16 06:00:00 | AAPL | Stock | 28.8125 | 28.8625 | 28.8025 | 28.8625 | 22992.0 |
| 2016-09-16 06:05:00 | AAPL | Stock | 28.86 | 28.8725 | 28.8475 | 28.8725 | 14076.0 |
| 2016-09-16 06:10:00 | AAPL | Stock | 28.8425 | 28.875 | 28.84 | 28.875 | 3800.0 |
| 2016-09-16 06:15:00 | AAPL | Stock | 28.8875 | 28.945 | 28.8875 | 28.945 | 23332.0 |
| 2016-09-16 06:20:00 | AAPL | Stock | 28.945 | 28.945 | 28.925 | 28.925 | 33708.0 |
| 2016-09-16 06:25:00 | AAPL | Stock | 28.8575 | 28.8575 | 28.8375 | 28.8475 | 12400.0 |
| 2016-09-16 06:35:00 | AAPL | Stock | 28.875 | 28.875 | 28.8625 | 28.8625 | 4400.0 |
| 2016-09-16 06:40:00 | AAPL | Stock | 28.875 | 28.875 | 28.875 | 28.875 | 400.0 |
| 2016-09-16 06:45:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.84 | 28.84 | 3988.0 |
| 2016-09-16 06:50:00 | AAPL | Stock | 28.8425 | 28.8425 | 28.8425 | 28.8425 | 8000.0 |
| 2016-09-16 06:55:00 | AAPL | Stock | 28.8425 | 28.8425 | 28.8425 | 28.8425 | 400.0 |
| 2016-09-16 07:00:00 | AAPL | Stock | 28.8925 | 28.9 | 28.87 | 28.9 | 22164.0 |
| 2016-09-16 07:05:00 | AAPL | Stock | 28.925 | 28.99 | 28.9 | 28.975 | 67564.0 |
| 2016-09-16 07:10:00 | AAPL | Stock | 28.975 | 28.9875 | 28.9375 | 28.9375 | 13588.0 |
| 2016-09-16 07:15:00 | AAPL | Stock | 28.905 | 28.905 | 28.8325 | 28.85 | 42820.0 |
| 2016-09-16 07:20:00 | AAPL | Stock | 28.835 | 28.8575 | 28.825 | 28.8525 | 34300.0 |
| 2016-09-16 07:25:00 | AAPL | Stock | 28.875 | 28.8875 | 28.8375 | 28.8675 | 25100.0 |
| 2016-09-16 07:30:00 | AAPL | Stock | 28.8625 | 28.8875 | 28.8625 | 28.8875 | 21804.0 |
| 2016-09-16 07:35:00 | AAPL | Stock | 28.8825 | 28.885 | 28.8625 | 28.865 | 33936.0 |
| 2016-09-16 07:40:00 | AAPL | Stock | 28.8525 | 28.8525 | 28.7875 | 28.8 | 57076.0 |
| 2016-09-16 07:45:00 | AAPL | Stock | 28.81 | 28.81 | 28.775 | 28.7825 | 28968.0 |
| 2016-09-16 07:50:00 | AAPL | Stock | 28.775 | 28.7975 | 28.7325 | 28.74 | 68876.0 |
| 2016-09-16 07:55:00 | AAPL | Stock | 28.735 | 28.7375 | 28.6875 | 28.7375 | 81932.0 |
| 2016-09-16 08:00:00 | AAPL | Stock | 28.8875 | 28.9875 | 28.6875 | 28.745 | 329460.0 |
| 2016-09-16 08:05:00 | AAPL | Stock | 28.745 | 28.775 | 28.7275 | 28.775 | 209984.0 |
| 2016-09-16 08:10:00 | AAPL | Stock | 28.785 | 28.785 | 28.75 | 28.755 | 63048.0 |
| 2016-09-16 08:15:00 | AAPL | Stock | 28.75 | 28.8 | 28.75 | 28.7975 | 85828.0 |
| 2016-09-16 08:20:00 | AAPL | Stock | 28.8025 | 28.8075 | 28.75 | 28.7525 | 117840.0 |
| 2016-09-16 08:25:00 | AAPL | Stock | 28.7525 | 28.775 | 28.75 | 28.775 | 40060.0 |
| 2016-09-16 08:30:00 | AAPL | Stock | 28.7675 | 28.8 | 28.73 | 28.73 | 169312.0 |
| 2016-09-16 08:35:00 | AAPL | Stock | 28.735 | 28.77 | 28.73 | 28.765 | 79720.0 |
| 2016-09-16 08:40:00 | AAPL | Stock | 28.76 | 28.7825 | 28.76 | 28.7725 | 34840.0 |
> showing 50 of 353,963 rows — these rows as CSV