PREVIEW / stock_5min / 2015-10-14
file: by_date/stock_5min/2015/2015-10-14.parquet size: 5.2 MB rows: 346,450 symbols: 3,395
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-10-14 04:00:00 | AAPL | Stock | 27.9525 | 27.9525 | 27.8225 | 27.8225 | 800.0 |
| 2015-10-14 05:55:00 | AAPL | Stock | 27.8225 | 27.8225 | 27.8225 | 27.8225 | 400.0 |
| 2015-10-14 06:00:00 | AAPL | Stock | 27.825 | 27.825 | 27.825 | 27.825 | 400.0 |
| 2015-10-14 06:10:00 | AAPL | Stock | 27.8375 | 27.8375 | 27.825 | 27.825 | 50128.0 |
| 2015-10-14 06:15:00 | AAPL | Stock | 27.8125 | 27.8225 | 27.775 | 27.8225 | 2800.0 |
| 2015-10-14 06:25:00 | AAPL | Stock | 27.8 | 27.8 | 27.7575 | 27.775 | 8000.0 |
| 2015-10-14 06:30:00 | AAPL | Stock | 27.775 | 27.775 | 27.75 | 27.75 | 147176.0 |
| 2015-10-14 06:35:00 | AAPL | Stock | 27.8125 | 27.8125 | 27.8125 | 27.8125 | 1532.0 |
| 2015-10-14 06:40:00 | AAPL | Stock | 27.8125 | 27.8125 | 27.8125 | 27.8125 | 400.0 |
| 2015-10-14 07:10:00 | AAPL | Stock | 27.795 | 27.795 | 27.775 | 27.775 | 4000.0 |
| 2015-10-14 07:15:00 | AAPL | Stock | 27.775 | 27.7825 | 27.7675 | 27.7825 | 3600.0 |
| 2015-10-14 07:20:00 | AAPL | Stock | 27.7825 | 27.8 | 27.7825 | 27.8 | 4400.0 |
| 2015-10-14 07:25:00 | AAPL | Stock | 27.79 | 27.7925 | 27.7875 | 27.7875 | 5200.0 |
| 2015-10-14 07:30:00 | AAPL | Stock | 27.79 | 27.7925 | 27.7625 | 27.7725 | 18912.0 |
| 2015-10-14 07:35:00 | AAPL | Stock | 27.7825 | 27.7825 | 27.7525 | 27.7525 | 12724.0 |
| 2015-10-14 07:40:00 | AAPL | Stock | 27.7675 | 27.78 | 27.7675 | 27.775 | 24080.0 |
| 2015-10-14 07:45:00 | AAPL | Stock | 27.775 | 27.775 | 27.7025 | 27.72 | 79756.0 |
| 2015-10-14 07:50:00 | AAPL | Stock | 27.735 | 27.75 | 27.735 | 27.735 | 87688.0 |
| 2015-10-14 07:55:00 | AAPL | Stock | 27.7325 | 27.765 | 27.7125 | 27.765 | 40092.0 |
| 2015-10-14 08:00:00 | AAPL | Stock | 27.8425 | 27.8425 | 27.755 | 27.78 | 80660.0 |
| 2015-10-14 08:05:00 | AAPL | Stock | 27.775 | 27.78 | 27.7575 | 27.7775 | 38840.0 |
| 2015-10-14 08:10:00 | AAPL | Stock | 27.7825 | 27.795 | 27.7725 | 27.7725 | 47360.0 |
| 2015-10-14 08:15:00 | AAPL | Stock | 27.775 | 27.7925 | 27.775 | 27.7875 | 30400.0 |
| 2015-10-14 08:20:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.77 | 27.77 | 18800.0 |
| 2015-10-14 08:25:00 | AAPL | Stock | 27.7675 | 27.7875 | 27.7575 | 27.785 | 50508.0 |
| 2015-10-14 08:30:00 | AAPL | Stock | 27.785 | 27.7875 | 27.7675 | 27.785 | 91136.0 |
| 2015-10-14 08:35:00 | AAPL | Stock | 27.785 | 27.785 | 27.725 | 27.725 | 104592.0 |
| 2015-10-14 08:40:00 | AAPL | Stock | 27.735 | 27.75 | 27.73 | 27.7425 | 29248.0 |
| 2015-10-14 08:45:00 | AAPL | Stock | 27.75 | 27.7525 | 27.75 | 27.75 | 14048.0 |
| 2015-10-14 08:50:00 | AAPL | Stock | 27.75 | 27.775 | 27.745 | 27.755 | 97796.0 |
| 2015-10-14 08:55:00 | AAPL | Stock | 27.76 | 27.775 | 27.755 | 27.775 | 20400.0 |
| 2015-10-14 09:00:00 | AAPL | Stock | 27.7625 | 27.77 | 27.7625 | 27.7625 | 2000.0 |
| 2015-10-14 09:05:00 | AAPL | Stock | 27.7675 | 27.7875 | 27.7675 | 27.7825 | 46340.0 |
| 2015-10-14 09:10:00 | AAPL | Stock | 27.785 | 27.8 | 27.77 | 27.77 | 170320.0 |
| 2015-10-14 09:15:00 | AAPL | Stock | 27.7725 | 27.7725 | 27.75 | 27.755 | 46928.0 |
| 2015-10-14 09:20:00 | AAPL | Stock | 27.7625 | 27.7775 | 27.7575 | 27.7675 | 36760.0 |
| 2015-10-14 09:25:00 | AAPL | Stock | 27.7825 | 27.825 | 27.75 | 27.825 | 165664.0 |
| 2015-10-14 09:30:00 | AAPL | Stock | 27.8225 | 27.88 | 27.7725 | 27.7812 | 4556992.0 |
| 2015-10-14 09:35:00 | AAPL | Stock | 27.7812 | 27.8325 | 27.745 | 27.8275 | 4343576.0 |
| 2015-10-14 09:40:00 | AAPL | Stock | 27.8275 | 27.87 | 27.805 | 27.84 | 2808724.0 |
| 2015-10-14 09:45:00 | AAPL | Stock | 27.84 | 27.8588 | 27.7775 | 27.785 | 2446460.0 |
| 2015-10-14 09:50:00 | AAPL | Stock | 27.7825 | 27.785 | 27.705 | 27.7375 | 4334060.0 |
| 2015-10-14 09:55:00 | AAPL | Stock | 27.7375 | 27.7475 | 27.6925 | 27.695 | 2426004.0 |
| 2015-10-14 10:00:00 | AAPL | Stock | 27.6975 | 27.705 | 27.61 | 27.6225 | 4481936.0 |
| 2015-10-14 10:05:00 | AAPL | Stock | 27.6212 | 27.64 | 27.555 | 27.585 | 3601172.0 |
| 2015-10-14 10:10:00 | AAPL | Stock | 27.5875 | 27.5975 | 27.5225 | 27.5388 | 3744068.0 |
| 2015-10-14 10:15:00 | AAPL | Stock | 27.5375 | 27.5472 | 27.5 | 27.5138 | 2953032.0 |
| 2015-10-14 10:20:00 | AAPL | Stock | 27.5125 | 27.515 | 27.44 | 27.4562 | 6033948.0 |
| 2015-10-14 10:25:00 | AAPL | Stock | 27.4575 | 27.5575 | 27.4525 | 27.5425 | 3750540.0 |
| 2015-10-14 10:30:00 | AAPL | Stock | 27.5422 | 27.5475 | 27.4468 | 27.4575 | 2889204.0 |
> showing 50 of 346,450 rows — these rows as CSV