PREVIEW / stock_30min / 2022-02-09
file: by_date/stock_30min/2022/2022-02-09.parquet size: 2.2 MB rows: 109,181 symbols: 2,540
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-09 04:00:00 | AAPL | Stock | 175.35 | 176.0 | 175.35 | 175.78 | 10841.0 |
| 2022-02-09 04:30:00 | AAPL | Stock | 175.77 | 175.9 | 175.77 | 175.83 | 5543.0 |
| 2022-02-09 05:00:00 | AAPL | Stock | 175.79 | 176.1 | 175.79 | 176.0 | 10022.0 |
| 2022-02-09 05:30:00 | AAPL | Stock | 176.02 | 176.1 | 175.85 | 176.05 | 18522.0 |
| 2022-02-09 06:00:00 | AAPL | Stock | 176.01 | 176.1 | 175.93 | 176.07 | 9311.0 |
| 2022-02-09 06:30:00 | AAPL | Stock | 176.1 | 176.45 | 176.05 | 176.34 | 16321.0 |
| 2022-02-09 07:00:00 | AAPL | Stock | 176.3 | 176.66 | 175.95 | 176.48 | 88056.0 |
| 2022-02-09 07:30:00 | AAPL | Stock | 176.48 | 176.69 | 176.36 | 176.57 | 38173.0 |
| 2022-02-09 08:00:00 | AAPL | Stock | 176.3805 | 176.76 | 175.0 | 176.54 | 174165.0 |
| 2022-02-09 08:30:00 | AAPL | Stock | 176.53 | 176.53 | 176.3 | 176.3 | 105456.0 |
| 2022-02-09 09:00:00 | AAPL | Stock | 176.32 | 176.35 | 175.95 | 176.08 | 235023.0 |
| 2022-02-09 09:30:00 | AAPL | Stock | 176.11 | 176.65 | 175.0805 | 175.24 | 8950191.0 |
| 2022-02-09 10:00:00 | AAPL | Stock | 175.25 | 175.9099 | 175.18 | 175.72 | 4722568.0 |
| 2022-02-09 10:30:00 | AAPL | Stock | 175.72 | 176.1699 | 175.37 | 175.7838 | 3530636.0 |
| 2022-02-09 11:00:00 | AAPL | Stock | 175.7845 | 175.98 | 175.2 | 175.45 | 3491913.0 |
| 2022-02-09 11:30:00 | AAPL | Stock | 175.44 | 175.8099 | 175.22 | 175.4248 | 2768588.0 |
| 2022-02-09 12:00:00 | AAPL | Stock | 175.43 | 175.705 | 175.25 | 175.5612 | 2398304.0 |
| 2022-02-09 12:30:00 | AAPL | Stock | 175.57 | 175.88 | 175.43 | 175.815 | 2342892.0 |
| 2022-02-09 13:00:00 | AAPL | Stock | 175.82 | 175.92 | 175.57 | 175.62 | 1997807.0 |
| 2022-02-09 13:30:00 | AAPL | Stock | 175.62 | 175.83 | 175.435 | 175.6 | 2162847.0 |
| 2022-02-09 14:00:00 | AAPL | Stock | 175.6091 | 176.05 | 175.59 | 175.9101 | 2247168.0 |
| 2022-02-09 14:30:00 | AAPL | Stock | 175.92 | 176.12 | 175.62 | 175.67 | 2559662.0 |
| 2022-02-09 15:00:00 | AAPL | Stock | 175.67 | 175.68 | 174.9 | 175.591 | 3669391.0 |
| 2022-02-09 15:30:00 | AAPL | Stock | 175.59 | 176.33 | 175.505 | 176.28 | 8045343.0 |
| 2022-02-09 16:00:00 | AAPL | Stock | 176.27 | 176.48 | 175.3865 | 176.4 | 7376511.0 |
| 2022-02-09 16:30:00 | AAPL | Stock | 176.4 | 176.46 | 176.28 | 176.4499 | 57943.0 |
| 2022-02-09 17:00:00 | AAPL | Stock | 176.44 | 176.59 | 176.41 | 176.45 | 29093.0 |
| 2022-02-09 17:30:00 | AAPL | Stock | 176.41 | 176.5 | 176.28 | 176.4001 | 699518.0 |
| 2022-02-09 18:00:00 | AAPL | Stock | 176.4 | 176.45 | 176.3 | 176.3 | 6102.0 |
| 2022-02-09 18:30:00 | AAPL | Stock | 176.34 | 176.34 | 176.14 | 176.14 | 8869.0 |
| 2022-02-09 19:00:00 | AAPL | Stock | 176.14 | 176.23 | 176.11 | 176.12 | 10143.0 |
| 2022-02-09 19:30:00 | AAPL | Stock | 176.14 | 176.17 | 175.92 | 176.0 | 20098.0 |
| 2022-02-09 04:00:00 | MSFT | Stock | 307.01 | 307.56 | 306.84 | 307.2 | 4693.0 |
| 2022-02-09 04:30:00 | MSFT | Stock | 307.2 | 307.2 | 306.86 | 306.9 | 2630.0 |
| 2022-02-09 05:00:00 | MSFT | Stock | 307.0 | 307.39 | 307.0 | 307.3 | 2910.0 |
| 2022-02-09 05:30:00 | MSFT | Stock | 307.45 | 307.49 | 307.45 | 307.46 | 536.0 |
| 2022-02-09 06:00:00 | MSFT | Stock | 307.35 | 307.87 | 307.2 | 307.87 | 2162.0 |
| 2022-02-09 06:30:00 | MSFT | Stock | 307.84 | 307.95 | 307.7 | 307.95 | 3407.0 |
| 2022-02-09 07:00:00 | MSFT | Stock | 307.94 | 308.94 | 307.68 | 308.5 | 24589.0 |
| 2022-02-09 07:30:00 | MSFT | Stock | 308.53 | 309.0 | 308.36 | 308.8 | 13678.0 |
| 2022-02-09 08:00:00 | MSFT | Stock | 308.5 | 309.47 | 307.61 | 308.89 | 31606.0 |
| 2022-02-09 08:30:00 | MSFT | Stock | 309.0 | 309.2 | 308.4 | 308.4 | 14710.0 |
| 2022-02-09 09:00:00 | MSFT | Stock | 308.5 | 310.0 | 308.4 | 309.91 | 69441.0 |
| 2022-02-09 09:30:00 | MSFT | Stock | 309.91 | 311.93 | 308.72 | 309.275 | 3644170.0 |
| 2022-02-09 10:00:00 | MSFT | Stock | 309.35 | 309.9 | 307.39 | 307.95 | 1690436.0 |
| 2022-02-09 10:30:00 | MSFT | Stock | 307.955 | 309.05 | 307.6296 | 308.65 | 1356934.0 |
| 2022-02-09 11:00:00 | MSFT | Stock | 308.655 | 309.07 | 307.56 | 308.35 | 1146868.0 |
| 2022-02-09 11:30:00 | MSFT | Stock | 308.32 | 309.0431 | 307.47 | 307.89 | 1450676.0 |
| 2022-02-09 12:00:00 | MSFT | Stock | 307.89 | 308.834 | 307.68 | 308.67 | 837541.0 |
| 2022-02-09 12:30:00 | MSFT | Stock | 308.67 | 308.97 | 308.1801 | 308.92 | 665596.0 |
> showing 50 of 109,181 rows — these rows as CSV