PREVIEW / stock_30min / 2024-02-29
file: by_date/stock_30min/2024/2024-02-29.parquet size: 2.1 MB rows: 103,700 symbols: 1,101
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-02-29 04:00:00 | AAPL | Stock | 180.89 | 180.89 | 180.6 | 180.73 | 7367.0 |
| 2024-02-29 04:30:00 | AAPL | Stock | 180.77 | 181.08 | 180.77 | 180.97 | 5355.0 |
| 2024-02-29 05:00:00 | AAPL | Stock | 180.96 | 180.96 | 180.29 | 180.48 | 13552.0 |
| 2024-02-29 05:30:00 | AAPL | Stock | 180.51 | 181.19 | 180.37 | 180.76 | 28217.0 |
| 2024-02-29 06:00:00 | AAPL | Stock | 180.8 | 180.9 | 180.76 | 180.76 | 3604.0 |
| 2024-02-29 06:30:00 | AAPL | Stock | 180.7 | 180.92 | 180.7 | 180.92 | 3115.0 |
| 2024-02-29 07:00:00 | AAPL | Stock | 181.0 | 181.0 | 180.65 | 180.65 | 9884.0 |
| 2024-02-29 07:30:00 | AAPL | Stock | 180.61 | 180.65 | 180.4 | 180.51 | 9404.0 |
| 2024-02-29 08:00:00 | AAPL | Stock | 180.89 | 181.41 | 180.4 | 180.63 | 80419.0 |
| 2024-02-29 08:30:00 | AAPL | Stock | 180.7 | 181.85 | 180.7 | 181.62 | 171348.0 |
| 2024-02-29 09:00:00 | AAPL | Stock | 181.62 | 181.7 | 181.0 | 181.25 | 174519.0 |
| 2024-02-29 09:30:00 | AAPL | Stock | 181.26 | 182.57 | 181.17 | 181.5 | 6129397.0 |
| 2024-02-29 10:00:00 | AAPL | Stock | 181.5 | 182.135 | 181.29 | 181.62 | 3980403.0 |
| 2024-02-29 10:30:00 | AAPL | Stock | 181.6253 | 181.71 | 180.71 | 180.9499 | 3318636.0 |
| 2024-02-29 11:00:00 | AAPL | Stock | 180.955 | 180.965 | 180.42 | 180.43 | 2695423.0 |
| 2024-02-29 11:30:00 | AAPL | Stock | 180.425 | 180.43 | 179.53 | 180.11 | 4420212.0 |
| 2024-02-29 12:00:00 | AAPL | Stock | 180.105 | 180.31 | 179.8017 | 179.82 | 2387786.0 |
| 2024-02-29 12:30:00 | AAPL | Stock | 179.82 | 180.18 | 179.65 | 180.145 | 2740699.0 |
| 2024-02-29 13:00:00 | AAPL | Stock | 180.145 | 180.8 | 180.14 | 180.38 | 2612223.0 |
| 2024-02-29 13:30:00 | AAPL | Stock | 180.38 | 180.41 | 179.68 | 180.085 | 2819272.0 |
| 2024-02-29 14:00:00 | AAPL | Stock | 180.085 | 180.49 | 179.98 | 180.11 | 2498121.0 |
| 2024-02-29 14:30:00 | AAPL | Stock | 180.12 | 180.24 | 179.86 | 180.2 | 2255422.0 |
| 2024-02-29 15:00:00 | AAPL | Stock | 180.2 | 180.7 | 180.19 | 180.585 | 3070797.0 |
| 2024-02-29 15:30:00 | AAPL | Stock | 180.585 | 181.11 | 179.57 | 180.77 | 11246879.0 |
| 2024-02-29 16:00:00 | AAPL | Stock | 180.73 | 180.96 | 180.35 | 180.9 | 54950272.0 |
| 2024-02-29 16:30:00 | AAPL | Stock | 180.9 | 180.95 | 180.72 | 180.89 | 73707.0 |
| 2024-02-29 17:00:00 | AAPL | Stock | 180.88 | 180.89 | 180.7 | 180.79 | 177628.0 |
| 2024-02-29 17:30:00 | AAPL | Stock | 180.75 | 180.75 | 180.5 | 180.6013 | 43137.0 |
| 2024-02-29 18:00:00 | AAPL | Stock | 180.6 | 180.66 | 180.2 | 180.21 | 37752.0 |
| 2024-02-29 18:30:00 | AAPL | Stock | 180.21 | 180.33 | 180.2 | 180.3059 | 8535.0 |
| 2024-02-29 19:00:00 | AAPL | Stock | 180.3 | 180.65 | 180.3 | 180.65 | 22886.0 |
| 2024-02-29 19:30:00 | AAPL | Stock | 180.66 | 180.67 | 180.56 | 180.63 | 7267.0 |
| 2024-02-29 04:00:00 | MSFT | Stock | 405.99 | 405.99 | 405.37 | 405.61 | 1816.0 |
| 2024-02-29 04:30:00 | MSFT | Stock | 405.51 | 405.67 | 405.4 | 405.67 | 2474.0 |
| 2024-02-29 05:00:00 | MSFT | Stock | 405.6 | 406.85 | 405.6 | 406.82 | 2085.0 |
| 2024-02-29 05:30:00 | MSFT | Stock | 406.76 | 406.76 | 405.7 | 405.7 | 2710.0 |
| 2024-02-29 06:00:00 | MSFT | Stock | 405.69 | 405.92 | 405.65 | 405.8 | 2706.0 |
| 2024-02-29 06:30:00 | MSFT | Stock | 405.85 | 406.56 | 405.84 | 406.56 | 2563.0 |
| 2024-02-29 07:00:00 | MSFT | Stock | 406.85 | 406.85 | 406.15 | 406.15 | 1928.0 |
| 2024-02-29 07:30:00 | MSFT | Stock | 406.5 | 406.54 | 406.14 | 406.14 | 592.0 |
| 2024-02-29 08:00:00 | MSFT | Stock | 406.15 | 406.8147 | 405.09 | 406.58 | 11685.0 |
| 2024-02-29 08:30:00 | MSFT | Stock | 407.0 | 409.75 | 407.0 | 409.2 | 59584.0 |
| 2024-02-29 09:00:00 | MSFT | Stock | 409.22 | 409.85 | 408.38 | 408.65 | 37913.0 |
| 2024-02-29 09:30:00 | MSFT | Stock | 408.77 | 410.205 | 407.74 | 409.81 | 2011672.0 |
| 2024-02-29 10:00:00 | MSFT | Stock | 409.81 | 410.12 | 407.85 | 408.33 | 1006885.0 |
| 2024-02-29 10:30:00 | MSFT | Stock | 408.36 | 408.82 | 407.43 | 407.75 | 627103.0 |
| 2024-02-29 11:00:00 | MSFT | Stock | 407.8 | 408.7 | 407.49 | 407.83 | 525542.0 |
| 2024-02-29 11:30:00 | MSFT | Stock | 407.79 | 407.92 | 405.92 | 407.7468 | 608126.0 |
| 2024-02-29 12:00:00 | MSFT | Stock | 407.74 | 408.36 | 407.52 | 407.85 | 355993.0 |
| 2024-02-29 12:30:00 | MSFT | Stock | 407.87 | 408.93 | 407.8503 | 408.66 | 398500.0 |
> showing 50 of 103,700 rows — these rows as CSV