PREVIEW / stock_5min / 2018-01-23
file: by_date/stock_5min/2018/2018-01-23.parquet size: 5.8 MB rows: 364,202 symbols: 2,894
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 |
|---|---|---|---|---|---|---|---|
| 2018-01-23 04:00:00 | AAPL | Stock | 44.45 | 44.5 | 44.45 | 44.5 | 9364.0 |
| 2018-01-23 04:05:00 | AAPL | Stock | 44.4975 | 44.5 | 44.4975 | 44.5 | 2456.0 |
| 2018-01-23 04:10:00 | AAPL | Stock | 44.475 | 44.5 | 44.45 | 44.4775 | 7472.0 |
| 2018-01-23 04:15:00 | AAPL | Stock | 44.4525 | 44.4525 | 44.4525 | 44.4525 | 400.0 |
| 2018-01-23 04:20:00 | AAPL | Stock | 44.45 | 44.45 | 44.45 | 44.45 | 7920.0 |
| 2018-01-23 04:25:00 | AAPL | Stock | 44.45 | 44.45 | 44.4475 | 44.45 | 4400.0 |
| 2018-01-23 04:40:00 | AAPL | Stock | 44.48 | 44.48 | 44.475 | 44.475 | 1772.0 |
| 2018-01-23 04:45:00 | AAPL | Stock | 44.475 | 44.475 | 44.475 | 44.475 | 400.0 |
| 2018-01-23 05:15:00 | AAPL | Stock | 44.4325 | 44.4325 | 44.4325 | 44.4325 | 400.0 |
| 2018-01-23 05:25:00 | AAPL | Stock | 44.45 | 44.45 | 44.45 | 44.45 | 1200.0 |
| 2018-01-23 05:30:00 | AAPL | Stock | 44.45 | 44.45 | 44.45 | 44.45 | 400.0 |
| 2018-01-23 05:35:00 | AAPL | Stock | 44.4725 | 44.475 | 44.4675 | 44.475 | 10344.0 |
| 2018-01-23 05:45:00 | AAPL | Stock | 44.4125 | 44.4125 | 44.4125 | 44.4125 | 400.0 |
| 2018-01-23 06:00:00 | AAPL | Stock | 44.47 | 44.475 | 44.47 | 44.475 | 3280.0 |
| 2018-01-23 06:05:00 | AAPL | Stock | 44.4125 | 44.45 | 44.4125 | 44.435 | 8800.0 |
| 2018-01-23 06:10:00 | AAPL | Stock | 44.41 | 44.41 | 44.375 | 44.375 | 4400.0 |
| 2018-01-23 06:15:00 | AAPL | Stock | 44.3625 | 44.3625 | 44.35 | 44.35 | 11968.0 |
| 2018-01-23 06:20:00 | AAPL | Stock | 44.35 | 44.35 | 44.35 | 44.35 | 5544.0 |
| 2018-01-23 06:25:00 | AAPL | Stock | 44.325 | 44.325 | 44.325 | 44.325 | 800.0 |
| 2018-01-23 06:30:00 | AAPL | Stock | 44.35 | 44.35 | 44.35 | 44.35 | 920.0 |
| 2018-01-23 06:35:00 | AAPL | Stock | 44.3725 | 44.3725 | 44.315 | 44.315 | 2416.0 |
| 2018-01-23 06:45:00 | AAPL | Stock | 44.325 | 44.325 | 44.325 | 44.325 | 3840.0 |
| 2018-01-23 06:50:00 | AAPL | Stock | 44.3325 | 44.3325 | 44.3325 | 44.3325 | 1760.0 |
| 2018-01-23 06:55:00 | AAPL | Stock | 44.3875 | 44.3875 | 44.3875 | 44.3875 | 1064.0 |
| 2018-01-23 07:00:00 | AAPL | Stock | 44.35 | 44.4 | 44.35 | 44.4 | 5720.0 |
| 2018-01-23 07:05:00 | AAPL | Stock | 44.41 | 44.45 | 44.41 | 44.445 | 16152.0 |
| 2018-01-23 07:10:00 | AAPL | Stock | 44.435 | 44.4375 | 44.435 | 44.4375 | 1200.0 |
| 2018-01-23 07:15:00 | AAPL | Stock | 44.435 | 44.45 | 44.425 | 44.45 | 17764.0 |
| 2018-01-23 07:20:00 | AAPL | Stock | 44.45 | 44.45 | 44.4375 | 44.4375 | 8988.0 |
| 2018-01-23 07:25:00 | AAPL | Stock | 44.42 | 44.42 | 44.42 | 44.42 | 800.0 |
| 2018-01-23 07:30:00 | AAPL | Stock | 44.45 | 44.4575 | 44.4375 | 44.4375 | 16520.0 |
| 2018-01-23 07:35:00 | AAPL | Stock | 44.4525 | 44.48 | 44.4525 | 44.48 | 9404.0 |
| 2018-01-23 07:40:00 | AAPL | Stock | 44.475 | 44.495 | 44.475 | 44.475 | 4752.0 |
| 2018-01-23 07:45:00 | AAPL | Stock | 44.475 | 44.4875 | 44.445 | 44.475 | 11228.0 |
| 2018-01-23 07:50:00 | AAPL | Stock | 44.4525 | 44.4525 | 44.44 | 44.44 | 9528.0 |
| 2018-01-23 07:55:00 | AAPL | Stock | 44.455 | 44.455 | 44.4375 | 44.44 | 6564.0 |
| 2018-01-23 08:00:00 | AAPL | Stock | 44.4375 | 44.4875 | 44.345 | 44.45 | 57288.0 |
| 2018-01-23 08:05:00 | AAPL | Stock | 44.4375 | 44.45 | 44.42 | 44.4375 | 73516.0 |
| 2018-01-23 08:10:00 | AAPL | Stock | 44.4375 | 44.45 | 44.425 | 44.4375 | 12408.0 |
| 2018-01-23 08:15:00 | AAPL | Stock | 44.45 | 44.45 | 44.425 | 44.445 | 20168.0 |
| 2018-01-23 08:20:00 | AAPL | Stock | 44.435 | 44.445 | 44.435 | 44.445 | 2100.0 |
| 2018-01-23 08:25:00 | AAPL | Stock | 44.4375 | 44.4375 | 44.4125 | 44.4125 | 24712.0 |
| 2018-01-23 08:30:00 | AAPL | Stock | 44.415 | 44.4375 | 44.4 | 44.4375 | 41348.0 |
| 2018-01-23 08:35:00 | AAPL | Stock | 44.4325 | 44.4375 | 44.39 | 44.39 | 49472.0 |
| 2018-01-23 08:40:00 | AAPL | Stock | 44.41 | 44.425 | 44.4 | 44.4175 | 25552.0 |
| 2018-01-23 08:45:00 | AAPL | Stock | 44.415 | 44.415 | 44.38 | 44.38 | 18980.0 |
| 2018-01-23 08:50:00 | AAPL | Stock | 44.395 | 44.41 | 44.395 | 44.41 | 32176.0 |
| 2018-01-23 08:55:00 | AAPL | Stock | 44.3925 | 44.4075 | 44.365 | 44.365 | 37836.0 |
| 2018-01-23 09:00:00 | AAPL | Stock | 44.38 | 44.3975 | 44.38 | 44.38 | 26624.0 |
| 2018-01-23 09:05:00 | AAPL | Stock | 44.375 | 44.395 | 44.3625 | 44.3925 | 32152.0 |
> showing 50 of 364,202 rows — these rows as CSV