PREVIEW / stock_30min / 2024-04-04
file: by_date/stock_30min/2024/2024-04-04.parquet size: 2.1 MB rows: 100,612 symbols: 1,042
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-04 04:00:00 | AAPL | Stock | 169.99 | 170.13 | 169.9 | 170.0 | 4965.0 |
| 2024-04-04 04:30:00 | AAPL | Stock | 170.15 | 170.18 | 170.05 | 170.06 | 1516.0 |
| 2024-04-04 05:00:00 | AAPL | Stock | 170.06 | 170.2 | 170.06 | 170.15 | 2142.0 |
| 2024-04-04 05:30:00 | AAPL | Stock | 170.15 | 170.19 | 170.15 | 170.19 | 950.0 |
| 2024-04-04 06:00:00 | AAPL | Stock | 170.05 | 170.12 | 170.0 | 170.1 | 2300.0 |
| 2024-04-04 06:30:00 | AAPL | Stock | 170.08 | 170.14 | 170.0 | 170.14 | 1177.0 |
| 2024-04-04 07:00:00 | AAPL | Stock | 170.2 | 170.31 | 170.1 | 170.17 | 11173.0 |
| 2024-04-04 07:30:00 | AAPL | Stock | 170.2 | 170.3 | 170.2 | 170.2 | 6563.0 |
| 2024-04-04 08:00:00 | AAPL | Stock | 170.19 | 170.42 | 169.83 | 170.18 | 32299.0 |
| 2024-04-04 08:30:00 | AAPL | Stock | 170.19 | 170.79 | 170.13 | 170.75 | 62476.0 |
| 2024-04-04 09:00:00 | AAPL | Stock | 170.75 | 170.89 | 170.15 | 170.31 | 128011.0 |
| 2024-04-04 09:30:00 | AAPL | Stock | 170.33 | 171.01 | 170.04 | 170.9799 | 4647530.0 |
| 2024-04-04 10:00:00 | AAPL | Stock | 170.9792 | 171.19 | 170.842 | 171.01 | 2295508.0 |
| 2024-04-04 10:30:00 | AAPL | Stock | 171.015 | 171.105 | 170.71 | 171.0182 | 2070261.0 |
| 2024-04-04 11:00:00 | AAPL | Stock | 171.0175 | 171.28 | 170.85 | 171.28 | 1609481.0 |
| 2024-04-04 11:30:00 | AAPL | Stock | 171.2775 | 171.765 | 171.27 | 171.73 | 1843310.0 |
| 2024-04-04 12:00:00 | AAPL | Stock | 171.73 | 171.92 | 171.71 | 171.73 | 1553154.0 |
| 2024-04-04 12:30:00 | AAPL | Stock | 171.725 | 171.8699 | 171.335 | 171.425 | 1650003.0 |
| 2024-04-04 13:00:00 | AAPL | Stock | 171.42 | 171.565 | 171.33 | 171.55 | 1098133.0 |
| 2024-04-04 13:30:00 | AAPL | Stock | 171.55 | 171.61 | 170.8 | 170.82 | 1682012.0 |
| 2024-04-04 14:00:00 | AAPL | Stock | 170.82 | 170.8251 | 169.7 | 169.74 | 3378846.0 |
| 2024-04-04 14:30:00 | AAPL | Stock | 169.74 | 170.1 | 169.2 | 169.8 | 3631252.0 |
| 2024-04-04 15:00:00 | AAPL | Stock | 169.79 | 169.93 | 169.02 | 169.041 | 3272676.0 |
| 2024-04-04 15:30:00 | AAPL | Stock | 169.04 | 169.74 | 168.83 | 168.89 | 6720140.0 |
| 2024-04-04 16:00:00 | AAPL | Stock | 168.86 | 168.99 | 168.77 | 168.98 | 8161185.0 |
| 2024-04-04 16:30:00 | AAPL | Stock | 168.94 | 169.12 | 168.82 | 169.05 | 61786.0 |
| 2024-04-04 17:00:00 | AAPL | Stock | 169.02 | 169.22 | 168.82 | 169.08 | 29258.0 |
| 2024-04-04 17:30:00 | AAPL | Stock | 169.1 | 169.15 | 169.1 | 169.1204 | 7258.0 |
| 2024-04-04 18:00:00 | AAPL | Stock | 169.15 | 169.25 | 169.1 | 169.15 | 19503.0 |
| 2024-04-04 18:30:00 | AAPL | Stock | 169.11 | 169.2886 | 169.02 | 169.1 | 34802.0 |
| 2024-04-04 19:00:00 | AAPL | Stock | 169.07 | 169.32 | 169.02 | 169.32 | 25093.0 |
| 2024-04-04 19:30:00 | AAPL | Stock | 169.32 | 169.55 | 169.21 | 169.22 | 24829.0 |
| 2024-04-04 04:00:00 | MSFT | Stock | 422.56 | 422.56 | 422.42 | 422.42 | 448.0 |
| 2024-04-04 04:30:00 | MSFT | Stock | 422.92 | 422.92 | 422.92 | 422.92 | 100.0 |
| 2024-04-04 05:30:00 | MSFT | Stock | 422.79 | 423.14 | 422.79 | 423.14 | 5046.0 |
| 2024-04-04 06:00:00 | MSFT | Stock | 422.86 | 422.86 | 422.8 | 422.85 | 404.0 |
| 2024-04-04 07:00:00 | MSFT | Stock | 422.85 | 422.98 | 422.0 | 422.12 | 2730.0 |
| 2024-04-04 07:30:00 | MSFT | Stock | 421.86 | 422.28 | 421.86 | 422.28 | 658.0 |
| 2024-04-04 08:00:00 | MSFT | Stock | 422.85 | 423.17 | 421.8557 | 422.68 | 13042.0 |
| 2024-04-04 08:30:00 | MSFT | Stock | 422.72 | 424.26 | 422.72 | 423.8 | 24752.0 |
| 2024-04-04 09:00:00 | MSFT | Stock | 423.88 | 424.96 | 423.5 | 424.94 | 35100.0 |
| 2024-04-04 09:30:00 | MSFT | Stock | 424.97 | 427.58 | 423.32 | 426.49 | 1529274.0 |
| 2024-04-04 10:00:00 | MSFT | Stock | 426.4639 | 426.94 | 425.26 | 425.7201 | 500038.0 |
| 2024-04-04 10:30:00 | MSFT | Stock | 425.7 | 426.08 | 425.13 | 425.81 | 359165.0 |
| 2024-04-04 11:00:00 | MSFT | Stock | 425.8479 | 426.8 | 425.8479 | 426.5 | 422672.0 |
| 2024-04-04 11:30:00 | MSFT | Stock | 426.48 | 427.08 | 426.151 | 427.04 | 335961.0 |
| 2024-04-04 12:00:00 | MSFT | Stock | 427.06 | 427.67 | 427.015 | 427.53 | 357050.0 |
| 2024-04-04 12:30:00 | MSFT | Stock | 427.55 | 428.67 | 427.44 | 428.14 | 483743.0 |
| 2024-04-04 13:00:00 | MSFT | Stock | 428.1 | 428.105 | 427.51 | 427.71 | 229035.0 |
| 2024-04-04 13:30:00 | MSFT | Stock | 427.72 | 427.82 | 426.54 | 426.76 | 306064.0 |
> showing 50 of 100,612 rows — these rows as CSV