PREVIEW / stock_30min / 2025-04-03
file: by_date/stock_30min/2025/2025-04-03.parquet size: 2.2 MB rows: 108,307 symbols: 456
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-03 04:00:00 | AAPL | Stock | 210.78 | 210.78 | 208.9 | 210.15 | 124003.0 |
| 2025-04-03 04:30:00 | AAPL | Stock | 210.14 | 210.26 | 207.86 | 208.85 | 109709.0 |
| 2025-04-03 05:00:00 | AAPL | Stock | 208.99 | 209.5 | 207.7 | 207.79 | 98937.0 |
| 2025-04-03 05:30:00 | AAPL | Stock | 207.8 | 208.26 | 207.14 | 208.12 | 61325.0 |
| 2025-04-03 06:00:00 | AAPL | Stock | 208.12 | 208.12 | 206.88 | 207.17 | 79270.0 |
| 2025-04-03 06:30:00 | AAPL | Stock | 207.23 | 207.48 | 206.67 | 207.3 | 74302.0 |
| 2025-04-03 07:00:00 | AAPL | Stock | 207.36 | 208.7 | 207.0 | 207.49 | 186990.0 |
| 2025-04-03 07:30:00 | AAPL | Stock | 207.46 | 207.5 | 206.3 | 206.99 | 159162.0 |
| 2025-04-03 08:00:00 | AAPL | Stock | 207.18 | 211.03 | 206.34 | 206.74 | 582416.0 |
| 2025-04-03 08:30:00 | AAPL | Stock | 206.53 | 207.5 | 206.15 | 207.0 | 431935.0 |
| 2025-04-03 09:00:00 | AAPL | Stock | 206.99 | 207.15 | 204.8 | 205.52 | 728541.0 |
| 2025-04-03 09:30:00 | AAPL | Stock | 205.53 | 207.49 | 202.52 | 204.3588 | 16714541.0 |
| 2025-04-03 10:00:00 | AAPL | Stock | 204.25 | 206.3521 | 203.2 | 205.635 | 5915324.0 |
| 2025-04-03 10:30:00 | AAPL | Stock | 205.625 | 206.47 | 203.37 | 204.3712 | 4732686.0 |
| 2025-04-03 11:00:00 | AAPL | Stock | 204.37 | 205.03 | 203.49 | 204.05 | 3637814.0 |
| 2025-04-03 11:30:00 | AAPL | Stock | 204.05 | 206.23 | 203.7043 | 205.595 | 3454629.0 |
| 2025-04-03 12:00:00 | AAPL | Stock | 205.62 | 207.04 | 205.48 | 206.06 | 2898054.0 |
| 2025-04-03 12:30:00 | AAPL | Stock | 206.09 | 206.3 | 204.56 | 204.81 | 2244195.0 |
| 2025-04-03 13:00:00 | AAPL | Stock | 204.82 | 205.3715 | 203.8401 | 204.005 | 1891210.0 |
| 2025-04-03 13:30:00 | AAPL | Stock | 203.99 | 204.6051 | 203.21 | 203.4299 | 1867844.0 |
| 2025-04-03 14:00:00 | AAPL | Stock | 203.42 | 203.645 | 202.7 | 203.0 | 2732099.0 |
| 2025-04-03 14:30:00 | AAPL | Stock | 202.98 | 203.52 | 202.34 | 202.905 | 3161780.0 |
| 2025-04-03 15:00:00 | AAPL | Stock | 202.88 | 203.03 | 202.14 | 202.2 | 3876024.0 |
| 2025-04-03 15:30:00 | AAPL | Stock | 202.2 | 203.86 | 201.25 | 203.06 | 10635210.0 |
| 2025-04-03 16:00:00 | AAPL | Stock | 203.03 | 204.0 | 202.73 | 203.27 | 12392989.0 |
| 2025-04-03 16:30:00 | AAPL | Stock | 203.2799 | 203.97 | 203.19 | 203.5 | 453918.0 |
| 2025-04-03 17:00:00 | AAPL | Stock | 203.5 | 204.25 | 203.19 | 204.01 | 96979.0 |
| 2025-04-03 17:30:00 | AAPL | Stock | 204.05 | 204.1 | 203.5 | 203.6015 | 65372.0 |
| 2025-04-03 18:00:00 | AAPL | Stock | 203.6 | 203.64 | 202.83 | 203.15 | 86539.0 |
| 2025-04-03 18:30:00 | AAPL | Stock | 203.2 | 203.45 | 203.1501 | 203.2245 | 39579.0 |
| 2025-04-03 19:00:00 | AAPL | Stock | 203.3988 | 203.53 | 203.1466 | 203.5299 | 26715.0 |
| 2025-04-03 19:30:00 | AAPL | Stock | 203.5293 | 203.695 | 203.0 | 203.38 | 22772.0 |
| 2025-04-03 04:00:00 | MSFT | Stock | 373.85 | 375.76 | 373.63 | 375.62 | 6534.0 |
| 2025-04-03 04:30:00 | MSFT | Stock | 375.61 | 376.01 | 375.45 | 375.71 | 12473.0 |
| 2025-04-03 05:00:00 | MSFT | Stock | 375.89 | 376.16 | 374.6 | 374.87 | 6823.0 |
| 2025-04-03 05:30:00 | MSFT | Stock | 374.69 | 374.91 | 373.32 | 373.32 | 6641.0 |
| 2025-04-03 06:00:00 | MSFT | Stock | 373.03 | 373.7 | 372.77 | 373.31 | 13385.0 |
| 2025-04-03 06:30:00 | MSFT | Stock | 373.48 | 373.48 | 371.87 | 372.02 | 8594.0 |
| 2025-04-03 07:00:00 | MSFT | Stock | 372.1 | 373.09 | 371.8 | 371.84 | 20725.0 |
| 2025-04-03 07:30:00 | MSFT | Stock | 371.97 | 372.09 | 371.27 | 371.8 | 14351.0 |
| 2025-04-03 08:00:00 | MSFT | Stock | 371.8 | 375.9548 | 371.29 | 372.1515 | 50846.0 |
| 2025-04-03 08:30:00 | MSFT | Stock | 372.13 | 372.25 | 369.45 | 369.46 | 49724.0 |
| 2025-04-03 09:00:00 | MSFT | Stock | 369.39 | 375.48 | 369.38 | 374.96 | 133213.0 |
| 2025-04-03 09:30:00 | MSFT | Stock | 374.6 | 375.99 | 369.35 | 372.94 | 3498047.0 |
| 2025-04-03 10:00:00 | MSFT | Stock | 372.82 | 375.22 | 372.01 | 373.525 | 1368114.0 |
| 2025-04-03 10:30:00 | MSFT | Stock | 373.5 | 373.8592 | 371.22 | 371.62 | 1054463.0 |
| 2025-04-03 11:00:00 | MSFT | Stock | 371.62 | 374.99 | 371.17 | 374.16 | 876268.0 |
| 2025-04-03 11:30:00 | MSFT | Stock | 374.04 | 375.73 | 373.8159 | 374.95 | 699210.0 |
| 2025-04-03 12:00:00 | MSFT | Stock | 374.945 | 376.88 | 374.85 | 376.87 | 569423.0 |
| 2025-04-03 12:30:00 | MSFT | Stock | 376.88 | 377.4 | 375.9217 | 376.355 | 556724.0 |
> showing 50 of 108,307 rows — these rows as CSV