PREVIEW / stock_5min / 2016-04-18
file: by_date/stock_5min/2016/2016-04-18.parquet size: 5.4 MB rows: 359,589 symbols: 3,326
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-04-18 04:00:00 | AAPL | Stock | 27.4 | 27.4 | 27.3025 | 27.3025 | 11948.0 |
| 2016-04-18 04:05:00 | AAPL | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 2356.0 |
| 2016-04-18 04:20:00 | AAPL | Stock | 27.255 | 27.255 | 27.2525 | 27.2525 | 6320.0 |
| 2016-04-18 04:45:00 | AAPL | Stock | 27.3025 | 27.3025 | 27.3025 | 27.3025 | 800.0 |
| 2016-04-18 05:00:00 | AAPL | Stock | 27.345 | 27.345 | 27.345 | 27.345 | 400.0 |
| 2016-04-18 05:05:00 | AAPL | Stock | 27.3025 | 27.3025 | 27.3025 | 27.3025 | 1600.0 |
| 2016-04-18 05:25:00 | AAPL | Stock | 27.31 | 27.31 | 27.31 | 27.31 | 2000.0 |
| 2016-04-18 05:30:00 | AAPL | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 2464.0 |
| 2016-04-18 05:50:00 | AAPL | Stock | 27.325 | 27.325 | 27.325 | 27.325 | 400.0 |
| 2016-04-18 05:55:00 | AAPL | Stock | 27.345 | 27.36 | 27.345 | 27.36 | 8400.0 |
| 2016-04-18 06:05:00 | AAPL | Stock | 27.36 | 27.3625 | 27.36 | 27.3625 | 10800.0 |
| 2016-04-18 06:10:00 | AAPL | Stock | 27.36 | 27.36 | 27.36 | 27.36 | 400.0 |
| 2016-04-18 06:15:00 | AAPL | Stock | 27.36 | 27.36 | 27.36 | 27.36 | 7200.0 |
| 2016-04-18 06:30:00 | AAPL | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 2000.0 |
| 2016-04-18 06:35:00 | AAPL | Stock | 27.335 | 27.35 | 27.335 | 27.35 | 4012.0 |
| 2016-04-18 06:40:00 | AAPL | Stock | 27.315 | 27.315 | 27.315 | 27.315 | 400.0 |
| 2016-04-18 06:55:00 | AAPL | Stock | 27.3125 | 27.3125 | 27.3125 | 27.3125 | 400.0 |
| 2016-04-18 07:00:00 | AAPL | Stock | 27.325 | 27.34 | 27.3 | 27.3 | 18748.0 |
| 2016-04-18 07:05:00 | AAPL | Stock | 27.31 | 27.3125 | 27.31 | 27.3125 | 3200.0 |
| 2016-04-18 07:10:00 | AAPL | Stock | 27.32 | 27.34 | 27.32 | 27.34 | 16416.0 |
| 2016-04-18 07:15:00 | AAPL | Stock | 27.3375 | 27.3375 | 27.325 | 27.325 | 26512.0 |
| 2016-04-18 07:20:00 | AAPL | Stock | 27.3125 | 27.315 | 27.2775 | 27.2775 | 38568.0 |
| 2016-04-18 07:25:00 | AAPL | Stock | 27.2775 | 27.29 | 27.2775 | 27.29 | 17800.0 |
| 2016-04-18 07:30:00 | AAPL | Stock | 27.29 | 27.2925 | 27.125 | 27.2325 | 33840.0 |
| 2016-04-18 07:35:00 | AAPL | Stock | 27.2475 | 27.26 | 27.2325 | 27.235 | 53252.0 |
| 2016-04-18 07:40:00 | AAPL | Stock | 27.235 | 27.235 | 27.225 | 27.225 | 26548.0 |
| 2016-04-18 07:45:00 | AAPL | Stock | 27.235 | 27.25 | 27.2225 | 27.225 | 29160.0 |
| 2016-04-18 07:50:00 | AAPL | Stock | 27.225 | 27.225 | 27.18 | 27.2175 | 45916.0 |
| 2016-04-18 07:55:00 | AAPL | Stock | 27.2175 | 27.225 | 27.2125 | 27.2125 | 15208.0 |
| 2016-04-18 08:00:00 | AAPL | Stock | 27.2125 | 27.3325 | 27.205 | 27.235 | 108888.0 |
| 2016-04-18 08:05:00 | AAPL | Stock | 27.235 | 27.235 | 27.215 | 27.215 | 31424.0 |
| 2016-04-18 08:10:00 | AAPL | Stock | 27.2225 | 27.23 | 27.215 | 27.2175 | 18412.0 |
| 2016-04-18 08:15:00 | AAPL | Stock | 27.225 | 27.245 | 27.22 | 27.23 | 68712.0 |
| 2016-04-18 08:20:00 | AAPL | Stock | 27.235 | 27.2625 | 27.235 | 27.2525 | 69196.0 |
| 2016-04-18 08:25:00 | AAPL | Stock | 27.26 | 27.2825 | 27.2525 | 27.2825 | 59756.0 |
| 2016-04-18 08:30:00 | AAPL | Stock | 27.275 | 27.2975 | 27.265 | 27.295 | 78844.0 |
| 2016-04-18 08:35:00 | AAPL | Stock | 27.295 | 27.2975 | 27.2775 | 27.28 | 45600.0 |
| 2016-04-18 08:40:00 | AAPL | Stock | 27.285 | 27.2875 | 27.2725 | 27.275 | 29572.0 |
| 2016-04-18 08:45:00 | AAPL | Stock | 27.275 | 27.275 | 27.2675 | 27.2725 | 34788.0 |
| 2016-04-18 08:50:00 | AAPL | Stock | 27.28 | 27.28 | 27.2525 | 27.2575 | 67600.0 |
| 2016-04-18 08:55:00 | AAPL | Stock | 27.2625 | 27.2625 | 27.2375 | 27.25 | 58316.0 |
| 2016-04-18 09:00:00 | AAPL | Stock | 27.25 | 27.26 | 27.2425 | 27.26 | 52748.0 |
| 2016-04-18 09:05:00 | AAPL | Stock | 27.255 | 27.2675 | 27.25 | 27.2575 | 27212.0 |
| 2016-04-18 09:10:00 | AAPL | Stock | 27.2525 | 27.26 | 27.25 | 27.255 | 42288.0 |
| 2016-04-18 09:15:00 | AAPL | Stock | 27.25 | 27.255 | 27.2375 | 27.245 | 24748.0 |
| 2016-04-18 09:20:00 | AAPL | Stock | 27.245 | 27.255 | 27.2425 | 27.255 | 58604.0 |
| 2016-04-18 09:25:00 | AAPL | Stock | 27.26 | 27.285 | 27.2025 | 27.225 | 228396.0 |
| 2016-04-18 09:30:00 | AAPL | Stock | 27.225 | 27.2375 | 27.155 | 27.1912 | 8243052.0 |
| 2016-04-18 09:35:00 | AAPL | Stock | 27.19 | 27.225 | 27.1275 | 27.17 | 4136808.0 |
| 2016-04-18 09:40:00 | AAPL | Stock | 27.1725 | 27.205 | 26.9525 | 26.995 | 8363636.0 |
> showing 50 of 359,589 rows — these rows as CSV