PREVIEW / stock_30min / 2022-03-30
file: by_date/stock_30min/2022/2022-03-30.parquet size: 2.2 MB rows: 108,371 symbols: 2,471
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-30 04:00:00 | AAPL | Stock | 178.5 | 178.5 | 177.7 | 177.72 | 12631.0 |
| 2022-03-30 04:30:00 | AAPL | Stock | 177.85 | 177.86 | 177.71 | 177.73 | 7600.0 |
| 2022-03-30 05:00:00 | AAPL | Stock | 177.75 | 178.07 | 177.74 | 177.91 | 27958.0 |
| 2022-03-30 05:30:00 | AAPL | Stock | 177.98 | 178.06 | 177.86 | 178.0 | 6892.0 |
| 2022-03-30 06:00:00 | AAPL | Stock | 177.82 | 177.9 | 177.66 | 177.8 | 11437.0 |
| 2022-03-30 06:30:00 | AAPL | Stock | 177.86 | 178.08 | 177.76 | 177.83 | 10036.0 |
| 2022-03-30 07:00:00 | AAPL | Stock | 177.86 | 178.33 | 177.8 | 178.26 | 85054.0 |
| 2022-03-30 07:30:00 | AAPL | Stock | 178.25 | 178.34 | 178.19 | 178.28 | 26845.0 |
| 2022-03-30 08:00:00 | AAPL | Stock | 178.32 | 178.52 | 177.47 | 177.6 | 376255.0 |
| 2022-03-30 08:30:00 | AAPL | Stock | 177.6 | 178.07 | 177.5999 | 178.03 | 209973.0 |
| 2022-03-30 09:00:00 | AAPL | Stock | 178.07 | 178.7 | 177.73 | 178.55 | 583041.0 |
| 2022-03-30 09:30:00 | AAPL | Stock | 178.55 | 179.61 | 178.2 | 178.74 | 12489995.0 |
| 2022-03-30 10:00:00 | AAPL | Stock | 178.75 | 179.5298 | 178.53 | 178.905 | 6965692.0 |
| 2022-03-30 10:30:00 | AAPL | Stock | 178.9081 | 179.025 | 177.84 | 177.9128 | 4883049.0 |
| 2022-03-30 11:00:00 | AAPL | Stock | 177.92 | 178.01 | 177.4686 | 177.65 | 5142488.0 |
| 2022-03-30 11:30:00 | AAPL | Stock | 177.65 | 178.18 | 177.56 | 177.8 | 3775030.0 |
| 2022-03-30 12:00:00 | AAPL | Stock | 177.79 | 178.06 | 177.5 | 177.7612 | 3563765.0 |
| 2022-03-30 12:30:00 | AAPL | Stock | 177.77 | 178.47 | 177.66 | 178.395 | 2992332.0 |
| 2022-03-30 13:00:00 | AAPL | Stock | 178.39 | 178.46 | 178.05 | 178.2 | 2815772.0 |
| 2022-03-30 13:30:00 | AAPL | Stock | 178.2 | 179.35 | 178.06 | 178.15 | 5223012.0 |
| 2022-03-30 14:00:00 | AAPL | Stock | 178.15 | 178.48 | 177.95 | 178.01 | 2912655.0 |
| 2022-03-30 14:30:00 | AAPL | Stock | 178.0 | 178.32 | 177.62 | 177.67 | 2857079.0 |
| 2022-03-30 15:00:00 | AAPL | Stock | 177.665 | 177.71 | 176.7 | 177.1925 | 4898441.0 |
| 2022-03-30 15:30:00 | AAPL | Stock | 177.19 | 177.79 | 176.96 | 177.725 | 8367150.0 |
| 2022-03-30 16:00:00 | AAPL | Stock | 177.78 | 177.99 | 177.42 | 177.88 | 8261404.0 |
| 2022-03-30 16:30:00 | AAPL | Stock | 177.88 | 177.97 | 177.73 | 177.91 | 61853.0 |
| 2022-03-30 17:00:00 | AAPL | Stock | 177.9 | 177.99 | 177.9 | 177.93 | 24079.0 |
| 2022-03-30 17:30:00 | AAPL | Stock | 177.93 | 177.97 | 177.89 | 177.94 | 21084.0 |
| 2022-03-30 18:00:00 | AAPL | Stock | 177.94 | 177.94 | 177.87 | 177.9001 | 9554.0 |
| 2022-03-30 18:30:00 | AAPL | Stock | 177.9 | 177.99 | 177.8701 | 177.99 | 28150.0 |
| 2022-03-30 19:00:00 | AAPL | Stock | 177.99 | 178.05 | 177.96 | 177.99 | 15314.0 |
| 2022-03-30 19:30:00 | AAPL | Stock | 178.0 | 178.05 | 177.88 | 178.02 | 21041.0 |
| 2022-03-30 04:00:00 | MSFT | Stock | 314.89 | 315.0 | 313.9 | 314.03 | 5486.0 |
| 2022-03-30 04:30:00 | MSFT | Stock | 313.98 | 313.98 | 313.67 | 313.68 | 2692.0 |
| 2022-03-30 05:00:00 | MSFT | Stock | 313.85 | 313.93 | 313.7 | 313.76 | 2071.0 |
| 2022-03-30 05:30:00 | MSFT | Stock | 313.98 | 314.0 | 313.98 | 314.0 | 2252.0 |
| 2022-03-30 06:00:00 | MSFT | Stock | 313.8 | 313.8 | 313.15 | 313.54 | 3162.0 |
| 2022-03-30 06:30:00 | MSFT | Stock | 313.55 | 313.55 | 313.55 | 313.55 | 303.0 |
| 2022-03-30 07:00:00 | MSFT | Stock | 313.9 | 314.3 | 313.8 | 314.3 | 3853.0 |
| 2022-03-30 07:30:00 | MSFT | Stock | 314.28 | 314.4 | 314.19 | 314.23 | 2488.0 |
| 2022-03-30 08:00:00 | MSFT | Stock | 314.38 | 315.0 | 312.55 | 312.55 | 31498.0 |
| 2022-03-30 08:30:00 | MSFT | Stock | 312.88 | 313.58 | 312.88 | 313.0 | 9784.0 |
| 2022-03-30 09:00:00 | MSFT | Stock | 313.0 | 313.69 | 312.7 | 313.55 | 10964.0 |
| 2022-03-30 09:30:00 | MSFT | Stock | 313.71 | 314.96 | 312.8527 | 312.92 | 1953837.0 |
| 2022-03-30 10:00:00 | MSFT | Stock | 312.97 | 314.125 | 312.23 | 313.22 | 1476873.0 |
| 2022-03-30 10:30:00 | MSFT | Stock | 313.24 | 313.77 | 312.52 | 312.61 | 1005406.0 |
| 2022-03-30 11:00:00 | MSFT | Stock | 312.63 | 312.7258 | 311.58 | 311.97 | 939690.0 |
| 2022-03-30 11:30:00 | MSFT | Stock | 312.01 | 313.69 | 311.855 | 313.69 | 736528.0 |
| 2022-03-30 12:00:00 | MSFT | Stock | 313.67 | 314.84 | 313.36 | 314.73 | 1121267.0 |
| 2022-03-30 12:30:00 | MSFT | Stock | 314.735 | 315.8 | 314.43 | 315.66 | 1164277.0 |
> showing 50 of 108,371 rows — these rows as CSV