PREVIEW / stock_30min / 2023-12-05
file: by_date/stock_30min/2023/2023-12-05.parquet size: 2.1 MB rows: 100,363 symbols: 1,292
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-12-05 04:00:00 | AAPL | Stock | 188.7 | 189.38 | 188.7 | 188.95 | 16305.0 |
| 2023-12-05 04:30:00 | AAPL | Stock | 188.61 | 188.72 | 188.6 | 188.72 | 1384.0 |
| 2023-12-05 05:00:00 | AAPL | Stock | 188.6 | 188.61 | 188.0 | 188.55 | 21875.0 |
| 2023-12-05 05:30:00 | AAPL | Stock | 188.64 | 188.77 | 188.4 | 188.67 | 34214.0 |
| 2023-12-05 06:00:00 | AAPL | Stock | 188.76 | 188.86 | 188.6 | 188.7 | 16065.0 |
| 2023-12-05 06:30:00 | AAPL | Stock | 188.71 | 188.77 | 188.56 | 188.57 | 11838.0 |
| 2023-12-05 07:00:00 | AAPL | Stock | 188.64 | 189.32 | 188.61 | 189.1 | 22836.0 |
| 2023-12-05 07:30:00 | AAPL | Stock | 189.22 | 190.5 | 188.97 | 190.26 | 86534.0 |
| 2023-12-05 08:00:00 | AAPL | Stock | 188.605 | 190.47 | 188.15 | 190.3 | 94012.0 |
| 2023-12-05 08:30:00 | AAPL | Stock | 190.31 | 190.49 | 190.0 | 190.05 | 52342.0 |
| 2023-12-05 09:00:00 | AAPL | Stock | 190.06 | 190.3 | 189.84 | 190.21 | 103359.0 |
| 2023-12-05 09:30:00 | AAPL | Stock | 190.21 | 193.35 | 190.18 | 192.69 | 11376696.0 |
| 2023-12-05 10:00:00 | AAPL | Stock | 192.66 | 194.31 | 192.61 | 193.59 | 7008650.0 |
| 2023-12-05 10:30:00 | AAPL | Stock | 193.5846 | 194.36 | 193.54 | 194.26 | 3969617.0 |
| 2023-12-05 11:00:00 | AAPL | Stock | 194.265 | 194.4 | 193.47 | 193.56 | 2989925.0 |
| 2023-12-05 11:30:00 | AAPL | Stock | 193.56 | 193.8 | 192.62 | 193.2141 | 2871728.0 |
| 2023-12-05 12:00:00 | AAPL | Stock | 193.22 | 193.78 | 193.15 | 193.76 | 2281465.0 |
| 2023-12-05 12:30:00 | AAPL | Stock | 193.77 | 193.83 | 192.95 | 193.62 | 1914062.0 |
| 2023-12-05 13:00:00 | AAPL | Stock | 193.63 | 193.66 | 193.13 | 193.14 | 1629726.0 |
| 2023-12-05 13:30:00 | AAPL | Stock | 193.145 | 193.24 | 192.85 | 192.91 | 1702210.0 |
| 2023-12-05 14:00:00 | AAPL | Stock | 192.91 | 193.31 | 192.75 | 192.99 | 1675659.0 |
| 2023-12-05 14:30:00 | AAPL | Stock | 193.0 | 193.26 | 192.77 | 193.22 | 1855730.0 |
| 2023-12-05 15:00:00 | AAPL | Stock | 193.2201 | 193.47 | 193.1 | 193.1917 | 2061734.0 |
| 2023-12-05 15:30:00 | AAPL | Stock | 193.195 | 193.54 | 192.87 | 193.5 | 5470971.0 |
| 2023-12-05 16:00:00 | AAPL | Stock | 193.5 | 193.5 | 193.31 | 193.42 | 6975130.0 |
| 2023-12-05 16:30:00 | AAPL | Stock | 193.4 | 193.42 | 193.33 | 193.4 | 83512.0 |
| 2023-12-05 17:00:00 | AAPL | Stock | 193.41 | 193.41 | 193.24 | 193.24 | 15223.0 |
| 2023-12-05 17:30:00 | AAPL | Stock | 193.23 | 193.25 | 193.2 | 193.23 | 21368.0 |
| 2023-12-05 18:00:00 | AAPL | Stock | 193.22 | 193.42 | 192.95 | 193.0 | 90257.0 |
| 2023-12-05 18:30:00 | AAPL | Stock | 192.99 | 193.36 | 192.895 | 193.33 | 109299.0 |
| 2023-12-05 19:00:00 | AAPL | Stock | 193.33 | 193.87 | 193.33 | 193.74 | 22838.0 |
| 2023-12-05 19:30:00 | AAPL | Stock | 193.71 | 193.9 | 193.66 | 193.79 | 24776.0 |
| 2023-12-05 04:00:00 | MSFT | Stock | 368.66 | 368.66 | 368.36 | 368.38 | 1318.0 |
| 2023-12-05 04:30:00 | MSFT | Stock | 368.2 | 368.29 | 367.81 | 368.06 | 1972.0 |
| 2023-12-05 05:00:00 | MSFT | Stock | 368.11 | 368.12 | 367.8 | 367.8 | 1854.0 |
| 2023-12-05 05:30:00 | MSFT | Stock | 367.85 | 367.85 | 367.3 | 367.45 | 1219.0 |
| 2023-12-05 06:00:00 | MSFT | Stock | 367.7 | 368.08 | 367.69 | 367.8 | 2087.0 |
| 2023-12-05 06:30:00 | MSFT | Stock | 367.73 | 367.85 | 367.6 | 367.62 | 3464.0 |
| 2023-12-05 07:00:00 | MSFT | Stock | 367.53 | 368.0 | 367.4 | 367.85 | 6189.0 |
| 2023-12-05 07:30:00 | MSFT | Stock | 367.56 | 367.7 | 366.8 | 366.8 | 5805.0 |
| 2023-12-05 08:00:00 | MSFT | Stock | 367.58 | 369.2 | 366.72 | 368.41 | 21229.0 |
| 2023-12-05 08:30:00 | MSFT | Stock | 368.31 | 368.44 | 367.79 | 368.02 | 10569.0 |
| 2023-12-05 09:00:00 | MSFT | Stock | 368.02 | 368.39 | 365.76 | 366.32 | 32306.0 |
| 2023-12-05 09:30:00 | MSFT | Stock | 366.45 | 370.06 | 365.621 | 369.76 | 2463474.0 |
| 2023-12-05 10:00:00 | MSFT | Stock | 369.7 | 371.41 | 369.21 | 370.5447 | 1521774.0 |
| 2023-12-05 10:30:00 | MSFT | Stock | 370.6 | 373.075 | 370.3301 | 371.79 | 1421442.0 |
| 2023-12-05 11:00:00 | MSFT | Stock | 371.785 | 373.075 | 370.39 | 370.76 | 1211319.0 |
| 2023-12-05 11:30:00 | MSFT | Stock | 370.79 | 371.36 | 369.36 | 370.66 | 890184.0 |
| 2023-12-05 12:00:00 | MSFT | Stock | 370.68 | 371.84 | 370.68 | 371.7938 | 568439.0 |
| 2023-12-05 12:30:00 | MSFT | Stock | 371.78 | 372.07 | 370.5003 | 371.7694 | 536307.0 |
> showing 50 of 100,363 rows — these rows as CSV