PREVIEW / stock_30min / 2008-10-16
file: by_date/stock_30min/2008/2008-10-16.parquet size: 1.2 MB rows: 70,358 symbols: 3,337
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-16 04:00:00 | AAPL | Stock | 3.5 | 3.5 | 3.5 | 3.5 | 56000.0 |
| 2008-10-16 04:30:00 | AAPL | Stock | 3.4996 | 3.4996 | 3.4996 | 3.4996 | 23044.0 |
| 2008-10-16 05:30:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4821 | 3.4821 | 8400.0 |
| 2008-10-16 06:00:00 | AAPL | Stock | 3.4911 | 3.4964 | 3.4821 | 3.4964 | 29400.0 |
| 2008-10-16 06:30:00 | AAPL | Stock | 3.5104 | 3.5171 | 3.4696 | 3.4696 | 21672.0 |
| 2008-10-16 07:00:00 | AAPL | Stock | 3.5 | 3.5318 | 3.5 | 3.5268 | 241472.0 |
| 2008-10-16 07:30:00 | AAPL | Stock | 3.5268 | 3.5268 | 3.4861 | 3.4946 | 604548.0 |
| 2008-10-16 08:00:00 | AAPL | Stock | 3.4946 | 3.5536 | 3.4696 | 3.5354 | 2378908.0 |
| 2008-10-16 08:30:00 | AAPL | Stock | 3.5375 | 3.6014 | 3.5368 | 3.5857 | 5545820.0 |
| 2008-10-16 09:00:00 | AAPL | Stock | 3.5854 | 3.6136 | 3.5536 | 3.5636 | 8363152.0 |
| 2008-10-16 09:30:00 | AAPL | Stock | 3.5632 | 3.5968 | 3.4393 | 3.4729 | 198755704.0 |
| 2008-10-16 10:00:00 | AAPL | Stock | 3.4736 | 3.4746 | 3.31 | 3.3396 | 191959488.0 |
| 2008-10-16 10:30:00 | AAPL | Stock | 3.3389 | 3.4068 | 3.2964 | 3.3468 | 203756504.0 |
| 2008-10-16 11:00:00 | AAPL | Stock | 3.3461 | 3.36 | 3.2764 | 3.3129 | 128333940.0 |
| 2008-10-16 11:30:00 | AAPL | Stock | 3.3132 | 3.4379 | 3.3086 | 3.4 | 123698316.0 |
| 2008-10-16 12:00:00 | AAPL | Stock | 3.4007 | 3.5143 | 3.3586 | 3.4489 | 143395644.0 |
| 2008-10-16 12:30:00 | AAPL | Stock | 3.4493 | 3.4786 | 3.3932 | 3.405 | 109316396.0 |
| 2008-10-16 13:00:00 | AAPL | Stock | 3.4046 | 3.4282 | 3.3625 | 3.3896 | 85557948.0 |
| 2008-10-16 13:30:00 | AAPL | Stock | 3.3911 | 3.4464 | 3.3571 | 3.4354 | 79889180.0 |
| 2008-10-16 14:00:00 | AAPL | Stock | 3.435 | 3.4496 | 3.3604 | 3.37 | 78434776.0 |
| 2008-10-16 14:30:00 | AAPL | Stock | 3.3714 | 3.4857 | 3.3496 | 3.4625 | 112656348.0 |
| 2008-10-16 15:00:00 | AAPL | Stock | 3.4625 | 3.6246 | 3.45 | 3.5521 | 191814896.0 |
| 2008-10-16 15:30:00 | AAPL | Stock | 3.5525 | 3.6939 | 3.5086 | 3.6364 | 199916696.0 |
| 2008-10-16 16:00:00 | AAPL | Stock | 3.6379 | 3.7161 | 3.4389 | 3.6936 | 34606544.0 |
| 2008-10-16 16:30:00 | AAPL | Stock | 3.5241 | 3.7032 | 3.5241 | 3.6786 | 2307256.0 |
| 2008-10-16 17:00:00 | AAPL | Stock | 3.6786 | 3.705 | 3.6389 | 3.7043 | 1911308.0 |
| 2008-10-16 17:30:00 | AAPL | Stock | 3.7043 | 3.7143 | 3.6946 | 3.7143 | 730632.0 |
| 2008-10-16 18:00:00 | AAPL | Stock | 3.7136 | 3.7143 | 3.7061 | 3.7114 | 366408.0 |
| 2008-10-16 18:30:00 | AAPL | Stock | 3.7136 | 3.7668 | 3.7111 | 3.7504 | 1125068.0 |
| 2008-10-16 19:00:00 | AAPL | Stock | 3.7536 | 3.7854 | 3.75 | 3.7639 | 2103332.0 |
| 2008-10-16 19:30:00 | AAPL | Stock | 3.7636 | 3.7636 | 3.7375 | 3.7393 | 1014384.0 |
| 2008-10-16 06:30:00 | MSFT | Stock | 22.66 | 22.66 | 22.66 | 22.66 | 200.0 |
| 2008-10-16 07:00:00 | MSFT | Stock | 22.72 | 22.77 | 22.66 | 22.73 | 15000.0 |
| 2008-10-16 07:30:00 | MSFT | Stock | 22.72 | 22.73 | 22.66 | 22.72 | 6924.0 |
| 2008-10-16 08:00:00 | MSFT | Stock | 22.75 | 22.84 | 22.67 | 22.84 | 23510.0 |
| 2008-10-16 08:30:00 | MSFT | Stock | 22.83 | 23.2 | 22.83 | 23.06 | 64341.0 |
| 2008-10-16 09:00:00 | MSFT | Stock | 23.06 | 23.11 | 22.77 | 22.95 | 118744.0 |
| 2008-10-16 09:30:00 | MSFT | Stock | 22.94 | 23.35 | 22.68 | 23.32 | 15121358.0 |
| 2008-10-16 10:00:00 | MSFT | Stock | 23.32 | 23.33 | 22.33 | 22.4 | 14528018.0 |
| 2008-10-16 10:30:00 | MSFT | Stock | 22.39 | 22.41 | 21.66 | 21.69 | 14196185.0 |
| 2008-10-16 11:00:00 | MSFT | Stock | 21.7 | 22.2 | 21.31 | 21.8 | 14778629.0 |
| 2008-10-16 11:30:00 | MSFT | Stock | 21.81 | 22.45 | 21.78 | 22.37 | 12182103.0 |
| 2008-10-16 12:00:00 | MSFT | Stock | 22.37 | 23.21 | 22.14 | 22.74 | 10473936.0 |
| 2008-10-16 12:30:00 | MSFT | Stock | 22.74 | 22.99 | 22.425 | 22.55 | 8122547.0 |
| 2008-10-16 13:00:00 | MSFT | Stock | 22.54 | 23.02 | 22.5 | 22.75 | 8288565.0 |
| 2008-10-16 13:30:00 | MSFT | Stock | 22.75 | 23.09 | 22.38 | 22.96 | 7027657.0 |
| 2008-10-16 14:00:00 | MSFT | Stock | 22.96 | 23.03 | 22.5 | 22.66 | 6764181.0 |
| 2008-10-16 14:30:00 | MSFT | Stock | 22.67 | 23.09 | 22.53 | 22.94 | 8613944.0 |
| 2008-10-16 15:00:00 | MSFT | Stock | 22.94 | 23.68 | 22.86 | 23.44 | 12747668.0 |
| 2008-10-16 15:30:00 | MSFT | Stock | 23.44 | 24.19 | 23.2 | 24.18 | 18528276.0 |
> showing 50 of 70,358 rows — these rows as CSV