PREVIEW / stock_5min / 2015-04-09
file: by_date/stock_5min/2015/2015-04-09.parquet size: 5.3 MB rows: 353,955 symbols: 3,496
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 |
|---|---|---|---|---|---|---|---|
| 2015-04-09 04:00:00 | AAPL | Stock | 31.4125 | 31.4125 | 31.4 | 31.4 | 23504.0 |
| 2015-04-09 04:05:00 | AAPL | Stock | 31.4025 | 31.4025 | 31.4 | 31.4 | 2400.0 |
| 2015-04-09 04:20:00 | AAPL | Stock | 31.4 | 31.4 | 31.4 | 31.4 | 2000.0 |
| 2015-04-09 04:30:00 | AAPL | Stock | 31.385 | 31.385 | 31.385 | 31.385 | 4000.0 |
| 2015-04-09 04:40:00 | AAPL | Stock | 31.375 | 31.375 | 31.375 | 31.375 | 9480.0 |
| 2015-04-09 04:50:00 | AAPL | Stock | 31.355 | 31.355 | 31.355 | 31.355 | 400.0 |
| 2015-04-09 05:20:00 | AAPL | Stock | 31.3825 | 31.3825 | 31.3825 | 31.3825 | 400.0 |
| 2015-04-09 05:25:00 | AAPL | Stock | 31.41 | 31.41 | 31.41 | 31.41 | 400.0 |
| 2015-04-09 05:50:00 | AAPL | Stock | 31.38 | 31.38 | 31.38 | 31.38 | 800.0 |
| 2015-04-09 06:05:00 | AAPL | Stock | 31.4325 | 31.435 | 31.4325 | 31.435 | 4000.0 |
| 2015-04-09 06:15:00 | AAPL | Stock | 31.42 | 31.42 | 31.4 | 31.4 | 11832.0 |
| 2015-04-09 06:20:00 | AAPL | Stock | 31.42 | 31.42 | 31.42 | 31.42 | 800.0 |
| 2015-04-09 06:35:00 | AAPL | Stock | 31.4275 | 31.4275 | 31.425 | 31.425 | 1600.0 |
| 2015-04-09 06:40:00 | AAPL | Stock | 31.4275 | 31.43 | 31.4275 | 31.43 | 4000.0 |
| 2015-04-09 06:50:00 | AAPL | Stock | 31.44 | 31.44 | 31.44 | 31.44 | 400.0 |
| 2015-04-09 07:00:00 | AAPL | Stock | 31.45 | 31.45 | 31.45 | 31.45 | 7416.0 |
| 2015-04-09 07:05:00 | AAPL | Stock | 31.4525 | 31.465 | 31.4525 | 31.4625 | 3600.0 |
| 2015-04-09 07:10:00 | AAPL | Stock | 31.485 | 31.485 | 31.48 | 31.4825 | 4400.0 |
| 2015-04-09 07:15:00 | AAPL | Stock | 31.48 | 31.4975 | 31.48 | 31.4975 | 9808.0 |
| 2015-04-09 07:20:00 | AAPL | Stock | 31.5 | 31.5525 | 31.5 | 31.5475 | 11604.0 |
| 2015-04-09 07:25:00 | AAPL | Stock | 31.5175 | 31.5375 | 31.51 | 31.525 | 11392.0 |
| 2015-04-09 07:30:00 | AAPL | Stock | 31.525 | 31.5375 | 31.505 | 31.5175 | 15580.0 |
| 2015-04-09 07:35:00 | AAPL | Stock | 31.52 | 31.55 | 31.52 | 31.54 | 12360.0 |
| 2015-04-09 07:40:00 | AAPL | Stock | 31.545 | 31.545 | 31.5275 | 31.5275 | 3216.0 |
| 2015-04-09 07:45:00 | AAPL | Stock | 31.5275 | 31.545 | 31.5 | 31.545 | 9880.0 |
| 2015-04-09 07:50:00 | AAPL | Stock | 31.5475 | 31.5475 | 31.525 | 31.5275 | 3200.0 |
| 2015-04-09 07:55:00 | AAPL | Stock | 31.5275 | 31.53 | 31.5275 | 31.5275 | 2412.0 |
| 2015-04-09 08:00:00 | AAPL | Stock | 31.5375 | 31.545 | 31.43 | 31.535 | 79916.0 |
| 2015-04-09 08:05:00 | AAPL | Stock | 31.535 | 31.535 | 31.5025 | 31.5025 | 53700.0 |
| 2015-04-09 08:10:00 | AAPL | Stock | 31.5025 | 31.525 | 31.5025 | 31.525 | 35892.0 |
| 2015-04-09 08:15:00 | AAPL | Stock | 31.5225 | 31.535 | 31.5125 | 31.535 | 56924.0 |
| 2015-04-09 08:20:00 | AAPL | Stock | 31.535 | 31.5375 | 31.5075 | 31.5075 | 39000.0 |
| 2015-04-09 08:25:00 | AAPL | Stock | 31.5075 | 31.525 | 31.505 | 31.5175 | 46520.0 |
| 2015-04-09 08:30:00 | AAPL | Stock | 31.5325 | 31.54 | 31.515 | 31.515 | 35020.0 |
| 2015-04-09 08:35:00 | AAPL | Stock | 31.505 | 31.5225 | 31.4875 | 31.52 | 91044.0 |
| 2015-04-09 08:40:00 | AAPL | Stock | 31.505 | 31.5075 | 31.5 | 31.5052 | 14640.0 |
| 2015-04-09 08:45:00 | AAPL | Stock | 31.515 | 31.5325 | 31.5075 | 31.5325 | 16976.0 |
| 2015-04-09 08:50:00 | AAPL | Stock | 31.5175 | 31.5275 | 31.5125 | 31.5125 | 18680.0 |
| 2015-04-09 08:55:00 | AAPL | Stock | 31.5175 | 31.5175 | 31.5075 | 31.5075 | 7920.0 |
| 2015-04-09 09:00:00 | AAPL | Stock | 31.5125 | 31.52 | 31.49 | 31.5 | 61064.0 |
| 2015-04-09 09:05:00 | AAPL | Stock | 31.495 | 31.495 | 31.45 | 31.4575 | 80852.0 |
| 2015-04-09 09:10:00 | AAPL | Stock | 31.46 | 31.495 | 31.46 | 31.475 | 33560.0 |
| 2015-04-09 09:15:00 | AAPL | Stock | 31.4825 | 31.5 | 31.4825 | 31.5 | 32280.0 |
| 2015-04-09 09:20:00 | AAPL | Stock | 31.5025 | 31.5025 | 31.4675 | 31.49 | 65932.0 |
| 2015-04-09 09:25:00 | AAPL | Stock | 31.4925 | 31.5125 | 31.4625 | 31.465 | 33688.0 |
| 2015-04-09 09:30:00 | AAPL | Stock | 31.465 | 31.57 | 31.4375 | 31.55 | 4488652.0 |
| 2015-04-09 09:35:00 | AAPL | Stock | 31.5525 | 31.5625 | 31.445 | 31.52 | 3164332.0 |
| 2015-04-09 09:40:00 | AAPL | Stock | 31.5225 | 31.5275 | 31.3325 | 31.3375 | 3328028.0 |
| 2015-04-09 09:45:00 | AAPL | Stock | 31.34 | 31.4225 | 31.34 | 31.385 | 3004800.0 |
| 2015-04-09 09:50:00 | AAPL | Stock | 31.385 | 31.385 | 31.2675 | 31.3075 | 4050916.0 |
> showing 50 of 353,955 rows — these rows as CSV