PREVIEW / stock_5min / 2019-03-21
file: by_date/stock_5min/2019/2019-03-21.parquet size: 5.8 MB rows: 362,439 symbols: 2,662
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 |
|---|---|---|---|---|---|---|---|
| 2019-03-21 04:00:00 | AAPL | Stock | 47.1 | 47.11 | 47.1 | 47.11 | 800.0 |
| 2019-03-21 04:05:00 | AAPL | Stock | 47.045 | 47.045 | 47.045 | 47.045 | 400.0 |
| 2019-03-21 04:10:00 | AAPL | Stock | 47.15 | 47.15 | 47.15 | 47.15 | 400.0 |
| 2019-03-21 04:30:00 | AAPL | Stock | 47.0675 | 47.0675 | 47.05 | 47.05 | 1704.0 |
| 2019-03-21 04:35:00 | AAPL | Stock | 47.0825 | 47.0825 | 47.08 | 47.08 | 1608.0 |
| 2019-03-21 04:55:00 | AAPL | Stock | 47.05 | 47.05 | 47.05 | 47.05 | 2652.0 |
| 2019-03-21 05:05:00 | AAPL | Stock | 47.0725 | 47.15 | 47.0725 | 47.15 | 5180.0 |
| 2019-03-21 05:15:00 | AAPL | Stock | 47.1375 | 47.1375 | 47.1375 | 47.1375 | 400.0 |
| 2019-03-21 05:25:00 | AAPL | Stock | 47.1375 | 47.1375 | 47.1375 | 47.1375 | 412.0 |
| 2019-03-21 05:45:00 | AAPL | Stock | 47.125 | 47.125 | 47.125 | 47.125 | 2000.0 |
| 2019-03-21 06:15:00 | AAPL | Stock | 47.17 | 47.175 | 47.1675 | 47.175 | 10020.0 |
| 2019-03-21 06:20:00 | AAPL | Stock | 47.2 | 47.245 | 47.2 | 47.245 | 4508.0 |
| 2019-03-21 06:35:00 | AAPL | Stock | 47.3025 | 47.3025 | 47.3025 | 47.3025 | 1200.0 |
| 2019-03-21 06:40:00 | AAPL | Stock | 47.2575 | 47.2575 | 47.2575 | 47.2575 | 444.0 |
| 2019-03-21 06:45:00 | AAPL | Stock | 47.2975 | 47.2975 | 47.2975 | 47.2975 | 400.0 |
| 2019-03-21 06:50:00 | AAPL | Stock | 47.2925 | 47.3 | 47.2925 | 47.3 | 800.0 |
| 2019-03-21 07:00:00 | AAPL | Stock | 47.265 | 47.375 | 47.25 | 47.3 | 55132.0 |
| 2019-03-21 07:05:00 | AAPL | Stock | 47.285 | 47.3225 | 47.25 | 47.25 | 29928.0 |
| 2019-03-21 07:10:00 | AAPL | Stock | 47.23 | 47.2875 | 47.13 | 47.13 | 24764.0 |
| 2019-03-21 07:15:00 | AAPL | Stock | 47.175 | 47.225 | 47.15 | 47.2175 | 20072.0 |
| 2019-03-21 07:20:00 | AAPL | Stock | 47.2225 | 47.2475 | 47.1375 | 47.1375 | 30256.0 |
| 2019-03-21 07:25:00 | AAPL | Stock | 47.2 | 47.325 | 47.15 | 47.275 | 130356.0 |
| 2019-03-21 07:30:00 | AAPL | Stock | 47.2675 | 47.3675 | 47.265 | 47.265 | 46396.0 |
| 2019-03-21 07:35:00 | AAPL | Stock | 47.2875 | 47.32 | 47.275 | 47.3 | 18424.0 |
| 2019-03-21 07:40:00 | AAPL | Stock | 47.3025 | 47.455 | 47.3025 | 47.42 | 99180.0 |
| 2019-03-21 07:45:00 | AAPL | Stock | 47.425 | 47.44 | 47.4 | 47.4 | 34624.0 |
| 2019-03-21 07:50:00 | AAPL | Stock | 47.425 | 47.425 | 47.3425 | 47.3625 | 36172.0 |
| 2019-03-21 07:55:00 | AAPL | Stock | 47.3625 | 47.3775 | 47.35 | 47.35 | 10324.0 |
| 2019-03-21 08:00:00 | AAPL | Stock | 47.3125 | 47.465 | 47.2125 | 47.3875 | 134048.0 |
| 2019-03-21 08:05:00 | AAPL | Stock | 47.3725 | 47.3875 | 47.3625 | 47.3625 | 25508.0 |
| 2019-03-21 08:10:00 | AAPL | Stock | 47.375 | 47.38 | 47.3525 | 47.3625 | 30472.0 |
| 2019-03-21 08:15:00 | AAPL | Stock | 47.3525 | 47.3625 | 47.33 | 47.33 | 50788.0 |
| 2019-03-21 08:20:00 | AAPL | Stock | 47.33 | 47.3375 | 47.315 | 47.325 | 40908.0 |
| 2019-03-21 08:25:00 | AAPL | Stock | 47.315 | 47.38 | 47.315 | 47.3725 | 49592.0 |
| 2019-03-21 08:30:00 | AAPL | Stock | 47.355 | 47.4375 | 47.355 | 47.43 | 103400.0 |
| 2019-03-21 08:35:00 | AAPL | Stock | 47.43 | 47.485 | 47.4175 | 47.485 | 87660.0 |
| 2019-03-21 08:40:00 | AAPL | Stock | 47.485 | 47.5425 | 47.48 | 47.5225 | 174872.0 |
| 2019-03-21 08:45:00 | AAPL | Stock | 47.5325 | 47.5925 | 47.525 | 47.5925 | 231920.0 |
| 2019-03-21 08:50:00 | AAPL | Stock | 47.5725 | 47.6225 | 47.5575 | 47.615 | 172132.0 |
| 2019-03-21 08:55:00 | AAPL | Stock | 47.615 | 47.6625 | 47.6025 | 47.62 | 167128.0 |
| 2019-03-21 09:00:00 | AAPL | Stock | 47.6025 | 47.645 | 47.5775 | 47.63 | 104272.0 |
| 2019-03-21 09:05:00 | AAPL | Stock | 47.63 | 47.65 | 47.6075 | 47.62 | 95720.0 |
| 2019-03-21 09:10:00 | AAPL | Stock | 47.6125 | 47.625 | 47.6075 | 47.6075 | 52848.0 |
| 2019-03-21 09:15:00 | AAPL | Stock | 47.61 | 47.6225 | 47.595 | 47.595 | 175928.0 |
| 2019-03-21 09:20:00 | AAPL | Stock | 47.5875 | 47.6025 | 47.545 | 47.55 | 150396.0 |
| 2019-03-21 09:25:00 | AAPL | Stock | 47.55 | 47.55 | 47.4925 | 47.51 | 243568.0 |
| 2019-03-21 09:30:00 | AAPL | Stock | 47.5225 | 47.8125 | 47.4525 | 47.8125 | 9201812.0 |
| 2019-03-21 09:35:00 | AAPL | Stock | 47.81 | 48.065 | 47.805 | 47.9838 | 8411768.0 |
| 2019-03-21 09:40:00 | AAPL | Stock | 47.98 | 48.017 | 47.9075 | 48.0152 | 3703868.0 |
| 2019-03-21 09:45:00 | AAPL | Stock | 48.01 | 48.095 | 47.9875 | 48.07 | 3174080.0 |
> showing 50 of 362,439 rows — these rows as CSV