PREVIEW / stock_5min / 2014-08-15
file: by_date/stock_5min/2014/2014-08-15.parquet size: 5.3 MB rows: 355,442 symbols: 3,564
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-08-15 04:05:00 | AAPL | Stock | 24.385 | 24.385 | 24.385 | 24.385 | 400.0 |
| 2014-08-15 04:25:00 | AAPL | Stock | 24.38 | 24.38 | 24.38 | 24.38 | 1600.0 |
| 2014-08-15 04:50:00 | AAPL | Stock | 24.4 | 24.4 | 24.4 | 24.4 | 400.0 |
| 2014-08-15 04:55:00 | AAPL | Stock | 24.4 | 24.4 | 24.4 | 24.4 | 4384.0 |
| 2014-08-15 05:05:00 | AAPL | Stock | 24.3825 | 24.3825 | 24.3825 | 24.3825 | 400.0 |
| 2014-08-15 05:10:00 | AAPL | Stock | 24.4 | 24.4 | 24.4 | 24.4 | 2000.0 |
| 2014-08-15 05:15:00 | AAPL | Stock | 24.4 | 24.4 | 24.4 | 24.4 | 400.0 |
| 2014-08-15 05:20:00 | AAPL | Stock | 24.4 | 24.4 | 24.4 | 24.4 | 1600.0 |
| 2014-08-15 05:40:00 | AAPL | Stock | 24.4 | 24.4 | 24.4 | 24.4 | 800.0 |
| 2014-08-15 05:45:00 | AAPL | Stock | 24.4 | 24.405 | 24.4 | 24.405 | 3600.0 |
| 2014-08-15 05:50:00 | AAPL | Stock | 24.405 | 24.405 | 24.405 | 24.405 | 2000.0 |
| 2014-08-15 06:50:00 | AAPL | Stock | 24.4125 | 24.4125 | 24.4075 | 24.4075 | 800.0 |
| 2014-08-15 07:00:00 | AAPL | Stock | 24.43 | 24.43 | 24.425 | 24.425 | 1600.0 |
| 2014-08-15 07:05:00 | AAPL | Stock | 24.425 | 24.43 | 24.425 | 24.43 | 960.0 |
| 2014-08-15 07:10:00 | AAPL | Stock | 24.4325 | 24.4375 | 24.4325 | 24.4375 | 4760.0 |
| 2014-08-15 07:15:00 | AAPL | Stock | 24.445 | 24.45 | 24.445 | 24.45 | 5636.0 |
| 2014-08-15 07:30:00 | AAPL | Stock | 24.44 | 24.44 | 24.435 | 24.435 | 1600.0 |
| 2014-08-15 07:35:00 | AAPL | Stock | 24.44 | 24.44 | 24.435 | 24.435 | 24000.0 |
| 2014-08-15 07:40:00 | AAPL | Stock | 24.4325 | 24.4325 | 24.425 | 24.425 | 2400.0 |
| 2014-08-15 07:45:00 | AAPL | Stock | 24.43 | 24.43 | 24.4125 | 24.4125 | 9360.0 |
| 2014-08-15 07:50:00 | AAPL | Stock | 24.4075 | 24.415 | 24.4 | 24.415 | 5400.0 |
| 2014-08-15 07:55:00 | AAPL | Stock | 24.4225 | 24.425 | 24.41 | 24.41 | 8600.0 |
| 2014-08-15 08:00:00 | AAPL | Stock | 24.415 | 24.4475 | 24.4 | 24.4125 | 122824.0 |
| 2014-08-15 08:05:00 | AAPL | Stock | 24.4125 | 24.425 | 24.4125 | 24.415 | 23460.0 |
| 2014-08-15 08:10:00 | AAPL | Stock | 24.415 | 24.42 | 24.415 | 24.42 | 12844.0 |
| 2014-08-15 08:15:00 | AAPL | Stock | 24.42 | 24.425 | 24.42 | 24.425 | 32744.0 |
| 2014-08-15 08:20:00 | AAPL | Stock | 24.4225 | 24.4225 | 24.42 | 24.4225 | 14500.0 |
| 2014-08-15 08:25:00 | AAPL | Stock | 24.4175 | 24.42 | 24.4175 | 24.42 | 10388.0 |
| 2014-08-15 08:30:00 | AAPL | Stock | 24.42 | 24.43 | 24.415 | 24.425 | 45156.0 |
| 2014-08-15 08:35:00 | AAPL | Stock | 24.425 | 24.425 | 24.42 | 24.42 | 7480.0 |
| 2014-08-15 08:40:00 | AAPL | Stock | 24.425 | 24.4325 | 24.425 | 24.4325 | 42520.0 |
| 2014-08-15 08:45:00 | AAPL | Stock | 24.4325 | 24.4325 | 24.42 | 24.4225 | 38128.0 |
| 2014-08-15 08:50:00 | AAPL | Stock | 24.4225 | 24.4225 | 24.415 | 24.415 | 37772.0 |
| 2014-08-15 08:55:00 | AAPL | Stock | 24.42 | 24.425 | 24.4175 | 24.4175 | 14288.0 |
| 2014-08-15 09:00:00 | AAPL | Stock | 24.4175 | 24.4175 | 24.415 | 24.4175 | 19444.0 |
| 2014-08-15 09:05:00 | AAPL | Stock | 24.42 | 24.43 | 24.42 | 24.4275 | 24308.0 |
| 2014-08-15 09:10:00 | AAPL | Stock | 24.4225 | 24.4225 | 24.4 | 24.4 | 118068.0 |
| 2014-08-15 09:15:00 | AAPL | Stock | 24.4 | 24.4075 | 24.3925 | 24.4 | 104976.0 |
| 2014-08-15 09:20:00 | AAPL | Stock | 24.3975 | 24.42 | 24.395 | 24.42 | 57192.0 |
| 2014-08-15 09:25:00 | AAPL | Stock | 24.42 | 24.5125 | 24.4125 | 24.4725 | 1176244.0 |
| 2014-08-15 09:30:00 | AAPL | Stock | 24.475 | 24.4975 | 24.4125 | 24.4275 | 26068832.0 |
| 2014-08-15 09:35:00 | AAPL | Stock | 24.4297 | 24.4525 | 24.395 | 24.411 | 3236672.0 |
| 2014-08-15 09:40:00 | AAPL | Stock | 24.41 | 24.4237 | 24.3625 | 24.385 | 3663776.0 |
| 2014-08-15 09:45:00 | AAPL | Stock | 24.3825 | 24.4175 | 24.3825 | 24.4038 | 2108284.0 |
| 2014-08-15 09:50:00 | AAPL | Stock | 24.405 | 24.4425 | 24.4 | 24.4412 | 1704728.0 |
| 2014-08-15 09:55:00 | AAPL | Stock | 24.44 | 24.445 | 24.415 | 24.445 | 1625044.0 |
| 2014-08-15 10:00:00 | AAPL | Stock | 24.445 | 24.4688 | 24.4425 | 24.4675 | 2374104.0 |
| 2014-08-15 10:05:00 | AAPL | Stock | 24.4675 | 24.505 | 24.4625 | 24.47 | 5555992.0 |
| 2014-08-15 10:10:00 | AAPL | Stock | 24.4712 | 24.5125 | 24.47 | 24.5112 | 2705788.0 |
| 2014-08-15 10:15:00 | AAPL | Stock | 24.51 | 24.5125 | 24.4358 | 24.5025 | 2815132.0 |
> showing 50 of 355,442 rows — these rows as CSV