PREVIEW / stock_30min / 2024-04-15
file: by_date/stock_30min/2024/2024-04-15.parquet size: 2.1 MB rows: 100,924 symbols: 1,013
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 |
|---|---|---|---|---|---|---|---|
| 2024-04-15 04:00:00 | AAPL | Stock | 175.36 | 176.21 | 175.15 | 175.26 | 40394.0 |
| 2024-04-15 04:30:00 | AAPL | Stock | 175.33 | 175.75 | 175.15 | 175.18 | 11732.0 |
| 2024-04-15 05:00:00 | AAPL | Stock | 175.25 | 175.55 | 174.84 | 174.84 | 17728.0 |
| 2024-04-15 05:30:00 | AAPL | Stock | 174.8 | 175.28 | 174.5 | 174.65 | 12175.0 |
| 2024-04-15 06:00:00 | AAPL | Stock | 174.72 | 174.72 | 174.0 | 174.6 | 27441.0 |
| 2024-04-15 06:30:00 | AAPL | Stock | 174.46 | 174.5 | 174.2 | 174.35 | 23926.0 |
| 2024-04-15 07:00:00 | AAPL | Stock | 174.4 | 175.18 | 174.35 | 175.0 | 71750.0 |
| 2024-04-15 07:30:00 | AAPL | Stock | 175.0 | 175.58 | 174.9 | 175.52 | 86378.0 |
| 2024-04-15 08:00:00 | AAPL | Stock | 174.43 | 176.28 | 174.3701 | 175.5 | 195823.0 |
| 2024-04-15 08:30:00 | AAPL | Stock | 175.37 | 176.0 | 175.15 | 175.6504 | 136853.0 |
| 2024-04-15 09:00:00 | AAPL | Stock | 175.73 | 175.92 | 175.21 | 175.36 | 110633.0 |
| 2024-04-15 09:30:00 | AAPL | Stock | 175.36 | 175.98 | 173.83 | 174.63 | 8126546.0 |
| 2024-04-15 10:00:00 | AAPL | Stock | 174.62 | 175.27 | 174.5 | 174.875 | 3904830.0 |
| 2024-04-15 10:30:00 | AAPL | Stock | 174.88 | 175.184 | 174.56 | 174.83 | 2661055.0 |
| 2024-04-15 11:00:00 | AAPL | Stock | 174.84 | 176.63 | 174.835 | 175.41 | 5020572.0 |
| 2024-04-15 11:30:00 | AAPL | Stock | 175.4 | 176.14 | 175.26 | 176.005 | 2436940.0 |
| 2024-04-15 12:00:00 | AAPL | Stock | 176.0001 | 176.15 | 174.96 | 175.1 | 1923099.0 |
| 2024-04-15 12:30:00 | AAPL | Stock | 175.095 | 175.24 | 174.9 | 175.13 | 1736911.0 |
| 2024-04-15 13:00:00 | AAPL | Stock | 175.135 | 175.57 | 174.5101 | 174.52 | 2777509.0 |
| 2024-04-15 13:30:00 | AAPL | Stock | 174.51 | 174.62 | 173.532 | 173.9 | 3226267.0 |
| 2024-04-15 14:00:00 | AAPL | Stock | 173.89 | 173.89 | 172.5 | 173.13 | 4544568.0 |
| 2024-04-15 14:30:00 | AAPL | Stock | 173.12 | 173.76 | 173.02 | 173.3111 | 3060006.0 |
| 2024-04-15 15:00:00 | AAPL | Stock | 173.32 | 173.45 | 172.8 | 172.93 | 2548581.0 |
| 2024-04-15 15:30:00 | AAPL | Stock | 172.93 | 173.64 | 172.66 | 172.69 | 5553631.0 |
| 2024-04-15 16:00:00 | AAPL | Stock | 172.69 | 172.78 | 172.59 | 172.61 | 10084617.0 |
| 2024-04-15 16:30:00 | AAPL | Stock | 172.59 | 172.99 | 172.43 | 172.95 | 195701.0 |
| 2024-04-15 17:00:00 | AAPL | Stock | 172.91 | 172.91 | 172.62 | 172.65 | 30235.0 |
| 2024-04-15 17:30:00 | AAPL | Stock | 172.69 | 172.89 | 172.61 | 172.8 | 16799.0 |
| 2024-04-15 18:00:00 | AAPL | Stock | 172.8 | 173.12 | 172.7 | 172.8 | 36461.0 |
| 2024-04-15 18:30:00 | AAPL | Stock | 172.84 | 172.84 | 172.5 | 172.66 | 13689.0 |
| 2024-04-15 19:00:00 | AAPL | Stock | 172.69 | 172.77 | 172.49 | 172.5501 | 11767.0 |
| 2024-04-15 19:30:00 | AAPL | Stock | 172.62 | 172.69 | 172.5201 | 172.65 | 14296.0 |
| 2024-04-15 04:00:00 | MSFT | Stock | 423.99 | 425.0 | 423.99 | 424.5 | 9273.0 |
| 2024-04-15 04:30:00 | MSFT | Stock | 424.5 | 424.54 | 424.5 | 424.5 | 1285.0 |
| 2024-04-15 05:00:00 | MSFT | Stock | 424.4 | 424.8 | 424.4 | 424.42 | 4192.0 |
| 2024-04-15 05:30:00 | MSFT | Stock | 424.2 | 424.2 | 424.07 | 424.13 | 1639.0 |
| 2024-04-15 06:00:00 | MSFT | Stock | 424.03 | 424.2 | 424.0 | 424.04 | 1503.0 |
| 2024-04-15 06:30:00 | MSFT | Stock | 424.05 | 424.3 | 424.05 | 424.2 | 1250.0 |
| 2024-04-15 07:00:00 | MSFT | Stock | 424.13 | 424.82 | 423.95 | 424.7 | 7692.0 |
| 2024-04-15 07:30:00 | MSFT | Stock | 424.55 | 425.0 | 424.55 | 424.7 | 11792.0 |
| 2024-04-15 08:00:00 | MSFT | Stock | 424.4 | 425.4 | 421.95 | 425.32 | 34832.0 |
| 2024-04-15 08:30:00 | MSFT | Stock | 425.05 | 426.26 | 424.93 | 425.45 | 17199.0 |
| 2024-04-15 09:00:00 | MSFT | Stock | 425.04 | 426.85 | 425.0 | 426.48 | 30188.0 |
| 2024-04-15 09:30:00 | MSFT | Stock | 426.6 | 426.6 | 423.71 | 426.17 | 1457621.0 |
| 2024-04-15 10:00:00 | MSFT | Stock | 426.15 | 426.82 | 422.31 | 423.09 | 996900.0 |
| 2024-04-15 10:30:00 | MSFT | Stock | 423.14 | 423.7 | 421.99 | 422.31 | 718491.0 |
| 2024-04-15 11:00:00 | MSFT | Stock | 422.3 | 422.74 | 421.96 | 422.71 | 482754.0 |
| 2024-04-15 11:30:00 | MSFT | Stock | 422.72 | 423.24 | 421.6 | 421.93 | 469309.0 |
| 2024-04-15 12:00:00 | MSFT | Stock | 421.91 | 422.45 | 420.5 | 420.61 | 469836.0 |
| 2024-04-15 12:30:00 | MSFT | Stock | 420.6 | 420.675 | 419.365 | 420.1 | 480782.0 |
> showing 50 of 100,924 rows — these rows as CSV