PREVIEW / stock_30min / 2004-01-07
file: by_date/stock_30min/2004/2004-01-07.parquet size: 750 KB rows: 39,450 symbols: 1,717
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-07 08:00:00 | AAPL | Stock | 0.3938 | 0.3945 | 0.3893 | 0.3945 | 4074000.0 |
| 2004-01-07 08:30:00 | AAPL | Stock | 0.3943 | 0.3943 | 0.3939 | 0.3939 | 207200.0 |
| 2004-01-07 09:00:00 | AAPL | Stock | 0.3934 | 0.3973 | 0.393 | 0.3946 | 2233616.0 |
| 2004-01-07 09:30:00 | AAPL | Stock | 0.3946 | 0.3966 | 0.3946 | 0.3948 | 63691264.0 |
| 2004-01-07 10:00:00 | AAPL | Stock | 0.3948 | 0.3954 | 0.3916 | 0.3939 | 66666320.0 |
| 2004-01-07 10:30:00 | AAPL | Stock | 0.3939 | 0.3939 | 0.3916 | 0.3934 | 30875824.0 |
| 2004-01-07 11:00:00 | AAPL | Stock | 0.3936 | 0.3946 | 0.3927 | 0.3939 | 14192472.0 |
| 2004-01-07 11:30:00 | AAPL | Stock | 0.3939 | 0.3971 | 0.3925 | 0.3964 | 34639528.0 |
| 2004-01-07 12:00:00 | AAPL | Stock | 0.3964 | 0.4018 | 0.3964 | 0.4011 | 96373032.0 |
| 2004-01-07 12:30:00 | AAPL | Stock | 0.4013 | 0.4077 | 0.4011 | 0.4065 | 59840368.0 |
| 2004-01-07 13:00:00 | AAPL | Stock | 0.4064 | 0.4068 | 0.4027 | 0.4046 | 27441120.0 |
| 2004-01-07 13:30:00 | AAPL | Stock | 0.4046 | 0.4071 | 0.4038 | 0.4043 | 31415552.0 |
| 2004-01-07 14:00:00 | AAPL | Stock | 0.4043 | 0.4045 | 0.4023 | 0.4025 | 28693672.0 |
| 2004-01-07 14:30:00 | AAPL | Stock | 0.4023 | 0.4048 | 0.4013 | 0.4046 | 13409312.0 |
| 2004-01-07 15:00:00 | AAPL | Stock | 0.4046 | 0.4052 | 0.402 | 0.4041 | 14516712.0 |
| 2004-01-07 15:30:00 | AAPL | Stock | 0.4039 | 0.4052 | 0.4021 | 0.4027 | 34196736.0 |
| 2004-01-07 16:00:00 | AAPL | Stock | 0.4034 | 0.4041 | 0.4025 | 0.4034 | 3842664.0 |
| 2004-01-07 16:30:00 | AAPL | Stock | 0.4032 | 0.4032 | 0.4027 | 0.4027 | 1129968.0 |
| 2004-01-07 17:00:00 | AAPL | Stock | 0.4034 | 0.4036 | 0.403 | 0.4036 | 515200.0 |
| 2004-01-07 17:30:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.4036 | 0.4036 | 5600.0 |
| 2004-01-07 18:00:00 | AAPL | Stock | 0.4038 | 0.4038 | 0.4038 | 0.4038 | 89600.0 |
| 2004-01-07 08:00:00 | MSFT | Stock | 28.23 | 28.29 | 27.5 | 28.15 | 10520.0 |
| 2004-01-07 08:30:00 | MSFT | Stock | 28.2 | 28.2 | 28.16 | 28.16 | 18500.0 |
| 2004-01-07 09:00:00 | MSFT | Stock | 28.16 | 28.19 | 28.14 | 28.17 | 181800.0 |
| 2004-01-07 09:30:00 | MSFT | Stock | 28.17 | 28.22 | 28.13 | 28.13 | 4723446.0 |
| 2004-01-07 10:00:00 | MSFT | Stock | 28.13 | 28.14 | 28.01 | 28.04 | 4334841.0 |
| 2004-01-07 10:30:00 | MSFT | Stock | 28.04 | 28.1 | 28.02 | 28.07 | 2474774.0 |
| 2004-01-07 11:00:00 | MSFT | Stock | 28.07 | 28.21 | 28.06 | 28.15 | 6638252.0 |
| 2004-01-07 11:30:00 | MSFT | Stock | 28.15 | 28.19 | 28.11 | 28.16 | 3996768.0 |
| 2004-01-07 12:00:00 | MSFT | Stock | 28.159 | 28.26 | 28.13 | 28.22 | 2878134.0 |
| 2004-01-07 12:30:00 | MSFT | Stock | 28.21 | 28.23 | 28.13 | 28.13 | 2559627.0 |
| 2004-01-07 13:00:00 | MSFT | Stock | 28.14 | 28.21 | 28.12 | 28.18 | 1733395.0 |
| 2004-01-07 13:30:00 | MSFT | Stock | 28.18 | 28.19 | 28.1 | 28.12 | 2679550.0 |
| 2004-01-07 14:00:00 | MSFT | Stock | 28.12 | 28.12 | 28.02 | 28.04 | 3209972.0 |
| 2004-01-07 14:30:00 | MSFT | Stock | 28.05 | 28.15 | 28.03 | 28.13 | 3531049.0 |
| 2004-01-07 15:00:00 | MSFT | Stock | 28.13 | 28.16 | 28.08 | 28.14 | 3206215.0 |
| 2004-01-07 15:30:00 | MSFT | Stock | 28.14 | 28.25 | 28.13 | 28.22 | 4776346.0 |
| 2004-01-07 16:00:00 | MSFT | Stock | 28.22 | 28.49 | 28.2 | 28.28 | 4031210.0 |
| 2004-01-07 16:30:00 | MSFT | Stock | 28.24 | 28.28 | 28.23 | 28.25 | 1037272.0 |
| 2004-01-07 17:00:00 | MSFT | Stock | 28.24 | 28.26 | 28.23 | 28.25 | 69107.0 |
| 2004-01-07 17:30:00 | MSFT | Stock | 28.25 | 28.29 | 28.25 | 28.28 | 13900.0 |
| 2004-01-07 18:00:00 | MSFT | Stock | 28.29 | 28.32 | 28.29 | 28.32 | 25608.0 |
| 2004-01-07 08:00:00 | NVDA | Stock | 0.2067 | 0.2068 | 0.2063 | 0.2067 | 516000.0 |
| 2004-01-07 08:30:00 | NVDA | Stock | 0.2067 | 0.2067 | 0.2067 | 0.2067 | 216000.0 |
| 2004-01-07 09:00:00 | NVDA | Stock | 0.2073 | 0.2077 | 0.2042 | 0.205 | 2529000.0 |
| 2004-01-07 09:30:00 | NVDA | Stock | 0.2043 | 0.2075 | 0.2029 | 0.2042 | 120419640.0 |
| 2004-01-07 10:00:00 | NVDA | Stock | 0.2042 | 0.2048 | 0.2035 | 0.2038 | 65911920.0 |
| 2004-01-07 10:30:00 | NVDA | Stock | 0.2038 | 0.2072 | 0.2038 | 0.2057 | 56829600.0 |
| 2004-01-07 11:00:00 | NVDA | Stock | 0.2057 | 0.2061 | 0.2046 | 0.2052 | 30606240.0 |
| 2004-01-07 11:30:00 | NVDA | Stock | 0.2052 | 0.2095 | 0.2052 | 0.2076 | 84265560.0 |
> showing 50 of 39,450 rows — these rows as CSV