PREVIEW / stock_5min / 2014-09-03
file: by_date/stock_5min/2014/2014-09-03.parquet size: 5.4 MB rows: 359,257 symbols: 3,582
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 |
|---|---|---|---|---|---|---|---|
| 2014-09-03 04:00:00 | AAPL | Stock | 25.7475 | 25.9 | 25.7475 | 25.9 | 14124.0 |
| 2014-09-03 04:05:00 | AAPL | Stock | 25.905 | 25.905 | 25.9 | 25.9 | 4800.0 |
| 2014-09-03 04:10:00 | AAPL | Stock | 25.9125 | 25.9125 | 25.9125 | 25.9125 | 2400.0 |
| 2014-09-03 04:15:00 | AAPL | Stock | 25.9175 | 25.925 | 25.9175 | 25.9225 | 3800.0 |
| 2014-09-03 04:20:00 | AAPL | Stock | 25.925 | 25.9625 | 25.925 | 25.9625 | 21232.0 |
| 2014-09-03 04:25:00 | AAPL | Stock | 25.96 | 25.9725 | 25.96 | 25.9725 | 5400.0 |
| 2014-09-03 04:30:00 | AAPL | Stock | 25.9625 | 25.9725 | 25.9625 | 25.9725 | 7284.0 |
| 2014-09-03 04:35:00 | AAPL | Stock | 25.975 | 25.975 | 25.975 | 25.975 | 2000.0 |
| 2014-09-03 04:40:00 | AAPL | Stock | 25.975 | 25.975 | 25.95 | 25.975 | 25440.0 |
| 2014-09-03 04:45:00 | AAPL | Stock | 25.985 | 25.985 | 25.985 | 25.985 | 400.0 |
| 2014-09-03 04:50:00 | AAPL | Stock | 25.975 | 25.9925 | 25.975 | 25.975 | 8780.0 |
| 2014-09-03 04:55:00 | AAPL | Stock | 25.975 | 25.975 | 25.945 | 25.945 | 10884.0 |
| 2014-09-03 05:00:00 | AAPL | Stock | 25.9375 | 25.9375 | 25.9375 | 25.9375 | 3200.0 |
| 2014-09-03 05:05:00 | AAPL | Stock | 25.95 | 25.955 | 25.95 | 25.955 | 2864.0 |
| 2014-09-03 05:10:00 | AAPL | Stock | 25.96 | 25.96 | 25.955 | 25.955 | 1704.0 |
| 2014-09-03 05:15:00 | AAPL | Stock | 25.9475 | 25.9525 | 25.9475 | 25.9525 | 5112.0 |
| 2014-09-03 05:20:00 | AAPL | Stock | 25.9375 | 25.9375 | 25.9375 | 25.9375 | 4800.0 |
| 2014-09-03 05:25:00 | AAPL | Stock | 25.955 | 25.955 | 25.9275 | 25.93 | 7200.0 |
| 2014-09-03 05:30:00 | AAPL | Stock | 25.925 | 25.95 | 25.925 | 25.95 | 6000.0 |
| 2014-09-03 05:50:00 | AAPL | Stock | 25.95 | 25.95 | 25.95 | 25.95 | 800.0 |
| 2014-09-03 06:00:00 | AAPL | Stock | 25.9475 | 25.9475 | 25.94 | 25.94 | 10240.0 |
| 2014-09-03 06:05:00 | AAPL | Stock | 25.94 | 25.94 | 25.9275 | 25.9275 | 2940.0 |
| 2014-09-03 06:10:00 | AAPL | Stock | 25.94 | 25.94 | 25.9275 | 25.9275 | 4800.0 |
| 2014-09-03 06:15:00 | AAPL | Stock | 25.9375 | 25.9425 | 25.93 | 25.935 | 11112.0 |
| 2014-09-03 06:20:00 | AAPL | Stock | 25.93 | 25.93 | 25.93 | 25.93 | 7392.0 |
| 2014-09-03 06:25:00 | AAPL | Stock | 25.9475 | 25.9475 | 25.9475 | 25.9475 | 1440.0 |
| 2014-09-03 06:30:00 | AAPL | Stock | 25.9475 | 25.9475 | 25.9325 | 25.9325 | 8688.0 |
| 2014-09-03 06:35:00 | AAPL | Stock | 25.9425 | 25.9425 | 25.895 | 25.895 | 37920.0 |
| 2014-09-03 06:45:00 | AAPL | Stock | 25.9 | 25.9 | 25.875 | 25.875 | 48800.0 |
| 2014-09-03 06:55:00 | AAPL | Stock | 25.9025 | 25.9125 | 25.9025 | 25.9125 | 17424.0 |
| 2014-09-03 07:00:00 | AAPL | Stock | 25.9125 | 25.9125 | 25.895 | 25.895 | 12920.0 |
| 2014-09-03 07:05:00 | AAPL | Stock | 25.9 | 25.9 | 25.875 | 25.8875 | 15600.0 |
| 2014-09-03 07:10:00 | AAPL | Stock | 25.8775 | 25.8775 | 25.8425 | 25.85 | 40460.0 |
| 2014-09-03 07:15:00 | AAPL | Stock | 25.85 | 25.8675 | 25.85 | 25.8675 | 7160.0 |
| 2014-09-03 07:20:00 | AAPL | Stock | 25.87 | 25.875 | 25.8575 | 25.8575 | 20520.0 |
| 2014-09-03 07:25:00 | AAPL | Stock | 25.8625 | 25.8625 | 25.8625 | 25.8625 | 1220.0 |
| 2014-09-03 07:30:00 | AAPL | Stock | 25.855 | 25.8575 | 25.85 | 25.8575 | 9560.0 |
| 2014-09-03 07:35:00 | AAPL | Stock | 25.8575 | 25.8575 | 25.85 | 25.85 | 7520.0 |
| 2014-09-03 07:40:00 | AAPL | Stock | 25.85 | 25.85 | 25.83 | 25.83 | 29920.0 |
| 2014-09-03 07:45:00 | AAPL | Stock | 25.8275 | 25.8275 | 25.805 | 25.825 | 58360.0 |
| 2014-09-03 07:50:00 | AAPL | Stock | 25.825 | 25.83 | 25.815 | 25.815 | 29200.0 |
| 2014-09-03 07:55:00 | AAPL | Stock | 25.83 | 25.83 | 25.8175 | 25.8175 | 25164.0 |
| 2014-09-03 08:00:00 | AAPL | Stock | 25.825 | 25.9125 | 25.78 | 25.7875 | 334068.0 |
| 2014-09-03 08:05:00 | AAPL | Stock | 25.7875 | 25.7875 | 25.725 | 25.7475 | 183308.0 |
| 2014-09-03 08:10:00 | AAPL | Stock | 25.7475 | 25.7625 | 25.74 | 25.76 | 192320.0 |
| 2014-09-03 08:15:00 | AAPL | Stock | 25.76 | 25.785 | 25.755 | 25.775 | 127700.0 |
| 2014-09-03 08:20:00 | AAPL | Stock | 25.7725 | 25.7825 | 25.765 | 25.7725 | 69288.0 |
| 2014-09-03 08:25:00 | AAPL | Stock | 25.7725 | 25.7875 | 25.7625 | 25.7725 | 96276.0 |
| 2014-09-03 08:30:00 | AAPL | Stock | 25.7725 | 25.7825 | 25.7725 | 25.7825 | 57240.0 |
| 2014-09-03 08:35:00 | AAPL | Stock | 25.7825 | 25.7875 | 25.78 | 25.7825 | 105892.0 |
> showing 50 of 359,257 rows — these rows as CSV