PREVIEW / stock_30min / 2023-05-11
file: by_date/stock_30min/2023/2023-05-11.parquet size: 2.1 MB rows: 100,648 symbols: 1,662
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-05-11 04:00:00 | AAPL | Stock | 173.42 | 173.99 | 173.42 | 173.93 | 7567.0 |
| 2023-05-11 04:30:00 | AAPL | Stock | 173.83 | 173.83 | 173.68 | 173.68 | 715.0 |
| 2023-05-11 05:00:00 | AAPL | Stock | 173.74 | 173.9 | 173.7 | 173.7 | 5136.0 |
| 2023-05-11 05:30:00 | AAPL | Stock | 173.8 | 173.88 | 173.78 | 173.78 | 2484.0 |
| 2023-05-11 06:00:00 | AAPL | Stock | 173.76 | 173.8 | 173.62 | 173.62 | 2434.0 |
| 2023-05-11 06:30:00 | AAPL | Stock | 173.65 | 173.66 | 173.58 | 173.58 | 892.0 |
| 2023-05-11 07:00:00 | AAPL | Stock | 173.65 | 173.75 | 173.37 | 173.67 | 32316.0 |
| 2023-05-11 07:30:00 | AAPL | Stock | 173.6 | 173.61 | 173.42 | 173.48 | 10516.0 |
| 2023-05-11 08:00:00 | AAPL | Stock | 173.7486 | 174.03 | 173.42 | 173.65 | 89165.0 |
| 2023-05-11 08:30:00 | AAPL | Stock | 173.66 | 173.9 | 173.51 | 173.6899 | 73852.0 |
| 2023-05-11 09:00:00 | AAPL | Stock | 173.71 | 173.99 | 173.26 | 173.81 | 147314.0 |
| 2023-05-11 09:30:00 | AAPL | Stock | 173.85 | 173.96 | 172.18 | 172.27 | 6236450.0 |
| 2023-05-11 10:00:00 | AAPL | Stock | 172.28 | 172.855 | 172.17 | 172.67 | 3173365.0 |
| 2023-05-11 10:30:00 | AAPL | Stock | 172.67 | 173.255 | 172.3 | 173.23 | 2731862.0 |
| 2023-05-11 11:00:00 | AAPL | Stock | 173.23 | 173.7 | 173.1601 | 173.7 | 3081738.0 |
| 2023-05-11 11:30:00 | AAPL | Stock | 173.695 | 173.88 | 173.26 | 173.59 | 2434873.0 |
| 2023-05-11 12:00:00 | AAPL | Stock | 173.59 | 173.915 | 173.35 | 173.66 | 2186013.0 |
| 2023-05-11 12:30:00 | AAPL | Stock | 173.67 | 174.025 | 173.66 | 173.76 | 1866558.0 |
| 2023-05-11 13:00:00 | AAPL | Stock | 173.76 | 173.94 | 173.38 | 173.47 | 1976969.0 |
| 2023-05-11 13:30:00 | AAPL | Stock | 173.47 | 173.74 | 173.06 | 173.6699 | 1911178.0 |
| 2023-05-11 14:00:00 | AAPL | Stock | 173.67 | 174.0 | 173.56 | 173.9901 | 1679362.0 |
| 2023-05-11 14:30:00 | AAPL | Stock | 173.9999 | 174.59 | 173.9305 | 174.37 | 2977597.0 |
| 2023-05-11 15:00:00 | AAPL | Stock | 174.375 | 174.4 | 173.86 | 174.09 | 2268448.0 |
| 2023-05-11 15:30:00 | AAPL | Stock | 174.075 | 174.15 | 173.5 | 173.81 | 3655976.0 |
| 2023-05-11 16:00:00 | AAPL | Stock | 173.75 | 173.84 | 173.54 | 173.56 | 5464405.0 |
| 2023-05-11 16:30:00 | AAPL | Stock | 173.57 | 173.75 | 173.55 | 173.61 | 16303.0 |
| 2023-05-11 17:00:00 | AAPL | Stock | 173.62 | 173.75 | 173.61 | 173.65 | 39294.0 |
| 2023-05-11 17:30:00 | AAPL | Stock | 173.5999 | 173.61 | 173.58 | 173.6 | 3561.0 |
| 2023-05-11 18:00:00 | AAPL | Stock | 173.6152 | 173.73 | 173.6152 | 173.63 | 13802.0 |
| 2023-05-11 18:30:00 | AAPL | Stock | 173.7 | 173.74 | 173.64 | 173.74 | 12599.0 |
| 2023-05-11 19:00:00 | AAPL | Stock | 173.73 | 173.75 | 173.7 | 173.72 | 6174.0 |
| 2023-05-11 19:30:00 | AAPL | Stock | 173.76 | 173.82 | 173.71 | 173.76 | 22735.0 |
| 2023-05-11 04:00:00 | MSFT | Stock | 312.0 | 313.06 | 312.0 | 313.06 | 1253.0 |
| 2023-05-11 04:30:00 | MSFT | Stock | 313.0 | 313.0 | 312.4 | 312.4 | 667.0 |
| 2023-05-11 05:00:00 | MSFT | Stock | 312.6 | 312.6 | 311.7 | 312.11 | 2767.0 |
| 2023-05-11 05:30:00 | MSFT | Stock | 312.22 | 312.25 | 311.94 | 312.1 | 4263.0 |
| 2023-05-11 06:00:00 | MSFT | Stock | 312.03 | 312.03 | 311.9 | 311.9 | 592.0 |
| 2023-05-11 06:30:00 | MSFT | Stock | 311.95 | 311.95 | 311.27 | 311.53 | 4591.0 |
| 2023-05-11 07:00:00 | MSFT | Stock | 311.5 | 311.68 | 310.8 | 311.3 | 16506.0 |
| 2023-05-11 07:30:00 | MSFT | Stock | 311.14 | 311.29 | 310.83 | 311.12 | 7173.0 |
| 2023-05-11 08:00:00 | MSFT | Stock | 311.6 | 313.06 | 310.8 | 311.4928 | 45509.0 |
| 2023-05-11 08:30:00 | MSFT | Stock | 311.5 | 311.88 | 310.5 | 310.7 | 61067.0 |
| 2023-05-11 09:00:00 | MSFT | Stock | 310.85 | 311.15 | 310.03 | 310.12 | 93133.0 |
| 2023-05-11 09:30:00 | MSFT | Stock | 310.14 | 310.26 | 306.2601 | 307.49 | 4774046.0 |
| 2023-05-11 10:00:00 | MSFT | Stock | 307.53 | 309.37 | 307.02 | 308.93 | 2008733.0 |
| 2023-05-11 10:30:00 | MSFT | Stock | 308.94 | 309.725 | 307.67 | 309.725 | 1333463.0 |
| 2023-05-11 11:00:00 | MSFT | Stock | 309.73 | 310.01 | 309.05 | 309.98 | 1113784.0 |
| 2023-05-11 11:30:00 | MSFT | Stock | 310.0 | 310.3299 | 309.03 | 309.55 | 964765.0 |
| 2023-05-11 12:00:00 | MSFT | Stock | 309.55 | 309.885 | 308.85 | 309.6471 | 812775.0 |
| 2023-05-11 12:30:00 | MSFT | Stock | 309.68 | 310.08 | 309.59 | 309.6701 | 555930.0 |
> showing 50 of 100,648 rows — these rows as CSV