PREVIEW / stock_5min / 2017-05-19
file: by_date/stock_5min/2017/2017-05-19.parquet size: 5.4 MB rows: 352,608 symbols: 3,025
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 |
|---|---|---|---|---|---|---|---|
| 2017-05-19 04:00:00 | AAPL | Stock | 38.1625 | 38.1625 | 38.1625 | 38.1625 | 620.0 |
| 2017-05-19 05:00:00 | AAPL | Stock | 38.3 | 38.3 | 38.3 | 38.3 | 3600.0 |
| 2017-05-19 05:10:00 | AAPL | Stock | 38.3375 | 38.36 | 38.3375 | 38.36 | 1572.0 |
| 2017-05-19 05:15:00 | AAPL | Stock | 38.375 | 38.3875 | 38.36 | 38.36 | 8676.0 |
| 2017-05-19 05:25:00 | AAPL | Stock | 38.4375 | 38.4375 | 38.4 | 38.4 | 10672.0 |
| 2017-05-19 05:40:00 | AAPL | Stock | 38.3725 | 38.3725 | 38.3725 | 38.3725 | 400.0 |
| 2017-05-19 05:50:00 | AAPL | Stock | 38.3875 | 38.3875 | 38.38 | 38.38 | 2400.0 |
| 2017-05-19 05:55:00 | AAPL | Stock | 38.38 | 38.38 | 38.38 | 38.38 | 2000.0 |
| 2017-05-19 06:05:00 | AAPL | Stock | 38.35 | 38.35 | 38.35 | 38.35 | 400.0 |
| 2017-05-19 06:10:00 | AAPL | Stock | 38.37 | 38.375 | 38.37 | 38.375 | 888.0 |
| 2017-05-19 06:15:00 | AAPL | Stock | 38.365 | 38.4225 | 38.365 | 38.4225 | 14576.0 |
| 2017-05-19 06:20:00 | AAPL | Stock | 38.425 | 38.425 | 38.425 | 38.425 | 8000.0 |
| 2017-05-19 06:25:00 | AAPL | Stock | 38.425 | 38.425 | 38.425 | 38.425 | 800.0 |
| 2017-05-19 06:30:00 | AAPL | Stock | 38.4025 | 38.4025 | 38.4 | 38.4 | 5600.0 |
| 2017-05-19 06:35:00 | AAPL | Stock | 38.38 | 38.38 | 38.38 | 38.38 | 1112.0 |
| 2017-05-19 06:40:00 | AAPL | Stock | 38.38 | 38.38 | 38.38 | 38.38 | 2800.0 |
| 2017-05-19 06:45:00 | AAPL | Stock | 38.375 | 38.375 | 38.3375 | 38.3375 | 4000.0 |
| 2017-05-19 06:50:00 | AAPL | Stock | 38.34 | 38.3475 | 38.34 | 38.3475 | 4000.0 |
| 2017-05-19 06:55:00 | AAPL | Stock | 38.3375 | 38.3425 | 38.325 | 38.3425 | 4800.0 |
| 2017-05-19 07:00:00 | AAPL | Stock | 38.36 | 38.36 | 38.36 | 38.36 | 400.0 |
| 2017-05-19 07:05:00 | AAPL | Stock | 38.36 | 38.3625 | 38.36 | 38.3625 | 5100.0 |
| 2017-05-19 07:10:00 | AAPL | Stock | 38.365 | 38.3675 | 38.3625 | 38.3625 | 5640.0 |
| 2017-05-19 07:15:00 | AAPL | Stock | 38.3725 | 38.3725 | 38.3525 | 38.3675 | 5840.0 |
| 2017-05-19 07:20:00 | AAPL | Stock | 38.3625 | 38.3625 | 38.3625 | 38.3625 | 400.0 |
| 2017-05-19 07:25:00 | AAPL | Stock | 38.355 | 38.3625 | 38.3525 | 38.3625 | 2284.0 |
| 2017-05-19 07:30:00 | AAPL | Stock | 38.3625 | 38.375 | 38.3625 | 38.375 | 12404.0 |
| 2017-05-19 07:35:00 | AAPL | Stock | 38.385 | 38.385 | 38.3725 | 38.375 | 6904.0 |
| 2017-05-19 07:40:00 | AAPL | Stock | 38.375 | 38.375 | 38.35 | 38.35 | 5280.0 |
| 2017-05-19 07:45:00 | AAPL | Stock | 38.37 | 38.37 | 38.35 | 38.3525 | 9756.0 |
| 2017-05-19 07:50:00 | AAPL | Stock | 38.3525 | 38.3625 | 38.3525 | 38.355 | 8000.0 |
| 2017-05-19 07:55:00 | AAPL | Stock | 38.3625 | 38.365 | 38.3525 | 38.3525 | 83472.0 |
| 2017-05-19 08:00:00 | AAPL | Stock | 38.37 | 38.4475 | 38.36 | 38.4375 | 204428.0 |
| 2017-05-19 08:05:00 | AAPL | Stock | 38.4325 | 38.4425 | 38.4 | 38.4425 | 47472.0 |
| 2017-05-19 08:10:00 | AAPL | Stock | 38.435 | 38.4375 | 38.4025 | 38.415 | 51848.0 |
| 2017-05-19 08:15:00 | AAPL | Stock | 38.4125 | 38.455 | 38.4125 | 38.455 | 45468.0 |
| 2017-05-19 08:20:00 | AAPL | Stock | 38.4725 | 38.4875 | 38.45 | 38.45 | 30504.0 |
| 2017-05-19 08:25:00 | AAPL | Stock | 38.45 | 38.4725 | 38.4375 | 38.455 | 40256.0 |
| 2017-05-19 08:30:00 | AAPL | Stock | 38.455 | 38.47 | 38.4375 | 38.45 | 24148.0 |
| 2017-05-19 08:35:00 | AAPL | Stock | 38.46 | 38.4725 | 38.4375 | 38.4625 | 33992.0 |
| 2017-05-19 08:40:00 | AAPL | Stock | 38.4475 | 38.46 | 38.4425 | 38.4425 | 15080.0 |
| 2017-05-19 08:45:00 | AAPL | Stock | 38.46 | 38.4625 | 38.445 | 38.4625 | 7176.0 |
| 2017-05-19 08:50:00 | AAPL | Stock | 38.4625 | 38.4625 | 38.4375 | 38.4575 | 35148.0 |
| 2017-05-19 08:55:00 | AAPL | Stock | 38.4575 | 38.465 | 38.4525 | 38.4575 | 28936.0 |
| 2017-05-19 09:00:00 | AAPL | Stock | 38.455 | 38.4575 | 38.45 | 38.45 | 17940.0 |
| 2017-05-19 09:05:00 | AAPL | Stock | 38.45 | 38.45 | 38.425 | 38.4375 | 56888.0 |
| 2017-05-19 09:10:00 | AAPL | Stock | 38.4375 | 38.445 | 38.415 | 38.425 | 68204.0 |
| 2017-05-19 09:15:00 | AAPL | Stock | 38.425 | 38.425 | 38.4125 | 38.4125 | 26780.0 |
| 2017-05-19 09:20:00 | AAPL | Stock | 38.4075 | 38.4225 | 38.38 | 38.3975 | 125972.0 |
| 2017-05-19 09:25:00 | AAPL | Stock | 38.4 | 38.435 | 38.31 | 38.3575 | 345976.0 |
| 2017-05-19 09:30:00 | AAPL | Stock | 38.3575 | 38.435 | 38.265 | 38.3025 | 12583132.0 |
> showing 50 of 352,608 rows — these rows as CSV