PREVIEW / stock_30min / 2022-03-07
file: by_date/stock_30min/2022/2022-03-07.parquet size: 2.3 MB rows: 115,519 symbols: 2,565
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-07 04:00:00 | AAPL | Stock | 161.78 | 161.78 | 160.13 | 160.65 | 50521.0 |
| 2022-03-07 04:30:00 | AAPL | Stock | 160.64 | 160.64 | 159.71 | 160.09 | 34250.0 |
| 2022-03-07 05:00:00 | AAPL | Stock | 160.09 | 160.45 | 159.88 | 160.35 | 21646.0 |
| 2022-03-07 05:30:00 | AAPL | Stock | 160.29 | 160.35 | 160.0 | 160.0 | 9613.0 |
| 2022-03-07 06:00:00 | AAPL | Stock | 160.0 | 160.4 | 159.6 | 160.25 | 11135.0 |
| 2022-03-07 06:30:00 | AAPL | Stock | 160.25 | 160.8 | 160.25 | 160.74 | 9908.0 |
| 2022-03-07 07:00:00 | AAPL | Stock | 160.85 | 162.24 | 160.67 | 162.21 | 98817.0 |
| 2022-03-07 07:30:00 | AAPL | Stock | 162.15 | 162.3 | 161.86 | 161.86 | 57603.0 |
| 2022-03-07 08:00:00 | AAPL | Stock | 162.01 | 162.763 | 161.05 | 162.14 | 247664.0 |
| 2022-03-07 08:30:00 | AAPL | Stock | 162.2201 | 162.9 | 162.22 | 162.7024 | 113166.0 |
| 2022-03-07 09:00:00 | AAPL | Stock | 162.74 | 163.67 | 162.67 | 163.33 | 387251.0 |
| 2022-03-07 09:30:00 | AAPL | Stock | 163.34 | 165.02 | 162.58 | 162.65 | 10074415.0 |
| 2022-03-07 10:00:00 | AAPL | Stock | 162.65 | 162.94 | 161.5 | 161.53 | 5784701.0 |
| 2022-03-07 10:30:00 | AAPL | Stock | 161.54 | 162.5 | 161.38 | 162.37 | 4879863.0 |
| 2022-03-07 11:00:00 | AAPL | Stock | 162.37 | 163.5 | 162.27 | 163.18 | 4582874.0 |
| 2022-03-07 11:30:00 | AAPL | Stock | 163.18 | 164.0 | 162.91 | 163.0675 | 4695090.0 |
| 2022-03-07 12:00:00 | AAPL | Stock | 163.06 | 163.08 | 161.41 | 161.68 | 4560759.0 |
| 2022-03-07 12:30:00 | AAPL | Stock | 161.67 | 162.23 | 161.3157 | 161.57 | 3832033.0 |
| 2022-03-07 13:00:00 | AAPL | Stock | 161.56 | 162.19 | 160.9 | 161.0599 | 4153632.0 |
| 2022-03-07 13:30:00 | AAPL | Stock | 161.04 | 161.89 | 161.035 | 161.15 | 3326879.0 |
| 2022-03-07 14:00:00 | AAPL | Stock | 161.155 | 161.68 | 160.8 | 161.0501 | 3428346.0 |
| 2022-03-07 14:30:00 | AAPL | Stock | 161.07 | 161.17 | 160.19 | 160.4 | 3904711.0 |
| 2022-03-07 15:00:00 | AAPL | Stock | 160.41 | 160.585 | 159.75 | 160.36 | 5789726.0 |
| 2022-03-07 15:30:00 | AAPL | Stock | 160.34 | 160.38 | 159.04 | 159.31 | 10224336.0 |
| 2022-03-07 16:00:00 | AAPL | Stock | 159.31 | 159.52 | 158.49 | 158.82 | 11309603.0 |
| 2022-03-07 16:30:00 | AAPL | Stock | 158.88 | 159.3 | 158.54 | 158.58 | 140182.0 |
| 2022-03-07 17:00:00 | AAPL | Stock | 158.57 | 158.64 | 158.25 | 158.45 | 53692.0 |
| 2022-03-07 17:30:00 | AAPL | Stock | 158.4113 | 158.58 | 158.2703 | 158.35 | 44836.0 |
| 2022-03-07 18:00:00 | AAPL | Stock | 158.35 | 158.72 | 158.35 | 158.7 | 37188.0 |
| 2022-03-07 18:30:00 | AAPL | Stock | 158.7 | 158.7 | 158.02 | 158.36 | 30322.0 |
| 2022-03-07 19:00:00 | AAPL | Stock | 158.42 | 159.3 | 158.4 | 159.13 | 60933.0 |
| 2022-03-07 19:30:00 | AAPL | Stock | 159.12 | 159.2 | 158.62 | 158.75 | 58649.0 |
| 2022-03-07 04:00:00 | MSFT | Stock | 285.25 | 287.0 | 284.18 | 285.6 | 9378.0 |
| 2022-03-07 04:30:00 | MSFT | Stock | 284.67 | 285.0 | 284.14 | 284.85 | 4620.0 |
| 2022-03-07 05:00:00 | MSFT | Stock | 284.71 | 285.27 | 284.37 | 284.69 | 5444.0 |
| 2022-03-07 05:30:00 | MSFT | Stock | 284.8 | 285.0 | 284.3 | 284.3 | 982.0 |
| 2022-03-07 06:00:00 | MSFT | Stock | 284.46 | 284.97 | 284.0 | 284.97 | 3499.0 |
| 2022-03-07 06:30:00 | MSFT | Stock | 284.98 | 285.49 | 284.7 | 285.49 | 1281.0 |
| 2022-03-07 07:00:00 | MSFT | Stock | 285.49 | 287.44 | 285.0 | 287.03 | 22999.0 |
| 2022-03-07 07:30:00 | MSFT | Stock | 287.6 | 287.69 | 286.76 | 286.83 | 8366.0 |
| 2022-03-07 08:00:00 | MSFT | Stock | 287.2 | 287.74 | 284.28 | 287.05 | 42735.0 |
| 2022-03-07 08:30:00 | MSFT | Stock | 287.5958 | 288.939 | 285.1 | 288.63 | 22185.0 |
| 2022-03-07 09:00:00 | MSFT | Stock | 288.3334 | 289.62 | 287.65 | 288.81 | 55437.0 |
| 2022-03-07 09:30:00 | MSFT | Stock | 288.67 | 289.69 | 283.36 | 283.6 | 3004705.0 |
| 2022-03-07 10:00:00 | MSFT | Stock | 283.51 | 283.76 | 280.19 | 280.23 | 2537317.0 |
| 2022-03-07 10:30:00 | MSFT | Stock | 280.23 | 280.649 | 279.0 | 280.2518 | 2914130.0 |
| 2022-03-07 11:00:00 | MSFT | Stock | 280.23 | 283.0 | 280.09 | 282.47 | 1682035.0 |
| 2022-03-07 11:30:00 | MSFT | Stock | 282.42 | 284.45 | 281.05 | 282.7165 | 1534713.0 |
| 2022-03-07 12:00:00 | MSFT | Stock | 282.71 | 282.97 | 281.39 | 281.8163 | 1250450.0 |
| 2022-03-07 12:30:00 | MSFT | Stock | 281.8 | 282.27 | 280.9 | 281.6606 | 1355374.0 |
> showing 50 of 115,519 rows — these rows as CSV