PREVIEW / stock_30min / 2024-04-29
file: by_date/stock_30min/2024/2024-04-29.parquet size: 2.0 MB rows: 97,310 symbols: 984
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-29 04:00:00 | AAPL | Stock | 170.49 | 172.1 | 170.49 | 171.63 | 38443.0 |
| 2024-04-29 04:30:00 | AAPL | Stock | 171.69 | 172.22 | 171.36 | 172.13 | 31896.0 |
| 2024-04-29 05:00:00 | AAPL | Stock | 172.0 | 172.3 | 171.87 | 172.05 | 29568.0 |
| 2024-04-29 05:30:00 | AAPL | Stock | 172.13 | 172.32 | 172.0 | 172.2 | 19515.0 |
| 2024-04-29 06:00:00 | AAPL | Stock | 172.2 | 172.7 | 172.18 | 172.59 | 36991.0 |
| 2024-04-29 06:30:00 | AAPL | Stock | 172.69 | 173.0 | 172.57 | 172.7 | 32367.0 |
| 2024-04-29 07:00:00 | AAPL | Stock | 172.7 | 173.25 | 172.16 | 173.15 | 99838.0 |
| 2024-04-29 07:30:00 | AAPL | Stock | 173.15 | 173.68 | 173.01 | 173.65 | 84764.0 |
| 2024-04-29 08:00:00 | AAPL | Stock | 173.65 | 173.75 | 170.25 | 173.66 | 253089.0 |
| 2024-04-29 08:30:00 | AAPL | Stock | 173.67 | 173.69 | 173.4082 | 173.47 | 101843.0 |
| 2024-04-29 09:00:00 | AAPL | Stock | 173.55 | 173.78 | 172.79 | 173.43 | 235962.0 |
| 2024-04-29 09:30:00 | AAPL | Stock | 173.37 | 176.03 | 173.13 | 175.19 | 12416921.0 |
| 2024-04-29 10:00:00 | AAPL | Stock | 175.2 | 175.99 | 174.515 | 174.76 | 4816150.0 |
| 2024-04-29 10:30:00 | AAPL | Stock | 174.75 | 175.07 | 174.38 | 174.8625 | 3031360.0 |
| 2024-04-29 11:00:00 | AAPL | Stock | 174.87 | 175.13 | 173.98 | 174.51 | 3260275.0 |
| 2024-04-29 11:30:00 | AAPL | Stock | 174.5199 | 174.71 | 174.01 | 174.6701 | 2771772.0 |
| 2024-04-29 12:00:00 | AAPL | Stock | 174.68 | 174.825 | 174.255 | 174.325 | 1778921.0 |
| 2024-04-29 12:30:00 | AAPL | Stock | 174.3277 | 174.67 | 174.22 | 174.55 | 1714052.0 |
| 2024-04-29 13:00:00 | AAPL | Stock | 174.555 | 174.89 | 174.39 | 174.87 | 1898573.0 |
| 2024-04-29 13:30:00 | AAPL | Stock | 174.87 | 175.105 | 174.52 | 174.81 | 1735189.0 |
| 2024-04-29 14:00:00 | AAPL | Stock | 174.805 | 174.8064 | 174.09 | 174.2658 | 1702813.0 |
| 2024-04-29 14:30:00 | AAPL | Stock | 174.2601 | 174.66 | 173.945 | 174.62 | 1960086.0 |
| 2024-04-29 15:00:00 | AAPL | Stock | 174.62 | 174.62 | 173.3515 | 173.825 | 2500111.0 |
| 2024-04-29 15:30:00 | AAPL | Stock | 173.825 | 173.9789 | 173.1 | 173.53 | 4742387.0 |
| 2024-04-29 16:00:00 | AAPL | Stock | 173.5 | 173.67 | 173.49 | 173.57 | 7466139.0 |
| 2024-04-29 16:30:00 | AAPL | Stock | 173.57 | 173.75 | 173.5 | 173.5 | 162392.0 |
| 2024-04-29 17:00:00 | AAPL | Stock | 173.67 | 173.7 | 173.5 | 173.55 | 21121.0 |
| 2024-04-29 17:30:00 | AAPL | Stock | 173.55 | 173.65 | 173.52 | 173.6 | 11056.0 |
| 2024-04-29 18:00:00 | AAPL | Stock | 173.64 | 173.64 | 173.52 | 173.56 | 11845.0 |
| 2024-04-29 18:30:00 | AAPL | Stock | 173.59 | 173.63 | 173.52 | 173.6 | 8972.0 |
| 2024-04-29 19:00:00 | AAPL | Stock | 173.57 | 173.69 | 173.54 | 173.5883 | 5840.0 |
| 2024-04-29 19:30:00 | AAPL | Stock | 173.52 | 173.77 | 173.52 | 173.52 | 14137.0 |
| 2024-04-29 04:00:00 | MSFT | Stock | 408.5 | 410.0 | 407.53 | 407.53 | 8610.0 |
| 2024-04-29 04:30:00 | MSFT | Stock | 407.56 | 407.86 | 407.5 | 407.8 | 1938.0 |
| 2024-04-29 05:00:00 | MSFT | Stock | 407.48 | 407.75 | 407.45 | 407.7 | 5239.0 |
| 2024-04-29 05:30:00 | MSFT | Stock | 407.63 | 407.87 | 407.3 | 407.3 | 1917.0 |
| 2024-04-29 06:00:00 | MSFT | Stock | 407.18 | 407.18 | 407.18 | 407.18 | 100.0 |
| 2024-04-29 06:30:00 | MSFT | Stock | 407.44 | 407.6 | 407.44 | 407.6 | 1242.0 |
| 2024-04-29 07:00:00 | MSFT | Stock | 407.09 | 407.2 | 405.54 | 406.49 | 14416.0 |
| 2024-04-29 07:30:00 | MSFT | Stock | 406.6 | 407.0 | 405.61 | 405.61 | 10041.0 |
| 2024-04-29 08:00:00 | MSFT | Stock | 406.35 | 409.35 | 405.01 | 405.45 | 47064.0 |
| 2024-04-29 08:30:00 | MSFT | Stock | 405.6599 | 405.75 | 405.17 | 405.75 | 17867.0 |
| 2024-04-29 09:00:00 | MSFT | Stock | 405.75 | 406.0 | 405.27 | 405.56 | 31361.0 |
| 2024-04-29 09:30:00 | MSFT | Stock | 405.25 | 406.32 | 399.19 | 401.3425 | 3000210.0 |
| 2024-04-29 10:00:00 | MSFT | Stock | 401.285 | 401.7724 | 400.25 | 401.155 | 1408796.0 |
| 2024-04-29 10:30:00 | MSFT | Stock | 401.19 | 402.63 | 401.13 | 401.9278 | 675129.0 |
| 2024-04-29 11:00:00 | MSFT | Stock | 401.9 | 402.1 | 400.29 | 400.45 | 673001.0 |
| 2024-04-29 11:30:00 | MSFT | Stock | 400.47 | 400.97 | 400.1035 | 400.9 | 565196.0 |
| 2024-04-29 12:00:00 | MSFT | Stock | 400.92 | 401.37 | 400.6 | 401.2 | 423603.0 |
| 2024-04-29 12:30:00 | MSFT | Stock | 401.21 | 401.6796 | 400.85 | 401.41 | 348963.0 |
> showing 50 of 97,310 rows — these rows as CSV