PREVIEW / stock_30min / 2023-08-23
file: by_date/stock_30min/2023/2023-08-23.parquet size: 2.0 MB rows: 98,527 symbols: 1,470
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-23 04:00:00 | AAPL | Stock | 178.0 | 178.33 | 177.95 | 178.21 | 7282.0 |
| 2023-08-23 04:30:00 | AAPL | Stock | 178.21 | 178.32 | 178.2 | 178.32 | 7360.0 |
| 2023-08-23 05:00:00 | AAPL | Stock | 178.29 | 178.43 | 178.01 | 178.16 | 6966.0 |
| 2023-08-23 05:30:00 | AAPL | Stock | 178.11 | 178.31 | 178.11 | 178.23 | 3193.0 |
| 2023-08-23 06:00:00 | AAPL | Stock | 178.27 | 178.37 | 178.17 | 178.17 | 6610.0 |
| 2023-08-23 06:30:00 | AAPL | Stock | 178.1 | 178.22 | 177.82 | 177.93 | 10739.0 |
| 2023-08-23 07:00:00 | AAPL | Stock | 177.85 | 177.85 | 177.31 | 177.6 | 24566.0 |
| 2023-08-23 07:30:00 | AAPL | Stock | 177.57 | 177.85 | 177.55 | 177.75 | 16029.0 |
| 2023-08-23 08:00:00 | AAPL | Stock | 177.92 | 178.42 | 177.3101 | 177.51 | 106154.0 |
| 2023-08-23 08:30:00 | AAPL | Stock | 177.53 | 177.9 | 177.47 | 177.56 | 73201.0 |
| 2023-08-23 09:00:00 | AAPL | Stock | 177.55 | 178.56 | 177.55 | 178.56 | 170864.0 |
| 2023-08-23 09:30:00 | AAPL | Stock | 178.56 | 180.17 | 178.325 | 179.8201 | 6975160.0 |
| 2023-08-23 10:00:00 | AAPL | Stock | 179.84 | 180.39 | 179.465 | 180.105 | 3782633.0 |
| 2023-08-23 10:30:00 | AAPL | Stock | 180.11 | 181.27 | 180.07 | 181.2101 | 4039951.0 |
| 2023-08-23 11:00:00 | AAPL | Stock | 181.2115 | 181.3311 | 180.87 | 181.15 | 2674773.0 |
| 2023-08-23 11:30:00 | AAPL | Stock | 181.15 | 181.31 | 180.79 | 181.13 | 2507476.0 |
| 2023-08-23 12:00:00 | AAPL | Stock | 181.13 | 181.18 | 180.63 | 180.73 | 1713101.0 |
| 2023-08-23 12:30:00 | AAPL | Stock | 180.73 | 180.92 | 180.65 | 180.68 | 1279715.0 |
| 2023-08-23 13:00:00 | AAPL | Stock | 180.68 | 181.29 | 180.63 | 181.24 | 1855301.0 |
| 2023-08-23 13:30:00 | AAPL | Stock | 181.2321 | 181.55 | 181.14 | 181.399 | 1968455.0 |
| 2023-08-23 14:00:00 | AAPL | Stock | 181.399 | 181.4 | 180.8906 | 181.06 | 1767607.0 |
| 2023-08-23 14:30:00 | AAPL | Stock | 181.0691 | 181.1199 | 180.8 | 180.945 | 1374805.0 |
| 2023-08-23 15:00:00 | AAPL | Stock | 180.95 | 181.54 | 180.81 | 181.535 | 2006526.0 |
| 2023-08-23 15:30:00 | AAPL | Stock | 181.535 | 181.54 | 181.0 | 181.14 | 4282724.0 |
| 2023-08-23 16:00:00 | AAPL | Stock | 181.16 | 181.33 | 180.6 | 180.69 | 7024122.0 |
| 2023-08-23 16:30:00 | AAPL | Stock | 180.72 | 181.2 | 180.52 | 180.9 | 258265.0 |
| 2023-08-23 17:00:00 | AAPL | Stock | 180.92 | 181.27 | 180.72 | 180.9999 | 220612.0 |
| 2023-08-23 17:30:00 | AAPL | Stock | 181.0 | 181.12 | 180.69 | 180.83 | 77330.0 |
| 2023-08-23 18:00:00 | AAPL | Stock | 180.85 | 181.0 | 180.7 | 180.83 | 24323.0 |
| 2023-08-23 18:30:00 | AAPL | Stock | 180.75 | 180.89 | 180.7 | 180.89 | 21424.0 |
| 2023-08-23 19:00:00 | AAPL | Stock | 180.89 | 181.9 | 180.8889 | 181.67 | 83173.0 |
| 2023-08-23 19:30:00 | AAPL | Stock | 181.7 | 181.9 | 181.15 | 181.32 | 46630.0 |
| 2023-08-23 04:00:00 | MSFT | Stock | 323.32 | 325.6 | 323.32 | 325.6 | 4004.0 |
| 2023-08-23 04:30:00 | MSFT | Stock | 325.29 | 325.29 | 325.0 | 325.0 | 3141.0 |
| 2023-08-23 05:00:00 | MSFT | Stock | 324.84 | 324.84 | 324.84 | 324.84 | 200.0 |
| 2023-08-23 05:30:00 | MSFT | Stock | 325.17 | 325.17 | 324.9 | 324.9 | 414.0 |
| 2023-08-23 06:00:00 | MSFT | Stock | 324.8 | 324.8 | 324.48 | 324.48 | 720.0 |
| 2023-08-23 06:30:00 | MSFT | Stock | 324.23 | 324.4 | 324.21 | 324.4 | 1128.0 |
| 2023-08-23 07:00:00 | MSFT | Stock | 324.4 | 324.42 | 323.0 | 323.8 | 11162.0 |
| 2023-08-23 07:30:00 | MSFT | Stock | 323.6 | 324.2 | 323.5 | 324.0 | 6086.0 |
| 2023-08-23 08:00:00 | MSFT | Stock | 323.0 | 324.4 | 322.7807 | 323.28 | 19319.0 |
| 2023-08-23 08:30:00 | MSFT | Stock | 323.55 | 324.27 | 323.4667 | 323.6024 | 5962.0 |
| 2023-08-23 09:00:00 | MSFT | Stock | 323.89 | 324.62 | 323.33 | 323.86 | 24286.0 |
| 2023-08-23 09:30:00 | MSFT | Stock | 323.82 | 326.45 | 323.46 | 326.27 | 1751318.0 |
| 2023-08-23 10:00:00 | MSFT | Stock | 326.27 | 327.5 | 325.8 | 327.11 | 1072675.0 |
| 2023-08-23 10:30:00 | MSFT | Stock | 327.135 | 328.45 | 326.8 | 328.17 | 772360.0 |
| 2023-08-23 11:00:00 | MSFT | Stock | 328.17 | 328.82 | 327.59 | 328.3701 | 657286.0 |
| 2023-08-23 11:30:00 | MSFT | Stock | 328.4 | 328.51 | 327.05 | 328.03 | 621744.0 |
| 2023-08-23 12:00:00 | MSFT | Stock | 328.0 | 328.08 | 327.5501 | 327.7375 | 382582.0 |
| 2023-08-23 12:30:00 | MSFT | Stock | 327.72 | 328.49 | 327.705 | 328.04 | 411691.0 |
> showing 50 of 98,527 rows — these rows as CSV