PREVIEW / stock_5min / 2014-09-05
file: by_date/stock_5min/2014/2014-09-05.parquet size: 5.2 MB rows: 348,092 symbols: 3,585
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-05 04:00:00 | AAPL | Stock | 24.525 | 24.6125 | 24.525 | 24.6125 | 2400.0 |
| 2014-09-05 04:05:00 | AAPL | Stock | 24.61 | 24.61 | 24.59 | 24.59 | 3600.0 |
| 2014-09-05 04:10:00 | AAPL | Stock | 24.58 | 24.58 | 24.58 | 24.58 | 800.0 |
| 2014-09-05 04:15:00 | AAPL | Stock | 24.57 | 24.57 | 24.57 | 24.57 | 692.0 |
| 2014-09-05 04:20:00 | AAPL | Stock | 24.5475 | 24.5475 | 24.5475 | 24.5475 | 1200.0 |
| 2014-09-05 04:25:00 | AAPL | Stock | 24.5475 | 24.5475 | 24.5475 | 24.5475 | 400.0 |
| 2014-09-05 04:30:00 | AAPL | Stock | 24.5375 | 24.54 | 24.5375 | 24.54 | 4040.0 |
| 2014-09-05 04:35:00 | AAPL | Stock | 24.54 | 24.54 | 24.54 | 24.54 | 2800.0 |
| 2014-09-05 04:50:00 | AAPL | Stock | 24.53 | 24.53 | 24.5125 | 24.5125 | 2216.0 |
| 2014-09-05 04:55:00 | AAPL | Stock | 24.52 | 24.5325 | 24.52 | 24.5325 | 800.0 |
| 2014-09-05 05:00:00 | AAPL | Stock | 24.525 | 24.5325 | 24.525 | 24.5325 | 8668.0 |
| 2014-09-05 05:05:00 | AAPL | Stock | 24.535 | 24.535 | 24.5325 | 24.5325 | 8400.0 |
| 2014-09-05 05:10:00 | AAPL | Stock | 24.5375 | 24.5375 | 24.5325 | 24.5325 | 6000.0 |
| 2014-09-05 05:15:00 | AAPL | Stock | 24.5425 | 24.5725 | 24.5425 | 24.5725 | 3600.0 |
| 2014-09-05 05:25:00 | AAPL | Stock | 24.55 | 24.55 | 24.5475 | 24.55 | 2300.0 |
| 2014-09-05 05:35:00 | AAPL | Stock | 24.595 | 24.595 | 24.5475 | 24.5475 | 1300.0 |
| 2014-09-05 05:40:00 | AAPL | Stock | 24.5725 | 24.5725 | 24.5725 | 24.5725 | 400.0 |
| 2014-09-05 05:45:00 | AAPL | Stock | 24.5725 | 24.5725 | 24.5425 | 24.555 | 2800.0 |
| 2014-09-05 05:50:00 | AAPL | Stock | 24.5575 | 24.5575 | 24.5575 | 24.5575 | 400.0 |
| 2014-09-05 05:55:00 | AAPL | Stock | 24.5725 | 24.5925 | 24.54 | 24.54 | 6400.0 |
| 2014-09-05 06:00:00 | AAPL | Stock | 24.54 | 24.54 | 24.5225 | 24.5225 | 2000.0 |
| 2014-09-05 06:05:00 | AAPL | Stock | 24.5475 | 24.5475 | 24.5225 | 24.525 | 37920.0 |
| 2014-09-05 06:10:00 | AAPL | Stock | 24.52 | 24.525 | 24.515 | 24.525 | 4700.0 |
| 2014-09-05 06:15:00 | AAPL | Stock | 24.5275 | 24.5275 | 24.5275 | 24.5275 | 400.0 |
| 2014-09-05 06:20:00 | AAPL | Stock | 24.5275 | 24.53 | 24.5275 | 24.53 | 3484.0 |
| 2014-09-05 06:25:00 | AAPL | Stock | 24.535 | 24.535 | 24.5275 | 24.5275 | 2576.0 |
| 2014-09-05 06:30:00 | AAPL | Stock | 24.5425 | 24.555 | 24.5275 | 24.5275 | 3600.0 |
| 2014-09-05 06:35:00 | AAPL | Stock | 24.525 | 24.525 | 24.525 | 24.525 | 800.0 |
| 2014-09-05 06:40:00 | AAPL | Stock | 24.5425 | 24.545 | 24.525 | 24.525 | 2800.0 |
| 2014-09-05 06:45:00 | AAPL | Stock | 24.5325 | 24.5325 | 24.53 | 24.53 | 1736.0 |
| 2014-09-05 06:50:00 | AAPL | Stock | 24.525 | 24.525 | 24.5225 | 24.5225 | 800.0 |
| 2014-09-05 06:55:00 | AAPL | Stock | 24.5225 | 24.5225 | 24.5225 | 24.5225 | 800.0 |
| 2014-09-05 07:00:00 | AAPL | Stock | 24.5375 | 24.56 | 24.5375 | 24.54 | 13360.0 |
| 2014-09-05 07:05:00 | AAPL | Stock | 24.55 | 24.6 | 24.5475 | 24.595 | 30200.0 |
| 2014-09-05 07:10:00 | AAPL | Stock | 24.6 | 24.6 | 24.5925 | 24.6 | 34572.0 |
| 2014-09-05 07:15:00 | AAPL | Stock | 24.6125 | 24.6325 | 24.605 | 24.6325 | 24440.0 |
| 2014-09-05 07:20:00 | AAPL | Stock | 24.6325 | 24.6825 | 24.6325 | 24.6625 | 26016.0 |
| 2014-09-05 07:25:00 | AAPL | Stock | 24.6525 | 24.665 | 24.615 | 24.615 | 19316.0 |
| 2014-09-05 07:30:00 | AAPL | Stock | 24.62 | 24.645 | 24.615 | 24.645 | 17400.0 |
| 2014-09-05 07:35:00 | AAPL | Stock | 24.6475 | 24.66 | 24.645 | 24.645 | 38000.0 |
| 2014-09-05 07:40:00 | AAPL | Stock | 24.65 | 24.6825 | 24.6425 | 24.65 | 22800.0 |
| 2014-09-05 07:45:00 | AAPL | Stock | 24.64 | 24.65 | 24.6375 | 24.64 | 46296.0 |
| 2014-09-05 07:50:00 | AAPL | Stock | 24.6375 | 24.6775 | 24.6375 | 24.6525 | 37284.0 |
| 2014-09-05 07:55:00 | AAPL | Stock | 24.6525 | 24.6625 | 24.65 | 24.6575 | 24924.0 |
| 2014-09-05 08:00:00 | AAPL | Stock | 24.655 | 24.7075 | 24.53 | 24.7 | 235956.0 |
| 2014-09-05 08:05:00 | AAPL | Stock | 24.7075 | 24.725 | 24.7075 | 24.725 | 87060.0 |
| 2014-09-05 08:10:00 | AAPL | Stock | 24.725 | 24.7325 | 24.695 | 24.695 | 101328.0 |
| 2014-09-05 08:15:00 | AAPL | Stock | 24.695 | 24.72 | 24.6825 | 24.695 | 114560.0 |
| 2014-09-05 08:20:00 | AAPL | Stock | 24.695 | 24.7 | 24.695 | 24.7 | 31896.0 |
| 2014-09-05 08:25:00 | AAPL | Stock | 24.7025 | 24.7125 | 24.695 | 24.7 | 38096.0 |
> showing 50 of 348,092 rows — these rows as CSV