PREVIEW / stock_5min / 2014-10-16
file: by_date/stock_5min/2014/2014-10-16.parquet size: 5.8 MB rows: 378,818 symbols: 3,562
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-10-16 04:05:00 | AAPL | Stock | 24.2525 | 24.2525 | 24.2125 | 24.2125 | 11120.0 |
| 2014-10-16 04:10:00 | AAPL | Stock | 24.2475 | 24.25 | 24.1525 | 24.1525 | 11984.0 |
| 2014-10-16 04:20:00 | AAPL | Stock | 24.21 | 24.21 | 24.21 | 24.21 | 400.0 |
| 2014-10-16 04:30:00 | AAPL | Stock | 24.1875 | 24.19 | 24.1875 | 24.19 | 2248.0 |
| 2014-10-16 04:55:00 | AAPL | Stock | 24.2 | 24.2 | 24.2 | 24.2 | 1120.0 |
| 2014-10-16 05:05:00 | AAPL | Stock | 24.21 | 24.21 | 24.21 | 24.21 | 400.0 |
| 2014-10-16 05:10:00 | AAPL | Stock | 24.1675 | 24.1675 | 24.165 | 24.165 | 3068.0 |
| 2014-10-16 05:15:00 | AAPL | Stock | 24.1525 | 24.1525 | 24.1525 | 24.1525 | 412.0 |
| 2014-10-16 05:25:00 | AAPL | Stock | 24.1525 | 24.1525 | 24.105 | 24.105 | 5200.0 |
| 2014-10-16 05:30:00 | AAPL | Stock | 24.105 | 24.105 | 24.04 | 24.04 | 6800.0 |
| 2014-10-16 05:35:00 | AAPL | Stock | 24.0825 | 24.0825 | 23.9925 | 24.0275 | 41040.0 |
| 2014-10-16 05:40:00 | AAPL | Stock | 24.0 | 24.0425 | 23.94 | 23.94 | 7668.0 |
| 2014-10-16 05:45:00 | AAPL | Stock | 23.9475 | 24.02 | 23.94 | 23.94 | 17820.0 |
| 2014-10-16 05:50:00 | AAPL | Stock | 23.95 | 24.0 | 23.95 | 23.955 | 8216.0 |
| 2014-10-16 05:55:00 | AAPL | Stock | 23.97 | 23.9725 | 23.875 | 23.9025 | 24420.0 |
| 2014-10-16 06:00:00 | AAPL | Stock | 24.0 | 24.0 | 23.8925 | 23.91 | 24652.0 |
| 2014-10-16 06:05:00 | AAPL | Stock | 23.8575 | 23.8575 | 23.725 | 23.8125 | 15480.0 |
| 2014-10-16 06:10:00 | AAPL | Stock | 23.755 | 23.755 | 23.45 | 23.4525 | 126156.0 |
| 2014-10-16 06:15:00 | AAPL | Stock | 23.51 | 23.5875 | 23.4375 | 23.5875 | 65392.0 |
| 2014-10-16 06:20:00 | AAPL | Stock | 23.5975 | 23.7225 | 23.55 | 23.6625 | 66880.0 |
| 2014-10-16 06:25:00 | AAPL | Stock | 23.6625 | 23.75 | 23.65 | 23.75 | 131424.0 |
| 2014-10-16 06:30:00 | AAPL | Stock | 23.825 | 23.825 | 23.7 | 23.825 | 36444.0 |
| 2014-10-16 06:35:00 | AAPL | Stock | 23.7525 | 23.7525 | 23.7 | 23.7025 | 18928.0 |
| 2014-10-16 06:40:00 | AAPL | Stock | 23.7025 | 23.7025 | 23.665 | 23.6925 | 38096.0 |
| 2014-10-16 06:45:00 | AAPL | Stock | 23.7475 | 23.84 | 23.7375 | 23.8175 | 83788.0 |
| 2014-10-16 06:50:00 | AAPL | Stock | 23.83 | 23.8475 | 23.75 | 23.775 | 25240.0 |
| 2014-10-16 06:55:00 | AAPL | Stock | 23.705 | 23.775 | 23.7 | 23.7125 | 6040.0 |
| 2014-10-16 07:00:00 | AAPL | Stock | 23.75 | 23.7625 | 23.725 | 23.7375 | 93620.0 |
| 2014-10-16 07:05:00 | AAPL | Stock | 23.7375 | 23.8 | 23.725 | 23.775 | 85228.0 |
| 2014-10-16 07:10:00 | AAPL | Stock | 23.7875 | 23.85 | 23.785 | 23.8475 | 100424.0 |
| 2014-10-16 07:15:00 | AAPL | Stock | 23.85 | 23.9125 | 23.8275 | 23.8975 | 120416.0 |
| 2014-10-16 07:20:00 | AAPL | Stock | 23.8975 | 23.9375 | 23.8975 | 23.925 | 71372.0 |
| 2014-10-16 07:25:00 | AAPL | Stock | 23.925 | 23.9625 | 23.9125 | 23.95 | 81220.0 |
| 2014-10-16 07:30:00 | AAPL | Stock | 23.95 | 23.955 | 23.9375 | 23.9375 | 40236.0 |
| 2014-10-16 07:35:00 | AAPL | Stock | 23.92 | 23.9625 | 23.91 | 23.9625 | 55808.0 |
| 2014-10-16 07:40:00 | AAPL | Stock | 23.9625 | 24.0225 | 23.9375 | 23.9975 | 53612.0 |
| 2014-10-16 07:45:00 | AAPL | Stock | 23.9975 | 24.0225 | 23.8575 | 23.89 | 59960.0 |
| 2014-10-16 07:50:00 | AAPL | Stock | 23.9075 | 23.925 | 23.8775 | 23.9025 | 61664.0 |
| 2014-10-16 07:55:00 | AAPL | Stock | 23.9075 | 23.925 | 23.9 | 23.925 | 71080.0 |
| 2014-10-16 08:00:00 | AAPL | Stock | 23.92 | 24.0325 | 23.7375 | 24.015 | 320500.0 |
| 2014-10-16 08:05:00 | AAPL | Stock | 24.015 | 24.04 | 23.975 | 24.0 | 177400.0 |
| 2014-10-16 08:10:00 | AAPL | Stock | 24.0 | 24.0 | 23.9525 | 23.975 | 111016.0 |
| 2014-10-16 08:15:00 | AAPL | Stock | 23.975 | 24.0075 | 23.975 | 23.975 | 101788.0 |
| 2014-10-16 08:20:00 | AAPL | Stock | 23.9775 | 24.0 | 23.95 | 23.95 | 84104.0 |
| 2014-10-16 08:25:00 | AAPL | Stock | 23.95 | 23.9575 | 23.9 | 23.9025 | 97824.0 |
| 2014-10-16 08:30:00 | AAPL | Stock | 23.915 | 23.955 | 23.8875 | 23.915 | 221036.0 |
| 2014-10-16 08:35:00 | AAPL | Stock | 23.9125 | 23.9125 | 23.825 | 23.87 | 237684.0 |
| 2014-10-16 08:40:00 | AAPL | Stock | 23.87 | 23.92 | 23.865 | 23.92 | 264452.0 |
| 2014-10-16 08:45:00 | AAPL | Stock | 23.91 | 23.94 | 23.8975 | 23.9075 | 227052.0 |
| 2014-10-16 08:50:00 | AAPL | Stock | 23.905 | 23.92 | 23.8875 | 23.9025 | 150776.0 |
> showing 50 of 378,818 rows — these rows as CSV