PREVIEW / stock_5min / 2021-09-16
file: by_date/stock_5min/2021/2021-09-16.parquet size: 7.3 MB rows: 449,347 symbols: 2,737
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 |
|---|---|---|---|---|---|---|---|
| 2021-09-16 04:00:00 | AAPL | Stock | 148.97 | 148.98 | 148.88 | 148.88 | 842.0 |
| 2021-09-16 04:05:00 | AAPL | Stock | 148.83 | 148.9 | 148.83 | 148.9 | 564.0 |
| 2021-09-16 04:10:00 | AAPL | Stock | 148.95 | 148.95 | 148.94 | 148.94 | 735.0 |
| 2021-09-16 04:15:00 | AAPL | Stock | 148.88 | 148.92 | 148.85 | 148.91 | 922.0 |
| 2021-09-16 04:25:00 | AAPL | Stock | 148.85 | 148.85 | 148.75 | 148.75 | 1794.0 |
| 2021-09-16 04:30:00 | AAPL | Stock | 148.71 | 148.71 | 148.67 | 148.67 | 869.0 |
| 2021-09-16 04:35:00 | AAPL | Stock | 148.61 | 148.67 | 148.56 | 148.63 | 2817.0 |
| 2021-09-16 04:40:00 | AAPL | Stock | 148.67 | 148.67 | 148.67 | 148.67 | 143.0 |
| 2021-09-16 04:45:00 | AAPL | Stock | 148.67 | 148.67 | 148.67 | 148.67 | 747.0 |
| 2021-09-16 04:50:00 | AAPL | Stock | 148.66 | 148.67 | 148.66 | 148.67 | 469.0 |
| 2021-09-16 05:00:00 | AAPL | Stock | 148.7 | 148.7 | 148.7 | 148.7 | 100.0 |
| 2021-09-16 05:10:00 | AAPL | Stock | 148.68 | 148.68 | 148.68 | 148.68 | 937.0 |
| 2021-09-16 05:15:00 | AAPL | Stock | 148.66 | 148.66 | 148.66 | 148.66 | 100.0 |
| 2021-09-16 05:20:00 | AAPL | Stock | 148.67 | 148.67 | 148.65 | 148.65 | 218.0 |
| 2021-09-16 05:25:00 | AAPL | Stock | 148.66 | 148.66 | 148.66 | 148.66 | 170.0 |
| 2021-09-16 05:45:00 | AAPL | Stock | 148.53 | 148.54 | 148.52 | 148.52 | 1029.0 |
| 2021-09-16 06:00:00 | AAPL | Stock | 148.53 | 148.53 | 148.53 | 148.53 | 442.0 |
| 2021-09-16 06:05:00 | AAPL | Stock | 148.55 | 148.55 | 148.51 | 148.51 | 1654.0 |
| 2021-09-16 06:10:00 | AAPL | Stock | 148.51 | 148.51 | 148.51 | 148.51 | 400.0 |
| 2021-09-16 06:15:00 | AAPL | Stock | 148.51 | 148.51 | 148.51 | 148.51 | 120.0 |
| 2021-09-16 06:20:00 | AAPL | Stock | 148.6 | 148.6 | 148.6 | 148.6 | 500.0 |
| 2021-09-16 06:25:00 | AAPL | Stock | 148.61 | 148.61 | 148.6 | 148.61 | 1772.0 |
| 2021-09-16 06:30:00 | AAPL | Stock | 148.61 | 148.62 | 148.6 | 148.6 | 1157.0 |
| 2021-09-16 06:40:00 | AAPL | Stock | 148.6 | 148.6 | 148.6 | 148.6 | 208.0 |
| 2021-09-16 06:45:00 | AAPL | Stock | 148.62 | 148.66 | 148.62 | 148.66 | 549.0 |
| 2021-09-16 06:50:00 | AAPL | Stock | 148.66 | 148.66 | 148.64 | 148.64 | 200.0 |
| 2021-09-16 07:00:00 | AAPL | Stock | 148.65 | 148.67 | 148.61 | 148.67 | 4322.0 |
| 2021-09-16 07:05:00 | AAPL | Stock | 148.7 | 148.7 | 148.62 | 148.62 | 2593.0 |
| 2021-09-16 07:10:00 | AAPL | Stock | 148.63 | 148.74 | 148.63 | 148.69 | 4986.0 |
| 2021-09-16 07:15:00 | AAPL | Stock | 148.67 | 148.68 | 148.66 | 148.67 | 400.0 |
| 2021-09-16 07:20:00 | AAPL | Stock | 148.63 | 148.66 | 148.63 | 148.63 | 3575.0 |
| 2021-09-16 07:25:00 | AAPL | Stock | 148.62 | 148.62 | 148.6 | 148.61 | 11928.0 |
| 2021-09-16 07:30:00 | AAPL | Stock | 148.601 | 148.601 | 148.56 | 148.56 | 5147.0 |
| 2021-09-16 07:35:00 | AAPL | Stock | 148.58 | 148.62 | 148.5 | 148.52 | 8338.0 |
| 2021-09-16 07:40:00 | AAPL | Stock | 148.52 | 148.56 | 148.51 | 148.51 | 3597.0 |
| 2021-09-16 07:45:00 | AAPL | Stock | 148.5 | 148.51 | 148.44 | 148.51 | 5985.0 |
| 2021-09-16 07:50:00 | AAPL | Stock | 148.53 | 148.55 | 148.53 | 148.55 | 855.0 |
| 2021-09-16 07:55:00 | AAPL | Stock | 148.55 | 148.55 | 148.53 | 148.55 | 2478.0 |
| 2021-09-16 08:00:00 | AAPL | Stock | 148.6465 | 148.74 | 148.36 | 148.39 | 98015.0 |
| 2021-09-16 08:05:00 | AAPL | Stock | 148.3801 | 148.39 | 148.32 | 148.35 | 10904.0 |
| 2021-09-16 08:10:00 | AAPL | Stock | 148.36 | 148.36 | 148.28 | 148.29 | 15398.0 |
| 2021-09-16 08:15:00 | AAPL | Stock | 148.339 | 148.4299 | 148.339 | 148.3897 | 31319.0 |
| 2021-09-16 08:20:00 | AAPL | Stock | 148.4 | 148.43 | 148.29 | 148.3003 | 27331.0 |
| 2021-09-16 08:25:00 | AAPL | Stock | 148.32 | 148.41 | 148.25 | 148.39 | 32554.0 |
| 2021-09-16 08:30:00 | AAPL | Stock | 148.35 | 148.63 | 148.33 | 148.5 | 32164.0 |
| 2021-09-16 08:35:00 | AAPL | Stock | 148.48 | 148.58 | 148.41 | 148.53 | 38402.0 |
| 2021-09-16 08:40:00 | AAPL | Stock | 148.4999 | 148.6199 | 148.4999 | 148.5699 | 41523.0 |
| 2021-09-16 08:45:00 | AAPL | Stock | 148.56 | 148.6 | 148.55 | 148.6 | 7800.0 |
| 2021-09-16 08:50:00 | AAPL | Stock | 148.6 | 148.7 | 148.57 | 148.68 | 26983.0 |
| 2021-09-16 08:55:00 | AAPL | Stock | 148.72 | 148.75 | 148.62 | 148.72 | 33659.0 |
> showing 50 of 449,347 rows — these rows as CSV