PREVIEW / stock_30min / 2002-03-28
file: by_date/stock_30min/2002/2002-03-28.parquet size: 602 KB rows: 31,426 symbols: 1,401
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 |
|---|---|---|---|---|---|---|---|
| 2002-03-28 08:00:00 | AAPL | Stock | 0.4195 | 0.4418 | 0.4195 | 0.4398 | 1926400.0 |
| 2002-03-28 08:30:00 | AAPL | Stock | 0.4242 | 0.4242 | 0.4241 | 0.4241 | 28000.0 |
| 2002-03-28 09:00:00 | AAPL | Stock | 0.4214 | 0.4221 | 0.42 | 0.4221 | 313600.0 |
| 2002-03-28 09:30:00 | AAPL | Stock | 0.4232 | 0.4239 | 0.4189 | 0.4216 | 19331200.0 |
| 2002-03-28 10:00:00 | AAPL | Stock | 0.4216 | 0.4264 | 0.4214 | 0.4261 | 8159200.0 |
| 2002-03-28 10:30:00 | AAPL | Stock | 0.4263 | 0.4264 | 0.4232 | 0.4254 | 5644800.0 |
| 2002-03-28 11:00:00 | AAPL | Stock | 0.4254 | 0.4257 | 0.4232 | 0.4232 | 3298400.0 |
| 2002-03-28 11:30:00 | AAPL | Stock | 0.4234 | 0.4241 | 0.4214 | 0.422 | 4586400.0 |
| 2002-03-28 12:00:00 | AAPL | Stock | 0.422 | 0.4248 | 0.422 | 0.4239 | 9189600.0 |
| 2002-03-28 12:30:00 | AAPL | Stock | 0.4241 | 0.4259 | 0.4232 | 0.4239 | 6395200.0 |
| 2002-03-28 13:00:00 | AAPL | Stock | 0.4239 | 0.4241 | 0.4204 | 0.4218 | 9161600.0 |
| 2002-03-28 13:30:00 | AAPL | Stock | 0.4218 | 0.4232 | 0.4211 | 0.4229 | 3623200.0 |
| 2002-03-28 14:00:00 | AAPL | Stock | 0.423 | 0.4234 | 0.4214 | 0.4223 | 4603200.0 |
| 2002-03-28 14:30:00 | AAPL | Stock | 0.4227 | 0.4246 | 0.4218 | 0.4218 | 6182400.0 |
| 2002-03-28 15:00:00 | AAPL | Stock | 0.4221 | 0.4236 | 0.4214 | 0.4232 | 7705600.0 |
| 2002-03-28 15:30:00 | AAPL | Stock | 0.4232 | 0.4239 | 0.4216 | 0.4227 | 8064000.0 |
| 2002-03-28 16:00:00 | AAPL | Stock | 0.4229 | 0.4238 | 0.4216 | 0.4227 | 7694400.0 |
| 2002-03-28 16:30:00 | AAPL | Stock | 0.4227 | 0.4227 | 0.4227 | 0.4227 | 201600.0 |
| 2002-03-28 17:00:00 | AAPL | Stock | 0.4227 | 0.4227 | 0.4227 | 0.4227 | 268800.0 |
| 2002-03-28 08:00:00 | MSFT | Stock | 30.6245 | 30.815 | 29.875 | 30.0 | 542600.0 |
| 2002-03-28 08:30:00 | MSFT | Stock | 30.0 | 30.075 | 29.9 | 30.075 | 42200.0 |
| 2002-03-28 09:00:00 | MSFT | Stock | 30.1 | 30.125 | 29.96 | 29.985 | 301200.0 |
| 2002-03-28 09:30:00 | MSFT | Stock | 29.975 | 30.1 | 29.92 | 30.02 | 5886000.0 |
| 2002-03-28 10:00:00 | MSFT | Stock | 30.03 | 30.225 | 30.02 | 30.225 | 4371000.0 |
| 2002-03-28 10:30:00 | MSFT | Stock | 30.225 | 30.295 | 30.15 | 30.205 | 3259800.0 |
| 2002-03-28 11:00:00 | MSFT | Stock | 30.2145 | 30.325 | 30.19 | 30.23 | 3039000.0 |
| 2002-03-28 11:30:00 | MSFT | Stock | 30.2355 | 30.25 | 30.085 | 30.09 | 2386200.0 |
| 2002-03-28 12:00:00 | MSFT | Stock | 30.091 | 30.125 | 30.03 | 30.09 | 2418800.0 |
| 2002-03-28 12:30:00 | MSFT | Stock | 30.09 | 30.145 | 29.97 | 29.975 | 2248200.0 |
| 2002-03-28 13:00:00 | MSFT | Stock | 29.975 | 30.01 | 29.83 | 29.99 | 3049600.0 |
| 2002-03-28 13:30:00 | MSFT | Stock | 29.975 | 30.125 | 29.955 | 30.11 | 1370400.0 |
| 2002-03-28 14:00:00 | MSFT | Stock | 30.11 | 30.16 | 30.02 | 30.145 | 1862000.0 |
| 2002-03-28 14:30:00 | MSFT | Stock | 30.14 | 30.225 | 30.125 | 30.19 | 1549800.0 |
| 2002-03-28 15:00:00 | MSFT | Stock | 30.185 | 30.245 | 30.125 | 30.235 | 2633800.0 |
| 2002-03-28 15:30:00 | MSFT | Stock | 30.2295 | 30.245 | 30.0 | 30.13 | 4733600.0 |
| 2002-03-28 16:00:00 | MSFT | Stock | 30.125 | 30.165 | 29.92 | 30.11 | 3236200.0 |
| 2002-03-28 16:30:00 | MSFT | Stock | 30.155 | 30.155 | 30.05 | 30.1086 | 238000.0 |
| 2002-03-28 17:00:00 | MSFT | Stock | 30.155 | 30.155 | 30.155 | 30.155 | 48800.0 |
| 2002-03-28 17:30:00 | MSFT | Stock | 30.09 | 30.16 | 30.09 | 30.14 | 438400.0 |
| 2002-03-28 18:00:00 | MSFT | Stock | 30.14 | 30.14 | 30.04 | 30.04 | 2400.0 |
| 2002-03-28 08:00:00 | NVDA | Stock | 0.3832 | 0.435 | 0.3789 | 0.3854 | 32028000.0 |
| 2002-03-28 08:30:00 | NVDA | Stock | 0.3854 | 0.3854 | 0.3821 | 0.3828 | 6924000.0 |
| 2002-03-28 09:00:00 | NVDA | Stock | 0.3837 | 0.3854 | 0.3812 | 0.3825 | 4740000.0 |
| 2002-03-28 09:30:00 | NVDA | Stock | 0.3817 | 0.3842 | 0.3644 | 0.3682 | 298020000.0 |
| 2002-03-28 10:00:00 | NVDA | Stock | 0.3682 | 0.3702 | 0.3662 | 0.368 | 114180000.0 |
| 2002-03-28 10:30:00 | NVDA | Stock | 0.3683 | 0.3698 | 0.363 | 0.3644 | 122532000.0 |
| 2002-03-28 11:00:00 | NVDA | Stock | 0.3642 | 0.3644 | 0.3567 | 0.357 | 203880000.0 |
| 2002-03-28 11:30:00 | NVDA | Stock | 0.3572 | 0.3575 | 0.3537 | 0.3552 | 217056000.0 |
| 2002-03-28 12:00:00 | NVDA | Stock | 0.3552 | 0.3562 | 0.3506 | 0.3526 | 173400000.0 |
| 2002-03-28 12:30:00 | NVDA | Stock | 0.3524 | 0.36 | 0.3524 | 0.3557 | 160884000.0 |
> showing 50 of 31,426 rows — these rows as CSV