PREVIEW / stock_30min / 2023-09-28
file: by_date/stock_30min/2023/2023-09-28.parquet size: 2.0 MB rows: 96,752 symbols: 1,396
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 |
|---|---|---|---|---|---|---|---|
| 2023-09-28 04:00:00 | AAPL | Stock | 170.2 | 170.25 | 169.81 | 169.86 | 9391.0 |
| 2023-09-28 04:30:00 | AAPL | Stock | 169.85 | 170.0 | 169.8 | 169.81 | 6158.0 |
| 2023-09-28 05:00:00 | AAPL | Stock | 169.81 | 169.85 | 169.61 | 169.72 | 19047.0 |
| 2023-09-28 05:30:00 | AAPL | Stock | 169.75 | 170.15 | 169.61 | 170.15 | 11966.0 |
| 2023-09-28 06:00:00 | AAPL | Stock | 170.19 | 170.29 | 169.98 | 169.98 | 3385.0 |
| 2023-09-28 06:30:00 | AAPL | Stock | 169.94 | 170.2 | 169.94 | 170.18 | 7344.0 |
| 2023-09-28 07:00:00 | AAPL | Stock | 170.18 | 170.23 | 170.01 | 170.05 | 7669.0 |
| 2023-09-28 07:30:00 | AAPL | Stock | 170.04 | 170.04 | 169.73 | 169.75 | 36707.0 |
| 2023-09-28 08:00:00 | AAPL | Stock | 170.0 | 170.5 | 169.41 | 169.87 | 187349.0 |
| 2023-09-28 08:30:00 | AAPL | Stock | 169.86 | 170.49 | 169.46 | 169.6799 | 134296.0 |
| 2023-09-28 09:00:00 | AAPL | Stock | 169.72 | 169.95 | 169.2 | 169.45 | 127048.0 |
| 2023-09-28 09:30:00 | AAPL | Stock | 169.55 | 169.8 | 167.62 | 169.61 | 8223014.0 |
| 2023-09-28 10:00:00 | AAPL | Stock | 169.61 | 170.01 | 168.9 | 169.13 | 3944125.0 |
| 2023-09-28 10:30:00 | AAPL | Stock | 169.14 | 170.27 | 168.69 | 170.249 | 3967902.0 |
| 2023-09-28 11:00:00 | AAPL | Stock | 170.24 | 170.68 | 169.8 | 170.5 | 3641082.0 |
| 2023-09-28 11:30:00 | AAPL | Stock | 170.5 | 171.6181 | 170.4708 | 171.6 | 3542416.0 |
| 2023-09-28 12:00:00 | AAPL | Stock | 171.6 | 172.03 | 171.2711 | 171.89 | 2743090.0 |
| 2023-09-28 12:30:00 | AAPL | Stock | 171.89 | 171.915 | 171.03 | 171.13 | 1978099.0 |
| 2023-09-28 13:00:00 | AAPL | Stock | 171.135 | 171.53 | 170.86 | 170.882 | 2294438.0 |
| 2023-09-28 13:30:00 | AAPL | Stock | 170.9 | 170.97 | 170.43 | 170.86 | 2003838.0 |
| 2023-09-28 14:00:00 | AAPL | Stock | 170.86 | 171.165 | 170.45 | 171.13 | 1944601.0 |
| 2023-09-28 14:30:00 | AAPL | Stock | 171.135 | 171.15 | 170.31 | 170.75 | 2046298.0 |
| 2023-09-28 15:00:00 | AAPL | Stock | 170.75 | 171.68 | 170.53 | 171.58 | 2214514.0 |
| 2023-09-28 15:30:00 | AAPL | Stock | 171.58 | 171.64 | 170.44 | 170.69 | 5063878.0 |
| 2023-09-28 16:00:00 | AAPL | Stock | 170.66 | 170.85 | 170.55 | 170.8 | 4203628.0 |
| 2023-09-28 16:30:00 | AAPL | Stock | 170.81 | 171.03 | 170.69 | 171.0 | 44951.0 |
| 2023-09-28 17:00:00 | AAPL | Stock | 171.0 | 171.0 | 170.84 | 170.96 | 17526.0 |
| 2023-09-28 17:30:00 | AAPL | Stock | 170.92 | 170.97 | 170.69 | 170.95 | 4165.0 |
| 2023-09-28 18:00:00 | AAPL | Stock | 170.97 | 171.24 | 170.97 | 171.18 | 19045.0 |
| 2023-09-28 18:30:00 | AAPL | Stock | 171.1525 | 171.19 | 170.95 | 170.95 | 21847.0 |
| 2023-09-28 19:00:00 | AAPL | Stock | 170.97 | 170.99 | 170.83 | 170.8701 | 7613.0 |
| 2023-09-28 19:30:00 | AAPL | Stock | 170.96 | 171.01 | 170.8 | 170.8 | 7328.0 |
| 2023-09-28 04:00:00 | MSFT | Stock | 312.97 | 313.17 | 312.81 | 312.81 | 577.0 |
| 2023-09-28 04:30:00 | MSFT | Stock | 313.1 | 313.1 | 313.1 | 313.1 | 600.0 |
| 2023-09-28 05:00:00 | MSFT | Stock | 312.55 | 312.55 | 311.65 | 311.65 | 900.0 |
| 2023-09-28 05:30:00 | MSFT | Stock | 312.0 | 313.1 | 312.0 | 313.09 | 932.0 |
| 2023-09-28 06:00:00 | MSFT | Stock | 312.94 | 313.1 | 312.94 | 313.1 | 2872.0 |
| 2023-09-28 06:30:00 | MSFT | Stock | 312.67 | 312.89 | 312.24 | 312.5 | 3454.0 |
| 2023-09-28 07:00:00 | MSFT | Stock | 312.28 | 312.28 | 311.75 | 311.75 | 6334.0 |
| 2023-09-28 07:30:00 | MSFT | Stock | 311.85 | 311.85 | 310.3 | 310.35 | 23415.0 |
| 2023-09-28 08:00:00 | MSFT | Stock | 310.4 | 313.35 | 310.3 | 311.59 | 39660.0 |
| 2023-09-28 08:30:00 | MSFT | Stock | 311.41 | 313.1 | 311.02 | 311.3798 | 30593.0 |
| 2023-09-28 09:00:00 | MSFT | Stock | 311.4 | 311.75 | 310.0 | 310.17 | 28212.0 |
| 2023-09-28 09:30:00 | MSFT | Stock | 310.99 | 311.7092 | 309.45 | 311.57 | 2024867.0 |
| 2023-09-28 10:00:00 | MSFT | Stock | 311.57 | 312.1189 | 310.5 | 310.92 | 1087398.0 |
| 2023-09-28 10:30:00 | MSFT | Stock | 310.945 | 311.8699 | 309.88 | 311.45 | 940069.0 |
| 2023-09-28 11:00:00 | MSFT | Stock | 311.445 | 312.87 | 310.8 | 312.87 | 846610.0 |
| 2023-09-28 11:30:00 | MSFT | Stock | 312.88 | 314.124 | 312.8349 | 313.86 | 1149849.0 |
| 2023-09-28 12:00:00 | MSFT | Stock | 313.86 | 315.46 | 313.73 | 315.45 | 915126.0 |
| 2023-09-28 12:30:00 | MSFT | Stock | 315.44 | 315.48 | 313.89 | 314.22 | 566762.0 |
> showing 50 of 96,752 rows — these rows as CSV