PREVIEW / stock_30min / 2008-01-08
file: by_date/stock_30min/2008/2008-01-08.parquet size: 1.2 MB rows: 70,442 symbols: 3,264
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-08 04:00:00 | AAPL | Stock | 6.3804 | 6.3804 | 6.3786 | 6.3786 | 5600.0 |
| 2008-01-08 05:00:00 | AAPL | Stock | 6.4054 | 6.4054 | 6.3786 | 6.3857 | 8400.0 |
| 2008-01-08 05:30:00 | AAPL | Stock | 6.375 | 6.375 | 6.3607 | 6.3607 | 16800.0 |
| 2008-01-08 06:30:00 | AAPL | Stock | 6.4054 | 6.4054 | 6.4054 | 6.4054 | 2800.0 |
| 2008-01-08 07:00:00 | AAPL | Stock | 6.3964 | 6.4286 | 6.3932 | 6.4279 | 392000.0 |
| 2008-01-08 07:30:00 | AAPL | Stock | 6.4464 | 6.4464 | 6.4068 | 6.4107 | 359240.0 |
| 2008-01-08 08:00:00 | AAPL | Stock | 6.4136 | 6.4282 | 6.3861 | 6.4021 | 4407844.0 |
| 2008-01-08 08:30:00 | AAPL | Stock | 6.4021 | 6.415 | 6.3989 | 6.405 | 2863896.0 |
| 2008-01-08 09:00:00 | AAPL | Stock | 6.4043 | 6.4482 | 6.3925 | 6.4286 | 4336248.0 |
| 2008-01-08 09:30:00 | AAPL | Stock | 6.4304 | 6.4821 | 6.3614 | 6.4079 | 181320272.0 |
| 2008-01-08 10:00:00 | AAPL | Stock | 6.4086 | 6.5164 | 6.3921 | 6.4789 | 149983680.0 |
| 2008-01-08 10:30:00 | AAPL | Stock | 6.4796 | 6.4961 | 6.4396 | 6.4471 | 81641812.0 |
| 2008-01-08 11:00:00 | AAPL | Stock | 6.4475 | 6.4614 | 6.3754 | 6.4125 | 103871936.0 |
| 2008-01-08 11:30:00 | AAPL | Stock | 6.4121 | 6.4286 | 6.3571 | 6.3936 | 102198320.0 |
| 2008-01-08 12:00:00 | AAPL | Stock | 6.3921 | 6.4289 | 6.3611 | 6.4144 | 57844892.0 |
| 2008-01-08 12:30:00 | AAPL | Stock | 6.4154 | 6.4329 | 6.3664 | 6.4143 | 59877804.0 |
| 2008-01-08 13:00:00 | AAPL | Stock | 6.4153 | 6.4621 | 6.3839 | 6.45 | 76257608.0 |
| 2008-01-08 13:30:00 | AAPL | Stock | 6.45 | 6.4607 | 6.4071 | 6.4579 | 58618476.0 |
| 2008-01-08 14:00:00 | AAPL | Stock | 6.4579 | 6.4946 | 6.4379 | 6.4936 | 76089608.0 |
| 2008-01-08 14:30:00 | AAPL | Stock | 6.4937 | 6.4986 | 6.3571 | 6.3704 | 117426596.0 |
| 2008-01-08 15:00:00 | AAPL | Stock | 6.3714 | 6.3829 | 6.1789 | 6.2396 | 203021056.0 |
| 2008-01-08 15:30:00 | AAPL | Stock | 6.2389 | 6.3036 | 6.1 | 6.1154 | 219087736.0 |
| 2008-01-08 16:00:00 | AAPL | Stock | 6.1143 | 6.3855 | 6.1044 | 6.1175 | 17804696.0 |
| 2008-01-08 16:30:00 | AAPL | Stock | 6.3767 | 6.3767 | 6.1132 | 6.1211 | 782096.0 |
| 2008-01-08 17:00:00 | AAPL | Stock | 6.1204 | 6.3767 | 6.1179 | 6.1271 | 971712.0 |
| 2008-01-08 17:30:00 | AAPL | Stock | 6.1293 | 6.1293 | 6.1096 | 6.1279 | 2497096.0 |
| 2008-01-08 18:00:00 | AAPL | Stock | 6.1268 | 6.1282 | 6.125 | 6.1275 | 470960.0 |
| 2008-01-08 18:30:00 | AAPL | Stock | 6.125 | 6.1275 | 6.1179 | 6.1243 | 652148.0 |
| 2008-01-08 19:00:00 | AAPL | Stock | 6.1211 | 6.1279 | 6.1071 | 6.1279 | 374332.0 |
| 2008-01-08 19:30:00 | AAPL | Stock | 6.125 | 6.1429 | 6.1214 | 6.1411 | 635488.0 |
| 2008-01-08 07:00:00 | MSFT | Stock | 34.71 | 34.71 | 34.71 | 34.71 | 100.0 |
| 2008-01-08 07:30:00 | MSFT | Stock | 34.88 | 34.88 | 34.8 | 34.87 | 1450.0 |
| 2008-01-08 08:00:00 | MSFT | Stock | 34.61 | 34.89 | 34.61 | 34.85 | 14600.0 |
| 2008-01-08 08:30:00 | MSFT | Stock | 34.85 | 34.85 | 34.78 | 34.85 | 3000.0 |
| 2008-01-08 09:00:00 | MSFT | Stock | 34.78 | 34.8 | 34.6 | 34.7 | 33394.0 |
| 2008-01-08 09:30:00 | MSFT | Stock | 34.69 | 34.71 | 34.34 | 34.36 | 5011738.0 |
| 2008-01-08 10:00:00 | MSFT | Stock | 34.35 | 34.54 | 34.28 | 34.31 | 4602836.0 |
| 2008-01-08 10:30:00 | MSFT | Stock | 34.32 | 34.35 | 34.23 | 34.33 | 3782532.0 |
| 2008-01-08 11:00:00 | MSFT | Stock | 34.32 | 34.38 | 34.15 | 34.238 | 3691849.0 |
| 2008-01-08 11:30:00 | MSFT | Stock | 34.23 | 34.24 | 33.89 | 33.978 | 5602481.0 |
| 2008-01-08 12:00:00 | MSFT | Stock | 33.97 | 34.12 | 33.9 | 34.109 | 3636354.0 |
| 2008-01-08 12:30:00 | MSFT | Stock | 34.11 | 34.19 | 34.03 | 34.14 | 2390474.0 |
| 2008-01-08 13:00:00 | MSFT | Stock | 34.14 | 34.33 | 34.04 | 34.31 | 4727453.0 |
| 2008-01-08 13:30:00 | MSFT | Stock | 34.3 | 34.31 | 34.15 | 34.22 | 4431682.0 |
| 2008-01-08 14:00:00 | MSFT | Stock | 34.21 | 34.26 | 34.12 | 34.215 | 5032653.0 |
| 2008-01-08 14:30:00 | MSFT | Stock | 34.21 | 34.22 | 33.85 | 33.89 | 6100939.0 |
| 2008-01-08 15:00:00 | MSFT | Stock | 33.88 | 33.96 | 33.55 | 33.69 | 10081584.0 |
| 2008-01-08 15:30:00 | MSFT | Stock | 33.7 | 34.25 | 33.4 | 33.46 | 24840402.0 |
| 2008-01-08 16:00:00 | MSFT | Stock | 33.46 | 34.659 | 33.45 | 34.015 | 3757783.0 |
| 2008-01-08 16:30:00 | MSFT | Stock | 33.45 | 33.63 | 33.45 | 33.45 | 36177.0 |
> showing 50 of 70,442 rows — these rows as CSV