PREVIEW / stock_30min / 2024-05-09
file: by_date/stock_30min/2024/2024-05-09.parquet size: 2.0 MB rows: 97,462 symbols: 957
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-09 04:00:00 | AAPL | Stock | 182.75 | 182.75 | 182.33 | 182.38 | 1728.0 |
| 2024-05-09 04:30:00 | AAPL | Stock | 182.37 | 182.37 | 182.13 | 182.2 | 1975.0 |
| 2024-05-09 05:00:00 | AAPL | Stock | 182.18 | 182.24 | 182.12 | 182.2 | 2252.0 |
| 2024-05-09 05:30:00 | AAPL | Stock | 182.2 | 182.21 | 182.17 | 182.17 | 350.0 |
| 2024-05-09 06:00:00 | AAPL | Stock | 182.3 | 182.55 | 182.3 | 182.5 | 6228.0 |
| 2024-05-09 06:30:00 | AAPL | Stock | 182.45 | 182.46 | 182.35 | 182.35 | 1384.0 |
| 2024-05-09 07:00:00 | AAPL | Stock | 182.4 | 182.46 | 182.25 | 182.26 | 8422.0 |
| 2024-05-09 07:30:00 | AAPL | Stock | 182.3 | 182.46 | 182.3 | 182.42 | 1607.0 |
| 2024-05-09 08:00:00 | AAPL | Stock | 182.41 | 182.82 | 182.25 | 182.535 | 25291.0 |
| 2024-05-09 08:30:00 | AAPL | Stock | 182.45 | 182.8599 | 182.4196 | 182.56 | 39352.0 |
| 2024-05-09 09:00:00 | AAPL | Stock | 182.55 | 182.93 | 182.32 | 182.53 | 83023.0 |
| 2024-05-09 09:30:00 | AAPL | Stock | 182.57 | 183.8299 | 182.11 | 183.75 | 5050708.0 |
| 2024-05-09 10:00:00 | AAPL | Stock | 183.75 | 183.7698 | 183.2001 | 183.42 | 2741221.0 |
| 2024-05-09 10:30:00 | AAPL | Stock | 183.425 | 183.86 | 183.11 | 183.2999 | 2963997.0 |
| 2024-05-09 11:00:00 | AAPL | Stock | 183.3 | 183.75 | 183.24 | 183.64 | 1739646.0 |
| 2024-05-09 11:30:00 | AAPL | Stock | 183.65 | 183.845 | 183.515 | 183.541 | 1974327.0 |
| 2024-05-09 12:00:00 | AAPL | Stock | 183.55 | 183.8 | 183.435 | 183.605 | 1457439.0 |
| 2024-05-09 12:30:00 | AAPL | Stock | 183.605 | 184.05 | 183.5399 | 184.02 | 1966327.0 |
| 2024-05-09 13:00:00 | AAPL | Stock | 184.02 | 184.59 | 183.89 | 184.38 | 3187374.0 |
| 2024-05-09 13:30:00 | AAPL | Stock | 184.39 | 184.65 | 184.31 | 184.48 | 2119592.0 |
| 2024-05-09 14:00:00 | AAPL | Stock | 184.48 | 184.5 | 184.06 | 184.25 | 1916617.0 |
| 2024-05-09 14:30:00 | AAPL | Stock | 184.24 | 184.615 | 184.24 | 184.52 | 1647683.0 |
| 2024-05-09 15:00:00 | AAPL | Stock | 184.52 | 184.55 | 184.22 | 184.315 | 1583054.0 |
| 2024-05-09 15:30:00 | AAPL | Stock | 184.31 | 184.66 | 184.3 | 184.65 | 4881329.0 |
| 2024-05-09 16:00:00 | AAPL | Stock | 184.57 | 184.78 | 184.47 | 184.73 | 5953968.0 |
| 2024-05-09 16:30:00 | AAPL | Stock | 184.75 | 184.75 | 184.57 | 184.66 | 50775.0 |
| 2024-05-09 17:00:00 | AAPL | Stock | 184.651 | 184.74 | 184.6 | 184.74 | 19707.0 |
| 2024-05-09 17:30:00 | AAPL | Stock | 184.73 | 185.0 | 184.57 | 184.66 | 46086.0 |
| 2024-05-09 18:00:00 | AAPL | Stock | 184.57 | 184.84 | 184.57 | 184.8 | 8411.0 |
| 2024-05-09 18:30:00 | AAPL | Stock | 184.7 | 184.85 | 184.7 | 184.8 | 4820.0 |
| 2024-05-09 19:00:00 | AAPL | Stock | 184.75 | 184.84 | 184.7 | 184.7 | 12868.0 |
| 2024-05-09 19:30:00 | AAPL | Stock | 184.7 | 184.86 | 184.7 | 184.79 | 17821.0 |
| 2024-05-09 04:00:00 | MSFT | Stock | 409.61 | 410.0 | 409.4 | 410.0 | 312.0 |
| 2024-05-09 04:30:00 | MSFT | Stock | 409.84 | 409.84 | 409.84 | 409.84 | 200.0 |
| 2024-05-09 05:30:00 | MSFT | Stock | 409.64 | 409.7 | 409.64 | 409.7 | 200.0 |
| 2024-05-09 06:00:00 | MSFT | Stock | 409.85 | 410.45 | 409.85 | 410.45 | 787.0 |
| 2024-05-09 06:30:00 | MSFT | Stock | 410.51 | 410.51 | 410.42 | 410.42 | 200.0 |
| 2024-05-09 07:00:00 | MSFT | Stock | 410.0 | 410.1 | 409.05 | 409.7 | 1063.0 |
| 2024-05-09 07:30:00 | MSFT | Stock | 409.61 | 409.61 | 409.61 | 409.61 | 100.0 |
| 2024-05-09 08:00:00 | MSFT | Stock | 409.8543 | 410.5 | 409.513 | 409.68 | 3734.0 |
| 2024-05-09 08:30:00 | MSFT | Stock | 410.0 | 410.988 | 410.0 | 410.8 | 13028.0 |
| 2024-05-09 09:00:00 | MSFT | Stock | 410.7 | 410.8 | 410.4 | 410.4 | 11707.0 |
| 2024-05-09 09:30:00 | MSFT | Stock | 410.35 | 411.33 | 409.1 | 410.41 | 758788.0 |
| 2024-05-09 10:00:00 | MSFT | Stock | 410.415 | 411.28 | 409.5501 | 410.725 | 447602.0 |
| 2024-05-09 10:30:00 | MSFT | Stock | 410.75 | 412.23 | 410.74 | 412.18 | 446536.0 |
| 2024-05-09 11:00:00 | MSFT | Stock | 412.18 | 412.59 | 411.71 | 412.5098 | 402961.0 |
| 2024-05-09 11:30:00 | MSFT | Stock | 412.54 | 412.72 | 411.13 | 411.29 | 246271.0 |
| 2024-05-09 12:00:00 | MSFT | Stock | 411.23 | 411.55 | 410.95 | 411.0 | 249333.0 |
| 2024-05-09 12:30:00 | MSFT | Stock | 411.0226 | 411.63 | 410.7001 | 411.56 | 240221.0 |
| 2024-05-09 13:00:00 | MSFT | Stock | 411.564 | 412.0798 | 411.24 | 412.0096 | 255113.0 |
> showing 50 of 97,462 rows — these rows as CSV