PREVIEW / stock_30min / 2024-04-08
file: by_date/stock_30min/2024/2024-04-08.parquet size: 2.0 MB rows: 98,192 symbols: 1,029
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-08 04:00:00 | AAPL | Stock | 169.6 | 169.6 | 168.9 | 169.12 | 11915.0 |
| 2024-04-08 04:30:00 | AAPL | Stock | 169.15 | 169.3 | 169.0 | 169.05 | 2552.0 |
| 2024-04-08 05:00:00 | AAPL | Stock | 169.05 | 169.3 | 169.05 | 169.28 | 8430.0 |
| 2024-04-08 05:30:00 | AAPL | Stock | 169.28 | 169.28 | 169.1 | 169.1 | 1880.0 |
| 2024-04-08 06:00:00 | AAPL | Stock | 169.12 | 169.12 | 169.0 | 169.08 | 2632.0 |
| 2024-04-08 06:30:00 | AAPL | Stock | 169.1 | 169.2 | 168.93 | 169.2 | 6779.0 |
| 2024-04-08 07:00:00 | AAPL | Stock | 169.22 | 169.31 | 169.0 | 169.04 | 15021.0 |
| 2024-04-08 07:30:00 | AAPL | Stock | 169.01 | 169.11 | 168.85 | 169.11 | 15452.0 |
| 2024-04-08 08:00:00 | AAPL | Stock | 169.22 | 169.61 | 168.85 | 169.1 | 60621.0 |
| 2024-04-08 08:30:00 | AAPL | Stock | 169.07 | 169.48 | 169.02 | 169.35 | 30689.0 |
| 2024-04-08 09:00:00 | AAPL | Stock | 169.38 | 169.39 | 168.76 | 168.99 | 100605.0 |
| 2024-04-08 09:30:00 | AAPL | Stock | 169.03 | 169.2 | 168.24 | 168.985 | 4145882.0 |
| 2024-04-08 10:00:00 | AAPL | Stock | 168.99 | 169.16 | 168.71 | 168.82 | 2382675.0 |
| 2024-04-08 10:30:00 | AAPL | Stock | 168.825 | 169.13 | 168.815 | 168.9901 | 1852857.0 |
| 2024-04-08 11:00:00 | AAPL | Stock | 168.995 | 169.08 | 168.65 | 168.815 | 1885407.0 |
| 2024-04-08 11:30:00 | AAPL | Stock | 168.815 | 168.815 | 168.4301 | 168.64 | 1654704.0 |
| 2024-04-08 12:00:00 | AAPL | Stock | 168.64 | 168.7 | 168.26 | 168.4124 | 1704763.0 |
| 2024-04-08 12:30:00 | AAPL | Stock | 168.415 | 168.835 | 168.405 | 168.805 | 1219365.0 |
| 2024-04-08 13:00:00 | AAPL | Stock | 168.81 | 168.83 | 168.405 | 168.645 | 1322705.0 |
| 2024-04-08 13:30:00 | AAPL | Stock | 168.645 | 168.745 | 168.47 | 168.695 | 1081255.0 |
| 2024-04-08 14:00:00 | AAPL | Stock | 168.7 | 168.9 | 168.675 | 168.7901 | 828310.0 |
| 2024-04-08 14:30:00 | AAPL | Stock | 168.795 | 168.795 | 168.545 | 168.76 | 1009143.0 |
| 2024-04-08 15:00:00 | AAPL | Stock | 168.76 | 168.7999 | 168.56 | 168.785 | 1080875.0 |
| 2024-04-08 15:30:00 | AAPL | Stock | 168.785 | 168.96 | 168.325 | 168.46 | 4206091.0 |
| 2024-04-08 16:00:00 | AAPL | Stock | 168.49 | 168.55 | 168.36 | 168.43 | 6056046.0 |
| 2024-04-08 16:30:00 | AAPL | Stock | 168.43 | 168.45 | 168.32 | 168.37 | 101059.0 |
| 2024-04-08 17:00:00 | AAPL | Stock | 168.37 | 168.4067 | 168.36 | 168.38 | 11310.0 |
| 2024-04-08 17:30:00 | AAPL | Stock | 168.39 | 168.41 | 168.39 | 168.41 | 3604.0 |
| 2024-04-08 18:00:00 | AAPL | Stock | 168.42 | 168.45 | 168.2852 | 168.36 | 12697.0 |
| 2024-04-08 18:30:00 | AAPL | Stock | 168.35 | 168.39 | 168.3 | 168.39 | 7553.0 |
| 2024-04-08 19:00:00 | AAPL | Stock | 168.3908 | 168.41 | 168.36 | 168.37 | 6889.0 |
| 2024-04-08 19:30:00 | AAPL | Stock | 168.35 | 168.38 | 168.26 | 168.27 | 14867.0 |
| 2024-04-08 04:00:00 | MSFT | Stock | 425.79 | 425.99 | 424.93 | 424.93 | 2789.0 |
| 2024-04-08 04:30:00 | MSFT | Stock | 424.4 | 424.53 | 424.0 | 424.0 | 7071.0 |
| 2024-04-08 05:00:00 | MSFT | Stock | 424.09 | 424.09 | 423.74 | 423.74 | 1506.0 |
| 2024-04-08 05:30:00 | MSFT | Stock | 424.05 | 424.05 | 424.05 | 424.05 | 343.0 |
| 2024-04-08 06:00:00 | MSFT | Stock | 424.09 | 424.09 | 423.91 | 424.04 | 1399.0 |
| 2024-04-08 06:30:00 | MSFT | Stock | 424.3 | 424.32 | 424.26 | 424.26 | 738.0 |
| 2024-04-08 07:00:00 | MSFT | Stock | 424.48 | 425.55 | 424.48 | 425.3 | 5972.0 |
| 2024-04-08 07:30:00 | MSFT | Stock | 425.0 | 425.0 | 424.4 | 424.9 | 3384.0 |
| 2024-04-08 08:00:00 | MSFT | Stock | 424.99 | 426.0 | 424.4003 | 425.9 | 14617.0 |
| 2024-04-08 08:30:00 | MSFT | Stock | 425.8 | 426.8354 | 425.28 | 426.0995 | 7879.0 |
| 2024-04-08 09:00:00 | MSFT | Stock | 426.39 | 426.491 | 424.6 | 425.03 | 18711.0 |
| 2024-04-08 09:30:00 | MSFT | Stock | 425.17 | 425.92 | 423.3 | 425.63 | 1359514.0 |
| 2024-04-08 10:00:00 | MSFT | Stock | 425.59 | 426.79 | 424.97 | 426.71 | 665107.0 |
| 2024-04-08 10:30:00 | MSFT | Stock | 426.71 | 427.28 | 425.61 | 426.33 | 673966.0 |
| 2024-04-08 11:00:00 | MSFT | Stock | 426.36 | 426.53 | 425.68 | 425.84 | 478543.0 |
| 2024-04-08 11:30:00 | MSFT | Stock | 425.82 | 425.84 | 424.21 | 424.78 | 455648.0 |
| 2024-04-08 12:00:00 | MSFT | Stock | 424.78 | 424.79 | 423.36 | 424.2 | 436145.0 |
| 2024-04-08 12:30:00 | MSFT | Stock | 424.21 | 424.96 | 424.13 | 424.96 | 266426.0 |
> showing 50 of 98,192 rows — these rows as CSV