PREVIEW / stock_30min / 2021-04-12
file: by_date/stock_30min/2021/2021-04-12.parquet size: 2.2 MB rows: 109,573 symbols: 2,924
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-04-12 04:00:00 | AAPL | Stock | 132.99 | 132.99 | 132.58 | 132.61 | 16959.0 |
| 2021-04-12 04:30:00 | AAPL | Stock | 132.61 | 132.71 | 132.56 | 132.6 | 22540.0 |
| 2021-04-12 05:00:00 | AAPL | Stock | 132.6 | 132.66 | 132.57 | 132.66 | 5305.0 |
| 2021-04-12 05:30:00 | AAPL | Stock | 132.63 | 132.69 | 132.6 | 132.65 | 9017.0 |
| 2021-04-12 06:00:00 | AAPL | Stock | 132.66 | 132.68 | 132.4 | 132.4 | 22265.0 |
| 2021-04-12 06:30:00 | AAPL | Stock | 132.4 | 132.4 | 132.06 | 132.18 | 22905.0 |
| 2021-04-12 07:00:00 | AAPL | Stock | 132.27 | 132.71 | 132.11 | 132.61 | 85735.0 |
| 2021-04-12 07:30:00 | AAPL | Stock | 132.65 | 132.88 | 132.43 | 132.68 | 117304.0 |
| 2021-04-12 08:00:00 | AAPL | Stock | 132.3299 | 132.86 | 132.15 | 132.38 | 246354.0 |
| 2021-04-12 08:30:00 | AAPL | Stock | 132.37 | 132.58 | 132.37 | 132.53 | 163345.0 |
| 2021-04-12 09:00:00 | AAPL | Stock | 132.52 | 132.73 | 132.22 | 132.58 | 202118.0 |
| 2021-04-12 09:30:00 | AAPL | Stock | 132.57 | 132.85 | 131.37 | 131.65 | 12351684.0 |
| 2021-04-12 10:00:00 | AAPL | Stock | 131.64 | 132.235 | 131.55 | 131.8801 | 5955473.0 |
| 2021-04-12 10:30:00 | AAPL | Stock | 131.89 | 131.93 | 131.05 | 131.175 | 5590755.0 |
| 2021-04-12 11:00:00 | AAPL | Stock | 131.18 | 131.43 | 131.08 | 131.2 | 4353464.0 |
| 2021-04-12 11:30:00 | AAPL | Stock | 131.21 | 131.26 | 130.63 | 130.98 | 5126589.0 |
| 2021-04-12 12:00:00 | AAPL | Stock | 130.98 | 131.3 | 130.84 | 131.2782 | 3771413.0 |
| 2021-04-12 12:30:00 | AAPL | Stock | 131.2701 | 131.86 | 131.2 | 131.85 | 3497791.0 |
| 2021-04-12 13:00:00 | AAPL | Stock | 131.84 | 132.27 | 131.71 | 131.79 | 4399718.0 |
| 2021-04-12 13:30:00 | AAPL | Stock | 131.79 | 131.94 | 131.45 | 131.5089 | 3205194.0 |
| 2021-04-12 14:00:00 | AAPL | Stock | 131.5 | 131.83 | 131.4401 | 131.535 | 2968646.0 |
| 2021-04-12 14:30:00 | AAPL | Stock | 131.535 | 131.6099 | 130.92 | 131.015 | 3343445.0 |
| 2021-04-12 15:00:00 | AAPL | Stock | 131.01 | 131.5 | 130.85 | 131.31 | 4407752.0 |
| 2021-04-12 15:30:00 | AAPL | Stock | 131.3093 | 131.53 | 131.125 | 131.26 | 8199999.0 |
| 2021-04-12 16:00:00 | AAPL | Stock | 131.26 | 131.46 | 131.21 | 131.2401 | 10905602.0 |
| 2021-04-12 16:30:00 | AAPL | Stock | 131.24 | 131.34 | 131.24 | 131.32 | 38422.0 |
| 2021-04-12 17:00:00 | AAPL | Stock | 131.32 | 131.35 | 131.28 | 131.32 | 26622.0 |
| 2021-04-12 17:30:00 | AAPL | Stock | 131.34 | 131.35 | 131.22 | 131.23 | 35421.0 |
| 2021-04-12 18:00:00 | AAPL | Stock | 131.24 | 131.39 | 131.22 | 131.28 | 22862.0 |
| 2021-04-12 18:30:00 | AAPL | Stock | 131.29 | 131.3 | 131.24 | 131.26 | 17321.0 |
| 2021-04-12 19:00:00 | AAPL | Stock | 131.25 | 131.36 | 131.22 | 131.31 | 24106.0 |
| 2021-04-12 19:30:00 | AAPL | Stock | 131.32 | 131.32 | 131.03 | 131.03 | 64808.0 |
| 2021-04-12 04:00:00 | MSFT | Stock | 256.16 | 256.48 | 256.0 | 256.4 | 2199.0 |
| 2021-04-12 04:30:00 | MSFT | Stock | 256.27 | 256.5 | 256.2 | 256.5 | 949.0 |
| 2021-04-12 05:00:00 | MSFT | Stock | 256.63 | 256.67 | 256.5 | 256.67 | 730.0 |
| 2021-04-12 05:30:00 | MSFT | Stock | 256.68 | 256.68 | 256.5 | 256.5 | 200.0 |
| 2021-04-12 06:00:00 | MSFT | Stock | 256.68 | 256.7 | 256.05 | 256.08 | 3412.0 |
| 2021-04-12 06:30:00 | MSFT | Stock | 256.07 | 256.2 | 255.29 | 255.41 | 4365.0 |
| 2021-04-12 07:00:00 | MSFT | Stock | 255.5 | 255.95 | 255.35 | 255.91 | 5897.0 |
| 2021-04-12 07:30:00 | MSFT | Stock | 255.91 | 255.98 | 255.25 | 255.25 | 9959.0 |
| 2021-04-12 08:00:00 | MSFT | Stock | 255.9999 | 255.9999 | 255.01 | 255.2 | 13710.0 |
| 2021-04-12 08:30:00 | MSFT | Stock | 255.35 | 256.5 | 255.35 | 255.87 | 22501.0 |
| 2021-04-12 09:00:00 | MSFT | Stock | 255.79 | 256.5 | 254.62 | 254.78 | 108446.0 |
| 2021-04-12 09:30:00 | MSFT | Stock | 254.71 | 256.99 | 254.62 | 255.02 | 2823805.0 |
| 2021-04-12 10:00:00 | MSFT | Stock | 255.02 | 256.2 | 254.64 | 255.43 | 1206106.0 |
| 2021-04-12 10:30:00 | MSFT | Stock | 255.45 | 256.23 | 255.09 | 255.97 | 962962.0 |
| 2021-04-12 11:00:00 | MSFT | Stock | 255.98 | 257.255 | 255.97 | 256.59 | 1280858.0 |
| 2021-04-12 11:30:00 | MSFT | Stock | 256.6 | 256.8517 | 256.22 | 256.85 | 835103.0 |
| 2021-04-12 12:00:00 | MSFT | Stock | 256.85 | 257.49 | 256.59 | 257.23 | 865466.0 |
| 2021-04-12 12:30:00 | MSFT | Stock | 257.22 | 257.59 | 257.1233 | 257.37 | 667681.0 |
> showing 50 of 109,573 rows — these rows as CSV