PREVIEW / stock_30min / 2005-05-31
file: by_date/stock_30min/2005/2005-05-31.parquet size: 847 KB rows: 45,331 symbols: 1,994
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-31 08:00:00 | AAPL | Stock | 1.4429 | 1.4443 | 1.4386 | 1.4418 | 211260.0 |
| 2005-05-31 08:30:00 | AAPL | Stock | 1.4414 | 1.4429 | 1.4393 | 1.4429 | 89600.0 |
| 2005-05-31 09:00:00 | AAPL | Stock | 1.4411 | 1.4554 | 1.4411 | 1.4532 | 588084.0 |
| 2005-05-31 09:30:00 | AAPL | Stock | 1.4521 | 1.455 | 1.4354 | 1.4371 | 46515784.0 |
| 2005-05-31 10:00:00 | AAPL | Stock | 1.4375 | 1.445 | 1.4364 | 1.4436 | 28173404.0 |
| 2005-05-31 10:30:00 | AAPL | Stock | 1.4439 | 1.4532 | 1.4425 | 1.4429 | 32458748.0 |
| 2005-05-31 11:00:00 | AAPL | Stock | 1.4429 | 1.445 | 1.4386 | 1.4414 | 22649228.0 |
| 2005-05-31 11:30:00 | AAPL | Stock | 1.4418 | 1.4486 | 1.4375 | 1.4389 | 15632344.0 |
| 2005-05-31 12:00:00 | AAPL | Stock | 1.4389 | 1.4432 | 1.4371 | 1.4421 | 15039836.0 |
| 2005-05-31 12:30:00 | AAPL | Stock | 1.4418 | 1.4421 | 1.4375 | 1.439 | 11417868.0 |
| 2005-05-31 13:00:00 | AAPL | Stock | 1.4393 | 1.4425 | 1.4386 | 1.4411 | 11365620.0 |
| 2005-05-31 13:30:00 | AAPL | Stock | 1.4411 | 1.4536 | 1.44 | 1.4404 | 13298908.0 |
| 2005-05-31 14:00:00 | AAPL | Stock | 1.4404 | 1.4421 | 1.4375 | 1.4389 | 17414460.0 |
| 2005-05-31 14:30:00 | AAPL | Stock | 1.4386 | 1.4411 | 1.4382 | 1.4407 | 19709704.0 |
| 2005-05-31 15:00:00 | AAPL | Stock | 1.4407 | 1.4411 | 1.4364 | 1.4364 | 25947068.0 |
| 2005-05-31 15:30:00 | AAPL | Stock | 1.4368 | 1.4368 | 1.4136 | 1.4182 | 109068512.0 |
| 2005-05-31 16:00:00 | AAPL | Stock | 1.4196 | 1.4218 | 1.4179 | 1.4182 | 3025624.0 |
| 2005-05-31 16:30:00 | AAPL | Stock | 1.42 | 1.4204 | 1.4182 | 1.4182 | 2011856.0 |
| 2005-05-31 17:00:00 | AAPL | Stock | 1.4191 | 1.4204 | 1.4191 | 1.42 | 970676.0 |
| 2005-05-31 17:30:00 | AAPL | Stock | 1.4182 | 1.4354 | 1.4182 | 1.4211 | 524216.0 |
| 2005-05-31 18:00:00 | AAPL | Stock | 1.4229 | 1.4229 | 1.4229 | 1.4229 | 33600.0 |
| 2005-05-31 07:00:00 | MSFT | Stock | 26.0 | 26.0 | 25.97 | 25.97 | 1000.0 |
| 2005-05-31 07:30:00 | MSFT | Stock | 26.0 | 26.01 | 25.97 | 26.01 | 3000.0 |
| 2005-05-31 08:00:00 | MSFT | Stock | 26.01 | 26.05 | 26.01 | 26.02 | 14814.0 |
| 2005-05-31 08:30:00 | MSFT | Stock | 26.03 | 26.04 | 26.01 | 26.03 | 14564.0 |
| 2005-05-31 09:00:00 | MSFT | Stock | 26.02 | 26.03 | 25.95 | 25.96 | 157951.0 |
| 2005-05-31 09:30:00 | MSFT | Stock | 25.99 | 26.03 | 25.94 | 25.949 | 5230515.0 |
| 2005-05-31 10:00:00 | MSFT | Stock | 25.94 | 26.0 | 25.91 | 25.94 | 3118501.0 |
| 2005-05-31 10:30:00 | MSFT | Stock | 25.95 | 26.01 | 25.85 | 25.85 | 2952546.0 |
| 2005-05-31 11:00:00 | MSFT | Stock | 25.85 | 25.9 | 25.79 | 25.88 | 4036211.0 |
| 2005-05-31 11:30:00 | MSFT | Stock | 25.87 | 25.9 | 25.83 | 25.86 | 1344369.0 |
| 2005-05-31 12:00:00 | MSFT | Stock | 25.87 | 25.94 | 25.84 | 25.89 | 1558223.0 |
| 2005-05-31 12:30:00 | MSFT | Stock | 25.89 | 25.93 | 25.85 | 25.86 | 1932338.0 |
| 2005-05-31 13:00:00 | MSFT | Stock | 25.85 | 25.87 | 25.83 | 25.84 | 1295848.0 |
| 2005-05-31 13:30:00 | MSFT | Stock | 25.84 | 25.88 | 25.83 | 25.83 | 1562207.0 |
| 2005-05-31 14:00:00 | MSFT | Stock | 25.83 | 25.97 | 25.75 | 25.83 | 2728714.0 |
| 2005-05-31 14:30:00 | MSFT | Stock | 25.83 | 25.89 | 25.82 | 25.842 | 1970594.0 |
| 2005-05-31 15:00:00 | MSFT | Stock | 25.85 | 25.89 | 25.83 | 25.839 | 2875816.0 |
| 2005-05-31 15:30:00 | MSFT | Stock | 25.84 | 25.96 | 25.79 | 25.81 | 7241194.0 |
| 2005-05-31 16:00:00 | MSFT | Stock | 25.81 | 25.83 | 25.75 | 25.8 | 1073285.0 |
| 2005-05-31 16:30:00 | MSFT | Stock | 25.8 | 25.806 | 25.79 | 25.8 | 347485.0 |
| 2005-05-31 17:00:00 | MSFT | Stock | 25.816 | 25.816 | 25.8 | 25.8 | 428879.0 |
| 2005-05-31 17:30:00 | MSFT | Stock | 25.8 | 25.82 | 25.8 | 25.8 | 81475.0 |
| 2005-05-31 18:00:00 | MSFT | Stock | 25.8 | 25.8 | 25.8 | 25.8 | 1000.0 |
| 2005-05-31 08:00:00 | NVDA | Stock | 0.2271 | 0.2271 | 0.2271 | 0.2271 | 12000.0 |
| 2005-05-31 08:30:00 | NVDA | Stock | 0.2293 | 0.2293 | 0.2293 | 0.2293 | 72000.0 |
| 2005-05-31 09:00:00 | NVDA | Stock | 0.2287 | 0.2293 | 0.2282 | 0.2293 | 828000.0 |
| 2005-05-31 09:30:00 | NVDA | Stock | 0.2283 | 0.2302 | 0.2239 | 0.2242 | 81780360.0 |
| 2005-05-31 10:00:00 | NVDA | Stock | 0.2242 | 0.2264 | 0.2221 | 0.2236 | 107957040.0 |
| 2005-05-31 10:30:00 | NVDA | Stock | 0.2236 | 0.225 | 0.2232 | 0.2247 | 55051200.0 |
> showing 50 of 45,331 rows — these rows as CSV