PREVIEW / stock_30min / 2006-06-30
file: by_date/stock_30min/2006/2006-06-30.parquet size: 1012 KB rows: 54,199 symbols: 2,309
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-06-30 04:00:00 | AAPL | Stock | 2.05 | 2.05 | 2.05 | 2.05 | 30800.0 |
| 2006-06-30 06:30:00 | AAPL | Stock | 2.05 | 2.05 | 2.05 | 2.05 | 28000.0 |
| 2006-06-30 07:00:00 | AAPL | Stock | 2.0604 | 2.0604 | 2.0536 | 2.0539 | 45808.0 |
| 2006-06-30 07:30:00 | AAPL | Stock | 2.0607 | 2.0632 | 2.0571 | 2.0604 | 67200.0 |
| 2006-06-30 08:00:00 | AAPL | Stock | 2.0568 | 2.0607 | 2.0368 | 2.0507 | 2784208.0 |
| 2006-06-30 08:30:00 | AAPL | Stock | 2.0507 | 2.0611 | 2.05 | 2.055 | 5694164.0 |
| 2006-06-30 09:00:00 | AAPL | Stock | 2.0546 | 2.0661 | 2.0518 | 2.0568 | 9000656.0 |
| 2006-06-30 09:30:00 | AAPL | Stock | 2.0568 | 2.06 | 2.0336 | 2.0346 | 139640284.0 |
| 2006-06-30 10:00:00 | AAPL | Stock | 2.0346 | 2.0482 | 2.0182 | 2.0218 | 108545164.0 |
| 2006-06-30 10:30:00 | AAPL | Stock | 2.0218 | 2.0354 | 2.0179 | 2.03 | 83102572.0 |
| 2006-06-30 11:00:00 | AAPL | Stock | 2.03 | 2.0479 | 2.0286 | 2.0396 | 67253284.0 |
| 2006-06-30 11:30:00 | AAPL | Stock | 2.0393 | 2.045 | 2.0339 | 2.0439 | 40891508.0 |
| 2006-06-30 12:00:00 | AAPL | Stock | 2.0439 | 2.0461 | 2.0371 | 2.0439 | 20837908.0 |
| 2006-06-30 12:30:00 | AAPL | Stock | 2.0439 | 2.0529 | 2.0418 | 2.0482 | 23051896.0 |
| 2006-06-30 13:00:00 | AAPL | Stock | 2.0486 | 2.0625 | 2.0482 | 2.0561 | 37815260.0 |
| 2006-06-30 13:30:00 | AAPL | Stock | 2.0557 | 2.0593 | 2.0504 | 2.0529 | 24341044.0 |
| 2006-06-30 14:00:00 | AAPL | Stock | 2.0529 | 2.0579 | 2.0475 | 2.05 | 23536268.0 |
| 2006-06-30 14:30:00 | AAPL | Stock | 2.0496 | 2.055 | 2.0446 | 2.0511 | 20742204.0 |
| 2006-06-30 15:00:00 | AAPL | Stock | 2.0511 | 2.0514 | 2.0357 | 2.0393 | 41321588.0 |
| 2006-06-30 15:30:00 | AAPL | Stock | 2.0396 | 2.0507 | 2.0218 | 2.0457 | 54107844.0 |
| 2006-06-30 16:00:00 | AAPL | Stock | 2.0439 | 2.0464 | 2.04 | 2.0429 | 1633464.0 |
| 2006-06-30 16:30:00 | AAPL | Stock | 2.0446 | 2.0464 | 2.0388 | 2.0464 | 1150604.0 |
| 2006-06-30 17:00:00 | AAPL | Stock | 2.0461 | 2.0482 | 2.0386 | 2.0386 | 494368.0 |
| 2006-06-30 17:30:00 | AAPL | Stock | 2.0374 | 2.0461 | 2.0374 | 2.0454 | 900620.0 |
| 2006-06-30 18:00:00 | AAPL | Stock | 2.0404 | 2.0536 | 2.0404 | 2.0536 | 410620.0 |
| 2006-06-30 08:00:00 | MSFT | Stock | 23.43 | 23.46 | 23.4 | 23.46 | 38833.0 |
| 2006-06-30 08:30:00 | MSFT | Stock | 23.45 | 23.55 | 23.45 | 23.52 | 76750.0 |
| 2006-06-30 09:00:00 | MSFT | Stock | 23.52 | 23.6 | 23.5 | 23.55 | 90888.0 |
| 2006-06-30 09:30:00 | MSFT | Stock | 23.54 | 23.63 | 23.53 | 23.53 | 7643368.0 |
| 2006-06-30 10:00:00 | MSFT | Stock | 23.54 | 23.59 | 23.42 | 23.58 | 5872870.0 |
| 2006-06-30 10:30:00 | MSFT | Stock | 23.59 | 23.65 | 23.49 | 23.62 | 3959925.0 |
| 2006-06-30 11:00:00 | MSFT | Stock | 23.62 | 23.63 | 23.57 | 23.61 | 4288328.0 |
| 2006-06-30 11:30:00 | MSFT | Stock | 23.61 | 23.611 | 23.54 | 23.56 | 3008404.0 |
| 2006-06-30 12:00:00 | MSFT | Stock | 23.56 | 23.568 | 23.45 | 23.462 | 2898575.0 |
| 2006-06-30 12:30:00 | MSFT | Stock | 23.47 | 23.54 | 23.45 | 23.47 | 1832866.0 |
| 2006-06-30 13:00:00 | MSFT | Stock | 23.47 | 23.48 | 23.4 | 23.431 | 3015847.0 |
| 2006-06-30 13:30:00 | MSFT | Stock | 23.44 | 23.52 | 23.38 | 23.5 | 3005861.0 |
| 2006-06-30 14:00:00 | MSFT | Stock | 23.502 | 23.54 | 23.48 | 23.51 | 2339504.0 |
| 2006-06-30 14:30:00 | MSFT | Stock | 23.51 | 23.6 | 23.5 | 23.58 | 2557857.0 |
| 2006-06-30 15:00:00 | MSFT | Stock | 23.59 | 23.59 | 23.51 | 23.56 | 4048541.0 |
| 2006-06-30 15:30:00 | MSFT | Stock | 23.55 | 23.57 | 23.3 | 23.31 | 8193931.0 |
| 2006-06-30 16:00:00 | MSFT | Stock | 23.39 | 23.4 | 23.28 | 23.39 | 806057.0 |
| 2006-06-30 16:30:00 | MSFT | Stock | 23.39 | 23.39 | 23.314 | 23.38 | 1219055.0 |
| 2006-06-30 17:00:00 | MSFT | Stock | 23.38 | 23.38 | 23.38 | 23.38 | 19700.0 |
| 2006-06-30 17:30:00 | MSFT | Stock | 23.3 | 23.39 | 23.27 | 23.38 | 714993.0 |
| 2006-06-30 18:00:00 | MSFT | Stock | 23.38 | 23.38 | 23.36 | 23.36 | 300.0 |
| 2006-06-30 06:30:00 | NVDA | Stock | 0.3582 | 0.36 | 0.3582 | 0.36 | 60000.0 |
| 2006-06-30 08:00:00 | NVDA | Stock | 0.3548 | 0.3583 | 0.3548 | 0.3582 | 147900.0 |
| 2006-06-30 08:30:00 | NVDA | Stock | 0.3598 | 0.3598 | 0.3598 | 0.3598 | 12000.0 |
| 2006-06-30 09:00:00 | NVDA | Stock | 0.3597 | 0.3623 | 0.3582 | 0.3617 | 342120.0 |
> showing 50 of 54,199 rows — these rows as CSV