PREVIEW / stock_30min / 2004-01-20
file: by_date/stock_30min/2004/2004-01-20.parquet size: 793 KB rows: 42,083 symbols: 1,721
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-20 08:00:00 | AAPL | Stock | 0.4054 | 0.4088 | 0.4054 | 0.4068 | 408800.0 |
| 2004-01-20 08:30:00 | AAPL | Stock | 0.4068 | 0.4077 | 0.4059 | 0.4077 | 589680.0 |
| 2004-01-20 09:00:00 | AAPL | Stock | 0.408 | 0.408 | 0.4055 | 0.4055 | 700560.0 |
| 2004-01-20 09:30:00 | AAPL | Stock | 0.4054 | 0.4055 | 0.3996 | 0.3996 | 62334608.0 |
| 2004-01-20 10:00:00 | AAPL | Stock | 0.3995 | 0.4018 | 0.3973 | 0.4009 | 42414680.0 |
| 2004-01-20 10:30:00 | AAPL | Stock | 0.4005 | 0.4016 | 0.3996 | 0.4013 | 22732248.0 |
| 2004-01-20 11:00:00 | AAPL | Stock | 0.4014 | 0.4018 | 0.3996 | 0.4002 | 17836448.0 |
| 2004-01-20 11:30:00 | AAPL | Stock | 0.4004 | 0.4018 | 0.3995 | 0.4016 | 10476984.0 |
| 2004-01-20 12:00:00 | AAPL | Stock | 0.4013 | 0.4016 | 0.4011 | 0.4016 | 10924368.0 |
| 2004-01-20 12:30:00 | AAPL | Stock | 0.4014 | 0.4018 | 0.4009 | 0.4016 | 9956184.0 |
| 2004-01-20 13:00:00 | AAPL | Stock | 0.4018 | 0.4043 | 0.4018 | 0.4032 | 19463192.0 |
| 2004-01-20 13:30:00 | AAPL | Stock | 0.403 | 0.4055 | 0.403 | 0.4052 | 10318840.0 |
| 2004-01-20 14:00:00 | AAPL | Stock | 0.4054 | 0.4057 | 0.4036 | 0.4052 | 16823576.0 |
| 2004-01-20 14:30:00 | AAPL | Stock | 0.4052 | 0.4071 | 0.4042 | 0.4068 | 12286120.0 |
| 2004-01-20 15:00:00 | AAPL | Stock | 0.4068 | 0.4071 | 0.4054 | 0.4057 | 10778936.0 |
| 2004-01-20 15:30:00 | AAPL | Stock | 0.4057 | 0.4063 | 0.4029 | 0.4063 | 39636576.0 |
| 2004-01-20 16:00:00 | AAPL | Stock | 0.4056 | 0.4068 | 0.4055 | 0.4059 | 5501104.0 |
| 2004-01-20 16:30:00 | AAPL | Stock | 0.4057 | 0.4066 | 0.4057 | 0.4061 | 776720.0 |
| 2004-01-20 17:30:00 | AAPL | Stock | 0.4059 | 0.4059 | 0.4059 | 0.4059 | 39200.0 |
| 2004-01-20 18:00:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 11200.0 |
| 2004-01-20 08:00:00 | MSFT | Stock | 28.05 | 28.08 | 27.9 | 27.97 | 93394.0 |
| 2004-01-20 08:30:00 | MSFT | Stock | 27.98 | 28.01 | 27.82 | 27.99 | 72400.0 |
| 2004-01-20 09:00:00 | MSFT | Stock | 27.99 | 28.05 | 27.97 | 28.0 | 808648.0 |
| 2004-01-20 09:30:00 | MSFT | Stock | 27.99 | 28.07 | 27.93 | 28.03 | 10993211.0 |
| 2004-01-20 10:00:00 | MSFT | Stock | 28.05 | 28.2 | 28.02 | 28.07 | 6023508.0 |
| 2004-01-20 10:30:00 | MSFT | Stock | 28.07 | 28.13 | 28.04 | 28.09 | 4643639.0 |
| 2004-01-20 11:00:00 | MSFT | Stock | 28.1 | 28.1 | 28.02 | 28.03 | 3216587.0 |
| 2004-01-20 11:30:00 | MSFT | Stock | 28.02 | 28.11 | 27.98 | 28.1 | 3572581.0 |
| 2004-01-20 12:00:00 | MSFT | Stock | 28.09 | 28.18 | 28.08 | 28.14 | 4159271.0 |
| 2004-01-20 12:30:00 | MSFT | Stock | 28.1392 | 28.18 | 28.13 | 28.15 | 2122598.0 |
| 2004-01-20 13:00:00 | MSFT | Stock | 28.15 | 28.18 | 28.13 | 28.15 | 1733808.0 |
| 2004-01-20 13:30:00 | MSFT | Stock | 28.15 | 28.19 | 28.12 | 28.14 | 2140675.0 |
| 2004-01-20 14:00:00 | MSFT | Stock | 28.13 | 28.18 | 28.05 | 28.14 | 3304285.0 |
| 2004-01-20 14:30:00 | MSFT | Stock | 28.15 | 28.19 | 28.14 | 28.16 | 2837818.0 |
| 2004-01-20 15:00:00 | MSFT | Stock | 28.16 | 28.17 | 28.09 | 28.11 | 2768622.0 |
| 2004-01-20 15:30:00 | MSFT | Stock | 28.11 | 28.12 | 28.05 | 28.08 | 5293510.0 |
| 2004-01-20 16:00:00 | MSFT | Stock | 28.08 | 28.14 | 28.03 | 28.07 | 4009648.0 |
| 2004-01-20 16:30:00 | MSFT | Stock | 28.07 | 28.12 | 28.05 | 28.07 | 470619.0 |
| 2004-01-20 17:00:00 | MSFT | Stock | 28.06 | 28.09 | 28.06 | 28.07 | 4100.0 |
| 2004-01-20 17:30:00 | MSFT | Stock | 28.06 | 28.1 | 28.06 | 28.06 | 17610.0 |
| 2004-01-20 18:00:00 | MSFT | Stock | 28.05 | 28.09 | 28.03 | 28.03 | 11125.0 |
| 2004-01-20 08:00:00 | NVDA | Stock | 0.2065 | 0.2067 | 0.2065 | 0.2067 | 684000.0 |
| 2004-01-20 08:30:00 | NVDA | Stock | 0.2067 | 0.2067 | 0.2067 | 0.2067 | 132000.0 |
| 2004-01-20 09:00:00 | NVDA | Stock | 0.2067 | 0.2079 | 0.2063 | 0.2079 | 1608000.0 |
| 2004-01-20 09:30:00 | NVDA | Stock | 0.208 | 0.2103 | 0.2067 | 0.2075 | 105708000.0 |
| 2004-01-20 10:00:00 | NVDA | Stock | 0.2075 | 0.2091 | 0.2071 | 0.2089 | 54288360.0 |
| 2004-01-20 10:30:00 | NVDA | Stock | 0.2089 | 0.2089 | 0.2071 | 0.2072 | 28026840.0 |
| 2004-01-20 11:00:00 | NVDA | Stock | 0.2072 | 0.2079 | 0.2058 | 0.2064 | 23125800.0 |
| 2004-01-20 11:30:00 | NVDA | Stock | 0.2063 | 0.2064 | 0.2057 | 0.2062 | 16609320.0 |
| 2004-01-20 12:00:00 | NVDA | Stock | 0.2064 | 0.208 | 0.2061 | 0.208 | 19825800.0 |
> showing 50 of 42,083 rows — these rows as CSV