PREVIEW / stock_30min / 2025-04-14
file: by_date/stock_30min/2025/2025-04-14.parquet size: 2.2 MB rows: 105,182 symbols: 441
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 |
|---|---|---|---|---|---|---|---|
| 2025-04-14 04:00:00 | AAPL | Stock | 209.68 | 210.8 | 208.9 | 209.33 | 288248.0 |
| 2025-04-14 04:30:00 | AAPL | Stock | 209.33 | 209.86 | 208.7 | 209.0 | 95603.0 |
| 2025-04-14 05:00:00 | AAPL | Stock | 209.0 | 209.3 | 207.64 | 207.64 | 102923.0 |
| 2025-04-14 05:30:00 | AAPL | Stock | 207.65 | 208.25 | 207.04 | 208.2 | 79307.0 |
| 2025-04-14 06:00:00 | AAPL | Stock | 208.2 | 208.54 | 207.55 | 207.82 | 74069.0 |
| 2025-04-14 06:30:00 | AAPL | Stock | 207.82 | 208.06 | 206.75 | 206.8 | 118290.0 |
| 2025-04-14 07:00:00 | AAPL | Stock | 206.88 | 209.94 | 206.8 | 209.49 | 462777.0 |
| 2025-04-14 07:30:00 | AAPL | Stock | 209.46 | 209.91 | 208.67 | 208.7 | 316031.0 |
| 2025-04-14 08:00:00 | AAPL | Stock | 207.85 | 211.9 | 198.843 | 210.9 | 1521101.0 |
| 2025-04-14 08:30:00 | AAPL | Stock | 210.88 | 211.77 | 210.5 | 210.63 | 537943.0 |
| 2025-04-14 09:00:00 | AAPL | Stock | 210.63 | 212.7 | 210.1 | 211.4 | 1135469.0 |
| 2025-04-14 09:30:00 | AAPL | Stock | 211.43 | 212.94 | 206.1 | 206.76 | 18727401.0 |
| 2025-04-14 10:00:00 | AAPL | Stock | 206.795 | 207.67 | 204.61 | 204.75 | 7421252.0 |
| 2025-04-14 10:30:00 | AAPL | Stock | 204.8 | 206.2 | 204.41 | 205.2446 | 4948920.0 |
| 2025-04-14 11:00:00 | AAPL | Stock | 205.22 | 205.6 | 203.41 | 203.6 | 4262480.0 |
| 2025-04-14 11:30:00 | AAPL | Stock | 203.65 | 204.0694 | 201.79 | 202.51 | 4144661.0 |
| 2025-04-14 12:00:00 | AAPL | Stock | 202.51 | 204.38 | 201.1621 | 201.75 | 4936904.0 |
| 2025-04-14 12:30:00 | AAPL | Stock | 201.73 | 203.15 | 201.56 | 202.1847 | 2643740.0 |
| 2025-04-14 13:00:00 | AAPL | Stock | 202.21 | 204.98 | 202.09 | 203.864 | 3297153.0 |
| 2025-04-14 13:30:00 | AAPL | Stock | 203.885 | 204.81 | 203.43 | 204.63 | 2480062.0 |
| 2025-04-14 14:00:00 | AAPL | Stock | 204.64 | 205.82 | 204.42 | 205.79 | 2263225.0 |
| 2025-04-14 14:30:00 | AAPL | Stock | 205.79 | 206.1899 | 205.39 | 205.9 | 2248168.0 |
| 2025-04-14 15:00:00 | AAPL | Stock | 205.89 | 206.66 | 205.46 | 205.71 | 2775147.0 |
| 2025-04-14 15:30:00 | AAPL | Stock | 205.72 | 205.9 | 202.31 | 202.59 | 6497652.0 |
| 2025-04-14 16:00:00 | AAPL | Stock | 202.59 | 202.93 | 200.6381 | 201.17 | 6849640.0 |
| 2025-04-14 16:30:00 | AAPL | Stock | 201.2 | 202.52 | 201.05 | 202.189 | 142809.0 |
| 2025-04-14 17:00:00 | AAPL | Stock | 202.15 | 202.3 | 201.6 | 201.94 | 63844.0 |
| 2025-04-14 17:30:00 | AAPL | Stock | 201.71 | 202.0 | 201.66 | 201.85 | 14004.0 |
| 2025-04-14 18:00:00 | AAPL | Stock | 201.67 | 201.8499 | 201.3317 | 201.4 | 21526.0 |
| 2025-04-14 18:30:00 | AAPL | Stock | 201.49 | 201.54 | 201.0 | 201.0 | 26409.0 |
| 2025-04-14 19:00:00 | AAPL | Stock | 201.0 | 201.44 | 200.75 | 200.9999 | 36457.0 |
| 2025-04-14 19:30:00 | AAPL | Stock | 201.15 | 201.43 | 200.8 | 200.93 | 33714.0 |
| 2025-04-14 04:00:00 | MSFT | Stock | 391.39 | 393.2 | 389.62 | 392.11 | 9396.0 |
| 2025-04-14 04:30:00 | MSFT | Stock | 392.19 | 392.74 | 392.01 | 392.55 | 5216.0 |
| 2025-04-14 05:00:00 | MSFT | Stock | 392.74 | 393.22 | 392.23 | 392.23 | 4051.0 |
| 2025-04-14 05:30:00 | MSFT | Stock | 392.16 | 392.16 | 390.8 | 391.4 | 3308.0 |
| 2025-04-14 06:00:00 | MSFT | Stock | 391.85 | 391.85 | 391.41 | 391.49 | 497.0 |
| 2025-04-14 06:30:00 | MSFT | Stock | 391.63 | 392.17 | 391.63 | 392.17 | 1267.0 |
| 2025-04-14 07:00:00 | MSFT | Stock | 392.0 | 392.7 | 391.8 | 391.86 | 8277.0 |
| 2025-04-14 07:30:00 | MSFT | Stock | 391.74 | 391.74 | 390.07 | 390.09 | 4665.0 |
| 2025-04-14 08:00:00 | MSFT | Stock | 391.4 | 392.8 | 389.809 | 391.15 | 43916.0 |
| 2025-04-14 08:30:00 | MSFT | Stock | 391.05 | 392.5 | 391.0 | 391.85 | 15069.0 |
| 2025-04-14 09:00:00 | MSFT | Stock | 391.89 | 394.74 | 391.5 | 392.99 | 32007.0 |
| 2025-04-14 09:30:00 | MSFT | Stock | 393.01 | 393.22 | 390.5449 | 390.89 | 1621819.0 |
| 2025-04-14 10:00:00 | MSFT | Stock | 390.92 | 393.2 | 390.52 | 392.91 | 740160.0 |
| 2025-04-14 10:30:00 | MSFT | Stock | 392.96 | 394.65 | 392.1729 | 392.86 | 575282.0 |
| 2025-04-14 11:00:00 | MSFT | Stock | 392.88 | 393.25 | 388.61 | 388.68 | 632906.0 |
| 2025-04-14 11:30:00 | MSFT | Stock | 388.71 | 389.79 | 386.4 | 386.45 | 626139.0 |
| 2025-04-14 12:00:00 | MSFT | Stock | 386.41 | 387.23 | 384.5563 | 385.81 | 853351.0 |
| 2025-04-14 12:30:00 | MSFT | Stock | 385.85 | 386.5448 | 384.33 | 384.445 | 416148.0 |
> showing 50 of 105,182 rows — these rows as CSV