PREVIEW / stock_30min / 2006-08-02
file: by_date/stock_30min/2006/2006-08-02.parquet size: 914 KB rows: 50,033 symbols: 2,325
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-02 07:00:00 | AAPL | Stock | 2.425 | 2.4446 | 2.425 | 2.4446 | 18200.0 |
| 2006-08-02 07:30:00 | AAPL | Stock | 2.4139 | 2.4139 | 2.4139 | 2.4139 | 5600.0 |
| 2006-08-02 08:00:00 | AAPL | Stock | 2.4139 | 2.4268 | 2.4089 | 2.4232 | 1784888.0 |
| 2006-08-02 08:30:00 | AAPL | Stock | 2.4218 | 2.4246 | 2.4143 | 2.4161 | 849156.0 |
| 2006-08-02 09:00:00 | AAPL | Stock | 2.4143 | 2.4229 | 2.4143 | 2.4161 | 813540.0 |
| 2006-08-02 09:30:00 | AAPL | Stock | 2.4161 | 2.4354 | 2.4111 | 2.4264 | 72632728.0 |
| 2006-08-02 10:00:00 | AAPL | Stock | 2.4264 | 2.4321 | 2.4211 | 2.425 | 47413324.0 |
| 2006-08-02 10:30:00 | AAPL | Stock | 2.425 | 2.4332 | 2.4221 | 2.4282 | 38300108.0 |
| 2006-08-02 11:00:00 | AAPL | Stock | 2.4279 | 2.4425 | 2.4268 | 2.4329 | 50531796.0 |
| 2006-08-02 11:30:00 | AAPL | Stock | 2.4329 | 2.4429 | 2.4325 | 2.4421 | 34138916.0 |
| 2006-08-02 12:00:00 | AAPL | Stock | 2.4418 | 2.4529 | 2.44 | 2.4468 | 56506968.0 |
| 2006-08-02 12:30:00 | AAPL | Stock | 2.4471 | 2.45 | 2.4425 | 2.4443 | 22612072.0 |
| 2006-08-02 13:00:00 | AAPL | Stock | 2.4443 | 2.4457 | 2.4332 | 2.4368 | 30718016.0 |
| 2006-08-02 13:30:00 | AAPL | Stock | 2.4371 | 2.4457 | 2.4346 | 2.4411 | 20063400.0 |
| 2006-08-02 14:00:00 | AAPL | Stock | 2.4411 | 2.45 | 2.4307 | 2.4321 | 31316936.0 |
| 2006-08-02 14:30:00 | AAPL | Stock | 2.4318 | 2.4354 | 2.4225 | 2.4329 | 46605020.0 |
| 2006-08-02 15:00:00 | AAPL | Stock | 2.4325 | 2.4329 | 2.4239 | 2.4254 | 30455600.0 |
| 2006-08-02 15:30:00 | AAPL | Stock | 2.4257 | 2.4371 | 2.4257 | 2.4304 | 48010816.0 |
| 2006-08-02 16:00:00 | AAPL | Stock | 2.4304 | 2.4354 | 2.4289 | 2.4346 | 768376.0 |
| 2006-08-02 16:30:00 | AAPL | Stock | 2.4357 | 2.4375 | 2.4318 | 2.4339 | 1858808.0 |
| 2006-08-02 17:00:00 | AAPL | Stock | 2.4343 | 2.4357 | 2.4343 | 2.4354 | 3416000.0 |
| 2006-08-02 17:30:00 | AAPL | Stock | 2.4354 | 2.4357 | 2.4343 | 2.4343 | 221844.0 |
| 2006-08-02 18:00:00 | AAPL | Stock | 2.4343 | 2.4368 | 2.4343 | 2.4368 | 164080.0 |
| 2006-08-02 08:00:00 | MSFT | Stock | 23.99 | 24.17 | 23.99 | 24.1 | 48580.0 |
| 2006-08-02 08:30:00 | MSFT | Stock | 24.09 | 24.12 | 24.07 | 24.07 | 29320.0 |
| 2006-08-02 09:00:00 | MSFT | Stock | 24.11 | 24.16 | 24.08 | 24.1 | 41418.0 |
| 2006-08-02 09:30:00 | MSFT | Stock | 24.12 | 24.17 | 24.07 | 24.15 | 3353015.0 |
| 2006-08-02 10:00:00 | MSFT | Stock | 24.15 | 24.19 | 24.05 | 24.08 | 3009896.0 |
| 2006-08-02 10:30:00 | MSFT | Stock | 24.07 | 24.1 | 24.03 | 24.04 | 2329901.0 |
| 2006-08-02 11:00:00 | MSFT | Stock | 24.04 | 24.19 | 24.04 | 24.1 | 3671196.0 |
| 2006-08-02 11:30:00 | MSFT | Stock | 24.1 | 24.24 | 24.08 | 24.21 | 3485074.0 |
| 2006-08-02 12:00:00 | MSFT | Stock | 24.21 | 24.38 | 24.19 | 24.33 | 5422399.0 |
| 2006-08-02 12:30:00 | MSFT | Stock | 24.33 | 24.4 | 24.29 | 24.38 | 2491102.0 |
| 2006-08-02 13:00:00 | MSFT | Stock | 24.38 | 24.38 | 24.34 | 24.36 | 1247467.0 |
| 2006-08-02 13:30:00 | MSFT | Stock | 24.36 | 24.4 | 24.35 | 24.382 | 1904703.0 |
| 2006-08-02 14:00:00 | MSFT | Stock | 24.38 | 24.4 | 24.32 | 24.36 | 3153680.0 |
| 2006-08-02 14:30:00 | MSFT | Stock | 24.36 | 24.37 | 24.3 | 24.33 | 3948596.0 |
| 2006-08-02 15:00:00 | MSFT | Stock | 24.33 | 24.35 | 24.28 | 24.34 | 2987847.0 |
| 2006-08-02 15:30:00 | MSFT | Stock | 24.35 | 24.38 | 24.28 | 24.3 | 7785879.0 |
| 2006-08-02 16:00:00 | MSFT | Stock | 24.29 | 24.35 | 24.27 | 24.35 | 285997.0 |
| 2006-08-02 16:30:00 | MSFT | Stock | 24.36 | 24.36 | 24.3 | 24.3 | 80694.0 |
| 2006-08-02 17:00:00 | MSFT | Stock | 24.31 | 24.31 | 24.3 | 24.3 | 600.0 |
| 2006-08-02 17:30:00 | MSFT | Stock | 24.3 | 24.33 | 24.3 | 24.33 | 200.0 |
| 2006-08-02 08:00:00 | NVDA | Stock | 0.3583 | 0.3583 | 0.3583 | 0.3583 | 108000.0 |
| 2006-08-02 08:30:00 | NVDA | Stock | 0.358 | 0.3592 | 0.358 | 0.3592 | 358500.0 |
| 2006-08-02 09:00:00 | NVDA | Stock | 0.36 | 0.363 | 0.3593 | 0.362 | 760200.0 |
| 2006-08-02 09:30:00 | NVDA | Stock | 0.362 | 0.3775 | 0.3612 | 0.3737 | 109280160.0 |
| 2006-08-02 10:00:00 | NVDA | Stock | 0.3737 | 0.3757 | 0.3667 | 0.3713 | 67532100.0 |
| 2006-08-02 10:30:00 | NVDA | Stock | 0.3713 | 0.3737 | 0.37 | 0.3708 | 38948460.0 |
| 2006-08-02 11:00:00 | NVDA | Stock | 0.371 | 0.3757 | 0.3703 | 0.3742 | 57631260.0 |
> showing 50 of 50,033 rows — these rows as CSV