PREVIEW / stock_5min / 2014-09-15
file: by_date/stock_5min/2014/2014-09-15.parquet size: 5.4 MB rows: 363,544 symbols: 3,592
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-15 04:00:00 | AAPL | Stock | 25.42 | 25.42 | 25.4025 | 25.4025 | 1600.0 |
| 2014-09-15 04:05:00 | AAPL | Stock | 25.4025 | 25.4575 | 25.4025 | 25.4575 | 4400.0 |
| 2014-09-15 04:10:00 | AAPL | Stock | 25.415 | 25.415 | 25.415 | 25.415 | 2000.0 |
| 2014-09-15 04:15:00 | AAPL | Stock | 25.4175 | 25.4175 | 25.4175 | 25.4175 | 5200.0 |
| 2014-09-15 04:20:00 | AAPL | Stock | 25.4175 | 25.4175 | 25.4175 | 25.4175 | 400.0 |
| 2014-09-15 04:25:00 | AAPL | Stock | 25.4175 | 25.4225 | 25.4175 | 25.4225 | 2000.0 |
| 2014-09-15 04:30:00 | AAPL | Stock | 25.4475 | 25.4475 | 25.4475 | 25.4475 | 800.0 |
| 2014-09-15 04:50:00 | AAPL | Stock | 25.4575 | 25.4575 | 25.4575 | 25.4575 | 1440.0 |
| 2014-09-15 04:55:00 | AAPL | Stock | 25.4475 | 25.4475 | 25.4475 | 25.4475 | 6800.0 |
| 2014-09-15 05:00:00 | AAPL | Stock | 25.4475 | 25.4475 | 25.4475 | 25.4475 | 9800.0 |
| 2014-09-15 05:05:00 | AAPL | Stock | 25.44 | 25.44 | 25.44 | 25.44 | 10708.0 |
| 2014-09-15 05:10:00 | AAPL | Stock | 25.44 | 25.46 | 25.4375 | 25.44 | 143400.0 |
| 2014-09-15 05:15:00 | AAPL | Stock | 25.44 | 25.44 | 25.44 | 25.44 | 8400.0 |
| 2014-09-15 05:20:00 | AAPL | Stock | 25.44 | 25.44 | 25.44 | 25.44 | 1600.0 |
| 2014-09-15 05:25:00 | AAPL | Stock | 25.44 | 25.44 | 25.425 | 25.425 | 1200.0 |
| 2014-09-15 05:35:00 | AAPL | Stock | 25.425 | 25.425 | 25.425 | 25.425 | 400.0 |
| 2014-09-15 05:50:00 | AAPL | Stock | 25.435 | 25.435 | 25.435 | 25.435 | 400.0 |
| 2014-09-15 05:55:00 | AAPL | Stock | 25.435 | 25.4375 | 25.435 | 25.4375 | 4400.0 |
| 2014-09-15 06:00:00 | AAPL | Stock | 25.48 | 25.5 | 25.48 | 25.5 | 2204.0 |
| 2014-09-15 06:05:00 | AAPL | Stock | 25.5 | 25.5 | 25.49 | 25.49 | 2348.0 |
| 2014-09-15 06:10:00 | AAPL | Stock | 25.475 | 25.4875 | 25.475 | 25.4875 | 1200.0 |
| 2014-09-15 06:15:00 | AAPL | Stock | 25.44 | 25.47 | 25.44 | 25.47 | 3536.0 |
| 2014-09-15 06:40:00 | AAPL | Stock | 25.485 | 25.485 | 25.485 | 25.485 | 4000.0 |
| 2014-09-15 06:45:00 | AAPL | Stock | 25.4875 | 25.49 | 25.4875 | 25.49 | 1600.0 |
| 2014-09-15 06:50:00 | AAPL | Stock | 25.4875 | 25.4875 | 25.4875 | 25.4875 | 400.0 |
| 2014-09-15 06:55:00 | AAPL | Stock | 25.475 | 25.475 | 25.475 | 25.475 | 1200.0 |
| 2014-09-15 07:00:00 | AAPL | Stock | 25.48 | 25.48 | 25.455 | 25.475 | 20908.0 |
| 2014-09-15 07:05:00 | AAPL | Stock | 25.4675 | 25.4675 | 25.455 | 25.455 | 14720.0 |
| 2014-09-15 07:10:00 | AAPL | Stock | 25.465 | 25.4925 | 25.4525 | 25.49 | 39520.0 |
| 2014-09-15 07:15:00 | AAPL | Stock | 25.4925 | 25.5 | 25.4925 | 25.5 | 48676.0 |
| 2014-09-15 07:20:00 | AAPL | Stock | 25.5 | 25.5125 | 25.495 | 25.495 | 14000.0 |
| 2014-09-15 07:25:00 | AAPL | Stock | 25.5 | 25.5 | 25.495 | 25.495 | 18200.0 |
| 2014-09-15 07:30:00 | AAPL | Stock | 25.4925 | 25.495 | 25.4875 | 25.495 | 18092.0 |
| 2014-09-15 07:35:00 | AAPL | Stock | 25.4875 | 25.495 | 25.4825 | 25.4875 | 33328.0 |
| 2014-09-15 07:40:00 | AAPL | Stock | 25.485 | 25.55 | 25.485 | 25.5475 | 43580.0 |
| 2014-09-15 07:45:00 | AAPL | Stock | 25.54 | 25.55 | 25.5375 | 25.54 | 23380.0 |
| 2014-09-15 07:50:00 | AAPL | Stock | 25.535 | 25.545 | 25.53 | 25.545 | 24568.0 |
| 2014-09-15 07:55:00 | AAPL | Stock | 25.5375 | 25.54 | 25.525 | 25.535 | 30916.0 |
| 2014-09-15 08:00:00 | AAPL | Stock | 25.53 | 25.55 | 25.4575 | 25.5375 | 396120.0 |
| 2014-09-15 08:05:00 | AAPL | Stock | 25.535 | 25.545 | 25.53 | 25.535 | 119148.0 |
| 2014-09-15 08:10:00 | AAPL | Stock | 25.53 | 25.5725 | 25.525 | 25.5725 | 152028.0 |
| 2014-09-15 08:15:00 | AAPL | Stock | 25.5725 | 25.6025 | 25.5675 | 25.5925 | 261832.0 |
| 2014-09-15 08:20:00 | AAPL | Stock | 25.5975 | 25.6 | 25.5775 | 25.5775 | 164676.0 |
| 2014-09-15 08:25:00 | AAPL | Stock | 25.58 | 25.5875 | 25.575 | 25.5875 | 179920.0 |
| 2014-09-15 08:30:00 | AAPL | Stock | 25.585 | 25.68 | 25.4475 | 25.65 | 1464048.0 |
| 2014-09-15 08:35:00 | AAPL | Stock | 25.65 | 25.685 | 25.5925 | 25.62 | 911560.0 |
| 2014-09-15 08:40:00 | AAPL | Stock | 25.62 | 25.6625 | 25.6125 | 25.65 | 356632.0 |
| 2014-09-15 08:45:00 | AAPL | Stock | 25.655 | 25.675 | 25.625 | 25.675 | 211860.0 |
| 2014-09-15 08:50:00 | AAPL | Stock | 25.675 | 25.675 | 25.645 | 25.6625 | 307600.0 |
| 2014-09-15 08:55:00 | AAPL | Stock | 25.67 | 25.7225 | 25.6625 | 25.7125 | 331888.0 |
> showing 50 of 363,544 rows — these rows as CSV