PREVIEW / stock_30min / 2024-03-26
file: by_date/stock_30min/2024/2024-03-26.parquet size: 2.1 MB rows: 99,858 symbols: 1,070
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-03-26 04:00:00 | AAPL | Stock | 171.05 | 171.45 | 171.01 | 171.25 | 8699.0 |
| 2024-03-26 04:30:00 | AAPL | Stock | 171.23 | 171.37 | 171.23 | 171.34 | 2146.0 |
| 2024-03-26 05:00:00 | AAPL | Stock | 171.33 | 171.41 | 171.32 | 171.41 | 3072.0 |
| 2024-03-26 05:30:00 | AAPL | Stock | 171.46 | 171.5 | 171.36 | 171.39 | 4625.0 |
| 2024-03-26 06:00:00 | AAPL | Stock | 171.4 | 171.55 | 171.4 | 171.52 | 6338.0 |
| 2024-03-26 06:30:00 | AAPL | Stock | 171.52 | 171.75 | 171.51 | 171.73 | 6041.0 |
| 2024-03-26 07:00:00 | AAPL | Stock | 171.65 | 171.68 | 171.43 | 171.43 | 11417.0 |
| 2024-03-26 07:30:00 | AAPL | Stock | 171.43 | 171.45 | 171.3 | 171.45 | 9694.0 |
| 2024-03-26 08:00:00 | AAPL | Stock | 171.66 | 171.7353 | 170.84 | 171.28 | 71027.0 |
| 2024-03-26 08:30:00 | AAPL | Stock | 171.27 | 171.35 | 169.11 | 170.62 | 609593.0 |
| 2024-03-26 09:00:00 | AAPL | Stock | 170.56 | 170.56 | 169.82 | 170.04 | 232457.0 |
| 2024-03-26 09:30:00 | AAPL | Stock | 170.02 | 170.8399 | 169.65 | 170.74 | 6000276.0 |
| 2024-03-26 10:00:00 | AAPL | Stock | 170.74 | 171.0699 | 170.605 | 170.72 | 3295397.0 |
| 2024-03-26 10:30:00 | AAPL | Stock | 170.72 | 170.89 | 170.36 | 170.645 | 2612036.0 |
| 2024-03-26 11:00:00 | AAPL | Stock | 170.65 | 170.87 | 170.44 | 170.651 | 1642709.0 |
| 2024-03-26 11:30:00 | AAPL | Stock | 170.655 | 170.79 | 170.495 | 170.5701 | 1574586.0 |
| 2024-03-26 12:00:00 | AAPL | Stock | 170.575 | 171.25 | 170.55 | 171.2311 | 2857278.0 |
| 2024-03-26 12:30:00 | AAPL | Stock | 171.24 | 171.24 | 170.915 | 171.05 | 1450063.0 |
| 2024-03-26 13:00:00 | AAPL | Stock | 171.05 | 171.42 | 170.675 | 170.82 | 2413538.0 |
| 2024-03-26 13:30:00 | AAPL | Stock | 170.824 | 170.9 | 170.28 | 170.295 | 1751221.0 |
| 2024-03-26 14:00:00 | AAPL | Stock | 170.29 | 170.5799 | 170.16 | 170.52 | 1897666.0 |
| 2024-03-26 14:30:00 | AAPL | Stock | 170.5125 | 170.575 | 170.3901 | 170.55 | 1235207.0 |
| 2024-03-26 15:00:00 | AAPL | Stock | 170.55 | 170.685 | 170.33 | 170.54 | 1913476.0 |
| 2024-03-26 15:30:00 | AAPL | Stock | 170.54 | 170.55 | 169.58 | 169.815 | 7593062.0 |
| 2024-03-26 16:00:00 | AAPL | Stock | 169.82 | 170.1 | 169.71 | 169.92 | 10154670.0 |
| 2024-03-26 16:30:00 | AAPL | Stock | 169.93 | 170.0 | 169.71 | 169.92 | 101236.0 |
| 2024-03-26 17:00:00 | AAPL | Stock | 169.91 | 169.94 | 169.64 | 169.71 | 57414.0 |
| 2024-03-26 17:30:00 | AAPL | Stock | 169.71 | 170.0 | 169.7 | 169.88 | 26790.0 |
| 2024-03-26 18:00:00 | AAPL | Stock | 169.87 | 169.9 | 169.85 | 169.88 | 11869.0 |
| 2024-03-26 18:30:00 | AAPL | Stock | 169.88 | 169.9 | 169.8 | 169.89 | 21937.0 |
| 2024-03-26 19:00:00 | AAPL | Stock | 169.89 | 169.9 | 169.81 | 169.9 | 8643.0 |
| 2024-03-26 19:30:00 | AAPL | Stock | 169.9 | 169.98 | 169.89 | 169.98 | 12140.0 |
| 2024-03-26 04:00:00 | MSFT | Stock | 424.59 | 424.59 | 424.59 | 424.59 | 200.0 |
| 2024-03-26 04:30:00 | MSFT | Stock | 424.75 | 425.24 | 424.75 | 425.07 | 845.0 |
| 2024-03-26 05:00:00 | MSFT | Stock | 425.4 | 426.32 | 425.4 | 425.94 | 3902.0 |
| 2024-03-26 05:30:00 | MSFT | Stock | 425.99 | 426.0 | 425.99 | 426.0 | 561.0 |
| 2024-03-26 06:00:00 | MSFT | Stock | 426.0 | 426.09 | 425.83 | 425.83 | 2210.0 |
| 2024-03-26 06:30:00 | MSFT | Stock | 425.7 | 425.7 | 425.02 | 425.39 | 2938.0 |
| 2024-03-26 07:00:00 | MSFT | Stock | 425.45 | 425.49 | 425.0 | 425.0 | 4130.0 |
| 2024-03-26 07:30:00 | MSFT | Stock | 424.73 | 424.81 | 424.73 | 424.8 | 1178.0 |
| 2024-03-26 08:00:00 | MSFT | Stock | 425.4 | 425.5 | 422.86 | 424.95 | 24045.0 |
| 2024-03-26 08:30:00 | MSFT | Stock | 425.0 | 425.0 | 424.4 | 424.5 | 5743.0 |
| 2024-03-26 09:00:00 | MSFT | Stock | 424.65 | 425.79 | 424.2 | 425.61 | 14199.0 |
| 2024-03-26 09:30:00 | MSFT | Stock | 425.62 | 425.99 | 422.9 | 423.6115 | 1109199.0 |
| 2024-03-26 10:00:00 | MSFT | Stock | 423.62 | 424.9 | 423.615 | 424.4 | 690383.0 |
| 2024-03-26 10:30:00 | MSFT | Stock | 424.41 | 424.71 | 423.81 | 424.29 | 636307.0 |
| 2024-03-26 11:00:00 | MSFT | Stock | 424.31 | 424.51 | 423.68 | 424.0 | 339018.0 |
| 2024-03-26 11:30:00 | MSFT | Stock | 424.0 | 424.86 | 423.9 | 424.805 | 407291.0 |
| 2024-03-26 12:00:00 | MSFT | Stock | 424.79 | 425.065 | 423.36 | 423.665 | 435336.0 |
| 2024-03-26 12:30:00 | MSFT | Stock | 423.69 | 423.8694 | 422.46 | 422.71 | 519371.0 |
> showing 50 of 99,858 rows — these rows as CSV