PREVIEW / stock_5min / 2021-03-25
file: by_date/stock_5min/2021/2021-03-25.parquet size: 7.9 MB rows: 496,547 symbols: 2,921
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-03-25 04:00:00 | AAPL | Stock | 120.15 | 120.32 | 120.15 | 120.31 | 1174.0 |
| 2021-03-25 04:05:00 | AAPL | Stock | 120.36 | 120.6 | 120.36 | 120.6 | 2859.0 |
| 2021-03-25 04:10:00 | AAPL | Stock | 120.57 | 120.71 | 120.5 | 120.71 | 1969.0 |
| 2021-03-25 04:15:00 | AAPL | Stock | 120.8 | 120.82 | 120.8 | 120.81 | 1745.0 |
| 2021-03-25 04:20:00 | AAPL | Stock | 120.82 | 120.82 | 120.78 | 120.78 | 352.0 |
| 2021-03-25 04:25:00 | AAPL | Stock | 120.8 | 120.8 | 120.66 | 120.66 | 469.0 |
| 2021-03-25 04:30:00 | AAPL | Stock | 120.72 | 120.72 | 120.64 | 120.65 | 1064.0 |
| 2021-03-25 04:35:00 | AAPL | Stock | 120.61 | 120.64 | 120.61 | 120.64 | 480.0 |
| 2021-03-25 04:40:00 | AAPL | Stock | 120.62 | 120.62 | 120.62 | 120.62 | 225.0 |
| 2021-03-25 04:45:00 | AAPL | Stock | 120.61 | 120.61 | 120.55 | 120.55 | 712.0 |
| 2021-03-25 04:50:00 | AAPL | Stock | 120.63 | 120.67 | 120.55 | 120.55 | 1532.0 |
| 2021-03-25 04:55:00 | AAPL | Stock | 120.56 | 120.65 | 120.55 | 120.6 | 4268.0 |
| 2021-03-25 05:00:00 | AAPL | Stock | 120.5 | 120.5 | 120.5 | 120.5 | 190.0 |
| 2021-03-25 05:05:00 | AAPL | Stock | 120.36 | 120.37 | 120.3 | 120.3 | 460.0 |
| 2021-03-25 05:10:00 | AAPL | Stock | 120.39 | 120.4 | 120.39 | 120.4 | 611.0 |
| 2021-03-25 05:15:00 | AAPL | Stock | 120.4 | 120.4 | 120.3 | 120.4 | 1279.0 |
| 2021-03-25 05:20:00 | AAPL | Stock | 120.44 | 120.45 | 120.41 | 120.45 | 699.0 |
| 2021-03-25 05:25:00 | AAPL | Stock | 120.48 | 120.58 | 120.48 | 120.58 | 1115.0 |
| 2021-03-25 05:30:00 | AAPL | Stock | 120.59 | 120.59 | 120.59 | 120.59 | 401.0 |
| 2021-03-25 05:45:00 | AAPL | Stock | 120.41 | 120.43 | 120.41 | 120.42 | 1189.0 |
| 2021-03-25 05:50:00 | AAPL | Stock | 120.41 | 120.41 | 120.41 | 120.41 | 252.0 |
| 2021-03-25 06:00:00 | AAPL | Stock | 120.47 | 120.47 | 120.47 | 120.47 | 100.0 |
| 2021-03-25 06:05:00 | AAPL | Stock | 120.5 | 120.6 | 120.5 | 120.6 | 1652.0 |
| 2021-03-25 06:10:00 | AAPL | Stock | 120.55 | 120.55 | 120.55 | 120.55 | 100.0 |
| 2021-03-25 06:15:00 | AAPL | Stock | 120.65 | 120.7 | 120.65 | 120.7 | 624.0 |
| 2021-03-25 06:20:00 | AAPL | Stock | 120.62 | 120.66 | 120.62 | 120.66 | 829.0 |
| 2021-03-25 06:25:00 | AAPL | Stock | 120.79 | 120.83 | 120.76 | 120.83 | 2283.0 |
| 2021-03-25 06:30:00 | AAPL | Stock | 120.77 | 120.77 | 120.77 | 120.77 | 800.0 |
| 2021-03-25 06:35:00 | AAPL | Stock | 120.8 | 120.88 | 120.8 | 120.83 | 1242.0 |
| 2021-03-25 06:40:00 | AAPL | Stock | 120.83 | 120.83 | 120.65 | 120.65 | 1171.0 |
| 2021-03-25 06:55:00 | AAPL | Stock | 120.67 | 120.67 | 120.6 | 120.6 | 348.0 |
| 2021-03-25 07:00:00 | AAPL | Stock | 120.64 | 120.7 | 120.37 | 120.37 | 19913.0 |
| 2021-03-25 07:05:00 | AAPL | Stock | 120.34 | 120.45 | 120.3 | 120.38 | 16143.0 |
| 2021-03-25 07:10:00 | AAPL | Stock | 120.38 | 120.41 | 120.31 | 120.35 | 16997.0 |
| 2021-03-25 07:15:00 | AAPL | Stock | 120.35 | 120.36 | 120.29 | 120.29 | 7479.0 |
| 2021-03-25 07:20:00 | AAPL | Stock | 120.28 | 120.29 | 120.15 | 120.21 | 18822.0 |
| 2021-03-25 07:25:00 | AAPL | Stock | 120.2 | 120.22 | 120.1 | 120.17 | 15998.0 |
| 2021-03-25 07:30:00 | AAPL | Stock | 120.17 | 120.17 | 120.03 | 120.05 | 11143.0 |
| 2021-03-25 07:35:00 | AAPL | Stock | 120.05 | 120.05 | 119.75 | 119.81 | 27455.0 |
| 2021-03-25 07:40:00 | AAPL | Stock | 119.81 | 119.83 | 119.69 | 119.69 | 24887.0 |
| 2021-03-25 07:45:00 | AAPL | Stock | 119.68 | 119.75 | 119.53 | 119.53 | 33181.0 |
| 2021-03-25 07:50:00 | AAPL | Stock | 119.52 | 119.63 | 119.0 | 119.14 | 80571.0 |
| 2021-03-25 07:55:00 | AAPL | Stock | 119.13 | 119.27 | 119.01 | 119.1 | 45157.0 |
| 2021-03-25 08:00:00 | AAPL | Stock | 120.4499 | 120.68 | 119.0 | 119.3 | 239081.0 |
| 2021-03-25 08:05:00 | AAPL | Stock | 119.2701 | 119.39 | 119.1 | 119.27 | 34753.0 |
| 2021-03-25 08:10:00 | AAPL | Stock | 119.34 | 119.44 | 119.11 | 119.16 | 34551.0 |
| 2021-03-25 08:15:00 | AAPL | Stock | 119.18 | 119.27 | 119.0 | 119.02 | 91483.0 |
| 2021-03-25 08:20:00 | AAPL | Stock | 119.06 | 119.15 | 119.0 | 119.15 | 98962.0 |
| 2021-03-25 08:25:00 | AAPL | Stock | 119.11 | 119.2 | 119.0 | 119.16 | 50593.0 |
| 2021-03-25 08:30:00 | AAPL | Stock | 119.09 | 119.4 | 119.06 | 119.22 | 40594.0 |
> showing 50 of 496,547 rows — these rows as CSV