PREVIEW / stock_30min / 2022-02-25
file: by_date/stock_30min/2022/2022-02-25.parquet size: 2.2 MB rows: 106,796 symbols: 2,542
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-02-25 04:00:00 | AAPL | Stock | 162.79 | 162.79 | 160.53 | 160.8 | 23933.0 |
| 2022-02-25 04:30:00 | AAPL | Stock | 160.83 | 161.88 | 160.81 | 161.82 | 7373.0 |
| 2022-02-25 05:00:00 | AAPL | Stock | 161.85 | 162.28 | 161.8 | 162.2 | 15899.0 |
| 2022-02-25 05:30:00 | AAPL | Stock | 162.04 | 162.1 | 161.74 | 162.07 | 3725.0 |
| 2022-02-25 06:00:00 | AAPL | Stock | 162.01 | 162.01 | 161.33 | 161.55 | 8102.0 |
| 2022-02-25 06:30:00 | AAPL | Stock | 161.71 | 162.71 | 161.62 | 162.2 | 31014.0 |
| 2022-02-25 07:00:00 | AAPL | Stock | 162.1 | 162.65 | 162.0 | 162.45 | 46662.0 |
| 2022-02-25 07:30:00 | AAPL | Stock | 162.45 | 163.8 | 162.05 | 163.49 | 68609.0 |
| 2022-02-25 08:00:00 | AAPL | Stock | 162.41 | 164.3 | 161.0 | 164.05 | 434873.0 |
| 2022-02-25 08:30:00 | AAPL | Stock | 164.05 | 164.74 | 163.99 | 164.13 | 340214.0 |
| 2022-02-25 09:00:00 | AAPL | Stock | 164.04 | 164.35 | 163.54 | 163.77 | 296639.0 |
| 2022-02-25 09:30:00 | AAPL | Stock | 163.83 | 164.0 | 161.12 | 161.26 | 10065553.0 |
| 2022-02-25 10:00:00 | AAPL | Stock | 161.24 | 162.34 | 160.8738 | 162.14 | 6609351.0 |
| 2022-02-25 10:30:00 | AAPL | Stock | 162.13 | 163.54 | 161.6 | 163.155 | 6200565.0 |
| 2022-02-25 11:00:00 | AAPL | Stock | 163.15 | 164.51 | 162.82 | 164.03 | 6044075.0 |
| 2022-02-25 11:30:00 | AAPL | Stock | 164.04 | 164.65 | 163.86 | 164.5725 | 4725062.0 |
| 2022-02-25 12:00:00 | AAPL | Stock | 164.58 | 164.84 | 164.01 | 164.3 | 3954347.0 |
| 2022-02-25 12:30:00 | AAPL | Stock | 164.3 | 164.82 | 163.85 | 164.075 | 3962583.0 |
| 2022-02-25 13:00:00 | AAPL | Stock | 164.075 | 164.62 | 163.48 | 164.485 | 4562982.0 |
| 2022-02-25 13:30:00 | AAPL | Stock | 164.49 | 165.01 | 164.3 | 164.55 | 3762136.0 |
| 2022-02-25 14:00:00 | AAPL | Stock | 164.555 | 165.01 | 164.14 | 164.78 | 3490903.0 |
| 2022-02-25 14:30:00 | AAPL | Stock | 164.78 | 165.0 | 164.02 | 164.425 | 3896631.0 |
| 2022-02-25 15:00:00 | AAPL | Stock | 164.43 | 164.99 | 163.98 | 164.675 | 4449568.0 |
| 2022-02-25 15:30:00 | AAPL | Stock | 164.68 | 165.12 | 164.45 | 164.87 | 8713052.0 |
| 2022-02-25 16:00:00 | AAPL | Stock | 164.85 | 164.96 | 164.7 | 164.9 | 6436904.0 |
| 2022-02-25 16:30:00 | AAPL | Stock | 164.94 | 165.0 | 164.85 | 164.88 | 58533.0 |
| 2022-02-25 17:00:00 | AAPL | Stock | 164.89 | 164.89 | 164.42 | 164.66 | 83250.0 |
| 2022-02-25 17:30:00 | AAPL | Stock | 164.56 | 164.71 | 164.55 | 164.55 | 24901.0 |
| 2022-02-25 18:00:00 | AAPL | Stock | 164.55 | 164.6 | 164.39 | 164.4 | 22080.0 |
| 2022-02-25 18:30:00 | AAPL | Stock | 164.4 | 164.43 | 164.33 | 164.4 | 18612.0 |
| 2022-02-25 19:00:00 | AAPL | Stock | 164.4 | 164.45 | 164.21 | 164.21 | 19941.0 |
| 2022-02-25 19:30:00 | AAPL | Stock | 164.22 | 164.41 | 164.15 | 164.34 | 28300.0 |
| 2022-02-25 04:00:00 | MSFT | Stock | 291.67 | 292.37 | 290.7 | 290.7 | 6355.0 |
| 2022-02-25 04:30:00 | MSFT | Stock | 290.8 | 293.0 | 290.8 | 293.0 | 3660.0 |
| 2022-02-25 05:00:00 | MSFT | Stock | 292.2 | 293.93 | 292.2 | 293.06 | 3826.0 |
| 2022-02-25 05:30:00 | MSFT | Stock | 293.0 | 293.0 | 292.72 | 293.0 | 1147.0 |
| 2022-02-25 06:00:00 | MSFT | Stock | 293.0 | 293.0 | 291.45 | 292.44 | 901.0 |
| 2022-02-25 06:30:00 | MSFT | Stock | 292.2 | 293.62 | 291.75 | 292.5 | 3572.0 |
| 2022-02-25 07:00:00 | MSFT | Stock | 292.9 | 293.97 | 292.77 | 293.75 | 10214.0 |
| 2022-02-25 07:30:00 | MSFT | Stock | 293.35 | 296.07 | 291.73 | 295.49 | 16917.0 |
| 2022-02-25 08:00:00 | MSFT | Stock | 293.0001 | 296.92 | 293.0 | 296.5 | 38953.0 |
| 2022-02-25 08:30:00 | MSFT | Stock | 296.54 | 297.5 | 295.3 | 295.7 | 33231.0 |
| 2022-02-25 09:00:00 | MSFT | Stock | 295.65 | 296.19 | 294.1811 | 295.01 | 84126.0 |
| 2022-02-25 09:30:00 | MSFT | Stock | 295.0 | 295.5 | 291.655 | 292.51 | 3084036.0 |
| 2022-02-25 10:00:00 | MSFT | Stock | 292.44 | 295.82 | 291.8 | 295.545 | 1806833.0 |
| 2022-02-25 10:30:00 | MSFT | Stock | 295.52 | 296.1 | 293.66 | 295.07 | 1494540.0 |
| 2022-02-25 11:00:00 | MSFT | Stock | 295.07 | 296.62 | 294.2099 | 295.89 | 1339452.0 |
| 2022-02-25 11:30:00 | MSFT | Stock | 295.91 | 297.17 | 295.23 | 297.1 | 1122748.0 |
| 2022-02-25 12:00:00 | MSFT | Stock | 297.1 | 297.36 | 295.66 | 296.98 | 1073312.0 |
| 2022-02-25 12:30:00 | MSFT | Stock | 297.03 | 297.4 | 295.07 | 295.28 | 1001663.0 |
> showing 50 of 106,796 rows — these rows as CSV