PREVIEW / stock_5min / 2021-08-31
file: by_date/stock_5min/2021/2021-08-31.parquet size: 7.4 MB rows: 454,810 symbols: 2,773
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-08-31 04:00:00 | AAPL | Stock | 153.28 | 153.6 | 153.15 | 153.6 | 4038.0 |
| 2021-08-31 04:05:00 | AAPL | Stock | 153.6 | 153.6 | 153.51 | 153.55 | 1977.0 |
| 2021-08-31 04:10:00 | AAPL | Stock | 153.61 | 153.61 | 153.51 | 153.55 | 5465.0 |
| 2021-08-31 04:15:00 | AAPL | Stock | 153.58 | 153.64 | 153.58 | 153.59 | 1440.0 |
| 2021-08-31 04:20:00 | AAPL | Stock | 153.59 | 153.6 | 153.59 | 153.6 | 1024.0 |
| 2021-08-31 04:25:00 | AAPL | Stock | 153.59 | 153.6 | 153.59 | 153.6 | 2075.0 |
| 2021-08-31 04:30:00 | AAPL | Stock | 153.61 | 153.7 | 153.6 | 153.65 | 14127.0 |
| 2021-08-31 04:35:00 | AAPL | Stock | 153.68 | 153.68 | 153.6 | 153.6 | 2226.0 |
| 2021-08-31 04:40:00 | AAPL | Stock | 153.58 | 153.58 | 153.5 | 153.5 | 1796.0 |
| 2021-08-31 04:45:00 | AAPL | Stock | 153.54 | 153.54 | 153.45 | 153.45 | 800.0 |
| 2021-08-31 04:50:00 | AAPL | Stock | 153.4 | 153.45 | 153.4 | 153.4 | 2223.0 |
| 2021-08-31 04:55:00 | AAPL | Stock | 153.4 | 153.44 | 153.4 | 153.44 | 300.0 |
| 2021-08-31 05:00:00 | AAPL | Stock | 153.5 | 153.5 | 153.5 | 153.5 | 100.0 |
| 2021-08-31 05:10:00 | AAPL | Stock | 153.45 | 153.45 | 153.13 | 153.32 | 6139.0 |
| 2021-08-31 05:15:00 | AAPL | Stock | 153.42 | 153.52 | 153.42 | 153.52 | 1863.0 |
| 2021-08-31 05:20:00 | AAPL | Stock | 153.46 | 153.46 | 153.46 | 153.46 | 499.0 |
| 2021-08-31 05:25:00 | AAPL | Stock | 153.46 | 153.46 | 153.37 | 153.37 | 1018.0 |
| 2021-08-31 05:30:00 | AAPL | Stock | 153.35 | 153.35 | 153.35 | 153.35 | 132.0 |
| 2021-08-31 05:35:00 | AAPL | Stock | 153.3 | 153.3 | 153.25 | 153.25 | 4645.0 |
| 2021-08-31 05:45:00 | AAPL | Stock | 153.25 | 153.25 | 153.2 | 153.22 | 1149.0 |
| 2021-08-31 05:50:00 | AAPL | Stock | 153.24 | 153.24 | 153.13 | 153.22 | 4859.0 |
| 2021-08-31 05:55:00 | AAPL | Stock | 153.12 | 153.12 | 153.07 | 153.07 | 1770.0 |
| 2021-08-31 06:00:00 | AAPL | Stock | 153.06 | 153.14 | 153.0 | 153.05 | 2637.0 |
| 2021-08-31 06:05:00 | AAPL | Stock | 153.03 | 153.14 | 153.03 | 153.07 | 1228.0 |
| 2021-08-31 06:10:00 | AAPL | Stock | 153.13 | 153.13 | 152.94 | 152.95 | 2321.0 |
| 2021-08-31 06:15:00 | AAPL | Stock | 152.95 | 152.97 | 152.81 | 152.94 | 2888.0 |
| 2021-08-31 06:20:00 | AAPL | Stock | 152.81 | 152.81 | 152.7 | 152.7 | 8439.0 |
| 2021-08-31 06:25:00 | AAPL | Stock | 152.7 | 152.78 | 152.68 | 152.78 | 5225.0 |
| 2021-08-31 06:30:00 | AAPL | Stock | 152.78 | 152.9 | 152.78 | 152.9 | 3092.0 |
| 2021-08-31 06:35:00 | AAPL | Stock | 152.87 | 152.9 | 152.64 | 152.7 | 4438.0 |
| 2021-08-31 06:40:00 | AAPL | Stock | 152.83 | 152.9 | 152.83 | 152.85 | 4831.0 |
| 2021-08-31 06:45:00 | AAPL | Stock | 152.86 | 152.86 | 152.61 | 152.7 | 4530.0 |
| 2021-08-31 06:50:00 | AAPL | Stock | 152.61 | 152.7 | 152.57 | 152.68 | 1744.0 |
| 2021-08-31 06:55:00 | AAPL | Stock | 152.66 | 152.72 | 152.57 | 152.65 | 6157.0 |
| 2021-08-31 07:00:00 | AAPL | Stock | 152.71 | 152.8 | 152.56 | 152.74 | 43637.0 |
| 2021-08-31 07:05:00 | AAPL | Stock | 152.75 | 152.83 | 152.7 | 152.82 | 27339.0 |
| 2021-08-31 07:10:00 | AAPL | Stock | 152.83 | 152.83 | 152.68 | 152.69 | 7923.0 |
| 2021-08-31 07:15:00 | AAPL | Stock | 152.69 | 152.83 | 152.68 | 152.83 | 14903.0 |
| 2021-08-31 07:20:00 | AAPL | Stock | 152.8 | 152.9 | 152.71 | 152.77 | 19451.0 |
| 2021-08-31 07:25:00 | AAPL | Stock | 152.76 | 152.82 | 152.63 | 152.8 | 36968.0 |
| 2021-08-31 07:30:00 | AAPL | Stock | 152.79 | 152.82 | 152.62 | 152.66 | 29919.0 |
| 2021-08-31 07:35:00 | AAPL | Stock | 152.69 | 152.7 | 152.67 | 152.7 | 7589.0 |
| 2021-08-31 07:40:00 | AAPL | Stock | 152.69 | 152.82 | 152.63 | 152.79 | 16452.0 |
| 2021-08-31 07:45:00 | AAPL | Stock | 152.78 | 152.8 | 152.7 | 152.71 | 10220.0 |
| 2021-08-31 07:50:00 | AAPL | Stock | 152.72 | 152.81 | 152.69 | 152.7 | 13405.0 |
| 2021-08-31 07:55:00 | AAPL | Stock | 152.73 | 152.76 | 152.69 | 152.71 | 7563.0 |
| 2021-08-31 08:00:00 | AAPL | Stock | 152.8 | 152.89 | 152.56 | 152.64 | 88448.0 |
| 2021-08-31 08:05:00 | AAPL | Stock | 152.63 | 152.69 | 152.61 | 152.6584 | 17683.0 |
| 2021-08-31 08:10:00 | AAPL | Stock | 152.67 | 152.8 | 152.64 | 152.7 | 28283.0 |
| 2021-08-31 08:15:00 | AAPL | Stock | 152.67 | 152.7 | 152.66 | 152.68 | 19915.0 |
> showing 50 of 454,810 rows — these rows as CSV