PREVIEW / stock_30min / 2025-04-09
file: by_date/stock_30min/2025/2025-04-09.parquet size: 2.3 MB rows: 111,762 symbols: 452
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-09 04:00:00 | AAPL | Stock | 172.1 | 177.09 | 172.1 | 174.75 | 247439.0 |
| 2025-04-09 04:30:00 | AAPL | Stock | 174.58 | 175.89 | 173.0 | 175.7 | 100517.0 |
| 2025-04-09 05:00:00 | AAPL | Stock | 175.74 | 176.4 | 174.93 | 175.12 | 66742.0 |
| 2025-04-09 05:30:00 | AAPL | Stock | 175.3 | 175.36 | 174.43 | 175.3 | 54080.0 |
| 2025-04-09 06:00:00 | AAPL | Stock | 175.29 | 175.4 | 173.95 | 174.67 | 65351.0 |
| 2025-04-09 06:30:00 | AAPL | Stock | 174.6 | 177.14 | 174.39 | 176.02 | 97531.0 |
| 2025-04-09 07:00:00 | AAPL | Stock | 176.07 | 176.37 | 168.53 | 171.26 | 599098.0 |
| 2025-04-09 07:30:00 | AAPL | Stock | 171.25 | 172.36 | 168.38 | 168.8 | 278882.0 |
| 2025-04-09 08:00:00 | AAPL | Stock | 173.8 | 176.065 | 168.0 | 169.35 | 689407.0 |
| 2025-04-09 08:30:00 | AAPL | Stock | 169.25 | 173.51 | 168.5601 | 172.0 | 426119.0 |
| 2025-04-09 09:00:00 | AAPL | Stock | 172.03 | 174.21 | 171.49 | 171.94 | 574167.0 |
| 2025-04-09 09:30:00 | AAPL | Stock | 172.06 | 178.9 | 171.89 | 177.385 | 13816381.0 |
| 2025-04-09 10:00:00 | AAPL | Stock | 177.4 | 179.42 | 176.72 | 178.4118 | 6703338.0 |
| 2025-04-09 10:30:00 | AAPL | Stock | 178.47 | 180.42 | 176.83 | 177.72 | 7086162.0 |
| 2025-04-09 11:00:00 | AAPL | Stock | 177.7 | 180.18 | 177.595 | 179.74 | 5220403.0 |
| 2025-04-09 11:30:00 | AAPL | Stock | 179.74 | 180.53 | 177.75 | 178.73 | 4878511.0 |
| 2025-04-09 12:00:00 | AAPL | Stock | 178.71 | 181.07 | 177.875 | 179.59 | 3975555.0 |
| 2025-04-09 12:30:00 | AAPL | Stock | 179.5799 | 181.36 | 179.24 | 181.07 | 3084369.0 |
| 2025-04-09 13:00:00 | AAPL | Stock | 181.1 | 194.49 | 179.3 | 188.525 | 11274637.0 |
| 2025-04-09 13:30:00 | AAPL | Stock | 188.51 | 194.8699 | 188.13 | 193.105 | 11650680.0 |
| 2025-04-09 14:00:00 | AAPL | Stock | 193.1 | 194.6499 | 188.18 | 190.8 | 9397347.0 |
| 2025-04-09 14:30:00 | AAPL | Stock | 190.78 | 191.34 | 184.18 | 184.9 | 8506403.0 |
| 2025-04-09 15:00:00 | AAPL | Stock | 184.9 | 198.98 | 183.87 | 196.0 | 15137844.0 |
| 2025-04-09 15:30:00 | AAPL | Stock | 196.0 | 200.61 | 195.91 | 198.85 | 16061388.0 |
| 2025-04-09 16:00:00 | AAPL | Stock | 198.89 | 199.03 | 197.47 | 198.3562 | 20045511.0 |
| 2025-04-09 16:30:00 | AAPL | Stock | 198.5938 | 198.85 | 198.15 | 198.5 | 531045.0 |
| 2025-04-09 17:00:00 | AAPL | Stock | 198.4985 | 199.4 | 196.8 | 197.24 | 254954.0 |
| 2025-04-09 17:30:00 | AAPL | Stock | 197.25 | 198.85 | 196.49 | 196.66 | 121539.0 |
| 2025-04-09 18:00:00 | AAPL | Stock | 196.7 | 197.64 | 196.33 | 197.45 | 111886.0 |
| 2025-04-09 18:30:00 | AAPL | Stock | 197.45 | 197.71 | 197.27 | 197.48 | 43810.0 |
| 2025-04-09 19:00:00 | AAPL | Stock | 197.4779 | 197.9999 | 196.56 | 197.03 | 44795.0 |
| 2025-04-09 19:30:00 | AAPL | Stock | 197.03 | 197.91 | 197.03 | 197.7118 | 90073.0 |
| 2025-04-09 04:00:00 | MSFT | Stock | 355.23 | 357.01 | 353.73 | 354.57 | 10828.0 |
| 2025-04-09 04:30:00 | MSFT | Stock | 353.1 | 356.15 | 352.37 | 355.94 | 3084.0 |
| 2025-04-09 05:00:00 | MSFT | Stock | 356.31 | 356.63 | 355.05 | 355.06 | 7500.0 |
| 2025-04-09 05:30:00 | MSFT | Stock | 355.9 | 355.9 | 354.27 | 354.6 | 3697.0 |
| 2025-04-09 06:00:00 | MSFT | Stock | 354.47 | 354.47 | 351.8 | 353.27 | 4131.0 |
| 2025-04-09 06:30:00 | MSFT | Stock | 352.78 | 356.36 | 352.27 | 355.62 | 7349.0 |
| 2025-04-09 07:00:00 | MSFT | Stock | 353.88 | 353.88 | 348.99 | 352.68 | 28328.0 |
| 2025-04-09 07:30:00 | MSFT | Stock | 352.5 | 353.0 | 348.41 | 350.38 | 15996.0 |
| 2025-04-09 08:00:00 | MSFT | Stock | 351.57 | 359.36 | 346.75 | 349.1827 | 78291.0 |
| 2025-04-09 08:30:00 | MSFT | Stock | 349.8 | 354.18 | 348.18 | 352.4 | 18501.0 |
| 2025-04-09 09:00:00 | MSFT | Stock | 354.21 | 356.0 | 351.75 | 353.42 | 41298.0 |
| 2025-04-09 09:30:00 | MSFT | Stock | 353.42 | 361.87 | 353.1 | 360.908 | 2563681.0 |
| 2025-04-09 10:00:00 | MSFT | Stock | 360.85 | 363.12 | 358.94 | 361.045 | 1239127.0 |
| 2025-04-09 10:30:00 | MSFT | Stock | 361.15 | 362.96 | 357.37 | 357.6951 | 874493.0 |
| 2025-04-09 11:00:00 | MSFT | Stock | 357.715 | 361.66 | 357.53 | 361.04 | 965258.0 |
| 2025-04-09 11:30:00 | MSFT | Stock | 361.07 | 362.9 | 359.41 | 360.9701 | 921701.0 |
| 2025-04-09 12:00:00 | MSFT | Stock | 361.04 | 364.67 | 360.27 | 363.7499 | 862548.0 |
| 2025-04-09 12:30:00 | MSFT | Stock | 363.685 | 366.5 | 363.13 | 365.94 | 898320.0 |
> showing 50 of 111,762 rows — these rows as CSV