PREVIEW / stock_5min / 2015-02-18
file: by_date/stock_5min/2015/2015-02-18.parquet size: 5.5 MB rows: 359,704 symbols: 3,527
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 |
|---|---|---|---|---|---|---|---|
| 2015-02-18 04:00:00 | AAPL | Stock | 32.1125 | 32.1125 | 32.0375 | 32.0375 | 14120.0 |
| 2015-02-18 04:05:00 | AAPL | Stock | 32.05 | 32.08 | 32.05 | 32.08 | 3200.0 |
| 2015-02-18 04:10:00 | AAPL | Stock | 32.05 | 32.05 | 32.05 | 32.05 | 400.0 |
| 2015-02-18 04:20:00 | AAPL | Stock | 32.0625 | 32.08 | 32.0625 | 32.08 | 3040.0 |
| 2015-02-18 04:30:00 | AAPL | Stock | 32.08 | 32.08 | 32.075 | 32.075 | 5920.0 |
| 2015-02-18 04:35:00 | AAPL | Stock | 32.075 | 32.075 | 32.0625 | 32.075 | 5560.0 |
| 2015-02-18 04:40:00 | AAPL | Stock | 32.0625 | 32.0625 | 32.05 | 32.05 | 10000.0 |
| 2015-02-18 04:50:00 | AAPL | Stock | 32.0525 | 32.07 | 32.05 | 32.05 | 4800.0 |
| 2015-02-18 04:55:00 | AAPL | Stock | 32.065 | 32.08 | 32.065 | 32.08 | 8176.0 |
| 2015-02-18 05:00:00 | AAPL | Stock | 32.0825 | 32.0875 | 32.0825 | 32.0875 | 7148.0 |
| 2015-02-18 05:10:00 | AAPL | Stock | 32.0875 | 32.09 | 32.0875 | 32.09 | 2880.0 |
| 2015-02-18 05:15:00 | AAPL | Stock | 32.09 | 32.09 | 32.075 | 32.075 | 7280.0 |
| 2015-02-18 05:20:00 | AAPL | Stock | 32.075 | 32.0875 | 32.075 | 32.0775 | 2720.0 |
| 2015-02-18 05:30:00 | AAPL | Stock | 32.0875 | 32.0875 | 32.0875 | 32.0875 | 600.0 |
| 2015-02-18 05:35:00 | AAPL | Stock | 32.1025 | 32.1025 | 32.0875 | 32.0875 | 4316.0 |
| 2015-02-18 05:40:00 | AAPL | Stock | 32.105 | 32.125 | 32.075 | 32.1175 | 25740.0 |
| 2015-02-18 05:45:00 | AAPL | Stock | 32.125 | 32.13 | 32.125 | 32.13 | 5576.0 |
| 2015-02-18 06:00:00 | AAPL | Stock | 32.075 | 32.075 | 32.0275 | 32.0275 | 4896.0 |
| 2015-02-18 06:05:00 | AAPL | Stock | 32.0725 | 32.075 | 32.0725 | 32.075 | 4000.0 |
| 2015-02-18 06:15:00 | AAPL | Stock | 32.0425 | 32.0425 | 32.0425 | 32.0425 | 2000.0 |
| 2015-02-18 06:20:00 | AAPL | Stock | 32.0625 | 32.0625 | 32.005 | 32.005 | 21156.0 |
| 2015-02-18 06:25:00 | AAPL | Stock | 32.0025 | 32.005 | 32.0025 | 32.005 | 30000.0 |
| 2015-02-18 06:30:00 | AAPL | Stock | 32.0225 | 32.0225 | 32.0225 | 32.0225 | 1872.0 |
| 2015-02-18 06:55:00 | AAPL | Stock | 31.98 | 31.995 | 31.98 | 31.98 | 4800.0 |
| 2015-02-18 07:00:00 | AAPL | Stock | 31.98 | 31.9925 | 31.975 | 31.9825 | 14020.0 |
| 2015-02-18 07:05:00 | AAPL | Stock | 31.9825 | 31.9825 | 31.9825 | 31.9825 | 3880.0 |
| 2015-02-18 07:10:00 | AAPL | Stock | 32.0 | 32.0125 | 31.9875 | 32.0125 | 26468.0 |
| 2015-02-18 07:15:00 | AAPL | Stock | 32.01 | 32.0375 | 32.01 | 32.035 | 10100.0 |
| 2015-02-18 07:20:00 | AAPL | Stock | 32.025 | 32.0325 | 32.025 | 32.0325 | 2400.0 |
| 2015-02-18 07:25:00 | AAPL | Stock | 32.02 | 32.02 | 32.0 | 32.0 | 31908.0 |
| 2015-02-18 07:30:00 | AAPL | Stock | 32.0 | 32.015 | 31.9875 | 31.9875 | 19544.0 |
| 2015-02-18 07:35:00 | AAPL | Stock | 31.9875 | 32.015 | 31.9875 | 31.9925 | 5600.0 |
| 2015-02-18 07:40:00 | AAPL | Stock | 31.9925 | 32.0 | 31.9875 | 31.9925 | 22400.0 |
| 2015-02-18 07:45:00 | AAPL | Stock | 31.9875 | 31.995 | 31.9875 | 31.9875 | 8200.0 |
| 2015-02-18 07:50:00 | AAPL | Stock | 31.9625 | 31.9875 | 31.9625 | 31.9875 | 10076.0 |
| 2015-02-18 07:55:00 | AAPL | Stock | 31.9875 | 31.9975 | 31.985 | 31.9875 | 4280.0 |
| 2015-02-18 08:00:00 | AAPL | Stock | 31.99 | 32.03 | 31.85 | 31.98 | 174200.0 |
| 2015-02-18 08:05:00 | AAPL | Stock | 31.98 | 31.9825 | 31.915 | 31.92 | 88356.0 |
| 2015-02-18 08:10:00 | AAPL | Stock | 31.92 | 31.9425 | 31.92 | 31.935 | 29816.0 |
| 2015-02-18 08:15:00 | AAPL | Stock | 31.9475 | 31.965 | 31.9375 | 31.95 | 13000.0 |
| 2015-02-18 08:20:00 | AAPL | Stock | 31.95 | 31.95 | 31.8875 | 31.9125 | 131564.0 |
| 2015-02-18 08:25:00 | AAPL | Stock | 31.9375 | 31.9475 | 31.8625 | 31.92 | 116932.0 |
| 2015-02-18 08:30:00 | AAPL | Stock | 31.905 | 31.91 | 31.865 | 31.865 | 76508.0 |
| 2015-02-18 08:35:00 | AAPL | Stock | 31.875 | 31.875 | 31.8575 | 31.8575 | 62980.0 |
| 2015-02-18 08:40:00 | AAPL | Stock | 31.8575 | 31.8675 | 31.85 | 31.85 | 141316.0 |
| 2015-02-18 08:45:00 | AAPL | Stock | 31.84 | 31.8625 | 31.84 | 31.8625 | 57920.0 |
| 2015-02-18 08:50:00 | AAPL | Stock | 31.8625 | 31.8775 | 31.8622 | 31.8675 | 90616.0 |
| 2015-02-18 08:55:00 | AAPL | Stock | 31.8675 | 31.8875 | 31.8675 | 31.8875 | 11424.0 |
| 2015-02-18 09:00:00 | AAPL | Stock | 31.8875 | 31.8925 | 31.8775 | 31.8825 | 22204.0 |
| 2015-02-18 09:05:00 | AAPL | Stock | 31.8825 | 31.8925 | 31.88 | 31.8925 | 34880.0 |
> showing 50 of 359,704 rows — these rows as CSV