PREVIEW / stock_30min / 2023-08-11
file: by_date/stock_30min/2023/2023-08-11.parquet size: 2.0 MB rows: 97,768 symbols: 1,487
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-11 04:00:00 | AAPL | Stock | 178.43 | 178.48 | 177.68 | 177.73 | 19257.0 |
| 2023-08-11 04:30:00 | AAPL | Stock | 177.68 | 177.77 | 177.4 | 177.69 | 7149.0 |
| 2023-08-11 05:00:00 | AAPL | Stock | 177.74 | 177.77 | 177.68 | 177.68 | 3164.0 |
| 2023-08-11 05:30:00 | AAPL | Stock | 177.75 | 177.8 | 177.37 | 177.58 | 6045.0 |
| 2023-08-11 06:00:00 | AAPL | Stock | 177.62 | 177.62 | 177.52 | 177.58 | 4121.0 |
| 2023-08-11 06:30:00 | AAPL | Stock | 177.6 | 177.7 | 177.6 | 177.67 | 5249.0 |
| 2023-08-11 07:00:00 | AAPL | Stock | 177.74 | 178.1 | 177.69 | 178.1 | 11392.0 |
| 2023-08-11 07:30:00 | AAPL | Stock | 178.08 | 178.1 | 177.85 | 177.93 | 32676.0 |
| 2023-08-11 08:00:00 | AAPL | Stock | 177.79 | 178.75 | 177.7204 | 178.07 | 78447.0 |
| 2023-08-11 08:30:00 | AAPL | Stock | 178.06 | 178.07 | 177.13 | 177.35 | 212695.0 |
| 2023-08-11 09:00:00 | AAPL | Stock | 177.27 | 177.55 | 177.25 | 177.32 | 105685.0 |
| 2023-08-11 09:30:00 | AAPL | Stock | 177.35 | 177.62 | 176.55 | 176.86 | 5296552.0 |
| 2023-08-11 10:00:00 | AAPL | Stock | 176.86 | 178.62 | 176.86 | 178.27 | 5078242.0 |
| 2023-08-11 10:30:00 | AAPL | Stock | 178.29 | 178.605 | 177.95 | 178.01 | 3122955.0 |
| 2023-08-11 11:00:00 | AAPL | Stock | 178.015 | 178.185 | 177.43 | 177.47 | 2254354.0 |
| 2023-08-11 11:30:00 | AAPL | Stock | 177.47 | 177.75 | 177.281 | 177.71 | 1989683.0 |
| 2023-08-11 12:00:00 | AAPL | Stock | 177.72 | 178.095 | 177.5 | 177.5635 | 1727019.0 |
| 2023-08-11 12:30:00 | AAPL | Stock | 177.56 | 177.72 | 177.3 | 177.395 | 1232044.0 |
| 2023-08-11 13:00:00 | AAPL | Stock | 177.4 | 177.97 | 177.2001 | 177.905 | 1570941.0 |
| 2023-08-11 13:30:00 | AAPL | Stock | 177.9 | 177.99 | 177.5 | 177.755 | 1708297.0 |
| 2023-08-11 14:00:00 | AAPL | Stock | 177.76 | 178.33 | 177.74 | 178.31 | 2095482.0 |
| 2023-08-11 14:30:00 | AAPL | Stock | 178.299 | 178.55 | 178.04 | 178.3389 | 2686291.0 |
| 2023-08-11 15:00:00 | AAPL | Stock | 178.33 | 178.35 | 177.8601 | 178.1 | 1912734.0 |
| 2023-08-11 15:30:00 | AAPL | Stock | 178.095 | 178.27 | 177.6699 | 177.89 | 3967853.0 |
| 2023-08-11 16:00:00 | AAPL | Stock | 177.79 | 177.87 | 177.58 | 177.62 | 5467408.0 |
| 2023-08-11 16:30:00 | AAPL | Stock | 177.63 | 177.79 | 177.62 | 177.79 | 44234.0 |
| 2023-08-11 17:00:00 | AAPL | Stock | 177.77 | 177.79 | 177.64 | 177.75 | 14638.0 |
| 2023-08-11 17:30:00 | AAPL | Stock | 177.73 | 177.74 | 177.6636 | 177.72 | 10665.0 |
| 2023-08-11 18:00:00 | AAPL | Stock | 177.72 | 177.75 | 177.6601 | 177.71 | 9539.0 |
| 2023-08-11 18:30:00 | AAPL | Stock | 177.72 | 177.74 | 177.69 | 177.7 | 6088.0 |
| 2023-08-11 19:00:00 | AAPL | Stock | 177.74 | 177.75 | 177.64 | 177.75 | 15934.0 |
| 2023-08-11 19:30:00 | AAPL | Stock | 177.74 | 177.75 | 177.69 | 177.75 | 12168.0 |
| 2023-08-11 04:00:00 | MSFT | Stock | 323.05 | 323.06 | 322.35 | 322.5 | 1751.0 |
| 2023-08-11 04:30:00 | MSFT | Stock | 321.95 | 322.2 | 321.69 | 322.16 | 1113.0 |
| 2023-08-11 05:00:00 | MSFT | Stock | 322.18 | 322.3 | 322.18 | 322.3 | 894.0 |
| 2023-08-11 05:30:00 | MSFT | Stock | 321.69 | 321.69 | 321.01 | 321.01 | 451.0 |
| 2023-08-11 06:00:00 | MSFT | Stock | 321.22 | 321.78 | 321.22 | 321.75 | 1268.0 |
| 2023-08-11 06:30:00 | MSFT | Stock | 322.08 | 322.12 | 321.76 | 321.8 | 909.0 |
| 2023-08-11 07:00:00 | MSFT | Stock | 321.99 | 322.38 | 321.99 | 322.1 | 4450.0 |
| 2023-08-11 07:30:00 | MSFT | Stock | 322.21 | 322.21 | 321.6 | 321.6 | 3171.0 |
| 2023-08-11 08:00:00 | MSFT | Stock | 322.0 | 322.38 | 321.44 | 321.75 | 9706.0 |
| 2023-08-11 08:30:00 | MSFT | Stock | 321.55 | 321.59 | 320.2402 | 320.27 | 34316.0 |
| 2023-08-11 09:00:00 | MSFT | Stock | 320.28 | 320.82 | 320.0 | 320.39 | 23027.0 |
| 2023-08-11 09:30:00 | MSFT | Stock | 320.36 | 321.12 | 319.42 | 319.74 | 1833592.0 |
| 2023-08-11 10:00:00 | MSFT | Stock | 319.78 | 322.32 | 319.56 | 321.62 | 1550029.0 |
| 2023-08-11 10:30:00 | MSFT | Stock | 321.64 | 321.928 | 320.2367 | 320.89 | 829519.0 |
| 2023-08-11 11:00:00 | MSFT | Stock | 320.93 | 321.49 | 319.57 | 319.735 | 754822.0 |
| 2023-08-11 11:30:00 | MSFT | Stock | 319.72 | 320.29 | 319.21 | 320.23 | 783292.0 |
| 2023-08-11 12:00:00 | MSFT | Stock | 320.21 | 321.54 | 320.04 | 320.3 | 673831.0 |
| 2023-08-11 12:30:00 | MSFT | Stock | 320.3 | 320.5726 | 319.77 | 320.29 | 507590.0 |
> showing 50 of 97,768 rows — these rows as CSV