PREVIEW / stock_5min / 2016-01-22
file: by_date/stock_5min/2016/2016-01-22.parquet size: 5.5 MB rows: 371,121 symbols: 3,401
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-01-22 04:00:00 | AAPL | Stock | 24.44 | 24.44 | 24.44 | 24.44 | 500.0 |
| 2016-01-22 04:05:00 | AAPL | Stock | 24.525 | 24.595 | 24.525 | 24.5625 | 10424.0 |
| 2016-01-22 04:10:00 | AAPL | Stock | 24.565 | 24.575 | 24.565 | 24.57 | 2300.0 |
| 2016-01-22 04:15:00 | AAPL | Stock | 24.5 | 24.5 | 24.5 | 24.5 | 3600.0 |
| 2016-01-22 04:20:00 | AAPL | Stock | 24.5275 | 24.5275 | 24.4825 | 24.52 | 4916.0 |
| 2016-01-22 04:25:00 | AAPL | Stock | 24.5375 | 24.5375 | 24.5375 | 24.5375 | 400.0 |
| 2016-01-22 05:00:00 | AAPL | Stock | 24.4375 | 24.4375 | 24.425 | 24.425 | 3600.0 |
| 2016-01-22 05:40:00 | AAPL | Stock | 24.5 | 24.5 | 24.5 | 24.5 | 800.0 |
| 2016-01-22 05:45:00 | AAPL | Stock | 24.5125 | 24.5125 | 24.5125 | 24.5125 | 400.0 |
| 2016-01-22 05:50:00 | AAPL | Stock | 24.4675 | 24.4675 | 24.4475 | 24.4475 | 1648.0 |
| 2016-01-22 05:55:00 | AAPL | Stock | 24.4825 | 24.4825 | 24.4825 | 24.4825 | 400.0 |
| 2016-01-22 06:00:00 | AAPL | Stock | 24.45 | 24.45 | 24.38 | 24.425 | 23780.0 |
| 2016-01-22 06:10:00 | AAPL | Stock | 24.47 | 24.475 | 24.47 | 24.475 | 1608.0 |
| 2016-01-22 06:15:00 | AAPL | Stock | 24.4975 | 24.4975 | 24.4625 | 24.4625 | 6392.0 |
| 2016-01-22 06:20:00 | AAPL | Stock | 24.4625 | 24.4725 | 24.45 | 24.45 | 2800.0 |
| 2016-01-22 06:25:00 | AAPL | Stock | 24.495 | 24.5 | 24.4775 | 24.5 | 21212.0 |
| 2016-01-22 06:30:00 | AAPL | Stock | 24.5 | 24.5625 | 24.5 | 24.515 | 27200.0 |
| 2016-01-22 06:35:00 | AAPL | Stock | 24.515 | 24.535 | 24.515 | 24.515 | 1200.0 |
| 2016-01-22 06:40:00 | AAPL | Stock | 24.5075 | 24.5075 | 24.5025 | 24.505 | 1532.0 |
| 2016-01-22 06:50:00 | AAPL | Stock | 24.5325 | 24.5375 | 24.5325 | 24.5375 | 2000.0 |
| 2016-01-22 06:55:00 | AAPL | Stock | 24.535 | 24.535 | 24.5125 | 24.5125 | 4208.0 |
| 2016-01-22 07:00:00 | AAPL | Stock | 24.5325 | 24.54 | 24.5 | 24.5 | 52692.0 |
| 2016-01-22 07:05:00 | AAPL | Stock | 24.4975 | 24.5 | 24.4725 | 24.49 | 13884.0 |
| 2016-01-22 07:10:00 | AAPL | Stock | 24.4825 | 24.5125 | 24.4825 | 24.5125 | 47680.0 |
| 2016-01-22 07:15:00 | AAPL | Stock | 24.4875 | 24.5025 | 24.4875 | 24.5025 | 5280.0 |
| 2016-01-22 07:20:00 | AAPL | Stock | 24.5125 | 24.5325 | 24.5125 | 24.525 | 8300.0 |
| 2016-01-22 07:25:00 | AAPL | Stock | 24.53 | 24.5375 | 24.5 | 24.5125 | 82004.0 |
| 2016-01-22 07:30:00 | AAPL | Stock | 24.5375 | 24.5775 | 24.525 | 24.5775 | 59504.0 |
| 2016-01-22 07:35:00 | AAPL | Stock | 24.575 | 24.575 | 24.5625 | 24.575 | 25808.0 |
| 2016-01-22 07:40:00 | AAPL | Stock | 24.575 | 24.5875 | 24.5675 | 24.5875 | 4800.0 |
| 2016-01-22 07:45:00 | AAPL | Stock | 24.5875 | 24.6 | 24.5875 | 24.6 | 9400.0 |
| 2016-01-22 07:50:00 | AAPL | Stock | 24.6 | 24.6 | 24.59 | 24.6 | 20464.0 |
| 2016-01-22 07:55:00 | AAPL | Stock | 24.6 | 24.6 | 24.59 | 24.595 | 12680.0 |
| 2016-01-22 08:00:00 | AAPL | Stock | 24.58 | 24.61 | 24.4875 | 24.61 | 232600.0 |
| 2016-01-22 08:05:00 | AAPL | Stock | 24.56 | 24.575 | 24.5575 | 24.5625 | 37172.0 |
| 2016-01-22 08:10:00 | AAPL | Stock | 24.5625 | 24.5625 | 24.5 | 24.5125 | 75268.0 |
| 2016-01-22 08:15:00 | AAPL | Stock | 24.525 | 24.59 | 24.525 | 24.5875 | 66376.0 |
| 2016-01-22 08:20:00 | AAPL | Stock | 24.57 | 24.59 | 24.5625 | 24.575 | 44036.0 |
| 2016-01-22 08:25:00 | AAPL | Stock | 24.5675 | 24.575 | 24.55 | 24.575 | 25496.0 |
| 2016-01-22 08:30:00 | AAPL | Stock | 24.575 | 24.5875 | 24.575 | 24.5875 | 44696.0 |
| 2016-01-22 08:35:00 | AAPL | Stock | 24.5825 | 24.6075 | 24.575 | 24.605 | 82088.0 |
| 2016-01-22 08:40:00 | AAPL | Stock | 24.6025 | 24.62 | 24.6025 | 24.6075 | 35388.0 |
| 2016-01-22 08:45:00 | AAPL | Stock | 24.615 | 24.615 | 24.59 | 24.6 | 32100.0 |
| 2016-01-22 08:50:00 | AAPL | Stock | 24.6 | 24.61 | 24.5275 | 24.5475 | 85768.0 |
| 2016-01-22 08:55:00 | AAPL | Stock | 24.5475 | 24.5475 | 24.5125 | 24.5225 | 55572.0 |
| 2016-01-22 09:00:00 | AAPL | Stock | 24.5225 | 24.55 | 24.5225 | 24.5425 | 48856.0 |
| 2016-01-22 09:05:00 | AAPL | Stock | 24.535 | 24.55 | 24.5 | 24.505 | 80196.0 |
| 2016-01-22 09:10:00 | AAPL | Stock | 24.5 | 24.55 | 24.4925 | 24.5275 | 84384.0 |
| 2016-01-22 09:15:00 | AAPL | Stock | 24.54 | 24.55 | 24.525 | 24.55 | 32676.0 |
| 2016-01-22 09:20:00 | AAPL | Stock | 24.55 | 24.62 | 24.55 | 24.615 | 92688.0 |
> showing 50 of 371,121 rows — these rows as CSV