PREVIEW / stock_30min / 2006-11-16
file: by_date/stock_30min/2006/2006-11-16.parquet size: 968 KB rows: 52,151 symbols: 2,444
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-11-16 04:00:00 | AAPL | Stock | 3.0214 | 3.0214 | 3.0214 | 3.0214 | 2800.0 |
| 2006-11-16 07:00:00 | AAPL | Stock | 3.0189 | 3.0286 | 3.0179 | 3.0279 | 64512.0 |
| 2006-11-16 07:30:00 | AAPL | Stock | 3.0286 | 3.035 | 3.0204 | 3.0214 | 187320.0 |
| 2006-11-16 08:00:00 | AAPL | Stock | 3.0214 | 3.0279 | 3.0179 | 3.0239 | 2065952.0 |
| 2006-11-16 08:30:00 | AAPL | Stock | 3.025 | 3.0336 | 3.0246 | 3.0286 | 3250548.0 |
| 2006-11-16 09:00:00 | AAPL | Stock | 3.0286 | 3.0321 | 3.0229 | 3.0321 | 2592464.0 |
| 2006-11-16 09:30:00 | AAPL | Stock | 3.0311 | 3.0429 | 3.0221 | 3.0414 | 95484312.0 |
| 2006-11-16 10:00:00 | AAPL | Stock | 3.0411 | 3.0518 | 3.0325 | 3.0492 | 56912184.0 |
| 2006-11-16 10:30:00 | AAPL | Stock | 3.0496 | 3.06 | 3.0393 | 3.0471 | 66323488.0 |
| 2006-11-16 11:00:00 | AAPL | Stock | 3.0471 | 3.0518 | 3.0429 | 3.0489 | 26530588.0 |
| 2006-11-16 11:30:00 | AAPL | Stock | 3.0489 | 3.0579 | 3.0457 | 3.0518 | 26253500.0 |
| 2006-11-16 12:00:00 | AAPL | Stock | 3.0521 | 3.0643 | 3.0489 | 3.0643 | 34806576.0 |
| 2006-11-16 12:30:00 | AAPL | Stock | 3.0643 | 3.0704 | 3.0593 | 3.0646 | 47255292.0 |
| 2006-11-16 13:00:00 | AAPL | Stock | 3.0646 | 3.0689 | 3.0607 | 3.0671 | 28096012.0 |
| 2006-11-16 13:30:00 | AAPL | Stock | 3.0671 | 3.0821 | 3.0661 | 3.0768 | 74490360.0 |
| 2006-11-16 14:00:00 | AAPL | Stock | 3.0771 | 3.0804 | 3.0571 | 3.0613 | 45734164.0 |
| 2006-11-16 14:30:00 | AAPL | Stock | 3.0612 | 3.0661 | 3.0582 | 3.0646 | 28845348.0 |
| 2006-11-16 15:00:00 | AAPL | Stock | 3.0646 | 3.08 | 3.0639 | 3.0754 | 49498904.0 |
| 2006-11-16 15:30:00 | AAPL | Stock | 3.0754 | 3.0768 | 3.0568 | 3.0593 | 73327128.0 |
| 2006-11-16 16:00:00 | AAPL | Stock | 3.0593 | 3.075 | 3.0571 | 3.06 | 11899188.0 |
| 2006-11-16 16:30:00 | AAPL | Stock | 3.0607 | 3.0632 | 3.0579 | 3.0607 | 187180.0 |
| 2006-11-16 17:00:00 | AAPL | Stock | 3.0607 | 3.0618 | 3.0571 | 3.0571 | 254968.0 |
| 2006-11-16 17:30:00 | AAPL | Stock | 3.0557 | 3.0589 | 3.0543 | 3.0575 | 288512.0 |
| 2006-11-16 18:00:00 | AAPL | Stock | 3.0586 | 3.0586 | 3.0575 | 3.0575 | 61600.0 |
| 2006-11-16 18:30:00 | AAPL | Stock | 3.0586 | 3.0589 | 3.0554 | 3.0554 | 140336.0 |
| 2006-11-16 19:00:00 | AAPL | Stock | 3.0554 | 3.0554 | 3.0543 | 3.0543 | 22792.0 |
| 2006-11-16 19:30:00 | AAPL | Stock | 3.0589 | 3.0604 | 3.0589 | 3.0604 | 97384.0 |
| 2006-11-16 08:00:00 | MSFT | Stock | 29.03 | 29.1 | 29.03 | 29.03 | 5301.0 |
| 2006-11-16 08:30:00 | MSFT | Stock | 29.03 | 29.12 | 29.03 | 29.12 | 24386.0 |
| 2006-11-16 09:00:00 | MSFT | Stock | 29.12 | 29.15 | 29.1 | 29.14 | 19701.0 |
| 2006-11-16 09:30:00 | MSFT | Stock | 29.135 | 29.28 | 29.13 | 29.27 | 5511654.0 |
| 2006-11-16 10:00:00 | MSFT | Stock | 29.27 | 29.38 | 29.27 | 29.38 | 4094508.0 |
| 2006-11-16 10:30:00 | MSFT | Stock | 29.38 | 29.41 | 29.3 | 29.4 | 5416132.0 |
| 2006-11-16 11:00:00 | MSFT | Stock | 29.4 | 29.45 | 29.37 | 29.42 | 2924361.0 |
| 2006-11-16 11:30:00 | MSFT | Stock | 29.41 | 29.47 | 29.39 | 29.45 | 2607809.0 |
| 2006-11-16 12:00:00 | MSFT | Stock | 29.458 | 29.47 | 29.19 | 29.41 | 3483942.0 |
| 2006-11-16 12:30:00 | MSFT | Stock | 29.4 | 29.48 | 29.4 | 29.48 | 3189498.0 |
| 2006-11-16 13:00:00 | MSFT | Stock | 29.47 | 29.64 | 29.42 | 29.47 | 5562469.0 |
| 2006-11-16 13:30:00 | MSFT | Stock | 29.46 | 29.56 | 29.46 | 29.49 | 4221508.0 |
| 2006-11-16 14:00:00 | MSFT | Stock | 29.49 | 29.53 | 29.45 | 29.52 | 3205670.0 |
| 2006-11-16 14:30:00 | MSFT | Stock | 29.51 | 29.61 | 29.48 | 29.54 | 4160981.0 |
| 2006-11-16 15:00:00 | MSFT | Stock | 29.54 | 29.61 | 29.51 | 29.6 | 5703421.0 |
| 2006-11-16 15:30:00 | MSFT | Stock | 29.6 | 29.61 | 29.43 | 29.44 | 9088092.0 |
| 2006-11-16 16:00:00 | MSFT | Stock | 29.45 | 29.48 | 29.41 | 29.44 | 132516.0 |
| 2006-11-16 16:30:00 | MSFT | Stock | 29.45 | 29.45 | 29.45 | 29.45 | 500.0 |
| 2006-11-16 17:00:00 | MSFT | Stock | 29.48 | 29.48 | 29.48 | 29.48 | 8000.0 |
| 2006-11-16 17:30:00 | MSFT | Stock | 29.45 | 29.45 | 29.45 | 29.45 | 700.0 |
| 2006-11-16 18:00:00 | MSFT | Stock | 29.45 | 29.45 | 29.45 | 29.45 | 400.0 |
| 2006-11-16 19:30:00 | MSFT | Stock | 29.45 | 29.45 | 29.45 | 29.45 | 100.0 |
| 2006-11-16 07:00:00 | NVDA | Stock | 0.5983 | 0.5983 | 0.5983 | 0.5983 | 6000.0 |
> showing 50 of 52,151 rows — these rows as CSV