PREVIEW / stock_30min / 2021-10-12
file: by_date/stock_30min/2021/2021-10-12.parquet size: 2.1 MB rows: 105,872 symbols: 2,670
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-10-12 04:00:00 | AAPL | Stock | 142.3 | 142.5 | 142.23 | 142.27 | 37891.0 |
| 2021-10-12 04:30:00 | AAPL | Stock | 142.26 | 142.35 | 142.2 | 142.35 | 76717.0 |
| 2021-10-12 05:00:00 | AAPL | Stock | 142.46 | 142.8 | 142.4 | 142.74 | 14813.0 |
| 2021-10-12 05:30:00 | AAPL | Stock | 142.76 | 142.77 | 142.67 | 142.7 | 6135.0 |
| 2021-10-12 06:00:00 | AAPL | Stock | 142.75 | 142.85 | 142.66 | 142.79 | 3477.0 |
| 2021-10-12 06:30:00 | AAPL | Stock | 142.8 | 143.0 | 142.79 | 143.0 | 8658.0 |
| 2021-10-12 07:00:00 | AAPL | Stock | 143.01 | 143.22 | 142.9 | 143.18 | 69572.0 |
| 2021-10-12 07:30:00 | AAPL | Stock | 143.16 | 143.2 | 142.9 | 143.0 | 64295.0 |
| 2021-10-12 08:00:00 | AAPL | Stock | 143.02 | 143.44 | 142.9 | 143.41 | 284916.0 |
| 2021-10-12 08:30:00 | AAPL | Stock | 143.37 | 143.37 | 143.0 | 143.21 | 99748.0 |
| 2021-10-12 09:00:00 | AAPL | Stock | 143.18 | 143.45 | 143.17 | 143.29 | 184951.0 |
| 2021-10-12 09:30:00 | AAPL | Stock | 143.23 | 143.25 | 141.885 | 141.885 | 8550871.0 |
| 2021-10-12 10:00:00 | AAPL | Stock | 141.885 | 142.29 | 141.54 | 141.79 | 5228656.0 |
| 2021-10-12 10:30:00 | AAPL | Stock | 141.79 | 141.84 | 141.42 | 141.53 | 4211281.0 |
| 2021-10-12 11:00:00 | AAPL | Stock | 141.54 | 142.19 | 141.54 | 142.0 | 3213790.0 |
| 2021-10-12 11:30:00 | AAPL | Stock | 142.01 | 142.31 | 141.7501 | 142.3 | 2802955.0 |
| 2021-10-12 12:00:00 | AAPL | Stock | 142.3 | 142.98 | 142.26 | 142.495 | 5529866.0 |
| 2021-10-12 12:30:00 | AAPL | Stock | 142.5 | 142.5288 | 141.8 | 141.85 | 2276392.0 |
| 2021-10-12 13:00:00 | AAPL | Stock | 141.85 | 141.94 | 141.63 | 141.8812 | 2181724.0 |
| 2021-10-12 13:30:00 | AAPL | Stock | 141.885 | 142.11 | 141.82 | 141.8953 | 2010000.0 |
| 2021-10-12 14:00:00 | AAPL | Stock | 141.89 | 142.48 | 141.8001 | 142.25 | 2408306.0 |
| 2021-10-12 14:30:00 | AAPL | Stock | 142.26 | 142.28 | 141.91 | 141.96 | 2117360.0 |
| 2021-10-12 15:00:00 | AAPL | Stock | 141.97 | 142.005 | 141.69 | 141.81 | 2345455.0 |
| 2021-10-12 15:30:00 | AAPL | Stock | 141.8 | 141.8999 | 141.0401 | 141.46 | 7992941.0 |
| 2021-10-12 16:00:00 | AAPL | Stock | 141.46 | 141.56 | 139.27 | 139.48 | 12394868.0 |
| 2021-10-12 16:30:00 | AAPL | Stock | 139.47 | 141.51 | 139.4 | 139.91 | 277589.0 |
| 2021-10-12 17:00:00 | AAPL | Stock | 139.91 | 139.93 | 139.45 | 139.46 | 176520.0 |
| 2021-10-12 17:30:00 | AAPL | Stock | 139.45 | 139.55 | 139.36 | 139.4301 | 141518.0 |
| 2021-10-12 18:00:00 | AAPL | Stock | 139.41 | 139.58 | 139.38 | 139.58 | 73078.0 |
| 2021-10-12 18:30:00 | AAPL | Stock | 139.57 | 139.58 | 139.48 | 139.53 | 55157.0 |
| 2021-10-12 19:00:00 | AAPL | Stock | 139.55 | 139.68 | 139.53 | 139.6399 | 73049.0 |
| 2021-10-12 19:30:00 | AAPL | Stock | 139.62 | 139.65 | 139.5 | 139.63 | 76786.0 |
| 2021-10-12 04:00:00 | MSFT | Stock | 293.9 | 294.1 | 293.62 | 294.1 | 2652.0 |
| 2021-10-12 05:00:00 | MSFT | Stock | 294.49 | 294.88 | 294.49 | 294.83 | 449.0 |
| 2021-10-12 06:00:00 | MSFT | Stock | 294.71 | 294.71 | 294.71 | 294.71 | 299.0 |
| 2021-10-12 06:30:00 | MSFT | Stock | 294.54 | 295.3 | 294.52 | 295.3 | 3981.0 |
| 2021-10-12 07:00:00 | MSFT | Stock | 295.3 | 295.39 | 294.8 | 295.19 | 28040.0 |
| 2021-10-12 07:30:00 | MSFT | Stock | 295.23 | 295.28 | 294.63 | 294.85 | 4296.0 |
| 2021-10-12 08:00:00 | MSFT | Stock | 295.4742 | 296.0 | 294.72 | 296.0 | 21611.0 |
| 2021-10-12 08:30:00 | MSFT | Stock | 296.09 | 296.11 | 295.05 | 295.22 | 12668.0 |
| 2021-10-12 09:00:00 | MSFT | Stock | 295.22 | 295.82 | 295.22 | 295.49 | 28043.0 |
| 2021-10-12 09:30:00 | MSFT | Stock | 295.48 | 295.48 | 292.7 | 292.999 | 1633230.0 |
| 2021-10-12 10:00:00 | MSFT | Stock | 292.98 | 294.16 | 292.95 | 293.91 | 969564.0 |
| 2021-10-12 10:30:00 | MSFT | Stock | 293.9 | 293.93 | 292.79 | 292.9 | 781113.0 |
| 2021-10-12 11:00:00 | MSFT | Stock | 292.94 | 294.22 | 292.9 | 293.7 | 609784.0 |
| 2021-10-12 11:30:00 | MSFT | Stock | 293.69 | 294.2499 | 293.17 | 294.2201 | 488355.0 |
| 2021-10-12 12:00:00 | MSFT | Stock | 294.24 | 294.9 | 294.23 | 294.45 | 639179.0 |
| 2021-10-12 12:30:00 | MSFT | Stock | 294.385 | 294.48 | 293.76 | 293.95 | 409031.0 |
| 2021-10-12 13:00:00 | MSFT | Stock | 293.92 | 294.02 | 293.47 | 293.925 | 410388.0 |
| 2021-10-12 13:30:00 | MSFT | Stock | 293.88 | 294.145 | 293.57 | 293.66 | 417342.0 |
> showing 50 of 105,872 rows — these rows as CSV