PREVIEW / stock_5min / 2017-05-31
file: by_date/stock_5min/2017/2017-05-31.parquet size: 5.4 MB rows: 352,178 symbols: 3,038
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-31 04:00:00 | AAPL | Stock | 38.4375 | 38.4375 | 38.4375 | 38.4375 | 600.0 |
| 2017-05-31 05:45:00 | AAPL | Stock | 38.4125 | 38.4125 | 38.4125 | 38.4125 | 3548.0 |
| 2017-05-31 06:05:00 | AAPL | Stock | 38.4425 | 38.4425 | 38.4425 | 38.4425 | 6000.0 |
| 2017-05-31 06:20:00 | AAPL | Stock | 38.48 | 38.4825 | 38.48 | 38.4825 | 2104.0 |
| 2017-05-31 06:30:00 | AAPL | Stock | 38.4725 | 38.4725 | 38.4725 | 38.4725 | 6800.0 |
| 2017-05-31 06:40:00 | AAPL | Stock | 38.475 | 38.485 | 38.475 | 38.475 | 4300.0 |
| 2017-05-31 07:00:00 | AAPL | Stock | 38.4625 | 38.485 | 38.4625 | 38.485 | 1200.0 |
| 2017-05-31 07:10:00 | AAPL | Stock | 38.4825 | 38.49 | 38.4825 | 38.49 | 5752.0 |
| 2017-05-31 07:15:00 | AAPL | Stock | 38.49 | 38.4925 | 38.49 | 38.4925 | 2800.0 |
| 2017-05-31 07:20:00 | AAPL | Stock | 38.4975 | 38.525 | 38.4975 | 38.52 | 20964.0 |
| 2017-05-31 07:25:00 | AAPL | Stock | 38.515 | 38.515 | 38.4825 | 38.4875 | 11560.0 |
| 2017-05-31 07:30:00 | AAPL | Stock | 38.475 | 38.4975 | 38.47 | 38.47 | 16360.0 |
| 2017-05-31 07:35:00 | AAPL | Stock | 38.495 | 38.495 | 38.495 | 38.495 | 1176.0 |
| 2017-05-31 07:40:00 | AAPL | Stock | 38.495 | 38.4975 | 38.4925 | 38.4925 | 5200.0 |
| 2017-05-31 07:45:00 | AAPL | Stock | 38.475 | 38.5025 | 38.475 | 38.5025 | 2400.0 |
| 2017-05-31 07:50:00 | AAPL | Stock | 38.51 | 38.51 | 38.5025 | 38.5025 | 5216.0 |
| 2017-05-31 07:55:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 3024.0 |
| 2017-05-31 08:00:00 | AAPL | Stock | 38.485 | 38.515 | 38.46 | 38.5 | 23180.0 |
| 2017-05-31 08:05:00 | AAPL | Stock | 38.5075 | 38.52 | 38.5075 | 38.52 | 36888.0 |
| 2017-05-31 08:10:00 | AAPL | Stock | 38.52 | 38.52 | 38.515 | 38.52 | 5220.0 |
| 2017-05-31 08:15:00 | AAPL | Stock | 38.5175 | 38.52 | 38.5175 | 38.52 | 2000.0 |
| 2017-05-31 08:20:00 | AAPL | Stock | 38.52 | 38.525 | 38.52 | 38.52 | 18444.0 |
| 2017-05-31 08:25:00 | AAPL | Stock | 38.525 | 38.525 | 38.52 | 38.52 | 13920.0 |
| 2017-05-31 08:35:00 | AAPL | Stock | 38.52 | 38.52 | 38.52 | 38.52 | 600.0 |
| 2017-05-31 08:40:00 | AAPL | Stock | 38.52 | 38.5225 | 38.5025 | 38.5175 | 22584.0 |
| 2017-05-31 08:45:00 | AAPL | Stock | 38.5225 | 38.5225 | 38.5125 | 38.5125 | 4000.0 |
| 2017-05-31 08:50:00 | AAPL | Stock | 38.5125 | 38.5125 | 38.505 | 38.5125 | 11264.0 |
| 2017-05-31 08:55:00 | AAPL | Stock | 38.51 | 38.51 | 38.505 | 38.505 | 2020.0 |
| 2017-05-31 09:00:00 | AAPL | Stock | 38.5125 | 38.5125 | 38.51 | 38.51 | 3200.0 |
| 2017-05-31 09:05:00 | AAPL | Stock | 38.505 | 38.5125 | 38.505 | 38.51 | 4768.0 |
| 2017-05-31 09:10:00 | AAPL | Stock | 38.5075 | 38.5275 | 38.5075 | 38.5275 | 16744.0 |
| 2017-05-31 09:15:00 | AAPL | Stock | 38.53 | 38.55 | 38.52 | 38.52 | 21088.0 |
| 2017-05-31 09:20:00 | AAPL | Stock | 38.5375 | 38.5375 | 38.5075 | 38.5375 | 12480.0 |
| 2017-05-31 09:25:00 | AAPL | Stock | 38.5075 | 38.5075 | 38.47 | 38.4825 | 15544.0 |
| 2017-05-31 09:30:00 | AAPL | Stock | 38.4925 | 38.5425 | 38.4275 | 38.4625 | 3055272.0 |
| 2017-05-31 09:35:00 | AAPL | Stock | 38.46 | 38.5 | 38.44 | 38.4875 | 930436.0 |
| 2017-05-31 09:40:00 | AAPL | Stock | 38.485 | 38.525 | 38.48 | 38.495 | 1062120.0 |
| 2017-05-31 09:45:00 | AAPL | Stock | 38.4975 | 38.5125 | 38.3875 | 38.41 | 1589300.0 |
| 2017-05-31 09:50:00 | AAPL | Stock | 38.4125 | 38.445 | 38.35 | 38.365 | 1497116.0 |
| 2017-05-31 09:55:00 | AAPL | Stock | 38.3625 | 38.375 | 38.24 | 38.25 | 2354556.0 |
| 2017-05-31 10:00:00 | AAPL | Stock | 38.245 | 38.2575 | 38.1625 | 38.2075 | 2268332.0 |
| 2017-05-31 10:05:00 | AAPL | Stock | 38.207 | 38.2125 | 38.1025 | 38.155 | 2383160.0 |
| 2017-05-31 10:10:00 | AAPL | Stock | 38.155 | 38.1875 | 38.1175 | 38.1625 | 1670720.0 |
| 2017-05-31 10:15:00 | AAPL | Stock | 38.1625 | 38.2 | 38.095 | 38.1385 | 1519368.0 |
| 2017-05-31 10:20:00 | AAPL | Stock | 38.1375 | 38.1725 | 38.1275 | 38.1425 | 1290632.0 |
| 2017-05-31 10:25:00 | AAPL | Stock | 38.1425 | 38.18 | 38.1338 | 38.1675 | 901384.0 |
| 2017-05-31 10:30:00 | AAPL | Stock | 38.165 | 38.1975 | 38.13 | 38.18 | 1017792.0 |
| 2017-05-31 10:35:00 | AAPL | Stock | 38.18 | 38.18 | 38.14 | 38.1475 | 723388.0 |
| 2017-05-31 10:40:00 | AAPL | Stock | 38.15 | 38.2075 | 38.1425 | 38.1962 | 854380.0 |
| 2017-05-31 10:45:00 | AAPL | Stock | 38.1975 | 38.215 | 38.1825 | 38.1987 | 710988.0 |
> showing 50 of 352,178 rows — these rows as CSV