PREVIEW / stock_30min / 2024-03-13
file: by_date/stock_30min/2024/2024-03-13.parquet size: 2.1 MB rows: 101,022 symbols: 1,095
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-13 04:00:00 | AAPL | Stock | 173.31 | 173.31 | 172.94 | 172.94 | 3104.0 |
| 2024-03-13 04:30:00 | AAPL | Stock | 172.91 | 173.08 | 172.85 | 173.08 | 1604.0 |
| 2024-03-13 05:00:00 | AAPL | Stock | 173.0 | 173.0 | 172.85 | 172.9 | 4733.0 |
| 2024-03-13 05:30:00 | AAPL | Stock | 172.99 | 173.07 | 172.99 | 173.05 | 1339.0 |
| 2024-03-13 06:00:00 | AAPL | Stock | 173.08 | 173.18 | 173.07 | 173.18 | 3116.0 |
| 2024-03-13 06:30:00 | AAPL | Stock | 173.14 | 173.23 | 173.14 | 173.23 | 1211.0 |
| 2024-03-13 07:00:00 | AAPL | Stock | 173.22 | 173.23 | 172.86 | 172.86 | 17651.0 |
| 2024-03-13 07:30:00 | AAPL | Stock | 172.87 | 172.87 | 172.74 | 172.81 | 11163.0 |
| 2024-03-13 08:00:00 | AAPL | Stock | 173.2297 | 173.34 | 172.4101 | 172.67 | 59032.0 |
| 2024-03-13 08:30:00 | AAPL | Stock | 172.77 | 173.2055 | 172.66 | 173.06 | 46455.0 |
| 2024-03-13 09:00:00 | AAPL | Stock | 173.07 | 173.5 | 172.57 | 172.88 | 141045.0 |
| 2024-03-13 09:30:00 | AAPL | Stock | 172.88 | 173.185 | 171.56 | 171.6653 | 4982609.0 |
| 2024-03-13 10:00:00 | AAPL | Stock | 171.67 | 171.7 | 170.76 | 170.985 | 4510173.0 |
| 2024-03-13 10:30:00 | AAPL | Stock | 170.985 | 171.35 | 170.91 | 171.04 | 2838548.0 |
| 2024-03-13 11:00:00 | AAPL | Stock | 171.035 | 171.21 | 170.865 | 170.995 | 2031157.0 |
| 2024-03-13 11:30:00 | AAPL | Stock | 171.0 | 171.18 | 170.8999 | 171.0301 | 1921053.0 |
| 2024-03-13 12:00:00 | AAPL | Stock | 171.04 | 171.14 | 170.8527 | 171.06 | 1700811.0 |
| 2024-03-13 12:30:00 | AAPL | Stock | 171.07 | 171.12 | 170.94 | 171.015 | 1318395.0 |
| 2024-03-13 13:00:00 | AAPL | Stock | 171.015 | 171.46 | 171.01 | 171.435 | 2155606.0 |
| 2024-03-13 13:30:00 | AAPL | Stock | 171.43 | 171.53 | 171.16 | 171.5 | 1611884.0 |
| 2024-03-13 14:00:00 | AAPL | Stock | 171.4998 | 171.76 | 171.44 | 171.58 | 1555153.0 |
| 2024-03-13 14:30:00 | AAPL | Stock | 171.58 | 171.8 | 171.51 | 171.65 | 1344467.0 |
| 2024-03-13 15:00:00 | AAPL | Stock | 171.65 | 171.74 | 171.03 | 171.29 | 2071560.0 |
| 2024-03-13 15:30:00 | AAPL | Stock | 171.28 | 171.705 | 171.04 | 171.17 | 4798273.0 |
| 2024-03-13 16:00:00 | AAPL | Stock | 171.175 | 172.322 | 170.98 | 171.17 | 8003393.0 |
| 2024-03-13 16:30:00 | AAPL | Stock | 171.15 | 171.32 | 171.08 | 171.13 | 43177.0 |
| 2024-03-13 17:00:00 | AAPL | Stock | 171.3 | 171.3 | 171.1 | 171.173 | 10696.0 |
| 2024-03-13 17:30:00 | AAPL | Stock | 171.1501 | 171.2 | 171.0206 | 171.0206 | 92691.0 |
| 2024-03-13 18:00:00 | AAPL | Stock | 171.11 | 171.4 | 171.11 | 171.2 | 17576.0 |
| 2024-03-13 18:30:00 | AAPL | Stock | 171.1453 | 171.35 | 171.1453 | 171.2545 | 10568.0 |
| 2024-03-13 19:00:00 | AAPL | Stock | 171.27 | 171.4 | 171.21 | 171.37 | 5958.0 |
| 2024-03-13 19:30:00 | AAPL | Stock | 171.36 | 171.58 | 171.36 | 171.5 | 10419.0 |
| 2024-03-13 04:00:00 | MSFT | Stock | 415.99 | 415.99 | 415.23 | 415.23 | 1184.0 |
| 2024-03-13 04:30:00 | MSFT | Stock | 415.1 | 415.1 | 414.97 | 415.0 | 1198.0 |
| 2024-03-13 05:00:00 | MSFT | Stock | 415.0 | 415.0 | 414.81 | 414.86 | 1877.0 |
| 2024-03-13 05:30:00 | MSFT | Stock | 414.89 | 414.99 | 414.89 | 414.99 | 356.0 |
| 2024-03-13 06:00:00 | MSFT | Stock | 414.9 | 415.28 | 414.9 | 415.28 | 545.0 |
| 2024-03-13 06:30:00 | MSFT | Stock | 415.38 | 416.63 | 415.38 | 416.63 | 4685.0 |
| 2024-03-13 07:00:00 | MSFT | Stock | 416.55 | 418.5 | 416.55 | 417.9 | 27476.0 |
| 2024-03-13 07:30:00 | MSFT | Stock | 418.0 | 418.86 | 417.59 | 417.75 | 10086.0 |
| 2024-03-13 08:00:00 | MSFT | Stock | 418.33 | 418.65 | 415.66 | 416.99 | 42002.0 |
| 2024-03-13 08:30:00 | MSFT | Stock | 416.77 | 417.7 | 416.67 | 417.7 | 13340.0 |
| 2024-03-13 09:00:00 | MSFT | Stock | 417.75 | 418.61 | 417.45 | 418.11 | 42855.0 |
| 2024-03-13 09:30:00 | MSFT | Stock | 418.17 | 418.18 | 412.0 | 412.2999 | 2034681.0 |
| 2024-03-13 10:00:00 | MSFT | Stock | 412.3 | 413.6 | 411.45 | 412.7999 | 946354.0 |
| 2024-03-13 10:30:00 | MSFT | Stock | 412.75 | 414.88 | 412.68 | 414.11 | 712781.0 |
| 2024-03-13 11:00:00 | MSFT | Stock | 414.11 | 415.287 | 413.85 | 414.26 | 512677.0 |
| 2024-03-13 11:30:00 | MSFT | Stock | 414.24 | 414.99 | 413.74 | 414.85 | 351669.0 |
| 2024-03-13 12:00:00 | MSFT | Stock | 414.86 | 415.24 | 414.46 | 414.89 | 323600.0 |
| 2024-03-13 12:30:00 | MSFT | Stock | 414.94 | 415.53 | 414.64 | 415.1624 | 338676.0 |
> showing 50 of 101,022 rows — these rows as CSV