PREVIEW / stock_30min / 2024-11-27
file: by_date/stock_30min/2024/2024-11-27.parquet size: 2.1 MB rows: 101,593 symbols: 691
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-11-27 04:00:00 | AAPL | Stock | 235.5 | 235.5 | 234.13 | 234.13 | 17130.0 |
| 2024-11-27 04:30:00 | AAPL | Stock | 234.38 | 234.59 | 234.3 | 234.4 | 7168.0 |
| 2024-11-27 05:00:00 | AAPL | Stock | 234.34 | 234.49 | 234.28 | 234.35 | 12059.0 |
| 2024-11-27 05:30:00 | AAPL | Stock | 234.24 | 234.38 | 234.21 | 234.38 | 4998.0 |
| 2024-11-27 06:00:00 | AAPL | Stock | 234.26 | 234.3 | 234.05 | 234.1 | 7229.0 |
| 2024-11-27 06:30:00 | AAPL | Stock | 234.02 | 234.2 | 234.0 | 234.19 | 14359.0 |
| 2024-11-27 07:00:00 | AAPL | Stock | 234.29 | 234.38 | 233.97 | 234.05 | 33844.0 |
| 2024-11-27 07:30:00 | AAPL | Stock | 234.0 | 234.17 | 233.92 | 234.17 | 17561.0 |
| 2024-11-27 08:00:00 | AAPL | Stock | 233.95 | 235.72 | 233.8826 | 233.98 | 69376.0 |
| 2024-11-27 08:30:00 | AAPL | Stock | 233.94 | 234.03 | 233.5 | 233.81 | 45664.0 |
| 2024-11-27 09:00:00 | AAPL | Stock | 233.8 | 234.55 | 233.26 | 234.5 | 117372.0 |
| 2024-11-27 09:30:00 | AAPL | Stock | 234.44 | 235.68 | 233.8101 | 234.32 | 3153682.0 |
| 2024-11-27 10:00:00 | AAPL | Stock | 234.33 | 235.4786 | 233.9796 | 235.15 | 2125349.0 |
| 2024-11-27 10:30:00 | AAPL | Stock | 235.16 | 235.69 | 234.575 | 234.62 | 1742422.0 |
| 2024-11-27 11:00:00 | AAPL | Stock | 234.62 | 234.8 | 234.1546 | 234.67 | 1181379.0 |
| 2024-11-27 11:30:00 | AAPL | Stock | 234.63 | 234.89 | 234.12 | 234.3525 | 1079444.0 |
| 2024-11-27 12:00:00 | AAPL | Stock | 234.35 | 234.6 | 233.98 | 234.57 | 1142329.0 |
| 2024-11-27 12:30:00 | AAPL | Stock | 234.56 | 234.74 | 234.4094 | 234.73 | 595401.0 |
| 2024-11-27 13:00:00 | AAPL | Stock | 234.73 | 235.0 | 234.6125 | 234.7801 | 791602.0 |
| 2024-11-27 13:30:00 | AAPL | Stock | 234.78 | 235.02 | 234.71 | 234.93 | 523392.0 |
| 2024-11-27 14:00:00 | AAPL | Stock | 234.925 | 235.1371 | 234.77 | 234.98 | 730408.0 |
| 2024-11-27 14:30:00 | AAPL | Stock | 234.98 | 235.25 | 234.94 | 235.06 | 606047.0 |
| 2024-11-27 15:00:00 | AAPL | Stock | 235.065 | 235.2 | 234.735 | 234.84 | 749169.0 |
| 2024-11-27 15:30:00 | AAPL | Stock | 234.8405 | 235.09 | 234.585 | 234.99 | 2146892.0 |
| 2024-11-27 16:00:00 | AAPL | Stock | 234.93 | 235.34 | 234.9 | 235.17 | 8754112.0 |
| 2024-11-27 16:30:00 | AAPL | Stock | 235.1801 | 235.1801 | 234.93 | 235.01 | 17190.0 |
| 2024-11-27 17:00:00 | AAPL | Stock | 235.03 | 235.14 | 235.03 | 235.08 | 3086.0 |
| 2024-11-27 17:30:00 | AAPL | Stock | 235.0999 | 235.0999 | 235.05 | 235.0981 | 640.0 |
| 2024-11-27 18:00:00 | AAPL | Stock | 235.07 | 235.1805 | 235.06 | 235.1805 | 1217.0 |
| 2024-11-27 18:30:00 | AAPL | Stock | 235.16 | 235.16 | 235.01 | 235.15 | 3575.0 |
| 2024-11-27 19:00:00 | AAPL | Stock | 235.13 | 235.24 | 235.0608 | 235.19 | 2917.0 |
| 2024-11-27 19:30:00 | AAPL | Stock | 235.25 | 235.25 | 235.08 | 235.2 | 2877.0 |
| 2024-11-27 04:00:00 | MSFT | Stock | 425.45 | 425.69 | 425.0 | 425.1 | 1727.0 |
| 2024-11-27 04:30:00 | MSFT | Stock | 425.43 | 425.43 | 425.01 | 425.01 | 1858.0 |
| 2024-11-27 05:00:00 | MSFT | Stock | 425.62 | 425.62 | 425.62 | 425.62 | 100.0 |
| 2024-11-27 05:30:00 | MSFT | Stock | 425.45 | 425.46 | 425.38 | 425.38 | 320.0 |
| 2024-11-27 06:00:00 | MSFT | Stock | 425.35 | 425.47 | 425.25 | 425.25 | 625.0 |
| 2024-11-27 07:00:00 | MSFT | Stock | 425.49 | 425.8 | 425.38 | 425.75 | 10969.0 |
| 2024-11-27 07:30:00 | MSFT | Stock | 425.75 | 426.21 | 425.75 | 426.0 | 3403.0 |
| 2024-11-27 08:00:00 | MSFT | Stock | 425.65 | 426.98 | 425.5 | 426.2 | 25885.0 |
| 2024-11-27 08:30:00 | MSFT | Stock | 426.22 | 426.35 | 425.51 | 425.51 | 11131.0 |
| 2024-11-27 09:00:00 | MSFT | Stock | 425.51 | 425.9 | 424.47 | 425.03 | 20745.0 |
| 2024-11-27 09:30:00 | MSFT | Stock | 425.12 | 427.2299 | 424.1 | 425.74 | 1306682.0 |
| 2024-11-27 10:00:00 | MSFT | Stock | 425.6 | 425.7899 | 424.14 | 425.555 | 601240.0 |
| 2024-11-27 10:30:00 | MSFT | Stock | 425.5742 | 426.09 | 423.745 | 424.44 | 531802.0 |
| 2024-11-27 11:00:00 | MSFT | Stock | 424.46 | 424.7199 | 422.99 | 424.575 | 503353.0 |
| 2024-11-27 11:30:00 | MSFT | Stock | 424.54 | 425.005 | 423.53 | 424.225 | 424592.0 |
| 2024-11-27 12:00:00 | MSFT | Stock | 424.225 | 424.395 | 423.28 | 423.87 | 291493.0 |
| 2024-11-27 12:30:00 | MSFT | Stock | 423.86 | 423.9842 | 423.25 | 423.37 | 247533.0 |
| 2024-11-27 13:00:00 | MSFT | Stock | 423.36 | 424.2 | 423.17 | 423.72 | 296692.0 |
> showing 50 of 101,593 rows — these rows as CSV