PREVIEW / stock_30min / 2024-05-02
file: by_date/stock_30min/2024/2024-05-02.parquet size: 2.0 MB rows: 97,463 symbols: 974
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-05-02 04:00:00 | AAPL | Stock | 170.5 | 171.5 | 170.5 | 171.28 | 21231.0 |
| 2024-05-02 04:30:00 | AAPL | Stock | 171.4 | 171.47 | 171.12 | 171.12 | 8803.0 |
| 2024-05-02 05:00:00 | AAPL | Stock | 171.14 | 171.2 | 170.92 | 171.07 | 3923.0 |
| 2024-05-02 05:30:00 | AAPL | Stock | 171.15 | 171.17 | 171.03 | 171.17 | 5149.0 |
| 2024-05-02 06:00:00 | AAPL | Stock | 171.18 | 171.38 | 171.02 | 171.08 | 6338.0 |
| 2024-05-02 06:30:00 | AAPL | Stock | 171.1 | 171.22 | 171.1 | 171.2 | 1615.0 |
| 2024-05-02 07:00:00 | AAPL | Stock | 171.15 | 171.27 | 171.05 | 171.2 | 12478.0 |
| 2024-05-02 07:30:00 | AAPL | Stock | 171.1 | 171.15 | 170.8 | 170.89 | 24919.0 |
| 2024-05-02 08:00:00 | AAPL | Stock | 171.15 | 171.29 | 170.8 | 170.8583 | 94369.0 |
| 2024-05-02 08:30:00 | AAPL | Stock | 170.85 | 173.1197 | 170.7 | 171.95 | 332894.0 |
| 2024-05-02 09:00:00 | AAPL | Stock | 171.9 | 172.94 | 171.6 | 172.43 | 276994.0 |
| 2024-05-02 09:30:00 | AAPL | Stock | 172.43 | 172.66 | 171.21 | 171.44 | 6976671.0 |
| 2024-05-02 10:00:00 | AAPL | Stock | 171.425 | 171.78 | 170.89 | 171.59 | 3114090.0 |
| 2024-05-02 10:30:00 | AAPL | Stock | 171.5942 | 172.08 | 171.42 | 171.5602 | 2492570.0 |
| 2024-05-02 11:00:00 | AAPL | Stock | 171.568 | 172.04 | 171.44 | 171.595 | 2295551.0 |
| 2024-05-02 11:30:00 | AAPL | Stock | 171.5972 | 172.19 | 171.46 | 172.1 | 2240497.0 |
| 2024-05-02 12:00:00 | AAPL | Stock | 172.105 | 172.505 | 172.055 | 172.345 | 3029455.0 |
| 2024-05-02 12:30:00 | AAPL | Stock | 172.345 | 172.45 | 171.93 | 172.1589 | 2249972.0 |
| 2024-05-02 13:00:00 | AAPL | Stock | 172.16 | 172.78 | 172.16 | 172.695 | 2205467.0 |
| 2024-05-02 13:30:00 | AAPL | Stock | 172.7 | 172.74 | 172.52 | 172.6 | 1928120.0 |
| 2024-05-02 14:00:00 | AAPL | Stock | 172.595 | 172.94 | 172.41 | 172.9 | 3306508.0 |
| 2024-05-02 14:30:00 | AAPL | Stock | 172.9 | 173.1 | 172.55 | 172.94 | 3521801.0 |
| 2024-05-02 15:00:00 | AAPL | Stock | 172.94 | 173.22 | 172.57 | 173.15 | 3775644.0 |
| 2024-05-02 15:30:00 | AAPL | Stock | 173.145 | 173.415 | 172.54 | 173.08 | 8064345.0 |
| 2024-05-02 16:00:00 | AAPL | Stock | 173.11 | 173.98 | 172.66 | 173.3 | 8454100.0 |
| 2024-05-02 16:30:00 | AAPL | Stock | 173.6 | 185.95 | 173.03 | 185.3 | 10310274.0 |
| 2024-05-02 17:00:00 | AAPL | Stock | 185.3005 | 186.6453 | 184.12 | 184.7985 | 3698651.0 |
| 2024-05-02 17:30:00 | AAPL | Stock | 184.76 | 185.49 | 183.93 | 184.1 | 964066.0 |
| 2024-05-02 18:00:00 | AAPL | Stock | 184.09 | 184.34 | 183.35 | 183.52 | 676422.0 |
| 2024-05-02 18:30:00 | AAPL | Stock | 183.52 | 183.7 | 173.03 | 183.52 | 372004.0 |
| 2024-05-02 19:00:00 | AAPL | Stock | 183.52 | 183.95 | 183.5 | 183.7399 | 158286.0 |
| 2024-05-02 19:30:00 | AAPL | Stock | 183.73 | 183.94 | 183.4 | 183.46 | 240759.0 |
| 2024-05-02 04:00:00 | MSFT | Stock | 397.9 | 398.13 | 397.9 | 398.1 | 4013.0 |
| 2024-05-02 04:30:00 | MSFT | Stock | 397.94 | 398.17 | 397.94 | 398.07 | 1053.0 |
| 2024-05-02 05:00:00 | MSFT | Stock | 397.78 | 398.17 | 397.69 | 398.17 | 793.0 |
| 2024-05-02 05:30:00 | MSFT | Stock | 398.14 | 398.17 | 398.03 | 398.17 | 1243.0 |
| 2024-05-02 06:00:00 | MSFT | Stock | 398.35 | 398.75 | 398.35 | 398.45 | 1517.0 |
| 2024-05-02 06:30:00 | MSFT | Stock | 398.8 | 399.0 | 398.8 | 399.0 | 1418.0 |
| 2024-05-02 07:00:00 | MSFT | Stock | 399.0 | 399.0 | 398.0 | 398.1 | 12274.0 |
| 2024-05-02 07:30:00 | MSFT | Stock | 398.1 | 398.1 | 397.48 | 397.7 | 10173.0 |
| 2024-05-02 08:00:00 | MSFT | Stock | 398.58 | 398.9199 | 397.5966 | 398.2597 | 30412.0 |
| 2024-05-02 08:30:00 | MSFT | Stock | 398.25 | 398.55 | 397.8 | 398.0 | 18314.0 |
| 2024-05-02 09:00:00 | MSFT | Stock | 398.0 | 398.56 | 397.4204 | 397.72 | 31589.0 |
| 2024-05-02 09:30:00 | MSFT | Stock | 397.56 | 399.93 | 395.4613 | 397.72 | 1581785.0 |
| 2024-05-02 10:00:00 | MSFT | Stock | 397.79 | 398.1731 | 394.89 | 396.29 | 727716.0 |
| 2024-05-02 10:30:00 | MSFT | Stock | 396.3143 | 396.91 | 394.89 | 396.46 | 546387.0 |
| 2024-05-02 11:00:00 | MSFT | Stock | 396.49 | 397.61 | 396.27 | 397.07 | 519311.0 |
| 2024-05-02 11:30:00 | MSFT | Stock | 397.08 | 397.44 | 395.9495 | 396.99 | 311408.0 |
| 2024-05-02 12:00:00 | MSFT | Stock | 397.05 | 397.25 | 395.11 | 395.7 | 365878.0 |
| 2024-05-02 12:30:00 | MSFT | Stock | 395.7 | 395.74 | 394.6515 | 395.38 | 340305.0 |
> showing 50 of 97,463 rows — these rows as CSV